Sql Server Data Analyst

HUI WANG

**** ****** ***** **, **********, NC ***10 · 617-***-**** · ***********@*****.***

SUMMARY

• Epic Certified Specialist on Clarity, Caboodle and Cogito.

• Microsoft Certified Solutions Associate (SQL Server 2012/2014)

• SAS Certified Specialist

• 8 years’ experience as professional data analyst engage in requirement analysis, design and implementation in healthcare companies.

• 8 years of experience in MS SQL Server 2008/2012/2014, strong ability in programming with SQL, writing queries and developing stored procedures, complex join, user defined functions and views.

• 8 years of experience in data visualization using SAP Crystal Report, Tableau, Power BI and SSRS.

• Proficient in the use of SSIS to import/export data from different homo- and heterogeneous sources including SQl Server, Oracle, MySQL, Access, EXCEL, Flat file and XML files

• Coding experience in VBA, Python, and R

• Familiar with the cloud environment (Office 365, Azure, VMware), Knowledge of Big Data and NoSQL (Hadoop, Spark, Storm, Hive, Hbase, Mongodb)

• Knowledge of healthcare industry standards and regulations, such as HIPAA

• Experience with Oracle databases and healthcare software applications

• Strong team player with great verbal, written communication and interpersonal skills. SKILLS

• Data extraction from Epic Clarity and Caboodle widely used in healthcare companies

• SQL language: MS-SQL, PL-SQL, MySQL

• Statistical Package: SAS, Python, R.

• ETL Package: SSIS, Pentaho, Informatica

• Reporting Package: SAP Crystal Report, Power BI, Tableau, SSRS

• PowerShell scripting and automation

• Linux/Unix: Redhat, Centos

• AWS, Azure,Snowflake

WORKING EXPERIENCE

Atrium Health Wake Forest Baptist

Senior Programming Analyst

Winston/Salem Oct 2021 - now

• Worked closely with doctors and medical researchers to collect requirements, wrote SQL scripts to retrieve EHR data from Epic Clarity and Caboodle, diagnosed data problems and fixed scripts to correct the data problems.

• Collected and transferred data from PopMedNet to CCW (Chronic Condition Data Warehouse)

• Submit and chart-review data of RECOVER (Researching COVID to Enhance Recovery)

• Provided support for I2B2 (a query tool that allows investigators to query clinical data in the Translational Data Warehouse for cohort identification and pull detailed data for research projects).

• Found data issues of I2B2 by visualization of Tableau and correct them.

• Migrated data from external data source by calling API in Jupiter.

• Wrote and ran queries with SAS EG for collaborating.

• Knowledge of medical coding concepts like CPT, LOINCs, SNOMED and ICD-10 Labcorp

Data Scientist

Winston/Salem, NC Oct 2017 - Oct 2021

• SQL development from different data sources (Db2, Oracle, MS sql server, SAS, txt, CSV, MS EXCEL and Access), diagnosed data problems and fixed scripts to correct the data problems.

• Design and implementation of SSIS/ETL process for the system.

• Created interactive dashboard and report using Business Intelligence tools (Power BI, SSRS Tableau, SAP Crystal Report) for presentation at department meeting.

• Relational model Database support (design, modification, updating, tuning and trouble shooting).

• Designed and transferred SQL scripts with SAS EG for team members, work with DBA to optimize the performance of SQL scripts.

• Created VBA in EXCEL and ACCESS to turn complex or time-consuming tasks into automated processes.

• Query/monitor/analyze of Revenue Cycle Management and Direct Billing Merck

Data Scientist

Rocky mount, NC Data Scientist May 2015 - Oct 2017

• Migrated data from Heterogeneous data Sources and legacy system (DB2, Access, EXCEL) to centralized SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformations constraints.

• Data query and analysis with SAS, R and Python.

• Generated weekly and monthly report with SAP crystal report, Power BI and MS Access.

• Troubleshooting and writing stored procedures, triggers, Functions, views and make changes to the code. North Carolina A&T University

Senior Analyst

Greensboro, NC Jun 2012 - Dec 2014

• Data collection, data cleaning, data statistics and data visualization with EXCEL, R and Matlab.

• Converted, loaded and integrated data from Access, EXCEL, text, CSV files and internal database applications.

• Generated reports for the department using SAP crystal Report and MS Access

• Experience in Trouble Shooting, Performance tuning and resolving issues within Tableau Server and Reports.

• Created interactive dashboard and applied actions using parameters, sets, groups and calculations. Harvard University

Senior Analyst

Boston, MA Apr 2007 - Apr 2012

• Created and maintained a MS SQL database for projects funded by USDA.

• Data collection, data cleaning and data statistics with EXCEL, R and Matlab.

• Data visualization and presentation with R, EXCEL and Access

• Created report with SAP Crystal Report and Access. CERTIFICATION

• EPIC Caboodle Data Model, EPIC Clarity Data Model, Epic Cogito, Issued at May 2023.

• MCSA (SQL Server 2012/2014) Credential ID (17497173)

• SAS Certified Specialist: Base Programming Using SAS 9.4

• R Programming for Data Mining

• Data Scientist Tool Box

• Advanced Microsoft EXCEL Training Course

EDUCATION

• Master's degree, Information system management, University of North Carolina at Greensboro, 2020-2022 2

Contact this candidate