Uttam Bavaria

Chandan

734-***-****

acvhly@r.postjobfree.com

Carrier Objective

Challenging position in SAS administrator and Consultant which encourages growth and

Leadership Opportunities and work with a concern providing me with most challenging job in

the field, where by I can use my intellectual and analytical skills and attain Organization Growth.

Professional Summary

Over 7 years of experience working as SAS Admin and Unix/Linux (Aix, Solaris, Redhat, Ubuntu server)

Admin.

Experience with SAS BI on SAS 9.1.3, 9.2, 9.3,9.4 Administration on various UNIX platforms.

Good experience migrating SAS Servers from 9.1.3 to 9.3 to 9.4 and working in multi-tier applications.

Experience with Base SAS, SAS Metadata Server, SAS Object Spawner, SAS Management console 9.1.3,

9.2, 9.3, 9.4 SAS Enterprise Guide 4.1, 4.3, 5.1, PC SAS, SAS OLAP Cube Studio, SAS Information Map

studio, SAS Performance Data Server and SAS Web Portals.

Good experience in SAS Grid 9.3 and 9.4 Server Installation, Configuration, Administration and Managing

metadata repositories.

Experience in configuring and managing high-availability (HA) and disaster recovery (DR) processes

associated with the SAS 9.3 and 9.4 Grids.

Experience in administering SAS 9.3 Platform RTM, monitoring jobs, setting up system thresholds for high

usage of server resources alert.

Management of User accounts and System security in SAS Management Console, maintaining file systems,

performance monitoring and tuning.

Experience in applying new license for SPDS, SAS Platform RTM and SAS Meta/compute servers.

Good experienced in working with Relational Database Management Systems such as Oracle, DB2, SQL

Server, GreenPlum, SPDS.

Experience in applying Hotfixes of SAS 9.1.3, 9.2, 9.3,9.4 on server side as well as client side.

Strong experience in Shell scripting to make process automated for client.

Hands-on experience with all aspects of Architecture, Designing, developing, testing and implementing ETL

solutions.

Work comfortably with both business and technologists.

Experience with designing and implementing data staging, including staging database design and staging

logic.

Take responsibility for performance tuning & Ability to troubleshoot issues in a multi-tier environment.

Coordinated efficiently with Business Analysts, Application Architects, and Infrastructure teams in handling

setup and maintaining SAS servers.

Worked on flexible hours for production, backup and on-call support for 24/7 environments.

ACADEMIC QUALIFICATION

Bachelor of Engineering: Electronics and Telecommunication. August - 2009

Pune University, Pune, Maharashtra, India.

Diploma of Engineering: Electronics and Communication. December- 2006

Maharashtra Board of Technical Education,

Mumbai, Maharashtra, India.

TECHNICHAL SKILLS

SAS: SAS BI 9.1.3,9.2,9.3 SAS Base 9.1.3,9.2,9.3,9.4 SAS Enterprise guide 4.1,4.3,5.1, PC SAS, SAS

Management Console 9.1,9.2,9.3,9.4 SAS OLAP Server, Metadata Server, Object Spawner, Data Integration

Studio, Web Report Studio, Enterprise Miner, SAS Access Interface to Oracle, Taradata, IBM DB2, Greenplum,

SQL Server, SAS Grid queues and their Priority, LSF Job scheduler.

Operating Systems: Linux (Redhat 4/5/6,Centos, Ubuntu,Fedora), Aix 5.x/6.x, Solaris (11/10/9), Windows

2000/2003/2008r2/2012 Sever, VMWARE ESX/ESXi 4.x/5.x .

Database: MySQL, DB2, Taradata, SQL, Oracle 11g / 10g, Greenplum, SPDS 5.3, 4.4 & 4.3.

Network Protocols & File System: ext2, ext3, ext4, GPFS, TCP/IP, DNS, DHCP, SNMP, SMTP, FTP, NFS,

NIS, SSH, LDAP, LAN, WAN, AT, SSH, rlogin.

Tools: Autosys job scheduler, Crontab, SAS Platform RTM monitoring, Ganglia system monitoring, Logical

volume manager (LVM), nmon monitoring, Cygwin.

Hardware: IBM pSeries 630, 670, Power 7 series, HP ProLiant DL 385, 580,585, HP blade server c3000/c7000,

Dell PowerEdge T300.

Programing language: C, C++, shell scripting, SAS Programing.

PROJECTS

Zions Bank (Salt Lake City,UT) Nov15 Present.

SAS Administrator

Responsibilities:

As a SAS Administrator and consultant responsible for managing and administration the SAS analytics with

Big Data platform Integration includes capacity planning, New products (i.e.) SAS 9.4 Grid Upgrade from

Single node to Multi Node, Teradata Integration through SAS etc. evaluation and installation and training

business users on the new SAS BI tools.

Involved in SAS Grid Upgrade from Single node to Multi Node with Teradata Integration. Working Closely

with SAS and IT on gathering requirements to prepare Road Map and Pre-installation document and Active

directory integration from UNIX standalone login.

Involved in SAS upgrade End to End from SAS 9.3 to SAS 9.4 with Teradata Integration. Engaging

collaboratively with the customer to demonstrate the new SAS product capabilities to SAS users community,

which enable business users to derive more value out of the historical data.

Involving in Performance Tuning, predictive analytics initiative, to understand the how new SAS BI statistical

tools can be used to build efficient predictive models.

Single point of contact to the customer for all production related issues and changes for the SAS BI platform.

Responsible for setting up programs that make it easier to understand past and current figures and predict

future successes/Loss.

Provide expertise in design, development and implementation of Business Intelligence (BI) and analytics

systems using tool SAS Enterprise Guide, SAS Enterprise Miner and SAS Text Miner.

Responsible for setup a demo to show the client how new hardware and software makes data easier to

manage.

Subject Matter Expert for the BI Applications hosted in the SAS platform, Project management and status

reporting to customer for the SAS related applications.

Environment: BASE SAS 9.4, SAS Management Console 9.3/4, SAS Enterprise Guide 7.1SAS/STAT, SAS/MACROS,

SAS/GRAPH, SAS/ACCESS, SAS Enterprise/Text Miner, SAS PC File Server, UNIX.

Uttam Bavaria

BCBS, TX Apr 14 Oct 15

SAS Administrator

Responsibilities:

Deployed end user SAS applications and make sure all the client/server connectivity is intact without any

performance issues.

Managed SAS Connect server, Metadata Server, Object Spawner, OLAP server, Store Process Server on

the AIX 6.1 environment.

Responsible for implementing the production changes such as installation of new SAS products on the server,

upgrading the SAS products, applying the patches and license renewals by following Change Management Process.

Managed SAS Metadata Server, ensured its availability without any performance issues and took regular

backups of the repositories.

Created new metadata objects using SAS Management Console 9.3 for projects to the end users in SAS

Metadata Server.

Created an ACL at Group level, User level and Table level in SAS Management Console 9.3.

Responsible for configuring the web based SAS services like Enterprise Miner, Stored Process and SAS web

portals.

Configure SAS 9.3 Platform RTM to spread jobs in different queues and set up threshold for server

resource utilization to send email notification when utilization is high.

Configured SAS Grid Manager Utility to send all SAS EG and batch jobs across grid based on grid

algorithm.

Created SAS Metadata Libraries for all kind of database (Oracle, SPDS GreenPlum, and MySql).

Installed and configure Jboss 5.1 to support SAS Web Applications like SAS Store Process, Web Report

Studio, SAS Bi Dashboard and BI Portals for both dev. and prod environment.

Installed and configured client components like SAS Enterprise Guide 4.3 & 5.1, PC SAS 9.1 & 9.3, SAS

Enterprise Miner 5.1, SAS Personal Login Manager 9.1 & 9.3, and SAS OLAP Cube Studio 9.1 & 9.3.

Installed and configure SAS Deployment tester 9.3 for testing all SAS Services on server runs fine.

Installed and configured SAS Access to Oracle, SQL and Greenplum database.

Developed shell script and SAS code to monitoring workspace and disk quota of SAS environment, Send

email notification to end user whenever utilization is above threshold.

Developed shell script to schedule batch jobs from crontab.

Supported production jobs and coordinated with UNIX system administrators to ensure the jobs are running

successfully.

On-boarded all SAS server ports into monitoring system to ensure high availability.

Escalated the issues and worked closely with SAS Support in resolving issues related to users and

environment.

Migrated SAS developed projects from 9.1.3 to 9.3 along with their base code.

Migrated SAS BI Application from SAS 9.1.3 Solaris 10 to SAS 9.3 AIX 6.1 operating system

Migrated SPDS tables from SPDS4.4 to SPDS5.3 with same domain structure.

Migrated SAS Metadata users from SAS 9.1.3 to SAS 9.3 and created new groups and ACL.

Coordinated with various support teams to deliver the projects in a timely manner.

Environment: SAS Management Console 9.3, SAS Grid Manager Utility, SAS 9.3 Platform RTM, SAS Access to Oracle,

SQL and Greenplum, SAS Enterprise Guide 4.3 & 5.1, PC SAS 9.1 & 9.3, SAS Enterprise Miner 5.1, SAS Personal

Login Manager 9.1 & 9.3, and SAS OLAP Cube Studio 9.1 & 9.3.

ABN AMRO Bank, Detroit, MI Oct12 - Mar 14

SAS Administrator

Responsibilities:

Responsible for SAS 9.3 Application Server under Solaris 9/10 with 4 different Servers for different in house

clients requirements.

Responsible for Managing Metadata Server and ensure its 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.

Work with Project SAS Admins to fulfill the users special request needs.

Responsible for managing SAS Metadata server, Connect App Server, Object Spawner, Store Process

Server on the primary Solaris environment under Sun Spark M9000.

Responsible for Managing User accounts and System security in SAS Management Console 9.3,

maintaining file systems, performance monitoring and tuning for around 1000 users.

Responsible to manage production support/maintenance issues of SAS 9.3 Application with 40 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.3)

Adding/Manage SPDS users and responsible for backing up their day to day data.

Responsible for SAS Web Report Studio application servers uptime and availability along with WEBDAV

repository for WRS in SAS Management Console

Responsible for helping end users (SAS Developers and BI Users) in terms of allotting user quota and

resolving their SAS dataset level issues.

Responsible for end users data management (Work Space) and Monitoring Work Space.

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 /Production

Servers

24/7 production jobs management using Autosys and take care of scheduled jobs

Responsible for all the production jobs that are running in Autosys and co-ordinate with Solaris System

administrators in ensuring all the jobs are running smooth.

Environment: SAS Management Console 9.3, Application Server, SAS Web Report Studio application, SAS Metadata

server, Connect App Server, Object Spawner, Store Process Server, SPDS environment, SAS BI Users.

Nationwide - Columbus, OH Nov10 Sept 12

Unix/SAS Administrator

Responsibilities:

Worked on upgrading platform application from 9.1.3 on AIX to 9.2 on Solaris 5.10 operating environment

with SP4.

Involved in promoting SAS/Access Interface to Oracle, DB2, Teradata Servers on the newly build 9.2

setup by re-configuring its SASROOT! host specific files and tested with SAS User community by working

with separate groups

Migrated all the Enterprise guide projects from 4.0- 4.3 and all the Enterprise Miner projects from5.3- 6.1

Worked very closely with SAS technical support and used a Plan file while implementing the new SAS 9.2

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

Performed post installation procedures to make sure SASROOT! file systems point to the new 9.2 installation

by exporting external Database client installations

Extensive experience in day to day SAS administration like managing users using SAS Management

console.

Uttam Bavaria

Changing SAS users directory permissions upon the request of the SAS user community.

Responsible for creating new pre-defined libraries for upcoming projects to the end users in SAS server

using SAS Management console.

Conduct meetings with business group managers and understand the potential need for future data

requirements to make them aware by going through the approval process.

Observe server performance status by using UNIX level commands and understand each users utilization.

Build Knowledge base articles for SAS while troubleshooting on day to day basis and update in internal SAS

wiki for future references.

Develop and maintain documentation of the system configuration, and apply hot fixes and maintenance

releases to SAS 9.1.3 & 9.2 Server & SAS products.

Installation, configuration, and administration of Red Hat Linux 4/5.

Use Bash/Korn shell and perl scripts to monitor system resources and system maintenance.

Evaluate and install new software releases, system upgrades, and patches within a configuration

management framework.

Installed and maintained the Websphere Application Server and Apache-Tomcat server in Linux Platform.

Configuration and administration of LDAP, NFS and NIS in Linux and also implemented Samba for

sharing of resources between Linux and Windows environments.

Installing and configuring of ESXi 4.x/5.x server, Creating cluster in vmware,Configuring High

Availability (HA),DRS.

Consolidation of Physical servers, deploying virtual servers using template, Cloning of virtual server,

Rules creation.

Installing local and remote YUM server on Redhat.

Creating new file systems, managing and checking data consistency of file systems.

Configured the systems for TCP/IP Networking with the existing LAN.

Created disk groups, volumes, volume groups and RAIDs using VERITAS Volume Manager and

Logical Volume manager.

Installed and configure Postfix SMTP server on centos 6 to replace Companys old MS exchange server.

Configuration of Vmotion, virtual switch, Vlan in Virtual center.

Responsible for data backup and restoration services.

Environment: SAS 9.2 installation, Migration from SAS 9.1.3 to SAS 9.2, SAS/Access Interface to Oracle, DB2,

Teradata Servers, Migrated all the Enterprise guide & Minner & more.

Cigna Health Springs, Nashville, Tennessee Aug09 Oct 10

SAS Administrator

Responsibilities:

Implemented the Hot Fix Installations, User Issues, & any other Maintenance issues

SAS Server has to be constantly backed up & has to be restored in case of server crash

Hands on Skills on Management Console Important are - Server Manager, User Manager, Authentication,

Customer Intelligence, Setting up Logging

Setting up DB Connections from Management Console to Oracle & DB2

Monitor all the tiers Metadata, Compute & Web on unix.

Promotion of Metadata such as libraries, metadata folders, information maps, campaigns, etc from one

environment to another

Actively participated in the complete SDLC Life Cycle of development, from the requirement phase to testing

phase

Monitor storage growth and work with user areas to develop purge criteria. Coordinate with other IT groups on

performance, storage issues, etc

Monitoring of servers, databases and workstations to ensure availability and efficiency.

Document operational processes and recovery procedures

Maintain environment configuration information

Administer user access and security on the system

Maintain the User Inventory & License Information

Install, Configure and support SAS 9.1.3/2 environments including SAS Metadata Server on unix.

Environment: SAS 9.1.3/2 environments, SAS Management Console, SAS Server backed up, Hot Fix Installations, DB

Connections to Oracle & DB2, user access and security, Inventory & License Information.

RESIDENTIAL STATUS

U.S. Citizen, ready to relocate for carrier and growth opportunity.

Contact this candidate