SUMMARY

• 10 years of IT experience as Senior Oracle Developer in PL/SQL, SQL, Oracle e Business Suite, Oracle Forms, Oracle Reports, Discoverer reports, UNIX shell scripting, Data Warehouse and ETL process.
• Strong experience as Senior Oracle PL/SQL Developer in various development and maintenance projects. Experience in analysis, design, development, testing and implementation of PL/SQL components.
• Extensive experience in development of many complex PL/SQL components including packages, procedures, functions, triggers, views and materialized views.
• Strong experience in Performance tuning of SQL, PL/SQL and reports using EXPLAIN PLAN, SQL TRACE, TKPROF, hints, index and Autotrace.
• Expertise in using Oracle API’s, Dynamic SQL, Records, PL/SQL tables, cursors, bulk binding and exception handling.
• Experience in creating PL/SQL packages to send emails from Oracle applications using API’s like UTL SMTP and UTL FILE.
• Experience in creation/modification of tables, temporary tables, views, materialized views, triggers, constraints and indexes.
• Experience in writing test plans, test strategies and test case execution.
• Good knowledge in Manufacturing, Insurance and Banking domains.
• Understanding and experience with Waterfall, Agile project development methodologies, participated in SCRUM meetings.
• Good knowledge in data warehousing concepts and ETL. Hands on experience in using SQL *Loader as an ETL tool to load data from flat files to Oracle staging tables.
• Strong experience in various modules of Oracle e - Business Suite Applications (R12, 11i) including requirements analysis, design, development, implementation and support.
• Hands on experience in Oracle applications modules Order management (OM), Advanced Pricing (QP), Oracle Purchasing (PUR), iProcurement (PROC), Cost management (CST), Inventory (INV), Warehouse management (WMS), Shipping Execution (WSH) and Core HR.
• Proficient in developing and implementing RICE components (Reports, Interfaces, Conversions, Extensions).
• Hands on experience in data conversion, migration, report generation and developing interfaces within several oracle modules.
• Good knowledge and experience in Oracle reports and Oracle forms.
• Expertise in creation, modification and testing of discoverer reports using Oracle Discoverer Administrator, Viewer, Desktop and Discoverer Plus.
• Hands on experience in UNIX Shell scripting for file validation, file transfer using FTP and invoke programs/jobs.
• Created Technical specification documents, design documents and test plans.
• Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills. Team-oriented, technically motivated and creative.
• Effectively lead the team from Offshore.
• Strong inclination for finishing job before project deadline. Flexible and versatile to adapt to any new environment and work on any project.

TECHNICAL SKILLS

ERP: Oracle e-Business suite R12, 11iModules OM, QP, PUR, PROC, CST, INV, WMS, WSH, Core HR

Database: Oracle 9i, 10g, 11i

Operating system: Windows, UNIX

Programming Languages: SQL, PL/SQL, Shell scripting

Tools: SQL *loader, SQL *plus, TOAD,Oracle Forms 6i, 11g, Oracle Reports 6i, 10g Oracle Discoverer

Version control tools: SVN, VSS

PROFESSIONAL EXPERIENCE

ETL/Oracle PL/SQL Developer

Confidential, NJ

Responsibilities:

• Participate in User meetings and work closely with Business analysts to understand and analyze the requirements.
• Create technical specification documents based on the requirements.
• Responsible for loading data from source systems into target tables using SQL *loader.
• Create database objects like tables, views, materialized views, procedures and packages using Toad, PL/SQL Developer and SQL* plus.
• Partition the tables and materialized views to enhance the performance.
• Extensively use bulk collection in PL/SQL objects for improving the performing.
• Write UNIX shell scripts to process files like renaming the file, extracting data from file and removing junk characters from the file before loading them into base tables.
• Created PL/SQL records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
• Develop Oracle PL/SQL stored procedures, functions and packages.
• Write test plans, test the PL/SQL components and prepare test results.

Environment: Oracle 11g, TOAD 8.6, UNIX Shell scripting, SQL, PL/SQL.

ETL / Oracle PL/SQL Developer

Confidential, CA

Responsibilities:

• Created Oracle PL/SQL design documents based on the functional specifications.
• Developed Oracle PL/SQL stored procedures, functions and packages to load the data from staging tables into the data warehouse tables.
• Extensively used SQL *Loader to load the data from various systems into the oracle database tables.
• Created tables, views, triggers and materialized views.
• Performance tuning of PL/SQL packages using TKPROF, explain plan, indexes and hints.
• Created and scheduled UNIX shell scripts to execute the programs and ETL processes.

Environment: Oracle 11g, TOAD, UNIX, SQL, PL/SQL.

Senior Developer

Confidential

Responsibilities:

• Manage the daily support activities, job monitoring and handling enhancements in Supply Chain Management.
• Requirement analysis, design, test planning, development, testing and post migration support of enhancements (PL/SQL packages, forms and reports).
• Write technical design documents for conversions, interfaces and reports.
• Query optimization and performance tuning of the PL/SQL packages using TKPROF, explain plan, indexes and hints.
• Root cause analysis and issue resolution for support tickets within the stipulated SLA.
• Create service requests and follow up with Oracle to troubleshoot issues.
• Proficient knowledge in Procure to Pay (P2P), Order to Cash (O2C) life cycles and supply chain business flows to fix the issues/bugs.
• Perform various Oracle applications system administrator activities like defining concurrent program, executable, value sets, profiles, users, menus and lookups.
• Mentor and guide the team.

Environment: Oracle E-Business Suite 11i, SQL, PL/SQL, UNIX, Oracle forms 11g, Oracle reports 10g, Oracle Discoverer.

Senior Developer

Confidential

Responsibilities:

• Lead a 10 member team in development of technical components (PL/SQL packages).
• Requirements gathering, analysis, design, documentation, development and testing of PL/SQL components.
• PL/SQL query optimization and tuning to improve the performance of the programs using HINT and indexes.
• Review of design, coding, and test results.
• Maintained the documents and pl/sql codes in the version control tool SVN.
• Mentor and guide the team throughout the life cycle of the project.

Environment: PL/SQL, SQL *Loader, UNIX.

Senior Developer

Confidential

Responsibilities:

• Daily support of the system including job monitoring, problem analysis, debugging, solution identification and fixing.
• Handling enhancements and small project requests - Including requirement analysis, design, development and testing.
• Creating new PL/SQL packages or procedures and changing the existing PL/SQL components as per the business requirement.
• Performance tuning of critical jobs and programs using Explain plan, SQL trace, TKPROF and hints.
• Monthly setup of Organizations, business groups, sub inventories, shipping networks, shipping methods and calendars in production and development environment within the stipulated SLA.

Environment: Oracle e-Business Suite Application 11i, UNIX, PL/SQL, and Oracle Discoverer.

Developer

Confidential

Responsibilities:

• Requirements analysis, design, tests planning, development and testing of PL/SQL components like packages, procedures, functions and triggers.
• Design, develop and test changes to Oracle reports.
• Daily support of the HR system providing bug fixes, improvements and HR data setup and HR activities.
• Import data from legacy system to Oracle Applications using Oracle Interfaces, SQL Loader and customized PL/SQL packages calling Oracle API’s
• Enhancements/ bug fixes of PL/SQL packages, triggers and functions.
• Minor enhancements of Universe in Business Objects.

Environment: Oracle Applications 11.5.7 and 11.5.8 (HRMS, SSHR), PL/SQL, UNIX, Forms 6i, Reports 6i and Business Objects XI.

Developer

Confidential

Responsibilities:

• Requirements analysis, documentation, benefits setup, unit testing and system testing.
• Configuration of Benefits and Events in the AON HR system as per client’s requirement for Annual Enrollments on test and production environments. Customized benefits setup of more than 30 clients.
• Develop maps and schemas (MS BizTalk Server) for the data exchange (Inbound/outbound) between the client and the carriers.
• Coding and testing of complex SQL queries to implement all the functionalities needed for reports.

Environment: Custom built AON HR benefits system, MS SQL, MS Biztalk Editor and MS Biztalk Mapper 2006.