Helping Our Clients
I am pleased to provide you with an update on our client projects. Projects we have completed over this period include...
Systems Integration
Integrated several disparate call center and other client service programs into a single application, allowing all processing to share the same underlying framework for work queue management and productivity reporting, reducing maintenance effort and improving management decision-making.
Automating Financial Transactions
Automated the creation of financial transactions from the completed research and resolution of denied or rejected claims, eliminating time-consuming and error-prone manual transactions, and freeing time for research and collection calls.
EDI and XML Translations
Designed and developed the processes and technologies needed to translate EDI documents to XML in order to interface with the business system, and then translating the XML to EDI documents to transmit to the federal government, allowing this client to retain a major contract and process high-volume transactions, while dealing with inconsistent or outdated EDI specifications.
Estimating Software: Testing and Deploying
Conducted final testing and oversaw the deployment and shakedown of a custom estimating application for this supplier to commercial construction contractors, applying technology to quickly and efficiently respond to requests for estimates, while also ensuring accurate pricing calculations for many complex parts and processes, helping management maintain tight control of pricing in an exacting industry.
Automating Receivables Reconciliation
Assisted this property and casualty insurer in automating the reconciliation of agent-due receivables across multiple business systems, reducing time requirements and improving accuracy in this labor-intensive process.
ERP System Rollout
Managed the cutover, resolution of post-implementation issues, and implementation wrap-up of this company's manufacturing facility and distribution center to a new ERP system, minimizing operational disruptions while accommodating the annual audit of physical inventory.
Future projects we are planning include...
Testing EDI Documents
Develop coding requirements to process and scripts to test poorly documented industry-specific EDI specifications, and then extensively test many sets of transactions and resolve problems discovered, helping this client satisfy the time-critical needs of their largest customer.
Integrating Billing Validation Processing
Incorporate the output of a billing data validation program into a call center work management queue, eliminating work by field representatives, consolidating processing of these and other validity checks, and speeding resolution of potential billing problems, all contributing to faster payment.
EDI Processing Automation
Create the SQL Server scripts and triggers to automatically convert EDI documents to XML records, and vice-versa, automating inbound and outbound processing between our client and one of its major customers.
Define Business Requirements for a Data Warehouse Project
Identify the analytics needs of line-of-business users, determine whether information is currently available to satisfy these needs, and incorporate all this into an overall requirements document to guide the design and development of a data warehouse and the selection of a dashboard or similar presentation tool, helping this client implement metrics to track progress toward still-evolving strategic goals, while meeting an aggressive timeframe.
Evaluating Contract and Service Profitability
Develop a data cube to mine for potential revenue enhancement possibilities by analyzing actual reimbursement patterns, net of contractual and other allowances, for services performed, allowing this medical testing services provider to assess the true profitability of its contracts and services, and then to knowledgeably work to enhance profit through contract negotiation and operational improvements.
System Screening for Business Spinoff
Assess the financial systems needs of this spinoff company, screening systems and vendors to ensure key functional and business system integration needs are met, and vendor capabilities and resources are adequate, helping this company meet an aggressive startup schedule.