The organization was seeking to migrate the existing process and application to a new, scalable technical platform, as well as bring the third party file processing in-house.  These actions would support the company’s planned future growth, as well as provide cost savings and efficiencies through process improvement and the elimination of the third party vendor.

• Developed the SOA Framework utilizing a reusable foundation of base classes and utilities that supported hosting of services.  The Framework was developed in .Net and included a dynamic security model, logging, instrumentation and load balancing components; the solution utilized repeatable SOA patterns and it is WS* compliant.
• Led the development, integration, and migration effort for the first application to use the SOA Framework.
• Redesigned the application databases. To provide scalability, Ironworks implemented a Federated Database Architecture with 3 MS SQL Server 2000 servers, which horizontally partitioned critical tables across the federated servers; utilized Distributed Partitioned Views to access the data from the partitioned tables.
• Selected file import/export utilities for handling inbound list source files and generating outbound production and response files for vendors and clients.  The ETL tool, Business Objects Data Integrator, was used to control the flow and mapping of both imports and exports.  Data Cleaning and de-duplication was handled by First Logic, which was integrated in the ETL tools flow.   Both processes were hosted as services exposed by the SOA Framework. 
• Redesigned the mission critical marketing campaign manager application to include page design review, page development, database design, and integration with the new database.  The application took advantage of the reusable SOA Framework.  Services were developed to handle business logic, information management, and workflow processing for marketing campaigns.  The Framework allowed the campaign management application to be integrated with file import/export utilities.
• Integrated the campaign management application with the CRM COTS package.
• Built a custom web-based reporting solution using MS SQL Server Reporting Services as the execution and delivery engine with a custom .NET web application as the UI; UI was built utilizing an SOA/web services based architecture to build upon the existing intranet architecture and create a consistent user experience.

Services were architected and built such that they could be separated and hosted across multiple hardware platforms and easily scaled and moved as performance needs changed.  Services represented a component approach that allowed the systematic integration of new functionality and the ability to integrate the application with existing legacy applications, until the legacy application could be upgraded through phased releases.  The services also offered efficient and distinct touch points for integration with two separate third party applications.  Ironworks mentored the organization’s staff in the new SOA technologies, enabling the client to maintain and utilize the SOA Framework moving forward.