We provide IT Staff Augmentation Services!

Sr. Business Analyst Resume

Houston, TX

SUMMARY

  • About 8 + years of Professional Experience in the field of Banking, Mortgage and Finance with strong exposure inBusinessAnalysis and Project Management Skills.
  • Well - versed in documentation of Business Requirements Documentation (BRD), Functional Specification Documentation (FSD).
  • Strong analytical and logical skills combined with experience in various cycles of a software development including development, testing, implementation and maintenance of applications.
  • Proficient in facilitating large meetings to help define vision, scope, requirements, design, and risk mitigation plans.
  • Full understanding of the SDLC requirement analysis and business specification, development, enhancement, quality assurance, testing including developing Test Cases and Test Scripts. Experienced in conducting User Acceptance Testing (UAT).
  • Solid understanding of Business Requirements Gathering, Evaluating Data Sources, Translating Requirements into Specifications, Application Design.
  • Experience gathering requirements through Joint Application Developments sessions (JAD) and Joint Requirement Planning sessions (JRP), Walkthroughs, Interviews, Questionnaires and Brainstorming with end-users, clients, stakeholders and the IT group.
  • Experience in working with Business Analysis, Processes, Data Mapping, Flow Diagrams and Business Requirement Documents.
  • Excellent skills in Business Analysis, Data Analysis, Gap Analysis, Requirement Analysis, Business Modeling and Use Case Development using UML methodology.
  • Experienced in financial instruments within investment banking and brokerage environments (Derivatives, Fixed Income, Hedge Funds, Capital Markets, Energy trading, FX, Futures, Options, Commodities, Debt, Equity and Structured Products, Mutual Funds, Swaps, Asset Backed Securities) and wealth management.
  • Collaborated in the implementation of a management framework to ensure corporate functions are in compliance with the Federal Reserve's Comprehensive Capital Analysis Review (CCAR) regulatory requirements.
  • Knowledge in Cards Payment processing and Retail Banking operations like Customer Relationship Management (CRM) and Enterprise Teller (ET).
  • Experienced on Banking & financial domain projects (SecuritiesFinance,Securitieslendingwith collateral, dividends, trade life cycle (front/middle/back office), custody settlements, ECN to Exchange conversions, Swift Alliance, Globe tax services, corporate actions, fixed income and derivatives).
  • Solid understanding and knowledge of Equities, Derivatives (Futures, Options, Forwards, Swaps), and Regulatory Reporting (FRY9C, CCAR, FR2420, FFIEC Report) FFIEC, RWA, Risk Analysis.
  • Expertise in diverse retail banking sectors including lending, deposits, payments, cards, trade finance, treasury, KYC, AML, payment system.
  • Knowledge with investment banking regulatory reporting regulations like Basel II Accord.
  • Good understanding the knowledge of Risk analysis, Securities (Stocks and corporate bonds) and their valuation, Portfolio Management (risks and returns) and analysis, Asset Allocations Bond pricing, Financial Derivatives, Cash flows, financing structure, Capital Management, Stock Valuation, Amortization, etc.
  • Experience in Finance industry, Credit Card, Investment Banking (GL, Personal Accounts, Check payment, ATM, Fraud - AML) and Mortgage industries.
  • Knowledge in the different banking systems, financial modeling, financialstatementanalysis, operations and the guiding compliance and regulations that support finance and/or core banking functions.
  • Good knowledge of different financial services includes commercial banking, middle-market lending, asset-based lending, leasing, cash management and trade finance.
  • Extensive knowledge in Automated Clearing House (ACH), Bank Clearing System, Electronic Funds Transfer (EFL), and SWIFT. General understanding of Accounting process including general ledger and account reconciliation.
  • Experience with SQL queries to retrieve and manage data in Data base.
  • Good experience of working with various bug tracking tools like HP Quality Center, Rational Clear Quest and JIRA and a very good understanding of the Defect Life Cycle.
  • Experience in assisting DBAs to create Data Model by designing conceptual data model and entity-relationship diagrams (defined entities, relationships, and attributes).
  • Strong SQL knowledge for querying the database and proficient in developing External Tables, Joins, Indexes, Data Modeling, Analysis, Verification, Cleansing, Transformation, Integration, Mapping, Extraction, Load Process from multiple Data Sources.
  • Exposure to Client/Server, Web Application developmental tools and Software development and design. Process/tools including, Oracle, SQL Server, MS Visual Basic, HTML, Microsoft Project tools, Reporting tools, XML, Rational Unified Process (RUP).
  • Perfect liaison between senior management and IT developers & QA team.
  • Assisted QA team in preparing Test Plan, Test Cases, Test Scripts and conducted Functional testing, System testing, Performance testing, GUI testing, Black-box testing, Smoke testing, Regression testing, and facilitated User Acceptance Testing (UAT).
  • Experience in solving complex problems, team coordination and motivation skills as well as the ability to communicate successfully across cultural barriers.
  • Quick learner and willing to contribute in a team environment.

PROFESSIONAL EXPERIENCE

Confidential - Houston, TX

Sr. Business Analyst

Responsibilities:

  • Acted as a liaison between technical team and business clients to accomplish application enhancement and production.
  • Reconciled business requirements documents against client task orders or change requests to validate and approve that the identified solution addresses the business need.
  • Preparation of Business Requirement Documents (BRD) including GAP Analysis with client requirements and existing new business system.
  • Worked with the Scrum team daily for sprint related standard activities.
  • Organized pre-grooming and grooming sessions with team as needed.
  • Involved in creating user stories and translating them to technical specifications.
  • Created the user interface and designed the reports layout and content, identified the data sources for reports.
  • Created the complete project plan, managed the requirements and deliverable with business groups, managed resources and published weekly project status dashboard for enterprise risk management teams.
  • Owned change management prioritization process - evaluated new change requests and partnered with business and technology to clarify and prioritize changes for delivery in packages.
  • Coordinated the use of Crystal Reports along with SQL server, providing reports for clientele including long term solutions leading to partnerships.
  • Assisted the project manager in preparing the project schedules, milestone tracking and resource allocation using MS Project.
  • Created Mock-ups and added them into user stories along with business acceptance parameters.
  • Performed organizational impact analysis in the process of gathering requirements for both the proprietary as well as customer trades.
  • Develop business relationships and integrate project activities with project team members, primarily QA and Software Developers, to ensure successful implementation and support of projects.
  • Coordinated testing and maintained the issue log to be submitted to the vendor for issue resolution.
  • Demonstrated user scores on the various functionalities and presented the same to the large audience for approval.
  • Prepared the RFC (request for change) and created the deployment checklist to ensure the smooth production release.
  • Managed development team through the project System Development Life Cycle (SDLC) while keeping project timeline in MS Project and using agile project management methods.
  • Planned and executed a workgroup examining templates and methodology standards, leveraging experience to recommend best practices on improving IT templates, processes and methodology.
  • Interacted with the front end team UI/UX on the design proposals.
  • Assisted in modeling UI wireframes, mockups and documenting the end-user's AS-IS workflow and TO-BE business processes.
  • Participated and contributed in daily Scrums, Sprint meeting and Sprint review meetings.
  • Elicited the requirements to understand business rules, business process, and business flow and follow the SDLC standard of the business in project meeting.
  • Prepared Requirement Traceability Matrices (RTMs) and managed all components of the business requirements.
  • Created BRD's in confluence and linked BRD's with JIRA stories.
  • Driving all the grooming sessions, sprint planning, daily scrum and retrospective meetings.
  • Part of Deployment verification after every release.
  • Coordinated and prioritized outstanding defects and system requests based on business requirements. Organized and performed User Acceptance Testing (UAT).

Confidential - New York City, NY

Business Analyst

Responsibilities:

  • Started and planned business audits including definition and choice of new ideas and advancement of new or
  • Worked on converting and documenting business requirements into BRD, User Stories and SRS.
  • Provide deal execution and transaction support across multiple currencies and markets
  • Engaged with the accompanying item: Stocks, Fixed Income, Mortgage-Backed Securities (for example CMOs, Pass-through), Liaison between the business clients and specialized group
  • Utilized the Data Stage Designer to create measures for removing, purifying, changes, coordinating and stacking information into information distribution center data set.
  • Caught Data stream charts and organizing of the information coursing through interfaces.
  • Possessed the whole revealing cycle. Interfaced with the ETL group, developer(s), the executives, and record holders to
  • Intermediate knowledge of core banking and loan processing software and systems collecting for commercial loans.
  • Provided reports to Commercial Lending Department as well as other departments as appropriate, using either standard report format or customized as required by the end user
  • Working knowledge and proven interest in pursuing a career in Capital Markets
  • Loan origination and maintenance of credit files according to federal banking guidelines improved cycles for regions recognized as wasteful or expensive
  • Used Use Cases, User Stories, Flow Charts, Process maps and Workflows Diagrams to supplement the planning phase.
  • Worked with IT team members and stakeholders about requirement changes and updates.
  • Involved in all phases of the SDLC, Agile, perform UAT testing. Understand, translate, communicate business requirements into detailed technical system specifications, and develop use cases.
  • Obtained business requirements from business users and stakeholders using JAD sessions, brainstorming sessions, focus groups and personal interviews on AGILE/ SCRUM methodology.
  • Worked on Methodologies, Governance frameworks for CCAR, ALLL/CECL, Stress Testing and Capital Planning, Regulatory Reporting for Consumer, Commercial Credit portfolios with Fixed Income trading desks.
  • Drafted User Stories and Use Cases and Identified User Story points with the Developers and assigned user stories to Sprints in Agile Methodology.
  • Reviewed existing functionality of online trading (Stocks & ETF’s), Options (Exchange Traded), MF’s and Bonds) to prepare for ported use of my Fi& CPB. Overhauled necessary components and reworked existing processes to increase performance and reliability on par with expected additional volume.
  • Full understanding of the structured trade life cycle (origination, trade modeling and execution, risk management, hedging, limits, credit risk management, ISDA standards and confirmations, reset processing, settlements, option event management, P&L analysis and reporting, account mapping and sub-ledger requirements, regulatory and compliance reporting).
  • Handled contract administration process duties to include, end-to-end signature process.
  • Was involved in daily risk analysis and analyzed daily trading activity for an interest rate derivative portfolio (IRD).
  • Assimilated the Business requirements from my Fi, CPB and Benefits Access to formulate their version of Online Trading Application with their own compliances.
  • Incorporated Automated Clearing House ACH functionality for the Private Label Credit Cards for Cash Advance abilities. Conducted Defect Validation using Test Director to screen the illegitimate defects raised by the QA and UAT teams before hitting Development.
  • Gathered insights on present framework and laid out the client centric application (Presentations).
  • Worked on billing system a cash management module and enhanced the encrypting standards that are required for the application.
  • Worked with SMEs to understand various assets and security classes, exchange traded derivatives (such as futures, options on futures, equity options and index options), OTC derivatives (such as interest rate swaps, swaptions, credit default swaps and total return swaps) and portfolio allocation and management.
  • Built a “restricted security” tool for the group to allow for RT blocking of specific securities in the case of last minute reorganizing issues.
  • Attended interviews and JAD sessions with stakeholders and other key decision makers in order to identify requirements and business-related information.
  • Involved in maintaining project progress and status through MS Project. Extracted periodic/ monthly status reports to the Project Manager to serve as the team's assessment of the project and its schedule.
  • Worked on Traceability Matrix table to uniquely identify and trace the business requirements to general design to testing as to prove that the requirements have been developed into a solution and that it has been tested and tracked.
  • Proficient in writing SQL queries for data analysis and validation.
  • Worked on SQL queries to retrieve data from Oracle for white box testing.
  • Responsible to extract specific data set from Operation database (ODS) by using PL/SQL query in order to data cleansing process and new feed processing purpose.
  • Involved in extensive DATA validation using SQL queries and back-end testing.
  • Worked with requirement documentation used for Data Extraction, Data Transformation and Loading process as a part of data mapping procedures.
  • Involved in training materials and interface requirements, adhered them to project management methodology.
  • Assisted Test Lead, Testers understanding business process and helped them for successful completion of Unit Testing, Integration Testing and Requirements Testing.
  • Involved in test cases and participated in UAT (User Acceptance Testing).

Confidential - Santa Clara, CA

Business Analyst

Responsibilities:

  • Gathered and documented business requirements from user groups, stakeholders and vendors by conducting interviews and discussions sessions. Gathering requirements from private bank group and business owner group.
  • Worked in software engineering methodologies or SDLC like Agile/Scrum and Waterfall methodologies.
  • Developed stories and documented alternate scenarios for bringing business prospective.
  • Arrange meeting to understand scenario of project and right the requirements on BRD and FRD.
  • Create use case scenario and draw process diagram and context diagram.
  • In the FRD Wright functional requirements, non-functional requirements and error Messages and Handling.
  • Handle whole project as a project coordinator and Making timeline for project to understand the budget of the project.
  • Elicited and documented application specifications by reviewing existing artifacts and interacting with stakeholders including the Asset managers, Portfolio Managers, Traders, Risk Managers, and Compliance team.
  • Interviewed Traders and analysts and created a list of functional specifications and Business Rules based on it.
  • Coordinated with risk compliance team for multiple products, in the analysis of alerts and investigation of transactional activities to detect any suspicions of fraudulent money laundering or terrorist financing activity.
  • Reviewing AML cases by doing extensive research on high-risk clients via KYC.
  • Analyzed Credit Risk (CCR) exposure measures using nice optimization.
  • Coordinate with EDW team for develop the database for the projects.
  • Assisted in the administration and review of Client Risk Scoring, Client Identification and KYC documentation oversight/management requirements.
  • Worked on various credit card applications to ensure PCI compliance and perform other ISA functions (Information Security Administration).
  • Analyze the new regulatory requirements of Dodd Frank and Basel Accord III for Pillar 1, 2 and 3 phases on Market Risk calculation, monitoring and reporting, and new implementation of Comprehensive Stress Testing.
  • Create stack holder check list to understand involve employee in the projects.
  • Worked on cyber security implementation form for project.
  • Working as project coordinator. Making timeline and project check points to achieve project deadline.
  • Conducted extensive analysis of KYC data to understand the attributes, schemas and data structures.
  • Worked on creating various reports using MS-Excel Worked on various Pivot tables to do the calculations and creating reports accordingly.
  • Create process flow diagram and contact diagram to describe whole project to developer.
  • Performed Data analysis, data mapping, created ER diagrams and used SQL queries to filter data.
  • Create report requirements to make sure about project achieve the goals.
  • Worked closely with QA team to create test plans, test objectives, test cases and executed smoke testing, performance testing, and UAT.
  • Used JIRA to track defects, report defects, and maintain log for the system.
  • Create UAT (user exceptions testing) to working with system analyst.

Confidential, New York, NY

Business Analyst

Responsibilities:

  • Gathered analyzed, documented business and technical requirements from both formal and informal sessions and validate the needs of the business stakeholders.
  • Co-authored business requirements document with project teams. Extracted, discussed, and refined business requirements from business users and team members.
  • Modeled AS IS and TO BE processes using MS Visio.
  • Analyzed Business Requirements and segregated them into high level and low level Use Cases, Activity Diagrams / State Chart Diagrams using Rational Rose according to UML methodology thus defining the Business Process Models.
  • Supervised and managed project throughout SDLC to ensure that project management methodology based on RUP is followed during the project lifecycle using MS Project.
  • Explain to the customer the aims and specifics of investment plans and policies, the kinds of services that will be offered, and the Financial Consultant's duties.
  • Ensured that information obtained is consistent with BSA/AML policy.
  • Strategic sourcing procurement specialist, skilled in managing supply chain, vendor contract management, inventory and logistics, audits, coordinating equipment, demand and maintenance scheduling with customer service posture.
  • Worked with the procedures of Banking, Regulatory Compliances - Anti-Money Laundering (AML), Customer Identification Program (KYC/CIP), CCAR Regulatory Reporting, Dodd-Frank Act.
  • Extensively worked on Contract lifecycle management tool like Oracle Contract Management ranging from establishing corporate contract policies to tracking contract performance.
  • Responsible for end to end support for state farm enterprise credit cards product: Visa, MasterCard, Amex and Discover.
  • Confirmed that BSA/AML Policy and Procedures and satisfies regulatory requirements were consistent with the information.
  • Assisted in the administration and review of Client Risk Scoring, Client Identification and KYC documentation oversight/management requirements.
  • Verified all aspect of Client Identification Program (CIP) and necessary account opening documents are provided and in accordance with know Your Customer (KYC) and Bank Secretary Act (BSA) standards.
  • Involved in analysis of KYC data to understand the attributes, schemas and data structures.
  • Conducted extensive data analysis of different data bases which were going to be part of the application to understand the attributes, schema and data structure.
  • Support CCAR and BASEL (II) data acquisition teams to validate and reconcile data from various systems.
  • Organized weekly Project Status and Task Review meetings, created PowerPoint presentations and project updates using MS Project for management review.
  • Interacted with the Client Onboarding Risk and Controls team to establish a quality assurance program for Client Onboarding to include methodology and sampling methods and ensure compliance with policy and regulatory requirements.
  • Cooperated with CCAR team on delivering of the Basel capital regulatory results to serve the CCAR variousreporting forms.
  • Organized the project into phases to impose management control using stage-gate reviews such as high-level user stories, test scenarios, Dimension modeling, Client reference data, Data Mapping, ETL etc.
  • Created project charter and project plan, presented different solution and time lines with the help of project manager.
  • Created flow chart diagrams using MS-Visio and BPM modeling.
  • Created data mapping document for the application after finalizing the attributes and tables with business users
  • Identified and communicated dependencies and potential risks to the completion of the project including resources, costs and systems.
  • Conducted Joint Application Development (JAD) sessions with IT groups. Identified the Key Changes, and participated in Stakeholder Management to communicate effectively with them.
  • Used Rally tool for requirements management and tracking user stories in a sprint and product backlog.
  • Tracking business reporting issues on JIRA by creating problem statements that help breakdown the underlying issue.
  • Involved in maintaining project progress and status through MS Project. Extracted periodic/ monthly status reports to the Project Manager to serve as the team's assessment of the project and its schedule.
  • Worked on Traceability Matrix table to uniquely identify and trace the business requirements to general design to testing as to prove that the requirements have been developed into a solution and that it has been tested and tracked.
  • Interacted with developers to resolves questions and discrepancies in documents, hands-on experience with SQL queries.
  • Proficient in writing SQL queries for data analysis and validation.
  • Developed customized SQL reports and queries for management decision-making and operational management.
  • Performed back-end testing on the Oracle database by writing SQL queries and executed SQL scripts for data validations with MIS team.
  • Wrote PL/SQL script to extract accounts payable data from API file to send to MAINFRAMEORACLE, advanced PL/SQL programming.
  • Developed strategies with Quality Assurance group to implement Test Cases in Mercury Test Director for stress testing and UAT (User Acceptance Testing)
  • Assisted with the development of test plans and strategies, coordinated testing events, and executed test cases in support of changes to business systems.
  • Participated user acceptance testing cycle; worked withbusinessusers to definebusiness scenarios, user acceptance test cases and user acceptance criteria.

Confidential - Jersey City, NJ

Business Analyst

Responsibilities:

  • Liaison between stakeholders, system users, clients and managers, software development team and the QA term to gather requirements.
  • Involved in the facilitation of (JAD) Joint application Development sessions to identify the business rules and requirements and then documented them in a format that can be reviewed and understood by both business people and technical people.
  • Involved in Requirement Scoping and analyzing high priority requirement for implementation.
  • Studied and analyzed competitor's applications and brainstormed to gather effective requirements for a quality product.
  • Created Business Requirements Document and converted them into System Requirement specifications document.
  • Followed the RUP methodology right from inception to the projects transition.
  • Coordinated with the development team, database team, data warehousing team and QA team throughout all phases in the RUP methodology.
  • Worked on business modeling, data modeling, and object modeling using MS Visio to develop the business architecture for the application.
  • Analyzed Requirements and created Use cases, Use Case diagrams, Activity Diagrams using Enterprise Architect.
  • Learned how to create and manage project templates, use case project templates, requirement types and traceability relationship in Requisite Pro.
  • Interacted with QA Team in writing test cases, test plans and tested the final application for usability testing to verify whether all the user requirements were catered to by the application.
  • Archived all project documents and implemented the UCM model for activity-based Configuration Management using Clear Case.
  • Used Rational Clear Quest for defect tracking and change management request and reported them.
  • Involved in preparing a simple and detailed User manual for the application, for an intended novice user.

Hire Now