SUMMARY

• A result oriented professional with over 10 years of experience in the financial services industry including in Investment Banking, Securities and Capital Markets domain covering business requirements gathering, analysis, documentation, testing, data mapping and analysis, securities trade processing at various stages of trade life cycle and other common functions like trade reconciliations.
• Solid requirement capture and functional and technical analysis experience working with data, providing analysis, mapping, effort estimates and reporting on several projects.
• Having sound understanding and an in depth knowledge of the software development life cycle and database concepts like design, tables, functions, stored procedures, triggers.
• Good at writing SQL queries, conducting code reviews, preparing and executing database scripts and taking care of code deployment process.
• Well versed with back office and middle office operations especially handling trade confirmations, setting up trade instructions and trade settlement and post settlement activities with strong fundamentals in Investment Banking & Capital Markets.
• Possess sound knowledge of financial markets with hands on experience in managing a wide array of financial products like Equities, Foreign Exchange & Money Markets. Also possess good knowledge of Fixed Income and Derivatives.
• A thorough professional with a proactive attitude having proven track record of accomplishment for meeting deadlines and submitting deliverables and imparting training to operations and development team members and delivering project/status reports.
• Had done MBA (major in Finance) and possess exceptional research and problem solving skills, sound decision making capabilities coupled with excellent interpersonal and communication skills.

TECHNICAL SKILLS

Operating Systems: Windows 95/98/2000/XP/7, DOS, UNIX

Management Tools: MS Visio, Word, Excel, PowerPoint, Outlook

Software Tools: CVS, IBM Rational Clear Quest & Clear Case, Build Forge, PuTTY, WinSCP

Defect Tracking Tools: Clear Quest

Databases: EXADATA, Oracle Database, Sybase

Development Tools: SQL Developer, Eclipse, Microsoft Office, Microsoft Visio

Programming languages: SQL

Domain skills: Investment Banking / Securities and Capital Markets.

Testing concepts: Had good exposure in System Integration Testing, Functional Testing, Regression Testing, Adhoc Testing, Performance Testing and User Acceptance Testing (UAT).

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

Senior Business Analyst

Responsibilities:

• Capture client specific requirements of each report, analyse the efforts required and provide an estimate to the client for approval.
• Convert reporting requirements into technical specifications; prepare functional specifications document and get sign - off from business users.
• Make data analysis and map various fields on the customized client specific reports to the specific columns in database tables that hold the required data.
• Identify the tables, table joins and filters to use in order to query the database to fetch the desired results on the report.
• Validating the data retrieved on the reports to make sure all expected trade, price, security and valuation data is picked up on the report and under each of the reporting field data is being displayed as per the each individual field requirements.
• Identify the requirement changes in existing reports, analyse the impact of changes and risks involved in making the requested changes and take pre-cautionary steps not to impact other clients’ reports.
• Write SQL queries with required columns, tables and filters and pass onto developers for further coding and development.
• Perform code review, re-review and provide comments for developers to make changes if required.
• Prepare and review the database scripts, take necessary approvals and execute database scripts to configure newly developed reports.
• Prepare table scripts and function scripts and raise tickets with DBA team for processing.
• Support the development team in day to day activities and provide the technical and functional clarifications.
• Create sample data suitable to test various scenarios, create and execute test cases, generate reports and perform data analysis to validate requirements, identify gaps and data issues.
• Attaining necessary approvals for code releases and taking care of deployments activities and informing business users when the code is promoted to the respective environment for testing.
• Creating autosys batch jobs using JIL scripts and monitoring newly created jobs to make sure reports are generated and delivered to the intended business users without any issues.
• Follow-up with business users on newly developed reports and seek business sign-off for promoting to the higher environment.
• Provide clarifications on issues raised by users and provide defect analysis and code changes required and timely resolution.
• Work on performance improvement of queries taking longer time or suggest alternate approaches to improve customer satisfaction.
• Access and read the applications logs from the server to debug the code related or any other technical issues.
• Identify and make any code and/or configuration changes due to any database related migrations and/or server migrations and provide support for smooth transition.
• Able to use the PuTTY to read logs or perform other activities like moving or copying a file, creating a folder etc., using UNIX commands.
• Support onsite - offshore coordination and client and business users’ interaction and provide weekly status updates to the client manager.
• Support business users in BUAT/CUAT testing and address the concerns raised appropriately.
• Prepare and maintain all audit related documentation and support any internal and external audits.

Confidential

Business Analyst

Responsibilities:

• Read the BRDs and understand user expectations and raise clarifications with stakeholders and document functional requirements.
• Read and review the Functional Requirements Specifications Documents of various transaction types (USD Wire Payments, DELPAY, RECPAY, DELFRE, RECFRE, FX, CM, etc) prepared by onshore/off shore business analysts, understand the requirements, provide comments and make amendments if required and attain the final sign-off from the business users.
• Prepare high level workflow diagrams and UI screens using MS-Visio and prepare the wire frame documents in detail based on Functional Requirements Specifications Document to make it easier for the technical team to understand the requirements and develop the application.
• Giving Knowledge Transfer to the development team on Functional Specifications.
• Act as SPOC for any requirements related issues and coordinate with business users for any clarifications whenever required.
• Identify all possible test scenarios for each transaction flow and prepare Functional Test Cases of various transaction workflows, review and implement the comments received from business SMEs and attain the final sign-off from business users.
• Validating the requirements during the development (intermittently) and testing (FT) phases.
• Provide clarifications to developers and testers on requirements to achieve the desired output.
• Provide high level estimates for requirements phase on ‘Change Requests’ received from client.
• Coordinate and handle Functional & Regression Testing and raise defects in defect tracking tool ’Clear Quest’ and track them to closure.
• Assist business users in User Acceptance Testing and clarify to users on functionality, analyse the defects raised by the users, make the developers to understand the defects as intended and ensure the defects are fixed correctly, re-test them and coordinate with users to track the defects to the closure.
• Prepare and review user guide documents, incorporate the comments received from users and get final sign-off from them.

Confidential

Senior Analyst

Responsibilities:

• Provide operational support to Confidential AG London equities business in Canada, Mexico, Brazil and Chile markets.
• Assess the flaws in the existing ‘as-is’ process maps and make clear recommendations of business process changes and incorporate them in the future ‘to-be’ process maps.
• Handle trade confirmation tracking, pre-matching, investigation and resolution of discrepancies.
• Instruct trades through SWIFT (MT540, MT541, MT542, MT543, and MT599).
• Manage SWIFT payments (MT202), wire payments and SPOs, exceptions, funding trades and coordinate with stock borrow / loan team to cover short positions.
• Ensures trade settlement, posting of all settled trades, daily reconciliation and resolution of stock & cash Breaks.
• Regularly interact and coordinate with Trade Support, Trade Booking team, Local agents or Sub-Custodians, Counterparties, Confirmations team, Inventory management group, Conversions team, Stock Loan & Borrow support and settlements, Corporate Actions team, Client aligned settlement support, ETF & ETD support, Programming & Proprietary trade support, Interest Claims team, Prime Brokerage team, Cash Management (Funding) team, Controls team, Static data management team, Buy-in department and other departments to ensure a smooth and efficient workflow.
• Prepare and submit daily MIS reports (Morning flash report, Fails risk report, Dash board) to the onshore to allow them to understand the process performance and analyse risk factors and action accordingly.
• Take up daily calls in the morning and at COB with onshore manager to discuss on all issues and complete EOD check list to ensure no process related activities are pending for the day.

Confidential

Senior Process Executive

Responsibilities:

• Handle Foreign Exchange & Money Markets Pre-Settlement Confirmation-Matching process with least or no guidance.
• Receive FX / MM client SWIFT confirmations (MT 300, MT 320, and MT 330) into the host system and identify exact pair of host and client confirmations which are not auto-matched and match them manually.
• Identify the real differences in close-fits between host and client confirmations and take action either to match or investigate and report as fails to the client.
• Follow up on fails until amended confirmations are received matched perfectly with no issues.
• Seek for confirmation from client or host where other side confirmation is missing to match.
• Identify the Nostro breaks, report to the client, investigate and resolve them promptly.
• Provide the operational support to Confidential Bank AG, Frankfurt by supporting the following MM & FX products.
• Money Markets: Loans, Deposits and Call Accounts.
• Foreign Exchange: Spot & Forward Trades, Swap Trades, Treasury Trades, FOREX Options (Spot & Forward Trades), Non-Deliverable Forwards and Prime Brokerage Trades.