SUMMARY

• 12 years of experience on SAS Platform Administration/SAS Viya Administration/ SAS Development on UNIX/LINUX, Windows and IBM Mainframe environment.
• Experience with complete Software Development Life Cycle and Software Engineering.
• Good familiarity with software development methodologies like Waterfall and Agile.
• Extensive Knowledge in Server/Client Installation, configuration, customization, support and maintenance of SAS 9.1.3,9.2,9.3 and 9.4versions.
• Experience on SAS Viya administration using SAS Environment Manager
• Working closely with Business Analysts, Business users, Application Architects, Production DBA's & Infrastructure team in setting up and maintaining SAS application server.
• Defining new libraries, servers and assigning security via SAS server permissions using SAS Management Console
• Experience in handling infrastructure needs of the server on which SAS Application resides.
• Provide guidance and assistance to SAS developers/analysts on operational and technical issues related to SAS Administration
• Experience in SAS Deployment Manager to apply Hot Fixes, Renew SAS Software, Update SID File in Metadata, Update Passwords for Internal Accounts, Remove Existing configuration, Uninstall SAS Software and so on
• Participate in full project life cycle, worked with required stakeholders on all aspects of SAS infrastructure deliverables
• Strong in development of specifications, functional and technical requirements and process flows.
• Experienced in the design of Extract Transformation and Load (ETL) processes, coding and testing the ETL processes, maintaining, troubleshooting and fine tune existing ETL processes.
• Expertise on SAS BI tools. (SAS Enterprise Guide, SAS DI Studio, SAS Information Map Studio, SAS Web Report Studio and SAS Management Console)
• Having good Knowledge on Data Warehousing Concepts.
• Extensive experience in developing SAS metadata Repositories.
• Experience in Active directory Authentication and PAM.
• Good experience with Shell Scripting.
• Excellent organizational, teamwork, presentation and communication skills.
• Determined quick learner, self - starter and effective troubleshooter and committed to continuous learning.

TECHNICAL SKILLS

Operating System: Z/OS, UNIX, RH Linux, Windows XP, Windows NT, Windows-2000

Environment: Client/Server, SAS GRID, SAS Viya

Database: Oracle, SQL Server, DB2

Languages: SAS, C, Java, R, SQL, JCL

ETL: SAS DI Studio, DataStage 7.5.1/7.0/6.0 (Manager, Administrator, Designer, Director, Parallel Extender), Informatica.

BI Tools: SAS Management Console 9.3, SAS, SAS OLAP Cube Studio 9.1, SAS Enterprise Guide 5.1, SAS Information Map Studio 3.1, SAS Web report Studio 3.1, SAS Enterprise Miner 12.1, SAS 9.3(Base SAS), SAS Studio.

Tools: PC SAS, Control-M, LSF, R-STUDIO, PVCS

X-Host Applications: Hummingbird v10

Service Desk Solutions: GSD

Big Data Ecosystems: Hadoop HDFS, MapReduce, Hive, Pig, Sqoop, Oozie, HBase, Flume

Cloud Computing: AWS, Azure.

PROFESSIONAL EXPERIENCE

Confidential, Chicago

SAS Platform/SAS Viya Administrator

Responsibilities:

• Coordinate with SAS Development team and downstream Hadoop team to establish connectivity from SAS 9.4 to Hadoop
• Workwith infra team on the local ID & group creation, providing privileges and to provide firewall rules
• Apply SSL certificates on SAS Viya and SAS 9.4 environments
• Administration of SAS Viya, SAS 9.4 (SAS EG, SAS DI) environments
• Applying maintenance releases, upgrades and hot fixes as required.
• Designs solutions to reduce the operational and management complexity of the platform.
• Perform platform capacity planning and management.
• Executing change control and promotion activities.
• Establish best practices and guidelines for usage of the SAS platform.
• Provide leadership and direction in designing and implementation for the SAS platform.
• Provide 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.
• Manage and track SAS products inventory and license updates for SAS servers and end users.
• Provide all levels of technical and application support; incident management; address user, application and data issues.
• Monitor usage logs to assist in performance tuning of the systems and servers. Conform to system architecture standards and practices and work with outsourced suppliers as required to keep up to date with enabling technologies.
• Monitor overall availability, performance of the SAS servers and take corrective actions as necessary to ensure peak operational performance.
• Evaluate and recommend new tools and methodologies to assist with change management and perform upgrades of the SAS environment when necessary.

Environment: SAS 9.4, RHEL, SAS Management Console 9.4, SAS EG 8.2, SAS DI Studio 4.9, SAS Viya 3.5, SAS VisualAnalytics 7.3, SAS Environment Manager 3.5, Ansible, Microsoft SQL Server and Hadoop.

Confidential

SAS Platform Administrator

Responsibilities:

• Administering and maintaining SAS Platform on Windows, Microsoft Azure Cloud and Linux Servers
• Installing and administer SAS EBI client tools like SAS EG, DI, E-Miner and provide required privileges with security
• Establishing the database connection from SAS to MS SQL Server, Oracle and Hadoop
• Defining new libraries, servers and assigning security via SAS Server permissions using SAS Management Console
• Renewing SAS license on both Windows and Linux environments
• Committed and ensuring all levels of issues got resolved within the given SLA and without any escalations
• Supporting host maintenance activities like applying server patches to ensure there is no impact to SAS software
• Performing regular Server Maintenance activities on Linux and Windows severs to enhance the performance
• Provocatively monitoring disk space especially for sas work and permanent sas libraries
• Obtain and apply SAS with new SSL certificates to ensure the security of the mid-tier
• Ensuring the regular metadata backups are taken as per the backup strategy
• Creating LASR server specific to a project
• Setting up autoload jobs for the respective project LASR memory
• Migrating existing SAS VA reports to SAS Viya environment
• Provide continuous support with commitment to ensure SAS platform (SAS Visual Analytics, SAS Viya) is always available to the business without any interruption
• To save time effort and achieve efficiency automated manual tasks like cleaning up of SAS sever logs, retrieving SAS users from Metadata repository and starting and stopping SAS services on Windows and Linux Severs
• Modify the Ansible playbook to point to the new license file when updating the license
• Use Ansible commands to start, stop, update license and check the status of Viya services
• Troubleshoot client applications and systems and provide end user support as required
• Identifying performance and recommending/implementing tuning of active SAS environment(s) providing projected capacity shortfalls
• Supporting SAS Viya platform like on boarding new users with their respective project privileges, creating dedicated project folders, establishing connection between SAS Viya and MS SQL Server, renewing SAS license, and perform troubleshooting.
• Monitoring logs page in SAS Environment Manager (SAS Viya) to ensure there is no error messages

Environment: SAS 9.4, Windows 2012R, Microsoft Azure VM, Linux, SAS Management Console 9.4, SAS Environment Manager 3.3, SAS EG 7.1, SAS VA 7.3, SAS DI Studio, SAS EMiner, ECM, SAS IDP, SAS Viya 3.4, Ansible, Oracle, SQL Server and Hadoop.

Confidential

SAS Platform Administrator

Responsibilities:

• Work extensively on SAS 9.4 installation and migration of users from SAS 9.2 to SAS 9.4.
• Responsible for SAS and SAS 9.4 Application Server administration on Linux environment
• Coordinating with Storage team for storage additions to existing file systems and creating new file systems based on business requirements.
• Coordinating with backup team to restore missing/corrupted files and adding making sure new file systems are added to backup.
• Design, implement, and maintain the SAS security framework (access rights and privileges, user roles / groups etc.)
• Responsible for scheduling SAS Jobs on control-M, backup scripts, cleanup scripts using Crontab.
• Apply SAS hot fixes on Desktops Clients as well as on Servers.
• Responsible for all the End-User community on daily basis and serve their day to day needs on SAS
• Responsible for setting up SAS Access/Interface to Oracle, DB2 servers for end users as per their requirements by implementing ODBC/SAS Connect configuration settings
• Conduct SAS connectivity trainings to SAS Developers and ensure internal processes are followed such as Incident, Change, problem management activities effectively
• Responsible for managing Object Spawner, Metadata server, Connect Server, SAS Access/Interface to Oracle and DB2 server.
• Ensure SAS license is up to date and work on all the SAS end user’s issues, with SAS support if necessary and document the same in share point portal internally as part of documentation process
• Ensure all SAS servers are up and running all the time
• Proactively implementing server monitoring scripts to receive alerts in case of server issues and hence take actions to avoid any downtime
• Responsible as a single point of contact for all of the SAS issues that are outstanding and work with SAS Cary support folks to address on-going top issues.

Environment: SAS 9.2, Windows 2008, SAS 9.4, Linux, SAS Management Console 9.4, SAS EG 7.1, GSD, ControlM, Remedy, WinSCP.

Confidential

SAS Platform Administrator

Responsibilities:

• Involved in requirements gathering from the business stakeholder
• Analysis, and prepared detail design document
• Created a SAS GRA Project are folder structure for users, groups in designated area using SMC
• Model custom Access Control Templates (ACTs) to define a pattern-based approach to the authorizations that will be easy to maintain
• Performed Design Review of Metadata Security Model
• Implemented and Test the Metadata Security Model
• On boarded GRA Project area users to Production environment

Environment: SAS Grid, SAS Management Console 9.4, SAS EG 7.1, SAS DI Studio, EMiner, Linux, Hadoop HDFS, SSH Tectia.

Confidential

SAS Platform Administrator

Responsibilities:

• Installation, configuration, customization and maintenance of SAS Software
• Coordinating with Desktop Support team for installing and Configuring SAS software on client machines.
• Administering and maintaining SAS software on UNIX and Linux Servers.
• Monitor, Trouble shoot, Maintain and Optimize SAS servers
• Creating backup and escalation plan for SAS servers.
• Managing production jobs and handled alerts at individual job level.
• Coordinating with Storage team for storage additions to existing file systems and also creating new file systems based on business requirements.
• Coordinating with backup team to restore missing/corrupted files and adding making sure new file systems are added to backup.
• Assisting the users for creating the SAS workspace for respective UNIX groups.
• Monitoring SAS workspace, running scripts for cleaning temp area.
• Checking the Server status and restarting the server if there is any server downtime.
• Scheduling SAS Jobs, backup scripts, cleanup scripts using Crontab.
• Providing metadata access to users to work on PCSAS, Enterprise Guide and Enterprise Miner.
• Develop, modify Unix scripts as per the business requirement
• Establishing SAS/Access interface connectivity to Oracle, SQL, DB2, and Teradata Databases
• Applying critical hot fixes for the servers and also installing patches for Desktop clients.
• Renew SAS license on timely manner and apply SAS Hot fixes
• Performing the SAS health checkups during DR activities.
• Monitoring Orphan jobs and intimates the User to kill the process.
• Conduct SAS connectivity trainings to SAS Developers and ensure internal processes are followed such as Incident, Change, problem management activities effectively
• Point of contact for all of the SAS issues that are outstanding and work with SAS Cary Tech support folks to address on-going top issues.
• 24/7 production jobs management using ControlM and take care of scheduled jobs
• Watch through all the GSD tickets and troubleshoot/Resolve user incidents.
• Watch through HTS SAS Mailbox emails and troubleshoot on timely respond.
• Responsible for creating documentation for the backup and escalation procedures.
• Worked as Sharepoint Administrator for the Data Management Team - providing accesses, uploading documents to Sharepoint, Creating document review processes on Sharepoint.

Environment: PC SAS, SAS Management Console 9.3, SAS E-Miner 12.1, Enterprise Guide 5.1, UNIX, Linux, SAS VA, SAS JMP, Control-M, Mainframe, JCL, GSD.

Confidential

SAS Developer

Responsibilities:

• Supporting CALOC application production issues
• Developing new enhancements as per the requirement
• Performing Unit testing and Integration testing
• Prepare technical design document

Environment: Base SAS, Macros, Windows.

Confidential

SAS Developer

Responsibilities:

• Contributed to design, development, unit testing, integration testing and documentation
• Performed data quality analysis usingSASprograms and SASDIStudio
• Extracted sourcing data from various systems and in multiple formats usingSASCode, SQL, ETLs
• Involved in ETL job development and customization forSASsolutions usingDIStudio
• Managed delivery schedule & UAT Support

Environment: SAS Management Console 9.1, SAS DI Studio 4.0, Enterprise Guide 4, UNIX.

Confidential

SAS Developer

Responsibilities:

• Understanding existing business model and customer requirements.
• Responsible for developing and monitoring the DI Studio jobs.
• Responsible for creating the user defined transformations in DI Studio environment.
• Responsible for rescheduling the jobs.
• Prepared flows for running the jobs.
• Involved in scheduling jobs.
• Preparing UNIT Test cases and done the UNIT testing.

Environment: SAS Management Console 9.2, SAS DI Studio 4.2, SAS Enterprise Guide 4.2, UNIX.

Confidential

SAS Developer

Responsibilities:

• Accessing Data from Flat files.
• Creating different SAS datasets.
• Data Manipulation using Data Steps and Base SAS procedures
• Used MACROS for creating datasets of each individual depending on the available data.
• Generated reports based on client’s requirement.
• Performing validation on datasets.
• Involved in unit testing, integration testing and acceptance testing
• Involved in SIT, UAT testing including documentation

Environment: SAS Enterprise Guide 4.0, UNIX.