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.

PROFESSIONAL EXPERIENCE

Confidential, Bellevue WA

Business System Analyst

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

Confidential, Bellevue WA

Functional Consultant (Oracle)

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

Confidential, Fremont CA

Quality Analyst/Functional Analyst (Oracle)

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

Confidential, San Jose, CA

QA Analyst(Oracle)

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.

Confidential, Nashville, TN

Functional Analyst(Oracle)

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.

Confidential, Tacoma, WA

Business System Analyst/ETL Tester

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