Haritha Bolla

Senior Business Analyst &

• Data Analyst with 8+ years of experience delivering enterprise-scale business analysis, data analysis, system integration, process optimization, and digital transformation initiatives across Banking &

• Financial Services, Healthcare &

• Human Services, Property &

• Casualty Insurance, Retail, and Telecommunications domains. Extensive expertise in requirements elicitation, stakeholder management, BRD, FRD, SRS development, user stories, use cases, RTM, GAP analysis, impact analysis, AS-IS/TO-BE process modeling, data mapping, and functional specifications across end-to-end SDLC and Agile/Scrum environments. Strong technical and analytical background in SQL, Advanced Excel, ETL, data profiling, data validation, reconciliation, source-to-target mapping, data lineage, data warehousing, KPI reporting, Tableau, and Power BI, with experience translating complex datasets into actionable business insights. Proven ability to analyze system integrations, APIs/web services, business rules, interfaces, and cross-system dependencies while bridging communication between business stakeholders and technical delivery teams. Experienced in JAD facilitation, Agile ceremonies, backlog refinement, SIT, UAT, regression testing, defect management, root-cause analysis, change management, and release readiness for complex enterprise applications.

Senior Business Analyst/Data Analyst at Citi Bank (2022-09 – Present)

Led end-to-end business and data analysis for enterprise banking initiatives, partnering with Product Owners, Operations, Risk, Compliance, and Technology teams to translate complex business needs into functional and data-driven solutions.

• Elicited and documented requirements through stakeholder interviews, workshops, and JAD sessions, producing BRDs, FRDs, functional specifications, user stories, use cases, acceptance criteria, and RTMs across Agile and Waterfall projects.
• Performed complex SQL analysis across Oracle and Teradata environments to extract, profile, reconcile, and validate large volumes of customer, account, transaction, loan, and financial data.
• Leveraged Python, SQL, and Advanced Excel for data cleansing, transformation, exploratory analysis, exception identification, and reconciliation, enabling efficient analysis of complex banking datasets.
• Utilized SAS for data analysis, statistical reporting, data validation, and investigation of portfolio, customer, transaction, and risk-related datasets supporting business and regulatory requirements.
• Partnered with Data Engineering and ETL teams to analyze Informatica workflows, source-to-target mappings, transformation rules, dependencies, and data-loading processes across enterprise data warehouse environments.
• Developed and validated detailed source-to-target mapping documents, data dictionaries, business glossaries, data lineage, transformation rules, and field-level specifications for integration and migration initiatives.
• Performed data profiling, data-quality assessments, reconciliation, and root-cause analysis to identify missing, duplicate, inconsistent, and inaccurate records and coordinated remediation with upstream and downstream teams.
• Analyzed high-volume structured and semi-structured datasets within Hadoop and Apache Spark environments, supporting large-scale data processing, analytical requirements, and downstream reporting initiatives.
• Supported cloud-based analytical initiatives involving Snowflake, validating data ingestion, transformation logic, schema mappings, business rules, and reconciliation between source systems and cloud data platforms.
• Designed and enhanced Tableau and Power BI dashboards to visualize KPIs, portfolio trends, transaction activity, operational performance, data-quality exceptions, and risk indicators for management and business stakeholders.
• Conducted GAP analysis, impact assessments, and current-state/future-state analysis for banking workflows, identifying process inefficiencies, data gaps, control weaknesses, and opportunities for automation and operational improvement.
• Supported AML, KYC, Customer Due Diligence, compliance, and regulatory reporting initiatives by analyzing customer and transaction data, defining validation rules, documenting controls, and investigating data exceptions.
• Performed business and data analysis across mortgage servicing, loan origination, CMBS/MBS, borrower information, portfolio management, and prepayment-risk processes, ensuring business rules and analytical outputs aligned with stakeholder requirements.
• Created comprehensive process flows, swimlane diagrams, data-flow diagrams, and current-state/future-state workflow models using MS Visio, providing clear documentation of complex banking processes and system interactions.
• Managed epics, user stories, acceptance criteria, requirement changes, dependencies, and defects through JIRA, while maintaining business requirements, meeting decisions, technical documentation, and project artifacts in Confluence and SharePoint.
• Facilitated sprint planning, backlog refinement, daily stand-ups, requirement walkthroughs, sprint reviews, and retrospectives, collaborating with cross-functional Agile teams to clarify requirements and support timely delivery.
• Supported SIT, UAT, functional, and regression testing by developing business test scenarios, validating backend data through SQL, maintaining requirement traceability, and tracking defects through JIRA and HP ALM/Quality Center.
• Collaborated with Data Architects, Data Engineers, ETL Developers, Developers, QA Engineers, and business SMEs to investigate data issues, perform impact analysis, validate interface requirements, and ensure accurate data movement across integrated banking platforms.
• Delivered analytical insights and executive-ready reporting using SQL, Python, SAS, Advanced Excel, Tableau, and Power BI, while supporting enterprise data solutions involving Oracle, Teradata, Informatica, Hadoop, Spark, and Snowflake to strengthen data quality, operational efficiency, risk management, and informed decision-making.

Senior Business Analyst/Data Analyst at Iowa Department of Health and Human Services (2020-08 – 2022-08)

• Facilitated and translated state program policies and stakeholder needs into comprehensive BRDs, FRDs, SRS documents, General System Designs (GSDs), user stories, use cases, acceptance criteria, business rules, and Requirements Traceability Matrices (RTMs).
• Analyzed complex Medicaid Management Information System (MMIS) workflows covering member eligibility, provider enrollment, claims submission, adjudication, adjustments, denials, payments, and reimbursement processes.
• Performed advanced SQL-based data analysis across healthcare and public-assistance datasets, extracting and validating member, provider, eligibility, claims, payment, and benefit information to support operational and analytical requirements.
• Conducted data profiling, cleansing, reconciliation, and root-cause analysis using SQL and Advanced Excel to identify duplicate, incomplete, inconsistent, and inaccurate records across Medicaid and eligibility systems.
• Partnered with Data Engineers, ETL Developers, Data Architects, and Data Modelers to define and validate source-to-target mappings, transformation logic, data definitions, business rules, and data-loading requirements for the HHS Data Warehouse and downstream reporting solutions.
• Developed and maintained data dictionaries, source-to-target mapping documents, business glossaries, data lineage documentation, interface specifications, and validation rules to improve traceability and consistency of healthcare data.
• Analyzed HIPAA-compliant EDI transactions, including healthcare claims and related electronic exchanges, validating transaction structures, business rules, provider information, and data movement between HHS systems and external trading partners.
• Supported electronic claims-processing activities, analyzing transaction requirements, claim-file validation, testing results, provider submissions, and data-exchange issues across Medicaid-related workflows.
• Evaluated SNAP, TANF, CHIP, Medicaid, and Child Care Assistance eligibility and benefit workflows, identifying processing gaps, data discrepancies, and opportunities to improve case-management and benefit-administration processes.
• Performed GAP analysis, impact analysis, root-cause analysis, and current-state/future-state assessments to identify functional, process, system, and data gaps across eligibility, enrollment, claims, and provider-management operations.
• Created detailed BPM/process flows, swimlane diagrams, data-flow diagrams, system interaction diagrams, and AS-IS/TO-BE models