Manager Management
Resume:
Pratusha SAS Administrator
Chandan
*******@*********.***
Profile summary:
6+ years of experience working as SAS Admin (Aix, Windows, Redhat, Ubuntu server)
Experience in migrating SAS Servers from 9.1.3 to 9.3 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 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.
Experience in SAS Grid 9.3 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 Grids.
Extensive experience in installing, configuring and testing SAS/Access Interface to Oracle, MS-SQL Server
& Teradata on SAS Enterprise Platform.
Experience in applying new license for SPDS, SAS Platform RTM and SAS Meta/compute servers.
Monitored Stored Process Server, Work Space Server and Scalable Performance Data Server (SPD Server) where Parallelization of Many SAS I/O functions Occurs to Improve the Overall Performance and Security and few times Reviewed logs for Resolve any issues encountered or to Estimate the Performance
Excellent administration experience in SAS Data Integration Studio, OLAP Cubes.
Extensive expertise in analyzing data and generating reports, summary tables, listings and graphs
Experience working with databases using SAS/ACCESS for ORACLE
Good team member with strong analytical and communication skills
Technical Skills:
SAS
Base SAS 9.4/9.2/9.1.3, SAS/STAT, SAS Macros, SAS/SQL, SAS ODS, SAS GRAPH, SAS Data Integration Studio, SAS BI Dashboard, SAS OLAP Cube Studio, SAS Information Delivery Portal, SAS Management Console, SAS Web OLAP Viewer for Java, SAS Enterprise Guide, SAS Stored Process, SAS Information Map Studio, SAS Stored Process Web Application, SAS Web Report Studio, SAS Add-In for MS Office
SAS Procedures
SORT, CONTENTS, TRANSPOSE, GPLOT, GCHART, FREQ, MEANS, SQL, REPORT, TABULATE,
PRINT, SUMMARY
Databases
ORACLE, SQL Server
Operating System
Unix-Linux, Win2008 Server, DOS, IBM-AIX, RHEL
Tools
SAS Migration Utility, SAS Disk Cleanup, SAS Renewal Utility, SASHFADD Tool. Autosys job scheduler, Crontab, SAS Platform RTM monitoring, Logical volume manager (LVM), nmon monitoring, Cygwin.
Education:- Bachelor of Science in Pharmacy 2010 GPA:3.5
Professional Summary:
Client: Wells Fargo, NC January2016-Till date.
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, Stored Process Server on the windows 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.
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 configured SAS Access to Oracle, SQL and Greenplum database.
Supported production jobs and coordinated with UNIX system administrators to ensure the jobs are running successfully.
Escalated the issues and worked closely with SAS Support in resolving issues related to users and environment.
Migrated SAS Metadata users from SAS 9.1.3 to SAS 9.3 and created new groups and ACL.
Coordinated efficiently with Business Analysts, Application Architects, and Infrastructure teams in handling setup and maintaining SAS servers.
Environment: SAS Management Console 9.3, SAS Stored Process, SAS Web Report Studio, SAS Deployment Manager 9.4, SAS Enterprise Guide 5.1 & 7.1, SAS Stored Process Web Application.
Client: Health Stearm, TN August 2014- December 2015
SAS Administrator
Responsibilities:
Good in applying Hot Fix Installations, User Issues, & any other Maintenance issues
Involved in System Recover plan(SRP) and DR procedures
Hands on Skills on Management Console – Important are - Server Manager, User Manager, Authorization Manager, Data Library Manager
Setting up DB Connections from Management Console to Teradata
Monitor all the tiers – Metadata, Compute & Web on AIX/Linux.
Deploying web applications in Web SpherePromotion of Metadata Objects such as libraries, metadata folders, information maps, etc from one environment to another.
Played key role in data analysis and statistical reporting for TIAA-CREF claims
Actively participated in the complete SDLC Life Cycle of development, from the requirement phase to testing phase
Verifying the grid configuration files (lsf.conf,lsb hosts etc)
Troubleshooting SAS logs w.r.t Grid
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
Environment: SAS 9.3 Software, SAS/Management Console,SAS Enterprise Guide4.2,SAS OLAP Cubes, Oracle, Windows, Microsoft Office (Excel, MS Access, MS Word, Visio), Adobe Reader
Client: Landis+Gyr, GA October 2013 – August 2014
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
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 TIAA-CREF claims
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.2/3 environments including SAS Metadata Server on unix.
Environment: SAS Management console, Enterprise Guide4.2, SAS OLAP Cubes,,SAS Visual Analytics,SAS Information Map studio, SAS Webreport studio,SAS ACCESS to Teradata.
Client: Aurobindo Pharma, India August 2011 –September2013
SAS Administrator
Responsibilities:
Implemented, 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 Management Console 9.1.3, SAS Enterprise Guide 4.0, SAS Stored Processes, SAS Web Report Studio, SAS OLAP CUBE Studio 9.1, SAS Enterprise BI Server, Tomcat/ Apache, SAS DI Studio
Client: DR. Reddy’s, India July 2010–August 2011
SAS Administrator
Responsibilities:
Install, setup, configure SAS9.2 on AIX6.1 Environment.
Responsible for Hotfix, Renewal of Server Licenses, patch updates.
Responsible for Metadata Backup and Recovery
Created an ACL at Group level, User level and Table level in SAS Management Console 9.3
Adding and removing user’s, created and assigns roles in SAS Management Console
Managed SAS Connect server, Metadata Server, Object Spawner, OLAP server, Stored Process Server on the AIX 6.1 environment.
Monitoring the Metadata Server, Compute Server & Web Tiers.
Scheduled jobs for SAS User’s through control M and Crontab.
Provided on call support for production problem resolution.
Create documentation for users and SAS Teams.
Monitoring Grid Environment.
Implementing SAS Best practices in the SAS Environment.
Checking the sas metadata logs including enabling trace and setting different levels on debugging.
Fine tuning the SAS Applications so that Jobs run with in the SLA time.
Watch through all the remedy tickets and troubleshoot user incidents.
Promotion of SAS9.2 to 9.4
Configuring SAS Environment Manager and Implementing HTTPS for Web/Web AppServers.
Enviroment: SAS/Management Console, Enterprise Guide4.2, SAS OLAP Cubes,, SAS Information Map, SAS Web Report Studio, SAS Hotfixes
Contact this candidate