Frank Jiang
Data Analyst
Weehawken,New Jersey
Overview
3
3
years of professional experience
3
3
years of post-secondary education
1
1
Language
Work History
Database Analyst
CVS Health
New York, NY
11.2020 - Current
- Developed and documented stored procedures to automate tasks in various databases within SQL Sever Management Studio.
- Utilized data visualization tools, including Tableau, to effectively communicate business insights and create client facing dashboards.
- Worked cross functionally across two internal teams to provide overlapping support in both production and server side issues.
- Researched and resolved real time bugs using SQL profiler's tracing feature to effectively investigate and deploy fixes from test environment to production
- Ensured the integrity of PHI data received on a daily basis and monitored data intake closely to provide any EDI or data processing errors
Analyst/Analytics
Havas Media
New York, NY
09.2019 - 04.2020
- Accountable for delivering over 20 monthly and fiscal yearly reports utilizing Tableau, which accentuated campaign performance across 3 major alcoholic brands
- Responsible for maintaining the integrity of over $4.5 million worth of historical campaign data across the entire client portfolio
- Developed and highlighted key campaign performance insights and optimizations that led to 14% average increase in
- KPI performance month over month
- Collaborated with the Data Engineering team to implement an automated reporting process using AWS that drove an 70% increase in overall productivity and streamlined the reporting process
Undergraduate Researcher
Rutgers Department of Industrial and Systems Engineering
06.2018 - 01.2019
- With GRIST Lab’s 3D Security Game
- Analyzed and adapted existing work from previous team members to jump start productivity in 2 weeks
- Engineered over 15 Unity builds that fixed 4 large game bugs/issues and 5 visual bugs
- Communicated daily with team members and lead professor on Slack to issues 5-10 fixes a day
- Implemented dynamic functionality to improve UX and UI across mobile, web, and tablet
Summer Analytics/Research Intern
IPG Mediabrands
06.2018 - 08.2018
- Created a full sorting, infographic, and an automatically updating dashboard with 28 metric that is heavily used by the
- Decision Sciences and Research team as a direct guidance to BMW/MINI
- Discovered and illustrated over 60 new key insights that the Strategy team used to create an informative presentation
- Carried out QA for every one of North and West regional dashboards sorted by different metrics
- Improved productivity by automating manual data analysis by using various macros in Microsoft Excel
Education
Bachelor of Science - Computer Science
Rutgers, The State University of New Jersey
05.2016 - 05.2019
Skills
Data visualization
Market Analysis
Performance based dashboards
Timeline
Database Analyst
CVS Health
11.2020 - Current
Analyst/Analytics
Havas Media
09.2019 - 04.2020
Undergraduate Researcher
Rutgers Department of Industrial and Systems Engineering
06.2018 - 01.2019
Summer Analytics/Research Intern
IPG Mediabrands
06.2018 - 08.2018
Bachelor of Science - Computer Science
Rutgers, The State University of New Jersey
05.2016 - 05.2019