Sas Administrator M A

Bharath Manyam (SAS Administrator)

Email:***************@*****.***

Location: Herndon, Virginia

Phone: 678-***-****

Professional Experience Details (SAS Certified Platform Administrator):

15+ years of experience in installing, configuring and upgrading SAS 8/9.1/9.2/9.3/9.4 EBI on various Operating systems on prem and Cloud servers(Azure and AWS): AIX (5.x, 6.x), Red-Hat Linux(7.x,6.x), SUSE Linux (10.x, 11.x), HP-UX (11.x), Sun Solaris (9.x, 10.x) and Windows Server 2003/2008/2016 R2 and supported the developers and end users with installations and troubleshooting of SAS Enterprise Guide 7.x/6.x/5.x/4.x, PC/SAS, SAS Enterprise Miner, SAS OLAP Cube Studio 2.x/3.x/4.x, SAS Macros, SAS DI Studio 3.4/4.x, SAS Web Report Studio 4.x/3.x, SAS Add in for Microsoft Office 7.x/6.x, SAS Information Map Studio 4.x/3.x, SAS Deployment Wizard and Download Manager Version 9.x and implemented SAS Disaster recovery.

Installed and Configured SAS Grid on SAS 9.4 M7 on Azure VM’s E64-16 ds v4 instances using NetApp Files storage with performance of 120 MB/sec/core

Installed and configured SAS 9.4 M6 on AWS EC2 cluster nodes on EC2 instance type (i3.16 large), Comprised of 64 cores 8TB storage and EFS of 6 TB with a dedicated throughput of 350 MB/sec/cor for Research department at Kaiser for AI initiative for team of 200 users.

Installation and configuration of SAS VIYA on Red hat Linux 7.1.3, configuration of CAS server for in-memory capabilities and Cloud Analytics capability to integrate with other software’s mainly R, Python and Java.

Implementation/Installation and maintenance of Enterprise SAS Grid version 6.x/7.x/9.x on SAS versions 9.2, 9.3 and 9.4

Extensive experience on SAS Business Intelligence Versions 9.1.3/9.2/9.3/9.4 administration, including SAS/Share Server, SAS/Connect, SAS OLAP Server, SAS Metadata Server, SAS Object Spawner, SAS Stored Process Server and SAS Web Infrastructure kit.

Proficient in administration of BI tools from SAS Management Console, few of the daily activities include creating metadata users, groups, roles, server definitions (SAS BI servers and other Database server definitions like Oracle, Teradata, MS SQL Server, Netezza), ACT’s, Server libraries, importing the tables, code migration of the BI content from lower environment to higher environment, securing the data by providing appropriate permissions on both at Metadata server as well as at the Unix level, creating SAS metadata backup using the Backup Wizard etc.

Configuring SAS parameters such as SASWORK, UTIL, SORTSIZE, and MEMSIZE as per project needs in sasv9.cfg file and included tag-set libraries in SAS autoexec file.

Installation, Configuration experience in SAS Access Interface to Oracle 9i/10g/11i/12c, MS-SQL Server 2017/2019, & Teradata 12.x/13.x, Netezza, Sybase, ODBC data sources.

Supported SAS/STAT, SAS/GRAPH, SAS/IML. Assisting users in creating connection profiles from BI tools i.e. from Enterprise Guide, Information Map studio, SAS OLAP Cube studio and SAS Data Integration Studio software.

Troubleshooting the major SAS issues with help of Arm logging for ObjectSpawner, Metadata server logging on the servers.

Installed and supported R Software, Tableau administration, Tableau Desktop support and Business object web reports.

Experience in writing UNIX shell scripts that includes start and stop services of SAS in /etc/init.d boot file.

Experience with job schedulers: Control M, CA7 scheduler, Autosys scheduler, UNIX Cron utility.

Well versed with Proc SQL and libname statements for testing and validating queries

Migrating the SAS datasets from UNIX to Linux operating system with help of CEDA utility and Proc Migrate SAS procedure.

Worked on %OMABKP macro and deployment and backup recovery tool for SAS Metadata backups to backup and restore the SAS Repository, SAS Content Server. Worked with System admins for setting up daily net backups and incremental file system backups also worked on setting up GPFS snapshots.

Experience in On-Call 24x7 production SAS System Administration and very-large databases on Oracle, Teradata, DB/2, Netezza & SQL Server environment.

TECHNICAL SKILLS

Operating Systems

IBM AIX 5.x/ 6.x/7.x, LINUX SUSE 10.x/11.x Redhat 5.x, 6.x, 7.x HP-UX 11.x, SUN Solaris 9/10/11, Windows Server 2003/2008.

Languages/Technologies

BASE SAS, PROC SQL, UNIX shell scripting, Amazon Web Services, Docker, Ansible, Kubernetes, Python, Azure and AWS cloud

Databases

Oracle 8i/9i/10g/11g/12, Teradata 11/12/13, DB2, SQL Server2003/2008/2010/2016/2019 R2, Netezza, Sybase

Monitoring Tools

Tivoli, HP Open View (File Systems and Hardware usage monitoring)

Trouble Ticketing System

Service now, Remedy, Clarify Ticketing system

(For Incidents, Problems & Change Management Tickets)

SAS Enterprise Application Servers & Clients

SAS Grid installs Versions 6, 7, 9 on SAS 9.2, 9.3 and SAS 9.4, SAS Enterprise Server 8, 9.1.3, 9.2, 9.3, 9.4 install, Configure and Migration Expertise of SAS BI 9.1.3, 9.2, 9.3, 9.4, SAS Base 8, SAS/CONNECT, SAS/INTRNET Server, Enterprise Guide 4.0, 4.1, 4.2,5.3,6.1,7.1 OLAP Studio, Data Integration Studio, Web Report Studio, OLAP Viewer for Java, Enterprise Miner 5.2, 12, 13.1, SAS Access Interface to Oracle, DB2, Teradata, SQL Server, SOLARIS Enterprise Server Version, Solaris 2.5.x/2.6/2.8, Windows 2003, VERITAS Volume Manager 3x/4x, VERITAS File systems, Remedy 5.5/7.

EDUCATION & Certificates

1.Master of Science Texas A&M Kingsville

2.Certified SAS Platform Administrator

3.Certified SAS Developer

4.Azure AZ 900 Certified

PROJECTS:

Project

SAS Platform Administration and R Administration

Company

Geico Auto Insurance company

Technology

Azure Cloud Provider, SAS Grid LSF 10.1, Redhat Linux 7.9, SAS 9.4 M7, SAS Management Console 9.4, SAS Intrnet Servers, Enterprise guide 7.1,8.3 SAS Studio 4.x, SAS Add-in for Microsoft office, SAS Access interfaces to DB’s (SQL Server, Oracle, Netezza, DB2), SAS Connect Server, Platform RTM, Visual Analytics, Control M scheduler)

Role

Sr. SAS Administrator- Lead

Duration

Oct 2022 – June 2024

Location

Chevy Chase, Maryland.

Migrated SAS Grid Application from RHEL 6.8 to version 7.9 on 5 compute servers each had memory of 256 GB and 12 cores on to Azure Cloud. SAS Data had dedicated storage of 120 TB and SAS Work storage is setup for 12 TB.

Involved in active migration of SAS users, SAS data, Programs, Catalogues, Index files from RHEL 6.8 to new RHEL 7.9 on Azure Cloud.

Installed and configured new SAS LSF, SAS Metdata, Data services, Compute Services, SAS Access engines to ODBC, DB2, SQL Server, Oracle, Sybase via SAS deployment wizard. Created the necessary third-party installation for Database clients to connect from SAS Servers on Azure Vm’s instance type E64-16ds v4 with assured IO through put of 100Mib/sec/core.

Azure Netapp Files was used for shared storage for E64-16ds v4 instances providing throughput of 120 Mib/sec/core

Worked with Database administration team to connect to the data bases and ensure performance in Azure cloud from SAS VMs connections to DB’s is optimal.

Created the SAS libraries and registered the tables via SAS Management console. Provided the necessary security for accessing the libraries for appropriate metadata groups setup in Management console.

Customized the SAS options (memsize, sortsize, altlog, altprint, work, autoexec) as per the production job requirements. Actively supported the Geico’s critical business i.e. Pricing, Underwriting, Claims and Prism applications

Worked with storage team to setup the daily common-vault backups for SAS files systems

Worked on setting up SASGSUB customizations for 500+ SAS production jobs handled by service accounts and scheduled in Control M scheduler.

Worked with customer for storage capacity planning for upcoming next couple of years.

Actively participate on production on call on rotation basis and also trained the SAS admin team members to solve the tickets for issues by customers.

Installed, configured SAS Stored process servers. 32 stored process servers are configured to meet the demand of web stored processes for the customers.

Created the SAS ADSYNC script for loading Active directory users into SAS Management Console and scheduled the script to run every twelve hours.

Worked on setting up the LSF queues, Job slots, Graph threshold setup for CPU, I/O, memory utilization

via Report Track and Monitor tool

Provided training to SAS developers to convert the code from PC SAS 9.4 to Enterprise Guide 8.3 from Enterprise guide 7.1 and included best practices, SASGSUB batch submission.

Created the automated scripts for monitoring SASWork disk usage, Filesystem monitoring and email alerts using shell scripting

Used the Change Management Remedy to implement production changes and also worked on incident ticket creation and resolution for any production outages

Worked with SAS technical support for any major issues and customer performance issues.

Monthly SAS server maintenance i.e. apply SAS hotfix’s and also work with linux admin team for applying the patching for Linux SAS servers

Maintained detail documentation of process for any SAS and R activity and published it to the shared point.

R administration duties:

Installed and configured Posit Rstudio workbench and Posit connect for customers in Azure RHEL 7.9 VM’s

RSW workbench RHEL VM’s version 7.13 had configuration of 2TB memory and 5T storage

Installed and configured ODBC Driver manager and Clients to help connection to databases mainly DB2, SQL Server and snowflake

Configured the roles i.e. RStudio connect publisher and viewer and assigned the roles to customers to publish and view the shiny apps.

Performed the scheduled monthly maintenance of R servers along with updating R packages at system levels and upgrading the Rstudio and R connect servers on quarterly basis.

Project

SAS Platform Administration – SAS GRID Migration

Company

Concentrix Catalyst, End Client (Kaiser Permanente)

Technology

SAS Grid LSF 10.1, Redhat Linux 7.13, AWS, SAS 9.4 M6, SAS Viya 3.5, SAS BI 9.4, SAS Management Console 9.4, Enterprise guide 8.1, SAS Studio 4.x, SAS BI Portal, SAS Web Stored Processes SAS Add-in for Microsoft office, SAS Access interfaces to DB’s (SQL Server, Oracle, Netezza, DB2), SAS Connect Server, Platform RTM, Visual Analytics, CA7 scheduler,

Role

Sr. SAS Administrator- Consultant

Duration

June 2017 – Oct 2022

Location

Pleasanton CA, (Working remotely)

Installed and configured SAS 9.4 M6 software on Linux distributed RHEL 7.1.3 Virtual machines at Kaiser Permanente catering needs of over 3000 SAS analytics developers and power users.

Performed SAS performance testing and scalability of SAS servers on new RHEL 7.1.3 machines to meet the requirements that could sustain Kaiser’s business growing needs for future 6 years.

Migrated SAS data, programs from AIX physical servers of more than 140 Tera bytes in total storage using the RSYNC and migration utilities provided by SAS software which is mainly used by SAS software and its enterprise clients that include SAS Enterprise guide, SAS Enterprise Miner, SAS OLAP, SAS Text Miner and many other SAS clients to the new environment.

Worked with Kaiser’s SAS Council and project management team to breakdown the timelines for SAS migration for many divisions of business and successfully achieved migration of AIX SAS servers to LINUX RHEL VM SERVERS before the estimated timeline of 1.5 years.

Directly involved with Business teams to setup Operating system infrastructure mainly for storage and enable the security at OS and SAS level for onboarding new teams to SAS platform.

Setting up the SAS BI platform security, Metadata permissions and Metadata Folders security setup templates.

Worked with infrastructure Linux team support to implement the full system backups and incremental backups at OS level using GPFS snapshots.

Scheduled SAS Application server backup from SMC and Applications servers for Metadata backup, content server backup and used DBRT backup for environment backup that could be used for DR

Written SAS automation scripts / Utilities in OS shell and SAS programs to enhance the SAS grid migration and also monitor the critical SAS services based on TCP and Linux daemon monitoring.

Providing the production on-call 24/7 support, applying maintenance and working with Linux infrastructure team to during the Linux patches

Helping customers setup the Authentication domains, SAS Data Libraries and Database libraries and provide assistance in registering the libraries

Troubleshooting issues with SAS Job failures, optimizing queries and SAS BI reports for customers.

Worked on implementing SAS best practices for SAS environment variables and

Engaged in optimizing SAS programs and SAS SQL queries connecting to oracle, SQL Server databases

Resolved critical RHEL VM issues that impacted SAS web application servers by fine tuning the Linux Kernel and module updates based on SAS vendor recommendation

Worked on creating SAS reports for Governance purpose for tracking and creating chargeback models for customers based on usage of SAS Environments.

Providing the 24/7 paging support for customers for critical SAS production jobs and SAS application monitoring and alerting capabilities

Extensively worked on service manager for change and incident management to resolve the issues for customers and apply changes to SAS Platform.

Involved in creation to SAS security model code for Active directory Sync and setting up of Access control templates to secure the roles in SAS Management Console.

Conduct meeting and training sessions with SAS customers to get up to speed with best practices and provide new features that are updated by SAS vendor on quarterly basis

Administration of SAS security, user onboarding and scheduling SAS Jobs from SAS Management Console

Involved in installation of SAS Viya 3.5 software, setting up the CAS server and CAS libraries for customers, third party software integration with SAS like JAVA, PYTHON for CAS code execution

Involved in Administration and maintenance of SAS VIYA software using SAS Environment Manager

Performed SAS VIYA 3.5 Installation to render the visual dashboard reports via Kubernetes deployment and worked on maintaining and troubleshooted the issues via the SAS environment manager and Kubernetes Cluster administration for SAS VIYA cluster.

Worked on setting up the SAS DR servers for SAS Grid Application and SAS VIYA application and enabled replication of content via setting up continuous daily syncing of data

Kaiser Permanente department of Research SAS on AWS setup for a new AI initiative.

Installed and configured SAS 9.4 M6 on AWS EC2 cluster nodes on EC2 instance type (i3.16 large), Comprised of 64 cores 8TB storage and EFS of 6 TB with a dedicated throughput of 350 MB/sec for Research department at Kaiser for team of 200 users.

Changing AWS S3 keys on SAS servers on quarterly basis.

Worked with AWS infrastructure network support to setup the security groups for network access for SAS application ports to EC2 instances.

EFS storage was primary used for cross data availability between multiple platforms using Python, R and machine language

Project

SAS Platform Administration – SAS GRID Migration

Company

World Class work force LLC. End Client (Geico Auto Insurance)

Technology

SAS Grid LSF 9.1, Redhat Linux 6.8, SAS 9.4 M3, SAS Management Console 9.4, SAS Intrnet Servers, Enterprise guide 7.1, SAS Studio 3.x, SAS Add-in for Microsoft office, SAS Access interfaces to DB’s (SQL Server, Oracle, Netezza, DB2), SAS Connect Server, Platform RTM, Visual Analytics, CA7 scheduler

Role

Sr. SAS Administrator- Consultant

Duration

Aug 2016 – May 2017

Location

Chevy Chase, Maryland.

Geico’s SAS Grid Cluster comprised of 5 serves nodes operating on Redhat Linux version 6.8, Central shared filesystem is on GPFS version 4.1. Each node had memory of 256 GB and 12 core CPUs. IBM V7000 storage is used. SAS Data had dedicated storage of 120 TB and SAS Work storage is setup for 12 TB.

Involved in active migration of SAS users, SAS data, Programs, Catalogues, Index files from Single AIX server version 7 to SAS Grid storage.

Utilized Cport and Cimport script to convert the SAS data from AIX to Linux format to improve the performance while SAS jobs are reading the data.

Created the SAS libraries and registered the tables via SAS Management console. Provided the necessary security for accessing the libraries for appropriate metadata groups setup in Management console.

Customized the SAS options ( memsize, sortsize, altlog, altprint, work, autoexec) as per the production job requirements. Actively supported the Geico’s critical business i.e. Pricing, Underwriting, Claims and Prism applications

Created the SAS intrnet services for accessing the reports from IIS servers via web using the intrnet service and load managers in the backend. Supported 300+ web reports by various departments at Geico.

Created the SAS ADSYNC script for loading Active directory users into SAS Management Console and scheduled the script to run every twelve hours

Worked on setting up the LSF queues, Job slots, Graph threshold setup for CPU, I/O, memory utilization

via Report Track and Monitor tool

Provided training to SAS developers to convert the code from PC SAS 9.4 to Enterprise Guide 7.1 and included best practices, SASGSUB batch submission.

Successfully migrated 300 PC SAS licenses to SAS EG thereby reducing the cost for company

Provided support for SASStudio application and encouraged users to use this light weight web programming interface for creating SAS programs.

Configured the SAS access interfaces to Oracle, SQL Server, Netezza and DB2 clients.

Worked on setting up the alerts to monitor critical SAS services in SCOM and splunk tools

Handled the Production issues on an on-call via bi weekly rotation

Configured the Metadata and regular backups as per the business requirement.

Project

SAS Platform Administration – SAS GRID Installation (Implementation Group)

Company

World Class Work Force LLC, End client - Fannie Mae

Technology

SAS Grid LSF Symphony cluster 9.1, SUSE Linux 11, SAS-Foundation 9.x, SAS Management Console 9.4, Enterprise guide 6.1, SAS Studio 3.1, SAS Add-in for Microsoft office, SAS Enterprise Miner 13.1, SAS Access interfaces to DB’s (oracle, Netezza, Sybase, ODBC), SAS Share Server, PC SAS 9.4, SAS Application Server, SAS Web Server, Autosys Scheduler, Synchrony( File transfers), EPV( Password Encryption), Java JRE, Ant(Deployment tool)

Role

Sr. SAS Administrator- Consultant

Duration

May 2014 – July 2016

Location

Reston, Virginia.

Worked right from initial setup of Fannie Mae’s SAS Grid Architecture comprised of meetings and collaboration with multiple teams i.e., Linux Engineering, Storage, Network and Enterprise architecture.

Baselines were setup for SAS Grid performance for dedicated IO throughput of 150 MB/sec/core, as part of SAS Platform team conducted the IO tests for data read/writes on IBM GPFS file-systems on the DDN Infini Band.

Installed SAS Grid software on Fannie owned 9.1 LSF symphony cluster that comprised of 16 SAS Grid compute nodes. Each IBM 3650 SAS compute server is a 16-core capacity machine with 256 GB of memory, the operating system is SUSE Linux 11.2 SP3

Installed the Enterprise SAS grid BI software (constituted of five different installations on 16 Linux servers based on Fannie Mae’s heterogeneous license purchase from SAS), SAS Application servers, SAS Mid-tier (SAS-Studio, Eminer ), SASGSUB client utility from SAS Software Depot and completed the successful Validation, Linux PAM authentication and post install configuration steps.

Played a vital role in setting up of SAS Grid Migration plan of 450 Fannie Mae’s SAS Applications (scheduled to be completed 3rd quarter of 2016) from current UNIX Servers (AIX/Sun-Solaris) to SAS Grid environment. Worked on creating documentation for user session briefings, provided trainings to users on getting started with SASGSUB, Enterprise Guide and Enterprise Miner connection profile setup to submit the jobs to SAS GRID.

Worked with SAS Professional services and Linux Engineering team on setting up the SAS Grid High availability for the LSF cluster using F5 Load balancer and LSF EGO scripts that included the failover of critical SAS Metadata Server and restart check-pointing capability for SAS Object spawner on compute servers upon failure.

Interacted with SAS Grid operations team to setup the necessary LSF queues that are in compliance with Fannie Mae SAS Licenses.

Worked on data migration from UNIX to Linux servers with UNIX administrators using R-sync’s for application data migration and respective application teams were notified of successful data migration after final R-syncs were completed.

Created SAS Proc migrate script for changing the Unix SAS data sets formats to native Linux format on SAS Grid.

Collaborated with Database teams, Storage teams and Unix operations for setting up of Database clients (oracle, Sybase, Netezza, ODBC) and validated the Fannie utilities required for password encryption, Code version control (ICART / Clearcase), deployment tool (Ant), Synchrony for File transfer mechanism.

Worked with various application teams to configure the SAS parameters as per the application needs mainly autoexec, memsize, sortsize, saswork and other dependencies

Proactively troubleshooted SAS issues for the users on daily basis and did setup meeting to understand the business requirements for upcoming SAS projects to setup the necessary infrastructure to support the project.

Created the SAS Script for uploading the UNIX users to SAS Management Console necessary for authenticating users from BI clients Enterprise guide, Enterprise miner etc.

Forecasted the Data storage needs for applications and worked with Storage team to establish the space requirements sufficient for upcoming 2 years.

Provided the details for daily and incremental data backup needs to Backup team, Implemented the SAS Metadata Server backup from SAS Management Console.

Provided daily support for 2500+ SAS users in Fannie Mae following the incident ticket system in place.

Attended the CAB (Change control Approval Board) meetings which was mandatory before the implementation of high risk and medium changes

Applied the SAS hotfix’s on scheduled monthly basis to keep the server up to date and bug free.

Worked with Unix team to setup the SAS Startup scripts in /etc/init.d file

Implemented SAS Grid Environment manager to monitor the loads on SAS Grid server

Worked with Enterprise Packaging team for packaging the PC SAS 9.2, 9.4, Enterprise guide 5.1 and 6.1 software on Windows 8 platform.

Project

SAS Platform Administration – GRID Architecture (Implementation Group)

Company

World Class workforce LLC. End Client (CapitalOne)

Technology

SAS Grid installation 7.1, Process Manager, Grid Control Server, Enterprise SAS 9.3, SAS Metadata Server, SAS Foundation, SAS connect, SAS Share, SAS Scheduling Framework, SAS Object Spawner Server, SAS Access interface to oracle, SQL server, Teradata, CA-7 Scheduler.

Role

Sr. SAS Administrator

Duration

Jan 2013 – April 2014

Location

Richmond Virginia

Providing daily support and production maintenance of enterprise SAS Grid environments, catering the needs for 2000+ SAS Users, there are 42 Grid nodes in production SAS cluster each server node configured at 300 GB RAM and 4 CPU cores on each server operating @3.3GHZ, the operating system installed is Redhat Linux 6.4.

Installation and configuration of SAS Grid software on SAS enterprise 9.2 and 9.3 versions. As part of installation the products installed are Platform suite for SAS, Process Manager, LSF, SAS Grid control services, SAS Metadata Server, BASE SAS software, SAS Foundation, SAS Management console the client software mainly includes PC SAS, enterprise guide 4.3 and enterprise miner 6.x.

Worked on Metadata server sync and Password syncs scripts for all the users across the Grid server nodes.

Migration of Single SASDOME HP-UX Unix server to SAS Grid environment Redhad 6 Linux OS, which led to improved SAS jobs execution times, High availability and lower maintenance as adding capacity vertically with the downtimes on Single Superdome server was directly affecting the SLA’s for the business.

Worked in Dynamic Agile Version one Kanban process for project migration tasks.

Supporting the SAS applications, assist customers to grid-enable SAS jobs from various client programs such as SAS PC SAS, SAS Enterprise Guide, and SAS Enterprise miner tools.

Installation of Driver Managers and then follow with configuration of SAS Access interface to ORACLE 11.x, Teradata 13, DB2 and testing the Libname connection to the DB servers.

Setup up NFS Share file-systems for SAS executables, SAS Job Deployment directories and for source input and output data both in form of SAS data sets and raw data.

Creating LSF queues and required configuration using the lsb.queues and lsf.conf files.

Scheduling of SAS jobs is done through PCRON utility and control M scheduler for Production job scheduling

The Backup solution in place was using the netapp storage snapshots, which have a retention period for 2 months

Active Participation in monthly Stake holder meeting to provide the necessary metrics from SAS usage perspective and then estimate the Capacity planning for upcoming 24 months.

Installation and renewing the necessary SAS license SID’s, CART and Tree-net Licenses third party data mining software that works in conjunction with SAS.

Starting, Stopping and reconfiguring the LSF, Process manager and other daemons when making changes to the LSF configuration files

Creating projects for all Lines of Business for SAS users within both Card and Bank Divisions, i.e. setting up of LSF queues, SAS work Paths, working with Storage and UNIX teams to setup the permanent file-system storage and UNIX accounts as needed.

Adhering to the company policies for Production Change control activities, attend the CAB meetings for medium and high-risk change tickets, Service now is the capital one standard ticketing system.

Project

SAS Platform Administration – SAS BI (Implementation Group)

Company

Arignar Inc. End Client (Cardinal Health - Ohio)

Technology

Enterprise SAS 9.2 & 9.3 SAS BI, SAS Base, SAS Foundation, SAS Metadata Server, SAS Object Spawner Server, Unix Cron, SAS Connect, SAS Share, SAS Access interfaces to databases.

Role

Sr. SAS Administrator

Duration

April 2011 – Dec 2012

Location

Dublin, OH.

SAS Server Implementation on 9.2, 9.3 / Upgrade from SAS 9.1 to SAS 9.2:

Successfully installed SAS 9.3 EBI on SUSE Linux 11.x Operating System at the current site. Implemented new Backup utility in SAS 9.3 for taking the Backups.

Proactively completed the SAS upgrade from version 9.1.3 SP4 to 9.2 on IBM AIX 6.1 using SAS migration utility

Migrated Code and Datasets from old Server environments to the new SAS Environments using CEDA and PROC MIGRATE

Worked very closely with UNIX and SAN Hardware teams right from the starting till end of the projects until the migration efforts were successfully achieved

Conducted meetings with business teams on quarterly basis to understand their data needs and forecast the storage by working with the infrastructure UNIX and SAN teams.

Created group based security for users that are migrated into newly built SAS Environment by creating production scripts to get them automated

Moved SAS Developers along with their SAS BASE code to 9.2

Involved in transitioning application migration projects by separating groups within SAS hosted environments between two different hardware setups

Worked closely with Project Manager by targeting to complete in less than 120 days for upgrading SAS application from its existing environment

Involved in promoting SAS / Access Interface to Oracle, Teradata & SQL Servers on the newly build 9.2 setup by re-configuring its SASROOT! host specific files and tested with SAS User community by working with separate groups

Worked very closely with SAS Cary and used Plan file while implementing the new SAS 9.2 installation and achieved success in all SAS components while performing their sub-sequent test analysis both from Server side and SAS Client side by using SAS Enterprise Guide and SAS Base in Unix environment

Performed post installation procedures to make sure SASROOT file systems point to the new 9.2 installation by exporting external database client installations

Written UNIX shell scripts to automate certain SAS scripts based on stdout, stderr exit codes.

Customized by implementing SAS Batch scripts to make jobs run via Autosys and in other enviornments via Unix Cron

Perform other day-to-day SAS Administration responsibilities: Assisting with client installations (Base SAS, EG, SAS AMO, InfoMapStudio ), creating metadata users, groups, server definitions, libraries, importing tables from SMC, SAS connect configuration i.e. tcpunix.scr file for remote job submissions.

Placed the disc space (mainly for SAS temp and utilloc), SAS processes alerts in Tivoli monitoring system.

Performed code migrations from Dev to Test and then to Production following approved change control process.

Administer the SAS Web Users activity from SAS Web Admin console in 9.2.

Worked closely with Backup team to understand the Backup strategy for Full and incremental disc backups. Used %OMABKP (sas.servers), Proc metaoperate as well as backup wizard utility available from SAS SMC to backup metadata server.

Provide on Call support to the end users on biweekly basis, troubleshoot their issues by analyzing the appropriate log files mainly ObjectSpawner, Storedprocess, Portal and servlet containter log files. Escalate the issues to SAS

Contact this candidate