QA Analyst, Testing

R. HARISH KUMAR

E-Mail: ******.***********@*****.***

Phone No.: 949*******

Professional Summary:

Having 2.9 years of experience in Quality Assurance.

Experienced in Functional, Mobile and Database Testing.

Well-versed in all stages of Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC) and Defect life cycle.

Knowledge in different types of testing methodologies like functional, regression, smoke and Adhoc testing.

Having knowledge on non-functional testing like performance, security, usability testing.

Having Experience on preparation of test cases and having exposure on executing Test Cases.

Good experience in writing SQL queries for Database Testing from different Databases using SQL Query Analyzer.

Extensively involved in functional, Black Box and Data Integrity Testing.

Managed & reported the status updates for multiple projects simultaneously & delivered successfully.

Excellent Functional knowledge on Airlines Domain.

Academic Record:

M.Tech (DECS) from Sree Vidyaniketan College of Engineering and Technology, Tirupathi with 8.7 GPA in 2013.

B.Tech (ECE) from Priyadarshini College of Engineering and Technology, Nellore with 72.50% in 2011.

Intermediate from Vikas junior College, Tirupathi with 94.40% in 2007.

SSC from Dolphin Dale High School, Rly Kodur with 83% in 2005.

Technical Skill Set:

Operating System : Windows 2000/2003/XP/7.

Test Management Tools : TFS, Application Lifecycle Management, JIRA.

Programming Languages : C, SQL, VB Scripting.

Databases : Oracle 11g, SQL developer, Teradata SQL Assistant.

Global Distribution Systems : Shares.

Web Services Tool : SOAP UI

Experience Summary:

Working with CSC India Pvt. Ltd., Hyderabad as Associate Software Engineer from September, 2013 to till now.

Project Details:

Project : Pilot Mobile App June 2015 – Till now

Client : United Airlines.

Portfolio : Crew Systems.

Team Size : Two

Tools : Perfecto Mobile, device Connect (Mobile Labs), JIRA, iOS 8.4/9.

Description : United Airlines, is a major American airline carrier headquartered in Chicago, Illinois. It is the world's largest airline when measured by number of destinations served. United is a founding member of Star Alliance, the world's first and largest global airline alliance. Regional service is operated by independent carriers under the brand name United Express. Pilot Mobile App is used by the United Airline’s pilot in order to know the current and upcoming activities. The Functional and UI are tested by logging into the application with the corresponding Pilot credentials. ETA/ETD events are posted using the Test Data builder tool and the corresponding event delay notifications will be triggered in the Pilot Mobile App. The testing is performed using device Connect environment.

Responsibilities:

Involved in Functional, mobile and web-service testing

Defect Posting and Issue verification

Posted events and performed data validation of the records.

Developed Test Plans and Test Cases for System, Integration and Regression Testing from Business Requirements, System Requirements, Technical Design Documents.

Had interaction with Developers to escalate testing issues and to take their valuable inputs for successful completion of Testing.

Performed test data analysis and drives the setup and verification of test data

Involved in meeting with the developers and client groups to determine performance requirements and goals and to determine test strategies that is based on requirements.

Created issue list for each day while performing testing to keep track the status and issues.

Project : Predictive Analysis. Dec 2014 – May 2015

Client : United Airlines.

Portfolio : Flight Operations.

Team Size : Two

Tools : Oracle SQL Developer, HSQL, Application Lifecycle Management, informatica.

Languages : Structured Query Language

Description : The Predictive Analysis Tool is a real time analytical tool used to monitor and detect upcoming, potential problems with the planned operation of flights. It reviews the timeliness and limitations of aircraft and crew availability, as well as Air Traffic Control programs to project/predict an Estimated Time of Departure. The events which are posted in the FLIFO tool for a specific flight will be stored/updated in the ODS database. The flight information from the PDS database is retrieved to predict the delay time for the next flight. The ODS tables are published into the HSQL cache memory.

Responsibilities:

Validated the Sources/Target tables present in database/data warehouse.

Performed data validation of the transformations and mappings in the ETL tool.

Performed the web testing of the application for browser dependency.

Worked with the Developers and the Test Lead to verify the Test Cases.

Prepared the Test Data to mock up all the Test Scenarios and Test Cases.

Involved in Creating the Test plan and Test cases.

Perform the Functional, regression, System and Integration Testing.

Regular interaction with developers to report various problems and issues.

Interactions with BA & Dev teams to resolve the issues.

Reporting daily testing status.

Defect Analyzing and Reporting in Quality Center.

Worked on SQL scripts to load data in the tables.

Worked with Data Warehousing developers who extensively used informatica, to design mapping to move data from source to target database using Stages to do the functionality.

Project : CORA Sep 2014 – Nov 2014

Client : United Airlines.

Portfolio : Flight Operations.

Team Size : One

Tools : Application Lifecycle Management.

Description : CORA (Controlled Operations Recovery Advisor) is a recovery tool that provides detailed information of flights regarding GDP (Ground Delay Program), AFP (Air Flow Program), GS (Ground Stop) and substitution of Flights at a Station. Basically the application displays the information of the stations affected by GDP, AFP and GS. It describes the details of the Station, Issued date and Time, Start Time, End Time, Subs of flights, Flights controlled from the station and BRG-OFF (Turn the bridge off and Synchronize with FAA (Federal Aviation Academy)).

Responsibilities:

Performed Functional testing on the application.

Defect Posting in ALM and Issue verification.

Reporting the identified issues to the developers.

Posted events and performed data validation of the records.

Developed Test Plans and Test Cases for System, Integration and Regression Testing from Business Requirements, System Requirements, Technical Design Documents.

Reporting daily testing status.

Defect Analyzing and Reporting in Quality Center.

Performed the web testing of the application for browser dependency.

Worked with the Developers and the Test Lead to verify the Test Cases.

Project : Quality First July 2013 – Aug 2014

Client : United Airlines.

Portfolio : Food Services

Team Size : One

Tools : Oracle SQL Developer, Application Lifecycle Management.

Languages : Structured Query Language

Description : The main objective of the project is to provide the awards for the Catering unit based on the goals and scores. The scores are calculated for monthly, quarterly and annually. The information present in the application is verified with the ODS database.

Responsibilities:

Preparing the Test Plan, Test Strategy for businesses as usual releases.

Creating the Test Scenarios and Test Cases and review those.

Defect Analyzing and Reporting in ALM.

Project : CRM Database Testing. Sep 2013 – June 2014

Client : United Airlines.

Portfolio : Loyalty.

Team Size : Three

Tools : Teradata SQL Assistant (Data Warehouse), Oracle SQL Developer, Application Lifecycle Management, informatica.

Languages : Structured Query Language

Description : The objective of the project is to increase the number of customers for the United Airlines. United Airlines is having a loyalty program called Mileage Plus. In this project, we are validating the member and non-member records in the database and data ware house in two phases- initial load and weekly load by using Structured Query Language to retrieve the data from the database and data ware house. The defects are posted in the ALM.

Responsibilities:

Preparing the Test Plan, Test Strategy for businesses as usual releases.

Creating the Test Scenarios and Test Cases.

Involved in running the jobs/Workflows for ETL process

Verifying the ETL data in target database

Verified column mapping between source and target

Prepared test data, high level test Scenarios and Test cases

Personal Profile:

Father’s Name : R. Siva Kumar.

Date of Birth : 21st April 1990

Known Languages : Telugu, English, Hindi.

Passport Number : J9819321

PAN Number : AUUPR5466K

Permanent Address : H.No:3/157-2, New Bazaar,

Railway Kodur-516101,

Kadapa (Dist), Andhra Pradesh.

(R.HARISH KUMAR)

Contact this candidate