RCBC Bankard Services Corporation

• Performs customer segmentation and data mining to identify a Top 6 Philippine bank's credit card business growth areas, focusing on retail, dining, travel and e-commerce billings of ~750,000 customers

• Used SQL to scope targeted SMS leads from SAS databases for 22 national and regional marketing campaigns, each generating up to HKD 10 million equivalent in revenue with 88% yielded by converted leads

• Developing a Power BI dashboard to automate KPI reporting of ~100k monthly processed card applications across 8 channels

• Provides C-suite and VPs with 5 monthly MIS reports on app user acquisition and loan and card product performance

Data Analyst - Business Intelligence | Marketing Analytics | Power BI

KPMG

• Served as both as Power BI Developer and Business Analyst to automate monthly accounting reconciliation of 15 balance sheet accounts for a leading Philippine consumer and industrial appliance manufacturer

• Liaised daily with internal and external project managers and stakeholders during requirements gathering and dashboard development

• Provided technical support and documentation to client business users and developers to facilitate user acceptance testing (UAT) and deployment of 2 dashboards and various Excel VBA data entry forms

Data Analyst - Power BI | Technology Consulting

Capvision

• Persuaded 70+ global C-level and senior executives monthly to join one of the world’s fastest-growing expert network platforms, ranking 9th among all NYC and HK Research Associates for lead conversion in Q1 2023

• Spearheaded expert recruitment and client communications with Tier 1 and Tier 2 management consulting firms and APAC private equity firms with >5 billion USD AUM

• Collaborated with NYC and Shanghai colleagues to support 30+ monthly investment research projects on various sectors, including banking and financial services, technology, media, telecommunications, retail, consumer goods, healthcare, automotive, and agriculture

Client Research Associate

Research Associate

DFI Retail Group

• Used Python and SQL to analyze a ~3.7-million customer database for HK’s largest retail loyalty rewards program to extract product assortment and customer demographic insights from transaction and smartphone GPS user data

• Achieved 82% accuracy in extracting 17 product attributes from 2,279 SKU images by automating text extraction & translation via Microsoft Power Apps to support customer segmentation initiatives

• Presented proof of concept to data science, analytics, and loyalty leadership team as part of HKU MSc Business Analytics capstone project

Data Analyst (Student Researcher), Yuu Rewards | Marketing Analytics

Analytiks Inc.

• Developed a classifier for influencer-generated TikTok videos based on audiovisual information and engagement data

• Utilized Python for data scraping, analysis, visualization, and modeling of 6,882 trending videos in the Philippines

• Identified influencers with over 96% accuracy using an extreme gradient boosting (XGBoost) algorithm

• Completed training modules on Python, SQL, Power BI, machine learning, exploratory data analysis, data visualization, feature engineering, data extraction, data mining, and data structures

Data Scientist Trainee

Unilever

• Selected as 1 of 39 interns among 2,000+ applicants for the 2020 internship intake

• Developed a market opportunity sizing framework for Unilever Food Solutions (UFS) that validated Q3 and Q4 2020 internal sales forecasts with 92.9% similarity

• Advised the UFS marketing leads on 2 key consumption drivers during the COVID-19 pandemic using market research data

• Created a data repository to enable return on investment analysis across 5 profitability metrics

Finance Business Partner

Nestlé

• Spearheaded the creation of Microsoft Power BI analytics reports for 11 sales roles

• Performed data cleaning and visualisation on 16-year training records of 285 employees

• Proposed a system for data collection and real-time reporting expected to reduce the department’s training needs assessment timeline by 18.5%

Data Visualization Intern - Sales Capability | Power BI

Data Analyst | HKU MSc | Marketing Analytics | Power BI

Data Analyst with 2 years of full-time experience in marketing analytics, Power BI development, and client services at the leading multinational retail, FMCG, consulting, and financial services firms in HK (via IANG visa scheme) and the Philippines. Skilled in Python, SQL, Power BI, Tableau, Microsoft Azure (Databricks, Machine Learning Studio, Data Studio), and Power Apps.

Taplio

Joseph Laurel's Linkedin Analytics

Want to drive more opportunities from LinkedIn?

Taplio

.css-1jgreyo{background-image:linear-gradient(284deg, rgba(39,43,72,1) 0%, rgba(33,47,183,1) 100%);color:transparent;-webkit-background-clip:text;background-clip:text;}Joseph Laurel's Linkedin Analytics

Want to drive more opportunities from LinkedIn?

Joseph Laurel's Linkedin Analytics