SUMMARY

• 8+ years of proven excellence as Business Analyst in banking and finance domains in analyzing business functions within the domains, creating functional requirements, Identifying data needed for different business functions and purpose of each data element for business functions.
• Solid understanding and knowledge of Identity and Access Management (IAM) System.
• Experience in Conducting JAD sessions, Business meetings and one on one discussion with stakeholders, customers for gathering the requirements in the most comprehensive way.
• Expert in formulating Business as well as Functional Requirement Documents (BRDs and FRDs) to ensure that the requirements are correctly conveyed to the development team.
• Proficient in conversion of Use Cases into test documents, Test Plans and Test Scripts good understanding of different business processes.
• Expert in Tracking and Managing the Requirements using Requirement Traceability Matrix (RTM) that controls numerous artifacts produced by the teams across the deliverables for a project.
• Solid Understanding of Anti Money Laundering (AML) procedures and hands on experience of working to ensure AML compliance at client’s place.
• Quality Assurance (QA) experience in developing and reviewing Test plans, Test scripts, Test requirements, Test cases, Test reports, and in using defect - tracking tool to address bugs/issues as required by the project
• Strong understanding of financial crime risks, typologies and suspicious matter reporting obligations
• Extensive experience in analyzing and requirements gathering and writing system functional specifications including use cases.
• Profound knowledge of various banking and finance fundamentals like Capital Markets and Risk Management Industry domain experience in Mortgage, Risk Management and Loan Pricing.
• Experience Working with AML SME’s provided direction and guidance to employees on appropriate remediation action for high-risk accounts.
• Mostly worked on Use Cases and Test cases and Manual Mapping of the transactions.
• Experience in conducting Joint Requirement Planning (JRP) sessions, Joint Application Development (JAD) sessions and Rapid Application Development (RAD) sessions with a committee of SME, business groups, senior management and IT groups.
• Experience on well-known Commercial Lending product Misys Loan IQ on all modules with expertise on accounting.
• Extensive experiences in Investment Banking projects specialized in Securities Trading, and wealth management.
• Extensive experience in UML modeling using MS Visio, MS Project. Expert with creating Use Case Diagrams, Process Flow Diagrams, Sequence Diagrams and Activity Diagrams.
• Good working knowledge of Loan IQ GL accounting including trade date accounting.
• Extensive knowledge and experience in Anti - Money Laundering (AML)/KYC and Operation Risk Management in the large Investment Banks and Finance Companies.
• Experienced with Loan Origination process and Fixed Income Products like Treasury (Bonds, Notes, and Bill), Mortgage-Backed Securities (MBS).
• Strong understanding as well as experience of working through all phases of SDLC. Have successfully worked in AGILE, RUP and SCRUM environments.
• Experience is using Jira, Rally, Confluence among other tools to track the SDLC of projects in an agile environment.
• Experience in conducting requirement analysis, use case design, designing test plans and developed database schemas based on the logical model.
• Excellent knowledge in SQL query writing, Performance tuning, Report writing and good knowledge of database testing.
• Experience in Competitive Analysis, Gap Analysis and understanding of ROI Analysis, P&L Analysis, SWOT Analysis, Impact Analysis and Cost - Benefit Analysis.
• Experience in conducting due diligence reviews on individual and business accounts and updating KYC profiles in accordance with KYC requirements.
• Experience in working with Cross Functional Teams and interacting with all levels of management for requirements.
• Strong Understanding of complex formulas using Advanced skills in Microsoft Excel including pivot tables, Power Query, Dashboards, etc.
• Proficient in Privileged Access Management within Azure in managing and monitoring privilege accounts.
• Highly motivated, result oriented team leader with excellent communication skills and never-ending willingness to learn and improvise.
• Experience on Transaction cost analysis (TCA) program trading and portfolio rebalancing for Equity Investments.
• Experience in writing automated test scripts and test procedures. Expert in creating the Test data and Test cases for User Acceptance Testing (UAT).
• Experience in Stored Procedures, Triggers and Cursors using SQL Server with T-SQL.
• Extensive experience tools like SQL Profiler, Index Tuning Wizard, I3 Precise, and Windows Performance Monitor for monitoring and tuning MS SQL Server performance
• Proficient in Quality Assurance Life Cycle like developing Test Strategies, Test Plans, Test Cases Manual / Automated, Defect Reports and developing Test Scripts.
• Proficient in User Acceptance Testing (UAT) with hands-on experience of working with tools HP Quality Center, Rational Requisite Pro.

PROFESSIONAL EXPERIENCE

Confidential, Winston-Salem, NC

Sr. Business Analyst

Responsibilities:

• Prepared Business Requirement Documents (BRD’s) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system.
• Defined and documented business requirements with sufficient detail to enable customer sign-off and Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Project.
• Utilized corporation developed Agile SDLC methodology. Used Scrum Work Pro and Microsoft Office software to perform required job functions.
• Created FRD (Functional Requirements Document) with detailed mock-ups and wireframes for the requirements selected for the release.
• Developed SQL data migration scripts for application conversion or integration, Applied patches for the SQL server environment after the Migration.
• Worked collaboratively with Development Team to identify data requirements and mapping, Established practical and efficient design and testing approaches
• Worked with Senior Business Users in Market & Credit Risk Management, Prime Brokerage, Auditing, Compliance, and Back & Middle Office to prioritize and secure Budgeting for Projects and Day-to-Day Support.
• Worked extensively on MS Office tools like Excel, PowerPoint, Word etc. for documentation and presentation purposes, used SharePoint for document storage/sharing.
• Worked on Loan origination and maintenance of credit files according to federal banking guidelines
• Worked with PM, reviewed and upgraded the records management in Objective, including file structure, access privileges administration and application of correct sentencing and disposal.
• Independently utilized quantitative analysis techniques to assess credit risk exposure; identifies, analyzes, and monitors issues that affect profitability, growth, and productivity.
• Developed pricing, servicing, and originations tests and be responsible for testing, monitoring, and profitability impact analysis. Generated ideas to improve current strategies.
• Managed and executed all global Capital Markets league table submissions to public data sources (Bloomberg, Refinitiv, Debtwire, LMG Analytics and LexLatin)
• Analyzed client data, documentation and negative news in order to determine client risk profile as established under the global KYC procedures.
• Worked on Undertake completion of Transaction Monitoring Alerts, annual Customer Due Diligence (CDD) information gathering exercise for all unassigned Customers and Branch Annual reviews.
• Established a RUP (Rational Unified Process) centric business analysis methodology. Collaborated in building a business analysis process model using Rational Rose, Requisite Pro, and Visio and Collaborated closely with the technical team for solution development
• Worked in the team and faced challenges during the project development and production process. Experience configuring and upgrading/migrating SailPoint IIQ Identity Access Management solution components.
• Explained the banking rules (Consumer Loan/Mortgage) to the development team and Worked on different areas of LoanIQ API and data model.
• Involved in maintaining the Requirements Traceability Matrix (RTM) across the deliverables for a project
• Involved in Internal Audit and Compliance to ensure timely and accurate remediation in response to observations and recommendations
• Worked with business and customers on new initiatives, identified and provided insight and recommendations of what data will be helpful to reach the desired project goals.
• Worked on Market-to-Market analysis of the commitment inventory, real-time loan pricing, counterparty commitments, risk analysis, hedging, and securitization strategies.
• Responsible for numerous decisions in respect to business policies, procedures, methods for implementation. Confidential Prepayment risk, Risk Analytics for Confidential, Loan Servicing, Loan Origination, Confidential, CMBS, and Secondary Confidential Market.
• Analyzed regulatory requirements for Dodd Frank initiatives and ensure completeness and accuracy by partnering with IT and functional groups
• Delivered automated scripts and documentation to support the adoption of these automations in Tableau.
• Monitored the mortgage market and recommended strategy, providing the Bank's daily mortgage loan pricing.
• Supported business and investment teams. Securities Trade Operations is responsible for the post-trade processing of equity and fixed income
• Worked on Automation of dashboards of the entire Investment Banking operations Capital Markets
• Involved with the IT team to understand guidelines of Identity & Access Management applications, including MS Active Directory and Cyber Arc platforms.
• Followed the Software Development Life Cycle throughout project and used the Agile methodology
• Supported AML suspicious matter investigations through obtaining information and lodgements of Suspicious Matter Reports.
• Reviewed mortgages of informed borrowers/related parties for loans, marketing conditions, documents needed to close the loan.
• Communicated on a daily basis with Senior Managing Directors and Directors surrounding AML monitoring and surveillance.
• Extensively researched and collected the customer financial documentations and completed research for suspicious activity reports on KYC, AML, and BSA analysis reports for flagged accounts.
• Involved in analyzing Mortgage-Backed Securities (MBS), derivatives (Interest Rate Swap, Swaption, Future), Repo, Fixed Income life-cycle.
• Performed Requirement Analysis and developed Use Cases, Activity Diagrams using Rational Rose To implement the process, Analyze and write a lot of Test Cases and Test scenarios.

Confidential, Washington, DC

Sr. Business Analyst

Responsibilities:

• Analyzed business needs and worked with technical and non-technical teams to overcome challenges worked with business users, stakeholders and SME’ Confidential amongst the organization
• Used extensive SQL queries for data analysis, to provide summary reports and data feeds to analytics reporting systems.
• Worked with BI Architect to implement logical data process model andEstablished a Business Analysis methodology around Agile (SDLC) methodology.
• Ensured all new and existing clients (and high risk) undergo AML sanctions review base on the Bank Secrecy Act;
• Utilized Rational Unified Process (RUP) and developed business process flows, system flows, validated object-oriented analysis and design methodology.
• Used BI for analyzing securities including equity, foreign exchange, bonds; building analysis flow for portfolio rebalancing and monitoring asset class performance.
• Liaised with Clients, Front Office, Credit, Legal and Client On-Boarding as necessary as part of the KYC process.
• Tested the brokerage and financial services applications like Equities, Fixed Income, Investment Research, Investment Deposits, Accounts (Accounts Activity, Balance Holdings, Portfolio Management, E-statements, Retail Consumer Lending, Mortgage Modules, Integration Module
• Expertise in underlying Finastra Loan IQ data model and components, Loan IQ Batch Execution Framework and schedules, Loan IQ APIs and their relationship across Finastra Loan IQ Modules.
• Responsible for the quality of all changes to Empower, the loan origination system for the Retail branches.
• Performed bulk loading of data in DEV/QA environments, Presented BRD to the Business for feedback and approval
• Worked with Manager for the planning, execution and completion of AML/CTF monitoring services relating to suspicious matter reports
• Responsible for all securities trading process requests in accordance with the Firm’s securities trading guidelines/policies.
• Made decisions on new IAM functionality to implement. Which may include expanding vendor relationships, integration partners, or adding a new vendor.
• Partnered with business leaders on research, design, build, configuration and operation of niche platforms (e.g., Financial Systems, Commercial Lending. Wealth management, Risk Systems, Treasury services, Sales Tracking Systems).
• Managed requirements from Global Business & Risk Management users and Worked with SQL queries for data manipulation and data validation.
• Performed Requirement Analysis by gathering both functional and nonfunctional requirements based on interactions with the process owners & stakeholders and document analysis, represented them in Requirements Traceability Matrix (RTM).
• Developed financial reporting by analyzing Capital Markets deal flow, incurred revenues, and identifying market trends and Provided maintenance and support after project completion
• Created waterfall framework artifacts such as BRD, FRD, use case and use case diagrams and Worked with Confidential cross-functional team of Business Development
• Analyzed and Documented Business Requirement Document (BRD), Functional Specification Documentation, and System Requirement Documentation, using UML methodologies.
• Developed a prototype of the system using Microsoft Visual Studio and conducted walkthroughs to users and developers.
• Analyzed the requirements and created Test Plans, Test Scenarios, Test Cases and Created Business Process Model and identified issues for Business Process Re-engineering work elements.
• Worked on a suite of Tableau products such as Tableau Desktop, Tableau Online, Tableau Prep and Tableau Data Management
• Responsible for various deliverables throughout the software development lifecycle from process flow diagrams to mock-ups and wireframes
• Created process maps, use cases, requirements and gap analysis documentation for JPM algorithmic trading workflow for regulatory reporting.
• Involved in requirements gathering, source data analysis, identifying business rules for data migration and for developing data warehouses.
• Researched the mortgage industry; including, regulatory changes and financial impacts of securitizing Mortgage-Backed Securities (MBS) that pertains to maintaining the Authority’s LOS.
• Monitored and maintained Capital Markets website by updating template forms, client forms, practice group presentations, site resources, and Capital Markets deal tracker and Used MS Project to create Gantt Charts for mortgage look back project.
• Elicitation techniques like interviewing, questionnaires, brainstorming, focus groups, prototyping and facilitating JAD sessions.
• Responsible in providing regular test reports to the management and Performed different levels of quality checks and performed UAT Sessions as required
• Identified Use cases from the Functional requirements and wrote Use Case Specifications and created business process workflow diagrams (Activity diagrams, Sequence diagrams, Collaboration diagrams).
• Created new Loan and Serve application based on Life Cycle of the Loan Origination based on committee and risk approvals and reports using Microsoft Access, Excel, VBA, Dashboards.
• Created and modified workflows for implementing business flows and performance tuning and problem determination for IAM solution.

Confidential, New York, NY

Business Analyst

Responsibilities:

• Performed gap analysis and prepared reports to identify applications and business processes that fell short of PCI standards.
• Created PowerPoint presentations and project updates using MS Project for management review
• Coordinated with Information System programmers on all aspects of the loan origination systems change requests and maintained compliance with all regulations.
• Directed the software development effort by representing the customer for the purposes of outlining and clarifying user stories with our development team through constant collaboration, business acceptance testing and making quality assessments.
• Interacted with Software development team and Business users as a liaison in helping developers to understand the business requirements, Functional requirements BRD, FRD thereby ensuring the proposed applications complies with the business specifications.
• Responsible for Project Planning, Tracking, Risk management, Resource Management, coordinating tasks and Creating/Updating Status Report with TIC.
• Created Business Process specifications, application designing using RUP, database schema design and implementation methodology.
• Conducted JAD sessions with the Business users, technical architects, Data management team and the UAT team, Developed and maintained Requirement Traceability Matrix (RTM) and Prepared data integration flow diagrams between COTS mortgage application & Capstone.
• Monitored and assisted in designing and development of Use Cases, Activity Diagrams, and Sequence Diagrams using UML and Responsible for leading Agile Scrum Sprint Planning Activities
• Added and trained new IAM users, including integration of existing remote also involved in the automated testing of Test Cases via Rational Functional Tester.
• Involved in conversion of Use Cases into test documents, Test Plans and Test Scripts good understanding of different business processes.
• Validated quality of draft Suspicious Activity Reports for various business units (AML Operations, Auto Lending, Savings, Information Security), Track record of working with data feeds and interfaces from Loan IQ
• Created requirements for FRY14 and interacted with the Axiom team to understand the data flow from station into Axiom.
• Worked on Loan IQ table maintenance especially around Pricing options, Base rates, Funding rates, account, GL short names and transaction events
• Created queries in Rational Functional Testing Tool RFT’s, running it and determined final eligibility of the individuals.
• Established on-going processes to ensure that all new applications and procedures meet PCI standards using SDLC and Waterfall methodology.
• Communicated with stakeholders to assess requirements, developed user stories and perform user acceptance testing to ensure criteria is met and Created QA Test plans, Test Cases for Functional, Integration Testing.
• Created the Business Requirements Document (BRD) to clearly define each business goal in terms of meaningful and structured functional requirements along with detailed process flows (using Visio) and respective SIPOC analysis.

Confidential, New York, NY

Business Analyst

Responsibilities:

• Reviewed mortgages of informed borrowers/related parties for loans, marketing conditions, documents needed to close the loan.
• Facilitated and managed meeting sessions from business areas including Confidential Origination, Loan Processing.
• Performed financial and business analysis, cost-benefit and risk management in support of capital planning for investments and Used MS Project to manage schedules, deadlines, and resources
• Created QA Test plans, Test Cases for Functional, Integration Testing and participated in UAT and the JIRA/SQL scripts for demonstrating the prototypes and for verifying the result sets and used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.
• Responsible for securities trading, account reconciliation, and cash management and Managed Regulatory-reporting expertise across numerous report forms, such as: FRY 9C.
• Running the Test Cases in the Test Environment using Manual input method involving different criteria and determining the final eligibility and Maintained close integration across the group and communicating effectively with seniors for day-to-day task
• Prepared analysis of loan and deposit portfolio growth trends by business lines, markets and segments for management.
• Write Use Cases, developed Business Rules documents for the implementation of Workflows in Pega PRPC and Defined relationships, related parties in connection with conflict requests.
• Responsible for ensuring timely and accurate reporting to the Group, Structured submitted and completed loan application for processing. Confidential Reviewed Files for Accuracy
• Partnered with Marketing, Finance and Business intelligence teams to develop reporting and analytics for business line and market performance.
• Effectively communicated and assisted other team members in the ongoing assignments as part of an agile environment.
• Stayed abreast on standards and developments in the areas of KYC, BSA/AML, and OFAC, and apply regulatory requirements and internal policies and procedures to case investigations
• Gathered and documented business BRD, FRD from both formal and informal sessions and validated the needs of the business stakeholders, Documented RTM Requirement Traceability Matrix for traceability of requirements.
• Worked on Program Trading, Rebalance of Equity portfolios and assisted with other portfolio management functions.
• Authored Business Requirements Document BRD with project teams. Extracted, discussed, and refined business requirements from business users and SMEs.
• Comprehensive knowledge of various research platforms with the ability to conduct thorough research and utilize suitable record keeping methodologies.
• Responsible for change management, process modeling and staff development in the implementation of the Rational Unified Process (RUP) for the IT department.
• Developed new reports, trouble-shoot technical problems and implement enhancements in reporting tools (e.g. Excel, Tableau)
• Facilitated Joint Application Development (JAD) sessions involving the management, development and user teams for clarifying requirements and facilitating better communication.
• Contributed to the development of reporting tools that enabled business leaders to quickly identify and respond to changing market conditions and customer behavior trends.
• Determined and compiled key performance indicators and provide variance to goal analysis for results, including strategic initiatives and ad hoc projects.
• Investigated AML cases and alerts involving various transactional activities to determine whether questionable transactions occurred in designated high-risk industries.
• Assisted in the preparation of the bank’s deposit pricing committee materials with Processed, allocated & paid renewal invoices for most states while reduced annual operating costs for Legal & Compliance.
• Involved in migrating the Commercial Lending Process from existing AFS Application to the new application platform Loan IQ, mainly focusing on the Commercial Lending Servicing process.

Confidential, Washington, DC

Business Analyst

Responsibilities:

• Involved in designing screen mockups to specify the User Interface of the Mortgage LOS application.
• Developed system concept, interviewed business SMEs to gather, analyzed and managed requirements, Managed SQL RDBMS, ability to read and understand data flow diagrams and ERD.
• Developed test plans, test cases and test scripts based on the functional specifications and Adept at writing SQL queries and scripting in PL/SQL Oracle.
• Analyzed Mortgage Processing workflow. Developed business process flows, Use Cases, and other documentation for expansion loan servicing, securitization, and trading model while coordinating with the Development Team.
• Facilitated JAD sessions involving the management, development and user teams for clarifying requirements and facilitating better communication.
• Conducted pre-work to make the business process as streamlined as possible, by mapping As-Is and To-Be process scenarios
• Extensively involved in project documentation including Software Requirement Specification SRS, Detailed Systems Design DSD Document, Use Cases, User Interface Specification, Report Specifications, Letter Specifications, etc.
• Developed User Stories, Use case Documents USD, Business Requirement Document BRD, Functional Requirement Document FRD and project scopes and created Project Plan utilizing MS Project.
• Updated Procedural Documents for the Business Risk Management Department and Created project management documentation following SDLC methodology for project planning and reporting.
• Identified potential project risks, based on Independent Verification and Validation IV V of the project effort being led by the prime vendor, and recommended risk mitigation strategies to VDOT.
• Worked on opportunities to adopt agile process earlier than scheduled and Adhere to Agile Methodologies through entire software development process
• Involved in various levels of testing like Smoke/Sanity, Functional, Regression, System, Security, End to End and UAT testing.
• Provided direct technical evaluation of third-party products for inclusion in IAM solutions and defined software development processes.
• Worked with risk management tools for mortgage loan servicing, commercial & residential mortgage, and risk analytics.
• Reviewed project artifacts like Requirements Traceability Matrix RTM, Use Case Document, as-is and to-be Process Flow Diagrams, Data Mapping Document, Technical Design Document, Interface Document, Test Plan, User Acceptance Test UAT Document, and Change Management Document.
• Responsible for the development and maintenance of Business Requirements Document (BRD) consisting of Functional and Non-Functional Requirements.
• Partnered with the business stakeholders, process owners, users to identify their requirements, produced detailed specifications, planned the project deliverables with the software development team, defined QA plan, and conducted User Acceptance Testing.
• Involved in mentoring specific projects in application of the new SDLC based on the Agile Unified Process. Created custom monthly report wholesales and retail banking (First loan mortgage, home equity loans, Auto loans, small business loans and other consumer loans) for different loan services used by the bank.
• Audited closed loans to verify they’re in compliance with FNMA, FHLMC, FHA, OFAC, DOJ, CFPB, BSA, AML, KYC & other government regulatory guidelines
• Utilized RUP methodology to create Process Flow, System Flow, Use Case Diagrams and Interaction Diagrams using Microsoft Visio.