Verified Expert in Engineering
Google BigQuery Developer
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.
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.
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.
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
- 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
- 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
- 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
- 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
- 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
- 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.
Data Integration and Visualization for an eCommerce Company
Google Sheets API, Node.js
Microsoft Power BI, Tableau, Stitch Data, BigQuery, Google Analytics, Excel 2016, Google Sheets
ETL, Business Intelligence (BI), Data Science, Automation
Google Cloud Platform (GCP), Amazon Web Services (AWS), Mixpanel, KNIME
Databases, PostgreSQL, Data Pipelines, Microsoft SQL Server, Google Cloud, MySQL, Amazon S3 (AWS S3)
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
Master's Degree in Big Data and Business Analytics
IE Business School - Madrid, Spain
Tableau Desktop Specialist