Ming Zhang

Sr. Data Analyst

*** ******** **, *******, **, 19355 216-***-**** ac7wqi@r.postjobfree.com

SUMMARY

7+ years of hands-on experience as an ETL/BI developer and Data Scientist using SQL/T-SQL, SSIS, SSAS, SSRS, and Power BI.

Excellent knowledge and professional experience in data modeling and database design.

Excellent knowledge and professional experience in Python, especially on data analysis/visualization using Pandas, Matplotlib, Numpy and Scipy.

Professional trainings on Qlik Sense (reporting, developing and security&administration) and SQL Data Warehouse.

Professional experience in handling large healthcare data sets on both mental health and physical health, with excellent knowledge of different types of Quality Measures in healthcare, including how to develop, collect/report and implement.

Capability of building up new HEDIS (the Healthcare Effectiveness Data and Information Set) measures of NCQA for large health care organizations.

Basic knowledge of SAS and C#.

EXPERIENCE

Sr. Data Analyst

Community Behavioral Health (CBH) – Philadelphia, PA - Aug 2017 to present

NCQA HEDIS ADHD (Attention-Deficit/Hyperactivity Disorder) measure

Created flowcharts according to the measure’s requirements.

Extracted, transformed and loaded external data to the data warehouse.

Designed and created 20+ staging and reference tables.

Designed and created 10+ stored procedures.

Calculated the measure’s numerators, denominators and rates.

Designed and created 10+ archive tables.

Designed, created, debugged and deployed 10+ SSIS and SSRS packages.

FY18 performance measures for Quarterly City Manager’s Report (QCMR)

Developed new measures, percentage of follow-up within 30 days of discharge from an inpatient psychiatric facility and percentage of readmission within 30 days to inpatient psychiatric facility (substance abuse & non-substance abuse).

Modified IPRO logic to break down rates by age categories.

Modified SSIS package to combine monthly and non-monthly sequence containers and add or remove parameters accordingly and optimize script tasks.

Created views to archive records for HEDIS and PA measures.

Modified related reports at Jira accordingly.

Modification of reports for Detox/Rehab population

Added more LOCs.

Broke down reports by adult and child categories.

Added parameters for age, date and LOCs and allow multiple selections and drill-down.

Evidence Based Practice(EBP) data tracking

Collected monthly data about the claims for Family Functional Therapy (FFT) and Parent-Child Interaction Therapy (PCIT) by providers, including number of individuals with a claim, average and range of claims per individual and demographics of individuals with the claim;

Tracked the trend in the data over time to monitor use of the new Level of Cares (LOCs).

Computer Programmer Analyst

DOHMH – New York, NY - Feb 2015 to July 2017

Extracted data from either websites or email attachments, transformed data as per requested and loaded data to the data warehouse for reporting and research purposes.

Tested, debugged and optimized FoodSafty, NOAAWeatherDataDaily, MosquitoCBData, PollenCount and PsegPowerOutageData SSIS packages.

Tested, debugged and optimized the C# based NYCETrack complain-inspection system.

Designed and developed SSIS package to drop all constraints of NYCETrack database in the development server, load 100+ tables orderly to the staging server based on their dependencies and rebuild constraints.

Generated 10+ SSIS package diagrams, including NOAAWeatherDataDaily, FoodSafety, Mosquito and Pollen etc.

Updated NYCETrack Version 6.0 manual book and deployed to SharePort of the Department of Health and Mental Hygiene.

Collecting data from either intranet or email attachments, generating pdf and html files and sending emails to clients for different purposes.

SQL BI Developer

Anichem LLC – North Brunswick, NJ - May 2011 to Jan 2015

Planned, designed and developed SSIS packages for extracting data from different data sources, loading data to staging, applying transformations and then moving to Data Warehouse.

Created parameters and variables to hold dynamic data from FTP server (FTP task); Collected data from parameters and variables using Foreach Loop Container; Generated Data Flow Task to transfer data to different destinations; Further normalized data using Conditional Split, Derived Column or Lookup transforms; Sent reports of execution results and errors to clients using Execute SQL Task and Send Mail Task.

Designed SSIS package to manage DML (update, insert and delete) actions on source tables in SQL server using CDC control task and Data Flow Task; Collected data in the destination tables and recorded all behaviors in the archive tables.

Extracted data from SQL server, loaded data to Flat File or Raw File or Excel destinations and created dynamic folder/file names by using date time functions and string variables on File System task and Data Flow task.

Deployed SSIS packages to SQL Server and set up time-based dynamic execution plan using SQL Server Agent.

Set up checkpoints, breakpoints, logging and event handlers to track data flow and variables and record execution process.

Created Tablular, Matrix, List&Chart, Parameterized, Ad-hoc, Drill down and Drill through reports according to business requirements.

TRAININGS

Create Visualizations with Qlik Sense – VP Global Education Services, Nov, 2017

Data Modeling for Qlik Sense – VP Global Education Services, Nov, 2017

Implementing SQL Data Warehouse (20767C) – ONLC, Feb, 2018

Qlik Security & Administration – June, 2018

SKILLS

Language: SQL, T-SQL, Python, C# and Java

Tools: SSMS 2012/2014/2016, SSDT, Power BI Desktop/Web, TFS, Qlik Sense, SAS University Edition and SAP Crystal Reports 2013

EDUCATION

Ph.D. Chemistry

Case Western Reserve University - Cleveland, OH - 2002 to 2007

M.S. Chemical Statistical Mechanics

University of Science and Technology of China - Hefei, China - 1999 to 2002

B.S. Chemistry

University of Science and Technology of China - Hefei, China - 1994 to 1999

Contact this candidate