Data Sql Server
Resume:
[pic]Base SAS Certified Professional [pic]
PRASANTHI NAGALLA
Ph: 571-***-****(M),
E-mail: **********.*******@*****.***
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