Home

Mrudula Sundru - Business Analyst

[email protected]

Location: San Jose, California, USA

Relocation: yes

Visa: H1B

MRUDULA SUNDRU +1 (217) 717-8766 | [email protected] | San Jose, CA Professional Summary 9+ years of professional experience as Business Systems/ Data Analyst in Business Process Analysis with e-commerce, networking and medical insurance background. Business Requirements Gathering, Database Design, Data Analysis and Data Mapping. Complete understanding of the Software Development Life Cycle (SDLC) and extensive working experience in various Software Development Methodologies like SDLC, AGILE, SCRUM, and Waterfall. Performed in-depth Gap Analysis to analyze/compare the As-Is and To-Be compatibility of existing system infrastructure with the new business requirements. Successful in translating Business Requirements and User expectations into detailed specifications employing Unified Modeling Language (UML) using Rational Rose & MS Visio. Expertise in using Microsoft, JIRA, and Rational tools for creating Use cases and Defect Monitoring. Proficient in Technical and Business Writing, Business Process Flow, Process Diagram, and Testing various applications. Created Activity Diagrams, Sequence Diagrams, Process Flows, Work Flows, Class Diagrams Experienced in conducting Requirement Analysis, Use Case Design, Designing Test Plans based on the logical models on multiple projects simultaneously. Experience in preparing and documenting the User Acceptance test (UAT) plan and obtaining the necessary sign offs from the concerned business units. Extensive exposure to End-to-End testing, System testing, and User Acceptance testing (UAT) Expertise and complete understanding of QA Life Cycle, QRP Process which includes Designing, Developing, Execution,and Documentation of the Test Cases, Automated Test Scripts, and Test Plans. Perform QA, assist the team with test case scenarios, strategy on existing software to analyze trends and avoid failure points. Documented operational, process and workflows using presentations, video recordings for training purposes to coach existing teams and new resources. Skillset and Tools Project Methodologies RUP, Waterfall, Agile (SCRUM) Business Modeling Tools MS Visio, Rational Rose, Miro Requirement Management Tools Rational Requisite Pro, Enterprise Architect, confluence Quality Management Jira, Buganizer, Atlation Databases Oracle (11g/12C,10g), SQL Server, MS Access, SQL Tools MS PROJECT, SQL, SharePoint, MS Office, Teradata Data Warehousing Data Marts, OLTP, OLAP, Oracle, Query/Reporting, Multidimensional Analysis Operating System Windows, Linux, Unix, Mac, Solaris. Documents & Processes SRS, Use Cases, UML diagrams, FRS, UAT, Test plans & cases, Business Process Modeling, Project Planning & tracking Education : Professional MBA in Project management - Campbellsville University Oct 2021 - Present Masters in Computer Science - Northern Illinois University Aug 2018 Work Experience Client : Google Role : Business Systems Analyst June 2023 - Present Determine the project scope, gather requirements from the clients, hold workshops with key stakeholders to determine the process flow of the project to acquire the desired outcome.. Designed a Roadmap and led the project to manage end-to-end UAT for assigning, executing and monitoring test cases in JIRA. Functioned as a single POC for managing business requirements by creating user stories, story writing, acceptance criteria, analysis, grooming, brainstorming and processflows. Document and generate reports by using Business Intelligence tools such as Google Plx(similar to Tableau). Analyze and communicate the insights to stakeholders to make data-driven decisions. Handle Change Requests and develop scripts, test cases to validate the updates on the data. Conduct scrum ceremonies for task assignment and dependency management. Responsible for demand management, creation of functional specification documents and other living system documents for the respective changes taking place within the interfaces. Hands on experience in creating Source to Target Mapping (STTM) documents and ability to work simultaneously with multiple projects of various complexity and scale. Access, track, manage, and accurately forecast demands for products and services. Proficient in Product Lifecycle Management (PLM) tools and methodologies, with hands-on experience in implementing and managing PLM systems. Skilled in analyzing business processes and requirements, and translating them into effective PLM strategies to optimize product development and lifecycle management. Proven ability to collaborate with cross-functional teams, including engineering, manufacturing, and supply chain, to define and improve PLM workflows and ensure seamless integration across departments. Strong knowledge of industry best practices and standards in PLM, including configuration management, change control, and documentation management, resulting in improved efficiency and regulatory compliance. Experienced in conducting user training and providing ongoing support to ensure successful adoption of PLM solutions, driving user engagement and maximizing return on investment. Performed in-depth Gap Analysis to analyze/compare the As-Is and To-Be compatibility of existing system infrastructure with the new business requirements. Develop a change management manual for the process changes and oversee the upgrades in the system. Created training guide, user guide and operations guide to train new resources and the existing teams. Perform analysis on the data KPIs like volume, NPRUs, SLA monitoring for open bugs and SLA adherence percentage. Provide on time delivery percentages of bugs based on TFR, TAT and TRT, Bugs quality adherence percentage based on score based system that measures bug quality on a weekly (WBR), monthly (MBR) and quarterly (QBR). Ensured the successful launch of multiple partners through technical, design and policy support using Salesforce, Buganizer and Hangouts. Client : Charter Communications (Spectrum) Role : Business Intelligence Analyst III January 2023 - June 2023 Design and build MicroStrategy reports, dossiers for Network Performance and Events features that support supply chain, NetOps and Customer Operations to track the network health. Collaborate across the BI organization to understand business requirements and deliver accurate, audience-specific metrics and dashboards that provide business insights and drive decision-making. Develop SQL queries utilizing TeraData to extract, clean, analyze and confirm the accuracy of the compliance program database. Leverage datalabs on Teradata to import tables from smartsheets or snowflake schema from BI Teams. Gather, define the requirements from stakeholders, perform analysis on the source data, articulate to the architect and assist in designing the architecture for the project. Perform validation on the tables in snowflake schema to identify outliers and anomalies during the development, testing phase. Oversee the migration in various layers such as XDW, XBI, _Q, UAT and Prod. Create Source to targets for both data procurement from source to XBI tables and S2T, wireframe for Microstrategy reporting. Generate mockups for the architecture review and product presentation during handoff. Collaborating with Project Manager to define a roadmap for the upcoming quarter/ year and support retrospective, planning sessions with the teams. Collaborating with cross functional teams throughout the Product lifecycle to ensure the requirements are addressed. Oversee the process through the development, testing, deployment and maintenance phases. Assist the scrum master in writing epics, stories, problem statements with acceptance criteria based on the functionality, sprint deadlines and level of efforts for both development and testing teams. Client : Google X, The Moonshot Factory Role : Business Systems Analyst (SME) November 2020 - December 2022 Provided business intelligence in-put to build, maintain design plans and technical design documents for developing applications according to business requirements using Agile methodology. Gathering requirements from Clients, Subject matter experts and stakeholders, write concise documentation identifying the opportunities, elicitation and translating functional specifications into data, technical and business requirements. Created and managed new workflows with engineers towards supporting the customer deployments based on Agile workflow and collaborated with cross functional stakeholders to ensure the new process aligns with the existing business software implementation and technology. Define and oversee the QRP process flow. Integrate the information and data available from present and the business work case scenarios from the past to establish defined documents for various SDLC procedures, test cases & results, task management, processes and workflows for modified business systems. Collaborated with Application, UI developers while developing an user tool for providing defined data updates. Provided KPI requirements & enhanced features that reduces the manual uptime. Identified new processes or alternatives to resolve problems and enhance operations by 13%. Created and maintained documentation on the operations, applications, process and workflow, developed user guide, process change management manual (process, data & systems change), operational process guide for playbook resource. Recorded videos and presentations for training purposes and coaching existing teams as well as new hires. Hold sessions with clients and stakeholders for various tasks such as signoff, trends analysis etc. Work along with Project Manager to track the team performance, capacity and analyze the demand to resource ratio to assist with quarterly planning and review. Worked on confluence for Creating, managing and organizing content by building and managing page hierarchy using advanced content formatting and content security. Also performed tracking versions and promoting standards. Developed Macros and connectors to other enterprise systems such as Jira, hip chat, outlook etc. Used Jira extensively to create projects and employee software development frameworks. Created custom workflows and reports. Issue operations such as linking and cloning, creation of tasks and subtasks, time and bug tracking. Worked on plugins such as Jira client, importer plugin, charting plugin etc Hold scheduled meetings, work as a scrum master and a liaison with clients to provide consolidated status and plan, coordinate ad hoc sessions when required. Schedule team sessions to regulate project communication with cross functional team members, assign Actionable Items based on their bandwidth, oversee and track implemented changes according to the timeline. Gathering and analyzing the past data to generate various enhanced reports for data availability and issue categorization using Google plx (Similar to Tableau), SQL to help the team categorize issues and analyze the trends, also used to reduce failure points. Use complex SQL queries to perform data validation, data mapping, data modifications and consolidation on both inbound and outbound data to pull up reports for Adhoc tasks and make large data to readable format. Regulate and resolve the bugs raised on Buganizer (Similar to JIRA) related to the interruption in software & hardware. Assign priority based on the identified risk, plan the process flow and escalate the issue. Collaborated with the end users, application engineering team for root cause analysis and to perform level 1 & level 2 troubleshooting for customer issues as well as bug triaging. Client : Google Role : Sr. Salesforce Business Analyst Feb 2020 - Nov 2020 Salesforce Sales, Service Cloud, Salesforce Communities, CLM implementation, business analysis, testing, configuration and support. Worked on applications like rally to assign the user stories to developers and tracking Responsible for Salesforce Sales, Service cloud full life cycle implementation and support of client's core business processes and the associated data & analytics business. Worked on the core enterprise service cloud salesforce projects spanning across multiple salesforce instances within legal risk bus & have also administered the salesforce environment. Implemented Salesforce Development Cycle covering Sales Cloud, Service Cloud, Call Center, Chatter & App-exchange applications. Worked on Salesforce community cloud platform to gather the ongoing business Made new feature enhancements on Service cloud console view and developed some Visual force components. Agile methodologies (SCRUM) was implemented that includes daily scrums with team and developed complex workflows and approval processes for automating business logic. Worked on Agile and Scrum Methodology for Salesforce custom app implementation. Proficiency in delivering on those requirements using Agile or waterfall methodology in multi - national, multi-currency enterprise environment Continuously working with business owners to gather the business requirements and creating user stories Worked with developers and architects to assign user stories to sprints and to developers Led end-to-end management of Pardot campaigns, including strategy development, segmentation, email template design, A/B testing, and performance tracking to enhance lead nurturing and drive engagement. Collaborated with various stakeholders, including marketing teams, sales teams, and IT professionals, to gather requirements, provide training and support, and ensure seamless integration between Salesforce and Pardot for effective marketing automation. Worked with offshore team as well as local team in everyday basis. Client : Google Role : Data Analyst/Technical Specialist - Accelerated Mobile Pages Feb 2019 - Jan 2020 Optimized data collection procedures and generated reports on a monthly and quarterly basis. Maintained AMP Dashboards and the workflow weekly to ensure working of all dashboard modules. Gathering details from Partners and converting queries into technical information. Analyzed the issue, escalated bugs to engineers and collaborated with various teams to provide data sets for content review study on AMP Pages. Designed, developed and implemented large and complex database systems comprising multiple tables with a user-friendly interface for others to leverage, based on the end users requirements using Google Scripts. Strong Understanding on stored procedures, functions, Triggers, Cursors and Indexes as well. Utilized SQL to extract, transform and load (ETL) data from multiple sources. Extensively used Joins and Subqueries to simplify complex queries involving multiple tables. Ad-hoc analysis and data modeling to understand and predict behavior trends, in order to optimize growth and engagement across publishers and partners. Design, conceive and develop modules for new features through GitHub requests and to extend AMP product offerings, categorizing, monitoring and responding to the queries on StackOverflow and Slack. Troubleshoot technical use cases, bugs and build/enhance new AMP framework modules. Coordinate with the QA team with test case scenarios, provide user feedback, feature backlog list for testing and provide QASA evaluation. Improve product feature offerings by providing partner feedback to internal cross-functional teams including Product Management, Business Development and Engineering. Company : Tufts Health Plan Role : Associate Salesforce Business Analyst Dec 2016 - Feb 2019 Extensive experience working with small and medium-sized businesses (SMBs), understanding their unique challenges, and developing tailored solutions to enhance operational efficiency and drive growth. Proficient in conducting comprehensive business analyses for SMBs, including process mapping, gap analysis, and requirements gathering, to identify areas of improvement and recommend actionable strategies. Skilled in leveraging technology solutions specifically designed for SMBs, such as cloud-based software, customer relationship management (CRM) tools, and project management platforms, to optimize business processes and streamline operations. Proven ability to collaborate with SMB stakeholders, including owners, executives, and employees, to align business goals, define key performance indicators (KPIs), and implement data-driven decision-making frameworks. Strong understanding of SMB market trends, competitive landscape, and industry regulations, enabling the formulation of strategic recommendations that address market challenges and drive sustainable growth. Gathered high level requirements from stakeholders located and developed scope along with the PM of the project for the implementation. Worked closely to understand the product life cycle. Mapped Project operational Process using MS Visio, conducted weekly meetings for deciding and reporting on the Policies and Procedures to be followed. Analyzed and prioritized user and business requirements as system requirements that must be included while developing the product in the Product life cycle. Performed the Risk Assessment, requirement analysis, impact analysis and documented the requirements using Rational Rose. Planned and defined system requirements to Use Case, Use Case Scenario and Use Case Narrative using the UML methodologies. Developed a database on MS Access for the company to keep a track on the expenses for various phases of the project. Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Visio. Scheduled meetings with developers, system analysts and testers to collaborate resource allocation and project completion using MS Project. Overseeing the status of the project and providing Product lifecycle management. Assisted in writing SQL Queries (RDBMS) as a part of Backend Testing. Identified and clearly functional issues and supported IT development staff throughout the design, development, testing, and implementation phases of the software development life cycle. Authored progress and completion reports, which were then submitted to project management on a weekly basis. Trained users team on new processes and operational procedures. Company : Bharat Heavy Electricals Limited Role : Data Analyst Intern Feb 2014 - Feb 2016 Spearhead high priority activity of database maintenance for the IT department of BHEL by achieving communication through complaint monitoring with an application - Information Asset Management System Gathering requirements from clients, SME and stakeholders and translating functional requirements into technical requirements for KPIs. Identify customer needs in terms of understanding capabilities, issues resolution, and develop strategies to meet customer demands, work with the necessary departments to implement the latest technology, and monitor progress. Analyzed Relational Databases using complex SQL queries and worked on managing the missing values as well as handling data for multiple data sources. Created an ER model using Rational Rose and developed, transformed into Relational Database. Developed and maintained complex SQL queries, aggregate functions,left joins, right joins, self joins, unions tables and views using MS SQL Server management studio. Transform data using SQL queries and analyze the data using Tableau and Excel to develop reports and dashboards. Created pivot tables and charts using worksheet data in Excel. Academic Projects Feature Extraction Using Classification for Sensorless Drive Diagnosis Implemented the models and understood the performance based in ROC Curve and F-1 Score. Identifying the features which are important and which can affect the failure (Feature Extraction). Extracting the records corresponding to the top features affecting the final failure cases. Performing analysis on the Extracted data to have a model which can outperform previous models. (Using Python 3, Jupyter notebook) Keywords: quality analyst user interface business intelligence active directory information technology microsoft California