VARUN SOWRIRAJAN INDIRA

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

Experience Summary:

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

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.1.3, 9.2, 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.2 to SAS 9.3 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#, Dotnetand 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

Testing Tools

SoapUI/ReadyAPI, 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, Familiar with MySQL & Oracle

Software Dev. Meth.

Waterfall & Agile

SAS BI Tool

Base SAS, SAS 9.1.3, 9.2, 9.3 & 9.4, SAS Viya

: SAS Enterprise Guide 4.1, 5.1, 6.1, 7.1& 7.3

: SAS Enterprise Miner 6.1, 7.1, 12.1 & 14.1

: SAS Web Report Studio 4.2, 4.3, 4.4

: SAS OLAP Studio 4.3, SAS Studio 3.4

: SAS Merchandise Intelligence Server

: SAS Customer Intelligence and RTDM

Middle tier

Web Sphere, Apache & Tomcat

Service Management Tool

HP SM, Remedy & Service Now

Career profile:

Since July 2019 TATA Consultancy Services Limited

Title: QA Lead

Period: Mar 2023 to Jan 2024

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:

Analyzed the user requirements, functional specifications and Use Case documents and created the Test Plans, Test cases for Functional testing.

Performed Black Box and Unit testing using Equivalence Partitioning analysis.

Used Quality Center as Test Repository for Requirements, Test plans.

Involved in providing the Testing Effort estimates and provided the timely feedback on progress of the testing activity.

Examine the results of test to pinpoint defects in the application.

Reviewed the Use Cases in Use Case document and converting into test scenarios and test cases / test scripts.

Prepared Traceability Matrix of Use Case coverage with Test Cases

Identification of environment specific Test data

Execution of Automation & manual test cases and logging of defects

Execution of Automated test scripts in Regression suite, analyzing failures and logging

of defects

Defect management using Quality Center, coordination with developers and Business

users for rectification of defects and retesting

Preparing Test metrics for weekly coordination meeting for the Test Manager.

Preparation of Test execution summary report.

As part of compatibility testing, executed the workflow manager web application related

test cases on different browsers like Internet Explorer and Mozilla Fire Fox on different

Operating Systems. (Validation).

Successfully Completed User Acceptance Testing (UAT) on each release of the project with the help of end user requirements.

Involved in weekly walkthroughs and inspection meetings, to verify the status of the testing effort and the project as a whole and leading offshore team.

Since July 2019 TATA Consultancy Services Limited

Title: QA Lead

Period: April 2021 – Feb 2023

Client Name: Walgreens

Position: Analyst

Project: WBA - USICE

Product Integration of Walgreens Boots Alliance with multiple stakeholders for the Retail and Finance Transformation and Pharmacy Renewal Program. part of Quality Assurance team which delivers the thoroughly tested code to the customer Walgreens Boots Alliance. Objective of the team is to assure the quality of the product integration with multiple partners of Walgreens Boots Alliance in their Retail and Finance Transformation and Pharmacy Renewal program.

Activities:

Extensively involved in all stages of testing life cycle, Test Driven Development methodologies, Software Development Life cycle (SDLC) using Agile methodologies.

Leading & coordinating with offshore QA team Assess manual test coverage and plan.

Monitored regression test results, fixed tests as needed and created bugs.

Participated as a member of an Agile team with daily SCRUM meetings.

Facilitated and fulfilled tasks using agile practices (includes peer reviews, paired programming, daily stand up meetings etc.)

Testing FirstData credit card payment page fucntionality and automated it in Selenium.

Investigated and resolved issues in development and test environments.

Supported Development team to handle miscellaneous release time issues

Worked with manual testers to create improvement plan documents for Development team.

Operating System: Windows

Languages: Macros, JAVA, HTML, XML

Special Software: Agile, JIRA, PuTTY, Firezilla, WINSCP,

Project Location: Deerfield, IL

Since July 2019 TATA Consultancy Services Limited

Title: Senior QA Tester

Period: July 2019 – March 2021

Client Name: Equifax

Position: Analyst

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:

Extensively involved in all stages of testing life cycle, Test Driven Development methodologies, Software Development Life cycle (SDLC) using Agile methodologies.

Developed test scenarios, test plans and test cases with Selenium Suite, IntelliJ IDE, TestNG, C#, Java, Microsoft Excel and Cucumber E1AF framework.

Equifax One Automation Framework (E1AF) is an Open Source Selenium Java based Test Automation Framework. The framework is based on page object module principals, enabling teams to fully utilize the robust libraries comprising but not limited to API, UI, DB, Batch and cloud functions.

Worked on SoapUI/ReadyAPI and Postman tools for functional and automation testing of Restful APIs.

Used SOAP UI tool to test RESTful API with JSON/XML.

Developed Test cases manually and generated Automation Scripts using open source tools like Selenium Web Driver, TestNG, SoapUI, Maven, Jenkins and maintained in Github.

Worked on distributed test automation execution on different environment as part of Continuous Integration Process using Selenium and Jenkins.

Involved in Designing& Developing data driven framework using Selenium WebDriver, TestNG and implemented Java Mail to send the regression result automatically.

Assess manual test coverage and plan and coordinate the creation of automated tests (web UI, RESTful API, proprietary API, Mobile Application, Unix environment, Putty & AWS Cloud)

Monitored regression test results, fixed tests as needed and created bugs.

Participated as a member of an Agile team with daily SCRUM meetings.

Facilitated and fulfilled tasks using agile practices (includes peer reviews, paired programming, daily stand up meetings etc.)

Investigated and resolved issues in development and test environments.

Supported Development team to handle miscellaneous release time issues

Used JIRA for Tasks and Bugs tracking.

Worked with manual testers to create improvement plan documents for Development team.

Operating System: Windows, UNIX

Languages: Macros, JAVA, HTML, XML, SQL & JSON

Special Software: Maven, Jenkins, Selenium WebDriver, Cucumber, TestNG, Web Services, APIGEE Edge, RESTful API, Ready API 2.4.0, Eclipse, Agile, JIRA, GitHub, Fiddler 4,, SOAP UI 4.5.0, Notepad, Postman, Swagger, AWS Cloud Console, PuTTY, Mobaxterm, Oracle SQL Developer, Robo 3T, DB visualizer, Mongo DB Compass, MySQL, WINSCP.

Project Location: Alpharetta, GA

Since April 2013 to June 2019 BioInfo Systems LLC

Title: Senior Manual Tester

Period: May 2018 to June 2019

Client Name: Equifax

Position: Senior Manual Tester

Project: APIGEE Management

An integration tribe has built an offering that all business units and teams globally are invited to leverage. This offering includes, An API management platform that provides the infrastructure for exposing, regulating and monitoring APIs. Provides API security and traffic management. Publish APIs on Developer portal that serve as the hub for interaction with API consumers. Analytics and usage reporting. Provide sandbox environment from which you can see API in action. Provide up-to-date documentation for APIs with every release.

Activities:

Extensively involved in all stages of testing life cycle, Test Driven Development methodologies, Software Development Life cycle (SDLC) using Agile methodologies.

Developed test scenarios, test plans and test cases with Selenium Suite, Eclipse IDE, TestNG, C#, Java, Microsoft Excel and Cucumber framework.

Worked on SoapUI/ReadyAPI and Postman tools for functional and automation testing of Restful APIs.

Used SOAP UI tool to test RESTful API with JSON/XML.

Developed Test cases manually and generated Automation Scripts using open source tools like Selenium Web Driver, TestNG, SoapUI, Maven, Jenkins and maintained in BitBucket.

Worked on distributed test automation execution on different environment as part of Continuous Integration Process using Selenium and Jenkins.

Involved in Designing& Developing data driven framework using Selenium WebDriver, TestNG and implemented Java Mail to send the regression result automatically.

Assess manual test coverage and plan and coordinate the creation of automated tests (web UI, RESTful API, proprietary API, Mobile Application, Unix environment, Putty & AWS Cloud)

Monitored regression test results, fixed tests as needed and created bugs.

Participated as a member of an Agile team with daily SCRUM meetings.

Facilitated and fulfilled tasks using agile practices (includes peer reviews, paired programming, daily stand up meetings etc.)

Investigated and resolved issues in development and test environments.

Supported Development team to handle miscellaneous release time issues

Used JIRA for Tasks and Bugs tracking.

Worked with manual testers to create improvement plan documents for Development team.

Operating System: Windows

Languages: Macros, JAVA, HTML, XML, SQL & JSON

Special Software: Maven, Jenkins, Selenium WebDriver, Cucumber, TestNG, Web Services, APIGEE Edge, RESTful API, Ready API 2.4.0, Eclipse, Agile, JIRA, GitHub, Fiddler 4, SOAP UI 4.5.0, Notepad, Postman & Swagger.

Project Location: Alpharetta, GA

Since April 2013 to June 2019 BioInfo Systems LLC

Title: SAS Admin & Senior Manual Tester

Period: April 2013 to May 2018

Client Name: Department of Human services, PA

Position: Senior Manual Tester

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:

Performed various admin activities such as Metadata backup/restore, yearly licenses SAS servers refresh & hot fix/ security patch installations for SAS 9.3 & SAS 9.4.

Added users, created groups, metadata libraries & allocate metadata permissions using SAS Management Console

Created Metadata folders for each group and assigned permissions to that group only.

Created folders such as RDBMS Libraries, cubes, projects, etc. so that users can logically add Metadata content into the corresponding folders

Promoted Metadata from Dev to Test & Test to Prod as per the SDLC using SPK package

Extensive experience working with different SAS products/services such as Metadata, Work Space Server, SAS Connect Server, SAS Stored Process, SAS Access Interface to various databasesand Object Spawner

Experience in building web applications using C#, dotnet and Jquery.

Supported users on various EBI clients such as Base SAS, SAS Enterprise Guide, SAS Studio, SAS Portals and with SAS Grid usage

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

Handled system administration tasks like login issues, password unlock, reactivating user accounts and password reset, provided access permissions on directories and files as needed

Experienced in LDAP and PAM authentication

Monitoring file system space, ports availability and resources on SAS Servers

Provided the support to end-user community on daily basis and served their day to day functional needs on SAS 9.3 and SAS 9.4

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 Webserices in SOA Policy Manager.

Testing FirstData credit card payment page fucntionality and automated it in Selenium.

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: SAS MC, SAS, EG, SAS EM, SAS Studio, 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

Since September 2007 TCS e-Serve Limited (Formerly CGSL)

Title: Software QA engineer

Period: Sep 2007 – Sep 2010

Client Name: Citi bank

Position: Software QA engineer

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

Since December 2006 Flextronics Technologies India Private Limited

Title: Software Tester

Period: Dec 2006 to Sept 2007

Client Name: Flextronics Technologies India Private Limited

Position: Software Tester

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

Since October 2005 TeamLease

Title: Software Tester

Period: Oct 2005 to Nov 2006

Client Name: GE

Position: Software Tester

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.

Debugging and executing the scripts.

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

Personal Details:

Date of Birth 05/16/1982

Sex Male

Nationality Indian

Marital Status Married

Number of Children 2

Date of Joining 07/01/2019

Designation Senior QA Automation

Location Cumming, GA

Passport Details S3081703

Place of issue: New York & Date of issue: 02/02/2018 (in DD/MM/YYYY)

Date of Expiry: 01/02/2028 (in DD/MM/YYYY)

Driving License DL NO. 061246844

Details Place of issue: Georgia & Date of issue: 10/23/2021

Expiry date: 10/23/2026

Contact this candidate