We provide IT Staff Augmentation Services!

Business Analyst Resume

New York, NY

SUMMARY:

  • 9+ years of experience in Business Analyst, Product/Project Management, Data analysis and Data Reporting
  • Extensive business analysis, project management, and quality assurance experience working in Risk and Regulatory Reporting, Financial Risk Management, Mortgage Lending, BFS, Capital Markets, and Oil and Gas
  • Knowledge of CCAR, FR Y - 14A/Q FR Y9 report, Dodd Frank (DFASTs). Understanding of asset classes including Fixed Income analysis (Pricing, Risk, Yield), interest rates, yield curve assumptions, derivatives etc.
  • Enterprise Portfolio Management, Application Development & Delivery Management, Business Process Optimization, Client Relationship & Account Management
  • Worked on ETL projects with interfaces including Autosys, AWS CLI on the Informatica Server (@ AWS, various data sources, and EDX to create reporting files in XML format
  • Extensive exposure to various SDLC methodologies such as Agile-Scrum and Waterfall enabling precision in the delivery of requisite Artefacts pertaining to Requirement Analysis
  • Responsible for leading QA/test activities and system/functional testing execution, UAT coordination, and senior IT staff activities in project planning, scheduling, analysis, and test documentation.
  • Project management activities providing MS Project scheduling, and status reporting, execution/implementation coordination utilizing PM tools including VSTS, Version One, HP ALM, JIRA, Rally, MS SharePoint
  • Extensively worked on stakeholder management including IT sponsors, business users and other managers, effectively communicated project related information to senior management and customer throughout project life cycle
  • Trained and mentored technical staff to adapt Agile Scrum methodology as SDLC.
  • Performed data extraction, wrote rules for data mapping, and analysed data using SQL queries

TECHNICAL SKILLS:

Agile: SCRUM, Scaled Agile (SAFe 3.0), Kanban, Waterfall

Project Management: Microsoft Office, MS Project, MS Visio, VSTS JIRA, HP ALM, Version One, Box, MS SharePoint

Languages: JAVA, JavaScript, Python, SQL, PL/SQL, HTML5/CSS3, XML

Databases: ETL, Informatica, SQL, MySQL, Oracle

Testing Tools: HP Quality Center (QC), HP Performance Center, HP LoadRunner, Selenium, HP UFT

Finance Tools: Bloomberg Terminal, Murex, Blackrock s Aladdin, Excel Macros

Modelling Tools: UML, MS Visio, Blueprint, Axure, Fluid UI

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Business Analyst

Roles and Responsibilities:

  • Product Owner/Business Analyst for three applications and scrum master for three different projects simultaneously.
  • Facilitating Scrum of Scrums, Sprint Planning, Daily Scrums, Backlog Grooming/Refinement/Prioritization and Sprint Retrospectives for multiple projects
  • Designed product backlog for a new product related to UK’s new regulatory body, which will be in action post Brexit. Wrote stories around UK’s regulatory taxonomies and mapping rules which will be implemented using Informatica as ETL Tool. Also worked on writing user stories for AWS Cloud Migrations
  • Regulatory Feed for FCA required data to be sourced from Billing, Commercial and Ratings Origin source to be collected in Regulatory Framework, transform the data as per the rules provided by Regulators and validate the data before converting them to XMLs. The process uses Informatica @AWS for ETL, Autosys for Scheduling Jobs and UNIX system for file validation and conversion
  • Creating a Revised Process Map for ESMA Regulatory Reporting in order to mitigate the risk of errors, saving expenses, saving time and manual efforts utilizing ETL capabilities in mapping rules and taxonomies, creating file extracts, reconciliation etc.
  • Handled Salesforce Data Encryption Project to secure personal data, created a strategy for the CRM Scrum team, helped them resolve issues related to encryption of formula fields. Attended Salesforce Accelerator to guide the CRM team
  • Tracked stories, assigned tasks, and performed capacity planning using VSTS, Version One. Co-ordinated defect tracking using HP ALM and reviewed QA Forms to ensure smooth production release
  • Utilize SQL queries to get data from different data sources in order to match the report generated from ETL and find out data quality issues
  • Report data quality issues and facilitate reconciliation sessions in order report reconciled data
  • Worked on estimations, sprint plans and team mapping to ensure critical projects are delivered without any resource crunch
  • Working with the Lean Management Team, Business Stakeholders and IT to improve the business processes involved in ESMA reporting projects. Defined KPIs to measure inefficiencies, calculated current state and estimated target state
  • Facilitated release of a GDPR regulatory change on 9 external facing applications by serving as a liaison between Legal, Compliance, Application Development and Change management teams. Performed UAT on all the 9 applications
  • Working with the business champions, IT and senior management to perform backlog grooming and to get the critical stories released, the stories will improve the quality of Reporting saving manual efforts
  • Working with the change management team to release critical regulatory reporting needs with strict deadlines

Confidential, Charlotte, NC

Business Analyst/ Agile PM

Roles and Responsibilities:

  • Actively participated through all the phases of Project requests: Estimation, Initiation, Execution/Development, Deployment, and Hand-off.
  • Worked on data reporting projects for the market risk projects.
  • Gathered requirements around collating data from multiple data sources into a framework to translate the data as per the mapping rules and convert the data in XML
  • Worked with Business Champions, SMEs and developers to create product roadmap, User Stories, and to perform backlog grooming
  • Served as liaison between technology, third party implementation team and product management teams.
  • Analysed business needs and translated them into functional and technical requirements in association with SMEs and business users. Wrote stories and UAT scripts for two end to end workflows
  • Identified dependencies between Projects to eliminate/reduce risks and potential conflicts during Program life cycle
  • Facilitated Daily Scrum, Scrum of Scrum, Sprint Planning, Backlog Grooming, Daily Scrums, Sprint Retrospective and Demonstration meetings with internal team, Business Users and PMO to monitor project progress.
  • Identified dependencies between Projects to eliminate/reduce risks and potential conflicts during Program life cycle
  • Worked on identifying data quality issues and reported to business champions in order to facilitate permanent solution
  • Assisted QA team to automate Functional and Performance test scenarios and designed a test methodology to ensure strict adherence to the user stories
  • Involved in creating detailed test plans and testing strategies and ensure these are executed extensively, which includes executing SQL queries to retrieve data and test
  • Provided support for User Acceptance Testing with UAT cases and resolved issues with the users

Confidential

Business Analyst/Project Manager

Roles and Responsibilities:

  • Facilitated meetings with Business Users, Senior Management, Infrastructure Team, Development Team, and PMO to create the process requirements, process improvements and explained to the development team the flow of future data modules.
  • Kept Project and Project Team Synchronized using PM tools including JIRA and HP ALM
  • Acted as Scrum Masters and maintained SCRUM Task Board to create transparency and track progress of Sprint
  • Executed Sprint 0 to build trust in team members and steered story mapping. Also, ensured that the team is ready to start sprinting. Coached Stake holders and project team on Scrum, its framework and advantages
  • Facilitated time-boxed SCRUM ceremonies that included Daily Stand-ups, Sprint Planning Meeting, Sprint Review Meeting, Sprint Retrospective Meeting, and Grooming Sessions with Product Owner
  • Tracked user stories in JIRA. Ensured that JIRA is updated regularly and reflects accurate information
  • Prepared functional requirement, test strategy, test plan, and process workflow documents for new projects
  • Collaborated with product managers and development team to identify and resolve issues, coordinate system requirements, and create project timelines.
  • Assisted QA team by Reviewing Test Cases and clarifying requirements to ensure complete coverage of requirements.
  • Conducted extensive GAP analysis by identifying AS-IS and TO-BE process models and process flows, where, how and how big the GAP to in turn help product owner to plan how to bridge the gap.
  • Helped product owner in prioritization of Product Backlog Items (PBIs) including the process of breaking down EPICS into user stories using INVEST criteria.
  • Worked with multiple stakeholders including business, project/QA team, to implement release cycles and change processes
  • Reviewed and transformed business and User Story requirement documentation and created wireframes using Axure for stakeholder approval.
  • Created SQL Queries for Portfolio Drill Downs to pull necessary data from data sources

Confidential

Business / Quality Analyst

Roles and Responsibilities:

  • Implemented a disaster recovery strategy in collaboration with two different implementation vendors, tasks included server migration, virtualization of physical servers, migration of application and database/storage servers.
  • Responsible for defining project scope, gathering business requirements and prepared documentation for project charter, estimations, resourcing, SOW, and stakeholder management
  • Built Automation Framework for SAP MM and FI workflows. Developed performance testing scripts to identify performance lags and deep dived into server level analysis to tune the performance
  • Understanding of SAP Material Management Workflow
  • Implemented SaaS based HP ALM, and HP QC and managed all the admin activities right from creating projects, adding users, assigning access rights, setting up defect lifecycle, and other restrictions for entire IT Landscape
  • Assigned tasks among development and QA teams, monitored and tracked progress of project following agile methodology.
  • Analysed Business Requirements and segregated them into high level and low level Use Cases, Activity Diagrams / State Chart Diagrams using Rational Rose according to UML methodology thus defining the Data Process Models.
  • Collected business requirements from business users, documented specifications and translated statement of work into business and system level requirements.
  • Organized and Facilitated weekly status meetings with internal team, bi-weekly status meeting with Outside stakeholders, and arranged touch base calls to monitor projects progress
  • Developed scenarios to validate application front end functions output against database, web services responses, validating throughout all layers of the application
  • Collaborated with the SME and development team to understand the Business logic and created test scenarios for validation.
  • Worked on re-testing and resolving issues based on Service Level Agreements and managing appropriate triages.
  • Clarified QA team issues and reviewed test plans and test scripts developed by QA team.
  • Documented test results, prepared test reports, and gathered and evaluated test metrics for reporting.
  • Wrote Test Cases and performed User Acceptance Testing, documented the defects using the Defect Tracking report.
  • Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
  • Carried out defect tracking using HP Quality Center and HP ALM

Hire Now