MARIANO LAGOS
Houston,TX
Summary
Rational Finance Advisor with 5+ years of experience enhancing operations for organizations through information systems solutions. Proven track record of transforming specific business goals related to growth and efficiency improvements into new system designs. Knowledgeable innovator known for recommending new technologies to enhance existing systems and introduce new systems.
Overview
7
7
years of professional experience
5
5
years of post-secondary education
1
1
Certification
1
1
Language
Work History
JV Audit Analyst
Shell Exploration & Production Company
Houston, TX
08.2020 - Current
- Providing support to the internal audit team during the planning phase of an audit through digitalization solutions to improve efficiency
- Reviewing accounting records to recover unclaimed property for all Shell subsidiaries
- This project recovered approx
- Half a million dollars in 2022
- Liaising with and supporting functions such as tax, legal, accounting and treasury as required, promoting exchange of best practices and collaboration.
Financial Analyst
Shell Chemical LP
, AL
02.2019 - 08.2020
- Develops automated reporting and forecasting tools for more efficient use of data, particularly during annual business planning
- Report on financial performance and prepare for regular leadership reviews to ensure optimal operational reliability, receiving a Special
- Recognition Award in September 2019
- Work closely with the accounting team throughout the Gulf of Mexico to ensure accurate financial reporting, collaboration, and drive process improvements.
Project Accountant
Coastal Protection and Restoration Authority
Baton Rouge, LA
06.2018 - 01.2019
- Reviewing budgets, including staffing, work plans, and fee structures per coastal master plan
- Providing project managers and clients with timely financial reports and budgets, as well as project forecasts
- Updating contracts according to coastal master plan requirements and reporting associated budget amendments.
SQL Developer
Louisiana State University
Houston, TX
08.2017 - 05.2018
- Analyze existing SQL queries for performance improvements using Microsoft
- SQL Server
- Develop procedures and scripts for data migration.
Intern
Shell Trading
Houston, TX
05.2017 - 08.2017
- Develop SQL queries in QlikView to interface with Endur databases to display exposure changes in commodities market
- Participate in team stakeholder management and continuous improvement efforts by collecting and analyzing data
- This internship was completed successfully and a job offer was extended afterward.
Data Analyst
Louisiana State University
Houston, TX
08.2016 - 05.2017
- Interpret data, analyze results using statistical techniques and provide ongoing reports to assist the Associate Vice Provost for International
- Programs
- Develop and implement databases, data collection systems, data analytics and other strategies that optimize statistical efficiency and quality.
Staff Accountant
General Motors Financial
Erie, PA
12.2015 - 07.2016
- Preparing journal entries, analyses, and account reconciliations and assisting with monthly close processes
- Maintaining documentation for accounts payable, accounts receivable, and assisting in internal audits
- Responding to information requests, reviewing financial statements, and assisting with audits.
Customer Service Representative
Agility Marketing
Erie, PA
09.2015 - 12.2015
- Build sustainable relationships and trust with state entitlement programs customer accounts through open and interactive communication
- Handle customer complaints, provide appropriate solutions and alternatives within the time limits; follow up to ensure resolution
- Follow communication and database management procedures, guidelines and policies.
Education
Bachelor of Arts - Accounting and Management
Mercyhurst University
08.2011 - 05.2015
Master - Accountancy; Forensic Services
Louisiana State University
08.2016 - 05.2018
Skills
Quantitative data
Cash Flow Analysis, Accounting Systems and Controls
MyComplianceManager, Advisor, Power BI DAXMicrosoft Office Suite: Word, Excel, Visual Basics, Access, PowerPoint, Outlook, Visio, and Project
Statistical Package for the Social Sciences (SPSS), Tableau
Statistical Analysis System (SAS), QlikView, SAP, Workday, Track, MySQL Management System
Microsoft SQL Server
Risk mitigation strategies
Advanced problem solving
Project planning and development
Data extracting
Budget Analysis
Trend analysis expertise
Certification
CPA - Certified Public Accountant
Timeline
CPA - Certified Public Accountant
12-2022
JV Audit Analyst
Shell Exploration & Production Company
08.2020 - Current
Financial Analyst
Shell Chemical LP
02.2019 - 08.2020
Project Accountant
Coastal Protection and Restoration Authority
06.2018 - 01.2019
SQL Developer
Louisiana State University
08.2017 - 05.2018
Intern
Shell Trading
05.2017 - 08.2017
Data Analyst
Louisiana State University
08.2016 - 05.2017
Master - Accountancy; Forensic Services
Louisiana State University
08.2016 - 05.2018
Staff Accountant
General Motors Financial
12.2015 - 07.2016
Customer Service Representative
Agility Marketing
09.2015 - 12.2015
Bachelor of Arts - Accounting and Management
Mercyhurst University
08.2011 - 05.2015