System Analyst Project Management

SHIVANI B

Email: ****************@*****.***// Phone: +1-480-***-****

PROFESSIONAL SUMMARY:

●Over 6+ years of experience as a Business System Analyst, which includes gathering and analyzing user requirements, writing user stories, preparing Business Requirement Documents (BRD), System Requirement Specifications (SRS), and improving processes.

●Worked on all phases of SDLC processes, with expertise in developing multi-tier, scalable, web-enabled business applications using both Waterfall & Agile (Scrum) methodologies.

●Defined project scope and objectives, while identifying, analyzing, and resolving risks during execution to completion of projects.

●Adept at project management and collaborating across cross-functional teams, delivering exceptional performance across various projects and managing testing.

●Experience in conducting Joint Application Development (JAD) sessions and White Board Sessions with end-users, Subject Matter Experts (SMEs) teams, Architects, design groups, and QA teams for project meetings, walkthroughs, and customer interviews.

●Solid experience in backlog grooming, storyboarding, capacity planning, tracking burn-down charts, and preparing Requirements Traceability Matrix (RTM).

●Documented solutions using Confluence and JIRA, communicating effectively to non-technical business stakeholders.

●Experience in creating AS-IS and TO-BE documentation for conducting Gap Analysis.

●Articulate communicator with excellent interpersonal skills, capable of evaluating alternatives and guiding business decisions.

●Adept at creating detailed user interface mockups and collaborating with cross-functional teams to deliver high-quality systems and solutions.

●Involved in documenting customization requirements, business rules and data migration requirements for the Implementation of Guidewire Claim Center and Policy Center.

●In-depth knowledge of UML to visualize and document artifacts using use case diagrams, class diagrams, sequence diagrams, and collaboration diagrams in MS Visio.

●Expertise in wireframing and mockup design when needed.

●Proficient in leveraging Microsoft Azure Synapse (formerly SQL Data Warehouse) for building scalable and high-performance analytical solutions.

●Extensive experience in implementation, upgrade, and customization of Oracle E-Business Suite Applications, including system study, design, analysis, and support.

●Utilized SAP functional configuration experience in FICO (Master Data Management), MM, PP, MRP, and PM modules.

●Experienced in Guidewire suite implementations, including Policy Center and Claim Center.

●Used MySQL, SQL Assistant, and TOAD to write SQL queries.

●Experienced with integrating and working on multiple systems/platforms like Salesforce, AWS, Informatica, and Jenkins.

●Experience working with offshore and on-site models. Ability to coach, mentor, and train others, with a strong work ethic and goal-oriented mindset.

●Flexible, innovative, and able to thrive in a fast-paced, growth-oriented, and time-critical environment.

TECHNICAL SKILLS:

Operating System

Windows 7, Windows 10, Linux, Windows Server 2013

Business Modeling

Microsoft Visio, Balsamiq, Lucid charts

Documentation

Microsoft Word

Version Tools

Clear Case / Clear Quest, Tortoise SVN, MS Shared Service

Defect Tracking

HP ALM, JIRA 6.4, Azure DevOps

Languages

SQL(PL/SQL), JSON, XML

Databases

Oracle 9i / 10g, MS SQL Server, DB2, SOR

Methodologies

Agile (Scrum), Waterfall

Data Warehouse Tools

Informatica, Power BI, Tableau.

PROFESSIONAL EXPERIENCE:

Ross Dress for Less, NY June 2025 - Present

Business Analyst

Ross Stores is a leading U.S. retailer of apparel and home accessories with multiple departments, where merchandising plays a critical role. The project modernized legacy Excel-based merchandising processes by building an internal cloud platform. The new system allows merchants to create quotes, convert them into buysheets, and seamlessly generate purchase orders (POs). The platform also manages PO submission and approvals, providing visibility, accuracy, and efficiency across the merchandising lifecycle.

Responsibilities:

Partnered with Merchandising teams to gather requirements for digitizing quotes, buysheets, and PO workflows previously handled in Excel.

Conducted JAD sessions, walkthroughs, and validation workshops with Product Owners, SMEs, and business stakeholders.

Captured detailed requirements for Buysheet creation, editing, validation rules, and conversion to PO’s.

Documented dependencies between Buysheet and downstream PO generation, ensuring data integrity.

Finalized requirements and mapping sheets, secured stakeholder approvals with traceability.

Authored user stories with acceptance criteria in JIRA; maintained backlog and refinement cycles.

Created BRDs, RTMs, process flows, wireframes, and UI mockups (Visio/Figma) to visualize Buysheet and PO features.

Defined field-level mapping for Buysheets including category codes, product hierarchies, vendor details, and pricing.

Supported bulk upload/download functionality design for high-volume buysheet management.

Acted as a bridge between Product Owners, Developers, QA, and SMEs, clarifying requirements and business rules.

Collaborated with developers on Buysheet validations (mandatory fields, cost/price alignment, vendor mapping).

Reviewed Swagger APIs and integrations impacting Buysheet PO workflows.

Designed test scenarios for Buysheet lifecycle (creation, edits, conversion to PO, error handling, and approvals).

Reviewed QA test scripts to ensure coverage of validations, workflows, and UI layouts.

Validated Quote and Buysheet in lower environments; logged defects and coordinated fixes.

Conducted feature demos of Quote and Buysheet workflows with SMEs and business stakeholders.

Facilitated feedback sessions and secured validation signoffs.

Created training materials and walkthroughs to aid business adoption.

Maintained comprehensive documentation including Requirement Logs, Mapping Sheets, Test Scenarios, MoMs, and Migration Trackers.

Tools & Technologies: JIRA, Confluence, Excel (legacy), Visio, Figma, Workspace, Swagger, RMS, Bamboo Rose.

Lululemon, Seattle, WA Jul 2023 – May 2025

Business System Analyst

Lululemon athletica is a technical athletic apparel company for different sports, whose business strategy is based on marketing a lifestyle rather than a product and DORA is a product team where all the major reporting is handled in Power BI Env, and the project aimed to develop a comprehensive Power BI reporting system for Lululemon, focusing on key business areas: sales, inventories, products, and distribution lists. The objective was to provide real-time, actionable insights to facilitate informed decision-making, optimize inventory management, and enhance distribution efficiency.

Responsibilities:

●Led the development and implementation of comprehensive reporting systems to monitor key performance indicators, sales trends, and customer insights.

●Managed the lifecycle of reporting projects from conceptualization to deployment, ensuring alignment with business goals and user needs.

●Utilized advanced analytics tools to extract, analyze, and present data, enhancing business decision-making processes.

●Coordinated multiple interactions with critical stakeholders—Business SMEs, Program Managers, and Development leads—to define Business Requirements using Agile.

●Collaborated with cross-functional teams to identify reporting needs and delivered tailored solutions to meet diverse business requirements.

●Collaborated with stakeholders to gather requirements and translate them into user stories for the development team.

●Worked closely with AWS Cloud solutions for data warehousing and analytics, ensuring seamless data integration, synchronization, and reporting processes.

●Wrote and maintained detailed user stories with clear acceptance criteria, ensuring traceability and alignment with business goals.

●Conducted backlog grooming sessions to prioritize and refine user stories, ensuring delivery of high-value features.

●Conducted in-depth analysis of business requirements and translated them into functional specifications for Lambda-based solutions.

●Analyzed and documented the Supply Chain End-to-End As-Is Business Processes, in collaboration with stakeholders based in offshore subsidiaries.

●Monitored and assisted in designing and development of Use Cases, Activity Diagrams, and Sequence Diagrams using UML.

●Created detailed user interface mockups and collaborated with cross-functional teams to design efficient solutions.

●Developed interactive mockups and wireframes to visualize user interfaces and present design concepts to stakeholders.

●Utilized tools such as Balsamiq and Lucid chart to create user interface mockups and storyboards for end-user approval.

●Extensively involved in the modeling and development of Reporting Data Warehousing Systems.

●Assisted in designing and coding ETL graphs that transform & transport data between upstream, Central Data warehouse & downstream systems.

●Data mapping, logical data modeling, created class diagrams and ER diagrams, and used SQL queries to filter data within the Oracle database.

●Created Requirements Traceability Matrix (RTM) to map user stories with test cases and ensure comprehensive coverage.

●Developed test cases and performed unit testing, integration testing, and user acceptance testing (UAT).

●Tools: UAT, AWS, CI/CD, ETL, Oracle EBS, SAP MM, SPP FICO, ServiceNow, Informatica, Power BI, Jira, SQL, PL/SQL, UML, XML, JavaScript, Agile

Zurich North America, Chicago, IL Sep 2021 – Apr 2023

Business System Analyst

Zurich is a leading multi-line insurer that serves its customers in global and local markets providing products and services in more than 210 countries and territories. Claims MLCI (Market Leading Claims Insight) is one of the teams in the Claims Department which mainly focuses on managing the technical aspects of the claims portal which includes creating/modifying implementations according to the business needs and to store the required data into the databases.

Responsibilities:

●Served as a liaison between the Business and IT to provide solutions to their business system needs and between product and development.

●Working as Business Analyst on implementation of Guidewire Claim Center for Property, General Liability and Workers Compensation lines of Business

●Conducted workshops with end-users and SMEs to refine user stories and gather feedback on proposed solutions.

●Conducted interviews, surveys, and workshops to understand user needs and expectations.

●Conducted multiple working sessions during the sprint with the DEV and QA team to design and deliver solutions aligning with Zurich s policies, processes, and regulatory requirements.

●Collaborated with development teams to create and test RESTful APIs, ensuring seamless data exchange and adherence to business requirements.

●Worked closely with product owners and stakeholders to document user stories capturing detailed business requirements.

●Played an integral role in refining user stories during sprint planning and backlog grooming sessions.

●Analyzed and documented complex business workflows and proposed optimizations for efficiency.

●Analyzed and identified issues/inconsistencies in various complex processes by working with resources from cross-functional teams.

●Utilized tools such as ALM (Application Lifecycle Management), JIRA, Rally, VersionOne, etc.

●Designed system flows, wireframes, and use cases to ensure clarity in requirements and processes.

●Created mockups and wireframes using Microsoft Visio to communicate design ideas and validate user needs.

●Developed system flow diagrams and storyboards to represent user journeys and system interactions visually.

●Created and maintained documentation for Tableau dashboards, including user guides, data sources, and processes.

●Created SPIKE’s and facilitated discussions with stakeholders and tech teams.

●Collaborated with stakeholders to gather and document business requirements for data visualization and reporting.

●Supported cross-functional teams in identifying KPIs and defining reporting requirements for CPQ adoption success.

●Designed Informatica ETL jobs for extracting data from heterogeneous source systems, transforming, and finally loading into the Data Marts.

●Created product rules and gathered requirements for the implementation of discounts, rating inputs, and reports for implementing Guidewire Policy Center.

●Created SQL-based reports to analyze and validate claims data for Market Leading Claims Insight (MLCI).

●Enhanced reporting capabilities leveraging AWS components like RDS and Redshift for optimized querying and reporting.

●Ran SQL Queries for the test case scenarios and assisted the Business Users in fetching the data with SQL Queries.

●Created and maintained data models to ensure accurate and efficient data retrieval for Tableau reports.

●Interacted with various user groups for gathering the Requirements for Salesforce CRM implementation.

●Worked with various salesforce.com objects like Accounts, Contacts, Leads, Campaigns, Reports, and Dashboards.

●Parallelly created SQL reports for the Source Database through SSIS for the reports to be analyzed for Data Migration.

●Executed advanced SQL queries for back-end testing, data validation, and ad-hoc reporting to ensure database integrity and compliance.

●Designed and implemented basic SQL queries for reports and data validation.

●As a functional consultant, implemented Guidewire Policy Center through an Agile Scrum development model.

●Documented the business requirements for Policy conversion to Guidewire Policy Center at the time of renewal.

●Created product rules and gathered requirements for the implementation of discounts, rating inputs, and reports for Guidewire Policy Center.

●Collaborated with QA teams to validate that test scenarios aligned with user stories and acceptance criteria.

●Created and executed test plans, scenarios, and scripts to validate MDM processes.

●Performed API testing using tools like Postman to validate the integration of claims portal functionalities with backend systems.

●Assisted in documenting API contracts using Swagger and ensured consistency with stakeholder needs and system integrations.

●Verified API response accuracy and latency to ensure optimal performance for claims data storage and retrieval processes.

●Experienced in User Acceptance Testing (UAT) and documenting the results.

●Tools: Tableau, ALM, AWS, CI/CD, ETL, SharePoint, Informatica, PowerCenter, Power BI, Jira, Salesforce, UAT, API, SQL, PL/SQL, UML, XML, JavaScript, Agile

Synchrony Financial, India Nov 2017– Jul 2021

Business Analyst

The project focused on enhancing data management practices and developing new financial products and features. This involved instituting data lifecycle management strategies, integrating governance frameworks, and democratizing data access for real-time analytics. Additionally, requirements for financial products, such as pricing, account fees, and transaction management, were gathered and seamlessly integrated into ServiceNow to ensure operational efficiency. The project adhered to the Waterfall Model, ensuring structured progress through defined phases like requirement gathering, analysis, design, development, testing, and implementation.

Responsibilities:

●Collaborated with business stakeholders and subject matter experts to gather and document business requirements for pricing, account fees, transaction processes, and financial products.

●Created use case diagrams, process flows, and business process documentation to capture user requirements.

●Assisted in analyzing source systems and data structures to identify data for integration and reporting needs.

●Supported the preparation of business requirement documents (BRDs) and functional requirement specifications (FRS).

●Worked with cross-functional teams to identify gaps in existing processes and proposed solutions to address them.

●Assisted in designing basic ETL workflows for extracting, transforming, and loading data from multiple sources.

●Contributed to documenting data lifecycle management processes, including data acquisition, storage, processing, and archival.

●Supported the creation of metadata documentation to ensure transparency and data lineage traceability.

●Designed simple SQL scripts for querying, testing, and data profiling to identify data discrepancies.

●Worked with ServiceNow developers to configure and customize workflows, ensuring alignment with business requirements.

●Collaborated with QA teams to create UAT plans, write detailed test cases, and execute tests for system functionality.

●Conducted API testing using Postman to validate data flow between systems and troubleshoot integration issues.

●Participated in back-end testing of SQL queries to verify data accuracy and consistency.

●Documented test results, reported defects, and ensured timely resolution of issues.

●Verified compliance with business requirements by cross-checking deliverables against initial specifications.

●Maintained and updated documentation of system configurations, workflows, and data models for ongoing reference.

●Assisted in monitoring performance metrics and data quality reports to identify potential issues.

●Assisted in preparing training materials and user guides to support system adoption and ensure user familiarity.

●Supported data reporting tasks by generating dashboards and visualizations using Power BI and Excel.

●Worked with senior analysts to automate repetitive processes, improving efficiency and reducing manual effort.

●Assisted in creating pivot tables, summaries, and statistical reports to provide actionable insights for decision-making.

●Attended regular team meetings to review progress and provide updates on assigned tasks.

●Tools: Informatica PowerCenter, Python, R, SAS, SQL, Jira, Confluence, UML, PowerPoint, Postman, CI/CD Pipelines, UAT, Tabalue, Excel

Education: Bachelor’s degree in Electrical and Electronics Engineering from CVR College of Engineering, 2018

Contact this candidate