We provide IT Staff Augmentation Services!

Senior Business Analyst Resume

5.00 Rating

Raleigh, NC

SUMMARY

  • An innovative and dynamic Business Analyst concentrated in Regulatory reporting, financial analysis and risk management area with 8 years of experience in business process analysis/modeling, business requirements gathering, analysis and documentation for various financial applications and systems.
  • High Level of Expertise in the Financial Industry and expertise in capital markets with extensive experience in Equities, Fixed Income Instruments, Derivatives (Future, Option, Swap, Forwards), and Alternative Investments (REIT, Hedge Fund, ETF, Mutual Fund)
  • In depth knowledge about the framework and foundations of risk management, including measurement and management of risks at enterprise - wise level
  • Experience in applying various risk measurement methods such as VaR, Expected Shortfall, stress testing for quantifying market risk, operational risk and credit risk
  • Familiar with different Linear Time Series Models such as ARMA, Seasonal Models as well as Conditional Heteroscedastic Models such as ARCH, GARCH and their deviations
  • Extensive experience with Trade activities, Trade Life Cycle, Capital Market, Portfolio Management, Wealth Management, Asset Management, Credit Risk, Market Risk, Operational Risk, Cash Correspondent Banking, Cost/Profit analysis, Budget and forecasting.
  • Strong knowledge with various regulations and compliances such as Basel II and III, CCAR, AML, KYC, Dodd-Frank/ Volker Rules.
  • Highly proficient in preparing Business and System Use Cases and supporting all the documents with UML diagrams using UML modeling tools such as MS Visio.
  • Solid experience in creating Wireframes, Storyboards, and User flows, Process flows and Site maps.
  • Extensive knowledge of Agile Scrum, Waterfall, and Rational Unified Process (RUP) Methodologies with expertise working with tools such as Rational Rose, Requisite Pro, Microsoft Visio, Microsoft Project, Microsoft Office Suite, Erwin Data Modeler, and Mercury Quality Center.
  • Extensive experience in developing Business Requirements Document (BRD), Functional Requirements Document (FRD).
  • Expert in writing queries using the SQL Server to perform data analysis.
  • Extensive knowledge in Data Mapping, Data Modeling, Star/Snowflake Schemas, OLTP/OLAP, and designing E-R Models; Worked with Erwin for Conceptual, Logical, and Physical designs.
  • Proficient in documenting System Test Plans, Defining Test Procedures and creating Test cases on the basis of product release features, client’s requirements and related technical documents.
  • Ability to manage workload within time sensitive deadlines in addition to handling multiple projects or tasks under minimal supervision.

TECHNICAL SKILLS

  • MS suite
  • Excel
  • Word
  • PowerPoint
  • Access
  • AXIOM
  • MS Visio
  • MS Sharepoint
  • UML
  • SSAS
  • SSRS
  • JIRA
  • Cognos
  • Rally
  • Rational Suite (Rose
  • Requisite Pro)
  • Actimize
  • MANTAS
  • Quality Center
  • Waterfall
  • Rup
  • Agile
  • JAD
  • UAT
  • RTM
  • Oracle SQL
  • SQL Server.

PROFESSIONAL EXPERIENCE

Confidential, Raleigh, NC

Senior Business Analyst

Responsibilities:

  • Analyzed FRB published mandatory changes for CCAR 14A reports and performed impact analysis on report automation process in Axiom.
  • Worked with Finance Change and Finance Accounting team to gather the business requirements and transformed business requirements into functional and technical specifications for development and QA teams.
  • Coordinated with development team to identify risk points in existing data sourcing process and provide the solution to remediate the risk.
  • Created and maintained mapping documents for FRY14A Jump off point data sourcing.
  • Performed data analysis across multiple reports in Axiom to solve user queries.
  • Created test cases and performed functional testing to ensure the requirements were implemented as specified in the documents
  • Collaborated with BASEL reporting team on gathering and documenting the functional requirements for the centralized mapping branch and updated the mapping table based on the new sourcing logic for Balance sheet and RWA items.
  • Worked closely with business users and IT development team throughout the various phases of the project and obtained timely sign-off by all respective parties.
  • Demonstrated a strong knowledge of financial instruments with regulatory experience and reporting/analytical skills
  • Supervised and managed projects from inception to implementation, ensuring that project management methodology is followed throughout the project lifecycle
  • Performed standard Management tasks including Performance Reviews, work assignment, and counseling.
  • Led/participated in meetings at the operational and project level, provide continuous feedback on project status; offering constructive options to ensure project tracks to original expectations.
  • Identified resources and/or scheduling conflicts; change in project scope; function as an escalation point to keep all parties aware of overall project impact, facilitating management decisions at the earliest possible time.

Confidential, Charlotte NC

Senior Business Analyst

Responsibilities:

  • Worked with BASEL compliance team to capture the existing process of Standardized Approach and BASEL II Advanced Approach of calculating RWAs and conducted analysis on major differences between two approaches
  • Defined the scope of each risk class and assessed the applicability of each approach for different asset classes
  • Supervised and managed projects from inception to implementation, ensuring that project management methodology is followed throughout the project lifecycle
  • Participated in the development of project documents including: design specifications, use cases, project plans, status reports, etc. using established methodology deliverables.
  • Worked with risk management team on the development of various VaR metrics to calculate the capital requirement for market risk segment, such as General VaR, Specific Risk VaR, Stressed VaR, Incremental Risk Charge, etc.
  • Designed the work flow of the risk modeling process, including model developing, model validating, model risk assessing, back-testing
  • Cooperated with CCAR team on delivering the calculation methodology of market risk RWAs and credit risk RWAs to serve the RWA projections in scenario analysis
  • Performed standard Management tasks including Performance Reviews, work assignment, and counseling.
  • Led/participated in meetings at the operational and project level, provide continuous feedback on project status; offering constructive options to ensure project tracks to original expectations.
  • Identified resources and/or scheduling conflicts; change in project scope; function as an escalation point to keep all parties aware of overall project impact, facilitating management decisions at the earliest possible time.
  • Assisted with the development of metric measurement and reporting to identify Change Management trends along with recommending plans to remedy trending issues.
  • Developed overall aggregate planning to support aggressive growth targets.

Confidential, New York, NY

Senior Business Analyst

Responsibilities:

  • Worked closely with PMO team to present, justify and negotiate the estimate with business stakeholders.
  • Worked on reporting application and interacted with various business teams for requirement gathering & analysis and conducted JAD sessions to quickly gather business & functional requirements.
  • Maintained SDLC standards by documenting Project Request Document, Project Planning Document, BRD, User stories, and Planning Phase End Metrics.
  • Performed research and analysis across multiple asset classes to identify attributes that should be incorporated in the portfolio reports
  • Created mock up screens for various modules including Portfolio/NAV Accounting Checklists, Portfolio Summary, Heatmap Reports and various portfolio reports of Fixed Income funds.
  • Identified data elements required for the AML surveillance system and created data mapping documents
  • Wrote functional scenario scripts for different business units to implement the Currency Transaction Reporting (CTR) and Suspicious Activity Monitoring(SAM) of Actimize
  • Analyzed effectively Transaction pattern covering different category of customers and periods to detect potential structuring and smurfing activities.
  • Used Rally to maintain and update status of each change request, enhancement, production issue and bugs for test results.
  • Maintaining all the project documents and updating them regularly with the new updates and enhancements in the application.
  • Involved in Scrum Sprint Planning Sessions, Backlog Grooming, Sizing, Sprint Retrospectives & Reviews, Daily Stand ups, User Stories and Acceptance Criteria.
  • Created and prioritized the Back Log in Rally, coordinated Planning Sessions and maintained User Stories and Acceptance Criteria.

Confidential, New York, NY

Senior Business Analyst

Responsibilities:

  • Conducted JAD (Joint Application Development) sessions and Gather Business Requirements, analyze and prioritize requirements by using Rational Requisite Pro.
  • Developed scope document, financial projections, budgeting and analysis for the project using IBM Cognos 10.
  • Analyzed the existing customer data and understood the necessary information that needs to be captured for each existing customer and prepared missing values, anomalies for the completion of the CDD
  • Prepared a Gap analysis of the existing system and identified the technical needs of the organization to implement the program.
  • Propose solutions or alterations to remove inefficiencies and close gaps in existing process via process redesigning.
  • Develop UML diagrams like Use Cases Diagram, Activity Diagram, Sequence Diagram, Class Diagram and Coloration Diagram using MS VISIO 2010.
  • Prepared Business Process Models that includes modeling of all the activities of business from conceptual to procedural level.
  • Interpreted Mantas process flow to the technology team to improve the process efficiency
  • Wrote SQL queries in Oracle SQL Developer and assisted in mapping Data through different sources to process the data into the staging system as per MANTAS format
  • Prepared the list of scenarios and initialed the Threshold determination using historical data
  • Worked with SAS team on Threshold Analysis and Threshold Optimization for AML key scenarios across various business lines of the firm
  • Defined and created the Test strategies and associated scripts for the verification and validation of all defined business requirements and associated functionality.
  • Reviewed and analyzed the Use cases and came up with System design and Test plan Templates and developed test plans, test cases and test strategy.
  • Designed the test plans and test scripts based on the user requirement specification and conducted UAT- Integration testing, Unit testing.
  • Provided training and assistance to business users.

Confidential, Boston, MA

Senior Business Analyst

Responsibilities:

  • Worked with Investment SME’s (subject matter experts), Financial Analysts as well as other business teams on requirements gathering.
  • Captured existing workflows of Firm Funding, Cashiering, and Retail Cash Management, Banking Services, Funds Transfer, Retirement Distributions and Margin divisions.
  • Performed gap analysis on the complete current state and converted all the workflows to Future State Business Designs in the projected Environment.
  • Prepared Roadmap Design of the project for Cash flow Movement and Margin divisions.
  • Wrote the Business Requirements Documents of all the Business Processes.
  • Worked extensively on Equity Derivatives and Cash Equities on trading desk.
  • Implemented Straight through processing functionality for new OTC Derivatives - Prime Brokerage business unit.
  • Created use case, UML diagrams and User Interface (UI) Prototypes for various report documents and statements to detail the completion of the clearance transaction.
  • Assessed Credit Risk strategies with various internal credit tools and implemented those strategies to augment Credit availability.
  • Involved in Scrum Sprint Planning Sessions, Backlog Grooming, Sizing, Sprint Retrospectives & Reviews, Daily Stand ups, User Stories and Acceptance Criteria.
  • Created and prioritized the Back Log in Rally, coordinated Planning Sessions and maintained User Stories and Acceptance Criteria
  • Mapped financial data, general ledger data, loss event data, transaction data and people reference data from source to target database for creating a central Risk Data Repository.
  • Performed data validation and data analysis to test mapping and development changes.
  • Assisted in creating and executing Test Cases/ test scripts and documented all issues identified during the testing phase and ensured that all incidents were discovered, tracked/ resolved and prepared the UA test cases for end-user testing.
  • Reported weekly status updates to project management and stakeholders.

Confidential, Chicago, IL

Business Analyst

Responsibilities:

  • Incorporated financial data from Bloomberg, Yahoo Finance, Morningstar, and several other providers as data sources of this project.
  • Conducted both online and offline surveys with prospective users to gather requirements.
  • Facilitated JAD sessions and communicated with stakeholders and developers for requirement gathering and deliverables producing.
  • Employed Rational Requisite Pro to manage all the high level requirements and translate business requirements into functional requirements.
  • Coordinated daily meeting with the IT Department to ensure current development met the standard and timeline.
  • Communicated functional requirements with developers and QA in the alpha testing process at the end of each sprint.
  • Developed test cases and wrote test plans to help developers locate and fix the defects.
  • Involved in the reviewing and analyzing processes of financial reports (balance sheet, income statement, and cash flow statement) from target companies.
  • Participated in the sprint review session to help client understand our goal and collect feedback.
  • Customized reporting tools like SSRS to generate different report layouts to satisfy clients’ needs.
  • Facilitated user acceptance testing (UAT) with clients and demonstrated features to track price and market capital changes, as well as to report ROI, EPS, P/E Ratio, ROE, and CAGR for selected companies in NYSE and funds managed by Oppenheimer Funds.
  • Managed sign-off for deliverables (functional and non-functional specifications, change requests, user acceptance testing, and production deployment).
  • Utilized SQL queries to access data stored in the database for analysis.
  • Incorporated Excel, PowerPoint, Keynote, and HTML5 Animation technologies to present current development status and results to clients.

We'd love your feedback!