We provide IT Staff Augmentation Services!

Qa Analyst Resume

CA

Summary

  • Over Eight (8) years of extensive and progressive experience in Design, Development and Testing with an earned reputation for meeting strict deadlines and delivering mission critical solutions on time and within budget.
  • Remarkable experience in Software Testing Life Cycle (STLC).
  • Having strong knowledge on SOA architecture.
  • Good functional knowledge on financial accounting and business processes
  • Expert in planning and executing Black box testing and White box testing.
  • Specialized in development of Test Plans, writing Test Cases and creating & enhancing Test scripts.
  • Extensive work experience performing Web, Custom, and Client/Server applications testing.
  • Participated in the teams through design, implementation, testing and launching of the software.
  • Extensively used SQL and PL/SQL to interact with Oracle database.
  • Expert in Manual Testing and Automation Testing using Mercury Interactive Tools such as Test Director, Quality Center, Quick Test Professional and Load Runner.
  • Involved in Project Planning, Coordination and implementing various QA methodologies.
  • Expert in planning and executing Functional Testing, Integration Testing, System Testing, Regression Testing, Backend Testing and User Acceptance testing.
  • Expert using Test Director for Defect Management Process and Creating Test Cases.
  • Strong working experience in Windows and UNIX environments.
  • At ease in high stress environments requiring superior ability to effectively handle multi-task levels of responsibility.
  • Excellent communicative, interpersonal, intuitive, analysis and leadership skills.
  • Proven ability to work efficiently in both independent and teamwork environments.

TECHNICAL SKILLS

Languages: C/C++, VB , J2EE, SQL, PL/SQL, ASP, .Net Operating System: UNIX, Linux, Microsoft Windows 95/98/00/NT/XP RDBMS: Oracle 8i, 9i, 10g, SQL Developers, SQL Server, SQL Navigator, MS Access Defect Mgmt Tools: Mercury Quality Center, Test Director Tools: MS Office, MS Front Page, Visio Rational Rose, Rational Tools Automation Tools: Mercury QTP, Win Runner, Load Runner ERP: Oracle Apps11i (GL, AP, AR, OM, PO, INV, FA), SAP Financials Web Technologies: Java Script, HTML, DHTML, XML

EXPERIENCE

Client: Confidential, CA Mar 2008 - Current Project Name: TAXPRO - BEDROCK IMPACT Description Confidential has a major initiate to upgrade the Oracle ERP systems from 11i to R12. As part of this initiate it also launched some other sub-initiatives which had an impact on the TAXPRO system which is a downstream system to Oracle ERP and the custom cost-plus system. Following are the sub-initiatives which impacted TAXPRO as a downstream system

  • Merging of two instances in one instance
  • Migrating the custom cost-plus system into third party Virtual Trader

The whole set of initiates were code named as Bedrock. TAXPRO which generates several reports like Segmented P/L, WWPBT, M14, 956 computation summaries is impacted due this Bedrock initiative. The data extract programs and computations of TAXPRO are required to be adjusted and all the flows and computations of TAXPRO were required to test.

Role: QA Analyst

Responsibilities:

Due to my prior experience of TAXPRO during actual development phase and knowledge of Cisco GL local and consolidation process, AP and AR I have also partly played the role of analyst thus preparing some requirement document portions. Below is the summary of responsibilities.

  • Analyze the difference in GL tables from 11i to R12. Capture the differences and provide the knowledge to IT team helping them to create an impact analysis and estimations
  • Study the differences between custom Cost-plus system and Virtual Trader and capture the differences and get sign-off from business on the change document
  • Participate in design reviews, provide review comments and ensure that the comments get incorporated to design specifications
  • Worked with Test Tracking Software package tools to track the defects opened
  • Scripts using java programs and tested the performance of the Multi Foreign Tax web based applications, 956 payables applications and Tax Account Analysis applications.
  • Review the data extract SQL statements written for R12
  • Prepare estimations and plans for testing
  • Used Quick Test Professional (version QTP 9.5) for the functionality of the application to automate the regression testing.
  • Use QA tools like Quality center to execute the test scripts
  • Involved in Load testing using the tool to test the performance of the application.
  • Work with business users to meet the execution metrics for each test cycle
  • Preparation of SQL Queries to fetch data from Virtual Trader and Oracle R12 and perform reconciliations against reports generated in Tax Provision Project
  • Extensively used VLOOKUPS, Macros for data and the report reconciliations
  • Regression testing and functional testing of modules Multi Foreign Tax, Tax Account Analysis, 956 Payables, BV/State Preparation, and Intercompany Interest Report during the Bedrock release Q2FY10.

Technologies: Oracle R12, JAVA/J2EE, Java Script, PL/SQL, SQL, Quality Center, TOAD, Cost Plus System, VT Application, SI and Windows XP.

Project Name: TAXPRO Description

TAXPRO is a customized solution which extracts data from several systems like Oracle ERP, Systems Integrator (SI), and Cost-plus. This application has several flows as below.

  • Admin flow which helps to perform system administration activities like creating users, assigning roles, role-screen mapping to name a few
  • Data extract flow which extracts data from upstream systems into TAXPRO database tables
  • 956 Payables which creates the 956 computation summary report based on mortgage loans provided by foreign entities to US entities
  • BV/State which creates the Segmented P/L, trial balance and account analysis report of US and Netherlands entities which are Cisco manufacturing entities
  • MFT which creates the Segmented P/L, account analysis and WWPBT and several reconciliation reports for worldwide foreign entities which are service providing entities

All the flows are based on Oracle 11i, SQL, PL/SQL and J2EE.

Role: QA Analyst

Responsibilities:

  • Analysis of Business Requirements.
  • Design and create test scenarios, Preparation of test plans, Preparation of test cases, execution of test cases and log defects
  • Used Quick Test Professional (version QTP 9.5) for the functionality of the application to automate the regression testing.
  • Experience with test tracking software tools and assigned the defects to IT and once fixed needs to test them again
  • Involved in Load testing using the tool to test the performance of the application.
  • Use QA tools like Quality center to execute the test scripts
  • Work with business users to meet the execution metrics for each test cycle
  • Debug defects found and retest as needed
  • Preparation of SQL Queries to fetch data from ERP and perform reconciliations against reports generated in Tax Provision Project
  • Production support to users and provide access as requested to the application and maintaining administration screens
  • Creation of alliance case as requested by the users issues or enhancements and analyze the issue and work with IT to fix the issue and deploy the fixes into production during deployment time.
  • Maintaining user access list, documents related to the deployments items, templates related to the application time to time in live link location
  • Production support for the applications Multi Foreign Tax, Tax Account Analysis, 956 Payables, BV/State Modules
  • Extensively used VLOOKUPS, Macros for data and the report reconciliations

Technologies: Oracle 11i, JAVA, PL/SQL, SQL, Quality Center, TOAD, Cost Plus System, VT Application, SI and Windows XP.

Client: Confidential, CA Jan 2007 - Feb 2008

Project Name: KWC Finance Implementation

Description Kyocera Wireless Corporation (KWC), which is fully owned subsidiary of Confidential., is engaged in the development of CDMA wireless handsets. Confidential is actively involved into Software Engineering, Product Testing and Research & Development activities in India.

Role: QA Analyst

Responsibilities

  • Analysis of Business requirements
  • Involved in creating test scenarios, test cases, coding standards for TSL, Win Runner test scripts.
  • Preparation of documents for the Win Runner test script recording, Win Runner script tuning, breakpoints, exceptions & checkpoint implementation.
  • Creation of a generic Win Runner script for different test conditions and implementing exception handling within the scripts. Also worked for modularization and parameterization of the scripts to make them scalable and reusable.
  • Created test Script in Quick Test Professional for Functional Testing
  • Created data driven test through QTP.
  • Performed and Coordinated User Acceptance Test according (UAT) as per the package requirement.
  • Creation of test plan, acceptance test plan.
  • Executed test cases using scripts ,along with manual testing
  • Reporting and verification of bugs
  • Wrote complicated SQL queries and extensively executed SQL queries to ensure data integrity throughout the database.
  • Loaded data into oracle table using SQL Loader from Legacy Systems to Current System.
  • Involved in writing Unix Shell Scripts for data transferring purposes.
  • Developed and executed procedures, functions and triggers using PL/SQL
  • Submitted the bugs using bug tracking tool Test Director.

Technologies: Oracle 11i, PL/SQL, SQL, JAVA, Quality Center, QTP, Remedy and Windows 2000.

Confidential, IL Mar 06 - Dec 06 QA Analyst

  • Tested the chart of accounts creation, currencies, calendars created as per the data given by the client and preparing the test documents as per the validation did across the set of books
  • Having strong knowledge in Oracle to create SQL Scripting, Procedures, Functions and Packages
  • Tested the procure pay(P2P) and Order to Cash(O2C) cycles for validating transactions
  • Validating the invoices in account payable modules with the purchase orders made in oracle purchasing module
  • Tested the workbooks, folders in Oracle Discoverer and Validate the reports in Discoverer
  • Testing the forms developed and validate the forms as per the data given with by the client
  • Checked the multi org setup of oracle applications implemented
  • Validating the reports data by checking them in front end and writing querys to check the proper output of the report
  • Worked on Black box testing by running manual as well as automated tests including regression.
  • Having a good functional knowledge in the modules GL, AP, AR modules
  • Involved in requirements gathering of the modules GL, AP, AR

Environment: Oracle 11i, (GL, AR, OM, Inventory) Test Director, Manual Testing, ASP, VB script, IIS 5.0, HTML, Oracle, Windows NT

Confidential, Irvine, CA Jan 2005-Feb 2006 QA Tester

  • Worked on Payables Open Interface Import to Test invoices from external systems into AP Invoice tables.
  • Responsible for documenting the mapping and requirements for the interfaces and conversions between the source and oracle Applications.
  • Tested a package to import expense information into Oracle Payables.
  • Involved in Validating some Custom reports and Forms for the end users to check the details and errors.
  • Analyzed the Business and System Requirements for various modules of the application.
  • Involved in both Manual and Automated Testing.
  • Developed Automated TSL Scripts for GUI and Functional Testing and maintained set of re-usable scripts.
  • Executing Test Cases as per Test Plan.
  • Parameterized the scripts and enhanced them according to the test cases.
  • Created User Defined Functions and incorporated Descriptive Programming, thus making the script reusable and also convenient to be used by anybody in the team.
  • Documented and Communicated Test Results and Bugs using Test Director 7.0.
  • Used SQL to perform Date Integrity Test and to verify the data.
  • Participated in the Unit and Integration Testing along with the end-users

Environment: Oracle 11i,( GL, AP, OM, Alerts) Quick Test Pro, Test Director, Manual Testing, Java, Oracle, Unix.

Confidential, Jacksonville, FL Aug 2004 - Dec 2004 QA Tester

  • Involved in setting up the cross validation rules.
  • Converted User Requirements into formal Functional specifications and Interfacing with client
  • Tested mapping documents for the columns of source application and oracle applications
  • Developed Test Plans and tested the application to ensure proper functionality, data accuracy, and that modifications have no adverse Impact on integrated system environment
  • Involved in automated testing using Quick Test Professional and Test Director
  • Involved in Regression Testing, Functional Testing and Integration Testing
  • Executed test cases and logged the defects using Test Director.
  • Actively participated in Defect Review Board Meetings to verify and review various defects logged.
  • Involved in backend testing using SQL.
  • Attended the Requirement and Status Meetings.
  • Worked closely with program developers to ensure that the application development met the user expectations

Environment: Oracle 11i,( GL, AP, OM) Quick Test Pro, Test Director, TSL, ASP.net, C#, IIS 6.0, TOAD, SQL, JavaScript, HTML, XML, Windows 2003

Client: Confidential, India Dec 2003 - Jul 2004

Project Name: GE Leads Role: QA Analyst

Responsibilities:

  • Involved in creating Test Plan using Business Transaction rules, Test Cases and writing Test Specifications and Data Validations.
  • Interacted with end users in collecting functional requirements for the application
  • Performed functionality, usability and regression testing using manual testing methods.
  • Coordinated the User Acceptance Testing efforts.
  • Tested the application manually for its GUI objects and their functionality and reported the bugs using an in-house tool.
  • Developed Test Plans for System, Regression, Integration and UAT testing.
  • Validated data using SQL
  • Involved in developing scenarios of testing and maintaining testing standards
  • Participated in developing and implementing End-End testing manually.
  • Coordinating between QA Manager, Developers and Team Members
  • Assisted Team members in knowledge transfer
  • Involved in Regression & Alpha / Beta Tests.
  • Participated in regression testing after each build
  • Conducted defect review meetings with the team members
  • Involved in Production System Validation

Environment: Java, J2EE, Web Logic 7.0, SQL, Visio, Oracle, TOAD, Cayman Defect tracking.

Confidential, India Aug 2002 - Dec 2003 QA Analyst

  • Creating the detailed test plans, test cases and executing it.
  • Developing test plan and test cases using web tracker.
  • Implementing the test case and test process with project time frames.
  • Manually testing functionality of web based application.
  • Comparing clients live site with development sites.
  • Testing text, navigation bar, links, and design.
  • Testing functionality o browser as well such as Internet Explorer with Netscape 6.2
  • Performing Black Box and Regression Testing.
  • Report and assign bugs using web tracker.
  • Doing cross browser testing.
  • Manually testing the application.
  • Shopping cart testing

Environment: Windows 2000 Professional, HTML, Asp, C++ and Java Script.

Confidential, India Dec 2001 - Jul 2002 Oracle Developer

  • Created Tables, Views, Indexes, Sequences, Constraints
  • Created Procedures, Functions, Packages
  • Loading data into tables using SQL*Loader
  • Worked on Performance Tuning and Improve the Performance of the Database
  • Developing and Customization of Oracle Reports
  • Performing Black Box and Regression Testing
  • Manually testing the application

Environment: MS Access, SQL* Plus, PL/SQL, Oracle7.i, UNIX, Windows NT/2000/98.

EDUCATION

  • Master of Computer Applications (MCA)
  • B.Sc

Hire Now