Data Analyst Senior Business

Matthew Tornquist

Add: Doylestown, Pennsylvania

Email: ********@*****.***

Phone: 908-***-****

Summary:

Senior Business Data Analyst BI & Regulatory Reporting Expert PL/SQL • Python • Oracle • AWS

Accomplished Senior Business Data Analyst with over 15 years of experience specializing in the design, development, and optimization of data solutions across the healthcare, pharmaceutical, federal, and defense sectors.

Expertise in reporting on large-scale commercial datasets, particularly within the healthcare and pharmaceutical industries, with a proven track record in leading data integration and business intelligence projects. Skilled in developing advanced reporting solutions and ensuring adherence to global regulatory standards.

Experienced in managing complex datasets related to Medicaid, Medicare, and regulatory submissions, utilizing advanced ETL processes and robust data governance practices to ensure compliance with federal and global health authorities.

Proficient in leveraging a broad range of technologies, including PL/SQL, Python, Tableau, SAS, Advanced Excel, and AWS Cloud, to support complex reporting needs and streamline data workflows.

Known for creating efficient ETL processes, maintaining high data quality, and implementing effective data governance frameworks that ensure compliance and accuracy across multiple datasets. I have contributed to improving operational efficiency and providing actionable insights that support decision-making from federal Medicaid and Medicare datasets to Oracle-based regulatory submission solutions.

Adept at designing impactful dashboards using Tableau and conducting deep data analysis and reporting with Advanced Excel. My proficiency in SAS for advanced statistical analysis and SQL for complex query writing allows me to work effectively with large datasets and optimize processes across platforms. I also use Python for automation and optimizing PL/SQL queries to improve data accessibility and resolve technical challenges.

Throughout my career, I have successfully led projects for organizations like Sanofi Pharmaceuticals and the Health Resources & Services Administration (HRSA), where I delivered federal reporting solutions, enhanced healthcare finance analytics, and optimized regulatory data systems. I also excel at creating clear, actionable presentations and reports using PowerPoint to communicate complex data insights to both technical and non-technical stakeholders. With a strong foundation in data modeling, OLAP, and cloud platforms such as AWS and Veeva Vault, I consistently adapt to evolving industry needs while staying focused on achieving operational goals and maintaining regulatory compliance.

Education:

Bachelor of Science in Computer Science

DeVry University, 2001 - 2004

Associate's Degree in Business Administration

Wingate University, 1998 - 2000

Certifications:

CompTIA Security+

Government Secret Clearance

Government Public Trust Clearance

Technical Skills

Programming & Scripting Languages:

Python

SQL

PL/SQL

SAS

Visual Basic

ColdFusion

C++

Databases & Data Warehousing:

Oracle (12c, 19c, 21c)

Microsoft Access

Oracle E-Business Suite (EBS)

OLAP (Online Analytical Processing)

ODS (Operational Data Store)

Data Modeling

Data Remediation

Data Governance

ETL & Data Integration Tools:

Informatica PowerCenter

Oracle Data Integrator (ODI)

Custom ETL using Python & PL/SQL

BI & Reporting Tools:

Tableau

Power BI

Oracle BI Publisher

Cloud & Platforms:

AWS Cloud

Veeva Vault (Regulatory Information Management)

Software Development & Version Control:

Git

CVS

SQL Developer

TOAD

Project Management & Methodologies:

Jira (Agile Project Tracking & Debugging)

Agile & Waterfall Methodologies

SIT (System Integration Testing)

UAT (User Acceptance Testing)

Code Review & Unit Testing

Technical Documentation Writing

Business & Regulatory:

Business Intelligence Reporting

Regulatory Submissions (Healthcare/Pharma)

Data Analysis & Visualization

System Testing & Validation

Data Pipeline Development

Query Optimization

Professional Experience

Alpha Omega Integration HRSA (Health Resources & Services Administration) Jan 2022 – March 2025

Senior Business Data Analyst / BI Reporting Manager

Spearheaded the design and development of BI Publisher reports in Oracle 21c to support federal reporting needs within the Health Resources & Services Administration (HRSA).

Managed large-scale Medicaid and Medicare datasets, facilitating seamless ETL processes using AWS cloud services to ensure timely, accurate data delivery across distributed systems.

Developed advanced Tableau dashboards to visualize key healthcare finance metrics, driving informed decision-making for federal budget planning.

Wrote and maintained complex PL/SQL scripts for data extraction, transformation, and validation, using tools like SQL Developer and TOAD for Oracle.

Led initiatives to standardize data governance practices by implementing robust quality checks, comprehensive documentation, and consistent metadata usage.

Created Python scripts to automate Medicare data workflows, significantly reducing manual workload and improving efficiency for cross-functional teams.

Applied OLAP techniques for multidimensional data analysis, enhancing HRSA’s ability to interpret complex healthcare trends.

Collaborated with cross-functional teams using Jira to manage development sprints, resolve defects, and ensure timely project delivery.

Created detailed technical documentation and training materials to support code reviews, testing procedures, and stakeholder onboarding.

Leveraged Informatica PowerCenter 10 for ETL and data warehousing operations supporting analytical and compliance reporting.

Sanofi Pharmaceuticals Bridgewater, NJ Sept 2018 – Jan 2022

Senior Business Data Analyst – Regulatory & Data Analytics

Developed and managed PL/SQL data solutions to support regulatory data submissions and global health authority compliance reporting in Oracle 19c.

Designed Power BI and Tableau dashboards to deliver real-time insights into regulatory operations, improving labelling accuracy and process visibility.

Partnered with Regulatory Information Management (RIM) and Veeva teams to align Oracle and AWS data strategies with industry standards for data governance and validation.

Conducted complex data analysis using SAS and Python, transforming raw datasets into meaningful visualizations and summary reports.

Authored detailed test cases, unit testing scripts, and system integration testing documentation to validate application functionality and data accuracy.

Played a key role in configuration management, change control, and data migration efforts related to Veeva Vault integrations.

Developed UAT testing protocols and supported Agile/Scrum ceremonies to ensure timely regulatory reporting deliverables.

UnitedHealthcare, Bridgewater, NJ June 2018 – Aug 2018

Business Data Analyst – PL/SQL & Data Visualization

Developed complex PL/SQL scripts, procedures, and views to support healthcare reporting platforms focused on claims, insurance policies, and patient financial data.

Built and maintained Tableau dashboards and PowerPoint-based reporting packages to deliver actionable insights to business, operations, and executive leadership teams.

Led data validation efforts across multiple datasets, ensuring data accuracy, consistency, and regulatory compliance in healthcare reporting.

Conducted root cause analysis on data discrepancies and implemented quality assurance measures in collaboration with QA and DevOps teams.

Executed ETL processes using Informatica PowerCenter 10 to cleanse, deduplicate, and validate healthcare data from various sources.

Applied data governance principles to ensure adherence to privacy and compliance standards while managing healthcare datasets.

Utilized Git for source control and change management of PL/SQL code and Tableau reporting artifacts in agile delivery environments.

Partnered with data engineering teams to streamline database performance through indexing, query tuning, and schema optimization.

Documented data lineage, business rules, and reporting logic to support transparency and reproducibility in analytics workflows.

Contributed to data enablement efforts by translating business requirements into technical specifications and improving stakeholder access to trusted datasets.

Sanofi Pharmaceuticals, Bridgewater, NJ Nov 2013 – June 2018

Business Data Analyst – Regulatory Systems & Oracle PL/SQL

Collaborated with regulatory affairs and IT teams to support Oracle 12c database development and ensure successful global regulatory submissions using LIQUENT InSight and PAREXEL platforms in AWS environments.

Designed and optimized PL/SQL procedures and backend logic to improve data accuracy, streamline workflows, and enhance data exchange with international health authorities.

Led ETL processes using Oracle Data Integrator (ODI) to standardize medicinal product data and ensure compliance with IDMP (Identification of Medicinal Products) regulations.

Authored comprehensive SIT and UAT documentation, delivered user training sessions, and configured production-level security roles to meet audit and compliance requirements.

Improved operational efficiency through performance tuning, data remediation, and custom dashboard development for regulatory reporting.

Lockheed Martin, Seattle, WA Sept 2009 – Oct 2012

Data Analyst / Oracle Developer

Developed and maintained Oracle and Microsoft Access databases to support internal budgeting and project tracking initiatives.

Created dynamic finance reporting tools and dashboards using ColdFusion, Visual Basic, and C++ to streamline executive reporting.

Improved system performance and data reliability through custom SQL development, process automation, and documentation.

Partnered with internal IT teams to enhance data quality and compliance with corporate governance standards.

CACI, Seattle, WA Sept 2008 - Sept 2009

Oracle Reports Developer/Programmer

·Created Application programs for government budgeting in Cold Fusion/Microsoft Access using Visual Basic/ C++ Programming and Oracle Databases.

·Created Microsoft Access data budget and financial reports.

·Developed reporting tools in ColdFusion and CCS.

Army Corp of Engineers, Seattle, WA Sept 2007- Sept 2008

Oracle PL/SQL Reports Developer/ Business Data Analyst

·Administered Oracle and Microsoft Access Databases for the Army Corp. of Engineers.

·Developed software programs for Colonel and Sr. Army Corp of Engineers Staff.

·Created fiscal year employee budgeting reports for chief financial officer.

Talk America, New Hope, PA Aug 2004 - Aug2007

Network Operations Manager

·Managed/monitored network cluster of UNIX/Windows/Database servers of Oracle and Informix for Talk America network operation center.

·Troubleshoot issues with database

·Monitored and troubleshoot database hardware at the datacenter.

Contact this candidate