PROFESSIONAL SUMMARY

• 8+ years of experience in the IT field as a Business Analyst, Business Systems Analyst and Scrum Master who has worked extensively on Banking and Finance sectors.
• Have robust understanding of various Software Development Life Cycle methodologies, like Waterfall, Agile, Waterfall - Scrum hybrid and Scaled Agile (SAFe 3.0, 4.0).
• Certified Scrum Master from International Scrum Institute, have deft proficiency in Scrum Methodology and ceremonies like Sprint Planning, Daily Scrum, Review, Refinement, Sprint Retrospective.
• Conducted Story writing workshops, just in time requirement analysis, created user stories using INVEST criteria, sliced epics and themes using vertical slicing, and assisted Product owner with Product backlog.
• Created tasks by using SMART criteria, story mapping, coached team on agile principles and how to be self-organized, logged and resolved impediments, adept at conflict management and resolution.
• Efficient at user story prioritization techniques such as Value Stream Mapping, MoSCoW, Kano Model, Business Value Based, Walking Skeleton, Technology Risk Based and Customer Value Based.
• Proficient in User Story Estimation techniques such as Planning poker, Bucket System, Relative Mass Valuation, T-Shirt Sizing, Dot Voting.
• Scrum retrospective techniques such as Satisfaction Histogram, Silent Writing, Mad Sad Glad and Starfish. Hands on experience with tools for Project Management activities, proficient with Project Management Tools.
• Involved in Business Process Reengineering by conducting Impact Analysis, Cost Benefit Analysis, Root Cause Analysis, Feasibility Study, GAP analysis to understand As-Is and To-Be business process, Risk Analysis, PESTLE analysis, SWOT analysis and Force Field Analysis.
• Proficient in networking with individuals at various levels while organizing, conducting and facilitating elicitation sessions such as survey/questionnaires, interviews, brainstorming, focus group, requirement workshops, interface analysis, document analysis, and JAD sessions.
• Proven expertise in creating Business Requirement Document (BRD), Use-Cases, Requirements Traceability Matrix (RTM), System Requirement Specification (SRS) and Test Requirement Document (TRD).
• Extensive knowledge of SOAP/RESTful web services, AJAX, JSON, XML, XML Schema Definition (XSD), Web Service Description Language (WSDL).
• Experience in creating XML, HTML and handling JavaScript, PHP files.
• Broad knowledge in reviewing test input data and test procedures, document detailed test plans, test scenarios, define test cases and experience in performing User Acceptance Testing (UAT).
• Experience supervising Black-Box Testing, Functionality Testing, System Testing, Integration Testing, Regression Testing, Performance Testing.
• Expertise on identifying various data sources, performing data profiling, data cleansing, data aggregation, data modelling techniques like Entity Relationship modelling, dimensional modelling, data vault modelling.
• Data validation in data integration, migration, warehousing projects using Informatica.
• Strong understanding of OLTP, OLAP, data marts, OLAP Cube, Conceptual modelling, logical modelling, ODS and ETL concepts. Experience and good understanding of using DDL, DML, DCL languages in SQL to perform CRUD operations on database including joins, order by, group by, procedures and functions.
• High expertise in Data Warehousing, Star/Snowflake Schemas. Architectures such as Centralized, Bus, Interconnected, Hub and Spoke and Federated.
• Profound knowledge in Big Data concepts including Hadoop Ecosystem consisting of HDFS, Name Nodes, Data Nodes, YARN with knowledge of libraries such as Pig, Hive, Flume, Sqoop, Spark, Impala, Kafka.
• Experience working in big data environment, in implementing business logic and optimize the queries using Hive Language (HiveQL), NoSQL.
• Expertise in UML (class diagrams, use case diagrams, state diagrams, sequence diagrams, activity diagrams) as a business analysis methodology for application functionality designs using IBM s Rational Rose.
• Self-Motivated and Objective driven with excellent communication and Interpersonal Skills with a sound understanding of the balance that must exist between customer satisfaction and technical excellence.

Project Management Tools/ Methodology: MS- Project, MS SharePoint, JIRA, Rally, Scrum, Waterfall-Scrum, SAFe and Waterfall

Languages: C, C++, Java, Python, R, HTML, CSS, JavaScript, SQL, PL/SQL, XML, SOAP, RestFul

Reporting Tools: IBM Cognos, MS office Suite, Tableau, Power BI, Crystal, OBIEE

Design Tools: MS Visio, Rational Rose, Balsamiq, Erwin

Big Data: Hadoop, HDFS, Hive, HiveQL, Pig, Sqoop, mapR 2.0, Spark, Flume, Ambari, Kafka

Analytics Tools: SAS Banking Intelligence Solution Suite, SAS High-Performance Analytics environment, SAS LASR Analytic Server, SAS management console, SASHDAT, MS Excel, MS Access, Tableau 9.1

ETL Tools: Informatica Power Center, Pentaho, IBM Data Stage

Testing Tools: HP QC, HP ALM, LoadRunner, Selenium

Office Tools: MS Word, MS Excel, MS SharePoint, MS Project, MS Visio, MS Access

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

Database: MySQL, SQL 2008/12, Oracle 9i, 11g, HBase

PROFESSIONAL EXPERIENCE

Confidential, Buffalo, New York

Sr. Business Systems Analyst/Scrum Master

Responsibilities

• Interacted with the stakeholders to understand the current state of system and defined future needs based on analysis of business requirements after implementing gap analysis.
• Conducted JAD sessions for requirement elicitation and to allow stakeholders to communicate their perspectives.
• Developed Data Migration, Data Profiling and Cleansing rules considering data linkage and data transformation rules. Developed Data Mapping and Data Transformation documents between Legacy database and Production DWH.
• Facilitated Database Design sessions with Data Architecture and IT development team to define a DWH Design to meet Enterprise, Business and Data processing requirements.
• Prepared ER Diagram, Use Cases and Data Flow Diagrams to communicate the page flow and user interaction with the system.
• Highlighted risks in timely manner by conducting SWOT Analysis, Cause-Benefit Analysis, Risk Analysis, Impact Analysis and ROI Estimation.
• Used PL/SQL stored procedures, triggers, functions and packages for extracting data, validating data and generate reports according to the requirements specified by the SMEs.
• Wrote User Stories fulfilling INVEST criteria, assisted the Product Owner in prioritizing the Product Backlog Items (PBIs) using techniques like Kano Model, Moscow and estimated Story Points using Planning Poker.
• Used JIRA to create and manage sprint and product backlogs, to track issues, trace requirements.
• Created Sprint Burndown and Release Burndown Chart to keep track of the team’s velocity and sprint progress for forecasting.
• Reduced risk and ambiguity by adding rigor to the Definition of Done and used domain knowledge and expertise to slice user stories based on business value.
• Facilitated all scrum ceremonies such as Sprint Planning, Daily Scrum, Sprint Review, Sprint Retrospective and Backlog Grooming.
• Shielded the team from various impediments and assisted the Product Owner in forecasting release plans by tracking the Team’s Velocity.
• Performed User Acceptance testing, verification testing and System testing manually.
• Involved in generating Test Plans and Test Specifications, prepared test data for positive and negative Test Scenarios as per system specifications and requirements.
• Implemented Change Data Capture (CDC) for inserting and updating slowly changing dimension tables in target for maintaining the history data.

Environment: Waterfall-Scrum, SAS Banking Intelligence Solution Suite 2.5, SAS High-Performance Analytics environment, SAS LASR Analytic Server, SAS management console 9.4, HiveQL, SASHDAT, Hadoop, Tableau, MS Visio, Python, SQL, JIRA, HP QC, HP ALM.

Confidential, Columbus, OH

Sr. Business Systems Analyst/Scrum Master

Responsibilities:

• Gathered business requirements through interviews, surveys by interacting with stakeholders and business users.
• Involved in preparing Logical Data Models and conducted controlled brainstorming sessions with project focus groups.
• Worked on Conceptual, Logical Modeling and Physical Database design for OLTP and OLAP systems.
• Created a logical design and physical design of the centralized relational database.
• Responsible for database design, star schema, snow flake schema design, data analysis, documentation, implementation and support.
• Created data model for the Star Schema using Erwin, created DDL scripts for static dimensions and ETL Mappings using Data Stage.
• Widely used Normalization methods and have done different normalizations (3NF).
• Created DMR mapping spreadsheets, Source to Target mapping documents including the transformation rules.
• Involved in business process modeling using UML through Rational Rose.
• Used Rational Requisite Pro to document technical requirements and business user requirements.
• Analyzed business requirements, transformed data, and mapped source data using the Teradata Financial Services Logical Data Model tool, from the source system to the Teradata Physical Data Model.
• Created logical data model from the conceptual model and its conversion into the physical database design using forward engineering in Erwin 4.0.
• Designed, Developed and Supported Extraction, Transformation and Load Process (ETL) for data migration using Informatica.
• Worked extensively in documenting the Source to Target Mapping documents with data transformation logic.
• Wrote User Stories fulfilling INVEST criteria, assisted the Product Owner in prioritizing the Product Backlog Items (PBIs) using techniques like Kano Model, Moscow and estimated Story Points using Planning Poker.
• Created Sprint Burndown and Release Burndown Chart to keep track of the team’s velocity and sprint progress for forecasting.
• Reduced risk and ambiguity by adding rigor to the Definition of Done and used domain knowledge and expertise to slice user stories based on business value.
• Facilitated all scrum ceremonies such as Sprint Planning, Daily Scrum, Sprint Review, Sprint Retrospective and Backlog Grooming.
• Shielded the team from various impediments and assisted the Product Owner in forecasting release plans by tracking the Team’s Velocity.
• Performed User Acceptance testing, verification testing and System testing manually.
• Involved in generating Test Plans and Test Specifications, prepared test data for positive and negative Test Scenarios as per system specifications and requirements.
• Designing and implementing quality control systems and processes for existing and new data management processes.

Environment: Waterfall-Scrum Hybrid, Erwin 3.5.2, Toad, PL/SQL, Oracle 9i, Informatica 7.1, BO 6.5/ XIR2, JIRA 5.2, Visual studio 2013, MS (Word, Excel, PowerPoint, Access), Tableau 8.3.

Confidential, Salt Lake City, Utah

Sr. Business Analyst

Responsibilities:

• Interacted with Subject Matter Experts in the Fixed Income Group, Portfolio Managers, Investment Advisors, Share Holders and IT Group Heads such as Project Managers, Developers, and Process Analysts to understand the business process, gather Business Requirements and identify enhancements.
• Performed Feasibility, Adaptability and Risk Analysis to identify business critical and high-risk areas of the application.
• Developed strategic partnerships with the business unit to develop a solid knowledge base of the business line, including the business plan, products, and process and revenue streams.
• Involved in creation and reviewing Functional Specifications and Project schedules.
• Authored the Business Document as well as High-Level Project Plan on the Project Scope.
• Designed and developed Use Case Diagrams, Activity Diagrams, Data Flow Diagrams using Rational Rose to define the Business Process and Data Process model.
• Facilitated Joint application development (JAD) sessions and walkthroughs between technical and regulatory teams for meeting requirements as well as solving problems on a daily basis classifying and documenting new change requirements, dealing with multiple product teams, researching delays, documenting errors and incorporating software enhancements into design documents.
• Worked closely with the UI team to model the screens and draw wire frames which met user defined requirements.
• Ported a trade reconciliation application from MS-Windows NT/MS-Access to UNIX, C++ and Oracle back end while achieving 400% performance improvement. The porting process included factoring out the program functionality in the business domain from the NT interface and MS-Access functionality, writing the Oracle asynchronous access layer and integrating all components into the application.
• Designed and implemented basic SQL queries for QA Testing and Report / Data Validation.
• Involved in creation and execution of Manual Test Cases in Mercury Test Director and automated Test Cases in WinRunner and analyzed the Test Results in the Mercury Test Director.
• Worked as a team with Developers and Process Analysts in preparing the requirements, and writing work flows, process flows. Interacted with system developers to resolve questions and discrepancies in Business Requirement Documents.
• Extensive interactions with the client and the management teams to understand the requirements and report the status of the testing efforts on their applications.
• Involved with the QA team to determine and develop test approaches and methods for unit testing, integration and functional/load/usability testing according to application complexity and test requirement.

Environment: Windows XP/NT/2000, Java, Oracle, SQL, PL/SQL, Rational Suite, MS-Project, MS-Office Suite, WinRunner, Load Runner 12.02, Bootstrap, Javascript, Angular JS, HTML, CSS3

Confidential

Business System Analyst

Responsibilities:

• Actively Involved in Pre-Analysis of project with SME (Subject Matter Experts) and Developers
• Conducted Gap analysis for ‘As-is’ and To-be of the process to identify and validate requirements.
• Participating JAD sessions with SME’s and multiple teams for requirement gathering and refinement.
• Analyzed the gathered requirement and reviewed Business Requirement Document (BRD)/Functional Specification Document (FSD).
• Created System Requirement Specification (SRS) document to describe all data, functional and behavioral requirement of the system.
• Used Share point for content management and document management.
• Wrote Use Case and built Use Case Diagram/ Activity Diagram using MS Visio.
• Created Requirement Traceability matrix (RTM) using HP QC tool.
• Used JIRA for allotting task and issue tracking, user story management and requirement traceability.
• Worked with QA team for designing Test Plan and Test Cases for UAT and regression testing.
• Tableau was used as a data visualization tool to communicate information clearly and efficiently via the statistical graphics, plots, information graphics, tables, and charts selected throughout the project

Environment: Wireframes, SQL Server, MS Word, MS Excel, MS PowerPoint, and MS Visio, HP QC, UAT Testing, SharePoint, ASP.net, Tableau, Ajax, XML, Web Server, HTML, CSS3, JIRA.

Confidential

Business Analyst

Responsibilities:

• Responsible for defining the scope of the project, gathering business requirements, doing gap analysis and documented them textually or within models.
• Interacted with the stakeholders by interviewing them, by preparing questionnaire and getting feedback.
• Gathered and documented the requirements that are critical to the business mission and used those requirements to design application software.
• Collected all requirements for generating account balance and transactions reports for a full year.
• Customize requirements for linking the card payment system to the centralized payment system.
• Used requisite pro to document requirements, associated change requests with requirements and connected requirements with use cases.
• Documented business workflows textually as well as in UML diagrams for the stakeholder review.
• Supported it unit creating functional specification documents for the design, development and implementation of strategic projects.
• Created use case scenarios, documented work flow and business process.
• Supported the assigned project manager with creating detailed project plans assisting in developing, scheduling and tracking project timelines.
• Analyzed and documented business requirements and detail design of the software for full understanding of the business.
• Conducted JAD sessions to allow different stakeholders to communicate their perspectives with each other, resolve any issues and come to an agreement quickly.

Environment: Waterfall, JIRA, MS Visio, SharePoint 13, Informatica Power Center, Tableau, MS (Word, Excel, PowerPoint, Access), Java, REST API, AJAX, HTML5, CSS3, JQuery, Java Script, JBoss Enterprise SOA Platform, JDBC, Oracle, JSON.

Confidential

Jr. SQL Developer

Responsibilities:

• Involved in creating logical and physical models using Erwin.
• Migrated data from heterogeneous data sources and legacy system to centralized SQL Server databases, which involved cleansing, data mapping and data conversion.
• Responsible for the end-to-end design, development and testing of assigned reports.
• Incorporating all the build rules, writing the code using SQL*PLUS, PL/SQL.
• Used SQL* Loader to load data into different tables.
• Involved in performance tuning to optimize SQL queries using query analyzer.
• Mapping Operational Repository to Business Repository elements and incorporating the build rules.
• For designing packages, stored procedures, functions and database triggers PL/SQL is used.
• Monitoring of statistics taken by the process, narrow down most expensive and long running queries to perform query optimization using SQL Server Profiler results and query plans.
• Extensively used PL/SQL to extract data from different tables with million records in some of the tables.
• Based on the user selection and finally storing the output as a flat file for further processing for the next module.
• Extensively used SQL & PL/SQL in reports.
• Identifying and automating repetitive tasks or processes to save time
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes

Environment: Waterfall, Oracle 8i, PL/SQL, SQL*Plus, SQL*Loader, Erwin, UML, Payment Processing, SQL Server, Rational Requisite Pro, Rational Rose, MS Office, MS Project, SharePoint 2007, HTML, CSS.