Kruthi Gandra

ac3b7e@r.postjobfree.com 425-***-****

Oracle QA/Functional / Testing Lead / Support

SUMMARY

Have 7+ years of diversified experience in Quality Assurance (QA), UAT, BI Reporting, ETL Testing & Oracle Functional in Oracle e-Business Suite 11i and R12

Worked as a Business / Functional Analyst, Quality, UAT Analyst Lead & BI Report Testing.

Well experienced with Application tools SQL Developer, Data Loader, ADI & Web ADI.

On daily basis working with Business Users/Analysts, leads to gather information about new requirements, process improvements, providing solution to complex issues, preparing test plan, test scripts, assess quality of solution deliverable.

Good Experience in Data Modelling, Data Mining/Data Warehouse.

Working knowledge of Test planning for Manual Testing, Integration Testing (SIT), User Acceptance Testing (UAT), ETL Testing & Performance Testing.

Hands on experience in Smoke Testing, Integration/System, Functional, Regression, User Acceptance Testing (UAT), Performance and Cross browsing testing.

QA/UA Testing experience using Waterfall and Agile Methodologies.

Functionally proficient in module designing, interfaces and reports, data mapping, data conversion, fit/gap analysis, testing, reporting and documentation based on organizational needs.

Proven skills in training and communicating with HR business users during the support.

Expertise in Testing tools and defect management tools – HP Quality Center, Test Link, JIRA, Service Now etc.

Expert in creating test data from front-end systems like POS, CSM, TMAG, Quick View etc.

Possess good knowledge of business process, transactional components and backend database.

Good understanding of Accounting Principles, US GAAP and business flows.

Worked in Release Support – Release to QA, involved in environmental setup, testing the release process.

Worked on Data Conversions from Legacy system to Oracle using Web ADI and standard interface.

Comprehensive knowledge of Software Development Life Cycle(SDLC).

Good Knowledge of Tableau software Reporting tool.

Experienced team player with good communication, interpersonal, analytical and problem solving skills.

Educational Qualifications

Master’s in Business Administration with majors in Finance – JNTU University, India

Work experience:

Project 1:

Client: T-Mobile, Bellevue WA Oct2016–Current

Business System Analyst (UAT Lead)

As America's Un-carrier, T-Mobile US, Inc. is redefining the way consumers and businesses buy wireless services through leading product and service innovation. The Company's advanced nationwide 4G LTE network delivers outstanding wireless experiences to 72.6 million customers who are unwilling to compromise on quality and value. Based in Bellevue, Washington, T-Mobile US provides services through its subsidiaries and operates its flagship brands, T-Mobile and MetroPCS.

Responsibilities

Worked as Systems Analyst Lead, responsible for test process analysis and identified system requirements on Revenue Recognition Project.

Gathered all requirements from Business and supported for UAT testing with test plan, test cases design and test execution using HP Quality Center.

Daily status call with Deck presentation to Business to understand the undergoing of test efforts.

Good experience in BI Reports Testing by using MyInsight(SAP) tool.

Expert in AdHoc Universe Testing in Web-Intelligence SAP.

Worked in UAT testing team on issue clarifications & resolution.

Worked on Revenue Calculations with new GUI (Aptitude) System (ARRE).

Prepared Expected Results with Journal Entry Validations for all different scenarios used to calculate Revenue.

Testing KPI’s as per the business

Expertise in Test Planning, Test Schedules, Test scope documents.

Conducted trainings for test team and development teams on Functionality process flows.

Defect Management engaging in discussion & clarifications on issues with Development teams

Captured and tested all modifications to proposed functional requirements.

Working closely with Business to understand the requirements on the BI Reports.

Offered Feedback and Suggestions to Developers while building BI Reports.

Worked on creating test data from front-end systems like POS, CSM, TMAG, Quick View, My TMO, Web etc using different credit card payments in Test Environment.

Good knowledge on SQL with running queries in Teradata, Oracle SQL Developer & TOAD and knowledge of understanding the technical design document.

Created Grid Reports, Graph Reports, Drill down and Drill through Reports

Scheduled periodic refreshes of reports using Scheduler

Optimized queries for better performance of the reports.

Environment: HP Quality Center 12.01, PL/SQL, Oracle 11g, SQL Developer, Teradata SQL Assistant V15, My Insight(SAP BI), Tableau, UNIX, ERICSON Billing System(BSCS) & SAMSON Billing System

Project 2

Client: Expedia, Bellevue WA Mar2014-Jun2015

Functional Consultant (Oracle)

Collectively, the Expedia brands cover virtually every aspect of researching, planning, and booking travel, from choosing the best airplane seat, to reading personal travel reviews of hotels, to planning what to do in a destination once you arrive. The Expedia portfolio serves both leisure and business travelers with tastes and budgets ranging from modest to luxury.

Responsibilities

Worked as a Functional consultant, responsible for analysis of all enhancement requests, feasibility study, suggest workaround’s, provide estimates etc.

Worked on Production support, solving issues by using JIRA defect tool.

Did first round of UAT Testing after QA passed.

Managed business requirement mappings and definitions.

Worked on Defects by contacting Oracle Support on daily basis.

Resolved period end and year end closing issues.

Worked on Concur Inbound (Integration) Testing and supported the application of all expenses of employees.

Test planning, Preparing test scripts, System Integration Testing (SIT), User Acceptance Testing. Test Oracle forms WebUIs.

Test Management, coordinate testing, report testing status, resolving issues.

Design and implement robust, scalable, and high quality Test automation suites, to improve quality and productivity of functional and regression tests.

Work closely with the business partners and drive the UAT cycles.

Developed Test Matrix to give a better view of Testing Effort.

Extensive Knowledge of QA methodologies and SDLC standards.

Organizing Review Issue Log meetings, weekly FIT (Financial Improvement and transformation) meetings. Responsible for Daily, Weekly and Monthly Activity Sheets, Issue logs, Status Reports.

Determined the cause of the issue and give best possible solution possible online.

Prepared knowledge base documents for issues with solutions.

Environment: Oracle apps 12.1.3 P2P, SQL * PLUS, PL/SQL, Oracle 9i & TOAD, JIRA, Test Lync

Project 2

Client: Logitech, Fremont CA Mar2013-Feb2014

Quality Analyst/Functional Analyst (Oracle)

Logitech Designs mainly focused on innovation and quality, Logitech designs personal peripherals to help people enjoy a better experience with the digital world. It became the worldwide leader in computer mice, and have reinvented the mouse in dozens of ways to match the evolving needs of PC and laptop users.

Responsibilities

As a Quality Analyst worked on 11i to R12 Upgrade, Production support and Quality Analyst for all modules.

Created Test documents, Test scripts, Test scenarios during the UAT phase.

Worked with the users to demonstrate that the deployed product is proactive and responsive to the needs of the users.

Understanding and analyzing the Business functionality of exiting system of financial system.

Preparing DFDs (Data Flow Diagrams) for the existing system and oracle 12.1.3

Prepared Business Documents for the requirement gatherings

Analyzing the gap between the existing system and Oracle Release 12.1.3

Preparing design documents for all customizations required in the oracle 11i for meeting the business requirement.

Actively involved with users in user acceptance testing (UAT)

Preparing Functional documents for strategies of conversion

Functionally assisting the technical team at offshore, with the various aspects of functionality of the project and the client requirement

Used ADI extensively for GL and FA module.

Comprehensive knowledge of Software Development Life Cycle(SDLC).

Good command over fixed assets process flow in regards to PO, AP, i-Procurement modules

Very good in troubleshooting mass additions, troubleshooting issues etc.

Worked in delivery of Change request or Defects coming in Production support phase of the project.

Developed Test Plan and Test scripts to validate complex approval rules. For example a purchase order approval may be based on its overall value or individual order lines, which may be approved by different approvers depending upon the product code or type.

Responsible for month close process.

Worked on various issues of upgrade for i-Procurement, i-Supplier & FA data migrations from 11i to R12.

Created new end-to-end processes for Procure-to-Pay for accurate purchase order creation.

Environment: Oracle e-business Suite 12.1.3, SQL/PL-SQL, SQL Developer, Windows XP & Load Runner

Project 3

Client : SunPower Corporation, San Jose, CA Oct2011-Mar2013

QA Analyst(Oracle)

SunPower Corporation designs and manufactures high-efficiency crystalline silicon photovoltaic cells, roof tiles and solar panels based on a silicon all-back-contact solar cell invented at Stanford University.

Responsibilities:

Responsible for Quality Assurance Testing for all business process integrated with each system.

Worked in Test planning for Manual Testing, Integration Testing (SIT), User Acceptance Testing (UAT) & Performance Testing.

Hands on experience in Smoke Testing, Integration/System, Functional, Regression, User Acceptance Testing (UAT), Performance and Cross browsing testing.

Expertise in Testing tools and defect management tools – HP Quality Center, Test Link, JIRA, Service Now etc.

Good Experience in Waterfall and Agile Methodologies.

Good understanding with BI Reports Testing.

Involved in Release Support – Release to QA, involved in environmental setup, testing the release process.

Comprehensive knowledge of Software Development Life Cycle(SDLC).

Good Knowledge of Tableau software Reporting tool.

Tested all the asset Key flex fields also tested Defined Corporate and Tax asset books and set up depreciation methods, conventions and defaults.

Creation and Execution of the Test Scripts for BR Change Requests.

Environment: SQL/PL-SQL, SQL Developer, Windows XP & Data Loader, HP Quality Center, JIRA, TOAD.

Project 4

Cummins Business Services, Nashville, TN Nov2009-Oct2011

Role: Functional Analyst(Oracle)

Cummins Inc., a global power leader, is a corporation of complementary business units that design, manufacture, distribute and service engines and related technologies, including fuel systems, controls, air handling, filtration, emission solutions and electrical power generation systems. Headquartered in Columbus, Indiana, (USA) Cummins serves customers in approximately 190 countries and territories through a network of more than 500 company-owned and independent distributor locations and approximately 5,200 dealer locations

Responsibilities:

Analyze design, customize, configure and test implement detailed Oracle applications and modules including AR, AP

Participated in the Conference Room Pilot sessions to interact with users to analyze the business process and identify the gaps.

Created Test scripts and for Enhancements and Customization.

Worked on Enhancements and Customization requests for Oracle Payables, Oracle Purchasing, I-Procurement and Oracle Assets.

Participated and documented the requirement gathering sessions and analyzed the impact of the changes.

Gather, manage and document functional requirements for technical customization including workflows and scripting.

Defined the Functional specifications for setups and reports and transformed the specifications to the Technical Team.

Work with the business architect and other planners to assess current capabilities and identify high-level requirements.

Identified the business requirements which need to be handled by the customizations and did the necessary analysis along with a technical resource.

Assist with functional configurations, implementations, and production support activities; Perform system configuration required to satisfy requests from end-users for fixes, changes, and enhancements to financial/accounting management functionality.

Involved in Regression testing for AP, Pay Terms in Procure-to-Pay(P2P).

Designed and prepared MD50 for customization of interface to load Journals for Reconciliation.

Environment: PL/SQL, SQL, SQL * Plus, Oracle 9i, TOAD, UNIX, SQL Developer, Teradata SQL Assistant V15.

Project 5

Trinity Glass, Tacoma, WA Jul2008-Nov2009

Business System Analyst/ETL Tester

Trinity Glass is a leading manufacturer of exterior doors, interior doors and patio doors.

Responsibilities

As a Business Systems Analyst, worked on gathering all requirements from Business and documenting for review with stake holders.

Direct interaction with end users for problem solving

Created and maintained

Submit Auto Invoice Import program to import data in the interface tables.

Created clearing and reconciling bank statement with Payables and Receivables

Guided technical team in redefining the custom reports

Created ETL test data for all ETL mapping rules to test the functionality of the Informatica graphs.

Tested the ETL Integration process, ETL Jobs as per business rules using ETL design document.

Test case execution and AdHoc Testing.

Experience in SDLC and Agile Methodologies such as SCRUM.

Used HP Quality Center for storing, maintaining the test repository, bug tracking and reporting.

Handled issues iExpenses and imported expense reports successfully

Solved the currency problem for freight in the invoice transaction.

Handling Auto reconciliation issues in CM (Cash management)

Gathered all requirements from Business and supported for UAT testing with test plan, test cases design and test execution using HP Quality Center.

Assisted UAT testing team on issue clarifications & resolution.

Expertise in Test Planning, Test Schedules, Test scope documents.

Captured and tested all modifications to proposed functional requirements.

Environment: Oracle apps 11.5.5, Windows 2000/XP, SQL, SQL* Plus, HP Quality Center

Contact this candidate