Jesus Oliva
Apodaca
Summary
Finance and technology professional with extensive experience in process automation, financial analysis, and solution development. Proven track record in creating applications, dashboards, and improving methodologies for enhancing operational and financial processes. Skilled in budget tracking, variance analysis, cost management, and financial modeling, with expertise in tools such as Power BI, Power Apps, Power Automate, SharePoint, and ShortPoint. Known for optimizing communication and workflows across departments, achieving significant efficiency improvements and cost reductions.
Overview
5
5
years of professional experience
1
1
Certification
Work History
SharePoint Developer
Prianti Consulting
Remote
04.2024 - 08.2024
- Provided technical support and consulting services to various departments at Metalsa through Service Desk, addressing a wide range of process improvement needs.
- Developed dashboards, apps, and methodologies using SharePoint, Power BI, Power Apps, and Power Automate to enhance process automation and problem-solving capabilities.
- Embedded visualizations and reports into platforms to track key financial and operational metrics, improving decision-making processes across teams.
FP&A Analyst
Terex Genie Mexico
Cienega De Flores, Nuevo León, Mexico
10.2021 - 03.2024
- Led the Rolling Forecast (3+18, 6+18) process, ensuring accurate financial planning and analysis across departments.
- Created the "Budget Tracker" application, tracking purchase orders (POs) and automating workflow to prevent bottlenecks, resulting in a 50% reduction in delayed invoices and a 90% improvement in process tracking.
- Calculated key financial ratios such as efficiency, leverage, profitability, and liquidity, providing detailed financial insights to drive business decisions.
- Managed travel expense tracking for employees, ensuring accurate reporting and adherence to budgetary constraints.
- Developed a comprehensive financial model for forecasting, budgeting, and overtime calculations, optimizing labor cost management.
- Produced Global cost tracking reports, analyzing and reporting on budget vs. actual spend, and conducted monthly variance analysis on material costs, including cycle counts, scrap details, and price variances.
- Improved interdepartmental communication by 80% through the development of a financial SharePoint, facilitating document sharing and enhancing collaboration.
Auxiliar contable
Foton Mexico
General Escobedo, Nuevo León, Mexico
01.2020 - 09.2021
- Streamlined the accounts payable process by implementing Aspel for mass XML invoice downloads, resulting in a 100% improvement in processing speed.
- Managed key performance indicators (KPIs) for the sales department, such as average ticket per invoice, product volume per invoice, and monthly invoice volumes using Excel.
- Played a key role in automating manual financial processes and improving the accuracy of daily transaction reporting.
Education
High School Diploma -
Universidad Autonoma De Nuevo Leon (FACPYA)
San Nicolás De Los Garza, Nuevo León, Mexico07.2024
Skills
- Problem Solving
- Analytical Thinking
- Adaptability
- Communication Skills
- Time Management
- Collaboration
- Attention to Detail
- Leadership
Certification
- Microsoft Certified: Power BI Data Analyst Associate, ADDC PERU
- Consultek Microsoft Certified: Power BI Data Analyst Associate
- ADDC PERU Microsoft Certified: Power Automate & Power apps
- Quick Learning
Languages
English
Timeline
SharePoint Developer
Prianti Consulting
04.2024 - 08.2024
FP&A Analyst
Terex Genie Mexico
10.2021 - 03.2024
Auxiliar contable
Foton Mexico
01.2020 - 09.2021
High School Diploma -
Universidad Autonoma De Nuevo Leon (FACPYA)