Uday D. Kavale

Senior Oracle PL/SQL Developer

919-***-****

xgmq3d@r.postjobfree.com

Profile:

• 11 Years of Total IT Experience

• 11 years of Oracle PL/SQL Experience

Summary:

• 11 years of IT experience spanning Applications Development, Database Design & Development using Oracle technologies in various domains like Insurance, Business Consulting, Telecom, Finance, HR, IT consulting, Structural Engineering industries, Performed various roles such as Module lead, Technical Lead, Project Manager & Agile Scrum Master during my Professional career.

• Database Architect/Programmer with more than 11 Years of experience in the areas of Designing, Developing and Performance tuning of OLTP and Data warehouse applications, good exposure to software quality processes and have worked in projects using Agile & waterfall methodologies. Experience spans across all the phases of a software development life cycle.

• Solid experience in Oracle Database Programming using PL/SQL, SQL,SQLX,XML,XSD, MS SQL, Oracle Forms 4.5/5.0/6i and Reports 6i/3/2.5, Database Design (both Physical and Logical), Database Modeling (Designer 2000), Gap Analysis, Data Mapping, Cleansing, Massaging, Transformations, Data Exports & Imports, Application Support, Performance Tuning, Security Administration, Resource Management, Software Maintenance, User & Security Management, Oracle Tuning & Optimization.

• Experience using PL/SQL, SQL, MySQL, T-SQL, Pro*C, C++, Java, VB, VBA, HTML, Stored Procedures, Functions, Ref Cursors, Constraints, Triggers, Indexes- B-tree Index, Bitmap Index, Views, Inline Views, Materialized Views, Database Links, Export/Import Utilities, Ad-hoc queries using SQL, Dynamic SQL. Expertise in writing and debugging Pro*C programs in both UNIX and Windows environment Experience in Installation, Setup, Configuration, Maintenance and Tuning of Oracle 11g/10g/9i/8i under UNIX (Sun Solaris 2.6, 7, 8) and Windows NT/95/98/2000 environment.

• Tuning of SQL Queries to improve performance of a system. Identify root causes and resolve problems related to system functionality. Experience in numerous Oracle implementations through full infrastructure and performance optimizations including I/O optimization, Backup and Recovery Planning, Testing and Implementation.

• Extensive experience in a Data warehousing environment and Datastage ETL.

• Education:

Bachelor in Engineering

Technical Skills:

Oracle Oracle 11g/10g/9i/8i, Oracle Developer 2000, SQL*Plus, SQL*Loader, TOAD 7.0, and Developer 2000, Oracle Tkprof & SQL Trace, Oracle Enterprise Manager

Databases Oracle 11g/10g/9i/8i, My SQL, MS Access, Teradata, SQL*Plus, SQL*Loader, TOAD, Developer 2000

Languages & Tools Oracle (SQL, PL-SQL, SQLX), Oracle Apps Order Management & Advanced Pricing R11/R12, Oracle Forms and Reports 6i/10, Java, J2EE, Ascential Datastage, Crystal Reports, Cognos, TOAD, PL-SQL Developer, Eclipse,PGP

Programming/Others SQL, PL/SQL, Developer 2000 (Forms 6i/4.5, Reports 6i/2.5), Unix Shell Scripting, SQL*Loader, SQL*Plus, Discoverer, Pro*C, C, C++, Java 2.0/1.2 (JFC, Servlets, Applets, Beans, Swing, AWT, Agile Methodology, Test Driven Development

Others Tools Visual Source Safe, Auto CAD, MS Office, PVCS, CVS, SVN, Kintana, ODBC, TCP/IP, and Dream Weaver

Operating systems UNIX, Linux, Windows 98/NT/2000/XP

Internet Technology ASP, JSP, HTML,XML,XSD, VB Script & Java Script

ETL Tools Ascential Datastage

Professional Experience:

Cisco Systems, RTP, North Carolina Jun’09-till date

Oracle Technical Lead/Developer

Project: Enhancement and Development of Oracle Apps Advanced Pricing & Discounting Applications

Description:

The Scope of the project includes enhancements and development for Oracle Apps Order Management & Advanced Pricing module. The project includes customizing the Order Management and Pricing & Discounting application according to the business requirements.

Responsibilities:

• Gather the requirements from Cisco Business

• Work with the IT Analysts and architecture the solution as per the business requirements.

• Prepare a Technical Specification document for the TO-BE solution and work with the team for the development, testing and deployment of the requirement on the production server.

• Perform the role of Technical Lead for the project and resolve the technical issues in the system.

• Suggest and implement various technical and performance improvements in the system on a regular basis.

• Enhance the Pricing & Discounting module by implementing the newly added pricing and discounting rules

• Coding (Oracle, PL-SQL, Oracle Forms and Reports), Unit testing the application on R11i and R12 versions.

Environment: Oracle Apps Advanced Pricing R11i & R12, Oracle 10g/11g, PL-SQL, Windows XP, UNIX, Java, J2EE, TOAD, PL-SQL Developer

Mckinsey & Co., New York Sep’06-Jun’09

Oracle Pl/Sql Technical Architect / Module Lead

Project: Enhancement and Development of Data warehouse & OLTP Applications

Description: Scope includes Enhancement and development of data warehouse & OLTP applications for one of the largest business consulting firm. The technology used for this application is ORACLE PL-SQL, SQLX , XML, XSD, Data stage, JAVA, VB etc. The aim of the project is giving end to end IT solutions for Data warehouse & OLTP applications. The project also involved performance reengineering of the processes which took considerable amount of time. This project was executed using the Test Driven Development methodology.

Responsibilities:

• Performed the role of Technical Architect and Scrum Master for the project

• Enhancing the existing recruiting application using Oracle, XMLs, XSDs with the help of SQLX package and functions.

• Performance tuned the existing PL-SQL & SQL code/queries using TKPROF, EXPLAIN PLAN etc.

• Coding (Oracle, PL-SQL, JAVA, SQLX, XML, XSD), preparing Unit Test Cases, Unit testing the application.

• Coordinate with the client on a regular basis for smooth execution of the project.

Environment: Ascential Datastage, Oracle 9i/10g/XE, PL-SQL, SQLX, XML, XSD, Java, J2EE, Cognos, TOAD, PL-SQL Developer,PGP

MetLife, UK Aug’05-Aug’06

Group Leader / Release Manager

Project: MetLife UK TIA Product Development

Description:

The scope included Maintenance/Enhancement of the TIA application. The technology used for this application is Developer 2000 Form/Reports and ORACLE PL/SQL.

The aim of the project is Modify/Add functionalities for the existing application. The application handles all the insurance related activities for MetLife UK. The application has two-tier client server architecture with D2K forms acting as the front end for the application whereas Oracle 9i serves as the database layer. The types of insurance policies handled by this application are Creditor insurance, Life Insurance and Health Insurance.

Responsibilities:

• Prepare MCR analysis / Functional & Technical Specification Document for the change requests.

• Enhanced the Insurance TIA application and implemented new features and business rules depending on the client requirements.

• Coding (PL-SQL ,Oracle Forms and Reports 6i), preparing Unit Test Cases, Unit testing the application for the changes done.

• Coordinate with the client on a regular basis for smooth execution of the project.

• Perform the role of Configuration Manager & Release Manager for the project.

• Perform the role of Group Lead for the project handling a team of 4 developers.

Environment: Oracle Forms and Reports 6i/10, Oracle 9i, TOAD, PL-SQL Developer Windows XP

MetLife, Mexico Jul’04-Jul’05

Role: Team Member / Configuration Manager

Description: Maintenance/Enhancement of Mexico Integrated Environment Applications (Java applications, D2K applications, Data Warehousing applications. The underlying technology used for these applications are Java-EJB, Java-Swing, Web logic, Developer 2000 Form/Reports, Visual Basic and ORACLE PL/SQL.

The aim of the project is modify / add functionalities for the existing application. The application is responsible for handling all the insurance related activities for MetLife Mexico. The application has two-tier client server architecture with D2K forms acting as the front end for the application whereas Oracle 8i serves as the database layer. The types of insurance policies handled by this application are Life insurance, Group insurance, Health insurance etc.

Responsibilities:

• Understand the applications functionally and technically.

• Prepare MCR analysis for the change request.

• Coding (PL-SQL ,Oracle Forms and Reports 6i), preparing Unit Test Cases, Testing the application for the changes done

• Coordinate with the client on a regular basis for smooth execution of the project.

• Perform the role of Knowledge Representative for the project.

Environment: Oracle Forms and Reports 6i/10, Oracle 8i, TOAD, PL-SQL Developer, Windows XP, LINUX

Patni Computer Systems Nov’03-Jun’04

Oracle Developer

Responsibilities:

• Design and develop / modify Web pages for presentation layer in ASP.

• Code for the required functionality

• Prepare Unit Test Cases

• Unit and Integration Testing

Environment: ASP, JSP, Java, Java Script, J2EE, MS SQL Server 2000, Windows 2000, IIS

Venus GNM Advertisement & Marketing Feb’03-Oct’03

Software Programmer

Project : Network Marketing Management System

Scope of the project:

The system is developed with a three-tier architecture layer. The presentation layer is developed in ASP whereas business logic components are developed using VB 6.0. Oracle 8.0 is used as the database layer. Business logic components are developed for calculations as per the business rules involved in the process. Interaction with the database is done through stored procedures.

Responsibilities:

• Develop business logic components

• Design and develop Web Forms

• Prepare Program Specifications

• Prepare Unit Test Cases and Test Data

• Write stored procedures

• Unit Testing

Environment: ASP/JSP, VB 6.0, Crystal Reports, Java, Java Script, J2EE, Oracle 8i, TOAD, PL-SQL Developer

H.M.Raje Consultants Pvt. Ltd Oct’02-Jan’03

Senior Oracle Developer

Scope of the project:

The system is developed with two-tier client server architecture. The presentation layer is developed in VB6.0. Oracle 8.0 is used as the database layer. Components are developed for calculations like getting payment report for a contract, possible deduction in the payment etc. The components interact with the database through stored procedures.

Responsibilities:

• Prepare Program Specifications

• Prepare Unit Test Cases and test data

• Design and develop forms

• Perform Unit Testing

• Prepare User Manual

Environment: VB, Oracle 8.0, Crystal Reports, Windows 2000

Clients in Construction business Jun’02-Sep’02

Scope of the project:

The system is developed using Visual Basic 6.0, which reads the design related information from MS-Excel spreadsheet and calculates the quantities for the same. The parameters for calculations are taken from the design codes stored in the Oracle database. The reports are generated in MS-Excel spreadsheet. The Excel object is used to read and write data to the spreadsheet.

Responsibilities:

• Prepare Program Specifications

• Prepare Unit Test Cases and test data

• Design and develop Visual Basic forms

• Perform Unit Testing

• Prepare User Manual

Environment: Visual Basic 6.0, VBA, Oracle 8.0, MS Excel, Windows 2000/98

Architects and Draughtsman Feb’02-May’02

Duration:

Scope of the project:

The front end is developed in Visual Basic 6.0 along with AutoCAD. MS-Access 2000 is used as the database for this application. The system is designed to read the data from the drawing file and manipulate it accordingly.

Responsibilities:

• Prepare Program Specifications

• Prepare Unit Test Cases and test data

• Design and develop Visual Basic forms

• Perform Unit Testing

• Prepare User Manual

Platform: Visual Basic 6.0, VBA, ADO, AutoCAD 2000, MS-Access 2000

H.M.Raje Consultants Pvt. Ltd Nov’01-Jan’02

Scope of the project:

The front end is developed in Visual Basic 6.0 along with AutoCAD. MS-Access 2000 is used as the database for this application. The software is designed to read the STAAD pro 2001output file.

Responsibilities:

Design and develop Visual Basic forms

Create Test Data

Perform Unit Testing

Software: Visual Basic 6.0, VBA, MS-Access 2000, MS-Excel 2000

ABC Consultants, India Dec’00-Oct’01

Scope of the project:

The front end is developed in Visual Basic 6.0 along with AutoCAD. MS-Access is used as the database for this application. This application works in conjunction with MSA, which is a third party designing application used by ABC consultants.

Responsibilities:

• Design and develop Visual Basic forms

• Maintain and enhance the system as per user requirements

• Create Test Data

• Perform Unit Testing

Environment: Visual Basic 6.0, MS-Access 2000, AutoCAD 2000

Contact this candidate