Kuladeep Mittapalli 317-***-****

fyrkic@r.postjobfree.com

fyrkic@r.postjobfree.com

OBJECTIVE

Seeking a contract position as a Senior SAS® Developer/Analyst in the field of Information Technology that leverages my broad technical background.

PROFESSIONAL SUMMARY

• Over 9+ years of USA experience providing innovative solutions needs in Financial, Telecom, Pharmaceutical and Sales and Marketing, Health Care.

• Thorough knowledge of Clinical Trials and Involved in all Phases of Clinical trials includes Data manipulation and Statistical Analysis.

• Profound Knowledge and Strong experience in Base SAS, SAS/MACRO, SAS/ODS, SAS/GRAPH, SAS/SQL, SAS/ETL, SAS ENTERPRISE GUIDE4.0 (SAS BI Client), SAS DI3.4.

• Strong experience in SAS SHARE, SAS/IntrNet, SAS/STAT, SAS/Connect, SAS/ETL, Enterprise Miner4.2, Crystal Reports, Web Report (SAS BI Client), MAP Studio (SAS BI Client).

• Thorough knowledge of ORACLE 8i/9i, MS-Access, SQL Server 2000, DB2, Sybase and SQL, Teradata.

• Thorough knowledge of DATA STEP GRAPHICAL INTERFACE (DSGI) in order to create 3D PIES.

• Good experience in IBM Mainframes: MVS/JCL, TSO/ISPF, CRO (Clinical Research Organization).

• Good experience in Change Management tool (Requisite Management tool).

• Thorough Knowledge of PEOPLE SOFT (ERP) Package, TCP/IP, FTP Protocols, Micro Strategy.

• Proficient in writing Perl, Perl/CGI and UNIX Shell Scripts (KORN, BOURNE), VB Script, Excel VBA/Macros, Linux.

• Excellent skills in Web Technologies like ASP, Java Script, CSS and HTML

• Possess experience in SAS® on Mainframes, UNIX and Microsoft Windows environments

• Profound concepts and extensive programming experience in Java, C, C++

• Good knowledge in software engineering methodologies

• Extensive experience in preparation of reports, tables, listings and graphs

• Strong leadership, interpersonal and oral/written communication skills

• Ability to work independently as well as collectively ~ willing to relocate

Summary: Pragmatic, Innovative, competent, excellent interpersonal and time management skills.

PROFESSIONAL SKILLS

Programming Languages C, C++, Java, COBOL, PL/SQL, VB

Databases Oracle 8i/9i, DB2, MS Access, Teradata, SQL Server

Mainframe Tools MVS/JCL, TSO/ISPF, MVS Utilities

Operating Systems Unix, Linux, Solaris, MS Dos, Windows 95/98/00/NT

Web Technologies HTML, ASP

Scripting JavaScript, PERL, PERL/CGI Unix Shell scripting (Korn, Bourne)

Modeling Languages ER

Web Server IIS 4.0 / 5.0, Apache Web Server

SAS SKILLS

Base SAS Macros, Data _Null_, Display Manager, Data Step, Reports, Array processing

Procedures Sort, Transpose, Tabulate, Print, Contents, Means, Chart, Plot, Univariate, Summary, Reg, SQL, Format with picture, Copy, gslide, upload, download, Printto, Datasets, Format, Boxplot, freq, forms, Gfont, cport, cimport, G3D,Anova.Means.,GLM,Report,Anova,compare,datasets,fslist,report,sql,Append

Products/Features Base SAS, SAS/MACRO, SAS/STAT, SAS/GRAPH, SAS/SQL, SAS SHARE, SAS/IntrNet, SAS/ODS, SAS/Connect, SAS/AF, SAS Enterprise Guide, Enterprise Miner, SAS DI Studio, SAS Web Report, SAS BI

EXPERIENCE

October 2008 to Till Now

Client: Hewitt Associates, Lincolnshire, Chicago, IL

End Client: Target (Health & Welfare Insurance Plans & HR Payroll Systems) & HSBC.

Role: Senior SAS Developer & Analyst – Implementation Team.

Project:

Assignment1:

1. Conversion of Health and Welfare employee indicative (HR) data from PeopleSoft into Hewitt’s benefit system. This assignment involves implementation of sas with C3PI (Enterprise Miner) from scratch, such that Job is going to retrieve all the Employees Information (HR data feed to support processing of TGT 401(k), Pension, Health and Welfare) and Validate each field of data and Load the data into the appropriate DB2 tables using Turbo BFLNG’s and Turbo IAP’s (SAS ETL Process). In some cases, the data first needs to be compared against existing Hewitt data in order to determine the desired approach for coding and loading. Various validation reports are created.

2. Cycle testing with clients (Target, HSBC) which involved job processing of millions of inbound conversion data records.

3. Configuration of Outbound Eligibility Interfaces (HYATT Legal Plan, INGINEX data aggregation).

4. Involving all types of mail campaigns.

5. Analyzing Credit check information from HSBC client.

6. Working with Requisite Pro Management tool.

. My responsibilities include:

• Analyzing requirements and identifying the tools to use in the configuration process.

• Validating each field of data using SAS functions (Verify (), Soundex () etc) before loading data into the DB2.

• Retrieving sas data sets, tables using DATA SOURCE node, change attributes/add new variables for target using CHANGE ATTRIBUTE node, transform the variables using TRANSFORM node, create different models using MODEL category and generate HTML report using REPORT node.

• Documenting & configuring using SEMMA (DATA MINER) data flow.

• Creating Different models (Regression & Tree) and comparing the output using score node using Enterprise miner.

• Creating Data Mart using Data Integration studio by configuring Meta data for Input, target designer.

• Creating JCL and custom SAS programs.

• Unit testing.

• Using FTP to retrieve employee Information, HR, Payroll Information from a flat file.

• Retrieving Millions of Records through DB2 tables and from tape too using PROC SQL, DATA STEP and compare data between them using SAS functions.

• Involved in Analysis Reviews and Test Plan Reviews.

• Documenting job flows and processes.

• Creating ad-hoc reports via SAS and SQL.

• Implementing based on SDLC Process.

• Writing COBOL Programs in order to retrieve data from flat file.

• Using SAS PROC SQL Pass through Facility to work with DB2 database.

• Using SAS DATA _ NULL_ and PUT statements to create the customized reports.

• Developing new macros for data validation using SAS/Macros.

• Using SAS ODS to create HTML, XML (SAS XML MAPPER/ODS), RTF and PDF outputs files in the process of producing reports.

Environment: Main Frame (MVS), SAS 9.1/Base, SAS/Macro, SAS/CONNECT, SAS/Share, SAS/Access, JCL, DB2, File Aid (Certified), POP Jobs (Certified), Pension Payroll Process (Certified), SAS/ETL, Enterprise Miner, COBOL.

April 2006 to October 2008

Client: CVS| CAREMARK, Lincolnshire, Chicago, IL

Role: Senior SAS Developer/Analyst.

Project:

Assignment1:

1. This assignment involves implementation of sas from scratch, such that Job is going to find out Eligibility beneficiaries for (Rx ,Re ,QL claims) qualified for Automatic Refill (It contains all the Patients information at Remote ORACLE DATA BASE exists at TEXAS) and Qualified Discounts in their copay at RETAIL /MAIL ORDER. Also find out qualified beneficiaries those who are having option from RETAIL TO MAIL ORDER.

2. Also Loading Drugs data into the appropriate table based on Users information through Front End.

3. Prepare Statiscal Report using PROC FREQ, PROC MEAN etc in order to determine Missing and Non Missing Values and also Relation between variables in a data set.

Assignment2:

1. This assignment involves implementation of sas from scratch, such that Job is going to pick up Different Delimited text Files belongs to (Rx, Re, QL data)(It contains all the Patients information from different Business users Located at Remote) using (FILENAME, MACROS, FTP)

2. Validating all the Beneficiary information(i.e. Name,ID,SSN,Address,Status etc) Using (SAS Functions, LAG(),VERIFY(),INDEX(),INPUT(),DATA _NULL_, SQL PASS THROUGH,SAS MACROS,DATA FUNCTIONS).

3. If Error found on Text file, Then Job send email to the team such that "Error found on Text file" Using(FILENAME EMAIL etc).

4. Validate data by connecting with Different database tables, If any Error found, Then Job send a email to the team.

5. After Successful Validation, Job update Communication data into Remote Database tables Using (FILENAME, FTP, LIBNAME, Different Procedures etc).

6. Prepare Statiscal Report using PROC FREQ, PROC MEAN etc in order to determine Missing and Non Missing Values and also Relation between variables in a data set.

Assignment3:

1. Developed Business rules by analyzing SAS Programs and Macros.

Assignment4:

1. Another assignment involves such that based on selection through Java screen (Client specific), job is going to pick up automatically all the active Claims (RX/RE/MEDICAID/QL) information (Millions of Records) exists at Remote host (EDW (Enterprise Data Warehouse) and find out eligible (Qualified) beneficiaries

2. Generate a Reports to the client using WEB REPORT (SAS BI) by using business logic and conditions using MAP STUDIO (SAS BI) also maintain communication history about all the Jobs.

3. Preparing Algorithm regarding Medicaid Claims.

4. Analyzing Fraud data (Any Void Claims, Inactive Claims) and report to the team.

Assignment5:

1. One more assignment deals with the COST SAVINGS (DOLLAR SAVINGS) based on drug brought by the Customer through MAIL service Instead of RETAIL. This assignment basically integrated with Java on the front end. Based on the user request through Java screen, job automatically pick up all the Beneficiary Claims related to the user and calculated savings calculations based on RETAIL drugs used by the user and generate the PDF report to the client using FTP .

2. Also Generate Graphs through HTML Format. Process is Fully Automated Process. (STAT PROCEEDURES, GRAPHS, PROC SQL, DATA _NULL_, MACROS, SASHELP).

3. Retrieve huge data (Millions of data) from Remote Host and loaded on local schema (Chicago DATAWAREHOUSE (CDW)) using scripts (Using LIBNAME, PROC SQL, MACROS).

4. Prepare One way statistical Analysis Report using ANOVA (Analysis of Drugs between each city in a state).

Assignment6:

1. One more assignment deals with the STANDARD FILE LAYOUT for all the Business Users (clients) from the Data ware. This assignment also basically integrated with Java on the front end. Based on user request through java screen, job automatically generates the PDF report with NEW STANDARD FILE LAYOUT FORMAT. Process is fully automated process (Using PROF FORMAT, PROC TEMPLATE, ODS, PROC PDF, PROC HTML, DATA _NULL_, MACROS).

. I am involving in analysis, configuration, Improve data quality, system integration, Unit testing, System testing & preparing Design document, and documentation.

My responsibilities include:

• Analyzing the tasks before doing the configuration.

• Analyzing, Configeration, Unit testing all the above tasks.

• Create Design Documentation regarding SAS Development.

• Developing Critical Macros such that these macros will be used by al l the common programs at CVS|Caremark.

• Documenting the Detailed process, i.e. documenting all the possible information about the application like SAS programs, DATA files and Connection to Remote host using SASNODE.

• Scheduling batch Jobs.

• Scheduling Chron File.

• Writing VBA/Macros.

• Writing the Korn scripts to load data into the database.

• Using Web Report (SAS BI) Creating HTML Reports to the client based on Business logic and Business terms to data whose fields, calculations and naming conventions using MAPPING STUDIO (SAS BI).

• Identifying the tools to use in the process.

• Implementing the process in intervals and testing the process.

• Implementing in production environment and giving access to the minimal number of user’s, to make sure process works good, before giving privilege to all the users.

• Used SAS PROC SQL Pass through Facility to work with DB2 & Oracle databases.

• Used SAS DATA _ NULL_ and PUT statements to create the customized reports.

• Working with HEDIS tool inorder to access to service, quality of care, feed back from the Customers, Doctors.

• Create PDF report, HTML report using ODS statements.

• Generating EXCEL Reports using Proc EXPORT, DATA _NULL_, PROC ACCESS.

• Retrieved different delimited files using PROC IMPORT, FILENAME, and PROC ACCESS.

• Develop new macros for report generation using SAS/Macros as per the customer’s requirements.

• Used FTP to retrieve remote information regarding client, and process the client information and add Extra information.

• Retrieving Millions of Records through DB2 tables.

• Received Appreciation Letter from Director, Project Manager for Good work.

Environment: UNIX, Enterprise Guide, Enterprise Guide V4, Main Frame (MVS), SAS 9.1.3/Base, SAS/Macro, SAS/CONNECT, SAS/STAT, SAS/GRAPH, SAS/Share, SAS/Access, Enterprise Miner, DB2 8.2, Oracle, Teradata , SAS/ETL, Map Studio, Web Report, Informatica.

April 2005 to March 2006

Client: Hewitt Associates, Lincolnshire, Chicago, IL

End Client: Boeing

Role: Sr SAS Developer/Analyst

Project: This assignment-involves Implementation of All Data Base tables (Health and Group Insurance plans ) from 3x to 4x Environment(Version) . Generate User request reports. I am involved in analysis, configuration, testing, preparing project plan and providing reports to the client.

My responsibility includes:

• Analyzing the task before doing the configuration.

• Maintaining large data sets, i.e. reading in data from various sources in various formats to create SAS data sets and/or ASCII files.

• Documenting the process, i.e. documenting all the possible information about the application like SAS programs, DATA files and source.

• Preparing project plan for the execution.

• Scheduling batch Jobs.

• Running Batch Adjustments.

• Creating ad-hoc reports.

• Identifying the tools to use in the process.

• Writing the JCL to run Batch jobs.

• Implementing the process in intervals and testing the process.

• Implementing in production environment and giving access to the minimal number of user’s, to make sure process works good, before giving privilege to all the users.

• Received Appreciation Letter from Client for Good work.

• Used SAS ODS to create HTML, RTF and PDF outputs files in the process of producing reports.

• Used SAS PROC SQL Pass through Facility to work with DB2 database.

• Used SAS DATA _ NULL_ and PUT statements to create the customized reports.

• Develop new macros for report generation using SAS/Macros as per the customer’s requirements.

• Default Report output is HTML and provided the options of WORD & EXCEL formats using SAS/ODS statements.

• Used FTP to download SAS Formatted Data into EXCEL AND CSV format.

• Retrieving Millions of Records Using different Procedures.

Environment: Main Frame(MVS), SAS 9.1/Base, SAS/Macro, SAS/CONNECT, SAS/Share, SAS/Access, JCL, DB2.

July 2004 to March 2005

Client: Burlington Northern SanteFe Railroad, Fort Worth, TX

Role: SAS Programmer

Project: Migration of SAS Application

This assignment-involved migration of SAS Application from OS390/MVS to AIX (Unix) environment from 8.1 to 9.1. Mainframe application has nearly 300 programs and 350 datasets, catalogs and formats to be migrated. I did the initial analysis of the project and prepared project plan to do the migration process. Based on the analysis study, code change will be minimal.

My responsibility includes:

• Analyzing the application before doing the migration.

• Documented all the possible information about the application like SAS programs, DATA files, Data source and tables.

• Prepared project plan for the execution.

• Identifying the tools to use in the process.

• Used SAS/Connect, FTP and CLIO/s downloading process.

• Proc Migrate is used to transfer files(Only certain formats)(SAS Data Sets).

• Using Proc cport and cimport migrate catalogs from mvs to unix.

• Validate the files using Proc compare.

• Created transport files to move the programs and Data .

• Convincing the user’s to move from mainframe.

• Writing the scripts to run Batch jobs using Chron.

• Writing Korn scripts to load data into the database.

• Implementing the process in intervals and testing the process.

• Implementing in production environment and allowing the access to the minimal number of user’s, to make sure process works good, before giving privilege to all the users.

• Some of the Jobs have to run from MVS; those applications were tuned to increase the efficiency and performance of the applications.

• Supporting the Web Forecasting Application, which was build using AppDev Studio and SAS/Intrnet.

Environment: Windows NT, MVS and AIX 4.3, SAS/Base, SAS/Macro, SAS/CONNECT, SAS/Share, SAS/Access, JCL and File aid, Teradata, DB2.

October 2003 to June 2004

Web Based Marketing Analysis Tool for Direct Market

Client: American Century Investments, Kansas City, KS

Role: SAS Programmer/Analyst

Developed a SAS web-based application, Data on Desktop (Marketing Analysis Tool) to Direct Marketing Group. The tool provides marketing professionals access to customer data in accordance with the business need. This tool provides a means of marketing professionals to more efficiently and effectively market to customers by (a) Increasing their knowledge of the customer (b) Decrease their dependency on the data mining and analysis staff. There is 2 categories in this tool for the first phase (1) Creating Groups:

Targeting the customer counts based on specific attributes for the campaign.(2) Creating Profiles : Demographic profiles can run on the customers targeted from the groups. This appears similar to the adhoc reporting systems, but is significantly more complicated.

Provided statistical reports for modelers, and analysts to refine targeted populations, and control groups.

The front end of this tool is developed using JSP, JAVA technology and back end is SAS/Intrnet. This application has more than 100 JSP’s and 50 SAS programs.

I also support the existing application called iLink, which is another web application build with JSP, JAVA, SAS/AF (SCL) and WebAF.

My responsibilities included:

• Mentor team members to develop programs using SAS and provide technical assistance.

• Design and Develop front-end screens using JSP, JAVA and HTML based on the user requirements. This was done using SAS AppDev Studio.

• Used SAS App Server to run the reports remotely and integrate with Web application.

• Used SAS/Intrnet tool to fully integrate the SAS programs with the web application.

• Load Manager - Socket service was used in the SAS/Intrnet configuration file.

• Unix Server (AIX) acts as the SAS application server.

• SAS/Intrnet Broker.cfg resides on Web server (Apache/Tomcat).

• Used SAS DATA _ NULL_ and PUT statements to create the customized reports.

• Develop new macros for report generation using SAS/Macros as per the customer’s requirements.

• Default Report output is HTML and provided the options of WORD & EXCEL formats using SAS/ODS statements.

• Produce SAS Graphical reports showing Trend Analysis charts for campaign.

• Created Regression Analysis, Predictive Modeling ,

• Writing Korn scripts to run the batch Jobs.

• Created Analytical Reports based on Supply Chain Experience (CPG).

• Used SAS PROC SQL Pass through Facility to work with Oracle database.

• Move SAS data sets across platforms from PC to UNIX and Vice Versa.

• Working closely with Data warehouse and infrastructure Managers, UNIX Administrators, DBA's for various technical issues such as allocation of space, workload analysis, capacity planning, file systems, etc.

Environment: AIX (4.3), WIN NT, SAS 8.2, SAS/Macro, SAS/STAT, SAS/ACCESS, SAS/CONNECT,

SAS/ODS, SAS/Intrnet, SAS/SQL, Home Suite, Apache/Tomcat, Oracle.

January 2001 to September 2003

Bristol-Myers Squibb, NJ

SAS Programmer Analyst –Clinical Trials

BMS is a Biopharmaceutical company developing products designed to improve the safety of the world’s health in Oncology and is conducting Phase III clinical trials. As a SAS Programmer, my role was in analysis of clinical trials data and generating required reports, listings, summaries and graphs for submission to FDA and other regulatory authorities.

My Responsibilities Included:

• Successfully designed and implemented statistical reporting processes for regular data collection and clinical data analysis. Analyzed Phase I, II and III Clinical Trials.

• Used Dynamic Data Exchange (DDE) feature of SAS for importing and exporting of data from and into SAS, MS Access and Excel.

• Maintenance of large data sets, combining data from various sources in varying formats to create SAS data sets and/or ASCII files by using Set and Merge for generating Reports and Graphs.

• Prepared new Datasets from raw data files using Import Techniques and modified existing datasets using Set, Merge, Sort, and Update, Formats, Functions and conditional statements.

• Created Validation and Derivation procedures in order to maintain data accuracy and track the results of the drug trail in accordance for GCP, GXP and 21CFR Part 11.

• Created complex and reusable Macros and extensively used existing macros and developed SAS Programs for Data Cleaning, Validation, Analysis and Report generation. Tested and debugged existing macros.

• Extensively used Data _Null_ and SAS procedures such as Print, Report, Tabulate, Freq, Means, Summary and Transpose for producing ad-hoc and customized reports and external files.

• Used SAS ODS to create HTML, RTF and PDF outputs files in the process of producing reports.

• Involved with all phases of System Development Life Cycle (SDLC) including gathering requirements, creating specifications, developing code and validating programs.

• Generated Tables, Graphs and Listings for inclusion in Clinical study reports and regulatory submission; Participated in preparing study results as well as ISS and ISE for FDA submissions using SAS.

• Created CRT’s with datasets in Transport File Formats and Data Definition Tables for NDA submissions to FDA.

• Attended project team meetings, worked with Bio-Statisticians, Data Managers, and Clinical Research Managers as appropriate. Reviewed and provided feedback for Data Integrity Plans.

• Implemented technical changes for ongoing maintenance and support; and also reviewed critical technical issues and participated in setting technical direction.

Environment: AIX (4.3), Windows 2000, SAS 8.2, SAS/Macro, SAS/STAT, SAS/ACCESS, SAS/CONNECT, SAS/ODS,

SAS/SQL, Oracle Clinical4.x

March 2000 to December 2000

Marketing department doing campaigning projects

Client: First USA Bank, Wilmington, DE

Role: Programmer/ Analyst

Involved in implementing Consumer Lending for Marketing & Performance Information Department of First USA Bank. . I am doing individual projects and supporting in another projects for my manager. Creating the mailing list of consumers for Direct Mailing and Telemarketing offers, and measures the performance of those campaigns. Now currently I am under process of a new project called E-Mail Marketing. Customer management obtains segments and analyzes customer profiles based upon variables of interest in data mart and data warehouse. Data are queried and SAS files are created with SAS PROC SQL/Pass through Facility. Tables, reports and OLAP results on account/household values and customer profiles are obtained by merging and summarizing data using SAS.

Involved in validating the Mortgage data by using Mathematical sas functions and Calculate Annual Interest rate and well as Monthly Interest rate and Load the data using Proc SQL through Oracle, DB2 as well.

My responsibilities included:

• I am currently working individual projects and supporting marketing campaigns.

• Creating a customer mailing list for Direct Mailing and Telemarketing.

• Work with large customer response and sales data sets.

• Maintain and enhance existing SAS reporting programs for marketing campaigns.

• Maintain SAS statistical analysis for the products purchased every month.

• Conduct individual account and household level analysis. Conduct significance tests and study response rates for different offers

• Creating Data Models for different level of Marketing based on the reports.

• Create Statistical Analysis using Segmentation Analysis, Regression Analysis and Predictive modeling.

• Run reporting programs and download the results into EXCEL and build pivot tables.

• Presenting the results and statistical reports in PowerPoint for marketing staff.

• Work with Data Mart and Data Warehouse using Business Objects.

• Using SQL and PROC SQL Pass through Facility to work with Oracle, DB2.

• Work with Enterprise Miner for marketing campaigns doing statistical analysis.

• Move data set across platforms (from PC and Mainframe to UNIX and Vice Versa).

•

Environment: IBMS/390 and IBM compatibles, UNIX, WIN NT, BASE SAS, SAS/ MACRO, SAS/ SQL, SAS/ STAT,

SAS/CONNECT and SAS/ACCESS, DB2, ORACLE

March 1999 to February 2000

VITEX PHARMACEUTICALS, WATERTOWN, MA,

SAS Programmer Analyst –Clinical Trials

Vitex is a Biopharmaceutical company developing products designed to improve the safety of the

world’s blood supply and is conducting Phase III clinical trials, designed to inactivate a wide range of viruses, bacteria and parasites, and has demonstrated its ability to remove proteins, while preserving the therapeutic properties of red blood cells. As a SAS Programmer, my role was in analysis of clinical trials data and generating required reports, listings, summaries and graphs for submission to FDA and other regulatory authorities.

My Responsibilities Included:

• Worked on Phase I & Phase II of the Clinical Trials and analyzed.

• Produced Listings, Reports, Tabulations and Summaries of the clinical trial data using procedures such as Freq, Means, Univariate, Summary, Tabulate, Report, Transpose for statistical analysis by other Bio-statisticians.

• Provided input to planning documents such as Validation, Study Protocol and Statistical Analysis Plans.

• Extraction of data from Oracle, DB2, Access and Excel for further analysis using Proc SQL ‘Pass Through Facility’ and DDE.

• Created and implemented statistical analysis plans and specification documents; participated in database design, data collection guidelines, and logic checks.

• Conducted, documented and reported Data Validation inspection in compliance with FDA Regulations (21 CFR) and other regulatory compliance.

• Participated in designing, coding, testing, debugging and documenting SAS Programs and Macros.

• Developed SAS programs using Base SAS for tabulation counts, correlation’s and check for dispersion for normality using PROC Means, PROC Tabulate and PROC Univariate.

• Applied generally accepted Programming Standards and Techniques to assure efficient program logic and data manipulation.

• Created a SAS reports using the Data _Null_ technique and Proc Report for NDA submission as per FDA regulations and company standards.

• Formatted HTML, RTF and PDF reports, using SAS - output delivery system ODS.

• Writing Bourne scripts to load and execute the process .

• Involved in preparing study results as well as ISS and ISE for NDA submissions using SAS.

Environment: BASE SAS V8, SAS/ACCESS, SAS/CONNECT, SAS/GRAPH, SAS/STAT,

Excel, Access, Oracle8, Window NT/ 2000 and UNIX.

November 1998 to February 1999

Client: ICICI BANK LTD

Role: SAS Programmer

Developed Order Processing System (OPS) for Icici Bank. This system was developed for credit system which will take care of credit processing like checking credit history, credit limit, credit card processing. It will prepare claims and reclaims and generates various reports. As a System engineer part of my contribution was involved in the process of information retrieval and data management system designed to simplify typical programming task by accomplished SAS for various reports in a pre-defined format. Used arrays, macros, merges, sets, in files, data_null_s, do loops, libnames, librefs, formats, first, last; PROCS: DELETE, APPEND, SUMMARY, COPY, FREQ, MEANS, SORT.

My Responsibilities Included:

• Wrote the programs in SAS and to generate the reports.

• Created base macros to run reports. Created standard reports to use across studies. Created base programs to set up data.

• Responsible for data entry and conversions; data validation and corrections; uploading/downloading data from/to PC; statistical analysis of data for use in litigation cases; creating permanent formatted SAS data sets for present and future analysis.

• Wrote analysis plans including specifications for table’s listings. Taking raw data and creating datasets for all programmers.

• Extensively used DATA _NULL_, UNIVARIATE, SUMMARY, MEANS, FREQ, and GCHART procedures Ascertaining quality and standards for the code changes made.

Environment: Windows NT 4.0, UNIX Sun Solaris2.6, SAS6.12, SAS/BASE, SAS/Macro, Oracle.

EDUCATIONAL QUALIFICATION

Masters at Embedded Systems.

Bachelor of Engineering in Electronics and Communications.

Contact this candidate