Mariano Chimenton

Result-driven Business Intelligence architect and Data Analyst consultant with more than 16 years of experience specializing within BI solutions architecture and boasting a wealth of multi-sector exposure, like banking and finance, and mining, among others. Particular expertise in financial reporting and being able to work alongside all levels of stakeholders to ensure they are confident and engaged with the data and systems they are using. Strong interpersonal skills, understanding the importance of communicating across the business to ensure end-to-end improvement.

Certified Microsoft Power BI specialist who is adept at design, analysis, development, support, maintenance, implementation of multidimensional models to direct the transformation of operations, processes, and systems.

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