SUMMARY

• Over 8 years of experience in Oracle technologies, primarily in SQL, PL/SQL development.
• Proficient in Oracle 10g/9i/8i, PL/SQL, SQL and ability to work with UNIX shell and Perl scripting.
• Good experience in technical aspects of Oracle E - Business suite (Oracle Applications)
• Proficient in PL/SQL programming- Creating stored procedures, functions, triggers, packages, cursors, ref cursors, collections and user defined types.
• Extensively used PL/SQL, Built in Oracle Packages, stored procedures, functions, triggers, cursors, Ref Cursors.
• Worked with Oracle Analytical Functions, Aggregate functions, native SQL, Exception Handling, Materialized views and views for processing data, enforcing referential integrity and needed business rules.
• Experience in Data Migration, SQL Loader.
• Expertise in Creating SQL Loader Scripts to load data from flat files into database and exporting data to flat files using UTL FILE package.
• Good exposure in tuning of procedures, packages, SQL.
• Expertise in performance Tuning- Tuning of SQL queries and complex procedures to improve performance & decrease response time utilizing TkProf, Explain Plan and Hints.
• Good understanding of normalization and de-normalization concepts of oracle.
• Creation of values sets, concurrent programs, request sets, functions, menus, responsibilities and request groups in oracle applications.
• Developing reports through concurrent programs and XML Publisher in oracle applications.
• Experience in UNIX Shell Scripting, Perl Scripting.
• Excellent analytical and problem solving skills and can work independently.
• Capable of working on multiple assignments in parallel.
• Excellent Communication skills and responsible team player.
• Quick learner with ability to master new concepts and applications.
• Involvement in all the design, development and testing phases of SDLC.

TECHNICAL SKILLS

Operating Systems: Windows XP/ Windows 7, Solaris 10, Linux

Programming languages: Oracle PLSQL, SQL, Java

Script Languages: UNIX shell scripting, Perl scripting, Java Scripting

Tools: /Software products: PL/SQL Developer, PUTTY, Oracle forms and reports, Oracle Workflow builder 2.6, J Developer 10g, MS Office 2003/2013

Database: Oracle 11g, 10g, 9i, 8i

ERP Suites: Oracle Applications 11i

Web Technologies: HTML, JSP

PROFESSIONAL EXPERIENCE

Confidential, Rochester, NY

Oracle PL/SQL developer

Responsibilities:

• Worked on many projects and enhancements related to the marketing and sales processes.
• Requirement analysis and understanding
• Created design documentation
• Built robust processes considering all the scenarios with excellent exception handling.
• Created complex PL/SQL packages, procedures, triggers and functions to meet the business requirements.
• Used oracle collections and bulk load concepts.
• Used advanced queues to establish integration with other systems
• Used advances oracle concepts of analytical, aggregate functions and native sql.
• Used SQL loader and UTL FILE packages of oracle to load the data from flat files into database.
• Used SPOOL and UTL FILE packages of extracting the data from database to flat files.
• Performance improvements by tuning PL/SQL code and SQL using the tools like explain plan and TKProfs.
• Test case preparation, regression and integration testing.
• Deployment support

Environment: PL/SQL, SQL, Oracle 10g, Oracle 11g, PUTTY, UNIX scripting, Perl scripting, MS Visual Source Safe 6.0, Tortoise SVN

Confidential

Oracle PL/SQL developer

Responsibilities:

• Requirement analysis and understanding
• Design documentation
• Create complex PL/SQL packages, procedures, triggers and functions to meet the business requirements.
• Create an interface to provide the data to adobe LiveCycle for the letter generation in pdf
• Test case preparation, regression and integration testing.
• Deployment support

Environment: PL/SQL, SQL, Oracle 9i, PL/SQL Developer, Adobe LiveCycle

Confidential

Oracle PL/SQL developer

Responsibilities:

• Requirement analysis and understanding
• Design documentation
• Design and develop oracle work flows
• Create complex PL/SQL packages, procedures, triggers and functions to meet the business requirements.
• Design and develop web pages using Java and JSPs.
• Integrate the workflows and the database code.
• Test case preparation, regression and integration testing.
• Deployment support

Environment: PL/SQL, SQL, Oracle 9i, PL/SQL Developer, Oracle E-Business Suite 11i, Oracle workflow builder 4.5, Java, JSPs, Java scripting, JDeveloper 10g

Confidential

Oracle PL/SQL developer

Responsibilities:

• Requirement analysis and understanding
• Design documentation
• Design and develop oracle work flows
• Create complex PL/SQL packages, procedures, triggers and functions to meet the business requirements.
• Integrate the workflows and the database code.
• Test case preparation, regression and integration testing.
• Deployment support

Environment: PL/SQL, SQL, Oracle 9i, PL/SQL Developer, Oracle E-Business Suite 11i, Oracle workflow builder 4.5

Confidential

Oracle Apps technical consultant

Responsibilities:

• Requirement analysis and understanding
• Design documentation
• Design and develop custom Oracle Forms and Reports
• Create values sets, concurrent programs, request sets, functions, menus, responsibilities and request groups in oracle applications.
• Creation of pay elements, links for compensation and payroll
• Migrate data from legacy system using APIs and SQL loader
• Develop the reports through concurrent requests and XML publisher
• Create complex PL/SQL packages, procedures, triggers and functions to meet the business rules.
• Used PL/SQL Collections and bulk collections.
• Test case preparation, regression and integration testing.
• Deployment support

Environment: PL/SQL, SQL, Oracle 9i, PL/SQL Developer, Oracle E-Business Suite 11i, Oracle forms and reports, XML publisher 5.5, MS Visual Source Safe 6.0

Confidential

Oracle PL/SQL developer

Responsibilities:

• Understanding the business rules and requirements.
• Create design documentation for the process.
• Create complex PL/SQL packages, procedures, triggers and functions to meet the business rules.
• Used PL/SQL Collections and bulk collections.
• Create tables, views, indexes and synonyms.
• Test case preparation, regression and integration testing.
• Deployment support

Environment: PL/SQL, SQL, Oracle 8i, PL/SQL Developer, MS Visual Source Safe 6.0

Confidential

Oracle developer

Responsibilities:

• Understanding the business rules and requirements.
• Create design documentation for the process.
• Create complex PL/SQL packages, procedures, triggers and functions to meet the business rules.
• Used PL/SQL Collections and bulk collections.
• Create tables, views, indexes and synonyms.
• Develop user interfaces for the business users using oracle forms and reports.
• Test case preparation, regression and integration testing.
• Deployment support

Environment: PL/SQL, SQL, Oracle 8i, PL/SQL Developer, Oracle forms and reports 5i, MS Visual Source Safe 6.0