Chakri Manthena

Sr. QA Tester

571-***-****

Professional Summary:

•Over 7 years of experience in Quality Assurance in both Web based and Client/Server applications. Strong software testing background includes reviewing system Requirements, writing Test Plan and executing Test cases

•Solid experience in Manual Testing (Black box & White box) testing techniques which include integration, functional, system, regression, GUI and performance testing etc.

•Extensive experience in User Acceptance Testing, regression, integration, volume, regression and stress testing as well as development, execution, and maintenance of test plans, test specifications and test scenarios.

•Experienced in testing ETL Informatica applications with Autosys Job Scheduling tool.

•Responsible for cleansing the data from source systems reporting the data quality levels on system-by-system basis.

•Worked on various built in components like Database, Datasets, FTP, Sort, Partition and Validate.

•Involved in development of the transformations (Filters, Joins, Reformat the source data) using SQL’s and Informatica

•Experience in migrating the databases and developing shell scripts in UNIX.

•Well experienced in project software development lifecycle (SDLC) and System life cycle (SLC).

•Experienced in Testing Web Services for Web related Applications.

•Excellent experience in both Manual and Automation Testing.

•Experience in designing Test plans, Test Scenarios, Manual Test Cases Automated Test Scripts and UAT Design Documents

•Hands on experience in writing queries using SQL language.

•Experienced in coding Stored Procedures and Complex Queries for performance optimization

•Ability to work under pressure.

•Extensively used HP test tools like ALM, HP Quality Center and HP Quick Test Professional.

•Strong background in Oracle RDBMS, Data Warehousing, Data Modeling and advanced knowledge in ETL, DSS and Data warehousing.

•Easily adaptable to any new technologies and business environment.

•Excellent analytical, communication and problem-solving skills.

•Team player with excellent organizational skills to assess needs, set priorities and meet deadlines.

Technical Skills:

Programming Languages : SQL, PL/SQL, Shell Scripting(Korn Shell),

ETL : Informatica

Web Technology : JAVA, J2EE, ASP 2.0, VBSCRIPT, JAVASCRIPT, SQL, HTML and DHTML

Database : ORACLE, DB2 8.0, IMS, Oracle, MS Access and SQL Server

Testing Tools : Quality Center, Test Director, Quick Test Professional

GUI Tools :Developer 2000 (Forms 6i/5/4.5 & Reports 6i/3/2.5)

Operating Systems : UNIX, MS-DOS, WINDOWS 95/NT

Professional Experience:

TRowPrice, MD Oct'15 – Current

Sr QA Tester

T. Rowe Price is a global financial services firm offering individuals and institutions investment management guidance and expertise. It Provides retirement plan with exceptional services and extensive resources to help you prepare for a secure retirement. It also provides investment topics, including portfolio assessment and reallocation, fund comparison and selection, setting up IRAs and college savings accounts, and rolling over 401(k)s.

Responsibilities:

•Creating Test plan and Test Strategy as per the business requirements.

•Creating Test cases to satisfy all the positive and negative scenarios for the new enhancements and changing the regression test cases for end to end testing.

•Created Data mockup input files to satisfy all the conditions as per the requirements.

•Coordinated with source system users and monitored existing production ETL processes on a daily basis.

•Created simple/complex ETL mappings in Informatica using various transformations like Expression, Join,Filter etc

•Created SQL's for data mockups in tables and for doing data validations on the backend in Oracle Database.

•Extensively used Toad to verify records that has been populated by the process.

•Involved in Progression, Regression and Integration testing to cover all the Enhancements and End to End process.

•Tested the whole process from end to end by taking the mainframe files as input and populating results in the Oracle Database.

•Worked with Job Scheduler to schedule the jobs to run in the test environments.

•Experienced in working with clear quest for creating defects and as defect-tracking tool to keep track of defects during the testing process.

•Experienced working with ALM to create all the test cases.

Environment: Informatica 9.6, Oracle 11g, SQL Server 2005, DB2, ALM,Clear Quest, Unix, TOAD, Windows.

LSG Sky Chefs, NC Feb’14 – Sep'15

SrQA Tester

LSG Sky Chefs is the brand name of LSG Lufthansa Service Holding AG, which is the world's largest provider of airline catering and in-flight services. Its primary business function is to prepare and deliver meals, beverages and snacks to aircraft for domestic and international flights. In addition the company also provides extended services on all other aspects of in-flight service, including the design and sourcing of in-flight equipment, in-flight logistics, in-flight management, onboard retail management and the management of airport lounges to name but a few. LSGRIDW is the EDW built for the enterprise with various data marts for each subject area. The project business requirements need is to load various airlines on board sales into LSGRIDW. BI team built an automated Retail Intelligence solution to integrate all airlines data into LSGRIDW data model.

Responsibilities:

•Analyzing the Business Requirements and specifications from different users.

•Creating Test plan and Test Strategy as per the business requirements.

•Creating Test cases to satisfy all the positive and negative scenarios for the new enhancements and changing the regression test cases for end to end testing.

•Creating XML files with new data points as per the new requirements and creating Test Case files and Input Excel files.

•Coordinated with source system users and monitored existing production ETL processes on a daily basis.

•Created simple/complex ETL mappings in Informatica using various transformations like Expression, Source.

•Tested the Frontend page web services to verify the rules that got set as per the business requirements.

•Tested Web Specific related like Browser compatibility, Operating System Compatibility, Navigation, Links, Images, Online forms etc.

•Created Automated ETL feed workflow jobs incorporating all the event waits, command, session, decision tasks andmaking sure all the dependencies defined in the ETL process flow document are covered.

•Extracted data from heterogeneous sources like Flat Files, Oracle, SQl Server, SAP-BW,TIBCO, ESB Web services and XML files.

•Extensively usedToad to verify records that has been populated by the process.

•Experienced in wring complex SQL’s for data mockup to cover all the Business Requirements for both positive and negative scenarios.

•Translate business-reporting requirements into data warehouse architectural designs andanalyzing source and target data models and makes necessary changes.

•Involved in Progression, Regression and Integration testing to cover all the Enhancements and End to End process.

•Worked with Job Scheduler to schedule the jobs to run in the test and acceptance environments.

•Experienced in working with clear quest for creating defects and as defect-tracking tool to keep track of defects during the testing process.

•Experienced working with ALM to create all the test cases.

Environment: Informatica 9.5, Oracle 11g, SQL Server 2005, ALM,Clear Quest, Unix, TOAD, Windows.

JP Morgan Chase, Wilmington, DE Jul’13 – Jan’14

ETL Tester.

The data warehouse brings multiple sources together in a form that permits cross-function analysis. Management reports and Ad hoc reports are generated from data mart to provide more flexible analysis

Responsibilities:

•Analyzed and reviewed Business and System requirements and participated in walk-through, and user group meetings.

•Create and Update Test plans, Test Cases, and Test Scenarios corresponding to the test requirements in order to maximize test coverage of system requirements.

•Responsible for managing the entire QA documentation using ALM tool and well versed with all the modules of ALM.

•Conducted Test Case review meetings with Team members and Business Users.

•Involved in different Phases of Testing effort including Shakeout, System Integration, Re-Testing and Regression Testing.

•Involved in extensive DATA validation using SQLqueries and back-end testing for the data movement from upstream systems into the CMIF database tables.

•Using TOAD Software for querying ORACLE and Using MS SQL Server Management Studio for querying SQL SERVER.

•Involve in executing Autosys Jobs and verify logs for job failures and make sure the master jobs complete successfully.

•Created test cases for the Automation Framework to validate large volume of data.

•Involved in setting up the source test data in various formats like .dat file, .ctl file & databases from where the system gets the data from the source location in to the environment.

•Worked extensively with XML files.

•Validating the staging tables with the source data from which the data transferred to the environment.

•Documented all the bugs detected in ALM for tracking and reporting, also followed up with development team to verify bug fixes, and update bug status.

•Interacted with Business, Development and SIT and UAT teams to ensure overall quality of the software.

•Used WinSCPto upload the files to server foldersand PUTTY to execute the Shell Script.

•Used ClearQuest (ICart) for Code deploy approvals and as well as weekly status updates in QMS.

•Involved in preparing documents including Risk-Based Test Matrix, Release Level Metrics, Maturity Metrics, Traceability Matrixdocuments.

Environment: UNIX, Putty, WinSCP, Autosys R11, Toad 9.5, SQL Server 10.0, Remedy Client, Oracle 11g, ALM 11.0, ClearQuest 7.1.1.9, Doors, JAVA.

AT&T Service Inc., San Ramon, CA Jan’11 – Jun’13

Test Engineer

AT&T Inc. provides telecommunication products and services to consumers, businesses and other telecommunication service providers under the AT&T brand worldwide. ADOPT-Hosting is a sales tracking, design, price, propose, contracting, and data repository application for Enterprise Hosting.

•Analyzed Software Requirement specifications (SRS) and reviewed the requirements.

•Identify the Test Scenarios and Developed Test Cases and Reviewed Test Cases as per the requirements.

•Executed all Test cases in different phases of testing like GUI Testing, Functional, Regression, Integration, System and User Acceptance Testing.

•Prepared the test data for positive and negative testing for executing the test cases.

•Involved in the preparation of Traceability Matrix document.

•Used Quality center tool to write the Test cases, Execute the Test cases, Defect Tracking and Defect Reporting.

•Involved in Defect review meetings with developers to discuss on critical issues.

•Involved in Back end testing to validate the back end data and compare the front end data and executed SQL queries.

•Responsible for writing SQL Queries to find out that the data is correctly populated in each field

•Prepared Test Summary Reports, Bug database and generated monthly reports.

Environment: Java, J2EE, Java Script, Quality Center, Oracle, MS Office, HTML.

CITI Group, NY Aug’09 – Dec’10

QA Analyst

Citigroup is the first financial services company to bring together Banking, Insurance, and Investments under one umbrella, The Project PROFILE - Profile for Windows (PFW) and FMS applications provide a comprehensive set of functionality for financial institution. Institutions deliver their services through a multitude delivery channels. Traditionally, branch offices functioned as the primary place of service delivery.

Responsibilities:

Responsibilities:

•Prepared Test Plan, Test Scenarios and Test Scripts as per functional, Business requirements using Quality center, and developed the Test Cases using Software specifications.

•Participated in the Bug review meetings and Bug Triage meetings.

•Conducted Browser compatibility testing using different browsers.

•Executed UAT test cases and procedures on different application build versions Responsible for defect management includes, defect logging, defect tracking, defect triaging and defect closure.

•Using Quality center to manage the requirements, test scripts and also defects.

•Developed SQL Queries to check data validity and database Integrity.

•Responsible for writing SQL Queries to find out that the data is correctly populated in each field.

•Involved in modifying UNIX scripts using commands and as per the requirements.

•Participated in end to end UAT testing of the application

•Used SQL’s for data mockup as per the Business requirements to cover all positive and negative scenarios.

•Working with Job Scheduler to schedule the jobs to run in the test and acceptance environments.

•Involved in preparing the Test cases for System Test plan on Release basis.

•Involved in Functional and Regression Testing for both System and UAT environment

Environment: Oracle 8i, TOAD, SQL, PL/SQL, SQL *Loader, Windows NT, Unix, Clear Quest, Clear Case, HP Quality Center

Sun Life Financial, Cranford, NJ Mar ’08 – Jul ’09

QA Tester

There are a number of systems in this project called Life System (LS), Auto System (AS), Property System (PS) and Transportation System (TS). Worked on Life System and on recently developed Annual Maintenance Charge (AMC) module to reduce the Maintenance Charge. This module will be called by a number of applications in the Life System. This module includes both maintenance and development related work.

Responsibilities:

•Study of Business and Design Specifications

•Responsible for writing Test Plans and Test Cases

•Analyzing the Impacted programs

•Preparation of Functional and Regression Test Cases and Testing the code

•Experienced in coding DB2 queries and Stored Procedures

•Self & Peer Reviews for Code & Test cases

•Involved in Integration and System Testing

•Used Test Director for tracking and documenting the defects

•Actively involved in fixing defects which involves changing the programs and other parameters

•Production Support through internal tools

Environment: UNIX, ES 9000, MVS, DB2, SQL, PL/SQL, JCL, MQ Series, Test Director.

Contact this candidate