SUMMARY:

• More than 15 years of IT Experience in Design and Development of software Systems in the areas of Oracle eBusiness suite (Oracle EBS).
• Proficient in Developing, Customizing, and Implementation of forms 10g, reports 10g and XML Publisher reports.
• Experience in coding Interface Programs for importing data from Legacy Systems in different modules mainly Oracle Financials (AP, AR, GL)
• In depth experience in Implementation and post production support in EBS R12
• Experience in configuring new Descriptive Flexfields (DFF) as per the business requirements
• Strong PL/SQL skills with the ability to write efficient, complex queries against very large data sets good knowledge of tuning of queries.
• Extensive experience using AIM (Application Implementation Methodology)
• In depth knowledge in creating Functional (MD50) and Technical (MD70) documentation
• Worked with State as well as Federal/Provincial Clients
• Good Knowledge in procurement software Coupa
• Worked as Oracle Data Integration Architect in integrating of Coupa with Oracle EBS (Payables)
• Good working experience in Forms 4.5, 5.0, 6i, 10g Reports 2.5, 3.0, 6i, 10g, PL/SQL, BI Publisher, Oracle Databases 7/8/9i/10g/11i and RDBMS Concepts.
• Good Techno - Functional knowledge of Oracle Financials (AP, AR, GL), Order to Cash, P2P, Cash Management, Order management, Oracle Inventory, Oracle HRMS, Oracle Trading Community Architecture (TCA), Oracle Fixed Assets, Oracle Project Accounting
• Experience in the analysis, design & development of financial & accounting applications.
• Good experience in MS Office - Project, Visio, PowerPoint, Word, Excel
• Oracle Certified Professional (OCP) who is highly motivated and thrives on seeking knowledge, adapting best practices, and collaborating with globally diverse team members.
• Currently pursuing for Oracle E-Business Suite R12 Financials Certified Expert Consultant

SKILL:

Oracle EBS 11.5.10/12.1.3 /12.2.4/12.2.6 : Oracle Manufacturing (INV, BOM, WIP, Costing), Oracle Financials (AR, AP, GL, CM, FA), Oracle Supply Chain (OM, Shipping, QP, PO, ASCP), Oracle HRMS

Databases: Oracle 7/8/9i/10g/11g

Languages/ Tools: Developer/2000- Oracle Forms 4.5, 5.0, 6i,10g, Oracle Reports 2.5, 3.0, 6i,10g, SQL, PL/SQL, SQL*Loader, TOAD, Oracle SQL Developer, BI Publisher (XML Publisher), Unix Scripting

Operating Systems: Windows 2000 Server / Professional UNIX (AIX, Solaris and HP), LINUX

WORK EXPERIENCE:

Confidential, Newark, NJ

Senior Oracle EBS Techno-Functional Consultant

Responsibilities:

• Creating new custom PL/SQL packages as per the functional specifications
• Gathering requirements from users creating technical specifications for the same
• Creating new reports in BI Publisher
• Providing technical support for Oracle iExpense, AP, AR, GL

Environment: Oracle EBS 12.2.6 Oracle iExpense, AP, AR,GL

Confidential, Jacksonville, FL

Senior Oracle EBS Techno-Functional Consultant

Responsibilities:

• Working at Confidential Technologies to provide Oracle EBS production support for their client
• Providing technical support in Oracle Accounts Receivables, Accounts Payables and PO

Environment: Oracle EBS 12.2.4 (Oracle Financials (AR, AP)), PO

Confidential, New York City, NY

Oracle EBS Data Integration Architect

Responsibilities:

• Confidential in house project to replace the current Ariba Procure to Pay system with Coupa Cloud based Procure to Pay system. Also involved in implementation of in house Supplier Information Management system called Vetted.
• Gathering business requirements from the users and creating functional documentation for the Inbound and Outbound AP Interfaces from OracleEBS
• Mapping Columns from Coupa to Oracle EBS and doing the Gap Analysis
• Creating different types of purchase orders in Coupa for testing the integration with Oracle EBS
• End to end mock testing in different Instances like CRP, SIT and UAT
• Assigning and Managing work to off shore technical team
• Good Understanding of Agile Software Methodology to create and track stories
• Creating functional documentation MD50
• Mapping columns from Vetted to Oracle EBS and doing the Gap Analysis
• Configured new Flexfields to as per the business requirements

Environment: Oracle EBS 12.2.5 (Oracle Financials (AR, AP, GL)), FA, CM, P2P Cycle, Oracle Order

Confidential, Warwick, RI

Senior Oracle EBS Techno-Functional Lead

Responsibilities:

• Creating new PL/SQL packages to automate the Fairshare and Processing processes in OM.
• Gathering requirements from users creating functional and technical specifications for the same
• Creating new reports in Oracle reports
• Providing technical support in various Oracle EBS modules like Inventory, Accounts Receivables, Accounts Payables and General Ledger, OTC
• Configured new Flexfields in Item Master to support new business requirements

Environment: Oracle EBS 12.2.4(Oracle Inventory, Oracle Financials (AR, AP, GL)), Oracle Order to

Confidential, Burlington, MA

Oracle EBS Techno-Functional Lead

Responsibilities:

• Working with the 3PL (Third Party Logistics) to get the legacy data as per Oracle EBS
• Coordinate with functional consultants to map the data and get the MD50’s
• Hiring and managing the resource for data integration
• Creating Inbound Interfaces Inventory Item’s (Master and Organization), Inventory Material Transactions, Order Management, AR Invoices and creating shipping API’s using PL/SQL Packages
• Providing resource and work estimation for data integration
• Created technical documentation MD70’s

Environment: Oracle EBS 12.2.4(Oracle Inventory, Oracle Financials (AR, AP, GL)), Oracle Order

Confidential, Jacksonville, FL

Senior Oracle EBS Techno-Functional Lead

Responsibilities:

• Participated in 11i to R12 upgrade.
• Retrofitted 11i custom RICE/CEMLI objects to R12
• Upgraded forms from 11i to R12 (Forms 6i to 10g)
• Upgraded reports from 11i to R12 (Reports 6i to 10g)
• Reviewed the existing code and made the changes to use R12 functionality/new features as necessary.
• Successfully Implemented Oracle Inventory (R12.1.3) at JAA
• Gathered data conversion requirements from BA mapped the legacy data from DataStream with oracle EBS tables
• Extracting data from legacy system DataStream and inserting the data into Oracle EBS staging tables for conversion and cleansing the legacy data in Oracle
• Designed and Developed Item Conversion to Import legacy inventory items in master and child organization
• Developed custom interface program to load inventory ( INV ) Adjustment data from external system into MTL TRANSACTION INTERFACE and MTL TRANSACTION LOTS INTERFACE tables
• Created Inbound Interfaces using PL/SQL packages for Inventory, Categories, Costing and On Hand Quantity to import legacy system data into Oracle EBS using PL/SQL Packages
• Reconciling of data in legacy system with oracle EBS once the integration is completed
• Providing estimation for technical deliverables in different phases of implementation of the project
• Worked closely with Business Analysts in gathering functional requirements (MD 50) and created technical documentation (MD 70)
• Created a new Oracle Form to enter subcontractor details in Purchasing and also created new Flexfields
• Providing technical support in various Oracle EBS modules like Inventory, Accounts Receivables, Accounts Payables, General Ledger, Order to Cash, Oracle EAM and HRMS

Environment: Oracle EBS 12.1.3(Oracle Inventory, Oracle Financials (AR, AP, GL)), Oracle project Accounting, Order to Cash, Oracle EAM, PO, HRMS, Oracle SQL Developer, Oracle PL/SQL 9i, Executive Dash reporting tool, Oracle Forms 10g, Oracle Reports 10g, Oracle 10 g

Confidential, Victoria, BC

Senior Oracle Consultant

Responsibilities:

• Customize Forms 10g, Reports 10g, BI Publisher Reports, Oracle packages
• Customized XML Reports according to the user change requests
• Working with Business Analysts in understanding the business requirement
• Creating Technical Documents for the business requirements
• Providing estimations for technical deliverables to the client
• Create Unit Test Plan for all developments
• Working closely with other Developers, Business Analysts, Testers in Confidential and validation of Business requirements and providing application support for in house Penfax Pension software

Environment: Oracle PL/SQL 10g/11g, Oracle Reports 10g, Oracle Forms 10g, BI Publisher (XML Publisher)

Confidential

Senior Oracle EBS Developer

Responsibilities:

• Was part of Oracle R12 Upgrade team
• Upgraded all the Custom code, Oracle Forms and Oracle Reports from 11.
• Maintenance of ETL packages
• Worked on maintenance and enhancements of Oracle Data warehouse
• Gather requirements from end user and create Technical Documents for the same
• Providing estimations for technical deliverables to the client
• Create Unit Test Plan for all customizations
• Working closely with other Developers, Business Analysts, Testers in Confidential and validation of Business requirements
• Implementation of GST/HST Taxes
• Providing application support to Oracle Financial, Order Management, Oracle to Cash, Oracle Inventory, Oracle Configurator modules, Oracle Projects

Environment: Oracle EBS 11.5.10/12.1.3 , Oracle Financials (AR, AP, GL), OM, FA, CM Oracle Inventory, Oracle Project Accounting, Oracle to Cash, P2P, Oracle Data Warehouse(ETL), Toad 9.7.2, Oracle PL/SQL 10g, Oracle Reports 6i/10g, Oracle Forms 6i/10g, SQL Navigator

Confidential

Systems Analyst (Oracle EBS)

Responsibilities:

• Successfully Implemented Oracle Manufacturing, and Oracle Financials and Oracle Supply Chain in 3 Business Units across US
• Gathered data conversion requirements from BA mapped the legacy data with oracle EBS tables and did the Gap Analysis
• Experience with Approval Management Engine (AME)
• Created Inbound Interfaces using PL/SQL packages in Oracle Manufacturing, Oracle Financials, Oracle Install Base and Order to Cash Cycle to import legacy system data into Oracle EBS
• Reconciling of data in legacy system with oracle EBS once the integration is completed
• Created Inbound Inventory Item’s Interface to load Master and Organization Items
• Worked closely with Business Analysts in gathering functional requirements (MD 50) and created technical documentation (MD 70) which included complex data flow diagrams, unit test plans and process diagrams
• Creating new reports and modifying existing reports in BI Publisher (XML Publisher) and Oracle Reports 6i
• Created Custom new form for user data entry and Worked on cutom.pll changes
• Providing technical support in various Oracle EBS modules like Oracle Financials (AR, AP, GL), Order to Cash, Oracle ASCP, Inventory, BOM, Costing, WIP, Order Management, HRMS, Purchase Order, Install Base

Environment: Oracle EBS 11.5.10.2(Oracle Financials (AR, AP, GL), O2C, P2P, Oracle Manufacturing (INV, BOM, WIP), Oracle ASCP, Oracle Financials (AR, AP, GL), FA, CM,Install Base, Service Contracts, Order Management, Oracle Advance Pricing, Oracle Costing, Purchase Order), Oracle HRMS, TOAD, EDI, Oracle PL/SQL 9i, BI Publisher, Oracle Forms/Reports6i

Confidential, CA

Programmer Analyst (Oracle EBS)

Responsibilities:

• Creating Functional (MD50) and Technical documentation (MD70) for outbound interfaces from oracle TCA, INV, Oracle Financials, HRMS, Service Contracts
• Did reverse engineering of legacy system and mapped the columns from consolidated data mart (Legacy System) with oracle EBS and did the Gap Analysis
• Developing the outbound interfaces from oracle EBS to consolidated data mart
• Created shell script to zip the data files once they are created on the server

Environment: Oracle EBS 11.5.10.2(Oracle Financials (AR, AP GL), Oracle TCA, INV, HRMS, Service