SISIRAJA PEDDIRAJU
Summary
Senior Business Analyst and Product Manager with 10 years of experience in the IT industry. Expert in Software Implementation with multiple Integration Systems, Analysis, Design, Wireframes and Process Flows, Business and Systems Requirements, User Acceptance Testing and End-User Training. Experienced in working with large scale projects and programs following processes, procedures in Waterfall and Agile/Scrum methodologies. Experienced in Risk Mitigation planning for software development and implementation. Worked cross-functionally with business partners, vendors and multiple teams throughout the organization. Worked with MS Excel (specifically with Pivot Tables, VLOOKUPS, and DAX) as well as Power BI, Azure tools, SQL and PowerPoint.
Overview
12
12
years of professional experience
Work History
Senior Business Analyst
Kroger Co, Inc
Dallas, TX
02.2023 - 05.2024
- Collaborated with the Sourcing Supplier Domain team to facilitate comprehensive discovery and requirement gathering processes for Kroger Primary Contact, ensuring all stakeholder needs were met.
- Managed stakeholder expectations through transparent communication and timely status updates, ensuring alignment between project deliverables and business objectives.
- Created detailed user stories for system enhancements, leading to improved functionality and user satisfaction.
- Played a key role in the development of a detailed Data Dictionary for Composite Service, enhancing the integration of Web APIs.
- Recognized for my technical and analytical skills in data domain, I was pulled into the DESP initiative for the Sourcing Supplier Domain, contributing to strategic project objectives.
- Acted as the primary resource for gathering requirements from multiple consumers for the DESP initiative, as well as for Data Topic Requirements, ensuring all requirements were accurately captured and addressed.
- Conducted comprehensive interview sessions to understand workflows and gather requirements for various consumers for DESP, including RPM, Archon, ServiceNow, Partner Pass, REM, SIRS and VPS, ensuring all stakeholder needs were thoroughly documented and addressed
- Significantly accelerated the delivery of Minimum Viable Product (MVP) requirements for the DESP initiative, streamlining processes and improving project timelines.
- Worked on analysis for Coupa workflow for categorization, understanding the entire process of SH/Coupa integration and SH requirements for Coupa/Kofax Enablement.
Lead Business Analyst/Product Owner
RSM International
Minnesota City, MN
01.2022 - 06.2022
- Upgraded from Dynamic 365 to Power BI and Azure platform
- Managed a team of 4 BAs and supported the project in all phases of implementation
- Defined the project scope and objectives by partnering with the IT Business Leaders
- Responsible for backlog management and work allocation to team members
- Worked with the program manager and team director in gathering technical requirements for multiple teams to meet organizational needs
- Responsible for user story and wireframes creation and testing the deployment thoroughly on Project Management reporting needs
- Worked with the scrum master and scheduled all the scrum meetings
- Responsible for story point allocation and work allocation for the sprint
- Lead the requirement gathering sessions with the Business in understanding the requirements and documentation
- Assisted the team in defining and adhering to the business process to make sure the work gets done
- Accessed the Scrum Maturity of the team and organization and coach the team to higher levels of maturity, at a pace that is sustainable and comfortable for the team and organization
- Developed risk mitigation plan for the project which is in compliance with the organization standards
- Worked with the QA team in performing testing for every deployment (Functional and Data side of testing)
- Created test cases and worked with the QA team on testing needs
- Worked with the developers directly in ensuring the Power BI reports are developed according to the requested requirements and complied with RSM standards.
Lead Business Analyst
Sleep Number
Minnesota City, MN
03.2021 - 12.2021
- Enterprise Analytics and the Business Intelligence team needed evolution and empowering the business partners to make decisions with data by delivering descriptive and diagnostic solutions
- Worked with the Business Analytics teams in meeting their desired solutions
- Partnered with the IT team and business partners to gather system requirements and capture current processes and map To-Be processes
- Assist with the development and execution of a data governance program in collaboration with others to enable strategic and ethical use of data across the enterprise
- Partner with internal teams and key stakeholders to understand and consult around data needs, impacts and data risk management
- Written the Data Quality Rules for QA
- Defined the project scope and identified necessary system enhancements
- Worked on translating the reporting requirements into high-quality technical design, leveraging industry best practices
- Responsible for creating wireframes and presenting them to the Business teams for feedback
- Managed the project backlog, user stories and acceptance criteria
- Lead the QA team on testing sprints and defect management
- Built and operationalized the dashboards and other analyses through their life cycles
- Provided enhancement input to business teams on BI platforms and reporting tools
- Responsible for project design, coding, testing, debugging and documentation
- Worked on building the Key Performance Indicators (KPIs) for the BI team
- Built reporting tools and continuously improved them by working with our business to drive action and decision quality.
Lead Business Analyst
TCF Bank
Minnesota City, MN
03.2020 - 09.2020
- Being in the nascent stages of creating a data centric organization, COE team at TCF set out to transition warehouses to a Hadoop framework
- With experience in change management I worked on setting standard practices that can be used and developed based on need
- This includes treating data far and wide, mapping cross-warehouse elements and developing metrics to track data health
- Reporting liaison pan COE team
- With minimal requirements, understood the objective of the data analysis and wrote rules for the data transformations
- Collaborated with team members and provided directions and processes on the system rules and necessary changes that needed to be done for target systems
- Trained Business teams in Dremio for exclusive reporting and other necessary tasks
- Performed heavy gap analysis between the 30+ source and target systems - LDM to Foundation data mapping for 1000+ elements
- Utilized MS SQL, Ambari Hadoop, Tableau, Dremio for data intelligence and analysis and gave numerous presentations to the business via visualizations
- Collected and analyzed data requirements and helped the team in realizing system needs to merge vs retire
- Worked with the team for data retrieval from SAP BO and maintained the documents in MS Teams and SharePoint
- Analyzed and updated the financial reports for the Business Teams
- Developed an extensive query repository to establish best practices
- Used Dremio for data intelligence and analysis and gave numerous presentations to the business via visualizations
- Worked with HQL, Tableau and Dremio and started mentoring team members for turnaround of tasks
- Created Extract queries and stored procedures for Business for their routine data tasks
- Provided recommendations over business decisions performing EDA, visualization, and statistical analysis
- Created Data Quality rules and queries for Completeness, Validity and Accuracy for 10 portfolios that are sent to Moody’s
- Lead the Dremio support team and designed training modules exclusively for Business
- Interpreted and analyzed data to identify key metrics and transform raw data into meaningful, actionable information.
Project Manager QA/BA
Hennepin County – Government Center
Minnesota City, MN
02.2017 - 10.2019
- Served as Project Lead (QA/BA) for multiple software upgrades, data ingestion processes, and system testing, ensuring project milestones were met on time and within scope.
- Led a team of 9 QAs, 4 BAs, and 3 interns for the Assessment and Taxes (A&T) Project, aimed at replacing outdated legacy systems (PINS and CAMA) and numerous ancillary systems supporting the county’s assessment and property tax processes.
- Managed the project with significant impact on various teams, interfaces, and reporting management systems, ensuring seamless integration and operational efficiency.
- Implemented new software to enhance security layers and reduce manual errors, significantly improving system reliability and data integrity.
- Defined project scope, created detailed project plans, managed resources, and allocated work effectively to ensure timely and successful project delivery.
- Owned and maintained the SharePoint site for QA and BA teams, creating tasks and notifications to streamline team collaboration and communication.
- Oversaw the testing effort for all mobile applications affected by the system changes, ensuring consistent performance and user experience.
- Served as Project Lead (QA/BA) for multiple software upgrades, data ingestions and testing of the systems
- Maintained the Requirement Change Matrix for the entire project, coordinating with 9 business teams to ensure all requirements were tracked and addressed.
- Developed and managed the Risk Management system, identifying organizational risks and triggers to mitigate potential issues.
- Led a diverse project team of system integrators and internal resources for the implementation of PeopleSoft, iNovah, and RecordEase systems.
- Served as a Subject Matter Expert (SME) and owner for text analytics processes, data analysis, strategy roadmap, and reporting, providing valuable insights and guidance.
- Analyzed, estimated, and sized user stories to prioritize story cards, develop software solutions, and write code using the Test-Driven Development (TDD) process.
- Recommended new data sources to enhance data coverage, contributing to more comprehensive data analysis and reporting.
- Extracted, interpreted, and analyzed data to identify key metrics, converting raw data into actionable insights for better decision-making.
- Created detailed report specifications with data mapping for development and QA teams, ensuring clarity and accuracy in report generation.
- Acted as the single point of contact for Hennepin Business, SMEs, and vendors, facilitating effective communication and project coordination.
- Updated the Requirement Traceability Matrix with every Business Analyst Artifact (BAA) document delivered by the vendor, ensuring comprehensive tracking of 46 BAAs, 25+ interfaces, and 30+ reports as of 2019.
- Conducted gap analysis on all test cases with the QA team, implementing corrective measures to ensure thorough and effective testing.
- Developed master and individual test plans for several third-party interfaces (27 interfaces), ensuring thorough testing and integration of external systems.
Lead Business Analyst
Securian Financial Group
Minnesota City, MN
02.2016 - 12.2016
- Project was to determine how the enhancement of the websites Life Benefits and Life Benefits Extra is in alignment with the overall corporate goals
- Captured technical requirements and defined technology solutions using user interviews, document analysis, requirements workshops, surveys, local site visits, business process descriptions, use cases, business analysis, task, and workflow analysis
- Documented requirements at all levels of detail and created/updated process flowcharts using MS VISIO
- Created the conceptual, logical, and physical design of the solution to ensure appropriate technology is acquired and implemented via producing and maintaining requirement specification documentation
- Documented requirements from a business perspective, in the form of user stories and acceptance criteria
- Worked with SME's and Test Lead to ensure that the programmed solution meets the requirements
- Documented and executed manual test cases, specifically related to system and integration testing
- Extensively tested Mobile applications with iOS and Android operating systems to ensure functional stability
- Thorough knowledge of testing in servers and move towards CI/CD processes
- Co-ordinated test plans with Test lead and tested developed products, potentially at the component level
- Ensured that the new application implementation on the website is in line with the requirements
- Responsible for ensuring that the website met the business expectations and thoroughly conducted testing to validate that the website meets the industry standards.
Business Analyst/Manager for Digital Platform
Google Inc
Hyderabad, India
06.2012 - 10.2014
- Managed Online Ad Campaigns for various clients from different parts of the world, performed Gap Analysis for internal teams and worked with developers to build reports
- Accomplishments include Best Performer of the Month (Nov 2012) and Star Performer of the Quarter (Oct, Nov & Dec 2013)
- Collaborated with developers, testers and end users to ensure technical compatibility
- Mapped and documented the attributes between legacy and TO-BE systems
- Produced project feasibility and cost analysis reports using Cognos and SSRS
- Gathered requirements from clients like IKEA, Vogue, GUCCI, Colgate and Hollywood movie ad campaigns
- Documented Policy Procedures and Specifications by facilitating JAD sessions with Google Business
- Worked with Rich Media and YouTube in-stream, in-display and in-search ads campaigns and VAST ad campaigns of various clients and Vendors
- Worked with Standard Expendables, Lightbox, Matchbox, Catalogbox, Mouse Rollovers and Click to expand ad campaigns
- Created training documents and efficiently led the training sessions involving Nooglers and Googlers from other teams on communication and product operations
- Coordinated the technical specifications with the lead developers and responsible from Requirements to Launch the product
- Worked with QA team for documenting the Test cases
- Executed testing for the campaigns at pre and post deployment phase
- Worked with various clients mainly focused from Australia, Japan, Korea and Indonesia
- Coordinated marketing and operations group and led the implementation and Quality check Pixels [Impression tracker, research trackers and remarketing trackers]
- Worked in uploading the 3PAS (Third Party Ad Serving) tags to AdWords interface.
Education
Certification in C, C -
09.2012
Bachelor of Technology in Electronics and Electronics Engineering -
JNTU, College of Engineering, Hyderabad (Kukkatpally) – India
05.2012
Skills
- Project Planning
- Software Implementation Planning
- Data Analysis
- Business process modeling
- Data Mapping
- Product Management
- Business intelligence tools
- Requirements Gathering
- Business process improvement
- Quality Assurance
- Risk Mitigation Planning
- Gap Analysis
- Resource Management
- Use Case Development
- Functional specifications
- User Acceptance Testing
- Software development life cycle
Technical Experience
Azure Dev-Ops, MS Project, SharePoint, JIRA, Excel Pivot Tables and Lookup tables, Power BI, DAX, Dremio, SQL, MS Office Suite, MS Visio, Azure Blob Storage, Azure Synapse, Project charter, Requirement, User Stories, Business Rules, Test Cases, Requirements Traceability Matrix (RTM), Business Process Flows AS-IS (current) and TO-BE (future), Defect logging and Risk Mitigation plan
Timeline
Senior Business Analyst
Kroger Co, Inc
02.2023 - 05.2024
Lead Business Analyst/Product Owner
RSM International
01.2022 - 06.2022
Lead Business Analyst
Sleep Number
03.2021 - 12.2021
Lead Business Analyst
TCF Bank
03.2020 - 09.2020
Project Manager QA/BA
Hennepin County – Government Center
02.2017 - 10.2019
Lead Business Analyst
Securian Financial Group
02.2016 - 12.2016
Business Analyst/Manager for Digital Platform
Google Inc
06.2012 - 10.2014
Certification in C, C -
Bachelor of Technology in Electronics and Electronics Engineering -
JNTU, College of Engineering, Hyderabad (Kukkatpally) – India