Erica Collins
Sugar Land
Summary
Proven analytics consultant delivering data-driven insights and optimizing performance. Expertise in cross-functional collaboration, project management, and stakeholder engagement to drive impactful solutions.
Overview
8
8
years of professional experience
Work History
Analytics Consultant
Accenture
Houston
05.2021 - 11.2022
- As a consultant, I generate data-driven insights to optimize performance and influence decision-making at senior levels. Proactively manage dependencies, trade-offs, and cross-functional blockers. Contributions include:
DC Department of Health Account:
● Senior Data Analyst, Sprint Project Manager: COVID DC Health Dashboards Project
During this project, I worked as an analyst to add KPIs and visualizations to several COVID tracking dashboards. In addition, I created tasks to track sprints within a team of 5 and researched backend application additions to Tableau.
● Business Analyst, Project Manager, Senior Data Analyst: DC Health Database Migration Project
During this project, I worked with one other consultant to understand the new database’s data requirements, managed the Ghantt timeline for the migration including 6 DC health employees, and worked with one other consultant to check the legacy data of 50+ features.
● Analytics Business Analyst: DC Health Provider Enrollment Project
During this project, I served as the business analyst of a team of 8+ people to detail a legacy vaccine provider enrollment process built out of Quickbase. As the analytics consultant, I, with 2 other consultants, identified bottlenecks and manual processes. As the business analyst, I documented findings daily and detailed work products for further staffing. In addition, I served as the overall summarizer for all 3 DC Health projects, emailing the larger team of 15+.
● Analytics Designer: DC Health Syndrome Alert System Project
During this project, I created the design plan for the development of a Tableau-based alert system for the department’s data team. The system improvement would notify data employees of potential health outbreaks based on the combination of symptoms that patients reported at different hospitals. I provided a backend outline of their legacy system that included custom code and forecasting algorithms, a new process design and a Tableau mockup that was presented to DC Health product owners for development - Collaborated with cross-functional teams to develop data-driven strategies.
- Created visual reports to present insights and findings effectively.
Sr Analyst - Data Strategy & Insights
American Express
New York
07.2019 - 05.2021
- Drove end-to-end performance of digital onboarding and underwriting funnel, balancing growth and risk outcomes through dashboards of current deal flow and segments for risk team
- Identified and unlocked opportunities to expand acquisition funnel, improving conversion by collaborating with risk leader to present key results on pending deals
- Generated data-driven insights to optimize performance and influence senior decision-making by creating a model for risk team that analyzed deal percentage, collaborating across sales, marketing, risk, decision science, and technology
Finance & Data Analyst
IBM
New York
09.2014 - 07.2017
- * As an analyst, I worked to optimize IBM’s global data systems in order to retrieve more accurate sales results at the customer level. In addition, I created financial models for the forecast teams, helping to set targets for new business lines and IBM’s strategic imperatives.… more
- Financial Planning AnalystMay 2014 - 2017 · 2 yrs 9 mosKey Responsibilities:
• Portfolio Management and Plan Results. Expense Accruals/Financial Controls. Sales Model Advisory and Market Forecasting.
Key Achievements:
• Consulted major corporate teams on sales data reporting strategy and provided emergency pre-earnings release performance packages to HQ. Translated business and risk needs by improving Top 20 and Top 100 customer accounting models built in excel and powerpoint including adjustments to pipeline, plan/budget and actuals (Advanced Excel). Owned monthly market forecast of portfolio of IBM’s selected international accounts while driving test and learn experimentation.
Education
Master of Science - Analytics
Carnegie Mellon University
Pittsburgh, PA05-2019
BBA - Finance
The University of Texas At Austin
Austin, TX05-2014
Skills
- Data analytics
- Predictive analytics
- Statistical modeling
- SQL querying
- Tableau development
- Dashboard creation
- Performance optimization
- Risk assessment
- Cross-functional collaboration
- Stakeholder management
- Dashboard creation
Timeline
Analytics Consultant
Accenture
05.2021 - 11.2022
Sr Analyst - Data Strategy & Insights
American Express
07.2019 - 05.2021
Finance & Data Analyst
IBM
09.2014 - 07.2017
Master of Science - Analytics
Carnegie Mellon University
BBA - Finance
The University of Texas At Austin