FINANCE ANALYST: Finance Solutions Team - Automation + Reporting + Modelling
IRESS is a technology company providing financial software and financial market data solutions to the financial services industry.
• Bud...
IRESS is a technology company providing financial software and financial market data solutions to the financial services industry.
• Budgeting/Forecasting: integration of external data from Netsuite, Workday or spreadsheets into Adaptive Insights
• SQL/VBA automation of accounting processes and analytic reports using external files generated by Workday and Preeceda: Australian Payroll Salary Journal, Quarterly Wage Analysis report
• Portfolio of Internal Finance Process Improvement projects: implementation of a Google Data Studio Dashboard to give a holistic view of the status of the projects to top management
MySQL
Excel
Excel VBA
View more
MySQL
Excel
Excel VBA
Google Data Studio
View more
FINANCE ANALYST: Excel/VBA Automation + Financial Reporting + Process Improvements
Ford Motor Company
2018-05-01-2019-08-01
As a Finance Analyst working in Product Development Finance for the Ford Ranger & Everest global product lines, my primary role is design...
As a Finance Analyst working in Product Development Finance for the Ford Ranger & Everest global product lines, my primary role is designing and maintaining the data collection and reporting systems required for the finance change management process. Essentially, this role involves tracking large amounts of financial data in a robust and error proof fashion and then consolidating it into readable and usable financial reports that call attention to major issues for visibility. This provides upper management with insight into the financial status of the vehicle development program and enables them to make strategic decisions for the business.
KEY RESPONSIBILITIES
• Improving Finance Processes and Reporting via Excel/Outlook VBA Automation
• Controlling data integrity and completeness of data inputs used in the processes
• Monitoring costs of ~20k vehicle’s parts: variance analysis by model, region and category.
• Developing Excel tools and performing ad-hoc financial analysis (cost/revenues analysis) on request
• Automating the generation of financial reports that consolidate data from ~ 1800 Excel files into meaningful financial reports (Material Costs, Investments and Finance BOM) for Management Reporting
KEY ACHIEVEMENTS
• Built from scratch a user-friendly EXCEL VBA tool generating automatically EXCEL reports in 3 clicks
• Reduced a financial report generation process from ~2 days to ~20 minutes via proper VBA automation
• Designed and implemented the email automation process required for data completeness checks
• Designed and implemented the automation process selecting, highlighting and gathering the most important project's cost variances per category and region into the financial reports
• Created, maintained and run the systems that use the historical data in the database to produce financial reports that slice the data by reporting function, change type, vehicle control models and average region cost impacts
MySQL
Excel
Microsoft Access
View more
MySQL
Excel
Microsoft Access
Excel VBA
View more
ASSET MANAGER: Financial Excel/VBA Modelling + Project Management + Legal due diligence
PSA GROUP
2014-11-01-2017-11-01
Providing Real-Estate Asset Management services for Peugeot holding and its subsidiaries, establishing project schedules & budgets, makin...
Providing Real-Estate Asset Management services for Peugeot holding and its subsidiaries, establishing project schedules & budgets, making real-estate related deals, interacting with notaries, lawyers and accounting/finance/legal/tax departments’ teams, designing a tool to track projects in portfolio and financial metrics.
KEY RESPONSIBILITIES
• Identifying and managing legal, financial and operational risks
• Writing real-estate contracts, tender processes and other legal documents
• Designing and updating a tool with EXCEL/VBA to track projects in portfolio
• Establishing financial forecasts, budgets, and other real-estate project planning
• Modelling and presenting business plans to create value and enhance financial metrics
• Planning, organizing, and coordinating different stakeholders for the real-estate projects
KEY ACHIEVEMENTS
• Contributed to 29 projects among which 9 asset disposals, 12 leases projects and 8 miscellaneous projects (20 projects completed)
• Set up the organization of a 200 M€ corporate project: breaking down into sub-projects such as leases projects, set-up of the tender process for the on-sale property, preliminary legal transactions, creating and following ad-hoc working groups
• Modelled exit scenarios for underperforming retail business subjected to non-breakable lease-contracts
• Established strategies for asset disposals: DCF analysis and accounting impacts depending on different hypotheses of sales agreements terms
• Built Excel VBA tools to manage projects in the portfolio with financial KPIs:
- Automation of reporting dashboards, data management of the projects
- Allocation of tasks to appropriate teams, consolidation by team and planning, following-up actions
- Sorting projects by criteria such as project's NPV/EAA, Cash-Flows and Income statements forecasts
- Tool allowing efficient monitoring of projects in portfolio with the ability to get into the details, while also keeping visualizations of the big picture
Excel
Excel VBA
Microsoft Word
View more
Excel
Excel VBA
Microsoft Word
View more