Lakshmi P.

Lakshmi P.

Oracle PL/SQL Lead

Bangalore , India

Experience: 10 Years

Lakshmi

Bangalore , India

Oracle PL/SQL Lead

USD / Year

  • Start Date / Notice Period end date:

10 Years

Now you can Instantly Chat with Lakshmi!

About Me

8.5 years of experience in Oracle PL/SQL (9i & 10g), UNIX shell scripting. 2 years of experience in DB testing / Automation scripting (Quick test professional, Iframe- CRAFT framework) Possess sound knowledge in PL/SQL development and coding technolo...

Show More

Portfolio Projects

Description

MIS or Material Information System is a global web-based system which will assist in Goodyear Tire & Rubber Company to streamline the Materials Information System which is an integral part of the Approval process. The scope of MIS project was to design an Approval Process work flow for following Material types used in the construction of Tires in Goodyear :

Raw Material, Reinforcement

The application developed is used by the purchasing department of Goodyear to track the work flow of the sourcing of material and its approval for plant production.

Show More Show Less

Description

MIS or Material Information System is a global web-based system which will assist in Goodyear Tire & Rubber Company to streamline the Materials Information System which is an integral part of the Approval process. The scope of MIS project was to design an Approval Process work flow for following Material types used in the construction of Tires in Goodyear : Raw Material, Reinforcement The application developed is used by the purchasing department of Goodyear to track the work flow of the sourcing of material and its approval for plant production.

Show More Show Less

Description

The TCGM system is used by Abbott International Division Manufacturing Accounting Department to track profit margin for sales in the supply chain between Abbott entities until the product is sold to a third party. The TCGM system has been implemented with a Web-based user interface

Show More Show Less

Description

ESA (Enterprise Service Automation) is a kind to ERP (Enterprise Resource Planning) for the service industry. It is an integrated solution specific to service centric organizations to optimize project revenue, reduce project delivery cost and increase resource utilization. The ESA modules are Contracts, Budget, Resource management (RM), Project Costing, Billing, Expenses and Account Receivables (AR).

Show More Show Less

Description

This project takes a data subset approach that is driven by metadata-driven SQL scripts. The subset of data is based on a business driven set of Screen protocols. This set of protocols drives which records in all downstream tables that will be copied to the test instance. The list of protocols and the subset logic for downstream tables are defined in a set of metadata tables. The output of this project is a set of metadata tables and an Oracle script that can be run to create the database subset.

Show More Show Less

Description

The project objective is to standardize reference data across GCIARM to enable consistency across GCIB sales and performance tools. This includes improving the overall customer experience, enabling CRMS customers to exploit data, enabling system predictability, achieving a measureable environment, fostering data tract and reducing CRMS overall TCO. The Database layer is responsible for defining and holding database objects for storing reference data from various source systems and PLSQL programs that are required to extract, manipulate and transform the data. Database layer provides various customs API’s to interface with J2EE front-end in order to support data representation within GUI and for supporting various DML operations on the user input.

GCIARM – Global Client Information Architecture and Risk Management

GCIB - Global Corporate / Investment Banking

CRMS - Client Relationship Management Services

Show More Show Less

Description

VIN or Vendor Information Network is a global web-based system with a suite of applications (tools) for shared supply base management. It is a centralized purchasing information system that aids in enhanced decision making and in managing the workflow across the various processes in the purchasing department. Measurement of Performance System in VIN is a tool for monitoring the performance of suppliers through the following reports, Supplier Performance Scorecard ,Master Supplier Summary Scorecard, Parent Supplier Summary Scorecard, MOPS Period Reports, Quality Period Reports, Delivery Period Reports, Launch Period Reports

Show More Show Less

Description

VIN or Vendor Information Network is a global web-based system with a suite of applications (tools) for shared supply base management. It is a centralized purchasing information system that aids in enhanced decision making and in managing the workflow across the various processes in the purchasing department. Program Tracking System in VIN is a tool for managing the processes for new product introduction and for changes in current products. The system has to track the status of all programs (new & changes) from award of business or kick-off through production launch. The system has to be user friendly and flexible enough to accommodate the diverse needs of the product, commodity and supplier development groups across the various product lines in TRW.

Show More Show Less

Description

VIN or Vendor Information Network is a global web-based system with a suite of applications (tools) for shared supply base management. It is a centralized purchasing information system that aids in enhanced decision making and in managing the workflow across the various processes in the purchasing department. Purchase Price variance is an application in VIN which enables TRW to calculate the costs and savings opportunities on products from individual suppliers and thereby propose alternative design based on the calculations and enhance business. This module includes also reporting.

Show More Show Less

Description

VIN or Vendor Information Network is a global web-based system with a suite of applications (tools) for shared supply base management. It is a centralized purchasing information system that aids in enhanced decision making and in managing the workflow across the various processes in the purchasing department.

Program Tracking System in VIN is a tool for managing the processes for new product introduction and for changes in current products. The system has to track the status of all programs (new & changes) from award of business or kick-off through production launch. The system has to be user friendly and flexible enough to accommodate the diverse needs of the product, commodity and supplier development groups across the various product lines in TRW.

Show More Show Less