Designed, Managed, and published various reports using SQL Server Reporting Services 2012 and Power BI.Migrated and translate legacy reports into Power BI from SSRS environment.Developed and implemented SSIS and SSRS application solutions for various business units across the organization.Developed Ab Initio Graphs based on business requirements. Involved in unit testing of the Ab- Initio Psets/graphs. Used DAX query in writing queries and defining measures and calculated columns in PowerPivot and in tabular models in SSAS.Developed number of business-oriented reports utilizing SSRS, Power BI and Tableau.Creating functional and technical specifications, unit and integration testing, preparing user manuals and training key users. Involving in optimizing queries with Stored Procedures and parameter sniffing to get rid of the performance issues.Created SSIS packages to clean and load data to Enterprise Data Warehouse.Performing DDL, DML activities in database to handle the data using Stored Procedures, functions, Triggers and T-SQL queries. Experienced in Error Handling and Troubleshooting the scripts in failure to load the data into database.Used SSIS to create ETL packages (.DTSX files) to validate, extract, transform and load data to data warehouse databases, data mart databases. Enhancing and deploying the SSIS Packages from development server to production server

Designed Data-Mart for Prescription using Relational Model and wrote SSIS Packages to extract data from the old PDX system and load it into the new data mart of SQL Server.Develop complex MDX, stored procedures, function table and views to generate various drill through, drill-down reports, with dynamic grouping capability, parameterized dynamicDashboard/Scorecard and link and pass the selected parameter values it to its sub reports using SSRS.Implemented complex business logic with case, cast, convert, CTE using T-SQL.Create and update SSIS Packages to pull data from source to destination database. Involved in Deployment and Administration on SSIS packages with Business Intelligence Development Studio.Created types of SSRS report (Parameterized, Linked, Drilldown, Drill through, Customized, dashboards, graphics) in SharePoint environment.Involved in building Data Marts and multi-dimensional models like Star Schema and Snowflake schema.Designed SSAS Cube and developed MDX queries for Analysis. Generating drill through reports, drill down reports, parameterized reports, linked reports, Crystal reports, sub reports, table, matrix, charts in SSRS 2012.

• Extracting and Loading data into SQL Server Database using SSIS.• Extensively involved in designing the SSIS packages to export data from flat file source to SQL Server database.Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2014/2012/2008/(SSAS)Used data modeling tool Erwin for creating Logical, Physical data models and DDL’s.Created SSIS Packages to migrate slowly changing dimensionsDesigned, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).Experience in creating complex SSIS packages using proper control and data flow elements.Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.Developed reports and deployed them on server using SQL Server Reporting Services (SSRS).Pulling data on a daily basis from OLTP database to OLAP or staging database using the SSIS packages.Rendering the reports to PDF formats as per the requirement and printing all the reports in a batch process for Monthly Statements.

Developing SQL code such as writing complex queries, stored procedures etc.Responsible for creating database objects like Indexes, Table, Views, Stored Procedure using T-SQL to provide structure to store data and to maintain database efficiently. Involved in some admin works like creating user access logins to users and providing access to the Database.Being active part of Database designing team, to identify integrity constraints for data integrity like Referential integrity using primary key and foreign keys relationships.Creating Packages on SSIS by using different data Transformations like Derived Column, Lookup, Conditional Split, Script, Merge Join, Sort and Execute SQL Task, Script Component Task to load data into Database.Creating SSIS Packages, Configure SSIS packages for different environments using DTS Config.Designed the staging database in order to extract and load the data from various sources optimally.Develop Exception handling process and audit process for each ETL package