Experience

The Children's Place

• United States
• Retail
• 700 & Above Employee

• SSIS / SSRS Architect

  • Oct 2022 - Present



Managed Health Care Associates, Inc.

• United States
• Hospitals and Health Care
• 100 - 200 Employee

• SQL Developer / DBA

  • Jun 2014 - Present

  • Experience as an extract, transform, and load (ETL) developer. • Experience in design, mapping, testing, implementation, scheduling and monitoring of ETL procedures. • Experience in building complex SSIS packages using different transformations like lookup,Conditional split, Merge, Script task etc.• Used C# in script task to extend SSIS functionality.• Experience in COZYROC component in SSIS.• Experience in creating complex stored procedures.• Knowledge of data warehousing, master data management, logical modeling and physical modeling. • Experience in data mapping and strong background in automation of processes • Strong analytical and problem solving skills.• Ability to work effectively, independently, and collaboratively within a team environment.• Excellent written and oral communication skills.



PNB MetLife India Insurance Company Limited

• MS SQL Server Developer

  • Oct 2009 - Nov 2010

  • Developed physical and logical Data Models using Erwin.• Requirement gathering and understanding the business logic.• Wrote T-SQL Queries and involved in programming of stored procedures, triggers, cursors, functions to implement the business logic.• Wrote Queries to generate company development reports using SQL Server ReportingServices(SSRS).• Experience in monitoring tools like SQL Management Studio, Enterprise Manager and Query Analyzer, Profiler.• Generated parameterized reports and ad-hoc reports using Report builder for the customers.• Responsible for designing, creating and deploying the reports into the production server.• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.• Created Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.• Responsible for creating and implementation of data access stored procedures and triggers for automating tasks.• Optimized queries and did performance tuning using various MS SQL Server tools such as SQL Profiler, SQL Performance Monitor, execution Plan and Database Engine Tuning Advisor.