Summary
Overview
Work History
Education
Skills
Accomplishments
Timeline
Generic

John McKee

Porter,USA

Summary

Results-oriented and detail-focused Senior Banking Consultant with expertise in financial services and banking operations. Proven track record in evaluating business requirements and identifying avenues for operational improvements. Expert in transforming complex data into actionable insights using advanced data visualization tools, effectively identifying critical trends. Proficient in process optimization and project management, ensuring efficient execution of banking solutions. Demonstrated ability in data analysis, driving informed decision-making and strategic initiatives. Proven track record of enhancing operational efficiency and delivering measurable results in financial environments. Strong communicator with excellent analytical abilities, delivering valuable insights that drive business growth.

Overview

18
18
years of professional experience

Work History

Vice President, Senior Consultant

Northern Trust Bank
Chicago, IL
08.2019 - 03.2025
  • Project leader - Led user acceptance testing (UAT) and completion of a management tool to source real-time data using SQL, Alteryx and SharePoint. Customized management oversight dashboards and Sr. Management metrics using Power BI.
  • Assisted in cleaning and transforming raw data into usable formats, contributing to streamlined reporting processes.
  • Built Excel-based reports and dashboards, reducing manual effort and improving data accuracy and availability for stakeholders.
  • Compliance lead and owner of the department Business Continuity Plan, quarterly SOC1 internal and external auditor testing and Global Business Unit audit.
  • Assist with resolving SharePoint issues and developing new sites to centralize global data in one location. Import SharePoint data into Power BI to generate dashboards.

2nd Vice President, Senior Portfolio Analyst / Consultant

Northern Trust Bank
Chicago, IL
08.2007 - 08.2019
  • CEO presented me with a distinguished Chairman's Quality Award for my involvement in the Accounting System Enhancement Project.
  • Selected to create a new Quality Assurance team within the Business Unit to ensure compliance with both internal and external standards across all global regions.
  • Completed a rotation within the Audit Service / Global Compliance to conduct SOC 1 and SOX 404 compliance testing. Developed Risk and Control Self-Assessment (RCSA) plans and performed internal audit risk testing.
  • Developed an online data storage site using SharePoint to replace hard copy paper reports, enabling the Chicago-based team to conduct global data reviews.

Education

Some College (No Degree) - Accounting and Finance

Purdue University
West Lafayette, IN

Skills

  • Financial Analysis & Modeling: Excel (VBA, Pivot Tables), SQL, Power BI, Alteryx, PowerPoint, SharePoint, Power Platform Tools, MS Word
  • SQL development
  • Data visualization
  • Power BI dashboards
  • Spreadsheet analytics
  • Business continuity planning
  • Compliance management
  • Process improvement
  • Data governance
  • Risk assessment
  • Project leadership
  • Effective communication
  • Team collaboration
  • Banking & Risk Management: Business Continuity Plan, SOC1, SOX404
  • Strategic Consulting: Process Optimization, Digital Transformation, Change Management
  • Documentation and reporting
  • Attention to detail
  • Problem solving
  • Critical thinking

Accomplishments

  • 2008 received a distinguished Chairman's Quality Award for my involvement with an Accounting System Enhancement Project.

Timeline

Vice President, Senior Consultant

Northern Trust Bank
08.2019 - 03.2025

2nd Vice President, Senior Portfolio Analyst / Consultant

Northern Trust Bank
08.2007 - 08.2019

Some College (No Degree) - Accounting and Finance

Purdue University

Similar Profiles

CREATE PROFILE