Business Analyst Senior

KAMIA ARORA

+1-862-***-**** Pompton Lakes NJ

************@*****.*** https://www.linkedin.com/in/kamia-arora-0b123035b

Senior Business Analyst 14 Years of Experience in Capital Markets & Financial Domain

Driven by the excitement of tackling challenges and turning ideas into impactful solutions. I thrive on building strong relationships, fostering collaboration, and ensuring every effort leads to meaningful outcomes. With years of experience navigating diverse projects and teams, I find fulfillment in creating value, inspiring innovation, and contributing to growth at every opportunity.

CORE COMPETENCIES:

Business Analysis, Full Project Life Cycle, Agile Framework, Brokerage, Investment Banking and financial services.

●Business Analyst with extensive experience in Trading, Compliance and Wealth Management.

●Extensive experience in various Software Development Life Cycle (SDLC) Methodologies including Agile and Waterfall.

●Experience in requirement gathering, process mapping, product development and implementation planning.

●Expert in preparing Business Requirement Document (BRD), Functional Requirement document (FRD), Use Case and User Stories.

●Sound knowledge on various asset types like Equity, Bonds, Mutual Funds, ETFs, ABS/MBS securities, Hedge Funds, Options, Swaps.

●Extensive experience of executing complex SQL queries for the Data Analysis and Data Mapping Validations.

●Excellent listing, communication and coordination skills to work with both On-Shore and Off-Shore teams.

●Proficient of creating Wireframe and process flow diagrams to document TO BE system.

●Experience of conducting GAP analysis to identify any deficiency in the existing system and come up with the solution.

●Experience working with the production support team after release go-live.

TECHNICAL SKILLS:

Software Models, Methodologies : Waterfall, Agile (Scrum, Kanban)

Operation Research Techniques : GAP Analysis, SWOT Analysis, Risk Analysis

Business & Project Modeling Tools : MS Visio, MS Project, Draw.io and UML

Requirement Management Tools : JIRA

Scrum and QA Utilities : JIRA, Azure DevOps

Databases : MS SQL Server, Oracle

EDUCATIONAL BACKGROUND

Master of Business Administration -Finance & Marketing (MD University, India)

Bachelor of Science -Maths Honors (Delhi University, India)

WORK EXPERIENCE

Title: Senior Business Analyst Jan 2024 to current

Client: Wells Fargo, Fairfield, NJ

The project involved enhancement of a Compliance platform that provides an ability to do account supervision and trade surveillance for managing their business. The application takes in data feeds from a variety of clearing firms and presents the trade data in an easy-to-use user interface. Using a compliance application, a user can be alerted for potential trading issues and examine transactions in specific detail. The application provides an array of standard tests that help organizations to comply with regulatory requirements.

Job Duties:

●Studied business needs, identified project stakeholders and their roles, recognized major

deliverables and collected business requirements for the project.

●Captured the AML trade surveillance compliance requirements by interacting with

compliance departments and SMEs in the laws/act of compliances.

●Analyzed, defined, and interpreted business needs and issues by gathering, analyzing,

documenting BRD, FRD and validating system requirements.

●Extensive work on financial instruments such as Bonds, Equities, Futures, Options, OTC/ET

Derivatives, SWAP, Securities, Trades, Positions, Capital Markets and CFTC regulations to

determine pertinence and consequence on functionality of the implemented system.

●Worked closely with stakeholders, including traders, risk managers, operations teams, and

IT professionals, to understand business needs and gather requirements for collateral

management processes and systems.

●Drafted project charter, which included project goals, business case, opportunity statement,

and high-level timeline and team assignments for the projects.

●Performed Data Analysis and Data validation by writing SQL queries.

●Identified Trade Data, Order Data, Position Data, Transaction Data, Reference data,

Security Master Data, and Market Data needed for various Trading, Cash & Asset

Reconciliations, Regulatory, Accounting, Performance Reporting, and Risk systems.

●Supported the various business deliverables for a given release of the regulatory reporting

such as CCAR, RWA, EAD, Basel.

●Organized the project into phases to impose management control using stage-gate reviews

such as high-level user stories, test scenarios, Dimension modeling, Data Mapping, ETL etc.

●Managed changes to project scope using a change management procedure in coordination

with the Change Control Board (CCB).

●Provided technical and procedural support for User Acceptance Testing. Tracked testing

issues, maintained test matrix, ran daily status meetings, and met the exit criteria for UAT.

Tools & Technologies: Agile Scrum, World-Check, LexisNexis, Rally, Jira, Informatica, Rational Suite, MS Visio, UML.

Title: Business Analyst Oct 2022 to Dec 2023

Client: PIMCO New York, NY

Worked on the strategic Aladdin OMS Implementation Project which included its integration with various Front Office, Middle Office and Back Office workflows for various asset classes including Equities, Fixed Income, Options, Futures, SWAPs etc.

Job Duties:

●Conducted data analysis and data validation to identify gaps between existing data feeds to/from Charles River Order Management System and new data feeds that need to be implemented as part of the Aladdin OMS Implementation Project.

●Documented functional requirement, business requirement, technical requirements and user stories by interacting with business stakeholders, subject matter experts and technical stakeholders in front office, middle office and back office.

●Worked as a proxy for the product owner for data mapping documents for data points between legacy and new vendor Order Management Systems, Execution Management System, Position and Holding System, Security Master, Performance Reporting System and Risk Reporting System.

●Identified Trade Data, Order Data, Position Data, Transaction Data, Reference data, Security Master Data, and Market Data needed for various Trading, Asset Reconciliations, Regulatory, Accounting, Performance Reporting, and Risk systems.

●Lead walkthrough sessions of requirements with developers, solutions architects, Quality Assurance, program managers, project managers and business stakeholders

●Re- engineered existing Store Procedures for Trader System and created specifications for generating legacy exports from Aladdin Order Management System.

●Wrote test cases, test scripts and test plans to accomplish the QA process; prepare test data for UAT; use Agile Methodology and JIRA through all phases of the project.

Tools & Technologies: Agile Scrum, MS Visio, MS Word, MS Excel, JIRA, SharePoint,Confluence, Oracle, SQL Server, SQL, Tableau, Mainframe, Quality Center.

Title: Business Analyst Feb 2021 to Sep 2022

Client: Wellington Management, Radnor, PA

The project was to enhance a global trading platform which supports buy and sell of various asset classes including Equities, Fixed Income, options, mutual funds, and an ETF. This platform offers users quick trading capabilities, view account balance and positions, pricing history, current news, real time streaming quotes, portfolio, premium research, customizable dashboard, charting tools, news feeds and access to all the broker’s tools.

Job Duties:

●Worked closely with Product Owner and Stakeholders in an Agile SCRUM environment to improve, prioritize, and support the development, testing and release of functionality.

●Interacted with Order Management teams to capture requirements responsible for Project Management and Trading modules.

●Documented history of creating and bringing new financial products to market and monitored

all investment instruments in the domestic and global securities market.

●Evaluated data gathered from multiple sources, reconciled differences, and ensured consistent approaches, data interpretation, and results measurements were employed.

●Identified the Data Source and defined them to build the Data Source Views for easy access.

●Conducted Gap Analysis to compare ‘as-is’ with the ’to-be’ business processes, perform analysis and offer solution recommendations.

●Analyzed bugs, defects using JIRA, interacted with team members in fixing errors.

●Facilitated SIT and CIT by providing test data and test cases and Performed User Acceptance Testing (UAT) with clients.

●Wrote and documented user stories about price-change-policies such as cutting off Commission on equities and ETF trades.

●Assisted top management with structuring low-cost for options-contract and other derivatives trading commissions.

●Partnered with QA Manager and Developer Lead to tackle software defects in a timely manner and keep the documentation up to date.

Tools & Technologies : Agile(Scrum), MS Visio, MS Office Suite, SQL Server, UML, Jira, Confluence, MS office, Tableau, Informatica.

Title: Business Analyst Jan 2020 to Jan 2021

Client: Fulton Financial, New York, NY

The project was based on customizing the web portal for Financial Advisors in a Wealth Management Platform that integrates resources and aggregates data on a mark-to-market basis, allowing Financial Advisors to conduct investment actions quickly and efficiently. This project involved Data analysis, Data cleansing and Data migration to reporting systems.

Job Duties:

●Worked extensively with Financial Advisors to acknowledge the business requirements by prototyping and meetings.

●Identified the Data Source and defined them to build the Data Source Views for easy access.

●Used MS Excel and SQL Server to implement data mapping, data validation, data reconciliation and data enrichment.

●Assisted Financial Advisors to conduct comprehensive reviews including asset allocation, risk management, preservation of wealth, accumulation and wealth transfer strategies.

●Worked closely with the development team to verify that business needs are fulfilled, and deliverables are produced within specified budget, quality and time.

●Documented history of creating and bringing new financial products to market and monitored all investment instruments in the domestic and global securities market.

●Maintained RTM (Requirements Traceability Matrix) for the current business process and proposed changes.

●Developed and implemented test plans and test reports, which included writing and running test cases ensuring all the functionalities are properly tested.

●Interacted with senior business analysts to conduct training sessions to make the users comfortable with the functionality.

Tools & Technologies : SQL Server, Jira, HP Application Lifecycle Management (ALM), MS

Access, MS Excel, MS Visio, Agile(Scrum)

Title: Business Analyst Aug 2019 to Dec 2019

Client : CIT Bank, Livingston, NJ

Description:

This Project was to create a new application that can facilitate business users such as Portfolio Managers, Financial Analysis, Fixed Income and Equity Traders to quickly obtain centralized information from the platform in order to monitor performance, or make quick actions such as buy/sell/short/hold decisions to bank’s customers. The platform is focused on capital market solutions.

Job Duties:

●Analyzed data and data flows, and documentation of data variances among systems as relates to various financial products.

●Translate key material into visually appealing and user-friendly dashboards.

●Helped shooting defects by checking RTM and data mapping documents and performed data profiling as well as GAP analysis.

●Coordinate User Acceptance Testing with business user community and QA teams

●Facilitated and drove project meetings with both business and technology teams.

●Engaged in OTC derivatives and other financial products such as Equities, Fixed Income, Options, SWAPS etc.

●Analyzed derivatives holding data using advanced Excel functions and queries in SQL.

●Listed out all the key trade attributes like trade date, risk %, maturity date, security type, currency type which are required to execute the trade for the financial products for fixed income securities.

●Performed feature GAP analysis by defining the basic functional requirements of the system to support the users.

●Identified "As is" process and "To be" process as parts of gap analysis for new functionality.

●Used SQL queries for data analysis.

●Coordinated demos with business users as well as securing UAT signoff backed by post-production support.

Tools & Technologies : MS Office, SQL 2008, Agile(Scrum), Jira, MS Visio

Title: Associate Business Analyst Nov 2015 to May 2019

Project: Xoriant Solutions Pvt. Ltd., India (SSBT)

Job Duties:

●Gather, analyze, and document business requirements related to capital markets operations.

●Develop and maintain data analysis frameworks to support regulatory compliance and risk assessment.

●Perform gap analysis and recommend process improvements to enhance operational efficiency. Ensure quality and compliance with AML (Anti-Money Laundering), FSA (Financial Services Authority), and other regulatory standards. Analyze counterparty risk profiles by evaluating financial statements and corporate actions. Validate credit ratings of issuers and securities using external sources such as Moody’s, Fitch, and S&P.

●Work closely with trading, risk, compliance, and technology teams to align business needs with technology solutions.

●Assist in developing data governance policies and documentation standards for better transparency.

●Collaborate with the Data Warehousing Team to allocate work and coordinate real-time data uploads.

●Support the onboarding and mentoring of new team members to maintain high-quality deliverables.

●Utilize data visualization and business intelligence tools (e.g., Power BI, Tableau, SQL) for reporting and insights.

●Work with IT teams to enhance data integration, automation, and reporting capabilities.

●Ensure accuracy and completeness of market data used for decision-making.

Tools & Technologies : SQL Server, MS Excel, Power BI and Tableau

Title: Benefits Analyst Dec 2010 to Jun 2014

Client: AON Hewitt, India

Job Duties:

●Conducts research and analysis of employee health insurance benefits provided by clients.

●Serves as the Work Package Owner for the Control Account.

●Collaborates with tech teams and clients to streamline benefit flows and resolve system defects.

●Drives continuous process improvement by implementing innovative ideas to optimize existing workflows.

●Provides training and onboarding for new hires.

●Reviews and updates Standard Operating Procedures (SOPs).

●Addresses client issues and concerns promptly.Ensures adherence to SLA requirements (interaction reliability, schedule adherence).

●Manages service delivery to clients/participants in alignment with client-defined parameters.

●Guarantees quality delivery and business continuity.

●Maintains regular communication with clients to address concerns

●and improve service levels.

●Accountable for meeting all business metrics, goals, and internal/external SLAs.

Tools & Technologies : MS Office, Oracle 10g, Jira, MS Visio

Title: Financial Analyst Jun 2007 to May 2009

Client : E-Businessware India Pvt. Ltd., India

Job Duties:

●Ensures quality and client service requirements in compliance with real time management.

●Assistance in framing & refining policies on data analysis and documentations.

●Allocation of work units to team members and coordinating with the Data Warehousing Team to upload the enriched Data into the Database.

●Classifying market counter parties as regulated or listed on exchange (AML and FSA classifications as per FATF members)

●Identifying Industrial Codes (SIC & NAICS), capturing corporate actions (Merger/ Acquisition & Name Change) and enriching hierarchy information.

●Analyzing counterparties Risk profiles by studying their Financial Statements.

●Projects : HSBC Bank PLC – London, Reuters - London

Tools & Technologies : MS Office, Oracle 10g, Jira, MS Visio

Contact this candidate