Data Analyst

• Jun 2021 - Present

• Migrated over 1 TB of data from Netezza SDS to Snowflake using advanced SQL techniques, resulting in minimal data loss and reducing the Validation time by 50% • Implemented a robust data validation process using SQL, resulting in a 90% reduction in errors and improved data accuracy for end users, also a 50% reduction in data remediation time for the Data Migration team • Implemented data quality checks and validations within ETL pipelines, resulting in a reduction of data errors by 60% and improving overall data integrity. • Collaborated in a bi-weekly Agile environment to help provide strategic decision and implementation for database migration and maintaining 90% consistency over the database layer • Developed interactive Tableau dashboards for the Auto and Property lines of business, providing real-time visibility into critical metrics and KPIs, resulting in a 15% improvement in decision-making accuracy. • Developed and implemented Python scripts to automate data cleaning processes, reducing processing time by 50%. • Utilized dbt (data build tool) to automate the transformation process for migrating 100+ tables, leading to a 40% increase in overall efficiency and accuracy. KEY TOOLS: Snowflake, DB2, SQL, Control-M, Informatica, Putty Show less

Data Analyst

• May 2020 - Dec 2020

My responsibility included •Analyzed client's traffic data using different tools like Google Analytics, SQL (BigQuery), and constructed KPI reports •Spearheaded ad-hoc statistical and visual dashboards using Tableau and data studio to infer underlying anomalies in KPIs, which led to an increase in the productivity of business processes by 33.3% •Garnered 15% growth in revenue for clients portfolios by A/B testing different DSPs for optimized results •Stimulated solutions based on end user's needs by uncovering ways to identify, assess & solve open-ended problems while going above & beyond to align with the need Key Tools used: Tableau, Google Data Studio, SQL, BigQuery, Python, Google Analytics Show less

Data Analyst - Paid Media

• Jun 2017 - May 2019

Key Tools Used: Excel, SQL, Ad Management, Google Data Studio, Tableau • Formulated data analysis on customers' portfolio to ensuring continuous improvement in the Ads quality and maximizing revenue from same, which improved over 10% of revenue for client's portfolio • Investigated websites to identify concepts of domain names to have an 80% detailed Ads targeting strategy • Accelerated team's efficiency by 30% by creating and maintaining advanced excel files that can automatically fetch data required for everyday analysis and observation Show less

Trainee

• May 2016 - Jun 2016

Received training to work on the latest embedded platforms and learned • ARM "Mbed" platform and basics of programming. • ARM Embedded Systems. • Cypress Programmable System on Chip. Received training to work on the latest embedded platforms and learned • ARM "Mbed" platform and basics of programming. • ARM Embedded Systems. • Cypress Programmable System on Chip.

Business Analyst

• Dec 2015 - Jan 2016