SUMMARY:

• Senior Business Analyst and Project Manager worked with various Investments Banking solutions for more than 13 plus years.
• Worked with Investment Banks and Brokerage Houses (Treasury, front office, middle office and back office solutions)
• D esigned/Implemented Fund Transfer Pricing Engine for Bank’s Balance Sheet - Current Position and Budget/Forecasted Numbers
• Implemented flagship products like QRM, Kondor Plus (Reuters) - Treasury Operations, RiskManager (Risk Metrics) - Value at Risk & Stress tests, and Confidential (ADP).
• Experienced in Business Requirement Analysis and Implementation of third party software: Liaise with various stake holders of bank to get the requirements and come up with various artifacts (like process/data flow diagrams, Traceability Matrix, BRD, FSD, Agile Development Stories) and Liaise with 3rd party vendors for implementing software for the defined requirements.
• Experienced in Process and Data Governance: Maintaining the best data management practices (Data Quality, Consistency, Accessibility, Accuracy and Completeness) & Process Governance: Define and Align the processes, Trouble shoot process failures, Root Cause Analysis, Reconciliation Issues between data feeds, Reengineering the processes to increase the efficiency and/or to rewrite SLA, Replacing (or Minimizing) the manual/error-prone processes to meet 100% Audit/Regulatory (Basel/Internal Controls) requirements, Using tools (Spot Fire and Web Interface ) for Data mapping, profiling, data cleansing, overwriting and monitoring data.
• Experienced in various domains of Investment Banking - Treasury, Asset Liability Management, Risk Management, Fund Transfer Pricing (NIR), Liquidity Reporting, Treasury Data Repositories, and Regulatory Reporting (Basel III - SSFA reporting) internal Operations / GT - Finance / Risk (ALM) and external (Development & Testing teams) customers, Ad-hoc production support at level 3 /4 & Managing and motivating a small team of personnel
• Dealt with Treasury Financial Products such as Fixed Income Instruments & Structured Products and Derivatives (OTC/Exchange traded - Options on Equity, IR Swap, Cap, Floor, Collar & Future,, Repos, Deposits, Overdrafts and Loans)
• Single point of contact, Good Communication, Better Inter Personal Skills, Strong Analytical Ability, Quick & Continuous Learning

TECHNICAL SKILLS:

Operating Systems: Unix and Windows

RDBMS: MS SQL Server, PL/SQL - Oracle and Sybase

SW Tools: ERWIN (Data Design and Modeling), TOADMS Visio, MS Project, MS Office, Spot fire,:

PROFESSIONAL EXPERIENCE:

Senior Business/Data Analyst,

Confidential, State Street, Boston

Responsibilities:

• State Street maintains Data Warehouse, named as Treasury Data Repository (TDR) as the system of record of current position at transaction level from the various source systems (In Trader, Hogan, Wall Street System, Wall Street Office, IBS, ACBS, FDW, QRM, INTEX, Core Logic, Bloomberg) including QRM for forecasted numbers
• Data warehouse with 10 plus (different) Source Systems, 100s of and Dimensional Data, 100s of Reports and Extracts
• GT Data (TDR) is being catered to the different client groups across State Street like Asset Liability Management, Liability Management, Treasury Operations, Global Treasury - Finance, Investment Management reporting and to the FED Reporting Regulatory Liquidity Reporting (4G) and SSFA Risk Weighted Asset reports
• Fund Transfer Pricing (FTP) - FTP Process is an internal profit measurement and allocation system of Global Treasury
• FTP Analytical Engine was built on TDR (Treasury Data Depository)
• Understanding Global Treasury products, Bank’s Balance sheet and their cash flow nuances of various products of the Balance Sheet, available in the Treasury
• Designed and modeled the FTP Analytical Engine for the Current Position and Forecasted Numbers based on Fund Transfer Pricing drivers
• Interacting/Educating with Business Users for studying the impact analysis of NIR/NIM (Net Interest Revenue/Net Interest Margin) of new product lines of Global Treasury and drawn complete process flow
• The comprehensive testing of NIR Analysis - Fund Transfer Pricing Methodologies, Calculating Transfer Spread, Transfer Rate and different components of Transfer Rate (Interest Rate Risk, Term Liquidity Risk …) and their Tax Equivalents
• Integrating different source systems to the Data Warehouse and Automating the manual process
• Working on various reports/extracts and transformations in the TDR
• Working with INTEX & CORE LOGIC Data for SSFA Reporting
• Maintaining the best data management practices (Data Quality, Consistency, Accessibility, Accuracy and Completeness) & Process Governance: Define and Align the process, Trouble shoot the process failures, Root Cause Analysis of the event, Reconciliation Issues between data feeds, Reengineering the processes to increase the efficiency and or to rewrite SLA, Replacing (or Minimizing) the manual/error prone-processes to meet 100% Audit/Regulatory (Basel/Internal Controls) requirements, Using tools (Spot Fire and Web Interface ) for Data mapping, profiling, data cleansing, overwriting and monitoring data internal Operations / GT - Finance / Risk (ALM) and external (Development & Testing teams) customers, Ad-hoc production support at level 3 /4 & Managing and motivating a small team of personnel

Risk Analyst,

Confidential, NY

Responsibilities:

• QRM Asset/Liability Management System - Implementation for Confidential Treasury
• QRM - AL Management - is one of the comprehensive Risk Management products in the Industry. One of the key features of QRM is User Customized Modeling of Cash Flow at Data elements level
• Understanding Confidential Treasury Products and Modeling their cash flow Loans, Assets, Funding
• Convincing Business Users/Validating with Benchmark Reports by explaining nuts and bolts of Cash Flow Explaining Variable / Fixed Rate Instruments’ Cash Flow, Scheduled Principal, FAS91 Amortization, Runoff (Sinking Fund Schedule), Default Cash flow, Market Rate Configurations, Rate reset rules, Shocking Scenarios, Significance of various data elements from the source data and their extraction business rules, QRM System - User defined equations & other computed line items
• Testing and Validation of requirements for RISK Valuation / Interest Rate Exposure and Finance Forecasting for NIM teams
• Creating excel prototypes QRM system Vs Manual to get sign off for the implementation UAT / Parallel Phase
• Maintaining and upgrading expert level understanding while interaction with Business Users, QRM-Vendor & Supervisors at Citi
• Supporting all stake holders of the project

Senior Business Analyst,

Confidential, Boston

Responsibilities:

• Creating Treasury Data Repository (TDR) from various source systems for Treasury Applications and reconciling with GL (Oracle Financials - Data Warehouse)
• Studying various source systems and writing functional specification / Business Rules / Traceability matrix for TDR
• Writing functional specification for GL Reconciliation - TDR Vs Financial Data Warehouse
• Meeting with business users for getting their requirements / manual practices / validations and to create automated system
• Analyzing the various databases for sourcing the information for TDR
• Dealt with Instruments like Equities, Money Market Instruments, Forex & Demand Deposit products…

Senior Business Analyst,

Confidential

Responsibilities:

• Detail instrument level mapping between Kondor plus and Risk Manager to develop the interface
• Dealt with wide range of Instruments like Equities, Money Market Instruments, Forex, FX OTC options, Interest Rate Derivatives like FX Cap, FX Floor, Swap (IRS & CIRS), Amortizing Swaps Swaption, FRA
• Managing team of professionals to develop the interface & to implement the RiskManager as per preplanned project schedule
• Interacting with business users/Vendor to resolve the issues
• Implementation of the RiskManager
• Support/Assist Business Users for effective usage of RiskManager Application

Technology: Visio, MS Office, Power Builder, C and Sybase

Senior Member Technical

Confidential

Responsibilities:

• Confidential is a real-time - STP system which automates the trade processing life cycle from order capture and trade execution through confirmation, reporting to the clearing agency and settlement
• Issue / Case Analysis (Enhancement / Bug fixing), Preparing and testing of solution kits for Confidential
• Giving on Business Processes of Brokerage Services and lead the new graduates for case analysis
• Effective participation in QMS activities for SEI CMMi

Senior Member Technical,

Confidential,

Responsibilities:

• To build Foreign Exchange (FX) Module - Order Management System / Risk Management over the existing product called AutoDeal+

Business Analyst,

Confidential,

Responsibilities:

• ARMADA- Automated Risk Management And Decision Analysis. This is system to monitor the Risk Exposure of the Stock Broking Companies of KLSE
• Writing functional specifications of the System, based on business rules laid by Clients
• Modeling thru’ Rational Rose tools
• Educating onsite / offsite teams on the project
• Writing Unit Test Case / Integration Test Cases

Technology: Dot Net and MS-SQL Server with Rational Rose Practices

System Analyst,

Confidential,

Responsibilities:

• To maintain lower level operational risk by tracking exposures in real time across Multiple Products, Regions, Markets/Exchanges and Clients
• Effective Treasury management across all Business Units ( Confidential Offices and Branch Offices) and across all Business Lines (Equities, Derivatives, Depository Participants with multiple exchanges)
• More streamlined and cost - efficient clearing & settlement processing across the enterprise using a centralized data base model across multiple branches, sub-brokers and other associated trading entities
• Designing Futures and Options module (Indian Market) for the seamless integration with core Spectrum GS
• Design and Development of Trade Engine, Brokerage Engine, Collateral Management System, Margin Collection and Margin Allocation (Auto Allocation)
• Design with Modeling Tools and writing Use Cases to exhibit the functionality of the module
• Preparing Test Model and writing test cases for the whole module
• Defining the requirements, Studying the impact analysis, Designing the functionality for incorporating with the existing Product
• Managing the team of professionals to create and maintain the application

Confidential,

Responsibilities:

• Creating functional Specification for on line Risk Management System for Indian Stock Market & Creating On line Surveillance System (Risk Monitors / Alerts) for the Clients and Brokers
• Interacting with Thailand team of Reuters India Limited for preparing detailed Functional Specification
• Preparing comprehensive test plan, test cases and test data for the whole ASP System which includes Order Management System, Export - Import Interface System, Risk Management System