Sr Business Analyst Resume
NJ
SUMMARY
- Over 8 years of proactive IT experience as a Business Analyst with Finance and Banking exposure inbusinessprocess analysis, design, development, testing, integration and maintenance with strong understanding of sequential and Iterative approaches like waterfall, RUP, Agile project management methodology with Scrum/XP to manage the software development life cycle (SDLC).
- Excellent knowledge of banking industry (Retail banking, Investment banking, Private banking, Portfolio management, Asset management) and financial servicesspecially in secondary mortgage market
- Expert knowledge in with various capital market instruments and securities including Equities, Fixed Income Instruments, Risk Management (Credit and Market Risk), Mutual Funds, Derivatives (OTC market, F&O), Hedge Funds, ETF’s, securitization, Mortgage backed securities, Asset backed securities
- Excellent knowledge of pricing capital market and money market securities such as fixed income securities, equities and derivatives how they are impacted by the Bank Secrecy Act, USA PATRIOT Act, Dodd Frank Act, Anti - Money Laundering, OFAC and Customer Identification Program (KYC/CIP), Basel II compliance using industry standards and regulatory guidance, etc.
- Excellent understanding of Corporate Finance, Quantitative analysis, P&L, Balance sheet analysis, accounting, Financial market, derivatives, fixed income, equity, Financial modeling, data forecast, sensitivity analysis
- Clear understanding of Cash Management, fee refunds and CRA activities,Clear understanding ofAccounting Controls, principles and procedures, generally accepted accounting principles(US GAAP), IFRS,
- Experience in AML& Trade Surveillance tools such as Actimize and good understanding of related topics structured Investment products, securitization and OTC derivatives market experience with exposure to trade life cycle, pre-trade/post-trade processes, collateral operation/management, market risk & credit risk modelling pertaining to OTC Market and products, pricing data, data, CCP’s
- Strong Experience and knowledge of working with MD 20, MD50s and MD70s documents
- Expert in planning and Design of Flex Field structures, Set of Books, Budget Setups & Controls, Consolidation, MRC and Income & Expenditure
- Worked closely with project stakeholders, SME & staff to understand requirements and specifications for new applications along with re-engineering the existing application
- Strong writing skills in preparingbusinessrequirements documents (BRD), system requirements specifications (SRS), Software Requirement Specifications (SRS), Use Case Specifications, Functional Specifications (FSD), Requirement Traceability Matrix (RTM) and technical design document
- Defining project plans then translatingbusinessrequirements/user expectations into detailed specifications like Use case diagrams, flow charts, activity diagrams, sequence diagrams,use case document,test plans and test case documents employing UML
- Highly proficient in conducting User Acceptance Testing (UAT) verifying performance, reliability and fault tolerance issues. Also familiar with testing tools (QC) to design as well asgenerate test plans and test scripts and their execution
- Moderate to high proficiency in SQL Queries and MS Excel
- A highly motivated, detail oriented and aggressive self-starter with integrative thinking & problem solving skills, capable of forming and maintaining positive and productive working relationships in internal, external, independent, and team environments
TECHNICAL SKILLS:
- MS Windows 2000
- XP 2003
- NT
- Vista
- MS Office 2010/2007/2003/2000
- Excel
- Word
- PowerPoint
- Project
- Visio
- Access
- Publisher
- FrontPage
- Outlook)
- Markit pricing data
- Lotus Notes
- VB 6.0
- Mainframes
- Rally
- Rational Suite 2003/2001 (Rose
- Requisite Pro
- Clear Quest)
- MS SQL Server 2008/2005/2000
- Erwin
- Oracle 9i/10g
- HP (Quality Center 9.2
- Quick set Professional 8.2/9.2)
- HP Unified Functional Testing
- Actimize
- SMARTS
- SSAS
- SSRS
PROFESSIONAL EXPERIENCE:
Confidential, NJ
Sr Business Analyst
Responsibilities:
- Studied the need to develop and implement this project
- Identified project stakeholders and their roles
- Identified major deliverables and collected business requirements for the project
- Drafted project charter, which included project goals, business case, opportunity statement, and high level timeline and team assignments for the projects
- Worked with senior management to get approval on project charter and ballpark budget estimatesPlanning
- Organized the project into phases to impose management control using stage-gate reviews such as high-level user stories, test scenarios, Dimension modeling, Data Mapping ETL etc
- Involved in Object oriented designing using UML (sequence, activity diagram), Translate business abstractions to object-oriented class representations in UML 2 notation.
- Devised a work breakdown structure by decomposing the project deliverables and User Stories
- Identified major activities as per the Agile Scrum methodology
- As Scrum Master created and prioritized the Back Log in Rally, coordinated Planning Sessions and maintained User Stories and Acceptance Criteria
- Elicited Business/system requirements and business/system needs as part of an Agile Scrum team
- Identified resource requirements i.e., business analysts, software developers, testers etc
- Developed project schedule by incorporating resource availability and milestones for reporting
- Prepared communication and information distribution plan for the project
- Conducted risk assessment of the project and trade surveillance for regulatory purposesExecuting
- Coordinated development activities across various departments
- Understood the AML7 trade surveillance compliance requirements by interacting with compliance department, and SME experts in the laws/act of compliances
- Observed major spikes and reworked release plans
- Studied the existing KYP/CIP system and prepared the test data for the CDD and EDD based on the inputs.
- Conducted review meeting to continuously assess the status of project with regard to project plan and controlled iterations of the deliverables in conjunction with UAT’s bugs or revisions
- Delivered presentations on prototypes of application to different groups in organization
- Created wireframes & mockups for the dashboard improvement project
- Designed business process flow
- Provided technical and procedural support for User Acceptance Testing
- Improved team morale by conducting team-building activities
- Managed the development of documentation pertaining to a project milestoneControlling
- Measured project performance on time and budget as per the project plan
- Managed changes to project scope using a change management procedure in coordination with Change Control Board (CCB)
- Prepared and monitored release plans
- Controlled iterations and released spikes
- Managed the software configure change management for code/ requirements/ design/ versions
- Delivered an IT Recovery Plan, process integration and governance model for all changes
- Managed project performance and reporting through project scorecards and milestone reportsClosing
- Verified deliverables for each phase with project stakeholders, by executing the test scenarios
- Delivered project documentation related to application design, testing results and operating procedures for the application
- Documented lessons learned from project
- Tracked testing issues, maintained test matrix, ran daily status meetings, and met the exit criteria for UAT
Environment: PMBOK, Agile Scrum, Rally, Rational Jazz suite, HP QC, MS Visio, UML, Actimize, SMARTS, Subversion (SVN), MS Project, SSIS, SSRS
Confidential, Cranston, RI
Business Analyst
Responsibilities:
- Gathered Business requirements pertaining to the pool of mortgages and their risk assessment criterion that are used to issue Fixed Incomes like bonds & Treasury, converted the same into functional requirements by implementing the agile scrum methodology and authored the same in Business Requirement Document (BRD).
- Maintain advanced knowledge of fixed income markets.
- Aggressively involved in the process of understanding and creating business rules for analyzing the pricing mechanism of Fixed income products(treasury bills/notes/bonds) to understand the credit rating criterion used by the credit rating agencies
- Being involved in dashboard designing using wireframes & mockups, created complex business rules to generate results in form of graphs which in turn helped the fixed income portfolio team to create credit enhancement strategies
- Created requirements document and user stories for the development and test teams using the Rational Jazz Suite - RTC and RRC tools
- Proactively identifying and removing blockers, facilitate frequent retrospectives, sharing metrics to identify and implement improvements.
- Provide coaching on Agile values and practice to other teams within the company
- Involved in Scrum Sprint Planning Sessions, Backlog Grooming, Sizing, Sprint Retrospectives & Reviews, Daily Stand-ups, User Stories and Acceptance Criteria.
- As Scrum Master created and prioritized the Back Log in Rally, coordinated Planning Sessions and maintained User Stories and Acceptance Criteria.
- Elicited Business requirements and business needs as part of an Agile Scrum team.
- Worked on creating Functional requirement documents, System requirement Document and business process flow
- Structured flexible test plans, test cases and test scripts to test entire application based on business requirements, technical specifications, product knowledge and use case scenarios.
- Addressed all aspects of the loan life cycle, starting from identifying a prospective client to the loan closure
- Participated in project review meetings to resolve defect related issues.
- Revised existing documentation comprehensively to enhance the ability of the stakeholders to proceed with the next major phase of developing the application.
- Performed User Acceptance Testing on behalf of end-user to ensure that the user requirements are satisfied and properly tested.
- Assisted in implementation and deployment of the best SCM processes with seamless integration among various phases of Software Development Life Cycle (SDLC) such as Change Request and Product Life Cycle Management utilizing UCM component of Rational Suite.
Environment: Agile Scrum, Rally, JAVA, Oracle, UML, OOD,Quality Center, VB, .NET, UNIX, Microsoft Office suite, MS Visio, Rational Jazz Suite - RTC and RRC tools, SQL server 2008,Fireworks
Confidential, NYC,NY
Business Analyst
Responsibilities:
- Gather the requirements for arriving at the reach a breakeven point where the firm starts making profit for itself and its stakeholders.
- Prepare the complex business logic to feed to the software that evaluates the breakeven using various methods such as Discounted cash flow method (DCF), NPV,IRR method to reach to the acceptability
- Gathered the data for the Industry analysis, market share, Key growth driver in mobile services industries, Telecom services revenue, data| voice| Non-voice ARPU, Global broadband penetration
- Fed the data to the software that analyzes the sensitivity to see how the variance in the critical parameters changes the impact on revenue and effects the decision
- Studied the 5 year of forecast of ARPU taking into account the industry growth, the structure of the company, the market share and historical CAGR, as well as the projected demographics details.
- Gathered the syndicated historic data of ARPU of existing 4G businesses of USA. In order to develop the forecasting model, we take assumptions based on PWC report and FICCI,HSBC Global Research in order to achieve the same
- Documented specifications for calculating and analyzing of the BETA (systematic risk) using linear regression model, Sensitivity analysis for variance in factors mentioned earlier, hence highlighting the most critical factors. Measuring Skewness (how biased the data is towards one side) & Kurtosis of projected 4G ARPU.
- Created detailed sequence diagrams, class diagrams, business process and activity diagrams to elaborate the behavior, structure and process flow for the use-case models.
- Assisted in developing test cases to check the system functionality
- Implemented Requirement Traceability Matrix (RTM) to tracking functional/non-functional requirements to test cases.
- Assisted users to perform paper trading during UAT and created user guides for end users
Environment: UML, MS Visio, MS SQL, MS Office Suite, Mercury Quality Centre, UML,OOD Quality Center,, J2EE technology, UNIX / Oracle Platform, waterfall
Confidential, Herndon, VA
BusinessAnalyst
Responsibilities:
- Gathered user andbusiness/regulatoryrequirements through interviews, surveys, prototyping and observing from portfolio managers and UI (User Interface)
- Conducted Joint Application Development (JAD) sessions for requirements gathering withBusinessStakeholders, SME's, Users, refined it using Wireframes
- Provide hands on agile project management approach & planning, apply strategy and scrum framework in various projects/phases, set team's objectives and goals
- Facilitate of all aspects of the scrum framework, including sprint planning sessions, backlog grooming sessions, daily scrums, product demos, sprint reviews and sprint retrospectives
- Support and consult product owner in developing, maintaining and grooming product backlog
- As Scrum master involved in maintaining the capacity plan, iteration board, sprint backlog, velocity charts and burn down charts
- As Scrum Master involved in identifying and removing impediments to the success of the sprint by working with every single team member
- Reconcile the tax information from generated reports, balance sheets, and general ledger accounts and post and prepare journal entries (J.E.)
- Coordinated withbusinessusers to prepare, updateBusinessRequirement Documents (BRD) and Functional Requirement Documents (FRD),business process flow documents
- Created Use Cases documents for requirements
- Scheduled meetings with developers, SAs (SystemAnalyst) and testers to collaborate resource allocation and project completion using MS Project
- Conducted process improvements, status meetings, presided over the Changed Control Board meetings to discuss Defect and Enhancement
- Conducted UAT and Coordinated with the QA Team for the sign-off process before deployment and assisted the Project Manager on creating the Lessons learned document
- Created Ad-Hoc financial reports for the topmanagementusing MS Excel.
Environment: Actimize, MS visual Studio .NET, MS .NET Framework, J2EE technology, UNIX / Oracle Platform, Agile Scrum, Rally, Rational Jazz suite, HP QC, MS Visio, UML, Subversion (SVN)
Confidential
Business Analyst
Responsibilities:
- Worked for change management team on derivative-(OTC)/collateral management/margin calculation area
- Prepared business requirement document for VAR based Independent Amount calculations for Equity, Credit, Interest Rates and FX swaps
- Prepared requirement document for collateral posting and contingent liability reporting of Derivatives SPVs due to credit rating downgrade by S&P and Moody’s
- Prepared BRD and test cases for consumption of margin calculations from risk based calculator in to back office collateral management system including feed specifications, dispute handling, and reconciliation and reporting
- Prepared current state and gap analysis documents and presented to senior stake holders for segregation of Independent Amount and third party Custodian Interface with help of Business and Technology partners including cash and securities settlement, reconciliation and reporting
- Integrated vendor pricing/ data into the model to get Insight into market sentiment and trading transparency from a macro to individual stock level
- Prepared BRD and Test document including test scripts for enhancement in to Legal Documentation System (ISDA Master Agreement/CSA) and collateral management system with the help of business, operations and technology partners. Coordinated QA and UAT including defects and its resolution by technology team in timely manner
- Responsible for review of requirement documentation done by junior analyst and mentoring for their project management career paths
- Prepared collateral operations specific project plan, defined end to end work streams and stake holder matrix for target state collateral
- Prepared RFP document for custodian liaison and interface and participated in discussions with various Custodians (BONYM, JPM, Confidential etc.) for automation and STP processing of collateral
- Prepared target state flow diagram for collateral at third party custodian including treasury, settlement and reconciliations system interface for cash and securities processing
- Evaluated regulatory impact on credit, and collateral provisions in ISDA CSA such as minimum transfer amount, threshold and rounding, eligible collateral, re-hypothecation, segregation of independent amount and compared them to current capabilities. Conducted gap analysis and prepared BRD document for enhancement in legal documentation system and its feed into margin system
- Conducted data analysis with assumptions and prepared cost estimate for CSA / ISDA Master Agreement renegotiation efforts in light of Regulatory Reforms
- Worked with XML data for communication purposes through FpML,SWIFT
- Prepared Bilateral OTC derivatives matrix and Client profile decision tree front to back workflow, collateral operations, legal documentation and margin calculations, reconciliation and reporting based on dynamically changing regulatory requirements
Environment: Rational Suite(Rational Rose, Rational Requisite Pro, Rational Clear Quest, Rational Clear Case), Rational Unified Process (RUP),Java, J2EE technology, Windows 2000 Advanced Server, UNIX / Oracle Platform, Markit data, MS Visio, SSIS, SQL server 2000 SQL server 2005,Microsoft Office suite, Bloomberg, ruters, markit data
Confidential, Dallas, Texas
BusinessAnalyst
Responsibilities:
- Created the GL mapping sheet to ensure proper migration of accounts within the general ledger via account codes to meet GAAP standards
- Involved as a SME in the design of the combined general ledger and the database used to verify the posting process
- Analyzed the business process and confirmed the setups needed to reflect the business process
- Involved in requirement gathering process using Rational Requisite Pro, which included interviews, brainstorms and meetings with stakeholders
- Identified the current business process, documented the workflow and improved the efficiency of the current business process in the Accounting department
- Developed scenarios of Posting, Check payment, ACH, Mortgage, Lockbox, Fraud and Exceptions
- Conducted JAD sessions to allow different stakeholders to communicate their perspectives with each other and resolve any outstanding issues
- Identified and created all necessary Business Use Cases from requirements, created UML Diagrams including Use Cases Diagrams, Activity Diagrams, Sequence Diagrams, and Class Diagrams related to MD 20, MD50s and MD70s documents
- Worked on data modeling and produced data mapping and data definition documentation
- Designed and implemented basic SQL queries for testing and report/data validation
- Used Data warehousing for Data Profiling to examine the data available in source Database
- Developed strategies for Data Scrubbing, Cleansing, Enriching, transforming and loading Data in Staging/Data warehouse
- Involved in the writing the SQL queries and managing the Oracle database for the Posting process
- Maintained and kept track of stakeholders’ requests for enhancements and changes
- Understood the business logic, User requirements and test-objectives to develop test plans, test cases, and test case execution
- Tested the application manually by executing Test Cases prior to Automation
- Participated in Bug-Review meetings with software developers, QA engineers, managers and suggested enhancements to the existed application from business perspectives, provided solutions to existing bugs
- Conducted UAT (User Acceptance Testing) to make sure that all the user requirements are catered by the application
- Involved in preparing a simple and detailed User manual for the application, for the intended users
- Provided to the Users and explaining them the Business as well as the Technical side of the Proprietary Santander system
Environment: RUP, UML, MS Visio, MS Access, SAP,SQL, Oracle 10g Java, SQL Server Reporting Services SSRS, Quality center
