## BIO
Projects involved in: BI Consultant • Developed ETL package to maintain synchronized databases on different servers • Created one of the main cube dimensions with alternative hierarchies applying the Clarity conventions • Developed a SQL procedure for Archive/Restore routine • Converted Clarity 6.2 templates and reports to Clarity 7 • Technology used: Data warehousing, OLAP, Microsoft SQL Server 2000, 2008, SSIS 2008, SSAS 2008, Clarity Studio 7.0 BI Consultant • Converted Clarity 6.2 templates/reports to Clarity 7.0 • Supported the client on some relational and OLAP issues faced while developing new reports • Technology used: Microsoft SQL Server 2005, Essbase, Clarity Studio 7.0 BI Consultant • Supported the client on how to use Clarity Studio 7.0 • Technology used: Clarity Studio 7.0 BI Consultant • Created a report using Clarity Visualizer 6.2 (Sample report for demonstration) • Technology used: Clarity Visualizer 6.2 BI Consultant • Created sample reports and templates for demonstration on how to use Clarity Studio 7.0 • Supported some of the client’s issues on how to use some features of Clarity Studio • Technology used: Clarity Studio 7.0 Projects involved in: BI Software Engineer • Developed ETL responsible for data extraction and manipulation from access source to SQL DB according to some business logic • Helped in developing the OLAP CUBE which holds business logic • Created required reports • Technology used: Data warehousing, OLAP, Microsoft SQL Server 2008, SSIS 2008, SSAS 2008. SSRS 2008 BI Software Engineer • Developed OLAP CUBE which holds the business logic • Created different types of reports • Technology used: Data warehousing, OLAP, Microsoft SQL Server 2005, SSAS 2005. ProClarity, Performance Point Server 2007 Telecom Demo BI Software Engineer • Developed OLAP CUBE supporting one business requirement • Worked with SQL 2005 for data insertion and manipulation • Technology used: Data warehousing, OLAP, Microsoft SQL Server 2005, SSAS 2005. ProClarity, Performance Point Server 2007 BI Developer • Designed and created star schema for developing the OLAP CUBE • Created ETL packages for extracting and transforming data from text files to SQL server database • Designed and created the OLAP CUBE • Designed and created reports • Technology used: Data warehousing, OLAP, Microsoft SQL Server 2008, SSAS 2008. ProClarity, Performance Point Server 2007 Projects involved in: Software Engineer – Business Intelligence Developer • Developed the ETL responsible for handling the Canadian business logic of the system. • Developed and supported SQL statements. • Implemented a dashboard for top management to measure the sales force effectiveness through a series of analysis reports using ProClarity Analytics Server and Dashboard Server for data analysis and reports generation. • Built OLAP cube to maintain data aggregation. • Technology used: Data warehousing, OLAP, Microsoft SQL Server 2005, SQL Server Integration Services, SQL Server Analysis Services. ProClarity Analytics Server, ProClarity Dashboard Server Software Engineer – SQL Developer and SQL Support Risk Management Re-Engineering • Developed SQL statements essential for the extraction system. • Support for some SQL was already implemented. • Helped in enhancing the performance of the system. • Helped in the re-engineering of the already existing applications (Collection, High Usage, Repeated Offender, Virtual Agent and Daily extraction) to comply with J2EE standards, integrate with TIBCO middleware. • Re-structured application’s database to minimize dependencies on Data warehouse database. • Technology used: ORACLE database, TIBCO Integration Framework, J2EE, Business Objects Server, Computer Telephony Integration CTI.
## Area of Expertise
Microsoft Products • SQL Server Business Intelligence Development Studio • SQL Server Integration Services (SSIS 2005-2008) • SQL Server Analysis Services (SSAS 2005-2008) • SQL Server Reporting Services (SSRS 2005-2008) • Microsoft Performance Point Server • ProClarity • Microsoft Visual [login to view URL] 2003,2005 • Microsoft Visual Source Safe 2005, Microsoft Visio, Microsoft Office components, Excel PowerPivot Clarity Systems • Template Builder 6.2 • Clarity Studio 7.0 • Clarity Visualizer 6.2 • Clarity Visualizer 7.0 SAS • SAS Base Programming • SAS Business Intelligence Suite • SAS DI Studio • SAS Management Console • SAS Enterprise Guide • SAS Information Delivery Portal • SAS Web Report Studio • Df Power Studio Database • Microsoft SQL Server 2005 • Microsoft SQL Server 2008 • Oracle 9i, Oracle 10g Platforms & Operating Systems • Windows server 2003, Windows server 2008, Windows XP, Windows Vista, Windows 7 • UNIX System Integration • TIBCO