PROFESSIONAL SUMMARY:

• Around 7 years of IT experience in Analysis, Design and Implementation as a Techno Functional Consultant in Oracle ERP Applications. Highly motivated, enthusiastic professional with high level of commitment to succeed.
• Received appreciations from management on various occasions for dedication and commitment towards work in various projects. Have Extensive experience in different phases of the software development life cycle such as requirements gathering, analysis, design, development, administration, testing, implementation and Documentation. Ability to work independently, key team player and effectively promote teamwork.
• Worked on more than 3 end to end large scale Oracle EBS implementation projects.
• Have experience in Implementation, Development, Customization, Testing and, Production Support of Oracle Applications, mainly in CRM, SCM and Financials Domains.
• Good working knowledge in Data Model of Order Management (OM), TCA Architecture, Purchasing (PO), Service Contracts (OKC/OKS), Install Base (IB), Oracle Projects (PA), Oracle Leasing and Financials Management (OLFM), Trade Management (OZF), Incentive Compensation (OIC), Account Receivables (AR), Account Payables (AP), Cash Management (CE), General Ledger (GL), Fixed Assets (FA) Modules.
• Have thorough hands on Experience as Oracle EBS Developer in SQL, PL/SQL, Oracle Forms, Reports, Oracle Workflow, BI/XML Publisher to generate reports in PDF, HTML, Excel Formats.
• Possesses sound knowledge of System Administration part of Oracle applications, Concurrent Program Registration, Responsibilities, Menus, and Functions etc.
• Strong technical and functional knowledge of Order to Cash, Procure to Pay and Contract to Cash flows.
• Experience in building integrations using SOA 11g with Oracle Applications or other custom applications.
• Experience in developing custom Oracle Forms, Pages using Oracle Application Framework (OAF) and Oracle Application Development Framework (ADF).
• Hands on data warehouse developer experience with ETL/ELT tools like Oracle Warehouse Builder (OWB) 11g and Oracle Data Integrator (ODI) 12c for loading data into BI, Hyperion and other data warehouses.
• Implementation experience in Oracle Self Service E - Billing Application for Invoicing and Payments.
• Expertise in developing RICE components using SQL, PL/SQL, as per Oracle Applications coding/ Customization/ User Interface standards and Coding techniques in Oracle Applications.
• Extensive experience in creating Stored Procedures, Functions, Packages, Triggers and other database objects using SQL and PL/SQL.
• Experience using Oracle Streams, Advanced Queuing (AQ), Java Store Procedures, DBMS Jobs, Generating/Parsing XML data, building and invoking Web Services from database.
• Knowledge Technical and Functional knowledge of Advanced Global Intercompany System (AGIS), Trading Community Architecture (TCA).
• Worked on Database Performance Tuning for custom programs in EBS and BI interfaces.
• Ability to learn new modules and Technologies quickly and efficiently.
• Excellent communication skills and team player, very good working knowledge in Technical Documentation
• Excellent problem solving and Analytical skills with an ability to identify problems and implement connective solutions.

TECHNICAL SKILLS:

Oracle Skills: SQL, PL/SQL, Oracle Developer 2000/6i and 10g (Forms and Reports), Toad, PL/SQL Developer, SQL*Plus, XML Reports, Oracle BI Publisher, Workflow, JDeveloper, Oracle Applications Framework (OAF), Oracle Application Development Framework (ADF), Oracle SOA Suite 11g.

ERP Suite (Enterprise Resource Planning): Oracle E-Business Suite R12.1.3 and 11i, AOL, Order Management (OM), Bill of Materials (BOM). Purchasing (PO), Inventory (INV), Oracle Trade Management / Channel Revenue Management (OZF), Oracle Incentive Compensation (OIC), Oracle Projects (PA), Oracle Leasing and Financials Management (OLFM) Service Contracts (OKS), Install Base (IB), Oracle Territory Management (JTY), Sub Leger Accounting (SLA), Oracle Receivables (AR), Oracle Payables (AP), Cash Management(CE), Fixed Assets (FA) and General Ledger (GL).

Data Warehouse Tools: Oracle Warehouse Builder 11g (OWB), Oracle Data Integrator 12c (ODI).

RDBMS: Oracle 12c, 11g, 10g/9i/8i.

Other Languages: Java, C/C++, UNIX Shell Scripting.

Operating Systems: Unix, Windows XP, 7, 10 for the Client.

Version Control Systems: SVN, Clearcase.

WORK EXPERIENCE:

OracleEBSTechnoFunctionalConsultant

Confidential, Webster, NY

Responsibilities:

• Played a key role in the successful development/implementation of new modules in the project.
• Successfully performed Proof of Concepts (POC’s) for complex technical solutions in new modules and gave demo to the business users and Xerox Engineering team.
• Worked extensively on OM, BOM, PO, INV, Channel Revenue Management, Incentive Compensation, OLFM, Service Contracts, Install Base, Lease Contracts, Oracle Projects,CE, FA, SLA, AR, AP and GL.
• Built Custom PL/SQL packages, forms, reports and Custom pages using OAF and ADF, prepared Solution Design Documents and Technical Design Documents for components developed.
• Crucial role in designing/developing critical interfaces like Lockbox, AR Pre Processing, ASN, Coupon interfaces in Channel Revenue management, Invoice load in E-Billing, EBS extracts for BI, Hyperion, OM and AR collectors in OIC, Inventory item import from PLM etc. to name a few.
• Received client appreciations on numerous occasions for managing multiple interfaces in the project and resolving critical issues.
• Worked on building Custom qualifiers in Territory Management, Customized Dunning Letter mailer workflow, creation of budgets, offers and claims in Channel Revenue management and interface data to AR.
• Developed Integrations using BPEL, Mediators and Adapters in SOA Suite 11g between EBS and other applications.
• Developed ETL projects/mappings in Oracle warehouse builder 11g and Oracle Data Integrator 12c to load data from EBS into Oracle E-Billing application, BI and Hyperion applications.
• Involved in developing complex rtf templates using XML publisher to support Invoice Presentment in E-Billing application.
• Knowledge on using Custom Source/ Mapping sets in SLA for deriving the accounts.
• Experience working in Onsite/Offshore model in the project.
• Mentored junior/newly inducted associates in Oracle Apps design/development and about the new modules being implemented.
• Performed gap analysis to identify the gaps in the Process flows and Applications.
• Supported functional and User Acceptance testing for fixing various bug fixes.

Environment: Oracle Applications R12, AOL, AR, PO, INV, OM, OKS, IB, FS, PO, AP, GL, FA, Oracle E-Billing 6.2, PL/SQL, Forms 10g/9i/6i, SOA Suite 11g, OAF, ADF.

Oracle Apps Techno Functional Consultant

Confidential, Webster, NY

Responsibilities:

• Played a crucial role in successful implementation of new modules and Integrations of the project.
• Worked extensively on Inventory, TCA, Service Contracts, Install Base, SLA, AR and GL.
• Did Proof of Concepts (POC’s) for complex technical solutions in new modules and gave demo to the business users and Xerox Engineering team.
• Developed critical interfaces like Customer Conversion/Update processing, Contract Publisher(extract and publish through SOA) to downstream systems, Lockbox, Meter Reads interfaces, Invoice Data extract for presentment, Service Contract creation Interfaces to name a few.
• Prepared Solution Design Documents and Technical Design Documents for various interfaces, conversions and extensions.
• Developed and designed critical Technical Components and successfully implemented it in Production after movement from Development, Quality Assurance and Volume Testing instances.
• Developed PL/SQL packages, reports, forms, customized workflows and built custom OAF pages.
• Experience invoking web services, parsing/generating XML types in database and using Java Stored procedures for remote procedure calls (RPC).
• Developed Integrations using BPEL, Mediators, Adapters in SOA Suite 11g between EBS and other applications.
• Worked on building interfaces using External Tables, Materialized views and DBMS jobs/scheduler.
• Involved in development of custom Descriptive Flex Fields (DFF’s) and enabling them in custom forms, leveraging Oracle Advanced Queueing techniques.
• Performed gap analysis to identify the gaps in the Business Process and Applications.
• Supported functional and User Acceptance testing for fixing various bug fixes.

Environment: Oracle Apps R12, AOL,, INV, OKS, IB, AR, GL, TOAD, PL/SQL, Forms 10g/9i/6i, SOA 11g.

Oracle Apps Technical Consultant

Confidential, Schaumburg, IL

Responsibilities:

• Involved in Design, Development and Implementation of the project.
• Worked extensively on developing AR, AP and GL interfaces to import data from legacy/other Oracle systems.
• Prepared Technical Design Documents for various interfaces, conversions and extensions.
• Developed and designed critical Technical Components and successfully implemented it in Production after movement from Development, Quality Assurance and Volume Testing instances.
• Developed PL/SQL packages, Shell Scripts, reports, forms and customized workflows.
• Experience in researching issues in Metalink, raise SR/ TAR’s for any bugs in the instance.
• Experience using SQL * Loader scripts, Form Personalization’s and modifying CUSTOM.pll.
• Performed gap analysis to identify the gaps in the Business Process and Applications.
• Supported functional and User Acceptance testing for fixing various bug fixes.
• Involved in Burn-in Support of the project and knowledge transfer to Prod Support teams.

Environment: Oracle Apps 11i, AOL, AR, AP, GL, TOAD, PL/SQL, Unix Shell Scripting, Forms 6i.

Oracle Apps Technical Consultant

Confidential, Schaumburg, IL

Responsibilities:

• Involved in Build, Unit Testing and Implementation of the Project.
• Worked on OM, PO and AR interfaces.
• Prepared Technical Design Documents for various interfaces, conversions and extensions.
• Developed and designed critical Technical Components and successfully implemented it in Production after movement from Development, Quality Assurance and Volume Testing instances.
• Developed interfaces to support Dropship orders in the environment.
• Involved in automation of Dropship orders, from booking, receiving Inventory and shipping sales orders.
• Developed PL/SQL packages and Shell Scripts.
• Supported functional and User Acceptance testing for fixing various bug fixes.
• Involved in knowledge transfer to Prod Support teams.

Environment: Oracle Apps 11i, AOL, OM, PO, AR, TOAD, PL/SQL, Forms 6i.

Oracle Technical Consultant

Confidential, Schaumburg, IL

Responsibilities:

• Involved in Build, Unit Testing and Implementation of the Project.
• Worked on OM, PO, INV modules.
• Prepared Technical Design Documents for various interfaces, conversions and extensions.
• Developed and designed critical Technical Components and successfully implemented it in Production after movement from Development, Quality Assurance and Volume Testing instances.
• Developed shell scripts and modified reports, forms to support the division of operating units and business.
• Developed PL/SQL packages and Shell Scripts.
• Supported functional and User Acceptance testing for fixing various bug fixes.
• Involved in knowledge transfer to Prod Support teams.

Environment: Oracle Apps R12, AOL, OM, PO, INV, TOAD, PL/SQL, Forms 10g/9i/6i.