I'm a finance and operations analyst who designs robust data systems and uses AI-driven approaches to drive meaningful improvements. I specialize in SQL querying, ERP reconciliations, data validation, and process automation to streamline end-to-end workflows and boost accuracy. I thrive in cross-functional teams, turning complex data into structured, scalable solutions. I enjoy mentoring and collaborating across technical and business groups to achieve precise, timely outcomes in challenging environments.

BILL WERTZ-AYITTAH

I'm a finance and operations analyst who designs robust data systems and uses AI-driven approaches to drive meaningful improvements. I specialize in SQL querying, ERP reconciliations, data validation, and process automation to streamline end-to-end workflows and boost accuracy. I thrive in cross-functional teams, turning complex data into structured, scalable solutions. I enjoy mentoring and collaborating across technical and business groups to achieve precise, timely outcomes in challenging environments.

Available to hire

I’m a finance and operations analyst who designs robust data systems and uses AI-driven approaches to drive meaningful improvements. I specialize in SQL querying, ERP reconciliations, data validation, and process automation to streamline end-to-end workflows and boost accuracy.

I thrive in cross-functional teams, turning complex data into structured, scalable solutions. I enjoy mentoring and collaborating across technical and business groups to achieve precise, timely outcomes in challenging environments.

See more

Experience Level

Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Intermediate

Language

English
Fluent

Work Experience

Principal at Little Sparks Academy
October 1, 2024 - December 1, 2025
Built a Google Sites portal enabling teachers to upload lesson notes, post exam schedules, and share announcements; integrated calendar and Google Drive to streamline content management. Designed Excel macros to generate new term sheets, carry forward unpaid balances, and flag debt thresholds, consolidating results into automated overdue-fees dashboards. Supervised staff performance with a Google Sheets system using Apps Script automation (time-driven triggers and email alerts) to track weekly lesson note submissions and automatically issue queries for non-submissions.
Freelance IT & Data Projects Lead at Motioncraft Studios
September 1, 2019 - Present
Led a creative team delivering web design, back-end development, mobile app interfaces, UI/UX design, and graphic design. Built platforms for event creation, management, RSVP tracking, automated e-ticket generation, and attendee dashboards with interactive search and filters. Created interactive prototypes in Figma to illustrate user flows, branding packages, and to help startups establish a distinct presence and stronger market visibility.
Finance Systems Officer at Volta River Authority
November 1, 2023 - December 1, 2024
Prepared and posted journal entries in the Oracle General Ledger, and imported batch journals via spreadsheet templates. Performed monthly reconciliations of general ledger, bank, and inter-company accounts to ensure accuracy, balanced books, and prompt discrepancy flagging. Created supplier and customer profiles, managed Chart of Accounts alignment, and conducted period closures for finalizing financial records in the Oracle ledger.
Teaching Assistant at University of Professional Studies
August 1, 2022 - August 1, 2023
Prepared lecture slides and assignments for Business Economics, Quantitative Methods, Research Methods, and Intro to Business Statistics. Graded exams, proctored assessments, and led discussions; supported sections with up to ~150 students.
Actuarial Intern at The National Insurance Commission
July 1, 2022 - October 1, 2022
Assisted in reviewing solvency margins of insurance companies; gained practical experience using NIC's Regnology regulatory software for data entry and form preparation, and applied Excel and RStudio for data cleaning and preliminary analysis.
Computing Teacher - Volunteer at Presbyterian Boys' Secondary School
June 1, 2021 - July 1, 2021
Volunteered as ICT teaching assistant; helped students grasp core computing concepts through discussions, practical exercises, and follow-up assessments.

Education

Bachelor of Science in Accounting at University of Professional Studies, Accra, Ghana
January 1, 2019 - January 1, 2023

Qualifications

Oracle Cloud Infrastructure Data Science Professional badge
January 11, 2030 - December 17, 2025
Oracle Cloud Infrastructure Generative AI Professional badge
January 11, 2030 - December 17, 2025
OCI AI Foundations Associate badge
January 11, 2030 - December 17, 2025
Tools for Data Science V2
January 11, 2030 - December 17, 2025
Data Science Orientation
January 11, 2030 - December 17, 2025
Technical Support Fundamentals
January 11, 2030 - December 17, 2025
Introduction to SQL
January 11, 2030 - December 17, 2025
The RProgramming Starter Course
January 11, 2030 - December 17, 2025
Learn PHP Programming from Scratch
January 11, 2030 - December 17, 2025

Industry Experience

Education, Energy & Utilities, Financial Services, Media & Entertainment, Professional Services