Dataflow Re-Engineering
These diagrams represent a major engineering effort to combine both an extended network infrastructure and data warehousing to create a standards-based framework to achieve a rapid integration of list-management across a wide variety of largely, outbound teleservices systems, in record time and at minimal cost.
The business context for this work was the rapid consolidation and impending regulation of, primarily, outbound telemarketing organizations. The company represented, had acquired, and was continuing to acquire incompatible call centers, with incompatible data formats. Additionally, there existed no corporate infrastructure on which to achieve integration, and standardization. My involvement facilitated both.
The project implemented essentially an ETL toolkit, which integrated leads into a central repository with a unique identifier. From that central repository, lists could be synthesized and leads managed, resulting in a significant gain in efficiencies, and resultant lowering of operational costs. The savings was in the range of a million dollars a year, not to mention the competitive advantage of being able to execute any campaign, in any center.
The scheme involved implementing significant amount of technology in a relatively short amount of time, while the company continued to transform itself by a flurry of merger and acquisition activity. In addition to a volatile workforce situation, lots of technology was involved, including a full Cisco Enterprise-class IP Network deployment, a Microsoft Exchange rollout, an Oracle data warehouse implementation, and the building of multiple computer centers, call-centers, and web-based applications all of which was achieved in twelve-to-eighteen month window.
Download the Diagrams
- Adobe Acrobat (.PDF) format:
- DFR_Original.PDF
- DFR_Detail.PDF
- DFR_Transactions.PDF
- DFR_Tracking.PDF
- DFR_Reporting.PDF