Sr. Business Analyst, Mifid Ii Regulatory Reporting Resume
Brunswick, NJ
SUMMARY:
- Objective: MBA with 12+ years of experience in Business Analysis, Data Analysis, System Analysis, and Project Management seeking a Business Analysis/Project Management position.
- Financial Industry: Capital Markets & IB, Broker Dealer, Prime Brokerage, Wealth Mgmt, Commodities, OTC, Retail Banking
- Organizations: Confidential, JP Morgan, Confidential, CME, Confidential, Confidential, Confidential, AIG FP, KPMG
- Domains: Regulatory Reporting, Credit/Market Risk Limits, Collateral, Treasury, Accounting, and KYC/AML
- Products (Cash, ETD, OTC): Hands on experience with Credit Default Swaps (CDS), Interest Rate Swaps (IRS), Foreign Exchange Derivatives (FX Forwards, NDFs, CSF, Swaps, Options), Equity Swaps, Total Return Swaps, Portfolio Swaps, Forward Rate Agreements, Securitized Products (CDO), Commodities (Cash Contracts, Futures, Options, and Swaps)
- Listed Derivatives: Futures, Options, FX Forwards, FX NDF, FRA, CDS
- Regulatory Reporting: MiFID II, Dodd - Frank (Creation, Continuation, Historical, Valuation) under Title VII, BCBS 239, SOX
- Regulatory Knowledge: CCAR (FR Y-14/M/Q/A, FR Y-9C), and Basel
- Risk: Credit risk, Market risk Framework, Operational risk, Liquidity Risk Ratios
- BA/PM skills:
- Experienced in leading client engagement, understanding their needs/priorities and expert in eliciting requirements from users in Front, Middle, & Back office with strong communication skills.
- Co-ordinate and network with multiple stakeholders to successfully deliver critical applications/solutions.
- Proficiency in working in all phases of software development life cycle (SDLC).
- Hands on experience with Waterfall, and Agile(Scrum) methodologies.
- Skilled in documenting Business Requirement Document (BRD) and Functional Requirement Document (FRD/FSD).
- In depth experience in creating business process work flow diagrams on white board as well as in Visio and Gliffy.
- Result oriented joint application development (JAD) facilitator and coordinator.
- Created test plans, test scenarios, and test cases as well as conducted User Acceptance Testing (UAT).
- Assisted in creating Gantt chart, milestones, forecasting, presentations, WBS, status update reports.
- Technology: SQL, MS Excel, Pivot Table Analysis, VBA Macro, Visio, MS Project, SharePoint; UML; COGNOS; IBM Rational Requisite Pro; Enterprise Architect; TIBCO Spotfire; SAP Business Objects; Calypso v15, Confluence, JIRA; Bloomberg; MarkitServ; Fidessa for Equity Cash, GMI for Futures and Options, DTCC D/S Match; Actimize, HTML; XML; FIX Protocol, FpML; XBRL; Altova XML Spy; CME Clearport, Micro Strategy
- Database: Oracle, SQL Server, Hadoop
PROFESSIONAL EXPERIENCE:
Sr. Business Analyst, MiFID II Regulatory Reporting
Confidential, Brunswick, NJ
Responsibilities:
- Implemented end-to-end MiFID II Regulatory reporting solution for Post Trade Transactions (To TradeEcho) and T+1 (To UnaVista) for all asset classes and successfully met the regulatory reporting deadline of January 3rd 2018.
- Created and contributed to Functional Specification Document (FSD), participated in data modeling exercise with, and created rules, and buy/sell logic document for all asset classes.
- Identified all source systems in scope for MIFID II and their sources and created data mapping document for PTT fields of 18 and T+1 Reporting fields (65) with mandatory and optional flags.
- Conducted detailed testing in conjunction with QA team and resolved issues with the assistance of developers and LSEG operations team before go-live.
- Proficient reading XML messages to find out data discrepancies, identified issues, and created QC in ALM.
- Communicated with on-site, off-site, and off-shore teams on a daily basis and also provided updates to C-Level management.
- Monitored post production reporting through reconciliation of trade counts, acknowledgements, non-acknowledgements, from TradeEcho, and UnaVista, and resolved post production issues.
- Created a daily recon report for all asset classes and circulated to all stakeholders.
- Lead and participated in daily Triage call to identify issues and resolutions.
Environment: Squirrel, MS SQL Server database, MS Office, Pivot table, XML, JSON, FIX
Sr. Business Analyst/PM, Credit Risk / Market Risk
Confidential York City, NY
Responsibilities:
- Acquired knowledge about UI based centralized limits management system and familiarized with various limits applied on Equities, Commodities, Rates, Credit, Wholesale, and OTC Clearing positions
- Elicited and documented business requirements for integrating new system using confluence.
- Communicated with Market Risk, users, technology teams (on-shore, off-shore) on a daily basis.
- Created UI screen mock ups and presented to users as well as technology teams for critique and evaluation.
- Dealt with system issues, created JIRAs on a daily basis and resolved with the help of technology team and user group.
- Coordinate with technology team for periodic releases (every 6 weeks) and supported over the weekend.
- Assisted in QA Testing as well as UAT testing.
Environment: SQL, MS Office, Visio, Pivot table, FIX Protocol, JSON
Sr. Business Analyst/PM, Retail Management Reporting Automation
Confidential, Long Island City, NY
Responsibilities:
- Acquired domain knowledge of Retail Banking, gathered management reporting requirements (Dimensions & Measures) from Retail Management Reporting team, created BRD & FRD (Business & Functional Requirements Documents).
- Conducted detailed data mapping exercises with source system and defined rules in conjunction with Retail Management Reporting team to create an Aggregation layer to suffice various ad-hoc and static Retail Management reporting requirements.
- Dissected CRO Monthly Report, created Data Demand Sheet for Aggregation Layer as well as CRO Monthly Report and participated in Data Modeling Exercises with Modeling team.
- Acquired account level sample data files from Big Data Repository (HDFS) to check the availability of data in the repository.
- Liaised and co-ordinate with source system owners, integration team, modeling team, and developers to publish data into reporting portal.
- Carried out SIT and mock report creation testing.
- Designed various test scenarios to create various Management Reports for ad-hoc reporting.
- Acquired signed off on BRD, FRD, and Data Demand Sheet on a timely basis.
Environment: Hadoop, SQL, Pivot table, Databridge, Java, Microstrategy, Citi Reporting Portal, Confluence, JIRA, Visio
Sr. Business Analyst/PM, Clearing Solutions (Equity Swaps and IRS)
Confidential, New York, NY
Responsibilities:
- Acquired knowledge on Equity Swaps, Portfolio Swaps, Total Return swaps and their architecture.
- Lead requirements gathering sessions with Product BLM, Operations, Risk, IT, SDR, to elicit requirements on Product Scope, Account set up, connectivity, messaging, risk management, client reporting to create BRD and detailed FRD for clearing listed Equity Swaps, BRL Swaps, Swaptions, CME listed NN/NG Commodity Futures Spreads.
- Analyzed and assisted in Calypso customization/configuration fields/elements around major modules like Trade Capture, Market Data capture, Valuations, Workflows, EOD Reporting, Regulatory, Risk, for Equity and BRL Swaps.
- Reviewed FIXML/FpML elements and inbound/outbound messages for Equity/Rates (CAD/BRL) Swaps and Swaptions.
- Hands-on experience with various listed options (CBOE) and futures (CME) contracts specifications, expiration, clearing, margining, and settlement.
- Tracked issues, project progress; and drafted Status/Forecast reports.
Environment: Clearport, Confluence, JIRA, Calypso, FIX, FpML, Altova XML Spy, MS Office, Gliffy, SQL, SharePoint, Cognos
Sr. Business Analyst/PM, Regulatory Reporting
Confidential, New York, NY
Responsibilities:
- Listed out all required data fields (approx 146 within pre-trade, execution, post-trade, accounting, risk, reporting, etc.) required by Section 17a-3/17a-4 of SEC (Security based products), Rules 1.34/1.31 of CFTC (non-security based products), and FINRA for Cross Assets including exchanged traded and bilateral.
- Conducted exhaustive system analysis to acquire data fields for Credit, Rates, Securitized Products, Commodities, and FX.
- Interviewed users within Operations and IT to gather system information, mapped required data fields to stand alone system or aggregator and documented into Functional Document/Feed On-boarding Specification document.
- Interacted with cross-functional teams located in various geographies and also provided weekly status update to Stakeholders.
- Participated in designing test scenarios and in UAT. Also resolved data quality/broken or failed feeds/user authentication issues.
Environment: MS Office, Visio, Project, RainStor, SQL, SharePoint, Cognos, SEC, CFTC, FINRA
Sr. Business Analyst/PM, Regulatory Reporting
Confidential, Santa Clara, CA
Responsibilities:
- Developed in depth understanding of Foreign Exchange OTC products - Forward, NDF, Window, Swaps, and Options; Interest Rate Products - Vanilla, Basis, Caps & Floors, and Swaptions
- Created Schedule matrix and listed out milestones describing completion of Data Mapping, Review, UAT, and Deployment to meet the deliverables and comply with reporting and recordkeeping deadline.
- Elicited requirements from FX/Rates traders on Product Scope, Operations on daily processes, Risk on Valuation Marks, Compliance on regulatory reporting, CRM on client on-boarding, IT for external connectivity.
- Drafted BRD, FRD, Gap Analysis, element mapping with DTCC GTR and analyzed systems end-to-end for limitations and upgrades with respect to customers such as LEI, Financial Status, US Status, Clearing/Execution Venues, etc.
- Lead daily meeting with on site and off-shore development team to test and deploy solution in UAT and in Production.
- Reviewed test plan, provided test scenarios, and drafted test cases for data validation and conducted UAT.
- Provided regular status summaries of impact points, escalated key issues for consideration and decision making.
- Tracked/Resolved issues internally and externally with DTCC GTR, drafted user guides, and provided tutorials to users.
Environment: MS Office, Visio, Project, RUP, CFTC, DTCC, FIX, FpML, SQL, SAP BI BO, Oracle, Toad, SQL Mgmt Studio
Sr. Business/Data Analyst, Application Portfolio Services
Confidential, New York, NY
Responsibilities:
- Analyzed Capital Market, Broker Dealer, and Investment banking businesses to understand various processes, systems used for those processes and their Domains.
- Contributed in strategic decision making exercise in determining decommission candidate systems.
- Interviewed 26 Domain Architects (SMEs) located across the globe to gather requirements about the ownership of applications.
- Compiled SQL queries to retrieve data on Applications and extensively used Pivot Tables, Spotfire, and Cognos for analysis.
- Created weekly status reports for Stakeholders to provide progress of the Application Portfolio Ownership.
- Conducted GAP analysis, gathered and documented new requirements for the New Application Repository, created use cases, process flow charts, and activity diagrams.
- Assisted in migrating Application data to New Application Repository, conducted UAT, and provided to end users.
- Designed and documented approval process for new applications for proper governance and future cost management.
Environment: SQL, Pivot table analysis, PowerPoint, Sparx Enterprise Architect, SharePoint, Spotfire, Agile, UAT