SUMMARY

• Over 8 years of IT experience in analysis, design and development of data warehousing and oracle related applications.
• Highly experienced in data modeling (Entity - Relationship and Dimensional Model) and logical and physical database design.
• Expertise in using Oracle Forms 6i/10g, Reports 6i/10g Discoverer 4i/10g, PL/SQL, SQL, BI/XML Publisher 5.6.2/5.6.3.
• Extensive experience in designing and working with Oracle 9i/8i/10g and writing SQL queries, PL/SQL Procedures, Functions, Packages, Database Triggers, Exception Handlers, Ref Cursors, Database Objects.
• Expertise in Design and Development of interfaces and conversion programs using API'S to integrate Oracle Applications modules to import data from Legacy systems and external systems into Oracle Applications using PL/SQL, SQL*Loader, UTL FILE.
• Extensive experience in creating new reports and customization of existing Reports, Forms and PL/SQL Procedures in Oracle Applications.
• Proficient in Oracle Tools and Utilities such as SQL*Loader, UTL File, Advanced Queue, Scheduler and TOAD.
• Experience in Tuning applications using tools like Explain plan, SQL*Trace and TKPROF for high efficiency.
• Exposure to the entire process of Software Development Life Cycle.
• Expertise in Testing phase planning, preparation and execution.
• Experience in using MS SQL Server, SQL*Plus, Procedures/Functions and Performance tuning.
• Experienced in UNIX shell scripting and data modeling using Erwin.
• Excellent Interpersonal and Communication skills, coupled with strong technical and problem solving capabilities.

TECHNICAL SKILLS

ERP/CRM: Oracle Applications R12/11i(Financials, Manufacturing & Supply chain Module)

Applications: Oracle Manufacturing OM, PO, INV, WSH, Oracle Financials GL, AP, AR, AOL, System Administrator.

Application Tools: Oracle Reports 10g/6i/4i, Work Flow Builder 2.6.4, Oracle Discoverer 10g/4i, XML/BI Publisher 5.6.3/5.6.2 , Oracle Forms 11g/10g6i/4.5, OAF, Developer Suite 10g, JDeveloper

Database Tools: TOAD, SQL* Loader, SQL* Plus, SQL* Developer, Oracle Advanced Queue

Languages: SQL, PL/SQL, XML, C

Web Technologies: HTML, XML

RDBMS: Oracle 11g/10g/9i/8i/7.x

Operating System: Windows NT/XP/2000/98, UNIX, Linux

PROFESSIONAL EXPERIENCE

Confidential, Lonestar TX

Oracle PL/SQL Developer

Responsibilities:

• Involved in requirement gathering and analysis.
• Involved in the logical and physical database design and developed the logical dimensional models using ERWIN 4.0.
• Extensively developed complex PL/SQL packages.
• Seasoned in optimizing Query performance using explain plan, SQL Trace and TKPROF utility.
• Developed complex PL/SQL packages to perform data integration from plant to HQ by transforming plant data as per client requirement and sending to HQ as messages.
• Utilized Oracle Advanced Queuing (AQ) to send messages from Lonestar plant to headquarters using DBMS AQ package to enqueue and dequeue the messages.
• Responsible for scheduling these messages to be sent at a set frequency daily using DBMS SCHEDULER.
• Troubleshot the existing PL/SQL procedures, functions, triggers.
• Analyzed tables and indexes for performance tuning.
• Developed scripts for checking Oracle errors in alert logs and trace files for every 15minutes.
• Wrote stored procedures, Functions, Packages etc.
• Registering newly created Forms with Oracle Applications.
• Responsible for developing new reports in Oracle Reports for Finance Department.
• Involved in Registration/Migration of concurrent programs, executables, Creation of Responsibilities, request Groups, Menus, value sets, Request Sets, Forms, Functions in System Administration & AOL.
• Created lexical parameters, bind parameters, formula columns, summary columns and place holder columns in reports.
• Extensively used triggers like Report triggers, Layout triggers, Data triggers in reports.
• Worked on Report Triggers (Before Parameter Form Report, After Parameter Form Report, Before Report Trigger, Between Pages Trigger, After Report Trigger).
• Created Value sets for report parameters and registered in application.
• Designing, Developing and customizing Forms, Reports, Packages, Procedures.
• Created several PL/SQL packages, stored procedures and functions.
• Writing several PL/SQL subprograms (stored procedures, functions and packages) using PL/SQL records, PL/SQL tables and global variables and also using IN and OUT parameters with TYPE, ROWTYPE, PL/SQL tables and PL/SQL records.
• Used CUSTOM.PLL extensively to modify the functionality provided by standard forms according to client requirements and created custom forms using zoom functionality.
• Performed unit testing, system integration testing.
• Developed Unix Shell scripts to automate repetitive database processes and maintained shell scripts.
• Involved in Production Support to resolve production issues in a timely and efficient manner.

Environment: Oracle 11g, PL/SQL, SQL *Plus, Toad 9.7.2, Erwin 4.0, UNIX Shell Scripts, SQL Loader, Oracle reports 10g, Oracle Forms 10g.

Confidential, Waukegan IL

Oracle PL/SQL Developer

Responsibilities:

• Created new database objects like tables, views, indexes and database links.
• Generated SQL scripts to install, create and drop database objects including tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Created the materialized views and also created the partitioning tables.
• Created several PL/SQL packages, stored procedures and functions.
• Written many database triggers for automaticallly updating the tables.
• Built the report using Reports 10g and integrated it with the application (based on the descriptive flex fields) to solve the client’s reporting needs.
• Built custom forms using Oracle Forms 10g to fulfill the business requirements of the client.
• Customized existing forms to add search criteria on descriptive flex fields.
• Developed forms using ZOOM functionality that pops up appropriate form based on the item context. Modified CUSTOM.PLL to activate zoom.
• Built custom forms using TEMPLATE.FMB to fulfill the business requirements.
• Proficient with the System administrator responsibility, which included customizing menus, adding new concurrent requests, request sets, registering the automation scripts as concurrent programs and created scheduling process that invokes the script periodically.
• Customized Inactive Item Report using Report 10g.
• Modified and created new concurrent programs as well as executable files when new reports were created.
• Participated in quality assurance testing, code reviews, and new system integration/implementation planning.
• Unit tested all the SQL scripts and PL/SQL packages.
• Used SQL Loader to import data from large flat files to Oracle tables.
• Loaded Data from huge Oracle Database tables to flat files.
• Used TKPROF, SQL Trace, Explain Plan to speed up the SQL Statements.
• Analyzed tables and indexes for performance tuning.

Environment: Oracle 11g, SQL, PL/SQL, SQL Loader, Windows 7, TOAD 9.7.2, Oracle Forms 10g, Oracle Reports 10g.

Confidential, Washington D.C

Oracle PL/SQL Developer

Responsibilities:

• Involved in the design, data modeling, development and testing phases of various projects and enhancements.
• Extensively worked in writing SQL Queries (Sub queries and Join conditions, correlated sub queries),
• Wrote Stored Procedures, Functions, Packages in SQL*Plus.
• Developed custom reports using Report 6i and also customized standard reports.
• Development and Testing of advanced SQL and dynamic PL/SQL code.
• Written many database triggers for automatically updating the tables.
• Worked in creation of Sequences for automatic generation of voucher numbers.
• Worked in creation of Views and Synonyms for hiding of actual Tables and Queries.
• Created indexes on tables and Optimizing Stored procedure queries.
• Worked on Query Optimization Techniques for complex SQL Statements. Used Performance Monitor and Explain Plan for performance tuning to enhance the performance of databases.
• Developed Unix Shell scripts to automate repetitive database processes and maintained shell scripts.

Environment: Oracle 10g, SQL, PL/SQL, SQL Loader, Windows XP, UNIX shell scripts, TOAD, Erwin 4.0, Oracle Reports 6i.

Confidential, Brooklyn, NY

Oracle PL/SQL Developer

Responsibilities:

• Involved in all the stages of Software Development life cycle (SDLC) - design, development, analysis, testing and deployment of application.
• Requirement Analysis, coordinating with customers to understand business issues related with the system.
• Generated SQL and PL/SQL scripts to install, create and drop database objects including tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Wrote stored procedures, Functions, Packages etc. in SQL*Plus.
• Created several PL/SQL stored procedures and functions for the data warehouse.
• Created Database and backup and recovery techniques and Query level optimization.
• Used TKPROF and SQL Trace, Explain Plan to Speed up the SQL Statements.
• Participated in quality assurance testing, code reviews, and new system integration/implementation planning.
• Wrote UNIX shell scripts to automate the backup of the database.
• Interacted and coordinated with technical and non-technical clients while providing 24/7 production support.

Environment: Oracle 10g, UNIX Shell Scripts, SQL*Loader, TOAD, SQL*PLUS, Windows XP.

Confidential, Boca Raton, Florida

Oracle Database Developer

Responsibilities:

• Involved in analysis, requirements gathering, functional/technical specification, development, deploying and testing.
• Developed packages, procedures and functions in PL/SQL for data loading and data processing.
• Created simple, complex joins, calculated items and conditions.
• Analyzed the tables and indexes using SQL and PL/SQL scripts.
• Monitored existing code and doing performance tuning if necessary.
• Wrote database triggers for audit and data validation.
• Creation of users, roles, schemas, tables, indexes etc.
• Planning of logical database and physical layout.
• Wrote procedures and functions using PL/SQL.
• Writing SQL*Loader scripts and UNIX scripts to format, load data from text files to database.
• Development of UNIX scripts for File formats archives, transfers and procedure execution.
• Development of Views for users.
• Investigation of production problems and bug fixing.
• Maintenance and enhancements to the application.
• On call production support.

Environment: Oracle 9i, SQL, PL/SQL, Unix Shell Scripts, Windows NT.

Confidential

Oracle Applications Developer

Responsibilities:

• Used custom SQL*loader program to load the invoices from other accounting systems to payables staging tables.
• Involved in checking the validity and accuracy of the legacy data by writing PL/SQL packages.
• Developed several Procedures and Database Triggers as per Business requirement.
• Imported Items from legacy system into Oracle Inventory base tables using the Standard Item Interface program.
• Developed Item conversion program for assigning Items to Item category set and Categories.
• Created loader file, porting invoices into the AP INVOICES INTERFACE and AP INVOICE LINES INTERFACE tables using SQL*Loader and then using Payables Open Interface to import the data into the actual tables.
• Frequently worked with defining accounting and descriptive flex fields, writing validations to custom forms.
• Worked on Auto Invoice (AR) Conversion Program to validate, load credit memos, debit memos and invoices from legacy system.
• Created several PL/SQL packages, stored procedures and functions.
• Writing several PL/SQL subprograms (stored procedures, functions and packages) using PL/SQL records, PL/SQL tables and global variables and also using IN and OUT parameters with TYPE, ROWTYPE, PL/SQL tables and PL/SQL records.
• Developed MD70 Technical Design Documents based on business requirements to include technical details for the project such as input data format, table mapping, flow chart, concurrent program names and order of execution.

Environment: Oracle Applications11i, PL/SQL, SQL*Plus, SQL Loader, Oracle database version 9i/10g, Reports 6i.