SUMMARY:

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

PROFESSIONAL EXPERIENCE:

Confidential,CA

SAS Administrator

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

Confidential, Richmond, VA

SAS Administrator

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

Confidential,Philadelphia,PA

SAS Administrator

• 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
• Experience with metadata-bound libraries
• 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 claims
• Actively participated in the complete SDLC Life Cycle of development, from the requirement phase to testing phase
• 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

Technologies: SAS 9.3 /SAS 9.4 Software, SAS/Management Console, Enterprise Guide4.2/7.1, OLAP Cubes, Oracle, SAS/SECURE

Confidential

SAS Administrator

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

Confidential

SAS Administrator

• Provided production support and handled maintenance issues for SAS 9.1.3 & SAS 9.2 Application
• Involved on the migration of the SAS 9.1.3 to SAS 9.2
• Creating SAS libraries and registering SAS datasets
• Applying Hot fixes on SAS Servers and client tools
• Renewing SAS license with SID (SAS Installation Data) files
• Modifying SAS configuration files and taking back up of original files
• Work with SAS programmers/Developers and understand their daily SAS needs and provide the support
• Capacity & Performance data collection
• Backup Monitoring & fixing failed backups
• Diagnosed, documented, reported, and resolved SAS user issues
• Interfaced with other support teams, customers, and vendors

Tools: SAS 9.1.3, SAS Access Interface to Oracle using ODBC method, SAS Enterprise Guide, SAS Enterprise Miner, UNIX.