Shanika Jackson

A Self-motivated mortgage professional with extensive experience in loan servicing and the software development lifecycle. A strong ability to manage priorities in high-pressure environments. Seeking a role that leverages analytical skills to conduct research analysis, risk mitigation, and compliance monitoring.

Adept at delivering high-quality results while ensuring confidentiality and stakeholder satisfaction. Applied SQL and Snowflake to clean, transform, and visualize large datasets, and designed investment dashboards using SQL to support mortgage-backed securities decisions. Committed to continuous learning, innovation, and collaborative success.

Senior Specialist at PennyMac Financial Services (2025-09 – Present)

• Develop and maintain SQL/Snowflake queries to support tax research, audits, exception reporting, and reconciliation.
• Perform root-cause analysis on tax exceptions, refunds, reversals, and non-negotiated checks to reduce recurring issues.
• Met with Executives to discuss Business Requirements for tax workflow enhancements and system improvements.
• Collaborate with IT and Data Engineering to test system updates, integrations, and tax vendor file changes.
• Support compliance and audit teams with data extracts, payment histories, and exception documentation.

Data Analytics Intern at Oeson Learning & Internship (2025-01 – 2025-04)

• Cleaned, transformed, and visualized large datasets using Excel, Python, and SQL, improving data accuracy.
• Built interactive dashboards in Tableau and Power BI, providing real-time insights for business operations.
• Applied statistical analysis and hypothesis testing to identify key business trends.
• Developed automated reporting solutions, reducing manual data entry by 30%.

Data Analyst Trainee at Chegg Skills (2024-05 – 2024-11)

• Analyzed historical sales data, increasing profitability by 20% through pricing and forecasting models.
• Designed investment dashboards that influenced $10M in mortgage-backed securities decisions.
• Utilized SQL and Python to extract, transform, and analyze complex datasets, improving operational efficiency by 50%.
• Developed data pipelines and APIs, ensuring 100% data accuracy in reporting.
• Conducted KPI analysis, optimizing performance metrics by 15%.

Certificate in Data Analyst – Oeson Learning & Internship (2025-04)

Certificate in Data Analyst – Chegg Skills (2024-11)

B.S. in Psychology – University of Phoenix (2012-08)