Oracle PL / SQL Developer Resume

U Gupta +1-201-***-****

*********@*****.**.**

SUMMARY

• 6+ years of experience in Requirements Gathering, Analysis, Development, Support and

Enhancement, Business Analysis of 3 tier businesses applications with core focus on DB

development.

• Experience of Reporting as well as Formsdevelopment

• 6 years of excellent hands-on experience in PL/SQL and well-versed with advanced PL/SQL

Concepts viz. cursors, exceptions, database triggers, database packages, procedures & functions.

• 2 months of project with ABB Ltd, being part of 2nd year of PGDM.

• 1 year of experience as Consultant. Recognized for successful project co-ordination, Productivity

improvement, Incident Reduction and Resolution of long pending Issues

• Excellent SQL skills, experience in writing complex queries and working with database objects

(i.e. tables / views / sequences etc.).

• Hands on experience in Data Migration from one database to another Database

• Proficient in utilities such as SQL*Loader, SQL*Plus, Import/Export and tools such as Toad,

SQL Developer.

• Experience in Query Optimization, Indexing and Hints

• Developed custom reports using SQL*Plus

• Experience in 24/7 Production Support & Maintenance of CA ITCM

• Excellent analytical, problem solving, communication and inter-personal skills to manage and

interact with individuals at all levels of Business, Engineering, QA and other teams involved with

System Development Life cycle.

• Enthusiastic team player with coordination and organizational skills

• Detail oriented and self-motivated with ability to manage multiple tasks, prioritize and adhere to

tight deadlines

• Extensively involved in all the phases of SDLC (Software Development Life Cycle)

• Preparation of impact analysis, Coding, System Test Plan, Testing, Code Review, coordinating user

training, UAT, Project demonstration, Implementation and Maintenance

• Worked in CMMI Level 5 Projects have been CC (Configuration Controller) and member of various

CM (Configuration Management) audits

• Quick learner with ability to master new concepts and applications

• Have Worked in Travel and Transport Domain for 3 years

• Experience in PerformanceTuningandOptimization

SKILLS

Technical expertise revolves around database development and supporting practices in software development

life cycle includes configuration management tools, integrated development environment and domain

understanding.

Languages PL/SQL, SQL.

Databases Oracle 10g/9i,SQL Sever

Networking Tools CA Desktop and Server Management 11.2, CA IT Client Manager 12.5, CA

DSM Reporter

Exposure To ADO.NET, Windows Communication Foundation, Windows Presentation

Foundation, Windows Workflow Foundation, C and AutoIT, PL/SQL Tuning,

Index Tuning

Tools SQL Developer, Toad, Eclipse.

Web Technologies HTML, Javascript

U Gupta +1-201-***-****

*********@*****.**.**

Methodologies Billing & Payments, Infrastructure Management System.

Operating Systems Windows 98, 2000, 2003, XP, Vista and 7.

(Server/Client)

PROFESSIONAL EXPERIENCE

Starwood Hotel and Resorts

11 months

Duration :

Adaptive Conversion (Nov 2013 – till date)

Project :

Position : Data Migration Developer

Project description : Starwood Preferred Guest and its active membership base continue to

grow. Conversion program consolidates its entire client base into a centralize database on oracle with

enhanced data model than old decentralized CRM systems. My module covers the minor data modelling

requirement for project and complete data migration from legacy system to new oracle system.

Responsibilities:

• Requirements gathering and leading a team of offshore developers for migration scripting.

• Worked with business analysts to consolidate functional requirements for migration.

• Development of procedures and SQL source per migration process.

• Performance tuning and optimization in scripting to reduce time of data load and downtime.

• Training and knowledge management for production support team.

Environment: Oracle 11g, PL/SQL, SQL, SVN

Pitney Bowes

Duration : 1 year 10 months

Mailer Integration (Jan 2012–Oct 2013)

Project :

Position : Oracle Developer (Reporting for Billing & Payments)

Project description : Pitney Bowes is trusted provider of mail process in software and

equipment. Mailer integration is a secure digital online mail service where mailers can log on to get their

customers’ bills, statements, notices, promotions and even coupons, all on one site. They can see different

feeds coming into system including customers mailing preferences. Reporting module is created to monitor

effectiveness and efficiency of marketing efforts in terms of mailer activities. It also includes various check

point reports for mailers and providers to check billing and payments data.

Responsibilities:

• Requirements gathering, clarification and development of reporting system.

• Worked with business analysts and cross functional teams to define workflow/processes and functional

requirements.

• Development of procedures and SQL queries to get reporting data.

• Day to day customized reporting required by business to make agile decisions.

• Coordination among services and consumer interface team for correct requirements flow.

• Involved in performance tuning and monitoring by creating indexes.

• Defined use cases and system test cases.

• Responsible for leading offshore development tasks.

• Created indexes for fast retrieval of information.

Environment: Oracle 9i PL/SQL, MySQL, Routines, UNIX, SVN, Eclipse, Soap UI, WSIMPORT, HTML,

PuTTy

ABB

U Gupta +1-201-***-****

*********@*****.**.**

PROJECT: Cost Effective Logistics with Optimal Inventory (Oct 2011 - Dec 2011)

This project was an attempt to study the COST SAVING IN LOGISTICS, ABB LIMITED. The project was

divided into two sections. First, the analysis of Current cost saving position of the company and second was

the study of cost saving techniques.

A study of Cost Saving in LOGISTICS at ABB LTD. Due accurate and detailed planning we would like to

shift the procurement of FG from Italy from Air mode to Sea mode fright, this will give us the advantage to

improve the OTD having stock of FGs and reducing the transport cost without significant increase of the

inventories

Ratio analysis has been done on the basis of five years data. Ratios have been discussed to compare inventory

management performance over the years and to comment and not the absolute values. Therefore figures have

been converted into 12 months in this report. To analyze the performance, published balance sheets of ABB

LIMITED have been used. This project report is based on financial data up to 2010-11 only.

Inventory a double edged sword is usually an asset of an organization, if not used properly it will become

liability. It is therefore absolutely very important to manage inventories efficiently and effectively in order to

overcome unnecessary investment. And To identify the problems/challenges involved in the Cost Saving in

LOGISTICS, at ABB ltd.

Objective: - Compare both the cost i.e. cost by air and cost by sea, and find a suitable way to import

material without affecting the On Time Delivery, Customer satisfaction & to add onto company bottom

lines.

The main aim was to manage the INVENTORY, throughout the process.

CIBERsites(April 2011 – September 2011)

Duration : 5 months

Projects : TechOps – Enterprise Management System

Position : Consultant (Reporting and Billing & Payments)

Project : ITO-ITCM

Roles and Responsibilities:

• Hands on experience in implementing as well as supporting CA Unicenter Desktop and Server

Management (CA DSM)

• Health checks& up gradation of CA products

• Daily DSM Health Check on Domain servers and resolving if any errors faced in any scalability or

domain servers

• Organized UAT for business admin user

• Developed packages, Stored Procedures and Stored Functions

• Practical exposure of working in CA DSM 11.2 as well as CA ITCM 12.5

• Weekly Patching on Windows XP and Windows Server machines

• Report Generation in DSM Reporter

• Responsible for in-house presentations, inter-company presentations

• Used AutoIT for packaging executable file software and creating package of Microsoft Installer file

software

• Participated in the process of Upgradation of CA Desktop and Server Management 11.2 to CA IT

Client Manager 12.5

• Development of procedures and SQL queries to get reporting data

• Involved in performance tuning and monitoring by creating indexes

• Defined use cases and system test cases

• Provide technical and functional application support including application patching and preventive

maintenance

U Gupta +1-201-***-****

*********@*****.**.**

• Generating Software Distribution Report for previous Static/Dynamic Software Deployments

• Created indexes for fast retrieval of information

• Support and maintenance to database issues

• Creating & configuring Software Distribution Policies

• Software Packaging in DSM Environment Testing & Releasing for specific machines using Software

Catalog or Distribution to a Static/Dynamic Group of DSM Agents

• Resolve issues by email.

Environment: SQL Server, Oracle, Oracle 9i PL/SQL, Routines, PuTTy, CA IT Client Manager 12.5, CA

DSM Reporter, HTML, AutoIT.

NIIT Technologies(Apr 2008 – Apr 2011)

Duration : 3 years

Projects : Airport Management Solution

Position : SoftwareDeveloper (Reporting and Billing & Payments)

Project : SITA Project (http://www.sita.aero)

Project description : SITA’s portfolio includes: managed global communications,

infrastructure and outsourcing services, as well as services for airline commercial management and passenger

operations, flight operations, aircraft operations and air-to-ground communications, airport management and

operations, baggage operations, transportation security and border management, cargo operations and more.

Airport management solution was one of the flagship projects for SITA that works mainly in TTL domain

(travel and transport logistics). AMS was a combination of products designed to optimize operations, reduce

congestion and improve the airport experience for all.

This project was a live project which is installed at approximately 125 airports and more than 40 international

airports in different countries. In India Mumbai was using this but they are now slowly phasing it out.

It has broadly two components APV (Airport Vision and AODB)

APV is responsible for the display and other information systems at the airport.

AODB works as a background application which keeps track of each and every service, Flight data, various

resources etc. and manages and schedules them for each and every movement of an airline.

AODB has logics for billing and it calculates the bills for each and every service that airport provides to and

an airline.

Responsibilities:

• Requirements gathering, clarification, design and development of reporting architecture

• Worked with project management, business analysts and cross functional teams to define

workflow/processes and functional requirements

• Development of procedures and SQL queries to get reporting data

• Coordination among services and consumer interface team for correct requirements flow

• Involved in performance tuning and monitoring by creating indexes

• Defined use cases and system test cases

• Debugging the flow to resolve issues using ADO.NET

• Worked on the localization strategy for the reports

• Responsible for leading offshore development tasks

• Created indexes for fast retrieval of information

• Responsible for in-house presentations, inter-company presentations

• Support and maintenance to database issues

• Initiating enhancements in business process for longer term cost benefits

• Interacted with business analysts and business partners to understand the requirements

U Gupta +1-201-***-****

*********@*****.**.**

• Executing the various major/minor/bug-fix and enhancement requests involves design and

development.

• Developed packages, Stored Procedures and Stored Functions

• Data Migration in application during plant transformation from legacy into Oracle ERP

• Production support of Airport Management Solution Application including 24/7 support for critical

issues

• Led the weekly status report meeting on planned enhancements and bug fixes

• Tested the application to validate proper functionality in integrated system environment

• Organized UAT for business admin user

• Client interfacing, communication regarding status of schedule and conflict resolution between

offshore and customer

• Design and development of flight arrival and departure process in PL/SQL

• Design and development of flight saved search functionality through PL/SQL

• Responsible for performance tuning of the database

• Tuning of SQL Statements

Environment: SQL Server, Oracle, Dot Net, Visual Studio, Oracle 9i PL/SQL, Routines, HTML, PuTTy.

EDUCATION AND CREDENTIALS

• B.Tech. in Computer Science & Engineering and PGDM in Finance

Contact this candidate