SUMMARY:

• Over 8 years IT experience in Oracle E - Business Suite (EBS) as Techno-functional consultant (Business System Analyst), with experience in Oracle Confidential
• Extensive experience with analysis, design, development, customizations and implementation of software applications including ERP applications
• Implemented/Part of several end-to-end implementations in multi-program, multi-project, multi-vendor environment
• Expertise in implementation, customization and support of Oracle Application modules like Oracle Payables, Oracle Receivables, Oracle Purchasing and Oracle Order Management
• Exposure to various Oracle modules related to Finance, SCM, and CRM and has good understanding on the data flow/integration within the modules
• Proficient in technical aspects of Oracle Applications Customizations, Interfaces, data Conversions and Extensions.
• Excellent working knowledge in customizing and automating components related to Order to Cash cycle.
• Experience in importing data from legacy systems to Oracle Applications through SQL*Loader and Fusion Middleware.
• Extensive experience in registering and configuring various AOL concepts like concurrent programs, request groups, request sets, Key Flex fields, Descriptive Flex fields etc.
• Expertise in developing and customizing Oracle Forms using Developer Suite.
• Possess working knowledge in Developer tools like Oracle Reports
• Proficient in Programming Using PL/SQL
• Participated in code review of custom scripts for easy maintenance of custom components
• Experience in UNIX shell scripting
• Excellent working knowledge in components related to Order to Cash cycle, Procure to Pay Cycle.
• Experience in Reports, Interfaces, Conversions and Extensions (RICE).
• Knowledge in Oracle AIA and ODI Confidential .
• Knowledge in Oracle ADF, OAF
• Able to work effectively at all organizational levels and have an ability to manage rapid changes.
• Good communication skills and a genuine team player with good organizational and self-management skill.

TECHNICAL SKILLS:

Oracle Applications: Oracle Applications 11i / R12. Accounts Receivables (AR), General Ledger (GL), Accounts Payables (AP), Order Management (OM), Inventory (INV), Purchasing (PO), Fixed Assets (FA), Application Object Library (AOL)

Oracle Confidential: Oracle SOA 11g, BPEL, ODI 11g

Languages/Frameworks: SQL, PL/SQL, C, UNIX Shell Scripting

Oracle Tools: Developer Forms 6i / 10g, Report 6i/10g, Work Flow Builder.

Databases: Oracle 11g/10g/9i/8i, MS Access.

Tools: Toad, SQL PLUS, SQL* Plus, SQL Loader, UTL FILE, Confidential

EXPERIENCE SUMMARY:

Confidential, Green Bay, WI

Senior Oracle Applications Developer

Responsibilities:

• Involved in requirements gathering, analysis, design, development, testing and deployment
• Interact with business users and translate customer requirements into formal requirements and design documents, establish specific solutions, and leading the efforts including programming and testing that culminate in client acceptance of the results
• Involved in Critical conversion Components.
• Responsible for development of a most critical and complex conversion that converts Customer and SalesPerson for Source Operating Units to Destination Operating Units
• Identifying reusability/Changes in existing integrations flow from customer Data to Downstream Systems and highlight gaps if any by working closely with Confidential team
• Developed the data loader script for loading Freight carriers from source Organizations to Destination Organizations
• Prepared the test plans and executed test cases for unit, integration and system testing.
• Involved in production issues and support

Confidential, Schaumburg, IL

Senior Oracle Applications Developer

Responsibilities:

• Development of PL/SQL report which displays the details of Requisitions and Purchase Orders as per client requirement
• Developed custom Invoice Interface program to generate code combinations as per requirement
• Developed reusable components (Common Email Program, Common Error Table and Common Archival Program) which can used in other tracks
• Modified interface for AR Invoice payment through Credit Card
• Migrated the developed code to various instances using version control tool Clear case and migration tool Kintana
• Automating alerts for monitoring the programs
• Responsible for maintenance of Master Control List (MCL tracker) and migrating the objects to Production Servers
• Responsible for development of an inbound interface between SAP and R12 to load invoices
• Developed PL/SQL Packages, Procedures, Functions for validating the invoices and payment information from the legacy system and imported into Oracle Applications using the Payables Open Interface Import program and populated the base tables, which involved in Releasing Invoices from Hold, Approval of invoices and creating of New Invoices
• Worked on Customer conversion to import data from Legacy System into Oracle Account Receivables by using Customer Interface. Created SQL*Loader control programs and validation procedures to execute along with Customer Interface (AR).
• Developed Custom Business events
• Developed interfaces to extract customer, invoice information to send data to downstream systems
• Worked on Purchase Orders conversion. Responsibilities involved configurations, data mapping using SQL*Loader to import legacy Suppliers into Oracle

Confidential, Atlanta, GA

Oracle Applications Developer

Responsibilities:

• Responsible for development of an interface that automates IR-ISO flow with zero touch
• Customization of Mass Additions Create program to load only particular data into Fixed Assets mass additions interface table from Payables Invoices.
• Development of PL/SQL report which displays the details of the Capital Appropriation Requests created
• Develop interfaces from external systems to Global Oracle 11i instance
• Uploaded all the concurrent program, Value sets and Responsibilities details into another instance by using FNDLOAD commands
• Developed an interface for monthly import of journal entries from payroll running on a legacy system by using the journal import interface provided by Oracle General Ledger
• Developed Sales by Customer Ship-To Location report that shows the sales information with corresponding order number, invoice number, Item number, and PO and customer ship-to location
• Customized PO Approval workflow process using Workflow Builder and define processes based on the purchasing amount and ship to location
• Developed lockbox interface
• Designed and developed custom program to load EDI 850 inbound Orders into Order Management
• Generated Reports for Confidential

Confidential, New York, NY

Oracle Applications Developer

Responsibilities:

• Analyze the requirements provided by Business Analyst and prepare Impact analysis and estimates.
• Have Prepared the Use cases and Functional Specification documents.
• Have Prepared the High Level Design Documents.
• Writing functional and technical design specifications, Test documents and Unit test cases and develop modules.
• Developed new PL/SQL packages and interfaces for the requirements
• Done AR Lock box setups in Oracle APPS
• Done GL Account setups
• Modification of existing flows to align with the new flow as part of design.
• Developed and Modified Unix shell scripts for processing of invoice files
• Developed new concurrent programs as per new design
• Modified the existing workflow for account derivations for new design
• Developing the code as per standards and migrating the code to production
• Involved in debugging the defects in production environment

Confidential, New York, NY

Windows Admin

Responsibilities:

• Trouble shooting of windows xp
• Configuring computers in windows environment
• Troubleshooting of computers
• Creating and disabling users on servers for use in network machines