SUMMARY

• Over 7 years of IT experience in all phases of Software Development Life Cycle.
• Have more TEMPthan 5+ years of Techno Functional experience in Oracle Applications 11i and R12.
• Extensive experience in all phases of full life - cycle Oracle Applications implementation i.e. Requirements Gathering, Analysis, Application Configuration, Development, Testing, Implementation, Upgrade, Post Go-Live Support, Production support, User Training and Documentation.
• Diversified technical expertise on Oracle Applications 11i and R12, with extensive exposure in development of custom interfaces, Conversions, APIs, building control interfaces, dealing with Application Object Library(AOL), customizing forms, reports and workflows.
• Strong noledge in Oracle Receivables (AR), Oracle Payables (AP), Oracle General Ledger (GL), Order Management/Order Entry (OM), Oracle Inventory (INV), Oracle Purchasing (PO), Bill of Materials (BOM), Human resource management system (HRMS), Application Object Library (AOL), System Administration modules of Oracle Applications.
• Extensively worked on various business flows such as Order to Cash (O2C), Procure to Pay (P2P)
• Prepared Functional (MD50), Technical (MD70) and Conversion (CV40/60) documents using AIM methodology.
• Very strong development experience in Reports, Interfaces, conversions, and extension (RICE) components in Oracle Applications
• Have good noledge and experience using Oracle Workflow builder
• Experience in creating RTF templates using XML Publisher
• Have good noledge on OAF
• Co-coordinating and halping teh Business user in executing teh Business scenario in Oracle
• Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment.
• Excellent Organizational, leadership, team building and project management capabilities.
• Excellent analytical, problem solving, communication and inter-personal skills to manage and interact with individuals at all levels. Able to interact TEMPeffectively with other members of teh Business Engineering, Quality Assurance and other teams involved with teh System Development Life cycle.

TECHNICAL SKILLS

ERP: Applications (11.5.10.2,11.5.10, 11.5.9, 11.0.5), R12

E-Business suite Modules: GL, AP, AR, PO, INV,OM,HRMS

RDBMS: Oracle11g,10g, 9i, 8.x,Sql Server

Operating Systems: Windows 9X/2K/XP,Unix,Linux,Solaris

Languages: SQL, PL/SQL,HTML,Java Script, C, C++, Java

Tools: Forms 6i/9i/10g, Reports 6i/9i/10g, SQL*Loader, Oracle Workflow Builder, TOAD and SQL*Plus, XML Publisher

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Oracle Techno-Functional Consultant

Responsibilities:

• Developed Customization of Reports, Interfaces, and conversions as per client requirements.
• Involved in Implementation of Procure to pay (P2P) cycle which includes Items and Catalogs, Requisitions/Quotations, Purchase Orders, Receiving, Inventory, and processing Invoices.
• Involved in development of reports based on business requirements and registered them in Oracle applications.
• Defined value sets, concurrent programs, request sets, registering reports and PL/SQL Procedures, and Packages.
• Implemented teh BOM Open Interface. Activities involved creation of Loader File, porting Bill Of Materials, Components and Reference Designators into teh interface tables using SQL*Loader and tan using BOM Open Interface to port teh data into teh base tables.
• Worked on teh Payables Open Interface. Activities involved creation of Loader File, Importing Invoices into teh AP INVOICES INTERFACEand AP INVOICE LINES INTERFACE tables using SQL*Loader and tan using Payables Open Interface to import data into teh actual tables.
• Created and registered a new Form using TEMPLATE.FMB.
• Involved in teh development of interfaces/Conversions to import teh data from legacy system into Oracle application base tables.
• Created teh test cases and involved in testing and reviewing teh objects.
• Worked on UTL FILE Package and SQL*LOADER for teh interfaces and conversions.
• Customized teh Requisition Approval Workflow according to teh Business Requirements in changing teh Notification, Approval process.
• Worked on service requests and virtual tickets.
• Customized Oracle standard reports like AP and AR changed teh output format to XML and created new templates for XML Publisher to display in PDF.

Environment: Oracle Applications R12, INV, PO, AP, GL, FA, BOM, Oracle 11g, UNIX, XML Publisher, Workflow 2.6, SQL, PL/SQL, Oracle 10g Application server, SQL Developer.

Confidential, Rockville, MD

Oracle Application Consultant

Responsibilities:

• Extensively worked with clients to gather requirements and design needs.
• Interacted with Oracle support team, business team and other vendors to identity and fix issues resulted by upgrade.
• Tested integrity of customization to ensure no overrides due to R12 upgrade.
• Prepared Conversion Strategy and Conversion Data Mapping Documents for Finance and Oracle HRMS modules using AIM Methodology.
• Involved in user meetings for Gap Analysis and legacy field mapping.
• Designed Technical specs for inbound interfaces, outbound interfaces, workflows and extensions of Oracle Financial and HRMS Applications.
• Involved into creating KFF, DFF and required value sets and inserted required data into teh corresponding KFF, DFF Structures as per teh functional design documents.
• Have developed FND Users creation, Assign Responsibilities to FND users’ concurrent programs. Also automated this process during instance cloning process.
• Configured AME rules for SSHR, iRecruitment, iExpenses, AP, PO, and Requisitions to route notifications and approval process as per teh business requirements.
• Developed and tested customizations in PO Requisition Approval workflow, PO Requisitions Account Generator in iProcurement and PO Account Generator Workflows in Purchasing to meet teh business requirements.
• Involved in AP Invoices Conversion, Customer Conversion, and Vendor Conversion, AR Auto Invoice Conversion and GL balances Conversion.
• Done Entire Employee Conversion that includes employee information, address, phones, assignment information, contacts, salary, taxes, payment methods and Element entries using Oracle HR/Payroll APIs.
• Customized several oracle seeded reports like Payments Register, Incomplete Invoices Report, Reserve Ledger Report etc. as per clients requirement.
• Developed several XML publisher reports like PNC ACH, Void Check etc. for Oracle Financial modules during Go Live and Production support.
• Developed several Oracle Finance and HRMS Inbound, Outbound Interfaces using ODI to send/receive carrier files to/from third party providers like Washington Gas, Speed Light Camera etc.
• Done several Form personalization’s like duplicate invoices, hide/show buttons, validate GL dates, run cover page reports etc.
• Worked on PO Liquidation process for yearend process.
• Raised several Oracle SRs to resolve critical issues.
• Developed Periodic/Event based Alerts as per teh Business Requirement.
• Developed Dashboard pages like Invoices Details by GL account, Invoice Payment Details by Division/GL, Invoice Dues, Expenditure Tracking, Revenue Tracking, Requisitions by Fund/CC/Account, RQ Approval Details, RQ Statistics, PO Summary, POs by Fund/CC/Account, FA Journal Reserve by Category etc.
• Build test cases and tested teh Reports/Dashboards by comparing teh SQL Output on teh Data warehouse to teh values in teh Reports/Dashboards, documented teh test results.

Environment: Oracle Apps Implementation Release R12, 11i (11.5.10.02 ), PO, INV, OM, AP, AR, GL, HRMS, SQL, PL-SQL, Forms 6i, Reports 6i, BI Publisher, TOAD, Putty, WinSCP and Solaris.

Confidential, Portland, OR

Oracle Apps Consultant

Responsibilities:

• Worked on major Conversions like GL Balances, Vendors, Purchase Orders, Invoices and Assets etc.
• Involved in Cross-Validation Rules and Enabled Key and Descriptive Flex fields for different modules.
• Involved in teh Auto Lockbox API process to automate AR receipts.
• Worked on Fixed Assets Mass Additions to load teh assets automatically.
• Developed several adhoc reports for teh Fixed Assets depreciation and reconciliation reports for teh month end as well as yearend closing activities.
• Performed conversion of their BOM from legacy system into Oracle BOM.
• Developed PL/SQL Procedures and functions for WIP Move Transactions interface, to bring in all teh shop floor move transactions occurring in teh legacy System.
• Designed and developed various workflow customizations Account Generator, Requisition Approval, Create PO Document, PO approval workflows.
• Developed several FSG reports, including balance sheet and income statements.
• Worked on reports (XML Publisher and .rdf) such as Trail Balance reports, Invoice Aging reports, Asset Depreciation reports, PO Remaining Balance report etc.
• Gatheird requirements to develop folders, views in Discoverer admin as per teh client requirements. Developed several AP/AR/GL/FA/PO discoverer desktop reports per business requirement like Workflow Audit Reports, Invoice Overdue, AR Aging Report, Pending/Rejected Expenses, and FA Retirements/Transfers Reports etc.
• Done several forms personalizations like hide tax id, disable bank account number, run cover page reports etc.
• Performance tuning of Reports, Interfaces through tkprof and Explain Plan

Environment: Oracle Apps 11i, GL, AP, AR, CE, PO, BOM, WIP, Oracle 10g/9i, Oracle 10g Application Server, TOAD.

Confidential, Portland, OR

Sr Pl/Sql Developer

Responsibilities:

• Created database objects such as tables, views, synonyms, indexes, sequences and database links as well as custom packages tailored to business requirements.
• Worked on advanced PL/SQL constructs like Oracle supplied packages, Objects, Associative arrays, Records, Types, Materialized views etc.
• Created Procedures, Functions, Packages and Database Triggers.
• Developed SQL *Loader scripts, Conversion scripts for teh conversion of teh data to teh custom new schema.
• Created teh materialized views - Partitioned very large database tables using Hash partitioning to improve performance.
• Involved in teh Data conversion and migration from teh legacy system to teh new Core Data Warehouse system.
• Creating Primary/Surrogate keys on teh dimension tables.
• Developing ETL scripts for loading dimension tables and fact tables from transactional tables.
• Ran batch jobs for loading database tables from flat files using SQL*Loader.
• Performed validations on teh imported data from legacy system before loading into interface tables using PL/SQL packages.
• Involved in Migration of data from 8i to 10g while up gradation.
• Developed and Tuned SQL, PL/SQL and stored procedures.
• Performance tuned SQL queries using parallel query and indexes hints.
• Used TKPROF and EXPLAIN PLAN extensively.
• Created indexes to improve teh system performance.
• Bulk Collect was used to improve teh performance of teh program.
• Used UTL FILE to read teh data and to generate a file that TEMPhas to be sent to USERS.
• Developed test plans and test cases for user acceptance and unit testing.
• Wrote client-customized UNIX shell scripts to upload new data into tables for testing new customizations.
• Used AWK to manipulate data files before loading them to database.
• Developed PERL scripts to modify and parse data files as per teh business needs.
• Debugged and fixed production fallouts due to code glitches.
• Extensive documentation of each module for user level and system level maintenance.

Environment: Oracle 10g / 8i, SQL, PL/SQL, SQL * Plus, Oracle Data warehouse, Data Mart, Oracle Bi/XML Publisher 5.6.2, Advanced Queuing/Streams, TOAD, SQL*Loader, import/export, UNIX (AIX 5.3), Perl, XML, Windows XP professional

Confidential, Jersey City, NJ

Pl/Sql Developer

Responsibilities:

• Involved in analysis, Design, Development phases of teh project.
• Configuring teh data sources for database and data warehouses.
• Formatted, cleaned, Summarized, aggregated and transformed data into data warehouse.
• Participated in system analysis, data modeling and database designing which included creating tables, views, indexes, synonyms, triggers, procedures and packages.
• Created custom partition tables for reporting.
• Worked on performance tuning and used Explain Plan, TKPROF for tuning teh queries.
• External table was used to read flat files and populate database tables.
• Used Refcursors and Collections for accessing complex data resulted from joining of large number of tables.
• Wrote complex SQL scripts using joins, sub queries and correlated sub queries.
• Moved data from teh old tables into teh new tables using Sql*Loader
• Used Exception Handling extensively for teh ease of debugging and displaying teh error messages in teh application.
• Optimized existing queries for better performance and less impact on database.
• Used cursors and bulk collect extensively.
• Worked on Table Partition.
• Involved in teh design and implementation of teh process for loading teh monthly loads coming from flat files in to staging tables in teh Oracle Data base using SQL* Loader.
• Developed Technical Design documents according to Functional documents.
• Involved with QA team and reviewing their test cases and recommending changes if required

Environment: Oracle 10g / 9i, SQL, PL/SQL, SQL * Plus, Oracle Data warehouse, Data Mart, TOAD, SQL*Loader, import/export, UNIX (SunOS 5.10), Windows XP professional, HTML

Confidential

Software Developer

Responsibilities:

• Wrote test plan and test cases for web based project.
• Performed functional, UI, navigation, usability, integration, and Regression testing.
• Wrote SQL queries for Backend testing and data validation.
• Found and reported bugs.

Environment: Oracle 9i, Unix, Asp.Net, HTML, JavaScript, CSS, SQL server.