SUMMARY:

• Around 8 years of experience in SAS Platform Grid Administration, development and architecture statistical analysis in various domains by using SAS Software
• Hands on experience in performing client installations and configuration of various SAS products like SAS Enterprise Guide 7.1, SAS Enterprise Miner, SAS Add - in for Microsoft office and SAS Model Manager, SAS Enterprise Business Intelligence, SAS Visual Analytics 7.1 on shared environment and individual architecture on windows and Unix/Linux operating system.
• Performed Installation and Configuration SAS 9.2, SAS 9.3 and SAS 9.4TS1M4 on Shared grid environment installed.
• Experience in administering SAS Grid environment, SAS Management Console and SAS LSF, SAS applications, SAS environment manager, Platform RTM, SAS Deployment Manager.
• Installed and configured Platform process manager and LSF8.01, LSF9.1.2, and LSF9.1.3 (load sharing facility).
• Managing queues and hosts. Start, stop and checking status of the servers used by scripts. Wrote SQL Queries to debug duplicate values and missing values.
• Tracking and installing hotfixes for different SAS components and experience with SAS deployment manager.
• Experienced working on PAM Authentication, LDAP authentication on UNIX/Linux platform and AD authentication on Windows platform. Single sign on for authorized users.
• Backup metadata with metadata wizard and tested restore SAS content and monitor backups periodically.
• Understanding Data management principles such as joining Data sets, Data aggregation, Subletting using PROC SQL. Extracted the data using from Oracle to DB2.
• Installed different database clients such as Oracle 11g,12c, MYSQL, DB2, and Postgres SQL by ODBC driver manager and JDBC driver manager.
• Experience in development of documentation like FRD technical specification from process and program flow.
• Monitoring and Managing SAS Servers and Spawners such as metadata server, Object Spawner, OLAP server, SAS workspace server, SAS pooled workspace server, Connect Spawner, Stored Process server, SAS web infrastructure platform data server.
• Renewed licenses for SAS servers and components and third party products on Linux/Unix/windows platform. Set system limits for users to avoid system crashes.
• Good understanding of the SAS Web(middle) tier and SAS Server Tier Architecture with excellent troubleshooting skills. Have Health Care Domain Knowledge.
• Created Software Development Life Cycle (SDLC) document and excelled in the process of Change Management, Release management and Configuration processes.
• Installing, configuring and setting up connectivity to Hadoop by using SAS/Access.
• Experienced working with SAS Enterprise Business Intelligence like information map studio, web report studio, information delivery portal.
• Effective communication skills verbal and written with customers and other professionals.

TECHNICAL SKILLS:

SAS Servers: Metadata server, object spawner, work space server, pooled work space server, SAS OLAP server, SAS stored process server, SAS Web server, SAS Web application server, SAS SPD server, SAS Deployment testerSAS Client Tools: SAS Add-in for MS Office, SAS DATA integration studio, SAS enterprise guide, SAS enterprise miner, SAS work flow studio, SAS OLAP cube studio, SAS Management Console.

SAS Web Tools: SAS Web report studio, SAS business intelligence dash board, SAS visual analytics, SAS studio, SAS Environment Manager.

SAS software Tools: PC SAS, Base SAS, SAS/MACROS, SAS/STAT, SAS/ODS, SAS/SQL, SAS/ACCESS.

Database: Teradata, Oracle, DB2, MS-SQL Server, MS Access, Hadoop, Greenplum

Operating Systems: IBM AIX 7.2, RHE Linux (6.3-7.2), VMS, MS Windows seven and server.

Office and other Suites: Microsoft office-Excel, Access, word, PowerPoint, Microsoft Visio, Micro strategy, GPFS, VERITAS, LSF, RTM, python, PuTTY, MobaXterm, Xming, Minitab 17.

PROFESSIONAL EXPERIENCE:

Confidential, Bellaire, TX,CA

SAS Administrator

Responsibilities:

• Administering SAS 9.4TS1M4 four tier grid environment on Linux Platform.
• Performed Installation and configuration SAS9.4TS1M4. Performed User Migration and Data migration (datasets and tables) from SAS 9.3TS1M2 to SAS 9.4TS1M4 servers and assisting users to fetch migrated data in the grid.
• Performed SAS product installations such as SAS enterprise guide 7.13, SAS OLAP cube Studio with SAS Deployment Manager on user’s machines and assisting users in connecting to the SAS Grid servers from the required SAS product for their activities.
• Testing all servers by using deployment tester after installation and configuration SAS servers. Performed depot subset for client side tools using SAS 9.4 Depot Sub Setting Utility.
• Working closely with the users and resolve tickets as per the Service Level Agreements. Hands on experience in SAS Enterprise Business Intelligence Administration with a strong background in Linux Systems Administration with on-call production support.
• Took responsibility for most complex, multi-site, multi domain SAS activities and integration.
• Creating and removing the users, user groups, and roles on the SAS Metadata and accessing the libraries by using SAS Management Console. Creating and managing libraries on metadata server by using LIBNAME statement. Controlling all SAS servers and grid nodes by using SMC, platform RTM, SAS grid manager, scripting.
• Providing SAS engineering support and oversight on design, engineering and development of SAS information technology solutions .
• Good understanding of MPP databases such as Teradata, greenplum and Oracle. Worked close with admin teams in monitoring Hadoop cluster.
• Coordinating with the security team very often and providing servers for the MS patches and rebooting for the, scheduled time. worked on SPDS implementation/support side lambda.
• Configured SAS access to Hadoop from SAS grid environment to Horton works HDP platform.
• Regular Monitoring of SAS Servers to ensure the performance. Extracted metadata reports by using SAS Enterprise guide, SAS code.
• Excelled in Change Management procedures, problem management procedures and version control for SAS code. worked on Data analyzing Platform
• SAS data sources connected to the SQL, Oracle, Hadoop, Teradata and DB2.
• Interacting with different Support teams like Linux Administration, Database Administration, Production Job Scheduling Team, Middle tier Team and others to meet SAS Developer’s access and connectivity requirements.
• Set limit for CPU utilizations to users, assigned and configured the system parameters to cluster nodes to avoid server crashing.
• Adding/removing queues and hosts in LSF cluster and set user limits to submitting the job. Worked on Data Warehousing for developing dash boards for BA.
• Attending sessions along with users organized by SAS Experts about various SAS Products and clearing up the user’s queries regarding SAS Grid.

Confidential,Bentonville, AR

SAS Administrator

Responsibilities:

• Performed Installation and configuration of SAS9.4 TS1M3 locally on individual nodes.
• SAS server components installed and configured on different machines as per the costume planning. Performed Data migration from SAS 9.3 to SAS 9.4TS1M3 by migration tools.
• Registered and unregistered libraries and datasets by using LIBNAME statement in SAS enterprise guide or Base SAS. Assigned different roles to users and groups. Accessioned permissions to users and groups depend authorization. Created and secured metadata folder structures.
• Tracked and downloaded Apply Hotfixes, patches service packs, tracked expiration date and renewed licenses of SAS applications and LSF.
• Worked with Distributed in process scheduling server to schedule jobs to web application server.
• Managed SAS Management Console plugins. Monitored and controlled SAS server tier and compute tier and middle tier servers on the GUI environment and command prompt.
• Used SAS base and SAS macros to created and tested the programs. Created and maintained SAS Datasets extracted from Database. Produced analysis datasets for generating Reports.
• Performed installation and configuration of LSF9.1.2 on RHEL platform. Managing and monitoring cluster by Platform RTM 2.08.
• Working closely with the users and resolve tickets as per the Service Level Agreements. Supported users on various enterprise clients
• Monitored space usage of SAS servers and sent out reports. And controlled workspace server and killed top ten jobs when workspace server was too busy.
• Configured Single sign on to authorized users for signing multiple SAS applications with one time sign in.
• Report building using SAS web report studio, build portal, SAS BI dashboard.
• Created Tables, Listings, Graphs and customized reports using various procedures PROC Report, PROC Tabulate, Data null and PROCGPLOT.
• Involved in creation of CRT datasets transport files and associating documentation as a part of FDA submissions.
• Documented various procedures for smooth functioning and troubles avoided for physical architecture, migration process code development. Root Cause Analysis helped.
• Produced quality customized and ad hoc reports by using PROC TABULATE, REPORT and SUMMARY and provided descriptive statistics using PROC MEANS, FREQ.
• Documented data sets using specifications worked out in conjunction with senior manager.

Confidential,Rahway, NJ

SAS administrator

Responsibilities:

• Performed installation and configuration of version SAS 9.3. Administered various SAS servers and applications, user definition, group definitions, grid nodes by using SAS Grid Manger, SAS management console, wrote scripts. Managed the SAS management console, repositories, libraries, folders.
• Performed user data migration on cross platform by using SAS migration tools like PROC MIGRATE, PROC CPORT, PROC CIMPORT.
• Tracking and installing hotfixes for different SAS components and experience with SAS deployment manager.
• Managed ques and hosts using LSF commands, setup job limits to ensure better end user experience.
• Extensively used SET, MERGE, UPDATE statements and PROC SQL for adding new variables or observations, creating subsets or modifying datasets.
• Experience in interacting with SAS Technical support and opening tickets about issues when required.
• Experience with UNIX shell scripts to set the performance limit to cluster.
• Installed different Oracle clients 11g and add Oracle database servers to SAS servers from SAS Management Console.
• Monitor the backups regularly and tested restore SAS content the from backup file.
• Worked with Statisticians in analyzing the data, generated reports, tables, listings and graphs using SAS based on Standard Operating Procedures (SOPs) and departmental guideline.
• Involved in designing the project and process flow diagrams using SAS Enterprise Guide.
• Creating directory for every individual user in a file system to store their datasets and directing them to the path in the assigned server. worked on Ad Hoc programming.
• Hands on experience in scheduling software version upgrade task on client servers and license renewing.
• Responsible for monitoring CPU usage, Disk usage, and system resources .

Confidential,Memphis, TN

SAS Administrator

Responsibilities:

• Performed installation and configuration SAS 9.3 and performed metadata migration from SAS 9.2 to SAS 9.3.
• Kept up-to-date with SAS hotfixes, patches, announcements. Familiar with SASHFADD. Updated licenses to SAS and third party components used in the SAS platform.
• Worked on Medical claims data. Managed monthly eligibility, membership and claims processes. Loaded and synthesized healthcare data from multiple sources with varied frequencies.
• Responsible for running production SAS programs/scripts and creating reports periodically for the respective users, groups. Start, stop and checking status of the servers used scripts and RTM.
• Created ad-hoc reports based on the business needs. Helped to development teams in troubleshooting SAS programs.
• Extracted data from the database by SQL PASS THROUGH FACILITY and LIBNAME facility.
• Created reports in PDF, Excel and HTML formats using ODS statements.
• Developed macros defining the macro parameters using different debugging options like MPRINT, MLOGIC, and SYMBOLGEN.
• Performed installation and configuration of LSF 9.1.1. Query the status of grid queues, hosts, and jobs from the command line as well as in Platform RTM 2.06.
• Monitored disk space for SASWORK and for permanent SAS libraries and the performance of jobs and queries running on the system.
• Used SAS base and SAS macros to created and tested the programs. Created SAS metadata boundaries.
• Installed DB2 database client. And add DB2 server to SAS sever by JDBC driver manager.
• Created and deleted libraries to metadata server on foundation repository. And created costume repositories for the security purpose. Used GPFS shared file system.

Confidential

SAS Administrator

Responsibilities:

• Developed SAS code to perform ETL (Extraction, transformation and loading) of data to create SAS database.
• Closely involved in installation and configuration of version SAS 9.2
• Ensured to checking the status and start, stop, or restart all SAS Servers.
• Generated summary reports and frequency tables using base SAS procedures
• Enhanced reports using labels, SAS formats, user-defined formats, titles.
• Implemented system level security for users and data.
• Troubleshoot the SAS server issues access file system overload issues.
• Successfully identified problems with the data, produced derived data sets, tables, listings and figures, which analyzed the data to facilitate correction.
• Updated licenses to SAS and third party components used in the SAS platform.
• Created complex and reusable Macros. Extensively used existing macros and developed SAS.
• Updated Internal user passwords and stop, pause, resume, and reset (or refresh) the metadata server.
• Used LIBNAME and SQL PASSTHRU FACILITY to import data from Oracle database into SAS files.
• Reviewed the Business Requirement Documents and the Functional Specification.
• Extracting data from the database using SAS/Access, SAS/SQL procedures and to create SAS data sets for statistical analysis, validation and documentation.
• Performed data analysis, created reports with extensive use of BASE SAS, Macro and SAS reports with the help of default procedures.
• Generated Graphical analysis using SAS Report and SAS /GRAPH.
• Analyzed existing SAS scripts based on various platforms such as UNIX/Linux and Windows
• Prepared daily, monthly, and ad hoc reports (by PowerPoint, Excel, pivot tables, and pivot charts, etc.), and present findings and recommendations to all levels of senior management.
• Automated SAS jobs running on a daily, weekly and monthly basis using SAS/BI and Unix Shell Scripting