Hello, my name is
Yanqing Jiang
Advance Analytics Senior Manager
- www.linkedin.com/in/jiangyanqing
- jiangyanqing90@gmail.com
![Headshot-block design Headshot-block design](https://www.jiangyanqing.com/wp-content/uploads/elementor/thumbs/Headshot-block-design-pf5t39ohsposfb4p4yzbmo29q1qiy649pvo450ih0o.png)
Latest AI project:
Ask anything about me and let ChatGPT answer it with my data
Search GPT with latest news! No more 2021 data cutoff from OpenAI!
![](https://www.jiangyanqing.com/wp-content/uploads/2021/10/Add-Comment-Blurred.gif)
All-in-One Supplier Review System
- Excel like experience in Power BI report (advance PowerApps visual)
- Supplier Score Card and Periodic Business Review 2-in-1 solution
- Conduct business review and send instant feedback at the same screen
![](http://jiangyanqing.com/wp-content/uploads/2021/10/Capex-Project-Tracker-Showcase.gif)
Capex Project Tracker
- Shopping cart like solution for Capex project tracking
- Main project with multiple line projects
- Impacted million-dollar business decision-making
![](https://www.jiangyanqing.com/wp-content/uploads/2021/10/2021-10-09_18-35-28-150x150.png)
Time Series Demand Forecasting
- R: Time series: train and test dataset, error comparing
- Run through 7 time series regression models
- Automated R script into a Power BI report for performance tracking
![](https://www.jiangyanqing.com/wp-content/uploads/2021/10/Engagement-Intake.gif)
All-in-One Engagement Intake
- Hundreds of daily users. Effected multi-million dollar decisions
- Highly complexed project management tool covers two major global categories
- Thousands of build-in business rules
![](https://www.jiangyanqing.com/wp-content/uploads/2021/10/Global-Inventory-Dashboard-150x150.png)
Global Inventory Management Dashboard
- First time in the organizational history, a global spare-part inventory dashboard with 20+ sub reports
- Guiding Inventory Managers with Min Max Safety Stock, Re-order point suggestions...etc
- Created million-dollar impact on inventory values and savings
![](https://www.jiangyanqing.com/wp-content/uploads/2021/11/hOYptqtI_400x400-150x150.jpg)
IBM Data Science Certificate
- Focus heavily on Machine Learning with Python
- In final capstone project I have 5 Machine Learning algorithm build-in and tweak for SpaceX launching dataset
- Click to visit GitHub repo pageAbout me
I am an enthusiastic data analytic professional developing data solutions for P&G's Amazon Sales team
I’m not a data cruncher, I’m a problem solver, a strategist. With entrepreneurial spirit from previous experience, I have mastered the skills of navigate around the most ambiguous problems and guide my stakeholders to the right direction. Not matter if it is a simple Excel sheet, or an advance machine learning model, I use these data analytic tools to create impact and make purpose of real world problems. I’m not afraid of the unknown. I know how to quickly learn and deploy the most-needed skills into use in order to find effective solutions.
What I do
Business solution Design
Develop web apps with effective data structure and easy-to-use interface to create impact through the organization. Exp: project trackers, project management, engagement intake...etc
data science
Building end-to-end machine learning forecasting pipelines, A/B Testing, data normalization using R and Python
Automated Analytic reporting
Revealing business insight by building Interactive Power BI report, Power BI DAX, advance visualizations
SQL Database
MS SQL server admin: writing Import procedures, views, advance queries from hundreds of relational databases
Data automation
From Python scripting, web scraping, MS SQL Server import procedures, to Databricks workflows, I save time by "automate the boring stuff".
2022-Present
Proctor & Gamble
Enterprise Analytics & Insight senior manager
Develop Analytics solutions for P&G's Sales team
2020-2022
Archer Daniels Midland
Data & Analytics Engineer
Developed data analytics solutions for ADM's industry-leading Global Procurement department
2016-2020
U.S. Army
Supply specialist
Active Duty Battalion S4 Supply Specialist
2014-2016
Alpha J Store Inc.
entrepreneur
Exclusive North America online retailor for a top 10 luggage manufacture in China