Andrew J. Alcorn

 

E-Mail:  andrew@andrewalcorn.com
Website: http://andrewalcorn.com

CAREER SUMMARY
Andrew is an enterprise information management leader with over 20 years of experience in the design, implementation and management of business intelligence, data integration, data warehousing, reporting and analytical modeling programs in close integration with the supporting networking, server, storage and database infrastructures. He has executed on all program phases from strategy definition, roadmap creation and project execution across various industries. His projects have included on-site and geographically diverse teams as well as third-party off-shore development teams. Andrew has designed and supported the operations of overnight batch and near real-time environments.

Specialties: Enterprise Information Management, Business Intelligence, Data Integration, Business Process, Portfolio Management, Strategic Planning, Operational Excellence, Agile Development.

EDUCATION

Master of Business Administration

Baker University, Baldwin City, Kansas, May 1996  http://www.bakeru.edu/

Bachelor of Arts, Economics, Finance and French (triple major)

Ball State University, Muncie, Indiana, May 1991  http://www.bsu.edu
Honors:  Outstanding Graduating Senior, Department of Economics

Diplôme de Langue

Aix-Marseille Université, Aix-en-Provence, France, May 1990,   http://www.univ-amu.fr/
Honors: Mention Bien


EMPLOYMENT EXPERIENCE


Manager, Business Intelligence Architecture, Centric Consulting, April 2013 to Present

Client: Global Communication and Technology Services Company, Digital Marketing Team

  • Designed data management layer for Spongecell and Google sources.
  • Analyzed and designed measures for creative content optimization.
  • Managed design of marketing campaign dashboard for the creative team.

Client: Multinational Risk Management Services, Insurance and Reinsurance Brokerage and Human Resource Consulting and Outsourcing Services Company

  • Data mapping and migration for organizational design application.
  • Created run books for production data to support multiple customers.
  • Designed application configuration data management process.
  • Procedure development to support configuration and operational management.
  • Database design and support for the application development team.
  • Managed test data environment for application configuration and data generation for volume testing.

Client: National Healthcare Management and Financial Solution Provider

  • Data warehouse and mart design.
  • Data modeling, profiling and documentation.

Client: Multinational Financial Services Corporation

  • Documented the current state of the technical and business components of the client environment.
  • Assessed the current state organizational readiness and process relative to business intelligence and information management.
  • Based on the client business strategy and priorities:
    • Collaborated with the client to create a BI vision and a multi-pronged strategy,
    • Designed a recommended technology architecture leveraging corporate support structures, current licensing agreements and existing organizational skill sets.
    • Created a road-map using an agile approach,
    • Designed an organizational structure to maximize resource utilization and to ensure ongoing business alignment and responsive support.

Client: Energy Company (Fortune 500 transmission, storage, distribution and generation)

  • Designed data source integration from multiple billing sources.
  • Designed data mart to support vendor billing analytics.

Client: International Automotive Parts Distributor

  • Defined business intelligence strategy and roadmap.
  • Established governance process.

Client: International Financial Services Company

  • Performed a business intelligence assessment offering strategic and tactical directional changes covering organization, security, governance, infrastructure, data modeling, reporting and data management.

Client: Digital Marketing Automation and Analytics Software Company

  • Developed user stories and data model for a marketing event management application supporting the UI development.

Client: Private Multi-Channel Marketing Integration Company

  • Developed the application data model for direct mail marketing campaigns supporting the UI development.

Client: Major Regional Property and Casualty Mutual Insurance Group

  • Enabled multivariate predictive modeling of personal auto policies for the purposes of more effective premium pricing and risk/exposure analysis. Successfully integrated data across many subject areas including policy, claims, census, crime, weather, accidents & violations and ISO value mapping.
  • Led the development team from manual coding practices to a tool based standard which dramatically increased development efficiency.
  • Established standard practices for data modeling, design specifications and source code versioning.
  • Technologies: MS SQL Server 2008 R2, SSIS, SSAS, MDX, Team Foundation Server, SSRS, Data Vault, Agile development.


Principal Data Architect, Brightpoint, Inc., February 2009 to April 2013

  • Conceptualize immediate and long-range needs of business organizations globally, with respect to business data strategy, enterprise data warehousing, reporting, and analytics.
  • Principal Architect for the business intelligence and data integration teams globally. Responsible for the global business intelligence and data integration strategy and architecture.
  • Primary consultant for development and administrative teams with performance enhancements and process improvements pertaining to data integration and business intelligence operations.
  • Committee member, Global Enterprise Architecture and Global Data Governance boards.
  • Ensure enterprise information goals and activities align to strategic business objectives through negotiation with senior management, key stakeholders and departmental management.
  • Design and implement extensive performance improvements covering infrastructure (storage, network, database and server), software and process domains.
  • Oversee business intelligence and data integration initiatives for adherence to architectural standards and to leverage global synergies.
  • Design and build proof of concept models in support of external customer proposals and internal performance and functional improvement initiatives.
  • Technologies: Pentaho Data Integrator, IBI Webfocus, Qlikview, Oracle, Sybase, SQL Server, MySQL, Moody’s Analytics, IFS ERP, Evavi, Sterling, Red Prairie, Provia, JD Edwards, Informatica, Data Architect Studio, Linux, Windows, PL/SQL, Data Vault, Java, scripting, Agile development.


BI Manager and Architect, Tempur-Pedic International, August 2007 to February 2009

  • Global Business Intelligence team leader.
  • Created and gained executive approval for enterprise Master Mata Management strategy.
  • Led the technology selection for global business intelligence platform.
  • Completed the first deployment project of the BI program going into production in just under three months and 12% under budget.
  • Provided enterprise reporting and analytics across two ERP systems and various silo applications.
  • Led development of integration and reporting capabilities between the SalesForce.com and the data warehouse.
  • Technologies: Business Objects Data Integrator and Web Intelligence, SQL Server DTS, Oracle, SQL Server, MySQL, MS Dynamics AX, Oracle E-Business Suite, SalesForce.com, Altiris, Project Insight, Linux, Windows, PL/SQL, Java, scripting, Agile development.

Business Intelligence Solution Manager, Level 3 Communications, June 1999 to August 2007

  • Managed business intelligence team and acted as liaison with business leaders in the design and deployment of business intelligence solutions to provide management key decision information across systems and business organizations.
  • Led company synergy team with $3.8 million in reoccurring costs savings realized from 2006 through 2007 including consolidating legacy order entry, leased vendor services, outside plant, reporting, application integration, billing systems and enterprise data warehouse integration.
  • Led the Enterprise Architecture Team. Refined and documented the enterprise architecture to maintain database, application and infrastructure standards.
  • Designed and developed middleware solutions to enable business process and enterprise data to flow seamlessly across systems and domains.
  • Conceptualized, defined and implemented system solutions from senior management’s vision, strategy and review of business process.
  • Led business teams through process documentation, project definition and functional design.
  • Technologies and Methodologies: Actuate, Business Objects, SalesForce.com, Vitria, Datastream MP5, Metasolv, Solomon, Remedy, Oracle 8,9, MS SQL Server, Kenan Billing, SSAS, SSRS, SSIS, Brio, Business Objects, SalesForce.com, Informatica, Tibco, Metasolv, Remedy, Rational.

Senior Market Planner, GTE Wireless, 1996–1999

  • Designed predictive analytic models using custom algorithms to forecast customer adoption by mining data from multiple internal and external billing systems combine with competitive intelligence data that provided financial and network capacity analytical outcomes used to create pricing plans and launch new products.
  • Developed excellent project management skills derived from large-scale projects spanning multiple business units; received employee excellence award and multiple employee initiative awards.

Assistant Internal Auditor, First Federal Bank of Kansas City, 1993–1996

  • Created analytical tools for branch location research using consumer geospatial data and also to target high probability customers for equity loan marketing.

Branch Manager, Banc One Financial, 1991–1993

  • Pioneered a successful new business market in the Kansas City area.
  • Exceeded production goals every quarter and set company record for the lowest branch delinquency.