Work History

Work History
Apr 2003 - Feb 2009

Director of Business Intelligence, EDW and Customer Marketing Systems

http://www.dsw.com

DSW Inc. is a leading multi-channel footwear specialty retailer that offers a wide selection of brand name and designer dress, casual, and athletic footwear for women and men. DSW had sales of $1.46B in 2008, has over 10k employees, operates 300 stores in 37 states and an e-commerce web site. 

Oversaw design, implementation and support of enterprise data warehouse, business intelligence, customer service and customer loyalty / marketing systems for $2.7B retail organization.  Led Shared Services function providing IT Services to DSW Inc, Value City Department Stores, Filene's Basement and Retail Ventures Inc.

Recruited, mentored, and managed 30-member team providing technical services to three retail companies with combined database portfolio of 20M+ customers. Accountable for all IT program and department P&L management, organizational development, budgeting, strategic planning, systems support and operations; partnered with senior business and IT leadership to develop multi-year IT plans and strategic business cases, directed multiple application development and project managers, and led teams through all phases of high-complexity BI, EDW, CRM, Web service development, and data analysis and reporting projects.

Selected Achievements:

  • Skillfully leveraged technology assets and investments to reduce costs, simplify IT footprint and increase efficiency in technical environments; marketing and CRM program improvements captured $2.5M in annual savings and led directly to projected revenue increase of $7.8M over two years.
  • Orchestrated migration of outsourced SaaS components for 8M-member customer loyalty program to in-house solutions; led database consolidation, internally hosted Web site deployments, and development / rollout of call center, EDW, campaign management, and BI reporting systems.
  • Launched DSW’s Data Warehouse Program.Created internal capability to deliver business performance insights (marketing effectiveness, market basket analysis, consumer buying patterns, fraud detection, cashier productivity) that ultimately changed company’s customer direct market strategy.
  • Introduced new business intelligence tools from Microstrategy, Business Objects (XIR3) and SAS. New data integration tools from Informatica and data quality tools from Trillium.
  • Retired 30 legacy reporting and intranet applications.Simplified enterprise architecture, improved data accuracy and system availability, and reduced operations costs.
  • Introduced and held accountability for DSW's Business Intelligence and Customer Information Steering Committee to ensure executive program governance and sponsorship.  Committee was chartered with establishing and executing a multi-year program and portfolio plan, reviewing and approving all data warehouse, BI reporting & analytics, enterprise and customer data integration, CRM, and data quality improvement projects.
  • Earned fast-track promotions from previous positions as Manager (2005) and Director of Business Intelligence (2006) to hold additional responsibility for all EDW and Customer Marketing Systems.
Jun 2000 - Apr 2003

Sr. Consultant

BearingPoint Inc.

BearingPoint, Inc. is one of the world's largest providers of management and technology consulting services to Global 2000 companies and government organizations in more than 60 countries worldwide.BearingPoint has over 15k worldwide employees and in 2008 had revenues of $3.20B.

Enhanced business systems and results for Fortune 500 customers of BearingPoint's Retail and Consumer Goods practice.  Consulting assignements with the following organizations: Pfizer, McDonalds, Hyundai, United States Air Force, Heinz and ICI/Glidden Paints.

Led teams of up to 15 resources and controlled budgets upwards of $1M while managing all SDLC phases to deliver data warehouse and business intelligence projects on time and on budget. Facilitated requirements gathering and design sessions, developed project plans and artifacts, and led key steering committees. Played integral role in managing RFI / RFP processes, vendor selections and contract negotiations. Led workshops for requirements review and certification, system design, QA, and user acceptance testing. Created and implemented data integration and ETL processes, production and ad-hoc reporting applications, and KPI dashboards. Delivered executive-level presentations, and conducted technical training workshops.

Selected Achievements:

  • Identified new business opportunities, assessed risks, and provided expert guidance and hands-on design for complex information and data architectures, directing logical and physical database design, data acquisition / transformation / cleansing strategies, capacity planning, and performance & query tuning.
  •  Provided enterprise data management consulting as project lead and SME within McDonald’s global Information Assurance program which was comprised of three distinct disciplines; Business Intelligence, Data Standards and Data Quality & Governance.Led the international data infrastructure development for Supply Chain Business Intelligence; Hands-on management and individual contributions of data architecture requirements & design documentation, data modeling, metadata documentation of global KPI and business metric definitions, ‘System of Record’ data source identification and certification, business rule and functional requirements for source system interfaces to global data warehouse and all integrated test plans.
  • Made significant contributions to foreign auto manufacturer's strategic product mix and facilities management plan; performed data mining and analysis of consumer demographics, purchase patterns, market segment analysis, product defects, and quality metrics.
  •  Devised solutions for BI reporting tool consolidation and new maintenance contract, saving major pharmaceutical customer $300k annually in software maintenance licensing fees.
  • Enhanced financial and G/L reporting capabilities for major paint manufacturer, reducing period close cycle, improving data quality and accuracy, and providing clear insight into fiscal performance.
Jul 1997 - May 2000

IT Architect

http://www.aep.com

American Electric Power ranks among the nation's largest generators of electricity serving 5.2 million customers in 11 states.AEP also owns the nation's largest electricity transmission system.20008 revenues were $14.4B with over 21k U.S. employees.

Excelled in both team leadership and hands-on contributor roles to provide business systems for enterprise operations and finance groups.

Headlined development of large-scale customer service / financial ERP system and pilot data warehouse system, driving major improvements in billing, operations reporting, and performance analysis. Gathered requirements, conducted design and review sessions, and facilitated User Acceptance Testing, clearly communicating project risks, issues, milestones, and status to all key stakeholders. Wrote detailed design, test, operation, and training documentation for ETL and report development; produced reporting prototypes and wireframes, participated in logical and physical data modeling sessions, and worked with administrators to implement database architecture and resolve performance and query response time issues.

Selected Contributions:

  • Delivered state-of-the-art reporting and billing functionality for field and home office staff, increasing data quality and accuracy, reducing billing errors, and improving customer service metrics.
  • Resolved data sourcing, validation, and load performance issues for more than 500Gb of customer transaction and billing data.
  • Chaired cross-functional QA task force, leading high-priority bug/fix and system defect resolution for new budget billing calculation routines and bill presentation / printing systems.
Jul 1995 - Jun 1997

Systems Analyst

http://www.principal.com

The Principal Financial Group is a leading global financial company offering businesses, individuals and institutional clients a wide range of financial products and services.The Principal serves 19 million customers world-wide and has over 16k employees.2008 revenues were $7.7B.

Provided programming and project leadership to drive development, maintenance and operation of corporate and benefit payout check writing systems for insurance industry giant.

Transitioned easily through all phases of systems development life cycle (SDLC), serving as Project Lead for broad range of computer programming, testing, implementation, modification, and support assignments. Interfaced directly with customers to complete requirements gathering, design review, and UAT tasks. Defined system specifications, drafted scenarios and scripts for unit functional, regression, and performance testing, and created operation and training documents.

Selected Contributions:

  • Adapted quickly to learn new business processes, and skillfully managed time and resources to complete assigned projects on time and on budget.
  • Leveraged strong technology background to accurately translate business requirements into effective technical specifications, consistently delivering high quality programs and system modifications.
  • Capitalized on stellar interpersonal and communication skills to develop strong business rapport and productive partnerships with internal customers.

Key Management Strengths

System Integration | Solution & Application Development | Program and Project Leadership | IT Operations and Support | P&L Accountability and Management | Business Case Development | Contract Negotiation / Vendor Management | Cross-Functional Team Building | “Big Six” Consulting 

Summary

Strategic Vision & Planning/Program & Project Leadership/P&L Accountability

Data Warehousing & ETL/Electronic Marketing Solutions/Cross-Functional Team Building

Versatile and resourceful technology leader with 16-year track record of success spearheading delivery of cutting-edge BI, CRM and cross-functional data management products and services to meet enterprise business needs; highly skilled at setting strategy, overseeing planning and execution of large-scale priority initiatives, and developing BI, Information Management and data integration teams into high-performance organizations. Offer polished communication, presentation, and relationship-building skills that are crucial to forging productive, cross-department partnerships, providing stellar service to internal customers, and collaborating effectively with personnel at any organizational level.

Certifications

  • Estimating & Managing Project Costs, Mar 2004
    • Certified by Project Management Institute
  • Managing Project Communication, Feb 2004
    • Certified by Project Management Institute
  • Managing Successful Negotiations, Jan 2004
    • Certified by Project Management Institute
  • Effective Project Scheduling & Control, Jan 2004
    • Certified by Project Management Institute

Areas of Expertise and Specialization

Business Intelligence | Data Warehousing | Customer Data Integration | ETL | Master Data Mgmt | Data Quality and Strategy | Service Oriented Architecture | Data Privacy and Security

Web and E-mail Marketing | Customer Relationship Mgmt | Database Marketing | Customer Loyalty Programs | eCommerce | Marketing Campaign Mgmt | Customer Service Mgmt | Web Development | Portal and Content Mgmt | Retail Point of Sale Systems | Retail Technology

Career Highlights

  • Nominated by Teradata in 2008 as Computer World Premier Top 100 IT Leaders for innovative use of enterprise data warehouse.
  • Provided technology strategy and leadership in support of an industry renowned customer loyalty and rewards program.The ‘DSW Rewards’ loyalty program was voted best Retail Rewards Program by Kiplinger’s Personal Finance magazine in 2006.
  • Delivered prototype of a web-enabled aircraft maintenance, parts, supply chain and logistics BI dashboard used by the United States Air Force in the wake of 911 disasters.Presented the prototype to senior USAF personnel within 12 weeks of terrorist attack.POC work lead directly to a $12M consulting services engagement.
  • Managed systems integration and launch of two start-up database marketing and customer loyalty programs; ‘VPlus’ for Value City Department Stores and ‘Fan Club’ for Filene’s Basement.
  • Spearheaded architecting and implementation of “Active / Operational Data Warehouse” solution integrating EDW real-time with DSW.COM, over 300 brick & mortar stores, and corporate contact center systems, simplifying use of information across all customer interaction and decision support systems.
  • Global Project Lead on a five-year, half-billion dollar ERP and data warehousing program created to provide global supply chain, finance, human capital, store operations and business intelligence applications for 30,000 restaurants and 121 country offices world-wide.Directed the global design and delivery of business intelligence and data warehouse solutions for the supply chain functions.
  • Led customer service task force to address business disaster – theft of 1.3 million credit card accounts; staffed 65-person, multi-local call center with 18-hour coverage in less than 72 hours.

Education and Credentials

Bachelor of Business Administration, Computer Information Systems – 1995

University of Texas – El Paso, El Paso, TX

Professional Development

  • ITIL Service Management
  • Instructor Led Training - Microstrategy: MSI Desktop, MSI Architect
  • Instructor Led Training - Oracle BI: Oracle Reports, Oracle Discoverer
  • Instructor Led Training - Business Objects: Business Objects 5.2, BO Designer, BO Supervisor

Key Technical Proficiencies

  • BI: Business Objects, Crystal Reports, Hyperion Essbase, Hyperion Reports, Aspect, SAS Enterprise Miner, Teradata Warehouse Miner, Cognos, Oracle Reports, Oracle Discoverer, Siebel Analytics
  • CRM: Teradata CRM, Blaze Advisor
  • Content Management: OnBase, Mobius, SharePoint, SunONE Portal
  • ETL: Informatica, Microsoft DTS, Trillium, Ascential Data Stage, Oracle Warehouse Builder
  • Database Management: Oracle, Teradata, DB2, SQL Server, ErWin data modeling tools
  • Productivity: CA-7, MS Office Suite, MS Project, MS Visio
  • Languages: .ASP, CICS, COBOL, HTML, Java, JCL, JSP, Visual Basic