SUMMARY

• Over 7.5+ years of experience in SAS Administration, Installation and Configuration of SAS on single as well as multi server environments.
• Over 4+ Years of experience working with BASE SAS, Advanced SAS, SAS Data Integration Studio (DI), SAS Enterprise Guide(Point and Click Analytics).
• Experience in working with SAS on different platforms like UNIX and WINDOWS (both x64 and x32 bit mode).
• Involved in SAS Installation, Upgrades, Promotion, Migration, Patch and Hot Fixes.
• Create and extract Oracle tables from SAS and within Oracle by using SAS/ACCESS, SAS/SQL, dbload and SQL PLUS.
• Experience in handling large volume of data.
• Proven skills in data cleansing by applying Slowly Changing Dimensions(SCD Type2 Loader, Surrogate Key Generator), Data Transformations(Proc SQL, Append, Extract, Hash Mapping(Lookup), Data Validation, Rank, Splitter), Data Access Transformations(Table Loader, File Writer) and Analysis Transformations(Summary Statistics, Frequency Report).
• Experience using Unix Shell/Perl scripts to perform ETL, data processing and automation tasks. Set up customized ETL programs for efficient and automated list processing routines with error/exception handling capability.
• Involved in all stages of SDLC (Software Development Life Cycle).
• Experience in handling software development, enhancements, testing and documentation.
• Effective communications liaison between business and technical groups, creative and resourceful, problem solving with good decision - making capabilities.
• Self-motivated individual with strong technical & analytical skills. Always keen and eager to face up to challenges by means of novel and innovative ideas.
• Good on experience in administering SAS Visual Analytics 6.2(Data Builder, Explorer, Designer, LASR Analytic Server, Mobile BI)
• Hands on experience in setting up SAS Data Loader for Hadoop(including HortonWorks and Cloudera)
• Responsible as a single point of contact for all of the SAS issues that are outstanding and work with SAS tech support team to address on-going top issues
• Excellent UNIX scripting skills to develop monitoring scripts and alerts

TECHNICAL SKILLS

SAS: Base SAS 9.4/9.2/9, SAS/STAT, SAS Macros, SAS/SQL, SAS ODS, SAS GRAPH, SAS Data Integration Studio, SAS BI Dashboard, SAS OLAP Cube Studio, SAS Information Delivery Portal, SAS Management Console, SAS Web OLAP Viewer for Java, SAS Enterprise Guide, SAS Stored Process, SAS Information Map Studio, SAS Stored Process Web Application, SAS Web Report Studio, SAS Add-In for MS Office, SAS Grid Environment, Platform Suite for SAS(Load Sharing Facility, Platform Process Manager, Grid Management Services), Platform RTM

Tools: SAS Deployment Wizard, SAS Deployment Manager, SAS Migration Utility, SAS Disk Cleanup, SAS Install Qualification Tool, SAS Operational Qualification Tool, SAS Integration Technology Configuration, SAS Server Configuration Utility, SAS Renewal Utility, SASHFADD Tool, FTP/SFTP, WinScp, SQL Developer.

SAS Procedures: SORT, CONTENTS, TRANSPOSE, GPLOT, GCHART, FREQ, MEANS, SQL, REPORT, TABULATE, PRINT, PRINTTO, GLM, SUMMARY, UNIVARIATE

Databases: ORACLE, SQL Server

Programming Languages: C, Java, Unix(Shell/Perl)

Operating System: Unix-Linux, Win2008 Server, DOS, IBM-AIX, RHEL

PROFESSIONAL EXPERIENCE

Confidential, Wilmington, DE

SAS Platform Admin/Developer

Responsibilities:

• Responsible for SAS9.4 upgrade from SA9.2 environment
• Installing Components of SAS Grid Manager Software-Platform Suite (LSF, PPM, GMS), Platform RTM for SAS.
• Monitoring and Configuring SAS servers to run within a SAS GRID Environment.
• Verifying LSF commands like lsid, lshosts, lsload, bhosts, bjobs, bhist, bqueues.
• Maintaining the Platform LSF directory structure and Configuration Files(lsf.conf, lsb.hosts, lsb.queues)
• Experience with Enterprise Grid Orchestrator (EGO) and Grid Management Services (GMS).
• Monitoring Platform Process Manager (Flow Manager, Calendar Editor).
• Providing reports to monitor workload and resources through Platform RTM.
• Submitting SAS Programs, display job status, results and killing jobs using SAS Grid Manager Utility(SASGSUB)
• Administering Grid using SAS Management Console-Grid Manager Plug-in.
• Knowledge on Grid statements that are required to use SAS code on the Grid.
• Checking Grid SAS log Statements for troubleshooting.
• Enabling SAS Grid for Client Applications like SAS Enterprise Guide.
• Good Understanding of Grid Load-Balancing Algorithm.
• Validating LSF Setup, Information Files, LSF Log Files and SAS Job Execution Errors.
• Managing all GRID nodes from a centralized location.
• Adding users, registering tables, creating libraries using SAS Management Console.
• Installing SAS Metadata Server, Workspace Server, Pooled WS, Stored Process Server, OLAP Server, Object Spawner.
• Securing SAS Configuration on each server including Data Sets, Server Scripts, Server Logs, Configuration Files
• Setting up Metadata Folder Structure like Libraries, tables, OLAP Cubes, Jobs, Information Maps, Stored Processes, Reports.
• Administrative Tasks including Start/Stop/Refresh Servers, Administer Logging & monitor Status of Servers.
• Promoting Metadata Objects using SAS Export/Import Package Wizard.
• Maintaining Foundation Repository & Creating Metadata Repositories -Custom/Project.
• Backing up Metadata & Recovering Backup using Metadata Utilities.
• Backing up Physical files like Content Server, Stored Processes, Custom code using cp and xcopy commands.
• Monitoring SAS Servers and Spawners activity from Server Manager Plug-in
• Configuring Server Logging using Loggers and Appenders.
• Updating Passwords, SID, Existing Configuration, Applying Hot fixes using SAS Deployment Manager.
• Administering Users, Groups and roles.
• Registering Libraries and Tables in Metadata.
• Metadata Security including Permissions, Creating ACTs, Securing Content in the Folder Tree.
• Promoting Metadata content using Import/Export SAS Package option.
• Administering the SAS Web Report Studio and Information Delivery Portal.
• Maintaining SAS Deployment through Deployment Manager, License Renewal, Hot Fix(using SASHFADD Tool).
• Utilities like Analyze/Repair Metadata Wizard and OMABAKUP were extensively used.
• Deploying the jobs and Scheduling using Schedule Manager.
• Migration of SAS Metadata Content using SAS Migration Utility (SMU) and SAS Deployment Wizard (SDW).
• Installed and Configured SAS/Access to Hadoop and responsible for all connectivity related matters
• Used SAS Visual Analytics Designer to quickly create reports or dashboards, which can be viewed on a mobile device or on the web
• Integrating SAS Visual Analytics with Microsoft Products like Excel, Word etc.
• Integrating SAS Visual Analytics with SAS Enterprise Guide

Environment: SAS Management Console 9.4, SAS Enterprise Guide 6.1, SAS Data Integration Studio 4.7, and Platform RTM, Platform Suite for SAS, SAS Scheduling LSF/PPM, SAS Grid 9.4

Confidential, Chicago, IL

SAS Administrator

Responsibilities:

• Installing SAS platform Suite and necessary components to support Grid Environment.
• Experience in SAS GRID Configuration/Environments.
• Configure SAS servers to run within a SAS Grid Manager environment.
• Install, configure, and troubleshoot LSF Platform Process Manager in SAS Grid Manager Environment.
• Reading SAS logs to determine SAS Grid Manager errors.
• Adding nodes to the SAS Grid Manager environment and reconfiguring nodes.
• Configure SAS Grid Manager usage tracking, monitoring, alerts notification, load balancing and queues.
• Monitoring Workloads and Resources using Platform RTM.
• Installation of client applications and Troubleshooting technical problems.
• Renewing SAS license with SID (SAS Installation Data) files.
• Monitoring SAS Server resources and reporting usage(s).
• Creating users, groups, roles on the SAS Metadata server.
• Identifying performance and recommending/implementing tuning of active SAS environments.
• Backup and Restore of Metadata using OMABAKUP macro.
• Scheduling backups using jobs in SAS Management Console & PPM/LSF.
• Assisting desktop application users on Connection Profiles to Metadata.
• Providing Metadata roles to Users in SAS Management Console.
• Administering Data Access like SAS Data Sets, RDBMS Tables and ODBC Data Sources.
• Updating Table Metadata using SAS Management Console, SAS EG and METALIB proc
• Pre-assigning libraries based on requirement in Metadata and Server autoexec file.
• Securing Metadata using Access Control Templates (ACT).
• Providing different Metadata Permissions.
• Promoting Metadata using Export and Import SAS Package Wizards.
• Connected to the SQL database and extracted the relevant data (using LIBNAME or Pass-through facility) and then processed the data using business logic to produce reports.
• SAS Procedures used are Proc Append, Import and Export, Proc Transpose, Proc Datasets.
• Used Enterprise Guide (EG) query builder to run queries against the tables and sub setting the data
• Exported SAS Reports to the Excel sheet by using ODS/Tagsets/Excel to get output in multisheets.
• UsedSASData Step logicsto Sort, Merge, Stack, Update and Interleave datasets for producing required analysis of data and usedSAS Business Intelligence (BI)to produce required Reports.
• Created various summary reports ofvarious regions and also presented the demographic reports using theInformation Delivery Portal and theDash Board Portlets.

Environment: BASE SAS 9.3, SAS/EG 4.2, SAS DI 4.2, SAS OLAP Cube Studio, SAS Information Map, SAS Web Report Studio, SAS/MACRO, SAS/SQL, Oracle 9i, SAS ODS, SAS Management Console 9.2, Platform RTM, Platform Suite for SAS, SAS Scheduling LSF/PPM

Confidential

SAS Platform Administrator / Data Analyst

Responsibilities:

• Good understanding of SAS layered Architecture and its framework.
• Installation and Configuration of SAS using SAS Depot Manager.
• Creation of Roles, Groups and Users.
• Using the %OMABAKUP Macro to Perform Backups and Restores
• Analyze/Repair Metadata using SAS Management Console's Metadata Manager
• Password changes using SAS Deployment Manager 9.2
• Troubleshooting SAS Issues and System Level Changes.
• Adding new libraries to the Metadata Server
• Checking the status and operations ofSASservers and processes, including starting, stopping, and/or pausing the servers / processes used in theSASsystem
• Managing metadata repositories
• Monitoring, logging, and/or troubleshootingSASservers and processes, including error messages and using system logs or setting logging options as well as options withinSASManagement Console (SMC)
• UnderstandingSASinstallation directory structures related to servers, SAS Scripts, configurations, content, etc
• Imported SAS datasets from SAS Management Console to SAS information Map Studio
• Using information map studio combined relational data table, calculated new data items, and created multiple pre-defined filters
• Build quick reports from web report studio using information maps, create filters, graphs and customize reports
• Using SAS stored process created selection screens, web reports and dash boards
• Designing and developing reports for the Market risk, Asset Management Data and FSA Reporting.
• Involved in creating the In-Text tables for the TLF’s (tables, listings, figures).
• Created derived SAS datasets as appropriate.
• Extracted data from Oracle database to Excel and SAS.
• Used procedure like TRANSPOSING, TABULATING, SORTING, etc. in Data transformation and Manipulation processes.
• Created tabular and graphical reports and summary statistics using PROC TABULATE, PROC SUMMARY, PROC PRINT, PROC GCHART and PROC GPLOT.
• Investigated missing data and data anomalies in SAS data sets.
• Advanced querying using SAS Enterprise Guide, calculating computed columns, using filter, manipulate and prepare data for reporting, graphing and summarization, statistical analysis, finally generates SAS datasets.
• Installation and Configuration of Enterprise Miner 6.2 in single machine using SAS Deployment Wizard.

Environment: Base SAS, SAS Management Console 9.2, SAS DI 4.2, SAS Enterprise Guide 4.2, SAS Information Map Studio 4.2, SAS Web Report Studio 4.2, SAS Olap Cube Studio 4.2, SAS Management Console 9.2, Oracle, SAS Enterprise Miner6.2