Mahak Agarwal

Business System Analyst

ad465q@r.postjobfree.com +1-206-***-****

Seattle-Washington (98109)

www.linkedin.com/in/mahakagarwal957a18a7

Profile:

Business Analyst with over 9 years of experience in diversified financial domains spanning Front and Middle office operations, Regulatory reporting (SFTR), FX entity Setup and Trade bookings in the capital markets domain-Investment Banking and healthcare interoperability :CMS Products & FHIR platform.

Knowledge about the functioning of Capital Markets, Banking applications and various asset classes like FX, Repo and OTC derivatives-Forwards, Spot,Swap

Strengths include excellent Business Analysis skills with expertise in Requirement gathering,mapping (as-is/to-be) and documentation (BRD/FSD,User stories) in the enterprise and startup-settings.

Provide functional and nonfunctional technical solutions leveraging enterprise solutions such as AWS,data bricks,IDP Authentication system, visualization and reporting systems.

Worked collaberately with development team to implement solutions that met client requirements.

Hands on experience in all phases of (SDLC) Software Development Life Cycle like Initialization activity, Planning, Feasibility Analysis, Gap Analysis, Functional Testing, UAT and Go-Live Support.

Project Management exposure with experience in project management/co-ordination activities-Preparing runbook, dashboard for status tracking.

Worked with full-fledged agile team and complying with Agile ceremonies like Sprint Planning, Stand Ups, Retrospectives, Backlog Refinements, Workshops, Definition of Done (DOD), and Demonstrations.

Having good experience with SQL queries, basic UNIX commands and JIRA tool.

Have experience in creating process flow diagrams to help UX teams building working prototypes.

Skill Summary:

Proficiency: Requirement Gathering, Designing User Stories, Functional Testing(UAT), Prod Go-live Support

Technical: AWS (S3, Dynamo DB), Databricks, MS Excel, Rest API.

SDLC Methodologies: Agile Model-Scrum, Waterfall model

Tools: JIRA, Jive, MS Visio, MS Excel, MS Word, MS Outlook,Confluence,MIRO,Postman

Trade Booking Systems-Summit, FX DDI,T3

ETL Tool:Benthos,Databricks

Account creation Tool-NCOB

Testing Tool-HP ALM

Databases: My SQL, Postgres.

Patient Identity Mgmt. Patform:Verato

Visualization Tool: Tableau, MS Excel

Domain: Capital Markets –Investment Banking, Regulatory Reporting, Front office, Back office, Trade Lifecycle

Healthcare Interoperability: HL7 V2/ FHIR Data Mapping, Da Vinci Forums, IG, CMS Products .

Professional Experience:

Name of Employer: Opala Health Inc. –Nov 2022-March 2024

Project: Implementation of CMS Mandate products

Description: The CMS mandate requires healthcare payers to implement a standardized patient access API and exchanging that data between payers.

Responsibilities

Developed user stories for CMS Mandate products: Payer to Payer Data Exchange, Patient Access API enhancement, ensuring seamless and positive patient experience.

Successfully executed integration with a HIE Partner to ingest daily clinical data (HL7 messages) for 400k + patients.

Successfully collaborated with IDP partners to ensure patients can securely log in to the application from any platform to access their data.

Collaborated with various payers to facilitate registration in a healthcare data portal for seamless payer-to-payer data exchange, while also registering endpoints in CAQH for expanded network reach.

Build patient centric FHIR data model and references as guideline for data engineering teams by mapping real-world entities with HL7 and FHIR elements.

Analyze DaVinci implementation guides (IGs) and represent the organization at various standards committees such as HL7 FHIR Da Vinci to raise implementation issues or concerns as needed.

Name of Employer: Capco Technologies Ltd – (Client: MORGAN STANLEY)-Aug 2017-Sep 2021

Project: SFTR (Securities Financing Transaction Regulation)

Description: The European commission wants to increase the transparency of securities financing transaction markets, which are not currently covered through other regulations. As, such this regulation will require firms to report SFT’S to an approved EU trade repository.

Responsibilities:

Worked as Agile Business Analyst with Different Stakeholders like Operations, Legal and Compliance, Trade Repositories and Regulators to gather the requirements.

Grooming of product backlog in collaboration with Product owner and prioritize them after communicating with stakeholders.

Created user stories in Jira and refined it after coordinating with dev team.

Ensure the user stories are in lined with SFTR regulatory procedure and facilitate the workshop with development team for implementation.

Writing SQL queries (JOIN, Group by )to perform data analysis and preparation.

Being part of Agile Scrum ceremonies like Sprint Planning, Stand Ups, Retrospectives, Product Refinement and Demonstrations.

Refining Jira which is as per the given standards by conducting the Product Refinement, Definition of Ready (DOR) and Definition of Done (DOD).

Followed both Kanban and 2 weeks sprint boards to plan and slice the deliverables with high quality and timeliness.

Project: FX Settlement system

Description: Set up of MS legal entities like MS Beijing etc. to enable FX trading into FX platform which involves end to end set up from booking the trade till settlement.

Responsibilities:

Setup Legal entities infrastructure for clients in FX System (front to back).

Update stakeholders on the status of projects, provide estimated timelines, highlight issues, blockers on

the weekly call.

Deal with FX products such as Spot, Forward, Swaps for trading with counterparties.

Host meetings and Coordinate with Business, Operations and Development team on entity setup

Conduct UAT testing for setup an individual applications along with Front to back testing with evidence.

Coordinate Pilot testing in production and gather stakeholders sign off for Go-Live.

Prepare Dashboard, RAG status with RAID log, Runbook for the project, Test cases, testing evidence,

Work on static data creation and setup in the system with the help of IT team and get the estimation.

Provide entity requirements to developers and work on estimation and release in QA and production.

Provide demo to Business unit on functioning of the entity and assist trader in booking the trade in FX

platform.

Also worked on migrating entities from legacy platform to FX platform to automate the process.

Take care of the OTC transaction reporting of the trades to regulators like CFTC via DTCC.

Name of Employer: Deutsche Bank Global Services(DBOI)-(Jan 2014-Aug 2017)

Project: 3D Cash, Payment Settlement System

Description: It is used to perform the settlement of cash flows for Global Market(Rate & Credit Derivatives).3D Cash receives cash flow information from CRE, performs SLA validation and STP. Assign Settlement Instructions to cash flows. Releases or suppresses payments as appropriate using different swifts.

Responsibilities:

Gathering requirements from business & technical teams. Analyse the requirements, understand the change and prepare detailed BRD and get it reviewed from senior BA.

Outline high level business scenarios and validate/review QA test cases to ensure they are aligned with the outlined business scenarios.

Performed functional testing and coordinated with QA team for the regression testing .

Writing SQL queries to do backend checks.

Provide walkthrough of the new functionality to the Business Users. Support/guide them through the UAT phase

Coordinate with IT, QA and RTB for sign- offs.

Support the project after release.

Certifications:

NCFM in OTC Markets

SQL for Data Analysis (Issued Jul 2022)

Agile Requirements Foundations (Issued Mar 2022)

EDUCATION

Uttarakhand Tech University-Bachelor of Engineering (Information Technology) -Dehradun (Uttarakhand)

Year -Jun 2009 - May 2013

Contact this candidate