Data Analyst

STEPHEN ASAMOAH SAMPONG, MPH

Telephone: 209-***-****. Email: ***************@*****.***

PROFESSIONAL SUMMARY:

I have 8 years of experience in Analysis, Design, Coding, Testing, Migration, Production support and Implementation of Software applications and on Tableau Business Intelligence/Business Analytics software.

Solid experience of technical support in major financial and Health institutions.

Expertise in Tableau, MySQL, SQL, MS. Access, MS SQL server

Experienced on Tableau Admin activities and writing SQL queries.

Database Administrator, Proficient in Document Management Software MS Office, MS

Visio and Excellent knowledge of System Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).

SECURITY CLEARANCE- SECRET

EDUCATION

COLUMBIA UNIVERSITY, Mailman School of Public Health, New York May 2014

Master of Public Health in Epidemiology, Certificate in Infectious Disease Epidemiology

Course work included; Methods for Research Design and Evaluation, Applied Data Analysis, Application of Epidemiologic Research Methods/SAS, Analysis of Categorical Data, Infectious Disease Epidemiology, Public Health Surveillance

UNIVERSITY OF GHANA, Accra-Legon, Ghana May 2005

Bachelor of Arts in Political Science

SKILLS AND CERTIFICATIONS

DBW/BI Tools: Tableau Desktop 9.2.10.0,2018.2 Tableau Server, SQL, Alteryx, SSIS, SSRS

Database: SAS, DB2, MySQL, MS. Access, MS SQL server, SSAS, Oracle, Oracle Essbase, Teradata

Environment: Windows 2008, windows 2003, XP

CERTIFICATION

Collaborative Institutional Training Initiative (CITI) certificate

Health Insurance Portability Accountability Act (HIPAA) training certificate

Financial Conflicts of Interest and Research for PHS Researchers certificate

ssss

PROFESSIONAL EXPERIENCE

Tableau Developer, UnitedHealth Group, Minneapolis, MN June 2014 – Present

Builds interactive dashboard using Medicare and Medicaid claims data via Tableau Desktop

Generates Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau reports

Publish worksheet and dashboard onto Tableau Server

Develops, test, and deploy dashboards based on client’s requirements

Performs gap analysis on EBM and HCC groupers to ensure data quality and integrity for risk adjustment

Performs data validation on UTAH All Payer Claims Data (APCD) for development of new risk adjustment model

Connects tableau to Chronic Disease warehouse data (CCW) to create visualizations and dashboards

Virtual access to CMS Virtual Research Data Center (VRDC) and conducts analysis within the virtual environment.

Compare hospital readmission rates and cost through visualization with the aid tableau

Provides pragmatic support to The Centers for Medicare & Medicaid Services (CMS) in health care policy implementation

Syneos Health, Inc., Florham Park, New Jersey February 2012 – May 2014

Tableau Developer

Supported research studies conducted by the clinical trials data analytic team by creating worksheets and dashboards

Combined data from multiple clinical trials in one visualization

Created dashboard to display the entire performance of the various clinical trials clinical trial.

Recommended appropriate analytics to meet business objectives based on the study Protocol and monitoring plan

Pulled data from multiple sources, data validation and processing for analytics purpose

Built dashboards for all research studies using drug protocol and Comprehensive Metabolic Panel (CMP)

Clinical Data Analytics Optimization – by developing core analytics (combining multiple studies)

Contribute towards overall process optimization and metrics framework

Integrates SAS with Tableau to utilize visualization for predictive models

Data extraction from various data sources (SQL Server, SAS, Oracle, SharePoint, Spreadsheets, Access,)

Data Analyst, Kaiser Permanente – Pasadena, CA February 2010 – January 2012

Created summary tables, reports, figures and text for publication and presentation to professional

Wrote policy papers and memos, assisted in program budgeting

Performed data cleaning, data management, data entry and review for effective data analysis

Developed measurement instruments for the project and assisted with the preparation of documentation

Interpreted data to draw conclusions for managerial actions and strategy

Created data collection tools to house all information pertaining to the study

Participated in seminars, workshops, and/or outreach programs for both federal and private clients

Performed chi-square test for descriptive analysis and logistic regression using SAS statistical software (9.3 version)

Produced reports, presentations, and visualizations of surveillance data quality and disseminated to Community- Based Organizations (CBO)

Contact this candidate