Oracle business analyst (SCM and Finance)

MRAY

Email: adjlvy@r.postjobfree.com

Phone: +1-650-***-****

Oracle ERP Supply Chain and Finance

SUMMARY: A forward thinking, capable and committed technology expert with proven ability to meet agreed deadlines, co-ordinate work and work to defined development & testing methodologies within a structured environment. Focused on any task at hand and able to utilize existing software development and test knowledge and experiences to come up with practical solutions and alternatives to develop processes. Having first class executive leadership, negotiating and communicating skills and capable of providing authoritative guidance and advice to both in house and third-party development teams.

Professional Qualification

Masters in Informational Technology

PROFESSIONAL EXPERIENCE

Experience in Engineering, Building systems & Testing – Oracle applications and Database and EDI Gateways.

Oracle EBS designing

Requirements Gatherings

Technical Enhancement & Upgrades

Software Applications Customization

Applications and Interface Upgrades

Systems Design Code Rollouts and Support

Business Process Testing

Functional Testing

Integration Testing

Performance Testing

TECHNICAL SKILLS:

ERP: Oracle E-Business suite EBS R12 versions. Oracle Apps Modules, Oracle System Administrator, Application Developer, RICE (Reports, Interfaces, Conversions, Extensions), Procure to Pay (P2P), Order to Cash (O2C), AIM methodology and Agile methodology, Production Support, Performance Tuning, Cloning, Error-Handling, SDLC, Onsite – Offshore Model.

Application Tools: Oracle Reports, Oracle Forms, Oracle Workflows, XML Publisher Reports 5.6.3/5.6.2, Discoverer Reports.

Databases & Tools: Oracle R12, Logical Data Model Diagrams, Advance Collections, Defect Prevention, SQL Developer, SQL*PLUS, Data Loader, UTL_FILE, WEB ADI, QC tool, HP Quality Center and Kintana.

Operating Systems: Windows NT/XP/2000/98, UNIX/LINUX and MAC OS

Others: PowerPoint, MS-Word, MS-Excel, MS-PowerPoint, Visio and outlook

Languages: SQL, PL/SQL.

Testing: Integration, E2E technical and functional test.

SKILL SUMMARY

Extensive knowledge in ERP development - Oracle 11i and R12 - in Multi-Org environment and in modules comprising in i-Procurement, Purchasing (PO), Reverse Logistics (RMA), Oracle Agile Product Lifecycle Management (PLM) including shop floor manufacturing, Oracle Order Management (OM), Inventory (INV), Bill Of Material (BOM), Oracle Work In Process (WIP), Advance Pricing, and Finance modules like Oracle General Ledger (GL), Oracle Accounts Payable (AP), Oracle Accounts Receivables (AR), Oracle Cash Management, Oracle Purchasing and System Admin and integrated custom applications

Experience in a wide variety of areas such as project management, proof of concepts (POC), gap analysis, configuration setups, business analysis, 11i and R12 upgrades, conversion and interface design, documentation (BR-30, BR-100, MD-50, MD-70), Full life cycle implementation going through Development, Conference Room Pilot, User Acceptance Test and Production, User Training, go-live and post go-live Support in Multi-Org global Environments.

Experience in using Oracle tools like SQL*Loader, SQL* Plus, WEBADI, UTL_FILE, Oracle packaged APIs etc.

Good knowledge on Oracle Forms, Workflows and OAF.

Extensively used the advanced features of PL/SQL like Records, Tables, Object types and used BULK COLLECTS, BULK BINDS in PL/SQL objects for improving the performance

Worked on Version Control software tools to check-in codes and integrated with KINTANA, Sarena PVCS management tool, CVS for file migration and Well versed with defect tracking tool such as HP Quality Center (QC) and requirement tracking tool such as Project Portfolio Management (PPM).

Software builds, Conducted Conference Room Pilots (CRP) and User Acceptance Testing (UAT)

Worked collaborated closely with Business Users & Vendor teams to accelerate the speed of knowledge transfer and drive the highest value from the successful deployment of the Oracle EBS

Having enriched knowledge as Business Requirements gathering and understanding, Gap analysis and development, solution design build and testing, configuration, setups, User/Partner Interface build, Unit Testing, System Integration testing, User Acceptance Testing and flat file/xml testing.

Experience in migrating the packages through Kintana Log files.

Heavily involved in brainstorming sessions, GAP analysis, Root Cause Analysis, Risk Analysis, walkthroughs, meetings, and JAD sessions with all stakeholders in the project.

Strong experience in training End-Users, Internal and External Stakeholders, Business Owners and Subject Matter Experts to gather business requirements and technical design execution.

Adept in reviewing and analyzing the 'as-is' business scenarios, processes and activities, evaluating end user requirements and custom designing solutions and troubleshooting any problems in the process.

Expert in developing Technical design documents (MD070), Technical Test documents (TE020), Conversion (CV050) and Migration documents (MD0120) using AIM Methodologies, Agile methodology and DevOps methodology.

Demonstrated abilities in mapping business requirements and translating these requirements into Oracle applications functional and technical specifications (MD 050 and MD 070) and custom designing solutions.

Worked on different application solutions including client server application and web-based applications.

Worked with the QA team in conducting System Integration Testing (SIT) and supported the User Acceptance Testing.

Can cope with multi-tasking assignment excellent analytical, interpersonal and communication skills. Team Player, responsive and organized

Extensive business area experience & have received great commendations at Client site for excellent interpersonal & Client interaction skills.

Strong Analytical, Diagnostic and Troubleshooting skills and ability to work in a fast-paced and team-oriented environment

Excellent judgment skills in identifying areas of high-risk, critical business areas, early in an application and prioritize my tasks to focus my efforts when time is limited

PROFESSIONAL EXPERIENCE:

CGG Veritas Jan 2018 – Present

Role: Business Analyst (SCM and Finance)

As a Business System Analyst, responsible for requirements gathering, design build and discussions, Implementations, Enhancements, Rollouts and Support projects of Oracle applications and database environment in OM, AR, INV, FA and GL modules. Contributed in Enhancements & Support for CGG’s Consumer Hardware systems, Rollouts & Support using oracle application modules.

Responsibilities:

As a Business Analyst, I acted as a primary liaison between Business & the development team throughout all phases of SDLC.

Analyze the Business Enhancement Requirements for IT and designing the project.

Identification of GAPs & proposal of Solution.

Documents the AS IS and TO BE Processes.

Analyze the Upgrade Requirements and strategize the migration of customizations to Release 12 instance.

Identification of GAPs & proposal of Solution.

Preparing of all the Functional Specification Documents (FSD), Business Requirement Documents (BRD), Data Mapping Documents (DMD) and Functional Testing Documents.

Carry out Data Mapping for data conversions.

Ability to engineer multiple poles simultaneously within CGG instances like R12 across the multiple Operating units of CGG.

Working as active participant from business team for requirements discussion and design implementation.

Working closely with Oracle, Sysadmin & DBA teams for regular Patch Applications, Outages, data fix, code fix, Scheduling of several scheduled requests.

Develop functional documentations for all CGG’s systems and applications that is easy to understand at all levels of the organization

Write custom SQL codes for data fetch in the Oracle DB.

Modifying requirements for engineers to build/correct software to fix errors, adapt it to new hardware, improve its performance, or upgrade interfaces.

Design, develop, test new Enterprise architectures and enhance the existing architectures

Design and drive solutions for new system builds, system refreshments, migrations and expansions

Client: F5 Networks, Seattle, WA April 2015 to Nov 2017

Role: Oracle SCM Support/Test Consultant (EDI, SCM, Distribution)

Modules: Oracle e-Business Suite R12.1.3 OM, INV, PO, EDI, BOM and WIP

Responsibilities

Preparing BR100, MD050, TE40, TE50, CRP execution, User training and coordinating with technical teams on Oracle Apps related Custom design validation

Understanding and analyzing the Business functionality of existing system

Identification of GAPs & proposal of Solution.

Documents the AS IS and TO BE Processes

Prepared the high-level strategic Test plan for the Project with its scope and objectives to meet the deliverables.

Prepared all the required test cases for all the testing cycles starting from Integration testing cycle 1 until UAT (User Acceptance Testing)

Tested the Financials Modules of OM, INV, PO, i-Procurement, i-Supplier, EDI, BOM and WIP modules of Release 12.1.3

Worked on the EDI 810 Invoice inbound, 850 Inbound Purchase Order, 843 Inbound Response to RFQ, 856 Shipping execution inbound and outbound.

Worked on the Shipping EDI transmission that was loaded into Oracle

Worked on the testing the ASN EDI File

Worked on the XML Gateway module – working on XML Inbound and outbound interfaces.

Tested and supported the Order to Cash and Procure to Pay business flows

Gathered all the business requirements of the project after each development phase until UAT and prepared test scripts based on the requirement.

Worked on testing and supporting the automatic update of start and end dates of a subscription renewal product in Installed base with 7 months of expiration based on which an opportunity gets renewed automatically in SFDC.

Monitored and tested the Oracle notifications (Business Activity Monitoring) and Error Recovery Portal which captured the errors in the process flow and suggested the appropriate workable and possible solution.

Documented all the test cases and its results on the Project SharePoint for management review.

Coordinated with the Functional resource and Developer to understand the required flow and implementation of upstream and downstream process.

Involved in Unit testing and system testing.

Optum Global Solutions (UnitedHealth Group) May 2014 to Mar 2015

Responsibility: Oracle SCM Functional/ Test Consultant

Modules/Skills used: Release 12.1.3, OM, INV, PO, i-Procurement, i-Supplier, EDI, BOM

Responsibilities

As an Oracle QA Test Analyst supported the testing of the Order to Cash Business Process (AR, AP, GL, SLA, Service Contracts, Install Base, OM, INV, PO, i-Procurement, i-Supplier) and all financial

Worked on the Oracle Application Testing Suite (OATS) module – Test Manager, Load testing.

Worked on the technical scripts for Automation Testing in OATS

Tested Conversions & Enhancements for OM, INV, PO, i-Procurement, i-Supplier, EDI, BOM, WIP and ASCP module

Created Requirements using Quality Center and generated trace ability Matrices to ensure that all the requirements are covered by the test cases.

Keeping Track of Defects in HP Quality Center.

Coordinated with different users for the Functional Specifications and final utility of the modules.

Executed and developed all Manual Test Scripts for the testing cycle for Order to Cash and Procure to pay processes.

Wrote Test Scripts and Executed the same for the EDI Interfaces

Worked on the CRP execution, User training and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.

Tested the OM, INV, PO, i-Procurement, i-Supplier, EDI, BOM, WIP and ASCP modules from scratch and simultaneously validated the BR100 documentation for the setups.

Created test scripts for UAT (User Acceptance Testing) in TE040 documentation with detailed testing of all the above modules.

Used manual testing methods to test Invoice rules, Payment terms and Transaction types in Accounts Receivable module.

Performed Black box and White box testing to test the custom forms and reports in different modules.

Involved in defect tracking and created various defect reports

Regression testing on weekly builds.

Successfully provided Technical and Functional support to the users, testers and Business System Analysts.

Tested the MRC Setup by testing the primary Set of Books and Reporting Set of Books in Oracle GL.

Contact this candidate