Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

David Crane

Tampa,FL

Summary

Seasoned Business Intelligence Analyst with background in converting complex data into actionable insights to drive decision-making processes. Skilled in analyzing trends, crafting detailed reports, and enhancing business operations through technology solutions. Demonstrated ability to work collaboratively across teams to implement improvements, leading to increased efficiency and productivity.

Business professional offering experience delivering cost-effective, high-performance technology solutions to meet shifting organizational demands. Astute technology-business professional translates operational needs into technical solutions. Equipped with analytics and reporting expertise to provide insights using data-driven philosophy.

Goal-oriented professional successfully assists companies by developing and implementing updates to operational standards, team organization and employee engagement strategies. Proactive and personable leader with top-notch skills in streamlining information, prioritizing tasks and approaching issues with analytical mindset. Bringing years of experience and demonstrated track record of success.

Overview

13
13
years of professional experience
1
1
Certification

Work History

Lead Data Analyst – Citigroup – Olympus Data Quality

Pyramid Consulting
Tampa, FL
01.2024 - 11.2024
  • Regulatory Compliance and Audits: Olympus and Eagle are data quality engines used to monitor the data in the trade execution workflow for the purposes of compliance with the OCC (Office of the Comptroller of the Currency) and Fed (Federal Reserve)
  • Specifically, this role concerned Citigroup’s compliance with Article V of the Consent Order of the OCC and required specific audit requirements
  • SQL Data Quality Profiling: Design SQL data quality profiles to query the Interest Rate Derivatives Business, Risk and Finance domains on axes of Completeness and Validity
  • Each statement in the profile represented different evidence for a Critical Data Element
  • Typically, close to 100 profiles were created each month per person
  • JIRA: End to End responsibility from the point of CDE profile request to delivery of the rule
  • Work tickets in a Kanban board including creation of tickets and bulk uploads/changes and exports to Excel
  • DAC: Tableau reporting provided evidence for the presence of the active rule and reporting on the exception counts of the queries
  • Reporting on Milestones which were incorporated into dashboard reporting and Book of Solutions, all of which were delivered to the requester and SLT via communications such as email

Senior Project Manager – Capital One – Retail Banking Technology

TEKSystems
Tampa, FL
01.2023 - 12.2023
  • Post Agile Continuous Delivery: Design and implementation of a post agile delivery model for Retail Banking Technology (Intake/Planning/Delivery/Monitor/Manage) for a group consisting of 250 teams with over 1100 employees
  • JIRA End to End: Focus on adapting JIRA for work in a large organization migrating from a SAFe model involving JIRA Align to a stricter use of only JIRA
  • Creation of consistent intake forms for intent flowing into JIRA and tracking of work completed, along with costs
  • Tableau: Monitoring of balanced delivery metrics such as TTM (Time to Market), Lead Time, Cycle Time
  • Remediating a gap in understanding, communicating, and tracking status reports and overall project(s) health and ensuring that all parties and stakeholders are up to speed with details around projects

Delivery Lead – PwC (PricewaterhouseCoopers) - Digital Asset Office - Risk Portfolio

TEKSystems
Tampa, FL
05.2022 - 12.2022
  • Project Management: Managed onboarding of the following products into the Ops environment (SRE support, DataDog, PagerDuty, CMDB, Dependency Mapping, MIM, ServiceNow flows): Risk Atlas, MatterNow, Beacon, THUB, AIO, Terrain Insights, FAAST, DMS
  • Onboarding of the Kanban based teams into the DAO ops process involved various tasks managed (installing DataDog synthetic endpoints, set up of SRE responses, building an SRE runbook, migration of the Cloud environment into DCX Cloud, etc)
  • Financials: Use of Apptio Cloudability to onboard and monitor ongoing cloud costs to evaluate FinOps costs
  • DAC: Creation of KT (Knowledge Transfer), Knowledge Base, Wiki articles, and support scripts for support of the systems

Cloud Migration Project Manager

Pinnacle Group
Tampa, FL
07.2021 - 03.2022
  • Project Management: Use of Scaled Agile Framework, Scrum and Kanban in use throughout the organization with additional high-level tracking of deliverables
  • Managed 16 simultaneous Active Projects across 10 internal stakeholders through this migration which involved cross functional teams such as Cybersecurity, FinOps, Cloud Platform Engineering, and DevOps
  • Build Strategic Working Relationships: The ECDOF was an umbrella program designed to help On Prem or net new projects migrate into the Common Cloud Platform, which was Southwest’ CICD pipeline arrangement
  • Modules existed in the Platform to enable rapid engineering and deployment of Cloud infrastructure
  • All aspects of Cloud migration such as scheduling, meetings, milestones, Security Scans, Pre-Prod Validation, Activation Planning (aka Go Live Strategy), Rollback Plans
  • Financials: Use of Cloudability to track cloud cost management for the projects migrating into the cloud
  • Use of time and effort tracking to understand Capital Expense of Cloud Migration and loss of value of On Prem assets

OCIO DevSecOps Scrum Master / Enterprise Agile Senior Business Analyst

DTCC/DTCC (BTO/HR)
Tampa, FL
02.2016 - 06.2021
  • SQL and PowerBI: Use of SQL to query Workplace Analytics for reports that were ultimately produced in PowerBI (examples include employee working behavior on sign in/sign out)
  • In addition, led several training courses in SQL basics
  • Project Management: Scrum/Kanban/Scrumban, run agile ceremonies such as standups and sprint reviews, backlog Grooming of stories and epics
  • Ceremonies included Standups, Backlog Grooming, Retros, Dependency Mapping, QTR, Scrum of Scrums for Cloud DevOps
  • Primary projects included Block Chain Exploratory Tech Initiative, Cloud Infrastructure and Security standup, Cloud Migration, establishment of CICD pipeline
  • Financials: In the OCIO part of my role was delivering Quarterly budget and forecasting reports along with burndown (MS Project) to executive status meetings, usually prepared in Power Point decks
  • As part of Enterprise Agile one of my duties was to give presentations to the Executive head of HR
  • DAC: Work in Enterprise Agile had the purpose of delivering meaningful metrics in the Agile workspace and creating meaningful insights for presentation to SLT

Basel Reporting and Risk/Finance Analyst

Citigroup
06.2011 - 01.2016
  • Compliance and Audit: In AML the role involved use of SQL to perform data mining and data quality profiling, upgrades to the ETL to accommodate anomalies such as Transaction Code (TCode) inconsistencies and physical address anomalies for LATAM
  • In Basel III reporting the role involved use of SQL to properly use SAS to analyze very large data sets of transactions (millions of transactions per day)
  • Project Management: Prepare test plan Strategy Documents, RICA, (FRD BRD, TDD), Test Scripts, RICA Log, Closure Documents, traceability matrices, track UAT test projects and manage resources (e.g., capacity planning, bandwidth allocation, environment usage), including development of tool to provide the tracking using MS Access VBA, monitor test and change control metrics (including report creation)
  • AML Compliance: Auditing and standardizing the Transaction Codes (TCodes) for the Citibank systems and the interface with Banamex to Citi
  • Enhancement of the KYC (Know Your Customer) process to add in things like type of business and typical account patterns
  • Refinement of false alerts/false positives
  • Refinement of physical address gathering in the ETL (for example addresses in LATAM are not standard to US template)
  • Much of this work was done using Excel and VLOOKUPS for example

Education

Computer Science

Hillsborough Community College
01.2000

Skills

  • Agile/Lean
  • AML
  • ABAC
  • Basel and Risk/Finance
  • BBA
  • CapEX and OpEx
  • CFPOA
  • Change Control
  • Cloud Migration (IaaS, PaaS, SaaS)
  • Corporate Reporting
  • Cybersecurity
  • Data Quality Profiling
  • Data Warehousing
  • Dependency Mapping
  • GSIM
  • DFD
  • ETL
  • FACTA
  • FCPA
  • FCRA
  • Fraud Compliance
  • GLBA
  • HIPAA
  • IAM
  • Infrastructure Provisioning
  • K&R Insurance
  • Servant Leadership
  • OFAC
  • Operations Management
  • OSS
  • OWASP Top 10
  • Portfolio Management
  • Post Agile Delivery
  • Project Management
  • Project Plans
  • RCA
  • Risk Management
  • RPA (Robotic Process Automation)
  • SAFe (Scaled Agile Framework)
  • Scenario Generation
  • Scrum Master
  • SDP
  • SQL
  • SOX
  • UAT
  • Unit Testing
  • Use Cases
  • UX Design
  • VSM (Value stream Mapping)
  • Wireframes/GUID
  • Requirements Gathering (BRD, FRD, TSD, RTM)
  • Tableau software
  • Predictive analysis
  • Data integration
  • Natural language processing
  • Advanced analytics
  • Optimization techniques
  • Data warehousing
  • Machine learning
  • Apache Spark
  • Big data processing
  • SQL expertise
  • ETL development
  • Data quality management

Certification

  • Certified Agile Practitioner – Scrum Alliance
  • Certified Scrum Master - Scrum Alliance

Timeline

Lead Data Analyst – Citigroup – Olympus Data Quality

Pyramid Consulting
01.2024 - 11.2024

Senior Project Manager – Capital One – Retail Banking Technology

TEKSystems
01.2023 - 12.2023

Delivery Lead – PwC (PricewaterhouseCoopers) - Digital Asset Office - Risk Portfolio

TEKSystems
05.2022 - 12.2022

Cloud Migration Project Manager

Pinnacle Group
07.2021 - 03.2022

OCIO DevSecOps Scrum Master / Enterprise Agile Senior Business Analyst

DTCC/DTCC (BTO/HR)
02.2016 - 06.2021

Basel Reporting and Risk/Finance Analyst

Citigroup
06.2011 - 01.2016

Computer Science

Hillsborough Community College
David Crane