Resume of SAS Developer

Title
SAS Developer

Primary Skills
SAS,Oracle, PL/SQL, Toad, Windows XP, UNIX

Location
Canada-QC-Montreal (will consider relocating)

Posted
Apr-05-07


Objective
To seek an exciting and challenging position utilizing my knowledge, skills and experience in SAS,Microbiology and working with large datasets on various platforms and several statistical analysis packages.

Professional Summary

• Three years of experience in SAS Base, ,Multivariate analysis,Macros, SAS Stat, SAS Access, SAS Graph, SAS SQL,SAS/ODS on Unix and Windows.
• Experience in analyzing medical claims data and interfacing SAS with MS Office applications such as Access/Excel.
• Expertise in developing PL/SQL Stored Procedures,Packages,Functions,Triggers and Tuning.
• Industry experience includes Health Care(Clinical Studies) and Pharmaceutical.
• Experience in working with customer support, quality assurance and debugging.
• Experience in producing external files and reports employing various SAS procedures, like _null_, ODS, Proc Print, Proc Report, Proc Summary, Proc Freq,Proc Mean, Proc Transpose, Proc SQL,
• Can effectively work as an individual contributor or a team member.
Tools and Methodologies
Databases: Oracle 10g,SAS Base (8.1,8.2,9.0),
SAS Macro,PL/SQL,SQL,TOAD,Acess,Excel, Proc Access,Proc SQL,SAS SQL
Pass
Languages : PL/SQL
Platforms HP UNIX 10.2,Sun Solaris 5.1, MS-Windows NT/XP/2003.
Industries :Health Care,Bio Tech and Pharmaceuticals .

Education :MSc in MicroBiology Nagarjuna University,India .

Professional Experience

Industry :Phramaceuticals
Client:Vitro Labs (P) Ltd Dec 2005 -- Till Date
Role : Sas Programmer
Worked with Non-clinical statistics unit of pharmaceutical company, developing computer programs to do the Statistical analysis of product sales, performance of sales department, regional sales, Monthly, Quarterly and yearly sales reports. The incentive compensation was taken care of in this project and the profit forecast was also done.
Responsibilities Include :

• Extensively involved in Oracle PL/SQL programming to create Triggers, database Packages Procedures/Functions etc. Creation of database objects like Tables, Views, and Synonyms etc.
• Developed new or modified SAS programs to load data from the source and create study specific datasets, which are used as source datasets for report generating programs.
• Transferring and migrating data from one platform to another to be used for further clinical analysis.
• Extracted data from Oracle using SQL Pass through facility and generated ad-hoc reports.
• Prepared, documented and tested required programs and procedure data displays in an efficient manner for inclusion in integrated clinical, statistical summary reports and other reports. Supporting other team members in designing and developing programs.

Environment: Windows XP, SAS 9.0, SAS/Base,SAS/Macro, SAS/STAT, SAS/ACCESS, SAS/CONNECT, SAS/ODS, SAS/SQL, Oracle 10g,PL/SQL,TOAD and UNIX 10.2.


Client:GRANULES (I) LTD Jan 2005 -- Oct 2005
Role :SAS Developer
Maintained SAS-based Medicaid fraud detection systems and related SAS and SQL programs. Updated and documented analytical programs, scheduled and executed production jobs, and ensured interoperability of the programs with the Department's Teradata data warehouse and other relational database systems. Used the Base SAS V8.2 and the SAS macro language to access a large relational database with Proc SQL processing files with at least 5 million records of health care claims data.
Responsibilities Include :
• Understanding the Business and its Requirements
• Gathering the requirements from user
• Extraction of data from Data Ware housing tables
• Modifying data using SAS/BASE and Macros.
• Preparing graphs using he modified data for business analysis
• Creation of Data Sets on the Remote server.
• Coordinating the production of monthly, quarterly, and annual performance reports for senior management.
• Extracting data from the database using SAS/Access, SAS SQL procedures and create SAS data sets.
• Creating SAS dataset from tables in Database using SAS/Access. Retrieved the Sales data from flat files, oracle database and converted to SAS data sets for Analysis using SAS/STAT procedures.
• Coding SAS programs with the use of Base SAS and SAS/Macros for ad hoc jobs.
Environment: Windows XP, SAS 8.2, SAS/Macro, SAS/STAT, SAS/ACCESS, SAS/CONNECT, SAS/ODS, SAS/SQL, Oracle 9i.


Industry :Health Care
Client:INDIA PENCILLINS LTD
Aug. 2003 -- Nov 2004
Role :SAS Developer/Consultant
IPL is a Biopharmaceutical company developing products designed to improve the safety of the world's health 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 DA and other regulatory authorities.

Performed experimental design, data collection as well as SAS programming
(drop/keep variables, sort, merge, concatenate/join files, etc. proc REG, proc
GLM, proc ANOVA, proc logistic, proc tabulate); imputed missing data, performed
time series analysis; developed Oracle database including analysis, design and
modeling; created tables, constraints, indexes, views, sequences, triggers,
stored procedures; tuned SQL statements.
Responsibilities Include :
• Successfully designed and implemented statistical reporting processes for regular data collection and clinical data analysis.
• 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 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.
• Attended project team meetings, worked with Bio-Statisticians, Data Managers, and Clinical Research Managers as appropriate. Reviewed and provided feedback for Data Integrity Plans.
• Coordinating the production of monthly, quarterly, and annual performance reports for senior management.
• Extracting data from the database using SAS/Access, SAS SQL procedures and create SAS data sets.
• Creating SAS dataset from tables in Database using SAS/Access. Retrieved the Sales data from flat files, oracle database and converted to SAS data sets for Analysis using SAS/STAT procedures.
• Prepared graphs using the modified data for business analysis.

Environment: Windows 2000, SAS 7.0, BASE SAS,SAS/MACRO,SAS/STAT, SAS/ACCESS, SAS/CONNECT, SAS/ODS, SAS/SQL, Oracle 8i.

References : Avaliable Upon Request

Certifications
See above


You must be logged in and have a current resume access subscription. Login or Register »

View all resumes in Canada-QC-Montreal »
View all resumes in Canada-QC »

View other SAS Developer resumes, Programmer / Developer resumes