Manager Data

NICHOLSON (NICK) WARMAN, PMP, CSM

Durham NC

LinkedIn: nickwarman email: ****.******@*****.***

Global Program and Project Manager

Program Manager for infrastructure, HRMS and data governance programs: global hardware sales market share grown from under 40% to over 70% (including one financial sector customer’s US$8 million purchases quarterly); Statistician-of-Record (director level) with the Government of Canada (Cdn Fed Govt)

Multi-organization relationship management – cooperative ventures, inter-agency conflict resolution, mutual research contracts, small local to multi-million-dollar international contracts, pre-Sales support, building consensus to establish collegial and transformative environments for mutual success

Data Architect / Project Manager in the financial and service sectors - in one global project cutting the operating costs by 66% - at AIG/United Guaranty Corp., Ally Bank, RBC Bank (USA), Decision Consultants Inc and Canadian Federal Government – included data/information governance

Project Manager for a functionality refresh of a suite of successful commercial software products in the HR/Litigation market sectors and financial sector institutions, and global business intelligence

Data Analysis Consultant/Manager – at Peoplefluent, UNC Greensboro (workshop development/delivery), Decision Consultants Inc, Canadian Federal Government

Data Quality/Data Lineage/Data Management – part of work at Wells Fargo, AIG/UGC, Hewlett Packard, Ally Bank, RBC Bank (USA), Peoplefluent, UNC Greensboro, Decision Consultants and Canadian Federal Government

Software Release Train Manager responsible for a reduction in Total Cost of Ownership (TCO) with initial savings of 30% and if fully implemented, an additional 30% - at Decision Consultants Inc, UNC Greensboro

CERTIFICATION and EDUCATION

Project Management Professional (PMP) certification (2008-2020)

Certified ScrumMaster (CSM) certification (2018-2020)

MBA, University of Ottawa, with a specialization in Public Policy and Strategic Management

B Sc (Computer Science), University of New Brunswick - Fredericton

B Sc (Biology), University of Prince Edward Island, also known as Pre-Med or Lab Sciences

WORK Experience

PEARSON EDUCATION, INC via The Select Group, Raleigh/Durham, NC November 2018 – January 2019

PROJECT MANAGER, Finance PMO

Technologies: GSuite (Docs, Sheets, Slides, Gmail), SmartSheet, Microsoft Teams

Write the Project Charter then prepare a Baseline Schedule for an update to the global MDM systems and a data conversion move from one regional system (being decommissioned) to the Global Business Intelligence/Enterprise Data Warehouse (Jira, AWS and Google BigQuery), using globally distributed developers for a multi-year project

Lead daily agile stand-up session with project team leads, and focus meetings with various team members to keep the project on track and to monitor the “health” of the team

Team Leads covered Business Analysis, Data Modeling, Quality Assurance, Data Quality, Architecture, Development, Provisioning, Reporting/Analytics + Waterfall + agile + Data Conversion + cloud

KELLOGG’s via TEKsystems, Raleigh/Durham, NC June 2018 – July 2018

PROJECT MANAGER

Technologies: MS Office (Excel, PowerPoint, SharePoint, Word), MS Project, PlanView

Integrate financial, procurement and project milestones

Lead workstream and program meetings (agile stand up, status, and executive briefing)

WELLS FARGO BANK, N.A. via Insight Global, Charlotte, NC August 2016 – March 2018

BUSINESS ANALYST FOR TRACEABILITY (Business Systems Consultant 6)

Technologies: SQL Server, SSIS, SQL Server Management Studio, SAS, MS Office (Access, Excel, PowerPoint, SharePoint, Visio, Word), Tableau (data store only), ab initio, Collibra

Traced the critical business elements (CBE) and their associated data flow(s) from those reports back to their respective Systems of Origin (SOO), across the various Systems of Record (SOR) and Provisioning Points (PP) of the Wells Fargo’s Lines of Business; canvassed and secured agreement with System Owners and Data Owners (and their respective staff) on data flows and narratives, process flows and narratives, risk and control inventories, findings and issues logs, and data mappings, for the transformational Data Management for all risk and regulatory reports (vis. BCBS 239)

Architected an initial database and ETL data flows to produce the Report Centric Score Card in Tableau; this Score Card will be shared quarterly with the regulators and senior management, so that they would know the risks and exposures and general state of each corporate risk and regulatory report

Contributor for several Fit-for-Purpose (FFP) Assessment Reports; provided the Quality Review of several completed risk and regulatory report (non-SEC reports) assessments, such as FR Y-14M (three schedules only), Interest Rate Risk and FFIEC 102, and was the Assessment Lead (project manager) for the FR Y-14M report (schedule D.1), working with System Owners, Data Owners, Report Owners and their associated staff +Data Quality +Data Conversion +Data Analysis +business systems analysis + Risk Reporting + Regulatory Reporting

AIG / UNITED GUARANTY CORP via N-Tier Solutions, Greensboro, NC July 2015 – June 2016

PROGRAM MANAGER, DATA MANAGEMENT MATURITY and DATA GOVERNANCE

Technologies: DB2, Oracle, SAS, MS Office (Excel, PowerPoint, SharePoint, Visio, Word), Collibra/Archer, DataStage/QualityStage, Information Analyzer, SDLC (Waterfall, agile) rewrite, IBM Z, iSeries

Create and maintain DMM Compliance and project plans for the various work streams to implement Data Governance + DMM Compliance + business analysis + SDLC (Waterfall, agile)

Reported the Data Management Maturity (DMM) program progress to the Enterprise DMM program, along with the state of all associated projects under the DMM program umbrella + Data Quality +Data Conversion

Provide Secretariat services (charter, orientation, minutes, agendas, mailing lists) for the Data Governance Council and the Standards/Quality/Visualization Working Groups

Plan Business Glossary updates and enumeration of associated data lineage documentation + BCBS 239

KNOWLEDGENT INC March 2015 – May 2015

INFORMATIONIST

Technologies: MS Office (Excel, PowerPoint, SharePoint, Word)

Developed Analysis and Visualization assets as the RAV Assets Lead and started process improvements for the evolving organization going forward + data visualization

Functioned as an Analyst on a short-term Strategic Assessment project for a hospital data governance and analytics program

Drafted White Papers, Use Cases, marketing and sales collateral, and Case Studies for group review and publication

HEWLETT PACKARD at SAS Institute, Cary NC February 2012 – October 2014

TECHNICAL ALLIANCE MANAGER to SAS and Cloudera, and

PROGRAM MANAGER for both HP Converged Infrastructure for SAS High-Performance and Visual Analytics (HP CI for SAS HPVA) and HP CSS BU Reference Architecture Management

Technologies: SAS, SAS Visual Analytics, Vertica, MS Office (Excel, PowerPoint, Visio, Word), software development and QC processes, Red Hat Enterprise Linux, Offering Management, Hadoop, Java

Managed jointly the global relationship between HP and its partners SAS and/or Cloudera, including:

i) conducting benchmarking studies, ii) assist pre-sales of Cloudera and SAS for HP or partners, iii) created/published hardware solution recommendations globally, iv) escalated/monitored support issues, v) tracked sales pursuits globally and vi) introduced partner and HP pre-Sales teams for joint pursuits, vii) initiated/presented in joint webinars and/or live presentations, and viii) configurations discussed or installed ranged from 1 to 256 servers plus all necessary infrastructure

Created a “flexible” Reference Architecture (RA) program in support of SAS in-memory analytical solutions (SAS VA and SAS H-PA) and the SAS/Intel Business Analytics Modernization Analysis (BAMA) initiatives for HP; these transformational efforts moved HP’s SAS-driven market share from under 40% to over 70%, based on unofficial data + Data Conversion + Data Governance + Data Management + Data Inventory + Data Lineage + Data Quality + business analysis

Provided Program Management services for HP’s Converged Systems and Solutions Reference Architectures teams, in conjunction with HP’s Storage Division management, per global project + benchmarks

ALLY BANK via TTI of USA, Charlotte NC August 2011 – January 2012

PROJECT MANAGER, BASEL COMPLIANCE

Technologies: REVELEUS (OFSAA), OBIEE, Oracle, MS Office (Excel, PowerPoint, Word), software development / QC processes, Java, Data Conversion

Developed a documentation standard and process to better implement ORACLE™ REVELEUS™ (now OFSAA with OBIEE); delivered documentation that addressed senior manager, business analysts, specialists, operational and system maintenance/development staff + business analysis + Data Conversion + Data Lineage + Data Quality

RBC BANK (USA) via EXPERIS/Manpower, Raleigh/Durham, NC May 2010 – August 2011

DATA ARCHITECT, BASEL II COMPLIANCE

Technologies: SQL Server, QRM, SSRS, DTS & SSIS, SAS, SPDS, MS Office (Excel, Word), Teradata

Developed a universal client identifier that covered every account “on the books” for every client, so that the Bank could comply with the BASEL accords requirements; an MDM approach used

Added that logic for use in DTS/SSIS components, including QRM

Added new data fields and files from existing data sources to the SAS™-based NORM corporate data warehouse to meet Risk Management’s data needs; provided the needed ETL processes

Built the BASEL Server Process Document, which defined data flows, access privileges and all details needed to understand, operate and audit the environment

+ Information Management + Data Governance + Data Lineage + agile + Data Conversion + Business Intelligence

PEOPLEFLUENT, INC., Raleigh/Durham, NC August 2003 – May 2010

SOFTWARE PROJECT MANAGER and SENIOR ANALYST

Technologies: SAS, Crystal Reports, MS Office (Excel, PowerPoint, Word), C, C++, C#, Visual Basic 6, .NET framework, COM Interop, HRIS extract implementations, waterfall, agile, Scrum (pilot), Java, Data Conversion

Managed the delivery of multiple releases of commercial products, using off-shore resources, primarily for the Affirmative Action and Legal marketplaces: AA Planner®, Peopleclick Monitor™ and Peopleclick PayStat™, on-time, in-budget and zero defects; responded to legal support questions + systems development + Data Conversion + Data Quality

Wrote and supported the regression calculation engine for inclusion in the company’s AA offerings

Invited speaker at several international conferences on litigation Data Analysis and HR risk compliance for Project Managers and organizations + Software Development + Data Quality

Understanding defense and/or opposing counsel’s client HRMS to accurately model relevant data as related to the various legal case claims and applicable FLSA, OFCCP and EEOC regulations + Data Lineage + Data Analysis

UNIVERSITY OF NORTH CAROLINA AT GREENSBORO, Greensboro NC January 2002 – August 2003

DATA ANALYSIS CONSULTANT (included project management role)

Technologies: SAS, SPSS, MatLab, Apple Mac, Novell, Solaris, DEC VMS, MS Office (Access, Excel, PowerPoint, Word), Data Conversion

Promoted Project Management methodology and processes (time, cost, other estimation, forecasting

Prepared and delivered workshops for qualitative and quantitative Data Analysis to faculty, staff and students; including SAS, SPSS and AMOS (Structural Equation Modeling)

Developed and delivered a set of 2-hour workshops on ETL and Data Integration, using SAS as examples

Developed and regularly delivered a 2-hour workshop (and in-class) on the use of the quantitative software package QSR*NUDIST, subsequently adopted as a training resource by the software vendor

Delivered semi-annual refreshes of all analytical software on all supported platforms for the University, with SAS, SPSS and other packages such as MatLab and S (foundation for R) + Data Quality + Data Conversion + Data Analysis

DECISION CONSULTANTS, INC., Raleigh/Durham, NC June 1997 – December 2001

SENIOR IT CONSULTANT AND PROJECT MANAGER

Technologies: SAS, MS Office (Access, Excel, PowerPoint, Word), Lotus Notes, z/OS JCL, Control/M, AIX, Java, Data Conversion

Example project 1 – Practicing Smarter (start-up company) – healthcare records for numerous clients, focus on billing, finance, insurance, payments, pharmacy, oncology, etc. records under HIPAA rules including ICD-9 to ICD-10 mapping + Data Conversion + Data Quality + Data Analytics

Example project 2 – for Global 100 multi-national client of IBM GS – global Reporting and Analysis report distribution + Data Conversion + Data Analysis + Data Quality

Example project 3 – SAS Institute – included HRMS implementations on behalf of SAS for its US HR/V clients

Example project 4 – NORTEL, a multi-billion-dollar Global Networking Equipment Manufacturer

Led remediation of a system costing $2-3 million per hour in lost orders + Data Conversion + software development + data architecture + Business Intelligence + Reporting/Analytics

GOVERNMENT OF CANADA (various departments), Ottawa, ON before 1997

Technologies: INGRES, Natural, ADABAS, SAS, Korn shell, HP/UX, IBM MVS and VM (now IBM Z), MS Excel, job scheduling, Tabula, HP-3000, Banyan Vines, Novell, WordPerfect, COGNOS Suite (included being alpha test site), Offering Management, solution integration, Data Conversion

Last post: CHIEF, INFORMATION DEVELOPMENT, PUBLIC SERVICE COMMISSION OF CANADA (director level and statistician-of-record)

design, implementation and management of HRMS for analytical purposes; team of 40 + Data Conversion + Data Analysis + Data Management + Data Lineage + Reporting/Analytics + statistics + Business Intelligence + data architecture + Data Quality + regulatory reporting

Prior: ASSISTANT DIRECTOR (AND ACTING DIRECTOR), Client Operational Services Directorate, Accounting Banking and Compensation Division (ABCD), SUPPLY AND SERVICE CANADA (SSC)

ABCD was the sole A/P, A/R and salary cheque issuing agency for the Government of Canada

SSC was the procurement agency for all federal government purchases

MANAGER, HRIS Division, DEPARTMENT OF REGIONAL INDUSTRIAL EXPANSION

This was the world’s then-largest COGNOS configuration, covering all facets of HR Management

Implemented as an integrated set of seven bilingual databases, for legal paper document generation, position classification and staffing records; team of seven

PROJECT LEADER, SENIOR ANALYST AND SENIOR PROGRAMMER, Statistics Canada, responsible for Health, Education, Science, Culture, Justice, Agriculture, Census Operations for Agriculture and Census Operation for Population; for most of a year, additionally Consumer Price Index (CPI), Salary and Earnings survey, Hospital Survey of Therapeutic Abortions, CANSIM (Canadian Socio-Economic Modelling and its data, such as Gross Domestic Product, wholesale trade by NAICS, etc.), Human Resources; team of over 40. Roles were data focused with an emphasis on Data Quality and Data Conversion

OTHER

Treasurer for international and national conferences, and church treasurer (also member of Parish Council)

Other Technologies

In no particular order: GitHub, Jira, Power BI, Python, QuickBooks, Subversion

PUBLICATIONS and PRESENTATIONS

1.HP QuickSpecs for the HP Converged Infrastructure for SAS High-Performance and Visual Analytics (CI for SAS H-PVA) http://www8.hp.com/us/en/products/solutions/product-detail.html?oid=5405512

2.Proceedings of the SAS Global Forum 2013, San Francisco, CA; April 27-May 2, 2013; “Paper 466-2013 –SASVA – Network Considerations and Information Governance”

3.North Carolina PMI® Chapter Monthly Meeting, RTP NC; April 22, 2010; reprise of “Project People: The Good, the Bad and the Ugly”; attendees earned PDUs and Risk PDUs

4.PMI® Global Congress 2009 – North America, Orlando, FL; October 10-13, 2009; “Project People: The Good, the Bad and the Ugly”; attendees earned PDUs and Risk PDUs

5.Invited paper: Proceedings of the 31st Annual SAS™ Users Group, San Francisco, CA; March 26-29, 2006; “Litigation Data Analysis, Auditing and ETL for BI: Triplets Separated at Birth”

6.Best contributed paper: Proceedings of the 30th Annual SAS Users Group, Philadelphia, PA; April 10-13, 2005; “Litigation and SAS™: Some Dos and Don’ts (or, You Call that Evidence?)”

7.Acknowledged contributor to “Canadian Financial Management: Theory and Practice” by Eugene F. Bigham, Alfred L. Kahl, William F. Rentz. Published by Holt, Rinehart and Winston of Canada

AREAS OF EXPERTISE

Program Delivery / Management

Staff/Consultant Engagement

Transformational Leadership

International Project Management

Change Agent / Innovator

Executive Briefings / Webinars

Data Quality and Fit-for-Purpose

Software Development / Support

Data/Information Governance

MDM/Data/Information Architecture

International Financial Operations

Budget Management / Forecasting

Staff Development / Mentoring

Infrastructure Architecture

Business Process Engineering

IT Project Management

Organizational Development

Data Warehousing / ETL / ELT

Data Analytics

Data Management

HRIS/HRMS Implementation/Design

Litigation Data Analysis (FLSA / OFCCP / EEOC)

System Development Lifecycle Standards, Management, development (Waterfall, Agile, Iterative, Rapids, RUP)

Global Team Management

Business intelligence

Data Conversion

Contact this candidate