Business Analyst Resume Profile
Summary:
- Over 8 years of Industry experience as a Business Analyst in Finance and Banking domain.
- Proficient in Business Requirements Elicitation, Data Modeling, Analyzing and Translating requirements into Specifications across different functions and Application Design.
- Experience conducting GAP Analysis, SWOT Analysis, and ROI analysis.
- Proficient in conducting Meetings, Interviews, and Joint Application Development JAD sessions with various Stake holders and flexible in coordination across various groups and vendor partners.
- Well versed with SDLC methodologies - Waterfall Model, Agile- Scrum, RUP, and Six-Sigma.
- Effective Project management skills and effectively acted as Project Manager on various occasions to maintain Scope, resource scheduling, status reports update and project plan updates.
- Proficient in creating documentations like BRD, SRS, FRD, RFP, RFQ, RTM Wireframes, Mock-ups and conceptual design creating Use Cases, specifications and Use case scenarios Business Processes Modeling using BPMN , Data mining and Data Modeling- Entity relationship diagrams, Work flow diagrams, Sequence Diagrams, Activity Diagrams etc. using UML.
- Experience in using BI Business Intelligence tools like Cognos, Toad, Oracle OBIEE, Financial Analytics, Crystal reports etc for reporting purpose. Proficient in working with Excel and functions like Pivoting, recording Macros, solver and lookups.
- Experience reviewing codes in JavaScript, XML, and writing SQL queries.
- Extensively interacted with the QA Team to help them execute various Test plans GUI, Functionality test, system test, integration test, defining Test Cases, POC, and facilitated UATs.
- Domain Skills:
- Product and Application management of Commercial loans, Risk management, Trade order life cycle Front office, Middle office and back office functions, Straight Through Processing - STP Custodian Services, Treasury Services, Foreign Exchange, COT, FIX Protocol, SWIFT Messaging, Payment Processing. Comprehensive Understanding of Capital Markets business, Fixed income products- Bonds, T-bills, corporate bonds, PPF Insurance - Annuities Derivatives Forwards, Futures, Options-American European, Swaps-CDS, Interest rate Swaps Securities and derivatives pricing methodologies, Securities valuation, Financial Accounting- GL, P L, A/c receivable payable.
- Familiarity of various Statistical/Quantitative/data analysis concepts - correlation matrix, variance and regression analysis, probability, creating binomial models calibrated to Monte Carlo model and other financial functions by using MS Excel.
- Thorough understanding of various corporate finance concepts and products - Valuation methods and Comparable analysis, DCF Analysis, Financial Statement Analysis, Ratio analysis, Credit risk analysis, creating Forecasting tables, budgeting, cost benefit analysis, Asset Liability management, Interest Rate Risk, liquidity Risk, Capital forecasting, LOS, Commercial loans, Mortgage loans, MBS, ABS, Understanding of Index like S P 500, Russell 2000, DJIA, Index Constituents, reference data, street identifiers like CUSIP, SEDOL, ISIN, Ticker symbols etc.
- Familiar with various compliance and regulatory standards like SOX, Dodd-Frank, Basel I II accords, AML laws, FFIEC AIBE rules, KYC and due diligence procedures, GAAP and IFRS rules, IT governing and monitoring activities and SOPs.
Skillset:
MS Office MS Word, MS Excel, MS Visio, MS Project, MS Power Point, MS Access, MS InfoPath Rational Clear Quest, Rational Clear Case, Rational Requisite Pro, SharePoint-2010,2007,2003 Enterprise Architects SQL, Oracle, Data warehousing, Data mining Agile-Scrum, Waterfall, Six Sigma, Rational Unified Process UML, BPMN , Clarity, SAP, Lotus Notes, HPQC, Rational Rose, Toad, Cognos, Crystal Reports, OBIEE, Informatica Windows 98 / XP / NT /vista / 7, Linux, Java Script, XML.
Confidential
Projects Summary:
Confidential
Business Analyst
- Confidential is a full service commercial bank with 20 billion in assets. Webster Bank provides consumer, business, government and institutional banking, as well as mortgage, financial planning, trust and investment services through Webster Private Bank and asset-based lending through Webster Business Credit Corporation, equipment financing through Webster Capital Finance, Inc.
- Develop MobileWeb and Banking Application for Mobile Smart devices devices and MRDC Mobile Remote Deposit Capture feature to deposit checks remotely by leveraging Mobile platform.
Responsibilities:
- Developed requirements into business Use Cases, Activity diagrams, Sequence diagrams, and UI flow for Mobile application.
- Created detailed SRS and FRD by identifying functional and non-functional requirements. Developed work flow processes documents/SDD for different functionalities/transactions to be utilized on mobile platform by providing complete impact analysis and risk analysis.
- Prepared Risk Assessment matrix and mitigation plan for banking services on mobile platform.
- Developed and maintained RTM and issue tracking to make sure requirements are matched.
- Mapped detailed Service Error Scenarios/Error codes of Vendor Mobile platform to Bank's Existing Web platform to be utilized by QA team.
- Participated in change management, provided solution for required enhancement by legal team and business team.
Environment: Microsoft Office 2003 MS Excel, MS Word, MS Visio Share Point 2003, HPQC-ALM, UML Diagrams, SQL, Internal proprietary applications.
Confidential
Lead Business Analyst / Project Management
- Confidential is a diversified financial services company providing banking, insurance, investments, mortgage, and consumer and commercial finance across North America and internationally.
- Develop enhanced UI for WDAI Wholesale Database Administration and Infrastructure team to manage Database Inventory, Include functionality in the UI for business groups to access data in a structured way.
Responsibilities:
- Worked with application manager and WDAI management to prioritize requirements and defined releases based on WDAI DB Inventory road map. Involved in full Software Development Cycle.
- Worked with Treasury Group to understand various treasury services and products to facilitate the streamlining of financial accounting data of clients both corporate and retail to provide easy access to various reports like A/c payables, A/c receivables, cash flows, general ledger GL , payment history, Auto invoice generating, mailing and tracking capabilities, etc. as a built in micro sites in the enhanced UI application.
- Worked with Trust and Custody groups to gather and analyze requirements to produce feature/functions and its interdependencies for their specialized reporting solution for Performance Measurement reporting, Multi Currency reporting and Analytics Attribution reporting for various financial products/services and portfolios.
- Worked with Portfolio managers of Asset/Wealth management group to gather requirements about performance measurement attributes of various assets class.
- Worked closely with Fixed Income group to understand processes for Bonds Corporate, government bonds, Treasury Bills, various risk associated with different Fixed Income products and to depict risk measures graphically on the application.
- Worked with Commercial loan group to understand mortgage life cycle and loan origination process.
Environment: UML, Use Case Analysis, BRD, FRD, Data Mapping, Process Flows, MS Office- MS Excel, MS Project, MS Outlook, MS Visio, Basel II, Data warehouse, SharePoint 2010, SQL, ETL Clover, Stored Procedure,
Confidential
Risk Analyst / Business Analyst and Team Lead
- Confidential is one of the largest Confidential bank that provides Consumer Business, Banking CBB , Consumer Real Estate Services CRES , Global Banking, Global Markets and Global Wealth Investment Management GWIM with 2.2trillion in assets.
- Transition and collaboration of the loan and credit risk data from Merrill Lynch and Countrywide acquired financial institutions into the existing bank of America ECRIS enterprise credit risk data repository system.
Responsibilities:
- Worked diligently on many Global Banking Global Markets Compliance, Credit Risk and Operational Risk initiatives, gathered requirements and developed BRD, FRD, and BPM documents.
- Worked with Mortgage Loan selling personnel to executers, loan processors, underwriters and accountants to understand the process flow, interacted with risk analysts to understand the risk measures involved like PD, LGD, LTV, and LTI.
- Interacted with credit analyst to develop the credit risk models for PD, LGD, and EAD.
- Analyzed various risk like market risk, liquidity risk, operational risk to facilitate the development of Basel II compliance initiatives.
- Used Oracle Financial Analytics for accessing the information of AR, AP, General ledger, Profitability and produced Cost/Benefit Analysis to support proposed changes.
Environment: UML, Use Case Analysis, MS Office - MS Word, MS Excel, MS Visio, MS Power Point, Data Warehouse, Oracle Financial Analytics, SAP, OBIEE, Toad, SQL, Windows XP, Agile, Rational Rose, SharePoint 2007, Informatica, JAVA Script.
Confidential
Business Analyst
- Confidential is a leading financial services company, advising clients in all aspects of finance, across the globe and serves mainly in Private Banking Wealth Management, Investment Banking and Shared services area.
- Development of Intranet web-based application for the financial advisors in the investment banking division. Application included Trading features, Investment products and advisory modules, Portfolio management modules to review and work with the brokerage accounts of the private customers and to advice them with investment strategies, compliance standards and risk analysis modules.
Responsibilities:
- Involved in revising the Trading Process Flow documents which involves preparation of different technical documentations for different process like trade capture, execution, booking, validation and confirmation, clearing settlement, Accounting, Client billing process, Cost basis accounting, etc.
- Interacted with representatives from Custodians and Clearing house stakeholders to understand the processes and ensured Dodd-Frank compliance are satisfied by requirements.
- Assessed risk associated with different systems that take part in ACH, wire transfers and documented them with authentication guidelines to enhance security and control over transactions, adhering to FFIEC AIBE rules.
- Coordinated with business group for compliance of Basel-II Standards, Due-Diligence procedures, AML regulations to apply to different transaction of Derivatives, Bonds, Securities and other financial instruments while preparing the data modeling, Risk Reporting and requirement documentation.
- Worked with different Fixed Income securities and derivatives such as Bonds, T-Bills, CDS, Interest Rate Swaps and prepared documentation for specification goes into pricing and risk evaluation to create different functional requirements, its attributes and use cases.
- Developed FIX protocol specification and interfaces, service flows, communication diagram, SWIFT Messaging attributes.
Environment: UML, Use Case Analysis, BPMN, MS Office - MS Word, MS Excel, MS Power Point, MS Visio, Rational Rose, Rational Clear Quest, Cognos, SQL, SAP, IBM systems, Windows XP, Java, Agile, JAD Sessions, Wireframes, Mockups, UAT.
Confidential
Business Analyst
- Confidential is a global investments company that delivers informed investment management and investment services across globe with presence in 36 countries and 100 markets.
- Eagle PACE implementation and redesigning of modules of Web Based Portfolio and asset management system that supports Basel II compliance by Business Process Reengineering.
Responsibilities:
- Worked with Fixed Income traders, gathered requirements, to facilitate technical team with functional aspects of various capital market instruments for implementation of Eagle PACE hub and portfolio management system.
- Interacted with Asset managers to understand the accounting processes and asset component to develop the specifications in data-flow diagrams.
- Prepared data flow diagrams for Trade Order routing for Foreign Exchange, currency trading, Securities, Derivatives, Options, Fixed Income Products Bonds, CDS, T-Bills, Swaps etc to marketplace for technical team, prepared various uses cases and test scenarios for overall Trade Order Processing.
- Involved with Investment Management Accounting group to understand the back office processing of trading various instruments and prepared process flows adhering Dodd-Frank regulations.
- Ensured all trading process complies with AML rules while preparing artifacts for business rules to apply to configuration procedures for system under implementation followed by KYC and Due Diligence process in place.
- Conducted risk analysis for different financial products utilizing company risk assessment matrix and made sure process complies with Basel II standards and SOX compliance for Eagle PACE accounting processes.
- Coordinated with third party vendors related to COTS requirements for integration purpose.
- Created detailed FIX protocol message attributes, SWIFT message attributes and documented them.
Environment: UML, Use case Analysis, BPMN, MS Office - MS Word, MS Excel, MS Visio, MS Project, Eagle PACE, Enterprise Architect, .NET, Meetings, JAD Sessions.
Confidential
A global Investment bank and securities trading and brokerage firm Acquired by JPMC . Developed Prime Finance System PFS . The main aim of PFS project is to buy structure and distribute closed residential loans Prime and Subprime . PFS is an integrated system solution to track and analyze Commercial Loans, loan inventory, its market value and it's PD, LGD.
Responsibilities:
- Worked closely with employees in the Entire Mortgage Life, including Loan Application, New Loan Origination, Payment Application and Remittance, Collateral Inspection and Monitoring.
- Developed and documented business process models for Mortgage Origination, Mortgage Servicing, Loan Monitoring, Assets Assessment and Secondary Mortgage Market.
- Assisted in the development, implementation and management of financial systems, cost accounting systems and/or financial policies and procedures as appropriate.
Environment: UML, Use Case Analysis, BRD, FRD, MS Office, MS Excel, MS Project, MS Visio, Toad, SQL, HPQC, Crystal Reports, Windows XP, MS Outlook, SharePoint 2003, Agile- RUP.