SUMMARY

• Over 9+ years of SAS Administration experience in various domains with project teams, interfacing with clients and business users and implementing technology to build successful solutions using SAS technologies in functional areas like financial, banking industries.
• 9+ years of experience in SAS Administration. Installation and configuration of SAS on single as well as multiple server environments. SAS Tools such as SAS Management Console, SAS DI Studio, SAS Enterprise Guide, SAS Information Map Studio, Enterprise Miner, SAS Information Delivery Portal, Web Report Studio.
• Provided help - desk support, production support, Tech support, administration.
• Extensive Upgrade Experience from SAS 9.4 M2 to M3 and M4.
• Troubleshot SAS Applications issues in user environment and provided technical solutions to business user needs.
• Did software upgrades, patches, maintenance- performance monitoring and tuning of SAS environments.
• Extensive hands on experience on SAS BI on SAS 8, SAS 9.1.3, SAS 9.2,SAS Web Report Studio, SAS 9.3 /SAS 9.4 Grid Administration including SAS connect, SAS internet server, SAS OLAP server, SAS Metadata server, SAS Object Spawner, SAS Management console
• Excellent installation, configuration experience of SAS9.3/SAS 9.4 in UNIX / Linux environment.
• Good experience in deploying SAS EBI software.
• Good experience in performing and tuning applications/ App servers.
• Experience in maintaining a large multi-platform SAS environment it includes SAS Business intelligence tools and SAS application tier.
• Worked with multi-platform across multiple environments.
• Experience in killing jobs, cleaning up dead processes.
• Good experience in Active directory Authentication and PAM.
• Administered the SAS start-up and stop scripts and the status of the server services.
• Hands on experience working on SAS/Base, SAS/Stat, SAS/SQL, SAS/ODS, SAS/Macros, SAS/Graph, SAS/Access
• Extensive expertise in analyzing data and generating reports, summary tables, listings and graphs
• Experience working with databases ORACLE, DB2, Teradata, and MS Access and applications using these databases in SAS V9
• Experience on programming languages in UNIX SHELL.
• Excellent knowledge and work experience data manipulation, data cleaning, sorting, concatenating, stacking, interleaving, merging and combining SAS datasets using SAS/Base, SAS/ETL, SAS/Enterprise Guide and SQL
• Skilled in writing to automate SAS related tasks and conversion of SAS Datasets to various file types (including HTML, Word, PDF, Excel, ASCII, and flat files) as well as converting various file types to SAS Datasets
• Experience in importing/exporting data between library files and flat files using SAS Data and Proc steps
• Expertise using SAS/MACROS and proc’s to access, extract, modify, merge, and analyze customer data and to generate statistical analysis reports
• Expertise in generating Graphs using SAS procedures Proc Gplot, and Proc Gchart
• Experience in Analysis, Design, Development, Testing and Implementation in all phases of SDLC
• Highly motivated with excellent organizational and interpersonal skills
• Possess strong ability to quickly adapt to new applications and platforms
• Good team member with string analytical and communication skills

TECHNICAL SKILLS

Statistical Software: SAS 9.X (Base SAS, SAS/STAT, SAS/SQL, SAS/MACROS, SAS/GRAPH, SAS/ACCESS, SAS/ODS), SAS/Management Console,SAS/Web Report Studio, Enterprise Guide

Software Packages: Microsoft Office (Excel, MS Word, Visio, PowerPoint), Adobe Reader

Databases: Oracle 9i/10g, MS Access

Operating Systems: Windows 95/98/NT/2000/XP/7, UNIX Shell Scripting

PROFESSIONAL EXPERIENCE

Confidential, PA

SAS Administrator

Responsibilities:

• SAS 9.4 Grid Administration & SAS Grid Computing Architecture responsibilities, client server and multi-platform across multiple environments.
• Good experience in upgrading SAS 9.4 M2 to M3 and M4.
• Involved in setting up SAS Access to MS SQL and create server definitions, libraries and authorization in SAS Management console.
• Created Oracle and MS SQL Server definitions and created library definitions in SAS Management console for different business units.
• Daily backup of Metadata server and manage the servers for space and other disk related issues
• Worked with Analytics Technologies like Angoss Knowledge seeker and Bayesia Lab.
• Good Understanding of SAS Web tier, SAS Server Tier Architecture with excellent Troubleshooting skills.
• Experience in working with Relational Database Management Systems like Oracle, Teradata and SQL Server.
• Worked on Jira Tickets on SAS and troubleshooting the issues.
• Support Meta/Compute/Mid-Tier Grid Environment Servers.
• Managed and Implemented both VM (includes Farm & Stand-alone) and non-VM based solution
• Worked with SAS OLAP Server, SAS Metadata Server, SAS Object Spawner, SAS Information Delivery Portal, SAS Management Console, Enterprise Guide, OLAP Studio
• Worked with Data Integration Studio, Web Report Studio,SAS Performance Forecast Server, SAS Connect Server, SAS Web Infrastructure Platform, SAS Enterprise Miner
• Worked with Configuration management process architecture using GITHUB
• Worked on Vulnerability Patches of Linux SAS Servers on every Quarter.
• Renew the SAS Licenses on SAS Linux Servers.
• Adding users on SAS Servers and Management Console.
• Worked Extensively on SAS Grid Environment Manager.
• Defining new libraries and assigning security permissions using SAS Management Console
• Monitoring SAS Application Servers (SAS EBI, Enterprise miner), Performed daily administrator duties such as backups, version control, troubleshooting and developing shell script to check system resources & send an email notification
• Implemented the production changes such as applying the patches, upgrading the SAS products, installing new SAS products on the server and license renewals by following Change Management Process
• Support SAS Users create New UNIX File mount systems.
• Prepared key project documents with technical specifications
• Working with Unix System Administration team to enhance the existing system configuration to meet current and future needs

Technologies: SAS 9.4,SAS Management Console, SAS Enterprise Guide 7.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, Teradata, Oracle 11g, SQL, JavaScript, SAS Enterprise Miner 5.3, SAS Forecast Studio, SAS Data Integration Studio, ObjectSpawner, Connect Server, APServer, OLAPServer, SAS Remote Services, SAS Studio,SAS Grid manager 9.4, Platform LSF,Platform

Confidential, NC

SAS Administrator

Responsibilities:

• Install, setup, configure and maintain SAS sever on Unix/Linux Environment.
• Configuring SAS to authenticate to alternative authentication methods such as LDAP, Active Directory or PAM
• Responsible for solving Tickets, fixing issues.
• Supported Onsite and Offshore developing Team
• Responsible for Backup and Recovery
• Adding and removing user’s, created and assigns roles in SAS Management Console
• Monitor the Metadata server environment and worked with end user’s.
• Updated the files on Grid environment
• Monitored the LSF on Grid environment
• Provided Customer support, production support
• Applied hotfixes, patches
• Scheduled jobs for SAS User’s, installed SAS Server and client components whenever needed.
• Connect SAS systems to other systems such as SQL, Teradata, oracle and DB2.
• Installing, configuring, and using the SAS/SECURE encryption methods.
• Provided on call support for production problem resolution.
• Create documentation for end users and internal (Other SAS Admins).
• Watch through all the remedy tickets and troubleshoot user incidents.
• Proc metalib options to permissions that affect data access through the Metadata Engine and write proc sql code through update metadata SAS Datasets.
• Responsible for daily server reboots.
• Upgraded SAS from one version to another.
• SAS 9.4 Visual Analytics - monitoring user dashboard reports, register SAS datasets through SAS 9.4 SMC and loading, unloading SAS datasets through Visual Analytics portal
• SAS Access to Hadoop Configuration setup and Hadoop Kerberos setup
• Deploy the Hadoop drivers on SAS Servers and setup environment variables
• Validating kinit, beeline & klist test connections on SAS Server
• Guide SAS Users how to access SAS Hadoop library connections on SAS Server

Technologies: SAS Management Console 9.1&9.2&9.3&9.4, SAS Enterprise Guide 4.0 & 4.3,5.1,7.1, SAS Stored Processes Web Application, SAS Web Report Studio, SAS Information Map Studio 3.1 & 4.2, SAS Information Delivery Portal, SAS OLAP CUBE Studio 9.1 & 9.2, SAS Web OLAP Viewer For Java, SAS Enterprise BI Server, Teradata, Oracle 10g, SQL, HTML, XML, JavaScript, SAS Enterprise Miner 5.3, Studio, Linux RHEL 4 Enterprise Edition, SAS Data Integration Studio 3.4 & 4.2, Metadata Server, ObjectSpawner, Connect Server, APServer, OLAPServer, SAS Remote Services, SAS Xythos, SAS Grid manager, SAS 9.4 Visual Analytics,SAS 9.4 Grid Administration, Hadoop

Confidential, NH

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 Teradata
• Experience with metadata-bound libraries
• Monitor all the tiers - Metadata, Compute & Web on unix.
• Deploying web applications in Web Sphere
• Promotion of Metadata such as libraries, metadata folders, information maps, campaigns, etc from one environment to another
• Played key role in data analysis and statistical reporting for Confidential claims
• 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

Technologies: SAS 9.3 /SAS 9.4 Software, SAS/Management Console, Enterprise Guide4.2/7.1, OLAP Cubes, Oracle, SAS/SECURE

Confidential, NC

SAS Administrator

Responsibilities:

• Extracting different reports related to Sales, Budget, cost and stocks
• Extracted data from various sources like Flat Files (.xls, csv etc), Oracle into SAS
• Extensive experience with concatenating, interleaving and merging SAS datasets
• Used SAS macros to produce a flexible SAS code
• Created complex and reusable Macros and extensively used existing macros and developed SAS Programs for Data Cleaning, Validation, Analysis and Report generation.
• Tested and debugged existing macros
• Extensively used PROC SQL to get the data from the databases
• Conducted analysis and generated tables, listings and graphs using SAS
• Extracted data from Databases using SQL within SAS to be analyzed and exported to Excel and CSV for further analysis
• Install, setup, configure and maintain sever on UNIX Environment.
• Responsible for solving Tickets, fixing issues.
• Supported Onsite and Offshore developing Team.
• Responsible for Backup and Recovery.
• Adding and removing user’s, created and assigns roles in SAS Management Console.
• Monitor the Metadata server environment and worked with end user’s.
• Worked on LSF schedulers
• Monitored the Grid environment
• Provided Customer support, production support
• Applied hotfixes, patches.
• Scheduled jobs for SAS User’s, installed SAS Server and client components whenever needed.
• Connect SAS systems to other systems such as SQL, Teradata, oracle and DB2.
• Provided on call support for production problem resolution.
• Create documentation for end users and internal (Other SAS Admins).
• Watch through all the remedy tickets and troubleshoot user incidents.
• Responsible for daily server reboots.
• Upgraded SAS from one version to another.
• Worked closely with statisticians and Data managers in analyzing the data and implementing statistical methodologies using proc freq and proc means
• Provided programming support to produce analysis, reports, and graphs on on-going studies, reviewing program codes, and suggesting alternative efficient solutions
• Supported testing of the product in CIT, SIT, UAT & PRE-PROD testing environments and efficiently resolve build, runtime & interface issues that arise across different testing environments.
• Coordinated & supervised the development activity of offshore. Review Plan documents and Test Results for each requirement.
• Experience programmatically querying and modifying SAS metadata with DATA STEP or procedures such as PROC METALIB
• Created functional specification, Test Cases and Design Documents.
• Participated in code review and performance tuning of the program and assisted the team in improvising the performance
• Adhoc report programs are developed to let the users select the specified boundaries to create a report
• Produced safety and efficacy reports in RTF and HTML formats
• Used CVS as a Version Control/Defect Tracking tools
• Ability to work on multiple projects simultaneously and meets the deadlines as and when required

Technologies: SAS/BASE, SAS/STAT, SAS/SQL, SAS/MACRO, SAS/GRAPH, SAS/ACCESS, SAS/ODS, SAS/GRID, Oracle, SASEnterprise Guide

Confidential, PA

SAS Administrator

Responsibilities:

• Managed day-to-day operational aspects of the project and scope. Provide information to business clients regarding technology directions and translate technology opportunities into integration solutions.
• Perform day-to-day support activities & work in the SAS Support team. Transition the same knowledge to the team for full support.
• Installation of client applications and Troubleshooting technical problems
• Tracking applicable SAS hot fixes and creating implementation plans for respective SAS modules and applications.
• Monitoring the SAS environment like SAS server resource and reporting usage.
• Installation of SAS software on client desktops.
• Archiving and backup planning.
• License management.
• Creating new repository, register repository, unregister repository and deleting.
• Scheduling production jobs Scheduling for the Business so that the Business can access the critical data on scheduled time thus reducing manual intervention
• Installing and configuring management console for security management for various users.
• Implementation of System Monitoring application that specifies number of processes, CPU & memory utilization per user etc. in order to find out peak time for the server, high traffic time, most frequent users & the users having high system usage
• Supporting global SAS environment by coordinating with multiple teams system engineers, n/w team and Business User
• Identify best practices for configuring applications and work with the development teams to implement the standards.
• Coordinate with other IT groups on performance, storage issues, etc.
• Coordinate with SAS Users to schedule production loads/jobs
• Communicate and collaborate effectively with staff of varying technical expertise.
• Provide outstanding customer support with a high degree of customer satisfaction, technical expertise, and a thorough and timely response.
• Performance tuning of both Server and Workstations
• Providing excellent analysis, problem determination and troubleshooting skills.
• Excellent oral and written communication skills with ability to interact at all levels of the organization on a regular basis.
• Working with offshore team members for efficient SAS Support.

Environment: Base SAS,SAS 9.1.3, SAS Macros, Oracle 10g, SQL,HTML,JavaScript, Teradata, SAS Enterprise Guide 4.0, SAS Stored Processes Web Application, SAS Web Report Studio, SAS Information Map Studio 3.1, SAS Information Delivery Portal, SAS OLAP CUBE Studio 9.1, SAS Web OLAP Viewer For Java, SAS Enterprise BI Server, Tomcat/ Apache, IBM/TSO/ISPF JCL,SAS/AF,SAS/SCL,SAS/ODS,SAS DI Studio, COBOL,DB2