Looking for a job

Christopher Rangel

@christopherrangel

Data and analytics leader in banking who automated Board reporting from 40+ hours to under 30 minutes.

At InBank, I automated the Board Reporting Package, cutting preparation time from 40+ hours to under 30 minutes. I also engineered automated solutions for incentive tracking and executive KPI reporting, and directed Cognos BI development and SQL administration.

At Mechanics Bank, I engineered audit-ready data platforms and reporting solutions, with automation that reduced manual effort by 50–90%. I also assisted product owners with bank merger data migration and conversion, using test data to expose loan-code gaps and prevent dozens of misclassifications before go-live.

Experience

Work history, roles, and key accomplishments

Sr. Analytics and Data Manager

Mechanics Bank

Jan 2023 - Jun 2026 (3 years 5 months)

Engineered SaaS-based, audit-ready data platforms and automated reporting solutions tied to defined KPIs. Automated processes that eliminated day-long manual efforts and reduced FTE utilization by 50–90%.

SQL Python Claude Code AI assisted Development Data Integration Data Migration Data Validation SaaS Automation

Vice President, Data Management & Analytics

InBank

Feb 2021 - Jan 2023 (1 year 11 months)

Engineered automated SaaS-integrated solutions for bank-wide incentive tracking and executive KPI reporting. Automated the Board Reporting Package, reducing preparation time from 40+ hours to under 30 minutes.

Cognos SQL SaaS Automation KPI Reporting Data Migration Data Conversion Audit Support

Independent Data Consultant

Rangel Consulting

Jul 2017 - May 2022 (4 years 10 months)

Provided data consulting, ad-hoc reporting, and data interface development for community banking clients. Designed and maintained enterprise reporting solutions across daily, weekly, monthly, and board-level cadences.

Data Consulting Reporting Data Interface Enterprise Reporting Efficiency Solutions

Vice President, Manager of Data Reporting & Analytics

First National 1870 (Sunflower Bank)

Oct 2013 - Jul 2017 (3 years 9 months)

Built full data reporting infrastructure from the ground up: SQL Server architecture, SaaS-based automation, and complete automation of daily, weekly and monthly departmental reporting. Directed Cognos development and data mining; supported annual audits and quarterly auditor reviews.

SQL Server SaaS Automation Cognos Data Mining Audit Support Data Migration

Director of Information Reporting

Core Centrix

Jun 2011 - Jul 2013 (2 years 1 month)

Designed client-configurable SaaS reporting packages meeting state and federal regulatory requirements for community banks. Administered SQL Server-based data warehousing and ETL processes.

SaaS SQL Server Data Warehouse ETL Excel Feed Integration

Senior Applications Developer

Vineyard Bank

Jan 1996 - Dec 2010 (14 years 11 months)

Delivered the Onyx CRM and Cognos 8 BI rollout on time and on budget; cut monthly Board reporting from a two-week manual effort to a five-minute automated process.

Onyx CRM IBM Cognos Project Management Automation Reporting

Sr. Project Leader, Business Analyst III, Systems Support Analyst

Fidelity Federal Bank, Union Bank of California, Jackson Fed

Jan 1996 - Dec 2010 (14 years 11 months)

Assisted with system conversions, data migrations, testing and vendor interface development; reduced state escheatment reporting from two weeks to two hours.

System Conversion Data Migration Testing Vendor Integration Escheatment

Financial Analyst & Supervisor, Unit Manager

Wells Fargo Bank and Wells Fargo Auto Finance

Jan 1996 - Dec 2010 (14 years 11 months)

Built an Excel staffing model that reduced scheduled FTE and proof machines from 130 to 80; managed a 15-person customer service and insurance collections team.

Excel Staffing Models Team Management Customer Service Insurance Collections