Program and Systems Management – Integration and Implementation – Applications and Infrastructure

Recognized for leadership in providing project management, analytical and data management services for Sales, Marketing, Market Research Analysis (BI -DSS), Marketing Services and PMO business areas.
Expertise:

• Business Intelligence - Decision Support Systems
• CRM Systems Analysis and Assessment
• Data Warehouse Design and Development
• Technology Management – Application Support
• System and Data Integration / Migration
• Testing - Quality Assurance and Control
• Planning and Analytical Studies
• Change Management – System Release Cycling
• Business and Vendor Relationship Management
• Multi-Location Sales Office System Infrastructure

• Translates business requirements into design and product development with detailed documentation, work plans, resource plans, risk assessments, scope control, timelines, schedules, priorities, and deliverables.
• Tracks progress, manages risk - issues and monitors compliance to project and performance standards.
• Develops project, requirements, functional specification, technical, and system documentation.
• Manages process for data modeling, transformations, development, integration and test plans.
• Technical environment setup and administration including database restatements and realignments.

Produced “read the business” portal consolidating multiple databases and systems to provide performance measurement, sales force, sales and distribution data warehouse variance analysis reporting system.

Developed internal requisition system for corporate identity marketing collateral and field sales promotion planning and execution. Consolidated approved procurement process for financial visibility and cost control.

Constructed digital workflow management review system in collaboration with Leo Burnett advertising agency leading to improved time-line and asset management.

Prototyped non-profit start-up health and wellness, community services information web-portal as a distribution channel and destination to transform or improve quality of life for the elderly and other at risk groups.

• System owner: Demand Forecasting – supply-chain multidimensional data warehouse driving current production and 5 year Corporate / Wall Street financial performance estimates and targets for analysis, allocation, distribution and decision-making. Designed database architecture, flows and processing between all systems. Documented data dictionary definitions, sources and usage.
• Re-engineered and migrated system and databases from Novell to multi-threaded processing web-services based Win2K UNIX Sybase – SQL Server environment. Managed data extract, clean, load and verification phases. Integrated warehouse, distributor, chain and store level hierarchies.
• Application advanced under my direction, created Scenario Planner, Database Snapshot modules, reduced cycle time 2 days and created “hot-fix” environment for risk mitigation. Productivity savings $525K.
• Wal-Mart – Business Opportunity data warehouse for mapping distribution at 2,500 locations, designed data structure, technical infrastructure and SQL programs for product sales aggregation, selection / matching using manufacturer, vendor and internal data. Improved product allocation profile $28M.
• PMO representative: implemented program, project, supplier management discipline, accountability, integration standards and services. Accelerated client area acceptance and adoption.
• Business relationship and service delivery manager recommending timely cost effective process / technology investments for new development projects, on-going system enhancements and support.

Managed the Marketing Systems project and technology portfolio providing systems and analytical databases that drive marketplace leadership. 
Implemented ITSM model for application and data, extended and deployed to Planters – Lifesavers companies.

• System owner: IRI / Oracle based Sales & Marketing multi-platform distributed data warehouse across the U.S. (150 locations). Developed CRM, category management and account planning reporting.
• Processes and procedures for account planning led to $8M sales lift.
• Produced complete re-write of mainframe based Executive Business Reporting system using VB, Crystal Reports and SQL Server. Enhancements: drill-down, custom aggregation, batch and automated reports
• Market research database systems: Spectra, Nielsen, Catalina Retail Incentive and Market Metrics.
• Partnered with customers, suppliers and internal constituencies to ensure successful implementation of solutions; mentored and coached staff members using structured project management methodology.

Managed multiple Executive Management sponsored projects for Consumer Sales Corporation.

• Produced BI – DSS data warehouse system infrastructure design, configuration, testing and deployment strategies and plans for controlled conversion and rollout.
• Developer Business Intelligence - Product Profitability Analysis, TOP Sales Performance, Going Price Survey, MDF - Market Development Funding and FACT forecasting systems.
• Designed and implemented distributed database server - U.S. Regional Sales Office Network.
• Accountable for system development, administration, network, server, desktop, logistics planning, team management, internal marketing, user, technical, and support.

Technical 
Platforms: Win Server 2K/XP/7, Web, Linux, Unix – SUN Solaris, Novell, OS/2, IBM30xx, MVS/TSO
Win and Shell Scripting, MS Office – Project – Visio, VB, FOCUS, FoxPro, ASP, JavaScript, T-SQL
IRI / ORACLE - Sales Analyzer OLAP Multi-Dimensional DBMS, SYBASE, SQL Server, MS Access, MS SSRS, FYI Planner, Data Structure, Database Design Optimization, Crystal Reports, Dimensional Insight, Business Objects, Visual Studio.Net

Education 
B.A. Economics 
M.S. Engineering, Management and Applied Analysis
Management Science - Operations Research Track 
Confidential College