Data Analyst Senior
Resume:
Crystal Warmack
Senior Data Analyst & Compliance Risk Analyst SQL • Python • AML/BSA • TRID
Bailey, CO 80421
*******.*******@*****.***
https://www.linkedin.com/in/crystal-warmack/ https://github.com/CrystalW11 https://crystal-warmacks-portfolio.vercel.app/ PROFESSIONAL SUMMARY
Data Analyst with over 15 years of experience in transforming financial and operational data into actionable insights that support strategic decision-making. Proficient in SQL, Excel, and Python for data querying, automation, and modeling, with a strong track record in dashboard reporting and trend analysis. Demonstrated ability to collaborate effectively with audit, compliance, and engineering teams to ensure data accuracy and regulatory alignment. Aiming to apply extensive analytics expertise in a data- centric role to drive organizational success.
TECHNICAL SKILLS
Analytics & Data Strategy:
Data Cleaning & Transformation, Financial Modeling, Forecasting, Budgeting, Variance Analysis, KPI Reporting, ROI Analysis, Trend Analysis, Audit Readiness
Tools & Platforms:
SQL (MySQL, PostgreSQL), MongoDB, Python (Pandas, NumPy), Excel (Advanced Formulas, PivotTables, VBA), Tableau, Flask, Git, GitHub, Appian, Encompass
Web & Full-Stack Technologies:
React, Vue.js, JavaScript, Java, RESTful APIs, Node.js, Express.js, Three.js Currently Upskilling:
Power BI, matplotlib, seaborn, C#, API integration for analytics Compliance & Risk Analysis:
AML/BSA, FCRA, ECOA, TRID, GLBA, OCC Guidelines, FHA, VA, Non-QM Loan Review Core Strengths:
Goal-Oriented, Cross-Functional Collaboration, Risk Analysis, Process Optimization, Business Requirements Gathering, Documentation & Reporting
PROFESSIONAL EXPERIENCE
Independent Study and Technical Training 01/2024 to 09/2024
• Engaged in independent study of Python, SQL, and web development to re-enter a data-centric profession.
• Executed household duties alongside dedicated technical upskilling using various online resources.
• Enrolled in coding bootcamp to further expertise. Data Analyst and Risk Specialist Situs AMC Remote 03/2016 to 03/2024
• Analyzed data to detect risk trends, anomalies, and fraudulent activities.
• Utilized Excel VBA and Tableau to build dashboards for monitoring real estate portfolio performance and compliance.
• Improved data accuracy through automation and anomaly detection.
• Executed analysis of variances and trends to minimize operational inefficiencies.
• Managed datasets adhering to FHA, VA, TRID, HARP, FNMA, and OCC standards to ensure precise reporting. Key Achievements:
• Achieved reduction in data error rates during compliance reviews by utilizing automation and custom SQL queries.
• Exposed multi-million-dollar fraud through innovative risk-scoring approaches.
• Commended for fostering teamwork and optimizing processes using data insights. Mom Career Break 06/2013 to 03/2016
• Took a career break to establish a family.
Data & Audit Analyst and Loan Compliance Clayton Holdings, LLC Denver, CO 07/2011 to 06/2013
• Analyzed servicing datasets to identify documentation inconsistencies and timeline issues related to modifications, bankruptcies, and title transfers.
• Developed standardized audit templates for financial reporting across diverse loan products.
• Provided actionable data insights to risk teams to enhance decision-making processes.
• Conducted analysis of financial data to aid in OCC-mandated consent order monitoring for a major financial institution.
• Ensured accuracy and compliance in judicial and non-judicial foreclosure data reconciliation.
• Ensured bankruptcy case data met all legal and compliance requirements. Key Achievements:
• Recognized for exceptional audit quality with rapid promotion to QC Analyst.
• Guided thirty analysts in compliance procedures, improving audit readiness. CERTIFICATIONS & COURSEWORK
Colorado Technical University Coding Dojo Full Stack Certification 01/2024 – 09/2024 Completed: September 2024
Technologies: Python, Java, JavaScript, Vue.js, React Software Developer Certified
• Key Coursework: Software Engineering Principles, Building Real-Time REST APIs With Spring Boot, Java 17 Master Class
• Completed three comprehensive Full-Stack Web Development Certifications, covering front-end and back-end technologies with Vue.js and React
Ongoing Learning:
C# Programming FreeCodeCamp (Self-Paced)
Applying object-oriented principles to financial modeling and automation. TECHNICAL PROJECTS
My Programmer Portfolio Developer https://github.com/CrystalW11/Crystals-portfolio.git React-based personal website showcasing interactive UI projects and data integration work.
• Designed front-end components with React, integrating 3D visuals using Three.js.
• Built responsive layouts and applied accessibility best practices. Key Achievements:
• Integrated 3D graphics into a React portfolio using Three.js, enhancing user engagement with interactive, real-time visual elements.
Pizza-Time Full Stack Developer Group Collaboration https://github.com/CrystalW11/Pizza-Time Full-stack app with data handling and delivery tracking for customizable orders.
• Build RESTful APIs using Flask and MySQL for order management.
• Integrated GPS API for real-time location and analytics features. Key Achievements:
• Developed full-stack software projects including a GPS-enabled delivery app and an interactive React-based portfolio site.
Contact this candidate