SUMMARY:

• Over 14+ years of experience technology IT which include 8+ years of experience in SAS Platforms admin and Solutions Administration background in LINUX/UNIX and production support in Banking, Health, Finance and Insurance Domains. and Retail.
• Extensive hands on experience in SAS Viya 3.3, SAS 9.1.3, SAS 9.2, SAS 9.3 & SAS 9.4 versions, SAS Connect, SAS OLAP Server, SAS Metadata Server, SAS Object Spawner, SAS Information Delivery Portal, SAS Management Console, SAS Enterprise Guide, SAS OLAP cube Studio, SAS Data Integration Studio, SAS Web Report Studio, SAS Connect Server, SAS Web Infrastructure Platform, SAS Enterprise Miner and SAS VA Visual Analytics Administration.
• Adding users, registering tables, etc. using Management Console.
• Installation of client applications and Troubleshooting technical problems.
• Strong experience working with Oracle on UNIX using command line and GUI SQL tools.
• Tracking applicable SAS hot fixes and creating implementation plans for respective SAS modules and applications. Monitoring SAS Server resources and reporting usage(s).
• Identifying performance and recommending/implementing tuning of active SAS environment(s) providing projected capacity shortfalls.
• Good understanding of the SAS Web tier and SAS Server Tier Architecture with excellent troubleshooting skills.
• Designing, implementing, and maintaining security on SAS Metadata and Linux for users.
• Designing, implementing, and executing the change control and promotions tasks in SAS.
• Establishing best practices and guidelines for SAS BI usage. Creating and implementing upgrade plans.
• Provide guidance and assistance to SAS Developers on operational and technical issues interfacing with the SAS Institute for Support on administrative and system issues.
• 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.
• Documented best practices for the SAS Application server from a scalability need.
• Expert in creation of Metadata folder structure and Metadata folder permission in SAS Management Console.
• Strong experience in SAS/Base, SAS/Graph, SAS/State, SAS/Connect, SAS/Access, SAS/Access interphase to Hadoop, SAS/ODS, SAS/SQL, SAS/Macros, SAS/Enterprise Guide, SAS/Enterprise Miner, SAS/Share, SAS Enterprise BI Server, and SAS Management Console.
• Established over 60 SAS libraries via SAS Management Console to the various Relational Database Management Systems such as Oracle, DB2, SQL Server, Netezza & Snow Flake.
• Expertise in Designing and building universes by Objects data model selecting/joining tables, indicating cardinalities, creating aliases to resolve the loops, subdividing into contexts and creating the objects, which are grouped into classes.
• Worked closely with Business analysts, Business users, Application architects, and production DBA in handling setup and maintaining SAS application server.
• Experience in developing different methods of extraction, transformation and loading (ETL) processes for various source systems.
• Excellent interpersonal, analytical, problem solving and communication skills with ability to interact with individuals at all levels.

TECHNICAL SKILLS:

SAS BI: Base SAS, SAS Metadata Server, SAS/EG, SAS Macros, SAS ODS, SAS/Graph, SAS/Access to RDBMS (Oracle, MSSQL Server, ODBC, MySQL), SAS/Connect, SAS/Share, SAS App Dev Studio, SAS OLAP Server, SAS OLAP Cubes, Platform Suite for SAS (SAS GRID Architecture), SAS Security. Installation /Configuration Administration of SAS BI Server, Metadata Server.

Databases: Oracle 9i/10g, MSSQL Server, MS Access, Teradata, Sql server 2008

Big Data: Cloudera, HDFS, Hive, Impala. Hue, Spark, Scala, Python 2.7,Numpy, Scipy, matalibplot, pandas etc.

Operating System: Windows 2000, Windows NT, Windows 9x,Linux

Data Modelling Tool: IBM Rational data architect, ER - Diagram

Version Control Tool: VSS and SVN

Project Management: Microsoft Project, JIRA

PROFESSIONAL EXPERIENCE:

Confidential

SAS Admin

Technologies Used: SAS Viya 3.3, AWS ec2, S3, Linux, ansible.

Responsibilities:

• Download SAS Viya Create a Mirror Repository.
• Run ansible-playbook system-assessment.
• Performed pre-install check as per the SAS provided documentation.
• Creation of inventory file and use ansible-playbook to install SAS Viya servers.
• Installation and configuration of SAS Viya 3.3 on Dev, QA and Production environment on AWS Ec2 servers.
• Configuration of Ldap authentication.
• Documentation of Installation process.
• Configuration to access data from S3 and snowflake.
• Coordinating with AWS, network to opening various ports and setting up firewall rule.
• Design of backup strategy for SAS metadata and other folder structure.

Confidential

SAS Admin

Technologies Used: SAS 9.4, AWS ec2, S3, Snowflake, Python, Jupiter notebook.

Responsibilities:

• Download SAS 9.4 and perform depot check.
• Performed pre-install check as per the SAS provided documentation.
• Installation and configuration of SAS 9.4 on Dev, QA and Production environment on AWS Ec2 servers.
• Installation of SAS client tools on Window server and made them available to user using Citrix server.
• Configuration of PAM authentication.
• Documentation of Installation process.
• Configuration to access data from S3 and snowflake.
• Coordinating with AWS, network to opening various ports and setting up firewall rule.
• Design of backup strategy for SAS metadata and other folder structure.
• Creation of various business user and provide the access based on their roles using SMC.
• Used rsync in migration of data from on-prim old forecast server to AWS server.

Confidential

SAS Architect/SAS Admin

Technologies Used: SQL, SAS BASE, Oracle, Unix, Management Console, Enterprise Guide, SAS DI, Jira and SVN, Python 2.7, Hive, Impala, Pig, Hue.

Responsibilities:

• Responsible to handle SAS 9.3 M2 Grid Environments and address day to day activities.
• Experience in setting up Data Access in SAS, including registering libraries and tables in the metadata, updating table metadata, setting up data access, and troubleshooting data access.
• Experience with different SAS servers and troubleshooting potential configuration problems.
• Expertise in managing SAS Application and Operating System level security, managing SAS Configuration Files.
• Response file has been created to install & uninstall SAS client tools on the user's machine by silent process.
• Worked on Migration project to move SAS93 users to SAS 94 Environment and fixing the issues which have been raised.
• Co-ordinated with different teams and updated the shell script to move respective batch jobs to run in SAS 94 Environment.
• Build graphs to track jobs which are running in batch vs EG jobs and jobs running in each node.
• Worked with vendor to track SAS EG idle sessions and touch base with him to kill the sessions.
• Coordinated with Storage team to decrease I/O wait, server latency and address sas -app connectivity.
• Worked with network team to address green plum connectivity issues due to MTU size increase.
• Responsible for maintenance and troubleshooting of the SAS 9.4,9.3 environment which includes SAS Metadata Server, SAS Enterprise Guide, OLAP Server, SAS Connect Server, and other SAS products running on AIX platform.
• Conduct meetings with new SAS users and take the requirements (both data and SAS needs) and plan according to their timeliness.
• Co-ordinated with SAS account representative regarding timely renewal of SAS software and receiving SID (Software Installation Data) files.
• Updating SAS licenses, applying SAS hot fix patches on AIX environment, fix existing bugs and to keep the SAS BI server environment up and running and bug free.
• Co-ordinated with SAS account representative regarding timely renewal of SAS software and receiving SID (Software Installation Data) files.
• Updating SAS licenses, applying SAS hot fix patches on AIX environment, fix existing bugs and to keep the SAS BI server environment up and running and bug free.

Confidential

Data Architect / SAS Admin

Technologies Used: SAS 9.1/9.2/9.3, LINUX, DB2, Oracle, Teradata, SQL, SAS/SMC, SAS/EG, SAS/OLAP.

Responsibilities:

• Installed SAS 9.3 on Linux 6.2 server in Test & Production Environment.
• Played a key role on End to End SAS implementation involving hardware and software compatibility, Performance testing.
• Client Installation Enterprise Guide, Enterprise Miner, SAS Management Console, OLAP Cube Studio in Windows 7.
• Worked on External database connectivity set up - SAS Access to Teradata/Oracle/DB2/SQL.
• Responsible for all the End-User community on daily basis and serve their day to day functional needs on SAS.
• Responsible for maintenance and troubleshooting of the SAS V9.1.3 & V9.2 environment.
• Installed SAS Access interface drivers for both SQL server and oracle.
• Responsible for End-User's data storage and conduct forecast on capacity planning and update to BI Manager on quarterly basis.
• Updating SAS licenses, applying SAS hot fix patches on UNIX environment, fix existing bugs and to keep the SAS BI Server environment up and running and bug free.
• Migrating Metadata from SAS 9.1.3 to 9.3.
• Migrating 60 TB of data from Oracle Solaris 5.9 to Linux 6.2 Server.
• 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.
• SAS Work Space monitoring and cleanup.
• Worked as a single point of contact from IT and support prospective for all 122 SAS users.
• 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.
• Customized by implementing SAS Batch scripts to make jobs run via Control-M.
• Monitoring server performance at regular intervals and recommend required changes in the infrastructure.
• 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.

Confidential

Technical Lead/SAS Admin

Technologies Used: SAS 9- BI, SAS DI Studio, Management Console, Enterprise Guide, SAS DI, SAS OLAP Cube.

Responsibilities:

• Provisioning User requests based on Access Control Libraries (ACL).
• Understanding of SAS Layered Architecture and its framework.
• Creation of Initial Roles, Groups and Users.
• Analyze/Repair Metadata using SAS Management Console's Metadata Manager
• Hotfix Changes using bin scripts
• Password changes using SAS Deployment Manager 9.2
• Troubleshooting SAS Issues and System Level Changes.
• Liaising with SAS Technical Support on critical Issues.
• Adding new libraries to the Metadata Server
• Checking the status and operations of SAS servers and processes, including starting, stopping, and/or pausing the servers / processes used in the SAS system
• Managing metadata repositories
• Monitoring, logging, and/or troubleshooting SAS servers and processes, including error messages and using system logs or setting logging options as well as options within SAS Management Console (SMC)
• Understanding SAS installation directory structures related to servers, SAS Scripts, configurations, content, etc
• Imported SAS datasets from SAS Management Console to SAS information Map Studio