Business Analyst Data
Resume:
Shiwali Rai
**************@*****.***
PROFESSIONAL SUMMARY
Business Analyst with over 6 years of overall IT experience in Business Analysis, Data Analytics and Project Coordination with the ability to work independently and manage business expectations with a delivery- focused approach to work.
Proficient in understanding Business Requirements and partnering to prioritize design and deliver a focused business solution.
Results-driven Agile Business Analyst with a proven track record of translating complex business requirements into clear, actionable user stories aligned with organizational goals.
Highly skilled in Agile methodologies, including Scrum and Kanban, facilitating seamless collaboration across cross-functional teams to drive continuous delivery and value.
Experienced in stakeholder engagement, requirement elicitation, and process improvement—ensuring solutions are user-focused, scalable, and strategically aligned.
Proficient in using JIRA, Confluence, and other agile tools to document, track, and communicate project progress with clarity and precision.
Proficient in employing proper elicitation techniques in accordance with project environment such as JAD, Discovery sessions, brainstorming, questionnaire, surveys, and focus group, etc.
Expert in developing and maintaining Agile artifacts like product backlog, user stories, sprint backlog, and burndown chart.
Adept at translating stakeholder needs into actionable user stories with testable acceptance criteria for efficient product delivery cycles.
Strong command of Agile frameworks including Scrum and Kanban, with hands-on experience in sprint planning, retrospectives, and backlog management using JIRA and Confluence.
Experience managing cross-functional collaboration, tracking project progress, and ensuring successful delivery within time and budget constraints.
Skilled at fostering collaborative working relationships within operations and across all levels and departments of the organization to execute project coordination activities and company priorities.
Adept at building interactive dashboards and reports in Power BI, visualizing key business metrics such as sales performance, customer trends, and operational KPIs.
I am skilled in researching for transitioning to new technologies by performing feasibility study, GAP analysis.
TECHNICAL SKILLS
Project Management: JIRA, Agile, Kanban, Confluence, Trello, Asana Collaboration & Documentation: Miro, Notion, MS Office Suite, Google Suite Tools and Technologies: MS Visio, SAP, AWS, QuickSight, SQL, Excel Product Management Tools:
EXPERIENCE
Product Roadmap, Product Backlog Management, Release Management
RightPoint, Chicago, IL Jul 2023 – Mar2025
Business Analyst
Collaborated with internal stakeholders and external vendors to assess performance, negotiate contracts, and ensure alignment with business objectives, contributing to cost savings and process optimization.
Collaborated closely with stakeholders to gather requirements and convert them into detailed user stories with defined acceptance criteria, supporting delivery in both Scrum and Kanban settings.
Participated in all stages of the Agile process—sprint planning, daily stand-ups, reviews, and retrospectives—ensuring clarity, progress, and accountability.
Worked alongside product owners, developers, and QA teams to bridge communication gaps, align expectations, and support smooth sprint execution.
Reviewed and analyzed complex supplier and customer legal agreements to identify key action items and ensure compliance with pricing and membership eligibility across B2B manufacturing/distribution operations.
Managed a portfolio of supplier and customer pricing contracts, ensuring accurate system hierarchy and member access based on bid awards and customer criteria using Oracle and SAP ERP systems.
Collaborated cross-functionally with Strategic Pricing, Legal, and BI teams to implement new/amended agreements, resolve escalated claims, and drive continuous improvements in pricing and membership processes.
Utilized advanced Excel functions and business intelligence tools to analyze pricing and membership trends, identify gaps, and develop actionable solutions to improve data accuracy and contract execution.
Provided training, support, and mentoring to new team members; reviewed credit/debit requests and team reports to validate accuracy and ensure corrective actions were properly implemented.
Identified and executed system/process enhancements to streamline pricing workflows and reduce discrepancies; assigned and managed incoming ticket queues to ensure timely resolution aligned with vendor SLAs.
Created and maintained thorough documentation in JIRA and Confluence, making project information easy to access and understand across the team.
Used JIRA and Confluence to manage user stories, sprint backlogs, documentation, and stakeholder updates.
Contributed to risk management and issue resolution by proactively identifying blockers and working with stakeholders to find timely solutions.
Continuously looked for ways to improve processes and enhance team efficiency, bringing a user-first mindset to every project.
Analyzed and documented business processes, identified key inefficiencies, and implemented solutions that improved operational efficiency by 30%.
Collaborated with cross-functional teams, bridging communication between stakeholders and developers to ensure alignment of project goals and requirements.
Led requirement analysis sessions and documented functional and non-functional requirements, ensuring clear understanding for project teams.
Utilized data analysis tools like SQL, Excel, and Tableau to create insightful reports and dashboards, supporting data driven decision-making for stakeholders.
Developed and maintained optimized Power BI data models by designing star schema and data warehouse concepts, improving report performance and reducing data load times by 35%.
Developed and maintained process flow diagrams, use case documentation, and other artifacts, providing a clear understanding of system functionalities.
Conducted gap analysis to identify areas for improvement, recommending solutions that reduced processing time and increased customer satisfaction.
Used Power Query for data transformation tasks, cleaning, and merging data from multiple sources, ensuring high quality, consistent, and accurate datasets for analysis.
Created complex DAX formulas to calculate business KPIs, sales forecasts, profit margins, and customer lifetime value, enabling better insights into business performance.
Spearheaded the implementation of Agile methodologies across multiple projects, enhancing project adaptability and reducing delivery time by 15%.
Managed and prioritized a backlog of features and requirements in collaboration with product owners and development teams.
Facilitated user acceptance testing (UAT), gathering and addressing feedback to ensure product quality and alignment with business needs.
Integrated Power BI with Azure data services to create scalable, cloud-based solutions for reporting and data analysis, enhancing collaboration and access across teams.
Provided training and documentation for end users on new systems, enhancing user adoption rates and minimizing postimplementation support needs.
Created complex Power BI reports by connecting to various data sources including SQL Server, Excel, and web-based APIs, allowing seamless data integration and analysis across multiple departments.
Transformed raw data into insightful visualizations, applying advanced DAX measures, calculated columns, and custom visualizations to provide actionable business insights.
Improved reporting processes by developing dynamic Power BI reports that auto-refresh based on scheduled data updates, reducing manual effort and improving report accuracy.
Leveraged business intelligence tools to monitor KPIs, track project progress, and identify risks, improving reporting accuracy by 25%.
Supported change management initiatives by coordinating with teams on new technology implementations, ensuring smooth transitions and minimized disruptions.
Engaged in strategic planning with senior leadership, contributing insights that supported long-term business goals and growth.
Rupaayan, Jaipur Mar 2018 – Feb 2022
Business Analyst
Worked in Supply chain Module to gather requirements from the Stakeholder and created the specification document for the Developer in the team.
Supported the sourcing team by analyzing RFP responses from suppliers, focusing on pricing structures, compliance, and delivery terms to aid in vendor evaluation and selection.
Worked with Developers to get the data from SAP tool to AWS cloud DAP (Data Analytics Platform) as per the requirement and validated it with Client.
Helped the team in creation of Supply chain KPIS like Forecast and Accuracy, On time Delivery for the dashboard in Quick sight.
Reviewed supplier proposals and conducted cost breakdown analysis, comparing total landed costs, service levels, and lead times to support procurement decisions.
Created and maintained process flows, BRDs, FDDs, and integration-level data mapping specs, including documentation of supplier management and procurement workflows.
Used Conditional Split, Lookup, and Derived Column transformations to ensure accurate data processing in ETL pipelines
Developed and maintained SSIS packages for data extraction, transformation, and loading, and created SSRS reports to deliver insightful analytics to stakeholders, enhancing decision-making processes.
Implemented parallel processing and batch processing in SSIS to handle large volumes of data more efficiently, significantly improving processing time for large data loads.
Incorporated data validation and cleansing logic within SSIS packages to identify and correct data quality issues during the ETL process, ensuring that only accurate and consistent data was loaded into data stores.
Automated data refreshes and reports using SSIS packages, ensuring that business users always had access to the most up- to-date data with minimal manual effort.
Handled ETL package deployment with parameters and environment settings for consistent production integration.
Used SQL Server Agent to schedule and automate SSIS packages, enabling the timely refresh of data loads and the automated generation of reports in Power BI.
Employed Fuzzy Lookup, Merge, and Union All transformations to enhance data quality and consistency across sources.
Managed and executed reporting and analytical projects from start to finish including project management, data gathering and manipulation, estimation, synthesis and modelling, problem solving, and communication of insights and recommendations.
Analyzed and documented business requirements for transportation and logistics software solutions, collaborating with stakeholders to optimize operational processes in truck, rail, and ocean logistics.
Led Agile projects by working closely with cross-functional teams, utilizing Scrum and Kanban frameworks to deliver high quality software solutions within defined timelines using tools like JIRA and Trello.
Managed and enhanced Transportation Management Systems (TMS), ensuring that business needs were met through continuous software updates, process improvements, and integration with existing logistics operations.
Performed data analysis using tools like Excel, SQL, and Power BI to identify trends, optimize logistics processes, and provide actionable insights for better decision-making in transportation and supply chain management.
Facilitated communication between technical teams and business stakeholders to ensure clear understanding of requirements, prioritized product backlogs, and supported user acceptance testing for software solutions.
EDUCATION & CERTIFICATION
• Masters of Business Administration- Management information System / Concordia University
• Bachelor Of Commerce- From Bhavans Vivekananda College
Contact this candidate