JESSICA CHIANG

End Client: Honda of America Engine Plant, Anna, OH

Key Achievements

• Reduced report generation time by 80% (2 days to 4 hours) with advanced SQL optimization and Tableau dashboards, using SQL and Tableau, empowering quicker decision-making across 10+ departments.
• Achieved a 1.94% increase in usage metrics and surpassed the 2,000 views average by developing dynamic dashboards and analytics solutions.
• Enhanced operational efficiency by optimizing ETL workflows and integrating plant-wide data systems, reducing manual data handling by 30%.
• Enabled compliance with pollution standards by analyzing energy usage metrics and recommending data-driven improvements.

Core Responsibilities

Advanced SQL Querying and Optimization:

• Designed and executed complex SQL queries for datasets exceeding 20 million records, optimizing performance by 66%.
• Implemented indexing, query optimization techniques, and partitioning, reducing average query response times from 15 seconds to 5 seconds.

Dynamic Reporting and Visualization:

• Developed over 25 dynamic dashboards using Tableau and Power BI, delivering real-time insights across 5+ departments.
• Automated reporting workflows by linking SQL datasets, improving data accuracy by 15%.

ETL and Data Integration:

• Collaborated with Data Engineers to build and optimize ETL pipelines, enabling seamless integration of data into dashboards.
• Designed and implemented systems programs for plant-wide data servers, enhancing data accessibility and visualization reliability.

Operational Analytics:

• MDRS Dashboard: Gap duration and occurrence analysis for AE associates.
• SAP Checkbooks: Monthly financial summaries using SAP data.
• Assembly Line Auto Downtime Report: Identification of top incidents, streamlining incident resolution.
• Energy Usage Analytics: Analysis of power consumption to reduce waste and meet compliance standards.

Collaboration and Issue Resolution:

• Partnered with IT teams to proactively identify and resolve errors in data and systems, preventing operational delays.
• Led data validation efforts, ensuring reliable analytics for stakeholders.

End Client: Ciena Corporation, Hanover, MD

• Conducted in-depth sales and financial data analysis, building dashboards with Power BI and SQL to deliver insights into resource utilization and pipeline management.
• Automated data extraction and transformation processes, enabling real-time reporting and reducing errors in large datasets by 25%.
• Researched and resolved data discrepancies, performing quality checks to ensure data accuracy and alignment with business needs.

• Built predictive models and ETL pipelines using SQL and Python to manage financial records and social media insights, enabling tailored client reporting solutions
• Applied advanced statistical methodologies and tools like R and Tableau to create visualizations for diverse datasets, improving client decision-making capabilities
• Spearheaded the creation of a robust data validation framework, enhancing the integrity of large-scale datasets and reducing reporting errors by 30%

• Model Precision and Data Analysis: Enhanced model precision from 17% to 73% using advanced techniques like Cross-Validation, Bagging, Boosting, and Grid-Search. Developed and implemented classification models to aid in customer segmentation and management.
• Data Management: Conducted data preprocessing, exploratory data analysis (EDA), and feature engineering. Utilized Python, Tableau, and Google BigQuery for data analysis and visualization. Managed project metrics and tasks using Trello, Slack, and Jira.

• Data Management and Reporting: Managed data sets and statistical data, dealt with missing data, and assisted the data team in various data detection tasks. Collected client information and survey data, reporting results to supervisors.