PROFESSIONAL SUMMARY:

• 11+ Years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Knowledgeable Oracle Developer skilled in data collection, analysis and management.
• Highly - skilled software development professional bringing more than 11 years in software design, development and integration. Advanced knowledge of Oracle SQL, PL/SQL
• Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques. Expertise in Client-Server application development using Oracle 12c/11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re- Write.
• Experience in Data warehouse concepts, ETL.
• Good knowledge on logical and physical Data Modeling using normalizing Techniques.Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Developed materialized views for data replication in distributed environments.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables. Loaded Data into Oracle Tables using SQL Loader.
• Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
• Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
• Created Shell Scripts for invoking SQL scripts and scheduled them using crontab.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.
• Experienced on the agile methodologies and was part of the agile delivery team for more than 5 years.

SKILL:

• Software Products
• Tools
• Oracle(SQL,PL/SQL) Performance Tuning
• Data Modelling
• SQL PLUS
• SQL loader
• UNIX Shell scripting
• HP Quality Center
• TOAD,
• Oracle Sql Developer
• ERWin 4.0/7.3
• QlikView Analytical Tool
• Shell scripting

WORK HISTORY:

Confidential

Sr Oracle PL/SQL Developer

Responsibilities:

• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
• Was part of the development of a new Oracle Asset Tracking system with in Oracle.
• Was part of the Building the Mobile Platform called TONGO
• Developed generic import tool with dynamic Sql loder control files
• Developed configurable extract tool
• Developed the conversion programs to convert 60 million records from legacy asset tracking system.

Confidential

Sr Oracle PL/SQL Developer

Responsibilities:

• Involved in the continuous enhancements and fixing of production problems.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Created indexes on the tables for faster retrieval of the data to enhance database performance

Confidential

Sr Oracle PL/SQL Developer

Responsibilities:

• Analysis and researching the CATS Issues.
• Developed configurable the Physical Audits workflow
• Developed the electronic data discovery(EDD) to automatically update the asset records EDD data
• Worked on the EPL projects to develop interfaces between oracle apps and CATS application
• Worked on the Error handling enhancements and Automated updates project

Confidential

Sr Oracle PL/SQL Developer

Responsibilities:

• Analysis and researching the Issues that has occurred in the Red Hat Period.
• Worked on the Bank account conversion.
• Involved in the continuous enhancements and fixing of production problems.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Created indexes on the tables for faster retrieval of the data to enhance database performance

Confidential

Sr Oracle PL/SQL Developer

Responsibilities:

• Analysis and researching the Issues that has occurred in the Red Hat Period.
• Worked on the vendor conversion and Employee conversions.
• Assisted in performing the go-live activities.
• Improved the performance of the application by rewriting the SQL queries.
• Wrote packages to fetch complex data from different tables in remote databases using joins, sub queries and database links.
• Involved in Logical & Physical Database Layout Design.

Confidential

Prod Support/Developer

Responsibilities:

• Involved in FA Conversions in Production (Asset Conversion)
• To research and resolve issues within the agreed SLA norms.
• Worked on FSG reports
• Reconciliation of the cost and Depreciation reserve for all the Corporate and tax book assets by account wise..
• Supported on Period end closing
• Assisted users in completing the transactions
• Worked on Oracle TAR support for Depreciation Calculations.
• Development of Unit Test Cases & Integration Test Cases for proper testing of the configured applications.
• Workflow and developing the Process flow to integrate With Other Modules.
• Worked on Conversion data file preparation and mapping the same with legacy system
• Post Implementation Support especially on Period end closing for all the Financial modules

Confidential

Prod Support/Developer

Responsibilities:

• Designing the technical approaches to split 1 million(Approx) Assets and transfer them to the Proper legal Entities.
• Developing of programs for asset Retirements
• Reconciliation activities to ensure that all the Assets have been properly transferred.
• Developed an approach for getting the necessary code Combinations enabled/created that involves the transfers of assets.
• Providing support for all the period close activities in the Period of the Go-live.
• Prepare all local technical Design Documentation (MD70)
• Prepare site-specific test script.

Confidential

Prod Support/Developer

Responsibilities:

• Implemented the EDI XML PO Outbound Process.
• Analysis and researching of the necessary set-ups and patches required for EDI XML PO Generation.
• Developing of Custom report to keep a track of POs setout through XML Gateway
• Getting the patches XML Gateway patching (Analysis, Application and Testing) done.
• XML Gateway Transaction,XML Gateway Protocol XML Trading Partner setup and validation
• Assisting in 850 Mapping with Tibco and Oracle development of custom XML File Generation program to generate the Flat file program to be ftped to Unix box Confidential Tibco End
• Development of Unit Test Cases & Integration Test Cases for proper testing of the configured applications.