ENOCH ANDREW WHENTON
Eichstätt
Summary
Master's Student and Microsoft Certified Data Analyst with 4+ years of experience in data analysis. Experienced in engineering automated ETL pipelines to analyze data & generate actionable reports by integrating Excel, SQL, Power Automate, and Power BI. Proficient in Python for predictive analysis, seeking to leverage skills in a data-driven internship role.
Overview
4
4
years of professional experience
1
1
Certification
Work History
Data Analyst
CEQA FOODS AND BEVERAGES
03.2025 - 10.2025
- Engineered an automated sales monitoring Power Bi report by integrating Power Automate, Excel, and Power Query to enable daily variance analysis
- Built a Power Bi report pipeline by executing SQL queries on ERP data to visualize KPIs that pinpoint high-waste inventory items.
- Built dynamic Power BI report templates to track daily, weekly and monthly food inventory deficits and surpluses across branches.
- Analyzed inventory stock data versus recorded usage to identify unaccounted inventory trends, improving shrinkage detection.
Business Data Analyst (Freelance)
10.2023 - 03.2025
- Built a multiple linear regression model via Python to forecast property prices for a real estate business.
- Built 5+ interactive Power BI & Looker dashboards for retail enterprises to track KPIs and review performances.
- Developed a financial model via Excel for a Palm Oil Business to enhance demand forecasting and operations tracking.
- Integrated survey data from a talent platform into an SQLite database to enable real-time reporting via Power BI
Finance Officer
PAN AFRICAN SAVINGS & LOANS
10.2021 - 10.2023
- Streamlined daily Profit & Loss reporting by automating deposit and loan disbursement analysis with Excel Macros reducing reporting time by 80%.
- Automated capital expense data aggregation from multiple sources with Power Query, significantly improving efficiency in monthly reporting.
- Built weekly and monthly progress dashboards in Power BI to be presented to stakeholders.
- Consolidated asset data across all company branches into a central database, significantly enhancing reporting efficiency
Education
Master of Science - BUSINESS AND PSYCHOLOGY
Katholische Universität Eichstätt-Ingolstadt
Ingolstadt, Germany10-2027
BACHELOR OF ARTS - PSYCHOLOGY & INFORMATION STUDIES
UNIVERSITY OF GHANA
Accra, Ghana11-2021
Skills
- Data Visualization: Microsoft Power BI (DAX, M), Google Looker Studio
- Programming & Databases: Python (Pandas, Scikit-learn), SQL (MySQL, PostgreSQL)
- Office & Tools: Advanced Excel (VBA/Macros), Power Query, Microsoft Power Automate, Sharepoint, PowerPoint, Jupyter Notebooks
- Languages: English (Native/C2), German (A1 - Beginner)
Certification
- Microsoft Certified: Power BI Data Analyst Associate (PL-300) | Microsoft
- Google Data Analytics Professional Certificate | Google
- Business Data Analytics Professional Development Training Program | Centre for Business Analysis (CBA), IIBA Endorsed
PROJECTS
Wake County Expenditure Analysis - Power BI Dashboard
Transformed Wake County's budget data (2016—2019) into an interactive dashboard to aid financial decision-making.,
Predictive Analytics for Palm Oil Retail Business - Microsoft Excel
Built a predictive regression model to forecast demand, factoring in price and unit cost fluctuations.
Please visit https://whentonenoch17.wixsite.com/my-site-1 to visit my portfolio website for project details.
Timeline
Data Analyst
CEQA FOODS AND BEVERAGES
03.2025 - 10.2025
Business Data Analyst (Freelance)
10.2023 - 03.2025
Finance Officer
PAN AFRICAN SAVINGS & LOANS
10.2021 - 10.2023
Master of Science - BUSINESS AND PSYCHOLOGY
Katholische Universität Eichstätt-Ingolstadt
BACHELOR OF ARTS - PSYCHOLOGY & INFORMATION STUDIES
UNIVERSITY OF GHANA