David Crane Email & Phone Number

Florida, United States

- Started a small business venture selling surplus aircraft decals for private owners.

Worldwide, Us

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. Interface with stakeholders in order to establish the Book of Work, the Book of Solutions, Evidence Gathering for each Critical Data Element and act as the Point Person for ownership throughout the lifecycle of the CDE into Production Deployment. Typically, close to 100 profiles were created each month per person.• Trading Workflows: CDEs are part of OTC (Over the Counter), FXD (Foreign Exchange Derivatives), and IRD (Interest Rate Derivatives), ETD (Exchange Traded Derivatives) throughout the lifecyle of Pre Trade, Trade Execution, Trade Clearing, Trade Settlement, Ongoing Risk and Position Management.• FIX Messaging Format: The CDE registration is mapped to our Data Dictionary system CitiFIX which contains the tag protocol number.• OMS: Trade entry systems are the source systems for the CDEs typically SimplicitiFX,Simliciti, eDealer, DCS Derivatives Clearing Service, Flexcube, Optima,FXCO, MONET, AQUA, Quantum FX and Local Marke

Hanover, Md, Us

At Capital One*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*Focus on adapting JIRA for work in a large organization migrating from a SAFe model involving JIRA Align to a more strict use of only JIRA*Creation of consistent intake forms for intent flowing into JIRA*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. * Highly organized with great reporting and presentation skills as well as experienced with working with multiple stakeholders in complex environments

Hanover, Md, Us

At PwC PriceWaterhouse Coopers*Capturing performance, ensure delivery is meeting the business requirements; *Monitor, report, analyze operational execution; *Metrics gathering and dashboarding;, creating and reporting on KPI’s associated with ITIL Practices;*Collaborate with IT teams/vendors to facilitate effective issue resolution; *Identify service delivery issues and define performance improvement plans;*Coordinating with Tier 1 Support (3rd Party Vendor) for training and triage as well as identification of issues that can be resolved via 1st call resolution;*Overseeing delivery and maintenance of application KB articles (working in conjunction with L2 Support Analysts); *Configuring ServiceNow (tickets and reports) to ensure proper ticketing flow as well as metrics gathering; *Defining escalation strategies for major incidents; *Identifying and engaging all external teams that will own a support component for the application (hosting, external vendors, etc);*Maintaining and tracking application infrastructure and asset information via ServiceNow APM/CMDB tools;*Onboarding/Training/KT for support team (L2, L3, L4)*Building for Ops Readiness: ensure operational readiness. Establish a relationship with Product Owners and reach a common understanding of support requirements and expected outcomes. Monitor Product Roadmaps to understand upcoming features and release schedules. Ensure user stories employ a Definition of Done that includes Operational and Production readiness. Enforce Non Functional Requirements Adherence: includes performance, capacity, monitoring, architecture and security criteria. *Coordination with QA leader to validate adequate testing scope. *CI/CD Readiness Assessment. Creation of production like environments for dev and test. *Ensure set up of automation in lieu of manual processes/tasks;

Dallas, Texas, Us

At Southwest Airlines• Transform: 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. 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• AWS Cloud Professional: Cloud Project Manager managing Commercial Portfolio Projects migrating into the AWS Cloud Infrastructure from On Prem infrastructure tracking features, risks, issues and dependencies, cybersecurity stage gates, Activation Plans, PPV, Business Continuity, Cloud Financials• Project Financials: Managing CapEx and OpEx through Cloudability

Jersey City, Nj, Us

Creating: Agile Documentation and blog postsAnalyzing: Power BI and WPA used for Agile Metrics studiesAnalyzing: Value Stream Maps and Process Flows for deployments (Cloud and Ground)Developing: Power Apps for enhanced surveys and process automationDeveloping: Power Automate for process automation and data securityMentoring: On Lean and Value Stream Maps, developing hypotheses for studies, SQL queries basics

Jersey City, Nj, Us

Working in Enterprise Infrastructure for the OCIO...primarily in PMO documentation for requirements gathering for AWS and Azure Cloud Deployments• Cloud Platform Cloud Compliance and Security: lead an 8-person squad in manually enforcing Cloud object compliance for disciplined security and automating Cloud object compliance using TFE Sentinel, Inspec, Azure DevOps• AWS and Azure Cloud Professional: Helping develop a Cloud Platform and standards from an Infrastructure and Security standpoint, 80% AWS and roughly 20% Azure deployments.• Scrum Master; 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• Transformation: Champion Agile Transformation and develop proper mitigation plans in order to ensure disciplined delivery• Product Ownership; Requirements Gathering and prioritization, meetings with stakeholders in order to take notes for requirements gathering process in order to create User Stories and Epics in JIRA• Requirements Gathering; SRDs (a hybrid BRD and FRD), TSD, and RTM developed for Enterprise Infrastructure. Primary projects included: Disaster Recovery Improvement, Network Segmentation, PMO Business Case Process Enhancement, Block Chain Exploratory Tech Initiative• Business Case Development: scoping CapEx and OpEx expenses, resource allocation, ROI development, Risk evaluation• Innovation; involved in R&D on Block Chain technology frame involving distributed ledger systems

Tarrytown, New York, Us

At DTCC prior to conversion· Requirements Gathering; SRDs (a hybrid BRD and FRD), TSD, and RTM developed for Enterprise Infrastructure. Primary projects include: Disaster Recovery Improvement, Network Segmentation, PMO Business Case Process Enhancement, Block Chain Exploratory Tech Initiative · Business Case Development: scoping CapEx and OpEx expenses, resource allocation, ROI development, Risk evaluation · Innovate; involved in R&D on Block Chain technology frame involving distributed ledger systems · Mentor: provide requirements gathering knowledge, app dev experience to junior employ

Washington, District Of Columbia, Us

At CitigroupReporting: Develop, document and maintain Basel III Compliance Tracker using Sharepoint (Publishing, Lists, Tasks, and Automation Development) champion compliance to the increased standards, manage deadlines and datesIntelligence: Data Quality Analaysis utilizing internal software known as DIP and systems such as SAS to conduct data quality searches, champion changes to improve data qualityCreate Oracle SQL queries, annotate and process report requests, Create Access Databases and reportsMentor: provide mentoring in advanced MS Office, SQL, and SAS tasks to other employees

Milwaukee, Wi, Us

• At PwC PriceWaterhouseCoopers• Develop and maintain more than thirty five concurrent reports utilizing Oracle reporting tools, MS Access, Starcite Events Cloud, QuestionMark, and IBM Lotus Notes 7• Manage IBM Lotus Notes request queue for Report Requests• Create Oracle SQL queries, pull and schedule adhoc reports for the Starcite system, export File Transfers from Question Mark, annotate and process report requests, Create Access databases and reports• Documentation of all processes followed in technical docs

Glen Allen, Va, Us

• At Citigroup• Develop automation code using MS Access 2010 and Sharepoint 2007 in order to process a Manager Scorecard for the entirety of CSS including AP, FRO and HRSS• Manage ticketing system for the Enhancement Request Database in AP utilizing MS Access 2010 and Sharepoint 2007• Install and develop AOD system (Access 2010/Sharepoint 2007/VBScript) as an interface to the P2P Software for Enterprise Metrics• Create Oracle SQL queries for data profiling and volume analysis/capacity planning

New York, New York, Us

• Manage Data Quality Wave 2 process of profiling data, establishing metrics, diagnosing data quality issues, assessing impact, pursuing resolution through the ticketing process, and • Research the handling of transactions of all types within the bank from end to end (including their accounting nature) and a comprehensive understanding of why monitoring is performed and exactly how it works both in process and in software including the arrangement of Oracle based server Mantas• Create Oracle SQL queries for data profiling, data warehouse reconciliation of Transaction Codes, and volume analysis/capacity planning• Create software for automation of all teams within the utility (primarily using MS Access and Access SQL). Including the import and export of flat files utilizing parsing.• Research the data flow of flat files into the Mantas database • Create and present training courses (including technical writing of instruction manuals) on topics of expertise (SME)• Implementation of 8 of the 10 AML scenarios (things like large deposits or frequent deposits) necessary for AML triggering according to Citi consent order issued by OCC• Data Quality: 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)• UAT: Tested Actimize and specifically its UI in Spanish and Portuguese. Connection for the AML L1 analyst to review the alert and do research for escalation to L2 using Accurint. L1 Research link included an interface to run Accurint to check the background (part of KYC)• Maintain meetings for stakeholder groups in North America, Latin America, Warsaw, and Kuala Lumpur

Hanover, Md, Us

• At Citigroup• Prepare test plan Strategy Documents, 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• Analyze database using Oracle SQL (plSQL) and train UAT team in performing queries• Monitor test and change control metrics (including report creation)• Liaise between key project stakeholders (globally across all regions) and UAT team, Participate in Change Control Board /Tech Workslate process

Hanover, Md, Us

• At Chase Bank• Manage readiness for move of functions from Lowell Direct Transmission Services to Tampa, Florida.• Researched end to end workflow - process analysis, procedure development and documentation, development of job aids for hand loading files and data reconciliations utilizing Oracle SQL (pl SQL) to analyze• Documented workflows and procedures for a team in Massachusetts whose work was due to be transitioned to Tampa• Supported client inquiries on technical file transmissions (host-to-host, EDI, FTP, etc.) • Provided status of the transmission, troubleshooting the transmission setups and individual files being sent, etc. • Created technical procedures for troubleshooting transmissions / setups with clients.

Ocala, Fl, Us

Liaise with external clients (front end brokers) in order to integrate them into the Wholesale mortgage environment; Gathered requirements from external stakeholders, created project plans, defined functional specifications, created user interface flows, tested products and fulfillment processes prior to launch, and ensured product quality were maintained after launch.Gather requirements for Functional Requirements Documents and Business Requirement Documents, Define Use Cases, create Wireframes, head SCRUM sessions and prepare ERDsActing DBA for the backbone system known as TBW_LOR or “Lore system” including schema creation, maintenance, entitlement, automation, data warehousing, data mappingAssisted in the growth of an online network designed to facilitate loan processing from site to site. Responsibilities include strategic planning, product/process development, business analysis and performance reporting.

Computer Science

Education record