Yan (Julia) Jiang
Cell Phone: +1(425) 223 9761
E-Mail:
Current Location: Issaquah, WA
Education
Shanghai Jiao Tong University 9/2001-6/2005
Bachelor, Computer Science & Technology
Skills
Proficient at DW/BI (Data Warehousing/Business Intelligence) Implementation.
Major skill sets:
· SQL (Teradata, Oracle, SQL Server)
· Unix/Linux Shell Scripting
· WhereScape
· Report Design and Development (Microstrategy, Tableau, SSRS)
· ETL Design and Development (Abinitio, Informatica, SSIS)
Working Experiences
Senior Data Warehouse Engineer Kaiser Permanente, WA 6/2017 ~ Current
Responsibilities:
As a member of the Informatics EDW group which builds and supports the Enterprise Data Warehouse to deliver strategic business value to the organization,
• Collaborate with product owners to plan and define requirements
• Design, develop, test and maintain a high performance data warehouse environment mainly using Teradata and WhereScape.
(DW architecture delivers BI capabilities including pre-defined, ad-hoc, dynamic reporting, OLAP analysis, and dashboards as well as data sharing interfaces with other systems.)
• Rotate on production support for key business (Pharmacy Details)
Senior Business Intelligence Analyst PayPal, Shanghai 7/2011 ~ 11/2016
Responsibilities:
As Senior Business Analyst in PayPal Global Ops,
• Delivered BI solutions under Scrum framework to transform data into information/business insights helping business users making more informed decisions.
ETL development using Teradata/SQL Server and Windows Batch/SSIS to acquire and process data from various sources.
Report/Document/Dashboard/Visual Insights design and development using Microstrategy/Tableau/SSRS/Excel.
• Performed in-depth analysis of report issues or anomalies (data inaccuracy, missing delivery etc.)
• Was one of the Gate Keepers to make sure all the standards (Coding, Metrics Definition, Data sources) been followed and resources used was under control (especially the CPU consumption)
• Provided Report Support and Training
Regular Q&A and manipulation training against PIE (“PayPal Information Exchange” a Web platform of Microstrategy) to APAC Global Ops users
Daily BI mailbox monitoring to answer user inquires in a timely manner
Senior Data Warehouse Engineer Cognizant, Shanghai 02//2008 ~ 6/2011
Responsibilities:
• Implemented Data Warehousing solution to customers with Teradata/Oracle, Unix KSH/Bash, Abinitio/Informatica and Cybermation.
• Leaded up to 3 team members on projects and made quality deliverables with high productivity under traditional waterfall framework.
Data Warehouse Engineer eBay, Shanghai 12/2005 ~ 12/2007
Responsibilities:
• Implemented ETL processes with Teradata/Oracle, Unix KSH/Bash, Abinitio/Informatica and Appworx/UC4
• Supported regular System/Tool Maintenance for Appworx/Informatica/Abinitio/ClearCase/Unix
• Performed QA/Production release on a regular basis