Pranay Karbande

To be a part of an organization that provides a challenging position where I can learn new skills, expand my knowledge, and can make the best use of my potential and contribute to the organization's growth.

• Marathi
• Hindi
• English

• Have more than 4 years of experience in Database programming using Oracle PL/SQL and Oracle D2K (Forms & Reports).
• Involved in writing PL/SQL Stored Procedures, Functions, Cursors, Triggers and Package.
• Written complex SQL (Sub queries and Join conditions), in PL/SQL. Proficient knowledge in performance tuning and knowledge to work according to the Work Request and Change Request.
• Ability to understand the business requirements and Data models. SQL Programming Using Analytical functions, Sub Queries, indexes and Set Operators.
• Involved in creating database objects like Tables, Indexes, sequences, views, sub program like Procedure, functions, triggers, cursors and exceptions.
• Coordinated with the front end design team to provide them with the necessary stored procedures, packages and the necessary insight into the data.
• Modifications in Packages, Stored Procedures, User Defined Functions.
• Possessing extensive knowledge and experience across various modules, including Sales, Purchasing, Finance, HR Payroll, and Administration etc.

1.CLIENT: LODHIA INDUSTRIES LTD.(NEO PROJECT) 

• ABOUT: Lodhia is one of the leading steel and plastic manufactures in Tanzania. founded in 1996 , Dar-Es-Salaam.
• Tools : PL/SQL Developer, SQL Developer, Forms and Reports D2K(12c) &11g,Oracle Apex Environment : Oracle 11g/12c, PL/SQL, D2K
• Description :The main concept of this project is to make easy to get all the Information about all the details regarding Purchase , Sales, Finance, Production and Planning. In this project work there is a form creation and modification of database structure as database objects like tables, alteration of tables, creation and development of stored procedures, functions and triggers.
  

2. Support projects: TWIGA STATIONARIES ,PLATINUM PACKAGING LTD.,KENTAINERS LTD,CARTON MANUFACTURING LTD.

• Tools : PL/SQL Developer, SQL Developer, Forms and Reports D2K(12c) &11g,Oracle Apex Environment : Oracle 11g/12c, PL/SQL, D2K
• Description : Worked on new requirements and changes in different modules also Support Provided for various module like Sales, purchase, inventory, finance and Hr-pay etc .

I hereby declare that all the information furnished above is true to the best of my knowledge and belief.