PROFESSIONAL SUMMARY:

• More than 6+ years of IT experience and SAS administrator and related SAS BI products Administration on Unix/Linux and Windows platforms.
• Implementation of SAS EBI, EDI, EM, MM, TM, MDM, FS & VA Tools on SAS versions 9.2, 9.3 & 9.4 suite of products.
• Duties include planning, coordinating, installing, migrating and implementing new releases and system enhancements, upgrades, testing and evaluation of new SAS products.
• SAS products installation and support of Base SAS, SAS Enterprise Guide, SAS Enterprise Miner, add in Microsoft office, Text Miner, SAS Data Integration Studio, SAS Information map studio, SAS Management Console, SAS Visual Analytics, SAS Web Report Studio, Office Analytics, SAS Forecast Studio, SAS OLAP Cube studio as well as other SAS tools may be evaluated.
• Administer and support all aspects of SAS Software in a SAS GRID Environment.
• Extensive working experience assigning libraries and pre - assigned libraries adding/deleting/security for the libraries via management console for SAS, DB2, ORACLE, Teradata, Green plum, Netezza, SAP Hana.
• Extensive knowledge on Network File System and CPM.
• DI jobs used to extract, transform and load the physical data structures, scheduled jobs and job flows.
• Monitor and log SAS servers and optimize memory usage or tune servers for optimal performance.
• Identifying potential issues, working with vendors and provide research and solution recommendations proactively.
• Writing and executing effective test plans to ensure quality and stability, and ensuring system documentation is complete per Clients standards.
• Saving, restoring, migrating, managing metadata on the Management Console and backing up WEBDAV, Content server.
• Usage of SAS Management Console (SMC) for setting up users, groups, access permissions, metadata access, database connections, registering stored processes, information maps, foundation and custom repositories, web reports, OLAP cubes, Monitoring SAS system performance, including individual processes, overall disk, CPU, Memory usage utilization and ability to assess growth and plan required upgrades.
• Extensive knowledge is SQL server Analysis services (SSAS).
• Ensure that system controls are in place to meet change management & compliance requirements.
• Setting up spawner’ Confidential (object, connect), servers (metadata, shared, stored process, OLAP,) and making sure to keep them up and running.
• Strong experience in SAS/Base, SAS/Graph, SAS/Stat, SAS/Connect, SAS/Access, SAS/ODS, SAS/SQL, SAS/Macros, SAS/Enterprise Guide, SAS/Enterprise Miner, SAS/Share, SAS Enterprise BI Server and SAS Management Console.
• Configuring SAS post install for setting up DB connections to enable data flow for users.
• Ability to work efficiently in both independent and team environments, worked with Project Managers, Team Members / Associates, Statisticians, Business Analysts.
• SAS Software stack includes SAS Enterprise Business Intelligence.
• Full support on all aspects of SAS EBI and SAS users and hotfix, maintenance release, update/upgrade on SAS 9.1.3 SP4, 9.2 TS2M3 & SAS 9.3 M1, SAS 9.4 M1 and the installation of SAS/Access products.
• Monitoring, logging and Troubleshooting SAS servers.
• Experienced SAS Grid and SAS Server Administrator. Extensive experience of LSF Platform, Platform RTM for SAS, SAS Grid, SAS server installation, configuration, administration and performance tuning, including SAS BI server, SAS Metadata server, SAS SPD server.

TECHNICAL SKILLS:

SAS Tools: Base SAS 9.4/9.3/9.2/9 , SAS/Stat, SAS Macros, SAS/SQL, SAS/ETL, SAS Graph, SAS Enterprise Guide, SAS/DI, SAS/EM, SAS/TM, SAS/SMC, SAS/FS, SAS/WRS, SAS/OLAP, SAS/AMO

Reporting Tools: Base SAS versions 9.3/9.2/9, SAS Enterprise Guide, SAS Enterprise Miner, SAS Graph, MS-Excel, SAS BI Platform, SAS OLAP Cube Studio, SAS Web Report Studio, MS-VISIO, and MS PowerPoint

RDBMS: SAS SQL, DB2, Oracle 7x/8i/9i/10g/11g, Teradata, MS-Access, Microsoft SQL Server, Netezza, Green Plum, SAP Hana and MySQL.

Languages: SAS, SQL, C, C++, C#, Java, Visual Basic, Visual C++, PHP

Operating System: Windows 95/98/XP/Vista/Win 7/Win 8/Win 10, UNIX, MAC OS, Linux and DOS

Batch Server: UNIX, Putty, SSH, and SAS scripting

Web Server: HTML, JSP, Linux, Apache Server

Office Tools: Word, Excel, PowerPoint, MS ACCESS, MS Visio

PROFESSIONAL EXPERIENCE:

Confidential, NY

SAS Administrator

Responsibilities:

• Maintaining SAS 9.3 M3 and SAS 9.4.
• Successfully completed migration from SAS 9.2 EBI to SAS 9.4 EBI.
• Created SAS Depots for SAS 9.3 & 9.4 and related client installation documents.
• Administer all aspects of SAS Platform in blended environment of Linux and Windows servers.
• Created metadata repositories for each department and giving right access rights and create ACT’ Confidential .
• Administer and support all aspects of SAS Software in a SAS GRID Environment.
• Maintained SAS Visual Analytics Server.
• Monitor usage logs to assist in performance tuning of the systems and servers.
• Perform upgrade, patches hotfix, backup, and maintenance release installations of the SAS environments.
• Managing 91 users from various locations of India and USA.
• Full support on all aspects of SAS EBI and SAS users and hotfix, maintenance release, update/upgrade on 9.3 TS2M3& SAS 9.4 M1 and the installation of SAS/Access products.
• Management of SAS users and their security via SMC.
• SAS client software installations on PC, laptop and Virtual Desktops via remote access.
• Monitoring, logging and Troubleshooting SAS server issues daily basis.
• Performance tuning on SAS servers.

Environment: SAS 9.3/9.4, Windows, SAS/EG, SAS/OLAP, SAS Visual Analytics, SAS/WRS, SAS/SMC, SAS/AMO.

Confidential, NY

SAS EBI Content Developer

Responsibilities:

• SAS 9.3 & 9.4 Platform Administrator to a 400 user’ Confidential environment.
• Provide 24x7 SAS support as needed.
• Maintaining all SAS configuration files, what they do, how they are related and how to modify in all 3 SAS EBI environments.
• Installed and configured SAS Visual Analytics Server.
• Administer and support all aspects of SAS Software in a SAS GRID Environment with LSF.
• Promoting successful Risk models into Production SAS BI server.
• Developed and implemented real-time error-capturing code in SAS for production environment.
• Designs, implements, and maintains platform security.
• Monitoring SAS system performance, including individual processes, overall disk, CPU, Memory usage utilization and ability to assess growth and plan required upgrades.
• Designs solutions to reduce the operational and management complexity of the platform.
• Assisted migration from SAS 9.2 to SAS 9.3.
• Installing ODBC drivers and creating SAS libraries for DB2, Oracle, SQL Server & Greenplum, SAP Hana, GPFS.
• Managing security models involving in administering the SAS installation.

Environment: SAS 9.2/9.3, Windows, DB2,Office Analytics, Oracle, SAS Visual Analytics, SQL, green plum, SAS/SMC, SAS/EG, SAS/OLAP, SAS/WRS.

Confidential, New York, NY

SAS Administrator

Responsibilities:

• Managing dev/test/prod SAS 9.3 EBI environments that run on 30 Linux hosts.
• Installation, Administration and Support of the software in conjunction with SAS on UNIX including hotfixes and patches.
• Administer and update all aspects of SAS Platform including SAS Enterprise Business Intelligence.
• Ensuring SAS availability 24/7 for End Users.
• Managing all SAS user, over 135, needs in terms of user and group creations with read & write access.
• Worked on CPM module.
• Monitor storage growth and work with user areas to develop purge criteria. Coordinate with other IT groups on performance, storage issues, etc. Coordinate with SAS "power users" to -schedule production loads/job.
• Create and maintain user profiles and groups consistent with security restrictions and performance considerations. Coordinate with IT Security as required.
• Work independently to resolve issues and escalate to management and other teams as needed.
• Installation of SAS software on client desktops within our group and preparation of documents for installation tasks for Help Desk technicians.
• Monitoring of servers, databases and workstations to ensure availability and efficiency.

Environment: SAS 9.3, Windows, SAS/EG, SAS/OLAP, SAS/WRS, SAS Visual Analytics SAS/SMC, SAS/DI, SAS Visual Analytics, SAS/TM, SAS/FS.

Confidential

SAS Administrator

Responsibilities:

• End - End Installation support and maintenance of version 9.2 of SAS on HP-UX, AIX, Solaris and Windows.
• Working on assigning libraries and pre- assigned libraries adding/deleting/security for the libraries via management console for SAS, DB2, Oracle, Teradata, SAP Hana.
• Using Management Console (SMC) for setting up users, groups, access permissions, metadata access, database connections, registering stored processes, information maps, foundation and custom repositories, web reports, OLAP cubes.
• Backup and restore metadata, scripts to start and stop SAS BI services, backing up webdav.
• Monitor environment for performance and proper operation.
• Worked on CPM module.
• Support end users with access and connectivity issues.
• Troubleshoot errors and work with the team and Unix Engineering on problem resolution and product deployments.
• Serve as the single point of contact for request and services from SAS developers and business users.
• Setting up spawner’ Confidential (object, connect), servers (metadata, shared, stored process, OLAP,) and making sure to keep them up and running.
• Monitoring SAS system performance, including individual processes, overall disk, CPU, Memory usage utilization and ability to assess growth and plan required upgrades.

Environment: SAS 9.2, Windows, Solaris, SAS/EG, SAS/OLAP, SAS/WRS, SAS/SMC, SAS/DI, SAS/EM.