CHRISTINE CEPELAK        
DATA ANALYSIS & MANAGEMENT FOR IMPACT
Plano, TX 75024 | (214) 699-1178 | christinecepelak@gmail.com 
LinkedIn: https://www.linkedin.com/in/christinecepelak | Personal Website: http://christinecepelak.com/

RELEVANT EXPERIENCE

Data Analyst

Toyota North America | Plano, TX  | October 2017-Present

  • Evaluating, reconciling, and updating datasets for reporting
  • Identifying problem areas & investigating potential opportunities for growth
  • Data cleansing & regular quality assurance analysis and reporting
  • Leveraging SQL, Alteryx, Python, Access, and advanced Excel to analyze large data sets for decision-making and quality assurance
  • Additional ad-hoc reporting and work with cross-functional teams
  • Tableau, Alteryx, SQL, Python/Jupyter Notebooks, Advanced Excel, Access

Senior Data Analyst

Reddy Ice Corporation | Dallas, TX  | May 2017-October 2017

  • Data mining & analysis for insights used by C-level executives
  • Evaluating, reconciling, and updating account datasets
  • Identifying problem areas & investigating potential opportunities for growth
  • Data cleansing & regular quality assurance analysis and reporting
  • Developing process flows, policy documentation & reporting
  • Close work with the Director of Internal Audit, analyzing customer & financial data
  • Additional ad-hoc reporting and work with cross-functional teams
  • Advanced Excel, VBA, Data Mining, Data Analysis & Reconciliation


Senior Consultant - Data & Program Manager

Responsible Return | Dallas, TX | September 2014 - October 2017

Consulting program strategist and data manager & analyst.

Clients include:

  • City of Denton, TX - Consultant for a City-Wide Data Assessment
  • Consulted to conduct a city-wide sustainability assessment
  • Research, analyze & report financial, environmental, and quality of life data from diverse internal departments & external stakeholders
  • Data-driven program recommendations
  • Manage data quality and collection, and two direct reports
  • Cedar Valley College - Program Director
  • Invited to act as Interim Sustainability Program Director
  • Gathered and prepared college-wide operational sustainability data for analysis, reporting, and decision-making
  • Used data to identify potential opportunities and problem areas
  • Developed partnerships by facilitating faculty/staff committees
  • Collaborated with diverse stakeholders to plan & execute campus-wide events for over 1,000 total participants
  • Dallas Fort Work - Coworking for Entrepreneurs & Freelancers
  • Consulted to develop programming and KPIs to boost social capital and profitability
  • Recruited, trained, and cultivated a community of 50+ volunteers
  • Development of streamlined workflows for management of 10+ direct reports

Program & Data Coordinator

ThyssenKrupp Elevator Americas | Frisco, TX  |  2013 – Aug 2014

  • Lead manager of environmental data for 200+ sites, across 15+ countries, 20+ data reporters for annual reporting using SAP and advanced Excel
  • Worked across departments to ensure high data quality & database maintenance
  • Manager of strategy for product transparency initiatives, including close collaboration with NGOs and international industry task forces.
  • Obtained, managed, and analyzed data for complex product transparency reporting using Advanced Excel techniques, SAP & Salesforce
  • Consistent work translating technical data to non-technical team members.

Research Scholar

University of Texas at Dallas | Richardson, TX  |  Aug 2011 - April 2012

  • Designed a unique research project awarded grant funding & top 10 distinction
  • Obtained IRB permissions, conducted field interviews, presented data visualizations, developed partnerships with organizations for interviews

EDUCATION
University of Texas at Dallas
Bachelor of Science (2013)

AWS: Certified Cloud Practitioner (2018)
Google Analytics IQ (2017)
Certified SCRUM Master (2017)
MOS: Excel 2013 Expert
 (2017)
MOS: Access 2013 (2017)
MTA: Database Fundamentals (2017)

SKILLS
Programming
Python (Pandas, Numpy, scikit-learn)
SQL (Oracle, SQL Server)
GitHub
HTML, JS, CSS

Data Science
Bayesian statistics
Natural Language Processing
AWS

Software Tools
SAP
Advanced Excel, Access
Tableau, Alteryx

Data Analysis & Management

Data Mining

Ad-Hoc Reporting
Policy Documentation
Process Flows

Interpersonal & Leadership

Leading Projects & Teams

Team Collaboration

Research & Reporting Problems

Stakeholder Relationships

Presenting to Non-Technical Audiences

Project Management

Progress Tracking & Reporting

Program & Data Reporting

Establishing Metrics & Evaluation

Process Improvement

Plano, TX 75024 | (214) 699-1178 | christinecepelak@gmail.com