Case Studies

Case Studies

rss

Case Studies

walmart-visioin-center-epochonline1.jpg

Walmart Needs Electronic License and Application Management System

The Need:

Walmart Optometric department requested a web-based License Agreement Management System that would allow optometric doctors and WalmartOD administrators to create, modify, and update License Agreements. Walmart business rules needed to be integrated into the system that would process these License Agreements.

This solution provides the following advantages:

  • More efficient terms negotiation information exchange (between Walmart administrators and optometric doctors)
  • Fewer errors during creation and certification of licensing agreements
  • Creation and automatic selection of agreement template definitions based upon business policy and location specific criteria
  • Electronic document storage, management and retrieval
  • Electronic "signing" of agreements by both parties
  • Management of agreement process with automatic notifications to stakeholders

Following is an outline of the functionality provided to users and by the production system:

Optometric doctors are able to do the following using the doctor web portal:

  • Submit application for License Agreement at approved stores online
  • Upload support documents
  • Preview and sign License Agreements

E-LAMS Administrators Control Dashboard:

  • Track and perform administrative tasks on Applications and License Agreements
  • Review and approve support documents
  • Inform stakeholders of application and License Agreement status and changes
  • Set up and maintain Scheduled Events for automatic Notifications
  • Create and modify Templates for merge documents

E-LAMS System (programmed elements of the web portal)

  • Merge and store License Agreements and related Template-based documents in an SQL database
  • Send notifications to stakeholders on status change of License Agreements or documents as the result of user actions

SEP Service (a Windows Service)

  • Send date-based notifications of License Agreement and Document statuses, uses SQL queue
  • Virtual SMTP for all sent email
  • Microsoft SQL logging
Since 1993, we've benefited from the trust, enthusiasm, and innovation of our partners. For small business and big business alike, we've provided out-of-the-box and custom Internet marketing solutions, as well as web-based, desktop, tablet, and phone applications—with all focused on results: increased revenue and cost-saving efficiency. Is it time to partner with Epoch Online?
 
 
Drop here!

Related Posts


  • AD-Screen-Search-Filtering-Sorting-Grouping32.jpg

    Application Development: Search, Filtering, Sorting, and Grouping - Part 1 of 4

    Search, Filtering, Sorting, and Grouping - Part 1 of 4
  • Tablet and Spreadsheet.jpg

    Company Needs Online Fee Estimator based on Excel and Related

    Using powerful 3rd party Excel library and Microsoft Excel itself, we've build and provided a dynamic web-based fee calculator hosting in the current website using role based and page based security and more. Technology used: Microsoft Excel, Spreadsheet Gear (spreadsheetgear.com), IIS, and ASP.Net.
  • entergy-epochonline-walmart-automate.jpg

    Epoch Online Helps Entergy Automate Analytics for Walmart

    Automation reduces a two-day, two-person, labor-intensive process (that wasn't enjoyed by anyone) to a 5-10 minute process. At the end of the day, the professionals who used to gather, organize, and build the presentation were freed up to do other things. The technology used: Microsoft SQL Server, Microsoft Task Scheduler, Microsoft SSIS, Datawatch Data Pump, Microsoft VBA, and Microsoft Excel.
  • banner-epochonline-power-bi-03.jpg

    Power BI - Part 3

    Part three of this three-part series addresses some of the additional benefits realized by our example client along with the reasons that decision-makers in the company found the Power BI system to be such a valuable solution. (Part 3 of 3)
  • banner-epochonline-power-bi-011.jpg

    Power BI - Part 1

    In part one of this three-part series, we review some circumstances that would lead an organization to decide to implement a BI (Business Intelligence) solution. In particular, we look at a manufacturing business that was tracking production data outside of their primary business application. (Part 1of 3)
  • crystal reports image1.PNG

    Dillard's Reporting Enhanced and Upgraded to the Latest

    Upgrading old technology to new technology is typically a challenge. The need for enhancements to get additional results and feedback often drives the need to make it happen, regardless. Technology used: Crystal Reports, SQL Server 2008, T-SQL Selects, SQL Views, Stored Procedures, Triggers, Export to Excel and .CSV for further manipulation, and VB.NET
ASP.Net, CSS, Email Notifications, HTML5, IIS, JavaScript, PDF, SMTP

Categories

Tags

.NET ASP.Net Content Management System Crystal Reports CSS Datawatch Data Pump Email Notifications Excel Exports FMS Tools HTML5 IIS JavaScript Microsoft Access Microsoft ASP.Net Microsoft Excel Microsoft SQL Server Microsoft SSIS Microsoft Task Scheduler Microsoft VBA MS SQL PDF SMTP Spreadsheet Gear SQL Server 2008 SQL Views Stored Procedures Triggers T-SQL VB.NET