Juan Carlo Mejía Chang
Data Analysis
Data Modeling
ETL Engineering
Business Intelligence & Reporting
Strategic Data Insights
About Me
Data analytics specialist & creative problem solver.
I am Senior Data Analyst, ETL Engineer, Business Intelligence & Reporting Specialist @ Dubai Holding Real State.
With over 25 years of experience across multiple industries, I have spent recent years focusing on data analysis, data engineering, and business intelligence. I specialise in designing and managing data solutions that support strategic decision-making. My expertise includes data modelling, ETL processes, and interactive reporting, all aimed at optimizing operations and enhance efficiency across the organization and its teams.
I have demonstrable expertise in integrating multiple data sources to generate meaningful insights, excelling in identifying areas of process improvement, streamlining workflows, and implementing automation to boost data accuracy, and optimise performance. With a proven track record of fostering team collaboration, I effectively communicate with stakeholders to ensure the achievement of goals, KPIs, and benchmarks.
Personal Details
- Date of Birth:
2024-02-20 - Country of Origin:
Panamá. - Residence:
Dubai, UAE - Address:
Jebel Ali, Veneto, Villa 1. - E.Mail:
juancarlo@mejiachang.com
- Phone:
+971 50 869 0853 - Employment Status:
Employed, but open to opportunities. - Freelance:
Available
My Core Competencies
Business Intelligence & Reporting.
Power BI, Knowage, Report Design, Data Visualisation, Reports Development, Data Modelling.
Data Engineering & Analysis.
Python, Pandas, Spark, Notebooks, Power Query, DAX, Advanced Excel (VBA).
Cloud & Distributed Computing.
Microsoft Fabric, Cloud Data Services, Distributed Data Workflows, Dataflows, Pipelines, Lakehouses & Warehouses.
Apps Development.
Angular, Django, RESTful API, HTML5, CSS3, Tailwind, TypeScript, Desktop Applications with Electron.
Databases.
PostgreSQL, MySQL, SQLite, Database Design, Data Modelling, Data Integration.
Process Improvement.
Gap Analysis, Requirements Gathering, Risk Management, Automation, KPIs.
Worked with
Résumé
Over 25 Years of Experience
Work Experience
June 2024 – Present.
Manager – Analysis and Processes
Contract & Procurement – Dubai Holding Real Estate [DHRE] - Dubai, UAE.
Reporting to: Chief Contract and Procurement Officer.
Develop and maintain data analysis tools and reporting capabilities for the DHRE Contracts & Procurement Team, primarily using Power BI, Advanced Excel (including VBA), SQLite, and Python to perform ETL processes, transform, clean, and aggregate data for analysis.
August 2021 – June 2024.
Manager – Analysis and Processes
Procurement and Contracts - Nakheel - Dubai, UAE.
Reporting to: Chief Procurement & Contracts Officer.
Developed and maintained data analysis tools and reporting capabilities for the Nakheel Procurement and Contracts Team, primarily using Power BI, Advanced Excel (including VBA), and Python to perform ETL processes, transform, clean, and aggregate data for analysis.
September 2020 - August 2021
Freelancer
Freelancer - Dubai, UAE / Islamabad, Pakistan.
Reporting to: Chief Operating Officer.
Freelancer doing projects for Hashoo Group, specifically developing a Technical Curriculum for two introductory courses: Introduction to AI and Introduction to Blockchain. Part of the project was at the Construction Technology And Training Institute [CTTI] in Islamabad, Pakistan.
July 2018 – September 2020.
Chief Project Manager
DUTECH / Customs World - Dubai, UAE.
Reporting to: Chief Executive Officer
Governed and oversaw technology teams, consolidating work plans, schedules, phases, and budgets (AED 100M+/-) into a master program plan. Delivered executive-level reports, dashboards, and insights as a key member of the Executive Advisory Team.
August 2012 – July 2018.
Senior Project Manager
CrimsonLogic Chile SpA. - Santiago, Chile.
Reporting to: VP of Regional HQ LATAM & Caribbean.
Performed Project Management and Agile Transformation for the implementation of Chile’s Single Electronic Windows for International Commerce and performed IT Infrastructure Project Manager duties for the Bahamas Single Electronic Window System and the Chile - Peru Interoperability Platform (IOP).
Created and implemented Business Intelligence and Analytics solutions related to trade and commerce for the President of Chile’s Digital Transformation Committee.
April 2009 – August 2012.
Senior Technical Presales Engineer
CrimsonLogic PTE LTD. - Singapore, Singapore
Reporting to: VP of Technical Sales and Solutions Engineering.
Developed and delivered competitive, feasible IT solutions for government agencies in Singapore and globally, incorporating data analytics, reporting, and insights to optimize decision-making while successfully securing bids in Singapore, Chile, Bahamas, Trinidad & Tobago, Suriname, and Saudi Arabia, leading to awarded contracts valued at over USD 300M.
June 2005 - April 2009.
Senior Security Consultant
Radiantrust PTE LTD - Singapore, Singapore.
Reporting to: General Manager of Radiantrust.
Administering and operating all the security infrastructure from the parent company (Crimsonlogic PTE LTD) as well as enforcing the ISMS policies and processes of the Corporation.
April 2004 – June 2005
Senior IT Engineer / Consultant.
Crimsonlogic PTE LTD - Panama City, Panama.
Reporting to: Senior Project Manager - Post Sales.
As an IT consultant supporting the Electronic Data Collection System (EDCS) implementation for the Panamá Canal Authority, a multi-million dollars’ project for the Panamá Canal logistics and operations.
October 2001 - April 2004
IT Coordinator.
Secretaria Nacional de Ciencia y Tecnología - Panama City, Panama.
Reporting to: Director of Internet Services.
As IT Engineer in charge of installation, maintenance and operation of the agency network and server’s infrastructure for the Panamá Government Science and Technology Secretariat.
January 1998 - October 2001
Internet Services Engineer.
Charter Communications / Pointecomm - Panama City, Panama.
Reporting to: Internet Services Manager.
In the Internet Services Team in charge of networks and servers management (operating, maintaining and evolving) and assisting the satellite hub engineers in maintaining the telecommunications and satellite links to ensure service availability.
Business Intelligence & Reporting.
PowerBI
DAX
Knowage
Data Modelling
Data Visualisation
Data Engineering & Analysis
Python for Data Analysis
Pandas
Spark
Power Query
VBA
Cloud & Distributed Computing.
Microsoft Fabric
Lakehouses & Warehouses
Dataflows
Pipelines
Workspace Management
Application Development.
Python
Angular
Django & Django REST framework
Electron
Typescript
Databases.
SQLite
Postgre SQL
MySQL
Data Modelling
Database Design
Languages
Spanish [Native]
English [Fluent]
Courses
2018
Certified Scrum Master.
Buenos Aires, Argentina.
Certification #000805452.
2007
IBM Servers Presales Specialist.
IBM, Singapore, Singapore.
2003
E-Government Implementation Specialist.
KOICA - Seoul, South Korea
2002
Java Development for E-Government.
Tata Infotech - New Delhi, India.
Education
2019
Artificial Intelligence: Implications for Business Strategy.
MIT Sloan School of Management.
1992
Bachelor of Science (B.Sc.)
Intituto Comercial Panamá.
Contact
Get in Touch
My Contact Information
Reach out to discuss freelance projects, or full-time roles within my expertise. Whether your organisation needs data-driven insights, advanced reporting development and design, or data engineering expertise, I’d be happy to explore how we can work together.