SUMMARY:

• Sr . Business Analyst with 8+ years of experience of working in Financial Services, Mortgage Loans, Credit Risk Management, Banking and E - Commerce
• Proficient inSystem Interface Analysis, Business Requirement Analysis, Business Process Improvement, requirements gathering & documentation and content management
• Extensive knowledge and exposure to various SDLC methodologies such as Waterfall, Agile-Scrum and RUP (Rational Unified Process) enabling precision in the delivery of requisite Artifacts pertaining to Requirement Analysis
• Analyze Functional and Non-Functional requirements and transform them into functional specifications by focusing on workflow analysis and design, user interface design, and process flow modeling
• Proficient in requirement elicitation and gathering techniques such as Prototyping, Interviews, Brainstorming and JAD sessions with end users, Subject Matter Experts (SME’ s) and stakeholders
• Proficient in creating documents like Business Requirements Document (BRD), Functional Requirements Specification (FRS), Software Requirement Specifications (SRS), Request for Proposals (RFP), Requirements Traceability Matrix (RTM).In addition,good understanding in preparing Responsible, Accountable, Consulted, and Informed (RACI) Matrix
• Worked on IBM Cognos Analytics, Atlassian Jira andHP Quality Center (HP QC) for Managing Requirements and Tracking Defects
• Extensive experience in conducting As-Is and To-Be analysis, Gap analysis, SWOT analysis, Impact analysis, Cost Benefit Analysis and Quantitative Analysis
• Strong expertise in using MS Visio and Rational Rose to create UML diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams, Data Flow Diagrams, Business Flow Diagrams and Sequence Diagrams
• Experienced in writing and reviewing Test Plans, Test Scenarios and Test Cases. Conducted different types of testing such as Black Box testing, Load Testing, Performance Testing and User Acceptance Testing (UAT)
• Practiced various tools for planning, tracking and managing projects such as HP Application Lifecycle Management (HP ALM), HP QC, Team Foundation Server (TFS) and MS Project Professional
• Facilitated Scrum processes and conducted scrum ceremonies such as SprintPlanning, Daily Stand-up, Sprint Review, Sprint Retrospective and Backlog Grooming
• Proficient in writing User Stories and handling the Requirements Churn. Efficient at prioritizing and estimating PBIs using different techniques like Planning Poker, MoSCoW etc.
• Involved in extensive client interactions and converting business functionalities into Technical functionalities
• Experienced in DataWarehouse Implementation including extraction, transformation and loading (ETL) data from various sources into data warehouse and Data Marts. Exposure to Informatica tool to perform ETL operation
• Performed various operations such as Roll-up, Drill-Down, Slice, Dice and Pivot by using various tools such as Tableau, IBM Cognos and QlikView
• Directed teams and participated in Data Visualization, Business Intelligence, Business Analytics, Statistical Analysis and Data Mining.
• Performed rigorous data analysis by writing complex, nested and joint SQL queries.
• Ability to work independently and in teams to meet business deliverables with a result-oriented approach
• Strong communication, analytical, interpersonal and presentation skills to perform well in individual or team setting under demanding situations.

TECHNICAL SKILLS:

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

Modeling Tools: Rational Rose, MS Visio, MockupScreens, Wireframes

Requirement Management: MS Office, JIRA, TFS, Rational, ClearQuest

Project Management Tools: HP ALM V11.5, MS Project, MS SharePoint v2007/2010

Testing Tools: HP QC v10.0, Load Runner

Financial tools: MS Excel functions and pivot tables, Financial Statement Analysis

Data Warehouse/Reporting Tools: Informatica, Tableau, Spotfire, QlikView

Databases Tools: MySQL, MS SQL, MS Access

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Sr. Business Analyst/Scrum Master

Responsibilities:

• Review agency practices and methodologies to recommend new methods and assure casework contact 95% compliance standard
• Identify process improvements and organizational changes that creates agency wide impacts on performances
• Evaluate and document agency business practices by conducting quarterly visits, interviews with executives, supervisory and quality assurance staff to identify the root causes of obstacles to work performance
• Conduct meetings with key business users to collect information on business processes and user requirements
• Assess the impact of current business processes on users and stakeholders
• Utilize problem-solving skills to analyze and resolve issues that affected business operations and goal achievement
• Document business processes and analyzed procedures to see that they would meet changing business needs
• Collaborate on all stages of the systems development lifecycle, from requirements gathering to product releases
• Review quality of Connections progress notes and FASP reports to insure Safety, Risk and Assessments are done regularly
• Create, sort, filter and process daily/weekly data analyst reports for agency review in Cognos Data Warehouse
• Monitor & assist in NYTD (National Youth & Transition Database) to insure Education, Tribal Affiliation, Independent Living Services and Surveys are met to compliance standards for each youth
• Monitor & generate monthly activities reports using MS Excel
• Assisted in the planning of new Voluntary Agency Review (VAR) Model
• Participate in monthly COFCCA Foster Care Accountability Committee meetings with OCFS, ACS and Voluntary Agencies to discuss Case Work Contacts related issues and resolution
• Manage the operational process of voluntary agency review database
• Reviewed cases for Voluntary Agency Review and filled out module to report out the findings
• Participate in the conference call for the Casework Contact Monthly Meeting with the home office in Albany

Environment: MS Office (MS Word, MS Excel, and MS PowerPoint), MS SharePoint, IBM Cognos, MS Access

Confidential, Somerset, NJ

Sr. Business Analyst/Scrum Master

Responsibilities:

• Held meetings with Subject Matter Experts (SME’s) for pre-analysis and requisites of the project
• Conducted high-level requirement gathering and elicitation sessions with Business Owners via JAD Sessions, Interviewing, Prototyping and Brainstorming Sessions
• Translated technical issues which involved breaking down technical and architectural complexities so that project stakeholders can easily understand any issues that crop up, explanation based on schedules and estimates
• Created Business Requirement Documents (BRD) and Functional Requirement Documents (FRD)
• Proactively participated in document-reviews, plan setup, plan configuration and incorporated them in Business process re-engineering, Business process improvements, Business process modeling using activity and swim-lane diagrams
• Assessed business priorities and advised business units on risks by doing Cost-Benefit analysis
• Created Use-Case Diagrams, Sequence Diagrams, Activity Diagram and Class Diagrams using MS Visio
• Created Mock-up Screens and Wireframes using UI Components such as Radio Buttons, Drop-down and Check boxes
• Performed data mining and data analysis to analyze historical data
• Captured and documented best practices, performed content management and organized knowledge transfer sessions for team members
• Designed data models and conducted normalization and de-normalization of data to fit OLTP and OLAP frameworks respectively. Slicing and dicing of data marts for analytical decision-making support
• Assisted the product owner in managing business users and sponsor’s expectations on project deliverables with managing stakeholder communication and implemented effective systems of project governance
• Estimated PBI’s effort using Planning Poker Techniques and to decompose epics into user stories based on INVEST
• Used JIRA for drafting the User Storiesand managing the requirements. Logged & tracked the defects and managed the testing process with the QA team
• Helped the Product Owner to prioritize the Product backlog items (PBI’s) using MOSCOW and KANO model. Responsible for 3 C’s (Card, Conversation and Confirmation) of the scrum process.
• Facilitated the SCRUM ceremonies (Sprint Planning Meeting, Daily SCRUM Meeting, Sprint Review Meeting, Sprint Retrospective Meeting, and Product Backlog Refinement Meeting)and enforced time boxing
• Created and maintained SprintBurn-down Chart and Release/Product Burn-Down Chart to keep the track of the process progress and the velocity of the sprints
• Worked with Product Owner to review the Potentially Shippable Product Increment (PSPI) during review meeting and helped deciding which features are done and satisfies the acceptance criteria
• Helped the team to maintain velocity and worked on completing story points in each sprint
• Reviewed and executed Test plans, Test casesand User Acceptance testing (UAT)
• Used SQL Server to design, implement and manage data warehouses OLAP cubes and reporting solutions to improve data centre services
• Documented the User Manual and trained the end users for the application

Environment: Waterfall-Scrum Hybrid, Wireframes, MS Office (MS Word, MS Excel, and MS PowerPoint), MS Visio, UML, JIRA, Informatica, SQL, Web Services, SOA, SOAP, XML, HTML, Tableau, JAVA

Confidential, Philadelphia, PA

Sr. Business Analyst/Scrum Master

Responsibilities:

• Conducted GAP Analysis by understanding the AS-IS business process and TO-BE business process
• Used MS-Visio for creating high-level process flow and screen flow diagrams for management and mapping the logical aspects of the process
• Defined the UI with inputs from the data architect and developers for the standardized claims system using HTML models and mockup screens
• Wrote down all the requirements in the form of user stories and prioritized them in the product backlog with the help of product owner
• Used JIRA for allotting task and issue tracking, user story management and requirement traceability
• Wrote Business rules for the verification of valid bank statements
• Facilitated all the scrum ceremonies, namely: Sprint Planning meeting, Daily Stand-up Meeting, Product backlog refinement meeting, Sprint Review meeting and Sprint Retrospective meeting
• Resolved impediments during the entire project life and responsible for handling requirement churn
• Drafted and updated the sprintburn down charts and tracked the velocity and the sprint progress
• Dealt with an offshore testing team. Coached and mentored the team to follow the agile principles and increased level of self-organization. Encouraging collaboration between the Scrum team, product owner and ensure the on-time quality delivery
• Managed the overall application lifecycle and tracked the progress of the project by using HP ALM
• Involved in developing test strategies and assisted in developing test scenarios, test conditions and test cases
• Conducted User Acceptance Test (UAT) along with writing test plans and test cases using HP ALM
• Used SSIS to map the data in a central data repository and created data marts for end users to verify the applicant’s bank statements and used SSRS for generating final reports for the underwriter or end user
• Understood the requirements of Process Server Database application, researched the latest bar scanning technologies and gave a presentation to the business user so that the estimation of the project feasibility, bar coding scanning technology and business process re-engineering can be ascertained on high level
• Created an automated ETL summary report which consists of the summary information for all the loading activities done each day and month
• Used basic SQL queries to validate business rules and data mapping
• Optimized the performance of queries with modification in SQL queries, normalized tables, established joins and created indexes wherever necessary

Environment: Agile-Scrum, Microsoft SQL, Microsoft Business Intelligence Development Studio(SSIS, SSRS), MS Visio, .Net HTML, XML, MS Office Suite, MS SQL Server, UML, MS Visio, MS Project, MS SharePoint, HP ALM, ETL, JAVA

Confidential

Sr. Business Analyst/ Scrum Master

Responsibilities:

• Utilized knowledge of Fixed Income Securities, Stock, Interest Rate Derivatives (Interest Rate Swap, Interest Rate Cap/Floor), Options, Commodity Futures, Mutual Funds and Portfolio Management
• Helped conduct Market Research, Feasibility studies, Systems analyses, GAP analyses and Risk analyses
• Processed the information related to Fixed Income, Risk Management, Profit and Loss (P&L), Compliance, Reporting trade execution
• Assisted the Project manager in scope definition, risk identification, project methodology, resource allocation and facilitation
• Conducted Interviews, Meetings and JAD sessions in the requirement gathering phase. Interacted with various cross functional teams to understand the inter dependencies between teams
• Designed the BRD’s&FRD’s collection approach based on the project scope and SDLC Methodology. Created a traceability matrix post testing to assure compliance with project goals
• Created GUI mockups using Mockup Screen and wireframes to have a clear understanding about desired system
• Performed the Scrum Master duties via Backlog grooming, Daily stand-up, Sprint Planning meeting, Sprint Review Meeting and Sprint Retrospective meeting
• Designed UML diagrams such as Use Case, Activity, Sequence and Workflowdiagrams using MS VISIO
• Decomposed epics into user Stories by following the principle of INVEST. Assisted Product Owner in Product Backlog refinement and listed the PBIs in JIRA
• Used the ETL tool Informatica for source to target mapping of the historical and real-time data in the data repository
• Developed and maintained the Sprint Burn Down charts to calculate the velocity of the scrum team
• Drafted high level Test Plans with the assistance of the QA Lead to define a road map for testing at different phases
• Helped the Quality Assurance team in writing Test Scripts, Test Cases and Test Scenarios
• Created / developed SQL Queries with several parameters for Backend/DB testing

Environment: Hybrid Waterfall-Scrum, JIRA, My SQL, SharePoint, HTML, UML, MS Visio, Mockup Screens, Wireframes, Informatica, JAVA

Confidential

Business Analyst

Responsibilities:

• Involved in Logical & Physical data modeling, Database design, ETL process,Data analysis, Documentation and Implementation & Support
• Involved in gathering and analyzing business requirements. Conducted JAD sessions with management, vendors, users and other stakeholders to develop specifications
• Created the Conceptual and Logical data model toillustrate the requirement tofunctional and technical team
• Helped the data architect to create database objects, install and deploy database, integrate high-level business rules with code, select unique identifiers and normalize the data model
• Carried out Data mapping work between legacy and prospect systems using Excel extracts
• Followed Service - Oriented Architecture (SOA) for the data mapping process
• Involved in walkthroughs with business and development teams
• Played a major role in support of SQL Server Analysis Services (SSAS) CUBE
• SQL validation scripts are run on the data to determine which data elements from the client data can be populated into the database
• Conducted User Acceptance Testing on the application - resolved issues from the participants, prepared and submitted Test Analysis Reports and participated in Product Readiness Review

Environment: Windows XP, MySQL, MS Access, MS Visio, MS Excel, JAVA, SSAS