Sr. Business Analyst Resume
5.00/5 (Submit Your Rating)
NY
SUMMARY
- 8+ years of proven excellence as Business Analyst in banking and finance domains with expertise in eliciting business requirements and translating them into various Business requirement documents (BRD), Functional requirement documents (FRD).
- Profound knowledge of various banking and finance fundamentals like capital markets, equities, financial databases, general ledger, accounts payable/receivable, risk management, derivatives contracts etc.
- Industry domain experience in Financial Budgeting, Insurance, Mortgage, Risk Management, Disaster Recovery, Loan Pricing.
- Strong subject matter expertise in Investment/Retail banking, financial statements, cash flow, financing structures, Foreign Exchange FX Risk Management, Capital Management, Asset Data, Fixed Income, Portfolio Analysis, Stock Valuation, Capital Structures and Budgeting, Value Based management. Worked extensively with Microsoft Excel Macros, VLOOKUPS, and Pivot Tables. Proficient Microsoft Word, Power Point, Access and Lotus Notes. Extensive experience on Mobile/E - Banking solutions.
- Experienced in SDLC methodology for Agile Scrum and traditional Waterfall. Well versed with Agile ceremonies and Agile tools (JIRA).
- Worked extensively with SME's including heads in areas of fixed income derivatives, options, foreign exchange (FX), futures and risk managers in understanding, extracting, refining and documenting the User and Business Requirement Specifications in the BRDs.
- Strong exposure in store and process credit card / Debit Card accounts and process transactions (Visa, MasterCard, Confidential, Europay, private label transactions). Having strong domain knowledge in application catering to banking/Credit cards / mortgage business. Familiar with the full life cycle of credit cards applications for different banking systems. Have strong knowledge in the following phases of credit cards life cycle.
- Strong knowledge in products like savings account, checking account, money market, Time deposits, Certificate of deposit(CDs), KYC(Know Your Customer), AML(Anti money laundering), ATM, loans, credit, mortgage, asset & liability products, cash management, ForeignExchange Internet baking, wire transfers(EFT, ACH, payments) and SWIFT.
- Worked with First Data Corporation, one of the top payment systems organizations in the world for providing banking solutions like electronic payments, Transaction warehousing, collections systems, Mortgages.
- Experience in Competitive Analysis, Data Analysis, Gap Analysis and understanding of ROI Analysis, P&L Analysis, SWOT Analysis, Impact Analysis and Cost - Benefit Analysis.
- Experience in various programming languages SQL, XML and operating hardware and software applications including TOAD, Crystal Reports, Oracle Discoverer, Query Analyzer and SQL Navigator.
- Strong experience in conducting User Acceptance Testing UAT and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
- Proven success as a business analyst through the years, providing a well-balanced understanding of business relationships, business requirements, and technical solutions.
- Professional experience in business analysis, operations management and development, design, documentation and testing.
- Highly experienced in Designing process modelling (UML) using Use Cases, Sequence Diagrams, Collaboration diagrams, Activity Diagrams, Class Diagrams and Data Modelling.
- Experienced with ETL Informatica Power Center and other ETL tools such as data stage and creating Database objects (Tables, Views, Stored Procedures, and Triggers etc.).
- Real-time experience in conducting User Acceptance Testing (UAT), documenting Test Cases and general QA by working with development and testing team during prior launch phase.
- Demonstrated ability to identify root causes of problems, consider both the long and short-term impact of proposed solutions and develop workable solutions. Ability to manage Multiple project tasks with changing priorities and tight deadlines. Ability to work well in a team. Open to Team related tasks, team meetings, team interaction and conference calls.
- Demonstrated ability to work well with a wide variety of people at various levels, foster cooperation and collaboration among individuals in the work unit, help team resolve conflicts constructively and ability and willingness to communicate when help is needed. A Self starter with a positive attitude, willingness to learn new concepts and acceptance of challenges.
PROFESSIONAL EXPERIENCE
Sr. Business Analyst
Confidential, NY
Responsibilities:
- Met with stakeholders and users to review / manage expectations and identify opportunities to improve ROI.
- Initiated business directives to standardize asset classification across wealth management practice to ensure consistency across capital market assumptions strategy, asset reporting, compliance, and sales functions
- Authored Business Requirements Document BRD with project teams. Extracted, discussed, and refined business requirements from business users and SME’s.
- Liaison with business users and IT for Business Requirement Document (BRD) and Business Functional Specifications (BFS) integration and conversion project execution.
- Documented Visio work flow diagrams of current and future US Tax provisioning processesthat were impacted by the US Tax Automation project.
- Prepared Use cases and Activity flow diagrams and Work flow diagrams with MS VISIO.
- Developed a consistent reporting system cash flow, P&L and balance sheets.
- Analyzed requirements & recommend strategic initiatives for OTC derivatives protocols and practices around DTCC, CDS, SWIFT for treasury and asset management documentation.
- Handled change request and change management and project management using Clarity Project.
- Developed Business rules for the equity trading system based on technical chart analysis and fundamental analysis and trends.
- Working 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 Knowledge of STP and SWIFT messages.
- Resolved issues with check printing, Crystal Reports, positive payment and Accounts Payable voucher matching functionality. Bring outsourced Oracle E-Business Suite support in-house, improve business processes.
- Moreover, I also authored functional requirements documents FRD by interacting with development team for improving client’s legacy system.
- Conducted status report meetings with the business and the IT team on a weekly basis, as the most important aspect of the project was Data Mapping.
- Assisted project managers with the development of project schedules. Developed requirements and preliminary design for client applications. Performed analysis and design projects using a systems development methodology. Worked with all levels of client staff in solution definition.
- Involved in supporting over the counter (OTC) derivative trade capture and straight through processing (STP).
- Assisted the development team in preparation of the CRUD Matrix.
- Prepared graphical depictions of Use Cases, Use Case Diagrams, State Diagrams, Activity Diagrams, Sequence Diagrams, Component Based Diagrams, and Collateral Diagrams and creation of technical design (UI screen) using Sparx.
- Exposed to SQL queries while churning out relevant information from company’s database.
- Assisted in system and user acceptance testing (UAT), free-trial demos, performed client presentations.
- Submitted change requests and worked with change request records in ClearQuest.
- Participated in entering and tracking system defects in Rational ClearQuest.
Sr. Business Analyst
Confidential, New York, NY
Responsibilities:
- Review various institutional accounts, retail and correspondent banking accounts
- Responsible for the appropriate collection and examination of documents to assist in identifying unusual transactions
- Worked with cross project technical BA teams to design ERS (Enterprise Registration Services) and MDMinterfacedesigns to SYNC UP systems, conversion and survivor rules.
- GatheredBusinessRequirements, interacted with the stakeholders, developers, Project Manager and facilitated JAD sessions to identifyBusinessProcesses.
- Reviewed Inbound and outboundInterfaceXML files and manipulated xml files for unit testing on XML Tester.
- Conductedmarketresearch and analysis inCapitalMarketsconsisting of StockMarketand BondMarket
- Experience in user requirements gathering, use case design and analysis, Use Case Specification Documents (USD), scenarios,businessprocesses, workflow diagrams, process flows and technical documentation, using Unified Modeling Language (UML) and MS Office Suite.
- UpdatedBusinessRequirement Document with review comments from stakeholders, contributed to UAT test strategy document, maintained team WBS for weekly report
- Analyzing the high-quality Liquid assets and cash flows across the portfolio of products -derivatives, deposits, loans, debt securities, equities, stock borrowing/lending, collateral swaps.
- Responsible for data sourcing, data mapping, data profiling and analysis and data quality check by querying DWH data and extract from transactional source systems
- Created data mapping file for design team, using SQL, Toad, Excel as major tools
- Experience in process mapping / process flows / process modeling.
- Experience with Microsoft Visio and workflow solutions.
- Negotiating withCapitalMarket, Leverage Finance, and Legal Counsel on originating bank debt loans.
- Proficient skills inbusinessanalysis, requirements analysis, data analysis and GAP analysis.
- Expert in documentation - Project Plan, High Level Requirements, BRD, Use Case,Business Implementation Requirements, SRS, Process Maps, Work Flow Diagrams, Change Requests.
- Took part in gap analysis to understand what new changes were needed in the existing system.
- Analyzed and collectedbusinessrequirements, identified system interfaces and created the BRD by user interviews identifying ambiguous, incomplete and incorrect requirements.
- Prepared vision document for defining the scope of the project and the various functional and non- functional requirements involved in it.
- Collected and documentedbusinessprocesses as well asbusinessrules.
- Prepared and documented Use-Cases using UML based on requirements gathered from stakeholders.
Business Analyst
Confidential, New York, NY
Responsibilities:
- Conduct Brainstorming and JAD Session to gatherBusinessRequirements from Market Risk Group, Risk Reporting Team and other stakeholders (PMEs, Compliance, etc.)
- Conduct Gap Analysis of the features and functionality of current platform version and new version to determine the new functions to be added in.
- Design detailed FRD according to BRD and Basel regulatory requirements using Power Designer.
- Model the detailed design of thesystemusing UML diagrams including Sequence Diagrams, Activity Diagrams and Use Case, and Data Flow diagrams using SmartDraw.
- Facilitate meetings with the Development Team and Testing Team to walk through the FRDs and discuss feasibility of each requirement.
- Performed GAP analysis to enhance the monitoring and reporting of control processes inCapital Marketsdealings from front office (sales and trading) to middle office (product control,) to back office/operations, (regulatory reporting and compliance) as well as trade processing, including clearance and DTCC settlement.
- Involved in identifying Functional and Non-Functional requirements and created the FunctionalSystemDesign document (FSD).
- Gatheredbusinessrequirements through interviews, surveys, and observing from account managers and UI (UserInterface) of the existing Brokerage Portal system.
- Analyzed user problems, including automated and manualbusinessprocesses and identified, researched, investigated, defined and documentedbusinessprocesses
- Reviews test scenarios to ensure complete coverage of release contents, management of change controls and integration into existing work items.
- Develop test plans/strategy documents and manage test cycles to verify error free implementation of changes using JIRA
- Responsible for gathering comprehensive and holistic requirements from abusinessperspective to ensure that
- Identify and assess potential data source of Interest Rate, help the market data team to integrate data using ETL tools.
- Implemented Front End to a Fixed Income Derivatives Trading System, including trade blotter and interfaces to risk management, accounting, and middle and back office.
- Implemented Simulation Tool to price complex equity derivatives portfolios in
- Combination with fixed income and finance desk portfolios.
- Developed a (UAT) User Acceptance Testing plan to guide a select group of key end-users in testing the userinterfaceand functionality of the application.
- Generated Unified Modeling Language (UML) diagrams such as Activity, State Transition and sequence diagrams to demonstrate critical processes.
- Documentedbusinessrequirements, and created abusinessrequirements document.
- Identified actors and use cases to create use case diagrams that described the behavior of thesystem.
- Reviewedsystem-testing results with the project and technical teams.
- Followed the UML methodology to generate Activity Diagrams, Sequence Diagrams, Class Diagrams and Collaboration Diagrams using Rational Rose.
- Facilitated questionnaire sessions to identifybusinessrules, requirements and document them in a format that can be reviewed and understood by both thebusinessusers and technical team.
- Review Test Plan and Test Cases provided by Testing Team.
- Conduct quick Smoke Test after each bill in testing.
- Involved in design and implementation of Progression and Regression Tests of the new functionalities added in QRMsystem.
- Manage bugs using Defect Tracking Tool like Silk Central, review each defect and assign development team to resolve problems.
- Generate User Manual and prepare Training Material of new QRM to internal users.
Confidential, Tampa, FL
Business Analyst
Responsibilities:
- Worked with Fixed Income, Bonds and Bond Trading Cycle, Bond Pricing, Equities, Trade Cycle, Derivatives (Options and Futures), Portfolio Management, Sales and Marketing.
- Collaborated in building a business process model using Rational Rose, RequisitePro, and Visio.
- Involved in business system analysis of customizing the BPS Risk Management product with involvement through the whole SDLC.
- Constant interaction with Capital Market business users for job shadowing, understanding certain issues which I need to deal with for completing Proof of Concept and BRD.
- Involved and reviewed TSQL/SQL queries and stored procedures to process, analyze and implement data integrity initiatives for various business units.
- Involved in documenting detailed Functional Requirement Specification based on Basel regulatory requirements by using Power Designer.
- Involved in extensive analysis on security trading cycles; provide consulting on financial disclosure, regulatory and compliance issue.
- Created Business Requirement Document (BRD), Functional Requirement Specification (FRS) document, User Requirement Specification (URS) and Change Request (CR) document for system application development.
- Gathered user and business requirements through interviews, surveys, prototyping and observing from Fixed Income Portfolio Managers/Advisors. Stored and modified requirements in MS Word.
- Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, and OOD using UML.
- Involved in performing requirement analysis, went through all the use cases and issue logs.
- Involved in customer's risk in terms of propensity to commit money laundering, terrorist finance, or identity theft.
- Provided clear and concise technical documentation regarding requirements management plans, Technical Requirements, supplemental Requirements, Test Plans and Test Cases.
- Executed several Optimized queries in SQL on this data.
- UsedRequirement Traceability Matrix(RTM) for mapping requirements to test cases usingJIRA.
- Involved in documenting detailed Functional Requirement Specification based on Basel regulatory requirements by using Power Designer.
Business Analyst
Confidential, Dallas, TX
Responsibilities:
- Interacted with Business Users to conduct thorough Requirements Analysis.
- Reviewed and analyzed the business environment and identified process improvements.
- Involved in interactions with the Subject Matter Expert, Project Manager, Developers, and the End-Users.
- Worked on activities with project manager and various other teams using MS Project.
- Interacted with other Business Analysts for designing and implementation of Use Cases and Test Plans.
- Involved in developing Logical and Physical data models that capture current state/future state data elements and data flows using Erwin.
- Involved in reviewing test plans and test cases and ensuring test cases reflect user needs. Also responsible for conducting user training and user acceptance testing to ensure and verify system is designed according to user needs.
- Worked on SDLC, Business analysis, Gap Analysis and Quality Assurance of application software in Agile framework.
- Helped in testing activities by developingTest plans, Test cases, Use Case ScenariosusingJIRA.
- Assisted in on-going process improvement efforts to ensure Test Planning, Execution, and Reporting is effective, efficient, standardized, coordinated, and integrated.
- Assisted the Senior Business Analyst in writing Functional Requirement Specifications (FRS) and User Requirement Specification (URS).
- Involved in developing Test Plans and Test Cases according to Business Requirements.
- Acted as User Acceptance Testing coordinator, monitored business testing, and interfaced with the development team regarding defect status and fixes on a daily basis.
- Involved in generation and execution of SQL queries.