Sign in

Senior Business Systems Analyst

Dallas, Texas, United States
September 25, 2018

Contact this candidate




Phone: 614-***-****


Pragmatic result-oriented Business Analyst with 8 years of experience working in a cross-functional team environment/different geographical locations teams on multiple projects using Agile Scrum and Waterfall in Retail, Ecommerce, Finance and Insurance domains. Able to capture stakeholder’s vision through elicitation. Strong analytical skills, commended for a detail Oriented eye while remaining focused on the bigger problem, with creativity within quantitative-oriented disciplines to better solve problems.


Experience with Agile Scrum, Waterfall, RUP.

Expertise in eliciting requirements, analyzing the requirements and simplifying and translating requirements.

Excellent experience in developing detailed functional specs through JAD sessions, Requirements workshops, Job shadowing, Prototyping, Document Analysis, Interviews, on site meetings with business users & development team.

Good experience in interviewing Business users & subject matter expert providing recommendations to resolve issues for various business/technical groups & defining strategic solutions to business problems in a multiple project environment.

Excellent verbal communication and writing skills; Follows the tasks and takes the directions well.

Good team player at work, clearly communicating ideas with the group.

Set and achieved challenging goals with initiative, problem solving and energetic personality.

Expert in facilitating all levels of management, developers, QAs, stakeholders, business users and off-site teams in JADs, Brainstorm sessions, White Boarding by conferences and WebEx and having strong project and time management skills.

Acted as Scrum Master to direct and lead development team from project initiation through delivery of final product, Facilitating Sprint Planning, Backlog Grooming, Sprint Retrospective, and Daily Standup meetings.

Expertise in analysis techniques such as ‘AS-IS’ and ‘TO-BE’ System Analysis, Business Process Analysis, Gap Analysis (while successfully reengineering key business processes to increase operational efficiency and alignment of business unit objectives), impact analysis, Feasibility Analysis and Risk Management Plan, Cost Benefit Analysis and ROI Analysis.

Designing and Analyzing (Use Case, Sequence and Activity diagrams) (UML, SDLC, Test Plans, Test Cases, Project Plans, SRS).

Documentation: BRD (Business Requirement Document), FRD (Functional Requirement Document) and Non-functional Requirement Document, SRS (Software Requirements Specification). Expertise in tracing requirements throughout the development process and verifying their adherence to Requirements Traceability Matrix and RACI Matrix.

Worked with Product Backlog, Sprint Backlog creating artifacts like Sprint Burn-Down Chart, Sprint Burn-Up Chart and Product Burn-Down Chart and managed Prioritizing and User stories, breaking down an Epic understanding business needs. Led daily stand-up meetings and sprint planning meetings in an agile scrum project.

Created story cards using Gherkin language to make a user story more readable and understandable both for developers and clients.

Well versed in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML) diagrams using MS Visio and Rational Rose. Developed Use Case diagrams, Swim lane Diagrams, Business flow diagrams, Activity/State diagrams and Sequence diagrams using Rational Rose so that developers and other stakeholders can understand the business process. Experience with data analysis, data mapping.

Proficient in executing SQL queries using Toad and Oracle SQL Developer. Comfortable in large data analysis using SQL/Excel/Access and GUI navigation design using MS office tools.

Experience on working with Database Platforms like Oracle, SQL SERVER, and Data warehousing environments and Data modeling tools like Erwin, MS Visio and tracking system Mercury Quality Center, JIRA, Clarity.

Strong understanding of the US market for Payments and cash management (ACH, wires, checks, Faster Payments etc.) and Trade Finance (like LC life cycle, supply chain finance and Open Account products).

Expertise in creating Dashboards/KPI’s, Scorecards, Reports, views, pivot tables for analysis using TABLEAU DESKTOP/SERVER and other DATA VISUALIZATION tools like QLIKVIEW, SAP BO.

Created and maintained an Issue log to keep track of the outstanding issues and the requirements that were changing from time to time. Conducted weekly meetings with the client to discuss the same.

Writing Test Case (manual/automated test cases) and Conducting Tests (Integration testing, Regression testing), UAT (user acceptance tests).

Worked closely with Application System Analysts, Operations & Integrations, Project Management, Testing Center of Excellence (TCOE) and cross functional team members to support application delivery initiatives.

User training on the changes being released and conducting post production activities like getting feedback from users. In case of any issues - doing root cause analysis, prioritizing tasks with business users.

Strong leader and team builder with excellent analytical and communication skills with capability to handle new technologies and situations, dedicated to meet deadlines and provide necessary deliverable and resolve issues creatively by out of the box thinking. Excellent success in building and maintaining relationships at all levels of the organization with strong motivational and team building skills. Working experience in a cross-functional team environment/different geographical locations teams.

Worked with the release management team, collaborating and coordinating with both technical and business teams, including Frontend/Backend Development, and other key internal and external functional groups.

Coordinated and managed scheduled plans ongoing activities across the cross functional team environment.

Involved in the migration and deployment of data releases to the production environment.

Skill Set:

Project Methodologies:


Business Modelling Tools:

Rational Requisite Pro, MS Visio, MS Project, Mind Map, Erwin

Operational Systems:

Windows, Mac OSX, Unix


Oracle 11i, MS Access, SQL Server 2012/2008

Data Analysis Tools:


Data Visualization tools:


BA Tools:

JIRA, Microsoft Office Suite (Word, PowerPoint, Access, Outlook, SharePoint 2010), Microsoft Project, Clarity, Confluence, iRise.

QA Tools:

HP Quality Centre (HP ALM), SOAP UI

Professional Experience:

PNC Bank, Pittsburgh, PA Feb’2018- Till date

Sr. Business Analyst


Worked extensively with the users, different levels of management; conducted formal interviews and JAD sessions to identify requirements, functional specifications and database specifications.

Lead discussions and JAD Sessions to gather business requirements and discuss possible solutions.

Responsible for defining the scope of the project, gathering business requirements, performing GAP analysis and documenting them.

Excellent track record for meeting deadlines and submitting deliverables on time using AGILE/SCRUM methodology.

Experience in assisting technical team in different phases of SDLC such as Design, Development and Quality Assurance.

Created System requirement gathering document that included Assumptions and Dependencies, specific Functional requirements, Non-Functional requirements.

Identified and documented business needs and created detailed Use Cases using UML and collaborated with production team to identify and map detailed existing processes, identify system gaps and developed functional requirements documentation (FRD) that supported overall strategy, goals and objectives.

Extensive use of MS Office tools like MS Access, MS Word, MS Excel, MS PowerPoint & MS Project for project documentation.

Result oriented, committed and hard working with a quest to learn new technologies and undertake challenging tasks.

Expertise in creation & execution of Test Plans, performing functional, usability testing and ensuring that the software meets the system Requirement.

Performed defect tracking for the modules in production, conducted feasibility study and performed impact analysis for proposed enhancements.

Used AGILE methodology guidelines to carry out every step of the business modeling process. Assisted scrum manager with daily scrum meeting, sprint planning/review meeting.

Facilitated daily scrum and ensure the integrity of the agile process capturing velocity and removing obstacles to drive success and grooming.

Generated documents through agile methodologies based on in-house Performance Management tool to retrieve and analyze data, extract, transform and load data, manage the data dictionary for data warehousing system.

Involved in creating the Project templates, use case specifications, Change request form, functional specification documents, and Business Requirement documents.

Worked with cross-functional teams for building use cases, demonstrating the business requirements, developing business models; Designed and developed business flow diagrams, activity diagrams, sequence diagrams, Object Oriented models using MS Visio.

Created static and dynamic prototypes using MS Visio and iRise to show as prototypes.

Customized SharePoint Sites, SharePoint Lists, Features, Workflows, and Document Libraries in SharePoint 2013 created user groups and assigned permission levels to users.

Worked with the design team to assist them extensively in designing the database.

Assisted Project Manager in managing requirements by coordinating and facilitating requirement tracking using Requirement Traceability Matrix (RTM).

Worked with testing team in developing the test plan, test conditions, test cases based on business requirements and technical specifications.

Experience in working with QA testing teams, while interacting with business users and gathering user’s requirements to develop necessary Test plans, Test Cases and Test script.

Generated and prepared reports using sequel server reporting services (SSRS).

Involved in UAT process and coordinated with the UAT team to get the feedback to make change requirements document.

Worked with the release management team, collaborating and coordinating with both technical and business teams.

Coordinated and managed scheduled plans and ongoing activities across the cross functional team environment.

Involved in the migration and deployment of data releases to the production environment.

CITI Bank, Tampa, Florida March’2016-Jan’2018

Sr. Business Analyst


Collaborated with client business leaders and end users to understand their business objectives and processes. Conducted sessions with business unit leaders and stakeholders globally to define project scope, gather requirements, to identify the business flows and perform impact analysis on existing systems as well as feasibility studies for the future process.

Facilitated requirement gathering workshops and interviews to identify, translate and document business and user needs into detailed, testable, and verifiable business, functional and system requirement specifications.

Developed detailed Technical Requirements Document/User Stories for envisioning the development effort.

Effectively broke down epics into User stories during the Backlog Grooming Sessions.

Created the data-mapping document, identifying, and noting the location of the tables, business rules and the transformation logics. Drafted the service level Agreements for the web services consumed.

Prepared conceptual Data Model and assisted in the preparation of Logical Data Model assuring alignment with BR.

Used MS Visio to create wire frames and mock up screens to present to the stakeholders the User Interface and elicit feedback early in the development phase.

Represented the system process using various UML diagrams such as Activity diagrams, Sequence diagrams and State-chart diagram. Collaborated with the UX team to meet requirements in terms of the design and layout of the components.

Created and maintained the Sprint Burn-down/Burn-Up chart to track sprint progress and the Impediments List.

Facilitated Sprint Planning, Backlog Grooming, Sprint Review, Sprint Retrospective, and the Daily Standup meetings.

Created story cards using Gherkin language to make a user story more readable and understandable both for developers and clients.

Facilitated the Backlog Grooming as and when needed or requested by the product owner.

Facilitated communications between solution architects, developers, QA analysts and business users as required throughout the requirement analysis, design and testing phases to ensure the defined requirements are interpreted correctly.

Analyzed and documented existing process flows to capture essential elements of securities trading.

Designed trade flow diagrams for cash and securities movement between investor, bank, stock exchange and depository participant. Received and analyzed Brokerage statements from prime brokers & step up brokers and determined the correct number of fees, taxes and commissions based upon the market and quantity of shares.

Created FR and source-to-target mappings including data transformation rules to the development team for implementation.

Created and maintained RTM correlating the system requirements to functional requirements and then to test cases.

Collaborated with the testing teams for test cases, test scripts planning, review and approval. Assisted testers in developing a variety of possible test scenarios and cases to ensure that the system being built is resilient.

Responsible for all ALM analysis, forecasting and planning analysis, and reporting for the bank portfolio of standard bonds, mortgage securities, interest rate swaps and options.

Co-ordinate and support business in defining and performing QA / User Acceptance Testing.

Worked with the release management team, collaborating and coordinating with both technical and business teams.

Coordinated and managed scheduled plans ongoing activities across the cross functional team environment.

Involved in the migration and deployment of data releases to the production environment.

New York Life Health Insurance, Queens, NY.

Aug’2014 – Nov’2015

Business Analyst


Gathered User and Business Requirements through interviews, surveys, prototyping and observing and modified requirements.

Extensively worked with Project Manager to determine the current best practices for requirement gathering.

Performed Gap Analysis with the FI team to Identify and estimate the scope of the major definition, design, Development.

Determined the magnitude of the gaps and the extra effort involved in filling the gaps.

Prioritized multiple tasks and handled ambiguity complex tasks and projects quickly with limited guidance.

Experienced in thinking, planning, and coordinate meetings and working sessions with the cross functional team.

Conducted regular JRP sessions with the external Business team to understand their product specifications/requirements.

Created and maintained an Issue log to keep track of the outstanding issues and the requirements that were changing from time to time. Conducted weekly meetings with the client to discuss the same.

Utilized Software Development Life Cycle (SDLC) to configure and develop process, standards procedures.

Created Need Analysis Documents of the requirements gathered through JAD individual elicitation sessions using MS Word

Created User Requirement Specifications, Business Requirements and Functional Requirements Specifications documents.

Developed Use Case diagrams, business flow diagrams, Activity/State diagrams and Sequence diagrams using Rational Rose so that developers and other stakeholders can understand the business process.

Used various SQL commands like create, delete, update, left joins, right joins and full joins to update the database and retrieve data for analysis.

Involved in analysis of the technical specifications of the current system and the infrastructure needs, performed Gap analysis.

Experienced setting up test scenarios and executing on these scenarios and worked closely with testing team to make sure all the changes made to requirements documents are implemented in their Test Cases.

Set up definitions and process for test phases including Integration test, System test and User Acceptance Test (UAT).

Conducted GUI testing, Functional Testing, Integration Testing, Performance and User Acceptance Testing on the application.

Extensively worked on Mercury Test Director for bug reporting/tracking.

Conducted Training Sessions to familiarize users with system.

Participated in the User Acceptance Testing (UAT) with large cross-functional teams.

Software AG, Hyderabad, India

Feb’2013 – Aug’2014

Business Analyst


Responsible for the requirements gathering phase and project plan.

Responsible for requirements analysis, design and developing technical requirements.

Job responsibilities included facilitating and driving weekly financial management meetings, including putting together the meeting agenda and minutes.

Consistently met important deadlines for monthly performance and Deliver meeting presentations, which involved coordination and consolidation of information from various project teams.

Collaborated and worked with various SME and Business users for putting together and documenting user manuals for CSR, and documentation of end to end process flows for Vendor management and financial management teams.

Other responsibilities included coordinating and setting up meetings with different teams, tracking WO’s in Remedy, providing research support to find existing materials on request, tracking and communicating team accomplishments and successes.

Assisted the team members to develop Service Oriented Architecture (SOA), and data warehouse system (EDW) to utilize data mining for data analysis.

Using SSRS creating well-formed reports and web-based reports for financial applications and in Facets Table data modeling; planning, designing, implementation of the data warehouse and conducted testing by developing complex SQL queries.

ICICI Bank Mutual Funds, Hyderabad, TG.

August’2009 – Jan’2013

Business Analyst

Conducted various analytical requirement gathering JAD sessions and with the help of presenting various scenarios helped the business and technical team to reach an agreement on a range of ambiguous business deadlocks.

Worked in Scrum/AGILE methodology and created/prioritized product backlog.

Develop Project charter and obtained approvals.

Wrote User Stories along with Acceptance Criteria as a part of the AGILE methodology

Used MS Visio to create Use Cases and Sequence Diagrams.

Accomplished experience through whole SDLC from requirement analysis till deployment.

Assisted development team to translate requirements into technical specifications.

Provided key inputs in working with users in defining project and system requirements.

Assisted PM in setting realistic project expectations and in evaluating the impact of changes on the organization.

Created and documented Business Requirement Documents (BRD), Functional Requirement Documents (FRD) and Use Cases.

Ensured all artifacts complied with corporate SDLC Policies and guidelines.

Worked on the presentations for the workflow diagrams using Visio and PowerPoint.

Interacted with users regarding requirements by managing the change control process and updating existing documentation.

Worked on risk management – cross-confirmed KRI's (Key Risk Indicators), performed gap analysis, Adhoc queries, potential impact of specific threats and made recommendations to enhance existing controls or to implement new controls.

Coordinating and prioritizing outstanding risks and enhancement/system requests based on business requirements, allowing enough time frame to ensure accuracy and consider deadlines.

Developed product launch plans and created new product requirements based upon input from customers and competitive analysis.

Initiated Test Plans, developed and executed test cases and scenarios, worked with users to develop specific acceptance criteria and prepare test exhibits.

Conducted User Acceptance Testing (UAT) sessions with business users and prepared document for enhancements and bug fixes.

Created Use Case Scenarios, Test case Scenarios and maintained the Textual Use Cases (Business Use Cases, System Use Cases) and modeled Use Case Diagrams, Activity Diagrams, Sequence Diagrams and Business Flow Diagrams.

Contact this candidate