EDDIE AUYEUNG

Consulting Experience

Current Client, CT 09/2011 – present

Designed, developed and implemented complex solutions involving access management activities

that are part of the integration among Aveksa, SCR, HP Service Manager and ITIM. Developed expert

level knowledge in customized consolidator which functions as a hub for transaction streamlining and site

specific routing. Performed proof of concept on REST web service utilizing RESTEASY, JERSEY,

Jasper Reports and struts2.

Tech environment: J2EE, JBoss App Server, UNIX, Oracle, Tivoli, SQL Server, DB2, Tomcat, Eclipse,

Spring, Ant, Maven.

United Health Group, Rocky Hill, CT 04/2011 –09/2011

Architected a web portal to be used by authorized users to access federated health care data. This data

comes from multiple organizations (Medicare/Medicaid/NIH/United Health group etc) and is assembled

and mapped in a virtual data zone and is encrypted and summarized to avoid privacy issues. Did proof of

concept by modifying open-source Pentaho Metadata and related code to utilize Metadata Query to allow

dynamic generation of SQL.

Tech environment: J2EE, JBoss App Server, Liferay Portal, Pentaho BI Suite, Oracle, Tomcat, Eclipse,

Spring, Ant, Maven. Role based Access Control.

United Technologies, East Hartford, CT 01/2010 –03/2011

Designed and built an electronic engine log workflow application consisting of intake, validation, update,

assembly and dispatch processses. Thevarious steps in the workflow interfaced with a Java layer made up

of JSF, WebSphere MQ/JMS and EJB3. Drools Rules Engine was used for the validation. The BPM was

developed in an WebSphere Application Server environment. JMS/Websphere MQ was used as the

message transport between the Java layer and the BPM engine.

Designed and built localized fuel consumption data capture facility utilizing FLEX, Mysql, PHP, J2EE,

Flash, AIR, EPG and Life Cycle Data Services.

Tech environment: J2EE, Websphere App Server, Drools, EJB, Oracle, Tomcat, Oracle BPM, Eclipse,

Apache, LAMP, jQuery, Spring, SDLC

BenefitsXML, Glastonbury, CT 03/2009 –09/2009

Designed and built an audit facility to allow authorized users to track changes made to

employee/dependent demographic data as well as benefits enrollment data. The functionality summarized

the activities in chronological order from which detailed information could be drilled down into.

Tech environment: J2EE, WebLogic, Hibernate, EJB, Oracle, XML, Eclipse, Web Services, IntelliJ

ESPN, Bristol, CT 09/2008 –03/2009

Designed and implemented a media assets management application for the client to handle the annotation,

editing, archiving and retrieval of vast amounts of multi-media entities by the client on a 24 X 7 basis as

part of the network’s daily business. The application had multiple front ends utilizing FLEX and AJAX

which made asynchronous calls to the backend and the persistence model was based on Hibernate, JPA

and EJB3 wrapped in web services exposed via proxies. Mysql was used as the database on the PDAs

maintained by the FLEX/PHP application.

Designed and built a Watch/Sync application deployed as a JBoss service. This application loaded into

memory at startup a number of options made configurable via the JBoss deployment descriptor as well as

the snap shot of the persisted state of items to be watched from the database. It then executed a listener to

the container(s) being watched and posted changes detected to a Drools Rules Engine which in turn fired

processes to sync up contents within these containers across multiple locations.

Tech environment: J2EE, JBoss, Hibernate, EJB3, Oracle, JPA, SDLC,XML, JSON, Eclipse, Web

Services, AJAX, JMX, Mysql, PHP, Life Cycle Data Services, Apache, BlazeDS, Mbeans, Drools Rules

Engine, BlazeDS, AIR, Flash, LAMP, jQuery, Tomcat, Spring

Aetna Health Insurance, Middletown, CT 03/2008 – 09/2008

Architected solutions to health care business problems involving interactive voice response and

subscriber oriented health incentive programs. Advised development team on design options in line with

Aetna enterprise infrastructure and project life cycle. Engaged as an integrated part of project team and

championed project from inception to design/development. Work with business to translate business

needs into functional requirements and generated preliminary solutions in conjunction with

business/infrastructure/development representatives. Drove high level/detailed designs on architecturally

significant components based on Aetna internal standards and presented and articulated proposed

solutions to architecture review group. Put together architectural artifacts to form a repository

representing point-of-time and finalized architectural conceptual design. Worked with multiple parties to

resolve time/budget constraints and resource contention issues. Communicated with infrastructure/fellow

architects/enterprise framework group to ensure best practices and address scalability/reusability issues.

Tech environment: J2EE, WSAD, WebSphere, Spring framework, Siteminder, LDAP, XML,

JBoss/Tomcat/ANT, Db2, Eclipse, SDLC,RSM, MQ, Web Services, WSDL, BPEL, Linux, Spring

Knights of Columbus, New Haven, CT 01/2006 – 02/2008

Participated in the rewrite of a number of Cold Fusion based web applications into the J2EE environment.

The rewrite resulted in full J2EE compliant applications utilizing best of breed design patterns which

enhanced the scalability and capability of existing functionalities and at the same time added major

functionalities in the areas of member management and member billing for the organization. Personally

responsible for putting together the architecture and developing many of the major components in the

presentation, business and data access layers of the application. Designed, developed and implemented a

web based reporting system utilizing open-source Jasper Reports to replace a SQL Server Reporting

Services (SSRS) System. The new reporting system leveraged the existing report request and data

gathering front end but made calls to Jasper instead of SSRS to render reports on line in either PDF or

Excel format. Utilized Filenet to Interface with Java applications.

Tech environment: J2EE, WSAD, WebSphere Spring framework, TAM, LDAP, Jasper Reports, XML,

JBoss/Tomcat/ANT, Db2, Eclipse, SDLC,Cold Fusion, IIS, Visual Studio.net, Linux SQL Server

Reporting Services, Tivoli Access Manager, WebSeal, Jasper, DTS, VbScripts

Mohegan Sun, Uncasville, CT 09/2005 – 01/2006

Designed and developed a SOAP based web service to be consumed either by a web-based or batch client

(for internal usage). The web service was deployed on Websphere application server and accepted xml

based parameters to handle patron inquiries and check-cashing activities.

Built Java interface to exposed services to Lotus Notes/Domino originated Java Agents utilizing MQ

Series and JMS as the message transport layer and Hibernate as the data access framework. Castor and

XStream were used to map data back and forth between objects and xml. As a proof of concept effort put

together a process to take xml schemas from the gaming industry standards association and generated

Java source code and a set of mapping files to handle bi-directional xml/object mapping. Also built test

clients to validate the generated artifacts. Eventually these objects would be integrated into the Mohegan

Sun environment at protocol and application levels to conform to industry Standards.

Tech environment: J2EE, WSAD, WebSphere MQ, Hibernate, Castor, XStream, XML,

JBoss/Tomcat/ANT, SDLC,Db2, Eclipse, JMS, Linux, Spring

Bank of America, Windsor, CT 03/2005 – 09/2005

Architected, developed and implemented a mission-critical multi-threaded Java application which

spawned simultaneous processes generating outbound and receiving inbound MQ messages to/from

multiple locations. On the outbound side the application polled the bank’s customer transactions database,

converted the result sets into XML and sent them as MQ messages either via a name-list or point-to-point

mechanism to multiple remote processing facilities to produce CD-ROMs and other finished products to

be delivered to the customers. On the inbound side the application polled the incoming queues and

updated the appropriate database tables based on the payload. In consideration of peak hour volume

requirements and concurrency issues the processes were designed to be configurable so that an optimal

number of messages to be processed could be specified at run time for each iteration to streamline the

data flow. Oracle database connection pooling was used.

Tech environment: J2EE, JBuilder, WebSphere MQ, Castor, XStream, XML, JBoss/Tomcat/ANT,

Oracle, SDLC

Cigna Health Care, Bloomfield, CT 11/2004 – 03/2005

Participated in the architecture and development of the client’s implementation of a new web-based

Interactive Voice Response (IVR) application. The application provided a mechanism for the internal

users to validate the outgoing responses generated by the incoming calls to Cigna’s automated number

(250,000+ calls a day) before it got transformed from data to voice to be heard by the caller. It also

allowed quick simulation of test data. The architecture was based on translating the response Java objects

(result beans) into xml and presenting the xml either on web pages or RTF /PDF documents via

generalized dynamic form/document construction. This was made possible with one single generic JSP

and struts action class working in conjunction with XSL style sheets. The transformation of xml to html

on the web page took place on the browser while the rendering to RTF/PDF occurred on a java class

utilizing XSTREAM and FOP.

Tech environment: J2EE, Struts, WSAD, UDB, XSLT/XSL-FO, JavaScript, JSP, JBoss/Tomcat/ANT,

XML, HTML, JDBC, JSTL, XStream, VoiceXML, IVR, Linux, CygWin, FOP, Eclipse, SDLC

Hartford Life Insurance Company, Simsbury, CT 06/2004 – 11/2004

Participated in the architecture and development of the client’s implementation of a new web-based

online enrollment application for the Group Benefits Division. Personally built a number of critical

components including a census import/export facility and a pre-enrollment package generation utility. The

import facility allowed internal users in the enrollment unit to access an excel spread sheet in the same

physical storage location in Network Attached Storage (NAS) regardless of what operating system the

online environment app was running under. The census data on the spread sheet could be in any order and

could have any column headings. For each column on the spread sheet the user was given an opportunity

to select from a drop down the target database column to map to. Java Transaction API (JTA) was used to

enforce logical unit of work at the participant level (bean managed as opposed to container-managed

persistence) so that in the case of an error all updates to various tables related to the participant could be

rolled-back. Asynchronized the process by developing message driven beans and configuring the

WebLogic application server. JexcelAPI and JXL were used to parse and manipulate the contents of excel

cells thru POI/HSSF methods. The successful import also included an encrypted password for the

participant to be written to the database and an unencrypted password along with a generated id to be

written to LDAP to allow subsequent individual online environment. The export facility was essentially

the reverse process which allowed the user to export census data into a spread sheet under NAS regardless

of operating system. The same Java/Excel interfaces were used and Blaze Advisor was called to provide

some of the final census statistics. The pre-enrollment package generation utility incorporated Java, XML,

XSL-FO and JMS technologies. This utility allowed an internal user to initiate an asynchronous process,

made possible by JMS, whereby data was extracted into a set of XML documents and formatted based on

XSL-FO style sheets, to be rendered in RTF, PDF, Microsoft Word and other formats.

Tech environment: J2EE, Struts, IntelliJ/IDEA, Oracle 9i, JavaScript, JSP, JBoss/Tomcat/ANT, XML,

HTML, JDBC, JSTL, Business Objects, XSL-FO, JEXCELAPI/JXL/POI/HSSF, JMS, JTA, EJB,

XStream, LDAP

HealthMarket Inc, Norwalk, CT 05/2004 – 06/2004

Participated in the design and development of the client’s implementation of a new episode health

insurance product. Wrote Struts action classes and adapters to call web services to perform

physician/facility search based on responses to dynamically constructed questionnaire. Created XSLT

processing servlet and style sheet and Java server pages to display the xml returned from the search.

Tech environment: J2EE, Struts, Eclipse, Oracle 9i, JavaScript, JSP, XSLT, JBoss/Tomcat, XML

Hartford Life Insurance Company, Simsbury, CT 10/2003 – 03/2004

Worked on a J2EE compliant, Struts-powered intranet application for the Group Benefits Division called

Sales Office Dashboard Application (SODA). This application will allow management to monitor and

report various sales activities and will interface the departmental data warehouse to generate a score card

to be used by the nationwide sales force. Designed and developed this mission-critical application based

on model-view-controller principles and design patterns incorporating reference data caching, dynamic

drop-down filtering, database connection pooling and other best practices.

Tech environment: J2EE, Struts, JBuilder, Oracle9i, Siteminder, Tomcat, XML, HTML, JDBC, Eclipse

National Grange Mutual Insurance, Keene, NH 06/2003 – 09/2003

Worked on a prototype as part of a proof of concept for the client to evaluate the feasibility and scope of

replacing an existing legacy claims application with a web-based application. The prototype took the

payment process of the claims application and re-engineered it into an N-tiered architecture composed of

a browser based front end, a business logic mid-layer and a data access backend.

Built Java Server Pages/Java Beans/JavaScripts to interface with HostBridge software for main frame

access.

Tech environment: J2EE, WSAD, JavaScript, JSP, HostBridge, JDBC, XML, HTML, WebLogic, Eclipse

Cigna Health Care, Bloomfield, CT 03/2003 – 06/2003

Member of a team that designed and developed a common service hub for the Health Insurance Privacy

Act of America (HIPAA) implementation for Cigna Corporation. Wrote cross platform Java Programs to

parse/validate/format/translate feeds from Cigna claim systems and marshal results to MQ in xml format

to be processed by CrossWorlds/WMQI and downstream systems. Worked with infrastructure, network

and MQ support teams to optimize queue depth, queue length and size of data to marshal. Utilized JAXB

API to generate Java interfaces based on Xml schema specifications and OS/390 JRIO API to handle

main frame based Data accessed by the Java executables residing in Unix.

Tech environment: J2EE, JAXB, WSAD, OS/390 JAVA, UNIX, XMLSpy, JRIO, MQ Series, UDB,

JDBC

Hartford Insurance Group Personal Lines Department, Farmington, CT 11/2001 – 02/2003

Member of a team that built a major imitative for the Hartford AARP Auto Insurance website. Personally

responsible for developing a large number of front end components as well as the underlying Struts

objects such as the form, detail, adaptor, model and action classes which were all critical components of

the framework.

Tech environment: J2EE, Struts, Visual Cafe, WebLogic, UNIX, JSP, HTML, JavaScript,

Jakarta/Tomcat/Ant

Hartford Insurance Group Actuarial Services, Hartford, CT 12/2001 – 01/2002

Worked with client management, business analysts and technical staff to develop a prototype for an

intranet error reporting and correction facility. The completion of this prototype successfully

demonstrated to the client the viability of the solution.

Tech environment: J2EE, Visual Age for Java, ASP, HTML, VBScript, IIS

L.L. Bean, Freeport, ME 06/2001 – 10/2001

Participated in the design and development of critical components needed for a major facelift of the

client's website. Built PowerBuilder interfaces to offer the client the flexibility of deciding at runtime how

product attributes would be computed and displayed on the internet. Wrote Java classes to encapsulate the

parsing of user input to derive the formulas used in subsequent calculations. Did major rewrite on Product

Attributes and Site Data Management systems to accommodate the capture and use of compound and

measurement attribute specific to the internet. The above allowed the client to implement mission-critical

functionalities such as comparison charts, related HTML editing, dynamic web page generation and

quick-read mechanisms which gave the client an edge over its major rivals in competing for web-based

direct sales.

Tech environment: J2EE, WebLogic, UNIX, JSP, HTML, JavaScript, UDB, PowerBuilder, PowerTools

Ames Department Stores, Rocky Hill, CT 06/2001 – 06/2001

Wrote email service to intercept specific email messages on the Ames Exchange mail server. These

messages were then subjected to special handling, reformatted and rerouted to predetermined

destinations.

Tech environment: J2EE, Visual Age for Java, JavaMail API

Cigna Health Care, Bloomfield, CT 09/2000 – 06/2001

Part of a small team engaged in the design and development of a Java based enterprise-wide framework

for all of CIGNA. Built prototypes for connectors to CICS, IMS, and MQSeries from mid-tier

applications via the IBM Common Connector Framework utilizing the persistence component of the

framework. This persistence layer would interface with I-Bus, the corporate standard that CIGA had

chosen as the mechanism for data communication across multiple platforms in batch, real-time and near

real-time mode. On a separate project wrote a Java client and a C++ DLL to be called by the Java client

via Java Native Interface. The C++ DLL interfaced with an EDI application which processed the

transactions captured by the Java client.

Tech environment: J2EE, Visual Age for Java, WebSphere, UNIX, JSP, HTML, UDB, JNI, C++, JDBC

Hartford Insurance Group Personal Lines Department, Southington, CT 05/1999 – 08/2000

Worked as a member of the Personal Lines Internet development team to implement a full scale e-

commerce solution. The project interfaced with various websites offering on-line insurance quotes such as

The Insurance Mall, Juno, Quicken, InsureQuote and SEMCI on a real-time or batch basis. Developed

mechanism to parse, edited and formatted the incoming XML data stream to pass to the rating engine on

the Hartford host main frame and returned the completed quote to the consumer, again formatting the

result in XML. Enterprise Java Beans (EJB) in BEA WebLogic containers were developed and deployed

utilizing JNDI and LDAP to invoke remote methods (RMI) and MQSeries was used as a bridge to the

main frame. Personally responsible for the design and development of a number of critical components

such as a mechanism to map data elements to and from a domain object model from the browser and the

main frame for the request and response leg of the workflow and a startup process occurring at regular

intervals to parse the input queues for selected activities to trigger stored procedures to be executed,

resulting in the capture of customer profiling information.

On a separate project with the same department re-engineered a main frame stuffer generation process on

the client server to reduce the turnaround time from two to three weeks to a day for the Personal Lines

Auto Policy Dec Page Issue Process. The new PFC based PowerBuilder application provided a wide

range of functionalities and supported users on multiple locations. This was a one-person fix-priced

project and I did everything from feasibility study to prototyping to development to deployment and

managed to finished on-time and within budget.

Tech environment: J2EE, Visual Cafe, WebLogic, UNIX, JSP, HTML, JavaScript, Oracle, EJB, JNDI

Hartford Insurance Group Environmental Claims, Hartford, CT 08/1998 – 05/1999

Environmental Claims data was inherently complex because of the large number of entities which made

up the data structure and the degree of interdependency among these entities, not to mention the sheer

amount of data. The customer was faced with a situation where the current database consisting of 300 or

so tables had reached a point where it could no longer satisfy the business needs. A new database was put

together doubling the number of tables. A full scale, one time conversion, however, was out of the

question as the data required a fair amount of cleanup and the customer was not in a position to wait for

all of that to finish. Developed PowerBuilder objects and PL/SQL based stored procedures to provide the

customer with a mechanism to selectively convert data after each phase of the cleanup. The wizard took

the selected accounts, looked for policies, claims, losses, legal info, and everything else associated with

these accounts, drilled down to the last data element, made decisions as to whether it needed to be

converted/translated/dropped and then proceeded to populate the new database with the converted values

IN THE PROPER SEQUENCE.

Once developed, this procedure was run time and time again and no referential integrity issues were ever

reported with data in the current conversion or previous converted.

Tech environment: PowerBuilder, PFC, Oracle, PL/SQL, Stored Procedures

Hartford Insurance Group Actuarial Services, Hartford, CT 09/1996 – 07/1998

On client's request performed an in-depth analysis on a mission-critical legacy IMSDB/TELON based

main frame system to advise on rewrite options. Captured sample data and developed a prototype to

demonstrate the feasibility of rewriting the system in a client server environment as opposed to trying to

patch up a system on its last leg. The effort resulted in a formal project proposal and an enthusiastic

acceptance on the part of the client. I led a team to put together a system consisting of a PowerBuilder

front end, an Oracle back end, an intranet component and a daily feed to the main frame. Gathered

business requirements and conducted jointed sessions between business customers, network, database and

infrastructure support teams to generate functional specifications. Besides acting as the architect, I also

built a number of critical components such as an object type wizard and an explodable feature and a

number of C/C++ modules to aid in the data conversion.

Tech environment: PowerBuilder, PFC, C/C++, Oracle, UNIX

CBS Networks, Shelton, CT 08/1996 – 09/1996

Built capability to accept incoming Nielsen ratings data and to bulk-load Oracle databases.

Tech environment: PowerBuilder, PFC, C/C++, Oracle

United Technologies (Pratt and Whitney), East Hartford, CT 05/1996 –

08/1996

Developed C/C++ interfaces to Oracle to allow synchronization of Oracle-based nodes on multiple sites.

This was part of the CACTUS Project for reporting of engine problems to a local node to trigger

synchronization worldwide on a near real-time basis. Work involved dynamically allocating memory to

handle large blob data types, programmatically compressing the data at the sending end, expanding and

validating it at the receiving end and parsing the SQL statements to take the appropriate update action on

the remote node(s).

Tech environment: C/C++, Oracle

State of Connecticut, Hartford, CT 12/1993 – 05/1996

Worked as a member of team on a multi-tier client server application for the Department of Children and

Families. The system replaced a number of legacy systems and handled all aspects of vendor processing

and case management. Built 3-D tab folder objects with single-commits for multiple table updates. Wrote

dynamic filtering mechanisms on multiple row/column drop-downs to facilitate operator input. Designed

and built PowerBuilder front end with multiple transaction objects to connect simultaneously to host and

remote database and execute cursor retrieval operations based on user selection. Managed and mentored

State of Connecticut I. T. resources working on the project.

Tech environment: PowerBuilder, APOL, DB2

Client: Hartford Insurance Group Claims Department 01/1992 – 12/1993

Hartford, CT

Worked on a number of projects among which were a Third Party Deductibles project and a consolidation

of multiple lines of business.

Tech environment: C/C++, Oracle, CICS, MICROFOCUS COBOL, CLIPPER

Client: Stanley Works 03/1991 – 12/1991

New Britain, CT

Built Electronic Data Interchange (EDI) applications in ANSI X.12 protocol to handle electronic invoices,

purchase orders, vendor managed inventory and advanced shipment notices. Wrote mechanism to track

exceptional demand and algorithm to determine dynamic optimal inventory levels. Developed CICS

screens to provide snapshot of inventory and order levels on a 52 week rotating basis. Added capability to

interface with Order Entry System with EDI based transactions.

Tech environment: CICS, COBOL

Education

BS (Computer Science) Berea College

MBA University of Toronto

Mobile 860-***-****

Contact this candidate