Open to opportunities

J W

@jw03

Message

Data analyst with 10+ years transforming complex data into actionable BI insights.

United States

Message

What I'm looking for

I seek data roles where I can automate pipelines, improve data quality, build BI dashboards, and drive measurable reporting efficiency in collaborative teams.

I am a results-driven data analyst with over a decade of experience converting unstructured legacy and operational data into reliable, actionable models and executive-ready dashboards.

I specialize in Power Query/Power BI, Advanced Excel, SQL, and Python to automate workflows, reconcile migrations, and deliver KPI reporting that improved reporting efficiency by up to 60% and reduced data errors significantly.

My background spans public sector and major tech firms where I built audit frameworks, designed interactive Tableau dashboards, and implemented data pipelines that improved process efficiency, reduced delinquency and return rates, and ensured data quality during large migrations.

Experience

Work history, roles, and key accomplishments

Current

Data Analyst

Current

San Mateo County

Jun 2021 - Present (4 years 8 months)

Led legacy data cleansing and reconciliation across AS/400, MS Access, and SQL sources, ensuring 100% reconciliation before Salesforce migration and automating audit workflows to reduce manual verification time.

Power Query SQL Data Cleanse Data Migration Excel ETL

Data Analyst

PG&E

Feb 2020 - May 2021 (1 year 3 months)

Extracted, cleaned, and transformed unstructured data into standardized templates, improving reporting efficiency by 60% and reducing data errors by 80% through Oracle SQL and Excel-driven quality checks.

Oracle Excel Data Mapping Data Quality

Data Analyst

Apple

Aug 2019 - Dec 2019 (4 months)

Developed KPI metrics and Tableau dashboards for lease administration and payments, improving process efficiency by 20% and reducing delinquency rates by 15% through Python-driven analysis.

Python Tableau KPI Analysis Data Analysis SQL Dashboarding Trend Analysis Reporting Optimization

Data Analyst

Facebook

Apr 2019 - Jul 2019 (3 months)

Partnered with sales and operations to define reporting requirements, optimizing AR/VR product dashboards and reducing product return rates by 30% using SQL/Presto and Tableau visualizations.

SQL Presto Tableau Dashboarding AR VR Analytics Data Visualization

Data Analyst

First Associates Loan Servicing LLC

Apr 2018 - Mar 2019 (11 months)

Managed encrypted FTP data ingestion and processed 50–60M rows daily, optimizing storage by 20% and automating invoice generation and pipelines to improve monthly data flow.

FTP Data Processing Power Query Data Pipelines Excel Performance Optimization

Data Analyst

Zillionix LLC

Sep 2017 - Mar 2018 (6 months)

Collaborated with end users to derive KPI metrics and build Tableau reports, reducing data prep time by 30% and improving dashboard and reporting accuracy.

Tableau KPIs Pivot Tables Data Cleaning Reporting Stakeholder Engagement

Data Analytics Intern

California State University East Bay

Sep 2016 - Jun 2017 (9 months)

Collected and analyzed sustainability data for STARS, built and maintained Tableau dashboards, and delivered weekly KPI reports to stakeholders to support campus sustainability decisions.

Tableau Data Collection KPIs Data Visualization Data Quality Reporting SPSS R

Assistant Professor

Sydenham Institute of Management Studies

Aug 2010 - Aug 2015 (5 years)

Taught statistics, research methodology, and market research to MBA students, led R-Studio and SPSS labs, and supervised research design and statistical analyses for student projects.

Teaching SPSS R Research Methodologies Hypothesis Testing Curriculum Development

Research Analyst

Feedback Business Consulting

Aug 2007 - Nov 2008 (1 year 3 months)

Designed surveys and performed exploratory and diagnostic analyses, applying regression and cluster models to identify drivers of customer satisfaction and delivering visual reports for client presentations.

Survey Design SPSS Regression Modeling Clustering Data Visualization Reporting Statistical Modeling

Education

Degrees, certifications, and relevant coursework

California State University, East Bay

Master of Science, Statistics

2015 - 2017

Activities and societies: Built and updated Tableau dashboards for the STARS project; performed data collection, manipulation, and quality checks as an intern.

Completed a Master of Science in Statistics with coursework and projects in data analysis, visualization, and statistical methods supporting sustainability reporting.

University of Mumbai

Master of Management Studies, Marketing / Management Studies

2004 - 2006

Activities and societies: Taught and advised on research design during subsequent academic roles; conducted statistical analyses using SPSS and R-Studio.

Earned a postgraduate Master of Management Studies in Marketing with training in market research and research methodology.