Data Project

SAS PROGRAMMER / ANALYST

HARI CHANDANA Email:****************@*****.*** Mobile No: +91-784*******

Objective:

To achieve a Challenging position as SAS Programmer/Analyst in a result-oriented company, where acquired skills and education will be utilized towards continual growth and advancement.

Professional work summary:

Having 3 years and 1month experience and strong knowledge in Clinical data analysis: analyzing clinical data, creating tables, listing and generating reports and summaries as per company standards, as per client’s specifications.

More experience in Data Extraction from varying sources, data manipulation and cleansing, Data analysis, Report development using SAS/Base, SAS/Access, SAS/SQL SAS/Macros, SAS/Stat, SAS/Graph, SAS/ODS and implementing of various applications in SAS.

Well known work experience in SAS/Base mainly in all types functions and in data management like SAS DATA step statements including Set, Merging, Appending, Concatenating, Interleaving, Formats, Informats .

Expertise in importing of data from access files by using SAS/Access and from excel files by using SAS/Excel procedure into sas and exporting data from sas to PC files.

Experience in producing external files and reports employing various SAS/ SQL Procedures like Proc Print, Proc Report, Proc Summary, Proc Freq, Proc Mean, Proc Tabulate.

More efficient knowledge in Proc Transpose, Proc Append, Proc Sort, Proc Format, Proc SQL procedures.

Expertise in generating and customization of Graphs, Charts and Plots by SAS/Graphs.

Good experience in SAS/Stat mainly in statistical analysis process like Proc Univariate, Proc Anova, Proc Glm, Testing of deviation by using t-test procedure, Testing of relationship by using Correlation procedure.

Knowledge of using SAS/ODS to generate customized reports and dynamic reports in multiple formats (HTML, PDF, RTF etc.).

Skilled in developing, modifying and maintaining SAS/Macros.

Good exposure in importing and exporting raw data from / to different file formats.

Knowledge in accessing data into SAS and experience with large data sets.

Execute analyses specified in the Statistical Analysis Plan (SAP) under the guidance of the project statistician.

Ability to learn and adapt new technologies quickly. Analytical and problem solving skills.

Excellent collaborative skills and the ability to manage complexity and change in a dynamic environment.

Educational Qualification:

2009 B.C.A Acharya Nagarjuna University

2011 M.B.A Alagappa university

Technical Skills:

• SAS tools : SAS/BASE, SAS/ACCESS, SAS/SQL, SAS/MACROS, SAS/GRAPH,

SAS/STAT, SAS/ODS.

• SAS procedures : SORT, TRANSPOSE, FORMAT, FREQ, UNIVARIATE, REPORT,

MEANS, SQL, COMPARE, TABULATE, APPEND, PRINT, ANNOVA,

GLM, T-TEST, CORRELATE.

• Operating Systems : DOS, Windows 95/98, Windows XP.

• Data Base : Oracle.

• Miscellaneous : Microsoft Office (Excel, Word & Access).

Project #3:

CLINICAL TRIAL DATA ANALYSIS ON TYPEII DIABATIES:

CLIENT : HETERO DRUGS.

ROLE : SAS Programmer.

DURATION : Mar 2011- till date.

TITLE:

Multicenter, randomization, double blind, tolerate drug response to determine safety and efficacy of Metformin and Benfotiamine to control Type2 diabetes across 220 sample size in 1:1 ratio Compared to placebo at 85% confidence intervals.

DESCRIPTION:

Developed model SAS data files for Clinical Trial Team using SAS in PC environment. This project involved statistical modeling of Metformin and Benfotiamine to control Type2 diabetes disease effectiveness data and analysis for the identification of high effectiveness concentrations. The objective of this project was to identify statistically significant range of drug compositions to enable the Clinical Research team in handling huge amount of data.

The data from the case report forms (CRF’s) those are provided by the client are entered into Access. Importing of data, creation of datasets, cleaning, validation are done using SAS/BASE Data step Procedures. The Statistical Procedures were applied as per the protocols provided by the Bio-Statistician. Graphical representation and report (in PDF and HTML format) generation had been done. Worked with a team comprising of Bio-statistician and clinical research associates those are responsible for data analysis and report generation.

RESPONSIBILITIES:

Access derived datasets from the server which are converted according to SDTMIG specifications and created SAS data sets that are required for the project analysis.

Run data Cleaning, validating, sorting and merging techniques is done using SAS/Base include Macros and SQL operations as per analysis.

Create analysis datasets from combination of derived datasets as per SAP and SOP Standards.

Generate reports Involved in Delivering output using ODS in listings and tables from safety data (DM, LAB, and AE, VT) according to Guidance of SAP document.

Compile reports as per template which is given by clients.

Generate report as per adhoc queries.

Prepare documents for submission according to client.

APPLICATIONS:

Data _null_, merge, string functions, sql, set statement, proc sort, Proc transpose, proc format, proc freq, proc means, proc report And macros.

TOOLS:

SAS 9.1 & SAS 9.2.

Project #2:

CLINICAL TRIAL DATA ANALYSIS:

CLIENT : HETERO DRUGS.

ROLE : SAS Programmer.

DURATION : May 2010 – Feb 2011 (10 Months).

TITLE:

Multicenter, randomization, Open Labeled, Effective drug response to determine safety and efficacy of a skin diseased drug Calcitriol to control Psoriasis problems across 120 sample size in 1:1 ratio Compared to placebo at 95% confidence intervals.

DESCRIPTION:

Developed model SAS data files for Clinical Trial Team using SAS in PC environment. This project involved statistical modeling of skin disease drug i.e Calcitriol for Psoriasis disease effectiveness data and analysis for the identification of high effectiveness concentrations. The objective of this project was to identify statistically significant range of drug compositions to enable the Clinical Research team in handling huge amount of data.

The data from the case report forms (CRF’s) those are provided by the client are entered into Access. Importing of data, creation of datasets, cleaning, validation are done using SAS/BASE Data step Procedures. The Statistical Procedures were applied as per the protocols provided by the Bio-Statistician. Graphical representation and report (in PDF and HTML format) generation had been done. Worked with a team comprising of Bio-statistician and clinical research associates those are responsible for data analysis and report generation.

RESPONSIBILITIES:

Access derived datasets from the server which are converted according to SDTMIG specifications and created SAS data sets that are required for the project analysis.

Run data Cleaning, validating, sorting and merging techniques is done using SAS/Base include Macros and SQL operations as per analysis.

Create analysis datasets from combination of derived datasets as per SAP and SOP Standards.

Generate reports Involved in Delivering output using ODS in listings and tables from safety data (DM, LAB, and AE, VT) according to Guidance of SAP document.

Compile reports as per template which is given by clients.

Generate report as per adhoc queries.

Prepare documents for submission according to client.

APPLICATIONS:

Data _null_, merge, string functions, sql, set statement, proc sort, Proc transpose, proc format, proc freq, proc means, proc report And macros.

TOOLS:

SAS 9.1 & SAS 9.2.

Project # 1:

HEALTH CARE INSURANCE:

Client Aviva Life Insurance

Environment SAS/BASE, SAS/MACROS.

Duration Mar 2009 – April 2010

Role SAS Programmer

Project Description:

Aviva India is a joint venture between one of the country’s oldest and largest groups, Dabur, and Aviva plc, the UK's largest insurance group, whose association with India dates back to 1834. With a strong sales force of over 20,000 Financial Planning Advisers (FPAs), we have initiated and pioneered many innovative sales approaches, including the concept of Banc assurance and Financial Health Check services

Project Details:

Market Research has been conducted to find the number of people with Health insurance coverage and without Health insurance coverage, based on real median household income, female and male earning ratio, poverty rate, race, place, age, gender etc. And design new competitive insurance products. Our job is to extract data from source, transform and prepare data sets for analysis. Generate reports as per the requirement.

Roles and Responsibilities:

• Extract data from oracle database using SAS/Access.

• Cleaning data sets using data step and SAS Base procedures.

• Prepare data sets as per the requirement.

• Generate Reports, using Proc Report and Proc Tabulate.

• Generate graphs & tables and export them using ODS.

(G.HARI CHANDANA)

Contact this candidate