QAD Customer Value Day

basheddockSoftware and s/w Development

Feb 21, 2014 (3 years and 7 months ago)

90 views

QAD Customer Day


Santa Clara, CA

QAD Customer Value Day

WELCOME!







QAD Customer Day


Santa Clara, CA

CUSTOMER CASE STUDY:

BUSINESS
PROCESS AUTOMATION & INTEGRATIONS

Mounir

Hasbany
, Director IT and Business Applications, Miramar Labs

Ray Greenwood, SVP Consulting Services, Strategic Information Group


QAD Customer Day


Santa Clara, CA


Who is Miramar Labs


Case Study: Auto Invoicing Application


Automation & Integration Tools and Available
Solutions


Q&A

Agenda

3

Business Process Automation & Integrations


QAD Customer Day


Santa Clara, CA

QAD Customer Day


Santa Clara, CA

EXCESSIVE UNDERARM SWEAT IS A DAILY STRUGGLE FOR MANY, AND
IT CAN INTERFERE WITH NEARLY EVERY ASPECT OF LIFE

5

QAD Customer Day


Santa Clara, CA

Did you know that approximately
30 million

people
suffer from excessive underarm sweat?

U.S. adults ages 18
-
49 suffer from
excessive underarm sweat

(from clinically diagnosed to sweat
-
bothered)



sweat outbreaks per week on average


say it interferes with their daily activities

1 in 5

10
+

89
%

Source: Proprietary market research study conducted by independent company.
Market study w/661 consumers (# sweat events non
-
athletics related);
clinical segment clinically diagnosed by doctor, sweat bothered score >7
on 10 point scale on how much sweat bothers them. Data on file.

6

QAD Customer Day


Santa Clara, CA

7

SO NOT COOL…EMBARRASSING…FRUSTRATING…

QAD Customer Day


Santa Clara, CA

8


Founded in 2006 in Sunnyvale CA by The Foundry, a top
global med device incubator


Conducted research and identified large consumer
dissatisfaction in $14 billion global sweat and odor
control category


miraDry

system launched in 2011


The
first and only

FDA
-
cleared device for treating
excessive underarm sweat that provides a
lasting
solution

© 2013 Miramar Labs, Inc. All rights reserved.
miraDry
® is a registered trademark of Miramar Labs, Inc.

QAD Customer Day


Santa Clara, CA

miraDry System uses microwave technology

Hz

Microwave energy is ideal
for treating underarm
sweat.


Maximum destruction of
sweat gland network


Minimal impact to
surrounding tissues


Non
-
invasive

9

QAD Customer Day


Santa Clara, CA

How miraDry works


miraDry delivers precisely controlled
energy
non
-
invasively

to the region
where the sweat glands reside


Energy heats and
eliminates sweat
glands

*

“The ontogenesis of sweat glands is only at the embryonic period, so no new
sweat glands are regenerated after birth.” Li H, Gang Z, et al. Antigen
Expression of Human Eccrine Sweat Glands.
J Cutan Pathol

2009; 36: 318
-
324.


Since sweat glands
do not grow back

or regenerate,*
there is a dramatic and lasting reduction of sweat


miraDry cooling system protects skin during treatment


1
0

QAD Customer Day


Santa Clara, CA

Results patients can expect


Lasting

results


Sweat glands don’t come
back once eliminated


>90% clinical efficacy at
24
-
month study visit


Dramatic reduction


82%

average sweat
reduction*


Immediate results

* Clinical study data on file at Miramar Labs.

1
1

QAD Customer Day


Santa Clara, CA

Case Study: Auto Invoicing Application

QAD Customer Day


Santa Clara, CA

QAD
Custom Reports

Access

reports from outside QAD

Change Progress

Code in Linux environment

Configure a batch file

Pass arguments

Execute Reports

Retrieve PDF output

Email

reports

QAD Customer Day


Santa Clara, CA

Prerequisites

QAD


Code

Behind Change (SIG)

ODBC

Connectivity to QAD from Windows (SIG)

.NET

Framework / C# / Visual Studio

FTP capability into QAD Linux Server (SIG)

QAD Batch

ID Configuration (SIG)

Email

SMPT Server

SQL Server Database

QAD Customer Day


Santa Clara, CA

QAD Code Behind

QAD Customer Day


Santa Clara, CA

Compile QAD Code Behind

QAD Customer Day


Santa Clara, CA

Custom Invoice Report

QAD Customer Day


Santa Clara, CA

Batch Mode Flag

QAD Customer Day


Santa Clara, CA

Custom Invoice Report

QAD Customer Day


Santa Clara, CA

Batch ID Configuration

QAD Customer Day


Santa Clara, CA

Batch ID Configuration (continued)

QAD Customer Day


Santa Clara, CA

FTP Arguments to QAD Linux Sever

QAD Customer Day


Santa Clara, CA

QAD Linux Server Folder & File

QAD Customer Day


Santa Clara, CA

Command File Construction
-
Windows

QAD Customer Day


Santa Clara, CA

Invoke Command File
-

Windows

QAD Customer Day


Santa Clara, CA

View Scheduled Reports and History

QAD Customer Day


Santa Clara, CA

URL to View Invoice Report

QAD Customer Day


Santa Clara, CA

FTP Back Report File From Linux QAD

QAD Customer Day


Santa Clara, CA

SQL Query


Pending Invoices

QAD Customer Day


Santa Clara, CA

Raw QAD Data from SQL Query

QAD Customer Day


Santa Clara, CA

QAD Invoice Post and Print

Wake Up and Run SQL Query

FTP Invoice Number to Linux Server

Execute Invoice Batch File

FTP Back .PDF Report File

Convert PDF to Text Using
iTextSharp

APIs

Verify Invoice Number is Correct

Email Invoice to Customer

C#
.Net

WPF Application

QAD Customer Day


Santa Clara, CA

Automation & Integration Tools and
Available Solutions

QAD Customer Day


Santa Clara, CA

Automation & Integration


Integration Software Tools


QXtend


Standard XML
-
based interface to QAD Enterprise Applications


Supports
open standards such as XML, SOAP and JMS


Published native integration formats (
QDocs
) on QAD Web
site


SIG/Connects


Flat file and XML based import utility for QAD



Dell Boomi


Software
-
as
-
a
-
Service (SaaS)
integration software











Business Process Automation & Integrations


QAD Customer Day


Santa Clara, CA

Automation & Integration


List of Available Automation & Integration Solutions


Expenses Reporting: Concur


Shipping: FedEx, UPS, USPS


CRM: Salesforce.com


PLM: Agile, Arena,
Omnify


QMS:
Cebos
, Master Control, Pilgrim


Sales Tax: Cytak, Avalara
AvaTax


Payroll: ADP, Kronos







Business Process Automation & Integrations


QAD Customer Day


Santa Clara, CA

Contact your Strategic Account Manager for
additional information and
pricing.

Business Process Automation & Integrations



QAD Customer Day


Santa Clara, CA

Questions

QAD Customer Day


Santa Clara, CA

THANK YOU!

Mounir Hasbany

mhasbany@miramarlabs.com


Ray Greenwood

rayg@strategic.com