We provide IT Staff Augmentation Services!

Integration Analyst - Oracle And Dynamics 365 Resume

Atlanta, GA

SUMMARY:

  • 18 years of IT experience (In Oracle Apps - QTC, I2C, P2P, O2C, VCP) in Design, Implementation, Customization, Support and Project Management.
  • Working as Integration Analyst for a major Oracle 11i to Microsoft Dynamics 365 (CLOUD ERP) integration project.
  • Worked as Techno - Functional Business Analyst in Oracle VCP (ASCP, Demantra, Inventory Optimization), OM, INV, BOM, Purchasing, Service Contracts.
  • Working on a major ERP integration from Oracle to Microsoft Cloud Dynamics 365 and as an EDI Analyst
  • Worked on a major Integration project called New Horizons bringing in data and users from many 3rd party systems to Oracle Universe (Inventory, ASCP, IO, BOM, FIO, OM, Purchasing, Demantra)
  • Worked in Agile Project Managing Methodologies using Rally
  • Designed and conducted a big employee initiative for Oracle E-Business Suite, Inventory, OM, Value Chain Planning (ASCP and Demantra) for 100 employees in ATT.
  • Worked 7 years On-site as Project Lead managing Offshore teams and 5 years in Offshore in various Lead positions.
  • Worked Extensively in GL, AP, AR, INV, Service Requests, BOM, Advanced Pricing, OM, FIO and ASCP modules
  • Worked on Trading Community Architecture (TCA) and Expertise on Interfaces/Conversion (PL/SQL API) and the RICEW components
  • Worked extensively on customizations, design of the Process Flows in the Scheduling tool UC4 - Appworx.
  • Worked on Data warehousing, building STAR schemas and Fact, Dimension tables
  • Worked Extensively on Analysis of the requirements and solution design and prepared MD50 and MD70 documents
  • Worked with Oracle in raising and solving the Technical Assistance Requests (TARs).
  • Worked on Shell scripts, PERL scripts and scheduling jobs in Unix
  • Efficient Project planning, resource coordination and task allocation skills and also worked on MS Project
  • Worked on Release Management Activities and extensively on PVCS, Kintana, Remedy and HP Quality Center
  • Managed Complex teams and executed complex projects with very minimal issues and escalations from On site
  • A self-motivated, dedicated, enthusiastic team player with good written and verbal communication skills.

TECHNICAL SKILLS:

E Business Suite: : R11.5.10, R11.5.9, R11.5.8, R12

Modules: : GL, AP, AR, Fixed Assets, iReceivables, OM, FIO, INV, BOM, Adv. Pricing, ASCPDemantra, Microsoft Dynamics 365(Cloud ERP)

Methodology: Application Implementation Methodology

RDBMS:: Oracle 11i, Oracle10g (R1, R2), 9i, 8i

Languages: XML, SQL, PL/SQL, UNIX shell script, PERL, Basic Java

Oracle Tools: Forms 6i, Reports 6i, TOAD, SQL Developer, SQL Navigator

Business Intelligence: Oracle Discoverer, Business Objects, Demantra, Power BI

Generic Tools: UniCenter Service Desk 6.0, ER Studio 6.0, PVCS, Kintana, Appworx, HP Quality Center, BMC Remedy

Utilities: SQL Loader

Others: Microsoft Visio, Microsoft Project.

Industry & Process Expertise: Insurance, Supply Chain Management, Chamber of Commerce, Retail Finance

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Integration Analyst - Oracle and Dynamics 365

Responsibilities:

  • Worked with 3 customers and 20 Trading Partners to establish the EDI specifications, test the connections and validate the EDI invoices and Advanced Shipment Notices. Author User Stories based on this for the users with acceptance criteria.
  • Worked with Business users from Oracle ERP modules like Inventory, Purchasing, Logistics, Payables to get the existing business processes in Oracle ERP and map them in Microsoft Dynamics 365 (Cloud ERP)
  • Perform gap analysis and utilize story mapping with Business Managers to identify and prioritize product features and enhancements
  • Facilitate requirements discussions to elicit business value of requested functionality
  • Conducting UAT Scenario workshops, executing the Scenarios and getting sign-offs from Users
  • Work with third party teams like BlackLine for GL, Bourque and Toolworx for Railcar Management, Dell Boomi for Transformation, SKC Global for Bank Integrations
  • Working with multiple third-party ISVs for understanding and smooth transition of the existing integrations.
  • Meeting with IT owners and Business owners for reporting the progress updates

Confidential, Alpharetta, GA

Techno-Functional Business Analyst

Responsibilities:

  • Meet Business Leaders to understand the requirements, document the requirement specifications and provide functional solutions by providing the Fit Gap Analysis.
  • Worked on a Major Integration for bringing in Minor Materials and Cable Items from Third Party Inventory, Order Management and Planning, Demand Management System into Oracle Inventory, ASCP and Demantra.
  • Creating New Item Categories and updating the Item Attributes. Enabling these new items in New Locations and Assigning planners to the items. Setting up Items, Child Items with BOM module.
  • Managed a big Oracle implementation Project called New Horizons - A Business suite of Oracle VCP (ASCP and Demantra including Inventory Optimization) and OM, INV, BOM, FIO, Purchasing
  • Inspect the Vertical and Horizontal Plans using the ASCP.
  • Working on Item Planning attributes and enabling for ASCP and Demantra along with the Min-Max Levels for Inventory Optimization module.
  • Validate the Item Substitutions, Item Relationships, Item statuses and the Min-Max Levels in Oracle Inventory
  • Validate the Back Orders and Replenishment Orders in Oracle Order Management.
  • Develop job-aids and conduct workshops to train users on interim releases, bug fixes or most frequently asked questions.
  • Review and sign off on Business Requirements, Functional Design and Testing documents for scheduled releases.
  • Develop scenarios and scripts to perform end-to-end manual testing to validate business requirements during scheduled releases.
  • Configuring Demantra for End-users. Validate the Demantra Item Loads and the Demand Analysis
  • Demand Planning for new items and loading the Demand History after enabling them in Demantra
  • Work as T1 Business Support to check on the issues and form a liaison for T2 Prod Support Team.

Environment: Oracle Apps 11 i- 11.5.10.2/R12; Oracle Inventory, OM, Demantra, Purchasing, ASCP, FIO, BOM, Appworx (UC4), Unix

Confidential, Alpharetta, GA

Oracle Apps Architect

Responsibilities:

  • Interacting with the GE Finance Center of Excellence to discuss new requirements on new GL Interfaces
  • For different feeds from different vendors
  • Also see the integrations for the existing AR and AP modules for the new receipts and check the reconciliations.
  • Design new Discoverer Universes and Reports.
  • Designed New Appworx (Oracle ERP Scheduling Tool Now called as UC4) Chains and Jobs
  • Manage the Testing Schedule and Manage the Production Deployments
  • Adhere to complete GE 6Sigma Quality Processes

Environment: Oracle Apps 11 i- 11.5.10.2 (GL, O2C, AR, AP, FA); Discoverer; HP PPM, VSS, AppWorx(AM8)

Confidential, San Jose, CA

Oracle Apps Techno Functional Analyst

Responsibilities:

  • Interact with the On-site Business Analyst to discuss new requirements.
  • Developed a new custom form for Amortization of the AR entries.
  • Prepare the Functional Design Document based on the Business Requirement Document related to the Collections Module.
  • Conduct FSD reviews with Business and Technical team and get Sign-offs
  • Test the deliverable against the FSD
  • Conduct the transition hand-shakes for all the support teams.
  • Adhere to complete Satyam Quality Processes as well the Cisco Quality norms

Environment: Oracle Apps 11 i- 11.5.10.2 (AR, Advanced Collections, OM)

Confidential, RTP, NC

Lead Oracle Apps Techno Functional Consultant

Responsibilities:

  • Worked on 2 major projects - one called MNQ - Multi National Quoting, where the billing area is in one country and the shipping to is a different country by defining, qualifiers and quantifiers.
  • The second project called FBP - Factor Based Pricing, where several factors play role for giving the customers discounts and list price
  • Interact with the on-site Business Analyst/User team to get new requirements, status on deliverables, and clarification on the requirements as well as delivery of the objects.
  • See the interactions with the existing AP and AR setups and ultimately check the flow into GL.
  • Prepare the Technical Design Document based on the Function Design Document related to the Pricing Module
  • Leverage the offshore team to get the deliverables done.
  • Used tools like Kintana, PVCS and other 3 party tools for transitions
  • Conduct the transition hand-shakes for all the support teams.
  • Adhere to complete Satyam Quality Processes as well the Cisco Quality norms

Environment: Oracle Apps 11 i- 11.5.10.2 (INV, OM, Advanced Pricing)

Confidential

Oracle Project Lead

Environment: Oracle Apps 11i - 11.5.10.2 (GL, INV, OM, Advanced Pricing, Telesales and Support)

Hire Now