Jhonson Francis
Bangor,PA
Summary
Accounting and Data Analyst with a proven track record at Monroe County Transportation Authority, adept in both Stata and Sage 50 accounting software as well as advanced Excel for financial reporting and data analysis. Detailed oriented, maintaining an organized record of accounts payable, general ledger and monthly reconciliations. Excelled in identifying trends and recommending solutions, enhancing decision-making and operational efficiency. Demonstrated exceptional collaboration skills. Actively pursuing CPA certification.
Overview
1
1
year of professional experience
Work History
Accounting and Data Analyst
Monroe County Transportation Authority
05.2024 - 11.2024
- Analyzed data to identify root causes of problems and recommend corrective actions.
- Produced monthly reports using advanced Excel spreadsheet functions.
- Utilized Sage Accounting Software to accurately track and prepare AP and AR.
- Balenced Budget for upcoming fiscal year.
- Handled incoming calls from consumers and transaction.
- Developed customized reports, summarizing and presenting data in visually appealing format.
- Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
- Collaborated with cross-functional teams to ensure data integrity and accuracy, resulting in better-informed decisions.
- Identified patterns and trends in large data sets and provided actionable insights.
- Generated accounting and financial reports, charts and forecasts.
- Handled cash transactions accurately, ensuring proper accounting for all sales activities.
- Performed monthly reconciliations of bank statements and weekly reconciliations of payroll deductions.
Education
Bachelor of Science - Economics
University of Dayton
Dayton, OH08-2024
Skills
- Sage 50 accounting software
- Excel proficient
- Budget balancing
- Bank statement reconciliation
- Month-end reports
- Bookkeeping
- Accounts receivable
- Accounts payable
- Audit Preparations
- Consumer acquisitions
Timeline
Accounting and Data Analyst
Monroe County Transportation Authority
05.2024 - 11.2024
Bachelor of Science - Economics
University of Dayton
Similar Profiles
Nicholas HenryNicholas Henry
Maintenance Mechanic at Monroe County Water AuthorityMaintenance Mechanic at Monroe County Water Authority
Gerald SmithGerald Smith
Section Manger Rail Maintenance of Way at Orange County Transportation AuthoritySection Manger Rail Maintenance of Way at Orange County Transportation Authority
Michael HilleyMichael Hilley
Coach Operator at Orange County Transportation AuthorityCoach Operator at Orange County Transportation Authority