SUMMARY

• Over 6+ years of extensive experience as Oracle Application Techno - Functional Consultant in implementation, upgrade and customization of Oracle e-Business Suite Applications (R12, 11i) and Oracle Fusion R12.
• Relevant 6 Years Techno - functional experienced in all Oracle EBS applications including Finance and Supply chain management 11i & R12 environments.
• Strong Knowledge of Oracle apps modules, including Finance & SCM modules like Order Management (OM), Inventory (INV) and Purchase Orders (PO).
• Having good hands-on experience on Financial Modules like Account Payables (AP), Account Receivables (AR), General Ledger (GL), Fixed Assets (FA) and Cash Management (CM).
• In my professional experience developed P2P applications and O2C applications like Contribute as a part of a team 30% Functional and 70% Technical knowledge, by providing support to the other professionals within the ERP development and able to work independently with the client on site.
• Being an Oracle Financial & EBS Functional expert, 2 full life cycles implementation experience of ERP application including review of the business processes system development in Multi-Org Structure and post implementation support.
• Strong Knowledge of Application Implementation Methodology (AIM), Application Object Library (AOL) implementation standards, Trading Community Architecture (TCA) and Software Development Life Cycle (SDLC).
• Expert in the functional and technical aspects of Oracle E-Business Suite/ Applications 9i, 10g and 11i deployment Requirements, Coding/Development, Customizations, Testing, and Functional User Training.
• Strong knowledge of development methodology including Structured Systems Analysis and Design.
• Proficient in RICE (Reports, Interfaces, Configuration, Enhancements) Implementation, Conversion
• Played team role in application set- Confidential, implementation, conversions, interface development, testing and end-user training.
• Evaluated the design and development needs of the client, writing functional specifications, debugging and testing, functional support and issue resolution which adhere to GAAP Accounting Principal.
• Executed best practice business procedures and processes in application analysis and design. Designed custom interfaces, process and reports to meet client’s requirements in General Ledger, OM.
• Developed an integration plan for data from a legacy system, set-up invoices, debit and credit memos, customized dunning letter and the statement cycle in the accounts receivable module.
• Extensive technical and business experience in Procure-to-pay, Order-to-cash, Quote to Cash and Assets to GL Record to Report.
• Work directly with personnel, projects and another departmental technical consultant as required in a functional role.
• Performed functionality testing, patch testing and provided recommendations for functional enhancements.
• Reconciled and maintained the School District's general and subsidiary ledgers, payroll and accounts payable and operating expenses. Prepared monthly financial statements for Federal and State funds.
• Prepared financial reports, developed processes, and performed variance analysis in accordance with business plan using Excel, Oracle Discoverer and Oracle Financial Reporting.
• Facilitated multi-unit work sessions to determine requirements, screen flows and processes
• Liaised between management and users to help define requirements and facilitate work flow.
• Good team player with good communication skills and flexible for learning new technologies.

TECHNICAL SKILLS

ERP: Oracle Applications R12 (12.2.5/12.1.3/12.0.6 ), 11i (11.5.10.2/11.5.8 ) GL, AP, AR, FA, Advancing Pricing, OM, PO, INV, iExpenses, iProcurement, iSupplier, EB-Tax, Oracle ERP Cloud R12

Programming Languages: SQL, PL/SQL, UNIX, PERL, JAVA, XML

Oracle Application Tools: Forms Builder 9i/10g/11g, Reports Builder 9i/10g/11g, BI Publisher, Discover, Workflow, ADF

Developer Tools and Utilities: SQL Developer, TOAD, SQL*PLUS, ERWIN, SQL*LOADER

Documentation Skills: AIM - MD50, MD20, MD70.

Databases: Oracle Database 9i/10g/11g/R12.

Other Tools: Putty, WinSCP, MS Office.

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia, PA

Oracle Techno-Functional Consultant

Responsibilities:

• Design, develop and execute several Customizations for various RICEW (Reports, Interfaces, Customizations, Extensions and Workflows) Software Components in ERP as a part of Account Payables solution design team.
• Document current process flows, business requirements and fit/gap analysis for custom extensions of Oracle EBS R12 financial modules including General Ledger, Accounts Payable, I Expenses, Sub ledger Accounting and Procurement.
• Working on Workday Integration Project with Oracle SOA composite to load XML files into Oracle.
• Loading the XML data files from Workday system into Oracle database through SOA composites.
• Worked on loading the XML files through SOA component and face the SOA experience as well.
• Working on AP invoice approval workflow to customize the components by using oracle workflow builder.
• Lead offshore team which working on both GXS and Workday Projects to deliver such a huge project.
• Assign the multiple work items to different developers without facing any issues and led both projects by very nice and decently.
• Hands-on experience with vendor import program and working on few customizations related to payment priorities and payment terms.
• Developed procedure for different payment terms for credit memo invoices along with selected suppliers only. They have some specific supplier then only it applicable to credit memo invoices.
• Worked on performance issue of updating state of service dff for vendor. Sometimes, when we load more invoices it is taking hours and hours of time. Try to reduce the time complexity of program.
• Developing the custom program for vendor data coming from third party system along with encrypted and writing the program to decrypt the file to load it into oracle systems.
• Customized standard Oracle reports like Suppliers Report, Account Status Report, Account Analysis Report and Backorder Summary Report as per the business requirements.
• Excellent team player, quick learner, highly motivated and ability to work independently.
• Working extensively in Oracle SOA gateway to load data files through SOA composites.
• Usually we have SOA team also but as an EBS developer I am testing xml files by using SOA console from oracle SOA Gateway.
• Worked on solution design and setup of Inventory, Purchasing & Order Management as per the client requirements and suggested business process changes.
• Requirement gathering, configured inventory, Purchasing and Order Management for three different implementations.
• Assisted in period closing and daily production support by resolving system & user issues70% Functional and 30% Technical knowledge.
• Key setups like Flex fields, Organization, Inventory parameters, UOM, Sub Inventory, Stock Locator, Item Template and Transaction type.
• Configured Auto - Sourcing rules, Approved Supplier List (ASL) and BPA to enable buyers to release purchase orders automatically from planners Workbench.
• Drop ship Functionality was setup to enable the OM team to ship the goods directly to Customers from Supplier warehouse and resolving day-to-day critical issues.

Confidential, Parsippany, NJ

Oracle Techno-Functional Consultant

Responsibilities:

• Design, develop and execute several Customizations for various RICEW (Reports, Interfaces, Customizations, Extensions and Workflows) Software Components in ERP as a part of Account Payables solution design team.
• Document current process flows, business requirements and fit/gap analysis for custom extensions of Oracle EBS R12 financial modules including General Ledger, Accounts Payable, iExpenses, Sub ledger Accounting and Procurement.
• Work on design and development of various database software applications utilizing, SQL, PLSQL, UNIX and XML Scripting.
• Extensively work on customization of R12 SLA (Sub ledger Accounting) module for developing custom complex Application Accounting Definition (AAD) as per the business requirements of Oracle Payables Module.
• Design and develop Technical specification documents embedding process flows, software components architecture and their usage, Tables, structures, processing schedules and pseudo codes for various Oracle EBS applications components.
• Perform unit testing, regression testing and support User Acceptance Testing (UAT) from the predefined test scripts and resolve defects identified.
• Design and develop various XML/BI Publisher reports and templates for Oracle Payables, Purchasing and iExpenses modules as per client requirements.
• Extensively work on month end, yearend and quarter end support and resolve various code bugs by analyzing and applying Data fixes and Root Cause Fixing Patches.
• Work in close proximity with Oracle support to resolve Code Bugs by creating Service Requests and supporting in a 24/7 mode for issue resolution.
• Work on various Software development tools like Version Control Software, Change Management Software, Defect Tracking Software, Incident Ticketing systems and plan and deliver solutions or code extensions for the monthly releases scheduled in a Waterfall environment.
• Work on performance tuning to improve the efficiency of concurrent programs, reports, SQL and PLSQL programs using EXPLAIN PLAN and creating database objects like indexes and hints as of when required.
• Design, develop or extend the functionality of various interface programs into Oracle Payables using SQL, PLSQL, SQL*Loader, Interface programs and APIs.
• Resolve various production issues on a timely manner performing detailed issue analysis and reproducing the issues. Provide resolutions and implement them meeting the client set deadlines.
• Designed and executed several Customizations and Setups in ERP as a part of Revenue Recognitions solution.
• Worked on the development of interfaces, Data Conversions, Developing Forms, Reports, Customizing Oracle Reports in order to Cash cycles touching various modules such as PO, AP, GL.
• Implemented AP Invoice import through Payables Open Interface Import Program.
• Responsible for Journal Imports from all other modules like Accounts Payables (AP) into General Ledger (GL).
• Designed and created custom form using Forms 10g tool to hold lookup cross reference values between legacy system and oracle apps. Registered the form and migrated forms executable file (. fmx) to AU TOP on forms server of client.
• For OAF pages design I used little of Java code like concepts of OOPS concepts (Inheritance).
• I used getter and setter methods to design the page layouts and styles.
• Our Java script code to OA Framework applications through controller customizations using setter methods for Java script events that are exposed on form web beans such as check boxes, text inputs, and so on

Environment: Oracle Applications R12.1 (PO, AP, GL, iProcurement, iExpenses), Oracle Forms/Reports 10g, SQL*Loader, TOAD, SQL Navigator, SQL Developer, PL/SQL, Winscp and Putty.

Confidential, Chicago, IL

Oracle Techno-Functional Consultant

Responsibilities:

• Planning, finalizing and Preparing Primary Ledgers, Reporting Ledgers, and Ledger sets as per client reporting requirements
• Build the SOA integrations with EBS Application services by using middleware services like Rest API’s.
• Developed advanced pricing get price api as per their custom price development and build with JSON format for integrations.
• Worked with implementing new business requirements using Purchase Orders cancellation API / Price list API / Inventory Item in bound and Item outbound APIs.
• Extensive development experience and expertise extending Oracle 11i Advanced Pricing Applications (11.5.10) using Pricing Entities, Price Breaks, Pricing Modifiers, Pricing Contexts and Attributes and pricing APIs, also having good experience with pricing engine rules.
• I used to post the request and get response from the SOA application as well and load the data in Oracle.
• Involved in creating a Form that will be used as a Front-End tool for taking and validating User inputs for Bulk Sample Orders Post Production Cleanup process and using Oracle APIs to perform the task.
• Created intercompany Transaction, Consolidation, Elimination entries setups and configuration for use. The use of ADI wizards like Budget wizard, Journal wizard and report wizard simplified work with general ledger.
• Designed and executed several Customizations and Setups in ERP as a part of Revenue Recognitions solution.
• Documented the current process flows, business requirements and fit/gap analysis for R12 General Ledger, Accounts Payable, Accounts Receivable, Cash Management and Treasury.
• Provided functional expertise on Encumbrance/Fund Accounting in the Public Sector EBS applications
• Delivered workshop to end users on the R12 SLA (Sub ledger Accounting) architecture.
• Business process analysis and requirement gathering for new customization, report development.
• Involved in I expense project costing, integration, performed configuration setups related to project accounting for expenditures types, expenditure classes and categories.
• Conducted CRP, UAT and training for end users and production support.
• Performing Business Requirement Study in Financials and modelling Future Process Model and preparing AS-IS (BP040) and TO-BE (BP080) documents.
• Efficient identification and gathering of Business Requirement, Business Process Analysis, Gap Analysis, Design, Requirements Definition, Development and Testing
• Worked on SLA (Sub Ledger Accounting) rules to replace traditional transaction codes for generating multiple accounting representations for one business transaction
• Proficient in delivering apt Techno-Functional skills to accomplish the project goals using the extensive experience gained in Oracle - GL, AP, PO, EB Tax, Projects and CE
• Remarkable negotiation and coordination skills with the Global / Offshore Business Partners, External systems and Team members

Environment: Oracle Applications R12 (Manufacturing, Shipping, OM, Packing), Oracle Forms/Reports 6i, SQL*Loader, TOAD, SQL Navigator, SQL Developer, PL/SQL.