PROFESSIONAL SUMMARY:

• Overall 9+ years of diverse experience as a Business Systems Analyst / Sr. Business Systems Analyst and a Scrum Master in leading and managing all phases of projects with prior experience in Financial reporting, Data warehouse and Business Intelligence projects. An expert in Agile and Waterfall Project Management Methodologies; successfully managed large project onsite/offshore teams and produced high - quality deliverables that meet or exceed timelines/targets. Experience in requirements gathering, documentation, workflow preparation, process re-engineering, process mapping, scheduling, capacity planning, statistical and data analysis including source data analysis and source to target mapping, and Test Planning & Execution.
• Accomplished Senior IT professional with a background in business intelligence, reporting systems, data quality including ETL, and full life cycle development
• Robust experience in different methodologies - Waterfall, Scrum, Scrum-Waterfall Hybrid and SAFe 4.0
• Comprehensive understanding of business modeling to map the AS-IS and TO-BE states using Gap Analysis
• Experienced with the procedures of Finance & Regulatory Compliances - Customer Identification Program (KYC), Basel III Accords, Dodd Frank Act and CCAR.
• Extensive experience in managing project requirements, including requirement elicitation, requirement gathering, requirement rating/analysis and requirement priority assignment
• Adept at using many elicitation techniques including JAD sessions, Brainstorming, Document Analysis, Interviewing, Prototyping, Requirements Workshops, and Questionnaires
• Created business rules, Vision documents, business glossary and, functional and technical specifications in documents such as BRD, FRD, SRS, RTM for various projects and actively participated in verification and validation of requirements meetings with stakeholders and presented the results to top executives
• Created multiple Unified Modeling Language (UML) diagrams including Use Case, Activity, Sequence, Data Flow and ER Diagrams using MS-Visio and wireframes, prototypes and mockups using Balsamiq
• Possess sound understanding of SQL and executed queries in SQL server for data manipulation and retrieval, Table creation as well as Joins, stored procedures and functions
• Adept in writing Data Mapping Documents, Data Transformation Rules and maintaining Data Dictionary
• Vast experience of working in the area of data management including Data analysis and Data mapping
• Conversant with database concepts like Data Warehousing, Data Structures, Schemas, Data Marts, Entity Relationships and User Administration. Worked in Data warehousing project and used the ETL tool, Informatica Power Center for data mapping and performing transformations
• Converted business specifications into Service Oriented Architecture models across IT environments; Knowledgeable about 3-tier architecture, Web Services, Client-Side & Server-Side Validation
• Deep understanding of SOA/Web Services, HTML, SOAP APIs, REST APIs, RESTful APIs, Document Object Model (DOM), with the ability to read, and write XML schema and JSON schema
• Used API/Web Service frameworks such as Postman and Swagger for documenting and testing REST Webservice requests and responses in XML and JSON formats
• Experienced in making Test Plans while interacting with quality assurance teams, helping them in discrepancy management and planning and executing of User Acceptance Testing
• Created Feature Files in Gherkin to aid developers in coding the step definition files in Cucumber and used the Record and Playback functions in Selenium Testing Framework to automate functional tests
• Documented test plans and test cases and performed black box testing on the application like functional testing, smoke testing, regression testing, and UAT
• Created List Reports, Crosstab Reports, Drill through Reports, multidimensional Reports and Ad hoc reports using Tableau and Power BI
• Excellent analytical, team building, critical thinking and decision-making skills coupled with good verbal and written communication skills, interpersonal skills and an aptitude for handling abstractions with demonstrable experience of leading projects within customer-facing environments
• Communication management for all high visibility changes and issues impacting banking platform to internal staff, IT Stakeholders and external consumers
• Extensive experience in capacity planning, estimating, scheduling, risk planning, team leadership, interfacing with executive management, issue resolution, scope and defect tracking and prioritization
• Excellent in Business Process Identification and Reengineering. Project experience includes Project Management, Customer and User interactions, and Leadership Responsibilities

TECHNICAL SKILLS:

Methodologies: Waterfall, Water-Scum Fall Hybrid, Scrum, SAFe 4.0, XP, Kanban

Documentation Tool: Microsoft Word, Microsoft Excel, Microsoft Project

Collaboration tool: Microsoft SharePoint

Designing Tools: MS Visio 2010/13, Balsamiq

Requirement Management: JIRA 5.x/6.x, HP ALM/QC10.0, Rally

Application Web Server: Oracle WebLogic Server 10.3.0, Apache Tomcat 5.5.15, Redhat Jboss

Databases: MS Access, Microsoft SQL Server 2005/2008, Oracle 10g/11g, DB2

ETL Tools: Informatics Power Center 9.x/8.x/8.x (Designer, Workflow Monitor, Repository Manager and Informatica Server)

Data Warehousing: ER Modeling, Dimension Modelling, Data Marts, OLTP, OLAP, Data Profiling, Data Mapping, Data Mining, Data Validation, Star Schema, Snowflake Schema

Operating systems: Windows 7, 8, 10, Mac

API Documentation & Testing: Postman, Swagger, SOUPUI

Languages: SQL, XML, JSON, Python

Reporting: Tableau 9.x/8.x, Power BI

PROFESSIONAL EXPERIENCE

Confidential, Boston MA

Lead Business Systems Analyst

Responsibilities:

• Demonstrated strong communication and facilitation skills by liaising between stakeholders at multiple levels including SVP, VP, Director, other senior managers and built credibility for high visibility projects
• Manage the project goals, scope and project teams to ensure overall project success, including customer satisfaction and the Chief Information Officer’s (CIO’s) Leadership Group goals and objectives
• Reviewed Business Requirement Documents (BRD) based on the gathered requirements; defined KPIs, reports & dashboards in Tableau & various models in Visio
• Worked on reporting for required compliances like the DFAST, Basel III capital adequacy requirements etc.
• Performed source to target data mapping from the Lending Platform to CCAR credit card schedule. Including CCAR mapping documents, metadata, tables etc.
• Role focused on Application Integration of the Salesforce CRM, SOA Systems and the AWS ecosystem
• Collaborated with stakeholders to define project scope, milestones, deliverables and success criteria
• Conducted Feasibility Study and performed Scope Analysis for the proposed solution in collaboration with the business sponsors and reported my recommendations to the relevant stakeholders
• Engaged in requirements gathering and gap analysis workshops with SMEs; Acted as liaison between business and technology stakeholders to ensure appropriate communication, expectation management, coordination & facilitation of objectives, requirements, constraints, and specifications
• Analyzed business needs in developed use-case scenarios to aid and facilitate JAD sessions
• Communicated stakeholder needs to the agile team & participated in user story writing and Backlog grooming sessions and assisted the team in slicing epics and estimating & prioritizing the product backlog
• Managed project dashboards (JIRA), change requests, issue escalations, resolutions and mitigations
• Worked on Service Oriented Architecture (SOA) primarily REST web services; Documented requests and responses to REST Web Services in JSON; Executed, manually tested them using SOUPUI
• Used SQL server for writing SQL queries to retrieve, modify and analyze customer and credit data
• Prepared Documents for Data Layer Mapping, Change Control, and Specifications on the ETL for the architectures. Any issues that needed to be tracked for the data were prepared
• Worked on Informatica Power Center tools - Designer, Quality, Workflow Manager and Monitor
• Guided the team in implementing various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mapping in the Designer
• Worked on Informatica Power Exchange for Salesforce plugin to get Salesforce connectivity and Salesforce related transformation and collaborated in drafting strategies for DF across AWS S3 to AWS Redshift Cluster
• Conducted various SQL Queries in order to perform the back end testing for Data Validation and Data Flow
• Planned and Facilitated User Acceptance Testing; compiled results, reviewed them & formulated reports
• Assisted in formulating testing documents like Test Plans, Requirements Traceability matrix (RTM) and Test summary report and developed Test Scenarios and Cases based on functional requirements
• Participated in discussion on regression testing, release and non-release, positive and negative testing
• Created multiple Tableau dashboards and data visualization reports for the executives to give them multidimensional variable analysis of business matrices
• Performed application functionality demonstrations in various departments; conducted and designed one on one end user module for the implementation team and formulated user manuals

Environment: Waterfall-Scrum Hybrid, JIRA 6.4, MS Office Suite, MS Project 2013, Informatica Power Center 9.5, Workflow Manager, Workflow Monitor, Oracle Service Bus 10gR3, Oracle Weblogic 10.3.0, MS Visio 2013, SQL Server 2008, AWS S3, AWS Redshift, Tableau 9.3, SOUPUI

Confidential, Pennington, NJ

Lead Business Systems Analyst / Scrum Master

Responsibilities:

• Participate in project team meetings to gather project status information as well as to provide information and guidance to the project team members. Act as the primary contact between the business team and the internal IT team and external partners.
• Manage project schedules across cross-functional teams, identify and mitigate risks and facilitate an open channel of communication between stakeholders and project teams.
• Directed efforts of testers and business analysts toward of individual milestones; solving time and resource conflicts
• Helped product owner in creating project plans and process flow for the software systems development
• Facilitated Scrum Ceremonies: Release Planning, Product Backlog Grooming, Sprint Planning, Daily Stand-ups, Sprint Reviews, Sprint Retrospectives
• Organize and lead project status and working meetings; prepare and distribute progress reports
• Prepared product backlog working with product owner and other SME (Subject Matter Experts), Assisted in prioritizing user stories and assigned them to different sprints, facilitated daily stand ups & managed task board with user stories & prepared and tracked burn down & velocity charts for timely delivery of projects
• Assist in team development while holding teams accountable for their commitments, removing impediments to their work, leveraging organizational resources to improve capacity for project work
• Used JIRA for allotting tasks and issue tracking, user story management and requirement traceability
• Worked on data profiling and various data quality rules using Informatica Data Quality. As part of Data Quality Analysis: Traced Data Lineage of data elements.
• Coordinated with Data stewards for effective Data Governance
• Fetched the data multiple data sources and used Informatica to perform the ETL and Data validations and check Data availability, used Informatica Power Center Designer to check for any anomalies
• Worked in Key and Data-Driven Frameworks to retrieve test data from SQL Databases using SQL queries like SELECT statement, Different Join’s, Conditional statements with WHERE clause, different aggregate statements like the COUNT, SUM, AVG, MIN, MAX and segmentation like the GROUP BY functions
• Used Postman to Tested and Document SOAP & RESTful using GET/POST/DELETE methods
• Assisted the QA team in generating reports on Automation KPI. The reports quantified and tracked the coverage of the Automation tests. Wrote Feature files in the Gherkin format for step definition files for performing Automated testing using Cucumber
• Assisted in formulating testing documents like Test Plans and Test summary report and developed Test Scenarios and Cases based on functional requirements
• Planned and Facilitated User Acceptance Testing; compiled results, reviewed them & formulated reports
• Created multiple Tableau dashboards and data visualization reports for the executives to give them multidimensional variable analysis of business matrices

Environment: Scrum Framework, MS Office Suite, MS Project 2013, MS Visio 2013, Informatica-Power Center 9.0, Informatica-Data Quality, JIRA 6.2, Tableau 9.5, Postman, SharePoint 2010, AWS S3, AWS RedShift, Cucumber, SQL Server 2008, Oracle 11g-11.2.0.1, Tableau 9.0

Confidential - McLean, VA

Lead Business Systems Analyst

Responsibilities:

• Working with the Front Office Traders, Development Team, and Operations team in designing and implementing new trading platforms and structures as well as risk management systems in compliance with the NFA, CFTC, MiFID and FCA
• Conducted analysis on Trading Lifecycle in front-office to back office systems and documented with diagrams
• Prepared Business Requirement Document (BRD) and Functional Requirement Document (FRD) and to enable development team understand the business requirements
• Prepared product backlog working with product owner and other SME (Subject Matter Experts), Assisted in prioritizing user stories and assigned them to different sprints, facilitated daily stand ups & managed task board with user stories
• Participated in the initial Impact Analysis for all the critical functions; worked with internal team to build a high-level roadmap & timeline to achieve objectives
• Identified Use cases from the Functional requirements and wrote created business process workflow diagrams Activity diagrams, Sequence diagrams, and Use Case Diagrams in MS Visio
• Created workflow diagrams, and flowcharts using MS Visio, which were used to diagrammatically represent the process of placing a request and getting match as per bid and ask prices
• Analyzed, designed, and created Graphical User Interface (GUI) screen mock-ups
• Assisted in Enterprise integration using JSON and Data transformation for message routing using REST, WSDL/XSD, and XML
• Defined web service interfaces using WSDL and XML schemas
• Designed and implemented SQL Queries using joins, unions, outer joins, group by and aggregate functions to extract data from different databases for timely reporting and validation.
• Created data mapping rules and FIX custom tags logic for product data enrichment required for the matching purpose
• Performed application testing along with QA team - conducted Functional Flow Testing, System Integration Testing, Performance Testing, Load Testing, Regression Testing, Smoke and Sanity Testing
• Participate in Triage meetings and documented the UAT Plan for the project and worked with the UAT Team to ensure every acceptance criterion for the requirements was included in the UAT task plan
• Kept a track of all UAT bugs/defects and helped the testers to resolve the issues and made a report of all the defects which were resolved
• Created complex Dashboards using Tableau Desktop and published it to Stakeholders for feedback.
• Developed Reports with multiple Data Connections, performed data Blending, and created different Visualizations like Bar Charts, Tree Maps, Bubble Charts using complex joins with Tableau

Environment: Water-Scrum Fall, MS Visio 2010, MS Office Suit, MS Project 2010, JIRA 6.2, IBM DB2, Tableau 8.0, Informatica 9.1, Bloomberg B-Pipe, HP ALM/QC 10.0

Confidential, Smithfield, RI

Business Systems Analyst

Responsibilities:

• Planned and conducted the requirements gathering sessions with the business team to collect the business reporting standards, security and service level requirements
• Extracted, discussed, and refined business requirements during JAD sessions
• Prepared business requirements document (BRD) and functional requirement document (FRD) by interacting with cross functional team members
• Analyzed and tested various performance related reports for sector analysis, holding analysis and profile analysis
• Identified, analyzed and documented business processes and prepared workflows, process diagrams and DFDs using UML
• Documented requests and responses to SOAP Web Services in JSON; Executed, manually tested them using Postman and helped the QA team in automation of REST services testing using Postman
• Developed the parent-child data relationship models, and ER modeling
• Developed data flow diagrams and business process workflow diagrams and also developed file monitor screen designs to efficiently streamline and monitor the inbound & outbound data flows
• Assisted the team in using Informatica PowerCenter created mappings and mapplets to transform the data according to the business rules
• Used various transformations like Source Qualifier, Joiner, Lookup, Filter, Expression and Update Strategy
• Involved in creating Stored Procedures, Functions, tables, and views and other SQL joins and statements
• Involved in System Functional testing and migrated all test cases and requirements to test director
• Involved in developing the test plans and test cases for System testing and executing the same
• Developed and Implemented Requirements Traceability Matrices, test case mapping to requirements, Project Status reports, Issue /defect matrices, UAT test plans and User documents
• Conducted User Acceptance Testing (UAT) and developed the test plan, test conditions and test cases to be used in testing based on business requirements, technical specifications as well as product knowledge
• Conducted user sessions and actively participated in pre-deployment and production testing

Environment: MS Office Suite, MS Project 2010, MS Visio 2010, PowerBI, Informatica 9.1, JIRA 5.2, MySQL Server 6.0, Confidential

Confidential, Richfield, MN

Business Analyst

Responsibilities:

• Constantly interacted with business users to discuss requirements and prepared Business Requirement Document (BRD) and Functional Requirement Document (FRD) to enable development team understand the business requirements
• Wrote User Stories fulfilling INVEST criteria and assisted the Product Owner in prioritizing the Product Backlog Items (PBIs) using MoSCoW, KANO & engaged the whole team in estimating Story Points.
• Demonstrated ability in utilizing Postman and SoapUI for testing web services (SOAP & REST API).
• Develop and deliver KPIs, Metrics and Quality Reports to quantify Compliance with Policy, Data Quality
• Assisted in preparing Logical and Physical Data Modelling for Data Warehouse Database in STAR SCHEMA as per the Business Requirements
• Assisted in using Informatica PowerCenter Designer analyzed the source data to Extract & Transform from various source systems by incorporating business rules using different objects and functions
• Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement and assisted when required in SQL server for writing SQL queries to retrieve, modify and analyze and required data
• Created and Configured Workflows and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.
• Participated in reviewing the Case Report forms & Data validation plans and worked on standardizing the forms as per organizational guidelines
• Supported Reporting Specialists during custom reports development regarding required functionality

Environment: Waterfall-Scrum Hybrid, Windows, Visio and MS Project, MS Office Suite, PowerBI, Informatica PowerCenter Designer 9.0, Informatica Repository Manager, Oracle10g, DB2 6.1, Erwin, PL/SQL, HP ALM/QC

Confidential

Business Analyst

Responsibilities:

• The methodology used was Waterfall and had a deep understanding of the requirement gathering
• SPOC for Development team and business users and effectively bridge the Techno-Functional gaps
• Gathered business requirements by Brainstorming, Interviewing, and Survey; then transformed requirements to Business Requirement Documents (BRD)
• Conducted JAD Sessions with various stakeholders and another project team for detail requirements
• Accountable for Track, Capture, and Communicate the Requirements using RTM which helped in controlling numerous artifacts produced by the teams across the deliverables for the project
• Prepared PowerPoint Presentations for monthly Review Meetings with upper management
• Collaborated with marketing team for a Market Survey to assist technical team in development
• Preformed Impact analysis under Change Control Procedure to facilitate CCB for a go-no- go decision
• Used MS Visio to prepare UML diagrams like Use Case and Activity Diagram from requirements
• Wrote complex SQL queries, queried database and generated test reports on Account Payable Database
• Assisted in Test Cases, Test Scenarios and UAT Test Plan implemented them with QA team
• Created complex Dashboards using Tableau Desktop and published it to Stakeholders for feedback
• Developed Reports with multiple Data Connections, performed data Blending, and created different Visualizations like Bar Charts, Tree Maps, Bubble Charts using complex joins with Tableau
• Involved in unit testing, UAT, Error Resolution with Production Incidents and Post go-live releases

Environment: SQL Server, Access, Informatica PowerCenter v8.0, MS SQL Server 2008, Tableau, UML, MS Office, MS Visio.

Confidential

Junior Business Analyst

Responsibilities:

• Interfaced with the client as part of the Requirements Engineering team to finalize the project scope
• Assisted the PM in developing the project plans and also managed changes to the scope of the project
• Conducted and gathered Requirements, analyzed the Requirements
• Designed and developed project document templates based on SDLC methodology
• Documented and delivered Functional Requirement Document to the project team
• Participated in the design sessions, assisted and developed high and low level design documents
• Coordinated Change Request for the Clients by conducting Impact and Cost analysis, prioritizing and mitigating changes and prepared change request form to provide details of the Change request
• Involved in performing Data Modelling by creating logical and physical models of the database system
• Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results
• Delivered Enterprise Data Governance, Data Quality, Metadata, and ETL Informatica solution
• Conducted User Acceptance Testing UAT

Environment: Waterfall, Java, MS Visio, Waterfall, MS Project, MS Visio, MS Office Suite, SharePoint, SQL Server 2005, Informatica PowerCenter 8.0