Saransh
**********@*****.***
SUMMARY :
Business system analyst, with 9 years of industry in the domain of Electronic Payments and Billing, Finance Service Industry like Mortgages, Investment Proposal, ‘Banking and management’, Telecom and Data Warehousing. Have good understanding of gathering Business Requirements, Business Process flow, and Business Process Modeling.
Certified Scrum Master (CSM) with proven ability to work with self-organizing and cross-functional teams in a wide spectrum of Portfolio, Mortgages and financial sectors. Have hands on Experience on Waterfall, Agile Scrum and Hybrid of Waterfall and Agile methodologies.
Extensive experience in Business process re-engineering, business process improvements, Data Reports Analysis accompanied by active participation in discovery sessions, interviews, prototyping, document-reviews, plan setup, plan configuration with customers.
Experience in conducting GAP and impact analysis of AS-IS and TO-BE systems, SWOT analysis, Feasibility study, Cost benefit analysis, Risk Analysis and ROI analysis.
Have extensive experience with the entire Software Development Life Cycle (SDLC) that included Requirement Elicitation, Gathering, Analysis, Design & Development and change management.
Extensive experience in requirements gathering, Analysis and Communication with SME’s, Stakeholders (technical, non-technical), business process analysis, Solution Assessment & Validation, documenting project artifacts and Testing/Maintenance operations.
Proficiency in gathering SMART (Specific, Measurable, Attainable, Realistic, Timely) requirements and transforming them into functional specifications focusing on workflow/user interface analysis and design.
Expertise in creating project artifacts such as Business Requirements Document (BRD), Use Case Documentation, Requirements Traceability Matrix (RTM), Business Rules Spreadsheet, Functional Requirements Document (FRD), Data Mapping Document, Systems Requirements Specification (SRS) and GUI Mockup Screens.
Extensive experience in Business Process Modeling using Visual modeling tools with professional expertise in MS Visio, IBM Rational Rose.
Extensive experience in UML Modeling like Activity Diagrams, Sequence Diagrams, Use Case Diagrams, Process Work Flow Diagrams, Timing Diagrams and Class Diagrams.
Good knowledge of database relationships and concepts; worked on RDBMS like MySQL and MS SQL server.
Excellent skills in analysis, design, development and implementation of ETL tools like Informatica Power-Center, SSIS and reporting tools like Tableau, IBM Cognos and SSRS.
Skilled with Data Analysis concepts of Data Modeling, Data Dictionary, Data Mapping and Normalization.
Good Understanding and hands on experience in creating Entity Relationship Diagrams (ERDs).
Organized and facilitated Joint Application Design (JAD) sessions & interviews, brainstorming sessions, questionnaire, focus group, implementation requirements, project status report and resolving issues/conflicts.
Comprehensive understanding of Web-Services like WSDL, SOAP using XML and REST using internet protocol suite like HTTP under Three-Tier Architecture and Service Oriented Architecture (SOA).
Comprehensive knowledge of web services related concepts such as XML, WSDL, HTML, Ajax, SOA, API and Web Architecture. Comprehensive knowledge of business engines and XML schemas.
Experienced in writing User stories and handling the Requirement Churn by conducting impact and Risk analysis
Proven expertise and experience in handling and conducting various Scrum Ceremonies like Sprint Planning meeting, Daily scrum meeting, sprint retrospective meeting, Sprint review meeting and backlog refinement meeting and adoption of agile related techniques (MOSCOW technique, Planning Poker)
Efficient in performing, prioritizing and using techniques such as Panning Poker, Moscow and T-Shirt Sizing.
Mastery in the use of Agile Methodologies (Scrum & Kanban) related tools such as Rally, JIRA to document and visualizes stories, tasks, and measure performance through burn down charts/velocity charts.
Documented and created Test Plans, Test scenarios, Test Objectives, Test Cases, Test Logs and Run Books. Experience in conducting User Acceptance Testing (UAT) and verified performance, reliability and fault tolerance issues.
Experience with ServiceNow for change management and handling change requests and proposals to Change Control Boards (CCBs).
Highly motivated team player with excellent communication, presentation and interpersonal skills, always willing to work in challenging and cross-platform environment.
A proactive and dedicated team player, with proven track record in producing high quality work under tight deadlines and multi-tasking to meet business goals. Experience in scheduling meetings, negotiating and co-ordination with Developers, Application Architects, Subject Matter Experts, business users and senior executives.
Technical skills
Business Modeling Tools
MS Visio, UML, Rational Requisite Pro, BPMN, Rational Rose, Rational Clear Case.
Methodologies / Frameworks
Agile/Scrum, Waterfall, Spiral and RUP
Requirement Management
MS Office, JIRA, RALLY, Confluence, HP ALM 11.5 and Rational Rose
Database
MS SQL Server2012/2008, My SQL Work bench V5.2, MS Access, Oracle 11
BI Reporting Tools
Tableau, Crystal Reports, Cognos 10 (report & Query studio), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Micro strategy reporting system, Qlikview
Programming Languages (Exposure)
C, C++, Java, JavaScript, Ajax, .NET, Python, PL/SQL
ETL Tools
Data stage, Informatica, IBM Cognos, IBM Infosphere, Infosphere
Information Services
QA Testing Tools
HP QTP, JIRA Green hopper, HP Load Runner, MS Test Manager 2013
Data Warehousing
Data Marts, MDM, OLTP, OLAP, Teradata, Query/Reporting, Multidimensional Analysis, Data Mining, Slicing/dicing, Drill Down/Roll Up
Project Management Tools
MS Project professional, MS Project Server, MS SharePoint 2013,
SharePoint Designer, JIRA, RALLY, HPALM, VSTS, TFS
Domain
Banking, Mortgage Loans, Electronic Billing and Payments, Insurance, Portfolio management (Bonds, Mutual Funds, Equities, Fixed Income, securities, foreign exchange, Swaps, Brokerage, Stocks, and Bloomberg Data), Telecom
Professional Experience
Fiserv, Alpharetta-GA Oct’ 16 – Current
Business System Analyst / Scrum Master
Fiserv is one of the leading provider of electronic billing and payments. The project objective was to upgrade/migrate clients from a legacy solution and to onboard net new clients on the platform in a manner that is flexible in terms of supporting existing client system while offering new features and adhering to PCI Compliance, BSA. The project was supporting a clientele from diverse domains such as Banking, Insurance, Utilities, Municipal cities and Telecom.
Key Responsibilities
Involved Pre-analysis and conducted feasibility study, Cost-Benefit and Risk analysis.
Facilitated JAD sessions with various stakeholders and project team.
Gathered business requirements using appropriate elicitation techniques like user observation, brainstorming, client interviewing and document analysis.
Analyzed, defined, documented and communicated business requirements to tech leads, developers and QA by interacting with the end customers to meet business partner’s needs.
Assisted with evaluation, customization and system integration. Conducted GAP analysis around the identification of business rules, business and system process flows, user administration, requirements and assumptions.
Analyzed and translated the client's business requirements and functional specifications into technical specifications, data flow diagrams and data models.
Responsible for creating management tools: flowcharts, context diagrams, interaction and presentations.
Work with the Product team to request enhancements, present use cases for client specific requirement
Used mockup screens to convey the look and feel of the GUI screens for the end users to developers
Understood various web services i.e billing, payment, orders using API and Web Architecture
Deliver IVR user interface design documentation outlining backend interfaces to support business functionality and application development.
Develop call flows for complex applications including data driven interactions and Contact Center routing of calls.
Worked with SQL DML queries to extract application data for validations used Stored Procedures and Triggers.
Facilitated the User acceptance Testing (UAT) after performing Unit Testing, System Integration Testing (SIT), Performance & Service level testing.
Developed training curriculum and conducts formal training sessions
Assist customer with User Acceptance Testing, developing and maintaining quality procedures, and ensure that appropriate documentation is in place. Assisted in Black box, UAT and Regression testing
Conducted Triage calls for quick resolution of defects and provide RCA support during implementation.
Used TFS/VSTS for issue tracking, user stories management and requirement traceability.
Knowledge on compliances Payment Card Industry (PCI) domain, BSA (Bank secrecy acts), US Patriot act, AML
Environment: .NET, SQL-Server, Scrum, Agile, Kanban, MS Project, VSTS, TFS, SharePoint 2013, CAWA
Bank of the West, San Ramon-CA Nov’15 - Oct’16
Business Analyst/ Scrum Master
Bank of the West is a wholly owned BNP Paribas subsidiary. The projects objective was to enhance the client’s legacy system for customer due diligence by adhering to FDIC Compliance, AML incorporating KYC KYA for legacy customers (10+ million) and to ensure transaction are flagged for Anti Money Laundering.
Key Responsibilities
Involved Pre-analysis and conducted feasibility study, Cost-Benefit and Risk analysis.
Interviewed business users to gather requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
Identified, researched, investigated, analyzed, defined opportunities for business process improvement, documented business processes and initiated efforts to make improvements.
Contributed to the definition of scope, performed extensive requirement analysis and defined functional specifications.
Elicitation of Functional/non-functional requirements and Conducting the functional requirements/user requirement specification reviews and walkthroughs with designers, developers, SME’s and stakeholders.
Worked closely with end-users and stakeholders, SME to develop a detailed understanding of the requirements and prepared comprehensive set of documents to define the specifications and business value of the systems and delivered them in the Business Requirements Document.
Responsible for creating management tools: flowcharts, context diagrams, interaction and presentations.
Facilitated JAD sessions with technical/non-technical team, SME’s to clarify business rules & solve impediments.
Performed GAP analysis to further identify deltas between legacy and new application.
Developed solid documentation by analyzing current processes and design business processes modeling notification (BPMN) utilizing UML for object oriented design and documentation utilizing MS Visio.
Acted as a liaison between management and Data Warehouse development team.
Extensively interacted with data analysts during the ETL operations in identifying the source files/databases from OLTP systems & implementing the transformation logic for achieving data uniformity in operational data store (ODS).
Lead the project and coordinated all IT efforts from planning and testing to implementation.
Coordinated with the DW architects and developers to identify appropriate dimensional modeling (identifying dimensions/facts/referential integrity) and Data Modeling measures (additive/semi-additive/non additive), and sizing (in terms of number of columns, records per dimension and fact table).
Gathered business requirements using appropriate elicitation techniques like user observation, brainstorming, client interviewing and document analysis.
Define key Agile processes, Roles & Responsibilities, Communication Plan, Agile Ceremonies
Conduct Release planning, Sprint planning, Deployment planning activities.
Performed GAP analysis to further identify deltas between legacy and new application
Worked with Product Management to groom, maintain and prioritize Product, Release & Sprint Backlogs
Worked on heterogeneous applications and data sources into business focused solutions
Developed solid documentation by analyzing current processes and design business processes modeling notification (BPMN) utilizing UML for object oriented design and documentation utilizing MS Visio.
Used JIRA for issue tracking, user stories management and requirement traceability.
Assist customer with User Acceptance Testing, developing and maintaining quality procedures, and ensure that appropriate documentation is in place. Assisted in Black box, UAT and Regression testing.
Conducted Triage calls for quick resolution of defects and provide RCA support during implementation.
Create/maintain HP QC, JIRA projects (and users, workflows, configurations, screens, quick filters, etc).
Knowledge on compliances BSA (Bank secrecy acts), US Patriot act, AML
Environment: Flat Files, Unix, Scrum, Agile, Kanban, MS Project, Visio, UML, SharePoint 2013, Java, JavaScript, Oracle 11, Mainframe, JIRA, HP QC
Ameriprise Financial, Minneapolis-MN Sept’14 - Aug’15 Scrum Master/Business System Analyst
Ameriprise is an American multinational financial services corporation.The project’s main objective was to create an investment proposal system, a web application which seeks input from individual investor, in the form of answer to a set of dynamic questionnaire, so as to ascertain the investment strategy, ascribe asset classes, quantify risk tolerance, and determine asset allocation and its weightage.
Key Responsibilities
Participated in various meetings/discussions, with Product Owner, SME, Lead Business Analyst, and Project Manager, to discuss and consolidate the business requirements.
Created and Managed Features to ensure that the business vision and goal is carried down to the Implementation Level by seeding Features (Epics) in to Agile Release Train (ART) as per the Release Planning.
Analyzed, defined, documented and communicated business requirements to technical architects, developers by interacting with the end customers to meet business partner’s needs.
Used Rally tool to track project status at a Portfolio, Release, and Iteration level.
Helped PO own the Product Backlog and perform Product Backlog Grooming, and supported in creating Epic and User Stories.
Facilitated the sprint plan, daily scrum meeting & retrospective meetings in each sprint cycle and removed Impediments as and when they are raised.
Worked with PO, Stakeholder to attend Sprint Review meetings and Approve/ Accept User Stories developed by the Delivery Team in the given Iteration.
Attended SRUCM of SCRUM meetings and discussed & communicated iterations plans with cross-functional teams and worked towards resolving inter-team dependencies in a SAFe environment.
Coached Team towards Agile processes and principles, and ensure that they are followed in the right way.
Assisted with evaluation, customization and system integration. Conducted GAP analysis around the identification of business rules, business and system process flows, user administration, requirements and assumptions.
As a scrum master coordinated with the Product owner in prioritizing the user stories in the product backlog and breaking Epics into smaller user stories.
Tracked the performance and progress of each sprint cycle with burn down chart identified burn down velocity
Coached Product Owners in creation and maintenance of Product Backlog.
Managed Kanban development team and helped PO keeping highest priority item at top of backlog.
Conducted training sessions and/or 1:1 sitting. Delivered training on Scrum/Kanban task board, etc.
Engaged with other Scrum Masters to increase the effectiveness of the application of Scrum in the organization
Tracked and effectively communicated team velocity and sprint/release progress to all affected teams and management.
Communicated the feedback by other stakeholders from scrum framework meetings to the scrum team.
Updated Agile tracking systems to provide transparency on product and sprint backlogs.
Coordinated with Project Manager to create Work break down structure (WBS), manage schedules, deadlines, resources and the project tasks using MS Project.
Coordinated the execution of Unit Testing, System Integration Testing (SIT), Performance & Service level testing and User Acceptance Testing (UAT).
Knowledge on compliances SOX, Dodd-Frank
Environment: Scrum, Unix Agile, MS Project, Visio, UML, SharePoint 2013, Asp.net, C#, Oracle, Tableau, Informatica, Mockup Screens, Rally
Farm Credit Bank, Austin-TX Oct’13 - Aug’14 Business System Analyst /Scrum Master
Farm Credit Bank is a leading lender in Commercial, Infrastructure development and Scope of the Project involves developing Data warehouse from the various operational functional areas systems and creating BI reports for predictive modeling and Ad-hoc querying for management to visualize Business performance. It also facilitated creation of a data mart to generate periodic reports like monthly and Quarterly reports. A portal with login functionality was provided to selected users/internal clients from that department to view the detailed reports by incorporating Business Intelligence tools to generate necessary dashboards.
Key Responsibilities
Understood Consumer Protection Financial Bureau (CPFB) and FHA rules.
Performed requirements gathering using both formal and informal sessions through interviews, questionnaire, video conferencing, JAD sessions and conference calls.
Analyzed, defined, documented and communicated business requirements to technical architects, developers by interacting with the end customers to meet business partner’s needs.
Participated in various meetings/discussions, with Product Owner, SME, Lead Business Analyst, and Project Manager, to discuss and consolidate the business requirements.
Analyzed and translated the client's business requirements and functional specifications into technical specifications, data flow diagrams and data models.
Assisted with evaluation, customization and system integration. Conducted GAP analysis around the identification of business rules, business and system process flows, user administration, requirements and assumptions.
Analyzed problems, including automated and manual business process flows, and identified, researched and investigated, defined and documents business processes.
Facilitated JAD sessions with tech leads, development team and QA team.
Implemented Unified Modeling Language (UML) to prepare Use Cases diagrams, process flow diagrams, sequence diagrams from the gathered requirements and created diagrams using MS Visio.
Used mockup screens to convey the look and feel of the GUI screens for the end users to developers
Involved in identifying the problem definition as part of continuous process improvement using Define, Measure, Analyze and Improve to support the business continuity of the organization.
Successfully analyzed the functional/non-functional requirements of the data warehouse for generating BI reports and communicated the same with architectures and developers.
Involved in identifying and suggested the different dimensions (slowly changing dimensions/rapidly changing dimensions) required for generating the reports and OLAP cubes to facilitate the multi-dimensional view of the data to generate slicing/dicing, roll-up/drill-down reports.
Established Requirements Traceability Matrix (RTM) using Rational Requisite Pro to trace the completeness of requirements.
Developed high-level and low-level documents like Business requirements documents (BRD), Functional requirements documents (FRD) and assisted in creating System requirements specification (SRS).
Conducted Business workflow analysis, process analysis, SWOT analysis, cost-benefit analysis and Gap analysis to know the condition of the current system in use.
Used various SQL commands like Create, Delete, Update, and Inner, Outer, Left, and Right joins to update the database and retrieve data for data analysis and validation. Assisted Data analysts in Data Modelling.
Excellent experience in design and development of data warehousing solutions and generation of OLAP reports.
Worked with SQL DML queries to extract application data for validations used Stored Procedures and Triggers.
Extensively interacted with the designers, developers to ensure functional implementation of business requirements and QA team in executing Test Plans, Test scenarios and Test cases.
Identified and reviewed the stored procedures and triggers developed by team based on customer specific requirements
Facilitated the User acceptance Testing (UAT) after performing Unit Testing, System Integration Testing (SIT), Performance & Service level testing.
Involved in Project Management activities like defining / managing project scope, schedule management,
Creating project plans, tracking and communicating project status, deliverables, and milestones.
.
Environment: Flat files, Mainframe, Oracle 11, Visio, UML, SharePoint 2010, HTML, XML, J2EE, UNIX, Java, JavaScript, HP ALM, JIRA, Informatica, MSSQL, Telegance, Enabler, Tableau
Tech Mahindra (AT&T), Pune-India Apr’12 - Aug’13
Business system Analyst
Techmahindra is a leading telecom consultant. As consultant to AT&T the project scope was to enhance their flagship website www.att.com for enhancing the middleware and integrating new customer from an acquisition to AT&T
Key Responsibilities.
Involved in identifying the problem definition as part of continuous process improvement using Define, Measure, Analyze and Improve to support the business continuity of the organization.
Facilitated JAD sessions with various stakeholders and project team.
Gathered business requirements using appropriate elicitation techniques like user observation, brainstorming, client interviewing and document analysis.
Used Mockup screens to convey the look and feel of the GUI screens.
Established Requirements Traceability Matrix (RTM) using HP ALM to map requirements to test cases using HP ALM.
Developed high-level and low-level documents like Business requirements documents (BRD), Functional requirements documents (FRD) and assisted in creating System requirements specification (SRS).
Conducted Business workflow analysis, process analysis, SWOT analysis, cost-benefit analysis and Gap analysis to know the condition of the current system in use.
Understood various web services i.e billing, payment, orders using SOA, API and Web Architecture.
Comprehensive knowledge of business engines and XML schemas
Used various SQL commands like Create, Delete, Update, and Inner, Outer, Left, and Right joins to update the database and retrieve data for data analysis and validation. Assisted Data analysts in Data Modelling.
Worked with SQL DML queries to extract application data for validations used Stored Procedures and Triggers.
Extensively interacted with the designers, developers to ensure functional implementation of business requirements and QA team in executing Test Plans, Test scenarios and Test cases.
Identified and reviewed the stored procedures and triggers developed by team based on customer specific requirements
Facilitated the User acceptance Testing (UAT) after performing Unit Testing, System Integration Testing (SIT).
Conducted WAR ROOM session to resolve defects in a timely manner across multiple teams.
Conducted review sessions on a regular basis with QA and development teams for preparing status and delivery of operational reports
Support migration of ID administration and management from local ISA (Information Security Administration) groups to AT&T's Center of Excellence.
Involved in understanding Data Migration of Amdocs Enabler CM,, Ensemble, CSM products for AT&T billing system
Configuring to schedule and monitor using Tivoli workload scheduler and console for optimizing performance.
Involved in Project Management activities like defining / managing project scope, schedule management,
Creating project plans, tracking and communicating project status, deliverables, and milestones using HP ALM.
Environment: JAVA, J2EE, UNIX, OSS, CRM, Visio, UML, SharePoint 2010, HTML, XML, JSON, Mockup Screen, Java, JavaScript, HP ALM, Rally, Informatica, MSSQL, Telegance, Enabler, UNIX
Ericsson, Noida-India July’11- Jan’12
QA/Jr. Business Analyst
Ericsson is one of the industry leader in offering services, software and infrastructure in information and communications technology. It had a good market share. The objective of the project was to enhance the customer service portal for India’s leading Telecom service provider.
Key Responsibilities
Interacted with users and stakeholders to identify business needs, worked with SME’s of different groups to gain detailed knowledge of E-commerce shopping.
Assisted with web portal development to enhance the functionalities of the system based on SOA and requirements collected for web architecture.
Scrum was used in acute functionalities to design, document and manage User Stories throughout the life cycle of the project, including definition, design and testing phases.
Analyzed requirements documents and Use Cases to prepare the detailed Test Plans and Test Cases.
Involved in Analysis and Design of Functional Specifications to identify Test Requirements, Design Test Cases, Test Scripts, and Test Data with expected output.
Identification and development of test scenarios to test application against Functional Requirements
Interaction with client / Business Partners on Business Requirements, Change Requests and Defects
Involved in build validation, smoke testing, sanity testing, regression testing and Performed User Acceptance Testing for testing the usability and user friendliness of the application.
Worked with SQL queries to extract application data to perform application validations.
Worked as a team with other team members to make an object oriented model and created use cases.
Involved in preparing test cases and test scenarios and coordinated with other QA’s in executing the test plans.
Assisted in client-side validation and server-side validation on the data which was given or submitted by the client.
Assisted in preparation of UAT test plan, testing cycle schedules, test scenarios and implemented them with QA team
Conducted war room meetings on bug reporting and issue resolutions.
Involved in discussions with the Team on Quality Analysis, Manual Testing, Automated Test Tools and Defect Tracking Tools, Root cause analysis.
Involved in mentoring specific projects in application of the new SDLC based on the Agile Unified Process, especially from the project management, requirements and architecture perspectives.
HP Quality center: Requirements upload, Test Case development with Requirement mapping, Test Sets creation for each release, Capture Test Results and mapped raised defects to the test sets, generated various reports upon request.
Environment: Waterfall, HP Quality Center / ALM, Share Point, JQuery, JSP, Java Script, Linux, JIRA, J2EE, GUI/UI, Apache, UML Telegence, Enabler, IBM, MS Office, MS Visio, MS Excel, MS SharePoint,SQL, PL/SQL, J2EE, HTML, XML, HP QTP/UFT
Airtel, Gurgaon-India Jan’10-June’11
Quality Analyst
Airtel is a leading communication technology service company providing. As a part of the mobility team I was responsible for testing the flagship web application called myairtel: Online Billing, Usage, Payment, Dashboard, Profile and CSR Service portal.
Responsibilities:
Analyzed requirements documents and Use Cases to prepare the detailed Test Plans and Test Cases
Identification and development of test scenarios to test application against Functional Requirements
Interaction with client / Business Partners on Business Requirements, Change Requests and Defects
Involved in discussions with the Team on Quality Analysis, Manual Testing, Automated Test Tools and Defect Tracking Tools, Root cause analysis, Conducted war room meetings on bug reporting and issue resolutions
Involved in Analysis and Design of Functional Specifications to identify Test Requirements, Design Test Cases, Test Scripts, and Test Data with expected output.
Involved in mentoring specific projects in application of the new SDLC based on the Agile Unified Process, especially from the project management, requirements and architecture perspectives.
HP Quality center: Requirements upload, Test Case development with Requirement mapping, Test Sets creation for each release, Capture Test Results and mapped raised defects to the test sets, generated various reports upon request.
Supported testing, Creating test cases in that would test various test scenarios.
Involved in build validation, smoke testing, sanity testing, regression testing and Performed User Acceptance Testing for testing the usability and user friendliness of the application.
Worked with SQL queries to extract application data to perform application validations.
Assigned problems to appropriate software development team for fixes.
Environment: Waterfall, HP Quality Center / ALM, Share Point, JQuery, JSP, Java Script, Linux, JIRA, J2EE, GUI/UI, Apache, UML Telegence, Enabler, IBM, MS Office, MS Visio, MS Excel, MS SharePoint,SQL, PL/SQL, J2EE, HTML, XML, HP QTP/UFT
Education:
Bachelor in Engineering Computer Science M.D.U, Rohtak, 2010
Masters in Computer