PROFESSIONAL SUMMARY

ü Strong technical knowledge on Business Intelligence, Reports Development.

ü Strong technical knowledge on Business Intelligence, ETL Packages and Development.

ü Good working knowledge on creation of various kinds of Dataflow, Control flow and different Transformations  using SQL Server Integration Services (SSIS).

ü Assisting developers on DBMS usage guidelines, improvements in logic and other design considerations.

ü Developed, analyzed, and documented data profiling of identified in-scope source systems.    

ü Perform daily monitoring of multiple databases to include Backup Execution/Monitoring and Performance Tuning.

ü Design & development of new capabilities to include data structure design and capacity planning.

ü Having 2.5 years of experience on Azure Data Factory.

ü Scheduled Jobs in Flows and ADF Pipelines.

ü Designed and Developed ADF pipelines using mapping flow.

ü Using triggers in ADF to schedule jobs

ü Experienced in Designing and Developing SSIS packages From Different Sources.

ü Expert in Extraction, Transforming and Loading (ETL) data flows using SSIS.

ü Experience in creating complex SSIS packages using proper control and data flow elements.

ü Experienced in programming tasks-Stored Procedures, Functions, and Views using SQL Server 2012/2014/2016 with T-SQL.

ü Good working knowledge on creation of various kinds of Reports using SQL Server Reporting Services (SSRS).

ü Creating the reports as per client’s requirements in the form of Table, Matrix, Chart and List.

ü Creating OLAP Cubes and processing Cubes using SQL Server Analysis Services (SSAS).

ü Deploying the designed packages to production server.

ü Excellent analytical and problem-solving skills, with Self-starter and ability to work independently or as part of a team Quick learner and adapts to new environments easily.

ü Having good knowledge on SQL Server 2012/2014/2016 and T-SQL.