Sr. Sas Administrator Resume
FloridA
PROFESSIONAL SUMMARY:
- 9 years of experience as a SAS Administrator in SAS 9.4, SAS 9.3 and SAS 9.2 on UNIX/Linux operating systems including the following products SAS Grid, SAS Connect, SAS Access interface to Oracle/SQL Server, SAS Access interface to Teradata, SAS Metadata Server, SAS Management Console, Base SAS end user support, Enterprise guide 5.1, 6.1, 7.1, SAS Customer Intelligence Studio 5.4 and 6.4, SAS Environment Manager in healthcare, banking and retail domains.
- Designing, implementing, and maintaining security on SAS Metadata and Linux for users.
- Configured the SAS Environment Manager dashboards, enabled extended monitoring and report center.
- Administering SAS platform in a multi - node GRID environment.
- Installation of client applications and Troubleshooting technical problems.
- Tracking applicable SAS hot fixes and creating implementation plans for respective SAS modules and applications
- Monitoring SAS Server resources and reporting usage.
- Identifying performance and recommending/implementing tuning of active SAS environment(s) providing projected capacity shortfalls.
- Designing, implementing, and executing the change control and promotions tasks in SAS
- Very good knowledge on administering SAS Grid environments, Job parallelization, LSF and platform RTM.
- Provide guidance and assistance to SAS Developers on operational and technical issues; interfacing with the SAS Institute for Support on administrative and system issues
- Good experience in troubleshooting and fixing the issues related to sas workspace and stored process servers, object spawner and mid/web tier.
- Implemented performance tuning techniques for sas stored process and pooled workspace servers.
- Creating and implementing upgrade plans.
- Occasional after hour support when system OS and hardware maintenance and applying SAS hot fixes and upgrades occur.
- Monitor and log SAS servers and optimize memory usage or tune servers for optimal performance.
- Focus on areas of capability, interoperability, scalability and enterprise class issues (i.e. like failover).
- Act as a liaison to SAS Technical Support for SAS users at the clients site.
- Reviewed, validated, documented and mentored SAS Admin and team regarding SAS environment.
- Worked as single point of contact for all SAS related issues.
TECHNICAL SKILLS:
Primary Skills: SAS Server & Metadata Administration, Installation, configuration, SAS Server Backups, Restore, User/Space Management, Resources Management, Technical Support and User trainings, BI Reporting.
SAS Tools: SAS Foundation 9.2, 9.3, 9.4, SAS DI Studio, SAS Web Report Studio, SAS BI Dashboard, SAS Enterprise Guide, SAS EMiner, SAS OLAP Cube Studio, Information Map Studio, SAS Information Delivery Portal, SAS Customer Intelligence Studio, SAS Stored Process Web Application, SPDS.
Programming Languages: Base SAS, C, Java
Administration/Scheduling Tools: SAS Management Console, LSF Scheduler, SAS Environment Manager, SAS Grid Manager, Platform RTM
Application Servers: Jboss, Oracle Web Logic, SAS 9.4 Web application server
Databases: Oracle, Teradata, Netezza, Hadoop, Amazon Redshift
Operating Systems/Platforms: Windows, Linux
PROFESSIONAL EXPERIENCE:
Confidential, Florida
Sr. SAS Administrator
Responsibilities:
- Assisted in SAS 9.4 upgrade from SAS 9.2, Code migration and validation of the same.
- Troubleshooting the issues encountered by users in SAS 9.2 and SAS 9.4 Marketing Automation solution.
- Contacting SAS Support for product specific issues.
- Troubleshooting issues related to SAS environment including the operating systems Unix and Windows.
- Incorporating new users into the SAS system, providing related user roles and permissions to access SAS Applications.
- Tuning the SAS Servers by modifying the connections, increasing the launch and availability timeouts and by increasing the memory in JVM options.
- Scheduling the scripts using crontab and ESP.
- Performing daily health checks and providing the reports for the same.
- Restarting the SAS services during weekly maintenance windows.
- Interacting with Apps Dev and Business teams while working on service requests.
- Creating and modifying the scripts when needed.
- Adding Libraries and providing data access to the users.
- Performing various maintenance activities on server, as applying patches, License renewal, SAS Hotfixes, Restarting the services and performance monitoring.
- Updating the Marketing Automation autoexec mods.
- Scheduling flows in LSF using Schedule Manager.
- Scheduling Marketing Automation campaigns using SAS Customer Intelligence Studio 6.4
- Validating the Marketing Automation environment by executing test campaigns.
- Configuring SAS Environment Manager dashboards, creating alerts for various SAS services and resource utilization.
- Enabled SAS Environment Manager extended monitoring and reports.
- Configured SAS Backup Manager and worked with SAS Deployment Backup and Recovery tool.
- Documented various issues, troubleshooting steps and SOPs.
Environment: SUSE Linux X64, Windows Server 2008 and 2012, SAS 9.4 M3 BI, SAS 9.4 Customer Intelligence - Marketing Automation and Marketing Optimization, Teradata.
Confidential
Sr. SAS Grid Administrator
Responsibilities:
- Administering SAS platform in a multi-node GRID environment and supporting almost more than 900 users.
- Hands on experience in using invoking SAS on Linux. Submitting jobs in batch process, SASGSUB.
- Installed and configured platform RTM application in the SAS Grid environment.
- Good experience in monitoring the SAS grid clusters' CPU and memory usage and runtime etc using platform RTM.
- Established DB connections like Oracle, SQL server and Teradata connections from SAS grid.
- Interacting with different Support teams like UNIX Administration, Database Administration, Production Job Scheduling Team, Middleware Team, Deployment team and others to meet project requirements. Defining Repositories, Server and Library connections for SAS Access setups.
- Promotion of SAS Packages from SMC and DI Studio
- Defining Metadata Custom Repositories.
- User management (User creation, assigning permission, roles and responsibility, etc)
- Renewing licenses for different versions of SAS and LSF
- Creating and scheduling backup policies as per backup requirements.
- Opening track with SAS technical support to resolve major technical issue.
- Played a key role in providing technical support to resolve SAS related issues of SAS products
- To monitor all ETL/Reporting Jobs daily basis and take necessary action within SLA if any issue occurred during loading.
- Share folders and assign permissions to those shares, assigning and managing disk quotas.
- Maintaining the backup of all the logs of users and mail logs for future correspondence.
- Providing solutions to client for Scheduled Maintenance and on Server Panic/Ad hoc Request.
Environment: SAS 9.3 Management Console, SAS Grid Manager, Platform RTM, SAS DI Studio, SAS Information Map Studio, SAS Enterprise Guide, IBM Aix, Windows Server 2008 and 2003
Confidential
SAS Administrator
Responsibilities:
- Defining Repositories, Server and Library connections for SAS Access setups.
- Promotion of SAS Packages from SMC and DI Studio
- Defining Metadata Custom Repositories.
- User management (User creation, assigning permission, roles and responsibility, etc)
- Renewing licenses for different versions of SAS and LSF
- Configuring and Administration of users, groups, Creation/Deletion, Monitoring.
- Creating and scheduling backup policies as per backup requirements.
- Expertise on trouble shooting of SAS server installation and configuration related issue.
- An Opening track with SAS technical support to resolve major technical issue.
- Played a key role in providing technical support to resolve SAS related issues of SAS products
- To monitor all ETL/Reporting Jobs daily basis and take necessary action within SLA if any issue occurred during loading.
- Share folders and assign permissions to those shares, assigning and managing disk quotas.
- Maintaining the backup of all the logs of users and mail logs for future correspondence.
- Providing solutions to client for Scheduled Maintenance and on Server Panic/Ad hoc Request.
Environment: SAS 9.2 Management Console, SAS Enterprise Guide, SAS Information Map, Studio, IBM Aix, Windows Server 2008 and 2003
Confidential
Testing Engineer
Responsibilities:
- Understanding the Business requirement and Functional Specification documents.
- Involved in the development, reviewing of test cases and executing the test cases.
- Defect reporting and tracking through Mantis tool.
- Prepared review document for final release builds.
- Participated in calls and meetings with client and other stakeholders.
- Define, document and execute test plans and procedures
- Design, develop and execute test programs that evaluate the quality of SAS system code written to provide solutions for customers
- Perform verification and QA of algorithms, data sets and reports used in creating and/or analyzing customer data
- Verify data back loads to ensure: all dates accounted for, data is accurate and reports accurately reflect data
- Identify system defects and makes recommendations for resolution
- Work with developers, analysts, and project managers to identify and mitigate risks to quality
Environment: SAS 9.1.3 Foundation, Windows 2003, RHEL, Oracle 10g, Base SAS, SAS Enterprise Guide 4.1, SAS Web Report Studio.