SUMMARY

• 7 years of experience as a Financial Business Analyst with strong understanding of Business Requirements Gathering, Business Process Flow, Business Process Modeling and Business Analysis.
• Ability to work on Testing, Data Analysis, Business Requirement Gathering, diverse aspects of regulatory - related projects.
• Performed numerous Ad-hoc requests, financial reports involving SQL scripts, UNIX, SAS and Teradata. Experience in Axiom analytics and reporting.
• Worked on Data warehousing business Intelligence area dealing with data analysis, solution design Metadata management and MDM, ETL
• In depth knowledge about ROCI Modeling and InventoryLossForecasting
• Hands-on implementation and production support experience of multiple BSA/AML Monitoring Systems, Broker/Trade Surveillance Systems, and OFAC & KYC/CIP Systems.
• Worked on Master data management (MDM) and data governance for improving data quality.
• Experience of serving as facilitator and Data Governance technical advisor to the Data Governance Council.
• Experience in developing business requirement documentation (BRD), reviewing, reconciliation and testing various systems for financial instruments, IHC CAAR reporting, regulatory reporting.
• Working with Regulators, Developing forms for bank holding, Middle office, balance sheet products, CCAR, G/L Recon and other Strategic review and ongoing advisory for growth on OTC Derivative Clearing.
• Extensive experience working in back end tester by writing SQL Queries and PL/SQL scripts on large data warehouse systems involving Terabytes worth of data.
• Have theoretical knowledge of banking regulations such as Basel, Risk Reporting, CCAR and Dodd Frank.
• Domain knowledge of Accounting Principles and Acts (GAAP & SOX), Capital Budgeting, Equities, Fixed Income, Mortgage - backed securities (MBS), Asset - Backed Securities (ABS), Derivatives (Options, Futures, Forwards, Swaps), KYC, AML, EWS, Credit Risk, Operational Risk, Market Risks, Commodities and Money Markets
• Translates data file formats (ETL) in Access, Microsoft Import/Export Wizard, SSIS, strong experience in RUP Business modeling process.
• Understanding of the implementation of regulatory guidelines such as the USA Patriot Act, Basel-II, Sarbanes - Oxley Act, SEC Rule 10b-5, Securiies Exchange Act of 1934 and basics of DTCC, FINRA, ISDA, ISIN, SEC, ECNs, SWIFT, STP, Dark Pools, Crossing Networks, ATS, etc. in Financial Institutions.
• Document and resolve issues of missing data, data trends and data quality deficiencies.
• Strong hands on ability to use SQL in RDBMS (SQL Server, Oracle) for verifying source data preparation and assisting of data design input and trouble-shooting.
• Strong knowledge of Business Intelligence, Data Warehousing and Business Architecture
• Extensive work experience using Change Management and Bug Tracking Tools like Quality Center, JIRA and Rational Team Concert
• Extensive experience in conducting Market Research, Feasibility Studies, Data Analyses, Data Mapping, Data Profiling, Gap Analyses, Risk Identification, Risk Assessment, Risks Analyses, and Risk management.
• Expertise in Performance Management, Asset Management, Cash Management, Portfolio Management, Credit Management, Client Reporting and implementing its benefits.
• Comprehensive knowledge of and solid experience in Derivatives including Credit Derivatives, Interest Rate Derivatives, FX Derivatives, Equity Derivatives and Commodity Derivatives.
• Worked on different Portal for searching like Bidsync, Onvia, Federal Business Opportunities (FBO) Understood Fixed Income, Bonds and Bond Trading Cycle, Equities and Equity Trade Cycle, Derivatives (Options and Futures), Portfolio Management, Wealth Management, and Sales and Marketing.
• Have in-depth knowledge of banking, finance and treasury functions, Basel II/Basel III, liquidity reporting/Capital forecasting.
• Extensive experience in Strategic development of a Data Warehouse and in Performing Data Analysis and Data Mapping, data mining from a Operational Data Store to a Enterprise Data Warehouse.
• Proficient in all phases of Software Development Life Cycle (SDLC) achieving milestone using Rational Unified Process (RUP) and waterfall model.
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

Sr.Credit Risk Reporting Business Analyst

Responsibilities:

• Designed and created daily Profit andlossforecasting.
• Leading the Data Lineage project from source systems to the CCAR Reporting tool using Informatica Metadata Manager.
• Lead client organization through successful implementation of a complete Data Governance framework and operating model.
• In response to a FDIC/SEC MRIA(Matter requiring immediate attention), facilitated the integration of the VaR (Value at Risk) exposures for Prime Brokerage (PB) trades, sourced from various PB margining systems, into central credit management systems, to be able to deliver a single platform to resolve shortcomings of supporting credit risk associated with these traded products, including the calculation and aggregation of exposure and limits
• Perform Surveillance of Employees accounts to detect potential insider trading, market abuse, and/or violations of the Trading Policies for Trade Surveillance/Compliance.
• Facilitated Change Management across entire process from Project conceptualization to Testing through Project Delivery, Software Development and Implementation Management in diverse Business and Technical Environments.
• Created user stories and use cases to be used in Rally and subsequently for the BRD.
• Review of Things gone wrong (TGW) and Concerns and Corrective actions report (CCAR)
• Participated in the design and documentation of mapping and transformation specifications, system standards and functional specifications in terms of Pervasive ETL Data Integrator to ingest data from a variety of sources, model aggregated data, and provides the modeled data to a number of downstream consumers to build Client Risk Portal Data Warehouse.
• Conducted scheduled performance reviews with appropriate project personnel and AXIOM senior management
• Provided support for development and test teams during testing cycles during SIT, UAT, including bug analysis and requirements deviation and in the preparation and delivery of application demos and training
• Created Technical specifications for the SAS Models Reporting Applications.
• Reviewed Stored Procedures for reports and wrote test queries against the source system (SQL Server) to match the results with the actual report against the Data mart (Oracle).
• Prepared UML to model systems of applications usingVisio
• Senior level SQL query skills (Oracle and TSQL) in analyzing and validating SSIS ETL database data ware house processes
• Provided leadership and vision to Axiom and subcontract corporate support personnel
• Dealt with data mapping issues between various source systems and staging area and datamarts
• Conducted status report meetings with the business and the IT team on a weekly basis, as the most important aspect of the project was Data Mapping.
• Made extensive use of SQL queries and RDBMS for the arrangement of customer data.
• Involved in monitoring, investigating and reviewing Personal Employee Trading Accounts and Trade Requests.
• Collaborated with Product Managers, senior stakeholders from Client Transition/Client Experience (KYC), Legal, Risk and Compliance groups to analyze business needs and delivered necessary artifacts (use cases, user stories, functional requirements specifications, UI designs, mockups, workflows, etc.)
• Created presentations and Business Process Flow maps using MSVisioand PowerPoint.
• Focal to the bank's entry into OTC clearing for Rates and Credit products as a result of Dodd Frank, played a pivotal role in defining the business and functional requirements to build an automated solution for the calculation of daily and monthly interest and Single Currency Margining fees, based on the daily margin requirements and cash and securities balances.
• Documented key changes in CCAR summer submissions and greatly involved in process re-engineering
• As part of OTC Clearing working group/steering committee, actively participated in an open forum consisting of Senior Credit and Market Risk managers, traders and Technology managers to discuss and track open issues and conduct brain storming sessions to understand and document the various nuances of OTC Clearing business
• Worked extensively with the Middle Office Clearing and Regulatory reporting and Compliance group to document BAML Risk monitoring procedures and guidelines
• Worked as a Test manager to design and implement the Test Framework and Test strategy. Coordinate SIT and UAT Testing.

Confidential, NY

Sr. Business Analyst

Responsibilities:

• Worked with SMEs to understand various assets and security classes, exchange traded derivatives (such as futures, options on futures, equity options and index options), OTC derivatives (such as interest rate swaps, swaptions, credit default swaps and total return swaps) and portfolio allocation and management.
• Designed new database tables to meet business information needs. Designed Mapping document, which is a guideline to ETL Coding.
• Assisted in identifying and quantifying Credit Risk, Operational Risk and Market Risk
• Generated requirements for Capital Markets - Fixed Income Investment Management Business, Portfolio Management, Hedge funds, corporate actions, Brokerage and Trading Model within the scope of both the Front and Middle Office.
• Conducted user interviews; gathered, and analyzed operational requirements in consultation with traders, developers, and end users using Requisite Pro, and the business requirements were in compliance with Sarbanes Oxley Act (SOX).
• Applied business knowledge of Fixed Income and Foreign Exchange Trading (Bonds, Spot/Forwards, Interest Rate Swap, Credit Default Swaps, Options: vanilla/single barrier/double barrier/digital) and hedge fund.
• Coordinated re-architecturing the existing VBA/Access system into ASP.net environment and existing table structure, stored procedures, and functions in MS SQL environment
• Using UNIX console commands to check database has been connected the other functionalities.
• Data cleansing and creation of layouts and specifications for end-user reports, delivering an end-to-end Metadata Management solution in the process.
• Documented Requirements for Activity management, Fixed Income, Asset Management Services, Client portfolio management, Order management system, Performance, Equities, Reconciliation, Transaction capture/Execution and reporting requirements for the user interface
• Prepared test Data sets and performed data testing using the PL/SQL scripts. Also used MS excel for data mining, Created cash flow models for Mortgage Backed Securities, Whole Loans, Structured Securities using Bloomberg, Intex and ADCO data
• Involved depth understanding of Credit Risk management for the application
• Strong experience in documenting business workflow, creating process flow diagrams, process improvement, reengineering by using MSVISIOand MS office products.
• Responsible for validate all aspects of models including retail or wholesale credit risk models, underwriting scorecards, liquidity and operational models, valuation and pricing models, and customer and marketing segmentation models
• Possess understanding of the Structured Finance with a focus on Asset Backed Securitization including MBS, credit card receivables securitization, insurance risk securitization, auto loan securitization etc.
• Responsible for Leading the Business Process Reengineering effort and for the SRS (Software Requirements specifications) documentation of the build out of the FWA dashboard and for client reporting. data cleansing, data mapping, data dictionary and data analysis.
• Extensively involved with the trading activities of Credit Derivatives, Interest Rate Derivatives, FX Derivatives, Equity Derivatives and Commodity Derivatives; and Futures including Commodity Futures Contracts and Financial Futures
• Performed interim and future state data governance workflow development and design for data elements based on Operational Finance Data Governance workshops.
• Performed Work Breakdown Structure (WBS) and Critical Path Analysis (CPM
• Participated in the UAT for Broker/Dealer conversion for integration using Mercury Test Director.
• Monitored and helped Design front end GUI using Dream Weaver, DHTML, HTML, JavaScript
• Exposed to SQL queries while churning out relevant information from company’s database.
• Involved in the Market Risk Calculation using VaR methodology
• Maintained the data integrity of the Baan ERP system by developing an end-user strategy for data cleansing and engineering revision control
• Involved in Logical & Physical Data Modeling. Database Schema design and modification of Triggers, Scripts, Stored Procedures in Sybase Database Servers.+
• Utilized corporation developed Agile SDLC methodology. Used ScrumWork Pro and Microsoft Office software to perform required job functions.
• Acquired extensive knowledge of financial products, services & terms during day-to-day tasks, such as - Exchange Traded Derivatives (Futures, Options, Single Stock Equities, Commodities & FX Currency)
• Used SQL to query the database and performed data analysis.
• Wrote BRD, FRD, use cases, test scenarios, test cases for testing the functional and non-functional aspects of both ETL jobs and Reporting jobs
• Wrote Test Cases in Mercury Quality center that would test various Test scenarios.
• Interacted with Cash Management Division and Compliance Office to review the AML (Anti Money Laundering) requirements and provide Positive Pay service to reduce check fraud

Confidential, Chicago, IL

Businesss Analyst

Responsibilities:

• Involved in monitoring, investigating and reviewing Personal Employee Trading Accounts and Trade Requests. Perform Surveillance of Employees accounts to detect potential insider trading, market abuse, and/or violations of the Trading Policies for Trade Surveillance/Compliance.
• Involved in conducting JAD sessions to identify the source systems and data needed by Actimize-SAM (KYC/CIP).
• Identified and documented Functional/Non-Functional and other related business decisions for implementing Actimize-SAM to comply with AML Regulations.
• Strong experience in documenting business workflow, creating process flow diagrams, process improvement, reengineering by using MSVISIOand MS office products.
• Generated requirements for Capital Markets - Fixed Income Investment Management Business, Portfolio Management, Hedge funds, corporate actions, Brokerage and Trading Model within the scope of both the Front and Middle Office.
• Work with region and country AML Compliance leads to support start-up of compliance-led projects at regional and country levels. Including defining the subsequent phases training, UAT, staff to perform test scripts, data migration and the uplift strategy (updating of customer information to bring them to the new KYC standards) review of customer documentation.
• Verification of journal entries by analyzing the general ledger using Axiom EPM software
• Competent in using business intelligence tools of enterprise resource planning, online analytical processing, data mining, etc
• Conducted workflow, process diagram and gap analyses to derive requirements for existing systems enhancements using UML.
• Regulatory regimes, such as Dodd Frank and MiFID II, dictate that trade surveillance must be carried out on a cross-market and cross-asset basis.
• Implemented Actimize Anti-Money Laundering (AML) system to monitor suspicious transactions and enhance regulatory compliance.
• Loading staging tables on Teradata and further loading target tables on SQL server via DTS transformation Package.
• Was actively involved in the design of BRD, FRD, Use Case diagrams and Activity diagrams using MS Visio.
• Assessed the data, functional area impacted because of Dodd frank and reporting requirements..
• Implemented Master Data Management MDM for all entities in the project by maintaining a master hub for improving the data quality by following various data governance techniques and data dictionary standards.
• Created a test plan and a test suite to validate the data extraction, data transformation and data load and used SQL and Microsoft Excel..
• Performed current state analysis/As-is process/to-be model on 'Allocation Model Maintenance usingVisio.
• Assisted the IT team to develop service oriented architecture (SOA), and data warehouse system to utilize data mining for data analysis.
• Interacted with Cash Management Division and Compliance Office to review the AML (Anti Money Laundering) requirements and provide Positive Pay service to reduce check fraud
• Wrote specification to implement application feed for trade-processing lifecycles from pre-trade analysis to post-trade risk management, settlement and regulatory compliance with SunGard's Capital Markets and Investment Banking solution.
• KYC procedures also enable banks to know/understand their customers and their financial dealings better, which in turn help them, manage their risks prudently.
• Performed Data Mapping and data migration from old system to the new one.
• Developed report layouts for Suspicious Activity and Pattern analysis under AML regulations
• Implemented Actimize Anti-Money Laundering (AML) system to monitor suspicious transactions and enhance regulatory compliance.
• KYC guidelines is to prevent banks from being used, intentionally or unintentionally, by criminal elements for money laundering activities
• Manage a team of analysts to complete monthly risk testing and reporting across AML/KYC/Onboarding functions.