SUMMARY

• 7 plus years of experience in IT Industry. Worked as oracle developer and oracle Apps technical Developer.
• Knowledge of analyzing, design and implementation of business applications in Oracle relational database management systems (Oracle RDBMS).
• Have experience working on Oracle Applications (11i/12i) in various modules (GL, AOL, OM, INV, AP, and AR).
• Expertise in Development/ Customizations/ Conversions/ Up - gradation/ Debugging/Integration of Oracle Applications.
• Worked in development, implementation and support phases of the project.
• Solid experience of creating and manipulating programming constructs like packages, stored procedures and functions, triggers.
• Experience in generating forms using triggers, stored procedures and functions for data validation.
• Developed various kinds of reports based on requirement. Worked on Oracle Reports 6i/9i/10g.
• Good knowledge of UNIX basic commands. Extensively used shell programs for calling pl/sql programs.
• Have experience in working with performance tuning of queries with Explain Plan, TKPROF and Indexing.
• Worked with utilities like SQL Loader, data pump utilities like Export/Import.
• Usage of advanced pl/sql topics like bulk collect, Ref cursors, partitioning, dynamic sql, UTL FILE.
• Have knowledge in relational data modeling, physical and logical data modeling and creating ER diagrams.
• Excellent analytical, problem-solving, communication and inter personal skills.

TECHNICAL SKILLS

RDBMS: Oracle 9i, 10g, 11g - SQL, PLSQL, SQL Loader, Data pump

ERP: Oracle Applications 11i/12i/R12 ( GL, AOL, AP, AR, OM, PO, INV )

Tools: SQL PLUS, SQL Developer, TOAD, Oracle forms and Reports, Discoverer (10g,11g).

Operating Systems: Unix, Linux, Windows 2003, Windows XP.

PROFESSIONAL EXPERIENCE

Confidential

Information Engineer

Responsibilities:

• Developed various reports using Oracle BI Discoverer and Oracle Reports.
• Developed complex queries for creating views according to the requirement of Reports.
• Analyzed the performance of views by examining explain plan.
• Modified procedures, packages, functions, views to obtain the required functionality.
• Developed shell scripts for executing reports in testing environment.
• Developed and modified Md.70 document for discoverer folders, views, packages and procedures.
• Worked on financial modules like GL, AP, AR, and FA.
• Confirms program operation by conducting tests; modifying program sequence and/or codes.
• Confirming reports to meet report standards as specified and doing modifications if any needed.
• Provides management with updates on project results and other project related issues.
• Participates in cross functional team meetings to develop and implement business solutions and optimize operations.

Environment: Oracle 11g, Oracle ERP R12, TOAD 11.1.2, SQL Loader, UNIX.

Confidential, Alpharetta, Georgia

Oracle Developer

Responsibilities:

• Involved in requirement gathering and development of the application.
• Created and maintained tables, views, procedures, packages and indexes.
• Used SQL loader to perform data loading into tables.
• Worked on performance tuning of queries using explain plan and tkprof.
• Developed complex SQL queries to fetch data from different tables using joins.
• Created Indexes and sequences for faster retrieval of the customer information and enhance the database performance.
• Extensively used cursors, REF cursors, user defined object types and records in PL/SQL programs.
• Used the advanced features of PL/SQL like collections, nested table and dynamic SQL.
• Developed and maintained UNIX Shell scripts to automate data loading process.
• Used the advanced features of PL/SQL like collections, nested table and dynamic SQL.
• Handled complex DB environment in QC.

Environment: Oracle 10g/11g, Windows XP, SQL*PLUS, TOAD 8.6, SVN, SQL Loader, Unix.

Confidential, Columbus, OH

Oracle Developer/Forms Developer

Responsibilities:

• Created and maintained Tables, views, procedures, functions, packages, DB triggers, and Indexes.
• Maintained the data integrity using integrity constraints and database triggers.
• Created Views and Synonyms for the database objects.
• Extensively used cursors, REF cursors, user defined object types and records in PL/SQL programs.
• Used SQl*Loader to perform data loading into database tables from external data files.
• Used the WITH clause to rewrite the Sql query for faster Performance.
• Designed the front end interface for the users using Forms 10g.
• Performed debugging in Oracle Forms using MESSAGE.
• Extensively used ‘vi’ editor in UNIX.
• Attended review meetings and walkthroughs to discuss the status of the project and for change requests.
• Worked with the team members in developing the Test Plan and Test cases for Unit testing for validation of the code.

Environment: Oracle 9i/10g, SQL, PLSQL Packages, Procedures, Functions and Triggers, TOAD, UNIX.

Confidential, Overland Park, Kansas

Oracle Applications Technical Developer

Responsibilities:

• Develop new extensions and customizing existing objects as per business requirements in Oracle EBS R12 system.
• Extensively used AOL and System Administrator modules for set up of various Concurrent programs, Request sets, Values sets and Descriptive flex fields.
• Developed custom PL/SQL conversion programs for loading PO Vendors using Oracle Standard Vendor.
• Developed custom UNIX shell script which is submitting concurrent program.
• Doing Root cause analysis and documenting enhancements and changes to existing objects.
• Delivered solutions designed by functional consultants.
• Developed custom PL/SQL conversion program for Item, Purchase Order and Oracle receipt.
• Performed Independent code review and Unit Testing to make sure coding standards are met, best practices and guidelines for coding applications are followed and the code is error free.
• Used Explain plan and TK PROF for Tuning the SQL statements. Generated session level trace and used the TKPROF utility to get the report for the trace file.
• Utilized SQL*Loader to perform bulk data loads into database tables from external data files.
• Wrote UNIX shell scripts to automate the daily process as per the business requirement.
• Developed reports using Reports 10g.

Environment: Oracle Applications12.0.6(OM, INV, AR,GL, PO, AOL) Oracle 10g, Reports 10g, Forms 10g, TOAD, Windows XP, UNIX.

Confidential, Atlanta GA

Oracle Applications Technical consultant

Responsibilities:

• Involved in SDLC gathering requirements from end users. Participated in system analysis and data modelling which included creating tables, views and synonyms.
• Developed Technical Design as per Business requirements which have defined in MD50.
• Customized Order, Line Workflow to meet the business requirement.
• Defined Conversion Strategy for millions of records.
• Developedand maintained packagesand procedures to load the Invoice, Purchase Order, requisition and general ledger Fact tables, Aggregate Tables fromall P2P tables.
• Developed workbooks using Discoverer to develop custom reports for business analysis.
• Customized existing forms to define system Profile Options, Descriptive and Key Flex fields.
• Used SQL Loader to load data into the Interface tables using flat files.
• Have performed various testing activities like Unit Testing, Integration-System Testing, Regression Testing, and User Acceptance Testing and ensured that the code is ideal.

Environment: Oracle 11g/10g, Oracle 11i/12R, UNIX, SQL, PL/SQL, SQL*PLUS, TOAD, Erwin, Business Objects XI Re2,3.1.

Confidential

Oracle Developer

Responsibilities:

• Created tables, synonyms, sequences, views, PL/SQL stored procedures and triggers.
• Enforced database integrity using primary keys and foreign keys.
• Created PL/SQL functions to facilitate business functions and calculations.
• Designed coding specification and documentation.
• Created public synonyms on the database links for easy reuse.
• Wrote complex SQL queries to generate views for the purpose of the administrative department.
• Monitored database performance using Explain plan and SQL trace.
• Managing tables and storage structures within a table.
• Created indexes for faster retrieval of data and better performance tuning.
• Generated crystal reports for billing information.
• Used various Joins for data retrieval from multiple tables according to the requirement.
• Managed and resolved design issues during development.
• Wrote UNIX Shell scripts according to the requirement.
• Improved query performance using better joins appropriately.

Environment: Oracle 9i, Red Hat Enterprise Linux 3, Crystal reports, Toad, SQL Plus, PL/SQL.