SAS, SQL

Beneet Kumar Pandey

**** * ******* *** *********, WI, 53211

Cell: 805-***-****

Email: - ************@*****.***

********@***.***

Career Profile:

To obtain a challenging position of SAS Programmer where I can put in use the best of my knowledge and experience of SAS programming for the growth of the organization.

Summary of Skills:

Dynamic and Result-oriented SAS Programmer with more than 5 years of SAS programming experience covering all aspects of SAS processes – analysis, design, testing and validating, including advanced statistical methodologies applied in Healthcare and Biotech industries (Clinical Environment).

In-depth knowledge of SAS programming, data processing, data collection, quantitative and qualitative data analysis, design of experiments, as well as creating SAS datasets, macro definitions, debugging programs, and documentation.

Experience in debugging and testing SAS programs to check and process data, generate graphs, tables and listings in analysis system.

Experience in creating database, tables, indexes, complex queries, stored procedures, views, user defined functions, complex joins using MS SQL Server 2008

Ability to work efficiently in both independent and team environments, worked with Project Managers, Team Members / Associates, Statisticians, Business Analysts.

Strong Problem Analysis & Resolution skills and ability to work in Multi-Platform Environments like Windows and Linux.

Familiar with HIPPA and ICH/GCP guidelines and requirements.

Project Management and Implementation

Database Design and Management

Relationship Management

MS BI Programming

SAS Data Warehouse Programming

Various Clinical Information Systems

Statistical Documentation and Consolidation

Tools and Technologies:

SAS Tools:

SAS/Base SAS/Graph SAS/SQL SAS/MACRO SAS/Access SAS/ODS SAS/Report

BI Tools:

SSRS SAS DI SAS BI SAS Management Console SAS Information Map SAS WRS

Programming:

Python JAVA/J2EE NLTK 3.0

Database:

IBM DB2 SQL Server 2008 PL/SQL MS Access

Operating Systems:

UNIX WINDOWS XP/1998/2000/7

Web Technologies:

HTML Java Script

Programs:

Microsoft Office Suite (Word, Excel, PowerPoint, Access and Outlook)

Educational Qualification:

Bachelor's Degree in Bioinformatics, Amity University - 2009

Master’s Degree in Clinical Research and Regulatory Affairs from Sikkim Manipal University - 2011 Master’s Degree in Healthcare Informatics from University of Wisconsin-Milwaukee-2016

Professional Experience:

1.Postgraduate Research Intern

Aurora Health Care (June 2015 to May 2016)

Projects:

Sleep Disorder and Cardiovascular Outcomes

Arrhythmogenic Mitral Valve Prolapse: Identification of Subjects at High risk of Sudden Cardiac Death (SCD)

Identifying patients with prolonged QT interval within Aurora Health Care system from an electrocardiographic recording database (MUSE).

Impact of low iron stores on clinical outcomes of patients with advanced heart failure undergoing Left Ventricular Assist Device (LVAD) implantation and cardiac transplant.

Impact of anemia on clinical outcomes of patients with obstructive sleep apnea.

Tasks and Responsibilities

Developed sleep disorder database and studying the effect of disturbed sleep due to restless legs syndrome, obstructive sleep apnea and other sleep disorders on adverse cardiovascular outcomes at Aurora St. Luke’s Medical Center.

Designed and developed project-specific SAS and SQL programs for data cleaning, merging, and producing analysis datasets, graphics and reports

Provided statistical analysis and reporting support

Designed data collection methods for projects using t-SQL

Fetched data from the connected systems (Epic, MUSE, Prucka, Prosolv, SomnoStar, MS SQL Server) using python, SAS, and t-SQL

Attended client and team meetings as required

Worked closely with the PI (Dr. Jahangir) and Biostatistician (Dr. Olet) to complete data analysis for presentations at National and International meetings and publications.

2.Project Assistant - SAS Programmer (May 2015 to May 2016)

Zilber School of Public Health (University of Wisconsin – Milwaukee)

Project: Young Women’s Health History Study (YWHHS)

This is a case control study to find ways to reduce the risk of breast cancer in young women

Worked as a graduate assistant in Young Women’s Health History Study (YWHHS) project

My role was data extraction, manipulating, cleaning, data sets preparation for reporting using SAS and SQL

Created SAS MACROs for automation of customized reports

Created reports to monitor study progress using SAS and MS SSRS

Environment: SAS, SQL Server, REDCAP, CAFÉ, JAVA

Project Link: http://www.epi.msu.edu/ywhhs/

3.Programmer, College of Health Sciences (Sep 2014 to May 2015)

University of Wisconsin – Milwaukee

Wrote python scripts for Biomedical Information Extraction from Penn Discourse Tree Bank

Worked on Natural Language Processing, Python NLTK 3.0, Java, and Annotation tools

4.SAS Analyst (Dec 2011 to July 2014) - Vayam Technologies, India

Project: NRHM Health Statistics Information Portal, Ministry of Health (Government of INDIA)

Created complex and reusable Macros and developed SAS programs for Data Cleaning, Validation, Analysis and Report generation.

Extracted raw data from a SQL Server database and used SAS/SQL to read it and SAS ETL tool to pull the data from live server to staging server for generating different kinds of reports.

Exercised advanced queries using SAS Enterprise Guide, calculating computed columns, using filter, manipulate and prepare data for Reporting, Graphing, and Summarization, statistical analysis, generating SAS datasets.

Optimized T-SQL scripts/procedures used to feed reports and implemented ETL logic for faster loading and processing.

I was responsible for DI studio such as SCD type-2 loader, table loader, extractor, append, SQL joins, transpose, surrogate key generator, Proc SQL (User defined) to write customize code.

Project Link: https://nrhm-mis.nic.in/SitePages/Home.aspx

Project: Integrated Data Management System (IDMS)

Supported to clients to resolve problems in the IBM Content Analytics, Reporting and Custom Search portal.

Handled DB2 Database for 50 million records. Analyzed unstructured information to derive new trends and patterns in a shorter time.

Publications:

1.Zoe Heis; Beneet Pandey; Susan Olet; Samian Sulaiman; Saagar Pamulapati; Mary Meyer; Lynda Daley Barsch; Michael N. Katzoff; A. Jamil Tajik; Arshad Jahangir. GENDER DIFFERENCES IN RISK OF STROKE IN PATIENTS WITH RESTLESS LEGS SYNDROME J Am Coll Cardiol. 2016;67(13_S):2024-2024.

doi: 10.1016/S0735-1097(16)32025-3

Presented at: The Annual Scientific Sessions of the American College of Cardiology in Chicago, April 2016; and The Joint Sessions of the International Society for Restless Legs Syndrome and the European Society of RLS, Monterey, California October, 2015.

2.Mamman S, Weissert J, Pandey BK, et al. Sa1496 Longitudinal demographic trends of nationwide gastrointestinal-related emergency department visits. Gastrointestinal Endoscopy. 2015;81(5):AB238.

http://www.giejournal.org/article/S0016-5107(15)01556-4/fulltext

References

1.Dr. Arshad Jahangir, MD

Director for the Center for Integrative Research on Cardiovascular Aging (CIRCA)

Aurora Research Institute, Aurora Health Care

Email: ******.********@******.***

Phone: 414-***-****

2.Dr. Ellen Velie

Professor, Epidemiology, School Of Public Health

Email: *****@***.***

Phone: 414-***-****

3.Ankur Gupta

Lead DBA at CNO Financial Group

Email: *****.*********@*****.***

Phone: +1-484-***-****

Contact this candidate