Air Force Manager

ShivaCharan Rangu

E-mail:adhn0p@r.postjobfree.com (or)

Mobile: +1-832-***-**** (Mobile)

Professional Experience: 12 Years

ISTQB Certified Sr QA with over 12 years of experience in IT industry with specialization in Test Web Automation &Functional,SOAPUI, Rest Assured, Database Testing.

Expertise in building and use automation frameworks using technologies: Java, Junit,Testng,selenium,soapUI/pro,REST,JSON and XML, Eclipse IDE, Log4J

Hands-on expertise in Test Automation tool SoapUI, Selenium, QTP/UFT

Ability to create and enhance automation test frameworks/environments

Strong in core Java packages used for automation

Should be strong in building automation frameworks for UI based application and non UI applications like Web Services

API automation testing preferably with POSTMAN and RESTASSURED testing expertise

Ability to create good acceptance and integration test automation scripts and integrate with continuous integration (Jenkins).

Expertise testing across a variety of platforms: Web and Mobile user interface, API (REST and SOAP) and database testing.

Good exposure to SDLC, STLC and Defect life cycle.

Worked on Software development and testing life cycle on Agile, Waterfall model and V-Model

Very good in writing, reviewing and executing Test cases, Test Scenarios from Use cases, FDD, HLDD.

Expert in different types of testing - Functional, System, Integration, Regression, Localization, Performance, UI, Smoke/Sanity, Adhoc testing,Database, Browser Testing IE7/IE9, Firefox and safari 4.0

Develop test scripts and perform automation and manual exploratory testing to ensure software meets business expectation.

Own responsibility for end-to –end product quality including: defect management and oversight, status reporting and metrics creations and escalation for issues discovered during the testing phase.

Develop business and product knowledge overtime and share such knowledge overtime to mentor new team members

Experience on Test management tools like TFS, HP/ Mercury Test Director, HP Quality centre (ALM) and got expertise in managing Test Plan, Test cases, Scripts, Execution and Reporting, Defect management.

Involved in different type of testing like Unit, Intergation,systems testing, retesting, Regression testing, Adhoc testing

Strong leadership and communication skills, enjoying responsibility and ownership at all stages of the test and development lifecycles.

Have a good working experience with Linux platforms and able to troubleshoot issues and find the root cause.

Working with Development team in resolving the issues faced during the testing and troubleshoot and resolve issues

Generating test reports to document all test results from ALM/QC, JIRA

Testing expertise on all Windows 98/ME/NT4.0/2000/XP/Vista/Win7/Win10 platforms and Macintosh (iMac 9.x & eMac 10.1.x. 10.2.x. 10.3.x. 10.4.x, 10.5.x) platforms.

Sound Technical knowledge, excellent exposure and ability to learn any tool quickly.

Energetic, self-motivated, strong work ethic, enjoys challenges and a fast-paced environment

Ability to effectively interact and communicate with all levels of employees, management, vendors and customers

Hands on experience on various Bug Tracker Tools such as JIRA, QC ALM, BugZilla.

Knowledge in various configuration management tools such as Perforce, VSS.

Strong oral and written communication abilities, Strong interpersonal skills

Strong analytical skills, strong problem-solving and decision-making abilities

Education Profile:

Bachelor of Technology (B.Tech) from J.N.T.U (Jawaharlal Nehru Technological University)

Intermediate from Nava Viganana Bharathi jr,college, Warangal

S.S.C from Oasis public school Warangal, Andhra Pradesh

Skill Set

Operating Systems

Windows 95/98/NT, 2000, XP, Vista, Window 7,Windows 10 and Mac OS 8 .6/9.x/10.x, Linux and Solaris

Programming Languages/ Technologies

C, C++, VB script, Java

RDBMS

Oracle,SQL server 2000/2005/2008 R2,2012

Bug Tracking Tools

JIRA, Quality center/ALM,TFS, Zephyr

Automated Testing Tools

QTP,SoapUI, selenium,RESTASSURED API

Test Management Tools

Perforce 2003.2, Visual Source Safe 6.0, ApTest,Slik Central,TFS.MTM

Web related

HTML, XML JavaScript, GROOVY

Source code Management tools

GIT, TFS

Continuous Integration tools

Jenkins, Bamboo

Web Service Testing Tools

SoapUI/Pro, Postman

Domain Expertise

Domain

Specific Area in Domain

Experience (Months)

Energy Utilities (Oil,Gas,Electricity)

Retail Energy ( Customer Billing, Finance and Remittance, Collection)

54 months

E-Learning

Learning system, Content system, Portal System, Caliper

10 Months

E-Commerce

Banking Payments

8 Months

Retail (POS)(Point Of sale)

QSR,EMV Payments, Brand and Non-Branded credit cards, Debit, Retail,EMV

24 Months

Logistics

Transportation management (OTM) (Oracle transportation management), Inbound, Outbound

24 months

Testing Certification:

ISTQB (International software testing Qualification Board) Certification in Foundation Level)

Projects Summary:

HUB GROUP INC (CHICAGO IL, USA) Jan 2020 to Till date

Domain : Logistics

Role : Sr QA /SME

Title : TRANSPORTATION MANAGEMENT SYSTEM REPLACEMENT (OTM)

Tools : SoapUI,Selenium(Webdriver)

Description:

TRANSPORTATION MANAGEMENT SYSTEM(OTM)

Transportation Management System (TMS) to more efficiently balance costs against service requirements, improve visibility of the CONUS supply chain, and automate the freight bill audit function. The current system has reached the end of its productive lifecycle and is not providing expected and needed optimization of route management, has not kept pace with enhanced functionality in the marketplace, and falls short of effectively and efficiently orchestrating and synchronizing processes across functional elements. The goal of replacing the current system with a more robust solution would improve the supply chain integration that spans the functional boundaries including inbound, outbound planning, multi-modal transportation, and international trade

Management. Further, with the enhanced TMS’ on the market, transportation services could be offered, both as a carrier and overseeing the complete transportation management for others, (i.e., be a 3PLprovider).

Description:

The scope entails replacing the “engine” that optimizes routing of freight for both commercial carriers and the Exchange private fleet to include multiple modes of transportation, systematically audits freight bills across all modes,

Plans for outbound optimization versus the current static routes, affords differentiating third party freight from Exchange freight, and encompasses global transit visibility

Role(s): QA Lead/SME

Specific Contribution:

Expertise in preparing the TestPlan, Test Estimation, Daily status reports to project stakeholders.

Testing the backend system API using the SoapUI & Rest assured webservices automation tool

Extensively automated regression and functional test suites using Selenium WebDriver, JAVA, TestNG.

Implemented Page Objects framework, Hybrid framework and Maintenance of automation suite when change of requirement

Lead the team during hotfix & production support

Debugging the issues and report it to development team

Developed Keyword Driven and Data Driven frameworks to retrieve test actions, test data from Excel files and SQL Databases

Identified weaknesses in QA Processes, Web testing, Selenium Automation. Suggested & implemented improvements

Design and create test conditions, test data, and test scripts to address business and technical use cases

Frequent use of SQL queries for UI/data validation

Participate in troubleshooting and triaging of issues with different teams to drive towards root cause identification and resolution

Perform pre-release testing and support post-release verifications

Conducting the Defect triage call with all DEV and business and stakeholder

Review and interpret all documentation related to testing, including business requirements, user stories/acceptance criteria and functional and design specifications, in order to provide input to the project team regarding the planning of testing activities

Preparing the Test plan for the vendor testing

Authoring Test case by analysing the requirements BRD and by referring the SDS

Preparing the test scenarios as per the User stories

Validating the master data setup in test environment

Working on various functionalities Inbound, Outbound and 3PL integrations

Validating the FTI reports as per the business requirement.

Mocking up the required test data by performing data mining using SQL.

Testing the integration between OTM and IIB and EDI integrations

Validating the XML and EDI X12 formats to the carrier and suppliers

Validating the different EDI mapping doc for EDI 753. EDI 754, EDI 204, EDI 990, EDI 214 and EDI 210.

Validating the Rate offering, Rate record, Rate service for all the service lanes

Validation of payment system walker for freight bills.

Validating the route optimisation for shipments build by OTM

Providing the training documents to UAT user for their production validation

Providing the hands-on training for newly joined associates

Daily Interaction with Business Analysts and Technical Analysts and Handling Client Calls.

Provide detailed test reports and metrics to document the status and any risk for current releases

Arm and Air force Exchange Services (Exchange, Dallas, Texas, USA) Feb 2016 to DEC 2020

Domain : Retail

Role : Sr. QA Analyst/SME

Title : POS (Point Of Sale) (Retail, Fuel, QSR)

Tools : SoapUI,Selenium(Webdriver)

Description: The Army Air Force Exchange System (AAFES) mission for more than 118 years has been to support the men and women of the armed forces during military operations, humanitarian missions and other endeavors around the world. The Exchange provides Soldiers and Airmen with the services and merchandise they need to make their lives more comfortable. The Exchange also maintains services and support to family members and troops back home

POS (Point Of Sale) (Retail, Fuel, QSR)

AAFES needs to modernize their retail POS system to effectively compete with other retailers like Walmart and Target. Their current retail software is over 20 years old and has limited flexibility to meet future needs. The Point of Sale (POS) Replacement Program is a major corporate-wide program that will encompass the replacement of all POS software for all retail, food, and fuel venues. AAFES will be a global effort covering over 3,700 facilities worldwide in more than 30 countries, 5 U.S. territories and 50 states. A minimum user client base of 7,900 devices and displays (i.e. POS) is expected

Description:

The Exchange requires: (1) an integrated sales processing platform that will incorporate all retail, food and fuel POS locations worldwide; (2) integration with our existing e-commerce site and a future consumer mobile application environment and; (3) complementary administrative and operational applications that are part of the offers’ proposed POS sales platform, such as CRM, Loyalty, campaign management, price/promotion management, etc.

Validating the POS as per business process

Validating all retail, food, fuel transactions from POS

Validating the discounts,promotions,layaway

Validating the customer payments using the military star card

Validating the transactions triggered from MSR and VeriFone

Validating back office configuration from Microsoft Dynamic AX 2012.

Validating the data load from RMS,ASAP,RPM to AX database

Validating the prepaid and postpaid fuel transactions and payments using different types of payments cards

Validating the T-log for loading the transactions to legacy system for generation of reports

Validating the credit card transactions( VISA,MASTER,DISCOVER,AMEX)

Validating the XML integration with FDMS( First data)

Validating the transaction Types (Sale,Return,credit,void,check)

Role(s): POS Payment SME

Specific Contribution:

Implemented automation using Selenium WebDriver, JAVA, Cucumber, Maven

Check in automated script in CI/CD server so that scripts will run on the latest build on daily night run.

Automating scripts using selenium web driver using JAVA

Conducting the Defect triage call with all DEV and business and stakeholder

Preparing the Test plan for the vendor testing

Authoring Test case by analysing the requirements BRD and by referring the SDS

Preparing the test scenarios as per the User stories

Testing different types of cards Branded and Non-Brand cards solution

Working on various functionalities End-End implementation of POS

Involved in testing of various reports generation and validating with backend.

Mocking up the required test data by performing data mining using SQL.

Running the manual jobs in Dynamics AX 2012 for check the configuration change.

Testing the Payment system API web services using the SOAPUI tool

Providing the hands-on training for newly joined associates

Daily Interaction with Business Analysts and Technical Analysts and Handling Client Calls.

Direct Energy, Houston, Texas, USA Jan 2014 to Feb 2016

Domain : Retail Energy

Role : Lead &Onsite POC

Title : Postpaid (Fiserv Payment Processing)

Description: Direct Energy (DE) is one of North America’s largest competitive energy suppliers of electricity, natural gas and related services. DE provide two kind of services prepaid and postpaid. This project is mainly on to prepaid services. Power up is application for prepaid system for direct energy which is capable of handling the only customer enrollments, billing, taxes, adjustments, payments

Postpaid (Fiserv Payment Processing)

Description:

Direct Energy currently uses third party vendor FIS to transmit, collect and store CC information. With this project, Direct Energy will now be transitioning from FIS to Fiserv all its payment processing activities. Walk-in vendor functionality with Fiserv will continue to be maintained.

Customer payment using the mobile app for android and app store.

Mobile App integration with external vendor for getting the data

Fiserv will be used to transmit, collect and store customer related credit card information

Fiserv will be used to process daily recurring credit card payments

Fiserv will also able to receive real time payments and utilize Direct Energy API(s) to post real time in peace.

Auto Pay customer accounts will be created in Fiserv that will have an account number which matches the DE Customers debtor number stored in CIS

The debtor number will therefore be the link between DE customer information and Fiserv CC information for that customer

Fiserv is the system of record for CC information

DE is the system of record for all other customer information

Role(s): Module Lead &Onsite POC

Responsibilities:

Building the automation framework using Testng with JAVA

Creating the reusable function to reduce the code duplication

Automate web based testing and Restful web services using industry leading tools such as Selenium and ReadyAPI

Creating, Maintaining and Executing test scripts for Functional, Regression and Integration test projects leveraging tools such as Selenium

Update existing tests/Create new tests in the automation test suite.

Add new tests and expand the automation test suite

Preparing the Test plan for the Project

Authoring Test case by analyzing the requirements and by referring the SDS

Testing of a search engine portal -PTJ Miner, used to search the Process Tracking jobs

Mocking up the required test data by performing data mining using SQL.

Running the CTRL-M job scripts on Linux OS and validating the reports.

Brand QA and migration testing on portals Online Self Service

Testing of IVR system using telephonic call flow and web services.

Testing of a search engine portal -PTJ Miner, used to search the Process Tracking jobs

Handling the defect calls

Specific Contribution:

Design, develop and execute test automation frameworks and test automation suites

Evaluate and maintain existing manual and automated test cases & procedures

Deep level of knowledge in test automation design, frameworks, and iterative development

Experience planning, designing, and implementing testing strategies and automation infrastructure for large scale system software

Preparing the Test plan for the vendor testing

Authoring Test case by analysing the requirements BRD and by referring the SDS

Preparing the test scenarios as per the User stories

Working on various functionalities like Autopay, Real Time payments

Involved in testing of various reports generation and validating with backend.

Mocking up the required test data by performing data mining using SQL.

Testing different type of cards like Credit card, Debit card,ACH

Running the CTRL-M job scripts on Linux OS and validating the reports.

Testing of IVR system using telephonic call flow and web services.

Given training to the newly joined team members.

Daily Interaction with Business Analysts and Technical Analysts and Handling Client Calls.

Direct Energy, Houston, Texas, USA Jan 2013 to Dec 2013

Role : Module Lead &Onsite POC

Title : Smart Thermo Stat

Automation Tools : QTP/UFT, QC, JIRA

Description: Direct Energy (DE) is one of North America’s largest competitive energy suppliers of electricity, natural gas and related services. DE provide two kind of services prepaid and postpaid. This project is mainly on to prepaid services. Power up is application for prepaid system for direct energy which is capable of handling the only customer enrollments, billing, taxes, adjustments, payments

The purpose of this project is to launch a smart thermostat product into the market for the existing/new customers and provide elegant thermostat features to efficiently manage their power consumption. This will also help DE to acquire new customers, retain customers, enable cross sell as well as create deeper customer relationships. In Phase-1 of this initiative, DE is launching the Smart Thermostat product only to Houston & Dallas regions only for DE Brand.

The Smart Thermostat will provide the following benefits for DE:

Build loyalty with current customers by creating a differentiated, value added experience that customers appreciate and wouldn’t want to lose if they switch. This will help DE to increase customer retention.

Acquire new energy customers

Lift customer engagement and satisfaction

Improve cross-sales of Direct Energy services

Give potential customers another reason to consider DE at time of sale

Differentiate from competitive energy providers

Role(s): Module Lead &Onsite POC

Responsibilities:

Building the Test automation framework using the QTP/UFT

Coding the test scripts for test automation

Updating the existing scripts and running the test automation daily.

Authoring Test case by analyzing the requirements and by referring the SDS

Mocking up the required test data by performing data mining using SQL.

Running the CTRL-M job scripts on Linux OS and validating the reports.

Brand QA and migration testing on portals Online Self Service

Testing of IVR system using telephonic call flow and web services.

Testing of a search engine portal -PTJ Miner, used to search the Process Tracking jobs

Handling the defect calls

Specific Contribution:

Authoring Test case by analyzing the requirements BRD and by referring the SDS

Ensure that DER/DES is able to produce the various reports as per the business requirements document

Preparing the test scenarios as per the User stories

Working on various functionalities like Smart TStat OAM App., DE mobile App., thermostat portal are working as expected

Involved in testing of various reports generation and validating with backend.

Ensure that Billing, Pricing, Finance, Remittance, Bill Print, Collections & Debt, Market Management, Customer Correspondence & Complaints/Escalation modules are working as intended

Running the CTRL-M job scripts on Linux OS and validating the reports.

Testing of IVR system using telephonic call flow and web services.

Given training to the newly joined team members.

Daily Interaction with Business Analysts and Technical Analysts and Handling Client Calls.

Direct Energy, Houston, Texas, USA Jan 2012 to Dec 2012

Role : Module Lead &Onsite POC

Title : Power to Go (Prepaid services for electricity)

Description: Direct Energy (DE) is one of North America’s largest competitive energy suppliers of electricity, natural gas and related services. DE provide two kind of services prepaid and postpaid. This project is mainly on to prepaid services. Power up is application for prepaid system for direct energy which is capable of handling the only customer enrollments, billing, taxes, adjustments, payments

Role(s): Module Lead &Onsite POC

Responsibilities:

Authoring Test case by analyzing the requirements and by referring the SDS

Mocking up the required test data by performing data mining using SQL.

Running the CTRL-M job scripts on Linux OS and validating the reports.

Brand QA and migration testing on portals Online Self Service

Testing of IVR system using telephonic call flow and web services.

Testing of a search engine portal -PTJ Miner, used to search the Process Tracking jobs

Handling the defect calls

Specific Contribution:

Working SSIS for transferring the EDI transaction between two system

Daily Interaction with Business Analysts and Technical Analysts and Handling Client Calls.

Team leading activities: Task allocation, Task Consolidation, Preparation of Status Reports.

Suggested enhancements to the client by exploring the product extensively.

Assigning work for offshore team and monitoring the cost of the project

Direct Energy, Houston, Texas, USA July 2010 to Dec 2010

Role : Module Lead &Onsite POC

Title : Banking consolidation Phase II

Description:

Banking Consolidation Phase II is divided into different phases with each phase being called with a different project name. Each project covers a chunk of requirements designed for BCP Phase II.

Different projects involved in BCP Phase II are

CPL and WTU Auto Pay Debit/Credit Card

Description:

This project extended the use of recurring credit card payment to CPL and WTU Customers. All Credit Card information is stored on a third party vendor application.

Also, this project consolidates the use of Online Account Manager and “Pay My Bill” so that it mirrors the current Direct Energy, Texas Organic process. CPL and WTU customers involved the use of 2 distinct profiles. One Profile for the “Pay My Bill” details stored with the third party vendor FIS and another for Online Account Manager .The consolidation of the 2 profiles supports in moving away from Direct Login Access to Seamless Login Access for customers and CSR managing AutoPay Credit setup on behalf of the customer. The Online Account Manager profile is required for all CPL and WTU customers who wish to store payment profiles. Conversion activities are performed to transition from the current FIS profiles used for the current Direct Login Access for Customer Console to a CPL Retail Energy Online Account Manager Profile required for Seem-less Login Access to Customer Console for CPL and WTU lines of business.

CIP Automated Returns

Description:

Automation of reversals is new functionality which is being implemented with this project to automate the payment reversal process for CIP payments by receiving and processing a CIP specific return payment file (RIP) from Citibank.

The return check/item process is currently performed manually by the back office personnel. The back office receives notification of insufficient funds via details provided on the bank statement per LOB. Payments posted to the customer's account associated with the return item are reversed manually using specific Peace return reason codes. The reversal automatically triggers an NSF fee to be applied to the account and an NSF letter writing PTJ to be logged, which was automated during the TPC project

Lockbox Migration

Description:

Citibank is migrating from the existing Organic lockbox functions currently supported by Mellon to Remitco. In order to support this Banking Consolidation Project is implemented to handle customer payments by Citibank- Remitco for CPL Retail Energy, WTU Retail Energy, Direct Energy Organic and Direct Energy Multi Family business units.

Roles & Responsibilities

Authoring Test case by analyzing the requirements BRD and by referring the SDS

Working with various bank vendors for payment processing.

Working on various functionalities like Journal ledger, Credit cards, online payments processing.

Involved in testing of various reports generation and validating with backend.

Mocking up the required test data by performing data mining using SQL.

Running the CTRL-M job scripts on Linux OS and validating the reports.

Testing of IVR system using telephonic call flow and web services.

Given training to the newly joined team members.

Daily Interaction with Business Analysts and Technical Analysts and Handling Client Calls.

Suggested enhancements to the client by exploring the product extensively.

Direct Energy, Houston, Texas, USA Jan 2010 to Jun 2010

Role : Module Lead &Onsite POC

Title : Texas Platform Consolidation

Description: Direct Energy (DE) is one of North America’s largest competitive energy suppliers of electricity, natural gas and related services. DE has two types of customers Organic & incumbent which use different versions of Customer Information System (Peace-6.2 and Peace-8.08). Peace is the industry's leading customer management solution for business innovation in regulated, transitioning and competitive markets around the world. With Peace, utilities and energy retailers have the speed, scale and agility to respond to changing opportunities and optimize their ultimate business asset – customers. Peace's customer management components expertly handle prospects, enrollment, customer care and the billing of residential, commercial and industrial customers, with the capacity to manage millions of customers and transactions in multiple markets and jurisdictions. Texas Platform Consolidation (TPC) is the project that migrate the incumbent customers’ data to Organic platform. TPC involve migration of millions of customers’ data to single platform.

Types of Testing:

·Component Testing

·Integration Testing

·Data Migration Testing

·Regression Testing

Role(s): Module Lead &Onsite POC

Responsibilities:

Authoring Test case by analyzing the requirements and by referring the SDS

Mocking up the required test data by performing data mining using SQL.

Running the CTRL-M job scripts on Linux OS and validating the reports.

Brand QA and migration testing on portals Online Self Service and OCC Tracker.

Testing of IVR system using telephonic call flow and web services.

Specific Contribution:

Daily Interaction with Business Analysts and Technical Analysts and Handling Client Calls.

Team leading activities: Task allocation, Task Consolidation, Preparation of Status Reports.

Suggested enhancements to the client by exploring the product extensively.

Assigning work for offshore team and monitoring the cost of the project

Derived & designed a complete functional diagram of IVR call flow.

BlackBoard Automation, Washington USA Jan 2009 to Dec 2009

Role : Module Lead &Onsite POC

Title : Blackboard Automation

Project Description:

Blackboard uses Modular automated framework and by which we are going to run on different servers like (installers, updaters, Linux, Solaris, windows) then around 6000 test cases run via QTP. The project involves scripting of BAT (Build Acceptance Test).The Failures reported during each phase i.e. build stage, Installation stage, Testing stage (both application issues, automation issues) need to be investigated, troubleshoot and analyzed. Based on the analysis report the Build health should be assessed depending on which the build is given for QA testing. On daily basis at least 3 builds (various releases) needs to be tested and analyzed.

Responsibilities:

Updating scripts.

Continuous monitoring of Daily Builds from Build Phase itself.

Reporting any errors in the Build formation via JIRA (Bug tracking tool) and trouble shooting for smooth compilation.

Trouble shooting and ensuring smooth installation of daily builds across various platforms.

Analyzing the failures generated from the Test results and further troubleshooting it to be a script failure or application bug.

Updating automation script and updating the changes in Perforce (central repository) once changes are accepted.

Analysis and reporting the Status and strength of the daily builds to all the stake holders (Clients including QA Director to Automation Egg.)

Responding to all the Queries and providing more information to the stake holders in taking major decisions during Build releases to QA testing and also to Customers.

Handling Client calls, Mutual exchange of information and knowledge in Qtp and product.

BlackBoard Academic suit, Washington USA Jan 2007 to Dec 2008

Role : Software Engineer

Title : Blackboard Automation

Project Description:

Blackboard Inc. is a leading enterprise software company for e-Education. It offers a complete suite of enterprise software products and services to Higher Education, K12, corporate/Government and International. Blackboard Academic Suite contains Blackboard Learning System, Blackboard Content System and Blackboard Portal System.

Blackboard Learning System is a Web-based server software platform that offers industry-leading course management, an open architecture for customization and interoperability, and a scalable design that allows for integration with student information systems and

Contact this candidate