Sr. Pl/sql Developer Resume

Summary:

• Oracle PL SQL programmer with over 7 years of extensive experience in Application Development, Oracle SQL, PL/SQL Development (Oracle 10g/9i), Implementation of ERP (Oracle Apps) Application, Performance Analysis, Production Support, SQL*PLUS.
• Hands on experience in implementing Software development life cycle, leading and executing deliveries and supporting global clients & customers
• Extensive experience working with Oracle 8i/9i/10g including PL/SQL programming.
  Proficient in writing complex SQL Queries, Stored Procedures, Normalization, Database Design, creating Indexes, Functions, Triggers, Sub Queries, Autonomous transactions and Packages on TOAD to analyze very large data sets
• Extensive knowledge of Dynamic SQL and queries
• Strong working knowledge on Oracle Database concepts
• Extensive experience in Performance Tuning (UsingTKPROF, SQL TRACE & Explain Plan, Analyzing Indexes) etc
• Hands on experience in Implementation, Development, Enhancement and support of Oracle Apps Modules (Account Payables/ Order Management/ General Ledger/ Purchasing/ Cash Management/ Inventory/ Manufacturing)
• Hands on experience increating and migrating AOL objects such as Concurrent programs, Value sets, Menus, functions
• Expertise with ERP implementation and Data Conversions
• Experience in designingOracle Interfaces
• Experience inOracle E-Business Suite 11i and R12 and Oracle Developer Suite
• Excellent Analytical skills to understand the business process and functionality, requirements and to translate them to system requirement specifications
• Experience in various phases of SDLC like Gathering Requirements, Analysis/Design, Development, Testing and deployment, Go-live and Post GO-live support
• Experience in preparing Test plans, Test Data and execution of Test cases to ensure application functionality meet the user requirements
• Experience in working onSQL Loader, UTL FILEoperations
• Well versed with UNIX Scripts and UNIX Shell Scripting
• Experience in handling Production cases and escalations
• Expertise in system integration testing, preparing design documents
• Ensured Project compliance to Quality and Standard implementation methodology – Drive QA processes for the project in the program, Participate in CMMI Level 5, Identify, communicate and implement opportunities for process/solution improvement; Establish CMMI process to control defects and improve customer satisfaction
• Have good experience in Onsite-offshore model execution of projects
• Excellent documentation and presentation skills, great verbal and written communication skills
• Analytical thinker, quick learner and proficient problem solver who envisions business and technical perspectives to develop workable solutions

Educational Qualifications:

• Master of Business Administration ( Operations Management), Confidential University
• Bachelor of Science (Computer Applications), Confidential University

Technical skills: :

Oracle Development Tools : Oracle Developer Suite

Tools: SQL, PLSQL, SQL Developer Oracle Apps

Modules: Oracle Payables, Oracle Receivables, Oracle General Ledger, Oracle Inventory, Oracle Order Management, Oracle Purchasing, AOL, Sys Admin, SABRIX

ERP Tools: Oracle R12, Oracle Reports 6i/9i/10g, Oracle Forms 6i

Database Environments: Oracle 10g, 9i

Script Languages: UNIX Shell scripting

Programming Languages: C, C++, HTML

Database Tools: TOAD 8.0/9.0, SQL*PLUS, SQL Developer, Data Loader, Putty, Workflow Builder

Operating systems: Windows 9x/2000/XP/NT/Vista, UNIX

Version Control tools & other tools: PVCS Tracker, VSS, Share Point, Remedy Tool, MS Office, Citrix

Web Development Tools: Macromedia Dreamweaver, Adobe Photoshop, Macromedia Flash, CSS

Professional Experience:

Client : Confidential Project Duration : Jun’10 to Mar’12 Location : Edison, NJ Technology & Modules : PL SQL, SQL, Oracle Payables, Oracle Receivables, SABRIX, Oracle 10g, Oracle Reports, UNIX Shell Scripting Type : Implementation

Role : Sr. PL/SQL Developer

This project deals with handling customizations around Tax calculations and integrating SABRIX with Oracle for a worldwide leader in networking.

Responsible for:

• Preparation of Technical Specifications
• Design, Development and testing of new RICE Objects
• Code review, Preparation of Unit Test plans and involved in User acceptance testing
• Responsible for migrations of AOL and other database objects to production instances

Contribution:

• Worked on PLSQL packages and various customizations involving UNIX shell scripting
• Designed various custom tables in Oracle 10g on the existing application
• Designed and Developed Oracle Reports (RDF) for customizing AP module
• Extensively involved in testing the customizations in Oracle account payables module
• Actively involved in testing the custom components
• Prepared the Technical design documents for the modules involved
• Build, test and deliver customizations
• Prepared the design document for customizations made in Account Payables module as part of knowledge transition

Client : Confidential

Role : Technical Lead / PLSQL Developer

This project deals with handling customizations around Tax Calculation and integration of SABRIX with Oracle for Cisco.

Responsibility as Technical lead

• Responsible for work allocation to the team (team size 5)
• Preparing and presenting weekly status report to the client
• Reviewing the technical specifications and the code changes
• Conducting Unit testing, reviewing test cases and test plans
• Guiding the junior resources on technical issues
• Responsible for day to day deliverables

Responsibility as Developer:

• Preparation of Technical Specifications
• Design, Development and testing of new RICE Objects
• Code review, Preparation of Unit Test plans and Participating in User acceptance testing
• Requirement Analysis, Collection of information from the client and co-ordinate withoffshore teamto accomplish the tasks

Contribution:

• Worked extensively on PLSQL cursors, Stored Procedures
• Worked on PLSQL packages and various customizations
• Designed global temp tables for developing custom components in Oracle 10g
• Designed various custom tables in Oracle 10g on the existing application
• Worked on UNIX Shell scripting to customize and support the implementation
• Designed and Developed Oracle Reports (RDF) for customizing AP module
• Solely involved in testing the customizations in Oracle account payables module
• Interacted with Client IT Team and business users for post Go-Live support activities
• Actively involved in testing the custom components
• Prepared the Technical design documents for the modules involved
• Build, test and deliver customizations
• Maintaining and publishing the status report for deliverables on daily basis

Role : Technical consultant / Module Lead

This project deals with implementing an end-to-end ERP solution, the Arrow ERP system is required to be integrated with several others standalone systems for data exchange. These interactions include data exchange between Arrow and its trading partners (both vendor and customer) as well as data exchange between Arrows Internal Systems.

Responsible for:

• Preparation of�Technical Specifications
• Coordinating with the onsite counterpart; understanding the requirements and customizing the components and to coordinate with the team in getting the deliverables on time
• Code review, Preparation of Unit Test plans and Participating in User acceptance testing
• Performance improvement process for the objects that are customized

Contribution:

• Designed and created staging tables for the inbound and outbound interfaces
• Worked extensively on PL SQL packages
• Worked extensively on stored procedures, functions, cursors
• Worked on SQL Loader for loading data into staging tables
• Worked extensively on performance tuning activities like analyzing the TKPROF, SQL TRACE
• Worked on data mapping for creating the inbound, outbound programs
• Developed�inbound and outbound interfaces in Oracle modules – Order Management, Purchasing
• Creating AOL concurrent programs and migrating�the same to other environments
• Understand Client Business process and preparing the technical design documents for the inbound and outbound interfaces
• Co-ordination with Onsite Interface Track lead
• Provide feasible solutions for the customization
• Co-ordinate between Onsite and Offshore Interface Teams
• Maintaining & publishing the status report of deliverables on weekly basis
• Design Technical design document in project

Client : Confidential Project Duration : Jul’06 to Jul’08 Technology & Modules : PL/SQL, SQL, Oracle 10g database, TOAD, Oracle R12, Oracle Extensions, Oracle Reports, Oracle Forms Type : Implementation

Role : Oracle PL SQL Developer / Technical Consultant

Responsible for:

• Preparation of Technical Specifications based on Functional Specification
• Coordinating with onsite counterpart, understand the requirement and deliver the code
• Code review, Preparation of Unit Test plans and Participating in User acceptance testing
• Performance improvement process for the objects

Contribution:

• Worked on PL SQL codeto submit the concurrent programs programmatically and test the process
• Worked extensively onPL SQL packages, stored procedures, functions, cursors and arrays
• Have extensive knowledge in creating global temp tables
• Worked on UNIX shell scripting which sends email to users with text output as an attachment
• Involved in end to end testing of the custom components
• Co-ordination with Onsite team for the deliverables
• Understand Client Business process and prepare the design documents and test plans
• Involved in integration testing

Client : Confidential Project Duration : Apr’06 to May’06 Technology & Modules : PL/SQL, SQL, TOAD, Oracle 9i, Oracle Payables, Oracle Receivables, Oracle 11i, Oracle Reports, Oracle forms, Oracle Interfaces Type : Support

Role : PL/SQL Developer

Responsible for:

• Requirements Gathering, Requirement Analysis and preparation of issues logs
• Fixing issues during User acceptance testing, Change requests
• Development of the objects on PLSQL
• Preparation of Technical Specifications based on Functional Specifications
• Code review, Preparation of Unit Test plans and Participating in User acceptance testing
• Performance improvement process for the objects

Contribution

• Working on�Oracle Custom Reports (RDF), PL SQL custom packages, stored procedures, cursors
• Understand the change requests and alter the SQL queries and tuning the same
• Testing the changes made in the existing custom components