We provide IT Staff Augmentation Services!

Sr. Finance Analyst Resume

3.00/5 (Submit Your Rating)

New York, NY

SUMMARY:

  • Extensive seven years of experience in roles such as Project management and Senior Business Analyst with excellent knowledge to the full Software Development Life Cycle (SDLC) methodologies, frame works and processes. Experienced in managing requirements from project inception through release.
  • Good domain knowledge and work experience in Banking, Investment Banking, Health care, Insurance and Financial services, Hedge funds and trading.
  • Advanced knowledge of Fixed Income — Corporate Bonds, Government Securities (T - Bond, T-Bills, T-Note, and Municipal Bonds), Money Market Securities, Mortgage and Asset Backed Securities (MBS and ABS). Knowledge in SOX (Sarbanes Oxley) compliance.
  • Expert in Software Development Life Cycle (SDLC), Object Oriented Analysis and Design and Agile Methodology. Experience in JAD Sessions, Live Meetings and Interviews.
  • Create regulatory data specifications for new FRY-14 (CCAR), FRY-15, FRY-9C, and FFIEC 031 schedules for new bank holding company clients.
  • Hands on experience with reporting tools like Doors Erwin Data Modeler 4x, Business Object (Crystal Reports),Cognos, Informatica
  • Conducted data modeling activities to map products (Equity, Bonds, Loans, etc) with the existing processes.
  • Involved in analysis of various types of risks (Credit Risk, Market Risk) which impact the portfolio management.
  • Provided solutions for cross-asset trading, back office, collateral management, margin management, risk management, operational and portfolio management for financial.
  • Gathered business requirements through interviews, surveys, and observing from account managers and UI (User Interface) of the existing Brokerage Portal system.
  • Knowledge and experience all areas of project life cycle in a highly structured change management environment using both proprietary methodologies, Agile Techniques and RUP.
  • Prepare analytical reports on sovereign wealth funds, public and corporate pension plans, family offices, and fund of fund
  • Well versed in project management tools like MS Project for project planning, Project scheduling. Organized JAD sessions to gather requirements at various stages.
  • Good understanding of Project Process and ability to analyze business problems and identify solutions.
  • Worked extensively with the team to meet business requirement, create prototypes and analyze workflow.
  • Experience in dealing with web services, web technology related application and experience in infrastructure design changes.
  • Experienced in creating Business Requirement Documents, User Requirement Specification, and Functional Requirement Specifications. Experienced in creating Data Flow Diagrams, Use Cases, State Diagrams, Sequence Diagrams, Component Diagrams, Use Case Diagrams & Activity diagrams.
  • Well versed in Process Narratives, Flow charting Techniques using UML and Good Documentation Practices. Prepared documents to conduct user acceptance testing. Good working experience in all the sprints of the project in SCRUM.
  • Coordinated multiple site visits for industry leading commercial lending system vendors
  • Tableau security and maintenance on the server by adding users giving access and securing the reports and data.
  • Constantly monitoring Tableau performance on the server as well as the dashboards/workbooks to maintain a smooth flow of data.
  • Experienced in functional, regression, UAT, Back End/Database Testing and stress / load /performance testing of web-based and client-server applications using Mercury Interactive Test Suite: Win Runner, Load Runner, Quick Test Pro and Quality Center.
  • Knowledge in the ETL (Extract, Transform and Load) with Informatica into a data ware house/date mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence). nitor various Treasury applications to support multiple business units - BDC, TM Connect File
  • Transfer, ACH, S1, BAI, Lockbox, FIS / Metavante, SunGard Billing, Respondent Bank, Swift, Loan Management, OFAC, EPA/PayPoint, Hogan, TM Connect Web, MoneyNet, Standard Register, ICPM, GlobalScape.
  • Excellent documentation skills including writing Business Requirements Documents (BRD) and Functional Requirement Document (FRD), as well as designing business models, Entity-Relation Diagrams, and process flows based on UML methodology.
  • CCAR: Strong knowledge with Basel III, CCAR, FR-Y 9C, FR-Y 14Q, PPNR, FR-Y 11, FR-Y 9LP, FFIEC 031, FFIEC 041, FFIEC D09, Dodd-Frank, KYC, AML, FINRA's rules and regulations
  • Skilled in performing Gap analysis and Impact Analysis by identifying existing technologies, documenting the enhancements to meet the end-state requirements. Extensive understanding of Operations Management and Logistics. Exposure to Change Request Management tools like Clear Quest.
  • Assisted QA team in developing Test Scripts, Test Cases and Test Plans for the User Acceptance testing.
  • Experienced in all areas of project life cycle in a highly structured change management environment using both proprietary methodologies, Agile Techniques and RUP (Rational Unified Process).
  • Conducted GAP Analysis, SWOT Analysis, Cost Benefit Analysis, Risk Analysis and Impact Analysis.
  • Effective in executing multiple tasks and assignments ahead of schedule. Strong Image for dedicated teamwork, high energy, work ethics and commitment with capability to handle new technologies and situations.
  • Team player and self-starter with excellent communication, coordination, documentation, project planning and interpersonal skills.
  • Good understanding of Basel framework, Market Risk, Liquidity Risk, Credit Risk and other financial and regulatory report filings.
  • Specialized in key business processes as per Leading Industry Practices toolkit to identify controls that help mitigate inherent operational and financial risk for Business Processes.
  • Managing implementation of Dodd Frank trade reporting and reconciliations.
  • Excellent Financial Product knowledge in Equity; Fixed Income (CDs, Treasury Bonds, Corporate Bond, Municipal Bond, Money Market, Repo, and Eurobonds); Structured securities, Derivatives: Futures, Forwards, Options, SWAP(interest rate swap, currency swap, Swaptions), Credit Derivatives -CDS, CDOs, CLNs, variable rate securities, Loans, Risk, AML & KYC, Dodd-Frank/Volker Rules, and Basel II.

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Sr. Finance Analyst

Responsibilities:

  • Wrote business process flows with user scenarios description (high level sequence diagrams and activity diagrams)
  • Analyzed and documented the business requirements, meeting minutes, responses to questionnaires and got approval of the documents from the client in the form of sign off.
  • Comprehensive experience in Root-cause analysis, Feasibility studies, GAP and Variance analysis, Impact analysis, Risk analysis.
  • Developed strategies with Quality Assurance group to implement Test Cases in Mercury Test Director for stress testing and UAT (User Acceptance Testing).
  • Gathered, Reviewed, analyzed, profiled, validated, and mapped system data into the data warehouse to meet reporting and analytical business needs.
  • Developed business requirements in SAP Business Objects Data Services.
  • Created Data Movement Models in SAP Power Designer for data lineage.
  • Tested the ETL Informatica mappings and workflow Processes and Built / Maintained Dashboards and Reports (Tableau, Cognos, SSRS).
  • Responsible for identified and creating Business Use Cases from requirements, created UML Diagrams including Use Cases Diagrams, Activity Diagrams, Sequence Diagrams and Class Diagrams using Lucidchart.
  • Performed data analysis by writing SQL queries against Oracle tables and views.
  • Developed various use cases, workflow, screen mock-ups, and conversion requirements.
  • Conducted risk engineering to derive and execute action plans on time.
  • Responsible for testing the entire application with Manual and Automated Strategies.
  • Responded to commercial lending inquiries from customers and Loan Officers
  • Created Test Plan and Test Case Templates for testing the entire application.
  • Interact with business users and subject matter experts to produce technical documentation and business requirement documents (BRDs) for CCAR filing for FR Y-9C, FR Y 14M, FR Y 14Q, and FFIEC 031 reports as well as IHC filing.
  • Functionality includes Security Bond Administration, Disclosures, P&I accounting and cash management.
  • Responsible for performing Functional, Integration, Performance Testing and End to End testing. Involved in quality assurance phase planning, coordination an implementation of QA strategy for overall project. Performed user acceptance testing (UAT) to validate user requirements and expectation.
  • Running usability of testing for readiness, and create procedural manual based on the need of the client.
  • Conducted Business Requirements Gathering sessions in the form of questionnaires and business scenarios with the end users, subject matter experts (SME) and the developers.
  • Schedule and conduct meetings with Client for Requirements gathering, Initial assessment/work estimation.
  • Worked with the Functional Analysts in Use Case to GUI mapping for the application.
  • Created Requirements document' (System Requirements Specification document) of artefacts produced by Functional Analyst, UI Designer and all Stakeholders.
  • Posting set changes that generate daily posting entries to the firm's General Ledgers and Reconciliations with other downstream systems (Back Office / Stock Record systems).
  • Additional requirements gathering for downstream feed and Reporting of P&L for Basel 3 reporting and other various key consumers of GTPL (Regulatory Compliance Systems, Counterparty Exposure Systems, Market/Liquidity Risk Systems).
  • Writing relational and multidimensional SQL database queries for data analysis.
  • Monitored project status to ensure progress toward completion, required procedural steps are completed fully and timely, participants are informed of progress. Tested the customer service management module in Amdocs.
  • Provided Systems Testing & Integration for the Ensemble and Enabler modules of the Billing System.
  • Measuring Risk using: VaR, Monet Carlo Simulation and Variance-Covariance and Use multiple market risk metrics for portfolio management.
  • Manage company audits (FFIEC, SOC, Card Associations, Risk Assessment) and received no findings or graded as low risk
  • Collaborate with the Tax team, Sales, On-boarding teams and clients globally to obtain accurate FATCA documentation.
  • Developed a plan to achieve compliance with Dodd-Frank regulatory legislation as it relates to over-the-counter derivatives.
  • Analyze business requirements from Operations and Compliance, and translate them into functional specifications for the AML Case Management System.
  • Strong business analysis skills and an understanding of the software development life cycle (SDLC) utilizing Rational Unified Process (RUP).
  • Experience working on Informatica Powercenter, SQL/PLSQL, experience in Software Development Life Cycle (SDLC) processes and Object Oriented Analysis and Design (OOAD).
  • Facilitated communications between the critical stakeholders involved in the project to upgrade commercial loan applications by coordinating core project activities, such as meetings coordination/notes, test cases definition, technical requests, and followed up on status/next steps.
  • Leveraged prior global fixed income trading and portfolio idea generation experience to align the solution with industry standard best practices while also reducing operational and/or investment risk.
  • In addition to LCR (Liquidity Coverage Ratio) Reporting, balance reconciliation with books and records, adjustment posting and report circulation. Portfolio covers Deposits received from Retail, Securities (Sec lending, Repo), Treasury, Private Banking, Commercial.
  • Collaborate with various Cross functional teams located across different geographical locations for the Portfolio governance and PMO organization.
  • Collected user requirements to create a technological platform to perform transaction -related asset level due diligence, analytics and cash flow modeling, structural and document review.
  • Managed multiple functional and technical stakeholders, gained sign-offs and senior mgmt. involvement to conduct impact analysis for Collateral Operations.
  • Mapped high-level to-be designs using Business Process Modeling Notation (BPMN) on MS Visio.
  • Perform XML regression testing and validation via SOAPUI platform for our webservices
  • Generated requirements for Capital Markets - Fixed Income Investment Management Business, Portfolio Management, Hedge funds, corporate actions, Brokerage and Trading Model within the scope of both the Front and Middle Office.
  • Created charts of the data in both EXCEL and Tableau and displayed them in PowerPoint presentations.
  • In depth knowledge about the framework and foundations of risk management, excellent understanding of banking requirements and regulatory compliances, such as Basel III, Basel II, CCAR & Dodd Frank Act/Volker rules

Confidential, Cleveland, OH

Sr. Finance Analyst

Responsibilities:

  • Regular discussions with developers to make them understand the use cases and function requirements of the client. Excellent Ecommerce applications / websites experience.
  • Responsible for supervising work activities (Development, Testing) to ensure that they are well-performed, coordinated among team members and consistent with the approved work plan.
  • Experience in collaterals and lending allocation process involved in the Bank and the research reports for various businesses. Designed and developed custom enterprise business system solutions using Microsoft and Java technologies.
  • Assisted the Quality Assurance team in reporting defects and bugs to development team using Mercury Test Direct
  • Capturing and maintaining metadata and data-linage for data warehouse and reporting components
  • Researching data integrity and quality issues while creating metrics to track data quality and providing recommendations for resolving issues.
  • Coordinated the design phase with the architects in improving the efficiency of the project.
  • Worked with QA team in identifying test cases/test data and lead the business team for UAT.
  • Documented all custom and system modification. Assigned problems to appropriate software development team for fixes. Tracked problems from start to correction and test.
  • Used Rational Rose and UML (OOAD) to design Use Case, Class, Activity, and Sequence diagrams for Functional Design documents
  • Interacted with technical team in allowing them to make a better navigational plan for the project flow which would further make a better user interactivity tool for the application.
  • Signed off progress and completion reports which were then submitted to project management on a weekly basis.
  • Worked as a Business Analyst/QA/UAT Coordinator in Market Risk Division that intended to implement regulatory framework (as per FSA, FINMA, BASEL) and related reports for Basel 3 regulatory requirements, Credit Valuation Adjustment (CVA), RNiV(Risk Not in VaR) etc.
  • Coordinate with members of the rules tracking team to enter finalized Dodd-Frank related rules from all applicable regulators into the Sharepoint site.
  • Use of business intelligence tool Informatica to complete ETL tasks.
  • Proficient with XML, XML Namespaces, XML Schemas, XSD's, DTD's, HTML, Java Scripts and Web Services. Complete Knowledge in explaining XML's, XML Schemas and web services to business.
  • Logical and Physical data modelling, OLAP analysis and cube development with cognos Dynamic cubes.
  • Conducted gap analysis and documented results and Used SWOT analysis to resolve issue.
  • Gathered compliance requirements needed for SOX testing.
  • Responsible for the Intermediate Holding Company (IHC) Financial & Regulatory Reporting work streams
  • Managed asset-backed security bond payment processes, model improvements, and investor reporting
  • Developed both Physical and Logical Data Models of Oracle and SQL Server Tables.
  • Helped prepare Logical Data Models that contains set of diagrams and supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the data elements to analyze and document business data requirements.
  • Modeled cash flows for securitized transactions containing wide variety of underlying asset classes. Responsible for creating proprietary Excel-based models to calculate bond waterfalls, over collaterization and interest coverage ratios, and several other portfolio criteria.
  • Assisted developers to create a platform for compliance reporting tie-out process and to review note valuation reports prepared by CDO corporate trusts on a monthly/quarterly basis.
  • Created excel based models to calculate both the distribution of cash flows to all related parties of a deal as well as various collateral criteria set forth in legal documents.
  • Performed agreed-upon-procedures related to collateralized loan obligations (CLO) and other structured products and maintained client relations with key personnel at prominent institutions.
  • Support of listed/OTC derivatives and Hedges trade capture or trade ordering requirements for such systems or platforms.
  • Created Business Requirements Gathering sessions in the form of questionnaires and business scenarios with the end users, subject matter experts (SME) and the developers. Gathered user and business requirements through interviews, surveys and prototyping.
  • Analyzed and prioritized user and business requirements as system requirements that must be included while developing the software. Planned and defined system requirements to Use Case, Use Case Scenario and Use Case Narrative using the UML methodologies.
  • Created Use Case Diagrams, Data Flow Diagrams, Activity Diagrams and Sequence Diagrams in MS Visio.
  • Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues. Implemented SOA concepts (search oriented architecture) for the application and implemented search engine based techniques.
  • Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
  • Performed quantitative and qualitative analysis across all asset classes including stocks, mutual funds, international and domestic investments, private equity, and real-estate
  • Assist Equity Derivatives IT in Risk Valuations, Scenarios, and Modeling/Analytics.
  • Understand AML policies and procedures which aid in identifying potential unusual activity or transactions.
  • Creating Agile User Stories for an online Loan Management System (LMS) for Sprint Cycle development.
  • Responsible for fixed income trade support, including ensuring trades to comply with client needs and restrictions and all buy/sell rebalancing issues resulting from changes in individual account information.
  • Formulating a comprehensive Liquidity Data Lineage / Sourcing Inventory as part of Finance Change and Treasury IT’s Liquidity Risk Management and Reporting program. Strategy geared towards Architecture simplification.
  • Onboarding and trade relations for international FATCA compliance. Document review/compliance approvals.

Confidential, Charlotte, NC

Finance Analyst

Responsibilities:

  • Responsible for Risk Analysis to detect the risks associated with the development of the new system. Additionally, formulated a Mitigation Plan to remove or reduce risks of high severity and one that would have major financial impacts.
  • Played a pivotal role in conducting Functional testing, Regression testing, Integration testing, Smoke testing and UAT (User Acceptance Testing)
  • Researched and corrected edit checks before submitting FFIEC-009 and FRY-9LP reports to the Federal Reserve through the Reporting Central system.
  • Managed Change Requests from stakeholders by conducting extensive Impact Assessments to capture the expected consequence of such changes
  • Responsible for creating and updating all documentation for the project, which required interacting with all concerned departments on a regular basis.
  • Reviewed integration test plan for integration between modules.
  • Developed Base line testing scripts for testing the future releases of the application using Test director. Participated in conducting Manual and Rational Tools for testing. Extensively used SQL for data integrity testing at the backend. Designed user and administrative privileges such as authentication.
  • Documented workflow, Designed UI and results of business analysis and obtained sign-off from client on specifications.
  • Created UAT/QA test plans, strong manual, functional, system and regression testing in an agile development environment.
  • Worked with the Information Technology teams on coupons, shortfalls and reimbursement reports for the entire team.
  • Conducted Defect Validation using Test Director to screen the illegitimate defects raised by the QA and UAT teams before hitting Development.
  • Developed a Credit Default life cycle process and prepared a power point presentation. Helped developers while they are preparing unit test cases and while preparing test plan.
  • Developed documents for Credit Derivatives businesses and the end-to-end transaction lifecycle.
  • SOX (Sarbanes Oxley) compliance rules implemented.
  • Worked in product settlement, documentation, collateral & margining processes.
  • Created cash flow models for Credit Default Swaps, Interest Rate Swaps, Total Return Swaps, Currency Forwards, Cross-Currency Interest Rate Swaps, Equity options, Structured products, Currency Futures, Options, Exchange Traded Funds (ETFs), and indexes.
  • Prepared test cases and came up with a testing strategy for testing the Banking Application by analyzed the Business requirements and the Accounting, Budget, and Procurement systems.
  • Communicated with Middle Office on bookings and payments for clients and broker dealers.
  • Worked with project team on: planning, analysis, requirements, design & testing and training for production implementations.
  • Worked with global clients, sales, strategist, traders and middle office to calculate structured product Credit Default Swaps (Credit Derivatives or CDS) interest, credit event fees, shortfall and reimbursements.
  • Analyze Credit and Equity OTC Derivatives Trading Life Cycle to improve legacy and proprietary trading process & systems.
  • Experience in Statistical analysis, SAS programming, Risk and Response analytics as part of BASEL II & CCAR financial regulation.
  • Cooperated with CCAR team on delivering of the Basel capital regulatory results to serve the CCAR various reporting forms
  • Assisted the execution of CCAR stress testing framework including gathering requirements of multiple stress scenarios and defining data elements required by stress tests.
  • Counseled and collected information for Loan Modifications and Researched databases for problems associated with loans using SQL scripts, and addressed issues accordingly.
  • Responsible for the programme intended to prepare a clone of the existing Credit Risk Platform.
  • Lead requirements review sessions of requirements with end-users, created process flowcharts for reference data, financial instruments data attributes.
  • Worked with the technical team to ensure that varied changes including configuration change requests submitted by the test team are logged, cross environment impact is assessed and cross environment migrations are managed.
  • Interacted with various members at the management level to understand business decision and analysis needs in order to generate appropriate and relevant data analysis reports. Extensively worked with Quality Analysts to make sure that the functionality meets requirements.
  • Communicated with clients, settled credit derivative payments with sensitive clients and broker dealers, investigated the discrepancies and communicated with Middle Office, Front office to resolve the discrepancies on asset-backed credit default swaps.
  • Works with team on assigned billing fraud cases to minimize dollar loss to the company through effective use of investigative tools and techniques
  • Reviews customer accounts for the prevention and detection of possible Fraud by performing research and analysis of account activity to assess levels of risk and fraud type.
  • Appointed by senior management to work on process efficiency that would help the team reach their quarterly goals of reduction in breaks. On joining the team, created a macro system to streamline the process of cash settlements. Created the dynamics and mechanics of two major macros and programmed for large settlement database every month and for settlements on a daily basis.
  • Worked with business users to accomplish User Stories around Collateral Management and Security Lending
  • Participated in Audit reviews and oversaw corrective action plans in conjunction with AML Compliance, Operations and Business Lines.
  • Process data from multiple sources using MS Access and Excel and publishing the final results using tableau.
  • Provide consulting support to clients through data and software analytics via SQL databases accessed by Teradata and Cognos, SDLC life cycle methodologies.
  • Responsible for translating Business Requirement Documents into functional specifications and test plans. Closely coordinated with both users and developers for arriving at mutually acceptable solutions.
  • Lead the process throughout the SDLC, which included requirements, specifications, design, analysis and testing utilizing RUP methodology. Utilized guidelines and artifacts of RUP to strategize the implementation of Rational Unified Process effort in different iterations and phases of software development life cycle.
  • Analyzed Institutional and Private Wealth Management (PWM) account changes to ensure regulatory compliance under FATCA
  • Collections, including ACH payments, wire transfers and credit card payments

Confidential, Tysons Corner, VA

Business Analyst

Responsibilities:

  • Successfully managed UAT activities for Data Assurance, Data Quality, Credit Risk Management, Management Accounting, and Treasury systems, achieving all major milestones and deadlines.
  • Performed requirement analysis for various types of funds and position reporting templates.
  • Functioned as the primary liaison between the business users, middle-office operations and the technical teams throughout the project cycle.
  • Management and coordination for all systems projects from the Derivatives, Fixed Income, Credit and Market Risk, Credit Portfolio Management and Comptrollers groups.
  • Knowledge and experience in Data Mapping and Data Analysis. Experience in dealing with different data sources ranging from Flat files, SQL server, Oracle, DB2, MS Access and Excel.
  • Creating functional specifications for internal model parameters, risk analytics and MBS enterprise system
  • Responsible for creating and reviewing risk-reporting requirements, functional specifications, project schedules, and test plans. involved in designing and developing mortgage backend security that is based on residential and commercial mortgage backend security
  • Documented High Level requirements for implementing interest and credit risk scenarios for various funds
  • Analysis of Surveillance system to keep track of expected and actual bond-level performance for portfolios
  • Translated the client reporting needs into system development requirements and communicated with the business on a non-technical level.
  • Consulted with clients on investments in stocks, bonds, options, and commodities
  • Assessed market trends and provided quantitative data for the Capital Investment.
  • Assisted in building a net present value of income report using Visio
  • Conducted project related presentations and provided reports to the higher management for feedback
  • Developed current and future Business Process Flows, and created BRD and FSD with Visio and Word
  • Interacted with the QA team to investigate and resolve production issues.
  • Responsible for requirements gathering, specifications and documentation of regulatory initiatives for OTC derivatives.
  • Experience in Object Oriented Analysis and Design(OOAD) techniques like UML using Flow Charts/Process Flows, Use Cases and Class, Sequence, Activity and State Transition diagrams
  • Experienced in a variety of OTC derivatives such as options and swaps (Credit Default, Interest Rate).
  • Led reviews with Risk & Audit groups to determine quality of BRDs, FRDs, technical specifications, test strategy, test plans, and test cases. Worked with multiple IT teams across Prime Brokerage to ensure concerns cited by internal audit were tracked and closed to completion
  • Compliance lead for regulatory enhancements and implementation for the trading systems supporting Cash Equities, Derivatives, Converts, Swaps, etc.
  • Helps in conducting Gap Analysis (GAP), User Acceptance Testing (UAT), and System Integration testing (SIT) and SWOT analysis. nitiate ACH, and wire payments using GTreasury workstation
  • Experienced in supporting end-user reporting needs using Informatica.
  • Investigate potential Anti-Money Laundering (AML) activities in a timely and efficient manner.
  • Assist the commercial lending departments with the underwriting and documentation of a loan request.
  • Escalate complex compliance issues surrounding client type and structure, financial products and services and other AML risk-related issues, including completing a quality review of Know Your Customer (KYC) records.
  • Experience in Loan Origination System (LOS) implementation and managing custom business
  • Requirements and collected target data in the data warehouse.
  • Mapping of source and target data for the warehouse, transformation for data. Deployment of the warehouse.

We'd love your feedback!