[pic]

SIRISHA M.RAMALA

abg7eh@r.postjobfree.com

813-***-****

Summary:

. SAS Certified base programmer for SAS 9 with around 6 years of I.T

experience with 2yrs in Direct marketing Analysis.

. Strong emphasis Clinical Research and Analysis, Design, Development,

Testing and Implementation of Clinical Trial projects in Healthcare,

Pharmaceutical, Biotech and Medical Device Industries.

. Accessing multiple databases using SAS and provide ongoing reporting

in support of information-based decision making, measure the execution

of marketing strategies.

. Extensive knowledge of SAS Clinical Trials for over 4 years and

involved in all four Phases of the Clinical Trials in various

Therapeutics areas - Cardio-Vascular, Endocrine, Oncology and

Orthopedic trials.

. Experience in Base SAS, SAS/Macros, SAS/ACCESS, SAS/ASSIST,

SAS/CONNECT, SAS/GRAPH and SAS/STAT, SAS/AF in Unix and Windows

environments.

. Possesses strong statistical concepts.

. Worked with Statisticians to provide SAS programming in analyzing the

Clinical Trial Data, generate reports, tables, listings and graphs.

. Database Creation and Table Programming for Safety (ISS) and

Integrated Summaries of Efficacy modification as well as consistency

of results. (ISE).

. Experience in all statistical aspects of clinical trials: experimental

design, selection of appropriate statistical methodology,protocol

review, data analysis and summarization and reporting.

. Excellent communication skills, ability to work in a team or

independently and is highly motivated.

Technical Skills:

SAS Tools: SAS9, SAS/BASE, SAS/MACROS, SAS/STAT, SAS/GRAPH,

SAS/SQL, SAS/AF, SAS/Access, SAS/CONNECT, SAS/ODS,

SAS/QC.

SAS Procs Print, Means, Univariate, Correlation, Regression,

SQL, Tabulate, Freq, Sort, Summary, Format, Import,

Export, Transpose, Plot, Compare, Life Test, Gplot

Languages: SAS,SPSS, SQL, PL/SQL, HTML, DHTML, C, Java, Perl &

CGI

GUI/Tools: Developer 2000, SQL*Plus

Database: Oracle, SQL Server and MS Access.

Operating Windows 95, Windows 2000, Windows NT, Windows

System: Vista,MS DOS, Unix

Office tools: MS-OFFICE 2000, Word, Excel, ACCESS

EXPERIENCE:

Hawk-I-Technologies IA:

April 2010-present.

Analyst:

Roles and Responsibilities:

. Wrote SQL queries, SAS procedures, Macros to ensure database

integrity,Access multiple databases using SAS and provide ongoing

reporting in support of information- based decision making, measure

the execution of marketing strategies and identify opportunities for

improvement to existing processes.

. Develop, test and maintain daily/monthly/quarterly report packages

that depict progress towards meeting the clients strategic objectives

(adhoc reports).

. Worked with batch jobs and validated the reports.

. Participated in System, Regression and Acceptance Testing.

. Involved in writing Test Plans, Test Cases and Test Scripts.

. Regular interface with account managers and analysts to determine,

interpret and program solutions to the information needs of the

client.

. Define requirements and timelines to ensure the timely and accurate

delivery of data elements required for analytic projects.

. Investigate and define system capabilities, evaluate current and

potential system technology use/needs for performance. Document

policies and procedures required to support system enhancements

Environment: Internet Explorer,windows vista,ToadTest Tools: WinRunner6.0,

Test Director 6.0, UNIX, SAS9.2, SQL.

Kobie Marketing

Dec 2008- Mar2010

St pete florida

Marketing Analyst

Develop, test and maintain daily/monthly/quarterly report packages that

depict progress towards meeting the clients strategic objectives.

Regular interface with account managers and analysts to determine,

interpret and program solutions to the information needs of the client.

Partner with IT to define requirements and timelines to ensure the timely

and accurate delivery of data elements required for analytic projects.

Investigate and define system capabilities, evaluate current and potential

system technology use/needs for performance. Document policies and

procedures required to support system enhancements.

Access multiple databases using SAS and provide ongoing reporting in

support of information-based decision making, measure the execution of

marketing strategies and identify opportunities for improvement to existing

processes using Macros.

Converted ORACLE data tables into SAS data files using SAS SQL and uploaded

SAS data files into ORACLE tables using SAS DBLOAD procedure.

Developed numerous adhoc SAS programs to create summaries and listings.

Developed SAS programs using Base SAS for tabulation counts, correlations

and check for dispersion for normality, sorting and merging data

validations using PROC Means, PROC Tabulate and PROC Univariate.

Created a SAS customized reports using the Data _Null_ technique for FDA

regulations.

Converted oracle data tables into SAS data files using SAS/SQL and uploaded

SAS data files into oracle tables.

Environment: SAS for Windows 9.2, SAS/ACCESS, SAS/BASE, SAS/STAT, SAS/ODS,

SAS/SQL, SAS/GRAPH, MS-Excel, PL/SQL, Oracle 8.0, HTML and Windows vista.

Configer,Brookline, MA

OCT2006- 2008 Nov

SAS Programmer - Clinical Trials

Clinical Trials are conducted to study the effect of new medicine in the

treatment of cancer disease. This study was a double blind randomized,

multi-dose studies conducted in two groups of patients i.e., One in

patient's with metastatic Cancer disease and one in patient's with hormone

refractory prostate cancer. The trial was initially conducted on a total of

46 chemotherapy patients with metastatic disease. The Study medicine was

given in a regimen of four monthly intravenous infusions of 3.0 mg/kg alone

or in combination with DTIC. Patients were followed until tumor progression

and were evaluated based on objective tumor responses. The data indicated

that the product was generally well tolerated. Across both studies, mild to

moderate adverse events, including a rash or itching were experienced in

small number of patients. Further signs of immunologic activity directed at

tumors included tumor necrosis, inflammatory reactions at tumor sites and

immune mediated rash.

Responsibilities:

. Converted the clinical trail data, subject records entered in the

database files to SAS data sets using SAS/Access.

. Developed SAS programs using Base SAS for tabulation counts,

correlations and check for dispersion for normality, sorting and

merging data validations using PROC Means, PROC Tabulate and PROC

Univariate.

. Involved in the process and IT infrastructures for Phase II and III

Clinical Trials. Ensured quality of dataset at the protocol level

while working to deliver competitive advantage and cost efficiency to

the company as a whole. Achieved these tasks by serving as member in

data other regulatory compliance, data transmission and integrity

check of the existing and in-house clinical trial management team.

. Created a user interface to provide an interface between the SAS

system and data from the other software vendor's database management

systems, including PC files formats such as DBF, and Excel using

SAS/ACCESS.

. Conducting, documenting and reporting computer validation inspection

in compliance with FDA Regulations (21 CFR), systems.

. Created a SAS customized reports using the Data _Null_ technique for

FDA regulations.

. Converted oracle data tables into SAS data files using SAS/SQL and

uploaded SAS data files into oracle tables.

. Database Creation and Table Programming for Safety (ISS) and

Integrated Summaries of Efficacy (ISE)

. Create programs for presentation of graphs using SAS/GRAPH. The

presentation of graphs include create a text slides, display several

graphs at one time, combine graphs and text in one display and create

automated presentations.

. Closely work with the statisticians and scientists to identify common

factors across the projects.

. Ensured quality of dataset at the protocol level while working to

deliver competitive advantage and cost efficiency to the company as a

whole. Achieved these tasks by serving as a member in data management

team.

. Created programs for generating reports of clinical studies which

include risk and odds rations, and significant multivariate factors

using SAS/STAT.

Environment: SAS/ Base, SAS/ Macro, SAS/Access, SAS/Connect, SAS/Graph,

SAS/Stat, SAS/AF, Oracle 8.0, Excel, Word, Windows 2000 and Unix.

Siris Pharma, Hyderabad, India May 2004 -

sept2006

SAS Programmer - Clinical Trials

The project is to study the effect of new Medicine in the treatment of

Multiple Myeloma. To compare the whether Study Medicine offer an effective

but less toxic alternative to the usual chemotherapy for patients newly

diagnosed with multiple myeloma. The toxicity "appears lower, and the

response rate is as good or better than that obtained using complex

combinations of chemotherapy regimens. The study is to evaluate "how much

extra response do we actually get over (dexamethasone), how much toxicity

are we buying in that process and its worth.

Responsibilities:

. Created new or modify SAS programs to load data from the source and

create study specific datasets, which are used as source datasets for

report generating programs.

. Extracted raw data from the warehouse and created SAS data sets that

are required for the project analysis using SAS FTP and SAS/ACCESS and

SAS/CONNECT.

. Converted ORACLE data tables into SAS data files using SAS SQL and

uploaded SAS data files into ORACLE tables using SAS DBLOAD procedure.

. Created SAS Data Entry Screens using the SAS FSP and View Table

Utility.

. Developed numerous ad hoc SAS programs to create summaries and

listings.

. Created SAS MACROS and SAS GRAPHICS. Customize the existing programs

using SAS Macros as per the statistician's requirements

. Analyzed different drugs sales activity metrics and generated reports

and graphical representation of these sales for comparison of

different drugs using SAS/GRAPH and SAS/STAT. Used PROC LIFETEST and

PROC GPLOT to create graphs in SAS.

. Generated SAS Customized reports using the DATA _NULL _ and PROC

REPORT techniques.

. Created survival graphs in Excel by transporting SAS data sets into

Excel spreadsheets.

. Created TEMPLATES to modify the appearance of the Displayed ODS Tables

using PROC TEMPLATE.

. Extensively used PROC FREQ, PROC TABULATE, PROC MEANS, PROC MACROS,

PROC MEANS, PROC SUMMARY, PROC CONTENTS, PROC COMPARE and PROC

UNIVARIATE.

. Documenting and reporting computer validation inspection in compliance

with FDA Regulations (21 CFR), other regulatory compliance and data

transmission. Create electronic data sets (i.e., SAS transport files)

for electronic submission.

Environment: SAS for Windows V8, SAS/ACCESS, SAS/BASE, SAS/STAT, SAS/ODS,

SAS/SQL, SAS/GRAPH, MS-Excel, PL/SQL, Oracle 8.0, HTML and Windows 2000.

Education/Training/Certification

. Master of Science from Osmania University, India

. Post Graduate Diploma in Computer Applications from Mtech computer

training centre Affiliated to Jawaharlal Nehru youth centre, Andhra

pradesh,India

. Bachelor of Science from Osmania University, Hyderabad, Andhra pradesh

India.

. Diploma in complete Java 2 from param Information systems.Hyderabad

A.P,India

. Diploma in C programming.Param computers India

. SAS certified base programmer for SAS 9

Contact this candidate