SUMMARY

• Highly motivated Business/Data Analyst professional with 5+ years of experience in Finance industry, currently seeking a contracting position with a growing company
• Good understanding of all the Capital and Financial Markets, Financial Instruments, Treasury Securities, Derivatives (Swaps, Options and Futures), Credit Derivatives, Trading systems.
• Familiar with AML, KYC, Dodd Frank Compliance, OFAC, FATCA Investment Banking, Trade Life Cycle.
• Familiar with report specifications for FRY9C and CCAR A/Q/M/ data analysis.
• Excellent understanding of financial products (SWAPs, Equity, Fix Income, Options, Mutual Funds, ETFs, OTC).
• Strong understanding/exposure to Market Risk data flows from front to back (front office systems, market risk management systems into strategic market risk data repository/reporting systems.
• Strong understanding of various Capital Market instruments including Equities, Fixed Income, Derivatives and the Financial Valuation concepts.
• Knowledge of Basel II/III, Credit Risk, Market Risk/Liquidity Risk Modeling and Management, Quantitative Approaches including Monte Carlo Simulation, and VaR.
• Comprehensive knowledge on Certificates of Deposits, Agency Securities, Asset - Backed Securities (ABS), Mortgaged-Backed Securities (MBS), Collateralized Mortgage Obligations (CMO), Collateralized Debt Obligations (CDO).
• Extensive knowledge in Software Development Life Cycle (SDLC) including: Waterfall, Agile (Scrum & XP), Rapid Application Development (RAD), and Rational Unified Process (RUP) methodologies.
• Expertise in preparing Business Requirement Documents (BRDs) and Functional Requirement Documents (FRDs), Use Case Documents (UCDs), User Interface Document (UIDs), Test Case Documents (TCDs)and creating Prototypes, Mock Ups, Artifacts, Wireframes, User Story, Requirement Traceability Matrix.
• Experienced at facilitating Joint Requirement Planning (JRP) and Joint Application Development (JAD) sessions with Subject Matter Experts (SMEs)/end users/development group/Client, asking detailed functionality aspects of business process and carefully updating the information related to requirements.
• Experience in analyzing and creating Use Case Diagrams, Activity Diagrams, Data Flow Diagrams, Workflow Diagrams, Wireframes, Class Diagrams, and Sequence Diagrams using MS Visio, IBM Rational Software Tools.
• Adept in conducting GAP analysis, SWOT analysis, Cost/Benefit analysis, Impact analysis, RACI analysis and Return on Investments analysis (ROI)
• Expertise in conducting Requirement Elicitation techniques such as interview, brainstorming, focus groups, prototyping, requirement workshops.
• Coordinated with Scrum Master for Project Progress and Release Management. Managed Product and Sprint Backlog to achieve the Sprint objectives in Agile methodology.
• Conducted Sprint Panning, Sprint Review, Sprint Retrospective and Daily Scrum/ Stand-Up Meetings, Acceptance Criteria to accomplish the Time Boxed tasks and deliver shippable product in every sprint.
• Experience in reviewing Test Cases, interacting with team members in fixing errors, automated testing, User Acceptance Testing (UAT).
• Strong team player with Problem Solving skills and effectivePresentation skills.

TECHNICAL SKILLS

Business Tools: SAP/Sybase Power Designer, Rational Suite Enterprise, Bizagi

Methodologies: Waterfall, RUP, Agile-SCRUM

Testing Tools: Silk Central, JIRA, BugZilla, HP Quality Center

Languages: HTML, CSS, XML, SAS, JAVA

Database: MySQL, MS Access, Oracle 11g, SQL Server

Data Analytics Tool: SAS Enterprise Miner, Tableau

User Interface Tools: SnagIt, SmartDraw, Just in Mind

Microsoft Tools: MS Excel, MS Visio, MS Project 2013, MS Word, MS PowerPoint.

PROFESSIONAL EXPERIENCE

Confidential, Pittsburg, PA

Business Analyst / Data Analyst

Responsibilities:

• Performed Requirements Elicitation by conducting interviews, surveys, workshops and created BRD and FRD
• Created Business Requirements Documents (BRD), Functional Requirement Specification (FRS), User Requirement Specification (URS) and Change Request (CR) document.
• Interacted with Senior Management to understand their requirements regarding integration of Previous Day reporting and Current Day Reporting.
• Conducted Gap Analysis of the features and functionality of current platform version and new version to determine the new functions to be added in.
• Facilitated Daily Agile/Scrum meetings, Sprint planning, Sprint review, and Sprint retrospective meeting.
• Authored various Use Cases and UML methodology to define the Data Flow Diagram (DFD).
• Conducted AD sessions, user interviews, and detailed research and requirement meetings to capture the requirements and prepare BRD.
• Made use of REST API to integrate Previous Day Reporting and Current Day Reporting databases.
• Made use of XML to transport data from the aforementioned systems.
• Created User Interface Document (UID),Wireframes, Prototypes to help developers in the development process.
• Developed Process Model in MS Visio and detailed Business Policies. Created documentation on supporting the newly designed modules.
• Worked with SME's (Financial Analyst, Risk Managers, Project Managers) and conducted Joint Requirement Planning (JRP) sessions as a facilitator to define business critical needs.
• Developed UMLUse-Cases and Use-Case diagrams to understand how the user is interacting with the system.
• Analyzed and prioritized Sprint Cycle Time Boxed Tasks, Acceptance Criteria andUser Stories from Product Backlog to Sprint Backlog and review the Prototype on regular basis in Scrum Agile SDLC.
• Performed Data mapping before the Data Integration to check what kind of data should be integrated in the new system.
• Before performing the Data Integration, collaborated with development team to check if the data is in the same format.
• Managed Product and Sprint Backlog and helped Product owners with the Release plan.
• Performed various analysis using techniques such as GAP Analysis to understand As- Is and To- Be process, Root-Cause Analysis to analyze decision and review the Impact Analysis of changes in the solution.
• Conducted walkthroughs with the end users and stakeholders to gather the modification requests to record in Change Requirement/ User Story Document.
• Actively managed Requirement Traceability Matrix (RTM) for higher management review and used JIRA to log the defects from various testing phases.
• Participated in Bug-Review/ Bug-Resolution Meetings with software developers, QA engineers, managers and suggested enhancements to the existing application from business perspectives, provided solutions to existing issues.
• Involved in design and implementation of Progression and Regression Tests and also reviewed Test Plan and Test Cases.
• Managed bugs using Defect Tracking ToolJIRA, reviewed each defect and assigned development team to resolve problems.
• Conducted quick Smoke Test after each bill in testing and Planned User Acceptance Test (UAT).
• Created Requirement Traceability Matrix (RTM) to keep track of the requirements.
• Extensively evaluated the Acceptance Criteria that was used by developers, testing team and by Product Owner to ensure that the intent is effectively captured.

Environment: Agile, Waterfall, JIRA, MS Visio, MS Excel, RTM, MS Visio, Oracle, Windows 7, Power Designer

Confidential, New York, NY

Sr Business/ Data Analyst

Responsibilities:

• Interacted closely with stakeholders and Subject Matter Experts (SME) for requirements gathering and clearly documenting, and holding joint application delivery sessions across functional areas to ensure requirements covering on business values, story points and acceptance criteria.
• Conducted walkthroughs for handling complex security issues arising due to implementation of Straight Through Processing (STP) radar.
• Extensive experience in checking and maintaining the quality of data in the warehouses by performing data profiling.
• Coordinated in implementing a project for Fixed Income Securities like different kinds of Bonds, Default swaps, Rate swaps for Exchange as well as Off-Exchange Trading.
• Mapped FIX Protocol used for the exchange of critical financial/trade information.
• Data Mapped on the sell-side of OMS which does Pre-trade, Trade, Post-trade and transform electronic communication of pre-trade and trade message between Financial Instrument.
• Used Calypso Trading Platform which is a Risk Management Platform. It is mainly to deal with CDS and IRS for safety and soundness of Market. The Collateral Management and Margining been handle by that software.
• Tracked agency obligations and expenditures using the automated Comprehensive Cost and Requirements (CCAR) System.
• Gathered historical market data for end-of-day positions, VaR calculations
• Gained good understand of OTC Life Cycle Processes.
• Improvising STP trade processing for the various clients reducing manual intervention on trade processing.
• Used Data Mining (Regression Analysis) to identify current market trends and collaborated with development team for Data Integration.
• GatheredCCAR, PPNR and supplementary metrics (FR Y-14, FR Y-9C) forecast from different business units.
• Worked with Risk Reporting Team to generate FRY9C and CCAR A/Q/M/ data analysis and reporting.
• Created forecasting model based on various market variables using Data Mining techniques.
• Prepared use cases and UI for Receiving and booking trade tickets and allocated trades via the allocation schedule and for asset management.
• Intense Expertise in creating UML diagrams like Process Flow Diagrams, Sequence Diagrams, Class Diagrams and Use Case Diagrams.
• Update and manage SharePoint Site for each CCAR cycle that is utilized for CCAR communication, storage of key CCAR files including business models, and automatic audit trail that is sent to internal audit team.
• Created and maintained User Stories by workshop, interviewing, brainstorming, one on one meetings with the business users to communicate the requirements to development and testing teams.
• Validate Loss Data for external CCAR reporting, also Conduct root cause analysis for DataRemediation.
• Made use of SSRS to create various reports and delivering it to the senior management team.
• Conduct Gap Analysis of the features and functionality of current platform version and new version to determine the new functions to be added into address these issues and implement proper solutions.
• Consulted the business users and SMEs, helped to create Product Backlogs to prioritize features and subsequently created Sprint Backlogs.
• Played lead role in JADsessions, got requirement specification documents including Project Objectives, Business Requirements, and Business Rules sign off.
• ConductedDaily Stand-up Meeting, documented and updated the Burn-Down Chart.
• Involved in Walk-through sessions with developers and gave presentations to help them understand the end user needs.
• PerformedSQL Queries to retrieve and validate data, prepared for data mapping document.
• Collaborated with QA team to create and implement test plan and test cases for User Acceptance Testing (UAT). Involved with the whole UAT to ensure the performance of the system and application.
• Developed User Manuals, presentations and training manuals as per project specifications and timelines.
• Model the detailed design of the system using UML diagrams including Sequence Diagrams,Activity Diagrams and Use Case, and Data Flow diagrams.
• Coordinating requirements gathering, design review, test script creation, Integration/ Performance/ UAT activities as part of break-fix and enhancements requests.
• Conducting brainstorming sessions with Business Users to gather raw requirements and facilitated Joint Application Development (JAD) sessions to make sure that project is in scope.
• Extensively worked in Agile frame work throughout all the phases of Software Development Life Cycle (SDLC).
• Reviewed controls for regulatory compliance and update new controls when necessary.
• Worked closely with Subject Matter Experts (SME) of all applications for different types of risk control violation, including conference call and raising Jira ticket for change request release.
• Maintained a Requirement Traceability Matrix (RTM) to ensure that all Functional Requirements are addressed at the Use Case Level and matched with the Business Requirements.
• Track new business actions, project progress, reporting issues, and manage issue escalation.
• Have been extensively involved in formulating Root Cause Analysis (RCA) of each of the UAT Defects by using various techniques like Fish-bone Analysis.
• Involved in design and implementation of Progression and Regression Tests of the new functionalities added in system.
• Conducted quick Smoke Test after each billing in testing and planned User Acceptance Testing (UAT).
• Conducting Scrum meeting with technology team to discuss possible solutions for requirements from the business team, and review the work of current phase
• Created Requirement Traceability Matrix (RTM) to keep track of the requirements.
• Managed bugs using Defect Tracking Tool JIRA, reviewed each defect and assigned development teamto resolve problems.

Environment: UML, MS-Visio, MS-Project, SQL Server, Windows, JIRA 7.1.0, Power Designer, Agile, MS SQL

Confidential

Business Analyst/ Data Analyst

Responsibilities:

• Performed Requirement Elicitation techniques to extract requirements from senior managers.
• Worked extensively to understand and document the requirements for the new modules which were being added to the system.
• Performed GAP Analysis to identify problems and inconsistencies with the business requirements specification and the existing system.
• Created Wireframes/ Mockups using Balsamiq tool for both the new modules which are being added to the current system.
• Designed and developed UseCase Diagrams, Activity Diagrams, Sequence Diagrams, and Collaboration Diagrams using MS Visio.
• Created Business Requirement Document (BRD), Functional Requirement Document (FRD). Non-Functional Requirement Document (NFRD), Use Case Document (UCD).
• Conducted JAD sessions with the management, vendors, users and other stakeholders for open and pending issues to develop specifications.
• Maintained Requirement Traceability Matrix (RTM) document throughout all the phases of SDLC to map requirements with test cases
• Provided detailed User Interface Document to the development and testing team for clear understanding of the system.
• Served as a liaison between the Business and Technology Department. Enhanced communication lines between executives, managers, and peers.
• Assisted the Scrum Master in facilitating daily Scrum meetings, Sprint Planning, Review and Retrospective meetings.
• Responsible for documenting and distributing the minutes of the weekly meetings to the Program Manager and other team members.
• Created Burn-down Charts to monitor the completion of work within the time-boxes.
• Collaborated with development team to make sure all the promotions are showing up on detail page.
• Extensively evaluated the Acceptance Criteria that was used by developers, testing team and by Product Owner to ensure that the intent is effectively captured.
• Carried out regular meetings and walk through with development team members, Project Managers and Quality analyst to better understand system functionality.
• Interacted with the developers to explain the proposed changes and understand the system requirements to handle these changes.
• Used JIRA to manage defects throughout all the phases of software development life cycle and communicated with multiple departments to resolve the defect.
• Coordinated with different responsible parties to remind them to take care of the pending Bugs using tools like JIRA to ensure that the quality of the system meets the industry standards and business users’ requirements.
• Conducted training sessions and updated Product Manual upon successful delivery of each sprint.
• Involved in Change Management process and performed impact analysis. Updated Requirement Traceability matrix after the changes was implemented.

Environment: Agile, MySQL, JIRA, MS-Visio, MS-Project, Balsamiq, Justinmind, SAP Power Designer, MS Excel, MS Access, Windows 7, RTM, Bizagi