SUMMARY

• Over 8 years of IT experience in developing cost effective solutions as Technical Consultant using Oracle Applications and related technologies Including Implementations, Upgrades, Data Conversions, Interfaces, and Customizations.
• Successfully completed three full life cycle implementations using oracle applications 12.1.3/12.0.6/11.5.10
• Did the Upgrade of oracle applications from 11.5.8 to 11.5.10
• Good working Experience in Oracle Financials (GL, AP, AR, FA, CE), PO (Oracle Purchasing), OM (Order Management/Advanced Pricing), Manufacturing (INV, WIP, BOM), CRM, HRMS, Payroll, Oracle Time and Labor (OTL), Advanced Benefits (OAB), Install Base, Service Contracts and AOL (Application Object Library).
• Extensive experience in using SQL, PL/SQL, Developer 2000/6i/10g, SQL Loader, Discoverer/4i/10g, Workflow 2.6, Oracle 10g/9i/8i/8/7.x, UNIX, Linux, and Shell Scripts and Oracle Applications (Financials, Manufacturing and Sales & Distribution modules).
• Expertise in Procure to Pay and Order to cash business flows.
• Extensive experience identifying product gaps coordinated with development team by creating TAR/SR and obtained one - off fixes. Managed and monitored TAR’s for several SEV1 issues.
• Have extensive experience in Customization of Oracle Application modules, which involved developing the Forms 4.5/6i/10g, Reports 2.5/6i/10g.
• Expert in developing OA Framework based UI pages using JDeveloper, developing XML Publisher/BI Publisher reports and their integration.
• Experience in set-up, configuration, and functionality checks.
• Strong knowledge of Application Object Library (AOL) i.e. in defining users, menus, responsibilities, printer set-ups and maintaining concurrent programs. Defined Custom Applications, which includes new Menus, Request Groups and Responsibilities using Application Developer and System Administrator responsibilities
• Implemented and Customized ceded Oracle Workflows and strong knowledge of PO workflows.
• Experience in building Forms, generating Reports and registering them as concurrent programs in Oracle applications using AOL.
• Written Interface programs for importing data from feeder systems to Oracle using SQL*Loader, PL/SQL.
• Extensively worked on AIM documents like MD050, MD070 and MD120
• Excellent communication skills, team player, quick learner and self-motivated.

TECHNICAL SKILLS

Oracle Applications: General Ledger (GL), Accounts Payables (AP), Accounts Receivables (AR), Fixed Assets (FA), Order Management (OM), Purchasing (PO), Cash Management (CM), Inventory (INV), Work in Process (WIP), Bills of material (BOM), Human Resources (HR), Application Object Library (AOL)

Oracle Tools: Reports 6i/10g, Forms 6i/10g, Discoverer 4i/10g, Developer 2000/6i/9i, Oracle 8i/9i/10g, JDeveloper, Workflow Builder

Languages: C, C++, JAVA, HTML, XML, XSLT

Databases: Oracle 10g/9i/8i

Database Tools: TOAD, SQL*PLUS, PL/SQL, SQL*LOADER

Scripting Languages: UNIX shell scripting

Version Control: PVCS, VSTS, MKS

Operating Systems: UNIX, HPUX, Solaris, Linux, Windows NT/2000

PROFESSIONAL EXPERIENCE

Confidential, Wauwatosa, Milwaukee

Oracle Apps Sr Consultant

Responsibilities:

• Wrote Technical MD70 design documents and Conversion Mapping Documents for various interfaces.
• Developed interfaces for AP, AR external Mainframe system to transfer the payments, AR transactions related data into oracle applications.
• Designed, documented and developed staging tables, conversion routines, Custom PL/SQL API’s for converting Open AP Invoices, Suppliers, Supplier Sites, Supplier Contacts, Customers using TCA, Open AR Invoices, Open Purchase Open Requisition from legacy system (Mainframe) to Oracle Applications.
• Designed and developed Asset Conversion by running Mass Additions Concurrent Program to transfer the data from interface to base tables in Fixed Assets (FA).
• Designed, documented and developed Bank Reconciliation interface to Oracle Cash management Interface.
• Customized the Po Requisition Account Generator Workflow based on the Business Requirement
• Did Analysis and fixed Accounting issues using Account Reconciliation Reports - Verification of GL Balances report in regard with Fixed Assets, Payables and Receivables. Fixed the Reconciliation reports with lot of analysis using write offs.
• Designed and developed staging tables, conversion routines, custom PL/SQL API to load Items, Item Categories, and Item Revisions.
• Customized the Oracle Purchase Order form using Forms Personalization.
• Designed and developed new Form using TEMPLATE.fmb for Purchase Returns irrespective of Purchase Order Number.
• Developed various Custom reports including preliminary & post payment register reports.
• Developed GL Summary, Income Statement Summary reports, Statement of Cash Flows, Consolidated Expense Report using FSG and ADI.
• Remittance/check addenda report Development.
• Involved in development of Discoverer reports like PA account information report, AR aging report etc.
• Customized XML publisher report for AR invoice in the client specified layout.
• Used Bursting technique to email the XML publisher output file
• Worked with Administrative and Desktop Edition of Oracle Discoverer 10g
• Personalized JSP pagers for I-Procurement.
• Creating responsibilities, users, request sets, value sets in Oracle applications using AOL, System Administrator, and UNIX shell scripts.
• Created SR/TAR in metalink, got fixes from oracle support and applied patches with coordination of Apps DBA for Bug fixing.
• Developed an UNIX shell script, which gets the files from Wells Fargo Bank Server

Environment: Oracle Applications R12 (12.1.3), AP, AR, GL, CE, FA, OM, Iprocurement, Oracle 10g, PL/SQL, SQL*Plus, SQL*Loader, TOAD, reports builder, forms builder, JDeveloper, UNIX, Solaris, PVCS, Rational Clear Quest.

Confidential, Austin, TX

Oracle Apps Developer

Responsibilities:

• Wrote CV40, MD50, MD70 documents, design and develop conversion routines, staging tables, PL/SQL API’s for Purchase Order, PO Requisitions, and Receipts
• Wrote CV40, MD50, MD70 Documents, developed conversion routines, staging tables, PL/SQL API’s for converting in HRMS for Employee, Employee Assignments, Jobs.
• Extensively worked on Oracle Cash management Bank Statement Interface.
• Analyzed and fixed issues uncovered during various testing phases (CRP/SIT/UAT cycles).
• Customized AP, PO, GL Oracle Reports like Returns report, Purchase Orders received not invoiced-Product; Purchase Orders received not invoiced-Non-Product, Check Register report, Receipt Balancing report, Material distribution report by Product line, Vendor exposure report
• Customized reports in General ledger (GL) GL Audit report, GL Review report and GL Exception report Using XML Publisher/BI Publisher
• Payroll conversion, payroll consolidation, Open Enrollment on Advanced Benefits, Oracle Time and Labor, and iRecruitment projects
• Analyzing, and modifying programming systems including encoding, testing, debugging, and installing to support Oracle eBusiness Suite, iRecruitment, Payroll, Time and Labor, and Advanced Benefits.
• Customized the Oracle Inventory, Invoice WorkBench Forms using Forms Personalization.
• Worked on creating application mode End User Layer, building business areas, and building discoverer workbooks, ad-hoc reports, parameterized reports using BI Discoverer 10g.
• Defined Attributes, Conditions, Rules, Approval Groups AME to implement the line based approval for Purchase Requisition Approvals using the Position Hierarchy.
• Did the setups for Approval Groups and Approval Assignments in Purchasing
• Customized the Inter-company Inventory Material transfer where the material cost should point the transaction cost rather than the Unit Selling Price
• Customized the Payments Form using TEMPLATE.fmb.
• Did personalization of Receipts forms using Oracle provided Personalization functionality as per user requirement.
• Experience in extending self-service applications using OA Framework
• Customized PO Account Generator Workflow based on the Business Requirement
• Provided daily productions Support

Environment: Oracle Applications R12i (12.0.6), GL, AP, AR, FA, PO, PA, Oracle 10g, PL/SQL, SQL*Plus, SQL*Loader, TOAD, Reports Builder, Forms Builder, Workflow Builder.

Confidential, Washington, DC

Oracle Apps Technical Consultant

Responsibilities:

• Design and developed an interface between Bank of America and (AR) Oracle Receivables and Customer, Customer Sites, Cash Receipts, AR Invoice.
• Wrote Functional (MD50), Technical (MD70) and Conversion Mapping document (CV40) for importing Legacy Purchase Orders into Oracle Purchasing, Legacy (AP)Payable Invoices into Oracle Payables, Journal Imports Interface from external Payroll, Items into Inventory, Bills of Material into BOM from legacy system.
• Designed and Developed Staging tables, Data Conversion SQL Loader Program and Custom PL/SQL API to import the Customers, Parties, Customer Accounts, Party sites.
• Interface development to import Projects, tasks & Budgets from external systems to Oracle PA.
• Analyzing, and modifying programming systems including encoding, testing, debugging, and installing to support Oracle eBusiness Suite, iRecruitment, Payroll, Time and Labor, and Advanced Benefits
• Designed and developed an Outbound Interface between Interlace Systems (Supply-Chain Management tool) and Oracle Applications for Customers, Items, BOMS, On hand Quantity, etc.
• Developed an inbound interface to download project tasks from external system in to Oracle PA.
• Designed and Developed a custom program to terminate the Service contract
• Designed and Developed a Custom Program to update Install Base status and create Install location
• Designed and Developed a reports to extract all the service contracts with different status at header, serivce and cover product level.
• Developed various Custom reports, Customized existing reports according to the functional specifications including Packing Slip, Pick Slip, Daily Inventory Transactions Report, AP NACHA Payment Format Report, Invoice and Expense reports, AR Adjustments etc using Reports 6i.
• Used Oracle Application Object Library (AOL) features like Value Sets, Descriptive Flex fields, Concurrent Programs, Profile Options, standard request submissions (SRS) and parameters in the process of development.
• Did post implementation support for various departments like Financials, Purchasing, Planning, Manufacturing and Sales.
• Created SR/TAR in metalink, got fixes from oracle support and applied patches with coordination of Apps DBA for Bug fixing.

Environment: Oracle Applications 11i (11.5.10), GL, AR, AP, FA, PO, PA, OM, INV, WIP, BOM, Install Base, Service Contracts Oracle 9i, PL/SQL, Work Flow, SQL*Plus, TOAD and Discoverer 4i

Confidential, Houston, TX

Oracle Financials Technical Consultant

Responsibilities:

• Upgraded the system from 11.5.8. to 11.5.10 and worked on the issues were the customization were broken through upgrade
• Worked on the implementation of Autolockbox Interface
• Customized the Oracle Seeded Order Management Transaction Type workflow to add workflow functions for email Notifications when the order is booked using Workflow Builder.
• Created Customized Invoice report for client by modifying standard Invoice Report provided by Oracle
• Enabled the descriptive flex fields on Sales orders and Invoices to facilitate additional information
• Involved in customization of several standard reports to serve important business processes very specific to the client. Such reports include Purchase Order Detail Report in PO, Invoice on hold report, Vendor, Payments, and analysis reports in AP, and also Customer, receipts, invoice and adjustment reports in AR.
• Involved in creating business areas, user views, custom folders and joins for reporting using Oracle Discoverer 4i in Administrative edition as per the user requirements.
• Identified product gaps, coordinated with Development Team by creating TAR and obtained one-off fixes. Managed and monitored TAR for several SEV1 Issues. Provided on site solutions and resolved showstopper issues.
• Involved in Code Development, Unit Testing, Business Testing and Reconciliation of reports. Developed and executed test cases. Involved in Functional, Performance and Regression testing
• Provided daily production support.

Environment: Oracle Applications 11i (11.5.8/11.5.10 ), GL, AR, AP, PO, CM, INV, OM, Oracle 8i, Forms 6i, Reports 6i, Discoverer4i, PL/SQL, SQL*Loader, SQL*Plus, TOAD, UNIX, Shell scripts, HP-UX

Confidential AZ

Oracle Apps Junior Developer

Responsibilities:

• Wrote Functional (MD50), Technical (MD70) design document and Conversion Mapping Document (CV40) for Item Import, BOM Import and Open Sales Order Import.
• Developed Conversion programs, Staging Tables and Customized PL/SQL API for Item Import and Open Sales Order Import.
• Developed a customized report to show different project activities.
• Developed Custom forms and added the zoom functionality in the e-business form. Also developed PL/SQL scripts. Registered concurrent programs, request groups for reports.
• Created Customized Invoice report for client by modifying standard Invoice Report provided by Oracle
• Enabled the descriptive flex fields on Sales orders and Invoices to facilitate additional information
• Responsible for development of Purchasing & Inventory Control Modules for implementing security based roles, created users in Oracle also involved in development of Financial Accounting System, production, Dispatch & Maintenance System.
• Created Tables & Views and referential integrity constraints using SQL.
• Wrote Database Triggers, Procedure & Functions using PL/SQL.
• Analyzed requirement of client and worked on developing and designing reports.
• Developed all the sales reports for the company using Oracle Reports.
• Implemented Security by creating different users/roles and assigning roles to users forms.

Environment: Oracle 7i, Developer 2000,SQL, PL/SQL, Windows 95

Confidential

PL/SQL Developer

Responsibilities:

• Analyzed and overviewed the database design for better understanding the relations, associations and dependencies within the database.
• Data modeling for client specific requirements.
• Developed database objects including tables, clusters, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.
• Developed complex queries on Data Warehousing and developed PL/SQL procedures to give in nice strategic plans to higher level of management.
• Created SQL*Loader scripts to load data into the temporary staging tables.
• Tuned complex Stored Procedures for faster execution and Developed database structures, according to the requirements in Oracle data warehousing.
• Used Dynamic SQL programming technique to build and process SQL statements "on the fly" at run time.
• Developed PL/SQL scripts for Data cleansing.
• Developed UNIX shell scripts that help as a scheduler for data load.
• Made timely changes and fixes to all the modules on reported problems from the database administrator.
• Used TOAD, PL/SQL developer tools for faster application development.
• Performed SQL tuning using Explain Plan, Hints and indexes.

Environment: Oracle 8, PL/SQL, TOAD and Windows 2000 server