Understand and manage data warehouse structure for optimum storage and query performance. Modules: SAS/BASE®, SAS/ACCESS®, SAS/STAT®, JMP® software Clients: Cema Distribution, Amgen - Safety Department, Miravant Medical Technologies, Timely Technical Solutions, SMCI, Westech

Projects: Management of Sales, Marketing and Inventory data for distribution center- Processed upto 40 million records of information on US Sales, Inventory, & Orders. Managed data on Retail Sales and Advertising Expenses Prepare adverse events files and datasets for Safety Dept. Datamart Worked with ClinTrials Software to extract data files for analysis Documentation, Data validation, Data cleaning & Data edit checks Convert between JMP files and SAS� Datasets Creation of a Single Integrated Statistical Analysis Dataset Prepared SAS� files to be sent to FDA with submission

Publications: "An Alternative Method of Transposing Data Without the Transpose Procedure" - SUGI ‘97, South-East SAS� Users Group Meeting ‘95, San Diego SAS� Users Group & Western Users of SAS Software ‘95 - Best Contributed Paper "Selectively Processing SAS� Datasets-Technical Tip" -PharmaSUG Newsletter ‘97 "Database Design Strategies in CANDAs" - PharmaSUG ‘96 - Best Contributed Paper

 

Copyright 2011, Gupta Programming. All Rights Reserved