We provide IT Staff Augmentation Services!

Oracle Apps Techno Functional Consultant Resume

Morrisville, NC

SUMMARY

  • Around 13 years of experience as an Oracle E - Business Suite Techno Functional Consultant in Analysis, Design and Implementation of Oracle E-Business Suite Application 11i and R12
  • Well versed with Business, IT and other stakeholder’s coordination for requirements gathering, technical design, development, testing, deployment and application support.
  • Worked in Agile environment, well versed with SCRUM methodology and Rally (Agile tool). Experience with DevOps work environment.
  • Implementation and techno functional expertise in Oracle Applications R12/11i, across the Finance, SCM, Manufacturing and HRMS modules
  • Extensive experience in end to end implementation of Oracle R12 application from a legacy system or Oracle 11i.
  • Good knowledge on Oracle Cloud Financials Release 13.
  • Proficient in Oracle Conversions and interfaces like Supplier Invoices (AP), Customer Invoices (AR), Purchase Orders, Sales Orders, Material Transactions, Suppliers, Customers and Journals.
  • Worked extensively on Customer Merge process to clean up the duplicate Customers.
  • Participated in support activities during month end closures for account reconciliations for Journals, Payables and Payments
  • Highly Proficient with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
  • Extensive experience in creating Stored Procedures, Functions, Packages, Triggers, Dynamic SQL, Collections and Exception handling using SQL and PL/SQL.
  • Good knowledge in ETL techniques and well versed with Informatica Power Center
  • Extensively used JSON/XML RESTful Web Services for interacting with Cisco Enterprise Process Manager (CEPM) for role based access and for interacting with Cisco Commerce tool for Customer address validations, create Orders and Product BOM setups in Cisco Commerce tool.
  • Experience in Shell Scripting for invoking SQL scripts and data integrations using SFTP file migrations and file operations.
  • Expertise knowledge on Trading Community Architecture (TCA) and established integration with Customer Data Hub to pull Customer and Customer Addresses
  • Strong knowledge of Oracle Forms 10g/6i, Reports 10g/6i, Discoverer 10g/4i, Oracle Workflow and XML Publisher, Discoverer 10g/4i Administrator and Desktop Edition
  • Subject Matter Expert in Oracle XML Publisher/BI Publisher
  • Worked on Relational database (Oracle) to NoSQL database upgrade (MongoDB). Experience in Data sync utility (in-house tool) to sync data between Oracle and Mongo DB
  • Prepared Technical Design Documents for customizations and conversions using AIM documentation methodology
  • Excellent problem solving skills with an ability to identify problems and implement corrective solutions.

TECHNICAL SKILLS

Project Management: PMP, Scrum, Agile methodology, Waterfall model, MS Visio, MS Project Planning

Languages and Scripting: Oracle SQL, PL/SQL, Unix Shell Scripting

E Business Suite: Oracle R12, Oracle Fusion, Oracle 11i and 10.7

Oracle Modules: Oracle Finance, SCM and HRMS modules like AP, PO, GL, FA, iProc, iExpenses, Costing, AR, OM, INV, BOM, OSFM, OPM, EAM, Oracle Advanced Pricing, HR, Payroll

Tools and Technologies: Oracle XML Publisher, Oracle Developer Reports and Forms, Forms Personalization, Oracle Discoverer, Spreadsheet ML Excel Reports, Business Events, Oracle Workflow, Oracle Alerts, Unix Shell Programming, Perl Programming, HTML, SQL Loader, WIN SCP, Putty, Toad, Mongo DB compass, Mongo Sync tool, SVN, APPDB, Golden Date, OAF Personalization, OAF Customization, Service Now, Rally

Databases: RDBMS databases - Oracle 12C, 11i, 10g, 9i and 10.7.

PROFESSIONAL EXPERIENCE

Oracle Apps Techno Functional Consultant

Confidential - Morrisville, NC

Responsibilities:

  • Application Support and Maintenance project on Oracle E-Business suite R12 and its upstream and downstream integrations
  • Support business for any clarifications and issues on Order to Cash and Procure Pay process flows
  • Monitor jobs daily - restart any failed jobs, analyze errors, identify and improve performance on any long running jobs
  • On daily basis, work on support tickets raised by users in Service Now and close them a per the SLAs defined
  • Provide guidance and immediate fixes to any queries/issues occurred during the Period Close
  • Monitor workflow process and reprocess any transactions that stuck in workflow
  • Monitor and reprocess Orders that got Shipped but not interface to Receivables
  • Help business with new approval limits setups, rerouting workflow during any Business team/role changes and reprocess the journals that stuck in Journal Approval Workflow (JAW)
  • Automate Salesperson updates based on Deal Approval number to appropriately calculate the Sales Credits and thus Commissions
  • Developed Customer Merge program using Oracle APIs to clean up duplicate customers in Oracle E-Business Suite
  • Identify the source for duplicate Customers creation and provide solution to avoid duplicate Customer creation
  • Work with respective stakeholders to perform functional testing and support the regression testing & UAT testing during the testing phase.
  • Identify frequently occurred issues, identify the root cause and provide solutions.
  • Support business during RMA process for any issues due to Customer deactivation
  • Simplify and automate the Channel Report - existing channel report is a very complicated report pulled from multiple data sources.
  • Root Cause analysis on frequently occurred issues and provide Long Term solutions wherever possible.

Oracle Techno - Functional Consultant

Confidential

Responsibilities:

  • Worked with Developers, Business Analysts and Core Business Team to understand the Requirements, Functional Design and Technical Design.
  • To work with Technical Core Team to perform functional testing and support the regression testing & UAT testing during the testing phase.
  • To coordinate Functional testing, UAT testing and Regression testing during the pre/post- migration patch activities.
  • Responsible for setting up Customer Accounts, Credit Profiles and BIDs with approval limits
  • New Customer onboarding to Oracle R12 - create new Customers, setup BID and SID for the Customers
  • Worked closely with Cisco Legal team for following the legalities of the Products sold in different geographies - NAM, EMEA, APJC regions.
  • Establish Customer Data Hub integration between Oracle E-Business Suite to Cisco Refresh Platform.
  • Establish, Maintain and Support the Order to Cash Cycle for Cisco Refresh Business
  • Month End close support
  • Root Cause analysis on frequently occurred issues, and provide Long Term solutions where ever possible.
  • For Sales Orders tool, used JSON/XML RESTful APIs to fetch the config items for ATO (Assemble to Order) model products, for Address validations, role/access validations and Order submission.
  • Debugging existing applications for identifying the issues
  • To support business on critical orders, use RESTful APIs using Postman for various Web Services like Product Config API for BOM details for Cisco Products, Customer Address API, CEPM service to fetch roles while accessing application and Order submission API to submit order to Cisco Commerce platform.
  • Where ever possible suggest improvements to existing systems and processes to reduce operational cost, make complex processes simpler.
  • Complete ownership to Design and Architect the Excess Ordering tool to support Cisco Refresh wholesale business for Customer to place Orders.
  • Database design based for the Ordering tool, develop PL/SQL scripts and APIs
  • Develop UX screens for mockups using iRise and mspaint.
  • Develop ETL transformations to pull Customers, Inventory and Product data with SOT (Source of Truth) using Informatica ETL
  • Integrate Inventory data from Cisco Commerce tool using Oracle Golden Gate Replications.
  • Performed a POC to migrate from Oracle database to MongoDB
  • Implementation of Data Sync utility to convert data from Oracle database to Mongo DB documents.
  • Conducting status meeting and knowledge sharing sessions
  • Responsible for overseeing the Quality procedures related to the project.
  • Perform Unit and Regression testing

Oracle Techno Functional Consultant

Confidential

Responsibilities:

  • Worked with Developers, Business Analysts and Core Business Team to understand the Requirements, Functional Design and Technical Design.
  • Performed all the setups for AP, GL, SLA and Payment modules for enabling new business integration process in oracle E-Business suite.
  • Design and Develop Journals interface from Oracle BRM system to Oracle E Business Suite R12.
  • Setup Royalty Journals (Manual Journals from Cisco Royalty Calculation Engine) in Oracle R12 Finance (Cisco Central Finance system).
  • Design and Develop Account Payable Invoices from Oracle BRM system to Oracle E-Business Suite R12.
  • Implement Oracle Golden Gate Replication to Invoices and Journal data integrations
  • Automate email notifications for any interface failures
  • Support Business during month end closure
  • Guiding the Offshore team in development
  • Conducting status meeting and knowledge sharing sessions
  • Responsible for overseeing the Quality procedures related to the project.

Oracle Techno Functional Lead

Confidential

Responsibilities:

  • Worked with Developers, Business Analysts and Core Business Team to understand the Requirements, Functional Design and Technical Design.
  • Analyzed the impacts of enabling MLS in an existing Oracle E-Business Suite Finance application
  • Responsible for end to end implementation of MLS functionality in Cisco’s one of the critical E- Business suite applications.
  • Developing an end to end automation of Employee Supplier bank creation process
  • Developing EDM Copy program
  • Developing Oracle XML Publisher reports, SQL reports and RDF reports
  • Internal Order capitalization enablement for US and LATAM entities
  • Worked on various complex XML Publisher reports
  • Customized iProcurement workflow to integrate with Field Glass for C-Worker process.
  • As a team lead drive the meeting Support Team for accepting the requests for existing production bugs and enhancements
  • Analyze the requests discussed during the Support calls and accept the requests based on predefined criteria
  • Participate in transition activities and ensure smooth production migration
  • Conduct status meeting and knowledge sharing sessions
  • Guiding the team in development
  • Responsible for overseeing the Quality procedures related to the project.

Oracle Techno Functional Lead

Confidential

Responsibilities:

  • As a techno Functional Lead, responsible for end to end implementation of Oracle R12 implementation suite from Off shore location.
  • Coordinate with Onsite teams, Offshore team on day to day basis for requirements and implementation
  • Interact with Customer IT and Business teams on need basis for low level requirements gathering, Data extractions from legacy system, Development and testing support.
  • Lead a 8 member team for successful Go-Live of Oracle R12 implementation project
  • Delivered / Developed reports in Oracle R12 Finance, OPM, OM modules
  • Developed various conversions in EAM module (Enterprise Asset Management) like Asset Activities, Asset Groups, Asset Number and Asset Attributes

Oracle Techno Functional Lead

Confidential

Responsibilities:

  • Extracted various master and transactional data from external system (Orion) - Customers, Suppliers, Item Master, Purchase Orders, Customer Invoices, Employee Leave Details and Air Passage Details
  • Coordinated for Suppliers, Customer Invoices, Employee Leave Details and Air Passage Details migration to Oracle E-Biz Release R12
  • Migrated Customer and Purchase Orders data to E-Business Release 12
  • Developed Employee Master Listing report in EXCEL using Spread Sheet ML language
  • Developed Employee Payslip XML Publisher report in PDF format and Given technical support to functional team at onsite for quick fixes during CRP milestones

Hire Now