Varun Sowri

848-***-****

ac4sb2@r.postjobfree.com

TECHNICAL EXPERTISE:

• Over 9 years of IT experience including SAS administration, SAS Grid administration and QA Analyst

• Extensive hands on SAS 9.1.3, 9.2, 9.3 and 9.4 administration including Base SAS, SAS Management Console, SAS Metadata Server, SAS Enterprise Guide, SAS Enterprise Miner, SAS Object Spawner, SAS Stored Process Server, Work Space Server, Data Integration Studio, Web Report Studio, SAS Information Delivery Portal, SAS OLAP Server, SAS Studio and SAS Connect server

• Experience in migrating users and data from SAS 9.2 to SAS 9.3 on UNIX environment

• Excellent installation & configuration experience of SAS servers and client applications in grid environment

• Installation and configuration experience of Platform LSF, RTM for SAS grid environment

• Experienced in installing, configuring and supporting web applications like Tomcat, Apache, and JBoss

• Experience in GPFS (Eminer and PC SAS) File system.

• Responsible for monitoring, reporting and controlling SAS server usage

• Possess extensive experience in analyzing problems and resolving issues of end users

• Experience in Ticket and Change Management products and procedures

• Experience in providing 24/7 call support for production environment

TECHNICAL SKILLS:

SAS BI Tools : SAS 9.1.3, 9.2, 9.3, 9.4 Base SAS,

SAS Enterprise Guide 4.1, 4.2, 4.3,

Connect to Oracle, SAS Connect to DB2,

Information Map Studio, SAS Web Report Studio,

SAS OLAP Server, SAS OLAP Cube Studio,

Data Integration Studio, SAS/Share,

SAS Add-in for Microsoft Office & PC file server

Operating System : Solaris Linux 5.6, Red Hat Enterprise Linux & Windows XP

Databases : Oracle 9i/10g & SQL Server 2005

Mid-Tier Server : Web logic, Xythos, Apache & Tomcat

X-Host Applications : Hummingbird v10, Reflection X & Cygwin

Packages : Microsoft Office (Word, Excel, PowerPoint & Outlook)

PROFESSIONAL EXPERIENCE:

Department of Human Services, PA

Mechanicsburg, PA Apr’ 13 - Till date

SAS Grid Administrator

Responsibilities:

• Installed and configured SAS 9.4 Grid environment

• Installed and configured LSF 7.1 & 9.1

• Created LSF queues for work load balance

• Performed various admin activities such as Metadata backup/restore, SAS servers refresh & hot fix/patch installations for SAS 9.3 & SAS 9.4 9.4

• Added users, created groups, metadata libraries & allocate metadata permissions using SAS Management Console

• Yearly SAS licenses for all SAS servers and platform LSF in SAS9.3 grid environment and supported SAS Admin activities by notifying downtime on SAS servers with users

• Created Metadata folders for each group and assigned permissions to that group only. Created folders such as Libraries, cubes, projects, etc. so that users can logically add Metadata content into the corresponding folders

• Created Base libraries and Database libraries

• Installed the client applications on user’s machines and worked with desktop support team to create SAS packages

• Experience in GPFS (Eminer and PC SAS) File system.

• Worked closely on end user tickets assigned to our queue

• Promoted Metadata from Dev to Test & Test to Prod as per the SDLC using SPK package

• Extensive experience working with different SAS products/services such as Metadata, Work Space Server, and Object Spawner

• Created script for cleaning the work space that killing the orphaned SAS processes running on the server using clean work utility that SAS provides

• Modifying SAS configuration files

• Supported users on various EBI clients such as Base SAS, SAS Enterprise Guide, SAS OLAP Cubes, SAS Studio, Information Maps, SAS Portals and with SAS Grid usage

• Perform server boot and shutdown as per requirements and process during maintenance windows

• Monitoring file system space, ports availability and resources on SAS Servers

• Provided the end-user community on daily basis and served their day to day functional needs on SAS 9.3 and SAS 9.4

CITIGROUP GLOBAL SERVICES LIMITED

Chennai, India Sep ‘07 – Sep‘10

SAS BI Administrator

Citigroup provides banking and financial services to its customers in various countries. Citi’s NA collections (Credit cards, Auto loan, Mortgage loan and personal loan), Risks and Controls are to design & analyzes the business to take an effective decisions.

The enterprise solution Credit Risk for Banking Solution includes the following products:

SAS Enterprise Miner

SAS Web Report Studio

SAS Enterprise guide

SAS Connect

SAS Graph

SAS Access interface to Oracle, DB2 and MS SQL Server

SAS Stored Process

Responsibilities:

SAS BI 9.1.3 support responsibility:

• Responsible for SAS 9.1.3 Application Server under HP Unix Enterprise framed environment separated into 4 Servers environments servicing 18 internal business units such as Risk, FINANCE, HR and other departmental SAS Developers/Business Analysts, Economists, Model builders etc within one enterprise class of SUN 25K framed architecture

• Responsible for managing all the Production jobs in coordination with Autosys Team.

• Responsible for all the End-User community on daily basis and serve their day to day functional needs on SAS.

• Responsible for End-User’s data storage and conduct forecast on capacity planning and update to BI Manager on monthly basis

• Responsible for end users SAS software deployments and make sure all the client/Server connectivity is intact without any performance issues

• Conduct meetings with new SAS users and take the requirements (Both data and SAS needs) and plan according to their timelines

• 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

• Conduct meetings with each business group manager and understand the potential need for future data requirements and work with Unix administration team to make them aware by going through approval process

• Educate SAS end user community by ensuring their data cleaning has been taken care

• Educate SAS end user community on new user additions process and removals when they depart

• Work with group managers for on-going jobs that are processed via Autosys as a single point of contact by providing the start code formats in scheduler to kick off jobs on both Autosys and Batch mode processing

FLEXTRONICS TECHNOLOGIES INDIA PRIVATE LIMITED

Chennai, India Dec ‘06 - Sep ‘07

SAS Administrator

Flextronics Technologies Limited is one of the leading manufacturer & expertise IT services for their financial, Consumer, manufacturing and vendor services..

Responsibilities:

SAS BI 9.1.3 Server Side Support Responsibility:

• Responsible for managing SAS based tickets for all end users (SAS developers/programmers/clinical associates) issues on a day to day basis

• Responsible for quota management from the SAS developers where there is a requirement for additional space allotment on the server side

• Daily account management requests for creating users/password reset activities/modifying the privileges of a user

• Upgrade of SAS patches for the existing deployment SAS version 9.1.3 Involved in Planned downtime for patch management as part of build procedures for SAS application server

• Responsible for Daily Server reboots

• Involved in Change Management activities as part of service deliver operations

• Troubleshooting auto mounting issues, day to day NFS administration

• Scheduling jobs using CRONJOB, administering print queues

• Responsible for Troubleshooting based on alerts in /var/adm/messages

• Weekly log maintenance- save old data and cycle logs

• Installing, Configuring & troubleshooting Licenses

• Responsible for ticket management (Severity High & Critical tickets on a daily basis

EDUCATION:

• Master of Science in Information Technology & Management

• Bachelor of Computer Application

Contact this candidate