Hugo Ernesto Roldán Ruiz Power BI developer | Data Analytics

T

Data Specialist

Tycom de México

Aug 2024 - Jan 2025 (6 months)

•Implementation of Business Intelligence solutions through Power BI, optimizing ETL processes with Power Query and star data modeling, achieving a significant reduction in processing times and improving operational efficiency. •Generation of advanced metrics using DAX, creation of dynamic tooltips, interactive buttons, and design of visually compelling reports with Figma, facilitating data interpretation for strategic decision-making. •Development of low-code applications with Power Apps, including CRUD forms for efficient data management and internal processes. •Exploratory Data Analysis (EDA) with Python, applying data cleansing, transformation, and visualization techniques to identify key patterns and trends that drive continuous impr

BI Developer

Inetum

Sep 2023 - Mar 2024 (7 months)

I developed an analytical data model (star model) in Microsoft Fabric with PySpark and Delta tables, consumed in Power BI. • I generated an ETL in Microsoft Fabric (Data Factory) and another in Dataiku for multi-source integration. • I developed Power BI reports with storytelling and intuitive navigation. • I prototyped in Figma, interactive features: drill-through, dynamic tooltips. • I automated data flows to SharePoint using Power Automate.

D

Financial Analyst

Don Ribs Grill Mx

Dec 2017 - Jan 2023 (5 years 2 months)

• Utilized Power BI to generate reports and analyze operational data, enhancing decision-making and restaurant efficiency. • Increased sales and productivity by analyzing competition and customer feedback from various delivery platforms using Power BI. • Optimized operational expenses through effective incentive plans and improved customer service, supported by detailed Power BI analysis.

F

Business Intelligence & CRM Analyst

Farmacéuticos Maypo

Jan 2016

Reporting to: Business Intelligence Management With 3 direct reports to Business Intelligence Manager, Sales Force Manager and 12 Medical Representatives. Responsible for the automation of reports for the company's Business Intelligence platform. Preparation of sales report for Medical Representatives. Main achievements: -Proposal and automation of KPI's for sales force Competencies developed in the position: Ability to analyze and understand commercial and CRM data, Experience in the use of Business Intelligence and CRM tools, Ability in the elaboration of sales reports and reports and KPI's.

B

Sales Analyst (outsourced by Technicon)

Bayer de Mexico

Jan 2016

Reporting to: Business Intelligence Manager, Sales Manager and 84 Medical Representatives With 2 Direct Reports: Commercial Intelligence Management, Sales Force Management, Indirect: Sales Force Management of 20 product lines. Responsible for: for the collection, cleaning, transformation and generation of incentive reports and commission qualification through KPI's of quota coverage, market share, annual growth, with information from IMS Health DDD audits and internal information. Main achievements: -1% monthly sales increase in 2 product lines by market and competitor analysis through data mining. Skills developed in the position: Ability to collect and transform large amounts of data into information, Advanced knowledge of data analysis

Business Intelligence Specialist

Montepío Luz Saviñón

Jan 2016 - Jan 2018 (2 years 1 month)

Responsible for the administration of the balanced scorecard of the institution. Generation of various Ad-hoc analyzes on amortization tables, customer segmentation, gold price, preparation of executive presentations with results and insights obtained for General Management. • Discovery of possible deviation valued at just over 1 million pesos, associated with the effort of jewelry of uncertain origin, concentrated in less than 10 clients due to deficiencies in the customer service procedure, through analysis in the database. •8% of additional annual income in 2017 due to optimization of the interest rate for the project “Te prestamos para comprar tu auto propio” from UBER. •5% increase in income withholding from jewelry placement,

Business Intelligence Senior Analyst

Farmacias de Similares

Jan 2012 - Jan 2015 (3 years 1 month)

Responsible for: Generation of daily sales reports, medicines and consultations given from 5 thousand pharmacies, proposal and generation of metrics or KPIs to measure the performance of sales and medical consultations, data analysis and generation of financial and operational statistical models of units new to open, relocations, forecast model for 110 products for Laboratorios Best. •Developed data analysis that reduced by 12% ($500,000 per year in 2014) the expenses of the Management through the optimization of sales product combos with higher vs lower profitability by type of morbidity. •I generated analyzes with data mining that reduced operating expenses by 8% between 2013 and 2014, addressing bad labor practices in the Point of S

Economics and Finance Management Analyst

CMiC

Jan 2007 - Jan 2012 (5 years 1 month)

Reporting to: Economics and Financing Management With 10 direct reports: Economics and Financing Management. Indirect reports: Technical Management. Responsible for: gathering and analyzing economic data of the construction industry for executive presentations for press conferences, interviews or meetings with governors, government bodies and media by CMIC representatives. Responsible for the administration and updating of the CMIC website "Economic Statistics" with information from INEGI, BANXICO, Ministry of Economy, Mexican Stock Exchange, World Bank, OECD, IMF, among others. Main achievements: I collaborated in the elaboration of outstanding publications at a national level that generated an 8% of additional annual income: -Survey of

Hugo Ernesto Roldán Ruiz

About

Detail

Timeline

Résumé