Jhony Chu
Verified Expert in Engineering
Google BigQuery 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
- Business Intelligence (BI) - 6 years
- SQL - 5 years
- Google BigQuery - 5 years
- Microsoft Power BI - 5 years
- Tableau - 5 years
- APIs - 4 years
- Google Data Studio - 3 years
- Python - 3 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
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.
- 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.
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 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 and Data Engineer Expert
Travelodge - Main
- 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.
- 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 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
Education
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, Clio API, Node.js
Tools
Microsoft Power BI, Tableau, Stitch Data, BigQuery, Google Analytics, Excel 2016, Google Sheets, Make, Google Docs, Tableau Prep Flow, Tableau Embedded Analytics
Languages
Python, SQL, Snowflake
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, Dedicated SQL Pool (formerly SQL DW), Mixpanel, KNIME
Storage
Databases, PostgreSQL, Data Pipelines, Microsoft SQL Server, Google Cloud, SQL Server Integration Services (SSIS), Excel Contact Databases, MySQL, Amazon S3 (AWS S3)
Industry Expertise
Social Media
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, 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, APIs, Data Science, Data Architecture, Social Networks, Database Optimization, Containerization, 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