Supported and created SSIS packages for 30+ employers in the monthly import and data warehousing of medical and pharmacy claims, and enrollment data from multiple vendors and formats, underpinning a healthcare analytics web and mobile application. Developed, maintained, and executed over 300 stored procedures for monthly data import, processing, and warehousing, as well as reports for data analysts. Achieved the deadline of the 10th of every month for complete loading and processing of analytics data by removing manual execution and monitoring of stored procedures and packages by creating SQLAgent jobs.Coordinated with a 3rd party benefits manager and over 20 third party administrators the development of an MSSQL data warehouse that powered the annual open enrollment for more than 15 employers. Developed SSIS packages and stored procedures to stage the data and deploy to production.Decreased the generation of monthly data analyst employer reports by 300% by creating persisted and ad hoc SQL extractionsAdministered the SFTP server and created accounts for 50+ clients data transfers.

Developed and maintained both a DTS ETL system and DTS data warehouse processing system, stored procedures, and relational database table structures supporting a customized 3rd party healthcare case management application. Executed scheduled and ad hoc database backups and restores on DEV, UAT, and Production servers. Enhanced database performance through query and index tuning, and key creations. Administered secure FTP site setup, maintenance, and new user creation.

Merged with Cognizant Technology Solutions

Merged with Xerox Care and Quality Solutions, Inc.

Enhanced and maintained a legacy Visual Basic application supporting healthcare case management nurses. Created a VB DLL integrated with Crystal Reports that automated the nightly printing of over 500 patient letters. Assisted Systems Engineers in required systems operation, maintenance, troubleshooting, and help desk activities. Monitored and administered the physical access control security system for the company. In 2005 transitioned my role to database development and administration.