SUMMARY

• Over 7 years of experience in analysis, design, development, testing and implementation of Pharmaceutical, Statistical and Client/Server applications using SAS, Oracle.
• Has extensive experience with SAS Programming, Clinical Trials (Phases I - IV), Reporting Tools, Object Oriented Programming, Oracle and PL/SQL.
• Worked with Statisticians to provide SAS programming in analyzing the Clinical Trial Data, generate reports, tables, listings and graphs.
• Worked closely with CRO’s for efficient Clinical Data management and Clinical Data Analysis.
• Developed SAS programs to cleanse and verify/validate data and also worked on various validation techniques.
• One plus years of experience in Market Research methodologies like Quantum, Quanvert and SPSS.
• Proven skills in data cleansing, data archival, data migration, ad-hoc reporting, and coding using SAS on various environments.
• Proficient in SAS 9.1,9.2,9.3,9.4, SAS/BASE, SAS/MACROS, SAS/QC, SAS/GRAPH, SAS/ACCESS, SAS/ASSIST, SAS/SQL, SAS/Connect and SAS/ODS.
• Created clear and easy to follow documentation, charts and PowerPoint presentations.
• Extracted, analyzed, validated and presented data for standard and ad hoc reporting purposes.
• Strong familiarity with data preparation, processing, classification, and forecasting.
• Strong understanding of data mining models, structures, theories, principles and practices.
• Excellent experience in query writing and report generation.
• Analyzing data and finding the root cause of the problems.
• Strong communication, interpersonal and organizational skills, and able to work in a fast-paced and team environment.

TECHNICAL SKILLS

Programming Tools: SAS 9.1,9.2,9.3,9.4,SAS/BASE, SAS/GRAPH, SAS/SQL, SAS/MACROSAS/ODS, SAS/ACCESS, SAS/INSIGHT, SAS/ASSIST, SAS/STATSAS/AF, SAS/ETL and SAS Procedures

Data Mining Software: SAS and SPSS

Market Research tools: Quantum and Quanvert.

Operating Systems: Windows 2000/XP/9X, UNIX.

Databases: MS Access, SQL Server, Oracle.

Office Tools: MS-Office, Lotus SmartSuite.

Languages: C, C++, JAVA, and Visual Basic.

Website development software: HTML, XML, Java Script and MS FrontPage

Reporting Tools: Business Objects

PROFESSIONAL EXPERIENCE

Confidential, Farmington Hills, MI

SAS Programmer

Responsibilities:

• To read external data files using data-step commands such as in-file, filename and libname statements.
• Formatting the data sets read into SAS by using Format statement in the data step as well as Proc Format.
• Managing and carrying out the analysis using Teradata.
• Updating and maintaining systems for the user and enhancing the user interface whenever necessary.
• Maintaining accurate records of expenditures, directing preparation of expenditure projections, and submitting timely requests for additional funding (marketing) whenever required.
• Processing the collected and analyzed data by writing SAS procedures such as Proc ANOVA, Proc GLM.
• Reporting using data null and put statements.
• Occasionally performing Case-by-Case analysis.
• Exporting and importing the data between different platforms such as SAS, MS-Excel.
• Generating the graphs using SAS/Graph to see the trends and develop forecasts.
• Provide customized output using SAS/ODS in HTML and RTF format.
• Helping clients with PowerPoint Presentations whenever required.

Environment: SAS/BASE, SAS/GRAPH, SAS/ODS, Relevant SAS Procedures, MS-Excel, Oracle 8i, Teradata, DB2, Extensive SQL, Windows 2000.

Confidential, Philadelphia, PA

SAS Programmer

Responsibilities:

• Responsible for providing SAS programming and analysis support for Phase II through Phase III clinical study.
• Generate tables, listings and graphs, including Patient Demography and Characteristics, Adverse Events, Laboratory etc.
• Developed SAS programs to cleanse and validate the data.
• Wrote code using Base SAS & SAS/Macros to extract data from Oracle Clinical tables.
• Worked with bio-statisticians to gather and analyze the analysis requirements.
• Reviewed data from clinical trials and developed a strategy for how to present results to FDA.
• Generated summary reports for ISS and ISE analyses of clinical study for FDA regulatory submissions and publications.
• Implemented statistical analyses and produced tables, listings and figures.
• Created SAS views from Oracle database tables using SAS/Access and writing SAS programs using Base SAS and SAS/Macros to create SAS reports.
• Worked with statisticians in generating SAS analysis datasets, production of data listings, summary tables, and statistical analyses.
• Extensively used Proc Report to create reports.
• Worked closely with CRO’s for statistical analysis, related to clinical studies

Environment: SAS/ BASE, SAS/MACRO, SAS/STAT, SAS/GRAPH, SAS/CONNECT, SAS/ACCESS, SAS/AF, Java, Ms-Excel, Lotus Notes, Oracle 8i, Sybase and Unix.

Confidential, NJ

SAS Programmer

Responsibilities:

• Extracted data from Oracle tables using BASE/SAS and SAS/MACROS.
• Involved in converting Excel data into SAS datasets as per requirement.
• Investigated missing data and data anomalies in SAS datasets.
• Generated data listings, Summary tables, Categorical tables and graphs including Patient Demography, Characteristics, Adverse Events and Laboratory.
• Developed Edit check programs to clean invalid data from the database.
• Developed SAS Macros for data cleaning and reporting.
• SAS was for Pre-Processing data, SQL queries, data analysis, generating reports and Statistical Analysis.
• Involved in creating Transport-files for electronic submissions to FDA.
• Wrote several shell scripts in production job migration.
• Used Various SAS Procedures for generating reports.
• Worked with bio-statisticians to gather and analyze the analysis requirement
• Written intense QC documentation.

Environment: SAS/ BASE, SAS/AF, SAS/MACRO, SAS/GRAPH, SAS/CONNECT, SAS/ACCESS, SAS/IntrNet, JavaScript, HTML, Ms-Excel, Oracle 8i, Unix, Windows NT and Java.

Confidential, CA

SAS Programmer/Analyst

Responsibilities:

• Create electronic data sets (i.e., SAS transport files) for electronic submission.
• Involved in the process and IT infrastructures for Phase II, III and IV Clinical Trials. Ensured quality of dataset at the protocol level while working to deliver competitive advantage and cost efficiency to the company as a whole. Achieved these tasks by serving as member in data management team.
• Conducting, documenting and reporting computer validation inspections in compliance with 21 Code of Federal Regulations (21CFR), other regulatory compliance, data transmission and integrity check of the existing and in-house Clinical Trial Systems.
• Involved in preparing analysis plans, data analysis and statistical report writing presentations to FDA and programming of patient profiles for statistical reports.
• Created SAS Customized Reports using the Data Null technique for FDA evaluations.
• Involved in to reviewed data from clinical trials and developed a strategy for how to present results to FDA.
• Generate tables, listings and graphs, including Patient Demography and Characteristics, Adverse Events, Laboratory etc.
• Data preparation & validation: Drawing flowcharts indicating the input data sets, sorting and merging techniques to get the required output and then writing the code using SAS/Base includes SQL, Macros.

Environment: SAS Data Step, Proc Step, Proc SQL, Unix, Oracle, PL/SQL,VB, VB Script, SAS/Warehouse Administrator, HTML, MIS, Shell script, MS-Excel and PowerPoint.

Confidential

SAS Programmer

Responsibilities:

• Production of standard Reports
• Established Access control environment for Different users and groups.
• Creation of SAS master file that is done on a weekly and monthly basis: Used these weekly master files and Oracle databases for report generation.
• Data extraction from Oracle and convert them to SAS data sets.
• Copied SAS datasets using PROC COPY utility
• Created and maintained SAS datasets that are extracted from an ORACLE database which includes data and database management of project data in Oracle tables, programming in SAS and SQL for data management, analysis and presentation.

Environment: Windows 95/NT, UNIX, MS Access, MS Excel, SAS/BASE, SAS/MACROS, SAS/SHARE, SAS/GRAPH, SAS/ACCESS, SAS/STAT, SAS/ SQL and Oracle.

Confidential

SAS Programmer

Responsibilities:

• Provided statistical and analytical support to Consumer Economics, Planned and performed load research studies and analyses.
• Prepared statistical summaries and reports on customer load usage surveys for use in regulatory hearings.
• Worked for Phase I, II, and III Clinical Trials.
• Developed SAS macros for data cleaning and Reporting and to support routing processing.
• Also identified problems with the data, if there were any, and also produced derived data sets, tables, listings and figures, which analyzed the data.
• Worked closely with clinical team to analyze data definitions, summary tables and listing specifications.
• Worked closely with clinical data management team to support data integrity checks and adherence to data definition standards.
• Assisted in investigating and applying new SAS programming methods and techniques to enhance current systems by using various SAS macros and standard programming procedures.
• Designed SAS programs to access, validate and summarize health outcomes data (including validation of pre-specified derived variables).
• Ensured that analysis data and programming code met regulatory and company standards and those they were consistently structured to permit efficient programming and reporting.
• Used SAS/BASE, SAS/STAT, SAS/GRAPH, SAS/MACRO to implement statistical analysis procedures, generate reports and graphs.

Environment: SAS, Oracle, Developer/2000, Reports 3.0 and Win’98

Confidential

Data Analyst

Responsibilities:

• Responsibility of looking out for timely deliverables of various project requirements.
• Responsible for checking out the Cleaning/tabulation and editing programs.
• Suggesting more better and innovative ways (tools and processes) for executing jobs.
• Collaborating with team members to achieve the project goals.
• Maintaining quality and productivity standards for all the projects assigned.
• Process/check the research data (survey Weighting, data cleaning, data merging, data format conversion) using various tools and procedures.
• Confirm the types of deliverables for a particular project and deciding on the resources required for completing the same.
• Create tabulation/SPSS program and produce analyzable data tables on the back end according the deliverables requirements.
• Collaborating with team members to achieve the project goals.
• Maintaining quality and productivity standards for all the projects assigned.
• Suggesting more better and innovative ways (tools and processes) for executing jobs.

Environment: Windows 98/NT, MS Excel, Quantum, Quanvert, and Market Mind.