Mariano Chimenton

BI, EPM and ETL Consultant, Finance Department (May 2017 – Dec 2022)

First Quantum Minerals (External Contractor through Simbiosis BI – UK)
London / Panama / Zambia

• Architect in charge of the Global Reporting Cube solution (Multidimensional Database), the primary source of Power BI reporting.
• Designed and deployed, with Power BI, an efficient Star schema model to store data from multiple applications and sources. Also implemented a parent-child hierarchy pattern to replicate the dimensions’ hierarchies from the sources.
• Developed complex calculated measures using DAX as copper cost per tonne or BCM, QTD and YTD calculations, etc.
• Led the development of a reporting solution suite containing several Power BI Reports, with a strong emphasis on data visualization and data storytelling best practices.
• Implemented Row-level security with Power BI to ensure proper access to data.
• Building and administrating Power BI workspaces, reports, and dashboards. Also involved in deployment pipelines. 
   
• Financial Forecast and Budget Oracle EPM models architect and developer.
• ETL management and development (FDMEE, SQL, Python, Groovy, Power Shell).
• Used Python to analyse formulas dependencies and complex data-cleaning processes from Oracle EPM extracts.
• Developed complex SQL queries using stored procedures and common table expressions.
• Developed MDX queries and formulas from multidimensional and relational data sources.
• Used other reporting tools like Oracle SmartView and Hyperion Financial Reporting.

BI and Oracle EPM Senior Consultant (Sep 2016 – May 2017)
Standard Chartered Bank (Peak EPM’s External Consultant) 

London, UK

• Developed complex SQL queries to get actual data extracted from the ERP system.
• Developed Python process used for data masking to populate non-production environments.
• Developed a PoC to improve the existing on-premises financial reporting solutions to a more consolidated and efficient set of reports and dashboards based on the new cloud solution.
• Developed automatization processes and created data gateways between on-premises and cloud systems.
• Designed the ETL process that would populate the cloud system.
• Developed a Proof of concept for migrating On-Premises multidimensional databases to its Cloud Version (Oracle EPM tools).
• Designed a hybrid approach where Actual data is kept on-premises while Forecast and Budget models are kept on the cloud.

BI, Oracle EPM and ETL Consultant (Sep 2011 – Dec 2015)

Royal Bank of Scotland (RBS) - 

London, UK

• Financial Reporting & Plan Spearheaded the planning and implementation of a Commercial and Private Banking Revenue Trade Model, overseeing analysis, design, and development. Data Visualization.
• System Development Life Cycle: Developed driver-based Cost models (End to end projects): Salary and Benefits (300+ users across different divisions), Travel and Entertainment model, Vendors model, Market Data Terminals model, Bonus Model, and Stress Testing Model.
• ETL process development using SSIS, Esbase Scripts and SQL. 

Data ETL, BI and Oracle EPM Developer (Jul 2010 – Sep 2011)

Deutsche Bank

London, UK

• Oversaw the end-to-end design and development of effective Headcount and Income Statement Planning Applications.
• Created Financial Reports ensuring data visualization best practices.
• Provided key support across; Hyperion Planning, Essbase, Smart View, and Excel Add-in. 
• Querying sources using SQL and Esbase scripting.

Power BI Data Analyst Associate - PL-300 Microsoft official certification.

Global MBA (B+ Score – Top 25%) - IE Business School / IE University, Spain.

Software Engineering degree (BEng). – UTN University, Argentina

Doing Business in China” (Part of MBA Program) – Coursed at Fudan University, Shangai, China