John Steven Tapican
Senior Data Analyst & Engineer at Magic, Inc- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Credentials
-
Crash Course in Modern Data Warehousing Using Snowflake Platform
Data Science DojoApr, 2022- Nov, 2024 -
Web Scaping with Python and BeautifulSoup
Data Science DojoMar, 2022- Nov, 2024
Experience
-
Magic
-
United States
-
Outsourcing and Offshoring Consulting
-
500 - 600 Employee
-
Senior Data Analyst & Engineer
-
Dec 2021 - Present
> Built SQL queries for data transformation and analysis for our ETL pipeline (Fivetran -> dbt -> BigQuery -> Google Data Studio). > Clean, transform and load raw data into a uniformed format from different sources (Stripe, Hubspot, Airtable etc.) to Google Cloud data warehouse using dbt, SQL, Python and Zapier. > Created fun and dynamic weekly KPI dashboards in Google Data Studio. > Created dashboards using Google Data Studio/Looker for Cohort Analysis and hypothesis testing of each department's initiative to improve User Retention and Monthly Recurring Revenue (MRR) to company founders. > Utilized machine learning for churn prediction. Show less
-
-
-
Nature LLC
-
United States
-
Senior Business Intelligence Developer
-
Sep 2020 - Present
> Developed Power BI and Google Data Studio dashboards for one-off analyses and weekly KPIs like customer retention, ticket resolution, return of ad spend (ROAS), SEO keyword performance and ranking, agent performance (Average Answer Speed, Response Rate, Service Level, CSAT, Quality Scores etc.), Amazon Sales per Reviews, Stripe chargebacks and daily orders count and sales. > Converted data into insights including implications and recommendations that are specific and actionable for the operations team and across the business. > API Data querying from a website using Excel Power Query. > Web Scraping of product details in Amazon using UiPath and Python. > Worked with marketing department to optimize campaigns using A/B Testing and Statistics. > Responding to Stripe disputes and Chargeback prevention. > Reports and data ETL worflow automation using Excel VBA and UiPath > Utilized advanced Excel Functions (SUMIF, COUNTIF, SUMPRODUCT, VLOOKUP, INDEX, MATCH, etc.) and VBA macros. Show less
-
-
-
Alorica
-
United States
-
Outsourcing/Offshoring
-
700 & Above Employee
-
Workforce Analyst
-
Mar 2020 - Sep 2020
Responsible for senior level monitoring of real-time call volume and employee adherence and service level goals. Key Job Responsibilities > Prepared daily, weekly, monthly and ad hoc reports for clients and senior management. > Analyzed information databases, historical data, and real-time information to create recommendations to improve daily objectives within the production team. > Forecasted the call volume and staffing schedule. > Monitored inbound service level goals, calls in queue, excessive talk time, agents in an extended aux status, break and lunch schedules, early departures due to sickness or family emergency and tardiness to ensure proper staffing levels and adherence. > Helped document system or telephone problems identified by team members; provided follow-up to ensure problem is resolved. > Assisted in skilling and hourly data to Global Command Center to ensure employees are assigned correctly to the right queue or line of business. Show less
-
-
-
Expert Global Solutions (now Alorica)
-
Outsourcing and Offshoring Consulting
-
700 & Above Employee
-
Reporting Analyst
-
Jan 2014 - Mar 2020
Responsible for developing reporting from data acquisition through report development and delivery. Key Job Responsibilities > Provides daily, weekly and monthly reports to appropriate team managers and senior leaders. > Integrates data generated locally and from other clients to create reports based on the needs of the business. > Collects, assembles, and analyzes data for operating trends & issues using Excel spreadsheets and SQL databases. > Provides immediate feedback or updates to the management team as to the account's performance. > Audits reports and uses available resources to confirm accuracy. > Identifies and resolves reporting issues proactively but immediately informs the direct supervisor for any hot issues. > Coordinates with workforce management (WFM) regarding data sources and other related reports. > Coordinates with the management to understand their reporting needs and apply best practices in report development and automation. > Frequent client engagement at all levels to understand needs and translate client requirements into reporting deliverables. Deliver adhoc reports as needed. Show less
-
-
-
Cropital
-
Philippines
-
Farming
-
1 - 100 Employee
-
Community Manager
-
Jan 2013 - Dec 2014
Created an impact in the lives of millions of farmers. Philippine's First Crowdfunding Startup for farmers. Key Job Responsibilities > Conducted orientation and meetings with farmers > Provided training, capacity building and basic financial education for farmers > Managed farm communities, farmer organizations, government offices and partner institutions > Generated farm reports about cropping status and profit-loss. > Coordination with institutional partners > Worked with Philippine Crop Insurance Corporation for insurance protection to farmers against losses arising from natural calamities, plant diseases and pest infestations of their palay and corn crops as well as other crops. Show less
-
-
-
Government Arsenal, Department of National Defense
-
Limay, Central Luzon, Philippines
-
Research Assistant Internship
-
Apr 2012 - Jun 2012
Research Intern for Bullet Casing Failure Analysis for Philippine National Police and Army Research Intern for Bullet Casing Failure Analysis for Philippine National Police and Army
-
-
Education
-
2008 - 2013
University of the Philippines Diliman
Bachelor of Science - BS, Materials Engineering -
2017 - 2017
Zuitt - Coding Bootcamp
Fullstack Website Development -
University of Baguio
High School Diploma -
Immaculate Conception Parochial School
Community
