Jerrod C. Frances
557 Old Highway 48, Clarksville, TN 37040
(931) 472-4714 IAmJCF@Yahoo.com
My Portfolio Site: IAmJCF.com
Objective
Strategic and versatile analyst with robust experience in data analytics, financial operations, and systems administration. Proven ability to leverage tools like Excel, SQL, PowerBI, and Powerpoint to streamline workflows, uncover insights, and support executive decision-making. Recognized for leading IT and financial initiatives that improve efficiency and data integrity. Seeking a long-term data or financial analyst role where I can apply both technical and accounting expertise to drive organizational success.
Education
Bachelor of Science in Database Administration
Austin Peay State University, Clarksville, TN
Graduation Date: May 2021
Bachelor of Science in Computer Information Systems
Austin Peay State University, Clarksville, TN
Graduation Date: May 2021
Technical Skills
Data Analysis & Reporting:
- Microsoft PowerBI: Dashboard creation, data visualization, and reporting
- Excel: Pivot Tables, Macros, VBA, XLOOKUP
- Microsoft Power Automate: Workflow automation and data integration
Financial Management:
- QuickBooks Online: Invoice tracking, check writing, financial reporting, and end-of-month reconciliation
- Profit and Loss reporting, Balance Sheet preparation, and financial presentations
System Administration:
- Azure Active Directory, Microsoft Active Directory Domain
- SharePoint: Site creation, data management, and security protocols
- Microsoft O365 Apps
Database & Query Languages:
- Microsoft SQL Server 2019, SSMS, Oracle SQL, MySQL, Microsoft Access
- T-SQL, PL/SQL
- Database design, normalization, optimization, ETL, and security
Programming & Scripting:
- Java, Python
- HTML/CSS/JS, React.js, Node.js
- Eclipse IDE, Microsoft Visual Studio
Work Experience
Accounts Payable Specialist
Stinky Pinky, a Waste Pro Company, Clarksville, TN
Sept 2024 – Aug 2025
- – Continued in AP role after Stinky Pinky was acquired by Waste Pro on Sept 1, 2024
- – Handled full-cycle accounts payable responsibilities for multiple business units
- – Processed invoices and payments using SAP, Concur, and Corcentric
- – Maintained daily reconciliation reports and vendor communications
- – Utilized Excel for budget tracking, variance analysis, and process audits
- – Supported transition of legacy financial systems into Waste Pro workflows
Chief Financial Officer (CFO) & Director of IT and Data Analysis
Stinky Pinky, Clarksville, TN
August 2023 – Sept 2024
- Promoted to CFO due to strategic thinking, detail-oriented nature, and reliability.
- Managed all financial operations, including invoice tracking, physical check writing, and financial reporting using QuickBooks Online.
- Led end-of-month reconciliation and oversaw the preparation of financial statements.
- Directed Executive Finance meetings on the second Tuesday of each month, presenting Profit and Loss reports and Balance Sheets.
- Assisted the owner in setting up and managing the IT infrastructure of the newly acquired business, integrating business processes and technology for seamless operations.
PowerBI Data Analyst/Director of IT
MPG Transport LLC, Clarksville, TN
May 2021 – August 2023
- Developed and maintained PowerBI dashboards for 4 departments, enabling historical data analysis and accurate forecasting.
- Embedded reports on SharePoint for easy access by department heads, the CEO, and owners.
- Implemented data mining techniques from multiple sources to populate Excel databases, enhancing automated reporting through Power Automate.
- Overhauled the company’s IT infrastructure, including network security updates, server management, and equipment upgrades.
- Organized and secured files on SharePoint with multi-level security protocols, significantly improving data accessibility and confidentiality.
Student
Austin Peay State University, Clarksville, TN
August 2016 – May 2021
- Graduated with a Bachelor of Science in Database Administration during the COVID-19 pandemic.
- Won 1st place in the Computer Science Fair for producing a full-length music video, showcasing technical and creative skills.
Project Management
- Sole IT manager for a company with 100+ employees, tasked with modernizing the IT infrastructure post-COVID.
- Reorganized and secured a large file system, transitioning from Windows Server 2012 to a more secure SharePoint environment.
- Automated invoicing and reporting processes using Power Automate, Adobe, and Excel, resulting in time savings and improved accuracy in financial reporting.
- Designed and implemented multiple PowerBI dashboards linked to automated reports, providing critical data insights to company leadership on a daily, weekly, monthly, and annual basis.
References
Available upon request.