Data Sql

Resume of Lakshmi Pendem Page

Lakshmi Pendem

* ********* **, ******, ** 08820

Tel: 908-***-****

Email: *******@*****.***

SUMMARY:

Experienced as a SAS programmer under various platforms including Windows98, Windows NT,

and UNIX.

Good understanding of CDISC SDTM models and experience in converting legacy data to CDISC

SDTM Standards.

Experience in Data mapping to SDTM Standards.

Experience in data extraction and exploration using SAS tools including SAS/STAT, SAS/Base,

SAS/Macro, SAS/GRAPH

Generated Reports using SAS, VBA, VB and Excel.

Developed and support the extraction, transformation and load process (ETL) for data

Warehouse from the legacy system using Informatica.

Have good understanding of Clinical Trial process and various Phases in it.

Comfortable working on Databases such as Oracle and MS Access.

Good written and oral communications skills.

COMPUTER SKILLS:

Languages: SAS, PL/SQL, SQL, C++, C, PRO* C, Java, JavaScript, Shell, Awk, VBScript

(ASP), XML, SQL*Plus, Perl, HTML

Software Packages/Tools: SAS Base, SAS Macro, Oracle Clinical, WinRunner, LoadRunner, Test

Director

OS: UNIX (HP-UX, SunOS), MS-DOS, Windows NT 4.0, Windows 95/98, and Windows 3.1

DBMS: Oracle 7, Informix 7.3, Sybase, MS-Access

Tools: Sablime, nMake, SQA Suite, Script Builder

Protocols: TCP/IP, UDP, and NFS

Others: MS Office, Good understanding of OOD/OOP & Internet Related technologies.

Hardware: HP 9000 series, Sun Sparc, Sun Workstations, NCR, PCs

EXPERIENCE:

Mt. Sinai School of Medicine/World Trade Center (9/11) Medical Monitoring Program, New York

(10/11 – Present)

Sr. SAS Programmer Analyst (Employee)

Environment: Base SAS, SAS/Macro, ODS, SQL, SQL Server, Trial DataBase (TDB), WEBAPP

Responsibilities:

Prepared Consent tables for data management group.

Created analysis datasets for research group.

Designed and implemented an automated certification batch program World Trade Center exposures

and self-reported symptoms/medical conditions.

Resume of Lakshmi Pendem Page

Designed and implemented an automated certification program World Trade Center exposures and

cancer.

Preparing Quarterly Reports for Physical Health Conditions, Physical Health Symptoms, Mental

Health Conditions and Certified Claims Data.

Prepared tables and listings for certified conditions.

Coordinated with IT group for creating certification.

Used PROC PRINT, PROC CONTENTS, PROC FREQ, PROC TRANSPOSE, PROC SORT,

PROC SQL, PROC DATASETS, PROC REPORT, PROC TABULATE

Johnson and Johnson Ortho Clinical Diagnostics, Raritan, NJ 6/2009 – 12/2009

SAS Programmer (Consultant)

Environment: Base SAS, SAS/Macro, SQL

Responsibilities:

Generated required tables, listings and graphs from clinical trial data for FDA submissions.

Worked closely with Data Managers and Statisticians in analyzing the data and generating the

summary tables, listings and graphs.

Created Customized Reports using Data _NULL_ and PROC REPORT to generate the outputs.

Used SAS ODS to produce RTF format.

Responsible for Quality Checking output results of other programmers.

Used PROC PRINT, PROC CONTENTS, PROC FREQ, PROC TRANSPOSE, PROC SORT

Johnson and Johnson Consumer Company, Morris plains, NJ 5/2007 – 4/2009

Biometric and Clinical Data Systems Department (BCDS)

SAS Programmer (Consultant)

Environment: Base SAS, SAS/Macro, EXCEL, SQL

Description: Provided SAS programming support to the Statisticians and Data Management group.

Responsibilities:

Responsible for creating audit listings and clinical listings for the Data Managers.

Transform raw data from excel to SAS and creating SAS datasets.

Generated tables, data listings and graphs.

Created derived analysis datasets from clinical trial data.

ESUB:

Created analysis datasets for Submissions as per FDA Guidance and internal company

standards.

Created ISS tables for FDA submissions (ESUB).

Created Transport Files.

Verified data with XPT compatibility utility.

Created blank annotated CRF (Blankcrf.pdf)

Generated Define.doc Word document using CRT creation utility.

Created standard analysis datasets.

Conducted the testing for standard data listing programs.

Worked closely with Data Managers and Statisticians in analyzing the data, generating the summary

tables, listings and graphs.

Resume of Lakshmi Pendem Page

Reviewed protocols and Clinical Study Reports.

Novartis, East Hanover, NJ 9/2005 - 5/2007

Business Analysis Department

SAS/VB programmer (Consultant)

Environment: Base SAS, SAS/Macro, VB, EXCEL, ACCESS DB, SQL, ORACLE DB, UNIX, SAS

Enterprise Guide, SAS/ETL, SQL

Description: Developing and maintaining the suite of Direct Access reports. Reports detail all aspects of

call and sales data.

Responsibilities:

Responsible for uploading SAS data into Oracle and Access Database.

Quality checking the reports

Validating SAS files.

Wrote shell scripts for validation.

Developed reports using Excel and VBA.

Responsible for generating Weekly and Monthly Field Analysis and Marketing Reports.

Developed VB generator for creating reports for different regions and districts

Developed SAS programs (in Siebel Format) for Siebel system.

Pfizer, NY. 5/2004 - 12/2004

SAS Programmer (Consultant)

Environment: BASE SAS, SAS/MACRO, PROC SQL

UNIX

Description: Preparation of CDISC compliance SAS transport files and accompanying data definition

documentation for the Electronic Submission (ESUB) of pharmaceutical data to the FDA using Unix SAS

with Pfizer proprietary GUI Interface.

Responsibilities:

Responsible for mapping, designing and implementation of transport files in CDISC SDTM format

using SAS/BASE.

Created and ran Macros for checking missing identifier variables, missing values for required and

expected variables and compared attributes with XPT and original CDISC data.

Wrote Macros to compare attributes.

Setup protocols on CDARS GUI.

Reviewed the code with ESUB group.

Responsible for Quality Checking:

Quality Checking Transport files.

Quality Checking Define Documents against Annotated CRF.

Used PROC PRINT, PROC CONTENTS, PROC FREQ, PROC TRANSPOSE, PROC SORT.

Resume of Lakshmi Pendem Page

Info Source Consulting 1/2001 – 12/2003

SAS Programmer (Consultant)

Environment: BASE SAS (SAS 8.2), SAS/MACRO

ORACLE CLINICAL, Windows NT and UNIX.

Responsibilities:

Designing, building and testing SAS programs to generate tables, reports and listings from

clinical trials data.

Created permanent formatted SAS data sets and developed reports using PROC REPORT, PROC

TABULATE, PROC PRINT and DATA_NULL_ for analysis.

Wrote Edit check programs and listings of clinical trial data

Imported, exported SAS data sets from and to Excel.

Created shell scripts to automatically extract data from Oracle/clinical.

Generated queries from Oracle Clinical.

Assisted in validating programs.

Modified existing SAS Macro programs and created new programs using SAS macro

variables

Several SAS procedures used including: PROC FREQ, PROC MEANS, PROC

SORT, PROC PRINT, PROC SQL, PROC TABULATE and PROC REPORT.

AT&T, Middletown, NJ. 10/98 – 6/2000

Programmer Analyst (Consultant)

Environment: C, C++, SQL*PLUS, Informix database, UNIX, connect direct

Description:

Member of the ICORE/BMP (Interspan Common Operations Resource and Engineering /

Business Maintenance Platform) interface development group. For each service (ATM, Frame

Relay), the ICORE server has the ICORE/BMP interface processes extract related data, format

the extracted data into ASCII files, and transmit the ASCII files to the BMP server through

connect direct. The application was developed using Java, JavaScript, C, C++, Shell and

Informix RDBMS on UNIX Systems.

Responsibilities:

Responsible for maintaining and enhancing interface processes. The processes were

implemented in C++, Shell scripts and used Informix as the database.

Responsible for primary production support of the interface systems. Was responsible

for monitoring data transfer processes and providing support to system engineering

groups.

Performed Integration and System Testing. Wrote Ksh, SQL*Plus scripts for

automating test cases.

Converted C++ code into JAVA.

The screens were developed for and were implemented in HTML, and JavaScript.

Participated in design and code reviews.

Resume of Lakshmi Pendem Page

AT&T, Piscataway, NJ 12/97- 8/98

Programmer Analyst (Consultant)

Environment: C++, Pro*C, Oracle (7.3.4) on Sun (Solaris 5.51), PL/SQL, SQL

Description:

Worked on EOT (Enhanced Order tracking system), which tracks order from the time they are

placed until the customer's requested product/service has been delivered. The application was

developed using C++, AWK, SED, PERL, Pro*C with Oracle (7.3.4) on Sun (Solaris 5.51)

Platform.

Responsibilities:

Responsible for development of modules to perform Master Order Database Updates

and Sub entries. Used C, C++, PRO*C, PL/SQL, SQL for the development.

Wrote SED/AWK scripts to parse flat files and load data into Database tables.

Later implemented some of the scripts in PERL. Scripts were also used to generate

reports.

Participated in design reviews. Used Sablime for source code control.

Performed unit testing, integration testing and supported the system testing.

Worked with tuxedo servers, services, configuration files and transactions.

EDUCATION:

Associate Degree in Computers (Applied Sciences): Brookdale Community College, NJ

Bachelor of Science (Biology, Zoology and Chemistry): Osmania University, India

Diploma in Data Processing & CIS: ICS, Hyderabad, India

TRAINING:

Windows NT 3.51/4.0 Administration.

Oracle Clinical Data Management.

PROJECTS:

Designed and implemented an Employee Database as a Project. Implemented in C, Unix File

system. No RDBMS was used. Primitive UNIX, C calls were used to implement the

application. Application provided the functionality to add, update, delete, get records and run

reports.

Implemented DML module for bookstore database for the JAVA class project. Using JDBC wrote

a process to insert, update, and delete records from the bookstore database. In addition to the

books the database maintained customers and publishers information.

Designed and implemented a Rational Number calculator in C++ using an array template,

inheritance and virtual functions for the OOD/C++ course.

Analyzed and implemented different sorting and searching techniques using C on UNIX and

Windows machines.

Installed and Configured Windows NT 4.0 server on a Pentium machines. Set up and managed

user accounts on a NT machine

PERSONAL: U.S. Citizen

REFERENCES: Available upon request

Resume of Lakshmi Pendem Page

Contact this candidate