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

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

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

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

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.

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

Bachelor Of Science (B.S.)