AddThis Social Bookmark Button
Oracle Applications
Minneapolis, MN - 55447 USA
Expertise :Oracle Applications 11i, forms, reports, PLsql and sql loader, Unix and Toad
Status :Have Work Visa
Job Type :
All - Corp-to-Corp
Position :

Resume
 

Summary

10+ years of overall experience in IT Industry with emphasis in Oracle Technologies.

5 years of Experience in Oracle Applications 11.0.3 and 11i in various modules
Bills of Materials like BOM
Account Receivables like AR
Warehouse Management System like WMS
Accounts Payables like AP

Work in Progress like WIP
Order Management like OM

AOL experience in using front end tools like Forms 4.5/6i/9i and Reports 2.5/6i In-depth knowledge of Oracle database, PL/SQL, SQL*Loader, SQL*plus, packages, procedures, functions, triggers and other Oracle tools, Developer 2000, Developer 6i and UNIX.

involved in Preparing Schedule and Timeline, Client Interaction, Coding, Testing and Maintenance and Quality Related Activities.

Experience with implementation, customization, Interfaces, development and debugging of AP, AR, PO, PA, Advanced Pricing, Inventory, WMS, HR, BOM, MRP, OE/OM, iStore and iExpenses modules.
Involved in implementation, customization, maintenance, conversions interfaces and user training Document Preparation
Development and customization of Reports, Forms, custom. pll, Forms Personalization and Interfaces
Excellent XML Publisher Working Knowledge
Configuring Value sets, DFF for various requirements
Defining Concurrent Programs, Executables
Inter-Personal, Communication, Coordination

Understanding the Technical Requirements
Detailing the design to the team
Providing support to existing applications
Integrating Custom Applications to the system
Understanding the functionality of custom. pll

Technical Skills :
Operating SystemsLinux, UNIX, Win NT/2000 or XPDatabasesOracle 8i/9i LanguagesC, PL/SQL and Shell ScriptsGraphic User InterfacesDeveloper 2000 like Forms and Reports 6i ToolSQL * Plus, Toad, PVCS, Data Loader and XML PublisherApplicationOracle Applications 11i


Employment

2006 -  Present
Technical Consultant

Client : Medtronic Inc USA Role : Technical Consultant Environment : Oracle Apps 11.5.10 : Environment :

Oracle E-Business Suite 11.5.10 residing on Unix Server. Modules involved Inventory like INV, Bills Of Material like BOM, Purchasing like PO, Work in Process like WIP, Warehouse Management System like WHS, General Ledger, Order Management like OM and Accounts Receivable like AR.

Responsibility includes

Good functional understanding of order to cash cycle
Good functional understanding of procure to pay cycle
Understanding the functionality of Inventory
Development of sales order Interface
Customization of order management module using forms and reports
Development of purchase order Interface
Customization of WMS module using forms and reports
Developed custom reports for BOM
Developed custom reports for inventory module
Developed custom forms for purchasing module
Development of Item Interface
Developed reports and forms for purchase order module.

Development of XML Publisher Reports for PO print, AR Invoice and other using XML publisher
Developed Sales Order Acknowledgement, Pack Slip, Commercial Invoice and Proforma Invoice reports Using XML Publisher
XML Publisher setup
Designing template and XML tagging.
Creating Template definitions and Data Definitions
Developing PL/SQL procedure to validate and move data to interface tables
Defining Concurrent programs, Request Sets and Request Group
Execution and Error reporting after Import process
Registering Forms and reports in the front end
Providing test support during user testing phase


2002 -  2005
Technical Consultant

Client : Grays Mauritius Role : Technical Consultant Environment : Oracle Apps 11.5.10 : Environment :

Oracle E-Business Suite 11.5.10 residing on Linux Server. Modules involved Inventory like INV, Bills Of Material like BOM, Purchasing like PO, Work in Process like WIP, General Ledger, Order Management like OM and Accounts Receivable like AR, Project Accounting like PA

This Project includes

Developed AR Invoice like Auto Invoice Interface

Development of XML Publisher Reports for PO print, AR Invoice, Pack Slip and other using XML publisher
XML Publisher setup
Designing template and XML tagging.
Creating Template definitions and Data Definitions
Development of Requisitions interfaces for Purchase Requisitions
Development of Purchase Order Interface
Understanding the functionality of Requisitions
Customized vendor report as per client requirements
Good functional understanding of RFQ and Quotation
Customized RFQ report
Technical design review with Onsite to cross check any dependency and got approved
Developing PL/SQL procedure to validate and move data to interface tables
Defining Concurrent programs, Request Sets and Request Group
Execution and Error reporting after Import process
Enhancing the programs based on new user requirements
Registering Forms and reports in the front end
Discussing the technical details with onsite team
Providing test support during user testing phase


2002 -  2002
Team Leader

Client : Export Processing Zone Labor Welfare Fund Role : Team Leader front end : Developer2000 like Forms6i/Reports6i back end : Oracle 8i Hardware : Pentium HP-UX Machines : Description Client : Grays Mauritius Role : Technical Consultant Environment : Oracle Apps 11.5.10 : Environment :

Export Processing Zone is an organization which gives loan to small-scale industry employees. Each small-scale industry should contribute every month certain amount for their employees. If the contribution from the small-scale industry is regular Export Processing Zone will give Loan to employees pertaining to that small-scale industry. The above application was designed and implemented on Developer2000 like Forms6i/Reports6i or Oracle system. Developer2000 as a front end and Oracle as a back end. System was developed using Client Server Architecture.

Responsibilities : Involved in Prototype, preparation of Functional Specifications, Design
Designed Dataflow Diagrams like DFD, Functional Hierarchy Diagrams like FHD, Entity Relationship Diagrams like ERD
Interacting with customers for user requirements
Provided planning for Team members
Assisted team member in coding and trouble shooting
System testing and Integration testing


2002 -  2002
Team Leader

Project : Mauritius Housing Deposit Scheme Client : Mauritius Housing Company Role : Team Leader front end : Developer2000 like Forms6i/Reports6i back end : Oracle 8i Hardware : Pentium HP-UX Machines : Description Client : Grays Mauritius Role : Technical Consultant Environment : Oracle Apps 11.5.10 : Environment :

This is the system where the client will deposit certain amount to earn interest whether it is monthly, quarterly, yearly or at maturity. This system has got cashier module to receive the receipts and cheque printing module to print the cheques. The above application was designed and implemented on Developer2000 like Forms6i/Reports6i or Oracle system. Developer2000 as a front end and Oracle as a back end. System was developed using Client Server Architecture.

Responsibilities : Involved in Prototype, preparation of Functional Specifications, Design
Designed Dataflow Diagrams like DFD, Functional Hierarchy Diagrams like FHD, Entity Relationship Diagrams like ERD
Interacting with customers for user requirements
Provided planning for Team members


2002 -  2002
Assisted team member Single Team Member

Assisted team member in coding and trouble shooting Project : Technical System Client : Mauritius Housing Company Role : Single Team Member front end : Developer2000 like Forms6i/Reports6i back end : Oracle 8i Hardware : Pentium HP-UX Machines : Description Client : Grays Mauritius Role : Technical Consultant Environment : Oracle Apps 11.5.10 : Environment :

This software is designed to inspect lands which is mortgaged for loan for the construction of house by the clients. The main objective of this project is to provide the clients the exact estimation of land.

The above application was designed and implemented on Developer2000 like Forms6i/Reports6i or Oracle system. Developer2000 as a front end and Oracle as a back end. System was developed using thin client like Accessing data through Web Browser architecture.

Responsibilities : Interacted with customers for user requirements
Designed and developed forms and reports using forms 6i and reports 6i
Written packages and triggers using Oracle 9i.
Worked on design document, test plan document
Prepared user and technical support manuals.


2001 -  2001
Team member

Project : Medical Scheme Client : Mauritius Housing Company . Role : Team member in a team of 3 front end : Developer2000 like Forms6i/Reports6i back end : Oracle 8i Hardware : Pentium HP-UX Machines : Description

This system was developed for Mauritius Housing Company which is leading housing company in Mauritius which facilitates Medical scheme for their employees. The main objective of this project is to register employee s claims for their different medical expenses. Different medical expenses are grouped in into different section. Each section has got certain limit of amount and employees are entitled to reimburse their money without exceeding limit. At the end of the every month a committee will group and approve the amount. The system will cross check their limit.

The above application was designed and implemented on Developer2000 like Forms6i/Reports6i or Oracle system. Developer2000 as a front end and Oracle as a back end. System was developed using thin client like Accessing data through Web Browser architecture.

Responsibilities : Interacted with customers for user requirements
Designed and developed forms and reports using forms 6i and reports 6i
Written packages and triggers using Oracle 9i.
Worked on design document, test plan document
Prepared user and technical support manuals.


2001 -  2001
Team Member

Client : Mutual Aid Limited Mauritius Role : Team Member in a Team of 4 front end : Developer2000 like Forms6i/Reports6i back end : Oracle 8i Hardware : Pentium HP-UX Machines : Description Project : Medical Scheme Client : Mauritius Housing Company . Role : Team member in a team of 3 front end : Developer2000 like Forms6i/Reports6i back end : Oracle 8i Hardware : Pentium HP-UX Machines : Description

Looking after the parallel run like new system for the system Bills, Claims and Shares which are developed by me and provided maintenance work for those systems.


2001 -  2001
Team Member

Project : Share System Client : Mutual Aid Limited Maurituis Role : Team Member in a Team of 4 front end : Developer2000 like Forms6i/Reports6i back end : Oracle 8i Hardware : Pentium HP-UX Machines : Description Project : Medical Scheme Client : Mauritius Housing Company . Role : Team member in a team of 3 front end : Developer2000 like Forms6i/Reports6i back end : Oracle 8i Hardware : Pentium HP-UX Machines : Description

This system is designed to register customers request for issue/transfer of shares. This system provides facility to compute share dividends for shareholders. The above application was designed and implemented on Developer2000 like Forms6i/Reports6i or Oracle system. Developer2000 as a front end and Oracle as a back end. System was developed using thin client like Accessing data through Web Browser architecture.

As a member, Sridhar is involved in design and development.


2000 -  2000
Team Member

Project : Claim System Client : Mutual Aid Limited Maurituis Role : Team Member in a Team of 4 front end : Developer2000 like Forms6i/Reports6i back end : Oracle 8i Hardware : Pentium HP-UX Machines : Description

This is system was designed to raise a claim against death of share holder, spouse and surgery by the Customers like Customers should be a shareholder of that company. Once the claim is registered the next step is to calculate the claim amount. Company can approve the amount or disapprove the amount. The above application was designed and implemented on Developer2000 like Forms6i/Reports6i or Oracle system. Developer2000 as a front end and Oracle as a back end. System was developed using thin client like Accessing data through Web Browser architecture.

As a member, Sridhar is involved in development.


2000 -  2000
Team Member

Project : Bill System Client : Mutual Aid Limited Maurituis Role : Team Member in a Team of 4 front end : Developer2000 like Forms6i/Reports6i back end : Oracle 8i Hardware : Pentium HP-UX Machines : Description Project : Claim System Client : Mutual Aid Limited Maurituis Role : Team Member in a Team of 4 front end : Developer2000 like Forms6i/Reports6i back end : Oracle 8i Hardware : Pentium HP-UX Machines : Description

Bill system was designed to enable the customer to register their money for interest based on certain period. The interest is refunded or refunded based on customer s wish.
The above application was designed and implemented on Developer2000 like Forms6i/Reports6i or Oracle system. Developer2000 as a front end and Oracle as a back end. System was developed using thin client like Accessing data through Web Browser architecture.

As a member, Sridhar was involved in development.


2000 -  2000
Team Member

Project : Conversion of SIL like State Informatics Limited HRMS Client : University of Mauritius Mahatma Gandhi Institute etc Role : Team Member of 2 front end : Developer2000 like Forms4.5/Reports2.5 Forms6i/Reports6i back end : Oracle 8i Hardware : Pentium HP-UX Machines : Description Project : Claim System Client : Mutual Aid Limited Maurituis Role : Team Member in a Team of 4 front end : Developer2000 like Forms6i/Reports6i back end : Oracle 8i Hardware : Pentium HP-UX Machines : Description

This like own software of SIL developed in Forms4.5 and Reports2.5 software was converted for many clients as mentioned above from forms 6i/Reports6i from Forms 4.5/Reports2.5 to enable the client to access this software through web browser like Thin Client Architecture. There were nearly 10 modules, approximately 100 forms and 80 reports to be converted From forms4.5/Reports2.5 to Forms6i/Reports6i. After Converting this software Customization was done according to clients requirement.

As a member of 2, Sridhar converted 50%of forms and reports and involved in full customization. Sridhar involved in system testing.


1999 -  1999
Team Member

Project : Share System Client : B.U.C Shares Limited Chennai Role : Team Member in a Team of 2 front end : Developer2000 like Forms4.5/2.5 back end : Oracle 7.X Hardware : Pentium HP-UX Machines : Description

This software is designed to maintain customer information, shares buying information, share selling information and generating reports. System was developed using Client/ Server methodology with Clients running on windows and the server running on Oracle databases.

In a team of 2, Sridhar involved in development and testing.


1998 -  1998
Team Member

Project : Purchase Order System Client : Star International Pvt Ltd Chennai Role : Team Member in a Team of 4 front end : Developer2000 like Forms4.5/2.5 back end : Oracle 7.X Hardware : Pentium HP-UX Machines : Description

This software was designed to provide orders for products. This system involves in Customer Maintenance, product information, Invoicing issued orders and received orders and generating reports. System was developed using Client/ Server methodology with client running in windows and server running on Oracle databases.

In a Team of 4, Sridhar performed development and system Testing.


1997 -  1998
Team Member

Project : Sales Order System Client : Rukma Steels Limited Chennai Role : Team Member in a Team of 3 front end : Developer2000 like Forms4.5/2.5 back end : Oracle 7.X Hardware : Pentium HP-UX Machines : Description

This Software was created to maintain Customer, Product information, preparing sales order form, Chelan form, Sales Invoice, printing product wise sales and printing backlog reports which displays all the pending orders along with the products that have not been delivered. System was developed using Client/Server methodology with clients running on Windows and the Server running on Oracle databases.

In a Team of 3, Sridhar performed development and system Testing.


1997 -  1977
Team Member

Project : Inventory System Client : Gee Bee Poly Industries Ltd Role : Team Member in a Team of 2 front end : Developer2000 like Forms4.5/2.5 back end : Oracle 7.X Hardware : Pentium HP-UX Machines : Project : Sales Order System Client : Rukma Steels Limited Chennai Role : Team Member in a Team of 3 front end : Developer2000 like Forms4.5/2.5 back end : Oracle 7.X Hardware : Pentium HP-UX Machines : Description




Education

Bachelor of Engineering, Madras University Year of Graduation in 1990.



Miscellaneous

Description

This Software was developed to create transactions for the purpose of moving items out of inventory. System was developed using Client/Server methodology with clients running on Windows and the Server running on Oracle databases.

In a Team of 2, Sridhar performed Development and system testing.