PROFESSIONAL SUMMARY:

• Accomplished Sr. Business Systems Analyst/ Scrum Master with proven ability to implement strategic initiatives, lead cross functional teams, develop new products & processes.
• Over 8+ years of experience in business analysis, consulting, project management, operations, data analysis, marketing, account management, and .
• Adept in new product conceptualization, translation of product strategy to tactical deliverables, execution of deliverables throughout SDLC.
• Extensive experience as a Business systems Analyst with strong domain knowledge in Finance, Banking, AML, KYC, Insurance and Mortgage.
• Collaborated with Program Managers, Product Owners, Technical Leads, Subject Matter Experts, and Business Users to ensure agile business acceptance and applied technical skills and business knowledge to achieve successful results.
• Facilitated backlog refinement sessions, sprint planning, daily scrum, sprint review, and sprint retrospective meetings.
• Assisted maintaining product backlog, sprint backlog, writing PBI’s, sizing and estimation of user stories. Managed open issues, removed impediments, worked with cross functional teams to deliver quality software products.
• Worked as a product owner and created epics, features and user stories and then breaking down epics using horizontal and vertical slicing techniques.
• Proficient in SMART requirement gathering, performing appropriate analysis and business processes management with a strong knowledge of System Development Life Cycle (SDLC) using Waterfall, and Scrum methodologies.
• Excellent business writing skills in writing Business Requirements Document (BRD), USE Case Specifications, Functional Specifications, Systems Design Specification (SDS), Requirements Traceability Matrix (RTM), Systems Requirements Specification (SRS), Data Dictionary and UML diagrams.
• Excellent customer facing skills, and experienced in meeting with customers for gathering requirement utilizing methods such as interviews, questionnaires, surveys, and Document Analysis.
• Designed and developed Use Case, Activity, Sequence, and Data Flow diagrams to define the Business Process.
• Expertise in the management of User Request Change, Change Management, and handle User/Team Conflicts.
• Evaluated change requests by performing impact analysis on the triple constraints - time, cost, scope.
• Significant experience in reviewing Test Procedures and creating Test Cases, Test Scripts and Test plans for Manual Tests. Conducted defect triaging and test management using JIRA.
• Worked closely with the QA team to conduct regression testing, functional testing, compliance testing, performance testing and develop the test plan, test conditions, test cases, ensured adequate testing of software both before and after completion, and conducted UAT.
• Proficient in creating mock-up screens, prototype and dynamic UI with HTML, MS Visio, and OmniGraffle.
• Proficient in tightly coupled architecture, loosely coupled architecture (including SOA), web services and web methods. Skilled with the BPMN process.
• Comprehensive understanding of Web-Services (and their documentation) using XML, WSDL and UDDI, using Three-Tier Architecture and Service Oriented Architecture (SOA).
• Acquired good understanding of AWS.
• Well versed with GAP and Risk Analysis and possess comprehensive knowledge of and highly applicable skills in Risk Identification, Risk Assessment, and Risk Mitigation, Quantitative Risk Analysis, Qualitative Risk Analysis, Preparing Risk Register and Risk Management strategies.
• Extensive experience in conducting Market Research, Feasibility Studies, Logical and Conceptual designs for Database, Data Warehousing, Business Architecture, and many Distributed IT systems.
• Good working knowledge of Three-Tier architecture, Service Oriented Architecture (SOA), Ajax, Web Services (SOAP, REST, WSDL), Version control, Client-Side and Server-Side Validation.
• Extensive execution learning of Business Intelligence, Data warehousing, Data Structures, Schemas, Physical Models, Data Marts, OLAP and OLTP Operations, Master Data Management (MDM), and Data-Governance Processes.
• Interacted with data architect for Data Mapping, Data Modeling and Entity Relationship Diagrams.
• Used DDL, DML and DRL in SQL to perform CRUD operations on databases including joins, triggers, and stored procedures.
• Strong knowledge of SQL, extraction/ transformation/ loading (ETL) process, and data migration using DTS.
• Excellent work ethics and analytical skills coupled with excellent written, communication, and interpersonal skills describing a committed team player and an individual contributor too.
• Proven ability to work in an extremely fast paced ENVIRONMENT, and perform at high standards with limited supervision, including ability to manage project teams located across multiple delivery sites.

TECHNICAL SKILLS:

Requirement Management: MS Office, JIRA, Confluence, Rally, HP ALM 11.5.

ETL Tools: Informatica, SQL Server Data Tools-Business Intelligence

Project Management Tools/Methodology: Unified Modeling Language (UML), MS-Project, Rally, JIRA, Agile-Scrum, Waterfall-Scrum, Waterfall, Extreme Programming, Kanban, SAFe

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

Financial Tools: Bloomberg Terminal, Bloomberg B-Pipe, Thomson Reuters, Morningstar

Testing Tools: HP QC, HP ALM 11.5, SOAP UI, Cucumber, Selenium

Languages: HTML, XML, SQL version 2014

Database: MySQL version 2012, MS Access, Oracle 9i, DB2

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

Finance & Banking Domain: Fixed Income (Bonds, Convertibles, T-Notes, T-Bonds), Derivatives, Money Market Instruments, Mutual Funds, Trading, Equities, ETFs, Forex (FX), Automated clearing house, Asset allocation, Portfolio management.

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburgh, PA

Senior Business Systems Analyst/ Scrum Master

Responsibilities:

• Conducted walkthrough with project stakeholders to verify the accuracy and completeness of the requirements
• Conducted elicitation techniques like surveys/questionnaires, brainstorming, client interviewing and document analysis, Impact analysis and conducted JAD Sessions with various stakeholders to understand the current state and expected future state of the system
• Conducted GAP analysis to identify the requirements
• Was responsible for creating and reviewing process flows, business requirements, functional requirements, project schedules, documentation and test plans
• Created Use Case Diagrams, and Activity Diagrams using UML modeling tool.
• Worked with Development teams in creating wireframes and mock up diagrams
• Created various types of reports/sub-reports and cross tab reports with bar chart, pie chart and line-chart graph representation reports using Crystal Reports. Participated actively in the interaction of UX, RESTful APIs
• Used UDDI to identify and study relevant web services and web methods required for the application
• Documented sample requests, depicting the format of the calls to and from the web service
• Analyzed business requirements and created business rules for client side validations
• Organized and facilitated sprint planning, user story writing sessions, reviews, retrospectives, demos
• Designed the Test Plan and Test Cases for the processes. Made sure that the ERISA act was followed
• Tracked the progress of the project using Rally and continuously monitoring of scope creep at all stages
• Acted as a gatekeeper for all the defects in the testing phase, logged and analyzed defects using HP-ALM
• Organized Triage calls to resolve conflicts as well as to work out defects identified in testing
• Maintained artifacts such as Sprint burn down, Product burn down chart, and defect logs, which in turn assisted in velocity and capacity calculation for superior planning of upcoming sprints
• Scripted business rules for the web service, and assisted in drafting agreements for various web methods in XML
• Worked with the product owner and development team in deciding and negotiating the definition of done and acceptance criteria for Potentially Shippable Product Increment (PSPI)
• Acted as a liaison between the technical staff and the users (staff and management). Also, was responsible for communications between Project Team and other related departments
• Conducted functional walkthroughs, User Acceptance Testing (UAT) sessions, and supervised the development of User Manuals for customers

Environment: Scrum, MS Word, MS SharePoint, MS Excel, MS Visio, Tableau, OmniGraffle, XML, HTML, UML, HP-ALM, MS Power Point, SQL, CA Agile

Confidential, NYC

Senior Business Analyst/ Scrum Master

Responsibilities:

• Work in an Agile environment towards understanding the business requirements, analyze, validate and breakdown the high-level requirements into system requirements, documenting them and making sure both the development and test teams are aligned.
• Working with the regional teams to prepare documentation for the country specific requirements and KYC configuration to meet the country regulations.
• Writing Business Requirements Document (BRD), USE Case Specifications, Functional Specifications Design (FSD) and Systems Requirements Specification (SRS).
• Facilitate walkthroughs, brainstorming, Joint Application development (JAD) sessions, daily scrum meetings, sprint planning, sprint review and retrospective meetings.
• Defining the scope, designing test strategies and planning of the projects along with documentation and getting stakeholder approvals.
• Creating a traceability matrix and designing the high-level scenarios to ensure that the QA execution would cover all the business requirements listed.
• Representing the QA team in discussions with Compliance regional managers to test the Risk assessment rules.
• Conducting technical workshops with system architects to build the KYC framework.
• Working on developing material to keep the team up to date.
• Assisted in creating test cases, environment setups, test execution and defect analysis and reporting.
• Defect triaging and management of defects in JIRA and working with development team to fix the defects.
• Expertise in build release coordination.

Environment: Scrum, MS Word, MS SharePoint, MS Excel, MS Visio, Tableau, XML, HTML, UML, JIRA, MS Power Point, SQL, CA Agile

Confidential, New York, NY

Business Analyst

Responsibilities:

• Studied and assessed the clients systems and business processes. Developed project plans and managed scope.
• Implemented both Waterfall and Agile Methodologies.
• Conducted JAD sessions for communicating with Stakeholders and Project team to understand the project scope and gather requirements.
• Communicated with clients and different levels of management to identify requirements, use cases and to develop functional specifications.
• Created Use-Case and Business Use-Case Model after accessing the status and scope of the project and understanding the business processes.
• Studied the As - Is system and performed the complete Analysis of the existing system in order to map it to the To-Be system.
• Built process models using Visio.
• Collaborated with technical architects and the business to develop both high-level and detailed application architecture to meet the business needs using Agile methodology.
• Actively involved in the various phases of agile methodology such as story time meetings, design storm meetings, estimation, release planning, Iteration planning and the retrospective meetings.
• Attending the daily scrum meetings and recording the status updates to the status dashboard and then acting upon the action items to ensure smooth functioning of the project.
• Documented the user stories and the acceptance criteria for each of the stories and entering then into Mingle.
• Updating and Monitoring the status dashboard on Mingle to ensure the project progress is up to date.
• Coordinated and prioritized outstanding defects and enhancement/system requests based on business requirements.
• Used HP-ALM to log, track, assign and close defects.
• Monitored client expectations and conducted user interviews.
• Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle.
• Organized several brainstorming sessions with various stake holders to identify the scope of the projects.
• Involved in the design and development of highly complex architectures and enterprise frame works
• Developed questionnaires and organized meetings emphasizing the scope of the project in order to provide key initiatives in working with users in defining project and system requirements.
• Worked on Project strategy and came up with detailed project plans, work assignments, target dates, Resource Management etc.

Environment: MS Visio, Mercury Quality center, Java/J2EE, XML, SQL, MS Word, MS Excel, MS PowerPoint, Rational clear case, HP-ALM.

Confidential

Business Analyst

Responsibilities:

• Gathered requirements on the online brokerage platform from stakeholders by facilitating JAD sessions and extensive meetings with SMEs. Conducted Gap Analysis and created AS-IS and To-Be Process Flows documentation.
• Conducted data mapping & data indexing for retrieval of information from existing account systems & outlined security measures for accessibility and transmission of information using standard templates in MS Excel. Created Requirements Traceability Matrix (RTM) to track requirements and test cases using Rational Requisite Pro.
• Assisted and worked with Project manager in creating and assigned task through Work Breakdown Structure (WBS).
• Interacted with the customers and internal stakeholders in defining project scope boundaries and gather user requirements and their expectations from the system to create BRD, FRD and SRS.
• Created business and functional requirement documents and prepared Use Cases models, Sequence Diagrams and Activity Diagrams using tools such as Rational Rose and MS Visio.
• Worked with the QA team for designing Test Plan and wrote Test Cases for the User Acceptance Testing (UAT) and assisting the Automation Testers in System Testing, Integration and Regression Testing.
• Developed plans for verification and validation of requirements at all levels so that developed software successfully fulfilled user expectations and business needs.
• Worked closely with Project Manager for any change request and helped to do Impact Analysis.
• Worked with Quality Assurance (QA) testing team in preparing the test cases, test plan and procedures for system testing
• Used HPQC for allotting tasks, issue tracking and requirement traceability. Documented the cause analysis and final resolution to the issues. Designed and Implemented SQL queries for QA testing and reporting data validation.

Environment: Waterfall, MS Visio, MS Office Suite, MS Access, SQL version, Rational Rose, HP Quality Center, MS Project, MS Visio, MS Office (MS Excel, MS Word, MS PowerPoint).

Confidential

Business System Analyst

Responsibilities:

• Conducted brainstorming and interviews with business heads to finalize the business requirements.
• Documented requirements and cre3ated Project artifacts such as FSD, SRS and RTM.
• Prepared Data Mapping Documents for the reporting documents generated by the system.
• Led requirement elicitation & management, competently upheld business requirements on HP QC.
• Created the mocks and UML diagrams such as Use Cases, Activity, Sequence using MS Visio.
• Performed extensive business process analysis including data analysis and GAP analysis
• Assisted development team in creating prototypes based on requirements specifications.
• Prepared Data Mapping Documents for the reporting documents generated by the system.
• Integrated various OLTP to the OLAP by using Informatica as an ETL tool.
• Schema design in Erwin and implement in database and preparing the technical design document for ETL.
• Gathered requirements for Client-Side Validation, and Server-Side Validation. Gained understanding of three tire and n tire architecture, understanding of request and response flow.
• Worked with QA team in creating a test scenario, test cases, test steps. Involved in software integration testing, regression testing, UAT testing and web services API testing using SOAP UI.
• Prepared UAT test document and developed Test Scenarios for validating the Business requirements and Uploaded Test scenarios, mapped Business requirements to Test scenarios and updated defects and defect tracking in HP Quality Center.
• Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance testing.

Environment: Informatica PowerCenter 9.0, Apache Tomcat, Oracle 10g, HP QC, Java/J2EE, XML 1.0, HTML MS Office, MS Project, MS Visio, UML2.2, SOA, SOAP UI

Confidential

Jr. ETL/SQL Developer

Responsibilities:

• Wrote SQL and PL/SQL programs to retrieve required information from the database.
• Created database objects like tables, functions, views, materialized views, procedures and packages using oracle tools like Toad and SQL Developer.
• Used Erwin tool extensively and performed the logical and physical data modeling
• Got familiarized with importing data from distinct types of sources like XML and Excel sheets
• Worked on SQL * Loader to load the data from flat files obtained from various vendors.
• Created Indexes on the table for faster retrieval of the data to improve database performance.
• Handled errors using exception handing extensively for the ease of debugging.
• Involved in ETL to meet the requirements for extraction, transformation and loading from source to target.
• Extracted data from various sources and loaded it into target database using Informatica Power Center.
• Tuned mapping and SQL queries for better performance and efficiency.
• Performed unit testing and validated the Data.
• Performed performance tuning of the process at the mapping level, session level, source level and the target level.

Environment: Waterfall, Informatica PowerCenter 9.0, Oracle 9i, PL/SQL, Unix Shell, MS PowerPoint, TOAD, Unix, MS SQL Server, and MS Excel.