SUMMARY:

• Over 7 years of experience working as SAS Admin (Aix, Windows, Redhat, Linux) .
• Experience in migrating SAS Servers from 9.1.3 to 9.3 and working in multi - tier applications.
• Experience with SAS 9.4, 9.3, Base SAS, SAS Metadata Server, SAS Object Spawner, SAS Management console 9.3, 9.2, 9.1.3 SAS Enterprise Guide 7.1, 5.1, 4.3, 4.1 PC SAS, SAS OLAP Cube Studio, SAS Information Map studio, SAS Performance Data Server, SAS Enterprise Miner and SAS Web Portals.
• Experience in SAS Grid 9.3 Server Installation, Configuration, Administration and Managing metadata repositories.
• Experience in configuring and managing high-availability (HA) and disaster recovery (DR) processes associated with the SAS 9.4 and 9.3 Grids.
• Experience in administering SAS 9.3 Platform RTM, monitoring jobs, setting up system thresholds for high usage of server resources alert.
• Management of User accounts and System security in SAS Management Console, maintaining file systems, performance monitoring and tuning.
• Experience in applying new license for SPDS, SAS Platform RTM and SAS Meta/compute servers.
• Monitored Stored Process Server, Work Space Server and Scalable Performance Data Server (SPD Server) where Parallelization of Many SAS I/O functions Occurs to Improve the Overall Performance and Security and few times Reviewed logs for Resolve any issues encountered or to Estimate the Performance
• Experienced in working Relational Database Management Systems such as Oracle, DB2, SQL Server, GreenPlum, SPDS.
• Experience in applying Patches of SAS 9.4, 9.3, 9.2, 9.1.3 on server side as well as client side.
• Experience in Shell scripting to make process automated for client.
• Installation of client applications and Troubleshooting technical problems
• Worked on flexible hours for production, backup and on-call support for 24/7 environments.

TECHNICAL SKILLS:

SAS: SAS BI 9.4,9.3,9.2,9.1.3 SAS Base 9.3,9.2,9.1.3 SAS Enterprise guide 7.1,5.1,4.3,4.1, PC SAS 9.4,9.3, SAS Management Console 9.4,9.3,9.2,9.1 SAS OLAP Server, Metadata Server, Object Spawner, Data Integration Studio, Web Report Studio, Enterprise Miner, SAS Access Interface to Oracle, Greenplum, SQL Server, SAS Grid queues and their Priority, LSF Job scheduler.

Operating Systems: Linux (Redhat 4/5/6, Centos, Ubuntu, Fedora), Aix 5.x/6.x, Solaris (11/10/9), Windows 2000/2003/2008 r2/2012 Sever, VMWARE ESX/ESXi 4.x/5.x .

Database: MySQL, DB2, Oracle 11g / 10g, GreenplumHardware: IBM pSeries 630, 670, Power 7 series, HP ProLiant DL 385, 580,585, HP blade server c3000/c7000, Dell PowerEdge T300.

Tools: Autosys job scheduler, Crontab, SAS Platform RTM monitoring, Logical volume manager (LVM), nmon monitoring, Cygwin.

Programing language: C, C++, shell scripting, SAS Programing.

PROFESSIONAL EXPERIENCE:

Confidential, NC

SAS Administrator

Responsibilities:

• Deployed end user SAS applications and make sure all the client/server connectivity is intact without any performance issues.
• Managed SAS Connect server, Metadata Server, Object Spawner, OLAP server, Stored Process Server on the Linux environment
• Supported PC SAS Migration and Users from Standalone server to SAS GRID.
• Supported Users Migration From DB2 to Teradata also making sure they have appropriate access and Users Credentials have been defined properly.
• Create Powerbroker Groups and Service ids to help users run jobs on Autosys .
• Experience with SAS 9.4, 9.3 also Installed and Configured client components like SAS Enterprise Guide 7.12, PC SAS 9.4, 9.3 & 9.1, SAS Enterprise Miner 14.1and SAS OLAP Cube 4.3, SAS Information Map Studio 4.31 and Troubleshoot Technical Problems.
• Installed and configured SAS Access to Oracle, DB2, Sybase, Teradata, Netezza database.
• Configure Odbc.ini files to Connect to Hadoop And SQL,
• Interact with various teams to ensure a stable production environment, including but not limited to client facing support, application developers, business analysts, infrastructure.
• Escalated the issues and worked closely with SAS Support in resolving issues related to users and environment.
• Developed shell script and SAS code to monitoring workspace and disk quota of SAS environment, Send email notification to end user whenever utilization is above threshold.
• Developed Utilities to check Users Disk Quota, Cleanup User Workspace, Tool to provide user info, etc.
• Supported 4500+ Users and serve as a first line defense for User Issues.
• Troubleshooting SAS logs w.r.t Grid
• Monitor storage growth and work with user areas to develop purge criteria. Coordinate with other IT groups on performance, storage issues, etc
• Monitoring of servers, databases and workstations to ensure availability and efficiency.
• Document operational processes and recovery procedures
• Maintain environment configuration information
• Supported Onsite and Offshore development Teams.
• Administer user access and security on the system

Environment: SAS E nterprise Guide 7.1 and 5.1, SAS Management Console 9.4, SAS OLAP Cube 4.3, SAS Information Map studio 4.31, SAS Data Integration Studion 4.5, SAS Webreport studio, SAS ACCESS to Teradata, SAS ACCESS to Netezza, SAS Visual Analytics.

SAS Administrator

Responsibilities:

• Managed SAS Connect server, Metadata Server, Object Spawner, OLAP server, Stored Process Server on the windows environment.
• Responsible for implementing the production changes such as installation of new SAS products on the server, upgrading the SAS products, applying the patches and license renewals by following Change Management Process.
• Managed SAS Metadata Server, ensured its availability without any performance issues and took regular backups of the repositories.
• Created new metadata objects using SAS Management Console 9.3 for projects to the end users in SAS Metadata Server.
• Configure SAS 9.3 Platform RTM to spread jobs in different queues and set up threshold for server resource utilization to send email notification when utilization is high.
• Configured SAS Grid Manager Utility to send all SAS EG and batch jobs across grid based on grid algorithm.
• Created SAS Metadata Libraries for all kind of database (Oracle, SPDS GreenPlum, Teradata and MySql).
• Installed and configure Jboss 5.1 to support SAS Web Applications like SAS Store Process, Web Report Studio, SAS Bi Dashboard and BI Portals for both dev. and prod environment.
• Installed and configured client components like SAS Enterprise Guide 7.1,5.1 & 4.3, PC SAS 9.3 & 9.1, SAS Enterprise Miner 5.1, and SAS OLAP Cube Studio 9.3 & 9.4.
• Installed and configured SAS Access to Oracle, SQL and Greenplum database.
• Supported production jobs and coordinated with UNIX system administrators to ensure the jobs are running successfully.
• Migrated SAS developed projects from 9.1.3 to 9.3 along with their base code.
• Migrated SAS Metadata users from SAS 9.1.3 to SAS 9.3 and created new groups and ACL.
• Coordinated efficiently with Business Analysts, Application Architects, and Infrastructure teams in handling setup and maintaining SAS servers.

Environment: SAS Management Console 9.3, SAS Stored Process, SAS Web Report Studio, SAS Deployment Manager 9.4, SAS Enterprise Guide 7.1 & 5.1, SAS Stored Process Web Application.

SAS Administrator

Responsibilities:

• Good in applying Hot Fix Installations, User Issues, & any other Maintenance issues
• Involved in System Recover plan(SRP) and DR procedures
• Hands on Skills on Management Console - Important are - Server Manager, User Manager, Authorization Manager, Data Library Manager
• Setting up DB Connections from Management Console to Teradata
• Monitor all the tiers - Metadata, Compute & Web on AIX/Linux.
• Deploying web applications in Web Sphere
• Promotion of Metadata Objects such as libraries, metadata folders, information maps, etc from one environment to another.
• Actively participated in the complete SDLC Life Cycle of development, from the requirement phase to testing phase
• Verifying the grid configuration files(lsf.conf,lsb hosts etc)
• Troubleshooting SAS logs w.r.t Grid
• Monitor storage growth and work with user areas to develop purge criteria. Coordinate with other IT groups on performance, storage issues, etc
• Monitoring of servers, databases and workstations to ensure availability and efficiency.
• Document operational processes and recovery procedures
• Maintain environment configuration information
• Administer user access and security on the system
• Maintain the User Inventory & License Information

Environment: SAS Management console, Enterprise Guide4.2, SAS OLAP Cubes,, SAS Information Map studio, SAS Webreport studio, SAS ACCESS to Teradata, SAS Visual Analytics.

SAS Administrator

Responsibilities:

• Implemented the Hot Fix Installations, User Issues, & any other Maintenance issues
• SAS Server has to be constantly backed up & has to be restored in case of server crash
• Hands on Skills on Management Console - Important are - Server Manager, User Manager, Authentication, Customer Intelligence, Setting up Logging
• Setting up DB Connections from Management Console to Teradata
• Monitor all the tiers - Metadata, Compute & Web on unix.
• Deploying web applications in Web Sphere
• Promotion of Metadata such as libraries, metadata folders, information maps, campaigns, etc from one environment to another
• Played key role in data analysis and statistical reporting for TIAA-CREF claims
• Experience in installing and Managing Accounts Receivable System.
• Monitor storage growth and work with user areas to develop purge criteria. Coordinate with other IT groups on performance, storage issues, etc
• Monitoring of servers, databases and workstations to ensure availability and efficiency.
• Document operational processes and recovery procedures
• Maintain environment configuration information
• Administer user access and security on the system
• Maintain the User Inventory & License Information
• Install, Configure and support SAS 9.2/3 environments including SAS Metadata Server on unix.

Environment: SAS 9.3 Software, SAS/Management Console,SAS Enterprise Guide4.2,SAS OLAP Cubes, Oracle, Windows, Microsoft Office (Excel, MS Access, MS Word, Visio), Adobe Reader

SAS Administrator

Responsibilities:

• Managed day-to-day operational aspects of the project and scope. Provide information to business clients regarding technology directions and translate technology opportunities into integration solutions.
• Installation of client applications and Troubleshooting technical problems
• Monitoring the SAS environment like SAS server resource and reporting usage.
• Installation of SAS software on client desktops.
• Archiving and backup planning.
• License management.
• Creating new repository, register repository, unregister repository and deleting.
• Scheduling production jobs Scheduling for the Business so that the Business can access the critical data on scheduled time thus reducing manual intervention
• Installing and configuring management console for security management for various users.
• Implementation of System Monitoring application that specifies number of processes, CPU & memory utilization per user etc. in order to find out peak time for the server, high traffic time, most frequent users & the users having high system usage
• Identify best practices for configuring applications and work with the development teams to implement the standards.
• Coordinate with other IT groups on performance, storage issues, etc.
• Communicate and collaborate effectively with staff of varying technical expertise.
• Performance tuning of both Server and Workstations
• Providing excellent analysis, problem determination and troubleshooting skills.
• Excellent oral and written communication skills with ability to interact at all levels of the organization on a regular basis.

Environment: SAS Management Console 9.1.3, SAS Enterprise Guide 4.0, SAS Stored Processes, SAS Web Report Studio, SAS OLAP CUBE Studio 9.1, SAS Enterprise BI Server, Tomcat/ Apache, SAS DI Studio

SAS Administrator

Responsibilities:

• Install, setup, configure SAS9.2 on AIX6.1 Environment.
• Responsible for Hotfix, Renewal of Server Licenses, patch updates.
• Supported Onsite and Offshore development Teams.
• Responsible for Metadata Backup and Recovery
• Created an ACL at Group level, User level and Table level in SAS Management Console 9.3
• Adding and removing user’s, created and assigns roles in SAS Management Console
• Managed SAS Connect server, Metadata Server, Object Spawner, OLAP server, Stored Process Server on the AIX 6.1 environment.
• Monitoring the Metadata Server, Compute Server & Web Tiers.
• Scheduled jobs for SAS User’s through control M and Crontab.
• Provided on call support for production problem resolution.
• Create documentation for users and SAS Teams.
• Monitoring Grid Environment.
• Implementing SAS Best practices in the SAS Environment.
• Checking the sas metadata logs including enabling trace and setting different levels on debugging.
• Fine tuning the SAS Applications so that Jobs run with in the SLA time.
• Watch through all the remedy tickets and troubleshoot user incidents.
• Promotion of SAS9.2 to 9.4
• Configuring SAS Environment Manager and Implementing HTTPS for Web/Web AppServers.

Enviroment: SAS/Management Console, Enterprise Guide4.2, SAS OLAP Cubes,, SAS Information Map, SAS Web Report Studio, SAS Hotfixes