sr business analyst and scrum master

TUSHAR

Senior Business Analyst/ Scrum Master

E-Mail ID: *************@*****.***

Contact No# 703-***-****

SUMMARY:

Highly accomplished and professional Business Analyst and Scrum Master with 8+ years of experience working in Banking, Finance & Insurance Domain with key stakeholder and business communities to comprehend the overall business vision and the business process flow for each project and Requirement Gathering, Documenting and expertise in SDLC and Agile Frame work.

PROFESSIONAL SUMMARY:

Comprehensive knowledge about Systems Development Life Cycle (SDLC) and artifacts of each phase.

Well versed on SIX Sigma, just in time, Lean Six Sigma Processes & SDLC methodologies like Waterfall, Agile Scrum with knowledge on Kanban, Scaled Agile Framework (SAFe) & Water-Scrum fall.

Proven success in conducting as-is and to-be analysis, Gap analysis, Risk analysis, Impact analysis, Cost benefit analysis, ROI analysis.

Elicited requirements using techniques like Interviews, Brainstorming, Focus Group, Document Analysis, JAD sessions, Survey/Questionnaires and documented Business Requirements Documents (BRD), System Requirements Specifications (SRS), and Functional Specification Document (FSD).

Experience in Banking Data warehousing developed test-plan, test cases for the adjusting application identified BASEL data requirement and produced data mapping utilizing company standards, Processes and procedure.

Extensive knowledge in banking standards for Customer Due Diligence (CDD), Customer Information Program(CIP), Anti-money laundering (AML) compliance, Know Your Customer(KYC), Enhanced due diligence(EDD), Special Customer Type (SCT), Wealth management customer risk types.

Regulatory, Commercial Lending, Capital Market, Treasury services, global payments, Retail Banking, Equities, Credit Risk, Corporate Banking and Investment Banking, Asset Management, Portfolio management industries. Very proficient with capital market knowledge, experience in valuation of equities, management of IPO's, etc. and have complete knowledge on all phases of the Software Development Life Cycle (SDLC)

Strong knowledge in overall Commercial Lending, Mortgage loan process flow,

Experienced in conducting Rapid Application Development (RAD) and Joint Application development (JAD) session, Interviews, Focus Groups, Brain Storming to converge early towards a design acceptable to the customer and feasible for the developer and to limit a projects exposure to the force of changes.

Proficient in creating Risk Analysis documents, Risk Management Plan, User Requirement Specification, Functional Requirement Specification, Data Flow Diagrams.

Designed & deployed custom dynamic workflows, validation rules, Approval Processes & Auto-Response Rules for automating business logic with Sales & marketing cloud on salesforce.com.

Experience working with Salesforce Classic and Lightning UI for custom theming, branding Wave and Einstein Analytics for account & opportunity insights, recommendations, prediction builder & predictive sorting

Expertise in performing in User Interface Design through Wireframes and Mock-ups, Familiar with conducting usability studies for the purpose of user interface and layout improvements.

Ability to organize, document and track changes and defects using MR tools like Clear Quest, assisted UI

Extensive experience in requirement documents, use case documents and design document such as Software design document(SDD), User interface design, Designing of application architecture, Created Work Breakdown Structure (WBS) and Perform Cost benefits Analysis, ROI analysis, Project Timelines and Project Schedules.

Evaluated Change requests by performing Impact analysis on the Triple constraints of the project.

Experienced in Extracting data from external sources, Processing and loading data files (ETL Process).

Highly Proficient in Database concepts like Data Warehousing, Data Marts, Data-Entity Relationships along with knowledge of Data modeling, Normalization, Data Table Structure, Mapping Schemas, Data Marts and OLAP operations such as Roll-up, Drill-down, Slice, Dice, Pivoting.

Knowledge of data warehouse architecture and designing Star Schema, Snow flake Schema, FACT and Dimensional Table, Physical and logical Data Modeling using Power Designer.

Worked extensively with Data Modeling tools identifying the key elements and table structures to aid database designing, experience in Data Manipulating component definition for programming and writing PL/SQL queries

Proficient at creating Data Mapping Document and identifying various transformation rules to cleanse the data and improving Data Quality by using Informatica.

Have knowledge on IoT Core platforms in the areas of data storage, data aggregation, messaging and cloud computing.

Understanding of Web Services like REST/SOAP using XML, WSDL and UDDI using internet protocol suite like HTTP under Three-Tier Service Oriented Architecture (SOA) was also involved in their testing using SOAP UI.

Designed and implemented SQL queries Joins, Unions, Outer Joins, Group by, Order by and aggregate functions to extract data from different databases (Oracle, SQL server)for timely reporting and validation.

Experience in coordinating UAT by developing Test plan, UAT test Scenarios, Test cases, Test data to be used in testing based on business and user requirement.

Experience developing solutions using SQL Server or another RDBMS technology

Expertise in Back-end testing using SQL Queries on Database tables, Reviewing Performance, Reliability, Regression, Stress, Load and Volume Testing.

Facilitated functionality testing such as Unit testing, Black box testing, Smoke Testing, System testing, Integration testing, Regression testing and Enhancement change management within various iterative models like agile and traditional methodologies like Waterfall.

TECHNICAL SKILLS

Modeling tools

SAP Power Designer, MS Visio, Axure, Mock-Up Screens, Rational Rose, Balsamiq, Enterprise Architect, MySQL Work bench and ERwin

SDLC Methodologies

Waterfall, Agile (Scrum, Kanban and Rational Unified Process) and Waterfall-Scrum Hybrid

Business Skills

Project Management Processes, Process Modeling, Change Management, GAP Analysis, Impact analysis, SWOT analysis, JAD Sessions, People management, Team management, Excellent Communication Skills, Sound Negotiator, Goal and Time oriented, Great Business Acumen

Data Warehousing

Data Modeling, Data Marts, OLTP, OLAP, Data Mining, Slicing/Dicing, Roll Up/Drill Down, Pivot, Data Dimensions, Star and Snowflake schemas, IoT

Databases

Oracle 9i/10g, IBM DB2, MS SQL Server 2005/2008/2012

Productivity Suite

MS Office (Word, Excel, Power Point, Project, Outlook, SharePoint and Access)

Requirement Management

JIRA, Rally, SILK Central HP Application Life Management (HP ALM), Team Foundation Server (TFS), GitHub, MS Office, StartNow and Version One, Silk Central

Reporting/BI/ETL Tools

Informatica, Tableau, XMLPad IBM Cognos and MS Excel

Testing tools

HPQC, HPALM, SOAP UI, Load Runner, Rational Clear Quest and Selenium

Languages

JAVA, .Net, SQL and XML

EDUCATION

Bachelors in Information Technology from University of Pune, Mumbai, India-2011

PROFESSIONAL SUMMARY

State Street, Boston, MA Mar 2017 to Till Date

Senior Business Analyst/ Scrum Master

Summary: The scope project was to monitor activities and establish the compliance and mitigated compliance risk across and monitor the accounts continuously and developing the regulatory compliance like bank Secrecy act and customer identification program requirement safe act monitoring and reporting the internal governance and regulations and review on the loan originator and can validate and identify root cause of the issues and maintain the complete accurate systems.

Roles & Responsibilities:

Facilitated JAD sessions as Facilitator and conducted interviews with various Subject Matter Experts (SMEs) and stakeholders, process reviews and policy & procedure reviews to elicit requirements.

Used MS Visio for Process modeling, Process mapping and Business Process flow diagrams.

Performed GAP analysis to assist Product Owner and Project Manager in planning the transition. Interacted with stakeholders to Identify business needs and evaluated business solutions.

Facilitated Joint Application Design (JAD) sessions with Research Analyst and Subject Matter Experts (SME) to identify business rules and requirements and document them in a format that can be reviewed and understood by both business and technical people.

Used Agile software development methodology in defining the problem, gathering requirements, development iterations, business modelling and communication with the technical team for development of the system.

Responsible for diagramming workflows and results of Business Analysis into Business Requirement Document (BRD) and obtaining sign-off from the client/business for waterfall projects (<=500hrs estimate)

Wrote SQL queries to retrieve data from databases after data migration.

Worked with the PO to gather requirements on Fixed Income, Other investments products, FX, Loan & Mortgages approval and disbursements, cash management and payment solutions, Credit cards, accounting entries, general ledger and journal entries; and personal accounts set-up application requirements.

Participated in the design sessions for prototyping new application systems structures.

Developed solution for implementing SSO for salesforce and implementing email to case, web to case and phone to case for service cloud.

Took part in salesforce automation using validation rules, workflow rules, process builder and lightning flow to improve the business logic.

Identified and resolve functional issues to enhance operation and information process flows.

Involved in converting existing business requirements into Users Stories and also created business process models from same documents.

Participated in Daily Agile Scrum "Stand-up", Biweekly Sprint Planning and Retrospective Sessions and update the team on status of upcoming User Stories.

Converting Process information, client wish lists and Salesforce Standard functionality into a Requirements Traceability Matrix for development team to use in the Build Phase.

Designed user stories, acceptance criteria in iterative developments, continuous integration, shared ownership, test-driven development environment, manage sprint task and artifacts (Agile project of over 500hrs)

Worked in mainframe environment and client server, used SQL to query various reporting databases.

Used JIRA to facilitate backlog grooming, planning, daily scrum, reviews, and retrospective.

Communicated effectively both verbally and in writing with an overall ability to be clear and concise.

Worked with internal customers to elicit Business requirements via interviews and studying of report cases and system.

Planned and assisted in the linking of QA Methodology workflows with tests conducted using HP ALM/ Quality Centre.

Environment: Agile-Scrum, Salesforce.com, AXIOM, Tableau (v-9.0), MS Visio, Oracle 12c, JIRA, SQL, Confluence, Bitbucket, GIT, MS Office, Informatica Power Centre v9, Selenium 2.5, Cucumber 2.0, ACTIMIZE, HTML5.0, CSS 3.0, IoT

Bank of America, Charlotte, NC Aug 2015 to Feb 2017

Sr. Business System Analyst

Summary: This project consolidated the legacy system’s wealth management platforms to alleviate the user's efficiency and reduce the processing time. The new dashboard provided a single interface to review reports such as asset allocations, compliance management, trading and equity reports and accommodate interactive data visualizations.

Roles & Responsibilities

Responsible for managing and directing the entire Software Development Lifecycle (SDLC) by coordinating with the project resources using a Hybrid Waterfall-Scrum methodology

Led business-wide End-to-End Implementation Planning including Process Management, Issues Management, Communication Management, Stakeholder Management, Quality Management and Procurement Management

Created and maintained Workflow Rules, Validation Rules, Approval Processes, Formula fields, and Record Types

Reported project progress through Status Review meetings, involved in Risk Management, escalated issues as necessary to the Project Champion, and also ensured that risks and issues were either mitigated, accepted, transferred or avoided.

Interacted with various business user groups for gathering the requirements for Salesforce implementation and documented the Business and Software Requirements.

Worked on various Salesforce.com standard objects like Accounts, Contacts, Cases, Opportunities, Products, Opportunity Line Items, Leads, Campaigns, Reports and Dashboards

Drafted and documented business requirements and initiate kick off meeting with the team after business sign off

Managed the successful planning, execution, monitoring and delivery of multiple projects and depending teams

Led a team of technical experts including Java Developers, QA Testers, Database analysts and business analysts

Used brainstorming sessions and questionnaires to guide the team of business analysts to gather business requirements and translate them to technical requirements to be used by Developers, QA and external testing teams.

Organized and facilitated interactive JAD sessions to elicit and document client requirements for customized wealth management platform. Prepared Requirement Traceability Matrix and Risk Assessment documents

Used Apex Data Loader and workbench mapped data sources and loaded data from legacy systems to Salesforce.com.

Conducted Root cause and SWOT analysis, Interviewed SME’s, Technical Architects, Stakeholders from different research groups to identify their current workflows and ideal work lows, drew process diagrams and administered Surveys to collect information about user’s routine operations, current business operations and data flow process.

Performed GAP analysis and As-Is study to understand the Fundamental analysis, Financial Models, Compliances and Regulations like Basel I, II, III and wealth management portfolio needs of the financial analysts (FA).

Created UML diagrams like Use Case Diagrams and Activity diagrams using MS Visio; UI mockups with Balsamiq

Assisted product owner in the prioritization of Product Backlog Items (PBIs) using Business Value, MOSCOW technique and assisted the team in breaking down EPICS into user stories.

Expert in handling Change Management by negotiating with the Business and Developers on Triple Constraints to accommodate the change. Handled requirement churn by assisting SME’s in Impact Analysis

Assisted in the creation of SQL Queries and Stored Procedures using SELECT and JOIN for Portfolio Drill Downs to pull data.

Used DDL and DML commands to assist in writing stored procedures and data manipulation and assisted in validating XML documents. Assisted in auto-generated documentation for all RESTFUL calls and API’s using Swagger.

Assisted in developing data maps for information retrieval from existing account systems and defined security measures for information accessibility and transformation.

Collaborated with the development team and QA team to validate transactions and modules are compliant with KYC, Dodd-Frank, and FINRA rules.

Worked with the QA team to create Test Cases, Test Plans and Test Scenarios for Functional and Smoke Testing.

Bamboo, Bitbucket, and JIRA software were integrated which increased traceability of the application lifecycle.

Assisted the development team with Jenkins for CI, automated build, and deployment.

Environment: Agile-Scrum, Salesforce.com, MS Visio (v 16.0), Balsamiq, MS Office Suite (2016), IoT, Swagger 1.5, TFS, JIRA, Oracle 12c, Java, Confluence, Angular JS 2.0, D3.JS, HTML 5.0, CSS 3.0, SOAPUI, Selenium 3.0, Cucumber 2.0, Eclipse IDE, Bitbucket

Germania Insurance, Brenham, TX Oct 2014 to July 2015

Senior Business System Analyst

Project Summary: The aim of the project to develop an Enterprise Level Information Intelligence System and there by integrate with Duck Creek Suit (Insights) and Salesforce CRM, which enables Risk Management Team, Actuaries and Decision Support Systems to perform Consolidated Geo-Special Analysis which helps in Managing the Risk in multiple line of business like Life Insurance, P&C Insurance for both Personal and Commercial policies and taking appropriate decisions in time further provides competitive advantages in Policy Pricing, Underwriting, Risk Exposure management, Catastrophic management, financial survival and Reinsurance Planning.

Responsibilities:

Assisted the project managers in developing project plan that included Project Schedules, Milestones tracking, and Meeting minutes using MS Project.

Created Business Process Workflow diagrams of Current and Expected System, using MS Visio and makes sure that both business and technical teams understand the process.

Elicited business requirements by conducting JAD sessions, Interviews, Focus Groups and Brain Storming sessions.

Drafted and Managed Business Requirement Document (BRD) and Functional Requirement Specifications (FRS) in Share Point Enterprise 2016and led the Requirement Workshops where the specifications get converted into User Stories.

Created and maintained Requirement Traceability Matrix (RTM) correlating the system requirements to functional- nonfunctional requirements and then to test cases.

Worked closely with Data Analyst Team and assisted in assuring the integrity of the collected data.

Analyzed and drafted Service Detailed documents from Web Service Description Language (WSDL).

Coordinated the Quality Assurance teams in Application Programming Interfaces (APIs) testing using Postman 4.8.0 and assisted in Technical Writing Workshops.

Experience in Salesforce.com Administration, operational analytics, project management, and quality assurance with emphasis on process improvement.

Expertise in integrating Salesforce solutions and keeping the Salesforce application aligned to the project success criteria.

Converting Process information, client wish lists and Salesforce Standard functionality into a Requirements Traceability Matrix for development team to use in the Build Phase.

Expertise in integrating Salesforce solutions and keeping the Salesforce application aligned to the project success criteria.

Proactively defined Reporting-Business Rules for Business Intelligence Analysts to expand on KPI metrics.

Worked on Relational Database Management systems (RDBMS), programmed SQL Queries, Metadata Analysis and documented Data Dictionaries and Data Mapping Artifacts.

Assisted Quality Assurance Team with Test Plans, Test scenarios and Test cases.

Involved in System Integration Test Planning, Test Preparation, Test Execution and Issue Resolution and Report Generation to assure that all aspects of a Project are in compliance with the Business rules.

Facilitated the Pre UAT (User Acceptance Testing) and UAT; assisted in testing and maintaining quality procedures such as Black box and Regression testing; created all the relevant documents for appropriate users.

Created User Manuals with detailed list of parameters and system responsive screen shots.

Environment: Agile, Duck Creek Suit, TDD, Eclipse Mars 4.7, ArcGIS Enterprise 10.3, Share Point Enterprise 2016, JIRA, MS Visio, MS Project, SOA, RESTful, JSON, XML, Informatica Power Centre, IDQ, Postman 4.8.0 - API Testing, Oracle 11g, AWS, MS Office tools (MS Word, MS Excel, MS PowerPoint), MySQL Workbench.

ICICI Bank, Mumbai, India Nov 2012 to Sep 2014

Business Systems Analyst

Summary: The scope of the project was to build a Enterprise Reporting system for the performance analysis of the credit card system in use. This further supported the portfolio management services of the bank.

Roles & Responsibilities

Facilitated meeting and arranged JAD sessions with business users for requirement gathering.

Performed requirements analysis, formulate and define systems scope and objectives through user needs and an understanding of business systems and industry requirements.

Developed documentation for various stages of the Software Development Life Cycle (SDLC), including Functional Designs and Test Cases. Provided functional support and guidance to application changes.

Served as a liaison between business team and the project team by assisting the business in identifying, understanding and documenting their business needs and requirements.

Created AS-IS and TO-BE business process flow diagrams, integrate process flow diagrams to show end-to-end business model including swim lanes for the elicited business requirements.

Responsible for preparing Software Requirement Specifications (SRS) and Functional Requirement Specifications and performing Gap Analysis to check the system compatibility with the new requirements.

Created use cases and designed use case diagrams class, sequence diagrams and activity diagrams.

Used SharePoint for content management and document management. Assisted in gathering requirements for the GUI (Graphical User Interface) Screens and designing mock-up screens using Balsamiq.

Added and configured various transformations like lookup, derived column, data conversion, aggregate, conditional split, merge, row count, union, select and join pertaining to data.

Environment: SQL Server 2008, SQL Server Integration Service (SSIS), SQL Server Reporting Services, Waterfall, MS Office, MS SharePoint, MS Excel, MS Access, UML, Balsamiq

J.P. Morgan Chase & Co., Bangalore, India Sep 2011 to Oct 2012

Business Analyst

Description: The project aimed to develop an Enterprise Reporting System to support the performance analysis related to credit card business with credit limit enhancement and various reward offerings (seasonal and annual benefits). The whole application processes involved a DW implementation that comprised of an ETL process for transactional data, Filter process to identify valid transactions, Calculation process for transaction and reward fee calculation. The end user interface was a web based OLAP reporting system implemented in SAP BO suite to provide business intelligence capability.

Roles & Responsibilities

Lead Joint Application Design (JAD) sessions to gather business requirements and to identify data stewards.

Served as a liaison between business team and the project team by assisting the business in identifying, understanding, and documenting their business needs.

Worked with business users and analysts to understand the requirements for mastering the data obtained from various sources and loading the golden records to the target MDM database.

Utilized previous experience and helped team in creation of Schema design in Erwin and implement in database and preparing the technical design document. Assisted in performing Data mapping testing in Informatica Data quality at each step of ETL mapping to ensure correct data in flow and outflow.

Instrumental in development of High level design, Conceptual design, Logical and Physical design for Database, Data warehousing and many Distributed IT systems along with data architects.

Documented and delivered Functional Specification Document to the project team.

Assisted the PM in setting realistic project expectations and in evaluating the impact of changes accordingly.

Gathered requirements for Client-Side Validation, and Server-Side Validation. Responsible technical writing for API development. Documented REST API request and response flow in XML format.

Conducted UAT to verify whether all the requirements were catered by new data warehouse.

Environment: MS Project, MS Visio, Informatica MDM, Informatica Data Quality, SAP BO suit, Xcelcius, Crystal Reports, SQL, Oracle 10g, MS Office, MS Visio

Contact this candidate