Oracle PL/SQL Developer with 8+ Years Experience

Shalini Kannappan

Ph: 407-***-**** Email: **************@*****.***

8+ years of extensive Database experience and application development, both on UNIX & Windows environments, using Oracle 10g/9i/8i, SQL, PL/SQL, SQL*Plus,

Good knowledge in procedure, package, function, triggers and table and index concepts and developed the same.

Experience in ORACLE PL/SQL based application support.

Business requirement analysis and estimation for the development work.

PL/SQL development work.

Worked few basics in AB initio.

Used AppDynamics for the application performance monitoring.

Strong Programming experience and Oracle Data analysis, data validation and SQL query development.

Debugging Oracle procedure/package and fixing the minor defects.

Extensive hands on experience in programming in SQL and PL/SQL – Creating Database objects, Stored Procedures, Packages, Functions, Triggers, Exception handling, Dynamic SQL, Oracle supplied packages. Implementation and execution from UNIX shell scripting.

Experience in performance tuning and optimization techniques using Indexes, Hints, Stats gathering, Profiling, Explain plan, Tkprof.

Strong understanding about Software Development life cycle (SDLC) and was extensively involved in all different stages including development, testing, implementation, knowledge transitioning and post implementation production support, troubleshooting & debugging.

Extensively worked in onsite-offshore model. Well known for managing group of team and working with cross-functional teams and various stake holders like QA, Release Management, Change Control teams, etc. to achieve on-time deliverables.

Strong analytical, problem solving & organizational abilities, ability to perform exceeding expectations. Ability to quickly learn and teach new concepts, adaptability to change and manage multiple tasks efficiently.

Experience in production Oracle development and support of software products by investigating and recreating reported defects

Answer Client Support questions via phone and e-mail

Experience in all phases of the project including requirements gathering, risk analysis, project planning, scheduling, testing, defect tracking & management, and reporting.

Experience in Project Analysis, Scope identification and Estimation.

Experience with software test plan development and execution.

Experience in writing and editing test scripts.

Assist in implementation of QA standards and continual improvement activities.

Assess testing quality by monitoring defect trends while moving application between various environments.

Generate various metrics to measure cause of disproportionate defect density.

Created complex project plans using Microsoft Project Plan.

Worked in Excel and used Pivot tables

Expertise in Project Management Activities - Audits and Reviews.

PROJECT EXPERIENCE

1. IDMS ( APPLE INC ) Support

Duration

Jun 2020 to Till date

Technology

Oracle 9i, PL/SQL, Java, PL/SQL Developer, Putty, SPULNK

Location

Wyndham Vacation Ownership, Orlando FL

Abstract

IDMS is identity management system for Apple internal and external Apple ID account management.

Project Type

Support & Maintenance

Role

Team member

SQL and Nosql Support

Account Management issue debugging using sql and nosql

Identifying the root cause of the issue

Contacting the respective operation team to fix the issue.

2. VOYAGER

Duration

July 2017 to Dec 2017 and June 2018 to Mar 2020

Technology

Oracle 9i, PL/SQL, Java, Hibernate, UNIX Shell scripting, SQL*Loader Toad, PL/SQL Developer, Putty

Location

Wyndham Vacation Ownership, Orlando FL

Abstract

Voyager is the application which maintains the room inventory detail of the resorts owned by Wyndham. The inventory system has multiple logics to generate the room availability for the future 24 months. The system batch job generate the room availability using the complex business logic handled in PL/SQL. For the requirement handling I have designed the tables and object and consumed the data in the PL/SQL for the business logic to generate the availability

Project Type

Development, Support & Maintenance

Role

Team member

PL/SQL code development

Integration of Stored Procedure with Java code.

AppDynamics For the Application performance monitoring

Created/Updated Hibernate mappings for any changes in the table structure during Production Support Enhancement.

Development/construction or package/procedure, table and index change

PL/SQL Development and unit Testing

Development Design

Requirement Gathering

Enhancing the existing code according to client request.

Involved in requirement gathering, analysis of business requirements and designing the applications.

Create database objects like Tables, Views, Materialized Views, procedures and packages using the database tools Toad, PL/SQL Developer.

Write UNIX shell scripts for data processing and refreshing materialized views.

3.IMS

Duration

Nov-07 to Aug-13

Technology

Oracle 9i, PL/SQL, UNIX Shell scripting, SQL*Loader

Location

COGNIZANT TECHNOLOGY SOLUTIONS INDIA PVT LTD, CHENNAI

Abstract

CLIENT DESCRIPTION:

IMS is the one global source for pharmaceutical market intelligence, providing critical information, analysis and services that drive decisions and shape strategies. Just about every major pharmaceutical and Biotech Company in the world is a customer of IMS. Their unique mix of experience and expertise makes them the right choice for help in optimizing portfolios, ensuring successful launches, managing brands and improving the effectiveness of sales teams.

IMS is a global company, with 6,000 employees and a presence in 100+ countries worldwide. IMS HEALTH is the largest pharmaceutical manufacturer information partner, with over 50 years' experience in the industry. Key products and services integral to customer day-to-day operations include market research for prescription and over-the-counter pharmaceutical products and sales management information to optimize sales force productivity. IMS Health’s market intelligence and analyses give customers the critical facts they need at every stage of the pharmaceutical life cycle - from the earliest stages of research and development through product launch, product maturation and patent expiration.

Project Type

Support & Maintenance

Role And Responsibilities

Support Engineer:

Application support

PL/SQL code fix and development activity

Performance issue fix in PL/SQL

PL/SQL unit Testing

UNIX shell script job control file debugging and performing the code fix

AB initio code debugging and bug fix

Have been involved in the Support and Maintenance of transaction and reporting modules.

Have produced test case documents for transaction and reporting modules and have been involved in testing the reporting module.

Have handled multiple change requests after implementation simultaneously

Provided support for the application by fixing bugs and loading data into the system as per client request.

Have prepared Technical specification and User guide documents covering the key features of the application.

Have generated ad hoc reports as per client request (which is usually an urgent request) and delivered them on time.

Contact this candidate