Charles Terranova
Spring,TX
Summary
Accomplished Senior Data Analyst with a proven track record at AkzoNobel, adept in statistical modeling and team leadership. Spearheaded SOP automation and enhanced cross-functional execution, significantly improving accuracy and efficiency. Skilled in SAP COPA and Excel VBA, with a knack for synthesizing complex data into actionable insights. Excelled in roles requiring precision, analytical prowess, and collaborative strength.
Overview
12
12
years of professional experience
Work History
Senior Data Analyst
AkzoNobel
Houston, Tex
09.2022 - Current
- Created forecasts comprised of $17,500,000 of material for two divisions within the network for 1,400 finished goods SKUs, as demonstrated by using top-down and bottom-up analysis.
- Provided KPIs for the entire network comprised of 14 business units.
- Pioneered, automated, and created SOPs for Open Order reports, Inventory reports, MAPE calculations, and Special-Order projects, resulting in improved accuracy and cross-functional execution.
- Gathered market intelligence from five sales managers across different regions to sharpen accuracy.
- Functionally supervised 10+ production planners and logistics planners, resulting in improved stock positioning, production prioritization, and prompt delivery dates.
Data Analyst
Goldstar Electric
Remote, TX
11.2019 - 04.2022
- Prepared forecasts via predictive analysis.
- Create SOPs for internal stakeholders.
- Compiled and modeled statistical data using Excel, Python, and Power BI.
Logistics Management
U.S. Marine Corps
12.2013 - 01.2020
- Served as a mentor to junior team members, as evidenced by the betterment of junior Marines' improved quarterly cutting scores and promotions.
- Worked at a rapid pace to meet tight deadlines, which resulted in mission readiness.
- Monitored the status of commodities through GCSS/GCSSMC.
Purchasing Analyst
Siemens Corporation
Houston, Texa
12.2018 - 10.2019
- I surveyed the status of deliveries, as demonstrated by querying Open Order Reports in SAP for two plants simultaneously.
- Reviewed and graded 17 vendor KPIs by supplying monthly, quarterly, and yearly progress reports reflecting their delivery reliability and capability.
- Worked closely with a team of 40+ Project Managers, Engineers, and Designers, which resulted in a granular understanding of current and future projects.
Logistics Planner
Schlumberger
Houston, Tex
08.2017 - 10.2018
- Successfully led several key projects, which resulted in higher profitability for Schlumberger, as demonstrated by contracting available lowest-cost carriers that have the capacity to execute RDDs on time.
- Oversaw logistics operations for over $4,500,000 per year in line hauls and back hauls that also consisted of company assets worth as much as $5,000,000 per truckload.
- Extended existing customer relationships through extensive communication via email and phone, on and off duty.
Skills
- Statistical modeling
- SAP COPA
- Inventory Analysis
- Excel VBA
- Team Planning & Building
- Data Presentation
- Public Speaking
- Advanced Excel
Accomplishments
- Achieved 8% cost reduction by amalgamating Transportation Requests for SLB Assets in 2 quarters after a 10% volume increase. (Schlumberger)
- Lead critical weekly demand control meetings comprised of cross functional departments within the company resulting in improved stock positioning, improved Made To Order forecasts, and production prioritization
- Improved MAPE % accuracy by 25% as demonstrated by granular communication with sales managers
- Created SOP for Inventory Reports, SAP COPA reports, Open Order Reports, MAPE Calculation reports, Made To Order Prioritization, and Transaction History Reports.
Languages
Spanish
Native/ Bilingual
References
- Oliver Miyokawa- 832-953-4699 (CFO & Board Member - Goldstar Equities)
- Alex Kaster - 832-866-8934 (Demand Analyst - AkzoNobel)
- Jacob Davis - 713-863-6761 (USMC Platoon Seargeant)
Timeline
Senior Data Analyst
AkzoNobel
09.2022 - Current
Data Analyst
Goldstar Electric
11.2019 - 04.2022
Purchasing Analyst
Siemens Corporation
12.2018 - 10.2019
Logistics Planner
Schlumberger
08.2017 - 10.2018
Logistics Management
U.S. Marine Corps
12.2013 - 01.2020