SUMMARY

• Around 7 years of experience in SAS BI Administration, Planning and Configuring SAS Environments
• Excellent Installation & Configuration experience of SAS 9.4 in AIX, Windows and UNIX environments.
• Experience in Installation and configuring SAS Access interface drivers for DB2, Oracle and Teradata on a UNIX Environment.
• Experience in Administering SAS Grid Environment.
• Good experience in Monitoring and troubleshooting of SAS servers and processes using logs and by setting logging options in SAS Management Console
• Good understanding on the design and the implementation of security on SAS Metadata in Linux environment and its maintenance.
• Extensive hands on experience on SAS BI on SAS 9.4, 9.3 & 9.2 administration, including SAS Connect server, SAS Metadata Server, SAS Management Console, SAS OLAP Server, SAS Object Spawner, OLAP Studio, Data Integration Studio, Web Report Studio and Enterprise Guide.

TECHNICAL SKILLS

SAS: BI 9.4, 9.3 & 9.2 and SAS Base

SAS Admin: Metadata Server, Object Spawner, Workspace server, SAS Management Console 9.4/9.3, SAS Customer intelligence Studio

SAS Components: SAS/Connect, SAS/IntrNet Server, SAS/OLAP Server, SAS/Access Interface ( to Oracle, DB2, Teradata, SQL Server, Hadoop), SAS Enterprise Guide 4.3/5.1/7.1, SAS Enterprise Miner 12.1, 6.1 and 5.3, SAS OLAP Viewer for Java, OLAP Studio, SAS Web Report Studio, SAS CI Studio, SAS Visual Analytics.

Operating Systems: Unix, AIX, Solaris and Windows Server 2003 and 2000, 2008

Scheduling tools: Control M, Autosys, LSF Platform Process Manager 7.1 AIX 6.1/5.3/5.2, HP - UX, Solaris 5.10/5.9/5.8 , Remedy 5.5/7, Assyst HP Open View 5.5, SIMM, Net IQ, TCP/IP, Cygwin

PROFESSIONAL EXPERIENCE

SAS Administrator

Confidential, Atlanta-GA

Responsibilities:

• Responsible to manage production support/maintenance issues of SAS 9.2 Application under multiple environments.
• Installing and configuring application software on UNIX and Windows platforms.
• Responsible for making the web based SAS services like Enterprise Miner Web based connectivity has no performance impact on the metadata server
• Managing SAS servers and ensure they ae up and running fine without any performance issues.
• Taking over On-call (24*7) schedules as per the schedule and perform log archival and server maintenance if any during the regular downtime.
• Responsible for day to day external database support for all the internal SAS Programmers/Developers as a SAS Administrator
• Extensive experience in day to day SAS administration tasks like managing users using SAS Management console; adding users to the new environment and creating new groups
• Responsible for monitoring space usage in various environments to ensure the file systems are not full and sent out notifications to top users to clean up their unwanted files.
• Administering and configuring LSF Platform Process Manager.
• Maintenance of SAS servers on different platforms (Windows, HP-UX and AIX).
• Worked on a potential migration plan to a GRID computing architecture in terms of consolidating Windows/UNIX platforms.
• Watch through all the Remedy tickets assigned to our group (Application Support) and troubleshoot/Resolve user incidents.
• Deal with End Users logging issues while connecting to the SAS Servers
• Developed and maintained documentation in a central location and updated them in SharePoint/JIVE site and made accessible to users and SAS Admins which includes BI User and Admin guides.
• Maintained an Issue Register where all unique request/issues were documented with resolution steps.
• Maintained an accurate accounting of all SAS Licenses.
• Applying server/client licenses and hotfixes as needed.
• Addressed several user issues and provided support in BI tools and User Management.
• Performed several client installations and guided Users in getting access to servers and registered them as SAS users.

SAS Administrator

Confidential, Parsippany-NJ

Responsibilities:

• In IDEAS project, SAS scope involves the Migration of two different environments & Migration from 9.3 to 9.4 and to modify existing scripts & models.
• As a pre-installation tasks, worked on System monitoring scripts and reports for disk space, memory and CPU usage.
• Tested and generated reports based on the shell scripts developed for disk space, memory and CPU monitoring.
• Developed stored processes for the system monitoring reports to view them in the web browser which enables business users to have easy access to view these reports
• Involved in the installation, configuration and administration of SAS GRID 9.4 on Linux server. Worked closely with SAS support in this regard to ensure the successful installation of all SAS components.
• Installed SAS9.4 and enabled multi user Enterprise Guide setup for Remote logon on Remote machines
• Migrated all Enterprise Guide and Enterprise Miner Projects to the new environment
• Responsible for data migration to the new environment and allocation of file systems with necessary storage required by the user group.
• Responsible for tracking all the tasks developed from offshore and review the same if any changes needed.
• Created SAS Response files which help to reduce the time spent on PC SAS installations on client machines. Also, managed SAS License updates
• Created new libraries for upcoming projects to the end users in SAS server using SAS Management console.
• Manage SAS Metadata Server and ensure its up and running fine without any performance issues.
• Responsible for taking regular backups of SAS Metadata Server repositories and Scheduled Restarts of SAS Servers
• Responsible for day to day external database support for all the internal SAS Programmers/Developers as a SAS Administrator
• Extensive experience in day to day SAS administration tasks like managing users using SAS Management console; adding users to the new environment and creating new groups
• Responsible for monitoring space usage in various environments to ensure the file systems are not full and sent out notifications to top users to clean up their unwanted files.
• Watch through all the CASD tickets assigned to our group (BI Admin) and troubleshoot/Resolve user incidents.
• Deal with End Users logging issues while connecting to the SAS Servers
• Developed and maintained documentation in a central location and updated them in SharePoint site and made accessible to users and SAS Admins which includes BI User and Admin guides.
• Maintained an Issue Register where all unique request/issues were documented with resolution steps.
• Maintained an accurate accounting of all SAS Licenses
• Addressed several user issues and provided support in BI tools and User Management.
• Performed several client installations and guided Users in getting access to servers and registered them as SAS users

SAS Administrator

Confidential, Montery Park - CA

Responsibilities:

• Upgraded SAS Enterprise Application from SAS 9.3 on AIX 6.1 to SAS 9.4 on RHEL 5.5 Operating Environment.
• Worked very closely with SAS and used a Plan file while implementing the new SAS 9.4 installation and achieved success in installing all SAS components while performing their sub-sequent test analysis both from Server side and SAS Client side by using SAS Enterprise Guide, SAS Enterprise Miner, PC SAS and SAS Base in Unix environment
• Involved in transitioning application migration projects by separating groups within SAS hosted environments between two different hardware setups
• Moved SAS Developers along with their BASE SAS code from 9.3 environment to 9.4
• Migrated all the Enterprise guide projects from 4.0 to 4.3 and all the Enterprise Miner projects from 5.3 to 6.1
• Performed post installation procedures to make sure SASROOT file systems point to the new 9.4 installation by exporting external Database client installations
• Created small depots for each individual SAS clients which can be stored on the network. These are used for installing the SAS clients on the remote users
• Responsible to manage production support/maintenance issues of SAS 9.4 Application with 40 Tera bytes of Data
• Responsible for managing SAS Connect server, AppServer, MetadataServer, Object Spawner, Application Server
• Responsible for SAS 9.4 Application Server under HP BL 460 C with RHEL 5.5
• Responsible for all the production jobs that are running in Control-M.
• Coordinating with Unix System administrators to ensure all the jobs are running smoothly
• Worked closely with SAS Support in resolving the SAS server and user issues
• Responsible for creating new metadata definitions for the upcoming projects to the end users in SAS Server using SAS Management Console (SMC9.3)
• Installed and configured various client components like SAS Enterprise Guide, PC SAS, SAS Enterprise Miner, SAS Personal Login Manager, SAS Universal Viewer
• Responsible for implementing the production changes such as applying the patches upgrading the SAS products, installing new SAS products on the server and license renewals
• Responsible for making the web based SAS services like Enterprise Miner Web based connectivity has no performance impact on the Metadata server
• Responsible for end user’s Work space management and Disk quota
• Installed SAS Analytics Platform Server on the Metadata Server 9.3
• Installed, configured SAS Enterprise Miner Server 6.1 in the month of August 2012 and upgraded to SAS Enterprise Miner 6.2 in October 2012
• Installed respective JRE latest versions on the client side before they tested using web site for E-miner 6.2
• Created Default User libraries to get more space while they create any data sources in E-Miner for effective data storage management purposes from the end-user perspective
• Tested the RMI Server remote method invocation using SAS AP Platform server which allows to go to the web site
• Thorough testing exercises have implemented on the client side to make sure data mining process is stable.
• Worked with UBC IT/Support teams and made them understand on the SAS upcoming requirements and co-ordinate with them by running through Project timelines
• Developed Shell scripts which will monitor the usage of Users Work file systems on Production SAS Server
• Created the users and groups on the Test, Dev, Prod RHEL SAS servers
• Developed a script which will assign the groups specific file systems for all the SAS Users which invoke SAS
• Developed scripts for scheduling SAS jobs using Control-M on the Solaris Prod SAS server.

Environment: SAS BI 9.4, 9.3 on AIX and RHEL -UNIX Based - Production Server

SAS Administrator

Confidential, Seattle - WA

Responsibilities:

• Responsible to manage production support/maintenance issues of SAS 9.2 Application with 85 Terra bytes of Data under SPDS environment
• Responsible for creating new libraries for upcoming small scaled projects to the end users in SAS Server using SAS Management Console (SMC 9.2)
• Responsible for Confidential in house reporting web sites, which are equipped with the SAS Servers and ensure all the intranet websites SAS data availability to let them view their reports regularly
• Manage Metadata Server and ensure it’s up and running fine without any performance issues
• Work with Project SAS Admins to fulfill the user’s special request needs
• Create/Manage SPDS users and responsible for backing up their day to day data
• Responsible for end user’s data management (Work Space)
• Responsible for SAS Web Report Studio application server’s uptime and availability along with WEBDAV repository for WRS in SAS Management Console
• Responsible for all the production jobs that are running in Tidal Scheduler and co-ordinate with Solaris System administrators in ensuring all the jobs are running smoothly
• Responsible for making the web based SAS services like Enterprise Miner Web based connectivity has no performance impact on the metadata server
• Work/Co-ordinate with Group Health IT/Support teams to make necessary approvals happen as part of SOX rules and policies in order to provide user permissions etc
• Responsible for internal production processes in terms of setting up SAS Access/ Interface to SQL Server and Oracle Database using ODBC connectivity method by following the change process for Test/Dev/Intg/Production Servers
• 24/7 production jobs management using Control M and taking care of scheduled jobs
• Installed SAS Access interface drivers for both sql server and oracle on a IBM UNIX Environment
• Created odbc.ini file and pointed the path for the installation of drivers for ODBC
• Specified Production database instances along with the user credentials in ODBC file and implemented successfully and made sure all the production users are connected from sas servers to respective production databases without any issues
• Work as a One Point Contact for Project SAS Admins and take their requirements (Example: Additional Disk space to their current project) and drive with IT support teams to ensure they get on time
• Help End user code level problems over the telephonic/in-person support
• Watch through SAS Admin emails bucket and troubleshoot and timely respond
• Build Knowledge based articles for SAS while troubleshooting on day to day basis and update in share point portal for future references
• Ensure Group Health SAS internet sites are up and running by using respective port number
• Observe server performance status by using prstat and understand each user’s utilization
• Ensure user’s new library requests are considered and create according to their project needs by using SMC and test their libraries from Enterprise Guide level with a thorough test process

System Administrator

Confidential 

Responsibilities:

• Installed, configured and maintained Solaris 8/9 servers and HP-UX Servers.
• Installation of client applications and Troubleshooting technical problems.
• Handled day-to-day user issues that are allotted to the support queue.
• Daily user account management requests for creating users/password reset activities/modifying the privileges of a user.
• Designing, implementing, and maintaining security on HP UX for users
• Performed all system administration related duties including user accounts maintenance, disk and file management, backup & recovery, auto-mounting, configuring and setting up of NIS, DNS, NFS, and SSH.
• Monitor the file systems of Solaris, HP-UX and CPU load for better performance
• Creating and configuring LPARS in HMC, using NIM to install and manage LPAR.
• Installing, configuring and maintenance of Apache, NFS and Samba services
• Setting up cron jobs.
• Created various analysis datasets based on specific requirements. Created programs according to protocol and statistical analysis plan.
• Building and implementing new hardware configurations.
• Installing and configuring application software.
• Install, upgrade, delete and query packages on the system.
• Expert in installation, configuration of Patch and Package Management.
• Installed and configured mail server. Send mail is configured as a SMTP mail server and POP 3 /IMAP is used for downloading mails to client workstations Installation and Backup of Oracle 8 on Solaris Volume Disc Management.
• Configured LAN Interface for network use.
• Installation of CISCO routers and switches. Checking the serial and Ethernet ports of CISCO routers, startup and running configuration.

Environment: Solaris and HP UX Based System Administration.