Patrick Whitaker

• Develop analytics solutions for the Pet Data & Analytics Cloud Platform, analyzing complex EMR datasets to uncover patient health trends.
• Design and architected data migration pipelines from internal warehouses and external on-prem databases to a Databricks data mesh with enriched, curated layers.
• Build ETL/ELT workflows, performed data modeling, cataloging, and KPI analysis for executive dashboards (CEO, CFO).
• Conducted financial data analysis, validated data integrity, and mapped multi-source data into unified models.
• Create SQL, PySpark, and Python Notebooks in Databricks for reporting and statistical modeling.
• Led the development of financial dashboards (Power BI, Tableau) analyzing revenue shifts pre- and post-pandemic.

An Autonomous Driving Company (GM-General Motors)
• As a primary developer on the Global Finance Ops and Analytics Team:
• Build and maintain a Finance Data Warehouse using Medallion architecture (Bronze, Silver, Gold Layers).
• Develop LookML models and Looker dashboards using SQL to enhance real-time financial insights.
• Implement ETL pipelines to streamline financial data processing.
• Ensure data quality, security, and compliance through automated governance.
• Translate business needs into scalable financial analytics solutions

A Government Environmental Protection and Licensing Agency
• Led enterprise web platform development, executing ETL processes to migrate legacy data from non-relational databases to SQL Server Management Studio through comprehensive data mapping, cleansing, and validation.
• Designed and implemented interactive dashboards using Tableau and Power BI, developing dynamic UI/UX elements with drill-down capabilities and cross-filtering functionality.
• Performed advanced statistical analysis on structured and unstructured datasets, applying regression models and trend analysis to generate actionable insights for software development priorities.
• Translated complex business requirements into detailed functional specifications, including business process modeling workflows and user stories with acceptance criteria.
• Conducted comprehensive user acceptance testing and A/B testing methodologies to validate complex fee calculation algorithms and multi-step workflow processes in both UI and database environments.

Healthcare Management
• Conducted data discovery, mining, cleansing, and mapping using MongoDB and SQL Server to track CRN assessments of patient needs.
• Designed reporting solutions, identified KPIs, and developed dashboards in Tableau.
• Collaborated with product owners on UAT testing and provided data-driven insights.
• Documented business requirements in Jira and Jira Align for digital solution development.• Conducted data discovery, mining, cleansing, and mapping using MongoDB and SQL Server to track CRN assessments of patient needs.
• Designed reporting solutions, identified KPIs, and developed dashboards in Tableau.
• Collaborated with product owners on UAT testing and provided data-driven insights.
• Documented business requirements in Jira and Jira Align for digital solution development.

State of California’s Earthquake Insurance Agency
• Developed SQL Server queries that identified defect patterns, reducing technical issues by 30%
• Created Tableau and Power BI dashboards that transformed insurance data into actionable insights.
• Selected for Business Intelligence team collaboration; earned SQL Server Data Analyst certification.
• Managed XML-to-SSMS ETL processes with 99.9% data integrity across insurance agency feeds.
• Authored precise user stories that accelerated development cycles by 25%.
• Conducted A/B testing that improved product optimization by 40.

Healthcare Agency
• Executed data analysis and mapping using SnapLogic, implementing cleansing protocols for healthcare systems integrity
• Translated complex healthcare requirements into technical specifications for system interfaces and data flows
• Led technical requirement sessions with IT teams and vendors for the MediCal program implementations
• Developed process diagrams and system architecture documentation for cross-departmental understanding
• Created and delivered technical training materials to end users on system functionality
• Performed risk assessment analysis on implementations with mitigation strategies

Medical Device Technologies
• Led advanced testing and troubleshooting of Hospital EMR platforms, resolving 25+ technical tickets weekly with a team of 130+ specialists.
• Conducted root cause analysis through data configuration testing, creating detailed technical documentation for Quality Assurance, DevOps, and R&D teams.
• Performed advanced troubleshooting of interface messages between EMR systems by analyzing XML, SQL Server, and HL7 FHIR messages, including data synchronization, web applications, IIS, Active Directory, PowerShell, and HTML.
• Increased internal efficiency by 60% through systematic resolution of complex software, network, and database issues while leading disaster recovery operations for medical device interfaces.
• Developed SQL queries to investigate millisecond-level transactions in SQL Server Management Studio and SAP, creating data visualizations in Excel and Tableau to identify system performance trends.
• Authored technical knowledge articles that were integrated into global company documentation, providing step-by-step resolution procedures for complex EMR issues.

• Designed and implemented a database system that improved internal efficiency by 170%, defining core requirements, UI/UX design, and platform compatibility in both Agile and Waterfall environments.
• Developed SQL scripts and reports to analyze law enforcement databases, improving investigative efficiency by 50%.
• Automated data workflows, enabling bulk indexing of 30,000+ files, reducing project timeline to 1/6th of the original estimate.
• Led cross-functional collaboration on the DOJ's Exclusion Management System (EMS), aligning business and functional requirements with contractors.
• Administered and optimized two large inter-agency systems, conducting user acceptance testing (UAT), refining database parameters, and enhancing UI/UX.
• Built an HTML web portal streamlining file access, boosting operational efficiency by 50% for 200+ employees.
• Authored 2,000+ pages of technical documentation, including error reports, enhancement requests, and training materials used for system-wide onboarding.