We provide IT Staff Augmentation Services!

Oracle Ebs Lead Analyst Resume

Baton Rogue, LA

OBJECTIVE

  • Seeking a competitive environment to utilize my skills and abilities in a futuristic organization that offers Professional growth while being resourceful, innovative, and flexible.

SUMMARY

  • Over 8+ years of diverse experience in the field of Quality Assurance and Software testing.
  • Excellent knowledge on all major financial life cycles in Oracle EBS 12.1.3 such as AML, BL, CAL, P2PL and RML.
  • Excellent knowledge on Oracle EBS Supply Chain Management Modules like Order Management, Inventory, Warehouse Management and Purchasing modules.
  • Excellent knowledge on Supply Chain, Financials Order - to-Cash flows, and Procure-to-Pay flows
  • Experience in Oracle’s OBIEE 10g/11g reports.
  • Excellent knowledge on Oracle Financials and Supply Chain ERP concepts.
  • Good knowledge of structured testing methodologies, testing tools and full testing life cycle including design and development of test plans, test cases and test objectives.
  • System specification analysis, testing methodology and test plan formulation.
  • Involvement in various stages of Software Development Life Cycle (SDLC).
  • Over Seven years of experience in Manual and Automated Testing the Oracle ERP applications, Client/Server, Web Applications and E-Commerce, Java, .NET applications testing on multiple platforms.
  • Experience in Database Testing using interfaces like SQL Plus.
  • Experience in UNIX (AIX, HP, Solaris) and Linux based application testing.
  • Excellent Knowledge of programming languages like C/C++, Java, and SQL.
  • Experience with automated testing tools like Load Runner, Quick Test Professional (QTP), Mercury Diagnostics, and Quality Center, and Clear Quest.
  • Experience in testing FIX and FAST messages in financials industry.
  • Experience in Integration, Functional, Performance, Regression, System, User Acceptance, and Load & Stress testing. Solid experience in Black box & White box Testing techniques.
  • Ability to work in a team environment. Strong communication and interpersonal skills. Ability to interact with other teams and team members with ease and professionalism.
  • Ensure that all deliverables are well within the quality standards, and this will be taken care by frequent audits on all projects.
  • Following the agreed methodology to prepare the individual Test Plans, Approach. In planning it covers Test Scripts, Cases, Results, Schedules, Complete Test Strategy, Acceptance Criteria, Risk Management & Final reports.
  • Ability to quickly master new concepts and applications

TECHNICAL SKILLS

Testing Tools: HP’s mercury Quick Test Professional (QTP), Quality Center, Load Runner, IBM’s Rational Clear Case, Clear Quest, SOAP UI and TOAD.

ERP Applications: Oracle EBS, Oracle Sales Cloud

ERP Life Cycles: Procurement to Payables (P2P), Order to Cash (O2C), Budget (BL), Core Accounting (CAL), Assets Management (AML - Inventory / Waterhouse Management) and Revenue Management (RML), Oracle Lease and Finance Management (OLFM), Delivery & Install, EDI testing

Languages: Java, C, C++, PL SQL, SQL, ASP.net, C#.net, Python

Platforms: Oracle EBS 12.1.1 / EBS 12.1.3, OBIEE 10g/11g, Windows XP, MS Windows, Unix/Linux, Mac OS, Raspbian.

Automation Framework: Selenium

Microsoft Office 365 Suite:

Database: MS SQL Server and Oracle.

Data Mining Languages and Tools: R, Knime

Scripting Language: Java Script and PL/SQL.

Machine Learning Platform: Tensorflow

Web Applications: Jupyter Notebook

Web Technologies: HTML, XML and Java Script.

File Transfer Tools: WinSCP, Putty, FileZilla

PROFESSIONAL EXPERIENCE

Confidential, BATON ROGUE, LA

Oracle EBS Lead Analyst

Environment: Oracle EBS 12.1.3, Financials, Oracle Supply Chain Management, UNIX/Linux, R, Knime, Python, Tensorflow, Jupyter Notebook

Responsibilities:

  • Worked on CAL, P2PL financials life cycles in Oracle EBS.
  • Involved in the development of deep learning model for multi-modal surveillance & prediction of vector borne disease in the Americas Using Supercomputers by integrating spatial and temporal data from hyperspectral satellite images.
  • Maintained course materials for three courses per semester in an e-learning platform.
  • Proctored exams and graded both undergraduate, graduate assignments and labs.
  • Assist the computer science faculty in the development of new material for their courses.
  • Worked as Lab Assistant for Statistics and Graphics with MATLAB, Computer Science I, Computer Science II courses and Teaching Assistant for Computer Networks.
  • Prepared detailed documentation for 12.1.3 upgrade testing for the newly adopted enhancements in all major modules like PPO (Planned Purchase Order) in P2P Lifecycle.
  • Extensively worked on Oracle EBS Supply Chain Management Modules like Order Management, Inventory, Warehouse Management and Purchasing modules.
  • Extensively on Supply Chain, Financials Order-to-Cash flows, and Procure-to-Pay flows
  • Conducted functional and regression testing for new enhancements in Oracle EBS 12.1.3 upgrade.
  • Good Knowledge in writing SQL queries in Oracle database
  • Extensively worked on regression test cases for Oracle EBS 12.1.3 upgrade project.
  • Worked on all major financial responsibilities in Oracle E-Business Suite 12.1.3.
  • Worked on UNIX platform to verify the errors and exceptions.
  • Extensively worked with Oracle database to verify the exceptions and back-end database testing of ERP modules.
  • Good knowledge on PL/SQL, and SQL.
  • Extensive knowledge on Oracle Apps R12 Order Management, Inventory and Purchasing modules.
  • Worked on Oracle Applications HCM modules.
  • Worked with Oracle ERP Functional SMEs in functional testing of Oracle ERP’s new enhancements and helped them to resolve the major functional issues.
  • Worked on all major modules of Oracle ERP such as AP (Account Payables), AR (Receivables), I-Expenses, Cash Management (CM), GL (General Ledger), Projects and HR modules.

Confidential, WAYNE, PA

Oracle EBS Quality Assurance Lead Analyst

Environment: Oracle EBS 12.1.3, Financials, Oracle Supply Chain Management, UNIX/Linux, HP ALM / QC and Jira, OSC, OFSC, Mobile Applications, RSOURCE, RQUOTE, Velocity, TOAD

Responsibilities:

  • Responsible for performing various types of process evaluations during each phase of the Software Development Life Cycle, including Review, Walk Through and hands on system testing.
  • Performed Data Driven Test for multiple scenarios with different sets of data.
  • Prepared detailed documentation for new customizations in Account Receivables (AR), Account Payables modules.
  • Extensive hands-on knowledge on Oracle Sales Cloud application
  • Responsible for Daily status to show the Progress of the automation testing effort.
  • Played a key role in process improvement and innovative idea generation. Involved in detailed test analysis and summary report preparation.
  • Involved in defect tracking, reporting and coordination with various groups from initial finding of defects to final resolution.
  • Designed black box testing related documents such as test plans, test strategies, and test cases and executed the same.
  • Lead the projects with larger group of people and worked on onsite-offshore model.
  • Extensively worked on implementing Warehouse Management, Inventory management, Order Management modules in Supply Chain Network project.
  • Extensively worked on testing the AR, AP and GL modules in 11i and R12 environment.
  • Worked on Auto Invoice customizations in Account Receivables (AR) module for both US and Canada upgrades.
  • Extensively tested and prepared detailed documentation for Auto Invoice accounting customizations in AR and GL modules for over 30 order types.
  • Used HP QC / ALM and Jira for ERP defects management.
  • Prepared detailed documentation for Oracle upgrade testing for the newly adopted enhancements in all major modules.
  • Used TOAD as a DB interface tool to conduct ERP back - end testing
  • Conducted functional and regression testing for new enhancements in Oracle 19B upgrade.
  • Worked on CRP1, CRP2, CRP3 and CRP4 phases to test End-to-end business processes in all the Oracle Financials and SCM modules.
  • Good Hands-on Knowledge in writing SQL queries in Oracle database.
  • Worked on all major modules of Oracle ERP such as AP (Account Payables), AR (Receivables), GL (General Ledger), Lease Management, Delivery & Install, Supply Chain, Finance, Inventory, financial reports, OBIEE and Order Management.
  • Prepared test plans and test scripts for software corrections and enhancements. Reviewed Software QA test plans and test reports.
  • Designed black box testing related documents such as test plans, test strategies, and test cases and executed the same.
  • Worked on Order Management, Inventory, Warehouse Management, Purchasing modules.

Confidential, HUNTERSVILLE, NC

Oracle EBS Quality Assurance Analyst

Environment: Oracle EBS 12.1.3, Financials, Oracle Supply Chain Management, UNIX/Linux, HP ALM / QC, Jira, and TOAD

Responsibilities:

  • Extensively worked on testing the SCM modules for both USA and Canada.
  • Extensively worked on all financials modules like AP, AR, and GL in Oracle EBS.
  • Tested and prepared detailed documentation AP, AR, and GL modules for different order types.
  • Used HP QC / ALM and Jira for ERP defects management.
  • Prepared detailed documentation for the newly adopted enhancements in all major modules.
  • Conducted functional and regression testing for new enhancements in Oracle EBS
  • Worked on CRP1, CRP2, CRP3 and CRP4 phases to test End-to-end business processes in all the Oracle Financials and SCM modules.
  • Extensively worked on Oracle O2C (Order to Cash), Oracle P2P (Procure to Pay) life cycles in R12 environment.
  • Worked with Oracle ERP Functional SMEs in functional testing of Oracle ERP’s new enhancements and helped them to resolve the major functional issues.
  • Worked on all major modules of Oracle ERP such as AP (Account Payables), AR (Receivables), GL (General Ledger), I-Expenses, Cash Management (CM), Inventory, and Order Management.
  • Prepared test plans and test scripts for software corrections and enhancements.
  • Reviewed Software QA test plans and test reports.
  • Worked on Order Management, Inventory, Warehouse Management, Purchasing modules.
  • Extensively worked on Wave dashboard in Warehouse Management module.
  • Worked on Oracle Database for backend testing.

Confidential, SHREVEPORT, LA

Oracle EBS Quality Assurance Analyst

Environment: Oracle EBS 11i, Quality Center, Java, Linux, R and MS Office Suite.

Responsibilities:

  • Performed Acceptance, Usability, Cross-Platform and Regression Testing during different stages of the application development.
  • Extensively involved testing custom Java applications, and Integrations with 3rd Party Applications using Application Messages.
  • Used Quality Center to store Test Plans, Test Cases, Test Scripts and for bug tracking.
  • Involved in testing application validations and data validations. Used TOAD & Oracle SQL Developer to browser schemas, write the SQL Scripts and to verify the data in tables.
  • Responsible for performing various types of process evaluations during each phase of the Software Development Life Cycle, including Review, Walk Through and hands on system testing.
  • Involved in gathering critical business requirements from Business Analysts and development team. Actively participated in making test strategies and test scope.
  • Analyzed application design document and prepared test cases and test plan.
  • Converted Business requirements and design documentation into test design products: Test Scenarios, Test Cases and Test Scripts.
  • Developed an integrated Test Plan covering the main functions of the designated parts of the application.
  • The application was tested manually most of the part, and automated testing wherever required, using the Test Cases.
  • Involved in defect tracking, reporting and coordination with various groups from initial finding of defects to final resolution.
  • Designed black box testing related documents such as test plans, test strategies, and test cases and executed the same.
  • Involved in the statistical analysis of data related to effects of air medical administration of Tranexamic Acid (TXA) on morbidity, mortality, and length of stay with implications spanning from civilian to battlefield medical care using R programming.
  • Worked on the High-Altitude Solar Eclipse Observer project.
  • Developed, maintained, and managed all analytical operational mission-critical business reports based on the tools.
  • Prepared, tested, and configured automated ETL to load application logfile data into multiple databases.
  • Performed complex SQL queries when immediate access to data was required.
  • Responsible for creating, developing, and administering Web-based analytic system.
  • Helped establish standards and procedures for reporting. Evaluated features in new product versions and assessed impact and improvements to Product Development and delivery.

Confidential

Oracle EBS Analyst

Environment: Oracle EBS 11i, Quality Center, Linux, and Microsoft Office Suite.

Responsibilities:

  • Analyzed application design document and prepared test cases and test plan.
  • Converted Business requirements and design documentation into test design products: Test Scenarios, Test Cases and Test Scripts.
  • Developed an integrated Test Plan covering the main functions of the designated parts of the application.
  • The application was tested manually most of the part, and automated testing wherever required, using the Test Cases.
  • Used Quality Center to store Test Plans, Test Cases, Test Scripts and for bug tracking.
  • Involved in gathering critical business requirements from Business Analysts and development team. Actively participated in making test strategies and test scope.
  • Involved in defect tracking, reporting and coordination with various groups from initial finding of defects to final resolution.
  • Designed black box testing related documents such as test plans, test strategies, and test cases and executed the same.
  • Developed complex Informatica mappings involving transformations like Expression, SQL, Transaction Control, Normalizer and Unstructured Data
  • Implemented complex ETL concepts including lookups
  • Collaborated with executive team to monitor critical business data and develop recommendations for methods that reduced the cost of doing business.
  • Designed Informatica B2B parsers that involved parsing complex source reports in .txt and .pdf format.
  • Assisted the database manager in maintaining and updating the entire database.
  • Helped to create several data mining procedures that made business intelligence reports more accurate and useful.

Hire Now