Business Intelligence Data Analyst

Marc S. Agger

** ****** ***** *****

Windham, Maine 04062

Cell: 207-***-****

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

Value Statement

Providing transparency into essential operational metrics that demonstrate business value and program success.

Education

M.P.H., Epidemiology and Biostatistics, Boston University School of Public Health B.A., Psychology, Clark University

Professional Experience

Payvus Small Business Credit Card (2023 - Present) Director, Business Intelligence

● Using a combination of MySQL, PowerBI and Excel, developed data pipelines, operational dashboards, and credit management tools for a start-up small business credit card.

● Designed, developed and implemented automated consumer engagement systems using a combination of MySQL and HubSpot.

● Developed back-end systems to support a credit card rewards payment program. Aliaswire, Inc. (2021 - 2023)

Director, Business Intelligence

● Developed comprehensive BI systems supporting multiple stakeholders, ensuring clear visibility into key performance metrics.

● Collaborated with business leads to identify success drivers and design KPIs, resulting in improved decision-making and operational alignment

● Implemented consumer engagement systems combining MySQL and Salesforce. Professional Data Solutions Inc. (2020 - 2021)

Director, Business Intelligence

● Lead analytic support for large convenient store retailers including Exxon, Citgo and Circle-K, providing insights to inform targeted marketing and loyalty strategies.

● Developed and implemented methodologies to evaluate the impact of CPG loyalty offers.

● Using a combination of AWS RedShift and Tableau, designed next-gen loyalty metrics and dashboards, streamlining reporting and enhancing data accessibility for key stakeholders.

Zipline (2016 - 2020)

Director, Business Intelligence

● Directed loyalty and payments reporting, establishing a unified dashboard system for internal and external client use that improved report accessibility and data-driven decision-making.

● Developed methodologies to measure program lift and financial ROI, directly contributing to increased program investment and customer segmentation insights.

● Generated insights that refined segmentation and targeted marketing, resulting in increase in customer engagement and retention.

● Implemented solutions using a combination of Microsoft SQL-Server, PowerBI and Excel.

Health Dialog Inc. (2000 - 2016)

Clinical Informaticist & Senior Scientist, Analytic Development

● Acted as strategist, cross-functional team leader, and client advocate in developing and launching population health management products.

● Pioneered novel clinical-intelligence products, such as Population Health Care Pathways, enabling real-time health status tracking and personalized intervention planning.

● Developed predictive risk models (e.g., hip, knee and back surgery, depression, obesity, end-of-life) to improve targeted interventions, enhancing care outcomes for high-risk populations.

Edmund S. Muskie School of Public Service (1992 - 2000) Health Data Manager and Research Analyst

● Developed clinical quality reporting tools for Medicaid, including the Primary Care Incentive Plan, which distributed $3M annually to 900+ primary physicians across the state of Maine.

● Utilized SAS tools to create intranet based querying capabilities, significantly reducing data retrieval time for program analysis.

● Managed projects on rural mental health service access, primary care shortage identification, and small business health insurance, producing actionable insights for state policy improvements.

● Led data analysis for the Maine Liability Demonstration Project, assessing the impact of health care reforms on medical malpractice.

Public Health Resource Group, Research Associate (1989 - 1992)

● Conducted market research for hospital planning leading to the development of a data driven insights solution leveraging multiple inputs such health claims data, mortality, and census data, to support regional and strategic planning.

● Analyzed Medicaid data to assess access to obstetrical care, informing policy recommendations for state-funded healthcare programs. SKILLS

Database Programming: Oracle SQL, Microsoft SQL-Server, AWS RedShift, MySQL, Python Visualization: PowerBI, Tableau, Excel

Analytic: SAS, SPSS

CRM: Salesforce, HubSpot

AI: ChatGPT

Contact this candidate