SAS Admin

VARUN

Mobile: 848-***-**** Email: *********@*****.***

Experience Summary:

Value driven and highly accomplished professional in Information Technology, Banking & Financial Services, Manufacturing, Public Sector Industries & Retail around 6 years in SAS Administration & 10 years in Software Quality Assurance including Automation and Manual testing using Selenium, Java, SOAPUI, TFS, SQL.

Extensive experience in testing the client, web & Mobile applications manually and using automated testing tools.

Key areas of expertise include project management, quality assurance with ability of documenting business requirements, reviewing functional specifications, analysis and comparison of existing solutions, providing cost estimations, writing test strategies, test plans, test cases, coordinating testing and documentation.

Experience in all phases of Software Testing Life Cycle (STLC) and good exposure to Software Development Life Cycle (SDLC).

Extensive hands on SAS 9.3, 9.4 and SAS Viya 3.4 administration including Base SAS, SAS Management Console, SAS Metadata Server, SAS Enterprise Guide, SAS Enterprise Miner, SAS Object Spawner, SAS Stored Process Server, Work Space Server, Data Integration Studio, Web Report Studio, SAS Information Delivery, CAS servers, Portal, SAS OLAP Server, SAS Studio, SAS Customer Intelligence, SAS Real Time Decision Manager, SAS Merchandise Intelligence Server, SAS Macro, SAS Access, SAS ODS, SAS Graph, SAS Stat and SAS Connect server

Experience in migrating SAS applications, users and data from SAS 9.3 to SAS 9.4 on UNIX environment, from SAS 9.4 M3 to SAS 9.4 M3 from Solaris to Linux and migrating SAS 94 M3 from oracle cloud classic to oracle cloud

Excellent installation & configuration experience of SAS servers, sas client applications, Platform LSF and RTM in grid environment

Experienced in building, installing, configuring and supporting web applications Tomcat, Apache, C#, .net and JBoss

Experienced in installing and configuring Disaster Recovery

Monitoring, reporting and controlling SAS server usage

Experience in creating dashboard using Tableau

Possess extensive experience in analyzing problems and resolving issues of end users

Experience in Ticket and Change Management products and procedures

Experience in providing 24/7 call support for production environment

Experienced in all phases of lifecycle including requirement gathering, risk analysis, project planning, scheduling, testing, defect tracking, reporting and managements.

Experienced in developing use cases, user interface specifications, and user requirement specification documents.

Exposure to performing database backend testing and in writing SQL Queries

Excellent interpersonal and oral/written communication skills with the ability to understand and explain both business and technical needs from and to clients and customers.

Good knowledge in Database Testing using SQL, PL/SQL.

Experience in testing web services based on SOAP and RESTful using SOAPUI Pro.

Proficient in different software development methodologies like Agile Methodology, Waterfall model, Iterative model and V-model.

Expertise in Manual Testing, API testing, Webservices testing, Smoke Testing, GUI Software Testing, Black-box Testing, Functional Testing, System Testing, and Regression Testing.

Strong Analytical and Problem-Solving skills.

Quick learner of new software/tools, self-starter, can work independently and in a team.

Can conduct functional, load, smoke, GUI, integration, and regression testing.

Good experience in working with bug tracking tools and defect management.

Ability to interact with Business Analysts and developers regarding functional requirements, bugs, enhancements and test case review meetings.

Good experience in writing Macros, DSR (Daily Status Report) and WSR (Weekly Status Report)

Computers Worked On

SAS BI Tool

: Base SAS, SAS 9.3 & 9.4

: SAS Enterprise Guide 7.1 & 7.3

: SAS Enterprise Miner 12.1 & 14.1

: SAS Web Report Studio 4.3, 4.4

: SAS OLAP Studio 4.3, SAS Studio 3.4

: SAS Data Integration Studio

Middle tier

Web Sphere, Apache & Tomcat

Service Management Tool

HP SM, Remedy & Service Now

Storage

SAN EMC & NAS Isilon

Databases

MSSQL, Oracle, Teradata & Hadoop

Testing Tools

SoapUI/Ready API, Maven, Swagger, Postman

Bug Tracking

JIRA, Bugzilla, HP ALM, Test Management Tool (MTM)

Operating Systems

Operational and Installation Knowledge of various versions of Windows & Linux OS

Familiar with Android, iOS, Mac, Solaris.

Languages & Scripts

VB .NET, Visual Basic 6.0, VBA, C#, Java, Linux commands

Databases

MS SQL Server, MS-Access, Teradata, Oracle and Hadoop

Software Dev. Meth.

Waterfall & Agile

Career profile:

GROKSYS LLC

Title: SAS Admin

Period: Mar 2024 to Sep 2024

Client Name: Equifax

Project: Data Fabric Analytics

Data Fabric platform designed to help solve complex business and data processing needs and it is a GCP cloud-based solution.

Activities:

Administering SAS 9.4 M7 & SAS Viya environments on RHEL 8 platform

Supported SAS applications such as SAS Enterprise Guide, SAS Studio, SAS Environment manager, SAS Personal Login Manager & SAS Management console.

Configured LSF queues for workload balance.

Performed various admin activities such as Metadata backup/restore, hotfixes, security patches installations for SAS 9.4 M7 & SAS Viya.

Yearly SAS licenses for all SAS servers.

Added and Deleted users based on the IDM request (Identity management Provisioning system)

Created Metadata folders for each group and assigned permissions to that group only. Created Metadata objects such as Libraries, users, groups and projects, unlock user account, etc based on the IDM request & in ServiceNow tickets.

Responsible for Disaster Recovery fail over and fail back testing.

Configure/Establish connectivity from SAS to various databases like SQL/MSSQL, Oracle, Teradata, Google cloud BigQuery.

Created training/informative documents for users such as how to onboard to new Grid platform, how to use different client and web tools like EG, Enterprise Miner, Personal login Manager, etc.

Created few other documents such as Database connectivity, Incident Management, Mainframe Connectivity from SAS, etc.

Monitoring the incidents and create report for audit purpose and make sure there is no SLA breaches with proper updates.

Responsible for fixing SAS vulnerabilities.

Used ServiceNow for change management & Incidents.

Starting and stopping the whole SAS grid during the maintenance activities and outages like OS patch.

Monitoring the SAS grid services, filesystem and server resources usage and ports using different SAS and third-party monitoring tool RTM.

Setup scripts for cleaning the SAS work space and orphaned processes and setup cleanwork utility

Work closely with users to resolve their issues and SAS TS as needed

Responsible for on call 24/7 production support

TATA Consultancy Services Limited

Title: SAS Admin

Period: Mar 2023 to Jan 2024s

Client Name: KeyBank National Association

Project: KTO Business Intelligence

KeyBank, the primary subsidiary of KeyCorp, is an American regional bank headquartered in Cleveland, Ohio, and is the only major bank based in Cleveland. KeyBank is one of the largest banks in the United States.

Activities:

Administering SAS 9.4M7 Grid environment on RHEL 6 platform

Supported SAS applications hosted on Citrix servers. SAS Enterprise Guide 7.1, SAS Enterprise Miner, SAS Flow manager, SAS Personal Login Manager & SAS Management console.

Configured LSF queues for workload balance.

Performed various admin activities such as Metadata backup/restore, hotfixes, security patches installations for SAS 9.4 M7

Upgraded Google SDK packages.

Installed Content Assessment & ESM tools in QV & PROD environment.

Yearly SAS licenses for all SAS servers and platform LSF in SAS9.4 grid environment

Added and Deleted users based on the IDM request (Identity management Provisioning system)

Created Metadata folders for each group and assigned permissions to that group only. Created Metadata objects such as Libraries, users, groups and projects, unlock user account, etc based on the IDM request & in ServiceNow tickets.

Responsible for Disaster Recovery fail over and fail back testing.

Configure/Establish connectivity from SAS to various databases like SQL/MSSQL, Oracle, Teradata, Google cloud BigQuery, Mainframe DB2.

Created training/informative documents for users such as how to onboard to new Grid platform, how to use different client and web tools like EG, Enterprise Miner, Personal login Manager, etc.

Created few other documents such as Database connectivity, Incident Management, Mainframe Connectivity from SAS, etc.

Monitoring the incidents and create report for audit purpose and make sure there is no SLA breaches with proper updates.

Responsible for fixing SAS vulnerabilities.

Used ServiceNow for change management & Incidents.

Monitor and work on Moogsoft AIOps situation and Alerts.

Starting and stopping the whole SAS grid during the maintenance activities and outages like OS patch.

Monitoring the SAS grid services, filesystem and server resources usage and ports using different SAS and third-party monitoring tool RTM.

Setup scripts for cleaning the SAS work space and orphaned processes and setup cleanwork utility

Work closely with users to resolve their issues and SAS TS as needed

Responsible for on call production support

TATA Consultancy Services Limited

Title: SAS Admin

Period: May 2018 to December 2022

Client Name: Equifax, Alpharetta, GA

Project: Property Data & Analytics

Property Gateway (Formally known as Property Data & Analytics) offers a diverse set of solutions around the mortgage value chain, including Automated Valuation Model (AVM) Insight, which can be utilized in account acquisition, pre-screening, appraisal review/QC, due diligence, portfolio management, loss mitigation and default management.

Activities:

Responsible for leading a variety of engineering activities including the design, acquisition and deployment of hardware, software, and network infrastructure in coordination with technology team

Coordinating between business end users and SAS supports on various project works and issues

Administering SAS Standalone and SAS Grid environment, installed and configured on Red Hat Linux & Solaris

Serving as a technology subject matter expert for internal and external stake holders and provide direction for all firm mandate controls and compliance initiatives

Ensure that all integration of functions meet business goals

L3 support activities like creating change requests and troubleshooting SAS and infrastructure related issues and ensuring the overall SAS grid health.

Supporting various third-party tool like NDM, Cognos & Tableau and downstream applications.

Performed various admin activities such as Metadata backup/restore, SAS servers refresh & hot fix/patch installations for SAS 9.4 M3 and SAS 9.4 M6

Maintaining Yearly SAS licenses for all SAS servers, platform LSF and SAS LASR servers

Created Metadata folders for each group and assigned permissions to that group only. Created Metadata objects such as Libraries, users, groups and projects, etc

Configured F5 load balance VIP’s for web tools

Installed the client applications on user’s machines and worked with desktop support team to create SAS packages

Responsible for Access control Management & user privileges

Responsible for tuning and providing best practices recommendations to user community

Support backup/restore the data using cold backups

Responsible for failover/failback to DR

Monitoring the incidents and create report for audit purpose and make sure there is no SLA breaches with proper updates

Configure/Establish connectivity from SAS to various databases like MSSQL, Oracle, Teradata and Hadoop

Starting and stopping the whole SAS during the maintenance activities and outages.

Monitoring the SAS services, filesystem and server resources usage and ports using different SAS tools like Environment Manager

Monitoring CPU, I/O and memory using NMON

Setup scripts for cleaning the SAS workspace, orphaned processes, rolling logs nightly and setup clean work utility

Configure security using Unix ACL’s and SAS ACT’s

Configuring production jobs and scheduling through Autosys

Created training/informative documents for users such as how to onboard to Grid platform, how to use different client and web tools like EG, SASGSUB, SAS studio, Enterprise Miner, and Stratum IRM applications. Etc

Support SAS application validations after various maintenance activities like OS patches, network changes and storage changes.

Work closely with users and resolve their issues and work with SAS TS as needed.

Responsible for on call production support

BioInfo Systems LLC

Title: Senior Manual Tester

Period: April 2013 to May 2018

Client Name: Department of Human services, PA

CHILD WELFARE INFORMATION SOLUTIONS (CWIS)

The Department of Public Welfare is the largest department within the Commonwealth of Pennsylvania. The Department is charged with improving the quality of life for the Commonwealth's citizens. The Department oversees the administration of state welfare programs within the following offices: Children, Youth and Families, Medical Assistance, Income Maintenance, Social Programs, Mental Retardation, and substance abuse.

INTEGRATED CLIENT INFORMATION SYSTEM (CIS)

Worked for Department of Public Welfare of Pennsylvania and involved in a project with CIS (Client information system), CIS sub systems have COMPASS (Commonwealth of Pennsylvania Access to Social Services), eCIS (Electronic Client Information System) and CIS (Client Information System). Worked on the Patient Protection and Affordable Care Act (PPACA), commonly called “Obama care” is the federal health care law. Most of the core functionality in eCIS has been developed in the .NET Framework (ASP.NET on VB.NET) and Oracle 10g/11i.

Daily Duties:

Worked on various Maintenance initiatives and work orders.

Analyse and Review Business Requirement Documents/Functional Requirement Documents (RDD) and Use Case Documents.

Created Test plan, Test strategy, performance Test Plan and User Acceptance Test plan.

Conducting team/bug triage meet, participating in App team, UAT team & Client team meetings, assigning task to team members.

Defined activities required to prepare and conduct Functional Testing, Integration Testing, System Acceptance Testing, Regression Testing, GUI Testing, Mobile testing (browsers & Native Apps), Backend Testing.

Responsible for reviewing Test Cases & creating the Traceability Matrix.

Create and execute test cases then recording of test results using Microsoft Test Manager.

Developed SQL Queries used to perform Oracle SQL Developer database testing and testing mainframe, Flat file, UNIX by using Commands.

Created XML to performed service testing through SOAPUI Pro and validating in SOA Policy Manager.

Automation of test cases using Selenium Web driver, Java, TestNG, Page object Model(POM), Jenkins, Maven & GitHub.

Used Protractor to run end-to-end tests that are written in JavaScript and run with NodeJS language used is Java and expanded test scenarios, tracked Cucumber reports.

Created XML based test suit and integrated with Jenkins Server to execute automation scripts on a regular basis by scheduling Jenkins jobs in different test environments with different test configurations.

Executed the automated regression test cases during every release and executed the daily regression test suites.

Extensively automated Regression and Functional test suites by developing over 140+ test cases and five test suites using Selenium WebDriver.

Developed BDD tests using Cucumber by writing behaviours and step definitions.

Developed required Selenium support code in JAVA for Cucumber.

Used Jenkins as continuous integration server to run automated test suites.

Experience on End-to-End testing from project Start to Sign-Off.

Interacted with Business Team, Scrum Master, Developers regarding for the requirements.

Maintained team Defects report though MTM & TFS and reported to the management on daily basis.

Operating System: Windows

Languages: Base SAS, Shell scripting, Macros, ASP.NET, VB.Net, C#.Net, JAVA, HTML, Macros, XML, SQL & JSON

Special Software: Selenium WebDriver, Java, SQL Server 2012, Cucumber, Web Services, Eclipse, Agile, Jenkins, TestNG, Oracle SQL Developer 4.0.3.16, Microsoft Test Manager(MTM), MS Visual Studio 2010, GitHub, Fiddler 4, SQL Server 2005/2008, TFS, SQL, SOAP UI 4.5.1, Notepad++, SnagIt Editor, Informatica, Policy Manager, CA IDM and Splunk.

Project Location: Mechanicsburg, PA

TCS e-Serve Limited (Formerly CGSL)

Title: Software QA engineer

Period: Sep 2007 – Sep 2010

Client Name: Citi bank

Daily Duties:

Performed the role of an Auditor for an affiliate of Citi's North Americas collections (related to Credit Cards, Auto loan, Mortgage loan, and personal loan).

Conducted audits on applications/processes used by the Bank and on the different communication tools used by the Bank to reach customers (calls, letters, emails etc.).

Notify clients/business on probably reputational/operational risk that might affect the business, it involves drafting and implementing a corrective action to mitigate the risk and follow up through to the point of resolution by working with the clients/business.

Reviewed and analysed requirements, developed test plans, writing test cases, performed Integration, System, Regression and User Acceptance Testing (UAT).

Used Test Director for bug tracking and reporting. Involved in the Manual Testing and developed Traceability Matrix. Performed Both Positive and Negative Testing.

Developed SQL Queries used to perform database testing.

Identified the bugs and interacted with the team lead and developers for a resolution to ensure the overall quality of the software.

Maintain excellent rapport with the clients and the management to discuss process improvements, risk, and control identification and establishment and to discuss issues and concerns while testing the risks and controls.

Weekly call with Clients regarding the deliverables required for testing.

Operating System: Windows

Languages: Visual Basic, ASP.NET & C#.

Special Software: SQL Server, Test director, Win XP, MS Office & SharePoint

Project Location: Chennai, India

Flextronics Technologies India Private Limited

Title: Software Tester

Period: Dec 2006 to Sept 2007

Client Name: Flextronics Technologies India Private Limited

Daily Duties:

Understanding the Functional Requirement Specifications (FRS) and interacted with the business users and providing feedback.

Understanding the application for the business perspective interacted with developers too for same understanding and then prepared the test scenarios and test cases accordingly.

Understanding Quality Assurance (QA) process and bug tracking tool(JIRA)

Responsible for System testing, Regression Testing, DB migration testing, web Testing etc. and then logged the defects using JIRA (Bug tracking tool).

After the end of every testing, the cycle could send the status and defect report to the managers, users, and developers and was involved in the discussions of the same.

Was involved in UAT after every Live Release of the application.

Partially was part of the Production Support team. Handled Production support cases (PS issues) and resolved and closed the same.

Tested the JIRA’s (defects) in ‘QA testing’ status and then moved it in ‘To be released to Live’ status.

Attended ‘Business Up gradation’ training given by business users.

Operating System: Windows

Languages: Visual Basic, SQL, ASP.NET & C#.

Special Software: JIRA, SQL Server, MS Office & SharePoint

Project Location: Chennai, India

TeamLease

Title: Software Tester

Period: Oct 2005 to Nov 2006

Client Name: GE

Daily Duties:

Involved in test plan design & review, reviewing test cases, traceability matrix creation, test scripts scheduling, test effort estimation and test scripts execution.

Worked closely with the QA manager to discuss/decide major activities, scopes and milestones in the QA life cycle, update and publish status reports.

Executing Functional Testing, Integration Testing, System Testing, Regression Testing, Backend Testing, Performance Testing and User Acceptance Testing.

Converting XSD to XML. Firing request XML and getting a response.

Developing SQL Queries for Database testing.

Reporting the defects using Bugzilla.

Timely reviewing of the updated Use Cases, BRD's and the TDD's to update self to the change in the application business flow.

Operating System: Windows

Languages: ASP.NET & C#, XML, SQL

Special Software: HP ALM, SQL Server, MS Office & SharePoint

Project Location: Hyderabad, India

Education

Master of Science in Information Technology & Management at University of Wales, Newport, United Kingdom, 2012

Bachelor of Computer Application at University of Madras, Chennai, India, 2003

Contact this candidate