Experience Summary

• Oracle Certified Professional with Fifteen plus years of Oracle tools set experience in various applications.
• Eight plus years of ERP implementation, support and enhancement.
• Involved in Design and development of complex projects according to the business needs. Team Lead in managing the projects. Involved in the whole life cycle of the project.
• ERP implementation, support and enhancement. Strong Techno Functional knowledge with Oracle Financial Modules 12.0, 11.5.10.2, 11.5.8, 11.5.5 (AP, AR, FA, GL, Payroll, Purchasing, Order Management, Inventory,HRMS) and Oracle CRM 11i Customer Care Module. Involved in Preparation of Design Document using AIM Methodology.
• Knowledge of Oracle Apps Release 12 Architecture.
• Extensive knowledge on XML Publisher, Oracle Forms, Reports, Custom PLL, Data conversion, Data Warehousing, PL/SQL – Packages, Stored Procedures, Database Triggers, Pro C, Oracle Application Framework and Workflow development.
• Design, Development and Analyzing Business Requirements. Production Support & Enhancement for Oracle Financial Project.
• Skills of developing, deploying Forms & Reports on Oracle Web Application Server 9ias using Developer 9i.
• Administration of Business Views and Ad-hoc Query Reporting using Brio query tool and Oracle Discoverer.
• Have skills in Tuning Application and Sql Queries.
• Involved in Application and Requirement analysis, Process improvement and documentation, Preparation of Technical Design document, Troubleshooting Technical and Functional issues of Oracle Application.

Educational Qualification: Master\'s degree in Science (Mathematics)
Confidential University

Certification: Oracle Certified Application Developer,
Oracle Internet Application Developer Release 6.0/6i

• Introduction to Oracle: SQL and PL/SQL.
• Develop PL/SQL Program Units.
• Developer 6.0/6i Forms 6i Part One
• Developer 6.0/6i Forms 6i Part Two
• Developer 6.0/6i Reports 6i

Technical Skills

Operating Systems: WINDOWS XP, NT 4.0, WINDOWS 95/3.11, Linux, HP-UNIX, Sun Solaris, IBM-AIX.

Languages:Java, Java Script, XML, Web services, Oracle PL/SQL, SQL * PLUS, PRO*C, C

ERP:ORACLE FINANCIALS 12, 11.5.10.2, 11.5.8, 11.5.3,10.7 (Inventory, Order Management, Purchasing, AP, AR, GL, FA, Payroll, Workflow, SYSADMIN, AOL, ), ORACLE CRM 11i

GUI:Developer 9i, 6i(Forms 6i), Developer 2000  (Forms 9i/6i/5.0/4.5/3.0/2.3), VB 3.0, PB 3.0

RDBMS:Oracle 10g, 9i, 8i, 8.X, 7.X, 6.X

Report Writers:XML Publisher, Developer 6i(Reports 6i), Reports 2.5/3.0, Discoverer 4i, Hyperion Brio

Application Server (Middle Tier):Oracle Application Server 4.0.8, IAS 1.0.2, Developer Server 6.0, Tuxedo

Data Modeling:Designor 2000, Designer 6i, Erwin 3.5.2, Designer 6.0

Others:TOAD, Oracle Jinitiator 1.1.7.11, ASP, Jdeveloper, XML, SQL * LOADER, RCS, Subversion, PVCS, Truechange Version Control, Web methods 5.0

Project Profile
Duration: September 2004 – Present
Project: Oracle Application
Client: Confidential, USA.
Project Description:

TheProject involves Implementation of Oracle ERP EBS modules. Involved in design and development of Interface programs for importing Payables, Purchasing, General Ledger, Fixed Asset, AR and customization of Oracle application.

Responsibilities:

• Provided analysis, design, installation, and implementation of Oracle EBS modules in SDLC phases.
• Involved in Functional setup, Functional and technical design for conversions, interfaces, and reports. Leader ship role in managing projects and assigning responsibilities to the team.
• Involved in the design of the following activities of Transfer to General Ledger, Month End Closing activities, 1099 Tax Reporting process.
• Developed Payables Invoice Interface, Auto Invoice, Customer interface, PO Interface, Requisition Interface, General Ledger Interface, Internet Expense and Vendor Interface and JSA, LD Interface, Oracle Financials Procure to Pay.
• Developed Custom Reports using Oracle Report and XML Publisher, AP Check Printing program, 1099 Tax Reporting, UTF8 character set conversion project.
• Designed and developed FileNet Document Management process for Invoices, General Ledger, Purchase Orders and Vendors.
• Involved in Forms, Reports, FSG, Workflow, Oracle Application Framework customization, and Personalization.
• Data Import using SQL*Loader, PL/SQL & Data validation using PL/SQL Programs. Selfservice and Web Interface installation.
• External Vendor System integration with Oracle Application using Web Methods.

Environment: Oracle EBS 12, 11.5.10.2(AP, Purchasing, AR, GL, FA, Payroll, Internet Expense, iSupplier, Order Management, HRMS), Developer 6i, Oracle 10g, PL/SQL, XML Publisher, IBM-Aix, Linux, OAF, AME, Workflow, Visual SourceSafe, RCS, Hyperion Brio query, Microsoft Power Point., Web methods 7.1.2, Jdeveloper.

Duration: Jan 2004 – September 2004
Project: Oracle Application
Confidential, USA.Project Description: 
TheProject involves writing Interface Programs using SQL* Loader for importing General Ledger, Fixed Asset, Payables & Purchase Order and customization of Oracle General Ledger, Oracle Payables, Fixed Asset, Oracle Purchasing modules using Forms 6i & Reports 6i.

Responsibilities:

• Involved in Data Conversion from Legacy to Oracle Application.
• Developed General Ledger Interface, Vendor Interface, Purchasing Document Open Interface, Mass Addition Interface
• Developed Custom Reports, PL/SQL Procedures as per the Business Requirement.
• Developed Bespoke Forms for Validating Interface Tables and customization of reports.
• Data Import using SQL*Loader, PL/SQL & Data validation using PL/SQL Programs.

Environment: Oracle APPS 11.5.8(AP, Purchasing, GL, FA, Payroll), Developer 6i, Oracle 8i, PL/SQL, HP-Unix, PVCS Tracker, PVCS Version Manager, Discoverer 4i, Designer 6.0, Microsoft Power Point.

Duration: Feb 2003 – Dec 2003Project: Oracle Application
Client: Confidential

Involved in ERP implementation, Custom Development, Support & Enhancement

Responsibilities:

• Data migration from Legacy to Oracle Application.
• Developed Reports for Verification of Conversion Programs and error detection.
• Customer Import From Legacy to Oracle Application
• Purchase Order Import from Legacy to Oracle Application.
• Journal Import from Legacy to General Ledger.
• Developed Custom Reports, PL/SQL Procedures as per the Business Requirement.
• Developed Bespoke Forms for Validating Interface Tables and customization of reports.

Environment: Oracle APPS 11.5.8(AP, PO, GL, AR, FA), Developer 6i, Oracle 8i, PL/SQL, Sun-Solaris, PVCS Tracker, ASP, PVCS Version Manager, Workflow 2.6, Discoverer 4i, Designer 6.0, Microsoft Power Point.

Duration: August 2002 – Febraury 2003 Project: Oracle Application, Client: Confidential.Project Description:
The CRB Disclosure system was developed for the Home Office of Great Britain. The Project involves registering organizations into the CRB System, Issuing Disclosure Certificates to the applicants (Future Employees) for the registered organizations. System Involves in Printing Disclosure certificates to Education Department & Health Department. The System was integrated with Oracle CRM.
Involved in Customization of Oracle CRM Customer Care Module.

Responsibilities

• Involved in Design & Development for the Be-spoke Application and as a Team Lead Position.
• Design and Development of forms, reports for bespoke application, Rehabilitation of Offenders Act (ROA). Restricted Information Database.
• Administrated & Developed Business Views, Ad-hoc Query reports using Oracle Discoverer.

Environment: Oracle CRM 11i, Developer 6i, Oracle 8i, PL/SQL, HP-Unix, PVCS Tracker, PVCS Version Manager, Java 1.2, Designer 6.0, Oracle Workflow 2.5, Discoverer 3i/4i.

Duration: April 2001 – June 2002 Project: Oracle Financial Application Client: Confidential, California, USA.

The Oracle Financial application has been Set up & Implemented according to the Client requirement.

Responsibilities:

• Journal Import from Legacy to General Ledger.
• Purchase Order import from Legacy to Oracle Purchasing.
• Import Assets using Mass Addition Interface.
• Developed Custom Forms, Reports & PL/SQL Stored Procedures in Oracle Payables, Oracle General Ledger & Oracle Assets according to the business requirements.

Environment: Oracle Applications 11i(AP,GL,FA, PO), Oracle 8i, PL/SQL, SQLPLUS, Sun Solaris, Developer 6i, Discoverer 3i, Designer 6i, SQL * Loader.

Duration: Jun 2000 – Mar 2001
Project: PRWORA Project, Friend of Court Child Support Information System, 
Client : Confidential.Project Description:

The Child Support System has been developed on Three-tier Architecture on Oracle Internet Application Server. The system involves the following modules: Financials, Enforcement, Case Initiation, Financial reporting. Project involves Deploying Forms on the Oracle Internet Web Application Server.

Responsibilities:

• Involved in Analysis, Design, Development and Taking Business requirements as a Team Lead Position.
• Developed Batch Programs for Financial Report & Federal Reports scheduling.
• Involved in Data Conversion and Oracle Back end Development.
• Developed inquiry Screens & Ad-hoc Reports for Financial Reporting using Oracle Reports and Discoverer.

Environment: Oracle 8.1.7.2, Developer 6.0.8.11, Developer Server 6.0.8, Oracle Internet Application Server 9 IAS, PL/SQL 8.1.4, SQL PLUS 8.1.4, C, 
Pro C, HP-Unix, Oracle Designer 6.0, Discoverer 3.1, PVCS Version Control,