Jhony is available for hire
Hire JhonyJhony Chu
Verified Expert in Engineering
Google BigQuery Developer
Location
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
Freight Finance Co. DBA Express Freight Finance
Tableau, Dashboard Development, Analytics, KNIME, PostgreSQL, Python...
Skyloop Digital Ltd
Tableau, Google BigQuery, BigQuery, Dashboards, Data Visualization...
ClimateWells
SQL, Data Analytics, Data Modeling, Data Analysis, ETL, Dashboards, Tableau...
Experience
Availability
Part-time
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
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
2021 - PRESENT
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.
Technologies: Tableau, Dashboard Development, Analytics, KNIME, PostgreSQL, Python, Machine Learning, Automation, Google Sheets, Google Sheets API, Social Media
Tableau Developer
2023 - 2023
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.
Technologies: Tableau, Google BigQuery, BigQuery, Dashboards, Data Visualization, Google Sheets, Google Sheets API, Social Media
Data Engineer and BI Developer
2022 - 2022
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.
Technologies: SQL, Data Analytics, Data Modeling, Data Analysis, ETL, Dashboards, Tableau, Microsoft Power BI, Python, Dash, Data Visualization, Cloud Run, Containerization, Natural Language Processing (NLP), Generative Pre-trained Transformers (GPT), GPT, Data Architecture, Automated Data Flows, Data Warehousing, Data, Databases, Google Cloud, Google Cloud Functions, Analytics, Excel 2016, Data Cleansing, Google Sheets, Google Sheets API
Senior Data Analyst
2021 - 2022
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.
Technologies: Tableau, Python, MySQL, Data Engineering, Data Pipelines, Microsoft SQL Server, ETL, Data Visualization, Azure SQL Data Warehouse (SQL DW), Data Analysis, Dashboards, Data Architecture, Automated Data Flows, Data Warehousing, Data, Databases, Google Cloud, Google Cloud Functions, Analytics, Excel 2016, Data Cleansing, Tableau Prep Flow
Data Analytics Manager
2020 - 2022
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%.
Technologies: BigQuery, SQL, Python, Google Data Studio, APIs, Google Cloud Platform (GCP), Data Analytics, Business Intelligence (BI), Reports, Social Networks, Analytics, Google Analytics, Data Engineering, Data Pipelines, ETL, Data Visualization, Google BigQuery, Data Modeling, Data Analysis, Dashboards, Data Architecture, Automated Data Flows, API Integration, Stitch Data, Data Warehousing, Data, Databases, Google Cloud, Google Cloud Functions, Excel 2016, User Interface (UI), Data Cleansing, Google Sheets, Google Sheets API, Social Media
Data Analytics Team Lead
2020 - 2021
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.
Technologies: SQL, Python, Tableau, Google Cloud Platform (GCP), Data Analytics, Business Intelligence (BI), Reports, Analytics, BigQuery, Data Engineering, PostgreSQL, Data Pipelines, ETL, Data Visualization, Google BigQuery, Dashboards, Data Architecture, Automated Data Flows, Data Warehousing, Data, Databases, Google Cloud, Google Cloud Functions, Data Analysis, Excel 2016, Data Cleansing
Digital Analytics Data Consultant
2018 - 2019
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.
Technologies: Microsoft Power BI, Google Data Studio, SQL, Python, Machine Learning, Google Cloud Platform (GCP), Amazon Web Services (AWS), Data Analytics, Business Intelligence (BI), Reports, Data Science, Social Networks, Mobile Apps, Mixpanel, Analytics, BigQuery, Google Analytics, PostgreSQL, Data Pipelines, ETL, Data Visualization, Google BigQuery, Data Modeling, Data Analysis, Dashboards, Data Architecture, Automated Data Flows, Data Warehousing, Data, Databases, Google Cloud, Excel 2016, User Interface (UI), Data Cleansing, Google Sheets, Google Sheets API, Social Media
Performance Improvement Data Consultant
2015 - 2016
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.
Technologies: SQL, Tableau, Data Analytics, Reports, Analytics, Data Pipelines, Microsoft SQL Server, ETL, Data Analysis, Dashboards, Automated Data Flows, Data Warehousing, Data, Databases, Microsoft Power BI, Data Visualization, Excel 2016, User Interface (UI), Data Cleansing, Google Sheets, Google Sheets API
Experience
Data Integration and Visualization for an eCommerce Company
An end-to-end project about data extraction from several third-party applications, such as Facebook Ads, Google Ads, LinkedIn Ads, and Shopify. I worked on data integration, cleaning, transformation, and creating powerful customized reports, including operations and logistics, customer lifetime value, cohorts, eCommerce and marketing overview, and wholesale dashboard.
Skills
Languages
Python, SQL
Libraries/APIs
Google Sheets API, Node.js
Tools
Microsoft Power BI, Tableau, Stitch Data, BigQuery, Google Analytics, Excel 2016, Google Sheets
Paradigms
ETL, Business Intelligence (BI), Data Science, Automation
Platforms
Google Cloud Platform (GCP), Amazon Web Services (AWS), Mixpanel, KNIME
Storage
Databases, PostgreSQL, Data Pipelines, Microsoft SQL Server, Google Cloud, 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, APIs, Azure SQL Data Warehouse (SQL DW), Data Architecture, Social Networks, Database Optimization, Cloud Run, Containerization, Tableau Prep Flow, Machine Learning, Mobile Apps, Amazon RDS, Dash, Natural Language Processing (NLP), Cloud Tasks, GPT, Generative Pre-trained Transformers (GPT), Dashboard Development
Education
2017 - 2018
Master's Degree in Big Data and Business Analytics
IE Business School - Madrid, Spain
Certifications
NOVEMBER 2020 - PRESENT
Tableau Desktop Specialist
Tableau Software