Sandeep Lal **************@*****.*** +91-976******* Pune, Maharashtra
Sr. Business Analyst LinkedIn Profile - https://www.linkedin.com/in/sandeep-lal-60155a54/ Education Profile Summary
Master of Business Total relevant 10.9 years of experience as a Business Analyst/Product Owner/Scrum Master. Administration – IT Domain – IT (Web/Mobile app development). Savitribai Phule Pune University
Advance Diploma in Software Experience
Engineering CRUDS System Pvt. Ltd. Consultant Business Analyst Aug 2023 - Present NIIT, Ranchi # Requirement gathering through interview, observation, brainstorm, workshop. Create Proposal document, SOW, Questionnaire, Assess client needs by understanding the Diploma in Software Testing client's requirements, challenges, and objectives. CMC, Pune
# Identify issues: Recognize current and potential issues. Create BRD, FRD, User Story (Jira). Bachelor of Commerce Develop strategies: Create business strategies that meet the client's objectives. Bharati Vidyapeeth, Pune Analyse data: Use analysis to support recommendations. Wireframe/Prototype with the Balsamiq or Figma tool. Involve in creating Test Cases and perform User Acceptance Testing (UAT) and API testing. Communicate: Present recommendations to clients Skills Transfer knowledge: work with team members and stakeholders. Business Analysis Make adjustments: Modify recommended strategies when needed. Azure DevOps
KPI Development & Tracking # Performed the Sprint Ceremonies - Sprint planning, Daily stand up meeting, Sprint Performance Metrics review and Sprint retrospective. Adjust Trade off and view Burndown/Burnup chart. ETL (Extract Transform Load)
Requirement Gathering Auxano Global Services Sr. Business Analyst May 2018 - Jun 2023 Process Improvement # Requirements gathering, analysis, documentation and create wireframe. Analyse & Competitor & Gap Analysis include the Change Requests. Efficient communication for solving the issues. Explore Stakeholder Management and R&D for the proposed solution. Meeting with team to describe solution. Technical Documentation Well conversant with SDLC. Conduct Gap Analysis as and when required. Agile Methodology & Scrum
Waterfall Methodology # Create the UML (Use case and Activity diagram). Provides the KT session, report the bug if Change Management any. Create change request document, CR gets included priority wise. Risk Management
ERP & CRM System iPatientCare Pvt. Ltd. Business Analyst Jul 2017 - Mar 2018 Data Analysis & Migration # Analyse the generated token of providers, communicate with stakeholders. Conduct Structure Query Language Gap Analysis to understand the existing system and get the findings out of it. Perform impact analysis, create the wireframe/prototype as required. Tools # Create the high-level SOW, Business Requirement Document and Use Case Diagram. Project Management – Jira Efficiently communicated, with stakeholder and coordinated with team to solve issues. Create SQL queries to get the output, update and delete to manage database & data mapping. Documentation – MS Office Identify the risks, dependencies and impacts of the newly introduced feature which Google Docs, Confluence must be integrated. Focuses on UI/UX while creating the wireframe. Data Analysis – Power BI
eXant Technologies Pvt. Ltd. Business Analyst Jan 2014 - May 2017 Prototype – MS Visio, Figma # Create proposal document based on the requirement provided by sales team. Miro, Marvel R&D of initial requirements and analyse the document. List out the dependencies of APIs, perform feasibility study. Involve in creating test cases and perform testing. UML Diagram – Draw.io
# Create feature listing and sow document for presales, brainstorming. Create clickable Wireframe Tool – Balsamiq wireframe with balsamiq tool and involve in demo and client communication. Presales activities - Close coordination with sales, marketing to ensure better API Testing – Postman experience across user touchpoints. Involve in client call to discuss the solution. Road Mapping & Prioritization
– Asana Major Projects
Commercial Bank of Qatar Web/Mobile App
# Data collection: Gather data through research and observation
# Data analysis: Identify patterns and trends in data to help find solutions Achievements # Risk management: Identify potential risks and develop strategies to mitigate them Certified Scrum Master # Regulatory compliance: Ensures the solution comply with local and international regulations Nov 2024, Scrum Alliance # Requirement gathering from stakeholder, Product backlog management and created BRD. Certified Scrum Product # Design customization done as per the user experience in the Home page, redundancy of CTA Owner has been removed from the account opening process and its subpages. UAT has been Dec 2024, Scrum Alliance performed retaining end user perspective for the complete portal which includes the functional testing. After that client used to test it in their environment. Agile Software Development
Framework # Data extraction, update, delete and publish. Client - Commercial Bank of Qatar. IDP Mar 2023, IIT Kanpur (Intelligent Data Processing) Artificial Intelligence – Data upload/migration, extraction, monitor, cleaning, testing and get data as downstream application. Certified Business Analyst
Professional (Trained)
– Aug 2023, IIBA Financial Automation Project Web App
# Perform Gap Analysis, understood the legacy system, list out the findings, analysed and Jira Project Management Prioritize the PBI based on business value. In Jira, created roadmap for overview & timeline. Apr 2023, Great Learning Created the epic for big modules and the user story with acceptance criteria under it.
# Created tasks which comes under user stories. Performed the process improvement, Performed the UAT in context of UI/UX and manage Trade-offs based on the requirements. Soft Skills
Analytical Thinking
Problem Solving Farah Fashion Web App
Communication # Gathered requirements from stakeholders/client. Created BRD which includes the high level Collaboration requirement, stakeholder’s needs, project goal, objective in the initial phase. Created FRD for Critical Thinking the granular details of features and functionalities referred by the dev/testing team in the Decision Making planning phase. It includes all the technical details, use case and system behaviour.
# Helps the testing team to create RTM for all the requirements, map with the executed test cases. Create the wireframe for the project and performed sprint ceremonies. Shoppz Web App
# Performed the competitor analysis, listed out the new and advanced features. Include the features and functionalities based on the timeframe and budget for creating BRD. Created the database tables for all actors, normalize table to simplify table structure. Listed out all the entities of tables in the data dictionary. Created the roadmap, divide modules in epic, listed out user stories, do the story mapping with alignment of increment releases.
# Performed UAT, involved in creating the test cases of project. Created interactive Power BI dashboard to track and analyse online sales data. Used complex parameters to drill down in worksheet and customization using filter and slicers. Created connections, join new tables, calculation to manipulate data and enable user driven parameters for visualizations.
# Used customized visualization (Bar chart, Pie/Donut chart, Clustered/Bar chart, Scatter/Line Chart, Area chart, map and slicers).