Jia Zhang
Data Warehouse Analyst @Blue Cross & Blue Shield of Rhode Island
Signup · Get unlimited contacts
WORK HISTORY
Data Warehouse Analyst @Blue Cross & Blue Shield of Rhode Island
Providence, RI, US
Perform database dimensional modeling and design, mapping the data from existing enterprise operational data stores into the data warehouse or assist projects mapping for data outbound to external vendors or downstream applications. • Supervise data quality and troubleshoot data users’ incidents, perform routine and ad hoc research by writing SQL scripts and SAS programs. Detect and document the data operational defects, validate data quality and ETL logic through test cases. • Maintain the data warehouse metadata, document data definition on SharePoint. Maintain DataStage flow thru drafting Visio Diagrams.• Participate in department initiatives and projects as SME, translate business and production requirements from the business community for the technical team. Work with the business community to validate data extract designs and methodologies to ensure consistent criteria. Write the system requirement specifications, review developer’s software design documents and test cases.
EDUCATION
Bentley University - McCallum Graduate School of Business
Master's degree, Business Statistics/Data Science
Harrisburg University of Science and Technology
Practical Training Program, Analytics/Data Science
Capital University of Economics and Business
Bachelor's degree, Law
Johnson & Wales University
Master of Business Administration - MBA, Finance
SKILLS
ABOUT JIA ZHANG
Analyst with a unique combination of Data Analytics, Finance, Retail sales and Management skills; Strategic and analytical thinker, consultative approach, detailed oriented, progressively promoted.TECHNICAL SKILLSMS Excel, PowerPoint, Word, Adobe, SPSS, Oracle, SQL, R, Tableau, SAS, Python, SAP, Salesforce, SharePoint, Visio, Power BI, Service Now, Snowflake.ACADEMIC KNOWLEDGE Data Modeling, Data Analysis, Data Visualization, Database Design, Data Warehouse Management.Multiple Linear Regression, k-Nearest Neighbors, Naive Bayes Classifier, Classification and Regression Trees, Logistic Regression, Neural Nets, Discriminant Analysis, Ensembles and Uplift Modeling, AB Testing, Association Rules and Collaborative Filtering, Cluster Analysis, Time Series, Social Network Analytics, Text Mining.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.