WorkflowGen.com | Product | Demo | Buy | Services | Customers | Contact us

Entries in SQL Server (2)

BRD Finance

http://www.brd.ro/brd-finance-ifn-s-a/

Mission
BRD Finance is the consumer credit unit of BRD group, a Romanian bank owned by Societe Generale. BRD Finance wants to be the most important consumer credit provider in Romania and operate with more than 300 employees and representatives in all national territory.

Testimonial
"WorkflowGen offered us a way to a better finance request tracking and reporting providing us necessary tools to understand and see how is our business going on at any moment in the past or today.
Due to huge volume of processing after 4 months from production launch we needed a solution to speed-up the system. Advantys and NESS Romania offered us a solution based on a secondary WorkflowGen site for archiving purposes that was freeing-up our main database, thus the production site was able to concentrate on the current business we have."

Crenguta Profir, Operations Manager .


Business Challenge
Approving credit request was a manual process that involved a lot of paper handling and storage. Reviewing dossiers or making reports was very slow with the impossibility to grasp an accurate present view of business.
A solution to overcome this situation was needed. Also budget limitation was imposed.
 
WorkflowGen Solution
Functional Solution
The implementation of WorkflowGen enabled the Backoffice team to define and launch first process in a couple of weeks. After the first process was in production and the management team was able to run sophisticated reports, another three processes were created then modeled within WorkflowGen.

Technical Solution
The SQL Server version of WorkflowGen Advanced was installed. ASP.NET forms were implemented. Archiving site was installed later on, using the same forms applications as the production site.

Associated documents, in no need to be modified, were uploaded into IIS virtual directory and they are available for later review either from the WorkflowGen production site or the archiving site.

A separate data warehouse database collecting the data from each workflow form was created for fast reporting. Also a bulk notification solution was implemented to model email notifications at predefined intervals, independent of the status of the processes.
 
Benefits
Immediate productivity gains
The implementation of the processes with WorkflowGen enabled the reduction of paper flows, and low added value activities.  Above all, it  dramatically reduced the average processing time per request. Reports that were difficult or impossible to be created before are now available in matter of minutes enabling better decision making process.  Currently the production site processes between 1000 and 3000 new requests daily, each staging through multiple actions that can be completed in one ore more days, based on particulars of the request.

Ease of use
The end users access WorkflowGen via their Web browser and launch their requests without any need for training due to friendly end-user interface. The unlimited user license of WorkflowGen Advanced allows BRD to expand its operations base worry free. In six months the number of users increased more than 100%.

Archival
The archiving site enables the organization to create a comprehensive archive with fast access to all closed requests and associated documents. The use of separate WorkflowGen archiving site also leaves the production database free of historical data enabling fast execution of processes anytime in the future.

Posted on Tuesday, September 11, 2007 at 04:12PM by Registered CommenterWFG Team in , , , , , , | Comments Off

Korean Air

http://www.koreanair.com/

Mission
Korean Air, owned by The Hanjin Group, currently includes 21 domestic and 19 overseas subsidiaries, with 33,500 employees.

Korean Air was looking for a software tool that would quickly automate the company’s unique in-house manual administrative processes at the ITDC* located in Los Angeles. 

Testimonial
"WorkflowGen is a (software) tool precisely designed to take care of automating any business workflow process. Wherever there is a form and a process, WorkflowGen can be applied very quickly to convert a manual process into a systematic process. Besides WorkflowGen’s simple and straightforward method to handle form and flow, it allows interfacing to external resources, at any step of a flow, a snap. For Business Intelligence (BI) reporting, we could integrate steps to write customized log records, which will serve as a base for all BI reporting."
Inkee Lee, Vice President and Deputy Director, ITDC for Korean Air. 
 
Business Challenge
Korean Air sales executives were seriously bogged down, trying to manage their travel agent incentive voucher system, a key component to the Korean Air client service process. 
 
WorkflowGen Solution
Functional Solution
As a part of their account management responsibilities, the executive sales staff at Korean Air was using traditional, semi-manual means to manage the administrative details and approval processes for handling travel agent incentive program.  Phone calls, emails, paper instruction forms, and physically “tracking down” associates, all had proven to be consuming far too much time, and not getting a integrated view of all the activities in time.

After researching the market for an affordable software solution that was powerful, but easy to use, Korean Air selected WorkflowGen®. Now, only days after implementing the software, each step of the travel agent incentive authorization procedure has been reduced to a simple, step-by-step, automated process.

Technical Solution
The SQL Server version of WorkflowGen® was installed, as well as a connector for the Active Directory to automatically synchronize and retrieve the user details. The Portlet module enabled Korean Air to populate the Intranet Portal with data that came from WorkflowGen® (actions to do, current requests, past due requests, etc). The SDK module enabled Korean Air to create custom workflow steps that provided connectivity to external data sources so forms could be pre-filled and action results could be utilized.
 
Benefits
Immediate productivity gains were delivered through efficiency, accuracy, and accountability. The new workflow expedited this important administrative process and begin accumulate data for automated executive reporting.

Fast Deployment
The Korean Air staff was successfully developing workflows shortly after the four day WorkflowGen® training.

Ease Of Use
After identifying WorkflowGen’s® ease of implementation and use, Korean Air is planning to take the application enterprise-wide, pending final review by the global IT director.


*ITDC (Information Technology Development Center) is located in Los Angeles and is part of Korean Air's IT department. ITDC acts as a new technology solution finder to improve the MIS environment for the corporation. 

Posted on Saturday, August 11, 2007 at 05:49PM by Registered CommenterWFG Team in , , , , , | Comments Off