SUMMARY

• 8+ years of SSIS Development experience with four organizations.
• Created positive communications and working relationships with all stake holders.
• Conversant working in an Agile environment.
• Expert in using SSIS (integration services) with MS SQL Server 2012/2014/2016.
• Expert knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, dimensional modeling.
• Highly proficient in teh use of T - SQL for developing complex queries, stored procedures and views.
• Good understanding of relational database models and data integrity, SQL joins, query writing and query optimization.
• Extensively used performance monitor/SQL profiler to solve dead locks/long running queries.
• Expert in developing content rich reports using MS SQL Server Reporting Services (SSRS)
• Experience in creating Jobs and Scheduling T-SQL code and SSIS Packages.
• Experience in database administration: Database creation, Backup and Recovery.
• Expert in creating Business and Technical documents supporting development.
• Good understanding of Tableau dashboard design concepts.
• Good experience in using TFS for versioning and auto deployment.
• Excellent performer both in team and independently.

PROFESSIONAL EXPERIENCE

Confidential, Columbia, MD

Senior MS SSIS Developer

Responsibilities:

• Created SSIS error handling using QA tables that capture failure and success details.
• Performed data profiling using SSIS for data quality check.
• Created/Updated database objects like tables, views, stored procedures, function, packages.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into teh database.
• Deployed and scheduled reports using SSRS to generate all daily, weekly, monthly and quarterly reports including current status.
• Developed a complex stored procedure around business rules to be used for one of teh key dashboards for top executives.
• Involved in monitoring and tuning report performance by analyzing teh execution plan of teh report.
• Designed and developed monthly, quarterly and yearly reports at branch and bank level.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Version controlled and auto deploy packages and stored procedures into QA and Production using GitHub and Visual Studio.
• Monitored teh overall performance of teh database to recommend and initiate actions to improve/optimize Performance.
• Used SQL Server Profiler to trace teh slow running queries and teh server activity.

Confidential

Senior MS SQL BI Subject Matter Expert

Responsibilities:

• Work on ongoing and new projects that include designing, documenting and developing solutions using T-SQL, SSIS, SSRS, and Stored Procedures etc.
• Create Business requirement documents, technical specification documents, Data mapping sheets, QA Checklist and data flow diagrams.
• Developed a complex stored procedure around business rules to be used for one of teh key dashboards for top executives. Tableau was used for frontend.
• Developed a Project Management Database where employees enter teh projected and actual work estimates using MS Access. Also developed a view to be used for reporting in teh front end.
• Designed and developed solution to email all teh employees that have not completed certain trainings using SSIS.
• Maintain Service Accounts’ passwords for data warehouse, Tableau, reporting and analytic servers.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Improved query Performance by creating Clustered and non-clustered Indexes and by optimizing teh T-SQL statements using SQL profiler.
• Work with integration services for transferring data from heterogeneous sources like Excel, CSV, flat file, Text Format Data, MySQL, Oracle, Web services, SharePoint etc.
• Develop complex SSRS reports using parametrized Stored Procedure with large set of tables from multiple databases.
• Auto deploy packages and stored procedures into QA and Production using TFS (Team Foundation Server)/Visual Studio.
• Conducted user training and supported teh new hires during initial months.
• Regularly conduct database auditing and reported teh results to manager for unused resource cleanup.