Keith Simpson Email & Phone Number

Greater Boston Area

Greater Boston Area

• Authored complex stored procedures using T-SQL• Developed and managed database ETL processes used to generate client deliverables• Designed and managed database import / export processes used to generate client data warehouse deliverables• Assisted in project planning and scheduling• Acted as technical lead and solution expert for client projects• Performed database modeling and design• Debugged and optimized SQL queries and stored procedures• Performed ongoing data warehouse maintenance, change management, and performance tuning• Implemented and managed database backup, archive, and recovery processes

Greater Boston Area

• Create, manage, and maintain ETL processes for the collection of complex datasets and importing/exporting to and from internal data warehouse• Manage and develop custom SQL logic for monthly/weekly and ad hoc client reports• Create custom SSIS packages to import and normalize various incoming data sources• Architect entirety of database structure and function of proprietary client facing applications including stored procedures and T-SQL scripts• Perform database maintenance and DBA tasks • Data analysis and QA to ensure validity and reliability of client and reporting data• Automate and document data and reporting processes where possible including the creation of stored procedures and SSIS packages to remove manual tasks • Engage in data sourcing and knowledge sharing across departments

Greater Boston Area

• Orion Rhapsody, SSIS, and SQL Server stored procedure data route development• Create ad-hoc SQL queries to troubleshoot and resolve client data problems• ETL processing on incoming lab, claim, EMR, RX, provider, and member sources in various formats including HL7, 837I, 837P, CCDA, and custom flat files• On board and mentor 4 data analysts simultaneously • Profiling and client engagement on all new data sources • Manage data support and software implementation of up to 10 clients at a time across multiple products• Develop artifacts and processes to improve team methodology and efficiency• Technical analysis for client statements of work• Lead development and implementation cross functional training sessions

Greater Boston Area

• Managed entire ETL process for client’s healthcare data• Gap analysis and mapping of incoming data sources using SQL, SSIS, and Rhapsody• Client analysis and training in all data-related aspects during and after implementation• Data transformation/normalization to adhere with software needs for multiple products• Developed cross functional data solutions with clinical and development teams

Cambridge, Ma

• Create and edit SQL and PL/SQL scripts for handling of client data • Troubleshoot and resolve data discrepancies to establish proper standardization• Develop benchmarking and program analytic reports for client organizations• Unite business and technology practices to provide unified data methodology• Collaborate with team members to enforce best practices are utilized on all data• Perform export, transform, and load procedures on client data• Develop control files and documentation for production processes• Check validity of data received with SQL and SQL*Loader

Grant research for IT health care initiativeDevelopment of user satisfaction instrument for grant project

Managed movement from physical network to cloud computing solution.Developed rollout strategy and executive summary of cloud computing and its benefits.Worked with vendors on pricing, contract terms, and specifications of cloud network design.Presented relevant cloud computing findings and solutions to INDEX executives.Assisted on several other projects:Website redesign Social media integration QA'd development websitesAPI integration

Master Of Business Administration - Mba, Management Information Systems, General

Bachelor Of Science (B.S.)