Oracle PL/SQL Lead/Developer

Professional Summary

Vadivel has over 10 years of professional experience in the field of Information Technology in various phases of Software Development Life Cycle SDLC process using CMM practices. He has extensive experience with Oracle Technology SQL, PL/SQL, Stored Procedures, Packages, Functions, Triggers, Collections, Snapshot, Partitions, etc., to design and develop robust OLTP/OLAP application.

Experience Synopsis

• Well experienced in Tuning, Debugging Trouble Shooting Oracle PL/SQL objects.
• Experienced with advanced Oracle programming concepts.
• Experienced in Logical/Physical Dimensional Data Modeling techniques and best practices using CA Erwin tool for Oracle databases.
• Experienced in developing reports using OBIEE tool Trained from Oracle University .
• Experienced in PeopleSoft SQR , Web FOCUS reporting technologies Oracle D2K to design and develop.
• In-depth knowledge of relational database design and database management systems.
• Very good experience in Water Fall methodology and fair experience with Agile methodology.
• Experienced in developing Data Warehousing OLAP applications.
• Experienced in developing Unix shell scripts.
• Knowledge on Retail, Financial Services Banking Domains.
• Knowledge in java application architectures web services .
• Ability to communicate with both technical Technical Architects and non-technical Business Analysts, Business Process Consultants, etc., team members.
• Have beginner level experience in creating reports using Hyperion.
• Excellent Oral Written communication skills.

Technical Skills Summary

Other Tools: WinSCP, Snagit, Test Director, HP Quality Center, Putty

Professional Experience

Oracle PL/SQL Lead/Developer

Project: Settlement Application Rewrite

Department: FedACH Federal Automated Clearing House

Role: Oracle PL/SQL Lead/Developer

Environment: Oracle 11g SQL, PL/SQL, Packages, Stored Procedures, Functions, Collections, Partitions , UNIX, OBIEE Reports, SQL Loader, UNIX Shell Scripts, Control M jobs

Project Description:

The FedACH system's core function is to facilitate the exchange of ACH items between participating banks by processing incoming ACH items from sending bank and delivering them to designated receiving bank. The project involves in developing a new distributed application to settlement transactions between banks through Federal Reserve Bank.

Responsibility:

• Develop new SQL Loader routines to load huge volume of data currently, 2 million records received from core currently, mainframe .
• Develop new and efficient PL/SQL objects to ETL raw data received from core to target tables after applying business rules.
• Develop new Oracle packages to create flat files using oracle UTL FILE utility and new packages to migrate huge volume of data.
• Develop UNIX shell scripts to interface Oracle object with Control M jobs.
• Develop UNIX shell scripts to multi-thread table data migration Chunks created for each table data segment with start/end rowid for parallel load .
• Design Oracle tables with partitions and indexes.
• Lead the team by assisting with PL/SQL Best practices and standards.
• Provide mentoring and knowledge transfer of PL/SQL skills to existing staff.
• Work with Business Analysts to understand the business requirements.
• Provide technical work estimates and task breakdown.
• Participate in peer code reviews and provide support to QA/Prod during the test/migration process.
• Develop OBIEE Reports Analysis Dashboard .
• Performance tuning of Oracle queries.

Oracle PL/SQL Lead/Developer

Confidential

Confidential

Role: Oracle PL/SQL Lead/Developer

Environment: Oracle 11g SQL, PL/SQL, Packages, Stored Procedures, Functions, Collections , Pro C Language, .net Front-End , Java J2EE Middle tier , Forms, UNIX

Project Description:

A program to automate the day-today activities of Target Corporation's RDC Regional Distribution Centre , IW Import Warehouse FDC Food Distribution Centre . The main modules of the program include Receiving, Warehousing, Shipping, Yard Management, Scheduling, and Paperless Picking. The project involves in converting the existing legacy system to 3 tier architecture. The new technology involves .Net as presentation layer, Java as middle tier and Oracle 10g as database. This project is executed according to Agile methodology.

Responsibility:

• Preparation of high level low level design documents for new Stored Procedures/Packages.
• Designed a checklist for PL/SQL coding standards to follow across the new application.
• Designed Oracle Type objects to transfer data between Oracle database Java.
• Decommissioned duplicate Oracle Stored Procedures with similar logic functionality .
• Stored Procedures with generic logic frequently used are group under a common Oracle Package for re-usability.
• Refactored the existing Procedure/Function with Advanced Oracle Concepts BULK COLLECT, etc., for better performance.
• Analyzed the performance Execution time in Milliseconds of each Stored Procedures/Functions and tuned the code using Oracle Advanced Concepts, Oracle Indexes and Necessary SQL Hints.
• Reviewed Oracle Stored Procedures/Functions/Packages code to verify the standards, nested loops, etc.,
• Performance Tuned the SQL queries using Explain Plan/Auto Trace.
• Designed Logical/Physical Data Model using CA Erwin tool for the project requirements.
• Implementation Deployment Verification for Oracle Objects.

Confidential

Role: Oracle Senior PL/SQL Developer Data Modeler

Environment: Oracle 10g SQL, PL/SQL, Stored Procedures, Functions, Packages , Java ATG Framework , Job Management using Control M, Queue Management using Qpasa, WebFOCUS7.6, UNIX, SQL LOADER, Erwin.

Project Description:

Manage Imports Business MIB is a new application rewritten from the existing legacy system that will not meet Target's expected growth in the import business. MIB is a system used by Import Finance team, to track international purchase order and invoice matching. MIB houses all import data.

Responsibility:

• Data Migration from legacy system Release 2.3 .
• Enhancement to the program for U.S.A Customs Border Protection Safe Port Act.
• Enhancement to the program for Overseas Freight Payment module.
• Interacted with Business Analyst to understand the project requirements.
• Designed Logical/Physical Data Model using CA Erwin tool for the project requirements around 30 new tables created .
• Reviewed the Logical/Physical Data Model with IA Information Architect , TA Technical Architect , BA Business Analyst for Target Corporation standards 3NF-3rd Normal Form, Abbreviation, etc., .
• Created necessary Indexes, Constraints Trigger on new tables.
• Developed new Oracle Packages to migrate the data from legacy system to new system.
• Developed new ETL PL/SQL scripts with BULK COLLECT, PARTITIONING concepts to load the data from old application database to new application database.
• Developed new Control files to load the data from flat files to Oracle database using SQL LOADER.
• Developed new reports using WebFOCUS 7.6.
• Tuned the SQL queries using Explain Plan.

Confidential

Role: Oracle Senior PL/SQL Developer

Environment: Oracle 10g SQL, PL/SQL, Stored Procedures, Packages, Types , Pro C, UNIX, C

Project Description:

IW Sorter Enhancement - To enhance the existing distribution system with a new module to auto scan the cartons boxes on the conveyor belt in IW Import Warehouses and Divert Tilt the carton to the corresponding RDC regional distribution centre door automatically based on the percentage satisfied RDC.

Alaska/Hawaii New Store Enhancement - To enhance to the existing retail distribution system for the expansion of new Target stores in Alaska and Hawaii to provide a special visual indicator 'RETK', 'T' on the store containers to segregate the boxes in stores to re-ticket the items/boxes for price change based on the local market strategy.

Responsibility:

• Prepared High Level Design for the project.
• Interacted with Onsite team to review the business requirements.
• Prepared Use Cases, Unit Test Cases System Test Cases based on business requirements.
• Developed a new Oracle Package 4000 Lines of Code, 18 Procedures/Functions to validate the barcodes scanned by conveyor and to return the DC allocation.
• Developed new Unix Shell script using fork concept to load test the new procedure to return the DC allocation in 2-3 seconds.
• New debugging logic is designed developed using Oracle Packages, Pragma Autonomous Transaction concept Oracle Types to find the exception location.
• Enhanced existing C Pro C programs for business requirements.

Oracle PL/SQL Developer

Confidential

Confidential

Environment: Oracle 9i SQL, PL/SQL, Stored Procedures, Packages, Synonym, Grant/Revoke, DB Link, Snapshots, Views , SQR3.0 Structured Query Reporting , Pro C, Forms

Project Description:

The program is a GUI Retail Application built to automate the Retail of Furniture, Appliances, and Electronics business of various modules like, Sales, Purchase, Finance, Accounting, Receiving, Warehousing, Shipping, and Inventory.

Responsibility:

• Interacted with Business Users to understand the requirements documented in CR Change Request .
• Prepared low level design document with Oracle PL/SQL pseudo code for offshore team to develop the requirement.
• Developed new Oracle Packages for POS - Point of Sale application enhancement.
• Developed new Oracle Snapshot objects to fetch the data from remote database for frequent reference.
• Created new DB LINKs to access data between Oracle Databases.
• Developed Oracle Synonyms for Oracle Tables/Procedures/Packages to Grant/Revoke specific privileges on the original Oracle object.
• Developed new reports using SQR 3.0 technologies.

Confidential

Role: Oracle Senior PL/SQL Developer

Environment: Oracle 9i SQL, PL/SQL, Stored Procedures, Packages, Triggers , SQR3.0 Structured Query Reporting , Pro C, Power house QTP, QKS, QZS , COBOL, SQL Loader, Forms

Project Description:

Conversion of 3GL Powerhouse file-system to Oracle GUI Applications to Automate, Television and Appliances Services TAS Trans Global Warranty TGW systems.

Conversion of the Retail System reports from Pro C, PL1 to SQR 3.0 Technology.

Responsibility:

• Designed new Oracle Tables for User-Program security for the new application User will be able to access the programs which are applicable .
• Developed new Oracle Triggers to retain old data before updates.
• Developed new Oracle Packages from Legacy Power house application QTP, QKS, and QZS .
• Developed new matrix reports using SQR 3.0 technologies.
• Used SQL LOADER to export the data from Power house application flat files to Oracle Database using Control Files.
• Assisted project team members with Oracle concepts.

Oracle PL/SQL Developer Confidential

Project: Application Conversion for IDOT USA , Paquet Express - Mexico

Environment: Oracle 9i Database SQL, PL/SQL, Stored Procedures, Packages , Oracle Forms

Project Description: Conversion of the application from lower version to higher version.

Responsibility:

• Analyzed the existing table structures to replace with new features CHAR to VARCHAR2 Datatypes, etc., .
• Prepared low level design documents for Oracle Stored Procedures modifications.
• Modified the existing Oracle Stored Procedures to re-factor the code with new features replace type with rowtype, etc., .
• Unit tested the modified code.
• Developed DML scripts to create data for system testing.

Oracle PL/SQL Developer

Confidential

Project: Interviewing and Record Keeping Project for Police Dept ,

Environment: Oracle 8i SQL, PL/SQL, Stored Procedures , Visual Basic 6.0

Project Description:

• The project is developed for State Government of Tamilnadu to capture the information provided by public people as a complaint in Police Station.
• Responsibility:
• Created all necessary DDL statements New Tables, Indexes, Constraints, Views, Synonyms, Sequences, etc., for the new application.
• Developed Unit Tested new Oracle Stored Procedures.
• Involved in Application System Testing.