About
Results-driven Data Analyst and Data Entry Specialist with a strong foundation in Accounting and an exceptional eye for detail. Expert in bridging the gap between raw data and strategic execution by engineering automated spreadsheets, optimizing data workflows, and building dynamic business intelligence dashboards. Proficient in Microsoft Excel (Advanced), Google Sheets, Zoho Invoice, Power BI, and PostgreSQL. A proactive problem solver dedicated to eliminating operational inefficiencies, reducing manual errors through smart automation, and delivering data-driven insights that protect and grow business margins.
Projects
Automated Invoice for Accounts Receivables (Google Sheet-Based)
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.
Sales Analysis Dashboard-Microsoft Excel-Based
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.
Student Result Management System (Excel-Based)
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
Multi-Tenant Syndicate Investment Ledger & Real-Time Portfolio Risk Engine
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.
Work
Freelance Data Analyst and Data Entry Specialist
|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.
Shatom Int’l Services, Yenagoa, Bayelsa State
|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.
Education
→
Virtual Class
Data Entry
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
Skills
Data Cleaning and Data Visualization
Cloud-Based Collaboration Tools
Microsoft Office Tools, Google Business Tools
Microsoft Excel, Google Sheets, and PowerPoint, Microsoft Word, Google Sheets, Google Doc, PowerPoint, Google Slide, Google Forms, Jot Forms, File Organization.
Dashboard Development and Reporting
Billing Tools Setup
Zoho Invoice, Loyverse.
Spreadsheet Automation
Lookup Functions, Import Range, Data Validation, Conditional Funtions.
Bookkeeping and Financial Reporting
Cloud-Based Collaboration Tools
Internal Control and Workflow Improvement
Strong Written and Verbal Communication Skills
References
Mr. Jacobson Park
Broadcaster, Golden FM Mike Okporkpor Street, Kpansia, Yenagoa, Bayelsa State +2348032397226 jacobsonpark1@gmail.com
Prof. Akens Hamilton-Amachree
Lecturer/Research Fellow, Federal University Otuoke Ogbia, Bayelsa State +2347038353141, +2347025493768 hamiltonaa@fuotuoke.edu.ng
Featured Links
Freelance Solutions Via Upwork
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.
Publications
The Smart Invoice Suite v2.0: Automated B2B Billing, Dynamic Bulk Stock Depletion, and Multi-Country Tax Validation
Published by
Supported by the 3MTT Nigeria (Three Million Technical Talent) Fellowship Program
Summary
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.
Excel Spreadsheet Automation: Designing Dynamic, Zero-Error Data Reporting Systems and Automated KPI Dashboards
Published by
Self-Published Technical Architecture Documentation
Summary
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.
Languages
English
Proficient
Interests
Data Analytics & Reporting
Data Cleaning, Relational Databases, Data Extraction, Trend Analysis, Descriptive Statistics, Administrative Workflows, Structured Data.
Spreadsheet Engineering & Automation
Excel Automation, VLOOKUP, XLOOKUP, IMPORTRANGE, Advanced Formulas, Interactive Dashboards, KPI Tracking, Financial Reporting, Automated Report Cards, Data Entry Processing, Form Controls.
Account Receivables
Zoho Invoice, Loyverse, Spreadsheet Automated Invoice.
Data Lifecycle & Records Management
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.