SUMMARY

• Around 8 years of experience as PL/SQL Developer in Analysis, Design, Development, Testing, Implementation of Oracle 11g/10g/9i/8i.
• Hands on experience in AOL, Oracle D2K, Discoverer, PL/SQL, SQL, SQL*PLUS, SQL Developer, TOAD, Oracle Forms 9i/10g,Oracle Reports 9i/10g,Oracle 11g/10g/9i/8i.
• Extensive knowledge of software development life cycle (SDLC) methodologies, such as Waterfall and Agile Methodology leveraging multiple frameworks.
• Strong knowledge and use of SDLC (Software Development Life Cycle) methodologies, standards, and procedures with experience in promoting database changes from development through production environments.
• Development and Customization of RICE components - Reports, Interfaces, Conversions and extensions.
• Extensive experience in Creating Front End Forms from Scratch, template.
• Good Knowledge on UNIX and Shell Scripting.
• CreatedPerl Scriptsfor invoking SQL scripts.
• Experience with Oracle Supplied Packages such asDBMS SQL, DBMS JOBandUTL FILE.
• Worked extensively onRef Cursor, External TablesandCollections.
• Experience in SQLperformance tuningusing Cost-Based Optimization (CBO).
• Experience in using SQL*Loader and UTL FILE packages for data conversion and interfaces.
• Extensively experienced in Oracle PL/SQL Development i.e. Stored Procedures, Packages, Functions & Triggers.
• Proficient in writing PL/SQL Scripts and other related tools and techniques on Oracle Database.
• Created and maintained Database Objects like Tables, Views, Indexes, Constraints, Sequence, Synonyms, Database link, Roles and privileges.
• Effectively made use ofTable Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write, Exception Handling
• Automation, Scheduling and monitoring of jobs with scheduler Autosys.
• Extensive involvement in development and Performance tuning of SQL and PL/SQL using HINTS, BULK-COLLECT, Global Temporary tables, Explain Plan, Tkprof, Table Partitioning, Indexes and Join Optimization.
• Experience inData warehouse concepts, ETL.
• Knowledge of Oracle Applications R12 GL, Inventory, OM, AP, AR, PO modules.
• Expertise in developing outbound and inbound interfaces.
• Good Knowledge on advanced PL/SQL constructs like Oracle supplied packages, Nested tables, Varrays, Records, Bulk collect, FORALL and Types.
• Experience in Extraction, Transformation and Loading (ETL) of large volume of data into Data Warehouse
• Experience withData Analysis, Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modelinganddesign techniques.
• Excellent in team collaboration, quick adaptation and problem solving with good communication skills.
• Strong Analytical, Problem solving and communication skills.
• Efficient in working under pressure with focus on meeting deadlines on top priority. Comfortable working in a team or as an individual when required.

TECHNICAL SKILLS

Operating Systems: UNIX, Windows

Database: Oracle 9i/10g/11g

Tools: SQL developer, TOAD, SQL * Loader, SQL*Plus, Oracle Forms and Reports 10g/9i/6i,Oracle D2K, XML Publisher Reports, BI Publisher

ERP: Oracle Applications R12, 11i.

Languages: SQL, PL/SQL, HTML, CSS,C and shell scripting

Packages: MS Office

PROFESSIONAL EXPERIENCE

Confidential, Plano, TX

Oracle PL/SQL Developer

Responsibilities:

• Involved in business process analysis and requirement gathering for new customization, report development.
• Resolving performance issue by decreasing cost of multiple queries by indexing multiple columns using the hints to perform well.
• Developed oracle applications using Application programming Interfaces (API) for inserting and updating the data in oracle applications.
• Used SQL*Loader and UTL FILE packages for data conversion and interfaces.
• Written PL/SQL Stored Procedures, Functions, Packages and Triggers to implement business rules into the application.
• Developing PL/SQL scripts to obtain the required functionality.
• Involved inOracle development (Data Base) by creating OraclePL/SQL Functions, StoreProcedures, Triggers, Packages, Recordsand Collections.
• Extensively worked on writing the SQL queries using joins, Order by and Group by.
• CreatedRecords, Tables, Objects, Collections, Views,Materialized views, Exceptionsand Global temporary tables(Nested Tables and Varrays), and performed Error Handling.
• Developed SQL Loader Scripts to load the data from comma separated file into the oracle table
• Written complex SQL queries with complexity using Inner/Outer joins, Union All, Intersect & Minus set operators.
• Extensively used DBMS Scheduler package in order to schedule the refreshment of the Materialized Views on a periodic fashion.
• Designed and developed several views like Materialized View for data retrieval for the reports.
• Created a package to generate the Trace file for the Materialized View Groups using DBMS SUPPORT Package.
• Work with QA team to verify/review the test scenarios and test cases
• Designed and developed Oracle Forms & Reports using Forms11g/10g and Reports11g/10g, including Forms based on stored procedures
• Designing and developing Customer Workbench Form to enter and maintain the Customer Address as well as Contact Information of Customer
• Created and customized reports using XML Publisher/BI Publisher in AR
• Developed the SQL queries to fetch the data from the Oracle ERP standard tables of AR module
• Design and development of the logical and physical data models, business rules and data mapping for the Enterprise Data Warehouse system.
• Extensively used TOAD tool to increase the productivity and application code quality.

Environment: Oracle 11g, UNIX, Oracle Applications R 12.1.3 (AR, GL, AP), Reports 10g/11g, Forms 10g/11g, Discoverer 10g, TOAD, SQL*Loader, PL/SQL, SQL* Plus and XML publisher, Work Flow Builder 2.6.3.

Confidential, Atlanta, GA

Oracle PL/SQL Developer

Responsibilities:

• Developed new PL/SQL programs to load and pull the respective data for those Loans eligible to be processed based on various business criteria.
• Developed new Packages to load eligible Vendor Order Request into the Target table based on various business criteria using the MERGE Statement.
• Involved in writing DDL and DML operations.
• Designed Data Modeling, Design Specifications and to analyzedependencies.
• Developed PLSQL Packages, Procedures and Functions for AR Customer Data Conversion in loading the data from Custom Tables to Oracle Base Tables using TCA APIs
• Runbatch jobsfor loading database tables fromFlat Files using SQL*Loader
• Extensively used TOAD, SQL PLUS, SQL Developer and PLSQL developer for programming purposes.
• Developed Custom PLSQL Package in Loading Sub ledger Journal Data from Stage tables to GL Interface Table.
• Developed an interface to load external data from legacy system using SQL* Loader into AP INVOICES INTERFACE and AP INVOICE LINES INTERFACE Interface Tables.
• Developed PLSQL Packages in Doing Outbound Data transfer from AR Transaction Tables based on the Business Requirements.
• UsedBulk Collectionsforbetter performanceand easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Expertise in using UTL FILE Package for inbound and outbound data from legacy system to Oracle EBS Base tables.
• Developed PLSQL Package to load Open Purchase Order details from Legacy System to Oracle PO Tables using Open Interface.
• Developed PL/SQL scripts to load order data from external system to OM interface tables and OE Base tables and OE HEADERS IFACE ALL, OE LINES IFACE ALL.
• Involved in using the Performance Tuning methods like TKPROF, Explain plan, Trace and creating Indexes.
• Involved in importing Customers from legacy system to Oracle base tables using SQL * Loader and API’s.
• Created PL/SQL objects such as tables, views, synonyms, indexes, sequences, triggers, Exceptionsand database links as well custom packages tailored to business requirements.
• Designing and developing Sales Order Header Zoom Form to enter and maintain the Contact Details of the Ordered Person as well as Order Details.
• Extensively worked on using Custom.pll in developing new forms from scratch.
• Designed and developed Custom Reports to keep track of Items with in the inventory using Oracle Reports Builder 9i for INV.
• Created the Shell and Perl Scripts to automate the execution of the PL/SQL subprograms and to move the data to store in historical folders.
• Developed the reports using SQL’s and automated through UNIX shell scripts.

Environment: Oracle Applications 11.5.10, R 12.1.3 (AR,GL,OM, INV, AP, PO,BOM,WSH), Windows, Unix, Oracle 11g, Reports 10g, Forms 10g, Discoverer 10g, TOAD, SQL*Loader, PL/SQL, SQL* Plus and XML publisher, BI Publisher Work Flow Builder 2.6.3.,Shell Scripting.

Confidential, Newport Beach, CA

Oracle PL/SQL Developer

Responsibilities:

• Developed PL/SQL procedures to validate the data and insert the validate data into Oracle Standard interface tables.
• Created and maintained Database Objects like Tables, Views, Indexes, Constraints, Sequence, Synonyms, Database link, Roles and privileges.
• Performed PLSQL tuning using BULK COLLECTIONS, Optimizer hints, Histograms, TKPROF, Explain Plan, PL /SQL Profiling.
• Created Custom Triggers, Stored Procedures, Packages and SQL Scripts, user defined Exceptions.
• Developed PL/SQL procedures that extracted data from a data warehouse for policy reporting.
• Used Materialized View and refresh Process to provide data to downstream Application.
• Developed Oracle PL/SQL code based on requests raised by changes in business logic, norms and standards
• Implemented utilities that use DBMS scheduling to scan relational database tables for updates Confidential specified intervals.
• Developed PL/SQL stored procedures & functions using REF cursors & collections.
• Created Pseudo code documents for writing stored procedures.
• Implemented business logic with Oracle Stored Procedures, Functions and Triggers using PL/SQL.
• Involved in writing CTL files (control files) for SQL*Loader to load the policy data from Flat files in to oracle tables.
• Used Database trigger for making history of insertion, updating, deletion and all kind of Audit.
• Extensively used oracle packages, Stored procedures, sequences, ref-cursors, dynamic queries, UTL files, bulk inserts, exception handling, DB Links etc
• Used bulk collections for better performance and easy retrieval of data, being a part of performance tuning of the procedures and packages.
• SQL*Loader was used to load the data from the flat files to database tables.
• Developed batch jobs, shell scripts to automate file transfers, data cleansing, loading and final data processing.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Performed the unit testing for procedures, functions and packages.
• Importing and exporting the Tables, Users and Schemas.
• Responsible in importing AP Supplier Payment invoices from legacy system to oracle data base using payables open interface program.
• Modified and debugged several PL/SQL programs for performance tuning using techniques like EXPLAIN PLAN, TKPROF and DBMS PROFILER
• Used PUTTY to login into UNIX box and run the shell scripts to copy the files to desired folder
• Developed customized reports using XML Publisher & Discoverer.
• Developed the Shell Scripts and Used the Autosys for scheduling Jobs.

Environment: Oracle Applications R 12.1.3 (AR,GL, AP, PO, INV, OM, Shipping), Unix, Oracle 10g, Reports 10g, Forms 10g, Discoverer 10g, TOAD, SQL*Loader, PL/SQL, SQL* Plus, XML publisher, Shell Scripting

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Developed PL/SQL stored procedures, packages, and triggers for data load and transformation, and data extraction.
• Build the business case for a proposed solution to address the customer’s business needs.
• Created Perl Scripts and Autosys job to automate the monthly report generation process
• Extensively used sub queries and joins while writing stored procedures.
• Involved in extensive coding using Oracle PL/SQL
• Used Merge statement for incremental loads and WITH statement.
• Created packages, procedures, functions, triggers, Exceptions.
• Used UTL File Packages to Load data from Excel Sheet to Oracle tables.
• Developed Forms and Reports as per the client requirement.
• Designed and Developed Forms 6i and Reports 6i by using Forms Builder and Reports Builder.
• Created PL/SQL Stored Procedures, Functions, Triggers and Packages for implementing business logic.
• Developed ER Diagrams, Data flow diagrams based on the requirement using ERWIN.
• Extensively used Cursors, User-defined Object types, Records, and Tables in PL/SQL Programming.
• Coding for the Interface programs to extract data into flat file and uploading of data files to the media application.
• Fine tuning the SQL Queries to improve the speed of program execution.
• Coordinated with users to ensure that the User Acceptance Testing is done successfully.
• Created Shell scripts to automate the loading of data from Text files to Oracle tables.
• Ensured the programs, scripts, procedures fully tested to ensure bug free performance.
• Involved in customization of standard Oracle reports in AR, AP and GL as per client requirements using Oracle Reports.
• Registering Concurrent Program and Forms. Supporting the Issues from various customizations (forms, reports, and interfaces) during the test cycles on priority basis.
• Performance tuning of long running jobs processing billions of data and cut down the run time by 40%.
• Overseeing project implementation and process changes.
• Developed test plans and test cases based on high-level and detailed designs.
• Fixing Bugs in Forms and Reports previously designed.

Environment: Oracle E-Business Suite 11i (AP, AR, GL), SQL, PL/SQL, Oracle 9i, Oracle Forms 6i & Reports 6i, TOAD, Developer 2000, Shell Scripting, ERWIN.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Data Conversion from Flat files to Oracle using Oracle SQL* Loader.
• Involved in performance fine-tuning of the queries/reports using PL/SQL and SQL Plus
• Creation and modification of various SQL and PL/SQL scripts.
• Developed DDL Scripts for generating Tables, Views, and Functions etc.
• Developed Views, PL/SQL procedures, functions, packages and Triggers.
• Developed Error-Handling package using PL/SQL tables to handle user-defined errors.
• Accessed remote databases using DB-Links.
• Also debugged the application with Confidential most accuracy and in least time.
• Involved in developing, testing and troubleshooting SQL Queries.
• Used Cursors, Exception Handling, Throwing Exceptions, and Nested Loops.

Environment: Oracle Applications 11.5.8, Discoverer, TOAD, Oracle 9i, Oracle Developer 2000(Forms 6i and Reports 6i), PL/SQL, SQL Developer.