SUMMARY

• Over 10 years of experience in software development industry with excellent communication and interpersonal skills.
• Extensive client interaction, analysis, designing, coding, implementation, documentation, support, restructuring, and enhancing products experience.
• Having SAS experience involving phase II, III studies, using BASE SAS, SAS/MACRO, SAS/ACCESS under Windows XP and UNIX Environment.
• Proficient in understanding of Clinical trial practice, procedures and methodologies.
• Experience in Clinical Data Analysis, Producing Reports, Listings, Tables, CRT’s (Case Report Tabulation), Summaries and Graphs from clinical trial data.
• Excellent knowledge in Proc SQL, CDISC, SDTM and SDTM plus, All domains, Suppquals and Relrec
• Excellent experience in using SAS/ACCESS Proc export/import to import and export data various external data files from and to SAS library.
• Developed and maintained programs in SAS on windows and Unix platforms.
• Expertise in developing data analytics solutions using SAS, Oracle, Sybase, MS-Excel and software solutions under Windows and UNIX environment using MS Access, MS SQL Server 2000, Actuate e.Reporting 5.0, and Crystal Reports 7.0.
• Experience working in Financial, Insurance, Entertainment and Marketing Research Industries.
• Proficient in the areas of developing and debugging SAS macros to create generic code to transform and analyze clinical data.
• Basic knowledge of Financial Accounting, Managerial Accounting, Statistical Analysis, Security Trading.

EDUCATION

• Oracle Clinical Programming/Data Management
• BASE SAS CERTIFIED.
• Certified Bioinformatics Specialist(CBS)
• M. S. (Computer Information Systems)
• M. S. (Statistics)
• B. S. (Statistics)
• Certificate course in Oracle and Developer
• Diploma in Computer Studies

SKILLS
Tools
Visual Basic 6.0, PowerBuilder 6.0, Jam 7, Developer 2000 (Forms 4.5, Reports 2.5), SQR 4.0, SQR Workbench 4.0, JavaScript, VBScript, ASP, HTML, Actuate 4.0, ERWIN 3.5/4.0, SQL Advantage, Sybase Central, DBArtisan 5.1, Autosys 3.x, Crystal Reports (4.0, 5.0), Lotus Notes.
Oracle Clinical v4.5.3.

DBMS
Oracle 8.x and 9.x, Sybase (11.x, 12), Microsoft Access 2003

Languages
Java (JDK 1.1 & 1.2), PL/SQL, SQL, Sybase Transact SQL, Perl 5, Shell, SAS 9.1

O/S
UNIX (HP-UX, AIX, Solaris), Windows (XP, 2000, NT 4.0, 98, 95, 3.x), DOS

EXPERIENCE

Programmer Analyst, Confidential,NJ (Jan\'09-Dec’09).

Therapeutic studies: Eye Exams in the Safety Follow-up on healthy subjects and postmenopausal women with overactive bladder, Postoperative Dental Pain Study, Diabetes, Gyn, type 2 diabetes mellitus,Osteoarthritis, and Rheumatoid Arthritis at different phases of clinical trials..

Responsibilities:

• Develop and document programs to create analysis, datasets summarizing key clinical trial data.
• Used proc means, freq and Univariate procs to provide descriptive statistics.
• Used SAS sorting, merging, set techniques on datasets to merge the datasets.
• Develop and document programs and to produce tables, listings and other reports and analyses summarizing clinical trial results using SAS/Base, SAS/Macro.
• Perform and document quality control checks for programs. Assist with analysis planning including review of table and listing mockups and analysis dataset requirements.
• Performed validation and QC of analysis datasets, tables and listing.
• Used format/informat to transform data.
• Involved in periodic audits to ensure compliance to SOP\'s.
• Created analysis datasets using the raw dataset (metadata) created through oracle used as repository.
• Successfully generated Tables and Listings shells as per protocol and under the guidance of Statistician for Phase III study.
• Performed UAT testing using CDR Standard Business Rules/Database Derivations on Inform, SDTM plus and SDTM plus unblinded data.
• Created reports for Medical Monitoring using inform data.
• Created PRS for the tables and datasets.
• Helped in creation of annotated eCRF.
• Helped in the preparation of Item11 and did validation by cross checking data with ecrf.
• Got training in SDTM, CDISC, and IREVIEW.
• Did CSR review and CSR UAT for tables in all stages. Did Validation by double coding for the programs written by Vendor. Used PRS and Independent Programming testing checklist for validation.
• Database Creation and Table Programming for Integrated Summaries of Safety (ISS).

Confidential,SAS Programming for Confidential,PA (Sep \'08-Dec\'08)

Responsibilities:

• Worked on raw clinical data to create sas data sets.
• Prepared numerous deliverables including statistical tables, data listings and statistical reports.
• Used SAS sorting, merging, format , informat, keep & drop techniques on clinical trial data to prepare analysis data sets, adhoc reports and check programs.
• Used SAS/Macro facility to provide reusable code that can be used frequently.
• Used proc means, freq and Univariate procs to provide descriptive statistics.
• Used SAS Fundamentals, Programming, Report Writing, ODS, Macro Language and SQL Processing.
• Create SAS Customized reports using the Data null_ technique.
• Produced reports using the proc tabulate, report and Summary.

Senior Programmer Analyst, Confidential,Middletown, NJ, USA (Nov ’05 – Apr’08)
(Consulting through Comsys, Inc)

New Metrics For Customer Intelligence.
Evaluate new metrics derived from integrating access cost and revenue at the enterprise level to improve customer profitability.

TARGET – ALS
TARGET is an Intranet-based management-reporting tool that supports AT&T Local Services Activities for monitoring sales effectiveness, managing opportunities and achieving revenue growth.

User Internet Scoring (UIS)
This study compares the profiles of customers with online activity to those that do not have any online activity. Online activity at the email level has been aggregated to the customer
(agid) level.

Responsibilities:

• Data mining. Extracting data from flat files into SAS dataset. Using SQL & PL/SQL for querying the database.
• Activities for monitoring sales effectiveness, managing opportunities and achieving revenue growth. Handling adhoc requests for reports from various data sources.
• Used SAS procedures like proc print, report, sort, sql, tabulate, frequency, format, means etc to create ad-hoc queries macros and reports.
• Creation of flow charts and control charts to document the applications.
• Developer in SQL & PL/SQL. Coding Unix shell scripts for extracting data from flat files for ad hoc / on-demand requests from customers. Using SAS/BASE to analyze the data. Creating, reading, reporting, Merging SAS data set, writing SQL code using SAS.
• Create SAS Customized reports using the Data_null_ technique.
• Produced reports using the proc tabulate, report and Summary.
• Worked on proc sql to create output datasets.
• Extensive use of SAS programming i.e. SAS procedures in Base SAS , Macros.

Senior Programmer Analyst, Confidential,Edison, NJ (Feb ’02 – Feb ’03)
(Consulting through HiByte Systems, Inc)

Gene Prediction & Analysis
The project used Sequence analysis, Gene prediction, Gene expression data analysis, Algorithm development and EST applications, Reconstruction of metabolic pathways, Automation of data acquisition, Integration and analysis using Perl, SQL, PL/SQL, Oracle 8i and CGI scripting.
Clinical Trial studies
This project involved creation of Analysis datasets, tables, listing and reports.
Developed programs for phase II and phase III clinical trials.

Responsibilities:

• The Statistical Analysis was done using SAS. Created datasets from raw data.
• Created reports using data _null_, proc report
• Created frequency table in the list and grid format using proc freq, proc univariate, proc means.
• Designed and developed web based (html) and rtf reports using Output Delivery Systems (ODS).
• Performed validation and QC of analysis datasets, tables and listing.
• Used SAS/Macro facility to provide reusable code that can be used frequently.
• Created SAS transport file from SAS datasets.
• Worked with different clinical trials data like Demographic, Adverse Event (AE), Serious Adverse Event (SAE), Laboratory-chemistry/Hematology/Urine analysis and Vital signs etc.
• Maintaining and enhancing existing SAS reporting programs for Clinical Data Analysis
• Produced customized reports by using PROC TABULATE, REPORT, SUMMARY and also provided descriptive statistics using PROC Means, Frequency, Univariate.
• Using SAS and SAS tools the Clinical trials data performed sorting and merging techniques to prepare and validate data for the input data sets, to get the required output and then writing the code using SAS tools.

Senior Software Analyst, Confidential,Rutherford,NJ (Jul \'01 – Jan’02)

Aged Inventory Reporting System
Aged Inventory Reporting System (AIRS) is used by the Pricing Policy and Control Group to implement the SSMB\'s policy for aged inventory of Equity, Bond, Fixed Income Security and FX trades. AIRS calculate the reserve for a strategy position based upon the age of the trades that makeup the position.

Responsibilities:

• Sybase stored procedures, triggers, creating database objects to incorporate new functionality.
• Application performance tuning - involving database redesign, procedures and triggers tuning.
• Production support, bug fixing, correcting data problems.
• Interacted with clients to refine and implement the requirements.
• Unix Scripts to invoke the stored procedures.
• Used Base SAS for reporting and tabulating data using different SAS procedures.
• Created reports using data _null_, proc report.
• Created frequency table in the list and grid format using proc freq, proc univariate, proc means.
• Designed and developed web based(html) and rtf reports using Output Delivery Systems (ODS).

Associate Consultant, Confidential,Edison, NJ (Oct \'00 – Jul ‘01)
Client: St. Paul Re-Insurance, NY

Global Reinsurance System (GRS) project. A web based reporting tool for providing MIS and customer reports to offices of St Paul Re worldwide. Reports provide the users with the information about the inward underwriting data, risk evaluation and customer history.

Responsibilities:

• Developed MIS and customer reports using SQR 4.0, Sybase 11.5 running on HP-UX 10.20.
• Developed data processing and loader batch programs using C/Perl and Sybase Transact SQL stored procedures.
• Created triggers and database objects to incorporate new functionality.
• Involved in performance tuning and web enabling existing SQR reports using Actuate 4.0.

Software Engineer, Confidential,RI (Aug \'98 – Jul ‘00)

VenueGame
VenueGame product developed for the super markets. An instant win game developed for the player express machines where the customer can place the wager and get the instant result.

PlayersDirect
PlayersDirect application for Lotto, Keno, Power Ball, Buckeye5 games. The application facilitates the game organizers to store the personal information about players and their preferences.

Retailer Management:
Retailer Management application manages information about all the retailers of lotteries.
The application was developed using Visual Basic 6.0 forms and Crystal Reports 4.0.

Responsibilities:

• Developed Transact SQL scripts in Sybase 11.5, DBArtisan 5.1
• Developed Perl and Shell scripts in Unix.
• Created the C/Unix scripts for loading the database from the flat files.
• Created reports using SQR 4.0, Transact SQL, Crystal Reports 5.0 and VB 6.0.
• The back end was also converted to support Oracle 7.3/8i running on DEC-Alpha for the overseas clients of GTECH. Telnet sessions were used to connect the game terminals to the Server.
• Developed the application using procedures and triggers in Transact SQL in Sybase 11.5.