SUMMARY

• Oracle and SAS certified programmer with over 8+ years of experience in software programming in Healthcare, Clinical trial, Pharmaceutical Sales and Supply Chain Industry.
• Extensive experience in SAS: SAS/BASE, SAS MACRO, SAS/STAT, SAS/ACCESS, SAS PC.
• Experience in extracting data and creating SAS datasets from different data sources like Oracle database, Access database Excel, Flat files using SQL Pass through facility.
• Proficient in concepts of Data Cleaning, Data manipulation, Data Analysis, Forecast, Data warehousing and Statistical analysis.
• Extensively used SQL, PL/SQL for Analytical Functions, Regular Expressions, Pivot/UnPivot, Recursive WITH Clause and Connect By clause. Developed database objects like Stored Procedures, Functions, Packages, Triggers and Cursors. Used SQL Loader to load data.
• Familiar with R Programming, Medicare and Medicaid, Auditing, Compliance and Guidelines ICH, GCP, 21 CRF Part 11, FDA, HIPAA, CMS.
• Strong written verbal and inter personal skills and work in collaboration with team members.
• Quick learner and hard worker, easily adaptable to newer tools and technologies

TECHNICAL SKILLS

Operating Systems: MS Windows 95, 98, 2003, 2007, UNIX, DOS

Programming Languages: SAS, SQL,PL/SQL, R

Databases: Oracle 8i/9i/11g, DB2 AS400, Teradata, SQL Server 2000, MS Access

Development Tools: SQL Navigator, Quest TOAD, DB Visualizer

Software: SAS: Base, Enterprise Guide 6.1, Forecast Studio 13.1, Oracle Clinical

Reporting Tools: Integrated Review, JReview 9.1, Web report Studio

Document Tool: EMC Documentum, VSS, CVS

Testing Tools: Winrunner 7.5,HP Quality Center 9.2/1

PROFESSIONAL EXPERIENCE

Confidential, Deerfield, IL

SAS Programmer Analyst

Responsibilities:

• Perform data analysis to monitor supply chain activities, logistics, synchronize supply with demand.
• Use UNIX Scripts, SAS programs and SQL queries to analyze and create datasets, run batch jobs.
• Extract data into SAS from DB2, Teradata, Oracle and Netezza databases.
• Create ODS output in using ExcelXP.Tagset, ODS excel, html for Excel output and embedded output.
• Automated emails with daily, weekly and monthly updates that save lot of time and effort. Set up automated failure report for team can take care of failed jobs directly.
• Create fusion tables, heat maps for regional sales using Google analytics.
• Mentor new hire to adapt the existing technology, explain concepts and usage to end users.

Confidential, Battle Creek, MI

SAS Analyst

Responsibilities:

• Shipment data is undergoes several transformations using data manipulation in an attempt to remove promotional activity to the Shipment using SAS Enterprise Guide
• Import data from
• The best method for Forecast of base material is derived using different Stat models in and by comparing data with APO Forecast
• Create Base Forecast, Ex Post forecast using a Univariate Model in SAS Forecast Studio
• Automated import, export and Forecast generation

Confidential, Oregon

Data Analyst

Responsibilities:

• Screen asymptomatic individuals for evidence of disease, conclude definitive diagnosis based on differential diagnosis, follow course of disease in patients and assess treatment impact. Perform descriptive statistics on patient data
• Screen asymptomatic individuals for evidence of disease, conclude definitive diagnosis based on differential diagnosis, follow course of disease and assess treatment impact
• Perform presentation, interpretation and reporting to data managers on finding

Confidential, New Jersey

SAS Business Analyst

Responsibilities:

• Created and maintained SAS datasets extracted from staging database using SQL Pass through facility. Combine and manipulate dataset using Set, Merge, Sort
• Reverse engineer existing programs to understand and modify the business rules
• Import SAS datasets from different sources into Excel and perform data Analysis and reporting, used DDE and automation.
• Manipulated dataset using Merge, Sort and roll up and create the projected sales data
• Support multiple therapeutic areas like Primary care, different specialties within primary care, Oncology, Managed care

Confidential, Oregon

Scientific Programmer

Responsibilities:

• Export data from Electronic health record and used dynamic data exchange and PROC Import to input data from excel sheets
• Developed SAS programs for Data cleaning, Validation, Analysis and Report generation
• Evaluate datasets using PROC MEAN, PROC FREQ, PROC SGPLOT
• Formatted HTML, RTF and PDF reports using SAS output delivery system
• Collect, Analyze, Debug and Test datasets using Base SAS
• Presented and explained outcomes to the physicians and the management as required

Confidential, New Jersey

Clinical Report Programmer

Responsibilities:

• Create clinical studies and annotated the CRFs using Oracle Clinical
• Worked in all four phases (Phase I through IV) within different therapeutic areas like Anti - Infectious, Cardiovascular, Immunology, Metabolic and Central nervous system.
• Created SAS Listings and Tables, Patient profiles, Graphs, Cross tabs, formatted Summary listing using SAS and SQL programs in iReview/JReview reporting tools
• Generate Clinical trial Global standard reports, MedDRA/WHO Dictionary reports, Study Conduct reports, Functional reports like Discrepancy reports, Adjudication reports, Reconciliation reports for FDA Submission.
• Coordinate with clinical staff of different teams to write report specification and define timeline
• Create analysis dataset from SDTM dataset and Involved in writing edit check programs, imputation to clean invalid data
• Used DATA STEP and Base SAS procedures such as PROC SORT, PROC MEAN, PROC DATASETS, PROC TRANSPOSE, PROC CONTENTS, PROC FREQ, PROC FREQ, PROC SGPLOT
• Provided programming support to data management and statistical programming teams