John Hatton Email & Phone Number

Philadelphia, PA, US

Iselin, New Jersey, United States

Mclean, Virginia, United States

• Develop report specifications, field mapping documents and SQL stored procedures for new Medicaid claims administration and finance solution for the Kentucky Department for Medicaid Services.
• Conduct data analysis to understand and document transformation requirements.
• Working closely with ETL and report development teams, test report interface and execution to ensure business requirements, quality standards and delivery deadlines are met.

Princeton, New Jersey, United States

• Designed, planned, built and implemented efficient client-specific healthcare relational databases, data warehouses and BI presentation and delivery tools, providing actionable metrics on business performance and.
• Developed reports for critical TAT, post-decision change audit, and real-time authorization letter data extraction reports on QNXT and MCSOnline systems.
• Managed field-level ETL mapping requirements and SQL stored procedures for CMS Interoperability & Patient Access (IPA Rule) FHIR Solution Implementation. Conducted discovery meetings with client SMEs and appropriate.
• Developed MS Access-based POC for HEDIS STARs rating performance solution.
• Developed ETL SQL stored procedures for the expansion and population of a Data Vault EDW containing QNXT, Beacon, and Essette datasets.
• Project team member for the design and implementation of a complex population health data mart. Performed data loads, code QA and review, and DBA activities; Developed SQL code to identify, de-duplicate and consolidate.

Malvern, PA

West Norriton, PA

• Analyze and review complex database designs, ensuring data structure aligns with established standards, business goals and requirements, intended use and flexibility/scalability.
• Produce DDL for all database objects as required for DBA implementation.
• Project Team Member for new system to enhance clinical quality control through applied statistical quality control methodologies.

Delaware, United States

• Combined technical acumen with business savvy to decisively create, implement and monitor strategic IT policies, procedures, standards and controls.
• Applied dynamic leadership talents toward directing, motivating, and supervising 15+ technical professionals, obtaining 100% retention rate over 4 years.
• Expertly supported large-scale concurrent systems, applications, databases, hardware, and software relevant to broker/dealer commissions, data warehousing, and business intelligence.
• Effectively communicated with other IT management and lead personnel to integrate simultaneous in-flight IT projects and operational activities.