SUMMARY:

• Over 14+ years of IT experience in System Analysis, Design, Development, Conversion, Customization, Interfacing, Implementation of business applications using ERP, Client/Server and Internet Technologies. Specialized in Oracle E - Business Suite, Oracle Applications (Financial, S upply Chain/Distribution, Manufacturing, CRM) skills with sound knowledge of their integration.
• Worked on versions 12/11i/11.0.x and 10.7 SC. Experience in Oracle Applications Implementation and Upgrade. Experience in setup, customization, System Administration, data conversion and interface programming and generating Reports and concurrent programs.
• Proficient with the Tables & their relations in AR (Accounts Receivables), AP (Accounts Payable), GL (General Ledger), PO, PA (Project Accounting),IExpenses, Iprocurement, FA (Fixed Assets), OLM (Oracle Lease Management), Service Contracts, HR, OKE, Project Contracts, Oracle Configurator, CE, OM, WSH, WIP, BOM modules.
• Strong working knowledge in Building and Customizing OA Framework based Applications (OA Framework Extensions and Personalization).
• Strong working knowledge of RICEW, AIM and CEMLI as part of implementation.
• Proficient in developing Forms and Reports using Oracle Forms 10g/6i/5.0/4.5, Reports 10g/6i/3.0/2.5, Discoverer 10g/4i and developing concurrent programs using SQL, PL/SQL, BPEL and UNIX Shell scripts.
• Strong knowledge in setting up Oracle BI Repository, creating (Dimensions, Dashboard reports, Charts, Calculations) using Presentation Services in OBIEE (Oracle Business Intelligence Enterprise Edition) Tools.
• Strong knowledge of Relational and Dimensional Data Modeling.
• Strong in customizing the Standard Oracle applications forms using Custom.pll and Forms Personalization.
• Strong knowledge of Application Object Library (AOL) and knowledge of implementing AIM methodologies
• Good programming knowledge in Oracle 10g/9i/8i/8/7.x, Oracle Jdeveloper 10g/9i, Developer 2000 (Oracle Forms, Oracle Reports), PL/SQL, SQL*Loader Utilities.
• Proficient in SQL Tuning, using Oracle Expert, TKPROF, EXPLAIN PLAN, AUTO TRACE utilities.
• Hands on experience on writing SQL queries, PL/SQL procedures, Functions, Packages, Triggers in Oracle and SQL server, also involved in database testing.
• Strong Interpersonal, Analytical, Problem Solving and Organizational Skills, caliber to interact with people at all levels. Good Communication and Presentation Skills.

TECHNICAL SKILLS:

ERP: Oracle Applications 12/11i /11.0.x/10.7 Workflow Builder 2.6, AIM 3.0 Methodology

Databases: Oracle 11g/10g/9i/8i/8/7..x

Languages: PL/SQL, SQL, Java, Pro*C, XML, ASP, HTML

GUI: Oracle Jdeveloper 10g, Oracle Jdeveloper 9i with OA Extension, Oracle Forms 10g/9i/6i, Oracle Reports 10g/9i/6i, Oracle Discoverer 10g/4i, OBIEE 10.1.3.4, Oracle Application Express

Tools: SQL* Plus, SQL*Loader, Oracle SQL Developer, TOAD, ERWIN, XML/BI Publisher

Office Tools: MS PowerPoint, MS Word, MS ACCESS, MS Excel

Operating Systems: Win XP, Win NT, Linux, HP-UX

Professional Certifications: Project Management Professional (PMP) Oracle Database Administrator Certified Professional (OCP)

PROFESSIONAL EXPERIENCE:

Oracle ERP Technical Lead/Analyst/Developer

Confidential, Pittsburgh, PA

• Involved in successful implementation of project360-salesforce implementation. Acted as Integration Technical/Functional Lead for Integration between EBS and Salesforce.
• Participated in IT Change Management Strategy that includes multiple technologies and CAB meetings on Weekly basis.
• Strong troubleshooting, problem solving skills in EBS Instance, Database Tier/Application Tier, Concurrent Manager related issues.
• Enforced Development Standards in EBS area in Quarterly Projects, Bug fixes.
• Enforced Project Management Methodologies in Quarterly Projects.
• Involved in design and development of updating items costs thru Interface in oracle EBS.
• Involved in design and development of year-end pricing update for configurator related Items in Oracle Advanced Pricing.
• Involved in successful implementation of Oracle Configurator. Acted as Technical Lead for some of development components for new configuration models.
• Involved in successful Implementation of BRS (Bulk Receiving Process) enhancements in Depot Repair module.
• Responsible for day-to-day support of EBS modules (Financials, Manufacturing, Supply-Chain modules, Service Contracts, Rental Contracts, Depot Repair, Service Modules).
• Involved in creating project plans, risk related aspects of project management in some of internal and EBS projects
• Worked as Technical Lead on custom components and supervised development work done in offshore.
• Involved in successful implementation of Supplier Conversion for Germany
• Involved in successful implementation of ACH Capability to pay vendors via ACH
• Involved in setting up of GL Accounts, Bank Accounts, Payment Documents, Payment Formats
• Involved in design and development of Vendor Rating Form and score card report
• Involved in design and Technical Lead for several reports/customizations in financial, manufacturing, supply chain, Order Management, CRM areas.
• Managed a team of Oracle Applications DBAs working from Offshore.
• Facilitated weekly meetings with Oracle Apps and Oracle DBAs to discuss issues/changes/concerns.
• Actively Involved in Oracle EBS Patching (AdPatch/Adop) and Cloning activities.
• Actively Involved in administering Application (Security/Non-Security) Patches on Quarterly basis.
• Actively Involved in administering development standards in CEMLI components within EBS context.
• Strong knowledge of Oracle Database and Oracle EBS Architecture and other different interrelated components.
• Strong working knowledge of SSO (Single-Sign On) Flow and integration with Oracle OAM (Oracle Access Manager).
• Strong knowledge of Salesforce Administration.
• Strong working knowledge of IBM Cast Iron Integration Cloud Tool.
• Involved in managing Oracle EBS Instances as a part of support work.
• Involved in laying out new landscape for Oracle EBS environment as part of Oracle EBS upgrade.
• Involved in resolving Licensing concerns with Oracle Representative.
• Involved in resolving critical oracle issues with Oracle Support.
• Strong Experience in SQL, PLSQL and Oracle Development Tools.
• Extensively used FNDLOADER scripts for migration of concurrent programs, request groups, responsibilities from one instance to another.
• Extensively involved in creating UNIX Shell scripts to notify users of successful completion of user reports and receipt of report outputs as email attachments for review.
• Extensively involved in preparing user guides and Training users on new developmental tasks.
• Extensively involved in defining and documenting requirements and providing test scripts and User training.
• Worked on development of Various Reports as per user requirements.

Environment: Oracle Applications R12 (AP, GL, SLA, CE, CZ, AOL, OM, INV, WIP, WSH, OKC, IB, OKS, Oracle Service), Cast Iron, Web ADI, Oracle DB 11/10g, Forms 11/10g, Reports 11/10g, TOAD, SQL, PL/SQL, LINUX, Oracle BI Publisher, Service Desk.

Oracle Finance Analyst/Developer

Confidential, Winston-Salem, NC

• Involved in successful implementation of Automation of Daily and Monthly interface jobs (Premium Collection, Refunds, Overpays, Claims and Accruals)
• Involved in successful implementation of Automation of System Audit related reports to meet SOX requirements
• Involved in design and implementation of Tri-Tech Premium Tax File Processing Interface to generate TAX data files from PASSPORT application
• Extensively involved in initial phase of GL, AP, SLA, CE module setups as a part of R12 Upgrade Process
• Extensively Involved in analysis of implementing AP, GL, CE modules as a part of R12 Upgrade Process
• Involved in Successful implementation of BB&T bank accounts in Oracle Payables Module for processing of checks from different accounts to pay vendors.
• Involved in successful implementation of ACH Capability to pay vendors via ACH
• Involved in successful implementation of ACH Approval Process by generating various reports and email notification.
• Involved in successful implementation of setting up Cash Management (CE) to process BB&T and BOA bank statements in Oracle Cash Management (CE).
• Involved in generating NACHA File as per BB&T NACHA file specification
• Involved in generating Positive Pay File as per BB&T Positive file specification
• Involved in setting up ACH for vendors
• Involved in setting up of GL Accounts, Bank Accounts, Payment Documents, Payment Formats
• Involved in setting up of new GL periods for Accounting Calendar and Opening Encumbrance year.
• Involved in setting up of Expense Report Templates for various Operating Units.
• Involved in setting up new Operating Units as per user requirements.
• Involved in setting up vendors for reporting 1099 payments.
• Involved in successful implementation of GL Journal Approvals for Manual and Web ADI Journal Entries based upon Approval Hierarchy that uses seeded Journal Approval Workflow.
• Extensively tested EBS financial modules as a part of system UPGRADE to Oracle Apps 11.5.10.2 RUP 7 and assisted APPS DBA in finding relevant patches for known issues thru Oracle Metalink.
• Involved in raising SR (Service Requests) and follow-up with Oracle Support Team as a part of troubleshooting issues thru Oracle Metalink.
• Involved in assisting users in setting up Web ADI for processing Spreadsheet based GL journal entries.
• Involved in assisting users in generating 1099 for suppliers and subsequent e-filing to IRS (Internal Revenue Service).
• Involved in assisting financial manager in Month-end and Year-end closing process for a given financial year
• Worked on creating new Check Template as per requirements using BI Publisher.
• Worked on customization, development and support of MINT (Mortgage Insurance Newest Technology) application.
• Worked on customization of certificate enquiry form to enable users to query certificate information based on various criteria.
• Worked on development of custom oracle form for approving the Claim Advances for a given loan in Claims Business Area, a check request will be issued only upon Claim Advance Approval.
• Involved in Production Support of MINT application by resolving production related issues and interaction with function users.
• Involved in development/testing of various object modules (forms/reports/packages) as a part of Oracle DB upgrade for MINT/PASSPORT application.
• Involved in monitoring of daily/monthly jobs using APPWORX.
• Extensively used APPWORX to setup application module and chains for automation of reports and interfaces..
• Extensively used SERENA version control software package SBM (Serena Business Mashups) to maintain version control and log user requests and monitor subsequent time line of each request.
• Extensively worked on RICEW, AIM and CEMLI as a part of implementation.
• Extensively used FNDLOADER scripts for migration of concurrent programs, request groups, responsibilities from one instance to another.
• Extensively involved in creating UNIX Shell scripts to notify users of successful completion of user reports and receipt of report outputs as email attachments for review.
• Extensively involved in preparing user guides and Training users on new developmental tasks.
• Extensively involved in defining and documenting requirements and providing test scripts and User training.
• Worked on development of Various Reports as per user requirements.
• Extensively involved in providing various System audit related reports as per SOX requirements.
• Involved in System Admin activities like setting up users, responsibilities, functions and menu securities in all applicable instances.
• Involved in troubleshooting Workflow related activities using Workflow Administrator Responsibility.
• Involved in troubleshooting production issues on prompt basis.
• Loading and validating the external data, creating packages, functions and stored procedures accordingly for applying business rules.
• Extensively involved in writing Complex SQL queries, PLSQL objects, Database Design, Table Design, Data modeling and Performance Tuning.
• Developed Application Extensions BR-100s, MD50s, MD070s, MD120s and DO070 using AIM methodology.
• Involved in Performance Analysis, Coding, Testing and Troubleshooting and Support.
• Examined the existing information processing systems to evaluate their effectiveness and design and develop new systems to improve production and workflow.

Environment: Oracle Applications R12 (AP, GL, SLA, CE, AOL, HR), 11.5.10.2 (AP, GL, HR, CE, AOL), Web ADI, Oracle DB 10g, Forms 10g/9i/6i, Reports 10g/9i/6i, TOAD, SQL, PL/SQL, LINUX, Oracle BI Publisher, Serena Team Track, AppWorx.

Oracle Applications Consultant

Confidential, Herndon, VA

• Worked on development of a report (Orders on Check Hold by Collector) that shows the information of Sales Orders that are failed in Credit Check and placed on Credit Check Hold.
• Worked on Development of a report (Direct Debit Customers Bank Detail) that shows the information of the Active Bank Accounts available at the customer header level where the active primary payment method at the same level is Direct Debit.
• Worked on development of a report (Expired and Evergreen Lease Contracts) that analyzes the assets that evergreen or expired this way contracts can be tracked to ensure that Investor has been paid the agreed residual value at the end of contract’s primary term. This report is done by extracting data using PL/SQL package in CSV format.
• Extensively used XML Data Templates, SQL, PL/SQL (procedures, functions, Packages), BI Publisher in building Data Extracts and Reports
• Worked on development of a report (GL Trial Balance Year-to-Date and Period-To-Date Summary/Detail) that shows Trial Balance information based on each Account Type.
• Worked on development of a SOX Audit reports to implement Sysadmin audit facility for AR and AP tables.
• AR SOX Audit Report - Changed Records
• AR SOX Audit Report - Current Situation
• AP SOX Audit Report - Changed Records
• AP SOX Audit Report - Current Situation
• Worked on development of a report (AR Payments due Next Month) that shows future payment dues for receipt method.
• Extensively involved in Tuning SQL and PL/SQL (procedures, functions, packages) objects used for various reports.
• Extensively involved in writing Complex SQL queries, PLSQL objects, Database design, Table design, Data modeling and performance Tuning.
• Extensively used XML Data Templates, SQL, PL/SQL (procedures, functions, Packages), BI Publisher in building Data Extracts and Reports
• Extensively used Materialized Views to improve query execution and response times.
• Setting up Oracle BI Repository, Creating (Dimensions, Dashboard reports, Charts, Calculations) using Presentation Services in OBIEE (Oracle Business Intelligence Enterprise Edition) Tools.
• Extensively involved in Tuning SQL and PL/SQL used for various reports.
• Worked on Development of following reports using OBIEE (Oracle Business Intelligence Enterprise Edition)
• Sales by Calendar Year Product Category
• Sales by Calendar Year Calendar Month Country Region
• Worked on development of following reports by extracting data using PL/SQL package in CSV format
• AP Invoice Audit Report
• Po Internal Audit Report
• Expired and Evergreen Lease Contracts Report
• Intrastat (AP/PO) Input Detail/Summary Reports
• Intrastat (AR/OM) Output Detail/Summary Reports
• Worked on development of following reports using Oracle BI Publisher.
• AR Transactions Report
• AP Tax Distributions Report
• RMA Return by Reason Code Report
• Month-End Partial Shipments Report
• Serialized Item Inventory Report
• Worked on following Custom Reports using Oracle Discoverer
• Open Backlog Report
• Invoice Sales Report
• Open Bookings Report
• Open PO Receipt Detail Report
• Calibration and Asset Report
• Lot Detail Report
• Worked on development of (Meter Billing Control Report) that allows comparing Actual Billed Amount for copies (for both B&W and Color) of OKS Contracts based on the meter readings in a specific period with Estimated Amount (Accrual Amount) in the previous period.
• Worked on development of a report (All Contracts on Billing Hold Status) that lists contracts which are on Billing hold status as result of last billing run.
• Worked on development of The Rental Cash flow report will select invoices lines from Oracle Receivables that have a transaction type of ‘Invoice-OKL’, an invoice line description of ‘RENT’, an outstanding balance and are associated to an investor agreement.
• Worked on development of The Pareto Analysis - Aged by Credit Controller Report that reports the AR Outstanding unpaid commitment per customer by Credit Controller.
• Worked on following Oracle standard reports using Oracle BI Publisher.
• Packing Slip Report
• Sales Order Confirmation Report
• Certificate of Compliance
• Country of Origin
• Commercial Invoice Report
• Involved in Sys Admin activities like setting up responsibilities, functions and menu securities in Development, TEST and Production instances.
• Created Installation Shell Scripts and FND Loader Scripts for migrating objects from one instance to another.
• Developed Application Extension MD120s, MD070s using AIM methodology by reviewing MD050s and interacted with functional team to build technical extensions.

Environment: Oracle Applications R12 (OM, INV, PO, AP, AR, HR, GL, OLM, Install Base, Service Contracts, AOL), Oracle DB 10g, Forms 10g, Reports 10g, TOAD, SQL, PL/SQL, LINUX, Oracle BI Publisher.

Oracle Applications Consultant

Confidential, Rockville, MD

• Procure-to-Pay Custom/Personalized Contract Invoice Data Entry Form: Worked on customizing standard open interface invoices form using Custom.pll to centralize the processing of Contract-based Invoices and Purchase Order based Invoices which are essentially entered by Finance Personnel, coded (entering COA/POET Account Info) by Requestor of Service (ROS), or their Administrative Assistants (AA) and Approved by ROS on Customized Standard Payables Open Interface Invoices Form in Oracle Payables Module.
• Involved in setting up Project Templates, Expenditure Types, and Expenditure Categories in Project Accounting Module.
• Developed a Custom Form (Finance Contracts Maintenance) for Finance Contract Admin Group (FCAG) who can review the actual Fully-Executed contract to ensure invoice is within the financial Terms of Contract after they are presented with Contract Related Invoice.
• Worked on a Custom Workflow Background Process using Oracle Workflow Builder 2.6 which will send Oracle Workflow Approval Notification to ROS (Requestor of Service) associated with Invoice Whenever Invoice is Approved/Rejected/Disputed thru a Custom Zoom Form on Open Interface Invoices Form.
• Create a Concurrent Program “OTS Import Contracts” to load newly created contracts and related info in Project Contracts Module into Custom table sothat Finance Contract Admin Group can review these contracts on Finance Contract Maintenance Form. This program is scheduled to run periodically.
• Worked on creating customizations on Oracle Employee Self-Service Web-based applications using OA Framework Personalization.
• Worked on Purchasing/Invoice Reconciliation Report for Accounting Dept to be able to a 3-way match for incoming vendor invoices to existing purchase orders. With this report Users will be able to reconcile purchase orders that do not have a matching invoice and also they can reconcile invoices received that do not have purchase order entered for.
• Worked on creating a word template for Printing a Purchase Order based on Standard Oracle Purchase Order Report using XML Publisher.
• Worked on OKE: Enhanced Change Management Process in Project Contracts Module where modifications will restrict access to the contract value field once a contract is “Active” and force the user to enter the contract change amount using Custom.pll.
• Developed following Reports using Oracle Reports 6i in Project Contracts Module.
• Contract Summary Report
• Contract Status Detail Report
• Contract Amendment Detail Report
• MSA and Task Order Summary Report
• MSA and Task Order Status Detail Report
• MSA and Task Order Amendment Detail Report
• Created various Procedures, Functions, Triggers, Alerts and Packages in support of Procure-to-Pay process.
• Developed Application Extension MD070s using AIM methodology by reviewing MD050s and interacted with functional team to build technical extensions.
• Involved in training end users and resolving their outstanding issues.

Environment: Oracle Applications 11.5.10.2 (AP,GL,PA, Purchasing, HR, iExpenses), Project Contracts, Oracle Workflow Builder 2.6, XML Publisher, OA Framework Personalization, AOL, Discoverer 4i, Reports 6i, Forms 6i, TOAD, SQL, PL/SQL, LINUX

Oracle Applications Consultant

Confidential, Sacramento, CA

• Created an interface to load and validate the data from Application Tracking System (ATS) and Consumer Affairs System (CAS) into Cashiering Account Receivable System (CARS).
• Worked on passing the Report of Deposit Number from Cashiering Account Receivable System (CARS) to CALSTARS in electronic file through Electronic File Transfer.
• Developed procedures to create TCA (Trading Community Architecture) related data such as parties, party relationships, party sites.
• Developed a Revenue Refund Requests Form which can have multiple address fields to accommodate foreign Addresses using Forms 6i and integrated with Oracle Applications.
• Involved in writing SQL* Loader script and PL/SQL programs for loading, data
• Mapping, data conversions and validating the data into the staging/target tables from the Legacy source
• Modified Cashiering Account Receivable System (CARS) sothat Revenue Refund Requests (Claim Schedules) and Agency code print in sequence when Revenue Refund Request Report is run using Reports 6i.
• Defined customer profiles, customers, payment terms, payment methods and tax structures, including tax exemptions and exceptions in Accounts Receivables
• Interacted with application users and resolved production related issues.
• Extensively used AOL for registering concurrent programs, request sets, creating custom value sets.
• Created Object Installation shell scripts and Migration Scripts.
• Developed Application Extension MD070s using AIM methodology by reviewing MD050s and interacted with functional team to build technical extensions

Environment: Oracle Applications 11.5.9 (AR, GL, AOL and INV), Forms 6i, Reports6i, TOAD, SQL, PL/SQL, LINUX

Oracle Applications Consultant

Confidential

• Generated a Intrastat Data Extract that extracts data from oracle inventory that will be used for assist in GL in reporting intra-European movement of physical goods at Confidential Corporation.
• Converted the required Oracle Bill of Materials (BOMs) data from current Oracle 11.0.2 environment into Oracle 11.5.10 environment.
• Created a Subversion report that gives detailed information about revision number, file information, revision date, person who made changes to subversion and log messages.
• Created a Harmonized BOM program that will check to see if certain part number prefixes exist in the primary bill of material; if so, it would create a new alternate “GATT” bill of material based on certain criteria found in the GATT component table.
• Created a SQL Script that will scan all the objects owned by each user in the apps database and check for all the privileges that are assigned to APPS, if any privileges are granted to APPS, then those privileges should be granted to custom user and has to create a synonym in the custom schema.
• Extensively used AOL for registering concurrent programs, request sets, creating custom value sets.
• Created Object Installation shell scripts and Migration Scripts.
• Developed Application Extension MD070s using AIM methodology by reviewing MD050s and interacted with functional team to build technical extensions

Environment: Oracle Applications 11.5.10 (AR, OM, INV, BOM), Reports 6i, TOAD, SQL, PL/SQL, LINUX, SQL Loader

Oracle Applications Consultant

Confidential, Detroit, MI

• Created a custom form to enter heat details like heat no, cert site no, length for each lot number using Oracle Forms 6i.
• Implemented zoom functionality using Custom.pll on standard forms like WIP completion form, Miscellaneous Receipts.
• Extensively used Custom.pll to customize the changes in the PO form, Release Sales Order forms.
• Converted items and categories from Oracle 11.0.2 environment into Oracle 11.5.10 environment.
• Created a concurrent program to generate customs invoices for Canadian customers.
• Created a concurrent program to import Intercompany invoices into AR invoice interface tables.
• Interacted with end users and resolved their issues.
• Customized the following reports using reports 6i
• Pick Slip Report
• Bill of Lading Report
• Sales Order Acknowledgement Report
• Purchase Order Report
• AP Unmatched Receipts Report
• AR Invoice Report
• Created custom drivers in apps and prt files on UNIX for printing documents
• Extensively used AOL for registering concurrent programs, request sets, printers and custom drivers.

Environment: Oracle Applications 11.5.10 (OM, Shipping, AR, PO, WIP, AOL and INV), Forms 6i, Reports6i, TOAD, SQL, PL/SQL, LINUX

Oracle Applications Consultant

Confidential, Memphis, TN

• Developed Application Extension MD070s using AIM methodology by reviewing MD050s and interacted with onsite functional team to build technical extensions
• Created TE020 - Unit Test scripts which details the steps to test the extension.
• Developed the following reports using Reports 6i
• Corporate Accounting in FA Transactions
• Remarketing Inventory
• Remarketing Advance Termination
• Remarketing Evergreen Averages
• Developed the following reports using Discoverer 4i
• AR VAT Accrual report
• Remarketing Sales, Sales by model, Sales Summary, Income
• Extensively worked on registering concurrent programs and reports in AOL using standard APIs.
• Created Amortization schedule concurrent program and report.
• Created concurrent programs for CSARL EMP Outbound Extract and Terminated Contracts Paid-In-Full.
• Developed formulas to generate amounts necessary for accounting entries for Terminated Contracts.
• Customized the PO Account Generator, PO Requisitions Account Generator workflows using Oracle Workflow Builder.
• Responsible for writing Object Installation shell scripts and migration scripts.
• Developed Discoverer migration scripts using CYGWIN and customized the standard views in building the discoverer end user layer for ad-hoc reports
• Created Custom value sets for various reports.

Environment: Oracle Applications 11.5.10, (OLM, AR, GL, FA, and INV), Forms 6i, Reports6i, Workflow2.6, Oracle Discoverer4i, TOAD, SQL, PL/SQL, LINUX

Oracle Applications Consultant

Confidential, Byfield, MA

• Entered and processed various transactions such as Invoice, Debit Memo, Credit Memo and Deposit. Worked on Auto Invoice and Customer Interface, Entered Receipts and Receipt Information.
• Creation of SQL*Loader control programs and PL/SQL validation procedures to execute along with Customer Interface (AR), and Order Import Interface (OE) programs to support the interface requirements.
• Completed the Receivables Cycle by running the Concurrent Process to transfer transaction information from Oracle Receivables to Oracle General Ledger.
• Developed custom forms to view profile, Sales, Orders for a particular customer and integrated the form with the Oracle Receivables.
• Developed various reports such as Detail Payment reports in Reports 6i/Discoverer 4i with reference to Salesperson, Branch Level Transaction report and Customer’s outstanding report.