SUMMARY:

• Business analyst with Ten years of progressive experience in capital markets and financial technology with leading financial institutions in developing, implementing, and supporting financial IT solutions and applications.
• Extensive business analysis skills in both Agile and waterfall SDLC models. Expert in capturing user stories and business requirements and converting into solution specifications. Skillful at gap analysis and impact analysis.
• Regulatory and risk technology experience: Basel II/III, CCAR, Liquidity Risk, 5G, Delegated Act, and Counterparty Credit Risk. Recent working experience in Counterparty Credit Risk and Liquidity Risk Technology with OTC traded derivatives. Proficient in credit risk concepts such BASEL II/III, EAD, PD, RWA, liquidity risk concepts such as LCR, NSFR, 5G, Delegated Act, and market risk concepts such as VaR, Greeks and risk reporting.
• Knowledge of quant finance: NPV, IRR, CAPM, P&L valuations, Monte Carlo simulation. Knowledge of Financial and managerial accounting: reading balance sheets and income statements.

TECHNICAL SKILLS:

Requirement Management: JIRA, Confluence, SharePoint, JAMA, MS Excel, MS Word

Visual Modeling Tools: UML, MS Visio, MS Excel, Axure

Database Languages: SQL, PL/SQL, DB2

Databases: MS SQL Server, Oracle, Mainframes

Project Management Tools: MS Project, MS Excel, MS Word, iEST, working towards PMP

Programming Languages: Python, PowerShell, UNIX, C (basic programming skills)

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Senior Business Analyst

Responsibilities:

• Business Analyst for the IMM program - focusing on implementing data control systems to serve Credit Risk in compliance of regulatory guidelines to allow for BASEL IMM submission.
• Designed IMM Dashboard and led development and implementation efforts. The application would provide a consolidated view of data quality as captured by all IMM controls to the CCRA ahead of the IMM exam in 2017.
• Managed both waterfall and agile software development tracks in conjunction as part of the IMM program (managed 10 waterfall and over 20 agile sprint releases), handling all aspects of project management - budgeting, planning, resource allocation, tracking, exception management and reporting of milestones, risks, issues, dependencies to program management, and compliance & release management.
• Defined Functional requirements by performing in-depth analysis and built data mapping documents to successfully migrate trading platforms from Confidential to Merrill Lynch across various asset classes.
• Liaised with three different control teams, program management, CCRA, functional analysts and development team to ensure that solution design and implementation met the business requirements.
• Performed gap analysis to identify the attributes that are not available in regulatory strategic system and communicated the same to FO, book owners, and upstream and followed up to resolution.
• Extensively used JIRA for requirement management and project management: created stories, epics, prioritized tasks, starting/closing sprints, acceptance criteria, performed PO validation on completed stories,
• Multitasking - Worked on multiple concurrent tasks and projects simultaneously - most times performing both business/data analysis and project management tasks simultaneously.
• Performed intensive data quality checks on Master agreement ID derivation/breaks - as part of a major program to unify the product representation between Confidential and Merrill Lynch, existing since the merger. Built complex SQL queries (Joins, etc) and used advanced excel techniques (Pivot tables, lookups, advanced filters and functions) for day-to-day ad-hoc data analysis.
• Often handled over million data records during analysis - transferring from one system to another using various tools/scripts - SQL, MS Excel, BCP, python scripts, notepad++, PowerShell scripts.
• Ensured over 99% data quality on Trade population and on critical risk attributes for CCR IMM calculations - Master Agreement, Netting Indicator, Counterparty, Prime-brokerage indicator, Legal Entity.
• Worked on various OTC derivatives, including Credit Default Swaps (CDS), Options, FX derivatives, Swaps, Swaptions, Equities, FIFs, and Credit linked notes, and non-OTC such as Listed Futures & Options.

Environment: Basel II CCAR, Dodd-Frank, JIRA, Confluence, SharePoint, MS Excel, SQL, python, PowerShell, Unix, MS Word, MS Visio.

Confidential, New York, NY

Business Analyst

Responsibilities:

• Business Analyst for BASEL III regulatory projects - LCR (Liquidity coverage ratio), NSFR(Net Stable Funding ratio) 5G, and delegated act. Successful implementation of these projects enabled accurate liquidity risk calculation of the investment bank.
• Worked on multiple BASEL III regulatory projects - LCR (Liquidity coverage ratio), 5G, European delegated act. These projects enable the appropriate Federal banking agencies to assess the liquidity profile of the firm.
• Investment banking product exposure includes various OTC derivatives, including security lending, credit derivatives, FX products, Swaps (CDS, IRS, TRS), Options (FX, Equity), Futures and Forwards etc.
• Analyzed the trade data sourced from Front office, cash flow data sourced from risk engines and collateral data to come up with the requirements for LCR netted calculations and reporting.
• Documented the source to target mapping, detailed functional requirements and use cases for LCR/5G enhancements and presented the same to Liquidity risk business, development, QA and support teams.
• Gathered requirements for internal LRM control reports - Position vs cash flow, Position vs collateral, book level reports etc that enabled the users to identify data anomalies.
• Worked closely with Front office IT to present the 5G cashflow bucketing standards and associated feed requirements. Validated the cashflow feeds from FO systems to ensure that the feeds are in line with the 5G maturity buckets and standards.
• Validated the payables/receivables at master agreement level to ensure that the pre-aggregations and netting logic is applied correctly in the LCR netted output.
• Extensively used data analysis tools - SQL, MS Excel, BCP, Notepad ++, MS dos, Python scripts etc.
• Demonstrated subject matter expertise on LCR architecture and process and trained BAs, Dev, and QA teams.
• Led requirement review session with developers to assure that the use cases is feasible, complete and consistent, and provided subject matter expertise throughout the implementation process.

Environment: Basel III, 5G, LCR. NSFR, Delegated Act, CCAR, JIRA, Confluence, SharePoint, MS Excel, SQL, MS Visio, MS Word.

Confidential, New York, NY

Business Analyst

Responsibilities:

• Gathered user stories from different user groups, prioritizing and segregating them into multiple releases.
• Identified and resolved issues by making sure that there was no redundancy in the reports. Categorized the reports into 5 major types, distributed the reports into their respective logical categories.
• Managed risks, such as information overload in reports, delay in batch reports processing, changes in requirement, change management undertaking, and accurate data calculation.
• Analyzed data and processes through data analysis and SQL queries to understand which processes can be run simultaneously so as to keep up the pace of SDLC, ad where to iterate given the change in requirements, how to maintain the flow of data with the work flow, and the use of UMLs and Use Cases in helping the development and design team, along with the coders, understand the workflow, so as to maintain a process behavior.
• Built use cases, mockups, work flows, process flows, and entity relationship diagrams to aid the architect and development team in building the reporting application.
• Worked along side architects during the design phase to ensure that design handles all use cases, thereby minimizing defects at later stages of the project.
• Reviewed Technical Designs created by other IT developers and validated them against functional specifications.
• Engaged in mining and listing down all business rules under a single repository.

Environment: MS Word, MS Excel, MS Visio, SharePoint, SQL, Toad, .Net, System testing, UAT.

Confidential

Business Analyst

Responsibilities:

• Gathered user stories and developed detailed solution specifications, including use cases, wireframes, process flow, entity relationship diagrams to demonstrate the prototype of the solution to business users and to further aid in the solution development process.
• Built the application in agile mode by prioritizing user stories for each release, working closely with pricing managers and mathematicians in validating model results for each release.
• Reviewed functional specifications prepared by peers to ensure quality and eliminate discrepancies.
• Ensured business continuity by leading a team of 20 associates in a weeklong production data load.

Environment: Agile, MS Visio, MS Excel, MS Project, iEST, ETL, Quality Center, SQL server, Toad, Integration testing, UAT.

Confidential

Business Analyst/QA Lead

Responsibilities:

• Hands on experience with configuring and supporting IMS. Performed in depth Business Analysis and Technical Specification by working with Implementation Managers, Operations and IT and prepared Business Specifications, Technical Specifications, Data mapping documents
• Set up Compliance Rules and Compliance Tests (Concentration Test, Value Test) for Compliance

Environment: MS Visio, Crystal Reports XI, MS Project, DOORS, SQL Server, Auto sys, Excel/VBA