Data Analyst Engineering
Resume:
Jennifer Sun
*********.**@*****.***
linkedin.com/in/jennifer-y-9602705
Tableau Developer Data Analyst SQL ETL Data Visualization Azure Business Intelligence
Experienced data analyst and BI developer with strong expertise in Tableau dashboard design, SQL data preparation, and business reporting. Skilled in collaborating with cross-functional teams to deliver actionable insights through intuitive visualizations. Proven ability to enhance data transparency and support data-driven decision-making. Extensive background in ETL development, data engineering, and large-scale migration projects. SKILLS
- BI & Visualization: Tableau (advanced), Tableau Server/Online, SSRS, WhereScape, SAP Visual Composer
- Cloud & Data Engineering: Microsoft Azure, Azure Data Factory (ADF), Azure Synapse, Azure Data Lake, SQL
- Programming: Python, PySpark, C#, JavaScript, SQL, JSON, XML, VBA, ColdFusion (CFML)
- Databases: SQL Server, Oracle, DB2
EDUCATION
- University of Cincinnati — B.S. in Information Engineering Technology
- Columbus State — A.S. in Computer Programming Technology EXPERIENCE
Washington State Department of Transportation (Project Propel) ETL Developer, IT Data Management
Oct 2023 – Mar 2025
- Designed and implemented Azure Data Factory and Synapse pipelines to integrate and transform complex datasets into Azure Data Lake Storage.
- Improved data validation efficiency by 30% and accelerated project lifecycle by 20%.
- Led senior-level ETL development, troubleshooting complex issues and mentoring team members.
- Gathered requirements, managed change, and implemented data solutions with strong written and verbal communication.
University of Washington, Finance Transformation (UWFT) Business Systems Analyst
Jun 2020 – Oct 2023
- Designed and developed Tableau dashboards to present data validation exceptions to data providers and SMEs, improving data quality and transparency across 9 UWFT End-to-End processes.
- Created visualizations supporting data validation, conversion progress tracking, and exception resolution across multiple legacy systems.
- Partnered with business stakeholders and developers to align dashboard content and design with reporting requirements.
- Documented dashboard specifications and iteratively improved them based on user feedback.
- Coordinated extraction, transformation, and loading of data into Workday Finance; tracked QA issues and deliverables in JIRA.
- Maintained WhereScape data warehouse documentation for UWFT Data Conversion. Accomplishments:
- Successfully facilitated collaboration between SMEs, functional teams, Deloitte, and the UWFT Data Conversion team.
- Implemented a streamlined communication plan, reducing misinterpretation and QA delays.
- Identified and resolved critical data conversion issues, mitigating risks and ensuring timely project delivery.
Macy’s Technology RFID Operations
Lead Software Engineer
Jul 2016 – Feb 2020
- Developed and supported ETL and BI solutions for RFID operations, enhancing inventory accuracy across 500+ Macy’s and 30+ Bloomingdale’s stores.
- Created and maintained SSIS packages and SSRS reports to support critical business functions.
- Designed an automated C# WPF MVVM tracking system to monitor 500+ servers and detect malfunctions.
- Optimized RFID functions by managing data collection across hundreds of SQL servers. Accomplishments:
- Improved inventory planning, product availability, and financial operations through enterprise-wide RFID adoption.
- Enhanced the replenishment process, maximizing sales potential and floor stock accuracy. Macy’s System Technology
Developer II
Nov 2015 – Jul 2016
- Supported Motorola handheld device programming and EXO project using C#, MVC, Entity Framework, Oracle, and SQL Server.
- Improved and supported Central Ordering System and Web distribution applications using ASP.NET and SQL Server.
- Resolved business-critical problems in logistics and vendor systems.
- Performed DDL, and DML to combine, and summarize data. University of Cincinnati, Business Core System
Software Application Developer
Mar 2002 – Sep 2015
- Supported SAP Public Budget Formulation (PBF) module and customized function modules with ABAP.
- Maintained SAP Visual Composer forms and BW reports.
- Developed a business data warehouse reporting site and automated financial reporting processes.
- Created an equipment inventory application using ColdFusion and SQL Server. PROJECTS
Macy’s Expense Offset System (EXO) Rewrite
- Upgraded .NET framework and Oracle database.
- Analyzed and prioritized rewrite processes and documented system improvements.
- Collaborated with Agile teams to deliver a stable, optimized system. University of Cincinnati Business Core Budget Formulation
- Developed automated budget forms using SAP Visual Composer.
- Improved budgeting efficiency and accuracy for the university’s financial operations. AWARDS
- Make Magic Award, Macy’s Technology RFID Operations, 2017
- Above and Beyond Professionalism Staff Award, McMicken College of Arts & Sciences, 2008 CERTIFICATES
- Oracle Certification in SQL/PL SQL
Contact this candidate