Data Sas

ANSHUL GANDHI (Masters in Biomedical Informatics, Certified SAS Programmer)

Email: *********@*****.*** Houston, TX Mobile: 832-***-****

Profile Summary

A Certified SAS Programmer with strong coding skills using various SAS tools and ability to analyze multiple, disparate data sources and applying various analytic techniques to identify growth opportunities, conduct root cause analysis on issues, forecasting the impact of macro factors etc. to drive growth. Well-developed understanding of target data mapping documents, data profiling, target transformation rules as applicable to multiple business domains.

Technical Qualifications Summary

Certified SAS Programmer with strong coding skills using various SAS tools (BASE, STAT, MACRO and SQL) & programming/analysis experience in SAS on windows environment

Experience in data analysis including segmentation, giving band, retention, post drug analysis, churn ratio and effectiveness analysis using SAS (Base SAS, Advanced SAS, Statistical Business Analysis and Enterprise Guide)

Strong SAS Programming experience in Healthcare industries.

Strong SAS programming background for creating, maintaining existing code, ad hoc reporting and supporting the reporting functions

Ability to perform data quality control and data management by optimizing SAS codes, updating data mart tables for analytics and reporting

Collaboration with the marketing department to develop marketing campaigns for customer acquisitions involving third part vendors, setting up internal IT systems and campaign data analytics

Expertise in using various SAS report generating procedures such as: Proc Format, Proc Sgplot, Proc Report, Proc Sgpanel, Proc Sgscatter, Proc Export, Proc SQL, Proc Univariate, Proc Freq, Proc Means, Proc Summary, Proc Tabulate, Proc Template, Proc Transpose, Proc Import, Data_Null and Proc Tabulate for customized report writing

Expertise in conducting multivariate analysis and developing regression models using Prog Logistic and Prog Reg. Proficient in dealing with multicollinearity and in-depth knowledge of variable reduction procedures such as Exploratory factor analysis and Principal Component analysis

Proficient with using various SAS statistical procedures such as Chi square, Contingency tables, Fisher test Proc ttest, Proc Anova, Proc GLM and Proc Corr

Understanding of CDISC standards, SDTM Domains and Adam Datasets

Experience in requirement gathering, analysis, planning, designing, coding and unit testing

Solid Understanding of Survival analysis for both parametric and non parametric models such as Proc Lifetest, Proc Phreg, Proc Lifereg

Experience in SAS to extract data from a variety of operational data sources

Experience in using SAS to read, write, import and export to another data file formats, including delimited files, Microsoft Excel and PDF

Additional experience includes using Procedures, Graph, Macros, Data Step and SQL, extracting internal/external data including cleaning and validation, use of formats and in formats

Experience in producing HTML, RTF, CSV and PDF formatted files using SAS/ODS

Experience in SAS/BASE, SAS/SQL, SAS/MACROS, SAS/GRAPH, SAS/Business Analysis

Experience in developing complex SAS programs, macros for data updates, data cleansing, and reporting

Ability to effectively manage multiple activities of varying complexity while under time constraints

Job Related Skill Set

Base SAS * SAS-SQL *SQL Joins*SQL SET operators** SAS Data sets*SAS Functions*Regression Models*SAS Programming* SAS System Reporting*Advance SAS techniques * SAS Macros * SAS STAT*SAS Graph* Data cleansing * Adam Datasets* SDTM Domains*Information analysis *Validating and Cleaning Data*Producing Summary Reports *Debugging techniques*Arrays* Process Improvement * Data Scraping *Table Listing & Figures* Training manuals * Data Management * ODS * Requirement Gathering * Data Analytics * Data Sources

Education, Certifications & Affiliations

MS in Biomedical Informatics, The University of Texas Health Science Center at Houston, 2018

Bachelors of Dental Surgery, MM College of Dental Sciences and Research, 2014

SAS Certified Base Programmer for SAS 9

Pursuing other SAS Certification/s: SAS Certified Advanced programming for SAS9 and SAS Certified Statistical Business Analyst using SAS 9

Work Experience

The University of Texas Health Science Center at Houston

Graduate Research Assistant

Project: Alcohol abuse descriptions September 2016 - Present

in EHR with alcohol related outcomes

Accomplishments

Performed data analysis and reporting in SAS after extracting complex data from multiple sources, such as raw data file, delimited, fixed text, Access and Excel spread sheets into SAS data sets by applying INFILE, INPUT, LIBNAME, PROC IMPORT and MACRO

Collaborated with Sr. Data Scientists to develop interactive visual dashboards, including integration of various data sources, data model creation, design, etc

Performing Data Sanity Check, data cleansing and variable reduction procedures

De-identify and annotate UT Physicians free text data to identify indirect markers of alcohol abuse and previously identified health outcomes

Build a natural language processing (NLP) system to extract the alcohol markers and health outcomes

Conduct Statistical analysis of extracted data to determine unreported alcohol abuse by patients using Chi Square Anova and Fischer test after utilizing principal component analysis and removing multicollnearity

Validating the data population as per the data mappings and the business requirements as well

Analyzed data using SAS/BASE Analysis Procedures, Pivot Tables & Charts

Identified automation opportunities using SAS debugging techniques in SAS Macro and SAS SQL with in the business to reduce TAT, increase quality and mitigate risk

Developed an understanding of data in the DW to identify data patterns to support adhoc report requests from business

Sub setting dataset using set, merge, sort, update and conditional statements

Performed integration of datasets and report generation

Created weekly and monthly reports using Base SAS, Macros and SQL

Performing different parametric and nonparametric utilizing SAS, conducting multivariate analysis and developing logistic regression models

Annotating data related to patient-specific questions for electronic health records

Skills Used

SAS 9.0, SAS Programming, SAS Enterprise Guide, Clinical trials, SDTM, Adam datasets, SDTM Implementation guide, Data Mining, Proc SQL, SQL, Microsoft SQL Server 2016, Tableau, Microsoft Excel, Microsoft Power point, Microsoft Visio

Sankhyana Consultancy Services

Statistical Programmer Analyst February 2016 to August 2016

Client/s: Tristar Retail & MTN

Project: Consumer Data Insights

Accomplishments

Gauge awareness, usage, preference, interest, repeat usage of various types of generic/broad range of technology products and underlying motivations for usage

Profile the nation’s mobile phone subscribers on technology adoption and readiness curve and establish opportunities to engage and grow them along the various stages and phases of the market evolution

Understand consumer data usage patterns and existing correlations with types of devices (dongle, Wi-Fi routers, tablets, smart phones, Blackberry, 3G devices and other ultra-low cost feature phones)

Detailed Analysis of Market readiness and market competitiveness: offerings and operators

In depth analysis of device trends, MTN’s market position in the data space and data market growth indices in Nigeria

Insight into MTN data users by extrapolating real behavior with lifestyle profile into 10 behavioral segments using principal component and association rules/market based to demarcate the inflection point (smart phone vs feature phone) in Nigeria

Developing logistic regression model to look at the Optimization point for data revenue measured through voice revenue as predictor

Gain insight into share of data market, usage drivers both for Mobile and Widescreen segments

Detailed analysis of impact of online advertising on the shopping behavior of the users.

Technographic Segmentation into Tech abstainers, Tech optimizers, Simple users, Digital Connectors and status seekers

Establish various degrees of marketing interventions that can be developed to maximize value across the various techno-segments such as MTN Talk Face2Face, MTNEasyInternet, MTN Unlimited Nollywood, MTN Magic Fingers, MTN Super Student

Performed various tasks using SAS, Excel and Word, Outlook experience including table design, and writing queries, forms, PDF conversion using SAS ODS

Reviewed Logical Data Model to understand the target data structure

Created, Updated and Maintained business source to target mapping on various complex projects

Collected, analyzed and interpreted business requirements, translated them into technical specifications

Analyzed data using SAS/BASE Analysis Procedures, Pivot Tables & Charts

Experience in manipulating and analyzing large marketing data

Created new data files using import techniques and modified existing data sets

Created weekly and monthly reports using Base SAS, Macros and SQL

Worked with diverse databases like MSSQL Server, SAS Import and Export

Partnered with OPS team at each stage of process automation using SAS MACROS

Identified automation opportunities using SAS debugging techniques in SAS Macro and SAS SQL with in the business to reduce TAT, increase quality and mitigate risk

Preparation of automation requirement document and get signed off by ops and training team

Skills Used

SAS 9.0, SAS Programming, Proc SQL, SAS/ STAT, SAS/GRAPH, SAS Enterprise Miner, ICD 10, SPSS, Data scrubbing, Data Mining, SQL, Microsoft SQL Server 2016, Tableau, Microsoft Excel, Jira

Sovereign Health of India

Data Analyst March 2014 – January 2016

Accomplishments

Performed business information analysis and reporting in SAS

Development and maintenance of productive working relationships with project sponsors, stakeholders and key systems users

Data analysis with claims data and clinical data using SAS for all portfolios including data extraction, conversion, cleaning and merging. Design, construct, deploy, test and support standard reports, dashboards, self-service queries and data visualizations

Collaborated with Sr. Data analysts to develop interactive visual dashboards, including integration of various data sources, data model creation, design, etc

Extracted complex data from multiple sources, such as raw data file, delimited, fixed text, Access and Excel spread sheets into SAS data sets by applying INFILE, INPUT, LIBNAME, PROC IMPORT and MACRO

Developed an understanding of customer segmentation/retention analysis

Use advanced SAS skills to transform and link data from the repository

Collaborated with BA’s, BI Architect and others to understand the business requirements and business rules

Developed an understanding of business needs and translated them into meaningful KPIs and automated reports

Interacted with client’s reps and analytical stakeholders to gather and define business requirements for developing tools, obtaining data and performing analysis

Performed data cleansing and validation using SAS procedures Proc Sort, If Then Else and Where statements

Identified scope for using SAS Macro automation to automate reports

Performed analysis using SAS reporting procedure like Freq, Means & Univariate

Maintain Strength in business systems analysis, research and project development

Skills Used

SAS 9.0, SAS Programming, SAS Enterprise Miner, SAS/ STAT, SAS/GRAPH, ICD 10, NextGen, Medisoft, Data scrubbing, Data Mining, Statistical Analysis, SAS/ODS, SAS/Macro, SQL, Microsoft SQL Server 2016, Tableau, Microsoft Excel, Jira

Other

Relocation: Yes. Anywhere in US

References: Available upon request

Contact this candidate