SUMMARY:

• Seasoned IT Professional with over 8+ years of work experience in roles such as Sr. Business Analyst & Scrum Master in domains such as banking, retail and education.
• Hands on work experience in Software Development Life Cycle processes such as Waterfall, Agile (Scrum), Hybrid of Waterfall and Agile methodologies.
• Working knowledge of industry standard methodologies such as Rational Unified Process (RUP), XP (Extreme Programing), Spiral and Kanban/Scrumban.
• Experience with Change Management, Risk management, Business Continuity Planning in waterfall methodology.
• Extensive knowledge of Business Process Re - Engineering (BPR), Business Process Improvements, Data Analytics along with experience in Discovery Sessions, Interviews, Joint Application Development(JAD), Focus Groups, Prototyping, Document Analysis.
• In-depth knowledge of Software Development Life Cycle (SDLC) that includes Requirement Elicitation, GAP analysis, Impact Analysis, SWOT Analysis, Cause & Effect Analysis, Cost Benefit Analysis, Risk Analysis, Feasibility studies.
• Experienced in writing User stories and handling the Requirement Churn in Scrum. Efficient in performing prioritizing techniques such as MoSCoW, KANO, Walking Skeleton, Validated Learning and Business Value Based.
• Extensive experience creating requirement artifacts such as Business Requirements Documents (BRD), Functional Specification Document (FSD), Use-Cases, UML, Data Mapping Document and System Requirements Specifications (SRS).
• Experience creating Requirement Traceability Matrix (RTM) to determine relationship by correlating baseline documents.
• Experience in successfully communicating with Subject Matter Experts (SME’s), Business Sponsors and Project Stakeholders.
• Used Web Content Accessibility Guidelines (WCAG) to develop through the W3C process in cooperation with individuals and organizations.
• Extensively used JIRA, Rally, Version One for generating Scrum Artifacts and User Story Tracking.
• Facilitated Sprint Ceremonies (Backlog Grooming/Story Time, Sprint Planning, Daily Scrum, Sprint Review and Sprint Retrospective) for Agile Scrum Methodology as Scrum Master. Created and maintained Scrum Artifacts such as Sprint Burn-down Charts, Sprint Tasks, Sprint Backlogs, Product Backlog Item (PBI), Product Backlog, Release Burn-down Chart.
• Extensive experience in employing Estimation techniques such as Planning Poker, T-shirt sizing, Relative Mass Evaluation.
• Experience creating Business workflows and Unified Modeling Language (UML 2.0) diagrams including Use Cases, Sequence Diagrams, Data Flow Diagrams, Activity Charts and ER Diagrams (Entity-Relation Diagram) using Rational Rose, MS Visio.
• In-depth experience in creating customer centric ad-hoc reports, story points and dashboards using Tableau.
• Experience using QC tools such as HP Quality center/ HP ALM. Experience reviewing Test Cases, Test Plans, Test Scripts, Test Analysis Reports, UAT Test Cases, UAT Test Plans and Test Scenarios.
• Expertise in documenting process models by Business Process Modeling (BPM) software such as TIBCO.
• Good Understanding of Project Management, proficient with Project Management Tools, Testing and Defect Reporting Tools.
• Knowledge of Databases, Data Warehouse, Data Table Structures, Schemas (Star, Snowflake, Galaxy/Multi-Star), Data Marts, ODS, OLTP and OLAP.
• Experience in working on projects with eliciting and converting business functionalities into Service Oriented Architecture (SOA) models. Knowledge of programing languages such as SQL, JavaScript. Experience working with Three-Tier architecture/n Tier Architecture, J2EE.
• Experience in projects involving Web Services. Conceptual Knowledge of SOA, SOAP, WSDL, REST, HTTP, XML DTD’s, XML Schema, Database Adapters, JDBC and ODBC. Assisted in creating XML Tags and validating Request and Response XML.
• Knowledge of MVC (Modeler, Controller and View) architecture, SOAP and HTTP Request and Response.
• Gathered business requirements and ensured correctness and completeness of Client Side and Server Side Validations .
• Experience working in all stages of ETL (Extract Transform and Load) ; Knowledge of Pipelined and Multistage Transformation .
• Assisted Data Analyst during Data Profiling to ensure Data Integrity using Informatica Data Quality (IDQ).
• Created Data Mapping Documents using Mapping Manager. Understanding of Mapplets, Transformation Logic, OLAP cubes, Facts in Fact Table, Hierarchy in Dimensional Lookup Table; Worked with Slowly Changing and Fast Changing Dimensions.
• Extensively used SQL Queries including JOIN, Nested Queries, Data Triggers and Constraints to ensure Data Integrity.
• Worked with Data Migration team for source system exploration. Also worked with ODS (Operational Data Storage), Staging Area and OLTP (Online Transactional Processing) systems. Experience creating Ad-Hoc reports using Tableau, IBM Cognos.
• Created of ER Diagrams, Conceptual Data Models using tools such as Enterprise Architect, MySQL Workbench.
• Knowledge of different types of OLAP cubes such as HOLAP, ROLAP and MOLAP. Hands on experience in OLAP Cube operations such as Roll-up, Drill-down, Slice, Dice and Pivot. Successfully gathered requirements for OLAP cube dimensions and measures.
• Facilitated Black-Box Testing, Functionality Testing, System Testing, Integration Testing, Regression Testing, User Acceptance Testing (UAT), Load, Stress and Performance Testing.
• A dedicated team player, with proven track record in producing high quality work under tight deadlines

TECHNICAL SKILLS:

SDLC Methodologies: Waterfall, Hybrid Waterfall-Scrum, Rational unified Process, Scrum, Extreme Programing, Kanban

Project Management Tools: Unified Modeling Language (UML 2.0), MS-Project, MS Share Point, Rally, JIRA, Clarity,Version One, MS Visio, Erwin, Enterprise Architect, IBM Rational Requisite Pro

Requirement Management: JIRA, Confluence, HP ALM 11.5, MS Office (Word, Excel, Power Point, Access, Project),Share Point, TIBCO, IBM Rational DOORS

Reporting Tools: Tableau, MS office Suite, IBM Cognos, Spotfire, SSRS

Database: Teradata, SQL Server 2000/2005, Oracle, IBM DB2

Office Tools: MS Word, MS Excel, MS PowerPoint, MS SharePoint 2013, MS Project, MS Visio

Testing Tools: HP QC, HP ALM 11.5, Soap UI, SeleniumHQ

ETL Tools: Informatica, SQL Server Data Tools-Business Intelligence (SSDT-BI), SSIS

Languages: HTML, CSS, XML, SQL, Excel- Macros, VBA and Java

Defect Tracking tools;: JIRA, HP ALM, HP QC

Data Warehousing: Data Modeling, Data Marts, OLTP, OLAP, Cube operations such as Slicing, Dicing, Drill Down, Roll Up, Pivot, ODS, Informatica Data Quality, ETL, Mapping Manager

Graphical Tools: Mock-Up Screens, Wireframes, Balsamiq

PROFESSIONAL EXPERIENCE:

Confidential, Cincinnati, OH

Sr. Business Analyst

Roles &Responsibilities:

• Knowledge of the Dodd-Frank Act, the Bank Secrecy Act, FinCEN and Sarbanes-Oxley Act.
• Conducted GAP Analysis to derive requirements for AML surveillance system.
• Used software methodologies including Agile (Scrum).
• Organized and Conducted the JAD team sessions and the weekly sessions from requirement gathering to sign-off of the application after testing.
• Developed a vision plan that defined AML policies and procedures are primary goals of the project.
• Elicited demands from the stakeholders and analyzed them for consistency, completeness and flexibility.
• Interacted with SME’s, asking detailed questions and carefully recording the requirements in a format that can be understood and reviewed by both technical and business people.
• Designed conceptual data models and conducted normalization, de-normalization of data; Used OLAP cubes for Slicing and Dicing, Roll Up, Drill-down operations for analytical decision making support.
• Worked on Service Oriented Architecture (SOA), SOAP, XML; Used AJAX and JavaScript for validations and integrating business server side components on the client side within the browser.
• Involved in Data Mining using SQL Queries to analyze the data for business needs and check Data Integrity.
• Facilitated end user training sessions, Scrum Workshops and Sprint Zero to guide scrum development on Agile Practices.Conducted Story Writing Session with the Product owner and Scrum Development Team; Also defined Definition of Done, Definition of Ready and Acceptance Criteria for the Agile project.
• Created User Stories and led the Planning Poker game to estimate complexity in Sprint Planning /Backlog Grooming meetings.
• Facilitated Scrum Ceremonies (Sprint Planning, Stand up meeting, Sprint Review and Sprint Retrospective).
• Assisted Product Owner with prioritization of the user stories using Relative Mass Evaluation, KANO and MoSCoW Techniques.
• Tracked and updated Agile Team’s velocity and facilitated self-organization by creating Sprint Burndown Chart and Product Burndown Chart/ Release Burndown Chart; Enforced Time Boxes and Supported the Agile team by resolving impediments.
• Ensured User Stories were written as per INVEST criteria; Conducted Scrum Workshops to encourage team adapt Scrum.
• Involved in Test Planning, Test Preparation, Test Execution and Issue Resolution and Test Analysis Report generation to assure that all aspects of a project are in compliance with the business and regulatory requirements.
• Logged and tracked the defects in HP ALM and created an RTM and managed the testing process with the QA team.
• Defined Acceptance Criteria for User Stories to perform User Acceptance Testing. Designed Test Cases, Test Plans, Test Scripts, and Test Scenarios; Extensively used RALLY throughout the project.
• Handled Requirement churn during the project by performing Impact Analysis by checking the feasibility in maintaining the Triple Constraint and discussing them in Daily Scrum.
• Created Deployment Flow Chart, Data Dictionary, Meta Data Registry and Data Mapping Document.
• Create ad-hoc reports and assist in data analysis to Quantitative research team and trade desk support analysts
• Identified expected and unforeseen data complexities to mitigate their impact on the analytic outcome and business decisions.
• Created Dashboards and ad-hoc reports using Tableau. Extensively used OLAP cubes to retrieve analysis from data warehouse.
• Proven record of Team Management, Project Management, Conflict Management and Leadership Skills.
• Conducted knowledge sharing sessions, created training materials for the scrum development team and other scrum masters.

Environment: Scrum Agile, Tableau, MS Visio, MS Project, MS office, UML, SCRUM, Fraud management, Money Laundering, SQL version 2014, JIRA, Kanban, Oracle, Tableau Desktop, MS Office Suite (MS word, MS Excel, PowerPoint), MS Project, Rally, SharePoint Version 2013.

Sr. Business Analyst

Roles &Responsibilities:

• Responsible for continuous process improvement and for identifying and maintaining a clear and measurable Development Process that is deployable throughout the enterprise-usingScrum.
• Analyzed prior documents and Gathered Business Requirements, analyze data/workflows. Defined the scope, financial projections and Cost/benefit analysis. Progressed from Problem Statement to well-documented designs.
• Conducted various requirements gathering through research, formal-informal sessions, and JAD sessions with SMEs (Subject Matter Experts), Teams, and Stakeholders.
• Assisted Project Manager in creating proposals and project budget allocations and worked on Project Charter and Work Break down Structure using MS Project.
• Prepared Business Requirement Documents (BRD) and Functional Requirement Document (FRD). Decomposed BRD into User Stories by conducting a story writing session with product owner and user Acceptance Criteria for PSPI(Potentially Shippable Product Increment).
• Facilitated Scrum Events like Backlog refinement, Sprint Planning, stand up meeting, Sprint Review and Sprint Retrospective.
• Helped to prioritize user stories using MoSCoW,KANO approach and estimate user stories using Planning Poker technique.
• As Scrum master tracked team velocity and Sprint progress using Sprint Burn Down Chart and Product Burn Down Chart, conducted time boxed daily scrum meeting.
• Engaged Scrum teams and programs SME’s to understand communicate status, priorities, risks and issues.
• Managed and monitored various scrum events through agile delivery process, worked closely with project manager, product owner and stakeholders to ensure their expectations are met.
• Highly proficient in writing User stories, creating Use Cases, Use case diagrams, Workflow Diagrams, Sequence Diagrams, and Class Diagrams etc. Extensively usedMS Visio for UML.
• Assisted Project Teams in preparing Software Requirement Specifications (SRS), Software Design Documents (SDD), User Interface Design, designing of Application Architecture & Database Modeling.
• Expert in Tracking and Managing the Requirements using Requirement Traceability Matrix (RTM) that controls numerous artifacts produced by the teams and I also handled requirement churn.
• Involved in 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 Requirements.
• Supported scrum team by resolving impediments such as the offshore testing team impediment.
• Analyze Business Requirements from Black Box testing perspective. Reviewed Test Strategy and Test Plans to ensure that test cases reflect user needs for the functional, User Interface, Performance, Usability and Security requirements.
• Establish Incident Reporting and Change Control procedures.
• Designed data models and conducted normalization and de-normalization of data to fit OLTP and OLAP frameworks, slicing and dicing of data marts for analytical decision making support.
• Experience in Extraction, Transformation and Loading (ETL) using Informatica.
• Logged and tracked the defects using JIRA. Created an error repository and managed the testing process with the QA team
• Assisted in the creation of deployment flow chart in conjunction with development, infrastructure, and network teams containing information for maintaining Application.
• Tracked requirement for the software application using HP ALM and verified adherence to Requirement Traceability Matrix (RTM).
• Assisted UI team in gathering requirements and validating completeness and correctness of Client Side Validations.
• Identified important entities, attributes and cardinalities and Used MySQL workbench to create a Conceptual Data Model .
• Assisted ETL team in creating Data Mapping document to accurately map attributes of source system to target repository.
• Identified Entities and Relationships (Association, Aggregation, Composition, Specialization) to create ER diagrams using ERwin.
• Used XML Spy to modify and update XML Nodes and create XML Schema. Used SQL Queries to fetch data from databases.
• Used JIRA for issue tracking, user story management, requirement traceability and creating Sprint Burndown Chart.
• Developed reporting metrics/ dashboards to capture maturity of maturity of scrum teams and promote transparency.
• Proven record of Team Management and Leadership skills.

Environment: SDLC, Agile Scrummethodology, MS project, MS office Tools (Word, Excel, PowerPoint, Share Point and Visio), Oracle, MS Project, MS Visio, SQL, UML, Informatica power center(ETL), User stories and JIRA.

Sr. Business Analyst

Roles &Responsibilities:

• Interacted with users and stakeholders to identify business needs, evaluated solutions for business problems.
• Conducted Joint Application Development (JAD) sessionswith Subject Matter Expert (SME) sessions.
• Conducted interviews, written correspondence, reports, implementation requirements, project status reports, oral presentations and email, to keep executive staff and team members apprised of goals, project status, and resolving issues and conflicts.
• The methodology used for the project was Waterfall and possess a deep understanding about the requirement gathering.
• Provided clear and consistent information about project status both internally, IT team and stakeholders.
• Worked with production staff to identify and map detailed current processes, identify gaps and failure points, perform root cause analysis and develop functional requirements that supported overall strategy, goals and objectives.
• Elicited and documented Functional requirements, business requirements AS-IS and TO-BE business process models.
• Played a key role in the planning, testing, and implementation of system enhancements and conversions.
• Used ETL to map data and assemble data repository and created data marts.
• Assisted in the implementation of enterprise data warehouse with individual data marts to address areas of business interest.
• Assisted with SNOW-flake schemas in the dimensional model architects to providing business rules.
• Understand the Software Development Life Cycle and experience in system architecture mapping.
• Documented business rules and workflows using Business Process Modeling Notation (BPMN) Version 2.0. Created models using Rational Rose and MS Visio.
• Designed and developed all Use Cases and UML models using MS Visio.
• Proficient in creating Use Cases, Sequence Diagrams, Collaboration Diagrams, Activity Diagrams, and Class Diagrams.
• Designed Test Plans and Test Cases for User Acceptance testing (UAT), Regression, and Black Box and White box testing with the help of QA teams.
• Assisted the Project Manager in setting realistic project expectations, in evaluating the impact of changes.
• Establish Incident Reporting and Change Control procedures.
• Developed timelines for project delivery, and managed projects and resources to successful completion.

Environment: SDLC, Waterfall, MS project, MS office Tools (Word, Excel, PowerPoint and Visio), MS Project, BPMN Version 2.0, data warehousing, Oracle, ETL (Informatica & tableau) IBM rational doors NG.

Business Analyst

Roles & Responsibilities:

• Comprehend and analyze the business case for the project and conducted GAP Analysis to understand the limitations of the existing system and contributed to the design of the future system.
• Worked with the Product Owner, SME’s and project stake holders to better understand the project scope and business value. Performed document analysis to derive business rules from legacy system and validated them. Helped PO and PM in ROI Analysis, Cost-Benefit Analysis and SWOT analysis in order to be prepared for potential business and technical risks to the system and to check the compatibility.
• Gather, analyze, and document high level business requirements from the business owners and stakeholders by using different elicitation techniques like JAD Sessions, Interviews, Job-Shadowing and Brainstorming Sessions.
• Created artifacts like Business Requirements Document (BRD), Functional Requirements Document (FRD/LLD).
• Helped in preparation of System Requirements Specification (SRS) to enable the development team to have a better understanding of the requirements and business needs.
• Involved in the Business Process Modelling (BPM) and designed business models using UML diagrams - Use Case, Sequence diagrams and Activity diagrams and ER diagrams in MS Visio.
• Created mock up screens and wireframes for better visualization of the system using Mock Up Screens.
• Effectively manage change by deploying change management techniques such as Change Assessment and Impact Analysis and establish Change Control procedures
• Wrote test cases, test plans, and test scenarios and traceability matrices used by the Quality team; User Acceptance Testing issue log for tracking the defects in JIRA and collaborated with system users to conduct UAT.
• Led the User Acceptance Testing (UAT) efforts, and opened/closed defects on QC.
• Extensively assisted in designing the database schema as well as scripted complex SQL queries using DDL and DML commands for database operations and generated ad-hoc reports writing ad-hoc SQL queries using joins to fetch data from the Microsoft SQL Server database to see historical business performance.
• Perform data profiling and match business requirements to the sources of data within systems to cleanse the data and ensure the data quality issues that must be corrected in the source system by using data flux tool.
• Involved in preparing data mapping specifications from source to target and defining transformation, business and logical rules by using SSISAssisted in modeling data-mart using Erwin data modelling tool for the further OLAP analysis. Assisted in Extraction, Transformation and Loading (ETL) using SSIS.
• Worked on the database to upload the files on the internal server using SQL server.
• Logged and tracked the defects using HP Quality Center by creating an error repository and managing it.
• Active part in the testing of the system during Unit testing, Black Box testing, Regression Testing, System Testing
• Used SharePoint as Content Management System for maintaining documents available across the organization.
• Created Requirement traceability matrix (RTM) in excel and then use that in JIRA to map all the Task ID of a particular requirement for tracing the test cases back to the requirements.
• Used SSRS to generate internal reports to study and analyze the planned interfaces.

Environment: MS Office, MS Project, MS Visio, Clear Case, Oracle, UML, Test Director, SQL version 2012

Business Analyst

Roles & Responsibilities:

• Elicited business requirements for the project using interviews, document analysis, surveys, site visits, use case scenarios and also used standard template of the organization to develop requirements.
• Conducted Joint Application Development (JAD) sessionswith Subject Matter Expert (SME) sessions.
• Maintained and build relationships with stakeholders to ensure their performance management and business analysis needs are understood and supported.
• Elicited and documented Functional requirements, business requirements AS-IS and TO-BE business process models.
• The methodology used for the project was Waterfall.
• Provided clear and consistent information about project status both internally, IT team and stakeholders.
• Responsible for creating UML diagrams (Use Cases, Activity Diagram and Class Diagram) in order to capture the dynamic behavior of different applications.
• Documented business rules and workflows using Business Process Modeling Notation (BPMN) Version 2.0. Created models using MS Visio.
• Developed Use Cases, Activity Diagrams and Sequence Diagrams for a clear understanding of the vision document.
• Designed Test Plans and Test Cases for User Acceptance testing (UAT) with the help of QA teams.
• Prepared Business process models; used Visio to create process flow diagrams for management and mapping the logical aspects of the process.
• Created the following types of documents mainly: Functional Requirement Specification (FRS), Functional Test Summary, Chance Control Documentation and Validation Specification.
• Prepared Requirement Traceability Matrixand interacted with QA team to ensure quality of software.
• 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.

Environment: SDLC, IBM Requisite pro,MS project, MS office Tools (Word, Excel, PowerPoint and Visio), MS Project, MS Visio,UML.

Junior Business Analyst

Roles & Responsibilities:

• Interacted with users, stakeholders and various business users to understand the AS-IS & TO-BE business condition to identify business needs, worked with SME’s of different groups to gain detailed knowledge.
• Elicited requirements using various techniques like formal & informal interviews, one on one sessions with stakeholders, brainstorming sessions, Conducted JAD sessions and facilitated discussions to bring about clear and refined requirements.
• Efficiently translated the business requirements into technical specifications to be understood by the development team, validated and analyzed the requirements and put them in the right format like SMART.
• Proficient in documenting the various requirement s artifacts like BRD,SRS,FRD functional Requirements Document (FRD).
• Waterfall were used in acute functionalities to design, document and manage requirements throughout the life cycle of the project, including definition, design and testing phases.
• Identified all necessary Business Use Cases from requirements, created UML Diagrams like activity diagrams, sequence diagrams and use case diagrams.
• Created the various work flow diagrams and business process models for better understanding of all the stake holders
• Created various prototypes l ike mock ups and wireframes using balsamiq and mockup screens to give an enhan ced idea to the stakeholders about the look and feel pf the interface.
• Worked as a team with other business analysts to make an object oriented model and created use cases.
• Analyzed Business Requirements Document (BRD) and used Microsoft Project to manage schedules, deadlines, and resources and collaborate on the project.
• Assisted the QA team in designing the test plans, test cases and test scenarios successfully facilitated user acceptance testing, functional testing, blackbox testing and regression testing
• Conducted weekly sessions to keep all the business users and stakeholders updated about the progress and track of the project and to address any change in requirements and get relevant feedback to keep the development going smoothly.
• Served as a proactive liason between all stakeholders involved to keep the project moving ahead at a fast pace, and making sure all requiremnts are being duly met.
• Proposed better business ideas and business process re-engineering to thrive better ideas and understanding and evolving better techniuques.

Environment: MS Office, MS Project, MS Visio, Clear Case, UML, Oracle, Test Director, SQL version 2012.

Junior .Net developer

Roles & Responsibilities:

• Developed solutions for diverse programming scenarios in C#, employing object oriented programming concepts such as: encapsulation, inheritance, polymorphism and Abstraction.
• Used C# and ADO.NET to define and implement secure middle-tier components using both connected and disconnected environment strategies.
• Components were consumed by web applications and windows application utilizing SQL Server and stored procedures to perform logical business transactions.
• Created and Deployed XML Web Services using ASP.NET and Web Services Enhancements(WSE).
• Consumed Web Services from both Windows forms and ASP.NET web Applications.
• Created complex business components in C# using .NET Class Library assemblies while migrating and implementing them in a multi- tier environment suitable for .NET Remoting, XML Web Services, Microsoft Transaction Server (MTS) and COM+ to address application infrastructure issues associated with building scalable enterprise level applications used by many clients.
• Developed web presentation layer using HTML according to WCAG standards and guidelines
• Developed ASP.NET user controls/ Classes using C#. Developed class libraries to implement the business rules.
• Used CSS for GUI design and extensively used JavaScript for client side validation. Customized Menu, Label, Toolbar, Data Grid Columns Using Custom Controls.
• Assisted in the documentation necessary for publishing the web service.
• Assisted the Senior Developer in creation of Instance Diagrams
• Writing stored procedure and triggers at the back end. Deployment of Application on Test and Server and testing of application. Optimized data access statements for more performance and efficiency.

Environment: ASP.NET, C# Web Forms, PL/SQL, ADO.NET, Oracle, WCAG, IIS, XML, XSLT, Visual Studio 2008, SQL SERVER 2000, Windows XP, HTML, JavaScript.