Data, process, enterprise modeler architect

DALE LEBOW Business Systems / Technical Analysis Data & Process Modeling Strategic Planning

Accomplished Professional with proven experience leading Enterprise and Data Architecture efforts, business systems analysis and design and overseeing the development and delivery of technology-based solutions addressing processing needs. Background includes leading enterprise development efforts within the automotive, healthcare, insurance, government, marketing, advertising publication, direct mail and small-business sectors. Demonstrated success employing a model-based approach and structured modeling techniques to define and document processing requirements supporting highly effective and accurate code development. Skilled at cultivating partnerships with internal staff and external partners to achieve goals. Areas of expertise include:

Enterprise Architecture Business Process Analysis Workshop Facilitation

Requirements Development Process Modeling Quality Control

Logical Data Modeling Database Design Staff Leadership

Application Architecture Process Improvement Technical Specifications

Database Re-Engineering

Physical Database Modeling Project Management

Data Integration Relationship Building

Business Analysis

PROFESSIONAL EXPERIENCE

DELL SERVICES FEDERAL GOVERNMENT, Fairfax, Virginia March 2009 - October 2011

Data Modeler / Architect

s On contract to the Department Of Defense, specifically the Department of the United States Army, Corporate Information Office (CIO)/ G6: performing detailed data and system analysis of the TACOM LCMC related systems and applications directly supported by the CIO/G6 and the hardware and software infrastructure for which the CIO is responsible. The U.S. Army Tank-Automotive Command Life Cycle Management Command, TACOM LCMC organization is responsible for all phases of support for the equipment required by Warfighters across the globe.

Key Accomplishments:

In conjunction with the CIO Enterprise Architect, developed approach, system meta-model, functional organizational and system As-Is inventory for the myriad of systems, applications and databases supported by TACOM CIO/G6. Utilizing the DoDAF 1.5 and 2.0 methodology within the Army-standard ProVision modeling tool, developing models of the systems, their related components and Oracle and SQL Server databases, as well as related proprietary technologies utilized and sustained by CIO/G6. Developed a TACOM-specific Enterprise Architecture framework to develop models appropriate to system/applications utilizing components of the CIO infrastructure. The application details are documented within a central repository with DoDAF-standard models to support the cost, capacity, ITIL-based change management workflow and general informational needs of the CIO/G-6 leadership.

VALASSIS COMMUNICATION, INC., Livonia, Michigan January 1998 – November 2008

Enterprise Data Architect, Senior Internal Consultant

s Provide consultative guidance to a specialized advertising and marketing firm with strong ties to the newspaper publishing and direct mail industries generating $2 billion in revenues annually.

s Develop customized application solutions to address business needs across a variety of Valassis products and processes.

s Champion initiatives to boost corporate productivity by developing comprehensive process and data modeling framework and using such automated tools as ProVision to optimize information system development.

s Enhance business operations and support client satisfaction and retention by managing system enhancement, installation, and on-site support for a major client’s Free Standing Insert (FSI) and Preprint business.

s Streamline development initiatives and employ best practices to eliminate redundancy through the reuse of legacy components and reports in the development and enhancement of new and existing systems.

Key Projects:

Facilitated the scope definition, analysis, design, code, and implementation of a newspaper-delivered free-standing insert product, a client-server application to manage customer’s orders; utilized ProVision in predevelopment phases and VB6, Access, SQL Server, and Oracle to support the large application for the clients’ and Valassis’ order process.

Facilitated and led the re-design, enhancement, and re-deployment of an enlarged Access to SQL Server application providing required and pertinent marketing data for national FSI distribution within the packaged goods industry.

Managed the re-design, developed code and implementation of an Access to SQL Server application in VB6 designed to assist Regional Sales staff by maintaining contact information for 9,000+ contacts and 100+ users while supporting work flow and lead information. Developed customized reporting modules.

Oversaw and facilitated the design and development of a web browser-based ASP.Net, SQL Server, and VB6 Preprint product and Run of Press (ROP) quote system enabling interactive, real-time quote configuration, market selection and ROP costs, and batch Preprint media targeting and costing capability via geographic and demographic qualifiers.

Teamed with internal staff to develop a VB6, SQL Server HR Applicant Tracking application based on defined protocols; developed scope, process and data analysis, presentation, and data design, code and user documentation.

Facilitated the analysis and design of a physical ad creation program within Preprint operations subsequently approved for development in a web-based environment.

Led due diligence efforts to support corporate acquisition assessment, decision-making, and purchase process of an existing ROP operations application; architected the integration, deployment and enhancement to the ROP system workflow designing a stable backend to handle increasing ROP business volume.

Facilitated key portions of the analysis, tech design and database design of an application to deliver a high-quality distribution recommendation to improve effectiveness and accuracy of newspaper delivered products by identifying media buyable units meeting geographic, demographic, and product qualifiers; designed and developed SQL Server and Oracle databases supporting logical data models.

Managed external business relationships, including serving as SME and IT team member for a project led by an off-shore consulting partner; mentored a 12 member design and documentation team, identified shortcomings, and recommended solutions to meet corporate goals, deadlines and requirements.

Teamed with third-party vendors to define the scope, analysis, design, and development of technical specifications for a Quote to Order system; designed process and logical data models, the physical database and the presentation layer.

Oversaw coding to develop functionality to support client-specific newspaper rate structure; defined a new database to store rates for 300+ newspapers and wrote specialized logic to handle exceptional newspaper markets considerations.

Customized existing applications to enhance processes and support unique requirements of different clients, including supporting client-specific newspaper rates for the ROP and Preprint product lines and interactive mapping functionality for the web-based application.

Selected as one of three IT representatives to define the integration of adirect mail distribution operation into existing newspaper distribution process subsequent to the acquisition of ADVO, Inc.; integrated multiple applications, designed and implemented physical databases, and transitioned portions of the data requirements from logical to physical.

Teamed with SME and developers to architect technical designs for pricing modules to feed rates to a larger application, including data structure, user interfaces, market level requests, and optimal service component response.

PROFORMA CORPORATION, Southfield, Michigan December 1989- December 1998

Managing Consultant

s Oversaw and managed all phases of consulting projects utilizing ProVision through the full system development lifecycle, including systems development, application design, project management, and CASE technology component development.

s Served as primary technical analyst on planning and design workshops and projects for insurance, automotive, public utility, government (Federal and State) and manufacturing industry applications employing ADW planning, analysis and design techniques and tools, Information Engineering, CASE practices and techniques ensuring client needs were met.

s Developed and executed a project plan by defining tasks, deliverables, and staffing for the design and development of a mainframe IMS/DB2 on-line and batch system for the State of Wisconsin.

Key Projects:

Served as project leader for a $6 million ADW-based design and construction initiative for a prominent automotive manufacturer; managed a 6 member technical team and held full accountability for component deliverables and mainframe components in an IMS DC/DB2 environment.

Led the development of a mainframe governmental on-line inquiry system with ADW and LAN executable ADW design and construction workstations, Microfocus Cobol, and XDB in a CICS/DB2 environment.

Championed the design and development of a medical claim processing and payment system for an insurance company using a Windows Microfocus, CICS, and DB2 emulation environment.

Supervised 4 internal personnel charged with performing hardware platform component development and maintenance while developing components used for an on-line CICS and DB2 insurance application.

Analyzed, designed, developed, tested, and maintained 20+ mainframe systems.

EARLY CAREER HISTORY

Sterling Software KnowledgeWare Logical Design Corp. Harcor Systems ComSpec Corp. Lebow Associates Inc.

EDUCATION

EASTERN MICHIGAN UNIVERSITY – Ypsilanti, Michigan

1968-1969 General Business Curriculum

TECHNICAL SKILLS

Systems / Applications / Languages: Microsoft .Net Development / Architecture Suite Visual Studio SQL Server Oracle Access DB2 RDB IIS COM+ DCOMM Microsoft SourceSafe Team Foundation Server ASP VB5 VB6 Visio Excel Microsoft Office IBM Mainframes Personal Computers Apple Computers Honeywell / Burroughs Systems DOS OS/2 Windows CICS IMS DB/DC COBOL IDS-I IDS-II DMIV-TP XDB Microfocus Mainframe Development Tools TSO ISPF RPG II

Methodology: UML Modeling ProVision ERwin Enterprise Architect Data Modeling Process Modeling Proposal Development DoDAF Zachman TOGAF Requirements Development Project Plan Development Database Design Standards and Template Development SDLC Full Lifecycle CASE Development Application Development Workbench (ADW) ForeSight Method I Pride

Contact this candidate