Experience summary:
I have 3+ years of experience in SAS technology, proficiency in SAS/Base, SAS/Macros, SAS/Sql and SAS ETL Studio.
- Creation of new datasets from raw data files using Import Techniques and modified existing datasets using Set, Merge, Update, and conditional statements.
- Sorting of observations and elimination of duplicates using PROC SORT.
- Export the SAS datasets into a file format as desired using Proc Export and Data step.
- Conversion of Character to Numeric values by using INPUT and vice versa using PUT functions.
- Excellent programming skills in SQL and understanding of data management principles, such as joining data sets, data aggregation and sub setting using PROC SQL.
- Extensive knowledge of character, numeric and date functions.
- Usage of KEEP and DROP options at data step and Proc step levels according to requirements.
CAREER PROFILE
- Working as SAS Programmer/ETL developer for Satyam Computer Services Ltd,
- Worked as SAS programmer in Manipal Acunova Ltd,
- Worked as Insurance adviser for ING Vysya from Nov2001 to Jun2004.
TECHNICAL SKILLS
SAS Technologies: Base SAS, SAS-Macro, SAS-Sql, SAS-Graph, SAS ETL Studio.
Operating system: Windows 98/2000/NT.
Languages: C.
Data Base: SQL.
EDUCATION SUMMARY:
Bachelor of Business Management from Nagarjuna University, 1996-1999.
WORK EXPERIENCE:
Project - 6
Duration: Jun2007 to Till date.
Technology: SAS 9.1 ETL Studio, SAS/Base, SAS/Macros, SAS/Sql.
Environment: windows.
Industry: Pharmaceutical.
Description:
Clinical research on drug development is been done using sas. Our job is to support Data Warehouse team by developing ETL process. Extracting data from sources, transforming it as per requirement and loading it in DBMS. Purpose of ETL development is to provide error free data for analysis.
Responsibility:
- Extract data from source and transform.
- Responsible for ETL Development of Data Warehouse load processes
- Create and Maintain Data Warehouse Extract Transform & Load (ETL) Processes.
- Create Meta Data describing database design and attribute descriptions.
- Identification and resolution of problems encountered by the users of the system.
- Loading transformed data in targets and olap cubes.
- Supporting analysis team by providing data as per their requirements.
Project - 5
Duration: Nov2006 to May2007.
Technology: SAS/Base, SAS/Macros, SAS/Sql.
Environment: windows.
Industry: Insurance.
Description:
Market Research has been conducted to find the number of people with Health insurance coverage and without Health insurance coverage, based on Real median household income, female and male earning ratio, poverty rate, race, place, age, gender etc. And design new competitive insurance products. Our job is to extract data from source, transform and prepare data sets for analysis. Generate reports as per the requirement.
Responsibilities:
- Extract data from oracle database using SAS/Access.
- Cleaning data sets using data step and SAS Base procedures.
- Prepare data sets as per the requirement.
- Generate Reports, using Proc Report and Proc Tabulate.
- Generate graphs & tables and export them using ODS.
Project - 4
Duration: April2006 to Oct2006
Technology: SAS 9.0 (BASE, MACRO, SQL)
Environment: windows
Industry: Pharmaceuticals
Description:
The research was conducted on the drug for safety and efficacy. The client provides the case report forms. The data from the CRF’s is entered into oracle in tabular form. Importing of data, creation of datasets, cleaning, manipulation, validation is done using Data step and Base SAS procedures. The statistical procedures were applied as per the protocols provided by the bio-statistician. Graphical, html or PDF reports are generated according to the client specifications.
Responsibility:
- Cleaning of data using data step and SAS base procedures.
- Run descriptive statistics and statistical analysis variables in database.
- Involved in development and enhancements of SAS programs
- Highly developed planning and prioritization skills. Ability to create meaningful management reports from various sources.
- Ability to take minimal requirements and successfully completing a project by recommending options, solidifying requirements and implementing the application.
Project – 3
Duration: Nov2005 to Mar2006
Technology: SAS 9.0 (BASE, MACRO, SQL)
Environment: windows
Industry: Pharmaceuticals
Description:
Clinical trail has been conducted using sas. Aim of the study was to find safety and efficacy level of study drug. Study drug was assigned to subjects randomly. placebo was given along with study drug to check effects of drug in subject. Study has followed single blinded model. Code has been developed as per the requirement. Statistical procedures applied under the guidance of senior statistician. Graphs and tables are produced from the results and exported using ODS in required formats.
Responsibility:
- Importing data using base sas procedures.
- Validation and cleaning of raw data.
- Preparation of analysis data sets.
- Running statistics using sas/analyst.
- Generation of tables and graphs.
- Export results using ODS in Pdf and Rtf format.
Project – 2
Duration: April2005 to Oct2005
Technology: SAS 8.1 (BASE, MACRO, SQL)
Environment: windows
Industry: Pharmaceuticals
Description:
The research was conducted on the drug for safety and efficacy. The client provides the case report forms. The data from the CRF’s is entered into Excel spreadsheet. Importing of data, creation of datasets, cleaning, manipulation, validation is done using Data step and Base SAS procedures. The statistical procedures were applied as per the protocols provided by the bio-statician. Graphical, html or PDF reports are generated according to the client specifications.
Responsibility:
- Using Programming in SAS Base. SAS Macros
- Developed various analysis reports as per client needs.
- Using sas graphs. and proc report.
- Exporting the results using ODS.
- We create different proto calls.
Project – 1
Duration: Sep2004 to Mar2005
Technology: SAS 8.1 (BASE, MACRO, SQL)
Environment: windows
Industry: Pharmaceuticals
Description:
The research was conducted on the drug for safety and efficacy. The client provides the case report forms. The data from the CRF’s is entered into Excel spreadsheet. Importing of data, creation of datasets, cleaning, manipulation, validation is done using Data step and Base SAS procedures. The statistical procedures were applied as per the protocols provided by the bio-statician. Graphical, html or PDF reports are generated according to the client specifications.
Responsibility:
- Using Programming in SAS Base. SAS Macros
- Developed various analysis reports as per client needs.
- Using sas graphs. and proc report.
- Exporting the results using ODS.
- We create different proto calls
No comments:
Post a Comment