SUMMARY

• 10+ years of experienceas a Business Analyst working in the Software Development Industry - specializing in Analytics, requirementmanagement,documentationandproject coordination.
• In-depth experience inproject management,financial functional SME,business administration, information technology applications, Production support and strategic planning working withFinancial,Capital Markets & Portfolio Management.
• Strong Knowledge ofSoftware Development Life Cycle( SDLC) and SDLC Methodologies like Agile Software Development, Waterfall Methodology, Data AnalystandStatistical Analysis.
• Extensive experience with Business Analysis inObject Oriented Analysisand Design usingUML andVisio
• Worked extensively on the various types of Business Requirements Elicitation, Process Modeling,Gap analysis, Impact analysis, Risk analysis,SWOT analysisand development of Functional Specifications
• Industry experience inFinancial Analysis, Capital Markets, Investments, Portfolio Management, Wealth Management, OTC Derivatives, Fixed Income Derivatives, Insurance, Brokerage, Trading Systems, Fixed Income Securities, Listed Derivatives.
• Extensive experience on Front Office Applications forFRA(Forward Rate Agreement),CDS(Credit Default Swap),IRS(Interest Rate Swap),Currency Forwards, Currency Futures, Stock Index Futures, Option Pricing,Swaps,Risk Managementof Derivatives.
• Experience inwritingBusiness Requirements Document (BRD), Functional Requirements Document (FRD), Data Analytics mapping, Analytic Flow documents.
• Providing data expertise to customers, responding toad-hoc requests, including analysis of data in source systems,data warehouseand assessment of information to support business needs.

PROFESSIONAL EXPERIENCE

Confidential, Livingston NJ

Business/Data Analyst

Responsibilities:

• Plan requirement gathering, JAD sessions, sprint planning with Business consumers in the Reg reporting team to understand the business requirement and create tech documentation to translate the requirement to the tech developers and QA.
• Create end to end data mapping/data lineage documentation in xl & visio that captures each schema.table.column of the data flow from the source system to the outbound consumer schema.
• Analyze and capture Data Analytics through use of SQL query logics in SQL Management Studio & Oracle SQL.
• Elaborate the data manipulation logics & data flow at each stage in the lineage process.
• Closely liaising with Developers & Testing team to finalize on the data manipulations & data stitching logic, data enrichment logic to be implemented to derive the target data.
• Work with all stakeholders for sprint planning & implementation in Agile Methodology to address the urgency of a Reg reporting project.
• Data validation, BA testing and UAT testing at each stage of development to make sure the requirement is accurately implemented and the data is produced as designed.
• Liaising with QA team to create Data validation & data quality scripts to test the data as per requirement.
• Liaising with all stakeholders of the project to ensure the pace of the project doesn’t suffer & accuracy isn’t compromised. To identify & emphasize the challenges as per project priorities.
• To ensure the work SLA, documentation, process & deliverables are adhered at industry best practice standards.

Confidential, Rockefeller Center, NY

Business/Data Analyst

Responsibilities:

• Analyze financial Models & work with Business side/Modelers to document Business User requirements capturing Data Elementsto be produced by Tech. team, which feed into the Models.
• Implementing projects in Agile methodology by liaising with offshore Development & QA teams.
• Conducting regular JAD sessions with all stakeholders for requirement gathering & constructing FRD, Analytic process flows, UI SRS, xl spreadsheets.
• Creating Analytic process flow in Visio describing the complete data analytic/ manipulation between source data & output data.
• Documenting End-to-End Data lineage to prepare data process flows sourcing from the DB tables/columns to produce end Data elements sourced in turn to the models.
• Documenting/Tracking Agile Sprints, Agile Board, open items in JIRA.
• Preparing Data Analytic flows & sample Data element files, UI Prototypes to finalise the project deliverable.
• Regularly run SQL scripts to understand the source data and produce xl reports for ad-hoc requests for Data.
• Constructing & running Data Quality Scripts using SQL in TOAD.
• Reporting Data Quality Reports to Modelers & Risk Management teams.
• Conducting exhaustive UAT testing and preparing testing xl spreadsheet to assist QA in testing analytics.
• In Live environment, handling Business training & Production support to assist Business side understand the software's functionality/analytics.

Confidential,Midtown, NY

Business/Data Analyst

Responsibilities:

• As a Financial SME my role was to determine the financial analytic logics which were inculcated in the Data Elements derived.
• Finalizing the requirements for the Financial Analytic calculations involved in producing Data elements as required by the downstream consumers (PWC Auditors).
• Running SQL queries in SQL Management Studio to get Data as required by Front Office or Project Managers.
• Ascertaining the accuracy of Data as received from our Security Master Data providers like Bloomberg, Reuters.
• Monitoring the daily runs of Data enrichment logics which align Security Master Data to PWC Client portfolio Data which includes products like Equity Derivatives, Fixed Income.
• Resolving the root cause of exceptions to the Data enrichment results.
• Providing Production support to PWC Auditors explaining the analytic calculations underlying the data they receive.
• Create FRD, UI specifications, UAT testing, SIT testing, Test Case review, User Requirement gathering, JAD sessions, Technical documentations to assist Developers.
• Coordinating with different Stakeholders around the globe as the project was to create a centralized Data hub for different consumers.

Confidential, Pennington, NJ

Sr. Business Analyst

Responsibilities:

• Preparing the Compliance Agreements between Upstream Data providers & Downstream Data consumers confirming the Data SLA.
• Conducting JAD sessions, Brain Storming & agreeing the requirements to finalize the Data Agreements.
• Running SQL queries for data analysis & production support in the production environment.
• Conducting GAP analysis on Data SLA fails.
• Documenting FRD to capture the Data Mapping, Functional & Non-functional specs.

Confidential, Midtown NY

Sr. Business Analyst

Responsibilities:

• Barclays Capitalis a leading global investment bank with a strong and profitable private client franchise. The Basel III compliance system was implemented in the Investment Bank LOB to calculate more accurately the capital provisions against credit and operational risk that allows greater business agility, lower programming costs, more visibility and control over how business decisions are being made.
• As an Equities Business Analyst my responsibilities were:
• Work with Front Office Business Users on Equity Futures & Options/Derivatives Analytics to ascertain Data attribute logic in order to send the accurate Data feeds for Regulatory Reporting.
• Financial Analytics specialist due to my degrees & heavy experience in Finance.
• Help Regulatory reporting teams interpret Data attributes, analytics & Data template logic in the production environment to better understand the data & help resolve their requests.
• Run SQL queries in DB by using TOAD 9.7.2 to extract data attributes on Trading Data & Reference Data from Upstream Exchanges like Confidential, Rolfe and Nolan, ISTAR, ICE & Bloomberg etc.
• Conduct Requirement Gathering,JAD sessions,impact analysis, gap analysis, prepare BRD & FSD, provide FSD walkthrough to Business, get FSD signoff & help in development & testing phase, conduct UAT testing & help post production support to Business Users.
• Help Developers throughout the Development phase in understanding the requirement, resolve coding challenges and resolve change impact.
• Help Developers understand the requirement in order to create Data Template, Data Architecture for the project, debug code & help Testing team review test scripts & conduct UAT testing.
• Set up regular meeting series to catch up on the project status & update the management on product Status Report meetings.
• Validate Trade Data attributes against Trade details in Bloomberg Terminal.
• Analyze trade extracts from Ipswitch & store Data templates in Perforce P4V.
• Work in AGILE/WATERFALL SDLC & at times a hybrid SDLC of both.
• Working with teams located globally e.g. Business Consumers of Trade data for Regulatory Reporting, working with Offshore teams across timelines.
• Create, update functional & technical documentation on SharePoint.

Confidential - Pennington, NJ

Sr. Business Analyst

Responsibilities:

• Work in a Business-System Analysis process, good understanding of BRS/SRS/Other requirement documents and Data Modeling. Writing technical documents like SRS.
• Analytic understanding of Wealth Management Process
• Understanding of Estate/Insurance and Annuity business area
• Prepare Analytic Flow Charts staring with preparing Data inputs Error & Assumptions, analytic sub-processes & output mapping to compute the analytic output.
• Requirement Gathering, Business Meetings Facilitator, Conducting Impact Analysis of the Requirements & consulting alternative solutions.
• Analyzing BRD requirements to document the specifications and conduct GAP analysis.
• Preparing Analytic Flow Charts and providing a detailed walkthrough of the analytics to the On-Shore & Off-shore Development teams. Resolving queries from Development team & testing team on understanding SRS.
• Helping the testing team validate analytic results output by preparing a parallel analytic spreadsheet using Advanced XL.
• Post - Release resolving Production QCs in order to help the Users understand the analytic details of how the output in question was derived.
• Preparing Data Mapping Flow Charts for Third Party Vendor Engines to leverage their analytics.
• Preparing UI SRS to specify the Business Requirement for the respective UI & consulting the business partners on the feasibility & the optimum look & feel of the UI. Helping resolve unfeasible UI requirements by providing alternative solutions. Involved working with MS Paint.
• Reviewing SRS across the project to ensure consistency with the set standard.
• Facilitating regular team meetings, prioritizing the agenda, keeping the meetings on track & documenting and communicating the minutes of the meeting.
• Resolving QC in the testing phase by formulating the optimum solutions to the discrepancy & making sure the Business Clients, Analyst team, Development team, testing team are in sync.
• Mapping Analytic output results to the Reports generated as per Business Specifications.
• Training team mates on financial products/solutions due to my Advanced Degrees & experience working in the financial domain for over 10 years.
• Helping the project Manager streamline & standardize business processes & documentation in times when there isn’t much project load.
• Helping the PM update Project Status Report.

Confidential, Midtown NY

Business Analyst

Responsibilities:

• Interact with the project team to define system objectives and scope, and identify constraints and the measures of success for theOTC Derivatives Risk ManagementMiddle Office system to be developed.
• Conducted user interviews and JAD sessions to get an understanding of client business process
• Understand Trade life cycle for CDS (Credit Default Swap), IRS (Interest Rate Derivatives) in order to setup the trade Clearing, Confirmation, Settlement & reconciliation process within the Middle Office & Back Office systems.
• Gathered data requirements for theCredit Risk Managementsystem by interacting with the users and data administrators.
• Gathered functional requirements from users and management(SMEs)
• Responsible for creating theCredit RiskBusiness Requirements Specification Document (BRD) and theOTC DerivativesFunctional Specifications Document (FSD)
• DesignedExchange Traded Derivatives in Futures & Options Position Management & Trade CycleBusiness Process Model to cater to End to End Trade Cycle comprising of the Front Office booking, Middle Office Trade load and Back office settlement (Activity diagrams, Sequence diagrams and Collaboration diagrams).
• Ensured application forms and reports (UI) inSQL,followed client’s development standards and guidelines in terms of usage, naming conventions etc
• Created theEnd-UserDocumentation
• Extensive experience ofSQLqueries & reporting. Help prepareData Warehouseconsolidation &Master Data Management (MDM) plan.
• Conducted workshops for internal users(processors, underwritersetc.) to provide training
• Contributed to development ofOnline Help Systemfor officers.
• Assured that all artifacts are in compliance with corporateSDLCpolicies and guidelines
• Provided hands-on project schedule management usingMS Projectduring the various stages of the project
• Responsible for creating and maintainingdocumentationrelated to the project including scope document, vision document, functional specification document,defectstatus report,risk analysisdocument,mitigationplans,supplementaryrequirements specification document andimpact analysisdocument
• Deflected the impact of multiple report requests from theBusiness Intelligenceusers
• Managed all the requirements in Requisite Pro, making requirements available to all team members
• Developed reports,chartsandgraphsto analyze critical data usingSQL.
• Designed thetest planand worked with the QA team to implement and monitor the entire QA process inQuality Center HPQCalso used for Defect Management.