Data Analyst Business

Sagarika Reddy Kankanala

Ypsilanti, MI ***** 734-***-**** *****************@*****.***

Professional Summary

Detail-oriented Business Analyst / Data Analyst with 5+ years of experience in business requirement gathering, data validation, test case execution, and financial data processing. Skilled in SQL, Python, Kafka, JSON, and Excel, with hands-on experience in GuideWire financial event processing and data reconciliation. Adept at collaborating with stakeholders, drafting user stories, and performing system testing to ensure compliance and data integrity. Proficient in JIRA, Agile methodologies, and reporting tools like Tableau and Power BI.

Technical Skills

• Business Analysis & Agile Tools: JIRA, JIRA Align, Scrum, Test Case Design, User Story Writing

• Data Processing & Analysis: SQL, Excel (Pivot Tables, Macros), Kafka, JSON

• Programming & Automation: Python (Pandas, NumPy, Data Validation Scripts)

• Databases & Reporting: MySQL, PostgreSQL, Tableau, Power BI

• Cloud & ETL Pipelines: AWS (S3, Lambda), Azure (Data Factory, Synapse Analytics)

• Testing & Quality Assurance: UAT, System Testing, Test Summary Reports, Functional Testing

Core Skills & Competencies

●Business Analysis & Requirements Gathering

●Test Scenario Development & Functional Testing

●Financial Data Processing & Reconciliation

●SQL, Python, Kafka & JSON for Data Handling

●JIRA, JIRA Align & Agile Methodologies (Scrum, PI Planning)

●GuideWire Financial Event Processing & Data Validation

●Data Transformation & Compliance Reporting

●Advanced Excel (Pivot Tables, Macros) & Dashboarding

●Stakeholder Collaboration & Process Improvement

Professional Experience

Business Data Analyst

Eastern Michigan University, Ypsilanti, MI April 2023 – April 2024

• Analyzed business requirements and translated them into user stories and test scenarios using JIRA.

• Conducted functional testing and data validation for financial event processing in GuideWire.

• Extracted and transformed large datasets using SQL, ensuring data quality and integrity.

• Developed Python scripts to automate test case validation, reducing manual data reconciliation efforts.

• Processed Kafka streams and JSON payloads for data standardization and compliance reporting.

• Participated in daily stand-ups, sprint planning, and PI planning to align development with business objectives.

• Designed Excel-based reports and dashboards, enhancing data-driven decision-making.

Research Assistant (Data Analytics & Testing)

Eastern Michigan University, Ypsilanti, MI August 2022 – April 2023

• Conducted SQL-based data validation, ensuring accuracy in financial and research datasets.

• Automated data extraction and error detection processes using Python, improving efficiency.

• Reviewed and executed test cases, ensuring compliance with business requirements.

• Processed structured and unstructured data from Kafka and JSON payloads, deriving meaningful insights.

Business Analyst

SNK Projects, India March 2018 – June 2022

• Automated data validation workflows with Python and SQL, reducing manual workload by 15%.

• Extracted and transformed financial and marketing data from Excel, JSON, and APIs for reporting.

• Built interactive Tableau dashboards to track business performance and financial trends.

Education

Master of Science in Information Systems

Eastern Michigan University, Ypsilanti, MI April 2024 GPA: 3.6

Bachelor of Technology in Electrical and Electronics Engineering

SR Engineering College, India September 2020 GPA: 4.0

Certifications

●Python Programming Certification (2021)

●IoT and Robotics Certification (2018)

●Programmable Logic Controller (PLC) Certification (2018)

Contact this candidate