SUMMARY:

• 5 years of experience as a SAS Administrator in SAS 9.1.3, SAS 9.2, SAS 9.3 and SAS 9.4 on UNIX/Linux operating systems including the following products SAS Grid, SAS Connect, SAS Internet Server, SAS Access interface to Oracle/SQL Server, SAS Access interface to Teradata, SAS Metadata Server, SAS Management Console Base SAS end user support, Enterprise guide 5.1, 6.1,7.1
• Designing, implementing, and maintaining security on SAS Metadata and Linux for users
• Adding users, registering tables, monitoring servers etc. using Management Console
• Performing SAS upgrades from 9.2 to 9.3 and currently working on 9.4 deployment and migration
• Monitoring SAS Server resources and reporting usage
• Tracking applicable SAS hot fixes and creating implementation plans for respective SAS modules and applications
• Organized demonstrations for new SAS products to the business users
• Defining new Metadata libraries, assigning security via SAS Server permissions and SAS Management Console
• Managed production jobs and handled alerts at job level and infrastructure
• Installation of client applications and Troubleshooting issues
• Extensive experience in analyzing problems and resolving issues of end users
• Knowledge in SAS programming, System Analysis, Design, Development /Implementation, Client - Server/Multi-tier application
• Ability to interface and communicate effectively and efficiently at multiple levels.
• Experience in working with team as well as individual contributor
• Worked as single point of contact for all SAS related issues

TECHNICAL SKILLS:

SAS BI Tools: SAS 9.1.3, 9.2, 9.3 and 9.4, SAS Enterprise Guide 4.1, 5.1, 6.1 and 7.1

SAS Access: Interface to Oracle, DB2, Teradata and SQL Server Information Map Studio, SAS Web Report Studio, SAS OLAP Server, SAS OLAP Cube Studio, SAS/Share, SAS Office Analytics

Databases: Oracle 9i/10g, Microsoft Access, SQL Server 2005

Operating Systems: Solaris, AIX, Linux and Windows

MidTier Tools: Web logic, Jboss, Apache

WORK EXPERIENCE:

Confidential, CA

SAS Administrator

Responsibilities:

• Install, setup, configure and maintain SAS sever on Unix/Linux Environment.
• Configuring SAS to authenticate to alternative authentication methods such as LDAP, Active Directory or PAM
• Responsible for solving Tickets, fixing issues.
• Supported Onsite and Offshore developing Team
• Responsible for Backup and Recovery
• Adding and removing user’s, created and assigns roles in SAS Management Console
• Monitor the Metadata server environment and worked with end user’s.
• Monitored the LSF on Grid environment
• Provided Customer support, production support
• Applied hotfixes, patches
• Connect SAS systems to other systems such as SQL, Teradata, oracle and DB2.
• Provided on call support for production problem resolution.
• Create documentation for end users and internal (Other SAS Admins).
• Watch through all the remedy tickets and troubleshoot user incidents.
• Proc metali options to permissions that affect data access through the Metadata Engine and write proc sql code through update metadata SAS Datasets.
• Responsible for daily server reboots.
• Involved on the migration of the SAS 9.3 to SAS 9.4.
• Worked on migration of all SAS users from Legacy platforms to SAS Grid Platform
• Configuring SAS to authenticate to alternative authentication methods such as LDAP, Active Directory or PAM
• Responsible for solving Tickets, fixing issues
• Supported Onsite and Offshore Developing Team
• Extensive hands on experience on SAS BI, SAS 9.1.3, SAS 9.2, Web Report Studio, SAS 9.3 /SAS 9.4 Grid Administration including SAS connect, SAS internet server, SAS OLAP server, SAS Metadata server, SAS Object Spawner, SAS Management console

Tools: AIX & Linux, SAS 9.4, SAS 9.3, SAS Enterprise Guide V7.1, SAS Enterprise Miner V14.1, LSF 9.1, SAS Access Interface to Oracle/DB2/Teradata, SAS OLAP Cube Studio.

SAS Administrator

Responsibilities:

• Installed and configured SAS 9.4 Grid (7 Node Production Grid)
• Involved on the migration of the SAS 9.3 to SAS 9.4
• Worked on migration of all SAS users from Legacy platforms to SAS Grid Platform
• Acted as single point of contact for all maintenance and troubleshooting of the SAS environment
• Updating SAS licenses, applying SAS hot fix patches on UNIX environment, fix existing bugs and to keep the SAS BI Server environment running and bug free
• SAS Work Space monitoring, setup Automatic cleanup
• Monitoring server performance at regular intervals and recommend required changes in the infrastructure and SAS Queues
• Responsible for keeping SAS platforms up to date by applying licenses and hotfixes as needed
• Established database connectivity between SAS platform and data sources like Oracle Teradata and SQL Server
• Worked with packaging team to Package PC SAS and Enterprise Guide 6.1 and 7.1
• Meet with the Business/Technical/SAS Developers and understand their pain points
• Responsible for all the SAS End-User community on daily basis and serve their day- to-day functional and technical needs on SAS Enterprise Server platform

Tools: Linux, SAS 9.4, SAS 9.3, SAS Enterprise Guide V6.1 and V7.1, SAS Enterprise Miner V13.1, LSF 9.1, SAS Access Interface to Oracle/DB2/Teradata, SAS OLAP Cube Studio.

SAS Administrator

Responsibilities:

• Installing SAS on the Servers and Client machines
• Packing and distributing the client software
• Securing Metadata foundation repositories
• Migrating Metadata from SAS 9.2 to 9.3
• Creating users, groups, roles on the SAS Meta data server
• Ticket Management and resolving issues with SLA
• Develop and maintain documentation of the system configuration, procedures, and apply hotfixes and maintenance releases to SAS 9.2 & 9.3 Server & client SAS products.
• Conduct meetings with each business group manager and understand the potential need for future data requirements and work with DCO-UNIX team & DNE team to make them aware by going through approval process
• Monitoring server performance at regular intervals and recommend required changes in the infrastructure
• Established database connectivity between SAS platform and data sources like Oracle Teradata and SQL Server
• Worked with packaging team to Package PC SAS and Enterprise Guide 4.1 and 5.1
• Responsible for end user’s data management (Work Space)
• Deploy and schedule SAS Data Flux jobs
• Generated the HTML embedded links to SAS graphs and reports etc formatting the out for the web browsers
• Exported SAS Datasets to various file types (including Excel, CSV files)
• Develop and debug routine SAS macros to create tables, graphs and listings
• Implemented the production changes such as applying the patches, upgrading the SAS products, installing new SAS products on the server and license renewals by following Change Management Process

Tools: SAS 9.2, SAS 9.3 SAS Enterprise Guide 5.1 and 4.1, LSF 7.1, SAS Enterprise Miner 7.1, UNIX.