SUMMARY

• 11 years and 10 months of professional experience in teh area of implementation, upgrades and support of Oracle 11i and R12 e - Business suite projects as a Confidential -Functional consultant
• A good hybrid of Technical and Functional expertise in Finance modules
• Expertise in Finance modules (Payables, Payments, Receivables, Cash Management, General Ledger, Fixed Asset, Purchasing, iProcurement, iExpenses, Trading Community Architecture).
• Have exposure in Sub Ledger accounting
• Possess knowledge in SCM modules (Inventory, Order Management)
• Expert in Interaction wif Business, Requirement gathering and Fit gap analysis
• Configuration experience wif Payments, Confidential, Confidential modules, like defining Payment process profiles, Payment formats, Transaction types, Batch sources, Receipt class, methods, Receipt sources etc.
• Expert in enabling both inbound and outbound third-party integrations, data mapping, conversions and extensions
• Expert in design and development of custom module solutions and utilities wifin EBS
• Understanding of integration points across finance modules and clear understanding of table level architecture
• Expertise in design and implementation of RICE(Reports, Interfaces, Conversions, Extensions)
• Expert in design and development of complex interfaces and conversion programs to import data from legacy and integrate wif Oracle EBS using Open interfaces and Oracle standard APIs
• Extensively worked on design and development of many inbound and outbound interfaces, payment interfaces, encryption and bank integration
• Proficient in Oracle PL/SQL, Oracle Reports, XML publisher (e-text templates, RTF templates), Workflow Builder, Oracle Application Framework.
• Worked on customization of Confidential pages and developed new pages as per teh business requirement.
• Vast experience in writing Packages, Procedures, Functions, Views and Triggers
• Worked on advanced PL/SQL collections and Bulk collects
• Have full project life cycle experience in Oracle EBS Implementation, phases which includes requirement gathering, fit gap analysis, functional & technical design, build, testing, migration, deployment, user training & warranty support
• Documentation of MD50, MD70, TE20 and MD120
• Excellent verbal & written communication skills and interpersonal skills
• Quick learner and potential to handle complex assignments single handed throughout teh SDLC
• Strong analytical, diagnostic and troubleshooting skills and ability to work in a dynamic, team-oriented environment
• Worked for Major clients such as Confidential.

TECHNICAL SKILLS

Financials: Payments, CM, iExpense

Supply Chain: PO, INV,OM

Technical: Pl/SQL, Reports, XML Publisher (RTF and e-text), Workflow Builder

Versioning tool: SVN, TFS

PROFESSIONAL EXPERIENCE

Confidential

Sr. Consultant

Responsibilities:

• Responsible for resolving teh support issues that are logged in teh Incident Management system.
• Interact wif Business user and shared service team about teh nature of teh issue and provide solution.
• Co-ordinate wif offshore team on teh support issues and responsible for resolution of teh issues as per SLA.
• Coordinate wif Business users and SMEs and understand teh gaps in teh existing processes and provide solution to teh issues.
• Customized payment instruction file for Confidential .
• Design and delivery of teh custom components.
• Interaction wif client’s business team to gather requirements, prepare and base line Customer requirement document, Functional requirement document, System integration test cases and solution deployment.
• Troubleshoot production issue and support month end activities.
• Prepare weekly status report of all teh incidents and teh progress of teh tickets wif client IT Manager.
• Work wif Oracle Support for bugs\issues and data corruption issues and implement teh solution for teh same.
• Confidential meeting for teh components that are to be migrated to Confidential .
• Perform regression testing on all teh modules and all custom components for major patch release from Oracle.

Environment: Oracle Applications R12.1.3 - Financial modules, Purchasing

Confidential

Sr. Consultant

Responsibilities:

• Analyze teh functional specification and provide technical design document.
• Developed Inventory FIFO Costing layer.
• Design and development of FIFO Inventory valuation report, Transaction report and FIFO Cost layer report.
• Perform code review, unit and system integration testing on custom components.
• Developed supplier Interface and Invoice Interface for Patient suppliers.
• Worked on support issues and provided solutions.
• Prepared MD 70, TE20 and MD 120 documents.

Environment: Oracle Applications R12.1.3 - Inventory

Confidential

Sr. Consultant

Responsibilities:

• Interact wif Business, gather requirements, co-ordinate wif offshore team and delivery.
• Analyze teh Functional Specification received from client and provide estimates for its closure.
• Provided all necessary Quality documents such as Technical Specification, Unit test case and Migration documents
• Created Interface programs to load Invoices, Confidential journals from a legacy system called Affiliated Revenue Systems to Oracle.
• Created custom Confidential Lockbox program to load credit card transactions to create Confidential Receipts and apply it against teh transactions
• Created Interface programs to interface Confidential Invoices from Concur system to Oracle.
• Created supplier Interface from RAS to Oracle using vendor APIs.
• Created new Payment process template as per teh setup of Confidential.
• Confidential to sub ledgers reconciliation reports.
• Customized supplier entry and supplier update Confidential page.
• Developed custom Confidential page and customized iProcurement page to validate project related Purchase requisitions.
• Bank, Branch, Bank account, transaction code and Bank statement set up for Bank statement load for Confidential.
• Developed many ad-hoc reports and one time scripts to halp business during Integration testing and user acceptance testing
• Support User acceptance testing, Face to face meetings, System integration testing, analyze teh defects and provide a fix Onsite - Offshore co-ordination
• Proposed and implemented many process improvement and automation ideas during teh course of teh project
• Plan teh release activities, review release notes Co-ordinate Release management, code deployment activities, during code migration to higher instances

Environment: Oracle Applications R12.1.3 -, PO, iProcurement, CM, Project Costing

Confidential

Sr. Consultant

Responsibilities:

• Analyze teh Functional Specification received from client and provide estimates for its closure.
• Provided all necessary Quality documents such as Technical Specification, Unit test case and Migration documents
• Involved in providing Confidential, User manual and live demonstrations to teh clients and Business Users
• Customization in Format payment instruction and created new Payment process template.
• Created Confidential Outbound Interface to Hyperion
• Design and development of Inter-Company Asset Transfer Report
• Developed XML Publisher Bursting reports.
• Preparation of Technical design document, Unit Test Case Document, System Integration Testing (SIT) documents
• Coordinated wif Client during System Integration Testing (SIT) and User Acceptance Testing (UAT)

Environment: Oracle Applications R12.1.3 - Finance Modules

Confidential

Sr. Consultant & Track Lead

Responsibilities:

• Involved in Requirement gathering and Gap analysis
• Creation of Confidential pages, Confidential enhancement and Confidential personalization as per teh requirement.
• Responsible for delivery of technical objects like Interfaces, Oracle reports, XML reports and Confidential pages.
• Implementation of Confidential credit card transaction for iExpense module.
• Customization of Customer Invoice and statement reports.
• Created new AME rules for a newly created operating unit.
• Understand teh functional specifications and create technical specification based on teh Functional specifications document.
• Review technical specification for Mapping and Data Migration.
• Technical and functional inputs to teh development team for any bug fixing, changes, minor enhancements etc.

Environment: Oracle Applications R12 - Payables, Payments, CM, Confidential, iExpenses, XML & Pl/Sql

Confidential

Consultant

Responsibilities:

• Track Lead, Lead a team of 4 members
• Preparation of Customer requirement document and Development requirement document
• Setup done - Payment process profiles, Payment formats, Payment templates, Internal Bank account documents, remittance advice setups
• Bank Statement mapping for SWIFT940 template, Bank statement generation and reconciliation
• Worked in Confidential supplier, Invoice interface for Confidential Localization.
• Customization of Format Payment instruction for Confidential.
• Implementation of Confidential, credit card transaction for iExpense module.
• Understand teh functional specifications and create technical specification based on teh Functional specifications document.
• Direct interaction wif Business users and providing support to technical and functional issues and period close issues.
• Interaction wif Onsite Project Managers and Business system analysts for Onsite-Offshore coordination
• Status reporting to both Offshore and Onsite project management

Environment: Oracle Applications R12.0.6, R12.1.3 - Finance modules

Confidential

Engineer

Responsibilities:

• Interaction wif Business users for gathering Requirements
• Involved in writing Technical Specification, Coding, Unit Testing and teh Review activities.
• Involved in providing Confidential and live demonstration to teh clients and Business Users.
• Deliverables:
• Interacting wif Business users and provide solutions to technical and functional issues.
• Designed Technical Specifications documents (MD70).
• Analysis & Development of Interface program and customization of Reports.
• Interacting wif onsite team and providing solution to technical issues in Confidential modules.
• Handle Business critical issues and work wif Oracle support to resolve product bug and data corruptions.
• Perform unit testing for teh developed components and creating migration documents.

Environment: Oracle Applications R12