Summary:

• Developed/customized Oracle Forms using Form Builder, Custom.pll, Forms Personalization and Jdeveloper 9i, Reports with XML Publisher.
• Expertise in RICEW Reports, Interfaces, Conversions, Extensions and Workflow.
• Experience in development tools such as PL/SQL, JSP, JDeveloper, Oracle Developer suite 10g Forms 9i/10g and Reports 9i/10g, Workflow Builder and XML Publisher.
• Expertise in Order to Cash O2C and Procure to Pay P2P cycles.
• Experience in modules like GL,AP,AR,OM,PO,FA,INV,BOM,IExpense,Istore,Shipping,Service Contracts, Install Base,TCA.
• Oracle Applications 11i, R12using ORACLE 10g/9i/8i, SQL, PL/SQL, Forms 10g/9i/ 6i / 4.5, Reports 10g/9i/6i/2.5, Discoverer 10g/4i / 3i.
• 8 years of experience in Oracle E-Business Suite,Experince in Design, Development, Implementation and Customization of business applications usingOracle Applications.
• Experience in writing Procedures, Packages, Functions, Forms, Triggers views, records, constraints and other database objects using SQL and PL/SQL
• Experience in developing and customizing Oracle reports by using Report 6i /9i/10g and Discoverer 4i / 10g and XML publisher.
• Customized Oracle Forms with Forms Personalization, Custom.pll on Forms 10g/9i/6i/4.5
• Well versed with client server environment and tools like TOAD, SQL Loader and SQL Navigator.
• Migration Experience working on 10g to 11i and 11.0.3 to 11.5.10 and from 11.5.10 to R12 Instances.
• Expert in preparing Technical specifications MD070 , Functional Specification MD050 , Conversion Mapping Documents CV050 , Future Business Mapping Document BP-80 and Business Requirements Mapping Documents BR-100 user training manuals, test procedures document preparation.
• Extensive Experience in Business requirements gathering, gap analysis, software design, development, enterprise integration, dat a migration, conversion, interface, Fast Formulas, development/customization of forms and reports, development of custom modules and integrating them with Oracle applications, developing test plan and test cases, testing, implementation and support.
• Knowledge of Oracle Metalink functionality/technical support area to aid in resolving application problems and solutions.
• Possess excellent communication skills, good team-management and leadership qualities and can work independently or collaboratively in teams.

Technical Skills:

Professional Experience:

Job Title :Oracle Applications Techno-Functional Consultant

Confidential

• Confidential is the world's largest producer of medicine and vaccinations for pets and livestock. 5 6 The company was a subsidiary of Pfizer, the world's largest drug maker, but with Pfizer's spinoff of its 83 interest in the firm it is now a completely independent company. The company operates in 70 countries worldwide with recent expansions into Southeast Asia and China.
• Worked on the implementation of Account Payables, Account Receivables, General Ledger, Order Management ,Oracle Pricing and Inventory.
• Involved in migration/conversion from the legacy systems to OracleApplications R12. The conversion involved the drug items, payordata,Pharmacyinformationetcfrom legacy systems with RPG files has been converted to Oracle Applications R12.
• Developing testing scripts and supporting QA and User Acceptance testing.
• Developing various Interfaces, both inbound and outbound and implemented various Data.
• Developed a data load using PL/SQL and SQL Loader calling Unix scripts to download and manipulate files.
• Developed PL/SQL scripts and Conversion Programs to Validate and Import data from legacy systems.
• Developed a custom PL/SQL package to pick the orders with the specific category items which are in pick released status and auto ship confirm the orders.
• Worked on performance tuning of custom PL/SQL programs and reports.
• Developed custom fulfillment order notification which will send to fulfillment contact person with the details of ordered items in a specific pattern which is based on the type of order and the ordered items.
• Developed a custom interface process which consists of creating outbound files which has fixed length. This package will pick the ordered items which are in pick released status, un assigning the delivery number from the ordered items and write in to the outbound file with order details. This process is also for accepting the inbound files, assign the delivery numbers to the items and auto ship confirm them.
• Implemented the Customer Item Cross Reference Conversion by extracting the drug items and
• Drug item references from legacy system with the help of an extraction Program and then inserting the validated data in to mtl ci interface and mtl ci xref interfacetables and then submitting the Import Customer items,import customer item cross ref to define the customer items and references .
• Developed On hand Quantity Conversion Interface to load data about the Item available onhand
• from Linksys to Belkin by writing SQL Loader scripts and PL/SQL scripts for validating the data and
• Storing the data into MTL TRANSACTIONS INTERFACE and then populating the base tables by
• launching the Transaction Manager.
• Develepod and Customized Pharmacy Reports,DrugReports,Back Order Reports,Shipment Summary Report.
• Developed Concurrent Programs for creating transactions , update balances in exchange for Invoice adjustments, Receipts and Reverse Receipts which are otherwise manually created in Oracle Financials.
• Developed a package containing different procedures and functions using PL/SQL to cross validate invoice information and load automatically invoices into auto invoice interface tables.
• Responsible for Data Migration process and involved in performance tuning of existing stored procedures, table indexes.
• Forms Personalization in AR, Pricing and OM using Oracle Application Framework Personalization and forms Personalization.
• Worked on the integration of istore with Inventory/Order Management/Receivables,documentation of administration duties with istore module configurations.
• Designed and developed an extension to display customer specific data/Option classes to User at runtime based on the calling application OM/ iStore.
• Responsible for publishing content for istore.
• Customized Order/Invoice detail report,Order by item report, Sales Order Workflow status Report, Sales Order and Purchase Order Discrepancy Report in Order Entry/Management.
• Created Stored Procedures at back-end and integrated them with front-end
• Created Forms using Forms 6i and registered them in Oracle Apps R12.
• Customized the Oracle standard Price List form to enable zoom on load by making changes to the Custom.pll file.
• Involved in developing the functional requirements and technical design .

Environment: Oracle E-business Suite R12,Account receivabales,AccountPayables,GeneralLedger,OrderManagement,Inventory,Oracle Approval Management,ServiceContracts,InstalledBase,istore,Oracle Worflow,Oracle 9i, PL/SQL, Forms 6i, Reports 6i.

Job Title :Oracle Applications Techno-Functional Consultant

Confidential

• The Confidential is a non-profit organization in the Confidential that fosters appropriate cardiac care in an effort to reduce disability and deaths caused by cardiovascular disease and stroke. Originally formed in Confidential as the Association for the Prevention and Relief of Heart Disease, it is currently headquartered in Dallas, Texas. The American Heart Association is a national voluntary health agency.
• First level / Second Level support in Progress Production Support. Fire fighting with the daily issues related to the system and helps to boom the monthly revenues as much as possible.
• Monitor the CRM Queue and resolve the tickets with high level customer satisfaction and adhering to SOX guidelines.
• Working with the customer support groups, educate them and make them do the tasks on their own.
• Develop a prototype from the functional customer's design requirements for new applications or major enhancements that have complex visual components,
• Gathering information and also do research and able to perform scope analysis
• As a lead analyst prepared the MD20, MD50, MD60, MD70 for the custom forms / reports and interface programs when ever neccessary.
• Responsible to report the project status to business stake holders, conduct and resolve the technical issues through discussions.
• Actively conducted Conference Room Pilots CRPs for TDT business groups and Prepared End-User Training Documents.
• Experience on 11.5.10 to R12 upgrade activities of OPM Inventory GMI to discrete Inventory INV
• Modified the timecard layouts as per Owens client business process.
• Responsible for creating the functional and technical design documents MD050, MD060 and MD070 and code move documents CM040 related to reports.
• Customized and developed R12 Oracle Forms/Reports, workflow and Data conversion in financial AP, AR, GL Modules.
• Developed SQL scripts to create temporary tables and SQL Loader control files to load the item legacy data into the temporary tables in R12.

Environment: Oracle R12, 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

Job Title :Oracle Applications Techno-Functional Consultant

Confidential

• Confidential communications company headquartered in Confidential. It provides communications and data services to residential, business, governmental and wholesale customers. 2 A member of the S P 500index, the company operates as a local exchange carrier and Internet service provider in U.S. markets and is the third-largest telecommunications company in the Confidential in terms of lines served, behind AT T and Verizon.
• Responsible for implementation and customization of R12 modules like OM, INV, AR, PO, PA, GL, and Purchasing.
• Involved in Development and Customization of the OM Interface Applications.
• Developed a custom screen/jsp page in the Century Link internal portal using OA Framework OAF to import an XML file and PL/SQL logic to validate and create sales orders using the OM public APIs.
• Worked on Customization and Personilization OAF framework.
• Developed Sales order Acknowledgement Report using XML publisher, and also customized AR to GL Reconciliation Report.
• Customized XML Publisher Pick Slip and Pack slip reports.
• Worked on Purchase Order Import Interface, the interface validates the Purchasing data and inserts into Interface Tables and calls Import Standard Purchase Order program and creates the Purchase Orders.
• Created AR customer import using Oracle TCA API's to create and update existing customer
• information.
• Developed custom programs to process and progress the order headers and lines stuck in error, purge the workflow errors using standard call to OM, WSH and WF APIs.
• Customized the Order Header level and Line level Workflow WF processes to add the custom activities.
• Developed Purchase Order Receiving package, which includes validating the Receiving Data, Inserting Data into Receiving Open Interface Tables and calling the Receiving Transaction processor Concurrent program.
• Developed the AP invoices Interface program, loaded the data from flat file to the staging table using SQL Loader and did all the necessary validations before loading into AP INVOICES INTERFACE, AP INVOICE LINES INTERFACE tables and Calling Payable Import Program.
• Developed conversion programs and download programs for Bills and Routings for creating and updating Bills and Routings in BOM module.
• Populated a custom table based on 'End Item Substitution' custom logic for generating the
• candidate list with all possible upgrades, downgrades and alternates of the customer ordered part.
• The candidate list is generated, by using the customer preferences and the Service Bulletin data
• fromeBOM.
• The Item Relationship tables are populated from the 'End Item Substitution' custom table.
• Designed developed and documented conversion process for Items, Item Categories, Item
• revisions, On-hand qty, Stock locations from ISSESS legacy system to Oracle inventory
• Wrote functional specifications CF250 and technical specifications MD200 and conversion
• mapping documents CV40.
• Wrote the technical specification documents with PL/SQL pseudo code including comments.
• Designed and developed staging tables, SQL loader scripts conversion routines and custom PL/SQL API for converting Items, Item Categories, Item revisions, On-hand qty, Stock location from ISSESS legacy system to Oracle inventory
• Used Application Implementation Methodology AIM for documentation.
• Provided support to the existing implementation and and post go-live application support.
• Worked on Store front deisgn,assess business requirements for istore.
• Worked on creation of project paln,catalog management,b2b/c2b administration.

Environment : Oracle E-business Suite R12, Account Payables, Accounts Receivables, Inventory, TCA,BOM,GeneralLedger,OrderManagement,ProjectAccouting,istore,iProcurement,OAF, XML/BI Publisher, Report Builder, SQL PLUS, SQL Loader, TOAD, UNIX.

Job Title: Oracle ApplicataionsTechnical Developer

Confidential

• Developed a custom interface process which consists of creating outbound files which has fixed length. This package will pick the ordered items which are in pick released status, un assigning the delivery number from the ordered items and write in to the outbound file with order details. This process is also for accepting the inbound files, assign the delivery numbers to the items and auto ship confirm them.
• Developed custom fulfillment order notification that sends fulfillment contact person with the details of ordered items in a specific pattern which is based on the type of order and the ordered items.
• Developed a custom PL/SQL package to pick the orders with the specific category items which are in pick released status and auto ship confirm the orders.
• Developed an Alert that gets fired when the order has pick released and shows the details of successfully pick released orders.
• Worked on the development and implementation of Oralce Order Management, Receivables,Oracle AR,PO,GL, Pricing,and Oracle Discoverer.
• Safeware is a fully licensed Insurance Agency as well as a Third Party Administrator for Extended Confidential. This unique combination gives customers and partners the flexibility to customize a program that meets their distinct needs
• Developed custom program which generates new price information based on the Accounting rule, rule start and end dates for orders and populates the custom tables.
• Along with the Custom program transferring the price information which are eligible to General Ledger on monthly basis.Developed custom PL/SQL report based on the price information data.
• Designed and implemented interface programs to load Purchasing PO data from legacy systems to Oracle Applications.
• Coding of custom reports for Purchasing PO module, defining concurrent programs, value sets and parameters.
• Development of custom XML publisher and rdf reports in Purchasing PO and in Account Payable AP modules.
• Developed custom forms, reports and concurrent programs using Forms 10g, Reports 10g and PL/SQL and registered them to Oracle Applications using AOL.
• Personalization of OA Framework pages.
• Designed and developed customizations using Oracle Application Framework in Project Resource Management, IExpenses and IProcurement modules.
• Developed a custom package to develop a PL/SQL report called 'Item Exception Report' which will display the items with the corresponding exception.
• Developed custom form to enter the quantity of required order item, based on this quantity developed a custom package to create the order lines in sales order lines form.
• Developed PL/SQL packages to Map, Validate and Load the Service Contracts, Install Base and Inventory items legacy data in to oracle application.
• Developed custom PL/SQL procedures to perform various form functionalities on OA Framework pages.
• Personalized seeded and custom OAF pages to hide fields and buttons on the pages
• Provided an OAF design, which is configured using OAF personalization.
• Worked on creating custom alerts, Pl/SQL programs, Discoverer and Oracle 6i reports.
• Designed automation process for Inbound and Outbound Interfaces from the legacy.
• Responsible for designing technical design, test case and porting instruction documents
• Developed a custom program to update vendor of type employee communication details.
• Developed a program to create vendor contacts for existing vendors.
• Developed a program to inactivate the vendors.

Environment :Oracle Applications 11.5.10.2/R12 GL, AR,AP, PO, OM, INV , Oracle 9i/10g, SQL, PL/SQL,OracleDiscoverer,OAF,XML Publisher, Forms 9i/10g, Reports 9i/10g, UNIX.

Job Title:Oracle Appliations Technical Developer

Confidential

• Customization of Purchase Order Print report as per the client's requirement.
• Customized and Developed reports like purchase price variance report, dunning letter report and registered them in Apps.
• Involved in performance tuning of custom PL/SQL programs and reports.
• Extensively used data templates with XML publisher to develop custom reports.
• Developed new Reports and customized existing Reports in the OM, AR and AP module according to the client's requirements.
• Worked on Vendor Conversionand Payables Open Invoice Interfacein AP.
• Created summary folder, hierarchies, item classes, complex folders and custom folders for list of values.
• Created custom built forms using custom.pll and event based triggers.
• Developed Shell scripts for automating the process of data loading.
• Worked in database development Created PL/SQL stored procedures, functions, packages and sequences
• Developed a Custom Program to validate and Import Sales Order from legacy system into Oracle Application using order processing API.
• Worked closely with user group and translated the requirements into detail technical and functional specifications.
• Confidential was one of the world's largest money management firms. Confidential, it was in the business of institutional and high-net-worth individual asset management, including the Dreyfus family of mutual funds business banking and shareholder and investor services.
• Developed new forms based on single table and multiple tables , single or multiple database blocks, Used pop up menu , alerts, program units, LOVs, visual attributes and libraries to make the front end application more user friendly.
• Involved in Production support.
• Coding, testing of the technical components to meet the functional requirements
• Involved in bug analysis and fixing process.

Environment :Oracle E-business Suite R12,General Ledger, Account Payables, Accounts Receivable, Inventory, Order Management,Statuatory reporting, SQL PLUS, SQL Loader, UNIX, Window NT, Oracle 8i, Forms 6i, Reports 6i, TOAD.

Job Title: Oracle Application Developer

Confidential

• Involved in database development by creating PL/SQL functions, procedures, triggers, packages and materialised views.
• Enhanced custom PL/SQL packages. Tuned long running PL/SQL programs.
• Created PL/SQL, SQL, SQL Plus, and SQL Loader scripts to validate and call stored procedures to validate and populate database objects before generating Oracle Error and Status reports.
• Developed Custom Oracleforms,created data blocks, items, Well versed with FORM, Block ,item level triggers, LOV's and Record groups.
• Confidential formed in 2010 from offerings previously provided by Capital IQ, elements of S P including Global Credit Portal and MarketScope Advisor, enterprise solutions such as S P Securities Evaluations and Compustat, research offerings including Leveraged Commentary Data, Global Markets Intelligence, and company and fund research.
• Created Records, Tables, Objects, Collections Nested Tables and Varrays , and Error Handling.
• Planned and implemented the data conversion methodology and programs to bring Installed Base IB instances software licenses and Service Contracts SCs service agreements and maintenance from a legacy system into the Oracle 11i application.
• Worked on the Migration of existing lower Oracle EBS 10.7 to higher EBS 11i version by implementing Oracle AR, AP, GL,Advance Pricing,Inventory,Order Management , Service Contracts, Installed Base . The objective of this implementation was not only to upgrade but also to bring two different businesses from different environments on to a single instance.
• Provided licensing information to the employees from a custom licensing web portal data interfaces from Oracle Install Base IB to this portal so it can presented to customers .
• Designed and coordinated all data conversion development/testing tasks for Install Base instances with Counters, Warranties, Service Agreements, and Service Contracts with Charges and custom development items.
• Responsible for developing ,Implementing, testing and production support for business functionality of Oracle 11i ERP system.
• Extensivley worked on the Implementaion and functional support of Oracle AR,AP,OM,GL,INV,SC,IB,BOM,TCA.
• Developing various Interfaces, both inbound and outbound and implemented various Data.
• Created procedures and SQL Loader Scripts to populate Customer interface tables
• Developedvarious custom reports and customized standard Oracle Reports, and also developed Discoverer Reports to be viewed from Discoverer plus and Viewer 4i .
• Worked on technical design documents for conversions, extensions, interfaces, and reports.
• Troubleshoot issues, including creation/follow-up of Oracle service requests SRs .

Environment: SUN Solaris 2.5, Oracle Applications R12/11.5.8/10.7, Oracle 10g/9i/8i, PL/SQL, Reports10g/6i and Forms 10g/6i, Discoverer 4.x.

Job Title:Oracle PL/SQl Developer

Confidential

• Involved in writing data Migration scripts/create table scripts to load database successfully from old schema to new structured schema.
• Extensively interacted with end-users and business analysts to identify and develop business requirements and transform it into technical requirements and ultimately responsible for delivering the solution.
• Creating Database Tables, Views, Indexes, Triggers and Sequences and Developing the Database Structure with ETL Concepts.
• Altering the database Objects to synchronize it with the new Schema created.
• Understanding the business logic to modify existing SQL Code and Performance Tuning
• Use of EXPLAIN PLAN, ANALYZE, HINTS to tune queries for better performance and also extensive Usage of Indexes.
• Created databaseobjects like tables, indexes, synonyms, views etc. using SQL Plus, used SQL Loader control files to load data from external data sources into Oracle database.
• Developed PL/SQL packages, Oracle tables, stored procedures, functions, triggers and UNIX shell scripts.
• Used Sqlldr for loading the database tables with huge volumes of data from Old Schema.
• Involved into updating procedures, functions, triggers, and packages based on thechange requests.
• Involved in writing procedures, functions, triggers, and packages fornew requirements.
• Modified Existing Packages, Procedures, Functions and transformations as per the Newrequirements.
• Import Export database for validation and performance testing.
• Provided Test Data to QA team to validate front end application. Also performed unit testing.
• Involved in Technical Documentation, Unit test, Integration Test and writing Test plan.
• Involved to prepare user level and system level maintenance documentation.

Environment :Oracle 10g/9i, SQL, PL-SQL, SQL Plus, ,Toad, Stored Procedures, Functions and Triggers, UNIX.