Power Query
Hazel Pearl Raagas, CPA
Business Finance Senior Analyst
Las Pinas City
Summary
Rational Senior Finance Analyst with 11 years of experience in Finance. Results-oriented and skillful in managing and breaking down large volumes of information. Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Seeking to maintain full-time position that offers professional challenges utilizing technical and interpersonal skills, excellent time management and problem-solving skills.
Overview
11
11
years of professional experience
11
11
years of post-secondary education
1
1
Certification
Work History
Business Finance Senior Analyst
Schneider Electric
Rosario, Cavite, Philippines
05.2023 - Current
- Analyze financial data, including manufacturing costs, operational expenses, and revenue trends.
- Prepare detailed financial reports, forecasts, and budgets to aid in decision making activities/processes
- Conduct variance analysis to identify discrepancies between forecast versus actual financial performance
- Collaborate with inventory control teams to ensure accurate valuation, reconciliation, and analysis of inventory levels. Provide insights on inventory optimization and assist in the resolution of inventory-related issues.
- Other reporting and analysis such as Part weights validation, direct labor productivity, Price, volume & FX sales data, purchase productivity validation, freight and other logistic data collections and their likes.
- Identify inefficiencies in financial processes and implement improvements to enhance data accuracy and efficiency
- Identify opportunities to streamline financial processes and enhance operational efficiency. Implement best practices and standardize financial procedures across the manufacturing department.
- Collaborate with cross-functional teams to identify areas of improvement, leading to increased operational effectiveness.
Finance Analyst - Intercompany Accounting
Chevron Holdings Inc.
10.2017 - 05.2023
- Processing of intercompany transactions including the preparation of invoices for local in-country compliance
- Perform month end accounting close activities
- Intercompany account reconciliation and analysis including tracing and escalating intercompany imbalances and other open items
- Settlement and collection of intercompany balances
- Ensure proper procedures and controls to maintain accounting records that comply with GAAP and regulatory requirements
- Support the customers' other intercompany activities
- Coordinate special projects and other ad hoc roles and responsibilities as assigned by Team Leader/Manager.
Finance Analyst
Regus Global Service Centre
06.2013 - 08.2017
- Responsible for accounting activities across the enterprise, whether embedded in Business Unit, in Corp, or Finance Shared Services
- Monthly/Quarterly Preparation and Calculation of Variable/Profit Share Rent Due
- Sending of Landlord Reports (directly to the LLs or Field Finance) Perform month end accounting close activities
- Rent Analysis and P&L Commentaries Balance Sheet Reconciliations Variable Rent Inquiries Respond to Internal and External Audits
Education
Bachelor of Science - Accounting
University of Perpetual Help System-Dalta
Las Pinas City 04.2001 - 04.2012
Skills
- Financial analysis
- Cost control and reduction
- Performance monitoring
- Knowledge of business operations
- Data analysis and interpretation
- Communication and collaboration
- Problem-solving and critical thinking
- Attention to detail
Accomplishments
- Used Power Query to automate computation of margin on inventory
- Developed templates for P&L monitoring and variance analysis
- Developed Sales dashboard and provided more valuable data for decision making to aid plant/operations
Software
Power BI
Certification
Certified Public Accountant
Timeline
Business Finance Senior Analyst
Schneider Electric
05.2023 - Current
Finance Analyst - Intercompany Accounting
Chevron Holdings Inc.
10.2017 - 05.2023
Certified Public Accountant
10-2014
Finance Analyst
Regus Global Service Centre
06.2013 - 08.2017
Bachelor of Science - Accounting
University of Perpetual Help System-Dalta
04.2001 - 04.2012