Charlotte, North Carolina, United States
Senior Business Data Analyst | Banking & Financial Services 📊 Senior Business Data Analyst with 9+ years of experience supporting Banking and Financial Services organizations by delivering governed, analytics-ready data solutions across Commercial Lending, Mortgage, Loan Servicing, Credit Cards, and Digital Banking platforms. Experienced in translating regulatory, audit, and business requirements into scalable data pipelines, validation frameworks, and reporting solutions. Strong background in data governance, data quality, reconciliation, and metadata management, ensuring audit-ready, compliant datasets aligned with SOX, CCAR, Dodd-Frank, KYC, and AML standards. Demonstrated expertise in SQL, ETL architecture, and data integration using Informatica and Azure Data Factory, partnering closely with engineering, compliance, risk, and business stakeholders. Proven ability to support system migrations, data conversions, and enterprise reporting initiatives, delivering trusted datasets for operational, regulatory, and executive decision-making. Highly skilled in developing Power BI and Tableau dashboards 📈, enabling clear visibility into financial performance, reconciliation metrics, and compliance indicators. Adept at working in Agile and Waterfall environments 🤝, balancing delivery timelines with data accuracy, governance, and regulatory rigor. Core Competencies 🧩 Data Governance & Quality | Metadata & Lineage | SQL | ETL & Data Integration | Informatica | Azure Data Factory | Power BI / Tableau | Commercial Lending & Mortgage | Loan IQ | Salesforce FSC | Regulatory Compliance (SOX, CCAR) | Agile / Scrum #SeniorBusinessDataAnalyst #Banking #FinancialServices #DataGovernance #AnalyticsReady #ETL #Informatica #AzureDataFactory #SQL #PowerBI #Tableau #LoanIQ #CommercialLending #Mortgage #RegulatoryCompliance #SOX #CCAR #AgileDelivery
This project strengthened regulatory compliance, improved capital risk and treasury reporting accuracy, and modernized mortgage, commercial lending, and treasury operations, ensuring audit-ready data and seamless regulatory adherence. Developed and supported enterprise data and web-based solutions for Basel III / CCAR capital risk reporting, treasury management, and mortgage/commercial lending platforms, enabling accurate RWA attribution, syndicated loan reconciliation, streamlined loan processing, escrow analysis, and underwriting workflows. Key Responsibilities: ✔ Led Basel III, CCAR, and Treasury Management initiatives with Risk, Finance, and Regulatory Reporting teams. ✔ Validated and reconciled capital, RWA, lending, and treasury data across multiple source systems, reducing manual adjustments. ✔ Strengthened data lineage, controls, and audit documentation to improve regulatory and treasury transparency. ✔ Designed and supported enterprise web-based platforms for mortgage origination, servicing, escrow, commercial lending, and treasury operations. ✔ Enabled daily reconciliation of syndicated loan positions, transactions, contracts, and treasury cash positions for agent banks and lenders. ✔ Developed Power BI and Tableau dashboards and supported SIT/UAT, defect triage, and Agile delivery in Jira.
Project 1: BI Solutions for Mortgage Operations This project improved mortgage origination and servicing visibility, enabling data-driven decision-making and operational efficiency. Developed enterprise Power BI dashboards consolidating mortgage data to track loan performance, workflow efficiency, and compliance metrics. Key Responsibilities: ✔ Designed and delivered Power BI dashboards for mortgage origination and servicing KPIs. ✔ Integrated data from multiple mortgage systems using SQL and cloud-based platforms. ✔ Defined reporting metrics and data models in partnership with Operations and Risk teams. ✔ Automated operational and compliance reports, reducing manual effort. ✔ Built executive scorecards highlighting exceptions and workflow bottlenecks. ✔ Supported Agile delivery through user stories, sprint planning, and Scrum ceremonies. Project 2: FDIC Reporting Automation (UDIRP) This project streamlined FDIC regulatory reporting and improved data accuracy through automated ETL and reporting workflows. Automated quarterly FDIC UDIRP submissions using Informatica and SQL, ensuring compliant and audit-ready reporting. Key Responsibilities: ✔ Automated FDIC UDIRP reporting using Informatica ETL and SQL pipelines. ✔ Defined AS-IS / TO-BE data models, mappings, and validation rules. ✔ Conducted data profiling, reconciliation, and quality checks for regulatory accuracy. ✔ Embedded data governance, lineage, and control checkpoints into reporting workflows. ✔ Supported AML and One KYC reviews by analyzing wire and account activity. ✔ Managed SIT/UAT defects and coordinated issue resolution through Jira.
This project modernized a legacy mortgage loan origination platform, improving automation, data accuracy, and regulatory compliance. Supported the implementation of a scalable origination system streamlining application intake, underwriting, and document management. Key Responsibilities: ✔ Gathered and documented business and functional requirements for mortgage and home equity origination. ✔ Performed process mapping and gap analysis to identify automation opportunities. ✔ Defined business rules and validation logic for underwriting and exception handling. ✔ Authored BRDs, process flows, and user stories supporting development teams. ✔ Supported data mapping, reconciliation, and SIT/UAT testing activities. ✔ Embedded regulatory controls and supported post-go-live stabilization.
This project modernized commercial lending operations, improved data integrity, and strengthened regulatory compliance by replacing a legacy loan servicing platform. Delivered an enterprise commercial lending solution through the AFS Level III to AFS Vision migration, enabling scalable origination, servicing, escrow, and syndicated lending workflows. Key Responsibilities: ✔ Led end-to-end migration from AFS Level III to AFS Vision for commercial loan servicing and syndication. ✔ Defined functional and system requirements across origination, servicing, escrow, and syndication workflows. ✔ Performed data mapping, reconciliation, and logical data modeling to ensure accurate data migration. ✔ Coordinated with ETL and BI teams to validate ELT pipelines and downstream reporting accuracy. ✔ Streamlined loan workflows, reducing manual effort and improving straight-through processing. ✔ Managed SIT/UAT cycles, embedded regulatory controls, and supported post-go-live stabilization.