Sign in

Data Sql

8820, United States
May 28, 2010

Contact this candidate
Sponsored by:
Post Jobs to
Multiple Job Boards &
Get more Candidates
Try it Free!
Start your 30-day
Free Trial

Harshavardhan Bhimanapati



. About 6 + years of professional experience of SAS programming in

Clinical, Biotechnological, Pharmaceutical and Software Industries.

. Experience in SAS BI components - SAS Data Integration Studio, SAS

Enterprise Guide, SAS Enterprise Miner, SAS OLAP Cube Studio, SAS Web

Report Studio, SAS Information Map Studio, SAS Information Delivery

Portal, SAS BI Dashboard, SAS Management Console and SAS Add-In for

Microsoft Office

. Experience in back-end database such as Oracle, MS-Access, SQL Server,

Teradata, and DB2 .

. Extensive Experience in SAS/BASE, SAS/STAT, SAS/MACROS, SAS/SQL,



. Extensive experience in SAS/REPORT generating procedures like PROC



. Good experience using SAS/GRAPH procedures, exclusively PROC GPLOT.

. Generated Reports, Tables, Listings, Graphs and Summaries as per

company standards and in compliance with 21 CFR Part 11, FDA, NDA and

other regulatory compliance.

. Interacted with senior Bio-statisticians and clinical data managers to

provide SAS programming in analyzing the data, generating reports,

tables, listings and graphs.

. Experience in SAS/ETL (Extraction,Transformation and Loading) with

Oracle/Access connectivity

. Worked on phase II, Phase III & phase IV Clinical Trials, performed

clinical data analysis and generated SAS datasets in accordance with

the SOPs and guidelines

. Experience in Integrated Summaries of Efficacy (ISE) and Safety (ISS)

according to Statistical Analysis Plan (SAP) and Protocol.

. Exposure to clinical trial data such as demographic data, Adverse

Events(AE), Serious Adverse Events(SAE), Laboratory data (Lab data)

and Vital Signs.

. Generated tables, listings, and graphs according to Statistical

Analysis Plan, Standard Operating Procedures (SOPs) and departmental


. Performed data extraction from Databases and Flat files. Conversion of

SAS Datasets to various file types (including Excel, PDF flat files).

. Generated Output files in RTF, HTML and PDF using SAS/ODS

. Expertise in Code of Federal Regulations (21 CFR PART 11)

. Good Experience in CDISC processes such as SDTM, ADaM, ODM

. Good experience in working with different PK/PD documents

. Strong working knowledge of FDA regulations, ICH Guidelines and GCP


. Ability to work on multiple tasks and strong interpersonal, analytical

and presentation skills.

. Excellent in analytical, presentation, communication and problem

solving skills and work independently as well as in a team




Enterprise Guide

SAS Procedures: Report, Print, Freq, Means, Summary, Univariate, Sql, Sort,

Transpose Contents, Options, Import, Export, Format, Anova, reg, Gplot,GLM,


Statistical Tools: SPSS, R, S-plus, Minitab, JMP,SPOT FIRE

Operating Systems: Windows 95/98/NT,XP 2000, UNIX.

Programming Languages: SQL, PL/SQL, MATLAB,BASIC C,ORACLE.




Bachelors in Pharmacy, India.


Certified Base SAS Programmer For SAS 9.


Millennium Pharmaceuticals, Cambridge, MA

Oct 09 - Present

SAS Programmer Analyst - Clinical Trials

Millennium Pharmaceuticals is a biopharmaceutical company developing

products designed to improve life of patients and is conducting Phase I to

Phase IV clinical trails, in wide range of viruses, bacteria and parasites,

and has demonstrated its ability to remove proteins, while preserving the

therapeutic properties. As a SAS programmer my role is in analysis of

Clinical trail data and generating required reports, listings and summaries

for submission to FDA.


. Performed SAS programming on SAS Base, Macro language. Used data

manipulation techniques, and statistical procedures (e.g., PROC



. Created SAS datasets to be used for the analysis programs.

. Extensively used SAS/ Macro facility to provide reusable programs that

can be conveniently used time to time.

. Modified UNIX scripting for SAS batch jobs in development.

. I have extensive experience in creating DEFINE.pdf formats in

submission of docs to FDA.

. Performed Data analysis, generated reports, listings and graphs using

SAS Tools - SAS/Base, SAS/Macros and SAS/Graph, SAS/SQL, SAS/Connect,


. Well versed in writing UNIX korn, bash shell scripts and scheduling

korn, at jobs for timely event trigger processes.

. Developed routine SAS Macros to create tables, graphs and listings for

inclusion in clinical study reports and regulatory submissions and

maintained existing ones.

. I have extensive experience in CDISC and SDTM.

. Experience in Integrated Summaries of Efficacy (ISE) and Safety (ISS)

according to Statistical Analysis Plan (SAP) and Protocol.

. I have Experience in Annotate CRFs in accordance with CDISC published

or sponsor specific guidelines with appropriate metadata to reflect

case report tabulation (CRT) data sets.

. Produced accurate, precise tables and graphs for Clinical Study

Reports by conducting, documenting and reporting computer validation

inspections in compliance with 21 Code of Federal Regulations (21CFR)

Part 11, FDA and other regulatory compliance.

. Generated tables, listings and reports of Adverse Events (AE) and

Serious Adverse Events (SAE) and was also involved in validating the

programs of integrated summaries of safety (ISS) and efficacy (ISE).

Environment: SAS 9, SAS/BASE, SAS/MACROS, SAS/SQL, SAS/STAT, Oracle8,

Oracle Clinical, Windows NT and UNIX.

American Century Investments, Kansas City, MO

Nov 08 - Sep 09

SAS Programmer

American Century Investments is a privately held investment management

firm. Their major criterion is to serve investment professionals,

institutions, corporations and individual investors. More than 40 percent

of American Century Investments' profits support research to help find

cures for the genetically-based diseases including cancer, diabetes and

dementia. I was involved in performing complex analysis on the data.

Roles and Responsibilities

. Used PROC SQL Pass-through facility and Oracle DB Load procedure for

data transfer

. Created SAS views from the tables in Oracle database using SAS/ACCESS.

. Involved in the data transfer and data conversion from one platform to

the other (SAS to Oracle, Oracle to Excel) and the obtained data was

used for further analysis.

. Extensively used statistical procedures like UNIVARIATE, SUMMARY,


. Modified existing SAS programs using SAS/MACROS to improve the

performance and enhance the data quality and developed numerous

decision support reports in a distributive environment for the

management department.

. Manipulated data by using MERGE, APPEND, CONCAT, SORT PROCs and

generated the reports.

. Generated graphs using PROC GPLOT through SAS/GRAPH and the SAS

Graphic Editor.

. Developed efficient, well-documented, comprehensible and modifiable

SAS code for ad-hoc jobs using SAS/BASE and SAS/Macro facility.

. Validated data by checking data distribution and by comparing it to a

standard data.

. Ran SAS report programs to generate weekly/monthly/annual reports and

exported the results to Excel for further analysis.


SAS/ACCESS, SQL, PL/SQL, Windows 2003.

Client :Deloitte

End Client:Dept. of Services - Virginia's Community Colleges, Richmond, VA

Title: Sr. SAS/SAS BI Developer.

Dec 07 - Oct 08

Project: Student Success Predictive Model

Virginia's community colleges ( have a 40-year track record of

educational excellence and innovation to serve the needs of the citizens

and strengthen the Commonwealth's economy. The mission of the Virginia

Community College System is to provide comprehensive higher education and

workforce training programs and services of superior quality that are

financially and geographically accessible and that meet individual,

business, and community needs of the Commonwealth. The Virginia Community

Colleges Policy Manual is a living document that guides the operation of

all community colleges in the Commonwealth. The Chancellor and State Board

for Community Colleges continuously approve changes to spur innovation and

maintain the highest standards of performance across the system.

Roles and Responsibilities:

. User Interaction, Analyzed the business requirements, written the

functional specifications, design, development, verification,

technical/user documentation, training, and mentoring

. Created the ER Diagrams with TOAD from oracle database

. Created the SAS Data marts from Oracle Data warehouse

. Performed the ETL by using the SAS Data Integration Studio

. Written the macros, used the PROC SQL Pass through Facility and

written the complex SQL queries

. Proficient in the maintenance and analysis of large data sets

. Developed the Predictive models with SAS Enterprise Miner to find the

Student success/risk

. Created the OLAP Cubes with dimensions, hierarchies and measures by

using the OLAP Cube Studio

. Created the Information Maps by using the Information Map Studio

. Created the static and parameter driven Reports by using the Web

Report Studio

. Published the Reports to the SAS Portals

. Written and registered the Stored processes, worked on front end

development using JSP, HTML, Javascript

. Analyzed, generated the ad-hoc and regular reports for various levels

of users

. Performed peer reviews of work items produced at various stages of the


. Developed Test plans, Test cases, Executed and documented the testing


Environment: Base SAS 9.1, Macros, SAS/STAT, SAS Data Integration Studio

3.4, SAS Enterprise Guide 4, SAS Enterprise Miner 5.2, SAS OLAP Cube Studio

3.1, SAS Information Map Studio 3.1, SAS Web Report Studio 3.1, SAS

Information Delivery Portal 2.0, SAS Management Console, SAS Add-In for

Microsoft Office, SAS Stored process, SQL, PL/SQL Developer, Oracle 10g,

VSS, Documentum, TOAD, FTP, SunOS 5.10 platform, Java, JSP, HTML,


Bristol-Myers Squibb Company, Princeton, NJ

Sep 06 - Nov 07

Sr. SAS Developer & Tester

Bristol-Myers Squibb ( is a global pharmaceutical and related

health care products company whose mission is to extend and enhance human

life. Bristol-Myers Squibb's 43,000 employees are dedicated to discovering,

developing and providing innovative medicines that address significant

medical needs of patients worldwide. And by living our mission and growing

our company for well over a century, we are also making a difference in the

lives of our shareholders, employees and neighbors.

Roles and Responsibilities

. Analyzed application requirements, provided recommended design and

created application from detailed specifications

. Developed and tested the Statistical Analysis and Reporting (SA&R)

Application in Unix environment

. Written the Stored processes, created detailed project outlines and

application design specifications

. Worked on front end development (GUI interfaces) by utilizing ODBC to

connect to the Open Architecture RDBMS (Relational Database Management

Systems) such as Oracle and Sybase

. Coded, tested, debugged, documented and maintained programs

. Used the PROC SQL Pass through Facility and written the complex SQL


. Quality reviews of code developed by other development staff

. Developed Test plans and Test cases, Executed and documented the

testing results

. Reviewed data to verify integrity and consistency for completeness,

accuracy and suitability, including data adherence to protocol, data

coding integrity, reliability of collection and interpretation

. Created SAS programs according to requirements specifications and

followed SOPs to produce accurate and timely results

. Maintained organized, complete and up-to-date study documentation,

testing and validation/quality control documents and programs in

compliance with company standards.

Environment: SAS 9.1, SAS Macros, SAS/ODS, SAS ETL, SAS Enterprise Guide,

SAS Enterprise Miner, SAS Stored process, SAS/Graph, SAS/STAT, SQL, Oracle,

UNIX - Sun Solaris, SQL, VSS, Documentum, FTP, Java, JSP, HTML.

Vertex Pharmaceuticals Inc, Coralville, IA

Jan 06 - Aug 06

SAS Programmer/Analyst

Vertex Pharmaceuticals main aim is to transform the way serious diseases

are treated. Vertex's drug discovery platform has been highly productive

and is the source of key product opportunities in infectious diseases,

cystic fibrosis, inflammatory disease, cancer and other areas.


. Worked closely with the research team of scientists to analyze the

data, generate the reports, and list them according to


. Involved in analyzing, writing clinical trial reports and presenting

clinical trial results.

. Generated the required SAS datasets from the database using sorting

and merging techniques.

. Performed Data conversions, Data corrections, Uploading/Downloading

the data.

. Developed and summarized clinical trials data using SAS/STAT

procedures such as PROC CORR,PROC REG, PROC ANOVA, PROC GLM and Data

step programming.

. Extensively used SAS procedures such as PRINT, REPORT, TABULATE, FREQ,

MEANS, SUMMARY and TRANSPOSE for producing ad-hoc, customized reports

and external files.

. Created Custom reports using DATA_NULL_ and PUT statements.

. Designed flowcharts indicating the input data sets and the techniques

that would be used (sorting, merging, etc) to get the desired output.

. Used SAS Macro functions to simplify the process and get consistent


. Using SAS/Macros, reports were updated on a monthly basis according to

the schedule.

. Used SAS/ODS to create HTML, RTF and PDF outputs files in the process

for producing reports.

. Developed the programs for generating Efficacy (ISE) and Safety (ISS)


. Based on the specification document created CDISC-SDTM SAS datasets

following all the standards.

. Involved in creating transport files as per the CDISC standards for

electronic submissions to the FDA.

. Worked with validation team to validate the applications in compliance

with 21 CFR Part 11 and other FDA mandatory regulations.

. Reviewed study Protocol, Annotated Case Report Form (ACRF), and

performed validation of clinical trial data to identify illogical data


. Involved in data transmission and integrity checking of the existing

and in-house clinical trial systems.

Environment: SAS V8.2, SAS/BASE, SAS/STAT, SAS/ODS, Oracle 8i, SQL, MS-

Excel, Windows 2000, UNIX (Solaris).

Dr.Reddy's Labs,Hyderabad, India

Jul 04 - Dec 05

Software Analyst

Dr.Reddy's Labs is a leading research-based pharmaceutical company with a

broad pharmaceutical product line and wide variety of vaccine products,

over-the-counter (OTC) medicines, oral care products and nutritional

healthcare drinks. As an analyst, performed relevant statistical analysis

of administrative and automated claims databases, surveys and economic

data, captured during clinical trials. Performed quality control (QC)

checks against database to ensure correct data was entered.

Roles and Responsibilities:

. Responsible for data collection, management and manipulation of

clinical database

. Performed statistical analysis, written SAS programs for data

management and reporting, and performed validation, including testing

SAS programs

. Downloaded data from Oracle using SQL within SAS to be analyzed and

exported to Excel for further analysis

. Compared consistency of SAS variables, formats, and format codes across

multiple studies

. Created standardized datasets from the existing datasets

. Created validation programs to validate the standardized datasets

. Produced quality customized reports using various procedures

Environment: Base SAS, SAS/ Macros, SAS/Access, Oracle, SQL

Sara Pharmaceuticals, Chennai, India

Nov 03 - Jun 04

SAS Programmer

Sara Pharmaceuticals are pioneers in manufacturing parental products. The

innovation, knowledge and experience accumulated in organization are

pivotal for getting safe and efficacious drugs.It is one of the reputed

Biopharmaceutical companies in India and is involved in developing new

sterile products, vials,ampoules and also parentral allopathic formulations

in injections


. Worked on phase II and phase III clinical trials

. Produced derived data sets, listings, tables for data analysis

. Worked with statisticians and data managers

. Used various BASE SAS procedures such as proc print, proc mean, proc

freq, proc report

. Used SAS/ACCESS to import and export data to and from MS Access and


. Responsible for choosing appropriate statistical techniques relevant

for the analysis of data

. Used SAS/GRAPH to generate figures as per Statistical Analysis Plan

. Developed SAS programs to validate the data and used different

validation techniques such as proc univariate, proc mean, and proc


. Export and import SAS datasets from and to excel



Contact this candidate