Resume

Sign in

Data Sql Server

Location:
Woodbridge, Virginia, 22192, United States
Posted:
May 25, 2010

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

[pic]Base SAS Certified Professional [pic]

PRASANTHI NAGALLA

Ph: (571) *** ****(M),

E-mail: abmrgl@r.postjobfree.com

Summary:

. SAS Certified Professional over Seven(7+) years of experience as a SAS

Programmer/Analyst in BI and in all Phases of Clinical trials, on

Windows NT/2000/XP and UNIX. Proficient in BASE SAS (V6/8/8.2/9.0),SAS

Enterprise Guide, SAS BI including SAS OLAP Cube Studio, SAS

Management Console, Web Report Studio, Information Map Studio, SAS

Information Delivery Portal, SPM, SAS/GRAPH, SAS/STAT, SAS Proc

Report, SAS SQL, SAS ODS and SAS Macro facility.

. Serving as a SAS BI Programmer will develop applications, including

data warehousing and SAS Business Intelligence (SAS BI) platform,

perform data modeling of data files containing Department of Commerce

administrative data.

. Work with database administration of a data warehouse, write and test

programs using SAS version 9.1.3, and retrieve and analyze data

stored in Oracle 9i and 10g.

. Work with the SAS Enterprise Guide 4.0 and SAS Mangement Console 9.1.3

and SAS Information delivery Portal. Doing the packages and migrating

from one environment to another environment Work on the UNIX

environment.

. Assisted in the Migration of SAS 9.1 to 9.2. Worked on the SAS Data

Integration studio 4.2, OLAP Cube studio 9.2, Information Maps 4.2 and

Web Reports.

. Served as a Data Manager on a CDC contract responsible collecting data

on grants and contracts for performance management and workflow

systems. Using SAS to collect data from source systems, cleanse data

and compute key performance metrics.

. Serving as a SAS developer maintaining and enhancing applications that

produce management reports and scorecards. Utilizing SAS tools (BI,

OLAP, Web Report Studio,Information Map and SPM) and other programming

languages (Java, weblogic, html, xml) to maintain and enhance software

based on client requirements

. Experience in creating and using complex and reusable Macros for Data

Cleaning, Validation, Analysis, Integration and Report generation.

. Experience in using SAS to read, Import and Export to other data file

formats, including Delimited files and Spreadsheet files.

. Generation of Reports, Tables, Listings, Graphs and Summaries as per

regulatory standards and in compliance with 21 CFR Part 11, FDA and

other regulatory compliance.

. Experience in extraction of data from relational databases like

Oracle, SQL, Symmetric, MS Access, etc. using SQL Pass through

Facility Experience in RDBMS design and development including SQL

queries, PL/SQL programs and stored procedures.

. One (1) year Experience with Development of Client-Server applications

using Visual Basic, Oracle, and SQL Server on Windows environment

. A quick learner, possessing excellent analytical and quantitative

skills. Ability to work both independently and in team environments.

Education & Certification

. Base SAS Certification

. Brain bench Certified in SAS 8.2 Base

. Masters in Computer Applications from IGNOU, India

. Post Graduate Diploma in Computer Applications from IGNOU, India

. Bachelor of Sciences in Computers from Nagarjuna University, India

Skill Summary:

SAS Software Base SAS, SAS/Graph, SAS/Stat, SAS Analyst, SAS BI

including SAS Management Console, SAS Enterprise

Guide, SAS Data Integration Studio, SAS OLAP Cube

Studio, Web Report Studio, Information Map, SPM, ETL

Operating Systems UNIX, Windows NT/2000/XP

GUI Developer/2000, Visual Basic 6.0

Languages SAS, SUDAAN, SPSS, C, C++, PL/SQL

Web Technologies HTML, XML

RDBMS Oracle 9i, 10g, MS-Access, SQL Server,

Symmetric

Report Tools Crystal Reports 8.5

Experience

Over seven years of total experience in Analysis, programming, database

maintenance in SAS and VB.

Employer : Kforce Inc.

June 2009 To Till Now

Client: US Census Bureau, Suitland, MD, USA

Role : SAS BI Programmer/Analyst

The SAS BI Programmer will develop applications, including data warehousing

and SAS Business Intelligence (SAS BI) platform, perform data modeling of

data files containing Department of Commerce administrative data.

Responsibilities:

Work with database administration of a data warehouse, write and test

programs using SAS version 9.1.3, and retrieve and analyze data stored in

Oracle 9i and 10g. Work with SAS/BI, i.e. Cubes, Information Map Studio,

Web Report Studio as well SAS Data Integration Studio.Establishing the

interface between Oracle and SAS; the current versions are Oracle 10g and

SAS 9.1.3, and demonstrated experience converting logical database designs

into physical databases.

Work with the SAS Enterprise Guide 4.0 and SAS Management Console 9.1.3 and

SAS Information delivery Portal. Doing the packages and migrating from one

environment to another environment Work on the UNIX on Open VMS environment

using the Reflection. Putting the alerts in the portal page using HTML

language

Work directly with business users to identify and document the

reporting and analytics requirements and develop/implement appropriate

solutions.

Support business users with ad-hoc data analysis as needed . Provide

guidance and technical expertise to business power users who are

responsible for developing reports and conducting ad-hoc data analysis.

Troubleshoot reporting and data quality issues and Provide backup

operational support for ETL processes.

Procedures Used: Proc SQL, proc OLAP, mddb, dbload, summary, Tabulate,

Import, Export, Report etc.

. Features used: BASE SAS (V6/8/8.2/9.0),SAS Enterprise Guide, SAS BI

including SAS OLAP Cube Studio, SAS Management Console, Web Report

Studio, Information Map Studio, SAS Information Delivery Portal, SPM,

SAS/GRAPH, SAS/STAT, SAS Proc Report, SAS SQL, SAS ODS and SAS Macro

facility.

SAS / STAT, SAS / GRAPH, SAS/ODS, SAS / Access, MS Excel, SQL

Server, HTML, UNIX

Employer : Teknostars Inc

May 2008 To June 2009

Employer : Global It Inc

Oct 2007 To May 2008

Client : CDC - SAIC, Atlanta, USA

Role : Programmer Analyst

Serve as a SAS developer maintaining and enhancing applications that

produce management reports and scorecards. Utilizing SAS tools (BI, OLAP,

Web Report Studio,Information Map and SPM) and other programming languages

(Java, weblogic, html, xml) to maintain and enhance software based on

client requirements. Responsible for performing software development,

analysis and testing, and development of technical documentation detailing

the project design parameters. Determines system specifications,

input/output processes, and working parameters to meet business

requirements and hardware/software compatibility.

Description:

The CDC's Procurement and Grants Office (PGO) measuring its performance by

defining and collecting data on Key Performance Indicators (KPIs). The KPIs

measure the workload within PGO and the cycle times for many PGO

activities.

PGO uses two tools to display and share data on the KPI's: Scorecards and

Operating Reports. Scorecards contain summary performance

information across PGO and at the branch level, while Operating Reports

contain detailed information to the level of individual transactions.

In order to provide a more intuitive, graphic, and user-friendly tool, the

existing Scorecards are being replaced. Overtime, additional PGO Scorecards

will be added, including cycle times for processes that are completed by

CIOs and additional measures of PGO performance, such as forecast data,

Small business by categories, employee attrition and customer satisfaction.

Additionally, the software used to power the new Scorecards will allow for

greater flexibility in the future, and the Scorecards and Operating

Reports will eventually be combined into one reporting tool.

PRO is an online tool for providing CDC personnel with reports of post-

award Grants and Contracts data.The PRO application is supported by offline

processing of source data using SAS.

Responsibilities:

. Primarily responsible for integrating new data sources into existing

Scorecards and reporting systems.

. Responsible in reading in data, cleansing and writing automated

processing programs.

. Maitain and enhance applications that produce management reports and

scorecards.

. Utilizing the SAS tools(BI,OLAP, Web Report Studio and SPM) and other

programming languages(Java, Weblogic, html,xml) to maintain and

enhance software based on client requirements.

. Responsible for performing software development, analysis and testing,

and development of technical documentation detailing the design

parameters.

. Software development implementing new requirements.

. Software changes fixing defects.

. Analysis to determine rootcause of defects or data anomalies.

. Demonstrates protypes to customer and document feedback.

. Assist in setting system parameters to enhance performance of

software.

. Designed flowcharts indicating the input data sets and the techniques

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

Wrote SAS code according to the design.

. Produced data listings, summary tables, graphs and charts for interim

and final analyses using different statements/functions/procedure for

data manipulation.

. Use SAS/ODS for delivering output in different formats including HTML,

PDF, RTF etc.

. Generated Ad-Hoc reports for analysis datasets using PROC REPORT,

PROC TABULATE and DATA _Null_.

. Developed SAS macros wherever reusability of the same code is required

Procedures Used: Proc SQL, proc OLAP, mddb, dbload, summary, Tabulate,

Import, Export, Report etc.

Features used: Base SAS, SAS tools (BI, OLAP, Web Report Studio,Information

Map and SPM) and other programming languages (Java, weblogic, html, xml),

SAS / STAT, SAS / GRAPH, SAS/ODS, SAS / Access, MS Excel, SQL Server

Employer : Global It Inc (Apr 2006 To Aug 2007)

Client : Eminent Services Corp, MD,USA

April 2006 to Aug 2007

Role : Programmer Analyst

EMINENT Services Corporation (EMINENT) supports the emerging pharmaceutical

and biotechnology companies as well as institutional and clinical research

organizations (CRO) in meeting clinical drug regulatory requirements.

EMINENT provides expert services in the area of assessing systems

requirement for data management and retrieval, design and implementation,

validation and acceptance testing, 21 CFR Part 11 Compliance, User Manual

preparation, and the development of a Disaster Recovery Plan.

Responsibilities:

. Involved in clinical trial studies, data migration/extraction of data

from Flat files, Oracle SQL Tables and SAS Datasets.

. Preliminary data validation (edit checks) is done on the clinical

trial data.

. Designed flowcharts indicating the input data sets and the techniques

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

Wrote SAS code according to the design.

. Produced data listings, summary tables, graphs and charts for interim

and final analyses using different statements/functions/procedure for

data manipulation.

. Use SAS/ODS for delivering output in different formats including HTML,

PDF, RTF etc.

. Generated Ad-Hoc reports for analysis datasets using PROC REPORT,

PROC TABULATE and DATA _Null_.

. Developed SAS macros wherever reusability of the same code is

required.

. Extensive interaction with the statisticians to understand the

requirements on statistical methods and measures.

. Involved in preparing the presentations of the findings to the end

users after conducting background research to do the required

analysis.

Features used: Base SAS, SAS / STAT, SAS / GRAPH, SAS/ODS, SAS / Access,

SAS / Connect, MS Excel, SQL Server

Employer : Sristek Consulting Pvt Ltd. (July 2004 to April 2006)

Client: Nizam Institute of Medical Sciences(NIMS), India

July 2004 to April 2006

NIMS is a deemed university offering MD in major specialization including

clinical pharmacology and is a major center of excellence in conducting

Phase I/II/III Clinical Trials in India.

Role: SAS Programmer

Description:

The project was a phase I study to evaluate the effect of the study drug on

subjects who had migraine attacks. The study was a double blinded,

randomized and the objective was to test the efficacy of the two drugs

(study drug and the existing drug).The pain relief time due to two drugs

were analyzed, considering the safety parameters. The reports were

generated as per the protocol.

Responsibilities:

. Worked with a team comprising of Bio-statistician and clinical

research Associates, responsible for data analysis and report

generation.

. Accessing and managing clinical data.

. Involved in development and enhancements of SAS programs.

. Involved in writing code to extract clean and validate Data from

tables.

. Provided SAS programming of data Listings, Graph outputs and

Statistical tables for the clinical trial study.

. Run descriptive statistics and statistical analysis on variables for

analytical processes using SAS analyst.

Procedures Used: Import, Tabulate, Transpose, Report, Univariate, Freq,T-

Test,Sql,Gchart,Gplot procedures are used. Macros are applied wherever

necessary.

Client: Reliance Company

Role: SAS Programmer

Description:

The objective of the study was to evaluate the safety and efficacy of the

study drug, which is a gel, in combination with good wound care in patients

with at least one diabetic neuropathic foot ulcer. This study was conducted

in two parts. The first part was open label, sequential dose escalation

designing which subjects were classified into 3 groups based on the study

drug. The second part was a single blinded comparison with placebo of the

two highest dose levels. Here the subjects were classified into 3 groups

based on the study drug. Creation of Datasets and cleaning, Manipulation,

Validation of data is done using Data step and Base SAS procedures. The

statistical procedures were applied and reports were generated as per the

protocol.

Responsibilities:

. Cleaning of data using data step and SAS Procedures.

. Registering variables as character and analysis variables in database.

. Provided SAS programming of data Listings, Graph outputs and

statistical tables for the clinical trial study.

. Run descriptive statistics and statistical analysis on variables for

analytical processes using SAS Procedures.

Procedures Used: Import, Tabulate, Transpose, Report, Univariate, Freq, T-

Test, Gchart, Sql procedures are used. Macros are applied wherever

necessary.

Client: Wyeth Limited

Role: SAS Programmer

Description:

The clinical trials were conducted on the drug of Renal Diseases, patients

Undergoing Dialysis, Undergone Kidney Transplantation. The CRFs were

provided by client. The data is entered into Excel Spread Sheets. Data is

then imported to SAS system. Creation of Datasets and cleaning,

Manipulation, Validation of data is done using Data step and Base SAS

procedures. The statistical procedures were applied as per the protocols

Provided by the Bio-Statistician using SAS/ANALYST application. Graphical

and HTML

Reports were generating on demographics, Safety Analysis, Efficasy Analysis

and Baseline characteristics in the SAS system.

Responsibilities:

. Cleaning of data using data step and SAS Procedures.

. Registering variables as character and analysis variables in database.

. Provided SAS programming of data Listings, Graph outputs and

statistical tables for the clinical trial study.

. Run descriptive statistics and statistical analysis on variables for

analytical processes using SAS Procedures.

Procedures Used: Import, Tabulate, Transpose, Report, Univariate, Freq,

Means, Sql procedures are used. Macros are applied wherever necessary.

Client: Indian Immuno Logical Center

Role: SAS Programmer

Description:

A phase III,multy center study to evaluate the immunogenicity and

reactogenicity of a recombinant Hepatitis B vaccine in healthy subjects.

The objective of the study was to evaluate if study vaccines sero

protective efficacy is better in the study group, who were treated with

investigational vaccine, compared to the control group, who were treated

with approved vaccine for clinical use.

Responsibilities:

. My role is to manage the data process and create Datasets using SAS

Base.

. Creating statistical tabulated reports on data by using SAS/STAT.

. For the production of statistical summaries using ANOVA, REGRESSION,T-

Test (analysis tables,figures)and analysis datasets using statistics.

. Gives integrated summary of efficacy and integrated summary of safety.

. The company provided input into clinical project documents like

protocols, CRFs validation and analysis plans.

. I have ensured quality of patients data listings, statistical summary

tables and graphs(Bar charts, Pie Charts)by implementing validation

procedures.

Procedures Used: Import, Tabulate, Transpose, Report, Univariate, Freq,

Means, GLM,T-TEST, Anova, Logistic,Z-Test procedures are used. Macros are

applied wherever necessary.

Client: Wyeth Limited

Role: SAS Programmer.

Description:

The Study was a multicenter, open label, non comparative phase IV post

marketing surveillance looking at safety of the study design in adults with

active Rheumatoid Arthritis (RA) and children with juvenile Rheumatoid

arthritis.. The CRFs were provided by client. The data is entered into

Excel Spread Sheets. Data is then imported to SAS system.

Creation of Datasets and cleaning, Manipulation, Validation of data is done

using Data step and Base SAS procedures. The statistical procedures were

applied as per the protocols. Provided by the Bio-Statistician using

SAS/ANALYST application. Graphical and HTML. Reports were generating on

demographics, Safety Analysis, Efficasy Analysis and Baseline

characteristics in the SAS system.

Responsibilities:

. Cleaning of data using data step and SAS Procedures.

. Registering variables as character and analysis variables in database.

. Provided SAS programming of data Listings, Graph outputs and

statistical tables for the clinical trial study.

. Run descriptive statistics and statistical analysis on variables for

analytical processes using SAS Procedures.

Procedures Used: Import, Tabulate, Transpose, Report, Univariate, Freq,

Means, GLM, Sql procedures are used. Macros are applied wherever necessary.

Employer : Soojee Technologies Pvt Ltd.,Hyderabad.

Mar 2002 to June 2004

Software Used: Visual Basic

Database : SQL Server, MS Access

Project Title : Human Resource Management System-HRMS.

Role : Team Member

Description:

An Automated system has been developed to automate the Soojee's HRD data

and Subjected to HRMS. It has been developed with a provision to add

new developments.

. Easily upgradeable with a new module when required.

. Required data transparency has been maintained to cope up with the

future developments.

. It is user friendly and has better interface with the people working

on it.

This system encompasses the functionality of employee Categorization,

department categorization, employee details, Compensation package,

attendance, leaves, training process, payroll

Management, Misc. Reports etc.

Project Title : Hospital Management System (HMS)

Client : Medisys

Role Team Member

Description:

This has been developed to handle mainly For In-Patient and Out-Patient

blocks. These are related to Consultation, Reports, Registration

allocation, Case sheet, Services, Surgery charges, Billing etc.

Responsible for Testing

. MS Charts Preparation

. Crystal Reports



Contact this candidate