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