Category / Analyst / Architect / Business Analyst / Market Analyst / Product Designer / System Developer / Systems Analyst / Writer

Took whatever it was apart to see what is or is not working (then fix it).

    Loading posts...
  • Financial Tracking Database with Analytics

    Builder Reporting and Analysis Tools The software is designed as a BI management tool, not a comprehensive project management system. It won’t replace Quick Books or MS Project. It can replace all those Excel spreadsheets that keep track of pipelines and projects. Estimates Select a customer and define the elements for a job, including dates…
  • Database Query Performance

    The company wanted to compare their solution with several different products, including Tableau. They wanted to measure the processing speed for different data sets, not for delivery to the user, but for delivery to an analysis tool. They also wanted to better understand where they had any advantages over other tools. Being able to get…
  • Desktop to Web Application

    The company had an old desktop database system they wanted updated and web enabled. The new system needed to have almost the same features and options as the old system. The technical requirements for a web-based system were never going to allow an exact mapping of features. What was handled by the OS on the…
  • Global Trade: Food and Wine

    for Straw Hat Trading Company, LLC Global trade in wines and specialty food products was trending up in 2012. The demand for European and American wines in China was high. Canadian and Australian wines were at the top of Chinese buyer's lists. Market timing seemed good. The company partners began preparations for an initial product…
  • 130 Country Reporting System

    for the United Nations The UN Development Operations Coordination Office (DOCO) issued a procurement notice for creation of an online reporting database application to manage annual and interim reporting from 130 countries. The system had to be capable of tracking report submissions as well as aggregating the data for review. The current system was mostly…
  • Executive Briefing: SharePoint

    for Nassal The company was looking for options to better manage their global file sharing and project communications. They had several systems in place, but wanted a closer look at a SharePoint / Office 365 solution. They were not sure what the specific benefits would be or what they would need to do if they…
  • User Interface Wireframe

    for Tech Hero The company had developed a comprehensive suite of online management tools for their Franchisees. The components included CRM (Customer Relationship Management) tools, Inventory Management, Ordering, Invoicing, a Payment Gateway and Service Call Management along with collaboration and various reporting tools. During the initial training, franchisees reported their staff had lots of questions…
  • Customer Service Details

    for Tech Hero Consistent customer service is critical for building a national brand. Some variations are normal and desirable to accommodate regional and specific customer preferences. But these should always be minor variations. A customer at one location should be able to expect and receive the same service at any other location. The franchise brand…
  • Remainders Workflow

    for Office Depot Managing the remainders process in a retail environment is essential for inventory management. Markdowns are scheduled and executed in each store. Corresponding order and accounting activities must occur. The incoming VP of Inventory Management had been asked to work on eliminating remainders write offs. His team had been using the same sets…