Professional Summary:

• Currently working as an Oracle Technical Consultant in Cisco Systems, San Jose, CA USA.
• Over 12 years of experience in database design, development, performance tuning and optimization of core Oracle Database 8i, 9i, 10g and 11g.
• Design, Development And Maintenance Of All Oracle Databases Related Objects Like Tables, Views, DB Links, Triggers, Packages, Function, Procedures Collections, Ref cursors, Analytical functions, Global temp tables, SQL Reports in Development, Test and Production Databases.
• Expertise in optimizing and Performance Tuning of SQL Queries and PL/SQL applications using utilities like Explain plan, TKPROF, Hints, Indexes and BULK Collect / FORALL. Monitoring and optimizing the performance of the Database through Database Tuning
• Experience of working on Oracle Apps R12 Order Management . Order creation, booking, Back to Back order, RTV, R2A, Creating Concurrent program, value set etc..
• Planning project activities viz., scoping, estimation, tracking, change management, delivery management post implementation support
• Prepared many Technical Designed doc - MD70 at detailed level
• Experience with version control SVN, PCVS, MKS, Microsoft Visual Studio , change management and defect tracking systems using Mercury Quality Centre.
• Actively assisted many Project Management activities like MSR, MTR generation, Configuration Management, Quality Management.
• Defining project scope, goals and deliverables that support business goals in collaboration with senior management and stakeholders
• Implementing project plans within preset budgets and deadlines ensuring SLAs are achieved and client expectations are met or exceeded
• Leading technical business functions to successfully translate business needs into application with reduced time to market
• Executing complex projects in close collaboration with management, customers and stakeholders
• Designing, developing and delivering cost-effective, high-performance technology solutions to meet challenging business demands
• Conceptualizing ideas converting them into programs/projects, developing objectives for major programs and projects
• Participating in developing long term plans and product strategies consistent with those plans

Significant Achievement:

Appreciation mails received from Client/Business for effective accomplishments of complex tasks.

Technical Skills

Database Specific Skills:

• Oracle SQL/PLSQL Packages, Procedure, functions, Triggers, Indexes, Tables, DB Links, Analytical
• functions, Collection, Bulk Collect, SQL Reports..
• Oracle Performance Tuning/SQL Query optimization using Explain Plan, SQL Plus and TKPROF
• Oracle Applications R12 Supply Chain Order Management, Inventory
• Oracle Forms 6i/9i/10g, Oracle Reports 6i/9i/10g
• Toad 10.5.0.41, Oracle PLSQL Developer

Other Skills:

Kintana, PVCS, MKS, Microsoft Visual Studio, XML Publisher, Microsoft Projects

Domain Expertise

Key Projects Handled

Confidential

• Software : Oracle 10g PLSQL
• Oracle Application R 12i Order Management
• Configuration Tool : PVCS, Kintana.
• Role : Technology Architect, Team Lead,
• QA reviewer, Analyst
• Ajit's responsibilities in this project include:
• Responsible for designing Detailed Technical design doc MD70 preparation , developing, and maintaining complex PL/SQL applications built off of Oracle 11g environment.
• Worked on code migration, database change management and data management through the various stages of the development life cycle
• Written PL SQL procedures, complex queries, functions, packages and triggers according to business requirements
• Performance Tuning part taken care from the beginning of the development to improve the performance.
• Team Leading
• Analysis.
• Quality Code Reviewer.
• Development.

Confidential

• Software : Oracle 10g PLSQL, Forms, Reports
• Oracle Application R 12i Order Management
• Configuration Tool : Microsoft Visual Studio 2010.

Role : Project Management, Technology Architect, Team Lead ,QA reviewer, Analyst

• Ajit's responsibilities in this project include:
• Project Management includes MSR, MTR generation, Configuration Management, Quality Management
• Responsible for designing Detailed Technical design doc MD70 preparation , developing, and maintaining complex PL/SQL applications built off of Oracle 11g environment.
• Worked on code migration, database change management and data management through the various stages of the development life cycle
• Written PL SQL procedures, complex queries, functions, packages and triggers according to business requirements
• Performance Tuning part taken care from the beginning of the development to improve the performance.
• Team Leading Approximate Team size 35 .
• Analysis.
• Quality Code Reviewer.
• Development.

Confidential

• Software : Oracle 10g PLSQL
• Oracle Application 12i Order Management

Configuration

Role : Project Management, Technology Architect, Team Lead,QA reviewer, Analyst

• Ajit's responsibilities in this project include:
• Project Management
• Technical Solution Design and Development.
• Team Leading. Approx. Team size 20
• Individual Client Interaction.
• Analysis.
• Quality Code Reviewer.
• Development.

Confidential

• Software : Oracle 9i, Developer Suit 10g Forms, Reports, Designer ,Oracle 9i AS, Oracle Lite
• Tool : Visual Source Safe.

Role : Site in Charge, Team Member

• Ajit's responsibilities in this project include:
• Data gathering and analysis. Standardization of data.
• Implementation of the application.
• User training and guidance on the field.
• Technical and functional support.
• Enhancement.
• Maintenance.

Confidential

• Software : Oracle 8i, Developer 6i Forms 6i Reports 6i .
• Duration : Four Months

Role : Programmer

• Ajit's responsibilities in this project include:
• Analysis of functionality of the current system.
• Design new forms with keeping existing functionality as it is in addition with enhanced functionality.
• Analysis and Bug Fixing of application.
• Handling Change requests from Clients.
• Detailed analysis of user requirements.
• Mapping the User Requirements to IT Requirements.
• Developing Detail Design Document.
• Coding.

Confidential

• Software : Oracle 8i, Developer 6i Forms 6i Reports 6i .
• Duration : Three Months

Role : CM/DPR, Programmer

• Ajit's responsibilities in this project include:
• Requirements and Analysis: Understanding the requirements of the project.
• Coding.
• Database activity includes creating new as well as enhancements in the current database objects.
• Maintenance of Visual Source Safe.
• Testing.

Confidential

• Software : Oracle 8i , Developer 6i Forms 6i .
• Duration : Three Month

Role : Analyst, Programmer

Confidential

• Software : Oracle 9i, Developer 6i Forms 6i Reports 6i .
• Duration : 9 Months

Role : Technical Leader

• Ajit's responsibilities in this project include:
• Lighthouse ERP is a customized software for Steel Industry. It includes modules like Stores, Finished Goods, Raw Material, Plant Maintenance, Finance and Weighbridge.
• Assistance in Maintenance of Database Oracle 9i .
• Creating Procedures, Functions, Packages Performing database related activities like Partitioning, Export / Import in Oracle 9i.
• Design Coding.
• Requirements and Analysis: Understanding the requirements of the client and act as a sole functional resource.
• Interacting with the client on various forums to discuss the status of the project, clarify any queries regarding the functionality etc.

Confidential

• Software : Oracle 9i , Developer 6i Forms 6i Reports 6i .
• Duration : 4 Months

Role : Technical Leader

• Ajit's responsibilities in this project include:
• Transport System is a supporting project for Lighthouse ERP, Primary Objective of this project is to include all transport related activities which are required for Transport Company.
• Assistance in Design Maintenance of Database Oracle 9i .
• Creating Procedures, Functions, Packages, Triggers, Index Performing database related activities like Partitioning, Export / Import in Oracle 9i.
• Design Coding.
• Requirements and Analysis: Understanding the requirements of the client and act as a sole functional resource.
• Interacting with the client on various forums to discuss the status of the project, clarify any queries regarding the functionality etc.

Confidential

• Software : Oracle 9i, Visual Basic 6, Crystal Reports 4.6, VS-Flex Grid,Visual Source Safe.
• Duration : 18 Months

Role : Programmer

• Ajit's responsibilities in this project include:
• Power Plant Monitoring System PPMS is an ERP specially designed for Power Plant requirement. It includes modules like Responsibility Monitoring System, Works Planning Systems, Material Management System, Budget Costing Financial System, Plant Maintenance System. This project is being successfully used in all power plant of MSEB including one of the Asia's largest thermal Power Plant i.e. Chandrapur Super Thermal Power Plant.
• Assistance in Design Maintenance of Database Oracle 9i .
• Creating Procedures, Functions, Packages, Triggers, Index Performing other database related activities like Partitioning, Export / Import in Oracle 9i.
• Coding.
• Requirements and Analysis: Understanding the requirements of the client and act as a sole functional resource.
• Interacting with the client on various forums to discuss the status of the project, clarify any queries regarding the functionality etc.