Case Studies
These are a few of the solutions we have provided to our clients.
Resource Competency Assessment System
Pepsico
PepsiCo is a world leader in convenient snacks, foods and beverages with revenues of more than $39 billion and over 185,000 employees in 2008. The QTG division of PepsiCo includes Quaker, Tropicana, and Gatorade brands.

Challenge
The HR department at PepsiCo needed a system to track employee’s competency levels and their progress each year. They needed a performance tracking system for employees and their managers to access and update on a regular basis.
Solution
Paltech Solutions worked closely with PepsiCo and developed a wizard type application that walks the employee through the tracking process step-by-step. The application has a friendly graphical user interface that verifies entered data and notifies user when the information is invalid. There is also the functionality to generate summary reports.

Company Database and Information System with Mobile Application Integration
ERA
ERA (Ecosystem Restoration Associates) is a Vancouver based carbon offsetting company that works with Municipalities, First Nations and other landowners to restore degraded ecosystems.

Challenge
ERA was in need to of a new system to manage, access, and maintain tree related information. Their tree data collection and management system was inefficient and inaccurate.
Solution
Paltech Solutions worked with ERA and developed a company wide Information System that is used for Inventory Management, Client Relationship Management, and Executive Decision Support. Furthermore, mobile application was developed for infield workers to access and update data remotely using smartphones

Testimonial
“Paltech implemented a tree and carbon-offset inventory system with mobile GIS integration. Thanks to their solution, we are able to update our field maintenance and tree implementation daily and more importantly, remotely. The system also tracks carbon offsets created, sold, and still available to sell. We were impressed with how quickly they grasped what our business is about, how inventory is created, and how we needed information to be tracked. They were also very professional during all stages of development and delivered the project on time. We have continued to use them for system extensions and support. We at ERA highly recommend Paltech Solutions”
Strategic Planning Database System
Kroger Co.
The Kroger Co. is the second largest grocery retailer in the US with fiscal 2008 sales of $76.0 billion.

Challenge
Kroger needed assistance with its strategic planning database that would be shared between various divisions. Apart from having well structured data tables, Kroger needed to implement Allocation, Capital, and Project summary reports.
Solution
Paltech Solutions worked with Kroger and designed a database system that is used by users in different location. The friendly user interface makes data entry and reporting simple.
Testimonial
“We have been very pleased with the level of customer service and technical expertise that Paltech has provided on this project. In working with the Paltech analysts, we found them to be courteous, professional, responsive and thorough in helping us define our requirements and deliver a product to meet the user needs.”
Patient Monitoring System
Attain
Attain, Inc. is a not-for-profit corporation that has been supporting people with developmental disabilities for over 20 years in the Central Florida community. They provide an array of community based programs for people with developmental disabilities.

Challenge
Attain faced challenges of the repetitive work required for tracking, monitoring, graphing, and reporting the progress of each patient.
Solution
Paltech Solutions developed a complete database system that allows Attain to record, track and graph patient’s progress. Our system facilitates the daily tasks performed by Attain employees. Our system also has the ability to generate and print OCR compatible forms, and it integrates effectively with the company’s business flow.
Student Management System
Dancing For Dessert
Dancing for Dessert Studio was founded in 2005 and it has grown to become the ballroom dancing destination for Langley and greater Vancouver area with hundreds of students.

Challenge
Due to its constant growth, Dancing for Dessert needed a CRM (Customer Relationship Management) system. The studio’s student management processes were inefficient and repetitive. They required a fully centralized solution that would solve all their management needs.
Solution
Paltech Solutions developed a custom web based student management system with a user friendly interface and a reliable database structure. The system now allows Dancing for Dessert to easily manage students and classes, produce reports, and print various types of information related to students and classes.
Testimonial
Coming soon…
Disbursements Cost Recovery Tool
Tim Louis & Company
Tim Louis & Company is a Vancouver based law firm committed to high quality service, competitive fees and corporate social responsibility.
Challenge
Tim Louis & Company needed assistance to improve their cost recovery process. Their existing methods were inefficient and repetitive.
Solution
Paltech Solutions developed an automated tool which was integrated with their existing Law software allowing for a more efficient cost recovery process.
Testimonial
“Paltech Solutions developed an automated system that enables us to easily import cost disbursements from a multipurpose machine into our Law software. We were very pleased with Paltech Solutions’ level of customer service and professionalism. Their solution saves us valuable time and effort. We highly recommend Paltech Solutions!”
Customer Relationship Management Database
Myers and Fuller
Myers and Fuller is a law firm based in Tallahassee, Florida that represents automobile, truck and motorcycle dealers in complex commercial transactions, business disputes, operational issues and litigation.

Challenge
Myers and Fuller contacted Paltech Solutions with the need to upgrade their existing client management system that was not effective and user-friendly.
Solution
Paltech Solutions created an easy-to-use database system for Myers and Fuller to store client and case specific information. The system also produces detailed reports, mailing labels, and specific exports.
Testimonial
Coming soon…
Automated Reporting System
Hirshorn Zuckerman Design Group
Hirshorn Zuckerman Design Group, HZDG, is a design and marketing company based in Rockville, Maryland.

Challenge
HZDG contacted Paltech and explained how their inefficient monthly reporting procedure took their staff days to complete. The work was also extremely tedious and frustrating to perform.
Solution
Paltech Solutions analyzed HZDG’s problem and suggested an automated system that would create the reports in seconds rather than days. The solution reduced HZDG’s operating costs and increased satisfaction among staff.
Testimonial
“We talked to many consultants regarding the program we needed. Paltech Solutions had the best pricing, broken out by section and options. They also delivered on time and are very reliable. Paltech Solutions created an excellent program that automatically creates reports that used to take days to complete.
Their after service support is outstanding. Every time we run to a problem, they are very responsive and helpful”
Tabulated Report Generator Application
PAC-COMM
PAC-COMM is a Virginia based consulting firm.

Challenge
PAC-COMM contacted Paltech Solutions for a challenging task of creating over 500 tabulated reports for publication purposes from a set of raw data.
Solution
Before jumping on the task, Paltech Solutions analyzed the problem and discovered that this task needed to be repeated on a yearly basis. Paltech Solutions then suggested implementing an automated system to generate the reports that could be reused every year. The solution would save the company more money in the long run. PAC-COMM chose the automated solution and plans to use the system yearly.
Testimonial
“…Paltech Solutions programming effort, customer and product support was excellent. We will be using the Table Generator for next years’ publications, thus incurring no additional costs or generating the same tables with updated data. We plan to use Paltech this year for other projects. Highly recommended!”
Business Planning, Sales Forecast, and Resource Allocation Consulting
NewCity
New City Contracting is a general contracting firm in Vancouver that has been providing quality workmanship in building maintenance and renewal in the Lower Mainland since 1997.

Challenge
NewCity needed a business sales and production tool for company senior managers to utilize. NewCity wanted a tool that could simulate different scenarios and be flexible to accommodate changes.
Solution
Paltech Solutions created a comprehensive business planning system that created production forecast for the next 5 years based on various variables and simple statistical analysis. It also calculated personnel requirements and increase of operations costs
Testimonial
“We needed a business sales and growth plan. Paltech Solutions created a forecasting program that is very easy to use and effective. The consultants at Paltech Solutions were friendly and knowledgeable. I am very satisfied with their work and recommend them.”
