(Reading time: 3 - 5 minutes)
Pin It

Working in the Industrial Sector requires process knowledge and expertise.  PCG has worked in dozens of Industrial systems.  

 

Sales Rep Lead Tracking System (Visual Basic for Applications / SQL Server / Microsoft Access / Microsoft Excel)

Requiring an independent, synchronically (distributed) database to manage their National Sales Force information in tight project completion deadlines, Phoenix Consultants Group "stepped up to the plate" and successfully delivered.  This integrated database was replicated, and synchronized nation-wide in SQL Server and Microsoft Access. Utilizing its proprietary "condensed development cycle" technique, PCG delivered the Microsoft Access and SQL Server integration that provided the complex analysis tools needed by the client's electronic division sales and marketing task force.

SQL Server Replication (Visual Basic / SQL Server)

Industrial network security against virus and competitor infiltration led this client to Phoenix Consultants Group, seeking a secure filtered web browser that would allow their employees internet access and still protect this customized embroidery client's own networks.  PCG developed the Lightning Internet Browser to work with Internet Explorer Client, and restrict employee internet site access to known, trusted, and/or secure sites during the workday. The reduction of invasive incidents and viral infiltration increased the productivity of the business by facilitating ease of net access under a secured network environment.

Phoenix developed this unique web browser utilizing an offsite SQL Server to host the secure sites that users could visit and additionally allowed an administrative module to be utilized to provide secure email to company individuals requiring contact with their many different vendors.

MSDS Automation System (Visual Basic for Applications / Microsoft Access / Microsoft Excel / Outlook)

Our challenge in this project was the adaptation of database functionality to inventory tracking of chemical products sold by multiple chemical production and shipping companies.

PCG was approached by this client wanting a "turn-key" product to match, select, and include the mandatory Material Data Safety Sheets.  Components safety labels customization was required for shipping potentially hazardous materials.  It was designed to track the inventory of companies that ship chemical products around the US.  Each chemical must have a Material Data Saftey Sheet attached to it and a proper marker/sticker/sign that reflects how the chemical is to be eliminated or neutralized dependent upon the type of spill (ie; oil goes into a river, how do you fix it).  This database printed thermal labels to allow the company to produce the proper labels to affix to packages.  Additionally, location and inventory control of the stock levels of the chemicals was written into this database to facilitate the location of all products at any given time to ensure compliance with OSHA.

Packing and Crating Delivery System (Visual Basic for Applications / Microsoft Access / Microsoft Excel)

Developing and creating database-driven software applications is a Phoenix Consultants Group specialty. When this client required a calculations and tracking module to calculate and monitor board-feet usage for customized shipping crate construction, PCG nailed it down. By integrating pricing components such as manhour consumption, extra materials (reinforcement; packing cushions; etc), with labor and hardware costs, we developed a multifunction calculations program on an MSAccess platform.

Banana Labor Force Tracker (Visual Basic for Applications / Microsoft Access)

Rising to the challenge put forth by one of "down-under's" large banana plantations to develop their detailed management program, Phoenix Consultants Group designed, created, and successfully integrated their client-specific Labor Force Monitoring and Tracking System, enabling this banana business to increase their production 30% in the first 3 months following incorporation of the PCG-designed program.

Our "Aussie application," written in Microsoft Access, allowed tracking of days worked according to employee, total employee days worked, overtime accumulation and tracking, benefits documentation, and other local management components were basic to the successful management functionality for this large scale grower-supplier. PCG's development of enhanced international shipment transport, tracking, and receipt tools, working in conjunction with incorporated lost or damaged product accountability documentation, lead to the rapid success of this all-purpose application.

Internet Filtering Application (Visual Basic / ASP / SQL Server / Microsoft Access)

Industrial network security against virus and competitor infiltration led this client to Phoenix Consultants Group, seeking a secure filtered web browser that would allow their employees internet access and still protect this customized embroidery client's own networks.  PCG developed the Lightning Internet Browser to work with Internet Explorer Client, and restrict employee internet site access to known, trusted, and/or secure sites during the workday. The reduction of invasive incidents and viral infiltration increased the productivity of the business by facilitating ease of net access under a secured network environment.

Phoenix developed this unique web browser utilizing an offsite SQL Server to host the secure sites that users could visit and additionally allowed an administrative module to be utilized to provide secure email to company individuals requiring contact with their many different vendors.

RSS Feeds

About us

9 Wilson Dr, Northfield, NJ 08225
Tel: 609.423.6979
Email: This email address is being protected from spambots. You need JavaScript enabled to view it.