Looking for a job

John Grumke

@johngrumke

Analytical professional with 15+ years of experience in recurring report generation, data validation, and stakeholder reporting.

United States

Message

What I'm looking for

I’m looking for a challenging opportunity, one that includes room for growth.

I have over 15 years of experience as a Business Analyst, I have developed a deep expertise in managing complex data, creating high-impact client reports, and driving operational efficiency.

Throughout my career, I have consistently balanced recurring monthly reporting cycles with urgent, ad-hoc data requests. At CPO Commerce, I managed promotional billing and inventory reporting, ensuring that data was accurate, formatted correctly, and aligned with stakeholder needs.

My experience at CIT Bank and IndyMac Bank involved high-stakes reporting for internal leadership and external regulatory agencies, including the FDIC. These roles required me to manipulate large datasets using Excel and SQL, translate complex business questions into polished presentations, and maintain meticulous documentation for audit purposes.

Experience

Work history, roles, and key accomplishments

Business Analyst

CPO Commerce

Nov 2020 - Apr 2025 (4 years 5 months)

Managed high-volume recurring reporting for inventory strategy, updating the master promo log and running daily FTP uploads to support the data warehouse and pricing system. Processed monthly promotional billing for accounting, resolved billing disputes, and prepared weekly dashboards plus quarterly excessive returns reporting.

Microsoft SQL Data Validation Reporting & Analytics FTP Process documentation Microsoft Office Suite Data Warehouse

Business Analyst

Cit Bank, N.A.

Nov 2015 - Jun 2019 (3 years 7 months)

Built and maintained QA queries, compliance matrices, and audit documentation for mortgage loan servicing sub-servicer oversight. Tracked regulatory notifications, performed service-level QA testing, and supported SOX/FDIC loss-share reporting with time-sensitive auditor responses.

SQL Quality Assurance Testing Regulatory Compliance FDIC Loss Share Reporting Mortgage Loan Servicing PowerPoint Data Modeling

Business Analyst

OneWest Bank, N.A.

Jul 2011 - Mar 2014 (2 years 8 months)

Coordinated quarterly compliance audits for completed loan modifications and produced management control reports for SOX calculations tied to loan servicing. Conducted quarterly testing for HAMP, generated monthly trending reports, and prepared responses to auditor observations and exceptions for the 60-day delinquent loan portfolio.

Compliance Auditing Mortgage Servicing Home Affordable Mortgage Program (HAMP)60 Day Delinquent Portfolio Reporting Management Reporting Audit Response

Business Analyst

Mortgage Recovery Law Group

Jun 2009 - Jul 2011 (2 years 1 month)

Created and maintained databases for loan-level quality control audit findings and delivered on-demand client reporting. Developed audit-driven KPI reporting and drafted ad hoc investigative reporting requests for management and auditor needs.

Loan Quality Database Management KPIs Investigative Reporting Client On Demand Reporting Data Validation

Business Analyst

Indymac Bank

Feb 2001 - May 2009 (8 years 3 months)

Generated time-sensitive spreadsheets by querying multiple proprietary data sources with SQL and modeling results in Excel using formulas, VLOOKUPs, and pivot tables. Ran a monthly post-purchase quality control pipeline for 90+ day delinquent loans, maintained a fraud recovery database, and presented loss recovery/avoidance results and seller scorecards to senior management and the FDIC.

SQL Pivot Tables Post Purchase QC Pipelines Fraud Recovery Databases