Solutions

Industry Problem Solution
Accounting Enter mass donations captured by the bank through a lockbox Design and build a program to read the incoming lockbox file and type the information into data entry screens without modifying the data directly.
Accounting Notify missionaries when expenses are paid Design and build a program to process an A/P output file, distributing the results to personal email addresses.
Accounting Develop policy-based personal missionary budget forecasts used to raise support. Design and build a budget forecasting tool that allows for what-if analysis, protection of approved budgets and distribution to multiple email addresses. Provides mass copy and calculation of annual budgets to speed the work.
Banking Track private loans by household Design and build a program that allows a private banker to manage a portfolio of private loans.
Child Care Reduce the burden on teachers of recording skill observations and reporting for hundreds of children. Design and build two different systems to track children through a managed care system. Web-based system follows the child from application through assessment and reporting.
Finance Identify requirements for a new workflow system and help evaluate vendors Conduct interviews. Document necessary features. Write a demonstration script based on core requirements. Assist with vendor evaluation during demonstration.
Finance Get contribution data to missionaries in the field. Write a utility that creates an import file for the tntMPD program.
Healthcare Capture, scientifically score and award grant applications for cancer research. Convert a sophisticated DOS-based grant application tracking system to Windows
Hospitality Manage club member trips to different countries Design and build a trip/event management system that tracks membership, event attendance, costs and margin.
Insurance Transportation claims processing company growth bottlenecked by heavy manual labor to produce monthly reports. Designed and built a system to publish monthly bordereaux reports for clients. Reduced 50 hours per month to less than one hour.
Insurance Aviation insurance agency processing quotes in spreadsheets. Hard to share data, control rules, and maintain calculation logic. Designed a new database model to move application to a web application model.
IT Services Speed up check-in of members at luncheons Enhance an existing Access application
IT Services Identify needs for, and then acquire an enterprise information portal. Interview users, facilitate meetings and direct the writing of an RFP that was distributed to 30 vendors. Issue preparatory RFI to educate the team. Help evaluate responses, guide the demonstrations and finalize selected vendors.
IT Services Clean up temporary files left behind by another application. Write a utility to delete files in a given set of directories by filename patterns.
Medical Education Deliver patient education content into hospitals via the web Design and build a solution in ASP.NET that authors, reviews and publishes controlled, structured content.
Manufacturing Quickly check out and back in expensive tools Design and build a program to check tools in and out using barcodes.
Other Capture time and activity for call center employees Build a call-center study tool for resale.
Project Management Manage short-term mission projects around the world. Design and build a project tracking system including budget, personnel, materials, travel and work assignments.
Retail Make sure people pay monthly rental for their computer Create a program that launches at boot time to verify a date-sensitive code before allowing the user to continue.
Retail Manage satellite TV sales and commissions Design and build a point-of-sale system for satellite TV sales for resale.
Retail Manage order fulfillment activity and reconcile online sales. Build a sales tracking and merchant account reconciliation system integrated with the web shopping cart.
Retail Manage referrals of affiliates and collection of commissions due. Design and build a solution using ASP, SQL Server and email that automatically matches referrals by distance and skills, notifying parties by email.
Retail Update custom database access from the web to be HIPPA compliant. Redesign data tables, removing the use of social security numbers as the primary (and visible) access mechanism.
Security Capture billable time for mobile security workforce and relay to financial system. Document, design and deliver a payroll time and billing system that integrates with Lawson Financials
Software Variable costs on large projects and no senior analysts to properly scope the solution. Our requirements analysts perform rapid structured interviews to fill in our well-defined Dynamic Blueprint. This provides crisp definition of scope for proper bidding.
Telecom Standardize telecom audit account management and handle increasing volume of clients. Analyze work process and specify requirements for a new system.
Utilities/Energy Standardize utility audit account management and handle an increasing volume of clients. Design and build a web-based audit tracking system that imports bills and runs analytical reports for customers over the web.
Web Design Multiple web sites for an international manufacturer needed consolidation and redesign. Interview 35 stakeholders from C-level to end customers. Gather requirements from interview results. Design information architecture and web site.