
Jhony Chu
Verified Expert in Engineering
Google Data Studio Developer
Madrid, Spain
Toptal member since June 22, 2021
Jhony is a data analytics expert with 8+ years of experience leading and implementing end-to-end analytics projects, from data project planning and definition to data extraction, ingestion, cleaning, transformation, and data visualization on cloud platforms.
Portfolio
Experience
- Microsoft Power BI - 10 years
- Tableau - 10 years
- SQL - 10 years
- Business Intelligence (BI) - 10 years
- Python - 8 years
- Google Data Studio - 8 years
- Google BigQuery - 8 years
- APIs - 8 years
Availability
Preferred Environment
Python, SQL, Microsoft Power BI, Tableau, Google Data Studio, APIs, Google Cloud Platform (GCP), Data Visualization, Dashboards, Analytics, Google Sheets, Google Sheets API, Looker Studio, Dashboard Design, Dashboard Development, Data Cleaning, Automation, Data Integration, Marketing, Data Validation, Google Analytics API
The most amazing...
...implementation I've led covered end-to-end analytics, from data extraction to processing, automation, and visualization, while utilizing different data sources.
Work Experience
Tableau Developer
Freight Finance Co. DBA Express Freight Finance
- Integrated APIs from multiple 3rd-party tools, such as Outreach, CallRail, Salesforce, and Google, to streamline data integration and enhance cross-platform functionality.
- Developed and automated pipelines using KNIME, ensuring efficient data processing and workflow automation.
- Introduced materialized views to optimize the performance of recurring queries and reports in PostgreSQL to Tableau Dashboards.
- Improved the performance of Postgres queries that fed into Dashboards by refactoring and applying indexing strategies, reducing the execution time by 30% to 60%.
- Demonstrated expertise in Tableau's advanced functionalities, including Level of Detail (LOD) expressions, data blending, joins, and calculated fields, enabling in-depth analysis and granular data manipulation.
- Leveraged these advanced functionalities in Tableau to create interactive dashboards that provide dynamic insights and facilitate data exploration for end-users.
- Developed machine learning models to accurately predict potential fraud, leveraging advanced algorithms and data analysis techniques.
- Partitioned Salesforce Lead Data Tables by Date to improve query performance for data exploration purposes.
Data Engineer
Volvo Car
- Integrated Google Analytics 4 (GA4) data into Snowflake to enhance insights for the online shop team. Developed automated data pipelines and optimized GA4 event data models.
- Created dynamic Power BI dashboards with DAX and direct queries to provide real-time reporting on KPIs such as conversion rates and traffic sources.
- Streamlined data processes, improving reporting speed and enabling data-driven decision-making across teams.
RFP Presales Support
Toptal Client
- Supported Toptal team in generating strategic sales slides for data architecture model for PowerBI and Microsoft ecosystem.
- Mapped potential risks and challenges for migration from Tableau to PowerBI.
- Mapped existing issues and proposed potential solutions about their existing data modeling for migration.
- Built data architecture for potential migration from Tableau to PowerBI.
Tableau Consultant
Cosgrove Partnership Inc
- Set up a Tableau Embedded environment with a login screen to filter different client reports based on login credentials.
- Set up a data warehouse in BigQuery with a multi-tenant structure to support Tableau dashboards.
- Implemented data extraction for several APIs, including QuickBooks, Google Maps Reviews, Google Analytics 4, Facebook Ads, and Google Search Console to integrate all the data in one single place.
- Created and automated dashboards in Tableau for a multi-tenant service in Tableau Embedded with an integrated login platform for several companies, enhanced with row-level security.
Data Visualization | Data Engineer Expert
Travelodge
- Refactored and processed business Google Sheets into BigQuery.
- Processed, cleaned, and transformed hotel sales and employee data by region and hotel in BigQuery.
- Created reports and generated insights in Google Data Studio for each region, hotel, and employee on an incentive program basis.
Google Data Studio Dashboard Developer
Travelodge - Main
- Automated the data flow from the client internal data source to Google Data Studio through Google Sheets.
- Managed the data blending in Google Data Studio to generate the defined metrics.
- Optimized the dashboard performance and the formulas created by the cleaning to improve the speed of the dashboard.
Tableau Developer
Skyloop Digital Ltd
- Utilized BigQuery for data cleaning and transformation processes.
- Optimized Postgres Queries pipeline that fed into BigQuery by applying indexing and partitioning based on event dates.
- Employed BigQuery to create materialized views for optimized querying and performance.
- Leveraged Tableau to develop customized reports aligned with specific business requirements.
Data Engineer and BI Developer
ClimateWells
- Developed a fully automated pipeline to upload data into buckets after reading from the drive using Python.
- Applied regular expression and natural language processing (NLP) using named entity recognition (NER) packages on text to classify data using Python.
- Deployed containers to automate whole extraction and transformation in Google Cloud Platform using Cloud Run.
- Built and designed an insightful dashboard for C-level executives in Looker Studio.
Senior Data Analyst
ITRenew Inc.
- Developed, automated, and maintained data processes from the Cloud using Python for a financial project.
- Monitored and secured the correct functioning of ETL processes.
- Developed, automated, and maintained business reports in Tableau.
Data Analytics Manager
LastObject
- Implemented end-to-end analytics and reporting solution from scratch within three months.
- Recommended and presented insights and findings to C-level executives on a weekly basis.
- Identified new technology opportunities for the company and reduced the monthly fixed costs by 100%.
Data Analytics Team Lead
Banner Analytics
- Identified and implemented scalable solution for data discrepancies project in six months.
- Managed a team of developers and quality assurance analysts to improve and automate a company solution.
- Presented results about data quality with over 95% confidence to C-level executives.
Digital Analytics Data Consultant
Accenture
- Managed end-to-end implementation of analytics and data visualization tools for Chatbot’s products across industries.
- Performed in-depth analysis of client’s historical data, identifying and regularizing 100% of sales revenue discrepancies.
- Conducted exploratory data analysis on the client’s current digital marketing capabilities and recommended detailed, actionable guidelines aligned with their enterprise-wide objectives of data for deep learning.
Performance Improvement Data Consultant
EY
- Improved client’s sales volume by 15% by eliminating process-related bottlenecks.
- Prepared and presented data-driven insights of adjusted pricing model to C-level suite.
- Identified and classified five different segments and developed several data-driven strategies for each of them during go-to-market.
Experience
Data Integration and Visualization for an eCommerce Company
Data Engineer and Power BI Development for Global Automotive Company
Data Engineer & Tableau Embedded Expert for Multi-tentant Client Dashboard
https://imgur.com/a/uHaeHPPEducation
Master's Degree in Big Data and Business Analytics
IE Business School - Madrid, Spain
Certifications
Tableau Desktop Specialist
Tableau Software
Skills
Libraries/APIs
Google Sheets API, QuickBooks API, Facebook Ads API, Google Analytics API, Node.js
Tools
Microsoft Power BI, Tableau, Stitch Data, BigQuery, Google Analytics, Excel 2016, Google Sheets, Make (formely Integromat), Google Docs, Git, Microsoft Excel, Looker, Tableau Prep Flow, Tableau Embedded Analytics
Languages
Python, SQL, Snowflake, JavaScript
Paradigms
ETL, Business Intelligence (BI), Automation
Platforms
Google Cloud Platform (GCP), Azure, Docker, Microsoft Power Automate, Azure SQL Data Warehouse, Amazon Web Services (AWS), Cloud Run, Mixpanel, KNIME
Storage
Databases, PostgreSQL, Data Pipelines, Microsoft SQL Server, Google Cloud, SQL Server Integration Services (SSIS), Data Integration, Data Validation, Google Cloud Storage, Amazon S3 (AWS S3), Excel Contact Databases, MySQL
Industry Expertise
Social Media, Marketing
Other
Google BigQuery, Google Data Studio, Data Modeling, Data Visualization, Data Engineering, Data, Data Analytics, Data Warehousing, Dashboards, API Integration, Data Analysis, Reports, Automated Data Flows, Data Architecture, Analytics, Google Cloud Functions, User Interface (UI), Data Cleansing, Dashboard Development, Looker Studio, Dashboard Design, Data Scraping, Web Scraping, Data Cleaning, Airtable, Integration, QuickBooks Online, Google Analytics 4, Facebook Ads, Google Search Console, Website Traffic, DAX, APIs, Data Science, Social Networks, Database Optimization, Containerization, Data Migration, Machine Learning, Mobile Apps, Amazon RDS, Dash, Natural Language Processing (NLP), Cloud Tasks, Generative Pre-trained Transformers (GPT), Excel Reporting
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring