Proffetional summary

Confidential

Role: Oracle APPS Technical Consultant

Description: De Lage Landen DLL , a fully-owned subsidiary ofConfidential, offers asset financing and leasing to equipment manufacturers, dealers and distributors around the world. We focus on a selection of industries: food agriculture, healthcare, construction, transportation industrial, office technology, clean technology, and mobility. Our asset-based financing programs help our customers grow market share, enhance profitability and achieve their strategic goals. In this Project we implemented AP, AR, GL, PO and OLM modules for this client.

Responsibilities:

• Worked on entire lifecycle of the project including Analysis, Design, Development and Unit Testing.
• Supported in setting up major Financials and Supply Chain modules like General Ledger, Accounts Payable, Inventory for a multi org environment.
• Involved in the data conversion of historical legacy data from 11i to R12, performed validations prior to transferring data into OM Open Interface tables and subsequently used Order Import program to populate base tables. Tools used for loading are SQL Loader and PL/SQL.
• Developed the interface program for Accounts Payables given in the flat file and loading the data from flat file to the staging table using SQL Loader and did all the necessary validations before loading into Oracle Standard Interface table.
• Customized standard reports like Aging Report and Invoice in AR.
• Developed new reports and customized existing reports using Oracle Reports 6i/10g.
• Supported in development of forms and customization of exixting forms using Oracle Forms 6i/10g.
• Excellent understanding of AOL Sys Admin, created users and attahed responsibilities, defined request sets and managed concurrent programs
• Involved in checking the validity and accuracy of the legacy data by writing PL/SQL packages.
• Worked on Auto Invoice Conversion Program to validate, load Credit memos, Debit memos and Invoices from legacy system.
• Worked on Oracle Lease Management OLM module which includes creating contracts and updating lease information for contracts and supported in fixing the bugs.

Confidential

Role: Oracle Apps Technical Consultant

Description: Client On-boarding which will streamline the On-boarding process and improve the quality of service offered to its Clients. Confidential is a workflow process that would be implemented for On-boarding Institutional Clients. Confidential is planned to be a framework with On-boarding workflow. The framework will be flexible to accommodate On-boarding requirements of different types of Institutions. These Institutions will need to on-board clients in different geographies for multiple products/services.

In this project we implemented Reports, Interfaces, Conversions and Extensions.

Responsibilities:

• I was involved in Accounts Receivables, Order Management, Purchase Order and Inventory modules including writing interface programs according to user and business requirements

• Developing several reports using Oracle Reports 6i according to the functional specifications provided and also migration of data from legacy into Oracle Application modules.
• Worked in Oracle Application Object Library AOL features like value sets, Flex fields, Concurrent Programs, Profile Options, standard request submissions and parameters which are extensively used in the process of development.
• Gathered and documented all the technical requirements to interface with a customs claims processing system and data conversion from legacy system.
• Performed the Data Migration using SQL Loader Scripts for importing legacy systems data into AR interface tables.
• Worked in Oracle Back-end PL/SQL Development i.e. Stored Procedures, Packages, Functions Triggers using SQL Navigator and Toad as development tools
• Created custom Interface to populate Customer interface tables with data such as Customer Profiles, Phone Contacts at various levels, Payment Method data Customer Bank data.
• Personalized the pick release form to make the waybill number mandatory before ship confirm.

Confidential

Role: PL/SQL Developer

Description: The project is designed to computerize the operations of the client who is involved in bulk sales of pharmaceuticals to various hospitals and medical outlets. Screens are developed which takes care of customer details, purchase of products of medicines in bulk from companies like Confidential etc. Stock details and products can be viewed by using LOV's. The software developed has been extremely user friendly with messaged boxes guiding the user for navigation.

Responsibilities:

• Created database objects such as tables, indexes, views, synonyms, table spaces, referential integrity constraints, and triggers to development needs
• Worked in Oracle Back-end PL/SQL Development i.e. Stored Procedures, Packages, Functions Triggers using SQL Navigator and Toad as development tools
• Involved in Software Requirement Specification and Technical Design. Development, Testing, Implementation and Training with web Development techniques.
• Designed and developed Reports as per Client Requirement
• Created user defined Exceptions while Handling Exceptions
• Created SQL Queries using Toad tool and scheduled some of the Common Reports.
• Involved in enhancement of Forms, Reports by User Interaction.
• Created Control Files for SQL Loader to load data from Text Files.