We provide IT Staff Augmentation Services!

Sr. Business Analyst Resume

SUMMARY:

  • 8 years banking and financial services experience in regulatory reporting, liquidity risk management, user acceptance testing and systems implementation.
  • Comprehensive understanding of liquidity ratios, regulatory capital and balance sheet substantiation: US/EU LCR, NSFR, 5G, EPS, Basel III, Confidential /CCAR stress - testing, GAAP and IFRS.
  • Successfully delivered projects in IBM MDM (Master Data Management), ERP (PeopleSoft, SAP, MS Dynamics, Great Plains) and Data Warehousing using strong Techno-Functional, analytical and problem solving skills
  • Expert in business process modelling and software development cycle (SDLC), including requirements analysis, system design, development, testing and implementation of software applications
  • Experienced in all phases of application development and integration including requirements analysis, functional specification, data analysis, data mapping, test planning, implementation and release to production
  • Deep understanding of enterprise data warehouses
  • Advanced Excel and SQL skills in data analytics, quantitative/statistical modeling and risk metrics ("RWA") calculations.
  • Understanding of Blueprint tool, SharePoint, Salesforce, HP ALM, Microsoft Office, User Stories and JIRA.
  • Solid understanding of Equity, Cash management, Capital market, SWIFT, STP and Credit risk, Derivative Securities fundamentals
  • Good understanding of Data Mining, Data Warehousing, Data Visualization, Accounting, Business Process Modeling, Data flow diagram, Flowcharts, Gap analysis, cause and effect analysis, BRD and FRD, FSD and SDLC.
  • Experience in Data warehousing, Data Extraction, Transformation and loading (ETL) data from various sources like Oracle, SQL Server,Microsoft Access, Microsoft Excel and Flat files into Data Warehouse and Data Marts using Informatica Power Center.

EXPERIENCE:

Confidential

Sr. Business Analyst

Responsibilities:

  • Support the US Regulatory Reporting Initiative to implement strategic CCAR 14 series and Confidential Stress testing, for Quarterly, Bi-annual and Annual filing cycles, to comply with Federal and other Regulatory boards
  • Review and evaluate daily operational risk in trade settlements, transaction placements, account reconciliations, and income accruals
  • Created Functional Specification Documents via Blueprint, and DSDs on Microsoft Excel.
  • Create and translate business process specifications into design specs and XML business rules
  • Create Process Work Flows, Functional Specifications, and responsible for preparing Software Requirement Specifications (SRS), and Functional Specification Document (FSD)
  • Analyze QA data using SQL and created data visualization of KPI using MS Excel and Tableau
  • Create the data mapping from the transactional data to the Actimize tool
  • Ensure processes, controls and accounting records are in accordance with US GAAP and IFRS
  • Analyze credit data and financial information of clients that are applying for credit, Customer Service to the clients
  • Design framework for collection of Projections Data for FR-Y 14A schedules based on the Reporting Line, Line of Business projections
  • Strong product knowledge (Equity, Fixed Income and Derivatives). As well as detailed working knowledge of securities transactions flows from trading systems to back office to general ledger and reporting application.
  • Developed and managed monthly reports; Profit and Loss Accounts consolidation, Balance sheet management (using US GAAP and IFRS). Designed and participated in new product approval process. Manage and coordinate the drafting of accounting policy and procedures.
  • Experience in Migrating data from Excel to Salesforce
  • Worked on various salesforce.com standard objects like Accounts, Contacts, Cases, Leads, Campaigns, Reports and Dashboards.
  • Understand business requirements and implement technical solution within Confidential in an efficient way. Test Confidential configurations and fix defects as appropriate
  • Did Data quality and data validation using Confidential .
  • Calculation of Market Risk Capital & RWA numbers for the Bank and it's legal entities using VaR and Expected Shortfall to be used in Financial Statements and for Regulatory submissions.

Confidential

Business Analyst

Responsibilities:

  • Designed framework for collection of Projections Data for FR-Y 14A schedules based on the Reporting Line, Line of Business projection.
  • Created a comprehensive Actuals & Projections Metrics capturing all the attributes necessary to facilitate 14A Projections including Line of Business projection.
  • Held knowledge sessions with Business user to define the scope of the bank's Product portfolio for Regulatory Reporting.
  • Responsible for defining & documenting requirements for sourcing data for 14A schedules Balance Sheet, PPNR, RWA etc.
  • Implementation & execution plan for Reconciliation across Regulatory reporting example FR-Y 9C, 14Q, and 14A within Axiom.
  • Provide periodic updates to Management and stakeholder on the progress made for the CCAR Project.
  • Collaborate with different IT functions to set up a sustainable BAU process for CCAR program that address all business needs.
  • From CCAR Dashboards by mapping MDRM keys validated each of the line items in FRY 14A Summary report (Standardized and Advanced).

Confidential

Business Analyst

Responsibilities:

  • Worked on reviewing and modification of the BRD for the enhancement of OTC derivatives, product control and private banking based on Basel III norms and Reg W Affiliates.
  • Gathered business requirements, performed Gap Analysis for client’s requirements and generated system workflows.
  • As part of agile methodology participated in different sprint planning sessions, scrum meeting, retrospective meeting and release planning sessions.
  • Aided in the design and development of the logical and physical data models, business rules and data mapping for the Enterprise Data Warehouse system.
  • Troubleshoot CCAR issues pertaining to releasing documents, managing budgets, new and existingCCAR accounts, CCAR records and allocation.
  • Configuration of FTP and Profitability rules in Confidential .
  • Closely coordinated with the PMO team to create milestones and timelines for deliverables on a weekly basis and detect and report Risks and Issues.
  • Manage Sharepoint site and document (functional & technical) source to target mappings, process flows, procedures and business requirements.
  • Closely involved in planning and execution of all the testing phases including UAT (onsite), proactively performed thorough reviews of System/UAT test-cases and data-sets.
  • Preparation of various Documents like Crystal Reports, Software Requirement Specifications, Requirements Traceability Matrix etc.

Confidential

Business Analyst

Responsibilities:

  • Gained extensive knowledge on Union Bank’s Different source systems used for capturing and processing cash flow on Mortgage data.
  • Analyzed and created Business Requirements and Functional Requirements for 14Q/A Actuals for various schedules
  • Ensured data integrity and accuracy with other regulatory submissions (FRY 9C, FRY 14A, FRY 14M, GL system)
  • Design framework for collection of Projections Data for FR-Y 14A schedules based on the Reporting Line, Line of Business projections
  • Designed detailed FRD, and Solution Options Document according to BRD and Basel regulatory requirements using Power Designer
  • Perform Data Mapping and Data Profiling to map various source systems to the new Target source system.
  • Document and maintain requirement traceability matrix to ensure all requirements are traceable from top to bottom.
  • Utilize Quality centre to record, track, update or close any defects related to business requirements or data quality.
  • Assist Test team in drafting test strategies and test plans to verify accurately any functionality issues and successful system integration.
  • Create Technical specification documents based on the functional design document for the ETL coding to build the data mart.
  • Assist in Data Extraction, Transformation & Loading (ETL) Process from source to target systems using Informatica Power Centre.
  • Work on daily basis with Lead Data Warehouse Developers to evaluate impact on current implementation, redesign of all ETL logic
  • Responsible for making the report available for scheduling or viewing on demand.
  • Record project changes on a weekly basis to update plan and provide up to date information for project status reporting.

Confidential

Systems Analyst

Responsibilities:

  • Used Requisite Pro for the Requirement Documents Preparation and Prepared Business Process Models that includes modeling of all the activities of the business from the conceptual to procedural level. Followed top down, levelled technique for building Business Process Models.
  • Utilized corporation developed Agile SDLC methodology. Used Scrum Work Pro and Microsoft Office software to perform required job functions.
  • Supported to Controller at cost control process improvement. Elaborated special cost benefit analyses as request to identify on cost cutting opportunities. Prepared integration data for cost reports and cost
  • Experience with requirements management, test management and defect management tools like Rally, QC.
  • Gathered and validated requirements, resulting in detailed business rules, functional requirements and process design
  • Facilitated User Acceptance Testing (UAT) in co-ordination with the business users to identify business requirements recorded the requirements in a format that can be reviewed and understood by both business people and technical people
  • Participated during all the phases of UAT testing i.e. Pre-UAT, During UAT and Post-UAT
  • Conducts closure of project after the implementation of project as per customer expectations.

Hire Now