SUMMARY

• SAS Administrator with 7 years of experience in UNIX - SOLARIS, AIX and implementation of various projects for Health Care, Pharmaceutical and Banking industries.
• Support & administer robust SAS environment compromising of 7 UNIX servers & supporting 600+ users (Installation, Maintenance & Upgradation).
• Extensive hands on experience on SAS BI on SAS 8, SAS 9.1.3, SAS 9.2, SAS 9.3 Administration including SAS connect, SAS internet server, SAS OLAP server, SAS Metadata server, SAS Object Spawner, SAS Management console, Enterprise guide, OLAP studio, Data integration studio, Web report studio, SAS performance forecast server, SAS connect server.
• Key role in huge SAS project comprising of 18 Linux servers & 1000 users.
• Expertise in using DB2, Oracle, Teradata and Sybase database systems management and migration.
• Experience working on different operating systems (UNIX, Windows, Mainframe(OS390) )
• Experience with configuration and administration of SAS 9 Intelligence Platform and various SAS BI tools on Windows and Unix
• Understanding of SAS EBI authentication and authorization and security model, experience implementing SAS Metadata security and access controls.
• Knowledge of setup various DBMS clients for SAS Server on Unix, including Oracle, DB2, Teradata, R/3, MS SQL Server, Informix, ODBC, etc.
• Experience migration SAS environment from v8 to v9 and from SAS 9.1.3 to SAS 9.2, SAS 9.3
• Designing, implementing, and maintaining security on SAS Metadata and Linux for users
• Monitor and log SAS servers and optimize memory usage or tune servers for optimal performance.
• Reviewed, validated, documented and mentored SAS Admin and team regarding SAS environment.
• Software upgrades, patches, maintenance- performance monitoring and tuning of SAS environments.
• Good experience in developing power point presentations.
• Exposure to scheduling utilities like Autosys, Maestro, and Crontab (UNIX).
• Good experience with Shell Scripting.
• Administered the SAS start-up and stop scripts and the status of the server services.

TECHNICAL SKILLS

Databases: Teradata, Oracle 11g/10g/9i, SQL Server 208/2005

Operating Systems: Windows 9x,XP,2000,Linux,Unix Sun Os 5.9

Tools: SAS, SAS Management console, SAS Enterprise miner, Enterprise guide SAS DI Studio, SAS OLAP Cube Studio

Web Related: HTML, Java Script, CSS

Languages: C,C++,VB,VC++

Others: MS office, MS project, PowerPoint, Excel, Java, J2EE, JSP, HTML,XML, CSS, Java Script, access, Cron, Autosys

PROFESSIONAL EXPERIENCE

Confidential, Jersey city, New Jersey

SAS Administrator

Responsibilities:

• Install and configure the complete SAS grid environment along with SAS.
• Migrate all metadata contents to SAS 9.3 Grid from the 9.2 servers.
• Monitor SAS 9.3 system & provide suggestions to improve performance.
• Migrated data, SAS Metadata and users to the new environment with no downtime on the existing environment.
• Upgraded SAS 9.2 to 9.3
• Adding and removing users, create, assign roles and register tables in SAS Management Console.
• Monitor the Metadata server environment and worked with end user’s.
• Defined SAS libraries and SAS servers by using SAS Management Console.
• Applied hotfixes, patches.
• Supported the running of Mainframe batch jobs and interfacing with various users and/or project team members during code development and testing.
• Manage user tickets for SAS related issues by assigning to appropriate team members.
• Prepare standard operating procedure (SOP) documentation for most common SAS admin tasks.
• Administer SAS solutions & provide users with required access.
• Apply SAS hotfixes & keep system up to date.

Environment: SAS 9.3/9.2, Unix, Mainframes, Base SAS, SAS Enterprise Guide, Enterprise Miner, Data integration Studio(DI) 4.2, OLAP Cube studio 9.1, Management Console, SAS\Access, SAS/SQL, SAS/AF, SAS/ETL, WEB Focus, Oracle, SQL Server, cron, Teradata, AS/400,Java, J2EE, JSP, HTML, MS Excel, MS Excel Macros, SQL.

Confidential, Dayton, Ohio

SAS Administrator

Responsibilities:

• Maintain huge SAS data marts (around 10 TB in size) by periodically updating indexes, data, access etc.
• Assist with SAS 9.2 installation, configuration and day-to-day administration of SAS platform.
• Actively involved in PCSAS (SAS 9.2 on Windows) to SAS Enterprise Guide migration of 250+ users.
• Interact with users for new business requirements/enhancements in the environment.
• Keeping environment up to date by installing hot fixes in development environment, test & propagate to production environment.
• Create sub-depots & assist users in installation, configuration & support of SAS desktop products like SAS 9.2 for windows, Enterprise Guide, Information Map Studio & OLAP Cube Studio.
• Monitor environment and troubleshoot user queries to ensure smooth working of the platform.
• Renew SAS, SPDS, LSF licenses.
• Manage connectivity between SAS environment to various data sources like Informix DB, Oracle DB, SQL DB etc.
• Play key role in gathering requirements for SAS Grid based on past experience/best practices.
• Work with SAS for installation/configuration of SAS 9.3 Grid.
• Migrate SAS datasets/ SAS Metadata from previous SAS version/OS releases to 9.3.
• Expert level support for SAS GRID UAT testing.
• Troubleshoot/Optimize SAS programs to users wherever possible.
• Create/Assist on scripts for data backup of SAS Metadata.
• Monitor SAS jobs in environment using LSF tools.
• Provide expert level administration on Solaris server hosting SAS Grid.
• Research on new SAS modules required by users and provides timely solution.

Environment: SAS, SAS Grid Manager, Java, J2EE, CSS, HTML, Java Script, JSP, Autosys, Windows, Sun Solaris 10/9.

Confidential, Tampa, Florida

SAS Administrator

Responsibilities:

• Install, setup, configure, migrate and maintain servers on UNIX environment.
• Performed metrics and reporting.
• Wrote shell script programs to run SAS jobs in UNIX, and then scheduling the scripts using Cron tab, at specific day and time.
• Provided support for SAS customers by trouble shooting problems with SAS applications/environment and provided technical solutions to business user needs.
• Install SAS 9.x software on large servers/multi-tier environments.
• Involved in migrations, upgrades and performed version upgrades for both server and client components.
• Data loading and maintenance of different SAS and SPDS datamarts.
• Identify data loading issues and fix the data issues.
• Respond and resolve all data issue queries from users.
• Provide SAS support to all business users.
• Ensure the data loading is not slow and improve the query performances wherever required.
• Monitor SASWORK usage and cleanup unwanted temporary files to ensure user jobs does not fail due to lack of space in SASWORK.
• Monitor SAS services on all SAS servers to make sure all services are up and working.
• Start and stop SAS and SPDS services whenever required and also regularly during any maintenance.
• Automating the required jobs using autosys
• Managing metadata using SAS SMC. It includes all admin work on SMC like user creation, group creation, server creation, library creation, ACT creation, setup security for different group of users, etc.
• SAS BI installation.
• Upgrade existing SAS installation by adding new SAS products.
• Upgrade SAS product versions to latest available version.
• Install hotfixes.
• Renew SAS, SPDS, LSF licenses.
• Install, configuration of SPDS and upgrade it to latest TSM level.
• Install JDK, Apache, Tomcat, LSF, Process manager.
• Do all administrative task for SPDS like starting/stopping SPDS services, adding users to SPDS domain.
• Managing SPDS libraries, adding file systems to existing libraries to increase SPDS space.

Environment: SAS, Oracle 9i, TOAD, PL/SQL, UNIX Shell Scripting, Sun Solaris

Confidential

SAS Administrator

Responsibilities:

• Created high level design, technical design documents.
• Manage daily production and ensure the effective and timely resolutions of any problems including communicating the status to the customer community.
• Responsible for the administration of SAS web applications, SAS OLAP, Base SAS and SAS connect.
• Recommend environment and configuration enhancements that improved SAS performance.
• Produced data sets for reporting.
• Administered SAS EDI, EM and Model manager.
• Provides hands-on SAS administrator training to SAS programmers which will enable a seamless transition of responsibilities at the completion of the project.
• Translates business specifications and designs into language coded programs, procedures or scripts.
• Responsible for day to day external database support for all the internal SAS programmers as a SAS administrator.
• Attend meeting with SAS users in order to resolve their day-to-day SAS issues/special requests.
• Help end user code level problems over the telephonic support.
• Identified small group of users, created work space, created a separate SAS server and implemented metadata user authentication process.
• Responsible for daily server reboots.
• Maintain the SAS performance in the UNIX-AIX servers.
• Created materialized view for reporting in oracle database using TOAD.
• Run the SAS jobs in the UNIX environment.
• Wrote Junit test for unit test, Integration test and functional test.
• Extensively used EG for writing SAS codes and administration purposes.

Environment: SAS v9, Windows XP, UNIX-AIX, SAS 9.1 EBI tools, SAS 9.2 EBI tools, RAD, Clear case, Junit, WebSphere 6.1,