SUMMARY

• 6 years of experience in SAS BI Administration in SAS 913, SAS 92 and SAS 93 under UNIX/Linux operating systems including SAS Grid, SAS Connect, SAS Internet Server, SAS Access interface to Oracle/SQL Server, SAS Access interface to Teradata, SAS OLAP Server, SAS Metadata Server, SAS Management Console Base SAS end user support, Enterprise guide 4.1, 4.2, 5.1 SAS Enterprise Miner 5.2, 6.2, SAS Web Report Studio 4.3
• Designing, implementing, and maintaining security onSASMetadata and Linux for users
• Establishing best practices and guidelines forSASBI usage
• Provide guidance and assistance toSASDevelopers on operational and technical issues
• Interfacing with theSASInstitute for Support on administrative and system issues
• Performing SAS upgrades from 9.1.3 to 9.2 and 9.2 to 9.3
• Occasional after hour support when system OS and hardware maintenance and applyingSAShot fixes and upgrades occur.
• Monitor and logSASservers and optimize memory usage or tune servers for optimal performance.
• Focus on areas of capability, interoperability, scalability and enterprise class issues (i.e. like failover).
• Act as a liaison toSASTechnical Support forSASusers at the clients site
• Reviewed, validated, documented and mentoredSASAdminand team regardingSASenvironment.
• Extensive Knowledge in Server/Client Side Installation of SAS 913 and SAS 92 SAS93
• Experience in SAS 913 to SAS 92 SAS 92 to SAS 93 and DATA Migration from HP UNIX to Linux Environments.
• 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.
• Co - ordination with SAS Account Representative regarding timely renewal of SAS Software and receiving SID (Software Installation Data) files.
• Organized demonstrations for new SAS products to the business users.
• Worked closely with Business Analysts, Business users, Application Architects, Production DBA's & Infrastructure team in handling Setup and maintaining SAS application server.
• Experience in SAS Programming
• Knowledge in shell scripting.
• Excellent interpersonal, analytical, problem solving and communication skills with ability to interact with individuals at all levels.
• SAS Access Interface to Oracle, DB/2, Mainframe, SQL Servers from SAS Metadata Server.
• Developed, Modified and Tested UNIX Shell scripts and necessary Test Plans to ensure the successful execution of the data loading process

PROFESSIONAL EXPERIENCE

Confidential, Richfield, MN

SAS Administrator

Responsibilities:

• Develop and maintain documentation of the system configuration, procedures, and apply hotfixes and maintenance releases toSAS9.2 & 9.3 Server & clientSASproducts,
• Maintenance of large data sets, combining data from various sources in varying formats to createSAS data sets and/or ASCII files by using Set and Merge for generating Reports and Graphs
• Developed new or modifiedSASprograms to load data from the source and create study specific datasets, which are used as source datasets for report generating programs
• Worked on SAS 9.3 installation and SAS data migration from SAS 9.2(HPUX) to SAS 9.3(RHEL)
• Coordinating with backup team to restore missing/corrupted files and making sure new file systems are added to backup schedules
• Responsible for scheduling SAS Jobs, backup scripts, cleanup scripts using Crontab
• Responsible for applying SAS hot fixes on Desktops Clients as well as Servers
• Taking regular metadata backup as part of disaster recovery process requirement
• Responsible for all the End-User community on daily basis and serve their day to day needs on SAS
• Responsible for End-User’s data storage and conduct forecast on capacity planning and update to BI Manager on monthly basis
• Single point of contact for all of the SAS issues and SAS Support
• Manage day to day application performance load on the Unix Server in which it was deployed
• Add/remove users from the application side up on the request that are made by SAS Developers
• Re-deploy Web Report studio when administrative password got expired
• Manage web based users and their profiles on the client side
• Install client side web report studio and setup the client side profiles for the users on daily basis
• Provide access authorization and with the respective domain authentication
• Make sure users have space to store the reports on the report repository and conduct meetings with the business managers in case of any increase that is forecasted by the business managers
• Installed SAS Services Application and SAS Analytics Platform Server on the Metadata Server

Confidential, Rockville, MD

SAS Administrator

Responsibilities:

• Work with SAS programmers/Developers and understand their daily SAS needs and provide the support
• Ensure SAS license is up to date and work on all the escalated SAS end users issues with SAS support directly and document the same in Share Point portal internally as part of documentation process
• Implemented all the SAS Server ports into Monitoring systems and pro-actively manage SAS Server availability by working/coordinating with Mid Range Unix administration teams
• Installed respective JRE latest versions on the client side before they test using web site for E-miner 5.1
• 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
• Monitor all the Remedy tickets and troubleshoot/Resolve user incidents
• Monitor Sas admin emails bucket and troubleshoot and timely respond
• Attend meeting with SAS Users in order to resolve their day-to-day SAS issues/special requests
• Work/Co-ordinate with IT/Support teams to make necessary approvals happen as part of SOX rules and policies in order to provide user permissions etc.
• Identify end user desktop SAS applications and upgrade them timely
• Responsible for setting up SAS Access/Interface to Oracle, MS Sql and Teradata servers for end users as per their requirements by implementing ODBC configuration settings
• Responsible for end users SAS software deployments and making sure all the client/Server connectivity is intact without any performance issues
• Conduct SAS connectivity trainings to SAS Developers and ensure internal processes are followed such as Incident, Change, problem management activities effectively
• Responsible for managing Object Spawner, Metadata server, Connect Server, SAS Access/Interface to Oracle and MS-Sql server and Workspace Server capacity planning on all the environments Adhoc/Dev/Intg/Prod
• Ensure SAS license is up to date and work on all the SAS end users issues, with SAS support if necessary and document the same in share point portal internally as part of documentation process
• Implemented all the SAS Server ports into Monitoring systems and pro-actively manage SAS Server availability by working/co-coordinating with Mid Range Unix administration teams
• Responsible for using Remedy 7.2 version to keep track of all the SAS issues and respond to them timely with clear resolution updates
• Responsible for updating the documentation with all updates, issues and solution and activities scheduled for every quarter.
• 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 through test process
• End Users logging issues while connecting to the SAS Servers
• Ensure SAS internet sites are up and running by using respective port number.
• Identify peak users and non-peak to schedule the activities accordingly
• Build Knowledge base articles for SAS while troubleshooting on day to day basis and update in internal SAS wiki for future references
• Installed respective JRE latest versions on the client side before they test using web site for E-miner 5.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
• Installed SAS Access interface drivers for both SQL Server and Oracle
• Created odbc.ini file and pointed the path for the installation of drivers for ODBC

Confidential

SAS Administrator

Responsibilities:

• Responsible for SAS Application Server under HP Unix in a framed with 4 different Servers for different in house clients requirements
• Manage Metadata Server and ensure it’s up and running fine without any performance issues
• Responsible for 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
• Responsible for managing SAS Internet/Server, App Server, Object Spawner, Application Server on the primary HP environment under HP
• Responsible to manage production support/maintenance issues of SAS Application with 85 Terra bytes of Data
• 24/7 production jobs management using ControlM and taking care of scheduled jobs
• Responsible for creating new libraries for upcoming small scaled projects to the end users in SAS Server using SAS Management Console
• Create/Manage users and responsible for backing up their day to day data
• Responsible for helping end users (SAS Developers) in terms of allotting user quota and resolving their SAS dataset level issues
• Responsible for making the web based sas services like Enterprise Miner Web based connectivity has no performance impact on the metadata server
• Installed SAS Access interface drivers for both SQL Server and Oracle
• Worked with SAS Web Report Studio trail version installation
• Created odbc.ini file and pointed the path for the installation of drivers for ODBC
• System Administration for Windows and Unix Servers
• Capacity & Performance data collection
• Backup Monitoring & fixing failed backups
• Security Administration (as per documented procedures)
• Spill over queue management (incidents in two shifts)
• On call support for two shifts
• Vendor management activities
• Standard image creationand performing jumpstart installations remotely by sitting at a consolidated datacenter operations