Ivan Gamo Email and Phone Number
Data Analyst and related role with more than 5 years of experience in managing complex data related projects for a variety of industries, mostly pharma and FMCG. Skilled in data gathering, scrutinizing, and transforming data using specialist tools such as excel, power query and sql to produce reports and charts communicating trends that helps marketing and operations team make decisions. Responding to data-related queries and keeping track of these. Setting up processes and systems to make working with data more efficient.
Professional Insights Marketing Services
View- Website:
- pimsgoc.com
- Employees:
- 96
-
Senior Data AnalystProfessional Insights Marketing Services Oct 2016 - PresentNational Capital Region, Philippines• 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. -
Junior Data AnalystMarket Insighting & Foresigting Inc. Apr 2013 - Oct 2016Las Piñas, National Capital Region, Philippines• 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
Ivan Gamo Education Details
-
Computer Science
Frequently Asked Questions about Ivan Gamo
What company does Ivan Gamo work for?
Ivan Gamo works for Professional Insights Marketing Services
What is Ivan Gamo's role at the current company?
Ivan Gamo's current role is SQL | Python | MS Excel | PowerQuery | PowerPivot | Data Analysis Expression | PowerBI | Data Analyst | Data Visualization | SFE Sales Force Effectiveness Associate | Database Management.
What schools did Ivan Gamo attend?
Ivan Gamo attended University Of Perpetual Help System Dalta.
Who are Ivan Gamo's colleagues?
Ivan Gamo's colleagues are Aurelia Maglente, Kristine Ruadap, Ma. Victoria Wenceslao, Rpm, Joyce Edaño, Marc Anthoni Genzola, Efrem Dizon, Carla Rivera.
Not the Ivan Gamo you were looking for?
-
-
Nicolai Ivan Gamo
Santa Rosa City -
Free Chrome Extension
Find emails, phones & company data instantly
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial