Excel
Bilingual Senior Financial Analyst with analytical profile and drive to make continuous improvements in efficiency and accuracy of accounts reconciliation and financial reporting using Excel and programming tools as Visual Basic and Python.
Highly motivated and goal-driven skilled in collecting, monitoring and studying data to analyze financial status. Experienced in qualitative and quantitative analysis. Tech-savvy in use of spreadsheets, accounting and financial management software. Versed in balancing priorities and meeting deadlines under pressure. Adapts quickly to challenges and changing environments.
Performed end-to-end process from new customer set up to final sale and billing for 135 airline lifting fuel at 7 critical airports. Developed negotiation skills interacting with key teams in BP Aviation and Airport staff. Improved customer service skills focusing on the end-user experience and helping retain and gain new customers at the airports, as well as other BP teams as my internal customers. Maintained good relationship and communication with our partners delivering the fuel at the airports.
May main accountabilities are:
- Inventory reconciliation for JET Fuel for 135 customers at 9 critical airports in the US and Mexico.
- Responsible for handling airlines requests and disputes.
- New/retained/lost customer set up internally and at the airport.
- Ensuring correct booking of Volume, flight, tail, customer and fees in SAP for accurate invoicing. Performing corrections if needed.
- Supporting Air BP Finance Team, Location Manager and Account Manager.
- Supporting on fees reconciliation process to make sure correct fees are being charged and corrections are done properly.
- Prepare desk procedure documentation to transition Mexico airports activities and to give training to the team in BP Mexico, including payments, settlements activities, inventory reconciliation and airlines disputes.
Contributed on creating the Settlements team for BP Mexico with 10 members. Created all processes and controls and helped develop the team processing Invoice and reconciling Inventory of 25 gas stations. Performed on site and remote training in Mexico and from Naperville's BP's offices. Managed the team remotely performing daily meetings to check the progress and handle issues the team had. Improved leadership skills as well as teaching skills. Created mutual trust as having a good communication was key during this process.
Settlement Analyst
- Invoice processing in SAP
- Identify invoice discrepancies on volume, product and price and work with the different teams to solve them.
- Create control report data and analyze and resolve missing payments.
- Prepare desk procedure documentation to transition activities, give training and manage the team in BP Mexico.
Site Reconciliation Analyst
- Gas Station inventory reconciliation for BP Mexico.
- Prepare desk procedure documentation to transition tasks and to train the team in Mexico.
Intercompany Reconciliation Analyst
- Work along with other BP areas to ensure proper SAP registration of purchase, sales, payments, invoices and accruals.
- Perform sales and purchase reconciliation reports to make sure all transactions are booked in SAP for both entities.
- Identify and resolve discrepancies.
- Negotiation and agreement with BP's trading partner analyst on missing bookings on each side.
Successfully transitioned HVC Inventory roles from four analysts during nine weeks training in the client’s office in Chicago to start performing those activities from Accenture and provided reverse KT to new joiners in Buenos Aires.
- Performed Inventory Reconciliation for eight terminals;
- Identified process improvements in reconciliation giving to a USD 300K savings annually to the client by reducing Gain and Loss amounts.
- Transaction Control Analyst responsible to book in SAP the daily movements of the client products.
- Automations SPOC for HVC Downstream. Created:
- Reports with trending analysis
- Operational reports and excel macro to decrease manual work, giving raw data the format needed to upload to the tools.
- Able to extract macros to improve quality of information and decrease manual work.
As a result of the automations it was achieved a cost avoidance of 200 hours annually.
- Perform all financial activities and control in collaboration with our customer leadership teams and corporate leadership during the monthly closing for a client in Brazil providing IT services
- Key role in budgeting and forecasting, review financial exceptions and perform deviation analysis and improvement proposals.
- Helped to achieve new and extended business opportunities providing pricing and business support.
January-2014 / January-2015, Audit & Litigation Semi Sr Analyst
- Coordination of the Audit & Litigation Team collecting documents and assembling the necessary reports on each audit or litigation
- Provide audit support for major assets divested.
May 2012 / December-2013 Revenue Analyst
- Ensure correct registration of all accounts for Revenue Management for both the company and its partners
- In charge of the monthly closing, reporting, analysis and account reconciliation
- Provide support to partners, third parties and royalty and working interest owners regarding payments
Financial and operational reporting
undefinedExcel
Visual Basic
Python
Pandas
Jupiter Notebook
Microsoft Office
SAP
PostgreSQL
Data Science