SUMMARY

• 10 years’ experience as Business Analyst in Financial services, Banking, Commercial lending and Capital Markets.
• Experienced in Business Analysis, Data Analysis, Business process modeling, Use Case Modeling.
• Good working knowledge in SDLC methodologies, Agile, Rational Unified Process (RUP) & Waterfall
• Good working experience in requirements gathering, brainstorming workshops, interviews with stakeholders/users/Subject matter experts.
• Knowledge in securities trade lifecycle - Front office, Middle office and Back office functions. Trade Execution/Capture, Trade matching, Trade confirmation, Clearing & Settlements (DTCC).
• Working knowledge in the Over the Counter trading system, InvestOne, SWIFT.
• Financial products Knowledge in Fixed Income, Futures, Options, Swaptions, Interest Rate Swaps, Mortgage Backed Securities, FX Swaps and Cross Currency Swaps.
• Knowledge in Credit Risk, VAR, PFE, CVA, DVA, Greeks, Bond duration, Convexity, ALM, P&L analytics, US GAAP (FAS 157, 133, 91), CECL.
• Working knowledge in Credit Risk (PD, LGD, EAD), economic capital and IPV calculations.
• Working knowledge in spreading financial statements, key performance indicators (KPI) for Bank, NBFI, Financial Markets and Real Sector to produce Credit Risk Rating.
• Working knowledge in commercial lending products (loans, syndications, guarantees, line of credits, letter of credits) and commercial lending applications - Cassiopae and ACBS.
• Working Knowledge in the price verification of mortgage backed securities.
• Experienced in gathering business requirements, functional requirements, conducting GAP analysis, Impact analysis, current state analysis and proposed state analysis.
• Produced deliverables business requirements, functional requirements, functional specs, process flows, use cases, process mockups, test plan, test cases and test summary for sign off.
• Experienced in testing, working with QA teams and business users in conducting SIT, UAT, Regression testing and Stress testing including BUG triage.
• Coordinated with off-shore teams like business analysts, developers & testers in the development and testing activities
• Worked in team environment and developed relationship with external customers and internal counterparts.
• Good analytical, problem solving, organizational, communication and documentation skills with the ability to handle multiple tasks effectively and quickly master new concepts and subjects.

TECHNICAL SKILLS

Areas Interested: Commercial Lending, Credit Risk, Trading/Settlement, Compliance/Regulatory Reporting.

Business Skills: Business analysis, Data analysis, Use Cases, Data mapping, Business process modelingFinancial Modeling, Requirements gathering and UAT/Regression/Stress testing.

Tools: used: Agile, RUP, SQL, ALM, JIRA, MS Visio, Wireframes, Power point, word, excel, IPV, IRP, ACBS, Cassiopae, Tableau

PROFESSIONAL EXPERIENCE

Confidential

Business Analyst and UAT Tester

Responsibilities:

• Worked closely with loan officers to implement functionalities in Cassiopae related to long term loans (fixed and variable), Libor loans, ABR loans, Syndicated loans, Syndicated guarantees, line of credits (fixed and variable) and letter of credits.
• Worked closely with the business users to capture requirements at the product level and the business processes at the product level to implement the product level functionalities in Cassiopae.
• Performed analysis at the product level, loan level, borrower level, data capture at various stages, data flow to downstream systems.
• Delivered requirements related to functionalities like commitments, disbursements, prepayments, overpayments, amortization, rollbacks, letter of credit issuances, fees, invoicing, internal transfers, rollovers, accounting etc.
• Lead the User acceptance testing and regression testing life cycle.
• Developed test cases to test the various functionalities in the Cassiopae related to loans, line of credits and letter of credits.
• Reviewed the test cases and test results with the business users before UAT test sign off to ensure test results are as expected.

Confidential

Business Analyst

Responsibilities:

• Engaged with loan officers/Syndicated officers to implement functionalities in ACBS 6.7 for fixed rate loans, variable rate loans, discounted value loans, syndicated loans, sub ordinated loans, Quasi equity products, guarantees, syndicated guarantees, Co-lended loans, trade finance program, supplier finance program, trust funds etc.
• Involved in the functional analysis to propose solutions for the Non-Regular Derivatives Counterparty Framework (NRDCP) in ACBS.
• Proposed daily compounded interest rate calculation based on ISDA compounded interest rate formula for loans in Columbian Peso currency booked in ACBS.
• Developed functionality for GTSF program to book interest as Flat Fees using transaction code 3800.
• Worked closely with the Trust Funds Group to develop Co-lending portfolio report syndicated loans and management team.
• Developed Donor Fund reports specific to Trust Funds operations unit called Blended Finance Report.
• Developed automated workflows for commitments, disbursements, billing, payments, other loan accounting transactions.
• Developed functionality to auto unbill maturity invoice in ACBS, if the invoice is generated on a date other than GTFP invoice due date.
• Engaged with the credit risk business users to understand the credit risk rating process for both loan and equity exposure to develop business requirements for IRP.
• Engaged with the business users to understand the purpose of Economic capital, develop business requirements related to inputs required and the simulation results (VAR, Capital Ratio) that will be generated based on risk factors and selection criteria (configuration parameters and simulation data run parameters).
• Engaged with credit risk business users to develop the credit risk rating modules based on S&P scorecards for Bank, Financial Markets (NBFI) and Real Sector ( Corporate Finance and Project Finance).
• Engaged with the spreading business users to develop financial templates and key performance indicators (KPI) for Bank, Financial Markets (Leasing, Life Insurance, General Insurance, Investment Funds and Others) and Real Sector.
• Involved with the business users to develop the revaluation process for General and Specific loss reserve accounts that are reported in the balance sheet in the local currency instead of USD for the Investment Portfolio reporting.
• Performed data mapping for the chart of accounts from Moody’s Financial Analytics to the financial templates that was developed for Bank. Financial Markets and Real Sector.
• Performed financial modeling, data analysis and data mapping related to credit risk and market risk data to conduct root cause analysis with respect to inputs required and model results validation for scoring and economic capital.
• Developed business process mapping portfolio data and market risk data along with configuration parameters and run parameters to produce simulation results.
• Involved in the root cause analysis to develop financial templates and how the financial data is captured by score cards to produce PD & LGD ratings.
• Lead the User acceptance testing and regression testing life cycle.
• Developed test cases to test the credit risk rating modules and spreading the financial templates to ensure the calculations by the financial templates and the PD and LGD ratings that is produced by the system are accurate.
• Reviewed the UAT test cases and test results with the business users before UAT test sign off to ensure test results are as expected.

Confidential

Business Analyst

Responsibilities:

• Engaged with the pricing & price verification business users to understand the price verification business process
• Engaged with the Black Rock solutions group to analyze the work flow regarding the data flow (trades) from Aladdin to the pricing application.
• Engaged with the business users to understand how securities, Loans & Derivatives are priced and verified using external price sources (Barclays, Reuters, Investment Reporting Database (IRDB) & Bloomberg Valuations (BVAL)).
• Involved in the root cause analysis and proposed new business requirements related price verification of Securities, Loans and Derivatives.
• Performed business analysis to gather business requirements for the price verification of various mortgage backed securities (Single Family, ARM and Multifamily).
• Involved with IPV users and developers to discuss the price verification functions and solutioning the business requirements.
• Performed data analysis and data mapping from the source systems to price verification systems to ensure data is captured for calculating the expected market prices and variances.
• Lead the User acceptance testing and Regression testing in testing the calculation of prices and their variances.
• Developed test cases to test pricing & price verification functions for securities, Loans and Derivatives.
• Responsible to ensure that User acceptance testing and Regression testing complies with Software Development Life Cycle (SDLC) and Sarbanes and Oxley Act (SOX) guidelines.