PROFILE SUMMARY:

• Over 12 years of experience as Techno Functional Consultant in Oracle E - Business Suite Applications
• Implementation and technical expertise in Oracle Applications R12/11i, across the Financials and SCM Modules such as Payables (AP), Receivables (AR), General Ledger (GL), Oracle Purchasing (PO), Inventory (INV), Order Management (OM), Oracle Pricing (OP), Oracle Project Costing(PA), Oracle Assets(FA),
• i-Procurement, i-Supplier, i-Expenses and System administration (AOL)
• Experience in designing, coding, testing custom applications with an integration to Oracle Applications or other custom applications.
• Experience in developing inbound and outbound Interfaces for Accounts payables, Oracle General Ledger, Accounts Receivables, Purchasing, Order Management and Inventory modules.
• Experience in Oracle Approval Management Engine Configurations.
• At present working as Oracle E-Business Techno-Functional Consultant at Onshore in U.S.A(Tampa, FL) for employer IBM India Private Limited
• Working in U.S.A client site since OCT-2013(4+ years)
• Experience in all phases of the system development /implementation/application maintenance/operation life cycle.
• Completed Bachelor of Technology in 2004(Regular) and Master of Business Administration in 2012(Correspondence)
• Having H1B and need a new employer and transfer.
• Aspiration is to get a long-term assignment and exposure in US IT companies.

HIGHLIGHTS:

• Experience in Oracle 11i and R12.
• Proficient in writing stored procedures, Packages and functions using SQL & PL/SQL, Advance Pl/SQL Concept.
• Strong perseverance and diligence towards attaining challenging goals and effective time management.
• Self-motivated, excellent team player with proven leadership skills.
• 8.5 Years’ Experience in Indian IT Industry as offshore consultant and 4 years’ Experience in Unites States IT industry as onshore consultant in Oracle Apps/EBS techno functional area.
• Technical Experience in Building and Customizations of
• Oracle D2K report-12+ Years
• Oracle SQL & PL/SQL, Dynamic pl/sql, Advanced Pl/SQL Concept. -12+ Years
• Oracle interfaces-12+ Years
• Oracle Conversions -12 +Years
• Oracle Extensions-12+ Years
• Oracle workflows-12+ Years
• Oracle XML Publisher reports -12+ Years
• Oracle Web-center Capture 10g/11g-3 Years
• Oracle Web-Center Form Recognition Services 10g/11g-3 Years
• Oracle ADF Customizations. -2+ Years
• Oracle OAF Customization. -2+ Years
• Unix Scripting-4 years
• Oracle cloud based solutions-2 Years
• Profound skills in Oracle workflows that includes
• Creation of new workflows, Customization of standard workflows, Timeouts-12 Years
• RFI customizations, Forwards/approve/Reject custom notifications
• Approver Groups/Queue/Peer approver groups workflow Routing customizations
• Workflow customization for AME. Workflow-ADF integration, Workflow - oaf integrations.
• Extensively worked on modules
• Oracle Financials (AP, AR, GL, OPM, i-supplier, FA, Projects, I-expense)-12 Years
• Oracle SCM (Purchasing, Inventory, I-Procurement, OM, Pricing)-12 Years
• Oracle, I-Expenses-12 years
• Oracle Application developer (AOL)-12 years
• AME-Approval Management Engine Design-5 Years
• Oracle AOL and SYSADMIN (User Management, Concurrent program management etc.)-12 Years
• Oracle Alerts-3 years
• Oracle Web Center Capture and Oracle Form Recognition Services-3 years
• Extensively worked on the oracle ERP life cycles
• Procure to Pay(P2P)
• Order to Cash(O2C)
• Record to Report(R2R)
• Prepared MD50, MD70, BR100, TC200 documents using AIM methodology
• Followed and Worked in ITIL process for the Application Maintenance Support Projects. Worked on Incident Management, Change Management, Problem Management, Release Management Processes.

SKILL SETS:

Functional Modules:

• Having a good knowledge and hands own experience in Oracle E-business Modules, such as
• Oracle Application Financials 11i &R12 (AP, AR, GL, I-expenses, electronic-invoicing)
• Oracle Application SCM 11i &R12 (Purchasing, Inventory, I-procurement)
• Oracle Application developer 11i &R12 (AOL), Oracle alerts

Technical Components:

• Technical Experience in Building and Customizations of
• Oracle Sql, PlSql, Dynamic SQL, Advanced PlSql, Visual Basic Scripting
• Custom Hooks, Packages, Procedures, Functions, Tables, Synonyms, Grants, Views
• Oracle D2K reports (Text, HTML, XML, Excel,CSV)
• Oracle D2K Forms, Custom pll's
• Oracle inbound Out Bound Interfaces (P2P/O2C Flow)
• Oracle Conversions (Oracle HRMS, P2P, O2C)
• Oracle Extensions, OAF Personalization, Customization
• Oracle Workflow Customization, New Custom Workflows
• Oracle XML Publisher reports
• Oracle XML Gateways, XML integration, XML Template, XML Source Code Customization
• Desktop integrator
• Oracle Web Center Capture 10g-Worked on Installation/Configuration/Customization
• Oracle Web Center Form Recognition 10g
• Oracle ADF customizations.
• Experience in Oracle Software as a service a(SAAS) and Oracle Platform as a service (PAAS)

PROFESSIONAL EXPERIENCE:

Tampa, FL

Oracle E-Business Techno-Functional Consultant

Responsibilities:

• Designed and developed a custom e-invoice Application called P2PXpress.
• P2PXpress is a P2P electronic invoice approval and payment system for Citi Payables department.
• Created and developed New Custom workflows for PO and Non-PO invoice Approval process
• Developed Oracle API’s and Workflow packages for ADF Integration.
• Configured Oracle WebCenter Capture and Oracle WebCenter Form Recognition (11g) for capturing
• Scanned and Emailed Vendor Invoices for P2PXpress.
• Performed Functional Setup or Oracle ADF Integration for P2PXpress
• Created Value Sets, Lookups, AOL Messages, Maps, System Profiles, Menus, Responsibilities
• Worked on Supplier and site level DFF configuration for P2pXpress logix
• Developed XML publisher reports
• Developed Oracle ADF Reports for Invoice details and Cycle time reports
• Implemented I Supplier for Oracle Payables
• Developed API’s for I Supplier Integration with Other applications like P2PXpress
• Customized workflows for adding the iSupplier related changes.
• Performed Acccount Standardization setups for Oracle Payables
• Performed Fit Gap analysis for Oracle Cloud Solution for Oracle EBiS
• Developed Custom solution for Oracle payables to Projects cost interface logics

Environment: Oracle Applications R12 (12.1.3) (AP, PO, FA, Projects GL), Oracle 11g (SQL, PLSQL), Reports 11g, Oracle workflow. ODC, OFR. Visual Basic Scripting.

Oracle E-Business Techno-Functional Consultant

Responsibilities:

• Performed functional setups for Payment manger, profile xml integrations.
• Implemented Check Printing, Positive pay file for Akamai.
• Developed Supplier, Sites, Bank Conversions. Auto lock box, Bank file integrations for cash management
• Developed PO requisition approval workflow account generator customization.
• Configured AME for Requisition Approval workflow, Invoice Workflow and Expense Workflow
• Performed AP invoice workbench form personalization’s. PO Xml gateway template setup and xml generation
• Created custom PO RTF template and attached the custom template in the PO requisition workflow.
• Developed Alert retrofit for the vendor and employee paid invoices.
• Performed custom remittance advice report setup and xml template customizations.
• Personalized OAF requisition page personalization for adding an LOV.
• Developed Amex Outbound interfaces.

Environment: Oracle Applications R12 (12.1.0) (AP, AR,I-procurement, I-expenses), Oracle 11g (SQL, PLSQL) Workflow

Redwood City, CA

Oracle E-Business Techno-Functional Consultant

Responsibilities:

• Developed GL conversion packages. Supported operational team during the GL conversion process.
• Developed Oracle Packages to extract the 11i data and based on mapping and account structure define.
• Performed functional setups for Converting the balance to reporting and accounting ledger in R12 respectively
• Customized sub ledger accounting, intercompany and Trial balance .
• Developed accounting reports, Intercompany, GL sub ledger drilldown reports and Translation adjust report
• Developed 11i to R12 reconciliation reports. Designed and setup the GL Intercompany flow per the REIT
• Performed Subledger Accounting Setups

Environment: Oracle Applications R12 (12.1.0) (GL, Sub ledger accounting, PO), Oracle 11g (SQL, PLSQL), Reports 10g.

Boston, MA

Oracle E-Business Techno-Functional Consultant

Responsibilities:-

• Led the Hyper care support team for the R12 implementation.
• Well-versed Knowledge on Order management flow(Enter Order, Book Order, Pick Release, Ship Confirm, Invoice, Receipt)
• Developed Order Management Inbound interface from Legacy System source SECCUREBASE for Order Management.
• Developed APIs for the Customer and Sites conversion from 11i system to R12
• Customized Auto invoice interface for the receivable import
• Customized Print Invoice report.
• Performed setups for the Auto Accounting.
• Customized Auto lock box logics to apply the receipts lines logic.
• Customized the Revenue Recognition .
• Performed advance collection setups and dunning letter based on Score engine and rates.
• Customized Oracle Order Management Lines Modifier logics based on Oracle Advance Pricing Module Setups.
• Performed Functional Setups for Qualifier and Modifier in oracle advanced pricing
• Created Pricing Formulas
• Customized the Pricing Attributes API’s based on the Modifier New logic.
• Customized the requisition account generator for the CAPEX and OPEX accounts, Project and NonProject Type.
• Configured AME for Requisition and Expense approvals.
• Performed Month end techno functional support for AR/AP account closing as well as issue resolutions after implementation
• Developed inbound/outbound interfaces and relative integrations issues/enhancements of Iron Mountain applications.
• Developed receivables inbound interface from Legacy system SKP,
• Developed spend file out bound extract to ZYCUS from Oracle Payables
• Developed outbound interfaces of customer transaction/GL details to HYPERION
• Developed customer receipt notification functionality.

Environment: Oracle Applications 11i (11.5.10) (GL, AP, AR, HRMS, I-Procurement, I-expenses), Oracle 8i (SQL, PLSQL, Reports 6i, TOAD, SQL Loader and UNIX, Data loader, XML Publishers, Oracle workflow.

Oracle Apps Senior Consultant

Responsibilities:-

• Designed and implemented customizations for oracle P2P cycles including the modules of Oracle i-procurement Accounts payables and General Ledger as main modules and Accounts Receivables, HRMS as supporting modules
• Maintained proactive interaction with the client to understand business practices to aid in system configuration
• Designed i-expense, I-procurement AME’s for non-project as well as project requisition/expense workflows
• Worked on Requisition Initiated Change Order Process and Requisition Approval Workflow customizations.
• Customized PO approval and Requisition/change approval workflows for automating the Requisition, Purchase Order and Account payable flow. The design checks the amount for a specific requisition and if meets the threshold set will automatically match the Invoice with the vendor Po and receipt based on the workflow notification verification approval from Requisition, Buyers and invoice approvers.
• Preparing FD, TD related to the change/new development requested. Identifying the functional/Technical requirement. Analysing Gap and finding out the best suit customization package. Worked on Failure mode analysis, route cause analysis, and management /monitoring reports, lean management process etc.
• Worked Oracle HRMS employee, assignment, element entry interface. Worked in GL interface
• Have experience in interface, legacy system integration, encryption/decryption methodology using UNIX
• Worked on OAF personalization/customization for expense header and lines page.

Environment: Oracle Applications 11i (11.5.10) (GL, AP, AR, HRMS, I-procurement, I-expenses), Oracle 8i (SQL, PLSQL, Reports 6i, TOAD, SQL Loader and UNIX, Data loader , XML Publishers, Oracle workflow.

Oracle Financial Consultant

Responsibilities:-

• Performed functional issue solution related to month end closing of the business in Accounts payables, General ledger and Accounts Receivables.
• Resolved issues related to unaccounted entries, un posted GL entries, sub ledger entries during month end processes
• Assisted clients in reconciliation of sub ledger entries with GL entries
• Sorted out the problem that can arise for expense items, inventory items, assets item P2P accounting flow
• Identified the issues while GRN (Receipt) creation, Purchase order creations, Invoice matching, payments.
• Prepared RFC for creation of purchasing hierarchies, positions, assignments, setting up of buyers
• Prepared flow and code of India localization taxation(TDS) logic
• Prepared Functional design and provide /direct assistance in building D2K Reports
• Prepared TD, Build for interfaces in modules like AR, AP
• Handled a short-term dash board P2P assignment inside the project.
• P2P dash board is an integration with the outside legacy system of oracle which Shows all the 2 way ,3 way matched and 4way matched accounted invoicesP2P Flow.
• Simultaneously handled the OLM (Oracle Learning Management) application as part of the application maintenance
• Prepared FD, TD and developed six XML publisher circle level reports and three Corporate(central) level reports for induction, refresher, PKQ topic wise, PKQ team wise, agent wise, trainer wise, attrition scenarios
• Implemented the process of automated user /CWK id creation, deletion, password reset through LMS content server uploading for efficient user management process. The temporary table stores the call ticket number for audit purpose

Environment: Oracle Applications 11i (11.5.10) (GL, AP, AR, Sys Admin, Alerts, OLM, HRMS), Oracle 8i (SQL, PLSQL, Reports 6i, TOAD, SQL Loader and UNIX, Data loader, XML Publishers.

Software Engineer

Responsibilities:-

• Prepared functional design, technical design and build for HRMS ,Payroll,P2P components
• Developed Complex D2K Report for Carillion Employee Pay Slips
• Prepared FD, TD, build for employee, assignment, salary Conversions
• Developed Oracle Conversion Packages and API;s for elements conversion.
• Prepared TD, build for employee benefits/pension schemes out bound interface
• Performed Payroll Fast Formula Setups
• Performed Oracle Time and Labor Setups
• Developed Technical designs and codes for purchasing/accounts payable modules like purchase order interface, Requisition Interface. Worked on pl/sql extension which Modified the invoice validation program to include different new holds (3 New holds) which is based on the Po Matching (2 Way). Designed and developed outbound interface exception program for 2way matching invoices which is inputted in to a Process re conciliation tool.
• Developed codes for a separate Invoice, purchasing hierarchy which is used for the approval process of 2 ways matched invoices. Etc.
• Prepared technical design for O2C discoverer/D2K reports. This included customer credit terms, credit transaction reports.

Environment: Oracle Applications 11i (11.5.10) (GL, AP, AR, AOL, Sys Admin, HRMS, Payroll), Oracle 8i (SQL, PLSQL), Forms 6i, Reports 6i, TOAD, SQL Loader and UNIX

Chicago, IL

Software Engineer

Responsibilities:-

• Prepared technical design and build code for Supplier, Sites, Contact Conversion
• Prepared technical design and build code for GL balance conversion, employee conversion
• Prepared technical design for Approval management engine of I-expense approval process
• Customized supplier exception report, Invoice aging reports, Accounts payable trial balance report, supplier paid invoice history report, supplier payment history report, invoice on hold report, Accrual reconciliation report as per the business requirements.
• Reconciliation of customized AP trial balance with GL trial balance had done for testing purpose
• Developed a package to import expense information into Oracle Payables
• Prepared TD and Developed credit card transactions inbound Interface
• Prepared TD, Developed supplier out bound interfaces. Worked on CR’s and defect fixing. Prepared test cases.

Environment: Oracle Applications R12 (GL, AP, AR, AOL, Sys Admin, i-expense,), Oracle 10g (SQL, PLSQL), D2K reports/Forms, TOAD, SQL Loader and UNIX, ADI, XML Publisher

Junior Software Engineer

Responsibilities:-

• Prepared functional/technical analysis document for current environment (11.5.9).
• Prepared functional/technical analysis document which depicts the difference between 11.5.9 and 11.5.10 for AP, AR, and GL with the help of oracle meta-link.
• Finding gaps between two instance and preparation of gap analysis documents
• Preparation of functional/technical analysis documents which explains the process of filling these Gaps
• Creation of User Manuals/Test Scripts for upgrade environment.
• Evaluation of data (including customized components) in both instances.
• Preparation of set up docs.

Environment: Oracle Applications 11i (11.5.9, 11.5.10) (GL, AP, AR, AOL, Sys Admin, Alerts), Oracle 8i (SQL, PLSQL) Forms 6i, Reports 6i, TOAD, SQL Loader and UNIX