SUMMARY

Sr. Consultant / Business Analyst

CORE COMPETENCIES

• Over 10 years of experience in the Securities Capital Markets domain with a background in Technology Strategy, Management Consulting, and Technological Risks.
• Primary experience concentrated in business process reviews, process transformation, software development, business analysis, and compliance review for financial clients.
• Extensive experience in business analysis and consulting in Capital Markets risk management and securities domain especially in Equity fixed income securities valuation and research, trade execution analysis, technical fundamental analysis of securities, risk mitigating techniques, Advance Excel, presentation and Negotiation skills, Status Reporting through Dashboard, Software Product Development and Testing, Agile Scrum and Waterfall methodologies.
• Hands on experience in creating simple to complex SQL queries on Oracle PL/SQL
• Hands on experience in UNIX MS Visio
• Expertise in analyzing and gathering requirements and translating into optimal business solutions through business and functional requirements document. BRD FRD
• Experience in creating Use Cases, Use Case Diagrams, Data flow diagrams and Entity Relationship Diagrams.
• Microsoft Office 2010, Microsoft SharePoint 2010 Sybase.

PROFESSIONAL EXPERIENCE

Confidential

Business Analyst

• AIS project aims to provide application maintenance and support for various applications used by the Bank in a timely and organized manner through a dedicated 24 X 7 team available to handle any queries/ issues arising from the end users.
• Brainware Distiller is a product suite designed by Brainware, Inc., to automatically process incoming documents. Brainware Distiller works with any document that is electronically available including scanned images, faxes, e-mails, and files.
• Gained comprehensive understanding of client operations, processes, and business objectives and utilize that knowledge on engagements.
• Supervising the Alternative Investments IT team to provide round the clock IT support and maintenance for 2 proprietary products of the Bank dealing with 200 Private Equity and Real Estate Investments made by large funds.
• Inducted the offshore team of 3 people from India into the project to support the application 24 hrs. and provide the issue resolutions in shortest possible time.
• Analyzed and tested the various customization and enhancements sought within the application to meet client needs and delivering 100 bug free releases.
• Working on applications Interchange VCx , MyStateStreet.com Vision Explorer.
• Reviewed operational, financial, and technology processes to provide management with an assessment of overall effectiveness and efficiency of processes and risks, as it pertains to IT governance and internal controls.
• Managed the project artifacts using Remedy, ISM Integrated Service Management and SharePoint to capture, trace and manage requirements through traceability matrix and defects during the projects lifecycle.
• Conducting Training sessions for business users to walk through of this new web based application for generating the client reports as per the requirements.
• Delivering the timely daily and weekly status to senior management apprising them of ongoing activities, reports in progress and issues, if any.
• Brainware Distiller Designer enables you to customize the automatic processing of incoming documents, where the document classes are relevant in an enterprise as well as which information is to be extracted from the classified documents.
• Batches that cannot be automatically processed in their entirety by Brainware Distiller Runtime Server are forwarded to the quality assurance application Brainware Distiller Verifier for manual correction.

Confidential

• The Client On-Boarding team facilitates the integration of institutional clients into the State Street's framework and product-offerings like Street FX, Equities, Futures and Securities Lending, including analysis of client requirements, networking and connectivity, configuration and static data management, certification testing, and production go-live.
• Gathered requirements through interviews and meetings with product owners and business users to arrive at the interface functional design for the engagement
• Documented Data and Process flows using MS Visio.
• Coordinated and participated in business requirements walkthrough and reviews with peers and the client team.
• Authored the FRD document for all data sources/feeds and target systems that need to be mapped.
• Involved in static data management and decomposing report requirements for Futures Commission Merchant FCM module for setup and testing.
• Extensively written and as well as reviewed SQL queries and procedures for client specific reports.
• Acted as project coordinator for a securities lending report workflow automation project through MS SharePoint 2010 from preparing a project plan till delivery.
• Contributed and assisted in product demos, knowledge transfers and Tier 2 support to the business.

Confidential

• This project was focused on various client Dashboards to be automated from MS Excel, PPT, PDF, Word doc other formats of data to a Web portal
• Automation of dashboards of the entire Investment Banking operations Capital Markets
• Training new employee's preparing training materials
• Preparing process maps in MS Visio FMEA for the automation
• Designing user interfaces and preparing functional specifications
• Preparing test scripts / test cases for all the processes
• Conduct and facilitate workshops with business owners and users to gather business requirements
• Analyze existing dashboard templates, files and formats to summarize KPI being measured, their formulas, thresholds etc.
• Draft the BRD Business Requirement Document from scratch in a specified format to facilitate IT development
• Performing GAP analysis following the Systems Development Life Cycle SDLC
• Measuring and tracking offshore vendor performance across multiple business areas
• Preparing high end reports PPT excel for the client Top management
• Training new employee's preparing training materials

Confidential

• Claims is the backbone for Sears which is the finance accounting division of sales happening in Sears. NCC takes care on filing the claims to the respective consumer, insurance company or any other 3rd party.
• Have experience in doing excellent documentation on business requirements
• Expertise in System design and development required for business process
• Vast Experience in Project and Operations Management
• Make sure all the claims are submitted to the respective vendors on time follow-up for the payments.
• Prepared the process maps for all the new processes in MS Visio both AS-IS TO-BE .
• Prepared the FMEA Failure Mode Effect Analysis for all the processes.
• Prepared training materials for the new employee's trained.

Confidential

• In a part of Reconciliation project migration from Credit Suisse bank, Singapore to Wipro, Pune, India
• Matching and tagging of items to the concerned department.
• Prepared process manuals for cash reconciliation.
• Querying to agent banks through Swift messages.
• Hands on experience in Intellimatch Merva Query System MQS .
• Private Bank Funds Transfer return of funds Singapore
• Reconciliation of Nostro a/c's for all CCY's
• Identify and resolve the payments, which are not settled and outstanding in Nostro A/c.
• Liaising with Counterparty and clients for constant follow up of the cases statements .
• Importing new GL and also updating the GL in PeopleSoft financials.
• Downloading the GL from PeopleSoft and reconciling them with the statements.

Confidential

• Update Bank Holidays for a year across different systems and locations.
• Recommended valid controls and enhancements are in place to mitigate system deficiencies.
• Actively supported in migrating Singapore Op-table SBS system maintenance activities.
• FX Rates, Static Data, Holidays CCY setup done in Globus.
• Maintained an up-to-date settlement instructions database for FX and MM products.
• Handled SWIFT messages and broadcasts.

Confidential

• Worked in the Pilot batch of CBNA which are Check collections, Mortgage release and Debit Cards
• Worked in US Mortgage for 2 years 6 months which includes all the 50 states in the USA
• Liaise with the clients for all Checks related queries and for new process updates.

------------------------------------------------