SUMMARY

• More than 15 years of IT Experience in Design and Development of software Systems in teh 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 teh business requirements
• Strong PL/SQL skills wif teh ability to write efficient, complex queries against very large data sets good noledge of tuning of queries.
• Extensive experience using AIM (Application Implementation Methodology)
• In depth noledge in creating Functional (MD50) and Technical (MD70) documentation
• Worked wif State as well as Federal/Provincial Clients
• Good Knowledge in procurement software Coupa
• Worked as Oracle Data Integration Architect in integrating of Coupa wif 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 noledge 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 teh 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 noledge, adapting best practices, and collaborating wif globally diverse team members.
• Currently pursuing for Oracle E-Business Suite R12 Financials Certified Expert Consultant

TECHNICAL SKILLS

• 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

PROFESSIONAL EXPERIENCE

Confidential, Newark, NJ

Senior Oracle EBS Techno-Functional Consultant

Responsibilities:

• Creating new custom PL/SQL packages as per teh functional specifications
• Gathering requirements from users creating technical specifications for teh 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 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 teh current Ariba Procure to Pay system wif Coupa Cloud based Procure to Pay system. Also involved in implementation of in house Supplier Information Management system called Vetted.
• Gathering business requirements from teh users and creating functional documentation for teh Inbound and Outbound AP Interfaces from OracleEBS
• Mapping Columns from Coupa to Oracle EBS and doing teh Gap Analysis
• Creating different types of purchase orders in Coupa for testing teh integration wif 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 teh Gap Analysis
• Configured new Flexfields to as per teh 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 teh Fairshare and Processing processes in OM.
• Gathering requirements from users creating functional and technical specifications for teh 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 Cash, TOAD, Oracle Reports

Confidential, Burlington, MA

Oracle EBS Techno-Functional Lead

Responsibilities:

• Working wif teh 3PL (Third Party Logistics) to get teh legacy data as per Oracle EBS
• Coordinate wif functional consultants to map teh data and get teh MD50’s
• Hiring and managing teh resource for data integration
• 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 Management, Order to Cash, P2P, TOAD, Oracle 11g, Oracle Process Manufacturing(OPM)

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 teh existing code and made teh 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 teh legacy data from DataStream wif oracle EBS tables
• Extracting data from legacy system DataStream and inserting teh data into Oracle EBS staging tables for conversion and cleansing teh legacy data in Oracle
• Designed and Developed Item Conversion to Import legacy inventory items in master and child organization
• 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 wif oracle EBS once teh integration is completed
• Providing estimation for technical deliverables in different phases of implementation of teh project
• Worked closely wif 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

Senior Oracle Consultant

Responsibilities:

• Customize Forms 10g, Reports 10g, BI Publisher Reports, Oracle packages
• Customized XML Reports according to teh user change requests
• Working wif Business Analysts in understanding teh business requirement
• Creating Technical Documents for teh business requirements
• Providing estimations for technical deliverables to teh client
• Create Unit Test Plan for all developments

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 teh 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 teh same
• Providing estimations for technical deliverables to teh client
• Create Unit Test Plan for all customizations
• Working closely wif other Developers, Business Analysts, Testers in creation 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 teh legacy data wif oracle EBS tables and did teh Gap Analysis
• Experience wif 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 wif oracle EBS once teh integration is completed
• Created Inbound Inventory Item’s Interface to load Master and Organization Items
• Worked closely wif 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, Burbank, 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 teh columns from consolidated data mart (Legacy System) wif oracle EBS and did teh Gap Analysis
• Developing teh outbound interfaces from oracle EBS to consolidated data mart
• Created shell script to zip teh data files once they are created on teh server

Environment: Oracle EBS 11.5.10.2(Oracle Financials (AR, AP GL), Oracle TCA, INV, HRMS, Service Contracts, Install Base), Developer/2000 Reports6i, BI Publisher

Confidential, Carlsbad, CA

Senior Oracle EBS Consultant

Responsibilities:

• Worked as Oracle EBS Lead and Senior Oracle Applications Consultant
• Managing a Small Team of Oracle XML Publisher consultants
• Directly reporting to teh CTO of teh company
• Creating custom reports in Order Management according to user requirements.
• Created Shipping, Backlog, Bookings Detail Report in Order Management.
• Created and automated complex reports for management purpose which gave a full picture of business revenue
• Developed Technical Design (MD070) for teh above Reports.
• Created new BI Publisher reports in Order Management
• Converted existing custom reports to XML Publisher Excel format
• Created reports in Oracle Financials, Inventory, Oracle Sales, Service Contracts, Install Base,
• HRMS, Payroll according to user requirements
• Provided User support for Order Management, Oracle Financials, Order to Cash, Inventory, Service Contracts, Install Base, HRMS, Payroll, Purchase Order

Environment: Oracle EBS 11.5.10(Order Management, Order to Cash, INV, Oracle Financials, Service Contracts, Install Base, HRMS, PO), Oracle Project Accounting, Developer/2000 Reports6i, BI Publisher, TOAD 7.2

Confidential, Pasadena, CA

Oracle EBS Technical Consultant

Responsibilities:

• Technical support for teh client in Project Accounting, Grants Module and Solving Post-Production Issues.
• Customized and modified Forms of teh standard application suite using Application Object Library
• Developed and Modified Reports according to teh User requirements.
• Developed Technical (MD070) and Functional Design (MD050) for teh above Forms and Reports.

Environment: Oracle EBS 11.5.9(Project Accounting) and Oracle Grants, Developer/2000-Forms6i, TOAD 7.2, Sun Solaris 2.6.

Confidential, Dallas, TX

Oracle EBS Technical Consultant

Responsibilities:

• Technical support for teh client in Custom PDR Module and Interfaces.
• Gathered /studied teh requirements for teh new Reports and Forms enhancements.
• Developed Technical Design (MD070) for teh above Forms and Reports
• Created new forms using Oracle Forms 6i and new reports using Oracle Reports 6i.
• Created shell scripts to call teh interfaces.

Environment: Oracle EBS 11.5.10, Developer/2000- Reports6i, Forms6i, TOAD 7.2, Sun Solaris 2.6.

Confidential, Mahwah, N.J.

Oracle EBS Technical Consultant

Responsibilities:

• Customized and modified Forms of teh standard application suite using Application Object Library
• Developed Concurrent Program that inserts and updates values in teh cross-reference table on daily scheduled basis.
• Worked on shipping Interface teh shipping Interface included moving of goods from Oracle Warehouse Shipping to teh Legacy System (BOSS) for further delivery.
• Developed Technical Design for teh above Forms, Concurrent Program and Shipping Interface.

Environment: Oracle EBS 11.5.9(Order Management, INV), Developer/2000-Forms6i, TOAD 7.2, SQL Loader, Sun Solaris 2.6.

Confidential, Burlington ON

Co-op Programmer/Analyst

Responsibilities:

• Worked as a Systems Analyst on Oracle and Developer 2000 on their proprietary software.
• Responsibilities include development of new reports and forms according to user requirements and resolve issues.

Environment: Oracle Forms/Reports 9i, Oracle 9i

Confidential

Programmer/Business Analyst

Responsibilities:

• Meet wif users and performed requirements gathering, identified reports, and screen outputs produced by teh system.
• Created databases and developed teh system. Wrote documentation, tested teh application and trained users.
• Provided production support on-site as well as on-call support during off-hours.

Environment: Windows NT, SUN Solaris, Oracle Forms 4.5/6.0, Oracle Reports 2.5/6.0, Oracle 7.x/8i