Data Analyst - SQL, Power BI, ETL Validation, Capital Markets

SWATHI MUDDANGULA

LinkedIn: www.linkedin.com/in/swathi-muddangula-a33b5633b

Phone: 630-***-**** Email: ***********@*****.***

PROFESSIONAL SUMMARY

●Senior Business Analyst/Data Analyst with strong experience supporting Capital Markets, Trading, and Wealth Management,Trading Platforms, and Regulatory Compliance(KYC/AML/OFAC)

●Hands-on expertise working with OTC derivatives, FX, fixed income, and investment products, partnering closely with front-office, risk, and operations teams.

●Proficient in SQL-based data analysis, data validation, reconciliation, and building regulatory and management reports.

●Extensive experience in Regulatory Reporting, Liquidity Risk, and Risk & Control frameworks across enterprise data platforms.

●Strong background in AML, KYC, sanctions screening, and financial crime compliance, supporting onboarding and remediation programs.

●Experienced across the full SDLC and Agile lifecycle, including requirements gathering, ETL mapping, UAT, and stakeholder management.

●Experienced in Power BI and advanced Excel reporting, delivering data-driven dashboards and analytical insights to support business and regulatory decision-making.

●Known for delivering accurate, audit-ready analytics and reporting in highly regulated banking environments.

DOMAIN & TECHNICAL EXPERTISE

Capital Markets & Trading Platforms Wealth & Asset Management Portfolio Accounting (GAAP, NAV, Reconciliation) Investment Compliance (Pre/Post-Trade, Rules Engine, OFAC) KYC/AML & Client Lifecycle Management

Data Analysis & Visualization (Power BI, Tableau, Excel) SQL & Data Validation Data Mapping & ETL Testing Data Governance & Break Resolution Trade Lifecycle Management

Agile (Scrum), BRD/FRD, User Stories UAT/SIT/CIT Execution Risk & Controls Azure Data Lake & Cloud Fundamentals JIRA, Confluence, Visio, HP ALM, SharePoint

CORE COMPETENCIES

Business Analysis & Requirements Engineering (BRD, FRD, FRS, Use Cases, User Stories)

Data Analysis, SQL Validation & ETL Testing (Reconciliation, Break Investigation)

Pre-Trade & Post-Trade Compliance (Rules Engine, Breach Management, Incident Resolution)

Portfolio Accounting & Performance Analytics (NAV, P&L, G/L, FX Translation)

RESEARCH & PUBLICATION

Portfolio Manager Ratings: k-Means and LDA versus Active Outperformance – ATINER

EDUCATION

Master of Science in Business Analytics – Lewis University, Romeoville, IL May 2025

Bachelor of Technology in Computer Science Engineering – GITAM University, India Aug 2021

PROFESSIONAL EXPERIENCE:

VForce Infotech / Cetera Financial Sep 2025 - Present

Business Analyst

Responsibilities:

●Developed firm-wide liquidity risk measurement, monitoring, and reporting capabilities through an integrated automated framework (QRM).

●Identified data sources and defined data controls to support liquidity risk models and regulatory reporting requirements.

●Analyzed and documented business and functional requirements for liquidity risk, cash flow, and regulatory reporting processes.

●Supported single-system consolidation initiatives, enabling retirement of legacy Quarterly Risk Management, Monitoring, 2052A, and LMS platforms.

●Worked with Capital Markets data across Foreign Exchange, Interest Rate Derivatives, Equity and Equity Derivatives, Credit Products, and Securities Financing.

●Sourced, analyzed, and validated liquidity-related transactional data to ensure compliance with regulatory data control standards and internal data policies.

●Collaborated with risk, treasury, operations, and technology teams to translate business requirements into functional specifications and user stories.

●Managed OTC derivatives cash flow activities including unwinds, resets, quarterly fees, upfront fees, coupons, and premiums.

●Created and maintained Power BI dashboards and advanced Excel reports to support liquidity risk monitoring, KPI tracking, and regulatory reporting.

●Coordinated system testing and User Acceptance Testing (UAT) by preparing test scenarios, validating outputs, and supporting business sign-off.

●Maintained requirements traceability, issue tracking, and project documentation using JIRA, Confluence, and SharePoint.

Environment: Agile, Rally, Rational Rose, Windows 7, SharePoint 13, Microsoft SQL, PL/SQL, HP Quality Center, UML, MS Office Suite (Word, Excel, Power Point, Access, Visio), JIRA, Confluence

Lewis University Aug 2023 - May 2025

Business Research Analyst

●Conducted quantitative financial research analyzing portfolio manager performance using machine learning techniques.

●Applied k-Means clustering and Latent Dirichlet Allocation (LDA) to group portfolio managers based on investment behavior and performance patterns.

●Developed Python scripts for financial data preprocessing, model development, and statistical evaluation.

●Performed data analysis and visualization to compare machine learning results with traditional active outperformance metrics.

●Analyzed financial datasets to identify patterns in investment strategies and portfolio performance.

●Collaborated with faculty researchers to document methodology, validate results, and publish research findings.

●Contributed to the research paper “Portfolio Manager Ratings: k-Means and LDA versus Active Outperformance” published by ATINER.

Master of Science in Business Analytics – Lewis University, Romeoville, IL May 2025

Genpact / Morgan Stanley Sep 2022 - Jun 2023

Business Analyst

Responsibilities:

●Gathered and documented business requirements by analyzing stakeholder needs for electronic trading and fixed income platforms.

●Analyzed and documented BRDs and FRDs and validated system requirements across front-office and middle-office workflows.

●Worked extensively with capital markets instruments including fixed income products, derivatives, swaps, and regulatory reporting data.

●Performed data analysis and data validation using SQL to support trading and reporting initiatives.

●Supported Agile delivery workflows and assisted teams with JIRA configuration and backlog management.

●Supported regulatory reporting deliverables across multiple releases and project phases.

●Assisted with data mapping, ETL documentation, and integration testing activities.

●Managed change requests and supported scope control through formal change management processes.

●Coordinated User Acceptance Testing (UAT) by supporting defect tracking, validation, and business sign-off.

●Provided technical and procedural support during deployment and post-implementation phases.

Environment: Agile Scrum, Microsoft, Sharepoint13, World-Check, LexisNexis, Rally, Jira, Informatica, Rational Suite, MS Visio, UML.

Contact this candidate