SUMMARY

• Oracle EBS/Cloud Techno - Functional Consultant with strong experience that includes 10+ years in Implementations, Team management, Development, Customization, Testing, Deployment, Integrations and Production support of Enterprise Applications
• Domain Knowledge Supply Chain Modules such as Purchasing, Inventory, Account Payables (AP), Account Receivables (AR), General Ledger (GL), Fixed Assets (FA) and Property Management
• Well versed in performing Gap analysis, Design analysis & Feasibility analysis to validate teh compatibility of existing business process and technical infrastructure with proposed business requirements.
• Proficient Oracle Methodologies (AIM, OUM) for creating Functional Design Documents (MD50, AN100), Technical Design Documents (MD70, DS140, CV40’s etc.), Process Flow Diagrams
• Experienced in all phases of teh software development life cycle methodologies (SDLC)
• Worked with Oracle Support (SRs), coordinated and followed on multiple issues based on priority including identifying bugs and follow-up with Oracle Development as well as conducting Oracle Web Conference (OWC) with Oracle Support Team.
• Decent exposure on Pre-Sales activities with Requirement gathering, Demo readiness, POCs, RFP response on tech area, Proposals and Estimations.
• Managed EBSsupport to make sure that teh issues are resolved, and proper change management process is followed for production code migration.
• Good Knowledge on Technical architecture and Functional flow of Oracle Applications modules such as Inventory, Purchasing, Payables and Fixed Assets.
• Excellent communication skills and leadership qualities with analytical problem-solving abilities, playing vital role in coordinating multiple business meetings and following up on open items.
• Managed Complex Confidential with Multi-Cultured Teams and extensively in Offshore-On Site Model
• Good understanding on both SAAS and PAAS models.
• Good experience in all teh Conversion/Interfacing activities using teh API’s and open interfaces in R12 with teh core subject of Trading Community Architecture (TCA).

TECHNICAL SKILLS

ERP Modules (R12, Oracle Cloud): Oracle Purchasing, Account Payables, Account Receivables General Ledger, Property Manager, FA (Fixed Assets), INV (Inventory)

Databases: Oracle 11g

Languages: Oracle SQL, PL/SQL, XML

Oracle Tools: Reports Builder, Forms Builder, ADFDi, FBDI, BI Publisher

Database Tools: TOAD, SQL DEVELOPER, SQL*PLUS, SQL*LOADER

Other Tools: Win SCP, Putty, Code Control tools

PROFESSIONAL EXPERIENCE

Confidential

Oracle Fusion Cloud implementation

Responsibilities:

• Involved in Data Conversions/Migration with design functional and technical specification documents for Suppliers, Open PO, Open AP from Legacy System to Cloud System
• Development of OTBI and BI Publisher Reports for Financials
• Defining ESS jobs for teh BI Publisher Reports
• Defining Role level security to ESS Jobs
• Worked in AP Invoice Approval Process
• Worked on Sandbox for Page Customizations
• Raising SR with Oracle for Bugs, issues and Standard Functionalities
• Test Scripts creation, User manual creations and End user training for Cloud solutions
• As there is a major change in accounting standards under IFRS and US-ASCs (US GAAPs) whose objective is to provide information on Financial Obligations and Rights of tenants/lessees by bringing teh leases (Property and Equipment) onto teh balance sheets of teh tenants/Lessees.
• Working as a techno functional PM consultant to deploy teh same for teh Sally Beauty.
• Completely involved with teh business to design and develop teh solution for teh upgradation process.
• Single handedly created teh technical scripts and queries to deploy teh upgradation and to test its results.
• Completed teh whole SLA setup for teh new changes in accounting by creating new AAD, Event, Event Types, Account Derivation Rules.
• Responsible for creating teh data templates, RD20, test cases for teh same.
• Actively involved with teh business to test teh complete process in all teh phases.

Confidential

Support of Oracle Applications

Responsibilities:

• Working as an Oracle Applications SCM Technical Consultant
• Actively involved with teh business and teh functional team to design and develop teh new solutions and upgradation of teh existing processes
• Single handedly supported in Item Creation Customization project as new items were to be created in Java as frontend and oracle as backend. All teh java events were carried out in oracle using procedures, packages, functions and PLSQL tables etc.
• Property manager and its custom integration to FA - Created custom form, workflow and a webadi to create buildings in property manager and to automatically create teh inventory locations and FA locations.
• Developed Reporting on property manager around leases and amortization schedules
• Standalone created a custom process for splitting teh asset into multiple items and tan creating new assets from them. dis process included forms and reports
• Worked as a part of technical team in creating a custom process of movement of assets from one location to another and returning any asset back to inventory for any reason like site scrapping or defect in item etc. dis process consisted of 5 forms and 2 workflows and 3 reports
• Created WebAdi for providing user friendly interface to user for data upload
• Created new reports and forms for Item Creation and other custom processes
• Actively participated in modifying teh objects according to R12 while teh up gradation of oracle applications from 11i to R12
• Responsible for writing down and verifying teh technical documents like MD70 and Test Cases TE020, User Manual, Training Document etc.
• Actively involved with manager in reviewing teh team progress and assignment of distributed jobs in respective Confidential

Confidential

Technical Consultant

Responsibilities:

• Migrated 1600 customer addresses from legacy system to oracle system using interface
• New system designed and developed for toner barcodes, their generation, issue, defective return and good return
• Alert designed to send an auto mail to teh concerned person when we create any purchase order
• Design new reports and forms as per discussion with teh users and there registration to Oracle Applications
• Involved in form Personalization
• Created file upload program for Confidential
• Auto mails will be sent to teh concerned managers for teh items which were not uploaded successfully
• To calculate teh stock in hand, MIT, DND, DNI etc. Costs for different elements of Inventory like Equipment, Paper, Spares, Consumables etc.
• Auto mail is sent to teh concerned managers which contains teh above stated report on daily basis
• Images has been applied on teh Marketing Invoices, depending upon teh user’s choice
• Customized forms were developed, and form personalization was done when required