Technical Lead
GlaxoSmithKline
King of Prussia, PA Technical Lead Technical Lead, Healthcare Professional(HCP) Program Team. Manage development of database, application, and support enhancements of the IPAS application utilized for government reporting of monetary contributions to Health Care Professionals(HCPs). Manage offshore and onshore resources to accomplish these tasks on-time and on budget. Work extensively with test team, business analysts, and business partners to ensure system quality. Provide system and architecture design expertise based on GSK standards for offshored projects. Interact with business customers during requirements gathering phases. Implement version control and build process for maintenance and project releases. Instrumental in setting strategic direction of the technical architecture for the program. Utilize Agile Software Development Methodology to implement new web-based software for capturing HCP Contract information and fund reservations with the goal of limiting spending to less than $150,000 per HCP GSK wide. Involved extensive interactions across GSK divisional lines for integration of solutions. Manage development team using agile development including story breakout, estimation, and iteration planning. Act as liaison between customers, business analysts, source system technical resources, and the development team to ensure requirements are detailed enough to progress development. Provide assistance to development team regarding technical and business issues. Applications DBA for Business Systems Engineering group. Provide data modeling and database design expertise for the Engineering group. Includes responsibility for several high-valued applications such as Compensation Modeling(SQL Server 7. 0/2000) and Total Project Costing(Oracle 8i/9i). Also Perl scripting for migration of legacy Documentum data during merger activities. Applications DBA for Health Care Informatics group. Responsible for design, administration, tuning, and troubleshooting of a multi-terabyte health care data warehouse. Created data model for version 2.0 of data warehouse and data mart. Worked with ETL team to manage load process and determine solutions to data quality and performance issues. Assisted analysis team and internal customers with query development and data extraction for research purposes. Optimized query performance through end-user training and back-end analysis. Created innovative solutions to issues encountered in all phases of development and implementation.