David Murthy Email & Phone Number

San Francisco Bay Area

- Managed numerous highly visible projects like system redesign and reporting redesign.- Responsible for all inbound and outbound medical, pharmacy, and eligibility data transfers.- Built automated ETL & sniffer process that downloads and loads data from over 50 SFTP sites per day.- Creates reports to demonstrate cost savings and reconcile customers’ medical claims.- Analyzes medical and eligibility data to measure and predict member risk and costs using complex SQL… Show more - Managed numerous highly visible projects like system redesign and reporting redesign.- Responsible for all inbound and outbound medical, pharmacy, and eligibility data transfers.- Built automated ETL & sniffer process that downloads and loads data from over 50 SFTP sites per day.- Creates reports to demonstrate cost savings and reconcile customers’ medical claims.- Analyzes medical and eligibility data to measure and predict member risk and costs using complex SQL queries.- Utilizes standard medical codes: ICD9, HCPCS, CPT4, REV, NDC, etc.- Regularly uses standard medical file formats: HL7, NCPDP, 834 5010, 837i/p- Key contributor to high profile projects: system redesign, data aggregator, ICD10 conversion- Implemented over 30 customers since hire date. Some customers include BP, ConAgra, Motorola, Corning, VFCorp.- Regularly collaborates with clients & partners to fulfill contractual obligations and strengthen relationships. Show less

- Managed Medicare billing project; reconciled millions of dollars erroneously billed by previous management.- Designed and built an automated and auditable system responsible for over $700,000 per month.- Created reports with data team and led presentations that directly impacted financial decisions of key members of the executive team.- Led meetings for internal and external customers.- Used Johns Hopkins ACG system to measure population health and cost.- Wrote highly… Show more - Managed Medicare billing project; reconciled millions of dollars erroneously billed by previous management.- Designed and built an automated and auditable system responsible for over $700,000 per month.- Created reports with data team and led presentations that directly impacted financial decisions of key members of the executive team.- Led meetings for internal and external customers.- Used Johns Hopkins ACG system to measure population health and cost.- Wrote highly complicated, SQL scripts and procedures to streamline key processes.- Built loading process for billing, medical, and eligibility files into a normalized database - Designed and built automated reporting interface- Create reports for internal and external customers that directly impact financial decisions of key members of the executive team - Responsible for billing for key customers such as Medicare (CMS)- Work directly with customers to gather requirements and SOPs for reports and projects- Use a collection of tools: SQL Server, SSIS, Reporting Services, Visual Studio, Oracle, ETL- Master at ETL, EDI and Data Integration Show less

San Francisco Bay Area

Aquired by BOSCH

- Shortened each processing cycle from weeks to just hours by creating highly robust ETL maps for inbound and outbound medical files- Automated trending status reports for customers to review eliminating time consuming ad-hoc reporting- Owner and developer of key ETL processes such as standardization of HIPAA files: 834, 837i/p, NCPDP, and HL7- Technical lead for numerous high profile projects, often juggling them to meet tight deliverable deadlines- Meticulously kept record of… Show more - Shortened each processing cycle from weeks to just hours by creating highly robust ETL maps for inbound and outbound medical files- Automated trending status reports for customers to review eliminating time consuming ad-hoc reporting- Owner and developer of key ETL processes such as standardization of HIPAA files: 834, 837i/p, NCPDP, and HL7- Technical lead for numerous high profile projects, often juggling them to meet tight deliverable deadlines- Meticulously kept record of every coding change and versioned each production change using source control tools (Team Foundation, VSS, Bugzilla)- Worked on key software that affects every account within the company- Trained peers and contractors to become highly productive and valuable resources throughout the company Show less

- Managed highly time sensitive production processes with millions of dollars of revenue at risk.- Extracted and transformed millions of raw claims data from major healthcare carriers from an array of data sources into a normalized data warehouse using Pervasive ETL tools and developing complex SQL queries- Processed client data from beginning to end of processing cycle; from raw data input to production output- Meticulously kept record of every coding change and versioned each… Show more - Managed highly time sensitive production processes with millions of dollars of revenue at risk.- Extracted and transformed millions of raw claims data from major healthcare carriers from an array of data sources into a normalized data warehouse using Pervasive ETL tools and developing complex SQL queries- Processed client data from beginning to end of processing cycle; from raw data input to production output- Meticulously kept record of every coding change and versioned each production change using source control tools (VSS, Bugzilla)- Collaborated directly with various teams and clients to support contract recons and data cleanup- Worked on high profile accounts (i.e. Aetna, Presbyterian, Blue Cross Blue Shield, Florida CMS Medicare, HCSC, and many others)- Audited daily processing throughout the department to analyze data trending- Trained peers and contractors to become highly productive resources throughout the company Show less

-Found potential savings of up to $50,000,000 per processing cycle for numerous health plans by using complex algorithms to advise members to switch from non-formulary to formulary/generic medications-Solely responsible for developing/maintaining rules: the core product of Resolution Health-Loaded and transformed millions of raw claims from major healthcare venders into a normalized data warehouse-Wrote SQL stored procs & scripts using complex & dynamic logic responsible for… Show more -Found potential savings of up to $50,000,000 per processing cycle for numerous health plans by using complex algorithms to advise members to switch from non-formulary to formulary/generic medications-Solely responsible for developing/maintaining rules: the core product of Resolution Health-Loaded and transformed millions of raw claims from major healthcare venders into a normalized data warehouse-Wrote SQL stored procs & scripts using complex & dynamic logic responsible for processing records in the hundred millions-Managed tables holding NDC,GPI,CPT4,ICD9,HCPCS,REV codes-Communicated directly with clients to manage projects & business requirements with technical & non-technical teams-Managed projects for rules,analysis,reports & DB requirements-Created reports using SQLServer in conjunction with Excel-Worked with development,operations and QA teams together to meet objectives & aggressive deadlines-Trained employees for various technical positions within the company Show less

- Responsible for testing products and finding errors and debugging source code- Worked with engineers to help meet Q/A requirements and complete projects within strict deadlines- Managed a database for accounting and for sales contacts on a FreeBSD machine- Troubleshooted and fixed software and hardware problems

Bs, Computer Science / Mathematics

Education record