SUMMARY

• Having around 9 years of IT experience as Oracle Apps consultant in the areas of Design, Development, Support and Maintenance involving projects like implementation, up gradation and Production support.
• Extensive experience in R12 implementations and Upgrade projects which includes working with business/functional teams on the conversions, Interfaces, workflows, client specific requirements and involving in planning, estimating, staffing, phasing, data migrations for technical objects for Oracle Financial modules.
• Extensive experience in working with Oracle Applications 11i/R12 Finance modules such as Oracle Payables (AP), oracle Receivables(AR), General Ledger(GL), Sub ledger Accounting(SLA), cash management (CM), Fixed Assets (FA), Trading Community Architecture(TCA), Oracle Customer Data Hub (CDH), Oracle Lease Management (OLM), Oracle Project Accounts(PA) and working experience on other modules such as Purchasing (PO), Inventory (INV), Order Management (OM), Service Contracts (SC), Install Base (IB).etc.
• Well versed with P2P and O2C flows and working experience on the respective components.
• Good Hands on Oracle Customer Data Hub (CDH) and Trading Community Architecture (TCA).
• Extensive experience in working with SQL, PL/SQL, SQL*Loader, Workflow customizations, form personalization’s, Oracle Forms & Reports (6i & 10g).
• SME (subject Matter Expert) in Accenture on XML/BI Publisher Reports.
• Expertise in developing RICEW components (Reports, Interfaces, API’s, Conversions, Workflows & Extensions) in Oracle Applications E - Business suite 11i and R12.
• Good Experience in supporting the EBS modules and creating, maintaining and managing SR’s with Oracle Support via Metalink.
• Proven ability to deliver the task on time with excellent quality and customer satisfaction.
• A good team player and leadership skills, capable of quickly adapting to new challenges and environments.
• Product expertise in Oracle E-Business Suite Applications (11i & R12) - ERP.
• Expertise in SQL and PL/SQL programming to develop stored procedures, functions, packages and triggers.
• Expertise in performance tuning using EXPLAIN PLAN, TKPROF to tune SQL queries, custom objects.
• Fair Knowledge on ADOP Patching tool steps, pre-requisites and process.
• Fair knowledge on APEX tool, designed developed custom web pages, reports and presentation charts.
• Hands on development of interfaces, Inbound and Outbound Conversions and used standard API’s. Expertise in development of Extensions to add additional validations and functionality to seeded oracle processes to meet the client's requirements.
• Experience in supporting Sabrix/Vertex Tax Engines
• Well versed with AIM Methodology and documenting the work done in a well-fashioned manner.
• Writing and maintaining Technical Specification document MD70 and Functional Specification document MD50.
• Worked with Oracle Utilities like SQL*Loader, UTL File, Toad, Putty and other utilities like SQL developer
• Insightful experience in all phases of the system development /implementation life cycle.
• Sound Knowledge on designing the requirements and GAP Analysis.
• Excellent Communication, Analytical, Interpersonal and Presentation skills.

TECHNICAL SKILLS

ERP: Oracle Applications 11.0.3, 11i, R12

Operating Systems: Unix, Linux, Windows NT/ XP, 2003

Modules: AR, AP, CM, FA, GL, INV, PO, OM, SC, IB, OLM, HRMS

Reporting Tools: Oracle D2K Forms & Reports 10g, XML/BI Publisher, workflow, APEX

Languages/Packages: SQL, PL/SQL, Java, shell scripting

Databases: Oracle 11g, 10g, 9i & 8i

Utilities: SQL*Loader, Data Loader, TOAD, KINTANA

PROFESSIONAL EXPERIENCE

Confidential

Finance Techno - Functional Consultant

Responsibilities:

• Involved in Analyzing, Designing, Developing, Implementing phases of a project ACV on their custom modules Bookings and Commissions.
• Involved in business meetings, requirement gathering from business and data mapping phases
• Prepared Functional Design for the new project ACV on Bookings modules.
• Assisted Technical team in Technical design, development and unit test phases in terms of functionality and requirements.
• Leading Off shore team and make sure development and testing is progressing in right phase.
• Worked on TCA and Supplier integration.
• Created custom user interfaces to maintain Party, Location, Party sites, Party site extensions, Contact, Contact Points, Account, Account Sites, Customer profiles.
• Worked on TCA and Supplier integration.
• Created and set up Data Quality Management (DQM) rules for search, duplicate identification and duplicate prevention
• Created Procedures, Functions and other database objects using SQL and PL/SQL.
• Assisted QA team in creating the test scenarios, test cases and involved in phases of UAT, SIT, CRP, etc.
• Preparation of MD070 Technical specification documents based on Functional Specifications.

Confidential

Techno Functional Consultant

Responsibilities:

• Analyze, Design, Develop a mini project for implementing Application outbound and EDI interfaces from EBS end integrating with TIBCO.
• Implementing R12 Payment Formats and Invoice printing Documents.
• Designed and Developed INTERCOMPANY AP Integration Program and support till it went live.
• Created custom user interfaces to maintain Party, Location, Party sites, Party site extensions, Contact, Contact Points, Account, Account Sites, Customer profiles.
• Worked on TCA and Supplier integration.
• Preparation of MD070 Technical specification documents based on Functional Specifications.
• Writing Unit Test cases and testing after completion of the Object.

Confidential

Lead Consultant (Finance Track Lead)

Responsibilities:

• Senior developer for finance track enhancements, developments and issues mainly dealing with finance modules AR, AP, GL, SLA, CM and OM, PO modules integration.
• Analyze, Design, Develop, tested several migration projects like Werfen, Genomics, MDET tax customizations, Co-fax which involves several components like conversions and reports.
• Handled the conversion of Optio reports to XMLP reports includes, Design, develop, testing and delivery of the objects.
• Did many conversions on PO, OM, Customers, and Vendors which can re-usable across all the projects for data migration.
• Worked on Complex payment formats and various cheque printing reports.
• Worked on components like EDI820, AP HOLD Resolution workflow, Supplier, site, bank account, invoices, payment formats in AP Module.
• Worked on TCA and Supplier integration.
• Created custom user interfaces to maintain Party, Location, Party sites, Party site extensions, Contact, Contact Points, Account, Account Sites, Customer profiles.
• Developed and support AR transactions, receipts, Lockbox interfaces and conversions and several outbound interfaces etc. in AR modules.
• Did setup’s and developed bank interfaces and bank statement uploads in CM module.
• Worked on GL interfaces for various Interfaces and Conversions, SQL, PL/SQL, stored procedures and packages
• Developed Outbound Interface in several modules using UTL FILE utility to generate extract and FTP file to different server locations.
• Developed several EDI gateways from ERP side which integrates with SOA suite.
• Analyze, root cause analysis, Applying fixes, providing solutions for Prod Issues.
• Extensive Experience in OM API's like order creation, order updating and pricing.
• Worked on several Other modules as a part of integration and development team
• Optimize Contract Renewal Process: Interface data from Oracle (Oracle Service Contracts and all data related to SCs) to a third party system, so that renewal opportunities can be quoted to the customer; When SC is ready to be “booked”, Renewal Manager interfaces SC back to Oracle SCs for signing and invoicing.
• Designing and implementing the data conversion methodology to bring Installed Base (IB) instances and Service Contracts (SC) from a legacy system into the Oracle 11i application.
• Worked on PO accounting customization flow and approval hierarchies.
• Responsible for Analyze, Design, Develop, Unit test the components.
• Actively involved in day-to-day support activities for Oracle EBS 11i Finance Multi-Org stream by troubleshooting, providing solutions and communicating with the users through Support tickets.

Confidential

Lead Developer/Solution Architect

Responsibilities:

• Worked on Modules like Receivables AR, Payables AP, General Ledger GL, Human Resources HRMS, Purchasing PO, Order Management OM, Install Base IB, Service Contracts SC etc.
• Interacted with onsite functional consultants and end users to capture business requirement and mapping.
• Designed and developed several FINANCE and HRMS Components such as Customer conversions, Invoice conversions, Employee, Employee Assignments, and Employee Absence conversion in HRMS.
• Designed and Developed bank statement upload interface in CM for the custom requirement.
• Designed and developed various payment formats on R12 Oracle payments module like remittance advice and check printing for various banks.
• Designed, developed the PO conversion and interface programs and tested the whole P2P cycle.
• Designed and Developed Apex applications for interfacing data and developed several reports for business teams, who works on custom applications.
• Designed and developed customer conversion and interfaces.
• Designed and Developed interfaces and extensions in order management, install base, Field Service and service contracts modules.
• Designed the technical specification for all the developed components with the unit test scripts.
• Worked various complex XML publisher reports on various projects, as I’m SME on XML Publisher reports.

Confidential

Senior Developer

Responsibilities:

• Worked on Modules like Receivables AR, Payables AP, Project Accounts PA, Purchasing PO, Order Management OM and Fixed Assets FA.
• Developed purchase order interface in PO with standard program tie back to the staging table.
• Developed Common utility UNIX host program which will track all the conversions results to control tables.
• Developed several host scripts to deploy components across instances using FNDLOAD and java utilities.
• Developed the payment formats remittance advice and check printing in AP.
• Developed complex Interface for project, task, and budget conversion in PA modules.
• Developed barcode report for the fixed assets and Purchase Order Detail Report in PO.
• The PO Approval Workflow is used to approve new documents as well as approve revisions to the Purchase Orders using workflow builder.
• Developed purchase order conversion and interface programs to create, modify and delete the PO's in ERP
• Provided post go-live support for developed components as well as for other components.

Confidential

Developer

Responsibilities:

• Fixing General issues, Month end and period end issues on priority basis.
• Doing Custom Developments and support scripts on business requirements.
• Developed Extensions to custom business flow from Order management, install base to service contracts for raising credit memos and invoices in AR.
• Developed complete flow of new employee access system, for HRMS and E-Buss suite (which includes, when an employee joined in any department, creating employee in oracle apps, creating employee assignments, create login for E-buss suite, adding responsibilities, emailing user with access details, etc.).
• Worked on Service contracts conversion
• Worked on Monthly Billing report and Optimization and simplification of the existing custom objects in service contracts module.
• Developed APEX custom module, to create and maintain Oracle Login and responsibility matrix automation, including creating persons and assigning roles in HRMS.
• Developed Receivables interface using interface tables and API’s to cater different requirements for different business
• Developed AR Receipts interface to create receipts from legacy system and receipt Application program to apply the receipts to respective invoices.
• Developed Conversion programs to import customers, customer sites, vendors and Employees.
• Developed XML based XLS reports for business to listing order management and service contract details.