Ivan Gamo Email and Phone Number

• SFE Associate (Pharma Industry)• Managed and built KPI Dashboards for local and multinational companies such as GlaxoSmithKline, Bayer Consumer Health, Absolute, Abbott Trade, Fonterra, Mundipharma, SANOFI and Conjug8.o Data Discovery and Formation. Understanding the business issue/so Designed Performance Tracker / Templates for Data Collectiono Generate Daily, Monthly & YTD Reports for The Operations & Clients• Collaborate with cross-functional team to understand client business, gather requirements and needs.• Data Modeling (create relational database) using Power Query, M Language, Excel Data Model)• Data Preparation and Processing. Identify and gather required information from multiple sources, cleansing (perform data wrangling)• Used Excel, Power BI, Power Query, DAX to build Field Force KPI Dashboard to track individual and group performance (determining the best method to represent insights based on analysis). • Led a team of 2 for Sales Performance Dashboard project.• Devised a method of ETL to streamline data flow and reduce cost. Used SQL and Python.• Coached new and less experienced analyst. • Worked with management to prioritize business and information needs.

• Main responsibility includes gathering and cleaning data using Excel. Collaborate with other DA in analyzing the data, creating reports/dashboards, and determining the best way to represent it visually to managers and stakeholders.• Designed Performance Tracker / Templates for Data Collection• Generate Daily, Monthly & YTD Reports for The Operations & Clients• Build web-based applications such as inventory and online learning/exam using PHP programming language and phpMyAdmin as database. • Used Visual Basic 8 and MS Access for Attendance Monitoring System Project