Jonathan Astudillo

Jonathan Astudillo

$20/hr
Insights & Data Analytics, Visualization using Excel, SQL & Tableau
Reply rate:
-
Availability:
Hourly ($/hour)
Age:
40 years old
Location:
Angeles City, Pampanga, Philippines
Experience:
13 years
WORK EXPERIENCE Insights Analyst Craveablebrands 05/2019 – Present | WFH QSRH Franchisor that owns three iconic Australian food brands: Red Roster, Oporto and Chicken Treat. Achievements/Tasks • Involved with Go To Market process with the completion of Stage gates / Project campaign lifecycle process with post campaign analysis of marketing campaigns with Insights, risk, and recommendation. Forecasting of future campaigns and computation of ROI. Work with business partners to interpret analysis results with a focus on actionable next steps. • Responsible for writing queries in SQL Platform to extract the required data or build quality database and connect in Tableau to build dashboards which will be delivered to business stakeholders. • Creating and editing visual content including maps, charts, and graphs. Transforming data sets, quantitative and qualitative analysis into compelling visuals. Providing visual, technical, and editorial guidance using tableau. • Using specialist tools such as GCP/ Google BigQuery and Tableau to present data in visual forms such as dashboards and automated reports. High Volume Data Reporting environment (Retail) using CUBE OLAP/SQL/QLIKVIEW/TABLEAU set analysis. • Selection of test and control stores to track and analyze product and customer data at very granular levels. Workforce Supervisor Arvato Bertelsmann 11/2015 –08/2018 | Clark, Pampanga Internationally active service group that develops and implements customized solutions for various business processes for customers in diverse industries. Achievements/Tasks • Analyze past volumes and staffing patterns and implementation based on the forecast provided by the client to ensure service goals are met. • Create High Level Reporting for the Leadership Team. • Analyze revenue leakages and how to improve or optimize revenue gain. • Create Estimates, Final Invoicing, Seat utilization and Financial / Budget Forecasting. • Work closely with each business area and the Global Business Intelligence Team to automate and improve reporting processes within the business. • Responsible for day-to-today reporting of team output, productivity, BTP and billable utilization. • Headcount overview managing and holiday planning. • Work with Senior Management Team on initiatives to support overall Operations. Reports Analyst Arvato Bertelsmann / Digital Room Inc / SITEL / Sutherland Global services 10/2010 – 10/2015 | Clark, Pampanga / Mandaluyong Business Process Outsourcing company Achievements/Tasks • Accountable for business analysis and subject matter expertise in customer systems and programs, working closely with operations/training team, and driving continuous improvement. • Prepare and maintain daily/weekly/monthly agent dashboard and scorecard. • Works with operations management team to design best practices and integrate business model into formal project initiative. • Maintain existing reporting database tools of program and process reports requests. • Provide requested reports with the required data elements for team and other departments. • Collect weekly Customer Satisfaction survey results and Quality Monitoring results and perform the appropriate analysis. • Provide real time analytics to operations to drive consistent improvements. • Adapt to changing requirements in business need and anticipate needed input and assistance by maintaining understanding of changing management objectives. SKILLS LANGUAGE English Filipino Full professional Proficiency Native or Bilingual Proficiency EDUCATION Baguio Central University BS in Nursing 06/2002 –03/2008 | Baguio City Other Experience L1 Customer Support Engineer Crossover 10/2018 –01/2019
Get your freelancer profile up and running. View the step by step guide to set up a freelancer profile so you can land your dream job.