MAURICIO CAMELO CARDENAS

Manager Business Intelligence Solutions

+573*********

aduo0m@r.postjobfree.com

Bogotá, Colombia

Analytical and problem-solving skills in cross-functional environments. Strong communication skills, with a high level of comfort transmitting information assertively to a varied audience. Highly creative, with an innovation and automation-oriented mindset. Focused on finding agile, efficient, and effective solutions. Data Visualization (DataViz), experience designing dashboards, scorecards and visualizations that allow to enhance the business impact of decisions based on large volumes of data. Self-taught, currently learning about python and R languages. Among my technical skills are strong knowledge in POWER BI use, Power Apps, Power Automate, the management of databases, analysis of large data sets, management of software oriented to business intelligence (SSIS, SSAS), SAS Guide and Miner, ETL processes, advanced Excel, VBA. Available to work in another city or country.

EXPERIENCE

Scotiabank Manager Business Intelligence Solutions April 2022 – Currently

• Lead reports and low-code applications solutions teams, providing guidance on best practices for development, training, and soft skills development.

• Lead the design, develop, test, deploy, maintain, and improve current reports, dashboards, KPI scorecards, and low- code applications using MS Power Platform suite.

• Identify opportunities to complement data presented in reports with low-code applications and/or automation tools and develop solutions using Power Platform

• Responsible for creating Business Intelligence Applications, reports, and insights to continuously improve the control posture within Global Collections, focusing on visualizations to “story-tell” but supplement with the underlying actionable details.

• Preparation of local teams from LATAM, Central America, Caribbean, and Canada in data viz, storytelling, reporting data modeling, low code applications, and other related topics. Scotiabank Manager BI, Analytics & Reporting

August 2021 – March 2022

• Provide added value to the global team and local operations by supporting and leading reporting and data driven projects focused on optimizing and improving Business Intelligence (BI) capabilities for Collections.

• Provide and present insights from existing data and / or new analytical models that add value to the business. Collaborate with local counterparts and the Division in the regions of Canada, LATAM, Central America and the Caribbean to launch initiatives and boost their benefits.

• Responsible for leading the creation of reports and insights to continuously improve the control posture within global collections, focusing on visualizations.

• Preparation of local teams from LATAM, Central America, Caribbean, and Canada in data viz, storytelling, reporting data modeling and other related topics.

Scotiabank Senior Analyst, Data & Reporting

December 2020 – Julio 2021

• Accountable for supporting data development, coding, analysis, design and implementation activities.

• Lead the reporting design in all division (Colombia, Mexico, Chile, Caribbean Countries), create methodology, branding, and training program for local teams.

• Understand current ETL processes, data models, production jobs and documentation.

• Design, develop, test, deploy, maintain, and improve current data models for different countries.

• Develop visual reports, dashboards and KPI scorecards.

• Work/hands-on experience in building complex SQL queries.

• Analyze, design, develop dashboards, views, data models, DAX measures, documentation for reporting and analytics in Power BI and/or any established tool.

Scotiabank Colpatria Professional, MIS & Analytics August 2016 - December 2020

• Development of the data warehouse for BI & MIS collections as the main input for divisional reporting oriented to making strategic decisions based on data analysis, indicators, and metrics.

• Automate all assigned reports in SAS, doing all end-to-end data process integrating multiple data sources, generating the code to process data, and connecting SAS library to Excel to present the dashboards and reports.

• Information analysis of the local / divisional collection financial ecosystem, at all levels.

• Development of KPI's, dashboards and scorecards for the business using applications such as Excel, Power BI, Power Pivot, multidimensional cubes in SQL Server Analysis Services.

• Responsible for the automation of processes through ETL developments based on SQL Server Integration Services

(SSIS), SAS Guide enterprise, SQL Server Management Studio.

• Responsible for monitoring automatic processes, updates, and changes in the different environments productive according to business needs.

EDUCATION

PL-200: Microsoft Power Platform Functional Consultant PL-100: Microsoft Power Platform App Maker Intelligent Training Intelligent Training

Bogotá, Colombia Bogotá, Colombia

2022 2021

Business intelligence with Power BI and Excel Telecommunications Engineer Universidad EAFIT Universidad Nacional Abierta y a Distancia Bogotá, Colombia Bogotá, Colombia

2020 2020

Foundation Tools: SAS Programming 1: Essentials Mechatronic Systems Design Technologist SAS Education Servicio Nacional de Aprendizaje - SENA Bogotá, Colombia Bogotá, Colombia

2019 2009

LANGUAGE SKILLS

English B2

Spanish Native

Contact this candidate