Transportation Workflow Software

Duration	8 months
Team Size	3 Developers, 2 designers and 1 QA
Technology	ASP.Net, C#.NET, SQL Server 2005

 

Business process of the client

The software is developed for a client located at Oakland, California. Their business is to pick up the containers [loaded / empty] from shipyard and deliver to the customer warehouse and vice-versa

How the software automates the business process?

The software will help the backend process of the business in the following process

1. Enter and save the load / container details [it is done by the staff of the company]
2. Assigning this job to drivers / carriers [carriers can be own carriers or can be a sub vendor]. It will be done by dispatchers / managers
3. Status of load movement can be entered [entered by staff]  and tracked [by customers or staff]
4. The related scanned documents can be uploaded through the software [done by staff] so the customers can view them.
5. The needed receivables and payables can be tracked with their payment status [integration with QuickBooks software]

Actors / users of the system

• managers [managers monitor the loads and take care of the tasks on daily basis]
• dispatchers [ Dispatchers assign the load pickup jobs to drivers / carriers]
• staff [staff will enter the loads and update the status of the load movement]
• customers  [customers can see the load movement status and check the relevant documents and also the payment status]
• carriers [ carriers can login and check the loads assigned them so they can attend the jobs and check their payment status]
• Drivers [ drivers can see the jobs assigned to them and check their payment status]

Key feature of the system

The key feature of the software is to display LAST FREE DATE and alert [The last free date is given by shipyard and delivery appointment date. Based on these dates, the carriers should pickup the loads. The delay causes them paying more which can be avoided using these alerts. If the pickups are numerous it is very difficult to track these dates manually.

---

SaaS based Solution for Hazardous Material Shipping – HazMat

Duration	12 months, and ongoing
Team Size	10
Technology	ASP.Net 3.5, SilverLight, C#.NET 3.5, SQL Server 2008, JavaScript, JQMobile Framework

 

Technology Behind

Operating systems / handheld devices:	Windows 2003 Server, iPad
Development Platform:	ASP.Net 3.5, C#.NET 3.5, .NET Windows Services, SQL Server 2008 and Telerik Controls (both Silverlight and ASP.NET), .NET Windows Services, JQMobile Framework, XML
IDE:	Visual Studio 2010 and MS SQL Server Management Studio
Other:	TFS 2010
Methodology:	Agile Scrum

 

Project Team Project manager – 1 System Architect – 1 Business Analyst – 1 Developers – 4 UI Designer – 1 QA Engineer – 1

Configuration Tools TFS 2010 DBA – 1 Configuration Tools Online Issue Tracker, Online collaboration platform

Overview

Customer is a well-known provider of consulting services in HazMat (Hazardous Materials) shipping industry. Prior to HazMat shipping, every shipper has to generate paperwork to ensure that he is compliant with US Federal and International HazMat shipping norms. Such norms include

• 49CFR of DOT(US Department Of Transportation) for US Ground Shipments
• DGR (Dangerous Goods Regulations) of IATA and ICAO for Air Shipments
• International Maritime Dangerous Goods (IMDG) of IMO for Sea Shipments

Documenting compliance for HazMat shipments is complex and time taking. Manual documentation is also often prone to errors, as the process is cumbersome and the rules tend to change and involves mathematical calculations.

Business Challenge

The customer saw a need in the industry for a suite of solutions that reduces both complexity and time in generating the compliance documentation. At the same time, the solutions were to facilitate even a relatively lay user who is not an expert in HazMat compliance to use the service(s) and generate reliable compliance documentation

Additionally, since the end-users that generate the documentation are largely out in dockyards, the service was to facilitate a variety of computing devices – including desktop, laptop and handheld devices.

Project Description

The suite of solutions to be designed included:

• An “Enterprise” version facilitating several users of the customer organization to perform specific tasks, including
• User and role administration
• Role-based definition and maintenance of parts / material to be shipped
• Role-based definition and maintenance of packaging components, material and packing instructions
• Creation of shipments and reports, including both compliance reports (Shippers Declaration, Bill of Lading) and other supporting documents
• Search past shipments
• A “One-off” version facilitating self-service e-commerce enabled solution that facilitates non-frequent users to quickly purchase credits online, create shipment(s) and print compliance and supporting documents
• A mobile / handheld version (for iPad device) with limited functionality that will facilitate dock workers to add shipping parts to the database on-the-fly, as they are moving in the warehouse and inspecting material

Benefits Delivered

Since all the above-mentioned solutions involved similar functionality and had to use the same data store, we designed a multi-tiered architecture that separated the presentation, business logic and data storage layers that facilitated an integrated approach for all these solutions. We also implemented a Service Oriented Architecture (SOA) that further enhanced the scalability, flexibility and maintainability of the system. Following are some of the advantages delivered to the customer:

• Rapid deployment of solutions
• All solutions share same business logic library and data access routines. This facilitated refactoring of objects, and hence reduced redundancy in these layers
• Lesser code and hence more easily maintainable

---

 

Email Campaign System

Duration	4 months, and ongoing
Team Size	4
Technology	ASP.Net 3.5, C#.NET 3.5, MySQL 5.1, JavaScript, jQuery Framework

 

Technology Behind

Operating systems / handheld devices:	Windows 2003 Server
Development Platform:	ASP.Net 3.5, C#.NET 3.5, .NET Windows Services, MySQL 5.1, .NET Windows Services, jQuery Framework
IDE:	Visual Studio 2010 and MySQL WorkBench
Other:	TFS 2010
Methodology:	Agile Scrum

 

Project Team Project manager – 1 Developers – 2 UI Designer – 1

Configuration Tools TFS 2010 Configuration Tools Issue Tracker

Overview

Customer is a well-known provider of billing and financial management service catering exclusively to a Greek Community – Fraternities and Sororities. They have recently launched a new web-based portal for group management, that will promote group activity by providing effective group management, improved communication, enhanced interaction between members and increased revenue by way of donations.

A key module of this portal is to provide a facility for the group leaders to launch bulk email campaigns. Key features of the system include:

• Intuitive, template-driven solution
• Ability to create HTML/plain text email newsletters / messages quickly using a feature-rich WYSIWYG HTML editor
• Email tracking and detailed analytics
• Schedule / resend email campaigns
• Bayesian algorithm – based SPAM score generation

Business Challenge

The customer had very limited time for development and deployment of this module. Additionally, the customer required a scalable solution that is capable of processing hundreds of thousands of emails a day.

Furthermore, by the time we were awarded this project, the project was already partially worked-upon by another team that left the project mid-way.

The initial plan was to implement a custom email processing module, which was also half completed.

The entire email campaign creation workflow was also counter-intuitive, and was prone to several limitations, and the WYSIWYG HTML editor was limited in functionality.

Solution Delivered

• In view of the tight timelines, we successfully proposed to discard the current homegrown email processing module and implemented a robust and industry strength email service that satisfied all the customer’s requirements
• Our team implemented the entire email campaign workflow in record time, and at the same time worked actively with the client to effectively address a large percentage of the existing limitations in the existing architecture.
• Our team developed a scalable Windows service for email processing and tracking that is capable of running simultaneously on multiple servers and handle high loads.
• Oure team identified and customized a feature-rich open source WYSIWYG editor to satisfy all of the customer’s requirements

Benefits Delivered:

• Timely response to requirements in terms of both resources and timelines, take the challenge headlong and exceed client’s expectations
• Provided consulting to the customer to suggest alternate solutions and meet deadlines
• Delivered solutions that are scalable and gave higher ROI

---

 

Hosted Solution for a Telecom client

Duration	4 months
Team Size	12
Technology	ASP.Net, C#.NET, SQL Server

 

Technology Behind

Operating systems / handheld devices:	Windows 2003 Server, Magnetic North Maximise Dialer Services
Development Platform:	C#.NET 2.0, ASP.NET, .NET Windows Services, .NET Windows Forms, SQL Server 2005 and Maximise OCX Controls
IDE:	Visual Studio 2005 and MS SQL Server Management Studio
Other:	Magnetic North Maximise Services and OCX Controls
Methodology:	Agile Scrum

 

Project Team Project manager – 1 Developers – 6 QA Engineer – 3 DBA - 2

Configuration Tools Visual Source Safe 6.0 Configuration Tools MS Visio 2003, Bug Tracker

Business Challenge

The customer is using Avaya and Ascpect Dialers for its different internal processes / practices for Outbound calling hosted by British Telecom. The requirement is to replace both its existing dialers with their custom Dialer, which will not integrate into their system directly. There is a need to customize according to the new requirements and integrate the dialer with their existing legacy applications which are hosted on AS 400 Servers (IBM). Their other applications are also to be integrated into the new system in a time bound manner.

Project Description

The solution was developed into different parts

1. Windows Service: The windows Service is developed to automate the process of creating the calling list for new dialer from flat files, which were used for previous dialers. A new windows service is developed for generation of calling lists for different processes, which is controlled by web interface developed by us.
2. Web Interface: The web solution is developed to configure and control the windows service for creating the calling list. It also provides solution for mapping outcomes generated by the New Agent Tool bar to the legacy outcome previously used. The filters can be created for different calling list and will be used by the windows service. The web interface also controls the dialer fields based on the process.
3. Customized Agent Tool Bar: A customized Agent Tool bar is developed on client’s dialer services using their OCX Controls. The solution is provided as a desktop solution and fields displayed on the dialer screen change from process to process. The dialer is provided with dynamic buttons to integrate with different application hosted on different servers. Based on the call status the business logic change for different processes, the dialer outcomes and other messages of the dialer and user-entered values in the dialer will be dynamically updated.

The solution delivered by us consists of:

1. Windows Services
2. Web Interface
3. Agent Tool Bar
4. DB Scripts (Schema, Stored Procedures & Default Scripts)

Supported Devices

Agent Tool bar with Agent CTI Instruments.

---

 

Sportspoolsonline.com

Duration	8 months
Team Size	3 Developers, 1 designer and 2 QA resources
Technology	.NET, SQL Server 2008, JavaScript
URL	http://www.sportspoolsonline.com

 

Technology Behind

This is an online sports betting application that lets users play Pick-Em game and will allow players to participate in an exciting game for an entire season. Even if your home or favorite team is out of the race, Sportspoolsonline Pick-Em, will insure that players maintain interest in their favorite sports.

---

 

labecx.com

Duration	8 months
Team Size	2 Developers, 2 designer and 2 QA resources
Technology	MS .NET (C#), SQL Server 2005, JavaScript
URL	http://www.labecx.com

 

Technology Behind

This is an e-commerce application developed in .net technology. The application also has extensive office management system in the backend for the website management office and its staff.