 |
Automated the integration
of Enterprise Resource Planning
(ERP), Customer Relationship Management
(CRM) and Supply Chain Management
(SCM) applications for a billion
dollar public company. Transformed
a simple Electronic Data Integration
(EDI) translation tool handling
approximately ½ million transactional
records per month for two (2) loosely
integrated systems, into an extensible
Enterprise Application Integration
(EAI) system handling more than
5 million transactional records
per month for eight (8) disperate
systems. Literally billions of dollars
of transactions traverse this system
each year. The necessary man
hours required for system maintenance
has decreased greatly even while
the transactional capacity of the
system has increased 10 fold.
|
|
Provided the US Social
Security Administration with a commercial
quality, secure client/server database
application that was distributed
to over 500 Rehabilitation Service
Providers nationwide. The application
gave users the ability to manage
a dynamic database of nearly 250,000
clients. Users were able to keep
current client data by periodically
connecting to a centralized server.
Less than one (1) FTE was required
to maintain the centralized data
repository and to service the entire
user community.
|
|
Increased employee
productivity by automating the process
of issuing credit to customers for
returned products for the world’s
second largest generic pharmaceutical
company. Employee effort in issuing
returned product credits to all
Wholesale and Retail customers was
reduced by 85%. Enhanced customer
service by greatly improving the
speed with which returned products
are processed and by improving the
accuracy of credit amounts. As a
result, customer disputes involving
product returns have been reduced
by 10%.
|
|
Connected five (5)
office locations throughout the
East and Midwest by seamlessly integrating
each location’s database (synchronizing
and replicating data) for a leading
Electronic Systems Contractor. Salesmen
at each location are more productive
as they can now work remotely and
share resources such as a searchable
online product catalog including
more than 200 manufacturers and
over 100,000 products. Annual
profit margins now average close
to 20% in an industry that averages
8% to 10% margins.
|
|
Integrated information from multiple internal systems and an external B2B system by developing an custom order tracking system. By linking the internal systems and the tracking page of a shipper's website (such as UPS, FedEx, etc.), the system gives the customer service department and the distribution center the ability to determine the status of an order quickly and seamlessly - which allows customer service and distribution center employees to be more productive. This solution also eliminated the need for a customer service representative to return a customer's call in order to provide the status of orders.
|
|
Automated the process of mass producing sales orders. The client needed a way to generate thousands of orders for delivery addresses not accessible by their ERP system. Data from the ERP system was integrated with data from the EDI system and data from a separate database containing customer delivery addresses to automate the process. One customer service representative now generates orders required for a product launch in minutes - a task previously requiring three (3) days of manual effort for ten (10) staff members.
|
|
Provided a solution for a human resources department to generate employee benefit profiles for more than one thousand employees. The profiles include personalized content and several pie charts for each employee. An application was developed to generate these pie charts automatically from data located in an Excel spreadsheet. These pie charts were then seamlessly incorporated into the individual employee profiles. A task that previously required several weeks effort from two (2) employees is now completed by one (1) employee in a matter of days. |
