Business Problem 1

Background

The client is a leading player in the consumer products manufacturing industry, with a dominating presence in household categories. They have more than 10 manufacturing locations worldwide and numerous suppliers globally.

The client was faced with the emergence of stronger competition with focused product portfolios and shrinking numbers of intermediaries in the supply chain. One of the initiatives was the revision of their business intelligence reporting and information systems strategy. System resources needed to be aligned more efficiently with the top brands by getting the field data in real time manner and analyzing it thoroughly. Additionally, the client needed to improve organizational-service levels and increase visibility between business units and their respective product-specific business processes.

Q3 InfoTech's Architects facilitated sessions with the client's senior management to reach consensus on definitions and business rules. Q3 InfoTech was responsible to do the data modeling, data warehouse architecture, ETL Frame Work design, Business Intelligence Reports Library Creation and Training. The database server is Oracle 9i running on HP-UX. The business intelligence reporting tool was Business Objects XI Web Intelligence with static HTML report generation.

Success

The deployed business intelligence reporting solution gives the client's management semantic and business-rule consensus across geographies, products and profit centers. The solution is capable of accommodating number of legacy data sources and also any standard based future data repositories. Q3 InfoTech trained the client's Business Users to modify the reports dynamically based on the Universal rules changes with minimal assistance from the IT Team.

Business Problem 2

Background

Headquartered in upstate New York, client is a manufacturer of consumer drugs. Client has more than 3000 employees at 15 manufacturing and sales locations in North America, Europe and Asia to serve customers worldwide.

A key to our client's success is the ability of its sales, marketing and R&D teams to understand and respond to business and product trends in their target markets. The challenges were the excessive time spent in searching for the sales and marketing collaterals, content re-production, posting the questions to the research team and response time, inconsistent information, using out dated materials and Lost opportunities because sales, marketing and R&D teams did not have the right information at the right time.

A joint Q3 InfoTech and Client team developed a portal application to address these challenges by allowing the sales, marketing and R&D teams to manage information more effectively and hence increase overall efficiency and productivity. Q3 Info Tech architected the entire application using MS.NET and Share Point Portal Server with MS SQL Server Database Server. The customized reports are generated using MS Reporting Services and Crystal Reports. The portal application interfaces with multiple back-end systems including DB2, BPICS, MS Access, Salesforce.com, and ADS.

Success

While different kinds of documents or content might be stored in a range of backend systems, the Virtual Library provides a single virtual entry point to presentations, image files, audio and video files, customer-complaint records, new-product plans, marketing plans and research notes. The complexity of where and how information is actually stored is hidden from the end user. A personalization component allows sales and marketing representatives to view the latest news about their products, customers or market segments when they sign on to the application. Q3 InfoTech continues to provide ongoing support for the Portal application.

Business Problem 3

Background

The client is a leading software product company that enables IT organizations to maximize the total return on software investment by delivering solutions that lower costs, accelerate development cycle times and eliminate redundancy. Their software and best practices in Asset-based Software Engineering have helped some of the largest organizations in the world achieve quantifiable improvements in productivity, quality and agility - dramatically increasing the business value of IT. Their software suite increases visibility into how teams are creating and using software assets, allowing project and program managers to quickly determine if they are in compliance with corporate and architectural mandates and to reduce duplicate efforts.

Q3 InfoTech has been successfully providing QA and Testing services on a continuous basis for several releases of their software product. Q3 InfoTech has adopted the partial onsite and offsite model for extending its testing services. Q3 InfoTech's QA Lead went onsite to understand the client's development environment. Following this, a team of test engineers replicated the development environment at our offsite development center, which included various combinations of database and application servers on which the products developed by our clients could be installed. The team developed a series of test cases and automated them using Win Runner and Load Runner in order to facilitate fast regression testing as the product versions evolve over time.

Communications with the client were facilitated through different means such as personal visits, conference calls, web seminars, e-mails and instant messengers. Q3 InfoTech has provided our client with an access to our web based collaboration tool used for defect tracking. Our testing team reports the bugs via this tool while ensuring to assign the priority for fixing the bugs. This facility ensures that our offsite team and the client stay in sync on the status of the bugs.

Success

Q3 InfoTech has provided our client with significant cost saving and at the same time enabling them to deliver greater quality in their software suite. The relationship with this client is ongoing and Q3 Info Tech continues to provide them with excellent quality assurance services for their stream of better and better versions.