­­­­

SUMMARY

• Having 8 years of experience in SQL Server Database and MSBI (SSIS, SSRS, SSAS) & Visualization tool Power BI
• Extensive experience in MS SQL Server 2005/08/12, SSIS (SQL Server Integration Services) both Package and Project Deploment model, SSRS (SQL Server Reporting Services) & Analysis Services SSAS.
• Participated in all phases of SDLC starting from analysis to delivery of the application development projects and also supported enhancement and maintanance of existing applications.
• Excellent skills in High Level Design and implementing ETL packages using SSIS 2012/08/05 for integrating data using OLE DB connection from heterogeneous sources ( Excel, CSV, Oracle, fixed width, Ragged right, Text file, SQL Server ) by using multiple transformations available in SSIS toolbox such as Data Conversion, Conditional Split, Derived column, Merge, Lookup and Union all.
• Extensive experience in Power BI Desktop and developed various dashboards like Pie chart, Donut, Graph, Slicer, Clustered column chart etc. and working on server level to maintain the dashboards and User level accesses.
• Developed D rill down, Cascading, Parameterized, Linked,Chart and Dashboard reports using (SSRS) and utilizing complex SQL queries and stored procedures.
• Good experience in Power BI Desktop and Services
• Developed SSIS project deployment Templates which can be used to develop SSIS Packages in such a way that they can be dynamically deployed into Dev, Test and Production Environments
• Experience in implementing Transactions, Logging, Error handlers and XML configuration files to SSIS Packages
• Debugging, Monitoring and Troubleshooting BI solutions, Performance tuning technics in (SSIS, SSRS and SQL)
• Involved in creating technical specifications,Desktop level process, HLD, LLD, Review& design documents.
• Extensive work experience in Team foundation server ( TFS ) and Ticket tools Service Now and JIRA and used job monitoring tools CA Application & Control M .
• Good experience in EXCEL database ( Pivot, Dashboards, Reports and templates design)

TECHNICAL SKILLS

ETL Tools: SSIS (SQL Server Integration services) (2005/08/12)

Reporting Tool: SSRS (SQL Server Reporting services) (2005/08 R2/16)

Analysis Tool: SSAS (SQL Server Analysis Services)

Operating Systems: Windows 2003, XP, Windows 7

Databases: SQL Server (2005/08/12,14)

Languages: SQL & T - SQL

Visualization Tool: Power BI

PROFESSIONAL EXPERIENCE

Confidential

App Dev - Lead

Responsibilities:

• Handling team of 4 and maintaining all documents part of project and assign work
• Actively participated in interaction with onshore and Off shore leads, team manager, to fully understand the requirements
• Writing complex queries to create Stored Procedures, Views and created Ad-Hoc SSRS reports, New Standard reports and created Power BI Dashboard as per requirements.
• Handling SSRS report deployment and security

Confidential

Responsibilities:

• Created multiple complex SSIS packages as per the requirement
• Created Test case documents, Check list and Setup CA job application for automation of SSIS packages.
• Writing complex queries to create Stored Procedures, Views and handled Keying and Data Standardization.

Confidential

Senior Software Engineer

Responsibilities:

• As a senior ETL developer in the application team to build ETL, SQL and Report design and support.
• Created multiple SSIS packages to load daily basis Geneva and ASTTRA data.
• Created complex Stored Procedures, Triggers and cursors to support ASTTRA Applications.
• Created multiple SSRS reports and deployed to SharePoint server and calling from ASTTRA application

Confidential

Software Engineer

Responsibilities:

• Single point of contact for all EOB(Extraction of benefits) related data loads/extractions and issues.
• Mainly involved in Creation of SSIS packages, SQL DB design and T-SQL development.
• Created the Packages in new versions like Package and Project deployment models and used Integration catalogs for monitoring and scheduling.
• Involved in Deployment Activities, created jobs and scheduling the ETL packages at desired frequencies using SQL Server agent jobs.
• Used multiple Transformations and various control flow tasks in SSIS to meet the Business Requirements.
• Hands on experience in implementing Event Handlers, Logging, Checkpoints, Transactions and package configurations.
• Created technical specifications, DLP (Desktop level process), HLD, LLD, Review& design documents.
• Involved in review and unit testing and created review documents.
• Creating SQL objects like Tables, Stored Procedures, Views and Indexes.
• Altering and created indexes on necessary table columns as per the requirement.

Confidential

Responsibilities:

• Creation of SSIS packages, SQL DB design and T-SQL development.
• Created the Packages in new versions like Package and Project deployment models and used Integration catalogs for monitoring and scheduling.
• Involved in Deployment Activities, created jobs and scheduling the ETL packages at desired frequencies using SQL Server agent jobs.
• Used various Transformations and tasks in SSIS to meet the Business Requirements.
• Hands on experience in implementing Event Handlers, Logging, Checkpoints, Transactions and package configurations.