Rajkumar A

Sr. BI Develop

As a BI consultant I use to meet the business users to gathering the requirements and provided the business solutions using dashboard and reports.

Created SSIS packages to Extract data from multiple sources and load to data warehouse facts and dimensions, Created OLAP cubes and OBIEE Subject area build reports and BI Dashboards for analysis purpose.

Migration From SQL Server2000 to SQL Server 2012
• Studied the existing OLTP and OLAP Data structure to understand the business requirements.
• Created SSIS packages to get the data’s from operational servers (Oracle, SQL Server, IBM Informix).
• Created and deployed SPs to update Fact and Dimension tables from the operational database.
• Build OLAP Cubes on the Fact and Dimension tables to generate reports.
• Created MDX calculations to find the business status.
• Tested SSIS Packages and Stored Procedures (SPs).
• Deployed packages and Cubes to server and created jobs to execute SSIS packages

Implemented and supported Data Warehouse using MSBI created • Developed complex SQL scripts to avoid Joiners and Look-ups to improve the performance as the volume of the data was huge.