Scrum Master Project Manager

Mohit S

Sr Business/Data Systems analyst/Scrum Master

Professional Summary:

9+ years of industry experience in multiple roles as Technical project manager, lead business system analyst and Sr business analyst with good domain knowledge in financial services, Investment Banking, Retail Banking and Compliances.

Prior knowledge in financial and investment banking concepts such as Financial Securities- assets (Cash, bonds, treasuries, MBS), Equities (stocks), Fixed Income (bonds), currencies and derivatives (forward futures and swaps contracts). Trade Lifecycle - Front Office, Middle Office & Back Office Activities, SIP (Systematic Investment Plans), Risk Management, Capital Market- ECM & DCM and RIA, IAR, IRA, ETFs & Mutual funds.

Experienced in maintaining/stewardship of Investment data, along with good knowledge in FX forwards(Forwards, spot, NDFs). Have good understanding on market terms and identifiers such as CUSIP, SEDOL, ISIN.

Experience with Order Management Systems (OMS) and Execution Management Systems (EMS)

Exposure to regulations & compliance such as FINRA, Dodd-Frank, ERISA, IRS, FATCA, GAAP, FINMA, Investment Company Act, Securities Exchange Act, SOX, BSA regulation, US patriot Act, Basel II & KYC rules.

Worked in environments such as waterfall methodologies, Waterfall-Scrum hybrid and Agile-scrum

Expertise in Business requirement elicitations, Requirement Gathering, Business Process Flow, Business Process Modelling, Change Management, Release Management, workflow description and prototypes.

Experienced in performing SWOT analysis, Risk analysis, Cost benefit analysis, Feasibility study, Impact assessment, Cause and effect analysis (root cause analysis), Effort estimation and mitigation plan.

Expertise in "As is" process and "To be" process as parts of gap analysis for new functionality requirements, as well as prioritizing them based on actual business needs so as to align them with the project roadmap.

Expert in translating stakeholder requirements into over deliverables such as user stories, workflow diagrams, data flows, use cases, functional specifications, Wireframes and Business Process Model.

Created User stories (INVEST criteria) and acceptance criteria for an iterative and incremental development of an application with the help of Scrum Master & Product Owners.

Experienced in using various prioritization techniques like MoSCoW, KANO, DOT-voting, 100point method, silent writing and estimation techniques like Planning poker, T shirt sizing, bucket system and Relative estimation.

Prepared Use Case specification document comprising actions, pre-conditions, post-conditions, triggers, actual/happy, alternate/unhappy paths, assumptions, constraints and business rules for different scenarios.

Competent in Creating Unified Modelling Language (UML) diagrams (Sequence Diagrams, and Activity Diagrams) and Use case diagrams using Mock-up Screen, Draw.io, Lucid charts and Ms Visio.

Created Conceptual, Logical and experienced in Entity-Relationship diagrams.

Experience in Informatica PowerCenter, IDQ, Oracle as an Informatica & Informatica MDM

Experience in SQL queries for Data Analysis, retrieval, validation, cleaning and modification.

Sound knowledge of Relational Database Management System (RDBMS) & Business Intelligence tools such as Power BI, Tableau, SSRS & QlikView for reporting needs.

Exposure to relationship types using Hierarchy tool to enable Hierarchy Manager in MDM HUB implementation

Good understanding of Big Data concepts such as Spark, Hive, Pig, Sqoop and Hadoop Ecosystem consisting of HDFS, Name Nodes, Data Nodes, HBase, Job Tracker, Task Tracker, MapReduce, Clusters and Nodes.

Proficient in Data warehouse, Data marts, OLAP operations (Slicing & Dicing), and OLTP related concepts of Entity relationships. Competent Dimensional Modelling, Data modelling, Data migration, Data profiling, Data governance, Master data management (MDM), Schemas, Data mart and Operational Data store.

Experienced working with data governance teams to create and maintain documentation related to Metadata of different kinds of data. Proficient creating Data Dictionary and Data Mapping Specification document.

Strong knowledge on Service Oriented Architecture, N-tier Architecture, SOAP & RESTful web services

Performed ETL process for transformation of data sources into one integrated system (Transformation performed include Sorter, Filter, Source Analyzer, Aggregator, Joiner, Lookup, Stored Procedures, Expression and Router).

Experienced in API documentation using Swagger and API testing using Postman to check if the API's are returning the data in JSON, XML format as defined in the API documentation and required by the workflow.

Involved in Bugs Validation, Conflict Resolution & Report Generation using various Defect Tracking Tools.

Proficient in developing and executing Test Plans, SQL queries, performing functional, usability testing and ensuring that the software meets the system requirements.

Collaborated in various types of testing like Functional testing, End to End Testing, Regression Testing, and User Acceptance Testing (UAT), smoke testing, functionality testing, Sandbox testing. Accompanied with expertise in developing Test cases, Test plans and Test case scenarios in manual and automated test environments.

Engaged actively in creating reports such as feature progress reports, performance reports and ad-hoc reports.

SKILLS AND TOOLS:

Categories

List of tools and technology

Finance domain knowledge

Capital Markets, Equities, Fixed Income (Bonds, Convertibles, T-Notes, T-Bonds),

Derivatives (Options, Futures, Forwards), Forex (FX Options, FX Futures, Currency Swaps, Currency Forwards), Commodity, Trade Reconciliation, Mutual Funds, Portfolio Management

Business system analysis/

business analysis

Requirements analysis, Requirements management and communication, Backlog grooming, user stories with appropriate acceptance criteria, wireframes, test cases, feature files, change request design flow, UI and UML.

Project manager/Srum master

Atlassian tools (Jira, confluence, Bitbucket), sprint health check, project dashboard, service management, project & program management.

Methodologies &frameworks

Experience in Traditional Waterfall, custom agile water scrum fall, Agile-Kanban, Scrum and Knowledgeable in Scaled Agile Framework (SAFe) Extreme Programming and Spiral methodologies.

Technologies

HDFS, Informatica Cloud, Informatica PowerCenter, Ms Dynamics CRM, AWS.

Reporting tools

Tableau, Power BI, MS Office Suite (Excel, Word, PowerPoint), Splunk Honeycomb, ServiceNow, MS Excel, Power BI and Tableau

Testing tools

HP Application Lifecycle Management (ALM)/ Quality Center (QC), HP LoadRunner 12.60.

Languages

C/C++, HTML, CSS, SQL, JavaScript, REST, XML, JSON, PHP and Python.

Other tools

MS Word, PowerPoint, MS Visio, drawio and Balsamiq

Certifications: Scrum Master Accredited Certification(SMAC), AWS Certified Cloud Practitioner and Lean Six Sigma Green Belt Certification

Professional Experience:

Subaru of America - Camden, NJ Mar 2024 - Present

Lead Business/Data Systems Analyst

Duties & Responsibilities :

Executed BA/QA duties under general supervision, contributing both independently and as part of larger project teams.

Collaborated with IT and Connected Business stakeholders to develop effective business use cases for Connected Vehicle projects.

Defined project scope, objectives, and timelines in alignment with organizational goals.

Developed QA test cases, test plans, and regression test suites tied to defined requirements.

Ensured comprehensive coverage and alignment of QA test plans with business needs.

Contributed to process improvement initiatives within the BA/QA domain and supported broader IT service quality improvements.

Organized project aspects and ensured adherence to timelines and deliverables.

Developed and maintained project plans, tracking overall progress and milestone achievements.

Reported project risks, mitigations, and outcomes to appropriate management channels, escalating issues as needed.

Strengthened partnerships internally and externally, including with third-party vendors.

Analyzed project progress and adjusted scope or timelines when necessary for optimal results.

Documented and followed up on actions and decisions from meetings.

Developed a deep understanding of business processes and fostered strong working relationships with business users.

Prepared presentation materials for meetings.

Assisted in coordinating project and change estimations.

Ensured adherence to project management frameworks and maintained all necessary documentation.

Followed standard change management procedures.

Participated in validation, compilation, and documentation of Business Requirements.

Contributed to vehicle technology validation testing initiatives.

Environment: Agile Scrum, SharePoint, Miro, JIRA, confluence

Professional Experience:

The Vanguard Group- Malvern, PA June 2019 – Feb 2024

Sr Business Systems Analyst/Scrum Master

Duties & Responsibilities:

Provided senior level IT project management for software, middleware, or hardware deliverables. Managed medium and small projects. Used IT’s project management standards to deliver project on time, within budget, and with agreed upon functionality and quality to internal clients.

Lead regular interactions with the executive sponsor(s) to inform, alert, negotiate and maintain a continuing good relationship and shared vision for the program outcome. Establishes and ensures appropriate governance functions for the program in accordance with enterprise policies. Expanding the Agile, Scrum and other rapid development processes in the development of applications.

Monitored and coordinated dependencies across the projects in the program, and resolved conflicts.

Developed, implemented, and monitored technical project plan. Identified deliverables, milestone, and tasks for the project(s). Interviewed team members for estimates. Updated schedule in IT project repository. Plans and integrates schedule, resources, and deliverables with IT department and vendors.

Communicated with internal clients, team members, management, and IT partners to ensure requirements and priorities are understood. Monitored project progress, and distributed reports to management and client.

Developed strong relationships with client. Met with clients to advise on resources, budget, and deliverables.

Indirectly managed team members. Worked with resources/departments managers to ensure adequate resources are in place. Lead and facilitated project related meetings.

Maintained current knowledge of IT development methodology, architecture, and related standards. Advocated and ensures usage of new standards by team members.

Responded to and resolved development issues in a timely manner. Identified potential solutions, including the cost/benefit of each option. Reviewed complex technical issues with technical lead.

Ensured team complies with IT policies and procedures, especially those for quality and productivity standards that enable the team to meet established client service levels. Ensured team complies with information security policies and procedures, and ensured deliverables met information security requirements.

Created and maintained change records, key controls, SAR (security architecture reviews), product health dashboard.

Lead a team of highly skilled engineers and architect in executing a plan to deliver the valuable new technologies and services.

Utilized a combination of scrum, Kanban, and lean methodologies to help the team manage their work.

Used JIRA extensively to track EPICS, Features, user stories, acceptance criteria, estimation, assignment, progress, impediments, approvals, closure & retrospectives.

Worked with outside vendors in maintaining SLA and project deliverables while reporting IT PMO manager about project status and issues that may impact delivery dates or product quality.

Responsible for Risk management, Release management, scoping major milestones, timelines and overall business objectives. Provided KPI and CPI dashboard reporting (weekly, monthly and ad hoc reports) for several projects.

Collaborated with QA team to ensure end to end testing, quality checks and approvals were in place before the production elevation.

Collaborated with UX designers to conduct user research and analysed findings and acted as a liaison between business stakeholders, UX designers, and developers.

Responsible for managing different process involved with respect to Production elevations and ensure smooth execution. Also, helped in deploying application using AWS CI/CD Pipeline.

Managed communication across departments to schedule and plan bi-weekly company all-hands meeting to ensure the team was bought into projects and the overall company mission.

Worked closely with the product management team to scope customer requested features and determine which feature would provide highest return on investment.

Facilitated scrum ceremonies to effectively capture the changes requested by the stakeholders and communicated with them for the implementation of the changes identified. Ensured scrum methodology best practices are followed.

Proactively planned staffing and made dynamic adjustments to ensure project success.

Overlooked analysis, design and preparation of application/system specifications for information systems solutions which address business needs and methods for testing and installing them. Organized, optimised and sustained ATTD and project artifacts that define Product baseline.

Worked with Order Management Systems (Aladdin, Charles River, Eze) and Execution Management System (Flex Trade) Asset Investment Management Hedge Fund or Financial Services

Involved in maintaining/stewardship of Investment data management for different product lines.

Worked with cross functional teams on several complex issues, providing business data, and requirement analysis to ensure reporting solutions meet the highest data quality standards using agile scrum.

Created user stories and acceptance criteria for an iterative and incremental development of an application with scrum master and product owner.

Monitored PCF to ECS migration of all the applications in the account.

Applied significant leadership and collaboration with the team to develop and execute manual End-to-end test cases, and exploratory tests following the test case standards.

Worked with different sources like Oracle, flat files, XML files, DB2, MS SQL Server.

Created and partnered with dev team in UAT Test Plan, Test Cases and Test Strategy creation based on the functional and non-functional requirements to deliver the Requirements, and performed Functional and Regression Testing.

Provided expert support and oversight to creation and maintenance of a set of automated test (using JUnit, Selenium, Cucumber, Jasmine, Protractor, Appium etc.). Provided thought leadership and significant technical contribution to enterprise automation infrastructure, code repositories, and community forums.

Managed and collaborated with team members on work projects and tasks in Trello

Removed team level impediments and escalated complex organizational impediments which blocked the team’s progress and focused on early resolution of conflicts to keep the team’s velocity and progress on track

Environment: Agile Scrum, SpringSource tool Suite 3.7.0, Visual Studio Code, Postman, Swagger Editor, MS Office tools, Invision, SharePoint, Trello, JIRA, confluence 6.13.9, SplunkCloud, Cognos.

Citizens Bank- Johnston, RI June 2018 – Jun 2019

Sr Business Systems Analyst/QA

Worked on enhancements and developed a system with Comprehensive automation for an interactive user interface, so users can get an automated investment solution to help them pursue their retirement/financial goals. The system delivers diverse data driven recommendations tailored to the needs of individual user by leveraging Big data.

Responsibilities:

Accountable for delivering results for large/complex/cross-functional project initiatives within established timeframes and quality measures.

Directed resources on assigned projects and ensure clarity of project roles and responsibilities.

Translated project goals/objectives into a defined future state and project success measures that can be understood by project stakeholders and delivered by the project team

Communicated effectively at all levels, from executive C-level management down to project resources.

Provided project reporting and status updates through client Steering Committee meetings, leadership meetings, and frequent stand-up meetings.

Ensured the Systems Development Life Cycle (SDLC) processes and guidelines are understood and adhered too

Prepare change proposals, negotiate change orders, initiate change orders (at Project Managers or Project Director’s approval), issue change orders to subcontractors and others (at Project Managers or Project Director’s approval). Aid PM & CM in preparation and tracking of Events.

Defining work strategies, aligning these with resources and desired client outcomes, and overseeing planning and execution of the work.

Ensured technology solutions are managed to support business strategies, often working with senior management

Directed the integration of technical aspects of all related projects/programs.

Conducted analyses and cost/benefit assessments and helping to broker other technology services. Monitored financials to ensure budget compliance.

Worked in Agile- Scrum Framework environment facilitating requirement elaboration and elicitation, stakeholder analysis and other business processes (AS-IS vs TO-BE) related optimization activities.

Conducted Gap analysis and Cost benefit analysis to determine the effects & performance of new features.

Conducted JAD session, Questionnaire, one-on-one interviews to collect requirements with Product Owner about data types required to be displayed on UI and Persona creation (novices, experts or somewhere in middle).

Defined the business rules by working with subject matter experts using 'if' and 'then' statements.

Determined traceability and dependencies between the requirements using Blueprint software.

Created Wireframes, Mock-ups and high-fidelity Prototypes after closely collaborating with the business users.

Used JIRA for drafting user stories, defects and tickets for maintenance and deployment of system being developed.

Facilitated time-boxed Scrum ceremonies such as Sprint Planning Meeting, Daily Standups, Sprint Review Meeting, Sprint Retrospective Meeting and Grooming Sessions.

Involved and assisted the scrum team in loading and transforming large sets of external data (structured, semi structured and unstructured data) from multiple source system such as investment firm researches, articles, stock/bond stories and reviews generated by the investors to Hadoop Data Lake.

Performed SQL Queries to extract data from different sources, verify, validate & modify using various commands.

Worked with the Product Owner during the Sprint Review Meeting for the Potential Shippable Product Increment (PSPI) and help decide which features are DONE and satisfied using the acceptance criteria.

Assisted the QA team to create the readiness document to move the system from testing environment to Pre-production environment and tested the product post deployment in E1, E2 and E3 environments.

Documented best practice implementation plans and continuously measured project outcomes for desired results.

Environment: Agile Scrum, Hadoop Cloudera distribution (CDH) 5.14.0, Hue 4.0, Hive 2.3.1, HDFS, Hbase, Flume, Spark, MS Visio, JIRA 7.2, Tableau 9.1, confluence.

Barclays Bank – Wilmington, DE Oct 2017 - May 2018

Associate Project Manager

The project was implementation of Oracle Mantas AML solutions which included Customer Identification Program (CIP), Customer Due Diligence (CDD), Currency Transaction Reporting (CTR), Watch list filtering, and Suspicious Activity Reporting (SAR). Also involved integration to the AML reporting under BSA (Bank Secrecy Act) act and OFAC (Office of Foreign assets control) compliance.

Responsibilities:

Worked in water scrum fall environment and assisted team in following agile principles effectively.

Played lead role in organizing and communicating detailed updates to senior business leaders on identified issues, project status reports, and any required reporting.

Conducted JAD (Joint Application Development) sessions and focus groups to gather business Requirements.

Involved in preparation of CTR (currency transaction report) and SARs (Suspicious activity reports) using the Oracle Mantas as per AML compliance laws.

Understood the Bank Secrecy Act, US Patriot Act, Basel II agreement with help of SMEs.

Documented requirements and prepared the BRD then worked with the development team to translate them into technical requirements and acted as a liaison between business users and technical team.

Developed wireframes and prototypes to get the feedback from business users and another stakeholder.

Developed UML (unified modelling language) diagrams like Use Cases Diagram, Activity Diagram, Sequence Diagram, Class Diagram and Coloration Diagram using MS VISIO 2016.

Prepared business Process Models that includes modelling of all the activities of business from conceptual to procedural level to explain workflows and security rules to team.

Analysed the business process to ensure that compliance with Know Your Customer (KYC) regulation is implemented in a layered approach throughout the bank's processes.

Conducted data analysis of end-to-end data flow to identify data gaps and data integrity issues with focus on raising alerts through Oracle Mantas tool and raised tickets on any errors.

Assisted development team in designing checking/savings accounts, credit and loan application modules to automate compliance with KYC by requiring users to correctly enter specific customer information.

Involved in Data analysis, Data cleansing and Data migration to reporting systems.

Worked in various data environments Data Warehouse, Meta-data and ETL to create various reports and matrices.

Developed SQL queries and assisted in extracting data from data sources for creating Data mapping document.

Assisted in conducting risk assessment of projects and coordination of project deadlines.

Defined and created the Test strategies and associated scripts for the verification and validation of all defined business requirements and associated functionality.

Set focus sessions to train the business in areas like transaction filtration, analytical views & reporting (SAR, CTR).

Involved in UAT Test Plan, Test Cases and Test Strategy creation based on the functional and non-functional requirements to maintain Requirement Traceability Matrix, and performed Smoke, Functional and Regression Testing

Environment: Water scrum fall, UML, Oracle SQL 2008, MS Visio 2016, MS Office, Oracle Mantas, HP Quality Center 12, SharePoint.

Charles Schwab – Phoenix, AZ Mar 2016 - July 2017

Sr Business System Analyst

Worked with a team on the Data Governance Acceleration and Sustainability Program (DGASP) which was launched to address a DG MRA(matter requiring attention) from the Fed. Identified and created an inventory of all KPI’s and KRI’s and their resulting critical data elements (CDE’s) that needed to come under governance. Collected all key performance indicator (KPI) and key risk indicator (KRI) around the firm to identify those CDE’s and Mapped map back those Critical data elements (CDE) to their original source systems.

Responsibilities:

Acted as a liaison between partner divisions and IT to develop complex workflow capabilities

Worked on all phases of the system development, procedures for requesting, implementing & supporting the process

Conducted face-to-face workshops & collaborative meetings with subject matter experts & development team to gather the list of high-level requirements for the critical data elements that need to come under governance.

Created team specific Agile process flow in Jira to move tasks from one activity to another.

Responsible for creating UML Modelling Plans, Use Cases, activity diagrams and sequence diagrams.

Developed and enforced methods and validation mechanisms for ensuring data quality.

Hands on experience in performing decomposition of physical elements into meaningful logical entities.

Documented data lineage and controls around 6 data Quality dimensions for different CCAR/ BCBS regulatory requirements (FRY-14M, FRY14Q, Other Risk Models)

Participated in selecting the strategic tool to maintain global data dictionary for UBS data management office.

Engaged with data stewards to get formal sign off on the Lineage and Controls.

Automated the daily tasks by writing SQL procedural queries which reduced the monitoring task by 70%.

Performed data analysis and data Profiling using complex SQL queries on various source systems including SQL Developer, Postgrel SQL and Microsoft Access.

Performed Bulk uploads using excel templates into Collibra Database system by mapping the required attributes.

Implemented data governance using Microsoft Visio, Excel, Collibra and IBM's IGC (Information governance Catalog)

Lead meetings to socialize organization's premiere data governance program that incorporates automation in response to the Federal Reserve's Matter Requiring Attention (MRA) to increase Transparency, Accuracy, and Accessibility

Worked with data Engineering team to develop automation and connect over 20 internal systems

Defined test cases and scripts that correspond to business requirements along with test planning and execution support.

Involved in SIF integration to develop xml code for external applications to perform search match API calls against MDM Hub Data.

Developed complex mappings using Informatica to load Dimension & Fact tables as per STAR schema techniques.

Relationship types using Hierarchy tool to enable Hierarchy Manager (HM) in MDM HUB implementation.

Tested different strategic data governance tools that match the organizational requirements.(Collibra, Ab-Initio, Informatica data Dictionary).

Performed an end to end data Lineage assessment and documentation for Metric's.

Environment: Agile-Scrum, collibra 5.0, Visio 2016, Ms Word, Ms Excel, Informatica MDM, Confluence, Jira7.0.

IndusInd Bank- Mumbai, India Apr 2015 - Feb 2016

Business analyst

Enhanced the Android Mobile/web application (major/minor enhancements) and new “add card” feature. Participated in workshops and meetings to identify features. Analysed customer requirement and worked with UI/UX designers, architect, QA, marketing, and other teams to guide products and features from initiation to release.

Responsibilities:

Participated in the Kick-offs meetings to understand product vision and strategy with business owners, SME's, stakeholders and team to gain strong understanding of the Key Performance Indicators (KPI)'s.

Gathered requirements from business owner, stakeholders and wrote user stories, epics in collaboration with the development team, breaking stories into executable and estimable task.

Designed Wireframes for multiple screens for the team to get a better understanding

Worked with the team to define the "Definition of Done"

Involved in Planning and prioritizing product feature backlog and development for the product. Assisted team of engineering and designers to build and ship a minimum viable product (MVP).

Analysed the business data and defined the Match and Merge rules and Trust Scores for MDM Hub.

Used UML diagrams to visually express the core functionality of the system under development

Worked with the team to decompose epics, themes and features into user stories that met the INVEST criteria in the Backlog Refinement Meeting

Assisted in planning sprints by ensuring user stories are meeting “definition of ready” for development with defined acceptance criteria.

Participated in Daily Stand-Ups to understand the progress/ impediments for assessing the possible risk.

Managed and monitored requirements by developing Requirement Traceability Matrix against the test cases.

Constantly kept stakeholders involved with timely and relevant updates through the entire lifecycle

Managed various stakeholders' expectations through the development lifecycle of the product

Developed test scripts for A/B testing, Google Analytics, to gather data and analytics on user behaviour. Used those to inform and validate the product feature decisions

Environment: Informatica Multi Domain MDM 9.5, Informatica Data Director 9.5, Informatica Power Centre 9.5,

Agile Scrum, Microsoft Visio 2013, JIRA 7.0, Web services- SOAP/REST, Balsamic 3.3, Oracle DB, Tableau 2018.3.

Project: Development of multiple backend services and user interfaces to support new feature rollouts for iOS and Android platforms. Played a key role in designing and implementing an Apple Watch application, enhancing the connected ecosystem for users.

Project 1: Developed multiple services for coordination of daily portfolio management. These services drive automation of the transaction activities necessary to keep a managed portfolio aligned to its recommended target investment allocation (IRA, General account and personal financial planning). Leveraged UI pages and UX with the backend DPM services.

Project 2: To maintain the investment data for internal and external facing consumers by developing the different applications and databases for source, store, steward and distribute the global EIP data.

Project 3: Maintained and dispositioned Separately managed accounts (SMA). Migrated the applications from PCF to AWS and closed business as per the program schedule.

Contact this candidate