Kumar

Cell: 989-***-****

Email: ac1ox4@r.postjobfree.com

Synopsis:

** ***** ** ********** ** SAS Platform Grid Administrator/SAS BI Admin/SAS Developer in analysis, design, development, Installation & maintenance of SAS applications on Windows, Linux/Unix platforms.

Experience in Installation and Configuration of SAS 9.4/9.3 Servers, Platform Suite for SAS Version 9.13 (Platform LSF 9.13, Platform process Manager 9.13, Platform Grid Management services 8.01) in SAS Grid Environment and Administration.

Performing SAS client installations on user's machines and assisting them in connecting to the SAS GRID server from the required SAS product for their activities and assisting them in trouble shooting with any issues.

Experience enabling SAS code to run on the GRID in a SAS/Foundation environment (enabling EG and EM processes to run on the SAS GRID).

Experience with Platform LSF, PM, GMS and Enterprise Grid Orchestrator as it pertains to a GRID environment (E.g., troubleshooting, configuration, installation, etc.).

Experience in monitoring and troubleshooting SAS services.

Experience with different SAS servers and troubleshooting potential configuration problems

Experience in Adding nodes to the GRID environment, or reconfiguring nodes.

Experience in Migration of SAS legacy servers (9.2, 9.3) to SAS 9.4 M3 Grid and assisted users with migration issues, coding issues, application issues, DB Connectivity issues, Access Issues, & Performance Issue, etc.

Stopping/starting the respective SAS servers and LSF Services as part of the Maintenance activities.

Updating patches, applying hot fixes & renewing the License on SAS servers and Client machines.

Experienced integrating SAS with Hadoop

Experienced in various SAS administration activities like monitoring different servers and experience using SAS Management console for all admin activities (Creating users, groups, Access control templates, Metadata Folder structures, Libraries and registering tables, database and server configuration, Scheduling jobs, managing security and permissions).

Experience in administering SAS Grid environment using SAS Environment Manager and RTM server.

Worked with multiple internal technical teams (Database, UNIX, Windows and Network) to troubleshoot issues related to SAS environment and enhance the performance.

Experience in configuring database connectivity through SAS/Access Interface to ODBC for the databases like Oracle, DB2, MS SQL Server, and Green plum.

Profound knowledge and strong experience on all SAS Applications & Servers that includes

Base SAS/SAS 9.4, SAS 9.3, SAS 9.2, SAS Management console, SAS Enterprise Guide, SAS Enterprise Miner, SAS OLAP Cube Studio, SAS Information map studio, SAS Web portals,

SAS Metadata server, SAS Workspace Server, SAS Stored Process Server, SAS OLAP Server, Object Spawner, Connect Server, AP Server, SAS Remote Services, SAS Grid Manager,

Platform Suite for SAS, Tomcat/ Apache, IBM Web Sphere MQ(AIX),SAS Xythos.

Excellent interpersonal, analytical, problem solving and communication skills with ability to interact with individuals at all levels.

Academic Qualification:

Bachelor of Engineering in Electrical & Electronics from P.D.A college of Engineering.

Post Graduate Diploma in Computer Applications (PGDCA).

Professional Skills:

OS : Windows 2000/NT/XP, UNIX, Red hat Linux 6.8, Microsoft(R) Windows(R) Server 2000/2003/2008/2012.

SAS Skills : Base SAS, SAS/MACRO, SAS/Connect, SAS/SQL, SAS/STAT, SAS/GRAPH, SAS/Share, SAS/GPLOT,SAS/IntrNet, SAS/ODS, SAS/Access, SAS Management Console 9.2/9.32/9.4,SAS Enterprise Guide 6.1/7.1/7.13,SAS Metadata Server, Object Spawner, Connect Server, AP Server, SAS SPDS, OLAP Server, SAS Stored Processes Web Application 9.4, SAS Information Map Studio 4.3/4.4, SAS Grid Computing, SAS OLAP CUBE Studio 4.3/4.4, SAS EDI, SAS EBI, SAS Web OLAP Viewer for Java, SAS/AF, SAS Enterprise Miner 12.3/13.2/14.1SAS Web report Studio 4.4, SAS Information Delivery portal 4.4, SAS Enterprise BI Server, SAS ETL Studio, SAS DI Studio 4.2, SAS Environment Manager 2.5, SAS Studio 3.4, SAS Workflow Studio 1.3,SAS Forecast Studio, SAS Remote Services, Platform Suite Components (Grid)-Platform LSF 9.13, Platform Process Manager 9.13, Platform Grid Management Service 8.01.

Big Data Technologies: HDFS, Hive, MapReduce, Cassandra, Pig, Hcatalog, Phoenix, Falcon, Scoop, Flume, Zookeeper, Mahout, Oozie, HBase, Storm.

Networking: Active Directory, TCP/IP, DHCP, DNS, Network routing, VMware, VLAN, VPN, Firewall.

Databases : Oracle, MS SQL Server, DB2, Teradata.

Programming Languages: C, C++, SQL, PL/SQL

Mainframe Tools : MVS/JCL, TSO/ISPF, COBOL.

Web Technologies : HTML, XML, JSP, ASP.NET

Web Servers : Apache, Web logic, Tomcat, Microsoft Exchange 2000/2003/2007

Scripting : Korn, Bourne, PERL, Python, Bash, JavaScript, VB Script.

Professional Experience:

MUFG Union Bank NA, CA Jan'16 -Till Date

Role: SAS Grid Administrator

Responsibilities:

Involved in Installation and Configuration of SAS 9.4 Grid Servers on Red Hat Linux Server

Installed and configured the Platform Suite for SAS Version 9.13 (Platform LSF 9.13, Platform process Manager 9.13, Platform Grid Management services 8.01) on all SAS Grid Nodes.

Involved in all phases of Project lifecycle (Design, Development, Implementation, Testing, Deployment) including business process change and enhancements.

Performed Migration from Legacy platforms to SAS 9.4 M3 Grid and assisted users with migration issues, coding issues, application issues, DB Connectivity issues, Access Issues, & Performance Issue, etc.

Responsible for all SMC Administration related tasks (user creation, group creation, ACT creation, library creation, managing security and permissions).

Installed and configured Oracle, MS SQL Server, and DB2, Green plum databases on SAS Servers to Establish connectivity between SAS platform and data bases.

Stopping/starting the respective SAS servers and LSF Services as part of the Maintenance activities.

Scheduled Jobs using Job schedulers like Crontab, Autosys.

Responsible for monitoring environment's health for capacity planning to address growth in terms of storage, memory and CPU utilizations and I/O bottle necks on the Server at regular intervals.

Performing SAS product installations with SAS Deployment Wizard on user's machines and assisting users in connecting to the SAS GRID servers from the required SAS product for their activities.

Responsible for monitoring space usage in various environments to ensure the file systems are not full and send out notifications to users to clean up their unwanted files.

Provided maintenance and support for SAS products during deployment, upgrade and any changes to SAS products and/or during other enterprise activities that impact SAS infrastructure.

Updating patches, applying hot fixes & renewing the License on SAS servers and Client machines.

Performed file System Administration, permission and ownership changes.

Responsible for monitoring all of the SAS production scheduled jobs and work with the respective user’s community to trouble shoot the issue.

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

Worked closely with SAS Tech Support for SAS Installation and configuration on the SAS Grid Servers/debug issues and opening tickets about issues when required for any additional support on SAS Applications.

Creating various directories for every individual user in file system and setting up disk quotas to store their datasets and directing them to the path in the assigned server.

Environment: SAS 9.4,9.3,9.2, SAS Management Console 9.4,9.3 SAS Enterprise guide 7.13,7.11 SAS Information map studio 4.4, SAS OLAP Cube Studio 4.4, SAS BI Dashboard 4.4, SAS Web Report Studio 4.4, SAS Stored process web Application 9.4, SAS Information Delivery portal 4.4, SAS Enterprise Miner 14.1,SAS PC File Server, SAS Personal Login Manager 9.4, SAS Environment Manager 2.5, SAS Studio 3.4, SAS Workflow Studio 1.3,SAS AMO 7.11, SAS/Connect, SAS/Access, SAS Grid Platform Suite Components-Platform LSF 9.13,Platform Process Manager 9.13, Platform Grid Management Service 8.01D,Windows Server 2012 R2, Red Hat Linux (RHEL version 6.7), Oracle, MS SQL Server, DB2.

General Electric's, KY Dec'14 –Jan’16

Role: SAS Platform Administrator

Responsibilities:

Installed and Configured and support of SAS 9.4 environment on Unix Server.

Installation & Configuration of SAS Applications on users Machines and applying Hot Fix Installations and Support user Issues & other Maintenance issues.

Daily Monitoring of SAS Server tiers-Compute & Mid-tier, portals to make sure they are up and running and checking storage space, backup's, clean-up temp & log files.

Adding Users to SAS Linux server and Creating Users, Groups, Roles and ACT's in SMC and controlling user group security permissions.

Controlling user access to various parts of the SAS system, granting permissions to read, write, create or view reports and data within the system– ensure that Users see only the information that they are authorized to access.

Creating Base SAS, Oracle, SQL library's in SMC and registering data into Oracle, SQL SAS libraries and granting the users to access SAS data thru SAS Enterprise guide application.

Scheduled jobs on the servers as per users request.

Monitoring and Trouble shooting of Daily and Weekly Scheduled jobs on SAS Servers

Installed & configured ODBC drivers on servers for various Databases for connectivity to SAS and pulled Data into SAS environment.

Change SAS users directory permissions at times, up on the request by SAS user community

Data is loaded to SPDS (SAS Scalable Performance Data Server) data marts and business reports are created from the same and published in SAS Web Report Studio and SAS Information delivery Portal.

Did software upgrades, patches and maintenance for improving performance

Responsible for managing SAS based tickets for all end users

Responsible for Storage space quota management, where there is a requirement for additional space allotment on the server side.

Troubleshoot SAS Users applications issues and provided technical solutions to business user needs. Support Mid-tier - SAS portal issues, SAS Server configuration issues,SAS servers performance issues and following up SAS Users issues and open ticket with SAS Support, Weekend and afterhours SAS Production jobs Support issues

Installing, configuring and setting up connectivity to Hadoop by using SAS/Access

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

Supporting weekend and after hours Production jobs support issues.

Installing & renewing SAS Licenses.

Giving read/write permissions to users on requested Tables and Libraries.

Creating accounts for users and giving access to SAS Applications and controlling user group security permissions.

Supporting users SAS Applications issues and SAS Servers issues.

Environment: SAS 9.32, 9.4, SAS Management Console, SAS Enterprise guide 6.1, SAS Web report Report Studio, SAS Information map studio, SAS Stored process web Application, SAS Information Delivery portal, SAS Enterprise Miner, SAS Web OLAP Viewer For Java, SAS Enterprise BI Server, SAS/Connect, SAS OLAP Cube Studio, Hadoop, HAWQ, SAS Warranty Analysis, SAS Data Integration Studio 3.4 & 4.2, SAS/SPDS SAS/ACCESS, Solaris, Oracle, MS SQL Server, DB2.

Capital One, Richmond, VA Jul'12–Nov'14

Role: SAS Platform Admin

Responsibilities:

Build SAS 9.3/SAS 9.4 Server setup Clients installation & SAS server configuration on Linux server

SAS 9.4 Grid Administration & SAS Grid Computing Architecture responsibilities, client server and multi-platform across multiple environments

Install the Platform Suite for SAS Version 7.1, Platform RTM for SAS and configure the Platform LSF, Platform process Manager, Platform MPI and Grid Management services on SAS Grid Application server

Monitor the SAS Server services, OMABackup’s, cleanup temps, Users storage space allocation and worked with end user’s requests.

Adding New users to SAS Linux servers, Create Users Groups, Roles,Access control template creation and controlling SAS user group security permissions

Create SAS Oracle, SAS SQL library's on SAS Management console register data into Oracle, SQL SAS libraries and grant the users to access SAS data thru SAS Enterprise guide application

Deploy patches on SAS Linux servers, hot fix deployment on SAS Servers.

SAS servers license renewal,Users SAS Clients renewal deployment, Setinit license cycle and be able to update the Setinit to avoid a lock out

Build setup SAS Metadata server, mid-tier, compute server configuration experience

Adding New SAS Application server to existing SAS 9.3/9.4 Server Configuration environment

Experience in maintaining a large multi-platform SAS environment it includes SAS Business intelligence tools and SAS application tier.

Troubleshoot SAS Users SAS applications issues and provided technical solutions to business user needs. Support Mid-tier JBoss - SAS portal issues, SAS Server configuration issues,SAS servers performance issues and follow up SAS Users issues and open ticket with SAS Support, Weekend and afterhours SAS Production jobs Support issues

Environment: SAS 9.3,SAS 9.4, SAS/Management Console, SAS Enterprise Guide 5.1 SAS Stored Processes Web Application, SAS Web Report Studio, SAS Information Map Studio, SAS Information Delivery Portal, SAS OLAP CUBE Studio, SAS Web OLAP Viewer For Java, SAS DI Studio, SAS Enterprise BI Server, Oracle, SQL, HTML, XML, JavaScript, SAS Grid manager, Platform LSF, Platform process Manager, Platform MPI, Grid Management services, SAS Grid Application server, Platform RTM for SAS, SAS Enterprise Miner, Linux, Microsoft(R) Windows(R) Server 2003, Enterprise Edition, SAS Data Integration Studio 3.4 & 4.2, Metadata Server, Object Spawner, Connect Server, APServer, OLAPServer.

Upromise Inc, Needham, MA Aug'11 to Jun'12

Role: SAS Administrator

Responsibilities:

• Installation and Configuration of SAS using SAS Depot Manager.

• Creation of Initial Roles, Users and Groups.

• Troubleshooting SAS Issues and System Level Changes.

• Interfacing with SAS Technical Support

• Adding new libraries to the Metadata Server

• 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.

• 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

• Using information map studio combined relational data table, calculated new data items, and created multiple pre-defined filters.

• Installing for users client side SAS applications like EG, SAS Enterprise Miner

• Responsible for scheduling SAS Jobs, backup scripts, cleanup scripts.

Backing Up and Restoring the SAS Metadata Server, using the %OMABAKUP Macro to Perform Backups and Restores from Unix development server and production server.

• applying SAS hot fixes on Desktops Clients as well as Servers.

• scheduling daily metadata backups

• Responsible for setting up SAS Access/Interface to Oracle, MS SQL and Teradata servers for end users as per their requirements by implementing ODBC configuration settings

• Implemented all the SAS Server ports into Monitoring systems and pro-actively manage SAS Server availability by working/co-coordinating with Mid-Range Unix administration teams

• Add/remove users from the application side up on the request that are made by SAS Developers

• Creating Profiles for SAS Enterprise Guide and SAS Enterprise Miner Users

• Setting up users desired Base SAS Libraries and External database related libraries

• Day to day SAS Server performance checks

• Conduct SAS metadata Server audits to monitor failed connectivity by going through log directories on the SAS Servers

• Day to day User support by implementing libraries and provide/grant access to the users accordingly

Environment: SAS 9.2,9.3 SAS Management Console, AIX, Unix, SAS Enterprise guide, SAS Web report, SAS Information map studio,SAS Stored process, SAS/Connect, SAS/ACCESS, Oracle, MS SQL Server, Teradata.

CSAA Insurance Group, Phoenix, Arizona Mar'10 to Jul'11

Role: SAS Administrator

Responsibilities:

Install, Configure and support SAS 9.2 environments including SAS Metadata Server on Unix.

Hands on Skills on Management Console – Important are - Server Manager, User Manager, Authentication, Customer Intelligence, Setting up Logging.

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

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

Monitor all the tiers – Metadata, Compute & Web on Unix.

Maintain and troubleshoot batch jobs, administering print queues

Deploying web applications in Web Sphere

Promotion of Metadata such as libraries, metadata folders, information maps, campaigns, etc. from one environment to another

Monitor production jobs, makes corrections and reruns

Responsible for all of the SAS production scheduled jobs and inform the respective developers community when it fails on timely.

Setup grants to the SAS tools by going through the approval phase from their Line SAS managers

Change SAS users directory permissions at times, up on the request by SAS user community

Put all the requested jobs in Production by going through Change Management process

Connect SAS systems to other systems such as Teradata, oracle and DB2

Tested validation and derivation procedures and verified the accuracy of the data

Did software upgrades, patches and maintenance for improving performance

Provided help- desk support, technical support, production support

Impact analysis, identifying and analyzing impact of the business process changes

Responsible for managing SAS based tickets for all end users

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

Involved in Change Management activities as part of service deliver operations

Ensure the SAS support documents of Server administration are updated with version control

Weekly log maintenance- save old data and cycle logs

Go through all of the SAS Developers issues by going through Remedy 5.1 as a Ticketing system

Installing & renewing SAS Licenses

Responsible for ticket management and ticket escalation (Severity High & Critical tickets on a daily basis).

Environment: SAS 9.2 Software, SAS/Management Console 9.2, SAS Enterprise Guide 4.2, SAS DI Studio 9.2,SAS Information Map Studio 4.2, SAS Web Report Studio 4.2, SAS OLAP Cube Studio 4.2,Oracle,DB2,Teradata, Unix.

JPMorgan Chase, Columbus, OH May'09 to Feb'10

Role: SAS Administrator

Responsibilities:

• Day to day SAS administration such as User Management in Management Console

• SAS Client side users, Installations like EG, SAS Enterprise Miner

• Responsible for scheduling SAS Jobs, backup scripts, cleanup scripts using Crontab

• Responsible for applying SAS hot fixes on Desktops Clients as well as Servers.

• scheduling daily metadata backups

• Responsible for setting up SAS Access/Interface to Oracle, MS SQL and Teradata servers for end users as per their requirements by implementing ODBC configuration settings

• Ensure SAS license is up to date and work on all the SAS end users issues, with SAS support if necessary 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 by working/co-coordinating with Mid-Range Unix administration teams

• Add/remove users from the application side up on the request that are made by SAS Developers

• Installed SAS Services Application and SAS Analytics Platform Server on the Metadata Server

• Monitor all sas.admin emails bucket and troubleshoot and timely respond

• Setting up users desired Base SAS Libraries and External database related libraries

• Day to day SAS Server performance checks

• Conduct meetings with Business managers to under the their needs and drive with Unix Mid Range Operations Teams till the closure

• Test Management, Defect Tracking, and Reporting for enhanced Regression Tests

• Conduct SAS metadata Server audits to monitor failed connectivity by going through log directories on the SAS Servers

• Day to day User support by implementing libraries and provide/grant access to the users accordingly.

Environment: SAS 9.2, SAS/Management Console, SAS Enterprise Guide, SAS Data Integration Studio 9.2,SAS Information Map Studio 4.2, SAS Web Report Studio 4.2,SAS Information Delivery portal, SAS Enterprise miner, SAS OLAP Cube Studio 4.2, IBM Web Sphere MQ(AIX),SAS/SPDS Oracle,DB2, Unix.

United healthcare insurance, Hartford, CT Jun'08 to Apr'09

Role: SAS BI Developer

Responsibilities:

Identifying user requirements, functional specifications and business rules to design, attribution values for each channel, develop and implement effective attribution process for all Line of Business for their respective Channel.

Responsible for gathering, synthesizing and documenting detailed business and technical requirements.

Created various transformation procedures by using SAS 9.1.3, SAS Cube Studio, SAS Data Integration Studio, and SAS Enterprise guide.

Developed new or modified SAS programs and used SQL Pass through facility and Libname methods to extract data from the Teradata DB and created study specific SAS datasets, which are used as source datasets for report generating programs. Extensively used various statistical Procedures like PROC FREQ, PROC MEANS to understand data quality, produce reports and handle the missing values.

Created SAS Datasets with the usage of SAS MACRO, Macro Variables, CALL SYMPUT Worked closely with our Informatica ETL Team to design and build dimensional data models (star schema) and OLAP cubes (Schema - Dimensions, Aggregates, Facts, Level Tables and Hierarchies).

Review/analyze excel, pdf, ppt, SAS datasets and reconcile / compare to reports generated by other lines of businesses and then provide SAS code (using Base SAS, Proc SQL, Macros, ODS, functions) to generate a new report based upon the reconciliation fixes.

Developed necessary SAS cubes for data integration, data calculation, and for OLAP.

Integrated all SAS BI components, SAS graphs, and programs onto one web application software for end users by using SAS DI, SAS information map studio, SAS Web report studio, and SAS Information Delivery Portal.

Generated queries/reports and other activities like OLAP through the SAS OLAP Cube Studio, Forecasting and Analysis as requested Participated in determining the criteria for Business Marketing Campaigns and developed SAS codes to meet those criteria.

Worked with large customer response and sales data sets and presented results to the users. Simultaneously tested the integrity of the mails and addresses in the database.

Designed standardized and ad-hoc processes for new product development, on-line marketing, direct mail, reward-based marketing, etc.

Have experience creating information maps which would be utilized by web report studio to generate static reports.

Designed and developed code with SAS/EG to support ad-hoc requests.

Automated the standard reporting with SAS BI and Microsoft Add-in.

Developed queries on the existing Oracle and SQL server databases to provide ad-hoc reports using SAS/SQL for marketing department use. Coordinated analyses involving customer information, campaign response data, and demographics.

Environment: SAS 9.1.3,SAS/MACROS, SAS/SQL, SAS/GRAPH, SAS/ODS, Excel, Access, UNIX, Windows, Winscp, Oracle, Teradata, SQL Server, SAS Enterprise Guide 4.0, SAS Add-In to MS Office, SAS Information Map Studio 3.1, SAS Stored Process, SAS DI Studio and SAS Web Report Studio.

ING Bank, Bangalore Mar 2007-Apr 2008

Role: SAS Programmer

This project involved implementing consumer lending module for marketing & performance information department of Standard Charted Bank. Marketing department creates a mailing list of consumers for Direct Mailing and Telemarketing offers, and measures the performance of those campaigns.

Responsibilities:

• Extensively used SAS Data Step functions and descriptive statistical Procedures to process large amounts of customer response and sales data

• Used PROC SQL LIBNAME and PROC SQL Pass-through methods to access data on Oracle database

• Cash flow modeling with Fixed Income Securities

• Created customer mailing lists for Direct Mailing and Telemarketing using PROC Forms

• Extensively used PROC Import and PROC Export procedures for importing and exporting PC files and Microsoft office files such as Excel Spreadsheet, Access Tables

• Basel II compliance for generating regulatory risk estimates

• Experience in SAS AML, customer risk scoring and suspicious activity monitoring

• Maintained and enhanced existing SAS Reporting programs using PROC Tabulate, PROC Report, PROC Print, ODS RTF, and ODS PDF for marketing campaigns

• Used SAS enterprise Guide to run statistical tests like ANOVA, Chi-square etc.

• Created Ad hoc reports for marketing managers using SAS Enterprise Guide and also helped in development of reporting application in VB.

Environment: Base SAS, SAS Macros, SAS/Access, SAS SQL, SAS Enterprise Guide, Windows, Oracle.

Contact this candidate