Front Office Data

Business Analyst, 781-***-****, 201-***-****

CITIZEN – UNITED STATES OF AMERICA.

***************@*****.***

EXECUTION ABILITIES

Business Analyst with Risk management, Capital Markets, Model Quantitative Analytics, Data Analytics, Data Governance, Risk & Regulatory Reporting, SQL, Tableau skills within Financial Services and Banking industry – 20+ YEARS.

Extensive experience in analyzing and documenting business requirements and functional/non-functional specifications.

Expertise in Risk and Regulatory projects such as LCR, NSFR, BASEL, CCAR, CECL, IFRS9, FR Y 14, FR Y 9C, Model quantitative (PD, EAD, LGD), Credit Risk – CCAR.

Extensive work experience in AGILE, RUP, and Waterfall methodologies.

Handling Master data management supporting and collecting data from various business processes for collecting, aggregating, matching, consolidating, quality-assuring, persisting and distributing data throughout to ensure a common understanding, consistency, accuracy and control in the ongoing maintenance and application on various data governance, Risk and Regulatory projects.

Working with Corporate and Treasury desks for Liquidity Risk requirements for Liquidity Coverage Ratio, 4G, 5G, 2052a, Resolution Liquidity Adequacy and Positioning (RLAP), & Resolution Liquidity Execution Need (RLEN).

Creating liquidity forecasts for stress testing, liquidity assumptions and framework, responding to regulatory and Independent Liquidity Risk (‘ILR’) requests, reporting Liquidity Stress Test (‘LST’) results and trends, and ad-hoc analysis related to the liquidity impact of various business and funding initiatives.

Excellent understanding of data warehousing applications and design carrying out data analytics, mapping exercises, working with data stewards and model execution teams to carry out business analytics skills working closely with stakeholders and technology.

Extensive background in KYC/KPI Client On boarding for Controls, Mid-Office, Operations and Technology groups.

Deep understanding of the securities lending agency and dynamic margining business working with Risk and Operations.

Skilled in validation and testing complex scenarios for the maintenance of Quality Standards in projects.

Lead and coordinated full QA process lifecycle for QA Integration, UAT and regression testing activities.

Conducted User Acceptance Test (UAT) with stake holders and system users to uncover the latent defects in the system.

Supporting Fixed Income applications involving back office clearing and settlement systems for most of the fixed income derivatives, such as Repo's, Tri-Party, Buy-Sell Back, Options, Cash, Bonds, Futures, Forwards, RMBS, CMBS, Structured Products.

Heavily involved in testing Fixed Income applications writing test cases, test plan and deployment and process models around the test cases for UAT and implementation procedural guides for user references.

Handling Securities lending Agency and Margining business for Custody and Broker clients using tools like Syncova.

Excellent Data analyst carrying out complex and simple SQL statements to facilitate all aspects of the various projects supporting IT and business for data governance, data comparison, data mapping, data gap analysis and regression testing.

Carrying out project management responsibilities for current BAU projects and Change Management projects tracking milestones, traceability, resource allocation and overall end to end project cycle.

Collaborating with the business partners, drive book of work prioritization, requirement elicitation and validation, providing regular status updates to the partners, and taking responsibility for various project artifacts.

Deliver project plans, status reports, and functional requirement documents.

Team up with Business users and bridge gaps between business and IT.

Deeply understand the business issues and data challenges of client's organization and industry.

Generate reports using Data Visualization using Tableau for various Lines of Business, Strategic Execution directives for Program Management needs on an ongoing basis.

Write specifications, business processes and recommendations related to proposed solution.

Develop functional specifications and interface specifications for client engagements.

Communicate necessary changes to development team.

Contribute to QA team on test plan reviews and assist in QA testing process with requirements clarifications and questions.

Liaise with other IT teams on analyzing and sourcing the data to support required analytics.

Produce documentation as needed, including project plans, status reports, functional specifications, data dictionaries, etc.

Liaise with development team on defining data structures to hold the data, transformation logic, and reporting specifications based on user requirements.

Contribute to QA team on explaining requirements, suggesting improvements and assisting with QA testing process.

Support UAT process.

EXPERIENCE

TD Bank – Credit Risk – Retail, Commercial, Auto & Credit cards businesses. MARCH 2017 to till date

Sr. Lead Business Analyst – Credit Risk – CCAR, Model Quantitative, Risk and Regulatory

Creating Business Requirement document (BRD) and Functional document (FSD) for all credit risk initiatives for retail and commercial TD business like Home Loan, Home Equity Line of Credit, Mortgage, Deposits, TD Cards, Auto, Credit Cards.

Understanding and capturing details of the FRY 14Q, FRY 14M, 9C schedules and CCAR reporting into requirements document. Participating in CECL and IFRS 9 Data analytics and Data governance activities.

Handling Master data management supporting and collecting data from various business processes related to accounts, customers, LOB’s, product lines and various downstream reports for Regulatory requirements for commercial lending, retail lending, Auto Finance and Credit Cards.

Working closely with Basel teams for risk aggregation and risk reporting for capturing bi-lateral exposures, loss forecasting, exposures through various sectors and underlying assets or instruments.

Working closely with Risk Managers and Quant teams to help facilitate requirements for models like Roll Forward, Retail Credit preprocessing models & Unemployment Moody’s models.

Carrying out data warehousing data analytics responsibilities making sure the model used for Credit Risk forecasting for various lines of businesses are functional.

Collaborating testing with IT, QA and Business users to make sure all requirements are tested using data analytics and reporting tools to reflect no gaps, impacts in the data.

Carrying out data mapping, impact analysis for data governance projects working closely with data stewards and model execution teams.

Using SQL to perform data analysis, data governance rules validations and overall data quality checks, logging defects and maintaining a log of Testing BAT & Regression using HP ALM, SharePoint and JIRA tools.

Carrying out project management responsibilities for current BAU projects and Change Management projects tracking milestones, traceability, resource allocation and overall end to end project cycle.

Creating mapping documents by collecting business CDE’s (critical data elements) for model execution and business acceptance testing.

Using Tableau to generate reports and carry out various data analytics presenting visualization of the underlying data trends with ease to help facilitate the overall granularity and sensitivity of the various lines of business and its segments for Credit Risk portfolios. Using SQL tools such as Alteryx, Toad, SQL Developer to push and pull this data into Tableau.

JOHN HANCOCK - MANULIFE DEC 2016 – MAR 2017 – BOSTON

BUSINESS ANALYST – PEFORMANCE MEASUREMENT AND ANALYTICS

Handling performance measurement and attribution requirements for the GO (Global Optimization) initiative.

Handling Master data management requirements and Bloomberg Polar Lake to Enterprise Data lake flows, requirements for global initiatives for 21 work streams.

Closely partnering with the Chief data office and various vendor partners for requirements related to Attribution, Analytics, Benchmarking, Equity and Fixed Income Characteristics and NAV calculations in and out of the lake.

Working with vendor application requirements such as MOTIF, POINT, PORT, FUNDUR, SALESFORCE, BPL, FACTSET, SYLVAN, VERMILLION, SIMCORP Data warehouse and SIMCORP Dimensions.

Partnering with various data modeling teams to carry out business analysis, project management effort for overall GO program.

Managing expectations on the front office collateral management and collateral validation, margin allocation, risk.

Dedicated effort for Client On boarding of Risk Control applications for the bank.

Managing PMO meetings, minutes, stakeholder traceability’s and milestones-timelines across the program.

Carrying out project management responsibilities for current BAU projects and Change Management projects tracking milestones, traceability, resource allocation and overall end to end project cycle.

Assigned Enterprise-wide responsibilities, including: Global coordination of high-risk investigations; Escalation point for reputation risk matters.

Took ownership of individual cases using appropriate case management tools and techniques to progress in order to meet timescales for alert investigation processing.

INFOGROUP MAR 2016 – NOV 2016 - BOSTON

Business Analyst – Consumer Product Development

Deep Designing requirements for an industry wide product that would-be service oriented and client independent to facilitate all clients for various marketing campaign services with Business, Consumer, Address, Geo Demographics data appendages to make information more robust and reachable to clients.

Assisted and successfully carried out client on boarding effort for the technology builds that support the clients.

Carrying out detailed Business Analysis and requirements matrix for 200 clients and making sure that the product is build using agile approach from start to finish using tools and methods to meet efficiency, performance and reliability of data quality.

Great effort in regression testing the information or data using SQL skills, data governance and carrying data stewardship skills creating data dictionaries. Creating data flow diagrams and data mapping for various processes in the project life cycle. Extremely capable of carrying out data analysis skills using SQL and transforming and mapping data helping perform regression testing, gap analysis and impact analysis.

Data flow diagrams, entity relationship diagrams created for projects across various program initiatives.

Carrying out project management responsibilities for current BAU projects and Change Management projects tracking milestones, traceability, resource allocation and overall end to end project cycle.

STATE STREET BANK TRUST JAN 2015 – MAR-2016 - BOSTON

Business Analyst – Securities Lending – Collateral Management and Margin Validation– Risk Management-SYNCOVA ADVENT

Handling various requests of Front Office Risk teams for various initiatives towards collateral management and collateral validation, margin allocation, risk workflow process using– Advent Syncova.

Dedicated effort for Client On boarding of Risk Control applications for the bank.

Creating data flow diagrams and data mapping for various processes in the project life cycle.

Extremely capable of carrying out data analysis skills using SQL and transforming and mapping data helping perform regression testing, gap analysis and impact analysis.

Carrying out project management responsibilities for current BAU projects and Change Management projects tracking milestones, traceability, resource allocation and overall end to end project cycle.

Carrying out data collection, data reporting for EBA regulations and domestic markets adhering to MIFID highlighting the exchange rate, currency of the reporting LOB and LE, client vs. Firm side reporting.

Carrying out specific MIFID reports highlighting key elements such as Firm name, Firm LE, Country Code, Firm’s group Structure, Total Assets, Assets at the various hierarchies of consolidation layers, jurisdiction agent details and tied agent exceptions for the Equities or Fixed Income market specific products. Deep understanding of the securities lending agency and dynamic margining business working with Risk and Operations handling multiple Tri-party Agency and Bi-party Agency business using Advent Syncova.

Working closely with Global Treasury, Business services globally and FED / Legal department and supporting IT program management, business analysis newer initiatives.

Gathering and managing market data for all the offices [USA, EMEA and APAC. Interacting with Front-Office and Mid-Office – Regulators, Finance desk daily.

Working Closely with AML and TS teams from compliance prospective for building in control reports and checks that interact with Risk and Regulatory Technology for FED/SEC reporting.

Using Tableau to generate reports and carry out various data analytics presenting visualization of the underlying data trends with ease to help facilitate the overall granularity and sensitivity of the various lines of business and its segments for Agency Lending models and portfolios. Using SQL tools such as Alteryx, Toad, SQL Developer to push and pull this data into Tableau.

Excellent Data analyst carrying out complex and simple SQL statements to facilitate all aspects of the various projects supporting IT and business for data governance, data comparison, data mapping, data gap analysis and regression testing.

JP MORGAN CHASE - JAN 2013– JAN 2015 – NEW YORK

Risk Business Analyst– BASEL III – LIQUIDITY RISK COVERAGE AND 4G/5G, 2052a, RLAP & RLEN.

Working closely with all LOB’s to facilitate Risk based LCR, EBA LCR and 4G, 5G, 2052A, RLAP & RLEN reports & architecture to meet FED guidelines for US, Europe and APAC respectively.

Carrying out data collection, data reporting for EBA regulations and domestic markets adhering to MIFID highlighting the exchange rate, currency of the reporting LOB and LE, client vs. Firm side reporting.

Carrying out specific MIFID 1 and MIFID 2 reports highlighting key elements such as Firm name, Firm LE, Country Code, Firm’s group Structure, Total Assets, Assets at the various hierarchies of consolidation layers, jurisdiction agent details and tied agent exceptions for the Equities or Fixed Income market specific products. Prepare LST reports analyzing variances, historical trends and assumption changes.

Handling Master data management supporting and collecting data from various business processes related to accounts, customers, LOB’s, product lines and various downstream reports for Regulatory requirements for liquidity risk initiative across various securities products.

Mapping the requirements for the FR 2052a which comprises sections covering broad funding classifications by product, outstanding balance and purpose, segmented by maturity date.

Market Ceiling’s on certain products as line items in the MIFID related reports need to be calculated and regression tested prior to sharing with Compliance and Regulation clients.

Carrying out Balance Sheet aggregation of assets using end user requirements based on EBA or domestic regulation guidelines. Analyzed new/prospective clients including Enhanced Due Diligence synthesized finding and assessed risk levels.

Reducing the probability and severity of losses resulting from risk managements weaknesses using risk and stress testing models for BASEL III and BCBS 239 and Liquidity Risk initiatives.

Capturing Liquidity Risk, Basel related Risk aggregation, Risk coverage Ratios and Risk Weighted average Ratios for mitigating risk by building and maintaining various future steady state risk models for various stress scenarios for model performance indicators related to legal entities, counterparties, customers, accounts.

Client On boarding for Technology solutions that help changes the bank initiatives and run the bank initiatives.

Managing Collateral data specific to REVERSE REPO, REPO, REPO BUY SELL BACKS, EXCESS PLEDGES and REPO MARGIN for supplemental and collateral schedules for Regulatory Reporting.

Executive briefing and reporting on scrum metrics, burn-up and process improvements periodically.

Delivered project needs on time and within the agreed acceptance criteria in a hybrid methodology environment as they attempted to transition to an Agile Methodology.

Extremely capable of carrying out data analysis skills using SQL and transforming and mapping data helping perform regression testing, gap analysis and impact analysis.

Data flow diagrams, entity relationship diagrams created for projects across various program initiatives.

Interacting with BackOffice and Operations and Development on a phase by phase basis of the project to make sure the deliverables are met, and the project changes are being tested from a functional prospective throughout the product life cycle.

Responsible overall for operations for back office operations and IT management and budgeting.

Managing SQL in various databases for reporting, data mining, data capture and various user ad-hoc requests from time to time during the complete SDLC lifecycle of the project.

Using Tableau to generate reports and carry out various data analytics presenting visualization of the underlying data trends with ease to help facilitate the overall granularity and sensitivity of the various lines of business and its segments for Liquidity Risk collaterals. Using SQL tools such as Alteryx, Toad, SQL Developer to push and pull this data into Tableau.

CITIGROUP, NJ 07/11– 01/13 – NEW YORK

Business Analyst– Reference data Management & Operational Risk Management

Engaging Front office trade flow to back office operations on a timely basis throughout the scope of the various projects.

Creating and Monitoring AML transaction monitoring strategy optimization rules mapping a structure that includes segmenting the customer base by analyzing customer activity and risk characteristics to monitor them more effectively.

Creating and developing Scenario Segmentation and Anomaly Detection Models.

Grouping together customers and accounts that have similar characteristics and transactional behaviors with the objective of setting risk-based thresholds that are appropriate for each segment. Segments of customers and/or accounts are grouped together based on one or more of their inherent characteristics, such as average transaction amount, average transactional volume, net worth, product usage, region, customer/account type, etc.

Working Closely with AML and TS teams from compliance prospective for building in control reports and checks that interact with Risk and Regulatory Technology for FED/SEC reporting.

Managing Compliance initiatives like Dodd-Frank, Large Trader, FATCA and others from a BA/PM/PMO prospective.

Maintaining and updating process flows and documentation (BRD, FSD, and mapping documents) in accordance with the changing SOA standards.

Working as a liaison between Compliance, Front Office users, Securities Operations, Treasury and the senior management to deliver timely requirements and detailed analysis of the various project timelines, scope.

Managing SQL in various databases for reporting, data mining, data capture and various user ad-hoc requests from time to time during the complete SDLC lifecycle of the project.

Extremely capable of carrying out data analysis skills using SQL and transforming and mapping data helping perform regression testing, gap analysis and impact analysis.

Ensured the development teams are practicing the agile principles. Completed product demonstrations, retrospectives, and resolve action items. Assisted Product Owner with Backlog maintenance.

HSBC, NJ 04/10 – 06/11 – NEW YORK

Business Analyst– FI, EQ and Asset Management

FULL TIME EMPLOYEE

Engaging Front office trade flow to back office operations on a timely basis throughout the scope of the various projects.

Client On boarding for all front office bond, cash, Repo and MBS desks.

Process and estimate new client requests, prepare proposals, determine implementation schedules, translate strategies into action plans. My role is to lead business operations and IT team on large, multi-functional efforts and work in a matrix reporting environment.

Managing projects specific to Fixed Income REPO, CASH business from an IT and Ops prospective.

Creating Current and Future state diagrams and process flows, BRD, FSD and mapping documents for business and supporting technology teams.

Working as a liaison between Compliance, Front Office users, Securities Operations, Treasury and the senior management to deliver timely requirements and detailed analysis of the various project timelines, scope.

Managing SQL in various databases for reporting, data mining, data capture and various user ad-hoc requests from time to time during the complete SDLC lifecycle of the project.

Excellent Data analyst carrying out complex and simple SQL statements to facilitate all aspects of the various projects supporting IT and business for data governance, data comparison, data mapping, data gap analysis and regression testing.

Carrying out project management responsibilities for current BAU projects and Change Management projects tracking milestones, traceability, resource allocation and overall end to end project cycle. (run the bank and change the bank)

Nomura Securities Inc. NY 1/07 – 3/10 (3 YEAR) – NEW YORK

Business Analyst, Fixed Income and Asset Management

(Sr. Management Consultant)

Engaging Front office trade flow to back office operations on a timely basis throughout the scope of the various projects.

Working with the Fixed Income Product Controllers gathering requirements for daily and monthly reporting purposes.

Develop high level Business Requirements Document and Functional specification documents for all the enhancements or changes on the REPO desk.

Implemented new Change Control process with executive team

Assisted IT in the development and implementation of a new release and off-release process and scheduling with executive team signoff

Aligned talent acquisition function to the organization’s business strategy through the integration of international teams, processes and tools.

Extremely capable of carrying out data analysis skills using SQL and transforming and mapping data helping perform regression testing, gap analysis and impact analysis.

Data flow diagrams, entity relationship diagrams created for projects across various program initiatives.

Handling reference data for various fixed income products for price verification process from back office operations prospective.

Managing SQL in various databases for reporting, data mining, data capture and various user ad-hoc requests from time to time during the complete SDLC lifecycle of the project.

Excellent Data analyst carrying out complex and simple SQL statements to facilitate all aspects of the various projects supporting IT and business for data governance, data comparison, data mapping, data gap analysis and regression testing.

JPMorgan Chase NY 10/01 – 12/06 (6 YEARS) – NEW YORK

Business Analyst, Fixed Income- North America-Rates & Market Data Group (Rates & Market data desk)

FULL TIME EMPLOYEE

Engaging Front office trade flow to back office operations on a timely basis throughout the scope of the various projects.

Leading all IT and business operations initiatives on the trading floor reporting to the Mid office MD managing Management Reporting, Fund Accounting, Market Data, Back Office Operations, Production Support and newer business initiatives for Front Office Traders and Mid Office Operations Support teams.

Delivering Projects quickly analyzing some of the Fixed Income business of JPMorgan Chase’s Fixed Income division handling the US Treasuries and BOND desk covering CASH and REPO desk business requirements, doing UAT/Regression.

Scoped and analyzed client change initiatives to determine people, process, and behavioral changes.

Understand the Profit Attribution Analysis (PAA) of the portfolio. Communicate daily and monthly results and/or issues to the trading desk and senior management, particularly around residuals. Drive to resolve them in partnership with the Front Office, Market Risk, Technology and Market Quantitative Analytics. Balance sheet and regulatory analysis, month end closing process and quarterly / annual disclosure reporting.

Partner with Price Verification team in the review of inventory valuation testing and results. Partner with Price Verification team in the review of inventory valuation testing and results.

Daily interaction with other managers throughout the organization, the trading desks, middle office, risk management, business unit management teams and operations will be necessary to resolve issues including but not limited to front to back reconciliations, trade booking issues, billing accuracy.

Ad hoc projects including system development, redesigning and streamlining daily and monthly processes.

Handling the steps in the life cycle of the project from trade entry through clearing and settlement to the BackOffice IMPACT system (ADP/ICI). Interfacing with client counterparts to determine custom reporting requirements and with internal developers/analysts.

Managing SQL in various databases for reporting, data mining, data capture and various user ad-hoc requests from time to time during the complete SDLC lifecycle of the project.

Goldman Sachs NY 10/99 – 10/01 (2 YEARS) – NEW YORK

Business Analyst, Prime Brokerage/Wealth Management

FULL TIME EMPLOYEE

IMD billing system is primarily responsible for handling the fee calculation for Private Wealth Management Clients of Goldman Sachs. The Fees charged to the client is based on the value of asset s managed. Private Wealth Management Customer representatives use the system.

Interacting with Front-Office and Mid-Office on a daily basis.

Interacting with BackOffice and Operations and Development on a phase by phase basis of the project to make sure the deliverables are met and the project changes are being tested from a functional prospective throughout the product life cycle.

Excellent team leader managing people and resources strategically always sharing knowledge and ideas and participating in every aspect of the project from design or gathering business requirements to debugging.

Managing SQL in various databases for reporting, data mining, data capture and various user ad-hoc requests from time to time during the complete SDLC lifecycle of the project.

TIAA-CREF, Investment Systems NY 9/96 – 9/99 (3 YEARS) – NEW YORK

Business Analyst, Securities Lending and Mortgage Real Estate

FULL TIME EMPLOYEE

Direct Offer Tracking System [DOTS] and Warrants

On-line Integrated Systems governing all of Teachers Insurance’s annuity funds and equities obtained through teachers and professors, building interest and having various investments policies for large companies to obtain as a transaction amount for a specific period of time with a certain rate of interest. DOTS facilitate you to edit or view a particular deal, check the type whether it is Limited Partnerships, Long term Corporate, Structured, Preferred Stock etc.

Managing SQL in various databases for reporting, data mining, data capture and various user ad-hoc requests from time to time during the complete SDLC lifecycle of the project.

EDUCATION

Bachelor’s degree in Computer Science and Engineering. University of PUNE. 1994.

CFA charter in progress. FRM charter in progress.

SOFTWARE PACKAGES/SKILLS● DATABASES/RDBMS

MS-Office (Excel, Word, Visio, Projects, PowerPoint), Business Objects, Use Cases, Bloomberg, SYBASE, ORACLE (PL/SQL), MS-ACCESS, SQL-SERVER, ICI/ADP (IMPACT), PeopleSoft, Business Objects, COGNOS, ADVENT-Syncova, Microsoft Projects

BUSINESS AREAS

CREDIT, LIQUIDITY, MARKET RISK MANAGEMENT AND ANAYTICS, FIXED INCOME, WEALTH MANAGEMENT, EQUITIES, LEGAL AND COMPLIANCE, REGULATORY, BASEL III, SECURITIES LENDING – DYNAMIC MARGINING, COLLATERAL MANAGEMENT, COLLATERAL VALIDATION.

Contact this candidate