CHRISTINE CEPELAK        
DATA ANALYSIS & MANAGEMENT FOR IMPACT
Plano, TX 75093 | (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
  • Developing process flows, policy documentation & reporting
  • Additional ad-hoc reporting and work with cross-functional teams
  • Advanced Excel, Access, Tableau, Data Analysis & Reconciliation

Senior Data Analyst (Contract)

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, International Political Economy (2013)

Danish Institute for Study
Sustainable Development (2012)

LEED AP O+M (2013)
GRI G4 Trained (2013)

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

SKILLS
Software Tools
Advanced Excel
SAP, SalesForce
MS Visio
AWS
Tableau

Data Analyst Skills

Data Mining

Ad-Hoc Reporting
Policy Documentation
Process Flows

Programming Skills

HTML, CSS, JS, Bootstrap

PostgresSQL, SQL Server, SQL lite

Python (Pandas, Numpy, scikit-learn, Flask)

Interpersonal Skills

Leading Projects & Teams

Team Collaboration

Research & Reporting Problems

Stakeholder Relationships

Presenting to Non-Technical Audiences

Project Management Skills

Progress Tracking & Reporting

Program & Data Reporting

Establishing Metrics & Evaluation

Process Improvement

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