Data Analyst Business Intelligence

KRISTEL JANE M. ESTAVILLO

** **. ******** **., **** 2, Central Signal Village, Taguig City, PH

Contact No. +639*********

Email:***********@*****.***

PROFESSIONAL EXPERIENCE

Skilled data analyst with over 10 years of experience in business intelligence and data analysis. Experienced in data management, data visualization, and data analysis. Knowledgeable in various business intelligence software and statistical tools such as Microsoft Excel, Tableau, SAS, R, Python, and SQL Server studio.

WORK EXPERIENCE

Growth Assistant (Part – Time)

Sr. AdOps and Analytics Manager May 2022 – April 2023

Working closely with the CEO to provide demonstrating current and cumulative performance for each ad campaigns.

Proficient in the use of various ad serving tools and applications (e.g. Facebooks Ads Manager, Tiktok, Google Ads Manager, Campaign 360)

Set up and ran different ad campaigns in Facebook and TikTok Ads Manager

Created and maintained dashboards and kpi reports on a weekly and monthly basis to track and analyze performance of various campaigns.

Performed ad hoc analysis as requested by the client.

Primary Tools: Google Data Studio/ Looker Studio, Google Analytics, Google Sheet, Google Tag Manager, MS Excel, Salesforce

SM Digital Partners, Florida, US (Part – Time)

Data/Tableau Analyst June 2021 – Jan 2022

Analyzed and generated weekly/monthly data and reports for individual clients, demonstrating current and cumulative performance for each ad campaigns

Created reports, visualizations and analytical tools in support of various enterprise-wide projects using Tableau and Microsoft Excel

Tested and validated underlying report data

TLIC Worldwide, Rhode Island, US (Part - Time)

Data Enrichment Specialist October 2020 – May 2021

Built profiles of our target customers and add/update them in Hubspot

Enriched our sales database in Hubspot

CRM Management, such as updating missing contact information and updating lead status for existing contacts

Optum Global Solutions, Taguig City, PH

Data Analyst September 2016 – Present

Designs and develops business intelligence dashboards and multi-functional reports using Tableau, useful in driving key business decisions, informing strategic format and guiding the operations team.

Completed various Customer Experience Analysis through Sentiment or Text Analysis (using R) which helped improve Customer Satisfaction, and identify growth opportunities

Performed Net Promoter Score Analysis- Designed NPS Framework and implement Analytics at multiple touch points to derive higher NPS and Customer Satisfaction

Developed and managed key metrics dashboards and scorecards for the Inpatient Care Management Team

Primary Tools: Tableau, R, Python, SQL Server Management Studio, MS Excel, SAS Base

Intercontinental Hotels Group, Makati City, PH

Reporting Specialist April 2014 - September 2016

Reporting Analyst May 2012 – April 2014

Supported Central Reservations Office (CRO) infrastructure and platforms by providing appropriate, timely and accurate reports to the internal stakeholders.

Maintained and developed a monthly forecasting report of revenue per region, designed with statistical models using the SAS programming language.

Stand as expert of Voice Analytics team where different operational analysis or Contact Center Analysis were completed

Completed automation of various operational reports through the use of SAS and VBA; successfully designed and implemented reporting processes for regular data collection.

Performed different ad-hoc analysis based on the needs of multiple stakeholders across the company

Analyzed massive and complex SAS data set; identified and researched data issues

Primary Tools: SAS Enterprise Guide, MS Excel, MS Access, Web Business Intelligence

SKILLS

Good Analytical and quantitative skills, with the ability to work with large data while maintaining a high attention to detail

Extensive experience in working with SAS Enterprise Guide, SAS/BASE, SAS/MACROS and SAS/SQL

Experienced in utilizing SAS procedures, Macros, and other SAS applications for data extraction, data loading, and reporting.

Advanced Data Visualization and Data Story Telling using Tableau and SAS Visual Analytics

Knowledgeable in RStudio programming

Extensive knowledge in Microsoft Excel, Access, and Visual Basic

Strong skills in Data Analysis.

EDUCATION

Bachelor of Science in Statistics

University of the Philippines June 2008 –April 2012

Diliman, Quezon City

Electives taken: Statistics in Market Research, Operations Research, Theory of Interest

AFFILIATIONS

University of the Philippines School of Statistics Student Council

Councilor for Publicity A.Y.: 2010-2011

Advertising Seminar, Project Head

University of the Philippines Statistical Society

Board of Directors, Secretary (2011-2012)

Contact this candidate