We provide IT Staff Augmentation Services!

Senior Business Analyst Resume

RaleigH

PROFESSIONAL SUMMARY:

  • Senior Business Analyst, CFA level 1 with over 12 years of experience working on large scale and complex IT projects with diverse business and technology needs
  • Core Capital Market professional with in - depth understanding of market instruments, market risk management practices, Trade System management and regulatory and Compliance aspects covering the industry.
  • Led business analysis effort by delivering large scale capital market initiatives.
  • Analyzed complex business problems and provided options and recommendations to senior level stakeholders
  • Expert knowledge of business analysis tools, techniques and practices from the Business Analysis Body of Knowledge book (BABOK) and working towards IIBA certification
  • Expert knowledge of Business Analysis integration points with PMI-Project Management processes and knowledge areas
  • Extensive Data Analysis and data presentation skill with knowledge of data lineage and data life cycle.
  • Strong application knowledge of data manipulation tools such a Advanced Excel, Access, SQL and Toad.
  • Strong Business Analysis Skills including in depth knowledge of Software Development Life Cycle (SDLC), having thorough understanding of various phases like Requirements, Analysis/Design, Development, Testing and Deployment.
  • Hands on experience handling Business Process Re-Engineering as well as Business Process Improvement initiatives using SDLC, Waterfall, AGILE and RUP methodologies.
  • Proficient in articulating business requirements and further decomposing them into functional specifications using use cases or other medium for software design.
  • Proficient in creating Business Requirement Documents (BRD), Software Requirement Specifications Document (FSD) and UML Diagrams using various tools including MS Visio, and Rational Rose.
  • Adept in Data Analysis, Data Modeling and Data Mapping.
  • Proficient in developing Test Cases, and coordinating User Acceptance Testing to gain business approval.
  • Elicited, analyzed and documented business and functional requirements for technology solutions
  • Improved operational efficiencies by identifying gaps in existing business processes or systems and created detailed business requirements
  • Strong ability to create current and future state process and use case models
  • Communication skills - able to effectively communicate (oral and written) with all types of stakeholders and all levels of management.
  • Analytic skills - able to analyze complex business problems and make recommendations or provide options
  • Consulting skills - able to plan all BA deliverables, manage relationships with all stakeholders and coach junior BAs
  • Strong ability to liaison between business area experts and the development team including 3rd party vendors and offshore resources
  • Strong ability to manage stakeholder expectations and setting the right expectations

TECHNICAL SKILLS:

MS Office Tools: Word, Excel, PowerPoint, Visio, Access, SQL, HPQC, Jira

PROFESSIONAL EXPERIENCE:

Confidential, Raleigh

Senior Business Analyst

Responsibilities:

  • Reviewing the data collection templates and clarifying requirements from the Implementation team/Model owners
  • Developing a data dictionary to create the data assets
  • Conducting walkthroughs with the users/implementation team to obtain sign off
  • Presenting requirements document to DEV team to ensure they clearly understand the requirements
  • Performing quality check on the on-boarded assets for QA sign off
  • Bulk uploading the portfolio data in ProPL (Oracle DB) on behalf of the model owners
  • Set up data sources and created workbooks for the model owners in Tableau

Confidential, Florida

Senior Business Analyst

Responsibilities:

  • Performing stakeholder analysis to identify key stakeholders for the initiative
  • Collecting the initial list of Regulatory Confidential from various FRO centers
  • Conducting walkthroughs with the Confidential owners to validate the list and to define the scope for the project
  • Establishing a master Regulatory Confidential Inventory for various regulatory forms such as (FR2314, FR Y-11, TIC forms, Country Exposure reporting, BASEL, FAS107, Confidential - FR Y-14Q & 14A, FR Y-9C, FR2402, FR2900, FR2915 etc..) and updating the master file on a bi-weekly basis
  • Classification and Categorization of Confidential based on existing capabilities/functions offered by Confidential
  • Analyzing Confidential by reviewing the gold copies obtained from users
  • Conducted workshops to capture high level requirements to put together a high level BRD
  • Conducted walkthroughs to verify and validate requirements to obtain user sign off
  • Decomposed high level requirements to develop a detail Functional Requirements document ( Confidential )
  • Performed detail fit gap analysis to identify gaps and to document the required platform enhancements
  • Participated in solution design and development workshops to provide recommendations
  • Created Minor development document ( Confidential ) for the developers to kick off the construction efforts
  • Performed Unit testing to ensure requirements are appropriately allocated to solution components and returning the expected output
  • Providing clarifications on requirements to the testing team and expected Pass/Fail outcomes
  • Providing product support on issues pertaining to daily filings such as FR2420 report

Confidential

Senior Business Analyst

Responsibilities:

  • Leading the recurring workshops with the stakeholders to clearly understand the data needs
  • Developing the end to end current data flow model to capture current data sources and to highlight manual uploads
  • Analyzing the data sets using the Oracle SQL developer 4.1
  • Setting up form meta data and writing data aggregation rules to subscribe the required Confidential from the strategic centralized data repository
  • Participating in identification and resolving the data gaps
  • Working with rules management team to create data demand request to acquire the required data sets through strategic systems
  • Created Functional requirements document and obtained sign off from the users
  • Writing form specification rules on required Confidential to generate the reportable balance
  • Writing and implementing the Fed provided edit check rules (Quality, Validity, cross form checks etc.) as well as internal edit check rules (variance analysis, Cross report checks, Cross cell validations etc.)
  • Reconciling the numbers produced by Reporting platform with the regulatory submissions
  • Obtaining approval for discontinuing the manual production of Confidential report and to start using the strategic platform for analytics and regulatory filings
  • Worked with Dev team, DBAs, testers, ETL and MSTR reporting teams to ensure requirements are clearly understood and implemented
  • Performed unit testing and provided walkthroughs to testers to perform end to end SIT testing covering entire reporting life cycle

Confidential, New York

Senior Business Analyst

Responsibilities:

  • Developed and documented Use Cases from the business and systems requirements
  • Defined documents and translated high level business requirements into detail system specifications.
  • Identified and analyzed business problems and defined the scope of activities required to address issues, including requirement definition, process review, impact assessment and operational streamlining where necessary
  • Worked extensively on analysis and development of FR Y-9C, FR Y- 14A and FR Y -14Q forms
  • Participated in configuration of Confidential Reporting System and other in-house reporting software /systems
  • Elicited business, system and functional requirements by conducting detailed interview with business users, stakeholders, Traders and Subject Matter Experts (SME)
  • Created business Process flows for end to end trade life cycle (Trade identification, Trade execution, Trade Settlement and Trade reporting)
  • Participated in data modeling, data analysis and requirement documentation of product types and map data from respective source systems to Target systems
  • Developed detailed level process maps to facilitate requirements gathering, gap analysis for projects and trainings
  • Supported the Project manager in planning, executing, controlling and closing phases of projects
  • Responsible for providing data inputs to various models to compute RWA, Stressed VaR, CVA as per Confidential guidelines
  • Captured and analyzed processes around data captured during the trade life cycle (Pre trade, Post trade and trade settlement)
  • Created test data in sandbox to ensure required credit levels/ratings were met for specified test clients in order to perform specific test in UAT
  • Developed User Acceptance Testing (UAT) test plans, test scenarios and test cases and manages the execution of testing plan
  • Working on trade message development (data modeling) in XML format for Confidential (CFTC), MAS & ESMA Trade reporting & Data repository
  • Responsible for providing trade & Risk data for Volcker project
  • Extensively used SQL Queries to design logical data models
  • Working on TOTUS exemption under Volcker Rule
  • Making decision on changing xml schema based on requirements Confidential requirements
  • Writing logic to determine trade reportability for all Confidential as well other G-20 regulators
  • Understanding resolving all Errors & Confidential received from different regulators
  • Defining, documenting and translating high level business requirements into detail functional specifications
  • Working & liaising with business partners, other technology solutions organizations and external vendors
  • Using the FpML specification and XML notation for data mapping
  • Understanding all components in various OTC products. Mapping data between various XML messages, related to 5 major assets classes
  • Improving data quality for options, futures, swaps, forwards and other derivatives.
  • Understanding & making sure that each & every fields are correctly mapped between Confidential XML ( Confidential source systems) & FpML (DTCC)
  • Managing issue logs as well as developing & executing test plans/scripts to ensure adherence to agreed upon requirements
  • Creating & maintaining process flow diagrams for Confidential, MAS, ESMA, MAS & ASIC using Visio
  • Providing alternatives when something didn't work & managing timeline
  • Writing/updating BRD (Business requirement Documents) & SRS (System Requirements Specification)
  • Helping QA to identify and resolve issues

Confidential

Senior Business Analyst

Responsibilities:

  • Effectively conducted workshops to facilitate gap analysis of the Retail Risk Management diverse business processes using the Rapid Approach Development (RAD) methodology.
  • Facilitated and coordinated JAD sessions with high level management officials, resulting in the identification of the major gaps.
  • Successfully performed data lineage from reporting layer to source systems for BCAR and ECAR Reporting.
  • Performed VBA development to create forms & reports. Also created Excel-Macros & v-lookup statements
  • Created a current state business process flow diagram in Visio to analyze the business process. Assessed process flow charts to support reengineering the Risk Management Reporting business process, resulting in approval to increase scope to support business alignment and excellence.
  • Interfaced with business stakeholders and senior management to capture high level business requirements to support the end state alignment to BCBS principles.
  • Collaboratively worked with IT to ensure requirements translated correctly.
  • Documented key risk metrics which included the business definitions and calculations.
  • Provided an opinion to auditors on data governance gaps across various retail and wholesale portfolios in the development of go forward data governance architecture.
  • Analyzed requirements and created data model (conceptual/logical/physical) for reporting data mart using SQL
  • Successfully performed Data Lineage to capture transformation rules across various hops for Confidential
  • Worked on reference data quality management to accurately measure and report exposures at org level
  • Performed backend testing using SQL
  • Developed Risk Data Dictionary and Glossary for effective Metadata management

Confidential

Senior Business Analyst

Responsibilities:

  • Identified and analyzed critical data elements required for BASEL II Reporting
  • Conducted workshops to gather business requirements to develop Business Requirements document
  • Created Detailed Design Specifications (DDS) and Software Requirements Specification (SRS)
  • Supported ETL team to understand the Reporting requirements
  • Worked with the ETL team to design a complex ETL workflow for loading application data to Dimensional data Mart using SAS
  • Worked on the IMM (Internal Model Method) approach to measure the capital requirements for various counterparty credit risk scenarios
  • Worked with the business stakeholders to capture requirements for model development
  • Provided data inputs for the computation of CVA (Credit Value Adjustments) and Counterparty risk ratings
  • Worked closely with the development team to design the Reporting layer
  • Performed field to field mapping from Reporting Data Mart to the Reports
  • Captured business logics to derive the risk measures for BASEL II Reporting
  • Supported QA Activities, User Acceptance Testing (UAT) and other implementation activities
  • Provided guidance to the members of the Testing team.
  • Created Test cases with the business SME to support the UAT
  • Responsible for coordinating with multiple teams to perform both unit and integration testing
  • Created Test Cases from Use Cases, requirements and executed test plans for functional testing.
  • Proficiently managed and tracked defects to their resolution using HPQC.
  • Identified and documented Change Management Process in order to support Training activities and knowledge management.
  • Developed Business readiness requirements document to address gaps in the existing processes, Technology and skills

Confidential

Senior Business Analyst

Responsibilities:

  • Identified all existing business processes and any gaps
  • Identifying and engaging the business stakeholders to document the detailed business requirements.
  • Creating and documenting the As-Is and To-Be business process models, business change plans, high-level system architecture, and solution design.
  • Gathered business requirements via workshops, interviews, and document analysis
  • Conducted walk-through of business requirement documents with all stakeholders
  • Conducted workshops to identify and document interface requirements
  • Captured business rules and control logics using process modelling
  • Decompose Business requirements into functional requirements using Use Case models on MS Visio
  • Successfully elicited, analyzed and documented User Stories to support Scrum methodology
  • Clarified and prioritized requirements by conducting brainstorming sessions with the stakeholders and SMEs.
  • Created Excel-Macros & v-lookup statements.
  • Used SQL to design data feeds in order to support the integration effort
  • Ensure Business requirements are understood and allocated to the solution by Design and Construction Team.
  • Provided guidance to the members of the Testing team.
  • Created Test Cases from Use Cases, requirements and executed test plans for functional testing.
  • Proficiently managed and tracked defects to their resolution using HPQC.
  • Identified and documented Change Management Process in order to support Training activities and knowledge management.
  • Developed Business readiness requirements document to address gaps in the existing processes, Technology and skills

Confidential, New York

Business Analyst

Responsibilities:

  • Involved in understanding and documenting the current business process using Process Modeling, Defining scope of the project along with position statement.
  • Captured “As Is” and “To Be” Business process to identify areas for improvements, opportunities or Threats
  • Proactively managed systems development, implementation and risk via use of SDLC.
  • Actively involved in integration of graphical charts and simulation into the system (Monte Carlo Analysis and Efficient Frontier)
  • Responsible for communicating with stakeholders to provide accurate reporting and information regarding the ongoing projects and initiatives.
  • Worked on the Risk Weighted Asset calculator requirements in order to support capital adequacy requirements as per the guiding principles of the Federal Reserve
  • Coordinating, Negotiating and Motivating outside vendors in support of time line and IT project deliverables
  • Did VBA development to create forms & reports. Also created Excel-Macros & v-lookup
  • Met with Risk managers, Risk Analysts and Portfolio Managers to understand the domain, gathered customer requirements through, Document Analysis, interviews (group and one-on-one) and Workshops
  • Led the creation of requirements, business use cases, functional Requirements Specifications (FRS) and technical specifications for planning system
  • Developed Technical documentation to support the efficient use of system capabilities
  • Trained Field Application support Team ( Confidential ) on various application rollouts.

Hire Now