My Portfolio 2
General Projects
Summary
More of my recent project on spreadsheet automation
General Projects
Summary
More of my recent project on spreadsheet automation
Summary
Developed a fully automated data-reconciliation and visualization ecosystem tracking corporate turnover and employee satisfaction metrics. Audited legacy data streams to build a centralized, tamper-proof repository on a 1–4 scale across multiple workplace indicators. Constructed the system architecture with zero overlapping formulas, enforcing structural integrity across multi-layered Pivot Tables to ensure real-time cross-verification with a 16% company-wide attrition rate. Designed a unified, dark-themed dashboard UI incorporating tailored visualizations, such as clustered column and donut charts, integrated with live department/gender Slicers, enabling leadership to instantly isolate operational bottlenecks and workforce burnout trends.
Freelance
Summary
An intelligent, cloud-based Operations & Billing Management System designed to modernize school administration. It replaces slow, manual data entry with automation inside the Google Workspace ecosystem, allowing institutions to handle student data, fees, inventory, and financial reports from a single dashboard. How It Works Instant Loading: Admins search and select a student from a custom sidebar to automatically fill in names, parent contacts, and billing dates. Smart Price Locking: When a fee or item is selected, a background script grabs the current price and locks it as a fixed number. This ensures future price changes never alter past financial records. Self-Healing Sheets: If a user accidentally clears a row or breaks a formula, the system automatically detects the error and restores the clean, underlying code instantly. One-Click Delivery: With one click, the system compiles the data into a professional PDF invoice, saves it to Google Drive, and creates a shareable link. Key Benefits for Schools Flawless Financial Audits: Protects past billing data. Schools can update tuition fees for a new term without corrupting the payment history of previous terms. Massive Time Savings: Cuts down invoice preparation, formatting, and file archiving from a clumsy 5 minutes per student to a 3-second, one-click execution loop. Faster Debt Recovery: Admins can copy the auto-generated invoice link directly from the tracker sheet and send it to parents via WhatsApp or Email for instant mobile viewing. Smart Inventory Alerts: Monitors physical school supplies (uniforms, textbooks, notebooks) in real time and highlights items with a "Low Quantity" flag to prevent stock shortages.
Freelance
Summary
Decoupled Tax Configuration Architecture: Isolates national tax adjustments on an independent backend settings dictionary, allowing business owners in the US, UK, Canada, and Nigeria to modify baseline compliance parameters with zero coding. Audit-Compliant Calculation Sequence: Programmed to dynamically evaluate trade discounts prior to computing state or national taxes, ensuring complete legal and financial reporting precision. Array-Protected Dynamic Inventory Tracking: Utilizes advanced multi-sheet logic to automatically monitor inventory depletion, opening balances, and low-stock alerts without manual data duplication.
Queries for Data Manipulation
Summary
This project highlights the use of Structured Query Language for extracting large datasets and manipulating transactional records across multiple relational databases.
Freelance
Summary
This project was design to study trends, patterns and timeline within a revenue period. Insight from this dashboard helps in obtaining insights that lead to better decision making for the business. while this file link is shared with Google sheet, Excel gives a better view as it was created using excel.
Freelance
Summary
Developed an automated student result management system using Microsoft Excel to compute scores, grades, and class positions. Reduced manual errors and improved efficiency through formula-driven calculations. Designed a dynamic template for generating student performance reports
Freelance-Members Ledger Automation
Summary
Architect and systems designer of a decentralized, double-entry financial ledger and risk compliance ecosystem engineered within a cloud spreadsheet infrastructure. This system replaces high-cost micro-finance SaaS platforms with a zero-subscription alternative for multi-member investment syndicates, capital pools, and cooperative funding networks. Key Architectural Frameworks & Technical Implementations: • Decoupled Multi-Tenant Architecture: Designed independent, secure client-facing account ledgers tracking Share Capital, Thrift Deposits, and Active Loans. Individual members gain secure, view-only mobile access to private real-time transaction balances without exposing the group's central database or endangering master formula integrity. • Centralized Cross-Sheet Data Aggregation: Developed a master administrative tracking matrix that utilizes advanced cross-file aggregation formulas (IMPORTRANGE arrays) to dynamically pull and consolidate decentralized member data into a unified balance sheet. • Automated Risk & Liquidity Underwriting: Integrated live financial sanity-check metrics that evaluate real-time Debt-to-Equity and Debt-to-Capital ratios across the fund, instantly triggering visual risk alerts when outstanding loan exposures exceed pre-configured organizational safety margins. • High-Volume Audit Trail Precision: Engineered structured historical ledger grids tracking debit/credit balance-brought-down (BBD) data, added capital allocations, and drawings, ensuring pristine, audit-ready data tracking for fund administrators. This project showcases advanced spreadsheet engineering, real-time distributed data management, and defensive corporate risk design.
General Project
Summary
This drive contains some of my projects on data Entry
Data Analyst/ Data Entry Specialist
Yenagoa, Bayelsa, Nigeria
Freelance
Summary
May 2025 – Present Helping Businesses to scale up through the creation of customized automated templates that meets Business solutions, using data analysis and data entry.
Highlights
Set up Zoho automated invoicing systems and Google Sheets income and expense tracking templates for Stepping Stone Schools, Yenagoa.
Developed passbook templates for tracking savings and loans for members of Onemind Business Cooperative Society, Yenagoa.
Assisted schools in automating student result processing through spreadsheet solutions. Built spreadsheet systems that improved reporting accuracy and reduced manual workload.
Yenagoa, Bayelsa, Nigeria
Contract
Summary
I contributed to the business by developing efficient financial and inventory tracking systems, preparing accurate invoices and income reports, monitoring sales and debtor accounts, and improving cash flow management through the effective use of Google Sheets and Zoho Invoice.
Highlights
Developed and implemented income and expense tracking templates using Google Sheets for real-time financial monitoring.
Created and maintained weekly imprest tracking templates to optimize cash management.
Prepared monthly income statements using Google Sheets tools to support financial decision-making.
Managed inventory tracking systems for medical supplies, helping to reduce waste and ensure timely replenishment.
Prepared patient invoices and billing statements using Zoho Invoice for improved accuracy and efficiency. Tracked sales and debtor accounts, contributing to improved collections and cash flow management.
Yenagoa, Riverine, Nigeria
Contract
Summary
I supported workforce and operational management by recruiting and training ad-hoc canvassers to drive monthly sales performance across assigned regions. I maintained accurate personnel records and workforce data using Microsoft Excel, prepared monthly payment databases for over 300 regional personnel, and ensured timely and organized payroll documentation. I also analyzed historical Excel records to extract valuable KPI insights and performance reports that supported management decision-making and operational planning.
Highlights
Recruited, trained, and supervised MoMo canvassers while consistently exceeding monthly agency targets.
Coordinated the job assessment exercise for over 500 candidates during the Presidential Amnesty Program in 2022.
Managed assessment data collection and collation using spreadsheets for Elper Nigeria company.
Prepared and maintained monthly databases for canvassers, improving operational efficiency.
Yenagoa, Riverine, Nigeria
Contract
Summary
I successfully recruited and onboarded Mobile Money agents across Riverine Territory, coordinated the branding of over 200 retail outlets, and supported agent liquidity management to ensure smooth financial transactions. I trained agents on transaction processes and CBN compliance standards, prepared operational reports using Microsoft Excel and Google Forms, and provided technical support by installing BVN enrollment applications on Windows systems. My contributions supported business growth, operational efficiency, and improved agent network performance.
Highlights
Ensured adequate cash flow for agents through coordination with financial partners.
Trained agents on transaction procedures and CBN compliance requirements.
Prepared daily, weekly, and monthly reports using Google Forms and Microsoft Excel.
Installed BVN enrollment applications on Windows 10 operating systems for trade partners.
Yenagoa, Bayelsa, Nigeria
Contract
Summary
Managed company cash transactions and expense disbursements with accuracy and accountability while maintaining organized financial records. Prepared and submitted daily receipt and payment reports to management via email, ensuring timely financial reporting and transparency. Also utilized Microsoft Excel to compute daily tilers’ wages based on square meter measurements, improving payroll accuracy and operational efficiency.
Manager
Yenagoa, Bayelsa, Nigeria
Permanent
Summary
Spearheaded the development of internal control systems by transforming manual data collection processes into structured spreadsheet-based reporting systems. Prepared detailed sales reports, inventory records, and cashbooks for management review, contributing to improved financial tracking and decision-making. Enhanced accountability and operational efficiency through accurate and organized record management practices.
Highlights
Digital Transformation & Process Optimization: Successfully transitioned the company’s core operational data from a high-risk manual paper system to a structured, automated Microsoft Excel infrastructure. Designed customized, secure ledger templates for each customer account using unique IDs and digital document integration. This eliminated data entry errors, mitigated fraud/theft risks for both agents and clients, and provided real-time visibility into accurate account balances and payable liabilities.
Courses
Introduction to Data Analysis
Microsoft Excel in Data Analysis
Structured Querry Language (SQL)
Python For Data Analysis
Power BI For Visualization
Courses
Using Cloud Storage Tools
Sales Tracking-Invoicing With Softwares
Electronic Forms For Data Collection
Tracking Exenses with Spreadsheet
Google Tools for SMEs
File Conversion
Inventory Management with Softwares
Writing Communication in Business
Courses
Accounting
Management
Finance & Banking
Marketing
Microsoft Excel, Google Sheets, and PowerPoint, Microsoft Word, Google Sheets, Google Doc, PowerPoint, Google Slide, Google Forms, Jot Forms, File Organization.
Zoho Invoice, Loyverse.
Lookup Functions, Import Range, Data Validation, Conditional Funtions.
Broadcaster, Golden FM Mike Okporkpor Street, Kpansia, Yenagoa, Bayelsa State +2348032397226 jacobsonpark1@gmail.com
Lecturer/Research Fellow, Federal University Otuoke Ogbia, Bayelsa State +2347038353141, +2347025493768 hamiltonaa@fuotuoke.edu.ng
Let’s collaborate on your next data project. Click here to review my client profile, check my other skills, and hire me securely for contract-based data analysis, advanced spreadsheet automation, and financial tracking solutions.
Supported by the 3MTT Nigeria (Three Million Technical Talent) Fellowship Program
Author and systems designer of an enterprise-grade spreadsheet manual and operational micro-ERP system. This publication outlines a decoupled relational database layout built completely inside a standalone spreadsheet framework, bypassing the need for recurring SaaS subscriptions (e.g., Zoho Invoice, QuickBooks). Key systemic frameworks detailed within the guide include: • Closed-Loop Warehouse Tracking: Utilizing advanced arrays (=ARRAYFORMULA(IF(ISBLANK(A2:A), "", C2:C+D2:D-E2:E))) to automatically process stock balance changes, prevent column formula corruption, and generate real-time low-quantity operational flags. • Multi-Regional Tax Logic: Integrating a detached tax settings engine with automated XLOOKUP matrices to compute localized B2B tax compliance parameters (VAT-NG, TAX-US, TAX-CA) across global markets. • Relational Data Warehousing: Constructing a horizontal transaction logging archive to preserve historical pricing integrity against future pricing modifications, directly feeding a centralized financial dashboard. This guidebook bridges the gap between accounting and warehouse logistics for high-volume B2B wholesalers and independent suppliers.
Self-Published Technical Architecture Documentation
A comprehensive technical blueprint showcasing the design and deployment of a database-driven spreadsheet infrastructure in Microsoft Excel. The architecture transforms flat-table data models into a dynamic front-end user interface. Key technical highlights cover the implementation of relational lookup models (utilizing advanced VLOOKUP structures and Data Validation), complex nested conditional logic for error-free grade and rank computation, and the automated generation of interactive report layouts. The system scales data processing workflows by over 80% while completely mitigating manual entry vulnerabilities.
Proficient
Data Cleaning, Relational Databases, Data Extraction, Trend Analysis, Descriptive Statistics, Administrative Workflows, Structured Data.
Excel Automation, VLOOKUP, XLOOKUP, IMPORTRANGE, Advanced Formulas, Interactive Dashboards, KPI Tracking, Financial Reporting, Automated Report Cards, Data Entry Processing, Form Controls.
Zoho Invoice, Loyverse, Spreadsheet Automated Invoice.
Data Entry, Information Management, Data Cleaning, Data Verification, Spreadsheet Maintenance, Error-Free Typing, Digital Filing, Record Keeping, Bulk Data Migration, Virtual Assistant, Document Organization, Data Transcription, PDF to Excel Conversion.