SUMMARY

• Seasoned IT professional with 8+ years of global experience in techno - functional roles across various domains including Financial Services, E-commerce, and Banking etc.
• Served as a Sr. Business Analyst, Scrum Master and Junior Business Analyst roles; and proven ability leading cross-functional and self-organizing teams in various business settings.
• Expertise as a liaison between technical team and management, change agent and a servant leader with an ability to communicate technical information to non-technical stakeholders. Experienced in mentoring the team and providing business value oriented conflict resolution.
• Experienced in mentoring the team and providing business value oriented conflict resolution.
• Adapt to ever-changing situations and skilled in conducting GAP Analysis (AS-IS and TO-BE analysis), Risk Analysis, Cost-Benefit Analysis, Root-Cause, Feasibility Study and SWOT Analysis to assist Product Owner and Project Manager in planning.
• Expertise in eliciting & gathering Business requirements, Business Process Re-engineering (BPR), Business Process Modeling (BPM), Data Analysis, System analysis and work-flow analysis.
• Worked with the Business Owners to identify a Risk Response Strategy based on the Positive and Negative Risks associated with the project.
• Assisted in creating a Risk Management Plan for identifying, assessing and monitoring different kinds of risks.
• Skilled in conducting and facilitating Requirement Gathering Activities to gather SMART (Specific, Measurable, Attainable, Realistic and Timely) requirements using diverse elicitation techniques including, but not limited to, Requirement workshops, Interviews, Prototyping, JAD Sessions and Brainstorming.
• Well versed in authoring/reviewing Business Requirements Document (BRD), Functional Specification Document (FSD), Software Requirement Specifications (SRS), Use Case documentation and Data mapping document.
• Extensive knowledge and expertise in implementing various phases of Software Development Life Cycle (SDLC) in Waterfall, Scrum, Agile (Extreme Programming, Test-Driven Development) and Scrum-Waterfall Hybrid software development life cycle environments.
• Extremely skilled as a Scrum Master in facilitating scrum process and Scrum Ceremonies including Daily Scrum, Sprint Planning, Sprint Review, Sprint Retrospective and Backlog Refinement meeting to improve team’s performance and handling team dynamics.
• Experienced in conducting Scrum Workshops and User Story Writing workshops to familiarize stakeholders with Scrum process skeleton and concept.
• Well versed with backlog prioritization techniques (MoSCoW, Business Value, Kano, And Technical Risk) and estimation techniques (Planning Poker and T-shirt sizing) to help product owner in picking Product Backlog Items (PBIs) to commit to in the iterations (Sprints)
• Proficient in handling Requirement Churns by performing Impact Analysis.
• Experienced in handling teams in Offshore/Onsite model and good communication skills (written and oral) to ensure seamless service delivery.
• Understanding of customizing standard Salesforce objects like Accounts, Contacts, Opportunities, Products, Price books, Cases, Leads.
• Involved in gathering business rules and documenting them for creation of APEX triggers in Salesforce.com for configuring Web Services to integrate with SQL Server for synchronous data transfer.
• Experience in managing projects using exceptionally strong Organizational Skills, Analytical Skills, Problem Solving, Decision-Making, Leadership Skills and Conflict Management.
• Highly collaborative team player with extensive customer relationship skills, also possess excellent facilitation and mentoring skills and ability to prioritize tasks according to business needs.
• Experienced in SOA, Web Services, XML, REST, JSON, API, Client Side Validation and Server Side Validation.
• Expertise in preparing Test Cases, Test Plans, Procedures and Traceability Matrix and documenting defects using HP QC and HP ALM. Collaborated and monitored Black-Box Testing, Smoke Testing, User Acceptance Testing (UAT) and Regression Testing.
• Well versed with writing SQL queries to integrate and extract data for analysis and generating reports; can construct complex queries for data extraction and formulate meaningful insights and conclusion from the same.
• Thorough understanding of Data Modeling, Schemas and use of Business Intelligence (BI) and experienced in creating interactive, analytical dashboards using Tableau and IBM Cognos for decision making.

TECHNICAL SKILLS

SDLC Methodologies: Waterfall, Waterfall-Scrum Hybrid, Scrum Agile

Business Skills: Change Management, Impact Analysis, and JAD sessions, SWOT Analysis, Project Planning, Project Scheduling and Project Budgeting, HLD, LLD, Business Process modeling.

Project Management Tools: Object Oriented Analysis and Design (OOAD) using Unified Modeling Language (UML), MS-Project, MS Share Point Server (2013,2010,2007)

Requirement Management: MS Office, JIRA, VersionOne, HP ALM

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

Database: SQL Server, MS-Access, Oracle

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

Financial Tools: MS Excel function, Financial Statement Analysis, Oracle Financial Services Analytical Applications

Testing Tools: HP QC, HP ALM

ETL Tools: Informatica Powercenter, SSIS

Data warehouse: ETL, Slicing, Dicing, OLAP, MOLAP, Big Data, Data Marts, Data modeling, Data Profiling, Data Mining.

Languages: Java, .NET, Hadoop, HTML, XML, SQL, C++

Web Services: XML, Rest, JSON, API, Client Side Validation, Server Side Validation, AJAX

PROFESSIONAL EXPERIENCE

Confidential, STRONGSVILLE, OH

SR BUSINESS SYSTEMS ANALYST

Responsibilities:

• Analyzed the business process along with the prior project documentation for complete understanding of the project. Also, interviewed SME’s and CRO in order to better understand the business process and contribute in the business process re-engineering and optimization.
• Knowledge of the Dodd-Frank Act, the Bank Secrecy Act, FinCEN and Sarbanes-Oxley Act, Suspicious Activity Reports (SAR).
• Conducted GAP Analysis, Impact Analysis, Feasibility Study, Cost-Benefit Analysis to derive requirements for AML surveillance system.
• 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.
• Organized and facilitated the JAD team and in conducting the weekly JAD sessions from requirement gathering to sign-off of the application after testing and analyzed them for consistency, completeness and flexibility.
• Assisted on creating a vision plan that defined AML policies and procedures as primary goals of the project.
• Assisted on the development of the Project Charter Document and Work-Breakdown Structure (WBS) using MS Project.
• Prepared HLD and LLD - Business Requirement Document (BRD) and Functional Specification Document (FSD).
• Developed Use Case documentation for system requirements, business process flows, and screen mockups using MS Visio.
• Responsible for identifying and documenting business rules and creating detailed diagrams including Use Cases, Use Case diagrams, Business Flow diagram, Creating process models, Data flow diagrams.
• Lead a story writing session with an aim of decomposing the scope into epics and user stories with product owners using INVEST criteria. Also, worked on the acceptance criteria for the above developed user stories.
• As a Scrum Master, facilitated Scrum ceremonies including Backlog refinement, Sprint Planning, Daily Stand up meeting, Sprint Review and Sprint Retrospective.
• Analyzed the Sprint Burn Down charts, Product Burn down charts in order to calculate the team’s velocity and track sprint progress.
• As experienced Scrum Master anticipated and removed impediments (internal and organizational), outside interferences from project team’s path and pushed them to deliver quality results based on schedule.
• Used JIRA for issue tracking and user story management.
• Performed slicing and dicing of data marts in order to facilitate the analytical decision making process.
• Integrated various OLTP to OLAP by using Informatica as an ETL tool.
• Developed reports using Tableau to communicate information-using graphs, charts and other info graphical solutions to the project team.
• Assisted in Data Profiling and Data mining.
• Administered ETL Process and identified source table, target table and created the data mapping document using Informatica Powercenter.
• Assisted User Acceptance Testing (UAT). Also, created an error repository and managed the testing process with the QA team. Logged and tracked the defects using HP ALM.
• Created Requirement Traceability Matrix (RTM) in order to track test cases and test plans
• Assisted in User Acceptance Testing, developing and maintaining quality procedures, and ensure that appropriate documentation is in place. Assisted in Black box, UAT and Regression testing.
• Utilized MS SharePoint 2013 as Content management system for maintaining documents.
• Executed SQL query operation such as DML and DDL commands and also supervised the source to target mappings in Informatica Power Center.
• Performed SQL queries using JOINS and nested queries to fetch data from MS SQL Server.
• Communicated effectively across company contacts and clients, also internal team about the project requirements schedules and launches.
• Assisted the project manager to construct a project plan that included Project Schedules, Milestones tracking, and Meeting minutes using MS Project.

Environment: Scrum-Waterfall Hybrid, Tableau 8.0, Informatica Power Center, HP ALM 11.x, MS Visio, MS Project, UML, Fraud management, Money Laundering, SQL Server 2012, JIRA 6.1, MS Office Suite 2013 (MS word, MS Excel, PowerPoint), MS Project 2013, MS SharePoint 2013, HIVE, HDFS, Hadoop.

Confidential, FRAMINGHAM, MA

SR. BUSINESS SYSTEM ANALYST/SCRUM MASTER

Responsibilities:

• Analyzed the business process along with the prior project documentation for complete understanding of the project. Also, interviewed SME’s in order to better understand the business process and contribute in the business process re-engineering and optimization.
• Conducted GAP Analysis by understanding the as-is business process and to-be business process.
• Performed Impact Analysis, Feasibility Study, Cost-Benefit Analysis and Return on Investment (ROI) in order to mitigate certain risks associated with the project and project output.
• Conducted JAD sessions and interviews with key stakeholders and SME’s for requirements gathering.
• Assisted project manager in developing Project Proposals and performed project budget allocations.
• Assisted the project manager in project budgeting and resource scheduling, in order to optimize the utilization of the project resources using MS Outlook.
• Prepared Business Requirement Document (BRD) and Functional Specification Document (FSD).
• Developed Activity Diagrams, Sequence Diagrams and USE Case Diagrams with GUI components for the System Requirement Specification (SRS) document along with the screen designs using MS Visio.
• Lead a story writing session with an aim of decomposing the scope into epics and user stories with product owners using INVEST criteria. Also, worked on the acceptance criteria for the above developed user stories.
• Facilitated estimation and prioritization of the user stories by using MOSCOW and Planning Poker.
• As a Scrum Master, facilitated and conducted the Sprint Backlog Refinement Meeting, Sprint Planning Meeting, Daily Standup Meeting, Sprint Review and Retrospective Meeting.
• Portrayed as a Proxy Product Owner, to facilitate the Product Backlog Grooming meeting to reprioritize the PBI’s as per the business value.
• Created and maintained the Sprint and Product Burn Down Chart in order to calculate the team’s velocity and track sprint progress. This was then utilized for planning of the upcoming sprints.
• Resolved impediments faced by the scrum team at the team and the organizational level.
• Used SharePoint as Content Management System for maintaining documents.
• Assisted in creating the Data Mapping Specification.
• Collaborated with DBAs to perform data mapping and executed simple and complex SQL queries to verify the mapped data.
• Used Tableau to visualize the data about the visitors' behavior, and perform trend analysis, to develop reports in order to communicate information-using graphs, charts and other info graphical solutions to the project team.
• Assisted in developing screen mockups, and wireframes using Balsamic.
• Created UI prototypes for early feedback from the stakeholders about the usability of the UX experience.
• Integrated various OLTP to OLAP by using Informtica as an ETL tool.
• Assisted in User Acceptance Testing (UAT) in conjugation with the QA team. Also, created an error repository and managed the testing process with the QA team.
• UsedJIRAfor project andissue trackingandrequirement traceability.
• Extensive experience in creating Data Repository, Source, Target Database for Extraction, Transformation and Loading (ETL) Informatica.
• Worked on Service-Oriented Architecture (SOA), JSON, POX and API.
• Assisted QA team in creating Test Plan, scripting Test Cases and assisted in Regression Testing, Functional Testing and performed User Acceptance Testing (UAT) with different test scenarios and test cases using HP ALM.
• Created Requirement Traceability Matrix (RTM) in order to track test cases and test plans.

Environment: Scrum-Waterfall Hybrid, JIRA 5.2, SQL 2012, MS-Visio, UML, MS Visio, MS Project Professional 2013, MS SharePoint 2013, Java, Java Script, IIS, Informatica, MS Office 2013, Tableau 8.0, HP ALM 11.x, Apache Tomcat, GAP Analysis, Functional Testing, Regression Testing, WSDL, SOA, Data Mapping, ASP, Java, Node.js.

Confidential, LANSING, MI

SR. BUSINESS ANALYST

Responsibilities:

• Involved throughout the System Development Life Cycle (SDLC) methodology Waterfall.
• Gathered project requirements by implementing techniques such as JAD, Document Analysis, Requirements Workshops, and Interviews with Subject Matter Experts (SME) and stakeholders.
• Performed GAP Analysis and documented the gap between the existing system and desired system.
• Developed a high level Business Requirements Document (BRD) and Functional Requirements Specification (FSD) document and had them base-lined from the business owner.
• Performed Change Management by handling change requests by implementing change impact analysis on business and technical impacts, and getting the approval from the Change Control Board (CCB), to make the appropriate changes.
• Worked with GUI development, requirements creation/design to create the initial UI wireframes, and mockups. Developed Mockup screens and prototypes for the learner’s home page requirements document using Axure.
• Created Use Case document by specifying actors, normal flow, alternative flows for all use cases.
• Used HPALM for requirements gathering, and writing the associated test cases against the requirements.
• Worked with Subject Matter Experts to define User Acceptance Test scenarios and write the Test Plan.
• Created activity diagrams to represent the current state business process, context flow diagrams to identify the interfaces and the data flow of the system, and sequence diagrams to specify the order of interactions.
• Constructed Requirements traceability matrix to determine the source of the requirement, to ensure all requirements are met and to locate affected system components when there is a requirements change.
• Used MS Project Professional to manage schedules, deadlines, resources and the project tasks.
• Coordinated with the other business analysts for assisting the Data mapping process, and Data extraction and Integration to the data mart.
• Used IBM Cognos to perform various different visualizations (reports).

Environment: Waterfall, MS Project 2010, Informatica Powercenter, SQL 2008,Angular JS, MVC, MS Office 2007 (MS Word, MS Excel, MS PowerPoint), GAP Analysis, UML, IBM Cognos 10.1, HP ALM, MS SharePoint 2010, Axure 6.5.

Confidential, COLUMBUS, OH

BUSINESS ANALYST/ SCRUM MASTER

Responsibilities:

• Conducted GAP Analysis to understand limitations of the existing system and contributed to design of future system; assisted in modeling the AS-IS and TO-BE business workflow.
• Performed document analysis to derive business rules from legacy system and validated them with stakeholders for consstency and completeness.
• Worked closely with IT Operations team to understand and document the manual activities that are being performed during commission calculation process.
• Developed system integration with Salesforce and other business systems for data to be available for marketing team to perform their operations seamlessly.
• Involved in gathering business rules and documenting them for creation of APEX triggers in Salesforce.com for configuring Web Services to integrate with SQL Server for synchronous data transfer.
• Involved in providing hyperlinks for documents using Content Management System (CMS).
• Analyzed requirements wrote User Stories and managed Agile Lifecycle in JIRA from planning to sprint deployment. Tracked and communicated team velocity and sprint/release progress. Assisted in managing the Product Backlog and Sprint Backlog.
• Reviewed and assisted the team in functional testing of the application prior to demo in the sprint review meeting. Maintained the Sprint Burn down and Release Burn Down charts.
• Developed test scenarios/scripts, test plans, prepared user acceptance test cases (UAT), UAT issue log for tracking the defects in JIRA and collaborated with system users to conduct UAT.
• Developed use case documentation for system requirements, business process flows, and screen mockups using MS Visio.
• Managed other BAs and sent their status to Project Manager/Business owners on a weekly and monthly basis using MS Project. Worked on project planning, scheduling and status reporting.
• Served as liaison between the scrum team, architect and key stakeholders, earning their confidence with reliable follow-through.
• Generated ad-hoc reports writing ad-hoc SQL queries using joins and nested queries to fetch data from the Microsoft SQL Serverdatabase to see historical business performance.
• Exposure to Payment API’s.
• Instructed and modeled core agile principles of collaboration, prioritization, team accountability and visibility. Ensured consistent application of scrum methodologies across the team.
• Used SharePoint as Content Management System for maintaining documents and templates available across the organization.

Environment: Scrum Methodology, SQL Server Management 2008, JIRA 5.2, Visual Studio, MS Office 2007 (MS Word, MS Excel, MS PowerPoint), MS Project, SharePoint 2010, SOA, XML, Mock-up screens, .NET, ASP.NET, LINQ, HTML, CSS, C#. Net, Ajax Control Toolkit, Salesforce Summer’12.

Confidential

BUSINESS ANALYST

Responsibilities:

• Performed document analysis to derive business rules from legacy system and validated them with stakeholders for consistency and completeness.
• Conducted GAP Analysis to understand limitations of the existing system and contributed to design of future system; assisted in modeling the AS-IS and TO-BE business workflow.
• Worked with business and technical SME’s to develop thorough understanding of Applications, Systems, relational database, Business Methods and Strategies.
• Generated key statistics e.g. Defect reporting by application, performance usage, tasks estimating as well as time and task reporting.
• Performed Change Management by handling change requests and performing change impact analysis on business and technical side, and getting the approval from the Change Control Board (CCB), to make the appropriate changes.
• Created project plans, work breakdown structures (WBS) and identified & managed risks using MS Project.
• 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.
• Used various modeling techniques like data modeling, data flow diagrams, and UML diagrams for designing and developing the application.

Environment: Waterfall Methodology, HP Quality Center 11.0,Informatica, Tableau 6.0, ETL, Java/J2EE, JSP, Apache TOMCAT, API’s/Web Services, MySQL, Unix, WebLogic Application Server, Java, HTML, CSS, MS Office 2007 (MS Excel, MS Word, MS PowerPoint), MS Visio, MS Project, Mock-Up Screens, UML, MS SQL Server 2005, SharePoint 2007.

Confidential

BUSINESS ANALYST

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 in the Middle East industries.
• Conduct JAD sessions authored 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
• 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.

Environment: Waterfall, MS Visio, MS Office Suite, MS Access, SQL version 2012, Informatica, Outlook, MS Office

Confidential

JR. BUSINESS ANALYST

Responsibilities:

• Analyzed the business process along with the prior project documentation for complete understanding of the project. Also, interviewed SME’s and CRO in order to better understand the business process.
• Conducted interviews, brainstorming sessions and document analysis in order to understand and prepare a compliance document for the project team.
• Captained GAP Analysis by understanding the as-is business process and to-be business process.
• Conducted JAD sessions and one-to-one interviews with key stakeholders and SME’s for requirements gathering.
• Prepared Business Requirement Document (BRD) and Functional Requirement Document (FRD).
• Developed Activity Diagrams, Sequence Diagrams and USE Case Diagrams with GUI components along with the screen designs using MS Visio
• Created sample wireframes to make system better understood by Business and Technology Teams.
• Developed Test Plans, Test Scripts and maintained Master Test Plan. Also, performed User Acceptance Test (UAT) and System Integration Testing (SIT).

Environment: Waterfall, MS Visio, MS Office Suite, UML, Windows XP, HP Quality Center, MS Project