SUMMARY

• Over 8+ years of experience as a business system analyst in the domain of IT, finance, Insurance, banking, oil & gas and management
• Good experience in business requirement gatheringusing elicitation techniques like Joint Application Development (JAD) sessions, Client Interviewing, Brainstorming, requirements workshops, survey/questionnaire and understanding of business process flow and business process management
• Skilled Business Analyst and agile coachwith a proven ability to work with cross - functional team and a self-organizing team. Proficient in various Software Development Life Cycle (SDLC) methodologies like Scrum, Waterfall, Waterfall-Scrum, Hybrid Agile
• Experienced Scrum Master, skilled in facilitating scrum events (Backlog grooming, Sprint Planning, Daily Scrum, Sprint Review and Sprint Retrospective) to improve team performance and handle team dynamics
• Experienced in conducting SWOT analysis, GAP analysis, Impact assessment, Cause & effect analysis, Cost benefit analysis, Feasibility analysis, Risk assessment and estimate ROI
• Experienced in creating the requirement documents like Business Requirement Document (BRD), Software Requirements Specification (SRS), Functional Requirements Document (FRD), Use Case documentation, Data mapping document,Test Scenarios, Test Cases andTest Plan
• Extensively experienced inBPMN (Business Process Model and Notation) andUML Methodologyto create like Activity Diagrams, Sequence Diagrams, Use case Diagrams, Process work Flow Diagrams, Interaction Overview Diagrams and Class Diagrams
• Experienced with HP Application Lifecycle Management (HPALM) and HP Quality Center (HPQC), IBM Clear Quest in managing requirements and tracking defectsand used Team Foundation Server (TFS) for version control
• Well versed in conducting various types of testing including Regression Testing, and User Acceptance Testing (UAT); monitored manual and automated Performance Testing in Load Runner.Experienced in writing technical article and knowledge articles
• Experienced with tools like Jira, HP Agile Manager, and MS Project Professionalfor planning, tracking and managing projects. Using Requirements Traceability Matrix for assisting the Project Manager
• Majorly involved withcreating and enhancing UI/UX wireframes, mockup screens, and creating prototypes
• Experienced in gathering SMART (Specific, Measurable, Attainable, Realistic, Timely) requirements and translating them into functional specifications. Proficient in writing User Stories.
• Efficient in prioritizing user stories effectively by using leveraging and analyzing techniques like Planning poker, MoSCoW and T-shirt sizing. Experienced in managing Requirements Churn and performing impact analysis.
• Experienced in managing projects using exceptionally strong organizational skills, analytical thinking, decision making ability, leadership skills and Project Management skills.
• Highly collaborative team player with extensive customer relationship management skills, also possess excellent mentoring skills and ability to prioritize tasks according to business needs
• Experienced in Data Modelling, involved in creating Conceptual and Logical data modelswith the data architect
• Proficient in extracting/generating reports using SQL Server/SSRS; can construct complex queries for data extraction and formulate meaningful insights and conclusion from the same
• Extensive knowledge of Data Warehousing, implementation approaches and schemas
• Performed ETL operations using Informatica and SSIS to load the data into the data warehouse from various disparate sources. Involved in deploying an OLAP cube and performing various operations such as Roll-up, Drill-Down, Slice, Dice and Pivot through SSAS, designing and deploying various reports through SSRS, Tableau, and IBM Cognos
• Extensive experience in working with different web services such as WSDL, SOAP, UDDI, REST under various architectures such as Three-Tier Architecture, and Service Oriented Architecture (SOA)
• Involved in implementing business logic in the web methods of the web services, and documenting the Web Service Level Agreement (WSLA) document, through the use of XML
• Experienced in handling teams in Offshore/Onsite model and communications to ensure seamless service delivery. Ability to work under pressure with minimum supervision and deliver results

TECHNICAL SKILLS

Methodologies: Agile- Scrum, Waterfall, Rational Unified Process (RUP), Waterfall-Scrum, Kanban

Project Management Tools: IBM Rational, JIRA, HPALM, MS Project Professional, MS SharePoint 2007/2013, TFS

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

Reporting Tools: SSRS, IBM Cognos, Informatica, MS office Suite

Databases: MS-Access, MySQL, SQL Server 2005/2008/2012 , Oracle 9i/10g

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

Analytics Tools: MS Excel, MS Access, Tableau

Testing Tools: HP Service Center, HP QC, HP ALM 10/11.5, HP Load runner

ETL Tools: Informatica PowerCenter, SSIS

Languages: HTML, XML, Visual Basic, C

Defect Tracking tools: Rational ClearQuest, HP QC

UI Design tools: Axure, Balsamiq Mockups, Moqups

PROFESSIONAL EXPERIENCE

Confidential, Columbus, IN

Sr. Business Analyst

Environment: SCRUM, MS Suite 2013 (Word/ Excel/ Visio/ PowerPoint), IBM Rational suite, SQL version 2014, Salesforce Identity Management.Platform: Web, Android and iOS.

Responsibilities:

• Organized brainstorming and JAD sessions with Director, Product Owner, Product Analyst, Marketing team, distributors and possible customers to create and outline Use Cases for the potential product
• Gathered, analyzed, documented, shared and made possible for the team to view, edit and track requirements in IBM Rational Requisite Pro
• Created functional and interactive wireframes and mockups for the different sections of the web portal as well as the mobile app
• Facilitated multiple sessions to finalize and review the wireframes from the stakeholders with the UX expert
• Assisted the Product Owner and Product Analyst in breaking the requirements into SMARTstories for the web developers, tableau developers and data base developers
• Developed user stories and acceptance criteria for every feature, and requested approval from the product owner
• Organized story grooming sessions with the developers and solution architect to understand and outline technical requirements to fulfill the business requirements
• Represented the Product Analyst in the various Scrum meetings including but not limited to Backlog refinement, Sprint Planning, Stand up meeting, Sprint Review and Sprint Retrospective
• Assisted the scrum master and scrum team in organizing and prioritizing the user stories
• Created detailed Use Cases, Use Case diagrams, Business Flow diagram, Creating process models, Data flow diagrams, developed use case documentation for system requirements and business process flows using MS Visio 2013
• Assisted and verified the test cases outlined by the testing team in IBM Rational Test Manager
• Conductedand participated in User Acceptance Testing, developed and maintained quality procedures, and ensured that appropriate documentation was done
• Deferred and managed defect raised by the testing team keeping in mind the deadline for the project and severity of the defect in IBM Rational Clear Quest
• Used Tableau to create the Tableau reports prototype for the Confidential Connected Solutions portal
• Communicated effectively across the company stakeholders, clients and internal team about the project requirements, schedules and releases

Confidential -Warren, NJ

Sr. Business System Analyst/Scrum Master

Environment: SCRUM, MS Suite 2013(Word/ Excel/ Visio/ Project), JIRA, Tableau, UML, Fraud management, Money Laundering, SQL version 2014, Mercury Test Director, Team Foundation Server (TFS), Java

Responsibilities:

• Knowledge of the Dodd-Frank Act, the Bank Secrecy Act, FinCEN and Sarbanes-Oxley Act
• Organized and conducted the JAD team sessions and conducted the weekly requirement gathering sessions to sign-off of the application after testing
• 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
• Conducted GAP Analysis to derive requirements for revising the existing AML surveillance system
• Used Mercury Test Director to ensure traceability of requirements, documented test plan for the software and managed test execution and documentation
• Assisted the project manager to construct a project plan that included Project Schedules, Milestones tracking, and Meeting minutes using MS Project
• Developed a vision plan that defined Citigroup AML policies and proceduresand primary goals of the project
• Assisted in identifying documents needed to develop Suspicious Activity Reports (SAR) as required by Bank Secrecy Act (BSA) and FINCEN for generating reports and red flags to report fraud, money laundering, patterns and inconsistent activities
• Created Wireframes and interactive mock-up screen layout to assist the managers in understanding the functioning of the reporting system
• As a Scrum Master I facilitated Scrum events including Backlog refinement, Sprint Planning, Stand up meeting, Sprint Review and Sprint Retrospective in a time boxed manner
• Developed user stores and assisted PO in prioritizing the Product Back
• Analyzed and maintained the Iteration Burn Down charts and reviewed defects. Used JIRA for issue tracking, user story management and requirement traceability
• As experienced Scrum Master anticipated and removed obstacles from project team’s path and pushed them to deliver quality results based on estimated schedule
• Created detailed Use Cases, Use Case diagrams, Business Flow diagram, Creating process models, Data flow diagrams, developed use case documentation for system requirements and business process flows using MS Visio 2013.
• ConductedUser Acceptance Testing, developed and maintained quality procedures, and ensured that appropriate documentation was done. Alsoassisted in Black box testing and Regression testing
• Communicated effectively across the company stakeholders, clients and internal team about the project requirements, schedules and releases
• Used Tableauto generate reports and forecasts to assist the PO in planning. Also assisted PO in making business decisions withdata visualization as well as data interpretation

Confidential - Austin, TX

Sr. Business System Analyst/ Scrum Master

Environment: Hybrid Agile, MS Suite 2013 (Word/ Excel/ PowerPoint/ Visio), Mainframe, Intranet Web Portal, Data Dictionary, UML, VersionOne and HP ALM/ QC 10, and Balsamic, Java, HTML 5, CSS, MS Sharepoint

Responsibilities:

• Involved from Concept inception to Deployment of the Software Development Life Cycle
• Built thorough understanding of repository artifacts and business processes; and developed understanding of the existing IT system
• Conducted Requirement Gathering sessions using JAD sessions and Interview elicitation techniqueand used VersionOne to gather requirements using SMART
• Prepared BRD and FSD, Gap Analysis Document and Impact Analysis Document using MS Word and Excel
• Assisted Product Owner with converting the FSD into User Stories and prepared the feature breakdown structure to prepare a timeline for the project
• Responsible for managing and developing the Requirements Traceability Matrix for the entire duration of the project using MS Excel
• Defined and implemented standard documentation and data standardization process
• Made sure if thequery system and the documentation system were compatible, performed SQL queries in the database to check compatibility
• Prepared a data dictionary for the common terms used in data documentation to avoid possible conflicts and defined as well as highlighted the common key terms to be used to query the system
• Prepared Activity Diagrams, Use Case diagrams and UML Diagrams using MS Visio
• Prepared paper proof concepts of theUI/UX system to be implemented as well as the client forms. Created Wireframes and paper proofs of UI to satisfy stakeholder expectations. Used Balsamic mock up screens to design and display the application layout
• Communicated the specific requirements accurately with the development team and the User Interface Design team and maintained Sprint Burndown chart in MS Excel to track progress
• As the users were limited to internal staff, participated and implemented Regression Testing and User Acceptance testing used HP ALM/ QC to manage the tests and track bugs and defects
• Prepared the User Guidewith MS Word and PowerPoint to enable appropriate usage of the system thus designed
• Conducted training sessions for the present staff to ensure understanding of the system
• The application thus developed, reboots every night and generates an automated report of the possible violators. This list is sent to the Sr. Technical Permitting Manager who can then analyze and make decisions

Confidential -Houston, Texas

Sr. Business System Analyst

Environment: Hybrid Agile, MS project, MS office Tools (Word, Excel, PowerPoint and Visio), VersionOne, data warehousing, Informatica PowerCenter and Team Foundation Server (TFS)

Responsibilities:

• Gain understanding of the current status of project and plan future releases accordingly
• Prepare High Level Document (HLD) and Functional Specification Document (FSD)andestimate a timeline for the project. Made the Minutes of Meeting (MOM) document and had it revised and signed off by the stakeholders
• Assisted the Product Owner in setting realistic project expectations, in evaluating the impact of changes
• Interacted with Educators, Students and Administrators to understand their expectations from the system. Created surveys and provided incentives to participate in surveys.
• Assisted the PO in breaking the functional specifications into User Stories by following INVEST
• Derive a high level Conceptual Model of the data to be integrated into the Data Warehouse. Also assist the architect with the design of Logical Data Model using MS Visio
• Performed Gap Analysisand documented business rules and workflows using MS Visio
• Conducted the SCRUM Ceremonies and estimated as well as handled impediments faced by teams on regular basis
• Created Requirement Traceability Matrix to maintain and track requirements
• Assisted the database team by managing and logging the defects and issues encountered
• Assisted the architect in developing the Primary Key, Functional Key and Conformed Key in the data set
• 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
• EstablishedIncident Reporting and Change Control procedures using IBM ClearQuest
• Prepared a plan for the ETL Operations, estimated system downtime for each phase of the ETL operation
• Conducted workshops for training end users, educators and administrators with their respective goals
• HISD includes 291 campuses and data pertaining to all the students, thus these databases were migrated into a data warehouse in multiple steps

Confidential -Baltimore, MD

Sr. Business Analyst/ Scrum Master

Environment: Agile Hybrid Environment, HPALM/QC, JIRA, MS Suite (MS Word/ Excel/ SharePoint/ PowerPoint/ Visio), XML, HTML5, Java, Blueprint, Cisco Webex, UML

Responsibilities:

• Developed understanding of the business rules, business process and model, performed in depth study of claim processing systemand the existing IT system and database
• Clarified and prioritized requirements by conducting brainstorming sessions with SMEs and stakeholders and Product Owner. ConductedJAD Sessions with the stakeholders available and Interview sessions with off shore stakeholders using Cisco Webex
• Prepared BRD from the requirements gathered and designed the Software Requirements Specification Document
• Developed & presented user stories to communicate user requirements to Product owner, and the development team and assisted in creating the Product Backlog
• Worked with stakeholders to create wireframes describing several UI components such as drop-down lists, and paginations, and extensively documented the various components of the front end
• Gathered all the design requirements for the web page and made paper proofs of each event
• Prepared Activity Diagrams, Data flow Diagrams, Use Case Diagrams using UML methodology using MS Visio
• Made interactive Mock-up screens using Blueprint to provide stakeholders the look and feel of the process
• Communicated the requirements aptly with the UI team and helped design test cases against the SRS
• Facilitated meetings for the sign off of the user stories and acceptance criteria by the senior management
• Facilitated Sprint Planning Meeting, Backlog Refinement meetings, Daily Stand-Ups, Review meetings and Retrospective meetingof all the teams involved in the project, including offshore teams. Used MS SharePoint and HPALM to sophisticate the process and coordinate efficiently with the teams offshore
• Documented and tracked the progress of the teams using Sprint Burn Down chart to keep the teams motivated
• Assisted and enhanced the team productivity by resolving the conflicts in the team and managing the impediments throughout the project
• Assisted the architect in creating Data models in the form of Conceptual, and Logical Model
• Involved in the creation of Dimensional Model, and selection of types of dimensions such as Conformed and Slowly Changing Dimensions, and translate the user requirements into dimensions
• Assisted in the Data Mapping process, Staging of the data, Data Integration and performed ETLoperations using Informatica PowerCenter from various sources to the target through SSIS into the target data warehouse
• Coordinated and controlled Requirements churn for the clients by conducting Impact and Cost analysis
• Logged the defects and bugs faced by the team, tracked the defect life cycle and utilized JIRA for issue management
• Designed Use Cases documents and a Use Case Test Plan for various scenarios. Acted as a coach to potential users and performed User Acceptance Testing

Confidential

Sr. Business Analyst

Environment: RUP, Load Runner, UML, Clear Case, MS Access, MS Office, ASP, SQL Server, Visual Studio

Responsibilities:

• Defined scope, objects, goals, risks and produced business requirements and policy-writing solutions to Property/Casualty/Personal and Commercial Lines
• Analyzed business needs/requirements
• Studied system feasibility and provided information to the stakeholders with benefits, cost savings and risks
• Conducted Joint Application Development (JAD) sessions with business user subject matter experts (SME’s) to collect requirements
• Prepared Gap Analysisand assisted in formulating testing documents like Test Plans, Test Cases and Test summary report
• Communicated directly with Clients to understand their business needs and to resolve business issues
• Analyzed cross-functional applications and met requirements for MIS reporting of cancellations, corrections and amendments performed on the existing systems
• Performed analysis and design of product enhancements for rollout of the new application and established a business analysis methodology around the Rational Unified Process
• Participated in the development of controls and workflows to meet new business requirements, productivity enhancements and regulatory changes
• Played a key role in the planning, User Acceptance Testing and implementation of system enhancements and conversions
• Worked with SQL queries to extract application data to perform application validations

Confidential

SQL Developer/ Asc. Business Analyst

Environment: Waterfall, MS SQL 2005, SSIS 2005, SSRS 2005

Responsibilities:

• Created SQL Server Reports using SSRS 2005
• Developed drill down, roll up, sub reports, and dashboard reports in SSRS 2005
• Identified and worked with Parameters for parameterized reports in SSRS 2005
• Responsible for scheduling the subscription reports with the SQL 4subscription report wizard (SSRS)
• Developed, monitored and deployed SSIS packages
• Implemented different types of constraints on tables
• Managed index, statistics and optimizing queries by using execution plan for tuning the database queries
• Optimized SQL queries for maximum efficiency using SQL Profiler
• Created Stored Procedures, Triggers and Views

Confidential

Jr. Business Analyst

Environment: MS Suite (Word/ Excel/ Project/ Visio), JIRA

Responsibilities:

• Assisted in conducting interviews and JAD sessions to elicit requirements from business users and various stakeholders
• Identified and analyzed the business requirements and prepared Business Requirements Documents (BRD)
• Interfaced with business and program areas to understand product needs
• Attended ceremonies likeDaily meetings, Planning meetings, Demo and Retrospectivesessions
• Worked with the scrum master, scrum team and stakeholders to define project scope, agile modeling techniques, such as INVEST for requirement definition
• Assisted in creating Use Cases from the list of user stories using MS Visio
• Took charge of representing the team in weekly status meetings held by product teams
• Collaborated with Business Liaisons, Architects to assess business and technical impact of changes or releases to the production