Designs and builds data infrastructure required to support analytics. Performs validations on incoming data using stored procedures and reconciles counts from incoming control files. Technical Lead analyzes business requirements, provides work estimates and develops timelines to execute design and development, peer review, unit testing and troubleshooting of data anomalies. Designs Star schema models to simplify compilation of analytical reports. Performs tuning on existing database procedures to improve load performance, validation and reproduction of analytic reports.

Managed data migration and market data solutions for the pharmaceutical and biotech industries. Loaded data into Salesforce platform (Veeva CRM). Customized analytics using SQL server for diagnosis and repair of operational breaks, data validation, and quality control. Led business requirements documentation with clients’ technical and functional experts. Designed SSIS packages for file import/export routines. Converted and cleaned data to produce file extracts for legacy systems

Developed and maintained proprietary custom applications, including an insurance management billing system. Designed database tables and structures to accommodate business requirements. Managed all phases of testing, ensuring test plans and test cases were completed (Functional, Regression, User Acceptance, GUI, and Installation testing). Corrected software errors and deficiencies to ensure quality assurance.

Developed, tested, and implemented data entry and client reporting applications. Implemented stored procedures to migrate data. Debugged complex programming issues and provided alternate solutions.

Developed and maintained corporate intranet applications. Designed the data infrastructures needed to support internal applications. Worked with other senior developers and designers to develop the corporate website. Assisted in the development of functional specifications. Collaborated with senior software developers to implement industry-standard technologies.