Help to document complex SSIS Packages and SQL jobs in Microsoft SQL Server applications.

Senior Database Developer tasked with writing complex stored procedures, automating file movements and ETL data loads on Microsoft SQL Server. Optimized complex T-SQL queries for portfolio risk code for government compliance.Promoted to team lead over group of SQL Database Developers, to mentor, guide, manage the team.Developed coding standards, automation standards and best practices for Database Development group.On-call rotation to support 24/7 batch processing of files/data.Developed SSIS packages for ETL loads of Datawarehouse

Wrote complex T-SQL to populate datamart for Banking Fee enhancement application. Automated SSIS/VB.NET file processing applications with Automate.Re-wrote VB6 applications in VB.NET console apps/T-SQL for automation.

Wrote SSIS packages in support of medical claim star-schema databaseUpgraded production system to new database design.Automated data loans with SSIS/SQL jobs.

Setup SQL servers, created and loaded databases with data, permissions for development group.Maintained Development, QA, Test servers during rapid development life-cycle of applications.

Wrote DTS Packages to support data loads.Wrote SQL Scripts for database and application migration,General DBA tasks: backups, restored, debugging failed DTS/SQL code,Setup replication for disaster recovery initiative.