SUMMARY

• Over 6+ years of experience as SAS Programmer and related SAS BI products administration on windows and Linux/Unix platforms
• Hands on experience in implementation of SAS EBI, EDI, EM, TM, MDM Tools on SAS versions 9.2, 9.3 & 9.4, suite of products and migrating from SAS 9.3 to 9.4
• Excellent noledge in SASBI on SAS9.3 & 9.4 platforms, including SAS Connect, SASOLAP Server, SASMetadata Server, SASObject Spawner, SASManagement Console, OLAP Studio, Data Integration Studio, Enterprise guide, Web Report Studio, SAS Connect Server, Slowly Changing Dimensions, SASEnterprise Miner, Platform RTM and SAS Environment Manager
• Extensive work experience in using Base SAS, SAS Enterprise Guide, SAS stored process, SASVisual Analytics, SAS/MACROS, SAS/SQL SAS/ODS, SAS/GRAPH, SAS/STAT, SAS/ORACLE, SAS/CONNECT, SAS/ACCESS and SAS/SHARE
• Proficient in using other procedures PROC PRINT, PROC SORT, PROC REPORT, PROC APPEND, PROC TABULATE, PROC PLOT, PROC GCHART, PROC IMPORT, PROC EXPORT and Data NULL to produce SASreports
• Work experience of LSF Platform, Platform RTM for SAS, SAS Grid, SAS server installation, configuration, administration and performance tuning, including SAS BI server, SAS Metadata server, SAS SPD Sever
• Utilization of SAS Management Console to maintain teh definitions for users, metadata access, database connections, registering stored processes, information maps, Monitoring SAS system performance, overall disk, CPU, Memory usage utilization and plan required upgrades
• Applying hotfixes periodically using SAS deployment manager and renewing SASlicenses
• Schedule SAS/UNIX jobs using platform LSF. Submit jobs to teh grid, view teh status and results using SASGSUB
• Establish and manage connections to different databases like SQL, NETEZZA, Teradata and oracle according to teh user requirement
• Restarting SASservers and Platform suite services in teh proper order for SAS 9.2 and 9.4 in SAS Grid.Good Knowledge of LINUX/UNIX commands and SHELL SCRIPING
• Involved in design & testing of ETL code, interface integration & database structures tobuild data marts
• Proficient in SASData Integration Studioto develop various jobs processes for extracting, cleansing, transforming, integrating and loading data into Data marts and Data warehouse database
• Strong skills in Data Analysis, Data Requirement Analysis, Data Mining, and Data Mapping for ETL process
• Familiar with FDA regulations, GMP, ICH, GCP and GLP. Knowledge of CDISC models like SDTM mapping and ADAM experience
• Performed data extraction from excel sheets using dynamic data exchange (DDE) and Macros.
• Provide guidance and assistance to SASDevelopers on operational and technical issues interfacing with teh SASInstitute for Support on administrative and system issues

TECHNICAL SKILLS

SAS BI Tools: SAS DI Studio, SAS OLAP Cube Studio, SAS Enterprise Guide, SAS Management Console, SAS Web Report Studio and SAS Information Delivery Portal

SAS System: SAS/BASE, SAS/MACRO, SAS/SQL, SAS/GRAPHSAS/ODS, SAS/STAT, SAS/ACCESS

Databases: Oracle, SQL, Teradata, Netezza, Informix, Sybase, Hadoop

Batch Server: UNIX, Putty, SSH, and SAS scripting

Languages: C, C++, PL/SQL, and HTML

Operating Systems: Windows, UNIX, Linux

Tools: MS Office 97/2000/XP, MS Excel, Power Point, MS Word and Access

PROFESSIONAL EXPERIENCE

Confidential, CA

SAS Administrator

Responsibilities:

• Maintaining SAS 9.3 M3 and SAS 9.4.
• Created SAS Depots for SAS 9.3 & 9.4 and related client installation documents
• Installed and configured SASPlatform Suite (LSF, PM, GMS) and Platform RTM
• Performing User Migration and Data migration (datasets and tables) from DSAP 9.3 servers to SAS Grid 9.4 servers and assisting users to fetch migrated data in teh grid.
• Installing ODBC drivers and creating SAS libraries for DB2, Oracle, SQL Server & Green plum, SAP Hana, GPFS.
• Maintaining SAS Server health, Installation of hot fixes, configure server tier, migrate and maintaining teh metadata in LINUX environment
• Efficient in writing SAS code to support teh development of an item and test analysis system
• Scheduling teh jobs and monitoring for day to day activities, escalating to technical if for any issues arises
• Created teh Metadata Server definitions and libraries connecting to external databases like Teradata by using SAS Management Console
• Created SAS OLAP cubes, SAS Information Maps and Stored processes for developing teh mock up reports and dashboards to teh end users
• Used SAS PROC procedure for grid enabling teh programs and analyzing teh legacy code for GRID modifications
• Used SAS Data integration studio for registering teh tables and creating teh libraries pointing to Teradata database
• Responsible for resolving all technical issues related to teh SAS upgrade Migration
• Updating teh stored process as per teh SAS code modification so that teh output statistics were pushed back to teh Oracle Database
• Analyzed teh legacy code and documented teh information to automate teh reports avoiding unwanted hard coding

Environment: SAS/BASE 9.4, SAS/MACROS, SAS/SQL, SAS/STAT, Mainframe, SAS/EG, SAS Information Map Studio, SAS Management Console 9.4, SAS Customer Intelligence Studio, SAS OLAP Cube Studio, SAS Web Report Studio. Excel, UNIX (SOLARIS), Windows, Oracle, SQL Server, SAS/Access Oracle.

Confidential, PA

SAS Administrator

Responsibilities:

• Worked as a SAS Administrator of SAS EBI platform for Solaris/SAS 9.3 migration to Linux/SAS 9.4
• Applied hotfixes and solved User Issues & any other Maintenance issues
• Effectively tested and packaged SAS components like JMP 9, SAS ActiveX graph and Enterprise Guide 6.1. These packages are pushed directly to teh user's computer minimizing teh efforts for a manual installation
• Creating and implementing upgrade plans, occasional after hour support when system OS or hardware maintenance required
• Developed and implemented real - time error-capturing code in SAS displaying various reports and model results on SAS Web Report Studio via SAS stored process
• Extracted data from DB2 and ORACLE databases using SAS/SQL Pass Through.
• Created new datasets from raw data files using Import Techniques and modified existing datasets using Set, Merge, Sort and conditional statements
• Performed data analysis, statistical analysis, generated reports, listings and graphs using SAS tools SAS/Base, SAS Enterprise Guide, SAS/Macros, SAS/Graph, SAS/SQL, SAS/Connect and SAS/Access
• Used SAS/Macros to optimize teh programs and reduce redundancy
• Responsible for creating new libraries for upcoming projects to teh end users in SAS Server usingSAS Management Console
• Created ETLprocesses using Data Integration Studio to load teh data from various data sources to teh Data Warehouse
• Analyzed existing SASscripts based on various platforms such as UNIX, Windows and Mainframe.
• Developed & Maintained Shell Scripts to automate teh Startup & Shutdown; monitor process/jobs status

Environment: SAS 9.4 Platform, Red hat LINUX, SAS Management Console, IBM Mainframe, SASRTM, SASData Integration Studio, SASEnterprise Guide, Maestro Scheduler, LSF Servers, LASR Servers.

Confidential, AR

SAS Programmer

Responsibilities:

• Performed data analysis, statistical analysis, generated reports, listings and graphs using SAS
• Experienced in handling Terabytes of records and manipulating them through SAS
• Used Enterprise Miner for taking data and converting them into required SAS datasets. Also, used teh SAS Forecast Studio for appropriate analysis of data for different Forecasting models like Time Series Forecasting
• Proficient in SAS Enterprise Guide build advanced querying, calculating computed columns, using filter, sorting, manipulate and prepare data for Reporting, Graphing, and Summarization, statistical analysis, finally generates summarization SAS datasets
• Using Information Map Studio to build information maps structuresand view teh information maps from Web Report Studio
• Build Selection Screens and Dash Boardsby using SAS stored process web application
• Experience in using proc SQL method to pull data from different data bases like Oracle, SQL, and Teradata
• Maintained large data sets, combined data from various sources in varying formats to create SAS data sets and/or ASCII files
• Used SAS/SQL for extract, transfer and load (ETL) methodology and processes
• Used SASEnterprise Guide to run statistical tests like ANOVA, Chi-square etc.
• Developed and maintained statistical documentation of SASprograms, results and discussion

Environment: SAS Web Report Studio, SAS Information Delivery Portal, SAS Enterprise BI Server, SASEnterprise Guide, SASAdd-In for Microsoft Office, Pl/SQL, SASStored Processes Web Application, Windows.

Confidential

SAS Programmer

Responsibilities:

• Extracted teh data from sources like Excel, oracle using SAS/Access
• Developed SDTM datasets (CDISC standards) from raw data and ADaM datasets from SDTM datasets
• Performed data validation and edit checks on ADaM datasets and TLG's for Clinical Phase me, II and III studies using various SASprocedures and Macro facility
• Created standard TLG's for ISS, ISE, CSR and Exploratory analysis for regulatory submission
• Developed Analysis datasets for Safety and Efficacy data. (Demographics, LAB, Adverse Events, Medical History, Physical Examination, ECG, Concomitant Medications, Overall Pain, Vital Signs, and Concomitant Medication) as per Statistical Analysis Plan (SAP)
• Maintaining large datasets and combining data from various sources in varying formats to create SAS datasets by using Set and Merge, joins for generating reports and Graphs
• Manipulated teh data and modified teh code using SAS functions and by using teh Proc SQL statements, Formats, Informats using Enterprise guide
• Extensively used Data null, Proc Freq, Proc Summary, Proc Mean, Proc Univariate, Proc Macros, Proc Tabulate, Proc Contents, Proc Compare, and Proc Report to produce teh reports
• Retrieved teh raw data from flat files, oracle database and converted to SAS data sets for Analysis using SAS/Stat procedures
• Created ad-hoc reports using various SAS procedures, SAS/Graph and SAS/Stat
• Used SASMacros extensively in analysis of standard clinical data and generated reports, graphs, listings, summaries, and tables
• Developed reports according to SOP's by using PROC TABULATE, PROC REPORT, PROC SUMMARY, PROC SQL and also provided descriptive statistics using PROC Means, Proc Freq
• Used SAS/ODS to produce teh reports directing SAS output to RTF and HTML files

Environment: SASEnterprise Guide, SAS/BASE, SAS/STAT, SAS/GRAPH, SAS/MACROS, SAS/SQL, SAS/ACCESS, SAS/ODS.

Confidential

SAS Programmer / Data Analyst

Responsibilities:

• Responsible for identifying, collecting, analyzing, and maintaining data to evaluate issues that support business decisions using SQL and SAS
• Analyzed data sets and generated SASoutput using PROC FREQ, PROC COMPARE, PROC CONTENTS, PROCSORT, PROC SQL and PROC REPORT etc.
• Creating and saving teh Macro programming into Macro library and maintaining Macro library to be used by all user in teh team
• Used PROC SQL LIBNAME and PROC SQL Pass-through methods to access data on Oracle database
• Cleaning data files to accommodate missing data, creating variables, use of aggregating commands, and various techniques of file merges to create results
• Involved in validating analysis data and prepared validation reports to resolve teh issues with analysis, files tracking and documenting study data information by working with statisticians
• Created tables using SASMacros, SASProc SQL and optimizing programs by using advanced SASProgramming techniques for development
• Performed ETL-Extraction/Transformation/Loading, Data Analysis, Data migration, Data preparation, Graphical Presentation, Statistical Analysis, Reporting, Validation and Documentation
• Performing analysis on survey responses and producing multi-dimensional reports using SAS
• Excellent Visual representation of data using Tableau, Excel and communicating analysis to all levels of business users within teh organization
• Documented teh policies and procedures required for supporting system enhancements
• Worked with Enterprise Miner for marketing campaigns doing statistical analysis
• Quality control and assurance including running datasets/files through programs

Environment: BASE SAS, SAS/MACRO, SAS/SQL, SAS/STAT, SAS/CONNECT, SAS/ACCESS, Unix and Windows, SAS/ENTERPRISE MINER.