Aparna Yellala

Business Analyst with around 5 years of experience supporting Data Warehouse, Data Integration, Reporting Analytics, Source-to-Target Mapping (STM), SQL Data Profiling, Requirements Elicitation, and Enterprise Data Management initiatives and Agile/Waterfall methodologies. Strong background in translating business requirements into functional requirements, user stories, and data-driven insights, working closely with product owners, developers, and QA teams. Experienced in Agile methodology (including Product Backlog Grooming, Sprint Planning, Sprint Reviews, Daily Scrum) and tools like JIRA and Confluence, as well as Waterfall environments for well-defined projects.

Skilled in conducting Joint Application Development (JAD) sessions, stakeholder interviews, surveys, and workshops for effective requirements gathering, and creating use cases, decision tables, and functional documentation. Hands-on experience in GAP Analysis, AS-IS / TO-BE process analysis, business process modeling, and designing process workflows, wireframes, and prototypes. Strong capabilities in data analysis using SQL (DDL, DML), data mapping, and business process improvement.

Participated in project feasibility analysis, requirement analysis, and converting business requirements into functional specifications (FSD). Proficient in creating BRD (Business Requirement Documents), FSD, UML diagrams, and process flows using tools like MS Visio and Rational Rose. Demonstrates strong analytical skills, problem-solving, decision-making, communication, and stakeholder collaboration abilities.

Business Analyst at YV IT Consulting (2025-06 – Present)

Project: Data Integration, Data Warehouse & Reporting Platform (Azure)

• Delivered 100% traceable Source-to-Target Mapping (STM) documentation by analyzing 500+ source data elements and business definitions from Archer(source), resulting in improved data quality and reporting accuracy across enterprise analytics initiatives.
• Led business and technical requirements elicitation sessions with 10+ stakeholders by conducting workshops, interviews, and requirement reviews, resulting in clearly defined functional and non-functional specifications for data integration projects.
• Optimized enterprise data management processes by documenting data flows from source systems to Enterprise Data Lake (EDL) in Azure platform, resulting in streamlined reporting and analytics consumption across business teams.
• Drove data profiling and analysis activities using SQL and Field Detail Reports (FDRs), resulting in the identification of data anomalies, transformation requirements, and business rules before development.
• Produced detailed BRDs, workflow documentation, and solution specifications by collaborating with business sponsors and technical teams, resulting in improved requirements traceability and stakeholder alignment.
• Coordinated cross-functional delivery across Data Engineering, QA, and Power BI teams by managing priorities and resolving ambiguous requirements, resulting in timely project execution and reduced rework.
• Implement data validation and data reconciliation processes by supporting quality assurance activities, resulting in improved consistency, completeness, and integrity of enterprise reporting data.
• Collaborate with reporting and analytics teams by documenting transformation logic, metadata, and business rules, resulting in enhanced usability of curated datasets for downstream applications.
• Facilitate stakeholder communication between business and technology groups by translating complex technical concepts into business-friendly documentation, resulting in faster decision-making and improved project outcomes.
• Support Data Warehouse and analytics initiatives by documenting source-to-target transformations and reporting requirements, resulting in scalable enterprise reporting solutions.

Business Analyst at Quantum Leap Consulting Pvt. Ltd. (2021-09 – 2025-04)

Project: Online Customer Experience Enhancement

• Achieved a 15% improvement in customer conversion rates by conducting business process analysis, user journey mapping, and stakeholder workshops, resulting in increased online revenue and customer engagement.
• Led requirements gathering and backlog prioritization for 20+ enhancement initiatives by collaborating with Product Owners, Marketing, IT, and Customer Support teams, resulting in successful Agile delivery across multiple releases.
• Improved customer experience metrics by analyzing CTR, bounce rate, and conversion data using Google Analytics, resulting in data-driven recommendations that enhanced platform usability.
• Developed functional requirements, user stories, acceptance criteria, and workflow documentation by facilitating stakeholder interviews and JAD sessions, resulting in improved development efficiency and requirement clarity.
• Optimized business processes through AS-IS and TO-BE analysis by identifying operational gaps and process bottlenecks, resulting in reduced user friction and increased customer satisfaction.
• Facilitated User Acceptance Testing (UAT) and data validation activities by coordinating business users, QA teams, and developers, resulting in successful deployment of high-quality releases.
• Delivered wireframes, process flows, and solution specifications by partnering with UX/UI teams, resulting in improved stakeholder alignment and faster approval cycles.
• Implemented continuous improvement initiatives by analyzing customer feedback and A/B testing results, resulting in measurable increases in engagement and retention KPIs.
• Managed cross-functional stakeholder relationships across business and technical teams by providing regular project updates and requirement clarification, resulting in improved communication and project transparency.
• Supported enterprise application enhancements by documenting business rules, process workflows, and integration requirements, resulting in scalable and customer-centric technology solutions.

Master of Business Administration in MBA – Sri Padmavati Mahila Visvavidyalayam (2019 – 2021)