Seasoned Data Analytics & Data Engineer with a 15-year track record in implementing advanced data engineering and cloud solutions. Proficient in SQL, Python, Power BI, Tableau, Kafka, JavaScript, and diverse AWS & Azure Cloud Services, and has managed large-scale data processing projects. Notable achievement includes developing an efficient data pipeline architecture, increasing reporting efficiency by 50%.
Overview
16
16
years of professional experience
1
1
Certification
Work History
Senior Data Analyst
San Francisco Health Plan (SFHP)
04.2024 - Current
Developed health & financial data solutions and visualizations for the San Francisco Health Department using on-premise & cloud structured and unstructured data.
Built and automated 35+ real-time dashboards in Tableau and Power BI, reducing manual reporting time by 70%.
Designed and optimized simplified SQL queries and joins to process complex datasets for Business Intelligence dashboards using Tableau and Power BI .
Developed Python scripts for data transformation and automation of internal and external file processing workflows.
Effectively prioritized between ad hoc data requests and ongoing project deliverables to meet tight deadlines.
Mentored & trained 4+junior team members and collaborated with cross-functional teams to ensure seamless project execution & knowledge sharing.
Data Engineer
Session AI
01.2020 - 04.2024
Engineered and visualized data tables for structured and unstructured data in the cloud as well as on-premise environment.
Developed complex SQL queries & joins to analyze datamart tables, facilitating the creation of dashboards & reports using Looker & Power BI
Optimized data models on on-Prem SQL database & AWS Cloud, improving system performance by 20%
Developed and maintained interactive reports leveraging diverse visualization charts and DAX measures to calculate key performance indicators (KPIs), enabling comprehensive data analysis and informed business intelligence
Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
Senior Software Engineer
Macy's
01.2011 - 01.2020
Developed software solutions with focus on data handling and visualization at scale
Contributed to the development of a software package increasing data processing speed by 40%
Implemented solutions in Python and Spark, improving data wrangling and visualization
Managed the integration of numerous sources, processing large volumes of structured and unstructured data efficiently
Software Engineer
eBay
01.2009 - 01.2011
Worked on the development and maintenance of databases and data warehouses
Assisted in the processing of structured & unstructured data into a form suitable for analysis, leading to more informed decision making
Participated in performance tuning and optimization of data, improving data quality by 30%
Education
Master's Degree - Computer Science
Gujarat University
12.2007
Skills
Python
POWER BI
SQL
Tableau
Looker
AWS & Azure Services
JavaScript
AWS Quick Sight
Business intelligence
ETL processes
Dashboard creation
Data warehousing
Advanced Excel
Certification
AWS Certified Data Engineer, In-depth course exploring AWS services such as Redshift, RDS, S3, Quicksight, Glue provided by Amazon
Timeline
Senior Data Analyst
San Francisco Health Plan (SFHP)
04.2024 - Current
Data Engineer
Session AI
01.2020 - 04.2024
Senior Software Engineer
Macy's
01.2011 - 01.2020
Software Engineer
eBay
01.2009 - 01.2011
Master's Degree - Computer Science
Gujarat University
Similar Profiles
Kyle Lai-FattKyle Lai-Fatt
Senior Digital Marketing Project Manager at San Francisco Health PlanSenior Digital Marketing Project Manager at San Francisco Health Plan