Case Studies

List of Case Studies

Dot Net Case Studies

Project Name: Engage-SBDB

Client: Engage IST, USA

Environment: ASP.NET3.5, VB.NET, MySQL5.1, Windows Server 2003, Linux, IIS7.0

Engage-SBDB is a web-based application to manage projects and contract of Small Business Data Base (SBDB) with a Relational Data Base Management System (RDBMS) and using ASP.NET3.5 with VB.NET and MySQL backend database. There are several types of users that include Engage IST users, consultants, Small Business (SB) users, Disadvantaged Businesses Enterprises (DBE) users, Disabled Veteran Business Enterprises (DVBE) users. This application has several modules as listed below

  • Project Management
  • Contract Management
  • Sub-Contract Management/Multi-Tiered Contract Management
  • Users Management
  • Vendor Management
  • NAICS/SIC Data Import
  • SB, DBE and DVBE data Import
  • Audit Trail
  • Attainment and Commitment Reports with charts and graphs
  • Report Data Export option in Excel, CSV and PDF formats
  • Backup and Restore

Project Name: ETrack - SMB-AMR Customer Web Portal

Client: SMB, Singapore

Environment: ASP.NET3.5, C#, Java, MS-SQL Server 2008, Windows Server 2008 and IIS7.0

SMB is one of the leading power suppliers for houses, business units in Singapore. SMB-AMR Customer Web Portal is an online portal for the tenant and admin users of the system to view current consumption report for the month, week, and current date. There are different types of users on this system like Admin Users, Owners and Tenants. Admin Users will have access to the admin module where they can manage users, user groups and roles related activities.

Owner module will have several reporting features like energy consumption by facility, zone and energy efficiency levels with zones, billing list.

Data for the system is be retrieved from the MultiDrive database which holds hourly consumption of power by each meters/tenants/building and etc.

The following is the list of modules

  • User Management
  • User Roles Management
  • Users Group Management
  • User Group Creation Screen
  • Zone Management
  • Owner Module
  • Tenants Module
  • Reports
    • Energy Consumption of facility
    • Energy Consumption by Zones
    • Energy Efficiency Level within Zones
    • Demand Summary
    • Zones wise summary
    • Tree view option for Facility/Zone/Tenant
    • Report Period(Historical Data Max 1 year or Present Data
    • Compare By Zones(Multiple zone selection option)
    • Report Options for Monthly, Daily, Hourly, By Zone and By Site

Project Name:Exotiq Property

Client: Exotiq Property, Singapore

Environment: ASP.NET3.5, C#, MS-SQL Server 2005, Windows Server 2003, IIS7.0

Exotiq is an online real estate web site to buy, sell or rent properties that includes high attractive resorts, apartments, penthouses, villas, lands and commercial properties.

  • User Management
  • Property Management
  • Buyer Management
  • Seller Management
  • Reports

Project Name:ABC Applications

Client:AmerisourceBergen Corporation, USA

Environment: ASP.NET3.5, VB.NET, AJAX, MS-SQL Server 2005, Windows Server 2003 and IIS6.0

We have developed many web portal and web applications for AmeriSource Bergen Corporation. Here is the list of applications developed

  • ABC Fastlane
  • ABC Micro Site
  • ABC Dashboard
  • ABC Contract Roll
  • ABC PRxOG

Project Name:Bridgestaffing

Client:Multi-Media Concepts, USA

Environment:ASP 3.0, AJAX, MS-SQL Server 2005, Windows Server 2003 and IIS6.0

We upgraded bridgestaffing.com web portal with the following modules

  • Personal Information
  • Education
  • Employment History
  • Skill Specialties
  • Miscellaneous

Project Name:Payroll System

Client:Olympic Payroll, USA

Environment:ASP.NET 3.5, AJAX, MS-SQL Server 2005, Windows Server 2003 and IIS6.0

The scope of this project is to replace the existing standalone application with web based version of the Olympic Payroll Application. This is a secured single web based system that will support all customers of Olympic Payroll Services. The new system is simple, user friendly and reliable to support the growth. This has automated following features

Admin Module Features

  • User Management
  • Customer Management
  • Reports

Customer Module Features

  • Payroll Period Management
  • Employee Management
  • Deductions Management
  • Miscellaneous Management
  • Direct Deposit
  • Time Transactions

Project Name:Employee Resource Allocation

Client:Resource America, Inc, USA

Environment:ASP.NET2.0, VB.NET, MS-SQL Server 2005, Windows Server 2003, IIS6.0

Resource America, Inc. is a specialized asset management company that uses industry specific expertise to generate and administer investment opportunities for its own account and for outside investors in the commercial finance, real estate and financial fund management sectors.

Employee Resource Allocation is an intranet application which uses form authentication and authenticates them against the Active Directory Groups and users. The User privileged screens will be displayed as per the AD Group. Employee's resources have been allotted by the Hiring manager and approved by the Human Resource Manager. They may even terminate the employee from the organization. It handles multiple companies and its employees and the Hiring and Human Resource Managers can only access the companies assigned to them.

Project Name:Repuestos-Originales

Client:Repuestos-Originales, USA

Environment: ASP.NET2.0, AspDotNetStoreFront, VB.NET, PostgreSQL, Windows Server 2003, IIS6.0

A search & buy web site for all parts of vehicles that are available all around the world. Database contains the details of billions of records about the parts of vehicles and diagrams of the parts. The main feature of this site is to search by Year, Make and Model of the vehicle as well as by VIN number and OEM Part Number. This also contains diagrams of all parts in the database. Data were imported from AAIA and MOTOR data repository.

  • Drilldown Search feature for vehicle parts for all make, all model available all around the world
  • Vehicle Parts display with diagrams and comparison of competitors price.
  • Real time Shipping rate calculation
  • Shipment Tracking
  • Multiple Language support
  • Multiple Payment Gateway Integration
  • QuickBooks Accounting Software Integration
  • Sophisticated Reporting tool
  • Import tool for MOTOR and AAIA data update

Project Name:Ordering System

Client:PSC Global, USA

Environment:ASP.NET2.0, VB.NET, MS-SQL Server, Windows Server 2003, IIS6.0

PSC Global is importers and distributors of Die board. This project maintains the board details, existing customers, Orders, invoices and inventory details. The following modules are available in this project.

  • Customers
  • Orders
  • Shipping
  • Invoice
  • Inventory

Project Name:Independent Management Appraisal Certification System- IMACS

Client:Independent Gemmological Laboratory, USA

Environment:VB.NET, MS-SQL Server 2005, Crystal Reports 11, Windows XP/Windows Server 2003

IMACS has been developed for the client Independent Gemological Laboratory, New York, USA. IMACS provides the complete solution for a diamond/colored stone/pearl jewelry grading and certification organization. IMACS handles all process including Order Receiving, Job Order, Quote Creation, Template Creation, Grading, Engraving, Inscription, QC, Certificate Generation, Printing, Invoice, Packing, Shipping, and sophisticated Security Management System for application's user management. It also supports integration with QuickBooks application to handle inventory, Customer and financial related transactions. Reports have been developed using Crystal Reports11

Key Features

  • QuickBooks Integration
  • Job Order
  • Inventory
  • Vendor
  • Grading
  • Certificate Printing on various sizes
  • Reports

Project Name:SetPointFitness

Client:SetPoint Sports+Fitness, USA

Environment:ASP.NET2.0, VB.NET, MS-SQL Server 2005, Windows Server 2003, IIS6.0

Setpoint Fitness is a Fitness company, which provides highest quality nutritional products available to athletes, coaches, personal trainers, or anyone on the go, who is seeking a healthier lifestyle. SetpointFitness.com is an E-Commerce website with effective shopping cart using PayPal. It also provides a Content management System in Admin Panel to add new products and to handle orders. Effective reports on Orders, Customers, Trainers Etc.,

Key Features

  • PayPal E-Commerce Payment Gateway Integration
  • Admin module
  • Product Management/CMS
  • Shipping
  • Inventory
  • Payment History

Project Name:SpecSheet and Cost Sheet

Client: TrakWear, USA

Environment: ASP.NET2.0, VB.NET, MS-SQL Server 2005, Windows Server 2003, IIS6.0

Lead the Development team in developing SPECSHEET and COSTSHET for an apparel manufacturing company Nancy Bolen, USA. The objective of this application was to define specification and calculate various cost involves in designing apparel based on Season, Style, Group, Size, Pattern, Material, Imports and Classes. Cost factors involve in this are labor cost, trimming labor cost, Import Cost, Trim Cost and other costs. Final cost sheet will be generated for various locations (country) based on the above-mentioned parameters.


Other Case Studies

The Client

The Client has a mammoth transportation business with its presence in USA and Canada, extending its service for logs and heavy mechanical equipments. The Client is headquartered in California, USA.

The Objective:

We stay abreast of the latest technical developments. Our expertise in Website designing includes:

  • Data Entry Operators to fill the details of a haul based on the data provided by Clients and Truck Drivers
  • Area Managers to generate reports by collating the details of each haul/trailer/train, their routes, commodities, Fuel consumption, associated problems, mills and garages
  • Accounting Personnel for associating accounts with Clients, fill payment details, calculates charges, makes sales receipts
  • Payroll personnel to calculate charges for Employees or Contract Drivers and makes bills accordingly.
Openwave Solution:

Openwave came up with a solution that integrated the complex workflows of the Client like automating the haul recording and tracking system, optimizing hauls and tracking payments. As there was a complex flow of data on hauls, charges etc and the haul details directly affecting the cost of operations, Ruby-on-Rails framework was implemented rather than Java EE or .NET, so as to make changes to the model directly and observe the results without having to set up every part of getting that data propagated throughout the rest of the system. Furthermore, due to the complex interface where a User like Data Entry Operator or Accounting Personnel had to enter a lot of information based on a range of information like truck/trailer details, route details, commodities and fuel consumption, Ajax was used to make quick and incremental updates to the User Interface without having to reload the entire browser page for this application.

Technology Stack:

Ruby-on-Rails, Ajax, PHP and MySql

The Client

The Client coordinates with WHO, UNICEF and other Non-Profitable Organizations around the world to eradicate HIV. This system was implemented first in the City of Baltimore, USA. This will be implemented worldwide in future.

The Objective:

The main objective of the project is to provide help expediting and coordinating the individual efforts of various Organizations working towards the eradication of HIV. The system itself is a complex one that integrates many software technologies and tools. The tools were used to implement the following features:

  • The Map of Baltimore city is shown in Flash with several layers like Census Block Group (CBG), Neighborhood, Zip Code, Censure Data, Morbidity Data, etc…
  • Social Networking features are integrated using "Dolphin"
  • The program interacts with the database using XML created at run time using the data from MySQL database.
  • With the help of Flex 3.0 we have created a Dashboard that can house various applications including CBIS, Social Networking, Google Maps….
  • A Custom built Content Management System (CMS) to manage the contents of the entire System.
Openwave Solution:

Openwave seeks to exploit the use of Internet and matchmaking technologies in the development of social capital that is directed towards the creation and maintenance of an active network of health agents that not only includes the CBOs but local and federal health agencies and research institutions as well. Better resource allocation, improved service coordination and more effective health interventions will result from providing an effective means for collective action. Through the innovative use of new technologies, such as vector-based mapping and "rich client" technologies that accommodate the development of accessible interface designs for the non-expert, we developed a fully functional, web based resource that creates a network of organized reciprocity for better health.

To build such an efficient system, we made use of Flash Action Scripting with the Combination of LAMP Architecture. We used our expertise in Flash to create Flash maps which has many layers and provide interactive user friendly interface.

We have made use of the Agile Software Development methodology.

Technology Stack:

Flash 9.0, Ajax, PHP and MySql, Flex 3.0, Dolphin Open Source.

The Client

Client focuses on supplying platform services through an Application Program Interface (API) or a customer-branded web interface or Interactive Voice Response (IVR) and processes credit card, debit card, and electronic check transactions. Their product interfaces with its corporate customers' systems to provide up to date billing information as well as daily settlements and comprehensive online reporting which streamlines reconciliation.

They offer specialized electronic bill payment programs for the following industries:

  • Utilities
  • Telecommunications and cable companies
  • Government institutions
  • Higher education institutions
  • Insurance companies
  • Consumer Loans / Mortgage
  • Healthcare

Additionally, other companies that bill their customers can leverage the service as well.

The Objective:

To develop a PCI compliance online payment portal with various features and functionalities that includes Application Program Interface (API), Interactive Voice Response (IVR) and Customer Server Representative (CSR).

Customers will be able to customize the user interface according to their own web site styles and color schemes.

Openwave Solution:

As this application deals with financial transactions and sensitive information like credit card, debit card, check and saving accounts, it is mandatory that the application be developed in such a way to be a PCI compliance system.

Openwave followed various securities and coding guidelines to make the system PCI compliance.

Technology Stack:

Tools & Technologies: ASP.NET, VB.NET, Framework2.0, XML, Web Services and MySql

Development Model: 3-Tier distributed deployment model

The Client

The client provides monitoring and maintenance activities of computers and network devices to a number of customers. They monitor numerous organizations' network devices such as servers, routers, firewalls, and workstation pc's. Their customers pay them a monthly fee for this service and one of the promised deliverables to our customer for this fee is a monthly report that summarizes their network's "health". They call this report the Executive Report or Network Health Report. In this report, they analyze a number of network metrics such as:

  • Status of Windows updates or patches for servers & workstations
  • Free disk space on hard drives
  • Anti-Virus protection - are virus signatures up to date or out of date
  • Internet uptime
  • Server uptime
  • Backup success or failure
  • Open and recently closed service tickets Nucentric has worked on while supporting their network.
The Objective:

The objective of this project is to monitor network devices and collect data about the status of network device. The Executive Report is built using Visual Studio and SQL Reporting Services.

Openwave Solution:

The report is designed to be a 1-page summary for non-technical customers such as a small business owner to show them that our Client is doing a good job supporting and maintaining their network.

Sections of the Executive Report

  • Customer Info
  • System Status
  • Security Status
  • System Availability
  • Service Requests
  • Disk Utilization
  • Patch Management
Executive Report Data Sources

The Executive Report uses 2 primary systems from which it gets its data:

  • Kaseya – This is a system that our client uses to monitor network devices and collect data about the status of network device. We also use Kaseya for patching servers and workstations, remote control support, etc.
  • Connectwise – This is a system that our Client uses for service ticket management, employee's time tracking and customer billing. The "Service Requests" section at the bottom of the report gets data from ConnectWise to display recently opened and closed service tickets.
Anti-Virus Sub-Report

In the Anti-Virus section of the Executive Report, the user may run a sub-report displaying the detail of the Anti-Virus status for that customer.

Anti-Virus Script

In order to gather the data necessary report on status of anti-virus, we had to create a script that runs on all of our "managed" pc's and servers that checks for the virus signature version and date. The script is deployed to all "managed" pc's and server via Kaseya. We install the Kaseya software agent on each of these "managed" pc's and this allows us to deploy scripts such as this Anti-Virus script to each of the managed pc's. The purpose of the AV Master script is so that one script can be executed on all client machines and collect data on every AV product that is installed.

Technology Stack:

Tools & Technologies:ASP.NET, SQL Reporting Services, Framework2.0, XML, Web Services and SQL server 2005

Development Model: 3-Tier distributed deployment model

Why Openwave?

Creating Value for clients

We strategically design solutions to create value of client businesses.

Futuristic Innovation

Standout in the crowd through creativity and with bespoken designs.

Plethora of Technology

We embrace and practice latest web standards & mobile trends to build your applications.

Passion For Technical Excellence

Committed towards excelling technically and achieveing quality results everytime.

Complete Integrity

Work ethics, mutual trust, fairness, business transparency and honesty.

Collaboration

We work closely with our customers towards a flexible & client-centric solution.

Our Solutions

Solutions like Magento, Ubercart, Virtuemart, Zencart, Oscommerce, X-cart, Opencart, Cubecart, Prestashop, CRE Loaded.

Get a Free Quote
CMS solutions built from scratch or implementing opensource tools like Joomla, Drupal, Wordpress, Expression Engine.

Get a Free Quote
Openwave develops Payment gateway solutions that seamlessly allow third party payment gateways to customer websites. Enabling a website for credit card and online payment increases the chance of closing the sale and getting paid fast.

Get a Free Quote