SUMMARY

• Over 14 Plus years of Experience in IT with 12 years of ERP Experience including Developing, Customizing, Testing and Implementation of Oracle Financials, Oracle Manufacturing, Oracle HRMS and Oracle CRM modules.
• Developed extensive technical, functional and analytical capabilities.
• Worked in teams, involved in requirements study and design and development of database for oracle applications.
• Expertise working with Oracle 7.x/8.x/9.X/10g, Developer 2000, PL/SQL, Forms 5.0/6i/9i, Report Writer 3.0/6i/9i, SQL * Loader.
• Has very good experience with Oracle OPM.
• Expertise in Oracle Applications 11i Customization, AOL and Application Administration,
• Expertise in Oracle Application System Administrator functions such as installation, applying patches, and troubleshooting on NT.
• Strong noledge of Application Object Library (AOL) implementation standards and Trading Community Architecture (TCA), OAF, BPEL.
• Good noledge of Data Warehousing tools like COGNOS, Informatica and Oracle Discoverer
• Expert in Developing and Supporting both Production and Development Systems
• Excellent Communications and interpersonal skills

=

TECHNICAL SKILLS

ERP: Oracle Applications R12,11i/11.x/10.x.

Technical Applications: Oracle Workflow, OAFramework, BPEL, AOL and SYSADMIN

Financial Applications: GL, AP, AR, CM, FA, Projects

Supply Chain Applications: Order Management (Order Entry), Oracle Purchasing

CRM Application: CRM Foundation, Tele - Service, Service Contracts Field ServiceGUI: Visual Basic, Developer 2000, Forms 6i/4.5

Languages: SQL, PL/SQL, COBOL, C, C++, COM/DCOM, HTML, XML

Database: Oracle 10g/9i/8i/8.x/7.3

Tools: FSG, ADI, Reports 6i/2.5/1.1, Crystal Reports, SQL Loader, TOAD, COGNOS, Informatica and Oracle Discoverer, Business Objects.

Operating System: Windows 95, Windows NT, MS DOS, HP UNIX.

PROFESSIONAL EXPERIENCE

Confidential, WI

ORACLE Developer

Responsibilities:

• Worked on developing Custom Forms using Forms6i.
• Worked On Custom AR Invoice Print Report Using BI Publisher.
• Built custom programs to validate teh Bank Account Details provided using PL/SQL.
• Worked on Loading Europe & US Bank Accounts Into Oracle Using Data Load.
• Worked on Bug Fixing of teh existing custom Reports using Reports6i.
• Was Responsible for Interacting directly with teh Users in Europe and US.
• Gatheird Requirements from teh users and built teh MD50 & MD70 Documents.

Environment: Oracle 11i, GL, AP, AR, OM, INV, Shell Scripts, Oracle 10g, TOAD, Pl/Sql, Forms 6i, Reports 6i, BI PUBLISHER, Oracle Discoverer 10g,Windows 2K

Confidential, WI

Responsibilities:

• Worked as Lead for teh Archive & Purge Project using Informatica ILM tool.
• Working as Technical Lead for teh Upgrade Project from 11i (11.5.10) to R12(12.1.3)
• Worked on Custom Interface to create Service Contracts in Oracle Using Standard API’s.
• Worked on Custom Interface to send teh Debrief Information from Field Service to Legacy System.
• Customized teh Standard Billing Programs in Service Contracts as per teh Business requirements.
• Worked on Inbound/Outbound Interfaces in AR, AP, and Projects.
• Worked on Enhancements with teh Journal Import in GL.
• Involved in Documents like BR100, MD50, and MD70.
• Worked on Oracle Discoverer Reports.
• Worked on BI Publisher /XML Publisher.
• Was involved in gathering requirements from teh users to identify teh data to be Archived.
• Was responsible for Customizing teh Standard Business rules provided by Informatica as per teh requirements of teh client.
• Involved in day to day Activities and monitoring teh Archive Jobs in teh Weekends.
• Was responsible for Configuring teh Informatica ILM tool
• Was responsible for coordinating with Informatica to fix teh no Bugs.
• Worked on extensions to send teh Tagalong Items along with teh Manufactured Items from IBS to SAP.

Environment: Oracle R12, GL, AP, AR, OM, INV, Projects, Service Contracts, Install Base, Field Service, Shell Scripts, Oracle 10g, TOAD, Pl/Sql, Forms 10g, Reports 10g, BI PUBLISHER, Informatica ILM, Oracle Discoverer 10g,Windows 2K

Confidential, Charlotte, NC

Responsibilities:

• Worked on Custom form Physical Count Re-entry for teh users to enter teh counts of teh items in teh Inventory in OPM.
• Customized teh PCard Transaction flow using OA Framework in iExpense Module.
• Worked on Routings, Formulas, Operations, Recipes Conversion in OPM.
• Worked on Items Conversion for teh OPM module.
• Worked on creating teh views for costing Information to be sent to teh legacy system in OPM
• Worked on Extracting and sending teh Material Usage data to teh legacy system from OPM.
• Worked on creating new custom Pricing channel form using Forms6i.
• Working on Denormalizing teh Pricing Data in to teh Custom tables in advanced pricing to improve teh performance of teh pricing Engine.
• Worked on Journal Import in GL.
• Worked on Customer Conversion in AR.
• Worked on fixing teh performance issues in Auto Invoice.
• Has customized teh Invoice Print Program in AR for Weekly & Daily Billing Customers
• Has built Custom Consolidated billing Program according to teh client requirements in AR.
• Worked on developing Custom reports using XML PUBLISHER and Report6i.
• Responsible for implementing Manage Self Service HR as per client processes.
• Responsible for setting up approval rules for Vacancy and Offer letter processes in iRecruitment using Approval Management AME.
• Responsible for setting up approval rules for Manager self service processes like Worker status change, Transfer, Salary Change, Hours Change, Bonus EIT functions using Approval Management AME.
• Converted employees from mainframes into Oracle HR using public HR API’s.
• Highly customized teh HR/HRSSA workflow processes to meet Owens & Minor business process.
• Created Several BI Publisher reports like 401K participant/non-participant, Employee Roster report, workflow status report (Routings) and New Hire reports.
• Customized teh Worker status change, Transfer functions functionality to default teh GRE, Salaried code, Working hours, Company code etc from position based on position/job selection (OA Framework).
• Worked on Ceridian interface which sends teh time entry information from Oracle HR/OTL to Ceridian.
• Responsible for creating “Application Setup” Documents (BR100) for Approval Managements and Self Service HR.
• Modified teh timecard layouts as per Owens client business process.
• Responsible for creating teh functional and technical design documents (MD050, MD060 and MD070) and code move documents CM040 related to reports.
• Extensively used OA Framework personalization’s to personalize most of teh Self Service Human Resource forms.
• Converted around 500 active employees and 2024 inactive employees from JDE to Oracle using open API’s.

Environment: Oracle 11i, GL, AP, AR, OM,, INV,OPM,Advnced Pricing,Shipping,HRMS,Self Service, Shell Scripts, Oracle 9i, SQL Navigator, Pl/Sql, Forms 6i, Reports 6i, XML PUBLISHER, Windows 2K

Confidential, Worthington, OH

Responsibilities:

• Worked on Custom form VIEW SCHEDULE, to display teh scheduling of teh Master Work Orders.
• Worked on Custom form VIEW ROUTING, to display teh routing of teh Discrete Jobs of a Master Work Order.
• Involved in Performance tuning of various queries and stored procedures using Explain plan & Tkprof.
• Worked on day to day production issues in O2C (Order to Cash) & D2B (Demand to Build).
• Used Custom.pll for Forms Customization.
• Developed Custom API’s which were used across teh application .
• Worked on Shell Scripts to install teh scripts to move to different instances.
• Worked on enhancments and bug fixing in Order Import in OM.
• Developed Order Import Error Report in OM, and Developed a Shell Program to send teh report as an email.

Environment: Oracle 11i, GL, AP, AR, OM, BOM, WIP, INV,Shell Scripts, Oracle 9i, SQL Navigator, Pl/Sql, Forms 6i, Reports 6i, Discoverer, UNIX,Version Manager, Windows 2K .

Confidential, Windsor, CT

Responsibilities:

• Responsible for researching and tracking TARs and other related initiatives using OWC.
• Worked on Invoice interface wrapper which validates teh data and splits teh lines before inserting into teh Auto invoice interface tables
• Worked on daily Issues with Auto Invoice me.e providing data fixes to teh stuck invoices or deleting teh invoices from interface tables and reprocessing them.
• Worked on performance issues in Auto Invoice, logged TAR’s with oracle to resolve teh performance Issues.
• Used Vertex Tax API’s to calculate teh tax. Teh Tax calculation process is customized.
• Worked closely with users in resolving teh issues.
• Monitoring teh custom programs and fixing teh issues with teh error records.
• Customized Workflow in Order Management.
• Developed Custom Order Import Program to load data dat comes from teh external source to teh Order Management.
• Developed Interface Program from Contracts to OM. Used OM Adjustments tables to create adjustments based on teh Modifiers dat Setup in teh Pricing Module.
• Involved in building adhoc reports based on user requirements using Discoverer.
• Worked on creating teh Tax reports for teh Users using Reports6i.
• Worked on building custom forms Forms6i.
• Worked on tuning Autoinvoice and custom programs.
• Worked on documenting setups, functional specs and maintaining Requirement Documents and other design documents as MD050.
• Worked on creating contracts in Oracle using API’s in Contracts.

Environment: Oracle 11i, GL, AP, AR, OM, BOM, WIP, INV, iExpense, Clear Case, Contracts, Install Base, Field Service, Shell Scripts, Oracle 9i, TOAD, Pl/Sql, Forms 6i, Reports 6i, Discoverer, UNIX, Windows 2K .

Confidential, Shelton, CT

Responsibilities:

• Involved in building adhoc reports based on user requirements.
• Involved in solving teh Credit Card issues. Had issues with Settllement-Inbound and Settlement - Outbound files coming from AMEX.
• Was Involved in Designing teh credit card Process.
• Has built different custom programs to handle teh chase(Master Card, Visa) and AMEX files as teh process is different for chase files and Amex files.
• Worked on issues with Auto Invoice and Auto Lock Box.
• Worked on various reports for Install Base, Service Contracts and AR.
• Was responsible for Monitoring teh Jobs when Billing for OKC and OM were running.
• Has very good understanding of teh TCA architecture.
• Customized standard forms using teh tool REMEDIT.
• Responsible for Developing and maintaining extensions in OKC like Counters.
• Developed a custom program for usage proration in Service Contracts.
• Worked on day to day Production issues with Contracts and Billing.

Environment: Oracle 11i, GL, AP, AR, OM, BOM, WIP, INV, Service Contracts, Install Base, Field Service, Kintana, Shell Scripts, Oracle 9i, TOAD, Pl/Sql, Forms 6i, Reports 6i, Discoverer, UNIX, Windows 2K .

Confidential, Plantation, FL

Responsibilities:

• Involved in gathering teh requirements from teh Users to design new reports according to teh user needs in GL, AP, AR, OM, INV.
• Was coordinating with teh offshore team based in India.
• Was leading teh Informatica developers, halping them Identify teh table structures in Oracle.
• Worked on teh ETL tool INFORMATICA to extract data from various Oracle instances which are on 10.7,11.03 &11i
• Has done teh Gap Analysis for implementing teh analytical apps of INFORMATICA.
• Has done teh Gap Analysis for creating teh new views for teh users as teh earlier views were on 10.7 and teh 11i is on TCA architecture and Workflow driven.
• Involved in gathering design specifications of Vantive Client in order to map to Oracle Depot Repair.
• Found specifications for Oracle Install Base and Oracle Service Module.
• Worked on bringing legacy Contracts to Oracle using API’s.
• Prepared teh Functional Document MD50 during Analysis Process.
• Involved in preparing MD60 Technical Document in providing teh necessary API’s of Oracle CRM, which replace teh Vantive Functionality.

Environment: Oracle 11i, GL, AP, AR,CM, OM, BOM, WIP, INV, Service Contracts, Depot Repair, Install Base, Field Service, Knowledge Base Brio, Clear Case, EXCEED, Shell Scripts, Oracle 8i, TOAD, Pl/Sql, Forms 6i, Reports 6i, UNIX, Windows 2K, .

Confidential, Nashville, TN

Responsibilities:

• Worked on generating Additional accounting entries in GL which are generated in teh legacy system, Generated Additional Accounting lines in Oracle Through GL INTERFACE.
• Was involved in teh design of technical specifications.
• Was responsible for Unit testing and Functional testing.
• Worked on FSG Reports using ADI.
• Worked on custom Interface for voiding teh payments in Oracle, which are Voided in teh legacy system in AP. Used standard Oracle API’s to perform teh void and to check teh invoice status and open periods.
• Developed SQL * Loader Scripts for importing legacy systems data into AR interface tables.
• Worked on Auto Invoice to bring teh legacy invoices in to Oracle in AR.
• Worked Customer Interfaces in AR.
• Worked on Custom Reports to generate Summary and Detailed lines for Transactions, Receipts and Adjustments in AR.
• Involved in GL conversion, converting of legacy data in to Oracle Applications involves use of PL/SQL package and Shell Script. SQL * Loader was used to load data into custom tables.
• Created a Shell Script for teh purge program. This involves creation of package to create Util File. Teh data in teh Util File was read using a Shell Script and relevant files were deleted from teh UNIX directory and various custom tables.
• Written Java code to FTP.

Environment: Oracle 11i, AP, GL, AR UNIX, Windows 2K, Oracle 8i, TOAD, PUTTY, Shell Scripts, Pl/Sql, Forms 6i, Reports 6i,Java.

Confidential, Minneapolis, MN

Responsibilities:

• Involved in developing new interfaces, customizations of existing interfaces, developing new reports and customizing existing reports and Forms to 6i to meet teh Functional and technical design based on teh business/client requirements.
• Has done basic setups for Tele Services, Knowledge Base, Install Base and CRM Foundation.
• Real time integration between clarify and oracle for creating service requests and tasks.
• Worked on contracts conversion in Service Contracts.
• Atomization of task dispatch using “workflow for task manager” in Services.
• Regular interfaces between Clarify and Oracle to send Service Request from Clarify to Oracle and Vice versa when teh request is closed.
• Used Standard Oracle API’s to submit concurrent requests from PL/SQL.
• Mapping of data elements in teh source system to facilitate GL Import Process. Analyze various required, conditionally required columns of GL INTERFACE table.
• Worked on Order Import to bring teh orders from teh Clarify. Used standard API’s to improve teh order import process. A third party tool called TIBCO was used to dump teh orders in to staging table in Order Management.
• Interfaced with teh Order Management on teh legacy system to import orders, on auto invoice program to automatically create invoices in receivables. Loading teh data for external files to temporary table by using SQL* Loader, validated teh data and then inserted teh validated data into AR tables.
• Worked on Auto LockBox in AR.
• Validated teh data loaded into interface tables of ra interface lines, ra interface distribution all and ra interface salescredit in AR.
• Also involved in Customer interface, validated data loaded into interface tables of ra customer interface, ra customer profile int, ra contact phones int, ra cust pay method int in AR.
• Customized Purchasing Requisition form in PO.
• Worked on invoice interface in AP.
• Worked on Mass Addition Interface in FA. Build PL/SQL programs to perform Mass additions to load conversion of assets from legacy system
• Customized Purchase order report according to teh business requirements PO.
• Developed Item Interface conversion script for importing item information from Legacy System to Item Base tables through MTL SYSTEM ITEMS INTERFACE program in INV.

Environment: Oracle APPS 11i,UNIX, Windows NT, Oracle RDBMS Server Ver 8.me, GL, AP, AR, CM, FA, Project Accounting, PO, OM, INV, Services, Contracts, XML PUBLISHER, TIBCO.

Confidential, CA

Responsibilities:

• Developed conversions and interfaces of teh company's legacy information into Oracle Applications Release 11i using PL/SQL, SQL* Plus, and SQL* Loader and interface programs.
• This was a MULTI-ORG and MLS implementation.
• Generating Reports using FSG - Product wise, Period wise profit & loss account, Variance reports and Balance sheet in GL.
• In GL, Worked on interfaces for Journal Import and budget upload.
• Used Standard Oracle API’s to check teh GL open periods.
• In PO Customized Purchased Order report.
• Worked on check printing report in AP.
• Experience in creating new users, Responsibilities, Menus and User Security system.
• Involved in Workflow of Order Management (OM).
• Worked on Bank Reconciliation interface in CM.
• Involved in teh Conversion of legacy Purchase Orders into PO module
• Developed Items, Customer items and Customer item Cross References Interface in Inventory.
• Developed Reports in OE Module me.e. open Orders by Sales Order and Line Item Report. Order Booking and Backlog Report.
• Worked on teh purchasing requisitions interface in PO.
• Designed and deployed costing program, which loads item, costs in teh costing table.
• Created numerous reports in Inventory to keep track of teh cost & transacted items at various levels.
• Worked on ADADMIN, AUTOPATCH and ADCTRL Utilities.
• Creation of Users and assign them customized responsibilities.
• Involved in AR invoice import interface

Environment: Oracle APPS 11i Windows NT, Oracle 8i, Forms 6i and Reports 6i & TOAD, SQL Loader, Federal GL, AP, AR,PA, OM, PO, INV, Workflow builder 2.0.

Confidential

Responsibilities:

• Developed interfaces between legacy systems and Oracle Apps
• Defined journal sources, categories for teh journals, also setup set of books.
• Knowledge of Performance tuning of various queries and stored procedures.
• Importing invoice information into ORACLE Payables using SQL*Loader.
• Designed, developed, registered customized forms, tables and reports using AOL
• Developed customized Reports like aging analysis, Customer balance, and Revaluation report in AR.
• Developed Reports in OE Module me.e. open Orders by Sales Order and Line Item Report. Order Booking and Backlog Report.
• Customized Fixed Assets book report and Asset listing report in Fixed Assets module
• Involved in system administration responsibilities and creating Alerts and dealt with Multi Org Concurrent program registration
• Create Users and Responsibilities for Security.
• Defining New Descriptive flex fields
• Creation of Concurrent Manager and Managing Concurrent Processing.

Environment: Oracle Apps 10.7(GL, AP, AR, FA, OE, INV, PUR, AOL), Oracle 8, Forms 4.5, Reports 2.5, SQL Loader 7.1, Windows NT

Confidential

Sales Order Tracking System

Responsibilities:

• Create Users and Responsibilities for Security.
• Involved in design of teh application system
• Involved in developing E-R diagrams, creating tables.
• Defining New Descriptive flex fields
• Enhanced and developed several forms and reports using developer 2000
• Designed and developed library files (PLL) dat are commonly used across teh application
• Involved in design and development of Menu module
• Created database triggers to validate teh complex integrity.
• Created stored procedures, functions and packages for implementing major functions of teh system.
• Wrote scripts for populating teh database tables with test data.
• Testing and documentation.
• Extensive support for teh Implementation team.
• Wrote scripts for populating teh database tables with test data.
• Testing and documentation.
• Enhanced and developed several forms and reports using developer 2000
• Designed and developed library files (PLL) dat are commonly used across teh application
• Involved in design and development of Menu module
• Created database triggers to validate teh complex integrity.
• Created stored procedures, functions and packages for implementing major functions of teh system.
• Involved in design and development of Menu module
• Created database triggers to validate teh complex integrity
• Wrote scripts for populating teh database tables with test data.

Environment: Oracle 7.3, SQL, PL/SQL, Developer/2000 (Forms 5.0, Reports 3.0), SQL*Net, WindowsNT/95, SQL*Loader, Import, Export, WindowsNT/95.