Gustavo Bejar

PROFESSIONAL EXPERIENCE

CVS HEALTH (Aquent)                                                                                     02/2023 –  Present

Senior DATA Analyst    

Identify, analyze, and interpret trends or patterns in complex data sets. Filter and “clean” data by reviewing excel reports, and performance indicators to locate and correct problems. Work with management to prioritize business and information needed, responsible for developing new Power BI Dashboards, for Planning and margin Management and cost variances, analyzing growth performance compared with previous periods, preparing, and maintaining quality data analytics that will be utilized across various business units and promote new opportunities for the organization, thus enhancing efficiency and resulting in optimal revenue. 

Use SQL Studio, Teradata, Power BI to procure data mining.        

QUINNOX GLOBAL IT-COCA-COLA COMPANY                                                       04/2022 – 12/2022

Project Leader (Power BI Coca-Cola LATAM)

1. Work with the Coca Cola Team from different countries in LATAM to Create, condense, automate, and optimize current and new reports, build dashboards, and visualization processes to help support the team on both a scheduled and ad hoc basis by leveraging BI Tools, Excel, and other analytics tools using different Statistical cubes from Nielsen to produce regional sales and financial reports in POWER BI.

• Manage and Lead a team of 5 Power BI Developers offshore.
• Introduce and implement 12 new detail dashboards in Power BI using DAX and Power Query for Brazil, Mexico, Colombia, and a Global Report. Monitor daily ETL procedures of all data warehouse sources.
• Design, Develop and Customize Financial and Operational Analytics
• Maintain organized libraries of all coding necessary to maintain data.
• Keep a record of all transactions and developments from project using Agile Jira. 

ROSS UNIVERSITY SCHOOL OF MEDICINE                                                           01/2018 – 04/2022

Senior Data Analyst

1. Perform Data Analysis and data modeling to produce accurate Operational and Student performance reports as well as Hospital performance and timeline achievement, considering all the student steps until graduation.

• Create special Dashboards using Power BI and Paginated Reports
• Complete the migration of 80 reports from COGNOS 10.2 to Power BI.
• Determine the analogous components in Power BI
• Determine the Reports Structures in COGNOS, Make an Inventory of existing process, Report Items, data sources and filters. 
• Setup a business matrix based on the Cognos reports to obtain the facts and dimensions used.
• Using a Query Editor in Power BI to perform certain operations like fetching data from different files.
• Recreate the reports in Power BI using the existing Cognos report layout as a template.
• Revise Model definition, check calculations and output columns, unwind and document the data model, then select the reports to inspect, view data structure, and source, determine layout, filters and revise the Queries, expressions, and relationships to recreate in Power BI.
• Validate the migrated reports to ensure they meet your requirements and display the desired data insights.
• Create users and gateways to update the New Power Bi Report data. 

Politecnico Gran ColombianoPolitecnico Gran Colombiano

Bachelor of Business Administration (B.A.), Finance and Financial Management Services

1987 - 1993
According to the evaluation issued by James W Foley, PhD, Associate dean from the School of Business Administration of the University of Miami about the academic records earned are equivalent to 165 semester credit hours, consequently the education and work experience exceed the credit hours requirement for the U.S degree Bachelor of Business Administration with a Major in international finance and marketing without include the last 14 years of working experience earned.