McKesson is a Fortune 50 company in the health care industry.

We have provided several different consulting and development solutions for them in the following areas:

• Business Intelligence solutions, Data Warehousing and Data Analytics for Generics program management.
• Intranet and Internet Portals and Collaboration tools for Tradeshow Ordering, Events Management, Sales Campaign Tracking and Sales Process Management
• Dashboards and Scorecards
• Business Application Development for Pharmacy Profitability Analysis, Sales Process Tracking and Tradeshow workflows
• Business Process Automation and Workflows for Online ClickThrough Agreements allowing McKesson to automate the manual processes requiring signatures and faxes. Customers have the ability to view contracts, fill in required information and approve the contracts online. Also supports multiple contract versions so contracts can be customized for specific customers as needed.
• Data export for integrating with internal systems.

BoomerangIt is a service which facilitates the recovery of lost and stolen items using security ID labels, tags and a patented methodology to track personal property. It has more than 1.2 million registered corporate and personal members.

Their web portal and infrastructure had become outdated and expensive to maintain. They were looking for a firm to provide a comprehensive, turn-key solution that included user interface design & information architecture, new database structure, development of an e-business portal, extensive management components, and hardware setup and hosting. They also wanted the firm to provide ongoing monitoring, maintenance and support for the long term.

We analyzed their present day needs and developed a state-of-the-art portal that met all of their requirements and provided a scalable and flexible platform for future growth. We setup and optimized new hardware and co-located the servers at our data center. We have been providing regular maintenance and support on the systems.

Some of the main features of the web portal are:

• Web 2.0 portal with extensive use of AJAX to provide spontaneous feedback to customers for an improved user experience.
• Online store to purchase labels, tags and subscriptions with automatic registration of the labels & tags to the user's account, online order tracking and account management.
• Ability to gift labels and subscriptions to others
• Online classifieds section to sell registered items and options to transfer items from one account to another.
• Multiple sub user accounts for corporate customers and ability to upload bulk items for registrations.
• Special accounts for Law Enforcement agencies to find the owner of lost and stolen items and fill out reports for items found/recovered.
• Proprietary technology for finding information for lost items and for finding items even when identification labels/tags are lost.
• Powerful order fulfillment section for administrators.
• Promotional programs in partnership with OEM product manufacturers, with tracking of traffic and revenue sharing.
• Automatic alerts and actions for expiring subscriptions, account suspensions, subscription activations and purchases.
• Support for multilingual transformations based on user preferences.
• Data Warehouse with a Powerful report and analytics engine which creates detailed reports, dashbaords and scorecards.
• Complete import of data from their old Oracle database.
• Highly optimized and scalable system that works well even with 1.2 million users and 5 million item registrations.

Screenshots:

Dell is a Fortune 50 company that is one of the leading manufacturers and direct sellers of computers and related products. We implemented the Dell Localization Platform which is an online management system for collecting localization performance data from different sources, analyzing the data and managing localization tasks performed by Dell vendors.

We created a portal based on the Microsoft Office SharePoint 2007 platform with a combination of standard components and custom forms. We provided Business Intelligence solutions with associated dashboards and reports built on the SQL Server platform. We created SQL Server Integration Services (SSIS) packages for importing data into the system from external sources.

The main solutions we provided were:

• Setup of a user friendly SharePoint portal with consistent organization branding and creation of user permissions with specific access rights.
• Import of Quality Trackers, MarCom Feedback Trackers and Forecast Trackers
• Setup Live Audit and customized audit reports
• Custom forms for order entry and management
• Interface for allowing vendors to upload invoices and excel sheets to the system
• Invoice, Order reports and charts for analysis
• Escalation lists for reporting
• Quarterly report pivot, languages and root cause reports
• Quality / SLA Impact list
• Impact column pie chart and audience views
• Document library for storing scorecard spreadsheets
• Data migration and import
• Utility to monitor FTP location for detecting new uploads and process the uploaded data by importing it directly to the system using SSIS import scripts
• SSIS scripts for building data warehouse and OLAP cubes
• Numerous dashboards, scorecards and reports including Daily Status; SLA Trends; Projects, Jobs and Tasks completed by week and quarter; Translation dashboard; Program performance by stakeholder and content type; Key Performance Indicators (KPI) Dashboard; Word count Pivot reports; Cost Pivot reports; and Live Audit reports

Screenshots:

JSR Micro, Inc. is an industry leading fine chemicals supplier to the high tech industry. JSR has established the reputation of being a leading-edge manufacturer by providing products of the highest quality, developing processes that ensure predictable, repeatable, best-in-industry results.

JSR used a legacy application developed on the MS Access platform for managing their Quality Control processes. The application had been continuously updated to adapt to changing quality requirements of the customers and new product additions. There were performance issues and restrictions on the no. of users who could use the system at any given time. The platform had reached its limits and was no longer updatable or scalable.

We revamped the architecture of the Quality Control (QC) system and developed a Web based application from the ground up. The application has a central, flexible database, a robust system design to overcome the limitations faced by the existing application and improved efficiencies across the board. We created a very interactive and easy to use interface. We also setup a data warehouse with associated analytics and reports.

The main features of the application are:

• An interactive, AJAX based application with user friendly features which leaves the windows based application far behind in user experience.
• Extremely extensible architecture which allows adaptation of data entry forms and reports when new business needs arise without modifying the code.
• Highly secure and scalable application that performs data operations efficiently even with many concurrent users.
• Complete QC process management system both for raw materials (inputs) and finished goods (outputs).
• Customizable user roles and user levels for security management.
• Concurrent data entry for the same product by different users.
• Support for Dual Quality control standards (by JSR and Customer) with automatic application of quality standards (specifications).
• Automatic QC reports (Certificates of Assurance) generation based on product specifications.
• Export of Certificate of Assurance to different formats like XML, CSV and PDF.
• Data import into SAS for statistical analysis.

Screenshots:

REC Solar specializes in grid-tied solar electric design and installation, offering the latest technology, state of the art equipment, and financing opportunities for all commercial and residential customers. It is one of the nation's largest photovoltaic installation companies with several million watts of solar installed.

REC Solar was being left behind by competitors who had started deploying interactive web portals including online tools for geo based customer quotes and sales lead generation. They also needed a much more maintainable website where non-technical users could easily add content and manage the database-driven components. They were looking for a development partner to revamp their existing web presence and provide an interactive system that customers could use to get pricing on solar installation, and order online.

We redesigned their web portal, providing a platform with a powerful, easy-to-use Content Management System (CMS) and developed an interactive Solar Analysis Widget that customers could use to get solar installation information and pricing, try out different options, order systems online and schedule appointments.

The main features of the web portal are:

• An interactive Solar Analysis Widget that uses online map solutions to help users locate their house using satellite images, draw out an area on their roof where they want solar panels installed, point out the direction of panels and roof slope and provide other relevant information. Based on this the system would calculate pricing options and present them to users.
• Generate solar energy production and energy consumption charts using solar energy data from PVWatts web service and various formulas.
• Provide break even period and profitability analysis with bar diagrams and charts.
• Interact with and send customer information to SalesForce CRM for lead generation and appointment scheduling for installations.
• Visually appealing site design with several Flash animations and AJAX functionality.
• Easy to use Content Management System for all pages and database driven modules for articles, news, FAQs, videos etc.

Screenshots:

San Francisco Department of Public Health was looking to automate and streamline its business processes for managing volunteers, managing their ongoing training, scheduling their visits, gathering work statistics, authorizing review of their work by managers and problem resolution.

We developed an Intranet portal with a central database and an easy to use interface that addressed all of their needs. We met all system requirements including high security due to the sensitive nature of the data.

The main features of the intranet portal were:

• Interactive Web 2.0 site with user friendly features
• Content Management System (CMS) which allows customization and personalization of pages based on user preferences and administration settings.
• Powerful security management with ability to create different user roles and setup different content access permissions based on roles and user requirements.
• Concurrent data entry by a large number of different users.
• User specific, personalized dashboard which provides an overview of all user activity in one place with appropriate links to associatedd sections and summary reports/charts
• Automatic alerts on pending training.
• Ability to send and receive messages and announcements to other users.
• Ability to schedule visits and upload interaction data to the server.
• Business Intelligence reports and dashboards including dynamic generation of graphs and charts based on data collected and imported from external systems
• Ability to get support and issues resolved from supervisors.

Screenshots:

Cisco Systems, Inc. is the worldwide leader in networking for the Internet and WorkplaceIQ is a technology solutions provider for the real estate industry. We integrated applications for Cisco Systems and WorkPlaceIQ by accepting and manipulating XML documents (related to property management) using the Microsoft SharePoint Server and Microsoft BizTalk Server platforms.

The project had two main functions: Import and Export. Import covers all steps needed to receive documents from Cisco, process/map documents and access web services to update the property management system. Export covers all steps needed to access web services to extract data out of the property management system, split them into single-record documents and route them to Cisco.

Both Import and Export rely on a number of custom components that work with BizTalk Server, SharePoint and Microsoft.NET web services to process and route XML data. These components are as follows:

• ASP.NET pages to receive documents
• BizTalk Application Integration Component that acts as an adapter between BizTalk Server and web services
• Web Service proxy component that communicates with the web service
• Microsoft.NET based Export Application that runs at scheduled intervals to export data using web services
• XML Splitter component that converts exported XML documents into single-record XML documents

The system accepted incoming XML documents through ASP.NET pages from WebMethods and routed them to BizTalk Server for processing based on various criteria configured in the SQL Server database. We configured BizTalk to map incoming documents to desired formats. We created components to call web services to parse the documents mapped by BizTalk Server and insert data in the database. We created COM+ components to call web services and transmit/receive XML documents.

Processes Overview

Matsunichi is one of the world's leading providers of digital consumer electronic products including portable storage devices and MP3 Players.

We developed a CRM (Customer Relationship Management) solution for handling sales and support management functions.

This is a powerful, easy-to-use customer relationship management (CRM) solution. It has a scalable and highly customizable architecture that allows new features and changes to be added seamlessly.

There are two distinct applications - one for sales and the other for support. Both applications are built using the Sharepoint and Microsoft.NET platforms. The application is highly modular so that components can be shared with different parts of the system and new modules can be plugged in easily over time. The user interface is designed to present a clean and intuitive look.

The Customer support portal features Login, New registration, Product registration, Case creation (online support request) for registered products and Email commuincation.

The Customer Service Representative site features User access integrated with Windows Active Directory, Create / Search customer accounts, Create / Update Cases, Create / Update Return Requests & MPRs, View message history, Send messages, Log phone calls & Support Requests and choose from different skins to customize the look of the site.

The admin site has the ability to Add/Edit brands, Define parameters to pass to branded web sites for integration, Reply to email addresses sent by CSRs for those brands and Manage Users (Reps and Manager). Managers have the same access level as Reps but can in addition assign cases to CSRs and manage products and problem types, Add/Edit Products, Add/Edit Problem Types and Manage other system wide configuration settings.

The Sales CRM poortal features Multi level, role based access for sales reps, sales managers, credit dept. and management team; Account and Contact management functions; Activity Management and Contact logs. It also has full admin functionality including the ability to add users, assign roles, update products and manage other system wide settings.

We provided business intelligence reports and data analytics through the SQL Server based Data Warehouse.

Screenshots of the Support CRM Application:

Screenshots of the Sales CRM Application: