Jerrod C. Frances | +1 (931) 472-4714 | IAmJCF@Yahoo.com | LinkedIn |Portfolio
POWER BI DATA ANALYST | SQL & FINANCIAL DATA SPECIALIST
Results-driven data analyst with 4+ years of experience across transportation, waste management, and finance industries. Skilled in Power BI, SQL, Power Query, DAX, and Advanced Excel for data preparation, modeling, and automation. Adept at translating financial and operational data into actionable insights through ETL workflows and dashboard development. Recognized for improving data quality, reporting efficiency and business decision-making.
CORE SKILLS:
- Data Visualization & Reporting: Power BI (DAX, Power Query, Power BI Service), Advanced Excel, Power Automate.
- Data Preparation & Modeling: SQL, MySQL, Oracle SQL, Data Cleansing, ETL, EDA, Data Validation
- Finance & Accounting Analytics: SAP, Concur, Corcentric, QuickBooks Online, P&L Analysis, Reconciliation
- System Tools & Platforms: SharePoint, Azure AD, Microsoft O365 Apps, SSMS
- Programming: Python PROFESSIONAL EXPERIENCE:
Accounts Payable Specialist – Stinky Pinky, a Waste Pro Company | Clarksville, TN 📅 Sept 2024 – Aug 2025
- Managed full-cycle AP for multiple units; migrated legacy data post-acquisition into Waste Pro’s SAP ecosystem.
- Performed ETL and EDA on invoice and payment data using SQL and Power Query, ensuring reconciliation accuracy.
- Designed Power BI financial dashboards for budget tracking, vendor spend, and variance trends.
- Automated daily reconciliation and approval notifications via Power Automate, cutting manual time by 35%.
PowerBI Analyst, AP, Controller – Stinky Pinky | Clarksville, TN 📅 Aug 2023 – Sept 2024
- Directed company-wide financial analytics and reporting, overseeing all monthly P&L and balance-sheet outputs.
- Created Power BI reports integrated with QuickBooks Online and Excel, using DAX for key financial metrics.
- Standardized financial datasets through Power Query transformations, enabling accurate automated refreshes.
- Utilized SQL for data validation and variance checks, improving accuracy of month-end reconciliation.
- Presented dashboards and KPIs during executive finance meetings, driving data-based strategic planning.
- Oversaw IT modernization – migrated file servers to SharePoint, improving collaboration and data governance.
Power BI Analyst, Sys Admin – MPG Transport LLC | Clarksville, TN 📅 May 2021 – Aug 2023
- Developed and maintained Power BI dashboards across finance, logistics, HR, and operations.
- Executed full ETL pipeline – extracted data from MySQL and Excel, cleaned via Power Query, modeled for Power BI.
- Conducted exploratory data analysis (EDA) to detect operational inefficiencies and forecast trends.
- Authored DAX measures and calculated columns for margin, delivery, and cost KPIs.
- Automated data refresh and distribution using Power BI Service and Power Automate.
- Implemented security layers & role-level access within SharePoint to ensure data privacy compliance.
PROJECT HIGHLIGHTS
Financial Performance Dashboard | Stinky Pinky (Waste Management Domain) Stinky Pinky Report
- Consolidated QuickBooks and Excel data into Power BI via Power Query for real-time P&L and expense insights.
- Developed custom DAX measures to track cash flow and operating margins month-over-month.
- Improved reporting cycle time by 40% using Power Automate for data refresh and PDF distribution.
Operational Insights Dashboard | MPG Transport LLC (Logistics Domain) MPG Transport Report
- Combined data from MySQL and Excel to develop interactive Power BI dashboards for route efficiency and fleet utilization.
- Performed EDA to identify high-cost routes and driver performance patterns leading to 15% cost savings.
- Published reports to Power BI Service with scheduled refreshes and drill-through pages for department heads.
EDUCATION
Bachelor of Science in Database Administration – Austin Peay State University, Clarksville, TN | May 2021
Bachelor of Science in Computer Information Systems – Austin Peay State University, Clarksville, TN | May 2021