SUMMARY

• Over 7 years of IT experience in all phases of Software Development Life Cycle.
• Has more than 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, wif extensive exposure in development of custom interfaces, Conversions, APIs, building control interfaces, dealing wif 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
• Has good noledge and experience using Oracle Workflow builder
• Experience in creating RTF templates using XML Publisher
• Has good noledge on OAF
• Co-coordinating and halping the Business user in executing the 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 wif individuals at all levels. Able to interact effectively wif other members of the Business Engineering, Quality Assurance and other teams involved wif the 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 the BOM Open Interface. Activities involved creation of Loader File, porting Bill Of Materials, Components and Reference Designators into the interface tables using SQL*Loader and tan using BOM Open Interface to port the data into the base tables.
• Worked on the Payables Open Interface. Activities involved creation of Loader File, Importing Invoices into the AP INVOICES INTERFACEand AP INVOICE LINES INTERFACE tables using SQL*Loader and tan using Payables Open Interface to import data into the actual tables.
• Created and registered a new Form using TEMPLATE.FMB.
• Involved in the development of interfaces/Conversions to import the data from legacy system into Oracle application base tables.
• Created the test cases and involved in testing and reviewing the objects.
• Worked on UTL FILE Package and SQL*LOADER for the interfaces and conversions.
• Customized the Requisition Approval Workflow according to the Business Requirements in changing the Notification, Approval process.
• Worked on service requests and virtual tickets.
• Customized Oracle standard reports like AP and AR changed the 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 wif clients to gather requirements and design needs.
• Interacted wif 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 the corresponding KFF, DFF Structures as per the functional design documents.
• Has 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 the 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 the 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 the 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 the Reports/Dashboards by comparing the SQL Output on the Data warehouse to the values in the Reports/Dashboards, documented the 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 the Auto Lockbox API process to automate AR receipts.
• Worked on Fixed Assets Mass Additions to load the assets automatically.
• Developed several adhoc reports for the Fixed Assets depreciation and reconciliation reports for the 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 the shop floor move transactions occurring in the 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.
• Gathered requirements to develop folders, views in Discoverer admin as per the 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 the conversion of the data to the custom new schema.
• Created the materialized views - Partitioned very large database tables using Hash partitioning to improve performance.
• Involved in the Data conversion and migration from the legacy system to the new Core Data Warehouse system.
• Creating Primary/Surrogate keys on the 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 the 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 the system performance.
• Bulk Collect was used to improve the performance of the program.
• Used UTL FILE to read the 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 the 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 the project.
• Configuring the 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 the 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 the old tables into the new tables using Sql*Loader
• Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Optimized existing queries for better performance and less impact on database.
• Used cursors and bulk collect extensively.
• Worked on Table Partition.
• Involved in the design and implementation of the process for loading the monthly loads coming from flat files in to staging tables in the Oracle Data base using SQL* Loader.
• Developed Technical Design documents according to Functional documents.
• Involved wif 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.