VIVEK SHARMA
SAP SD Vistex Functional Consultant
sharmaedp1 @gmail.com
*****.********@**************.***
SKILLS SUMMARY:
Around 11.8 years of comprehensive and strong professional SAP experience
on SD module with 3.5 years knowledge on vistex Pricing and Bill backs
chargeback Module.
Vistex:
DM Pricing: Worked on Price Sheets Badis related with pricing formula
profile, Enhancement Profile for Price sheets, creating a new access
sequence for price sheets, creating a new price sheets
Bill backs: Worked on claims, Bill back documents, creating a new Pricing
Procedure,
Creating a new Agreement types for claims and badis related to claims and
bill backs
Worked on Issues related to Accruals and settlement
Membership: worked on Membership workbench for creating membership, Viewing
Membership and have knowledge badis.
Chargeback: Worked Sales Tracing and chargeback Claim workbench.
Agreements: Worked on Agreement Request and Agreement workbench and well
versed with concept and badis related to Agreement workbench.
Rebates: Worked on two types of rebates in Vistex IP Module Purchase and
Customer Rebates .
FICO: Customized the GL Account related to FICO used for Bill back
posting.
EDI Idoc:
Have knowledge and on EDI 867 inbound idoc for creation on claims.
Worked on EDI 845 Inbound idoc for creation of Agreement
SD Billing:
. Invoices, Credit Memo, Debit Memo, Rebates, Individual, Collective
Billing, Inter-Company Billing and Invoice split.
. Expertise in MM and FICO integration Functionalities like Third Party
Order Processing Inter-Company Order, Inter-Company Stock Transport
Order, Subcontracting.
. Hands on Cross Module Experience of SAP SD Integration with MM, PP, WM,
FICO and CRM.
. Good knowledge in SAP ABAP, EDI/IDOC, ALE, BDC'S and BAPI'S.
. Efficient Team Member with Excellent Work/Time Management Skills. Cross
Functional Awareness. Excellent Leadership Communications and
Interpersonal Skills.
. Generation of mapping documents between SAP for EDI transactions (both
inbound and outbound), Partner determination and Output Determination,
Creation of Partner Profiles, IDOC extensions and IDOC types,
verification of outbound IDOC and of inbound IDOC, ALE, Work flow basics
and User-Exits.
. Master Data: Customer Master, Material Master, Customer-Material
information Records, Condition Record
. Pricing: Configuration of Condition Types, Condition Tables and Access
Sequences. Determining and Maintaining Pricing Procedure. Creation of
Condition Records, Condition Exclusion and Analysis of Pricing.
. Experience on Make-to-Order, Engineer-To-Order, Try and Buy(Demo) and
Returns process, Customer Contracts, Customer Service Orders
. Shipping and Transportation: Processing of Deliveries, Maintaining
Route Determination and Configuration for Picking, Packing and Post
Goods Issue. Configuration of Transportation Planning Point, Shipment
Types and Transportation Planning.
. Sap Abap: Certified in Abap 4.7c Strong understanding of Abap
Procedural Programming and Object Oriented Programming with Bapi and Badi
knowledge of debugging Sap Abap Program..
TRANINIG: Trained from VISTEX INC on DM Pricing Bill back and
Chargeback Module.
TECHNICAL EXPERTISE:
Languages ABAP, C, C++, SQL, Data Structures, Unified Modeling
Language, JAVA, and ORACLE.
SAP Versions SAP ECC 6.0, R/3 4.7 and R/3 4.6C
SAP Tools ALE, IDOC, EDI, BAPI's, RFC, TDMS, ALV, BADI, BDT, BDC,
LSMW
Operating Windows NT/95/98/2000/XP, UNIX, MS-DOS
System
RDBMS Oracle 8i, SQL Server 2008, Sybase 11, Access 2007.
EDUCATION:
. Bachelor Of Engineering (B.E) from University Of Madras,Chennai India
PROFESSIONAL EXPERIENCE:
Cardinal Health May 2012 toTill date
Dublin OH Sap Vistex Consultant
1 Project Name : DM project (USA)
Roles and Responsibilities: Manager Apps and Design.
Involved in Presales team as Vistex consultant and was leading a team of
10 guys.
. Created and helped Technical resource to identify Badi to correct this
piece of Logic for claims Mass claims Processing on GCRM for
correcting Net sales Value for Adjustment Code DN01 and Rej.Rsn C004
on Line item
. Worked on Mapping Issue for Inbound EDI867 for creating claims.
. Worked on Mapping Issue for Inbound EDI845 for creating Agreements.
. Purchase Rebates:
. Customization: Defining Number Ranges for Purchasing Rebate Document.
. Created a new Pricing Condition table for
Price determination process for
. Purchase Rebate.
. Created a new Agreement type (Purchase
Agreement) ZPPA type
. Defined IP (Accrual) for the Agreement
.
. Worked on PURCHASING REBATE WORKBENCH (/N/IRM/IPPRASP)
. Worked on Transaction /n/irm/ipcrm to create an IP document
.
. Worked on following items for /N/IRM/GCR37.
. Need the ability to work all rejections in mass
o We want to delete true C004 in the system
o Need to be able to add adjustment code AC02 in mass
o Need to be able to work A002 reason rejection in Mass
o Need to be able to highlight multiple lines, select correct agreement
for highlighted lines. Need to add "Additional Data" tab to GCR37
o Need column for "submitted purchase price" and "submitted agreement
price" by UM.
. Need the ability to enter a comment ( Comment field - text field )
. Need the ability to work the text field in mass, not just line by
line. Usually the text will be for many lines and current process is
for user to copy and highlight line and paste into all lines.
. Need the ability to cut and paste one or many columns of data, instead
of one cell at a time or having to export everything, in order to copy
and paste from /irm/gcr37 to /irm/gmlm
. Worked on Variance report with Issue where data line with TRC was
getting displayed.
. Corrected Issue on Variance report where we had to stop the output
which had more than .99c
On the report.
. Worked on Logic to throw warning message when we are connecting
different Levels in membership.
. Worked on Logic to get value of different Z fields when the value is
missing in Maintenance mode of GMLM .
. Worked on Upgrade from 60.C TO 60.D version on standard vistex related
objects.
. Have worked on worked on Archiving standard vistex tables and have
applied notes
To reduce the size of table/irm/ipargv related to agreement request.
. Business Warehouse : have worked to develop logic for BW extractor to
pull data from
From claims, Membership header and line item table from vistex related
tables.
PROFESSIONAL EXPERIENCE:
Farmland and Smithfield Jan 2011 to May 2012
Smithfield VA Sap Vistex Consultant
2 Project Name : Vistex Project (USA)
Responsibilities:
Worked as Team Lead for Smithfield and Farmland on DM pricing and Bill back
Module of Vistex.
Leading a Team of 5 people
Module DM Pricing:
. Created Functional Specs for Contract Pricing Enhancements.
. Created new price sheets for new enhancements as per new access sequence.
. Created a Functional specs for contract Pricing where if 2 agreements
are posted in contract pricing with duplicate condition records 2
condition record will update in condition table
Overwriting the 1st condition record.
. Created new Pricing condition type in SD pricing which will be used for
DM Pricing Condition Type.
. Created 4 new batch jobs for posting pricing Condition records at Sold to
level, Customer group Level which will run on different dates and update
the condition records.
. Created Functional Specs for Development of report for DM pricing
related called as Price List which will extract data from different
condition table of Pricing and give a detailed report
Related to Pricing for each material.
. Worked on creating a batch customized Z program which will update the
different price sheets
As per the run of the variants set up in batch job this was developed on
standard vistex
Pricing job /N/IRM/IPB15.
Bill back Module:
. Created Functional Specs for correcting error for claim which expensing
on the billing date to loading date as per sales order.
. Created Functional Specs for Creating new reason code on claim workbench.
. Created Functional Specs for new reason Rejection Reason code on claim
workbench.
. Created a new agreement type for Buy down claims.
. Created a new Pricing Procedure for Agreement type.
. Corrected Issue for claims in Badis where the claims which were posted
should have status 9 after posting but still were having status of 004.
. Corrected Issue for Rejection reason for claims in posting report for
each agreement.
. Worked on /IPBB23 AND IPBB22 batch transactions related mass updates of
bill back documents and agreements updates.
Environment: Sap 4.7C
State County Of Virginia Project Oct 2010 to Dec 2010.
New Jersey Sap SD Consultant
3
4 Project Name : Focus Project (USA)
Responsibilities:
. Creating sales document type for bonded product from bonded storage,
Order type duty paid from bonded storage, duty paid from duty paid
storage, sales of services, sales of scrap/non oil products. Development
of a New Interface between Harmony to ECC (FI system
. Assigning to Business service to scenario Bulk retail, return bulk
contaminated duty paid sales order, o Receive down payment, create
delivery, create delivery conformation, create billing document, clear
down payment against invoice value.
. Retail sales of CNG, retail sales of SKO duty paid stock, sales to
consumer from bonded stock o Lubes sales, lubes stock transfer, sales to
lubes distributor, issue of free goods, o Sales of aviation fuel, create
of exchange agreement type, Bulk sales, o Hydrocarbon stock transfer-
across division, with in marketing division across states, with in
marketing state office. contract, o Retail sales of MS& HSD duty paid
stock, retail sales of MS & HSD bonded stock, o Pricing- Pricing
procedure, condition type, condition records suitable to business
process, pricing shipment cost, pricing sale, promotion, rebate and
rebate settlement, o Sales through agent, sales to retail customer,
Transport contract payment, and transportation changes for crude,
hydrocarbon stock transfer inter company Developed Graphical Mapping for
The Interfaces.
. Configuration of various functions like shipping conditions, route
determination including the configuration of shipping types, modes of
transport, routes, transportation zones and stages, transportation groups
and loading groups
. Logistics configuration for shipping like picking, packing and goods
issue for outbound deliveries.
Environment: Sap 6.00
HP (USA) Jun 2010 to Oct 2010
Roseville, CA Sap SD Consultant
5
6 Project Name: Scitex on boarding Services and Support.
Responsibilities:
. Setup SD configuration for as required per the US template, which
includes, setting organization structure, various order types (sales,
returns, consignment), Bill of materials, setting delivery and billing
configuration.
. Proficiency in pricing applications including condition types, pricing
procedures, access sequences, accruals, scale pricing, commissions and
custom pricing tables. Provided pricing configuration and support for
complex make-to-order production environment. Familiarity with database
tables and data extraction.
. Roll-out encompassed six manufacturing plants which involved production
processes for make-to-stock and make-to-order consumer goods.
. Setting up interfaces with legacy systems that will be replaced
eventually, other interfaces include, sales logix, cupid, SAP CRM.
. Written specifications for enhancements for zero Pricing; this
enhancement is to set the status flag at Billing data set level, whenever
order is eligible for zero prices and set the commercial release flag
based on the zero price flag.
. Enhancement Frame Work: Extensively used new enhancement frame work
(Implicit enhancement) used to block the sales order creation from
customer interaction center and Standard, whenever there is a credit
block on the order, and used this technique to set other status fields
like Password required, Schedule Line generation error, Missing content
on ad spec etcWriting Logic in SAP-XI to route Repair PO to Fusion and
New buy PO for spare parts to Oracle.
. Logistics configuration for shipping like goods issue for outbound
deliveries. Configured the Shipment cost types and defined the Number
ranges for Shipment costs.
. Based on the client fs requirement to have the sales at micro zone level.
Worked on enhancing the Order Creation so that user will have an option
to choose micro zones. Whenever user chooses the micro zone order, the
enhancement triggers an extra surcharge price.
. Provided specifications for data migration using ALE and other inbound
and outbound transactions with EDI interface, provided enhancement
requirements for the IDOCS according to the business requirements.
. Responsible for blue printing, conversion and data migration, provide
custom reports,
.
.
. Environment: Sap 6.00
7
IBM Oct 2009 to Dec 2009
India Sap SD Consultant
8
9 Project Name : BSL PROJECT: SAIL (Steel Authority of India Limited)
Responsibilities:
. Configured sales BOM's (pre-packs) and material grids necessary to
support the product range of the client. Handled bundle SKU's issues,
pieces versus cases conversion in orders via EDI.
. Involved in Bulk contracts setup and handled EDI Bulk and release orders.
. Configured pricing procedure for various document types.
. Provided SAP functional knowledge for technical and functional design
sessions / meetings covering Orders, Delivery, Picking, Packing, Shipment
documents, and shipment costing.
. Gather user requirements and maintain material master conversions from
legacy and update of relevant fields of interest to the organization.
. Facilitated team discussion in the design of the SD Organizational
Structure, Order management (order types, item categories, and schedule
line categories), bulk contracts, pricing configuration, billing, invoice
consolidation, and SD Output Determination.
. Maintained credit management check at all points in the sales order
cycle.
. Worked with GIS team in implementation of feasible solutions in complex
EDI scenarios specific to clients business.
. Worked on providing mapping for 850, 856, and 810 in both outbound and
inbound scenarios. Other EDI transactions include warehouse messages,
945(WHSCON), 944, 943, 940(WHSORD) and 820(REMADV) inbound and outbound,
816, 812, 860(ORDCHG) inbound, 832, 997(SYSTAT01), 864, 855 IDOC mappings
with GIS system and coordinating custom developments (User exits
specifications and necessary logic) with both offshore and onsite
developers.
. Setting up Partner Profiles, RFC destinations, EDPAR Table, EDSDC Table
and NACE (For Output Trigger) in SAP
. Developed test cases and involved in integration testing with transport
vendors, customers and agents.
. Provided specifications for custom reports and custom developments in
exits and dialog programs based reports for UPC based information
extraction.
. Involved in setting up allocation run, setting default tables, site
groups, distribution center, synchronizing the tables for order changes.
. Value added service procedure determination and assignment for different
document types
Written functional specifications for customized reports involved in
testing RICEF objects and perform go-live cutover activities
. Functional Specification for Enhancement is done for Sales Order
processing in VA01/VA02 transaction or substitution of tax jurisdiction
code during intrastate transactions Reports.
. Functional Specification for Development of a report to delete equipment
BOM and BOM long texts.
. Functional Specification for Development of a report to upload Equipment
Characteristics
. Functional Specification for Development of procedure to archive and
delete Equipment Master Data.
. Functional Specification for Development of Backlog report in SD.
Environment: Sap 6.00
10
IBM Apr 2008 to Sep 2009.
India Sap SD Consultant
11
12 Project Name : Nestle America.
Responsibilities:
. Provide Support, business process Analysis for integrated SAP (Magellan
system) worldwide delivery environment adhering to the business
compliances. Lead a small team as part of the Project drake.
. Testing enhancements in the posting programs and interfaces between SAP
and third party systems.
. Worked on providing pricing notifications to aviation customers based on
aviation formulas and helped in smooth transition from their legacy
system, a MS- access based Pricing database to another third party system
called PRINOS.
. Worked with aviation pricing analyst in training her to use simple
queries in SAP to extract necessary information.
. Worked on aviation?fs legacy challenge to justify their current processes
and to help aviation to adapt to their ongoing transition to GSAP (4.7
version).
. Work with offshore team in designing key performance indicator (KPI)
reports and other modifications to existing SAP system.
. Worked with business tax consultant in configuring taxes (sales, use,
fees, VAT etc.) for Visiting international customers in Atlas-SAP system,
validate SAP tax configuration, billing, revenue recognition and testing
on Project drake.
. SD liaison to project team for full lifecycle implementation for Century
located in Hickory, NC. The company manufactures custom make-to-order and
make-to-stock furniture products supplying retail stores worldwide.
. Responsible for pricing configuration and Variant Configurator
programming for diverse, make-to-order product lines with variable base,
options, and promotional pricing.
. Provided sign-off?fs on the Final acceptance testing (FAT) and user
acceptance testing of the enhancements and reports.
. Implemented resource related billing for the SERP project.
. Worked with Basis team to obtain proper security authorizations for the
users to access, run various reports and to use different screens in SAP.
. Provided process and functional analysis for implementing the advantage
contract pricing specific to aviation business.
. Areas of work include process testing among SAP and various shell
interfaces (including EDI transactions) to third party systems such as
logic raft, one hub, and Atlas, monitoring and addressing production
issues and support tickets.
. Working knowledge of mercury and live link.
. Provided operational and analytical support to the development and
execution of business group objectives, setup project timelines, and send
status reports to achieve the project deliverables within the stipulated
timelines.
Environment: Sap 6.00
IBM Jan 2008 to Mar 2008
India Sap SD Consultant
13 Project Name : Arla, Denmark
Responsibilities:
. Prepared functional Detail specifications (FDS) for reports,
conversions, interfaces, enhancements and forms for OTC (Order to Cash
Processes
. Identified SD configuration, which will impact ECC 6.0 and expand the
scope of configuration by SAP such as Text Determination.
. Configured Sales & Distribution involving Sales Quotations, Orders,
and Contracts, Shipping, Billing and interval scales for conditions.
. Configured Billing components comprising billing document types,
Invoices based deliveries and services, Periodic and milestone
billing, and Collective processing of billing documents
Environment: Sap 4.7C
IBM Aug 2007 to Dec 2007
India Sap SD Consultant
14 Project Name: PepsiCo Together, Egypt
Responsibilities:
. Involved in configuration of SAP SD business processes in Order to Cash
and support for the production systems.
. Provided EDI development and testing which included creating output types
for order confirmations, ASN fs, Invoices.
. Involved in order management, configuring sales document types, item
categories, and bulk contracts, copy controls.
. Pricing configuration, Billing, sales revenue recognition credit and
debit memo configuration, invoice split and returns order
. Material master maintenance and update and extension of material views
necessary for the organization.
. Provided functional specifications for RICEF objects, and LSMW routines.
Worked on delivery requirements, and interfacing with WM team for
picking and packing process
. Configured Route determination that includes modes of transport, shipment
types, routes and stages, transportation connection points,
transportation zones, transportation groups
. Configured transportation planning, individual and collective shipments,
transportation legs, freight costs, planning profile, preliminary
secondary leg determination shipment documents
. Configured shipment costs processing by defining the shipment cost types
and item categories, number ranges for shipment costs. Worked on freight
costing, freight payables, freight payments
. Configured output determination for advance shipment notification,
delivery note, shipping label and shipping instruction using condition
techniques
. Worked on inbound and outbound IDOCS creation and testing, this included
creating output types for order confirmations (855/ordersp), ASN fs (856-
DESADV), Invoices (810-INVOIC), order changes 860(ODRCHG), 830, 850, 862,
824, 997(SYSTAT01) 820(REMADV), 861(gsverf01), DELINS, DELJIT(98A),
DELFOR01A messages.
. Developed various test scripts and as a team member actively involved in
testing phase of the project in which exclusively did integration testing
and regression testing
. Documented test cases, and tested various scenarios using mercury test
director.
. Set up trading partners in INOVIS and GXS VAN fs and thorough integration
testing of the EDI system with customer. Helped in training and
conduction user acceptance testing and signoff on developments.
. Product was roll off to nine plants across North America with
simultaneous go lives in each plant within an interval of eight months
which included go live support and any immediate developments required.
. Provided structured documentation, user training, knowledge transfer, and
handover to IBM Germany, which is a global partner of Hydro in post go
live support.
. Rebate processing for turnover discounts, billing and posting to FI.
. Defined Pricing Procedures with associated Condition Types, Condition
tables, Access Sequences for automatic pricing during Sales Order
Processing and Billing Stage.
. Worked on availability check and transfer of requirements.
. Worked on value contracts process and pricing procedure determination.
. Billing and inter-company financial transactions from SAP were issued via
idoc message type INVOICE02
. Worked on Output Determination, Account determination in SD.
. Created Invoices, Pro-Forma Invoices, Credit, and Debit memos.
. Giving technical specifications to ABAP programmers for designing Inbound
Interfaces & reports based on the requirements.
. Analysis and recommendation of Customer Installed Base tracking
. Assisted in the composition of post go-live documentation to aid in
the continuing support of the SAP implementation. Assisted in training
junior consultants. Transfer of knowledge of order entry, delivery,
billing, purchasing, and reporting to the client
. Preparation of Technical Specification.
. Design and coding of interface programming BDCs for MR21, FB01, MM01,
FB60, XK01, XD01, F-32. BAPIs for FI automatic posting and goods
movement.
Environment: Sap 4.7C
Siemens Jan 2007 to Jul 2007
India Sap SD Consultant
Project Name : NTPC, NOIDA (U.P)
. Responsibilities:
. Analyzed and verified existing 4.6C and 4.0B OTC functionalities &
Documented SD existing 4.6C and 4.0B business process in detail.
. Translate business requirements into SAP functional and configuration
requirements for OTC Process.
. Documented SD custom 4.6C and 4.0B transaction codes, user exits,
function modules, reports & queries as part of upgrade analysis.
. Executed all SD custom programs on new ECC 6.0 environment to verify
execution process.
. Prepared functional Detail specifications (FDS) for reports,
conversions, interfaces, enhancements and forms for OTC (Order to Cash
Processes)
. Identified SD configuration, which will impact ECC 6.0 and expand the
scope of configuration by SAP such as Text Determination.
. Configured Sales & Distribution involving Sales Quotations, Orders,
and Contracts, Shipping, Billing and interval scales for conditions.
. Configured Delivery processing (Delivery types, Delivery item
categories, copying controls, number ranges).
Siemens Oct 2006 - Dec 2006
India Sap SD Consultant
Project Name: HONDA, GURGAON (HARYANA).
Role: SAP Techno Functional Consultant
. Responsibilities:
Module: FI Implementation
. Prepared Functional design documents
. Development of Reports for Purchase Register.
. Development of Reports for Component Sales Register.
. Development of Reports for Asset Register.
. Development of Reports for Export Sales Register.
. Development of Reports for Scrap Sales Register.
. Development of Reports for Domestic Sales Register.
Environment: Sap 4.7C
Unilever June 2005- Oct 2006
India Sap Consultant
Responsibilities:
. Involved in modules SD and MM with version 4.6C.
. Preparation of Technical Design Documents.
. Preparation of Unit Test Plan document.
1 Reports
. Created an Interactive Report for displaying plant status report to know
the status of a particular material for a particular period
. Created a report to display the details of all sales order including
customer details, net amount, document no, invoice no, material
details.
. Developed goods receipt report to with details like material document
number, material Document year, item number, quantity and unit of measure
in ALV.
2 SAP Scripts
. Modified existing programs to satisfy customer's requirements.
. Extensively worked on company logo, objects, text ids and header texts.
3 SAP Smart Forms
. Migrated standard SAP script for purchase order to smart forms and
modified the layout set according to Requirement of client.
Environment: Sap 4.7 c
Siemens June 2004 - June 2005
India Sap Abap Consultant
2
3
4 Responsibilities:
. Developed reports in material master that outputs material valuated
stock, grouped by Material type & plant. The output shows material
number, storage location, unit of Measure & description.
. Developed a report to list the first 100 purchase requisitions at the
plant 'pl01'(table EBAN) amd make it possible to change the purchase
requisition itself from the list by Clicking twice on the row or by using
a push-button.
. Developed a report to get different quantities like order quantity,
delivery quantity and Balance quantity based on the conditions specified.
. Developed a report to display purchase order details. The output shows
change date, Username, time, purchase order name and vendor code.
. Developed a report to display the user last login date and time using sub
screen Selection (user name, last login date, class belongs to).
. Developed a report to list Sold to party & Ship to party based on
selection criteria of Sales organization, Distribution Channel & Sales
Office.
. Developed a report in SD module such as sales order report, which covers
all Organization levels, delivery status, invoice status, shipping
details & partner function Details.
. Developed the interactive report that displays sales order information
like sales order Number, sold to party & delivery status. The detailed
list gives item data & item delivery Status.
. Developed a report to generate sales document details, the report lists
all the sales Orders as per the selected date range, sales order no.
and/or order type by the user. List displays all the order details along
with delivery & billing.
5 BDC:
. Developed an ABAP/4 conversion program to extract the data from Legacy
System for Vendor master data transfer. LSM Workbench was used in this
conversion.
. Developed a BDC program in MM to load material master data from legacy
system to SAP system. Developed a BDC program in SD to update the records
in the sales order Screen.
. Used LSMW to update Customer Master Records with transaction recording.
6
SAP SCRIPTS:
. Developed a layout to display vendors order details from ALV report.
. Developed a layout to display the details of MM purchasing details
similar to ABAP Query details in layout.
. Environment: Sap 4.7c
NON-SAP PROJECTS:
8
Binary Semantics Ltd Aug 2002 - May 2004
India Developer
9 Project Name: Parser Program
10 Responsibilities:
. Developed Auto Scheduler.
. Unit Testing
Environment: Windows 2000, VB 6.0, Oracle 9i
Elogix System Ltd Jun 2001 - Aug 2002
India Developer
11
12 Project Name: Wireless Application and Control System
(WACS)
13 Responsibilities:
. Designed and developed a product for WACS, USA, on ORACLE 8i and Visual
Basic 6.0.
. Developed a portal for consumption and billing details for the electrical
power supply.
. Environment: Windows 2000,VB 6.0, Oracle 8i