PROFESSIONAL SUMMARY

• Over 8 years of experience in IT industry having experience in Analysis, Design, Development, Data Conversion, upgrades, customization, Interfacing and Implementation of business applications using Oracle Applications R11i/11.0.x/10.7, SQL, PL/SQL, Oracle 9i/8i/7.x, Developer 2000/6i and Discoverer.
• Extensive experience in Oracle Application Modules which include Order Management (OM), Inventory(INV), General Ledger (GL), Accounts Receivable (AR), Accounts Payable(AP), Cash Management(CM), Fixed Asserts(FA), Purchasing (PO), Bill Of Materials (BOM), HRMS, Payroll, Oracle time and labor (OTL), Advanced Benefits (OAB), Application Object Library(AOL),Project Accounting(PA), System Administrator in Solaris Environment.
• Proficient in developing PL/SQL program units using Procedures, Functions. Packages and Triggers, public API’s.
• Well versed with client server environment & tools like SQLLOADER, TOAD and WORKFLOW BUILDER.
• Extensive experience in developing Interface/Conversion Programs to import data from various sources into Oracle Applications using PL/SQL, SQLLoader, UTL File, UNIX and Shell script etc.
• Extracted data from Oracle Database using ODBC (Oracle Database Connectivity) into Excel spreadsheets.
• Experienced in Form 4.5/6i customizations and personalization registering them as concurrent programs in Oracle applications using AOL.
• Experienced in Customizing and developing Oracle Reports 6i.
• Ability to create financial statement generator (FSG) reports for Business use.
• Experienced in Customizing and developing reports using OBIEE, BI Publisher/ XML publisher and Discoverer.
• Experienced in RICE (Reports, Interfaces, Conversions and Extensions) components.
• Experienced using DATALOAD for loading external data into Oracle Applications UI.
• Extensive Experience with AOL to develop Flex fields, Reports, and Validation sets and Concurrent programs and registered in AOL.
• Proficient in usage of EXPLAIN PLAN and SQL TRACE used in Performance Tuning of Code.
• Wrote Technical Documents on Reports developed.
• Ability to interact effectively with clients, Understanding their requirements and providing optimum solution and support.
• Excellent Analytical, interpersonal and communication skills.
• Quick learner with ability to develop proficiency and adapt to new technologies and methods in a short period of time.

TECHNICAL SKILLS:
ERP: Oracle E-Business Suite v 11i, 11.5.3, 11.0.3, 10.7
ERP Modules: OM (Order Management), Inventory (INV), GL (General Ledger), AP (Account Payables), AR (Account Receivables), BOM (Bill Of Materials), PO (Purchasing), HRMS, AOL (Application Object Library), System Administration.
Interface Tools: Forms 6i/6.0/4.5, 4i/3i, SQLLoader, TOAD and Workflow Builder
RDBMS: Oracle 7.x/8.x/8i/9i, SQL Server 7/2000, Access 97/2000
Languages: SQL, PL/SQL, Visual Basic, JAVA, HTML, C
Operating Systems: Ms-Dos, Windows 9.X, Windows NT/2000/XP, UNIX, Linux, KEA! X
ETL: Informatica 6.2
Reporting Tools: Reports 6i, Discoverer 4i, Cognos Impromptu, Cognos Reportnet 1.1
Education: BE (E&C), Bangalore University,
MS (Computer Science), University College London, UK
Training: Oracle Backend Programming (Oracle University)
Cognos Reportnet 1.1
PVCS: Serena Changeman VM, PVCS Merant

PROJECT SUMMARY

Confidential, Sep’08 – Present
Yardley, PA
Role: Oracle Apps Techno-Functional Consultant

The Journal Register Company is strategically situated within six major metropolitan areas, circulating to 465,000 daily newspaper customers and reaching nearly 3 million through weekly and other non-daily publications. Owns and operates 20 daily newspapers and more than 160 non-daily publications and affiliated websites.
Conversions/ Interfaces

• Wrote Functional Specification (MD050) and Technical Specification (MD070) documents for
• Fixed Asset Additions API
• Fixed Assets Adjustments API
• GL Interface
• Customers using TCA.
• Payables-Bank Check Payment Interface
• Oracle-Cash management, Bank Check paid interface
• Developed an Oracle Payable bank check payment output INTERFACE to create a text file output of check payment data to send to the bank.
• Developed Conversion program to import Vendor/Supplier Information into Purchasing by loading data into staging tables from legacy system, validating data using PL/SQL API and then loading the data into Vendor information Base tables as part of R12 conversion.
• Prepared Technical Specification Document (MD070), and Developed Interface for loading Customer information from Ceridian system into Oracle using TCA API’s. TCA API’s are used to
• create new Customers and site,
• create new addresses and contacts and
• Update the assignments of the customers.
• Validations were performed.
• Developed a conversion for loading new customers and their information from legacy system into oracle using TCA API part of Conversion process to R12.
• Developed a conversion for loading and converting Items in OM from different source machines in a company into oracle as part of upgrade to R12
• Developed the Fixed asset API to add new assets to system and also to make a mass changes and adjustments to the existing assets using the API’s.
• Created and designed the GL Interface to receive files form different external sources on the servers and then load into interface tables and then kick off the program to create the journal import.
• Inbound interface from ADP to General Ledger for importing Journals every month.
• Developed a shell script for Refund upload process and registered as a Host Program, where the refund files are loaded into tables ,and a package is developed for further process which creates vendors and invoices for the new refunds in the system

Reports

• Worked with finance department (AP, AR, PO) on various reports like
• Top vendors Report by Paid date
• Top vendors Report by Invoice date
• AP Matching Options Report
• Developed Reports in FA
• FA Parent Asset Report
• FA Reserve Ledger Report – Excel Friendly
• Developed custom report and customized existing reports recording the functional specifications.
• Vendor Open Invoices By Company-Summary
• Vendor Open Invoices By Company-Detail
• Developed reports in General ledger (GL)
• GL Budget Summary Report
• GL Budget Comparison report by Publication
• GL revenue Detail Report
• GL Expense Detail Report
• GL Adhoc Account Summary By Publication
• Used Oracle BI/Xml publisher to generate reports on Account balances, Budget balances, and Variance reports as per business required outputs.
• Worked with a team of Apps DBA’s to install and configuration of Oracle BI Publisher 10.1.3.3.2
• Created packages and views as per business requirements required for creating a report through Xml publisher.
• Raised TAR to resolve issues related to Oracle BI /Xml publisher.
• Worked on creating application mode End User Layer, building business areas, and building discoverer workbooks, ad-hoc reports, parameterized reports using Discoverer4i.Created parameterized reports using Discoverer Plus.

Forms

• Performed form Customizations

System Administration/ Support

• Worked closely with end-users/clients through complex problems involving deployment, Performance testing and conversion
• Worked in production Support for Company. Resolved Severity tickets and made changes in existing reports and existing forms from production.
• Worked closely with the bank to design the file format, support the process to make easy for the end user in receiving and sending the files.
• Worked as a team to create the functional setup to process the vendor payments through ACH implementation.
• Worked closely with functional team and business to resolve bugs and defects and UAT.
• Created shell scripts for registering Cron jobs in UNIX.

Environment: Oracle Applications 11.5.10 Oracle Financials (AP, PO, HRMS, AR, GL, INV, FA,), Custom Module VR, PL/SQL, Oracle 9i, Forms 6i, Reports 6i, SQL Loader, TOAD, SQL Developer, CORE FTP, KEA! X, HP UNIX

Confidential, Feb’08 – Aug’08
State college, PA
Role: Oracle Apps Technical Consultant

C-COR.net is a leading global provider of HFC (Hybrid Fiber Coax) technology and services used to facilitate and manage delivery of voice, video and high-speed data over advanced broadband cable networks.

Conversions/ Interfaces

• Wrote Functional Specification (MD050), Technical Specification (MD070), Conversion Mapping (CV040) documents for converting
• Customer site Address
• Inventory items
• AR invoices.
• Customers using TCA.
• Developed Conversion program to import Customer site address with HIGHEST TAX RATE combination of state, city and county based on Zip Codes, carried out by loading data into staging tables from legacy system, validating data using PL/SQL API and then loading the data into customer information Base tables.
• Analyzed a Customer site conversion program and developed a update maintenance routine script by registering as concurrent programs and scheduling it accordingly at times to run the routine to keep updated.
• Developed a Bank check paid INTERFACE in Oracle Cash Management to upload check paid data from the bank into Oracle Cash Management through the Oracle Bank Statement Import & Auto Reconciliation program in R12. The interface is defined by a three-step process:
• Upload bank check paid data to a custom database table.
• Process uploaded data, and then populate Oracle bank statement interface tables with processed data.
• Kick off the Oracle seeded Bank Statement Import & Auto Reconciliation program.
• Developed a procedure to change the description of items in OM by doing a bulk update in the item master table in R12.

Reports

• Prepared Technical specification documents (MD70) for Reports and forms customized.
• Built Functional spec (MD50) documents on reports developed in sales orders and Accounts Receivables while interacting with the end users.
• Developed custom report and customized existing reports recording the functional specifications.
• Created Customized Invoice report for client by modifying standard Invoice Report provided by Oracle
• Developed reports in Order Management (OM) for sales orders generated
• Developed reports in Accounts Receivable (AR) for invoices generated with highest tax rates.
• Worked on Optio report document to change the VAT information on the invoices being printed.
• Worked on Discoverer report for Price list Migration aid Desire Customer name and customer price list displayed side by side to aid the migration to PS
• Developed Reports using Discoverer 10g, created business areas, workbooks, joins, and items based on business requirement.
• Worked on creating Packing slip report using BI/Xml publisher, to modify the layout and enhance the information.
• Customized various standard report using Xml Publisher to get the output in excel or PDF format as per business use.
• Developed Reports using Business Intelligence Discoverer 10.2.1.2, created business areas, Folders, workbooks, Worksheets, Conditions, Calculations, Totals, Percentages based on business requirement.
• Wrote various Custom SQL to developed Reports in Oracle BI Discoverer as per business requirements.
• Customization of several Discoverer and Oracle reports

Forms

• Performed form Customizations
• Worked on customizing the ASCP Workbench form to get the supplier name information from a different attribute level

System Administration/ Support

• Built numerous custom value sets and defined values for value sets.
• Registered concurrent programs, scheduled requests and defined request sets.
• Built Several SQL Scripts for solving help desk tickets
• worked on feasibility and effort analysis, training and explaining R12 new functionality to Users.
• Prepared Test case documents on all components developed.
• Did tuning on the SQL and PL/SQL, making the Procedures runs faster and more efficiently.
• in the tuning process as part of performance testing

Environment: Oracle Applications R12 Oracle Manufacturing (AP, AR, GL, INV, OM,), Custom Module VR, PL/SQL, Oracle 9i, Forms 6i, Reports 6i, SQL Loader, TOAD, SQL Developer, CORE FTP, HP Unix

Confidential, Feb06 – jan08
Somers, NY
Role: Oracle Apps Technical Consultant

The Pepsi Bottling Group (PBG) is the world\'s largest manufacturer, seller and distributor of Pepsi-Cola beverages — some of the world\'s most recognized consumer brands.

Conversions/ Interfaces

• Wrote Functional Specification (MD050), Technical Specification (MD070), Conversion Mapping (CV040) documents for converting
• Open Requisitions,
• Open Purchase Orders,
• Suppliers, Supplier Sites, Supplier contacts.
• Customers using TCA.
• Developed Conversion program to import Vendor/Supplier Information into Purchasing by loading data into staging tables from legacy system, validating data using PL/SQL API and then loading the data into Vendor information Base tables.
• Analyzed an SR on interface trip stop program and modified and executed the script for different internal requisitions and sales orders (OM). Converted the same script into Concurrent request.
• Prepared Technical Specification Document (MD070), and Developed Interface for loading Employee information from Ceridian system into Oracle using HRMS API’s. HRMS API’s are used to
• create new employees, update new employees,
• create new addresses and
• update the assignments of the employees.
• Validations were performed on US, Canada and UK employees of PBG Company.
• Designed and developed an Inbound Interface between web based Order management system Odyssey to Order Management (OM) for import Sales Orders.
• Designed and developed inbound interface from ADP to General Ledger for importing Journals every month.

Reports

• Worked with finance department (AP, AR, PO) on various reports like
• HDL Returns report,
• HDL Purchase Orders received not invoiced-Product;
• HDL Purchase Orders received not invoiced-Non-Product,
• HDL Check Register report, HDL Receipt Balancing report,
• HDL AR Bill Balancing report,
• HDL Material distribution report by Product line,
• HDL Vendor exposure report.
• Developed Reports in OM and shipping,
• HDL Orders cuts and returns, summary,
• Detail and by vendors.
• Developed reports in Shipping: HDL Bill of Lading report and
• HDL Pack list Report.
• Developed custom report and customized existing reports recording the functional specifications.
• Merged open sales orders.
• Developed reports in General ledger (GL) GL Audit report,
• GL Review report and GL Exception report.
• Developed reports in Custom module HDL Vendor Returns.
• Reports like HDL Open RAR’s report,
• HDL RAR’s on hold report.
• Worked on creating application End User Layer, building business areas, and building discoverer workbooks and ad-hoc reports using Oracle BI Discoverer 10g.

Forms

• Built custom HDL AR enquiry form.
• Performed form Customizations

System Administration/ Support

• Worked closely with end-users/clients through complex problems involving deployment, testing and conversion in the order-to-cash(OM)
• Worked in Postproduction Support for PBG’s Canada Go-Live. Resolved Severity tickets and made changes in existing reports and existing forms from production.
• Made changes to existing code in PVCS and tested it with business and functional users before moving it back to production through change management.
• Worked closely with functional team and business to resolve bugs and defects and UAT.

Environment: Oracle Applications 11.5.9 Oracle Manufacturing (AP, PO, HRMS, AR, GL, INV, OM,), Custom Module VR, PL/SQL, Oracle 9i, Forms 6i, Reports 6i, SQL Loader, TOAD, SQL Developer, PVCS Serena Changeman version manager, Bugzilla, Deloitte eroom, Managenow Ticket Log, CORE FTP, KEA! X, HP Unix