BBS, Inc. 

Putting the information and technology pieces together....to build your strategic future.


 

Johnson & Johnson - PowerBuilder / Oracle Projects:

Return to Previous Page

From To Accomplishment

Sep-01

Feb-02

  • Provided analysis and design consulting services to remote developers migrating the PB Field Sales Data Maintenance application from PB v3.0 to v7.0

Jan-00

Mar-00

  • Analysis, Design and Implementation of SVO v6. This version required additional processing logic and supporting tables to support Independent Sales Reps, customer territory assignments and Divisional Manager Compensation. Implemented functionality to allow the user to schedule re-posting of sales as necessary. Entire re-write of Sales Posting of End-User Sales was also implemented.

Feb-99

Mar-99

  • Analysis, Design and Implementation of SVO v5. This version required additional processing logic and supporting tables to support the increasingly complex business rules. Integration of Electronic Report distribution using HTML report format.

Aug-98

Jan-00

  • Planned Y2K Test Design and Executed Y2K Testing for a number of PowerBuilder / Oracle applications. Off-site support for actual turn of events for Y2K.

Mar-98

Mar-98

  • Analysis, Design and Implementation of a small PowerBuilder application which performed an upgrade to the dial-up component of the Field Sales Rep's PC in order to comply with a corporate mandated network upgrade. Performed this upgrade remotely with little user knowledge.

Feb-98

May-98

  • Analysis, Design and Implementation of a PriceList Application. This application used various Oracle components from the Contract Development System to produce customer price lists based on their unique contract terms.

Feb-98

Mar-98

  • Analysis, Design and Implementation of SVO v4. This version required an upgrade from PB v3 to PB v5 and from Oracle v6 to Oracle v7.3 Additional processing logic and supporting tables were implemented to support the increasingly complex business rules.

Jul-97

Nov-97

  • Analysis, Design and Implementation of a PowerBuilder v5.0 / Oracle application to perform what-if analysis sales histories and future Contract pricing terms to develop Pricing Contracts. The Contract Development System utilized the first HTML-like interface for a PB Application. Involved the design and implementation of a number of stored procedures and associated processes to perform the necessary calculations in a three-tiered architecture in order to free up the client workstation while processing occurred.

Feb-97

Mar-97

  • Analysis, Design and Implementation of SVO v3. This version required complete re-architecture of the batch posting process of sales due to the complexity of the business rules. Re-written to make use of stored procedures, packages and called Oracle functions. Front-end application was also enhanced to perform some process for Divisional Manager Commissions.

Dec-95

Jul-96

  • Analysis, Design and Implementation of SVO v2. This version accommodated two types of sales reps - Instrument and Neuro Specialists each with different commissions formulas. Also added processing for Annual and Semi-Annual Bonuses.

Jul-95

Jul-95

  • Developed and Implemented the first Production PowerBuilder Application - Sales vs. Objectives v1.

Jan-95

Jul-95

  • Analysis, Design and Implementation of the first client/server application within Codman. The Sales vs. Objectives v.1 (SVO) application automated the process of setting objectives and tracking actual sales to those objectives at a Product Franchise level. Sales Rep Commissions were calculated bi-monthly based on sales actuals and objectives. Assisted with setting PB and Oracle standards.

 Top    •    Return to Previous Page


Send mail to webmaster@bbsystems.com with questions or comments about this web site.
Version 2.3 Last modified: 10/08/02