We provide IT Staff Augmentation Services!

Sas Administrator Resume

4.00/5 (Submit Your Rating)



  • 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 knowledge 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
  • 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 the 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 the grid, view the status and results using SASGSUB
  • Establish and manage connections to different databases like SQL, NETEZZA, Teradata and oracle according to the user requirement
  • Restarting SASservers and Platform suite services in the 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 the SASInstitute for Support on administrative and system issues


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


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


Confidential, CA

SAS Administrator


  • 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 the 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 the metadata in LINUX environment
  • Efficient in writing SAS code to support the development of an item and test analysis system
  • Scheduling the jobs and monitoring for day to day activities, escalating to technical if for any issues arises
  • Created the 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 the mock up reports and dashboards to the end users
  • Used SAS PROC procedure for grid enabling the programs and analyzing the legacy code for GRID modifications
  • Used SAS Data integration studio for registering the tables and creating the libraries pointing to Teradata database
  • Responsible for resolving all technical issues related to the SAS upgrade Migration
  • Updating the stored process as per the SAS code modification so that the output statistics were pushed back to the Oracle Database
  • Analyzed the legacy code and documented the information to automate the 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


  • 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 the user's computer minimizing the 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 the programs and reduce redundancy
  • Responsible for creating new libraries for upcoming projects to the end users in SAS Server usingSAS Management Console
  • Created ETLprocesses using Data Integration Studio to load the data from various data sources to the Data Warehouse
  • Analyzed existing SASscripts based on various platforms such as UNIX, Windows and Mainframe.
  • Developed & Maintained Shell Scripts to automate the 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


  • 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 the 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 the 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.


SAS Programmer


  • Extracted the 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 I, 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 the data and modified the code using SAS functions and by using the 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 the reports
  • Retrieved the 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 the reports directing SAS output to RTF and HTML files



SAS Programmer / Data Analyst


  • 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 the Macro programming into Macro library and maintaining Macro library to be used by all user in the 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 the 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 the organization
  • Documented the 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


We'd love your feedback!