· Requirement specifications collected from several parties and individuals.

· Provided all technical support for the developers.

· Mainly participated in Development, test environment and Implementation stages.

· Extensively worked on building business components, database, server and client system designs.

· Extracted large volumes of data from different data sources and loaded the data into target database by performing different kinds of transformations using SQL Server Integration Services (SSIS).

· Optimization of stored procedures used as the source for the reports.

· Implementing logging and Deploying.

· Having hands on experience in Migration DB’s and SSIS Migration from SQL Server 2000 (Rewriting SSIS packages in 2012), SQL Server 2008 to 2012.

· Supporting end user Applications and working on enhancement requests.

· Used Best practices for package design, dataflow techniques, deployment and management in SSIS.

· Developed Power BI reports and dashboards from multiple data sources using data blending.

· Expertise in writing complex DAX functions in Power BI and Power Pivot.

· Automated Power Query refresh using power shell script and windows task scheduler.

· Used various sources to pull data into Power BI such as Sql Server, Oracle, SQL Azure etc.

Extensive experience in onshore/offshore coordination and responsible for project deliverables.

· Worked with SSIS Packages.

· Created the mappings using transformations such as the Derived Column, Data conversion, Union All, Multicast, merge join, Sorter and Fuzzy Lookup using Data Flow Tasks.

· Optimization of stored procedures used as the source for the reports.

· Implementing logging and Deploying.

· Having hands on experience in Migration DB’s and SSIS Migration from SQL Server 2000 (Rewriting SSIS packages in 2012), SQL Server 2008 to 2012.

· Supporting end user Applications and working on enhancement requests.

· Used Best practices for package design, dataflow techniques, deployment and management in SSIS.

· Tracing performance tuning through Query Analyzer and Sql server Profiler.

· Created Drill down and drill through reports in SSRS.

· Expertise in scheduling reports to end-users and give acess to the report server.

· Created Subscriptions such as standard and data driven in Report Manager SSRS to generate email notifications.

· Developed and scheduled the cached reports in SSRS

Extensive experience in onshore/offshore coordination and responsible for project deliverables.

· Involved in Supporting and Enhancing the SSIS packages, keeping in view implementing appropriate SSIS controls and Implemented Package Configuration, Message Logging and Auditing.

· Created the mappings using transformations such as the Derived Column, Data conversion, Union All, Multicast, merge join, Sorter and Fuzzy Lookup using Data Flow Tasks.

· Tracing performance tuning through Query Analyzer and Sql server Profiler.

· Optimization of stored procedures used as the source for the reports.

· Supporting end user Applications and working on enhancement requests.

· Handling ITSM resolutions and creating the CR for enhancement work and released it in weekend release process.

· Working as Release Manager to process the CR release in weekend and co-coordinating with Onshore/Offshore team and responsible CR release to Production.

· Extensive experience in creating Datamart reports in Microstrategy as per the user requirements

· Extensively working on user requests to resolve Access issues and provided required access to particular area of reports in Microstrategy web.

· Worked on Microstrategy Report data issues and provide the solution to users. Good exposure to data query tools like SQL Developer and TOAD.

· Excellent experience in Microstrategy Report development, Report testing, Report tuning, Ad-hoc, scheduling report delivery and Alerts.

· Extensive experience in onshore/offshore coordination and responsible for project deliverables.

· Handling ITSM and JIRA’s resolutions

· Involved in Unit Level and Peer Testing.

Requirement specifications collected from several parties and individuals.

Extensively worked on building business components, database, server and client system designs.

Implementing SSIS packages to load the claims details into the database. pdf compress and decompress using SSIS packages.