Andrew Thompson
Summary
Senior Data and Systems Analyst with extensive experience in designing, developing, and optimizing data pipelines, database architectures, and enterprise analytics solutions. Skilled in SQL, Python, ETL/ELT processes, Snowflake, Tableau, Power BI, Alteryx, and AI-driven automation. Proven ability to build scalable data models, engineer high-performance workflows, and support both front-end user applications and server-side systems. Experienced in data visualization, predictive analytics, and statistical modeling to drive operational efficiency and improve data quality across cross-functional environments. Strong track record of enhancing data integrity, reducing discrepancies, and delivering reliable dashboards, reports, and automated solutions. Adept at collaborating with engineering, product, and business teams to implement robust data systems and support enterprise-level decision-making.
Overview
13
13
years of professional experience
1
1
Certification
Work History
Data Analyst II
OPTUM
01.2019 - 10.2025
- Resolved complex data discrepancies by identifying root causes with stakeholders, improving data accuracy, accelerating operational turnaround times and producing actionable insights.
- Improved first-time resolution rates by 70% and enhanced data visibility by transforming KPIs and operational metrics into scalable dashboards and ad hoc reports using Tableau and Power BI, delivering actionable business insights.
- Increased client adoption by 20% for a web-based application by leading onboarding initiatives, executing targeted outreach, and developing custom UX workflows for cross-functional teams.
- Managed concurrent development, large datasets, streamlining data ingestion pipelines in Snowflake, and optimizing ETL workflows using Alteryx and generative AI development tools.
- Delivered a large-scale data migration project three iterations ahead of schedule by leveraging Azure, Python automation, and data-warehouse/lake architectures to support on-premise-to-cloud modernization.
- Triaged and resolved high-priority discrepancies across business segments using ServiceNow, ensuring timely issue resolution while supporting project workflows, data-quality validation, testing, and pre-/post-deployment deliverables in Rally.
- Notable Contributions:
Business Production Analyst
LINCARE
03.2014 - 01.2017
- Ensured data integrity across security and analytical systems by implementing security protocols, monitoring access compliance and proactively developing practical solutions.
- Redesigned and standardized security guidelines across two regional offices, reducing security discrepancies by 34% and improving compliance within highly regulated, data-sensitive environments.
- Led stakeholder engagement and technical troubleshooting for ECG/EKG devices and related applications, improving issue resolution speed by 40% through targeted, data-driven root-cause analysis.
- Increased first-time resolution rates by 60% by leveraging Excel, product logs, and issue-tracking systems to analyze and resolve complex clinical application, data, and network issues.
- Delivered multi-channel stakeholder support, enhancing communication flow, issue visibility, and real-time escalation across operational teams.
- Notable Contributions:
Senior Business Analyst Consultant
CIGNA AND AETNA
09.2012 - 06.2013
- Coordinated cross-functional collaboration across five web-development initiatives, ensuring timely delivery and alignment with business goals.
- Expanded healthcare client base by 25% by executing strategic follow-ups, driving stakeholder engagement, and facilitating structured UAT and JAD sessions to validate requirements and optimize system functionality.
- Accelerated delivery of a major Healthcare Plan tool revamp by efficiently gathering and prioritizing high-impact requirements, enabling completion within two development sprints.
- Captured and documented business requirements using BRDs, IBM Rational/ClearCase, and standardized traceability frameworks, improving development accuracy and alignment across technical teams.
- Led cross-functional product reviews via SharePoint, ensuring internal and external stakeholders remained aligned on deliverables, timelines, and system expectations.
- Enhanced tool functionality and user experience by analyzing consumer feedback, forecasting value-added enhancements, and partnering with engineering teams to implement data-driven improvements.
- Notable Contributions:
Education
Master of Business Administration - Corporate Innovation
Post University
Waterbury, CTBachelor of Science - Information Systems Studies
Charter Oak State College
New Britain, CTSkills
- Technical Skills: SQL, MS SQL, Snowflake, Oracle, Alteryx, Tableau, MS Azure, Power BI, Generative and Development AI Tools, Databricks, AQT, Python, Java, SharePoint, Rally, SDLC, Agile, EMR/EHR tools, Cloud-based applications and computing, EFT, ETL Processes, Server Scripts, and automated data job development and scheduling
- Data & Analytics: Data management, mining, integration, governance, validation predictive analysis, statistical analysis, workflow optimization, performance Monitoring, data visualization and modelling
- Business & Operations: Business Process Improvement, HIPAA, Data Security Transit, stakeholder retention and engagement, cross-functional training & onboarding, security protocol, regulatory and Compliance Oversight
Certification
- Computer Systems Business Applications Information Technology | American Institute of Business | West Hartford, CT
- MS Azure for AI and Machine Learning | Coursera
- Databricks Accreditation Badge – Generative AI Fundamentals | Databricks Academy
Timeline
Data Analyst II
OPTUM
01.2019 - 10.2025
Business Production Analyst
LINCARE
03.2014 - 01.2017
Senior Business Analyst Consultant
CIGNA AND AETNA
09.2012 - 06.2013
Bachelor of Science - Information Systems Studies
Charter Oak State College
Master of Business Administration - Corporate Innovation
Post University
Professional Highlights:
- Improved first-time resolution rates by 70% by transforming large datasets, KPIs, and operational metrics into actionable dashboards and ad hoc reports using Tableau and Power BI, enabling faster root-cause analysis and data-driven decision-making.
- Automated analytical workflows by leveraging Generative AI tools, Power BI, complex SQL queries, statistical analysis, data cleaning techniques, and Python scripting, reducing manual effort and improving reporting efficiency.
- Enhanced data integrity and reduced discrepancies by 34% by exceeding delivery expectations, implementing structured validation processes, and strengthening cross-functional collaboration to improve operational performance.
- Increased quarterly stakeholder engagement by 20% through targeted outreach, onboarding initiatives, and the development of enhanced UX-focused dashboards and reporting experiences.
- Streamlined web-tool changeovers and system enhancements by leading requirements gathering, aligning cross-functional stakeholders, and driving an efficient Go-Live three development sprints ahead of schedule
- Strengthened system security and access governance by collaborating with security teams to refine tiered-verification workflows, manage access controls across multiple departments, and proactively mitigate priority data and system discrepancies.