cellconsult.com - the test company
Welcome to cellconsult.com
Your Partner for Software Testing
Non quia difficilia sunt non audemus, sed quia non audemus, difficilia sunt
A-1010 Vienna, Austria | Formanekgasse 12-14 / Stiege 1 / Tür 2
Mobil +43 660 6100 660 | Fax +43 (1) 25 33 0 33 8831
office@cellconsult.com
Mission Statement, technology environment, computer systems, marketing plans, rapidly changing market trends and technologies, challenges of the market, implement new software, introduce new services,
software development and techniques, manage those risks
Application Testing, Requirement Review
hidden, redundant and/or excessive requirements we analyze your existing requirement documents
Four levels are identified and examined: Business Requirements, User Requirements, Functional Requirements and Non-Functional Requirements. We make your requirements traceable for Specification Analysis, Acceptance and Change Request Assessment.
Specification Analysis
We ensure that your requirements are adhered to by reviewing the specifications before approval, so differing expectations and resulting disagreements can be prevented from the very beginning. Additionally specifications have to reflect implicit requirements - like compliance with national and international regulations and recommendations - that may have been unspoken but are nevertheless mandatory.
Use Case Extraction & Test Case Creation
Use Case Extraction is a modeling technique used to describe requirements from the user's point of view in a categorized, systematized and retraceable way. Use Cases make requirements testable. Subsequently Test Cases are created by combining Use Cases with Test Data. A Test Case explains exactly what values or conditions will be sent to the software and what result is expected.
Test Planning
Our Test-Engineers develop custom-tailored test-plans that encompass human- and time resources as well as test calendars. In addition the test plans contain the general test strategy and the prioritization of test activities (risk first).
Generation of Test Data
Test Data is essential for executing Test Cases. Our Test Data is built in a way that the testing effort can be minimized. The advantages of generating test data are: approved & standardized input, independence of real data, time & resource savings, reusability, large amount of test calls, intentionally erroneous calls
Test Execution
We use dedicated test environments for each test area synchronized by master test plans and scheduled by test calendars. The goal is to simulate the reality during a defined time-period. Even under extreme time pressure our experts are able to accomplish your objectives.
Documentation & Reporting
As a matter of principle we keep detailed and systematic reports and documentation on the test services provided.
Requirements Management
Requirement Analysis
In the beginning it is of utmost importance to define needs, goals and objectives, identify stakeholders and interfaces and realize the visions and expectations of the customer. Only then we collect the requirements of all stakeholders and assemble them. To accomplish this target we provide experts who fully understand your functional requirements as well as the importance of non-functional and supplementary requirements.
Use Case approach
From our experience we learnt that the Use Case method is the most effective way to achieve best practice in managing requirements. Use Cases help to manage complexity, provide a basic groundwork for requirement- and specification documents, user and training manuals and Test Cases.
End-to-end Traceability
To avoid that your Requirements get lost on the way while your project proceeds from the initial Requirement creation to the Technical Specification and on to the Test Phase, you have to make them retraceable. Using Requirement Management tools enables us to integrate Requirement Management-, Error Tracking- and Test Management processes to detect the loss. A Requirements Traceability Matrix will point out where Requirements are missing and/or specification documents are incomplete. In addition traceable Requirements are a powerful instrument to distinguish between valid and questionable Change Requests..
Test Management
Test Suite Implementations
We support the management of Test Suites from all prevalent vendors for Load Tests, Performance Tests, GUI and API Tests, Application & Web Tests. Our consultants work with you to create a tailored implementation plan covering initial project assessment, rollout, mentoring, training and administration.
Change & Release Management
Change Management Tools are vital for tracking the versions and the reasons behind the changes. Integrating software changes into our test strategy at an early stage of a project leads to improved flexibility, reliability and speed.
Version Control and central storage of software ensure that correct versions of the software are tested and rolled out.
Design of Acceptance Criteria
Our experts will create Acceptance Criteria and Guidelines to ensure that the delivered products correspond exactly with your requirements.
Management of Test Environments
The careful planning of Test Environment architecture is crucial for running tests efficiently. Our Test Engineers have long experience in designing and maintaining dedicated test environments for each test area, working with a master test plan - synchronizing end-to-end tests using multiple environments simultaneously, scheduling tests in test calendars - for coordinating time dependent test-cases while aging a test-environment and exchanging data between test environments - for subsequent test activities in other environments avoiding redundancy and saving time.
Error Tracking
We provide the evaluation, installation & configuration and training of automated defect tracking tools including the design of role-models, state diagrams and error classes. Defect tracking is extremely useful for risk assessment. Used as a knowledge database the collected information facilitates help-desk support after roll-out.
Training & Coaching
To support you in introducing professional test processes to your company we provide goal-oriented training on test methodology and test tools. After finishing the training your staff will be capable of mastering the daily test challenges. For individual problems high-level coaching is provided on demand.
Test Data Generation
Generated Test Data has a couple of benefits you cannot neglect.
It is "virtual" so you have no legal obstacles in using it
It can be generated on demand. No tedious extraction from your production system is necessary
It can be intentionally erroneous so negative test cases can easily be tested
Our tools are so flexible that other formats & protocols can be easily generated after a preparation phase of a couple of days.
Analogue Mobile Network - Motorola (TACS)
GSM - Nortel, Siemens
GPRS - Siemens/Alcatel
WAP - Siemens
PSTN - Siemens
IP - Siemens
GSM-IN - Siemens/Alcatel
SMS - Nortel, Siemens, Materna
Content Application - Materna, Alcatel
TAP2/2+/3 - ITU
Quality Management
We offer support for internal Audits and analysis. Based on the collected information we set up an ongoing coaching of an integrated quality management system (e.g. based on ISO 9001:2000, ISO 14000, etc.).
Process Management
Process Design
In the phase of process design we setup key performance indicators (KPI's) to measure and control the processes. The KPI's are often used as input to a Balanced Score Card for the Top-Management. Additionally we offer enterprise specific trainings for process management.
Process Analysis
We analyze your legacy business processes, perform process consolidation and design target business processes based on new requirements.
Process Compliance
We check the compliance of your business processes to common and applicable standards or business process frameworks like eTOM.
Revenue Assurance
Methodology
Our Revenue Assurance methodology focuses on the key areas of your business, where our systems integration skills and in-depth knowledge of communications business processes can recapture the richest pools of revenue losses. Our end-to-end view of business architecture covers both - business support systems and operational billing systems.
Switch to Bill Audit
Our tests encompass all services and challenge the system's ability to rate effectively by targeting all possible rate plans. This might include hitting peak and off-peak hours, as well as positive and negative testing to determine which calls should or should not pass through the system. Our experts monitor systems for possible revenue leakage, focusing on four main areas: switch integrity, message processing, roamer verification and bill audits.
CDR Verification
Regardless of the tool used during switch verification, the general premise is the same. Test calls are typically used to check the switch's performance. While many providers still may determine their test call patterns manually, some tools do this automatically. Others may decide to simulate calls to avoid the expense of actually running test calls. Cellconsult is supporting both alternatives.
Revenue Stream Integrity
We deploy a testing system with our experts and run continuous end-to-end testing, providing you with the results you need to validate the integrity of your revenue stream. This allows you to quickly recover lost revenue, create a self-funding program, benchmark these results against the results of the industry, and improve the quality of your customer bills.
Fraud Detection Enhancement
We have the expertise to generate fraudulent call data rarely occurring in the network. This particular knowledge enables us to check fraud systems exhaustively and to find even the proverbial needle in the haystack.
To avoid hidden, redundant and/or excessive requirements we analyze your existing requirement documents. Four levels are identified and examined: Business Requirements, User Requirements, Functional Requirements and Non-Functional Requirements. We make your requirements traceable for Specification Analysis, Acceptance and Change Request Assessment
For the Euro conversion of SiMobil's billing system Cellconsult developed a Basic Euro Concept and Impact Assessment including the collection and definition of all requirements. The creation of flow-cases for external interfaces and the development of financial test cases guaranteed the seamless crossover from the Slovenian Tolar the the Euro
Cellconsult planned and executed acceptance tests for the implementation of Telekom Austria's new billing system. Our objective was to accompany requirement and specification phases, carry out the user acceptance tests and help the customer to replace IP, IN and wireline systems to provide a convergent bill for his subscribers
Managing Director of Cellconsult was interviewed by Austria's business magazine Wirtschaftsblatt. "...Cellconsult performs in-depth tests on billing applications. For this purpose we simulate up to 500.000 call scenarios to ensure rating and billing functionality and correctness. So loss of revenue can be avoided from the very beginning..."
Our experts were assisting tele.ring with the implementation of a new billing system starting in the year 2000. Cellconsult was responsible for the design and execution of modular tests and the overall acceptance test. System patches and successive releases of the new software were also tested by us until 2002
Cellconsult supported the introduction of a new convergent billing system at Mobilkom Austria. For this purpose we developed a test-case repository and tools for the generation of test usage. Our experts performed end-to-end tests and the acceptance test for the first and several subsequent software releases
Project System Integration Test (SIT)
Goal of the project was the replacement of the current Hutchison3G Chordiant based CRM system with PeopleSoft CRM.
The project has been delivered in two phases, phase one replacing all technical workflows for order management using OMQore and mapping current business process functionality available through DasCore/Tom and TOC onto the PeopleSoft model. Basically, every function, that has been available with these systems, has been replaced by PeopleSoft CRM.
The second phase has involved the replacement of CCAA UI and Chordiant and the introduction of brand new functionalities such as hierarchical billing accounts.
The testing process was the key for ensuring that all systems were integrated correctly and that process flows were integrated on a complete 'end to end' basis.
The testing lifecycle could be kept up in every project stage from completion of business requirements to the development phase, see V-Model.
Since the integration of PeopleSoft CRM was such a large endeavor, touching every part of the business support environment and communicating with most other business support systems was necessary to divide the test project into specific focused areas, mainly determined by business processes:
Acquire & Register Customer
Billing Account Management
Service Management
Mobile Number Portability
Prepaid and Voucher Management
Logistic
System Management
Reviews of functional specification have been one of the most important tasks for Cellconsult to prevent requirement defects from occurring.
During the System Integration Test (SIT) a complete end-to-end test has been performed on an environmental level, ensuring that the test systems were communicating and working in accordance to the customer's requirements and specifications.
The SIT approach has been based on the Chordiant centered environment. So Migration was an essential part of the project and has been tested in two phases: the test of the data migration itself and the test to guarantee correctness and consistency of the migrated data.
Additional details
Acquire & Register
Search for Profile
Validate a Customer
Create Consumer Prospect
Create Consumer Customer
Convert Consumer Prospect to Customer
Create Contact – Authorized Contact
Perform Initial Credit Check
Create Business Prospect
Create Business Customer
Convert a Business Prospect to Customer
Create Contact – Business Administrator
Update Result of Financial Stability Check
Maintain Customer / Contact Profile
Break Relationship between Contact and Customer
Create Hierarchical Customer
Billing Account Management
Create Billing Account
View Account Information
Maintain Billing Account
Take Ad Hoc Payment
Create Payment
Allocate Payment
Take Payment from Suspense Account
Apply Adjustment
Apply One off Charge
Service Management
View Installed Products and Service Attributes
Add Service
Remove Service
Suspend All Products and Services
Reactivate All Products and Services
Change MSISDN
Raise Insurance Claim
Change Device
Change Tariff
Change USIM
Compete Retirement
Complete Termination
Return Handset
Suspend Services and Blacklist Handset
Contract swap
Mobile Number Portability
Port In
Maintain Port In
Port Out
Maintain Port Out
Port In/Port Out Monitoring
Prepaid and Voucher Management
Create Prepaid Customer Registered
Create Prepaid Customer Anonymous
Check Voucher
System Management
Availability
Storage and Disaster Recovery
Second Level Support – Response Time
Security
Permissions
Ongoing System Integration Test / End-to-end Test Support
from 04/2006
for the following systems
Peoplesoft CRM
EAI
Billing & Payment (SinglEView)
Euro Conversion Project for si.mobil (Vodafone Slovenia)
The night from December 31st, 2006 to January 1st, 2007 si.mobil had to switch over to Euro currency. Our goal was to ensure that no functionality was lost and the business processes of si.mobil could continue without interruption.
Requirement Inspection
Compliance with Council Regulation (EC) No 1103/97 of 17 June 1997, the Rules of the Central Bank of Slovenia, and other legal requirements
System Requirement Specification according to ANSI/IEEE Standard 830-1984
Test Planning according to IEEE 829
Test Cases according to IEEE 829
Highlights of the project:
Conversion rate of 239,640 (complex rounding scenarios)
Any action done in 2007 referring to a transaction made in 2006 (SIT) had to be made in EURO. This applied to
Payments (cash, direct debit, credit cards)
Reversals
Refunds
Backouts
Manual Cash Allocations
Fund Transfers
Adjustments on any level
Credits
The time frame was extremely tight (September to December 2006, "Big Bang" solution)
Interfaces
The following interfaces had to be analyzed for possible impacts and amendments:
SAP Interface
Direct Debit Extract File
Credit Card Extract File
Direct Debit Answer File
Shop File
Credit Cards Input Files
Incoming Cash Announcement
Incoming Cash Confirmation Announcement
Incoming Cash Confirmation
Dunning Letter
Billing Interface
Customer Referred to Collection Agency
ASPI Interface
Data Warehouse
MAX Interface
Cellconsult.com supported Telekom Austria with the introduction of the new Billing-System "MaxBill" (Phase 1) from November 2002 until April 2004. Among our tasks were the conception, preparation & execution of the integration & acceptance test. In addition we were responsible for the installation and maintenance of requirement-management and test-tools. These programs were enhanced and their functionality extended by our own developments in the course of the project.
The following services were rendered by Cellconsult during the project (in extracts):
Test-Tools
Installation und administration of Rational "RequisitePro" for the collection of requirements
Installation and administration of the error management system Rational "ClearQuest"
Installation and administration of the Rational "Testsuite"
Test Data Generation
Generation of test data for rating and billing and for all external interfaces
Development of scripts for the data generation tools in particular for the generation of test customers for "MaxCare" test
Test conception, design and test execution
Development of a test-concept based on Use Cases for the acceptance tests of the delivered MaxBill components ("MaxAdmin", "MaxCare", "MaxGen", "MaxRate", as well as the product catalogue and all related interfaces)
Creation of Use Cases based on delivered DFS, ATP and ATS. Development of test scenarios and related test scripts. In total over 840 Use Cases, 3,000 Business Objects, 6,200 Validation rules & constraints and 53 Actors were identified for the following acceptance test
Conception and design matching of the Error Management System for ClearQuest
Organization of training
Organization of DFS-Review workshops including analysis and amendment of requirements and specifications
Execution of "sanity tests" for delivered test environments
Supervision of development processes and attendance at the supplier's system test
Version- & Change Management for deliveries (programs, scripts, data and bug-fixes)
Review of DFS documents
Execution of End-to-end test for the areas of (in extracts)
* Billing Configuration
* Customer Hierarchy
* Customer Management
* Invoice Interface
* IT Processing
* ORAK Processing
* Order Management
* Provisioning
* SAP Interfaces
* Security Level Management
* Product Catalogue
Development of a "product catalogue mimikry application" to check all product catalogue relevant combinations in the area of order management
Creation of automated check routines and scripts for the validation of "Papyrus" invoice files
Support of Business Acceptance Tests (Know-how, test data etc.)
Creation of error reports
Error classification and error tracking
Execution of regression tests
Preparation of system acceptance decision
Single Point of contact for the supplier for the tracking of errors. Support of the supplier in identifying and localizing errors to enhance software quality.
Archiving and administration of test specific data like test usage, test results, error logs and error reports
Delivery of all test data, applications etc. to Telekom Austria after the successful beginning of operation of "MaxBill" Phase 1
Application Testing & Test Management
System & Integration Test
Acceptance Test
Regression Test
Methodical test approach (no random/spot test)
Test is based on specifications
Use Cases are the basis for our Test Cases
Focus on Processes from the users view
Implementation of vertical & horizontal Traceability
Holistic system view End-to-End Test
Use Cases…
document the business process
can identify possible collaborative business areas
can separate business processes into functional system areas
can serve as requirements documentation for system development, as they are defined in a non-implementation/easy-to-read manner.
can identify possibilities of system or component reuse
can be used to categorize requirements (e.g., state of implementation, shipyard, functional system, etc.)
can be used to rank requirements (e.g., level of importance, risk, level of interoperability, etc.)
can be used to publish requirements at various levels (e.g., detailed design requirements, hanger analysis requirements, document management: document creation requirements, etc.)
Because they part of the object oriented design process, they can be used to identify the effects of functional changes on implementation systems, or implementation changes on functional capabilities
Use Cases are used for…
Requirement analyisis
System documentation on a functional level
Verifying integrity, correctness and completeness of specifications & requirements
Estimation of system complexity
Training & manuals
Test Case creation & automatisation
User Tests (Acceptance Test, User Acceptance Test, Black Box-Tests)
Requirement & Specification documents
Analysis & Design (development)
Use Cases are the smallest component of planning Estimation of effort & resources
Requirement Review
correct, consistent, not redundant, testable, complete
Requirements Management
Identify Stakeholders, needs, goals and objectives
Transform requirements to Use Cases
Setup of requirement repository
Identify dependencies
Prioritization
Traceability
Specification Analysis
Complete, comprehensive, correct
Compliant to Requirements and Business Rules
Identify supplementary specifications (e.g. interface specs)
Use Cases
Extend existing, Transform specifications to Use Cases
Setup of specification repository
Creation of Test Plan
Resource planning
Conceptual design of Tools
Design of test environments
Analysis of data formats
Preparation of Test Data
Test Data generation
Creation of Test Cases
Setup of Test Case Repository
Interlink with Use Cases, Specifications, Requirements
Combination to Test Scenarios
Coding of Test Scripts
Creation of Test Calendar
Test Execution
Manual and automated
Environments Management
Sanity Check
Parallelization of Tests
Ageing, Data Exchange
Reduced Test Efforts
Advanced Test Processes
Reduced Time-to-market
Enhanced Software Reliability
experiencied IT consultants, Professional Testing Solutions, Testing, Certified Tester, CMC, CITC, ISTQB, CSTE, incite Vienna, Austria, Wien, Österreich, EDV, IT, Unternehmensberater, Unternehmensberatung, acceptance test, acceptance tests, acceptance, interconnect, mediation, amdocs, intec, telecommunications and Utility Billing Systems, Telecommunications, Utility, Billing Euro Preparation for Companies in New EU Member Countries, Euro, Currency, New EU Members Requirement, requirements, requirement engeneering, IEEE, ANSI EDIFACT, DATANORM, ELDANORM, ETIM, Interface, Interfaces Data Exchange, Banks, Bank, Credit Card Companies, Credit Card, Credit Card Company Total Quality Management, Good Manufacturing Practices, Good Practice, Good Practices Quality Management, Knowledge Management, Balanced Scorecard, IT Service Management, IT Infrastructure Library, ITIL, European Organization for Quality, Quality, Certified, Certification Certified Quality System Manager, System Manager, Manager, mobilkom, tele.ring, telering, A1, handy, mobilfunk Telecommunication, Telecommunications, Telecom, Telekom, Telecommunikation
Telecommunications and Utility Billing Systems
Telecommunications and Utility Billing Systems
Professional Testing and Requirements and Euro Currency
Professional Testing and Requirements and Euro Currency