Learn Data Skills
Beta
Farah Clerveau

Farah Clerveau

Freelancer

NA

Technologies

My Portfolio Highlights

My New Project

Introduction to DataCamp Projects

My New Course

Introduction to Python

Quantitative architect, designing solutions with numbers as building blocks.

My Work

Take a look at my latest work.

course

Introduction to SQL

course

Introduction to R

course

Introduction to Python

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

My Work Experience

Where I've interned and worked during my career.

The Coca-Cola Company | Apr 2021 - Aug 2022

eCommerce Insights & Analytics, Senior Manager

Led multiple projects related to ecommerce shopper, sales, and marketing analytics •Developed executive level business intelligence visualizations and dashboards for eCommerce financial and KPI reporting •Partnered with multiple stakeholders to create quarterly roadmaps for the US business unit eCommerce data strategy •Created training material and provided live training to 100+ stakeholders for PowerBI dashboards •Provided thought leadership and cross industry insights through researching and documenting best practices •Collaborated with customer and IT teams to create new data pipelines and design analytics solutions
Show More

The Coca-Cola Company | Jan 2021 - Apr 2021

Innovation and Sustainability Analyst

Expansion of prior BI Data Analyst role with focus on innovation and sustainability data solutions for fairlife Organization ●Technical and Supply Chain lead for external certification data collection and created resource allocation framework ●Automated process flow for ingesting Consumer Interaction Center data into Power BI dashboard

The Coca-Cola Company | Sep 2020 - Dec 2020

Business Intelligence Data Analyst

Short Term Assignment with fairlife Organization to accelerate V2.0 of their data strategy - Conducting a business case to recommend which external certification best aligns with fairlife's mission and purpose statements - Engaging with key stakeholders to present analytical opportunities in implementing a transparent value chain - Leveraging CCNA network to provide fairlife Technical, Supply Chain, and Strategic Initiatives team with greater breadth in their consumer interaction data - Project manager for Animal Welfare data acquisition to gain insight on fairlife's Sustainability Health - Participated in Technical Writing course to continuously improve written communication skills

The Coca-Cola Company | Apr 2020 - Aug 2020

Lead Analytics, End-To-End (E2E) Sustainability

Short Term Assignment to accelerate End-to-End Sustainability effort in North America Business - Engaged with technical, brand, global, and external supplier associates to produce a holistic sustainability exploratory document on the system transition of green PET bottles to clear PET bottle - Exploratory analysis on sustainable agriculture within the Tea category to increase subject matter knowledge and identify key stakeholders, external trends, and next steps - Brought an external mindset to the team through sharing articles and best practices of industry peers to spark creativity and conceptualization - Implemented digital workplace tools (OneNote, Teams, OneDrive) and provided training to enhance the team's digitally remote collaboration efforts - Increased depth of knowledge in internal/external sustainability practices (packaging, sustainable agriculture, carbon footprint, etc.) through internal/ external training and networking - Collaborated with Technical Consumer Research on social listening to gain insight on consumer sentiment on sustainability topics - Collaborated on social and business connection points as a member of the department's Connections team to build team engagement - Participated in PowerBI, Alteryx, SQL, and Power App training to keep abreast of best practices in data applications - Participated in the creation of the Allyship Guidebook to help promote a more inclusive and just workplace

The Coca-Cola Company | May 2018 - Apr 2020

QSE Data Manager

- Expanded on prior role to include more responsibility and scope - Conserved 10+ hours a week by writing multiple Python scripts to automate manual data cleaning processes and embedded the code in a scheduled Alteryx Workflow - Identified reputable regulatory data source for various fleet metrics, consolidating data files from over 90 bottling organizations; efforts significantly reduced the data collection, cleaning reporting timeline, from days to hours. Without this data, there would be very little insight into fleet consumption for the North American System - Leveraged the Federal Motor Carrier Safety Administration's (FMCSA) data to provide an alternative source of reporting fleet safety metrics for the North America Bottling System - Controlled access rights to department Tableau Server Site as Site Administrator for over 50 internal and external users

The Coca-Cola Company | Sep 2016 - Apr 2018

Business Analyst

- Contributed supporting data in collaboration with Shared Services (internal department), Arbor Recycling (external partner), and the New York Department of Environmental Conservation (DEC) to aid in the prosecution of redemption centers that participated in fraudulent activity. The following NYC Daily News article highlights the outcome of a DEC investigation:(http://bit.ly/2mf7OTc) - Discovered new software such as Import.IO and Blockspring to integrate external data within the system. This discovery allowed for the work of integrating different data sources from the EPA and OSHA. - Pioneered the STEM Outreach Lead role in the Technical Innovation & Stewardship (TI&S) Women’s Forum whose purpose is to educate youth in the local community about women in STEM and STEM careers in the company. - Mentored colleagues on applying Tableau to their data and excel techniques such as VLOOKUPs / Pivot Tables

The Coca-Cola Company | Jun 2015 - Aug 2016

Financial Analyst

Analyzed the financial impact of the Container Deposit Laws to the Coca-Cola Bottling System in North America and communicated discoveries to Senior Leaders through creative, interactive Tableau Dashboards. •Collaborated with suppliers in deposit states and territories to identify redemption locations that were most susceptible to fraud through exploratory data analysis in Excel •Extracted data from SAP systems (SAP Business Warehouse NetWeaver) and visualized in Tableau •Mentored colleagues on practical Tableau application with their data, how to structure data for effective data analysis, and advanced Excel techniques such as VLOOKUPs and Pivot Tables

The Coca-Cola Company | Jun 2014 - Aug 2014

Container Deposit Compliance Intern

-Member of End-to-End Deposit Solution team contributed to framework to accurately capture cost, analyze commodity redemption and compliance. -Performed sales and redemption analysis cross-licensed brand, identified opportunity for cost avoidance. -Developed a sales and redemption report for Glaceau products in Connecticut -Performed data validation for redemption vendor locations to ensure accuracy -Authorized products available for redemption at vendor locations -Participated in Start Up Weekend

Flaggs Accounting, Inc | Aug 2010 - Jun 2014

Accounting Assistant

-Utilized Quicken and QuickBooks to input the data of 100+ clients -Organized and totaled 100+ source documents daily - Reconciled 100+ bank statements for various clients -Completed tax returns

Passport Magazine | May 2013 - Aug 2013

Accounting Intern

- Taught accounting interns Quicken and Quickbooks - Utilized Quicken and Quickbooks to file source documents - Interviewed applicants for accounting intern position

Study Edge | Jan 2013 - May 2013

Academic Intern

- Synopsized relevant information into a study guide for customers - Demonstrated time management skills by meeting deadlines - Promoted company through social media

Collegiate Candidates | Aug 2012 - May 2013

Fundraising Chair

- Incorporated new fundraising initiatives within the organization - Integrated $5 membership fee

Collegiate Candidates | Aug 2011 - May 2012

Treasurer

- Increased support from Athens business to financially support the organization - Established a banking account for the organization

Oglethorpe Dining Commons | Aug 2011 - Dec 2011

Food Service Worker

- Prepared food for 1,000+ customers daily - Maintained a clean work area

Hooch Hut | Sep 2010 - May 2011

Accountant

- Performed annual inventory - Recorded monthly revenues in Excel - Created annual reports using accounting software

My Education

Take a look at my formal education

Certificate, Data Science and AnalyticsGeorgia Institute of Technology | 2019
Bachelor of Business Administration (B.B.A.), Finance, Minor in FrenchThe University of Georgia | 2015
French StudiesAccent Français | 2013

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • Create Your Data Portfolio for Free