We provide IT Staff Augmentation Services!

Oracle Cloud Analyst Resume

Alpharetta, GA

EXPERIENCE SUMMARY:

  • A SCM/Finance Functional and Test Analyst with specialization in Financials and Distribution Systems having around 7+ years of industry experience which revolves around Oracle ERP Applications Implementation, Support and Upgrade and has also worked on successful e - business suite implementations (Oracle EBS 11.5.10/R12).
  • Hands on experience with all phases of Software Development Life Cycle. Involved in entire QA Life Cycle, which includes Designing, Developing and Execution of the entire QA Process and Documentation of Test Strategy, Test Plans, Test Cases, Test Procedures and Test Scripts for ERP Applications, Java/J2EE, Web based and Client/Server applications.
  • Extensive experience with MS Visual Studious Test Suite.
  • Experience in Testing involved in Unit Testing, Functional Testing, Performance Testing and Regression Testing
  • Extensive experience with Oracle Application Testing Suite (OATS).
  • Conversant with Oracle Financials modules and Distribution Modules - Quoting, Advance Pricing, OM, INV, Costing, Purchasing, i-Procurement, AP, INV, GL.
  • Understands both the "Quote to Cash" process as well as the "Procure to Pay" process. Conversant with Configuring Oracle Application modules as well as understands the underlying schema, which gives her a better insight into converting user requirements into functional and technical specifications.
  • Actively responsible for testing of the functionality of Oracle ERP Application Well conversant with documentation as per the AIM methodology, involved Conference Room Pilots and User Acceptance Testing.
  • Well-rounded knowledge of Oracle Applications functionality.
  • Expertise in writing SQL Queries, SQL *PLUS, PLSQL stored procedures for databases.
  • Experience in Data-driven testing and writing SQL queries for database manipulations.
  • Possesses excellent Communication, Presentation, analytical, Interpersonal and Coordinating skills to work and interact in Team Environment.

TECHNICAL SKILLS:

SDLC: Iterative, Agile, Waterfall

QA Tools: Quality Center, Test Director

ETL Tools: Ab Initio 2.x

Operating Systems: Microsoft Windows - Vista, XP, 2000, NT 4.0, OS/2UNIX - Sun Solaris, HP-UX

Databases: Oracle: 10g, 9i, 8i, Microsoft: MS Access, SQL Server 2005/2008, Teradata

Languages: SQL, PL/SQL, UNIX Shell Scripts.

PROFESSIONAL EXPERIENCE:

Confidential, Alpharetta, GA

Oracle Cloud Analyst

Responsibilities:

  • Involved in sprint and walkthrough meetings to go through the business requirements and understand the scope of the project.
  • Participated in sprint planning meeting with business analyst, product owners to discuss high level test scenarios.
  • Worked on test data for positive and negative test scenarios for Functional Testing as documented in the test plan.
  • Involved in testing Conversion (FBDL, Spreadsheet, HDL), Report, Roles User and Minor page personalization’s.
  • Worked on outbound integration process such as customer outbound integration, store sales outbound integration and vendor outbound integration.
  • And inbound integration process such as Domestic AR Invoices, International Invoices and pretty good understanding of sales adjustments upload to AR portal i.e. AR invoices manual upload to AR portal
  • Good understanding on Testing AR Portal Extension’s Billing Process that in corporate the use of several tables. Having good idea on TC Architecture and setups. Good command on executing the custom processes.
  • Implemented Regression test while bug scrubbing for the bugs that were no longer valid.
  • Track the newly updated requirements in the project and modify testing artifacts accordingly.
  • Participated QA weekly meetings and various other meetings and discusses enhancement and modification request issues and defects in the application.
  • Created SQL queries to test data movements, data validation and verification on backend Oracle and SQL Server.
  • Used SQL *Loader control file to import the customer information provided in the form of flat files into staging tables
  • Developed PL/SQL program to perform validations and to relate customers with addresses, contacts, banks and profiles and perform conversion validations between staging table and interface tables
  • Developed custom reports for billing history by client and Invoices by client report using Discoverer.
  • Participated in detailed design sessions that include use case detailed reviews and approvals screen specifications reviews and approvals and sign off.
  • Performed Smoke Testing, GUI Testing, Functional Testing, Backend Testing, Regression Testing, and User Acceptance Testing (UAT).
  • Validated request and response XML, SOAP and RESTFUL Web service calls, Performed the API (Application Programming Interface) testing using POSTMAN service, review the JSON generated, also created the documentation on the GitHub repository.

Environment: , POSTMAN,GITHUB, Test Link tool, DBFit, XML, Performer, HTML,, Oracle PL/SQL, Windows XP.

Confidential, Alpharetta, GA

Oracle SCM Functional/Test Analyst

Responsibilities:

  • Tested the modules of OM, INV, PO, BOM, Costing, Advance Pricing, and Shipping.
  • Worked on the Oracle Application Testing Suite (OATS) module - Technical Testing, Test Manager, Load testing.
  • Developed automation scripts using Open Scripting using OATS.
  • Maintaining test cases, analyzing defects, tracking bugs and working for the closure of bugs.
  • Delivering and implementing the project as per scheduled deadlines; extending post-implementation and maintenance support to the client.
  • Coordination with Business teams.
  • Additionally, played test lead role for supporting customizations from Onshore.
  • Test estimations for the CR's that are raised during testing.
  • Status reporting (productivity sheet, Daily/weekly status report, test summary report, monthly metrics report.
  • Tested Advance Pricing Module - defining modifiers, qualifiers, price lists, price breaks, custom attributes for pricing, price mapping, etc. Tested the Order to Cash flows.
  • Tested the INV module including the Item Catalogs, Catalogs, categories and Types, Item structures, document management, defining roles and implementing role-based security.
  • Responsible for the complete setup and implementation of Oracle OM, AR, Shipping, Advance Pricing modules .
  • Defining and setting up of complete Order to Cash cycle setups.
  • Worked on the setups of the i-Procurement module - Setting up the Punch-out's, catalogs, categories, content-based security, etc.
  • Worked on the Configuration of the INV module including setting up of the Item Catalogs , Defining Catalogs, defining change categories and Types, Defining Item structures, setting up document management, defining roles and implementing role-based security.
  • Responsible for the implementation AME Module for Approval process .
  • Performed Gap Analysis so as to map the business requirements to oracle functionality
  • Performed solution pilot covering prototyping of "To Be" business process flows
  • Prepared business requirements documents for Shipping, Pricing & OM

Confidential, Washington, DC

Oracle R12 Fusion Techno Functional Consultant

Responsibilities:

  • Tested entire Quote to Cash process including the modules of Quoting, OM, AR and Advance Pricing.
  • Tested the OM, INV, PO, BOM, Costing, Advance Pricing, Shipping modules.
  • Analyze business processes, work with users to determine/clarify requirements, and prepare Functional Specifications to address technology solutions for meeting business requirements. Work with the users to review, in corporate feedback and obtain approvals for the Functional Specification.
  • Tested custom attributes for pricing in Advance Pricing and attribute mapping
  • Tested dynamic formulas in Advance pricing using custom attributes.
  • Tested Automatic Discounts and Surcharges in Advance Pricing
  • Tested volume based discounts in Advance Pricing
  • Tested Price Breaks in Advance Pricing
  • As a SCM Functional Consultant implemented the Business flows including Oracle OM, Shipping, Advance Pricing, Quoting , AR modules.
  • Worked in the configuration of the AR module.
  • Performed Requirement and Gap analysis.
  • Configurations and Setups for Oracle OM, Shipping, Advance Pricing, AR module
  • Worked on the Functional Mappings for data conversion from 11i to Release 12 for all Distribution and Financials modules.
  • Preparing BR100, MD050, TE40, TE50, CRP execution, User and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
  • Worked on the EDI Transactions for Inbound and Outbound PO, Inbound Sales Order , Inbound Invoice, etc.
  • Worked on setting up the Approval Hierarchies in AME Module.
  • Implementation of Electronic Funds Transfer (ACH and Wire) FT for US and Canada
  • Pre-upgrade testing and Post upgrade production live support.
  • Performed all the steps for Oracle OM, AR, Shipping, Advance Pricing, Quoting modules.
  • Worked with the Business team to baseline the 'As Is' Process and derive 'To Be' flow.
  • Worked on the entire integration strategy to update it into the current AS IS system.
  • Managed the complete testing activities SIT, UAT and Oracle QA.
  • Obtained and signed off documents and tests from Oracle ERP side.
  • Providing Post Implementation support
  • Worked for the Category & Mapping data migration to meet the go alive deadline.
  • Jointly worked with the QA team in formulating the Test Cases & Test Scenarios.
  • Assisted Business for Business Acceptance Testing and obtain Sign off.

Environment : i-Procurement, AR, Purchasing, Procurement Contracts, Advance Pricing, Quoting, Service Contracts, Install Base, ASCP, GOP, EDI, I-Supplier, i-Procurement, BOM, Order Management, Accounts Receivables, Shipping, Inventory modules

Confidential

Oracle R12 Fusion QA Tester

Responsibilities:

  • Tested entire Quote to Cash process including the modules of Quoting, OM, AR and Advance Pricing.
  • Tested the OM, INV, PO, Costing, Advance Pricing, Shipping modules
  • Analyze business processes, work with users to determine/clarify requirements, and prepare Functional Specifications to address technology solutions for meeting business requirements. Work with the users to review, in corporate feedback and obtain approvals for the Functional Specification.
  • Tested Modifiers and Qualifiers in Advance Pricing
  • Tested custom attributes for pricing in Advance Pricing and attribute mapping
  • Tested dynamic formulas in Advance pricing using custom attributes.
  • Tested Automatic Discounts and Surcharges in Advance Pricing.
  • Tested volume based discounts in Advance Pricing
  • Tested Price Breaks in Advance Pricing
  • Worked in the configuration of the AR module. Performed Requirement and Gap analysis.
  • Configurations and Setups for Oracle OM, Shipping, Advance Pricing, AR module.
  • Worked on the Functional Mappings for data conversion from 11i to Release 12 for all Distribution and Financials modules.
  • Preparing BR100, MD050, TE40, TE50, CRP execution, User and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
  • Worked on setting up the Approval Hierarchies in AME Module.
  • Pre-upgrade testing and Post upgrade production live support.
  • Worked with the Business team to baseline the 'As Is' Process and derive 'To Be' flow.
  • Worked on the entire integration strategy to update it into the current AS IS system.
  • Conducting Pre-Project Review & Post Project Review. Managed the complete testing activities SIT, UAT and Oracle QA.
  • Obtained and signed off documents and tests from Oracle ERP side.
  • Providing Post Implementation support
  • Worked for the Category & Mapping data migration to meet the go alive deadline.
  • Jointly worked with the QA team in formulating the Test Cases & Test Scenarios.
  • Assisted Business for Business Acceptance Testing and obtain Sign off.

Environment: i-Procurement, AR, Purchasing, Procurement Contracts, Advance Pricing, Quoting, Service Contracts, Install Base, ASCP, GOP, EDI, I-Supplier, i-Procurement, BOM, Order Management, Accounts Receivables, Shipping, Inventory modules

Confidential

Oracle Apps Consultant

Responsibilities:

  • Complete setup of OM, Shipping, Advance Pricing, AR modules which includes defining all of the configurations for each of these modules.
  • Defined Accounting Flex field Structure, Security Rules, Assigned Security Rules Setup, Define Cross-Validation Rules.
  • Defined Period Types, Accounting Calendar, Currencies, Conversion Rate Types, Enter Daily Rates, Set of Books.
  • Defined Journal Sources, Journal Categories, Shorthand Aliases
  • Oracle - to define new items and categories.
  • Implemented Oracle Cash Management for Bank reconciliation .
  • Performed Bank Reconciliation.
  • Trained users on General ledger.
  • Fully participated in Conference Room Pilot (CRP) and authored user's manuals.
  • Test various business scenarios in the new system.
  • Interact directly with end users, infrastructure teams, and project teams.
  • Writing and executing detail manual test scripts in Mercury Test Director.
  • Developed input test data and expected results for test plans.
  • Researched testing errors for resolution and documented all defects in detail with attachments, before passing on to the senior business analyst for further review.
  • Interacted with the end users to get necessary feedbacks .

Hire Now