Oracle plsql developer

Padma S

Mobile: +1-484-***-**** Email: **********@*****.***

Expertise Summary

•13+ years of Development and support experience in Oracle Database.

•Good understanding of SDLC, worked on Waterfall and Agile Models.

•Worked on Supply chain management, Insurance and Health Care Domains.

•Provided support and leadership in critical production support issue resolution.

•Worked with team to achieve timely resolution of all production issues meeting or exceeding service level agreements.

•Coordinate with dba s for task such as creating/rebuilding indexes, adding partitions, and analyzing tables.

•Proven experience in writing complex query Joins and using the PL/SQL performance tuning and optimizing SQL queries.

•Handel error using exception handling extensively for the case of debugging and displaying the error.

•Wrote packages to fetch complex data from different tables in the remote database using joins, sub-quires and database links.

•Creating an index on tables to improve the performance by eliminating the full table scans and viewing for handling the actual tables and to eliminate the complexity of the large queries.

•Extensively worked on Procedures, Packages, Cursors, and Functions.

•Proficient in SQL, PL/SQL.

•Knowledge of EBS (Oracle APPS 11i)

•Knowledge of D2K Forms and Reports

•Capable of understanding Client Requirement.

•Team Lead with interpersonal and good communication skills.

•Knowledge On Pipelined Functions, SQL LOADER, XML

•Quick problem-solver, strong analytical, coding, debugging skills.

•A versatile Team member with proven problem and solving skills.

• Excellent analytical and communication skills.

•Worked on Informatica, Control-M, SQL server MDM at basic level

Professional IT Experience:

•Principle Software Engineer in DELL INTERNATIONAL SERVICES from April 2013 to March 2021.

•Team Lead in NTT DATA (worked for Honeywell), Bangalore from April 2011 to April-2013.

•Senior Software Engineer in IIC SERVICES (INDIA) PVT LTD (Worked for WIPRO INFOTECH), Hyderabad from JULY 2010 to MAR 2011.

•Worked as a Software Developer in BSV Technologies Pvt Ltd. Hyderabad from May-2008 to June-2010

Qualification:

•B.E from Andhra University with 76% during the year 2008.

Technical Skills

Database

Oracle 9i/10g/11g/12C/19C, SQL server 2008 &2012

Programming Languages

Python 3.13.0

ETL

Informatica

Tools

SQL Loader, FTP, TOAD, SQL Developer, CM21, TFS

& Control m, GitLab

Project Assignment:

Project #1

Project: LOT (Large Order Tracker)

Client: DELL IT

Duration: 10-Jan-2018 to March-2021

Environment: Oracle 12C, Control-M, Informatica, SQL SERVER MDM, SQL SERVER2012, CONTROL-M, GitLab

Description:

A Large Order Tracker in Supply Chain Management (SCM) is a critical tool designed to monitor and manage large orders throughout the supply chain process. The large order tracker (LOT) tool is used for tracking the quotes with large orders, to set the supportability analysis for the Quotes and Parts, also to analyze the material readiness for pre-production factory builds.

Responsibilities:

•Participated in discussions with stakeholders to gather and refine project requirements Worked with Business Analyst to understand the requirements.

•Collaborated with project managers and stakeholders to estimate project timelines, resource needs, and deliverables.

•Conduct thorough code reviews to ensure high quality, maintainability, and adherence to coding standards.

•Worked closely with product managers, QA teams, and UX/UI designers to ensure alignment on project goals and user requirements.

•Monitored application performance, identifying bottlenecks and areas for improvement, and implementing optimizations.

•Regularly communicated project status, challenges, and accomplishments to stakeholders, ensuring transparency and alignment.

Project #2

Project: SCDH (Supply chain data Hub)

Client: DELL

Duration: Apr-2013 to Jan -2018

Environment: Oracle 11g, Informatica, SQL SERVER MDM, SQL SERVER2008, CONTROL M TFS

Description

This is a Supply chain data hub for DELL products. SCDH will maintain the data related to backlog, master data, fulfilment data, purchase data which will be consumed by many DELL applications. The scope for this project is to provide an end- to-end view of available finished goods inventory. It will enable Dell customers to receive accurate shipping and delivery dates at order creation. The Oracle Global Order Promising module will reserve inventory and calculate delivery times based on whether the inventory is on-hand, in transit, or to be purchased/manufactured. It will optimize the choice of fulfillment location(s) based on the requested options and 2nd touch services.

Responsibilities:

•Worked with business analysts to understand requirements and translate them into database solutions.

•Developed and maintained ETL processes to extract, transform, and load data from various sources into the SCDH system.

•Documented ETL processes, data mappings, and transformation logic for reference and compliance.

•Set up and managed job schedules in Control-M for automated data processing tasks related to the SCDH application.

•Monitored job execution and ensure that jobs run on time and without errors.

•Handled job dependencies and notifications for successful and failed jobs.

•Design and implemented MDM solutions to maintain a single, accurate view of critical supply chain entities (e.g., products, suppliers).

•Ensured that master data is synchronized across different systems within the SCM application

• Resolve the various production issues within time

Project #3

Title: Projections

Organization: NTTDTA.

Client: Scottish life Insurance

Duration: Jan-2013 – April - 2013

Environment: Oracle 10g

Description

This is an Insurance Project which calculates the Projections for the Pension. Pension is the amount which will get after the retirement age. It consists of new business, existing business and exits. New business contains illustration. Existing business contains projection calculation. Exits are the last stage of pension.

Responsibilities:

•Designed and developed PL/SQL programs, including stored procedures, functions, Packages to support insurance business processes.

•Written efficient SQL queries to retrieve and manipulate data related to policies, claims, premiums, and customer interactions

Project #4

Project: Aero Space

Organization: Honeywell Technology Solutions.

Duration: Mar 2011 – Dec-2012

Environment: Oracle 10g, TOAD, CM21

Description

Honeywell Aerospace is a leading global provider of integrated avionics, engines, systems and service solutions for aircraft manufacturers, airlines, business and general aviation, military, space and airport operations.

Aircraft equipped with Honeywell Flight Management Systems (FMS) use electronic navigation data for automatic guidance, electronic map displays and performance management. The navigational guidance provided by the FMS depends on the content, quality and integrity of the electronic navigation data loaded with each revision. Honeywell s Database and Information Services team provides the service needed to support your flight operations.

Key Benefits:

•Ensures timely delivery of navigational data to improve flight efficiency.

•Database delivered on schedule according to ARINC Cycle.

•Worldwide coverage is compatible with your navigation system.

Responsibilities:

•Designed and implemented PL/SQL programs, including stored procedures, functions, and triggers, tailored for aerospace applications

•Released Many Prototypes for customers to make sure the AERO data is accurate and reliable.

•Worked with business analysts and system architects to understand requirements and translate them into technical specifications.

•Follow SDLC standards (CRD, SRD) to make sure the code is documented, developed and tested.

•Involved in code reviews and test cases review.

•Mentored junior developers and provided training on PL/SQL best practices, particularly in the context of aerospace applications.

Project #5

Project: Wipro HIS

Client: New Medical Care (Abu Dhabi)

Organization: IIC SERVICES PVT LTD.

Duration: JULY-2010 to March-2011

Environment: Oracle 10g, SQL SERVER 2008

Description

Wipro HIS is comprehensive enterprise-wide software that covers all aspects of management and operations of a hospital. It is a modular and flexible system, and the various modules are seamlessly integrated with each other. HIS provides immediate access to clinical, administrative and billing data required by the various entities for the efficient functioning of the hospital. Scheduling outpatient visits and admissions are also streamlined by the proposed application. Requisitions and results reporting for laboratory, radiology tests and dispensing of pharmacy and non-pharmacy items is possible using HIS.

Responsibilities:

Analyzed existing SQL Server data structures, stored procedures, and scripts then Transformed and migrated data to the Oracle format.

Rewritten SQL queries and procedures to make sure those are compatible with Oracle.

Validated the migrated data from SQL SERVER to ORACLE and did it through testing.

Developed Database functions, Tables, Views, Synonyms, sequences, Triggers.

Written the PLSQL logic to support the Front end to generate reports.

Project #6

Project: CARD

Client: IGRS Department, AP. Govt, India

Organization: BSV TECHNOLOGIES PVT LTD

Duration: JUN-2009 to Jun-2010

Environnent : D2K (Forms/Reports 4.5 and 6i), Oracle 9i (SQL & PLSQL), TOAD

Description

CARD is a Computer-Aided Administration of the Registration Department. CARD is a catchy name given to the comprehensive project of computerizing one of the oldest wings of the Government "The Registration & Stamps Department". CARD provides overall transactions details regarding the registration and stamps of Andhra Pradesh Government which accomplishes the main modules Encumbrance, Reviews, Login Administration, Help Desk, and Citizen Services. Encumbrance is a process for search criteria for the respective properties. Reviews provide to Upload, Data Review, Version Review, Utilization Revenue Details, Survey nowise Registration Data, Income Tax, Circulars. Login Administration provides security authentication for different users. Helpdesk provides the information regarding the end user requests and the administrative side. Citizen Services provides Find SRO, Duty Rates, Structure Rates, Unit Rate of M.V, Duty & Fee Stmt, Encumbrance, and Deed Details.

This CARD project mainly deals with the Registration involved in Lands, Firms in the entire Andhra Pradesh. This project is based on client-server Architecture.

Responsibilities:

Created FORM UI to capture marriage registration details.

Developed Database packages to maintain Business Logic for FORMs.

Involved in Developing of Database Procedures and Triggers, functions.

Created REPORTs for the users to view registered forms and history of data.

Developed Database Tables, Views, Synonyms, Sequences.

Migrated the existing FORMs and REPORTs from 4.5 version to 6i version.

Production Support.

Project #7

Project: EVENT LOGBOOK MAINTENANCE

Organization: BSV TECHNOLOGIES PVT LTD

Client: LANCO POWER PLANT

Duration: May-2008 to May-2009

Environnent : D2K (Forms/Reports 6i), Oracle 9i (SQL & PLSQL), TOAD

Description:

Event Logbook Maintenance project is used to track the defects of Machinery and Accidents in the plant. Regular analysis on the productivity of the plant is also maintained, to make efficient usage of the resources. Safety regulation certifications and reports are generated periodically to maintain the history of the plant.

Responsibilities:

Created FORM UI to maintain defects of Machinery.

Developed Database packages to maintain Business Logic for FORMs.

Involved in Developing of Database Procedures and Triggers, functions.

Created REPORT for the users to view the history of the plant.

Developed Database Tables, Views, Synonyms, Sequences.

Personal Details

Name: Padmavathi Devi. Singu

Date of Birth: 05-04-1986

Father’s Name: Mr. Pitchaiah Singu

Contact this candidate