This project involved analysis, designing and development of a Data Warehouse for storing the meaningful Study and Kit related data .Project is executing in agile model. Scrum and sprints are followed for User Stories management.Carried out the following activities:Involved in client meeting to understand their business processes.Designed data model to support Study and Kit related analytics and reporting.Designed ETL packages to pull data from various source like Oracle, Azure SQL Excel etc. Laid down the scheduling and logging mechanism for the ETL packages.Designed the SSAS cube that was based on the best Microsoft practices.Furthermore, designed the ETL package to handle the processing of the cube.Created Power BI reports from Tabular cube.SSRS reports from data warehouse.Team handling of 20+ size.

This project involved analysis, designing and development of a Data Warehouse for storing the meaningful operation data .Project is executing in agile model. Scrum and sprints are followed for User Stories management.Carried out the following activities:Involved in client meeting to understand their business processes.Laid down the designing of the Dimensional Model for the project, so that all the key point indicators could be easily captured and determined.ETL strategy which include designing of master/ child SSIS packages, capturing logging information of the ETL packages, laying down the scheduling mechanism for the ETL packages.Interacted with the business to understand the requirement for OLAP cube and based on the gathered information have designed the SSAS cube that was based on the best Microsoft practices. Furthermore, designed the ETL package to handle the processing of the cube.Created Power BI reports from Tabular cube.Team handling of 20+ size.

This project involved creation of a Data Warehouse. Analytical data was accessed by client via OLAP cube and Dundas reports for monitoring the performance of their company and their associate.Carried out the following activities:Involved in client meeting to understand their business processes. Co-ordinated with the Mitchell Business team to understand what operational data would be required by them for the analytical purpose. Based on the information gathered from the client, have laid down the formation of ETL strategy which include designing of master/ child SSIS packages, capturing logging information of the ETL packages, laying down the scheduling mechanism for the ETL packages.Written SQL server functions and procedures that for handling the complex business requirements.Interacted with the business to understand the requirement for OLAP cube and based on the gathered information have designed the SSAS cube that was based on the best Microsoft practices. Furthermore, designed the ETL package to handle the processing of the cube. Created SSRS reports.Laid down the security model for the project such as controlling access on the project servers, SQL server databases, Integration services and role based access control mechanism for the SSAS cube.

Develop BI solution for my client. Hays has OLTP adapt system. Project caters the need of providing critical information to higher management. Data from Adopt system is populated in Data Mart and then SSAS cube gets refreshed.The ETL process do a delta extract from the Adapt DR database daily at an agreed time (during the night), to allow for the Data Mart reporting database to be updated. TYPE 1 and Type 2 implementation has been done for different dimensions. Project is divided in 2 main parts-Data Load - From Oracle source data is extracted and loaded in BI databaseCube –All the facts and dimensions gets refreshed after data load.

Data is provided in flat files. Business rules are applied to process data and then saved in SQL database. Biz talk schema, Maps, Orchestration, WCF, Pipelines etc. are used to meet the requirements. Project is divided into 2 main parts .Inbound interfaces and outbound interfaces.1. Inbound interfaces are used to extract data from file. Apply business logic on data and then store data in database. Some of interfaces is developed using SSIS.2. Outbound interface are used to extract data from database. Prepare flat file in desired format. Biz talk is used for these interfaces

Ceridian Life works BI project is the BI implementation for Ceridian .It is used to process historical data sent from clients and then generating Reports which is used by top management. Data warehouse is developed in SQL database. Star schema is used to link facts and dimensions. Data is received in CSV/EXL format.SSIS is used for fetching data and apply business logic and storing the data in database. VB.net is used for scripting. SSAS is used to create cubes. SSRS is used for generating reports.

Technology used SSIS,SSAS,Power BI,SSRS and SQL server

Technology used SSIS,SSAS,Power BI,SSRS and SQL server

Technology used SSIS,SSAS,Power BI,SSRS and SQL server

Technology used SSIS,SSAS,Power BI,SSRS and SQL server