We provide IT Staff Augmentation Services!

Senior Ms Ssis Developer Resume

Columbia, MD

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.

Hire Now