Quality Assurance Supply Chain

UmaShankar

732-***-****; ********@*****.***

SUMMARY OF PROFESSIONAL EXPERIENCE:

Over 14+ years IT experience of software Quality Assurance in various Client/Server, Mainframe, and Web Applications (.NET/J2EE) of various industries engaged in Finance, Leasing, Insurance(Life, P&C), Healthcare, Retail, Logistics, Manufacturing, ERP & Utilities.

Excellent work experience in projects executed under standard Software Development Life Cycle (SDLC) in Waterfall, Agile methodologies

Participation in JAD / Requirement collection sessions to estimate testing needs

Interacted with key stake holders/project team in the capacity of Test Lead/QA Lead/Test Coordinator/UAT Lead

Experience in conventional and ERP applications (SAP MM/SD/PM) and experience in Production Planning and good knowledge on WMS, Supply chain logistics, e-Commerce, Retail

Experienced in SAP End to End testing, UAT, Security testing, ETL and Data Warehouse

Experience in Reports testing based out of Business Objects, Crystal, SSRS, custom generated for functionality, UI

Experience in QA Effort estimation, Resource selection, Mentoring, conduct Walkthroughs

Coordinated with different teams during test plan preparations, test lab set up and test execution phases of UAT/SIT. Coordinated SIT/UAT, provided daily/weekly reports

Very good experience in use of Rational, HP Tools for Test management and Test Automation (WinRunner/Quality Center/ALM/QTP/Load Runner/Selenium)

Administration and Configuration of test management tools HP Quality Center/ALM, QTP

Experience in preparing Test Plans for Functional, GUI, Performance, Upgrade, Acceptance testing and Defect Transition plan, Requirement Traceability Matrix

Experience in coordinating with offshore teams and facilitate knowledge transfer

Hands on experience in Manual and Automated testing of Applications based on RDBMS, Non-RDBMS Databases using SQL/NoSQL, Data modeling, Localization, API, mobile device testing

Used SQL extensively for Database testing using tools TOAD/WinSQL/SQL Developer

Experience in process of ETL and data warehouse, Data migration, Data Quality

Having good knowledge on SSIS, ADF

Experience in testing upgrades and enhancements, Code Review, Code development

Tracked defects till closure, conducted review meetings for defect fix priorities

Involved in automation Test management Tool evaluation and Selection

Creation of automation scripts in QTP, Selenium for regression testing

Provided periodic Status reports, KPI, Dash board reports on metrics to senior management

Very good Knowledge of programming languages(Java, C#, VB Script, Javascript, PowerBI)

Experienced in Testing Web Services/RestAPI using SOAP UI, Postman, Cloud tech

Knowledge on AI and machine learning.

SKILL/EXPERIENCE ENVIRONMENT:

ALM, Load Runner, QTP 10.0, UFT, Selenium, VSS, ERwin, TSL, TOAD, Quality Center 10.x/11, MSTS, ClearQuest, API, SOAP UI, Postman, JUnit, SharePoint, Citrix, Agile Version One, JIRA, Zephyr, Xray, Gherkin, Cucumber, GIT, Azure DevOps, ADO, AWS, Cyber Ark

UNIX/LINUX, Windows/NT, XML, HTML, CSS, ASP.NET, C#.NET, VBScript, Shell, Java script, Java, Python, SAP(MM/PM/SD), Mainframe, TSO/ISPF, TFS, MTM, Angular, Power BI, GIS, SCADA

Oracle 12/11/10, SQL Server, SQL*Plus, PL/SQL, T-SQL, SSIS, ADF, Azure Cosmos, SQL/NoSQL

Publix., FL Nov ‘22 – Dec ‘24

Test Lead

Publix Super Markets, Inc., doing business as Publix, is an employee-owned American supermarket chain retailer for food, groceries, pharma etc. Work included testing applications like ISAS, Vendor Portal, EMST.

Responsibilities:

Test Planning, execution, Regression, End to End testing in Agile Scrum methodology and CI/CD

Coordinate with Sprint dev and test teams, Business analyst, Defect reviews

Functional Requirement analysis. Identification of Test scenarios per system requirements and Acceptance criteria, Test Data requirements identification

Test scripts management, Defect review, coordination, tracking and management using ADO

Integration testing of e-commerce Application with Hybris e-commerce, SAP interfaces, Supply chain flows

Involved in development and execution of Automation scripts for regression testing

API Validation using Postman, Batch Job executions, mobile testing

Backend validation using SQL queries on SQL server and Azure

ETL data validations from JSON file, transformation rules and conversions

Test effort estimations, Test summary reports, Release Notes

ENVIRONMENT: Windows, C#.Net, SQL Server, MySQL, ALM, Selenium WebDriver, BDD, ADO, SAP, JSON, Azure Cosmos, CyberArk, RestAPI, Swagger

ABB Inc., TX Mar 14 – Oct 22

Sr. Quality Analyst/Test Lead

ABB Inc., offers solutions for large independent electrical power system operators, Transmission and Distribution companies through its Network Manager products SCADA/EMS/DMS/OMS. NM DMS offers Graphic and web interfaces for Control Center Operators, Service Center and Call Center personnel, and management for handling Outage Management, Switch Orders, Trouble Calls, Crew Dispatch, Status Reports etc.

Requirement Analysis, Test Planning and Coordination for UAT and Regression cycles and End to End testing in Scrum/Agile methodology with Sprints

Test scripts management, Defect review, tracking and management using HP ALM, Xray

Integration testing of NM DMS with SCADA/Service Suite/Customer Call/netC interfaces

Scenario based testing of ADMS/OMS (Outage Management System)/OMI

ADMS Feature testing includes VVO, Fault Location, GIS integration

Integration testing with SAP(MM/PM/SD) and end to end testing

Identification of Test scenarios per Acceptance criteria, Test Data requirements, Testing risks

Validation of ETL data transfer, transformation and conversion procedures between systems (Oracle to SQL Server) using SQL

Message verification for Tibco/MQ based interfaces, mobile testing, file transfer from ftp sites

Automation script (Java/Selenium) modification, execution

Interface testing and validation using SQL procedures, server logs on LINUX, psim, AQL

Coordinate between Sprint test teams, Scrum Master, Product Owner and PSO team

Preparation of Test summary reports, Release Notes, Test effort estimations

ENVIRONMENT: LINUX, Windows, Oracle, Java, C++, .Net, HP ALM, Version One, Confluence, ClearQuest, ADMS/OMS, SCADA, Service Suite, RabbitMQ, TFS, Postman, Jira, Xray, Zephyr, Selenium WebDriver, DevOps(ADO), GIS, CI/CD

EFG Companies, TX Nov 13 – Feb 14

Sr. QA/Lead

EFG has been a leading provider of Automobile consumer protection solutions (eg: MVP, Walkaway) offered through multiple channels including Dealerships, Financial Institutions, Automobile Manufacturers & Consumer Goods Retailers. Current project involves building an ETL solution for monitoring the Sales across multiple channels and validate the Sales Reporting functionality and their enhancements.

Test Planning for SIT/UAT, End to End testing and Coordination for UAT

Verification of enhancements in consultation with SMEs and business analysts

Validation of test data and conversion data from legacy systems using SQL

Defect analysis and Fix validation, Defect Tracking, Defect review meetings

Integration testing with other applications and interfaces

Validation of ETL processes, Data exports, Role based Security, ETL data in Source/Staging/Target

Identify scenarios for Automation and performance testing

Defects and Test scripts management, Test coordination using Quality Center

Upload scripts into TFS, work flow customization, Test execution in MTM

Tested Web services for validating customer data using SOAP UI

ENVIRONMENT: Windows, AS/400, MS SQL Server 2008, SSRS, TFS, Test Manager(MTM), VISIO, MS Project, SharePoint, SOAP UI

SAP Project(NGLR), PG&E, CA Sep 13 – Oct 13

System Test Analyst

PG&E’s Next Generation Linear Reference (NGLR) project ($10 Mn.), under the Mariner program, for Gas Transmission Lines introduces the concept of Linear Asset Management (LAM) within the Plant Maintenance (PM) module of SAP and integrates with Coler & Colantonio, Inc’s. Intrepid™ GIS Asset management solution, SAP-GEO.e (Geographic Enablement) and Documentum to provide a fully integrated pipeline information solution for PG&E to reduce data discrepancies and improve data quality and Pipeline safety.

Responsibilities:

Create test scripts for Integration and Functional testing to implement Linear Asset Management Data

Verification of Geographic/Linear data transfer through interfaces from Intrepid GIS to SAP

Verification of Notification/Work Order creation using custom transactions zNotif/zOrder

Integration testing between modules PM/GIS/Documentum/Linear Asset Management(LAM)

Validation of custom reports (ECC) for Notifications/Work Orders/Task Lists/LAM data

Testing for manual/automatic creation of Maintenance items and Maintenance plans for various pipeline activities(Install/Reroute/Merge etc.)

Verification for creation/updates for Technical objects like FLOC/Equipment due to various Pipeline events/features, enhancements in UI and business logic based on Notification types

Assist team in UAT test scripts, Upload scripts into HP Quality Center from Excel

ENVIRONMENT: UNIX, SAP R/3 (PM/LAM/MM), GIS, Oracle, HP Quality Center 11.0, VISIO, SharePoint, Citrix

EHR Project, Concentra, TX Dec 12 – Sep 13

Sr. QA Analyst

Concentra, a subsidiary of Humana Inc., is a national Health care company focused on offering services in Urgent Care, Physical therapy, Primary care and Health & wellness. The current project is about implementation of Electronic Health Solutions product Allscripts Enterprise EHR at various care centers of Concentra and integrate it with existing applications like OccuSource, GE Centricity Business, ChartSource etc.

Responsibilities:

Interact with product configuration team and SMEs to analyze the business requirements

Created test plans and scripts using BRD and Functional specification design

Data validation from databases SQL Server, Sybase using SQL queries

Verification of ICD 9/10 codes, Data migration validation using ETL, CPT codes

Functional Integration testing of feature enhancements and Regression testing, UAT support

Validate the Workflows, Security profiles for the applications Allscripts EHR, GE Centricity Business, OccuSource. EDI docs etc.

ENVIRONMENT: Windows2003/7, .Net Framework, Allscripts EHR, GE Centricity PM, SQL Server 2008, Sybase, XML, ETL, Quality Center 10.0, Compuware TrackRecord, Agile, Citrix, EDI

SAP Project, Sempra, CA Mar 12 – Nov 12

Sr. Test Lead

Sempra Energy, a Fortune 500 list company with of $10 billion, develops energy infrastructure, operates utilities and provides related services to more than 31 million consumers worldwide. The project implementation was to SAP for the maintenance and construction projects.

Responsibilities:

Test scenario identification for end to end testing and Coordination for UAT

Verification of new enhancements in consultation with SMEs

Defect analysis and Fix validation, Defect Tracking

Validation of test data and conversion data from legacy systems

End to end UAT, roles/security testing and integration testing with other modules FI/MM/PM

Coordinate with business users and collecting requirements, identify the custom changes

Technical mapping and verification of custom reports (ECC/BI) for Notifications/Work Orders/Service History/Task Lists/Compatible Units/Designs

Assist users in creating Custom Layouts, Variants, User training and documentation

Identify scenarios for Automation and performance testing

Defects and Test scripts management, Test coordination using Quality Center

Upload scripts into Quality center, work flow customization

ENVIRONMENT: UNIX, SAP R/3 (PM/FI/MM/SCM), Oracle, HP Quality Center 11.0, MS VISIO, SharePoint, VBA, QTP, Citrix, SQL

Data Integration Project, Trizetto, MA Jun 11 – Mar 12

QA Lead/Engineer

DI project is targeted to implement Health data integration from core applications FACETS/QNXT to Care Advance(CCA) application and provide enhanced functionality for Utilization management and secure web services for use by third parties like insurers and healthcare professionals.

Responsibilities:

Interact with product designer, development teams for multiple projects in Agile environment

Configuration of Data integration tool to extract data from external systems of databases SQL, Sybase, Oracle, Flat files

Build deployment and virtual servers and validation, configuring interfaces developed in .NET framework

SQL Scripting for data validation and data population into database table

Create SOAP UI projects and validate web services for secure session authentication

Created test plans, strategies and scripts using BRD and Functional specification design

Monitor SQL trace during the web service call and verifying service trace files

Verification of SSO for the applications, cookie verification using Fiddler

Verification of ICD-10 codes, Data migration

Functional testing of feature enhancement and regression testing

Validate the CCA data with respect to the data in external systems (QNXT, FACETS) for claims

ENVIRONMENT: Windows2003, .Net Framework, C#.NET, HTML, Web Services, Oracle, SQL Server 2008, Sybase, Informatica, XML, SOAP UI, TFS, Quality Center 10.0, QTP, VB Script, Fiddler, QNXT, Agile

SAP Project, Freeport McMoran, AZ Oct 10 – May 11

QA Lead/QC Admin

Freeport-McMoRan Copper & Gold Inc. is the world's largest publicly traded copper company with mining interests in geographically diverse places with reserves of copper, gold and molybdenum. This project is about implementation of SAP along with HPQC for Test Management

Activities:

Interact with business teams to understand the test planning needs

Validate the functional/technical requirements and integrated test scenarios

Establish templates for Test Case creations in line and export into Quality Center

Maintaining the Traceability matrix for Requirement/Tests/Defects through QC

Defect reporting and tracking in Quality Center. Participated in defect review meeting and followed up for defect fixes/closure.

SAP end to end UAT coordination, RICEF categorization

Administer and Manage Quality Center and day to day basis & troubleshoot QC issues

Create users in HPQC and manage user groups based on profile/role and User support,

Configured HPQC for Requirements, Test Plan, Test Lab and Defects using Workflow

Managed QC patches, backups for HPQC data, Uploaded Test Scripts into HPQC

Managed Release cycles for Assembly Testing, Product Testing, UAT

Created Dashboard Reports to monitor Testing progress and track defects

Prepared project specific user guides for QC users and trained people to use the QC modules

Created backups of QC projects, provided back up plan to Systems group

Prepared custom reports and graphs in Excel using VBA

Involved in Test scenario review and execution of integrated scenarios comprising multiple modules (FIN/MM/PM) and coordinated with teams

Environment: Windows 2003, SAP R/3 (FI/HR/MTC), Oracle, SQL Server 2005, Quality Center 10.0, SharePoint, VBA, QTP

IM Healthcare, UT Apr 09 – Sep 10

Sr. QA Analyst

Desktop Applications Integration: DAI is integration of multi platform applications(MF, Java, .net) into single application space with sync up of all the applications into a single integrated system developed to provide ease of use for healthcare professionals.

Activities:

Project Test plan preparation, Test case Reviews, End to End Test case design

Liaison with program manager and coordination with development team and business analysts

Test case preparation, Test execution, Defect reporting, Test status reports

Requirement analysis, review of Business requirements and Functional System Design

Coordinate with BA and SME in conducting UAT

Integration testing, Regression testing for each test cycle and reporting results & test summary

Test Data validation, Execute SQL queries using database connecting tool TOAD

Requirements Matrix and Test Scripts development for validating business rules

Web services testing using SOAP UI and review/debug C# code

Involved in configuration and creation of Reports in Quality Center

ENVIRONMENT: Windows 2003, .Net Framework, Windows Forms, Web Services, Visual Studio, NUnit, Oracle 10g, XAML, XML, SubVersion, Quality Center 9.0, SOAP UI, Mainframe, Java, Agile

American Republic, IA Apr 08 – Mar 09

AR is a diversified insurance and financial services company specializing in innovative, tailored health insurance products for individuals, families. It was a multi project environment aimed to implement various enhancements to the applications with the major being implementation of Agent Compensation System(Callidus) to serve direct and indirect agents of AR’s sales network.

As QA Lead

Involved in Requirement analysis, review of BRD and Functional System Design(FSD)

Coordinated with BA, Tech Group and SME in conducting the pre UAT, regular UAT

Integration, Regression testing for each test cycle and report prepare test result summary

Test Data validation, Execute SQL queries using database connecting tool Eclipse

Identified test scenarios for automation for use in test tool QTP, LoadRunner

RTM and Test Scripts development for validating business rules and UI requirements

Prepared Test Strategy and Test Plans, evaluated Test Management tools

Involved in creation and modification QA process templates

Reported issues and tracked, worked closely with BA/SME

ENVIRONMENT: IBM Mainframe, Windows XP, Oracle 9i, DB2, Eclipse, TSO, Quality Center, DTS, XML, MS Team System, API, Callidus, Crystal Reports, LoadRunner

RIS Products, Principal Financial Group, IA Feb’ 07 – Aug ‘07

Principal has major business in financial products catering to Retirement and Investment services and Medical Insurance. The projects consisted of introducing new products, enhance existing products in mutual fund category and ensure Agent and Broker compensation calculations by the marketer services department.

Responsibilities as QA Analyst

Interact with Business Analysts and SME’s during requirement collection phase.

Estimate QA effort for onsite and offshore testers for multiple projects

Prepare high level test plan/matrix, strategy, Defect transition plan, conduct walkthroughs

Test Data identification, Conduct Test execution, Regression Testing and validate test results.

Work closely with offshore testers, review detailed test plans and test execution

Participate in UAT, getting signoffs, ensure post production validations, Integration testing

Test result validation using SQL queries for to compare backend data and UI

Verification of Business Objects Reports during version upgrade to Xi

Defect management using ClearQuest, setup projects in ClearQuest

ENVIRONMENT: IBM Mainframe, TSO/ISPF, DB2, ClearQuest, BO, MS Project, Win SQL

EDUCATION

M. S.

Contact this candidate