نبذة عني
Tony is an inquisitive data analyst with a solid background in Chemical Engineering and strong technical skills. Tony is passionate about data mining, data ETL, data analysis, data pipeline, predictive analytics, and dat…
Tony is an inquisitive data analyst with a solid background in Chemical Engineering and strong technical skills. Tony is passionate about data mining, data ETL, data analysis, data pipeline, predictive analytics, and data visualization. Tony brings strong analytical problem-solving abilities and critical thinking skills from engineering experience combined with excellent communication skills.
الخبرة
Data Analyst
● Integrated varied CRM data sources into Google Sheets using Zapier 's automated processes
● Utilized Google Cloud BigQuery for intricate SQL analysis of Google Ads Campaign data, designed data warehouse schema
for raw table and pdt views, created conceptual-level SQL queries to perform the exploratory data analysis
● Administered and analyzed extensive sales data within the relational database, effectively handling large datasets
● Managed Power BI data flows, employing DAX and M language, extracted and cleaned raw data from BigQuery
● Designed and built interactive Power BI dashboards to continuously track omnichannel marketing campaign performance,
including conversions, CTR, ROAS(return on ad spending), sales, commissions, etc
● Automated reporting workflow by scripting and APIs, delivering weekly marketing dashboard to support management decision
● Creating SQL store procedures and functions to perform data quality checks, applying data governance using Collibra
Data Analyst
Integrated varied CRM data sources into Google Sheets using Zapier's automated processes.
Utilized Google Cloud BigQuery for intricate SQL analysis of Google Ads Campaign data.
Designed data warehouse schema for raw table and pdt views.
Created conceptual level SQL queries to perform exploratory data analysis.
Administered and analyzed extensive sales data within the relational database.
Effectively handled large datasets.
Managed Power BI data flows, employing DAX and M language.
Extracted and cleaned raw data from BigQuery.
Designed and built interactive Power BI dashboards to continuously track omnichannel marketing campaign performance, including conversions, CTR, ROAS, sales, commissions, etc.
Automated reporting workflow by scripting and APIs.
Delivered weekly marketing dashboard to support management decision.
Created SQL store procedures and functions to perform data quality checks.
Applied data governance using Collibra.
Data Analyst
Built the data platform and reporting infrastructure from zero for various dental practice management software.
Used Power BI desktop and SQL Server.
Developed operational reporting in Power BI and Excel to streamline client base growth and self-serve data management.
Reduced 20 hours of workload per client per month.
Managed clients' Microsoft 365 credentials.
Established data connections such as on-premises data gateway.
Collected ad-hoc business requirements from clients in bi-weekly meetings.
Delivered valuable data insights.
Provided technical consultations on business opportunities.
Recommended improvement strategies to workflow processes for clients.
Performed data accuracy testing of developed reports to enhance data quality and usability.