Archive for January, 2010

Should a company build a data warehouse when it has reached a particular size?

by on January 30th, 2010

Data warehousing is fast becoming the buzz word in marketing nowadays. But, when should a company embark upon a data warehousing project? The company size alone may not be the sole determinant for initiating this action. Company size can only be one amongst several other important factors that determine the need for a data warehouse.

The other ancillary queries that have to be addressed first are –

(1)    Are executives asking questions pertaining to customer profiling in a particular region, the reasons for dip/rise in sales in specific geographic locations, impacts of allocations of advertizing budgets per locale, prediction of buying patterns and identification of hidden trends in the business directions?

(2)    Is there a need to reconcile a company’s different data sources and enhance the in-house intelligence capabilities so that executives are empowered to make appropriate business decisions?

(3)    Is the market that the company belongs to characterized by rapidly changing parameters and is it currently difficult to refocus corporate strategy because of the dynamic environment?

(4)    Do executives from different corporate functional departments feel the need for integrating decision making processes across the organization so that only those decisions that truly add value are pursued? Now the tacit assumption is that the company has already had a chance to define its KPIs.

If the answer to all the above questions is yes, the need for a data warehouse has come, irrespective of how big the company is.

Why Returns Management is Overlooked in Cellular Point of Sales

by on January 28th, 2010

Why is it that cellular phone point of sale systems often ignore the complexities surrounding returns and the reverse logistics process?  Perhaps it is because many point of sales systems treat returns as basic inventory transactions.  A sale is a decrement in inventory and a return is an increment in inventory.  In reality however, a cellular phone return is not so simple an atomic transaction.  Complex workflows often develop to determine whether a refund is possible, whether the phone is still under warranty, whether the phone is insured, etc.  Point of sales systems often do not have an architecture that supports such complex workflows.  As a result, returns management systems are often built as separate applications.  This is unfortunate since substantial integration effort is then required to keep the returns management and point of sale systems in sync.

Where do we stand on Innovation ?

by on January 25th, 2010

In my class this weekend at Stanford University – Advanced Project Management program, the topic of discussion was – The Managerial Challenges of Innovation Strategies. The speaker divided types of innovation in two main categories

  1. Innovation Strategies in Growth Markets e.g., Skype, Sony PS platform
  2. Innovation Strategies in Mature Markets e.g. P&G, Disney

The assignment was to position your company in one of these markets and then determine the type of Innovation strategies that are or should be employed by your company. Since Perficient, being a consulting firm does not fit the paradigm required here, I decided to extend my analysis to the Telecommunication Service providers at large. Perficient has served a bunch of  Telecom Market leaders and start-up firms in the past and we have noticed that the challenges they face are uniquely different from those of other industries. They face the dreaded sluggishness of legacy systems, that need to be fixed time and again and need a big portion of the budget and resources to devote their time on such projects. But these companies cannot stay behind , they don’t have time to cut slack, they NEED to innovate rapidly to fight competition.

(more…)

Making Sense of QA Test Results – Part 1

by on January 24th, 2010

How often have you been part of a software development project where Quality Assurance efforts seemed to produce relatively meaningless figures and statistics? What does 69% execution rate, with a 53% pass rate really mean? How do you make sense of 400 defects, even when they are set to appropriate priority and criticality? Does this tell you anything about the health of a development initiative?

Let’s say, for example, that you are in the PMO group of an organization launching a brand new wireless service offering. This offering includes all facets of a customer facing wireless service solution (from the network, to billing system, to customer self care and CSR systems).

(more…)

The Wireless PIT (Policy Interaction Triangle)

by on January 24th, 2010

People want connectivity everywhere. They want to use mobile data applications in almost every setting possible (on the bus, plane, ski slopes, rural countryside, etc). With the exponential growth that customers experience in today’s mature communications market, they expect wireless coverage to be completely ubiquitous, to exist everywhere, and without interruption.

Advertisement slogans like “More Bars in More Places”, the “Now Network” and the induced fear of “Dead Zones” contribute towards strengthening this expectation. But customers are only one element in a wireless communications service provision system. Careful study of this system can lead us to being able to represent the entire system with a single diagram that we will call “the wireless PIT” (Policy Interaction Triangle). Understanding the elements of the PIT and abstracting the interactions between these elements can assist in the design of a formalism that can be extended to the study of other telecommunications systems as well. Like in most other systems, a company that is able to position itself to deal with these interactions between elements is capable of developing a niche area of expertise in the market.

Wireless PIT 

(more…)

The Launch of Nexus One

by on January 23rd, 2010

Google Nexus OneLast weekend, I found myself in a company of four members of what David Pogue calls the Droid Army. Being the only iPhone user in the group was definitely not working for me. So I decided to look deeper into the Nexus One – the gadget – and Google’s way of marketing the product.  One of the ‘aha’ features of the new gadget is its speech to text feature. It works. It really does. And it handles different accents fairly well. None of the product reviews mentioned this feature. Are there more hidden features that are going unnoticed due to Google’s targeted marketing approach?

Google’s belief in not advertising using the mainstream commercial channels might not be the best move in today’s context. There are many on the streets that still think that Droid was the last phone that works on Android. What is Google counting on – word of mouth and tech blog readership? Google must spend its money to drive the phone to the heart of its customer base.

(more…)

Why Isn’t Application Integration for Cellular Supply Chain Management (SCM) Real-Time?

by on January 22nd, 2010

The first time I worked on an SCM application integration project, I was amazed at how the architecture was almost entirely based on passing batch files between internal business and operational support systems.  With all the new integration acronyms out there (e.g. EAI, SOA, BPM), I thought I had stepped back in time twenty years.   I had also come from a background where “Flow Through Provisioning” of individual orders without delay was the mantra for on-network activation of services.

It wasn’t until I more fully understood the business processes around the cellular phone supply chain that I realized there are legitimate needs to maintain batch file integration architectures.  The three biggest impediments I see to real-time SCM integration are:

  • Non-standard delivery and format of automatic shipping notifications (ASN) by the majority of handset original equipment manufacturers (OEM).
  • Lack of capability by the third party logistic (3PL) vendors to provide real-time views to on-hand inventory and instead provide daily inventory snapshot reports.  Granted, these vendors have limitations associated with in-transit shipping (e.g. “the slow boat from China”).
  • Certain inventory functions at the retail stores (e.g. cycle counts, transfers) are themselves performed in batch, yet the results from these activities need to be reconciled with the master inventory.