Helping Our Clients
I am pleased to provide you with an update on our client projects. Projects we have completed over this period include...
Producing Accurate Costs
Worked with this manufacturing client to assess options for producing an accurate composite cost across various plant locations and manufacturing configurations, devising a cost-effective approach for system-assisted creation of composite costs.
System Modifications for New Offshore Plant
Overseen the business system and integration system modifications affected by a change in routing goods between domestic and offshore plants, and conducted extensive review and testing of these changes, allowing this apparel manufacturer to quickly adapt its production flow to respond to changed business priorities.
EDI Processing Automation
Created the SQL Server scripts and triggers to automatically convert over twelve different EDI documents to XML records, and vice-versa, and performed extensive testing of these items, automating inbound and outbound processing between our client and one of its major customers.
Creating EDI Document Definitions
Used XML technology to create the definitions for over 75 different EDI document types, based on "in process" and incomplete EDI specifications unique to the Federal government, and extensively tested the document definitions, allowing our client to meet a tight timeframe and retain a major contract.
Validating Report Definitions
Validated and, as needed, reconstructed the Access- and Excel-based queries and analyses used by several former employees for month-end reporting, enabling the new employees to quickly learn these processes and produce needed management reports, and laying the groundwork to develop robust reporting through SQL Server.
Assisting with Building Move
Worked with our client to plan and manage the acquisition and installation of new servers, phone and data services, and other technology infrastructure upgrades coordinated with a physical building move, minimizing downtime during the move and freeing company personnel for day-to-day operations.
Survey Analytics and Information for a Data Warehouse Project
Began identifying the analytics needs of line-of-business users, and surveying available information to satisfy these needs, helping this client move forward on a high-visibility business dashboard project, while strategic goals are still evolving.
Future projects we are planning include...
Business Analytics Increase Government Revenues
Develop sophisticated screening, matching, and cross-referencing routines to simultaneously analyze multiple data sources, allowing governmental entities to comprehensively search for additional revenue opportunities.
Resolving EDI Implementation Issues
Support the implementation of numerous EDI documents aggressively resolving issues on daily and weekly inventory reconciliation transactions required to retain a major contract, and improving processes to achieve faster order fulfillment.
Business Process Improvement Assessment
Work with this rapidly growing services company to assess key business processes and review related technology usage, recommending changes to reduce costs, cut cycle time, or improve quality, thereby improving operating efficiency and effectiveness.
Extending EDI Documents to Commercial Contracts
Extend the XML technologies used to create EDI documents for the Federal government to commercial contracts, achieving full inbound and outbound handling of sale and purchase transactions, improving the accuracy and reducing the costs of transaction processing.
Evaluating Outsourcing and Cloud-Based Computing Options
Advise this professional services firm on various technology options, helping them understand the costs, benefits, and trade-offs of extensively using outsourced IT support and cloud-based computing, to help simplify IT management, increase system availability, and improve the user experience.
Reengineering Report Methodology and Delivery
Work with this fast-growing firm to upgrade its management reports to SQL Server reports deployed through the corporate intranet, improving the data consistency, presentation flexibility, and information delivery for daily, weekly, and monthly reports to the entire executive and management team.
Design, Develop, and Deploy a Data Warehouse and Dashboard
Select the On-Line Analytical Processing (OLAP) and Dashboard tools, design the detailed data schemas, train client developers on preparing Extract-Transform-Load (ETL) routines, and oversee all development and deployment of a data warehouse and summary dashboard, giving executives and managers tools to ensure day-to-day decisions fit within the overall strategic plans.