Business Analyst Project Manager

AISHWARYA

IT BUSINESS ANALYST BUSINESS SYSTEM ANALYST TECHNICAL PROJECT MANAGER

**.*********@*****.*** 213-****-***

PROFESSIONAL SYNOPSIS:

• 8+ years of experience as a IT Business Analyst & Technical Project Manager Specialized in Requirement elicitation, Project Planning, Project Roadmap, stakeholder management, and risk mitigation, Project delivery and developing functional workflows and Business process models

• Operated across diverse domains, including Technology and Software, Tax/Finance, Education, Insurance, Government Project, Manufacturing, Supply Chain and Logistics

• Associated with Data Conversions/Migration, Composed Project, Status Reports and Release reports.

• Developed a product backlog, prioritized initiatives based on business impact, and partnered with development teams to deliver high-quality solutions

• Strong background in performing detailed technical analysis of customer-facing web applications developed with modern technologies such as Angular, Java/JavaScript, CSS, HTML, Spring/Spring Boot, and web services like RESTful API and SOAP.

• Supported data integration and ETL processes to ensure seamless data flow between systems.

• Maintained data models, dashboards, and reports using Azure Devops, Snowflake

• Observed and Aggregated moderate project testing tasks from requirements gathering to deployment, including assigning work, setting priorities, and Bug triaging issues

• Handled Scrum artifacts (Product Backlog, Spring Backlog, Sprint Task List, Sprint Burn Down Chart and Release Burn Down Chart)

• Elicited and documented precise system requirements, translating business needs into technical specifications, mapping system interdependencies, and creating detailed technical design documents

• Designed and customized, SharePoint solutions to meet business process and workflow needs

• Provided technology solution development and integration across the SDLC including requirements, functional specs, design custom development, integration, STLC (Software Testing Life Cycle) and deployment

• Fostered 85% of end-to-end testing of systems to ensure successful integration, identified enhancements, and helped systems understand how to integrate with data hubs

• Monitored and logged tools like Datadog, Splunk, or similar platforms to analyze application logs in both test and production environments.

• Executed User Training sessions, facilitate UAT sessions, creation of business and test scenarios and test scripts for System Integration Testing (SIT), coordinating GO-LIVE activities and and experience in prototyping and User Interface mock-ups

• Liasoned with Cross-Functional teams to enhance system reliability, scalability, security workflows, and implementation roadmaps

• Assisted in the development and implementation of data governance policies and procedures

• Proficient in process development, use case creation, GAP analysis, FIT-GAP analysis, and business process standardization, ensuring optimized workflows and alignment with organizational objectives EDUCATION:

• Master’s in Information Systems, University of Utah, Salt Lake City, USA

• Master’s in Business Administration, Indiana University of Pennsylvania, USA

• Bachelor in Commerce (Emphasis in Statistics, Banking and Finance), Mumbai University TECHNICAL SKILLS:

Database: SQL, SQL SSMS, MySQL, Snowflake, Cloud, SAP, Spectrum, ERP Software Practices: Waterfall, Agile Software Development, Scrum, Kanban Data Visualization Tool: Power BI, Tableau

Operating System : MacOS, Windows, Linux

Development Tools: Microsoft 365 Suite including MS Visio, Visual Studio, JIRA, Confluence, Share Point, Azure Devops, Lucid charts, Domo, Service Now, Smartsheet, GitHub, TFS Language: Python, Java

CERTIFICATIONS:

• Certified Scrum Product Owner (CSPO)

• Project Management Professional (PMP)

• PMI Risk Management

• Career Essential in Business Analyst and Data Analyst(Microsoft)

• Intermediate SQL

• Equity & Derivate Capital Market- Bloomberg

• Lean Six Sigma Green Belt

• ServiceNow IT Leadership

PROFESSIONAL EXPERIENCE:

Client: LAUSD- LOS ANGELES UNIFIED SCHOOL DISTRICT Los Angeles, California Role: Business Analyst August 2023 - Present

Project: Whole Child 2 – Enhancement of Cloud Based Comprehensive Student Information System (PowerSchool) Responsibilities:

• Performed data validation and ensured data accuracy and integrity across all platforms

• Tested, and Noted processes, SQL queries, and stored procedures

• Provided ad-hoc analysis and reporting as needed to support business objectives

• Imported data from excel/csv files into SQL Server for data analysis

• Exported SQL Server datasets to excel/csv per customer requests for decision making

• Extracted data from Snowflake, including various databases like SQL SSMS, Cloud and Structured data

• Applied A/B testing and Agile Scrum practices to refine workflows, enhance user experiences, and support project progress

• Assisted Product Owners in Crafting user stories and EPICS

• Tracked change success metrics, KPIs, and feedback loops to measure impact to drive continuous improvement.

• Created knowledge management resources and standard operating procedures (SOPs) to support continuous learning and process improvement

• Utilized data-driven insights to refine change management plans and improve adoption rates.

• Designed, developed, and delivered training materials, including user guides, job aids, e-learning modules, and live training sessions.

• Distributed workload, budgeting, prioritization and interface needs using tools like Azure, DevOps, Jira

• Researched and evaluated new integration technologies, tools, and best practices to improve the integration data architecture and integration data capabilities

• Conducted Data interrogation, exploratory data analysis, profiling, and reconciliation

• Documented SharePoint-specific business requirements in BRD format for developers

• Automated notifications and document versioning using SharePoint capabilities

• Updated Manual or Automated test scripts, utilities, simulators, data sets and other programmatic test tools required to execute test plans

• Gathered business requirements through interviews, surveys, and observing from account managers and product management teams and UI (User Interface) of the existing Web Application

• Facilitated release planning sessions with Product Owner, consolidated 30+ user stories to frame MVP and MRF, streamlined Product and Sprint Backlog, improving release cycle efficiency

• Implemented data-driven solutions to optimize operational efficiency and drive business growth

• Synthesized and Assembled data requirements for items to new data demands, new regulatory consumption, attribute mapping, defining aggregation rules

• Proposed thorough analysis of the 'As is' and 'To be' system documents, delivering comprehensive insights on existing functionalities v/s enhancements that influenced design strategies for new software releases

• Managed the integration data architecture roadmap and data architecture projects

• Translated complex business and performance insights into compelling, executive-ready narratives, using data visualization tools like PowerBI

• Orchestrated the translation of business needs into functional specifications through strategic techniques like use case analysis, storyboarding, process flow, led Requirement Gathering sessions with user groups, analyzed workflows, optimized UI screen dynamics

Environment: Cloud, AWS, Scrum, Agile, SQL SSMS, SQL Server 2016, Data Mapping, JIRA, Confluence, SharePoint, Microsoft Dynamics 365, Azure Devops, Snowflake, Kanban, SharePoint, Power BI, GITHUB, TFS, Smartsheet Client: Neha Nitin Gujare Taxation and Allied Services MUMBAI, INDIA Role: Lead Business Analyst/ Associate Project Manager Mar 2020 – Jul 2022 Project: Implementation of ERP System- Spectrum for Audit/Taxation Responsibilities:

• Identified project issues and risks, and creates a risk mitigation plan for small- to medium-sized projects.

• Led end-to-end change management initiatives, including organizational readiness assessments, impact analysis, and stakeholder engagement.

• Elevated project plans for small- to medium-sized projects which include schedule, resource allocation, forecasting, stakeholder identification, scope, and meet deadlines

• Designed and implemented change strategies to drive adoption, minimize resistance, and ensure sustainable transformation.

• Refined Agile Sprint User Stories and Tasks for Developer/QA resources

• Executed communication plans to align leadership, stakeholders, and end-users with change initiatives.

• Spearheaded Agile Project Planning and Sprint planning, Release Planning, Daily Standups, Sprint Review and Sprint Retrospectives.

• Organized project team, and managed the work of the project team by establishing schedules and task assignments, and tracking tasks of team members

• Familiar with data analysis techniques such as regression, trend lines, forecasting, data modeling, and clustering (Tableau, Google Analytics)

• Established project goals and sequenced deliverables with input from project stakeholders to ensure alignment with business objectives and successful project outcomes

• Initiated workshops, streamlined project timelines and improved team collaboration, resulting in 20% faster project delivery and 15% increase in productivity

• Ensured system designs meet security, compliance, data governance and performance standard

• Collected and Organized the test script library

• Lead and managed data migration and system integration projects from inception to completion

• Executed project plans, scope, schedule, budget, resource management, Solution design and deliverables

• Standardized templates and structured the documentation process, ensuring consistency and clarity

• Monitored and troubleshooted the integration monitoring systems performance, availability, and reliability.

• Collaborated with stakeholders to understand business needs, perform data validation, and conduct rigorous application testing to enhance performance and user experience

• Engineered intricate sequence diagrams, physical data models, ER Diagram, BPMN, and optimized back- end processes, allowing the system to support 80% more concurrent users seamlessly Environment: Spectrum, SAP, ERP, Power BI, Tableau, Google Analytics, Agile, Azure Devops, JIRA, SharePoint, SQL, Quick Notes, Microsoft Outlook, Microsft Excel, Rally, Smartsheet, Python Client: Vimal Intertrade PVT LTD MUMBAI,INDIA

Role: Technical Business Analyst Aug 2018 – Mar 2020 Project: Implementation of ERP System- Spectrum

Responsibilities:

• Planned and updated Software Development Life Cycle (SDLC) documentation, such as a Functional Requirements Document (FRD), Business Requirements Document (BRD), Technical Requirement Document (TRD) and Implemented Projects with various workflows as well as activities

• Co-ordinated Joint Application Development sessions (JAD) and worked closely with Subject Matter Experts, gathered detailed functionality aspects of business Logic and updated the information to the requirements documents

• Trained new team members in Scrum and assisting teams in creating as well as owning their working agreements with a clear understanding of what is considered the Definition of Done in a spring

• Assess product performance against KPIs Collecting data, tracking user actions, analyzing it uncovering insights through qualitative and quantitative metrics and drive continuous improvement

• Ensured the correct use of scrum process, track, removed impediments which blocks for the development

• Headed QA by managing the Testing Team across projects including Test Strategy, Test Plan, Test scenarios and Scripts and part of project management team

• Aligned change management strategies with business objectives and transformation goals

• Advanced Requirement Traceability Matrix (RTM) to map test cases req. with assistance from QA team

• Participated in all scrum ceremonies for a cross-functional team of 10+ members, utilizing JIRA and SharePoint as per document requirements, resulting in a 20% reduction in development cycle time

• Collaborated with cross-functional team, Stakeholders, Development team to gather datasets, business requirement and resolve the issues and and define acceptance criteria, ensuring smooth E2E/UAT processes and timely releases

• Utilized Agile methodologies to drive project delivery while ensuring adherence to UX/UI best practices and optimizing web performance

• Developed process maps and documented using tools like Visio and Lucidchart

• Translated elicited information into comprehensive business and functional requirements, including use cases, user stories, and software specifications

• Managed the orchestration and execution of user acceptance testing, fostering collaboration among cross- functional teams to validate system functionalities and ensure alignment with business requirements

• Adept at created and transformed business requirements into functional requirements and designing business models using UML diagrams - Context, Use Case, Sequence, Activity diagrams, MS Visio Environment: ServiceNow, SQL, MS Visio, JIRA, Agile, Scrum, UAT, LucidChart, Azure Devops, Power BI, TFS, SharePoint, Smartsheet, Snowflake

Client: Pidilite Industries MUMBAI,INDIA

Role: Business System Analyst for Commercial Finance Apr 2016- July 2018 Project: Upgrading Business Credit Risk System - SAP Responsibilities:

• Managed credit model, evaluated risk rate and monitor financial institutions and various companies

• Worked closely with cross functional IT and Business teams and finalizing components needed involving Service Contracts, Pricing, Inventory, Reporting, Accounts Receivables

• Administered the project with a team of 15 people to ensure a seamless user experience including the delivery for customizations, integrations SAP, Conflurnce and reports built on an integrated platform

• Managed Accounts Payable, Expenses, General Ledger, Project Costing, Asset Management, Cash Management, Lease Administration, AR (Grants), Billing (Grants), Contracts (Grants), Grants Management

• Calculated Impact analysis on data points, code structure & Formulate proposals for new systems, procedures & processes, Credit Grants, Deposits, Management Modules Environment: ServiceNow, SQL, MS Visio, JIRA, Confluence, Agile, Scrum, UAT, LucidChart, Azure Devops, Tableau

Contact this candidate