Lily Gerardo
CRA Compliance Officer I
- Role
- Cra Compliance Officer i Cra Compliance and Exam Management at Truist
- Location
- Charlotte, NC, US
- LinkedIn followers
- 500 followers
About Lily Gerardo
CRA Compliance and Exam Management Officer in the financial services industry with a background in leadership, audit, risk, and regulatory governance. Specialized in Microsoft 365 automation, data analytics, and process optimization to modernize control environments, eliminate manual data processes, and streamline complex workflows. Experienced integrating regulatory risk expertise with technical capabilities to translate business and compliance requirements into scalable, technology driven solutions that strengthen governance and deliver measurable operational impact.
Experience
Cra Compliance Officer i Cra Compliance and Exam Management
Oct 2024 — Present
Perform Tier 1 CRA eligibility determinations for community development loans, investments, and services while building data driven validation frameworks that have reduced review cycle time by approximately 75% and strengthened regulatory compliance accuracy.• Engineered a Power Platform solution leveraging Power Apps, Power FX logic, and Power Automate workflows to centralize quarterly Go-to-Market reporting across 146 Facility Based Assessment Areas, replacing manual workflows with structured data capture that strengthened validation controls, improved data accuracy and retention, and standardized reporting.• Launched a user focused Power BI dashboard that evaluates occupational wage by geographical area and occupation through the integration of BLS employment data by MSA and non MSA, FFIEC Median Family Income data, BLS area definitions, and internal footprint datasets, which reduced the annual manual data compilation process by approximately 90%.• Built advanced compliance analytics frameworks utilizing Python, Power Query, and DAX modeling to automate disaster, distressed, and underserved geographic impact analysis, delivering regulator ready reporting that enhanced leadership visibility and strengthened CRA examination preparedness.
Education
University of North Carolina at Greensboro
Bachelor of Science - BS, Economics
2015 — 2018
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.