Data analytics specialist (MS Finance, Excel specialist, AI certified, Power Query / Power BI). Able to deliver reports, automate repetitive tasks, create templates, visualize data, simulate using Monte Carlo and more. 7 years of experience Freelancing on Upwork.…

Isaiah Gains

Data analytics specialist (MS Finance, Excel specialist, AI certified, Power Query / Power BI). Able to deliver reports, automate repetitive tasks, create templates, visualize data, simulate using Monte Carlo and more. 7 years of experience Freelancing on Upwork.…

Available to hire

Data analytics specialist (MS Finance, Excel specialist, AI certified, Power Query / Power BI). Able to deliver reports, automate repetitive tasks, create templates, visualize data, simulate using Monte Carlo and more. 7 years of experience Freelancing on Upwork.

See more

Language

Work Experience

Data Analytics Specialist at Upwork
January 1, 2019 - Present
Completed 150+ remote analytics projects for international clients with 100% job success, 5-star ratings, and Top-Rated status over the last 6 years. Automated data entry, transformation, analysis, and reporting using Excel (Pivot Tables, Power Query, advanced formulas, VBA) to reduce errors and improve workflow efficiency. Performed medical report analytics for oncology-related dosimetry and treatment guidance, including statistical analysis, data QC, and visualization. Built business intelligence KPI dashboards using Power BI and Excel. Delivered client consulting and training across Excel/Google Sheets and statistics for analysts through CEOs. Produced financial analyses including amortization schedules and automated income statement generation.
Business Development Analyst at Independent Marketing Alliance
June 1, 2017 - June 1, 2019
Collaborated with suppliers and member companies on 20+ foodservice industry procurement requests, delivering $1.3M+ in savings. Led the transition from Excel workbooks to a new RFP engine. Hosted training sessions for senior management and junior colleagues, bridging developers and business needs. Created tracking systems for $5.6M+ in recurring service fee payments, reducing reconciliation time by more than 50% each quarter.
Graduate Assistant & Academic Instructor at University of Houston
August 1, 2015 - May 1, 2017
Instructed students in Excel, Finance, Math, Statistics & Probability, and Economics with real-world applications. Supported the department business administrator with accurate and timely data entry, payroll processing, and financial reporting.

Education

Master of Science (M.S.) - Finance (Focus in Data Analytics) at University of Houston
January 1, 2015 - May 1, 2017
Bachelor of Science (B.S.) - Economics (Minor in Mathematics) at University of Houston
January 1, 2010 - December 1, 2014

Qualifications

Google AI Professional
June 1, 2026 - July 30, 2026
Google AI Essentials
May 1, 2026 - July 30, 2026
Corporate Entrepreneurship (University of Houston)
December 1, 2014 - July 30, 2026

Industry Experience

Professional Services, Healthcare, Financial Services, Education, Media & Entertainment
    SELECTED PROJECTS

    1.HRMS Development in Excel
    ▪Built a full HR management system using date-dependent formulas (such as DATE/WEEKDAY combined with text functions), while incorporating VBA with buttons/controls, PIVOT Tables, & dynamic visuals
    ▪Automated data management, payroll processing, & performance tracking, increasing operational efficiency & accuracy

    1. Medical Data Analytics for Oncology Reports
      ▪Collaborated with cancer research scientists & radiologists to analyze dosimetry data for patients undergoing radiological treatments
      ▪Summarized critical statistics using PIVOT Tables & transformed data using POWER QUERY, nested combinations of Excel functions (such as INDEX/MATCH, IF/IFS, AVERAGEIFS, XLOOKUP, TRANSPOSE, FILTER, UNIQUE, text functions etc.)
      ▪Performed rigorous data QC (Quality Control), verifying accuracy, completeness, and consistency of compiled datasets to ensure reliability of end reports & visualizations

    2. National Basketball Association (NBA) Personnel Salary Survey Analysis
      ▪Prepared confidential annual salary survey reports for 90+ NBA personnel, aiding in successful contract negotiations & salary adjustments over 4 years
      ▪Designed/deployed surveys using Google Forms; conducted comprehensive Excel data analysis to deliver anonymized insights, detailed summary statistics, & visualizations.

    3. Power BI Smart Home Protection Panel Dashboard
      ▪Developed a Power BI dashboard connected to a SQL database to visualize smart home metrics, including active devices & operational statuses

    4. Automated Income Statement Generator in Excel
      ▪Built a dynamic Excel template enabling entry/tracking of financial transactions — both cash inflows & outflows▪
      Leveraged PIVOT Tables & formulas to automatically aggregate data, producing comprehensive income statements with improved speed & accuracy

    5. Google Ads & Analytics Live Dashboard
      ▪Developed a live performance dashboard integrating Google Analytics and Google Ads data to track key marketing metrics in real-time using Looker
      ▪Automated data pulls and visualizations to monitor traffic, conversions, and ad spend efficiency, allowing stakeholders to make informed, data-driven marketing decisions

    6. Project Management Web App
      ▪Engineered a comprehensive Project Management Pipeline using Google Apps Script
      ▪Integrated HTML & JavaScript for data entry, modification, and search functionalities