Senior MS SSIS Developer Resume Columbia, MD - Hire IT People

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.

We provide IT Staff Augmentation Services!

Senior Ms Ssis Developer Resume

Columbia, MD

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship