SUMMARY

• Over 8 years of extensive experience as a Business Analyst in business and functional requirements gathering, analyzing requirements, business process re - engineering, object-oriented design/ modeling and project management in finance and insurance domain.
• Experienced in all financial instruments within investment banking and brokerage environments (Equity, FI, FX, Derivatives, Mutual Funds, Options, Swaps, Asset Backed Securities, Hedge Funds); Basel Risk Management (Credit, Market, Operational); Portfolio Risk (Credit Risk; Market risk across all assets, Obligor Risk Rating, Facility Risk Rating, Statement Forecasting, Stress Testing PD); Trading, Settlement and messaging concepts (Trade lifecycle, Straight through Processing and SWIFT).
• Expert in writing documents like Business Requirements, Functional Requirements that match Technical system setups, front/ middle/ back office, and Use Case, Vision, Scope and Project Plan Documents. in using MS office applications for day to day activities, MS Visio for drawing flow diagrams and MS Project for prioritizing and managing individual tasks.
• Proficient in creating UML diagrams like Use Case Diagrams, Activity, Sequence, Collaboration, Class, State, Workflow, Process flow, Dataflow and Deployment Diagrams.
• Proficient in creating mapping spreadsheets, Source to Target mapping documents including the transformation rules.
• In-depth understanding of Software Development Life Cycle, Rational Unified Process, Product Data Management and QA methodologies such as making the Test Plans conducting the User Acceptance Test and creating & executing Test Scripts/ Test Cases.
• Experience in writing SQL queries for the data validation exercises using Oracle SQL Plus, SQL Server and TOAD.
• Experienced in Data quality Management, Data profiling, Data Cleansing, Data Integrity. Also, expert in maintaining reference data and defining transformation rules for load and extract processes.
• Expert in facilitating all levels of management, developers, QAs, stakeholders, business users and off-site teams in JADs, Brainstorm sessions, White Boarding by conferences and WebEx.
• Strong leader and team builder with excellent analytical and communication skills with capability to handle new technologies and situations, dedicated to meet deadlines and provide necessary deliverable and resolve issues creatively by out of the box thinking.

TECHNICAL SKILLS

• MS Windows (2000 XP NT Vista)
• MS Office 2007/2003/2000 (Excel Word PowerPoint Project Visio Access Publisher FrontPage Outlook)
• MS Sharepoint 2007
• Lotus Notes VB 6.0
• Mainframes
• SWIFT
• Basel II
• SQL Server 2005/2000
• Toad
• Oracle 9i/10g
• Adobe CS3/CS2 (Photoshop
• Illustrator
• Acrobat
• Dreamweaver)
• HP (Quality Center 9.2
• QuickTest Professional 8.2/9.2)

PROFESSIONAL EXPERIENCE

Confidential

Business Analyst

Responsibilities:

• Analyzed business requirements and reporting requirements with the help of interactive JAD sessions with upstream, downstream and reporting teams.
• Worked closely with Confidential and FSR teams to finalize the input layout of the data feed files for GIW.
• Performed GAP analysis for existing GIW Data model/Database for various referential and transactional entities and created Data model change requests for the enhancement.
• Worked on data model enhancement/change requests and produced data definition documentation.
• Frequently prepared the change request documents various columns, data length, data types, index and constraint of the tables in that data warehouse.
• Defined the load processing order (hierarchy) for each entity based on dependency check.
• Responsible for the Data mapping documents between source to GIW and GIW to the downstream system.
• Worked closely with the development team to define the data load rule, data processing rules, normalization and transformation.
• Also worked with the development team to define the file processing logic, to combine multiple files, etc.
• Performed Data Validation exercises by running the SQL queries using Oracle SQL Plus and SQL Server.
• Prepared test cases for load and extract processes of the referential and transactional entities.

Environment: Microsoft Office, Windows 95/98/NT/2000/XP/ Vista, Rational Project Viewer, Toad, Oracle SQL Developer, Oracle SQL Plus

Confidential

Business Analyst

Responsibilities:

• Gathered and translated Business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality.
• Derived Functional Requirement Specifications (FRS) based on User Requirement Specification URS.
• Conducted highly interactive JAD sessions with project’s stakeholders such as users, and project management team, identifying and resolving issues.
• Created Data Dictionary for often used retail and technical terminology for benefit of developers and customers respectively.
• Created Entity Relation Diagrams to represent the relationships existing between designs the internal schema of a database, depicting the data tables, the data columns of those tables, and the relationships between the tables.
• Created and frequently updated the data mapping documents. Also created the documents for Data model changes, Data model migration and Data Patch for various attributes.
• Used Data warehousing for Data Profiling to examine the data available in an existing database.
• Resolved the data issues between the source systems and the target system using the Mapping Documents and issue logs.
• Worked closely with different development teams to document file sizes, file processing schedules and the volumetric of each file.
• Created test scripts and test plans and also executed basic SQL queries for testing and report/data validation.

Environment: Microsoft Office, Windows 95/98/NT/2000/XP/ Vista, Rational Project Viewer, Toad, Oracle SQL Developer, Oracle SQL Plus

Confidential

Business Analyst

Responsibilities:

• Gathered Requirements and interacted with Subject Matter Experts to identify, understand and document business needs for data.
• Analyzed and finalized input feed layout for all the entities. Also prepared the data dictionary for knowledge transfer to the development team and future use.
• Performed gap analysis for existing AS-IS Data model/Database for various referential and transactional entities and created Data model change requests for the enhancement.
• Defined very complex logic for the load process of securities (Funds) in which defined rules for ISIN, CUSIP and SEDOL.
• Defined the load processing order (hierarchy) for each entity based on dependency check.
• Developed the data mapping documents for all entities, i.e. accounts, investor-distributor, funds, transactions, foreign exchange rate, dividend balance, calendar, etc.
• Performed data validation exercise for all the load processes, maintained the issue log of data validation issues and fixed such issues working closely with the development teams.
• Also prepared the documented SQL queries for the Production Website and validated the same.
• Responsible for troubleshooting the issues reported by the development team in a timely manner.
• Facilitated User Acceptance Testing (UAT) using HP Quality center with the stakeholders and the business users, and the errors discovered were fixed and then verified via regression testing.
• Acted as a liaison between the development team and the business and worked on resolving the issues reported.

Environment: Windows, MS Office(MS Word, MS Excel, MS Access, MS PowerPoint, MS Visio), UML, SQL, SWOT analysis, GAP Analysis

Confidential

Business Analyst

Responsibilities:

• Responsible for managing and maintaining relationships with clients as they pertained to new enhancements, GAP analysis, monthly reporting, and current expectations.
• Defined program and project goals, objectives, products, services, constraints, assumptions, risks and facilitated processes by working with the GIW team to baseline the scope of the work and enable development of the plan.
• Analyzed business requirements and functional requirements from clients and writing of the Data Dictionary, Preliminary and Final Function.
• Created Data Dictionary for often used retail and technical terminology for benefit of developers and customers respectively.
• Responsible for creating the data mapping documents between source to GIW and GIW to the downstream system.
• Also frequently updated and maintained the latest versions of the data mapping documents on the sharepoint website.
• Prepared test data for various entities, various test Cases and performed unit testing exercise using SQL server and Oracle SQL Plus to examine data quality
• Responsible for maintaining the latest versions of all the data mapping documents, documenting all the proposed changes and explain the changes to the development team.

Environment: Windows, MS Office(MS Word, MS Excel, MS Access, MS PowerPoint, MS Visio), Toad, Oracle SQL Plus.

Confidential, New York

Business Analyst

Responsibilities:

• Created Scope Document by analyzing the recommendations of the senior executives, business owners and merger and integration committee members.
• Coordinated and conducted meetings with the business users in the various fields and through that process gain an understanding of the functions of the department.
• From these meetings created standards and procedures. Templates and reporting spreadsheets were also developed for senior managers and MI committee members.
• Created visual diagrams of the process to simplify functional process for the ‘As-is’ state to analyze and find out what is unknown and needs clarification from SMEs.
• Liaised between SMEs, legal, integration and operation departments for Portfolio accounting, Security movement and control (SMAC) responsible for trade, processing, Fee receipts and deliveries, and receive currency/ cash and instructions via various swift messages.
• Performed extensive requirement analysis including data analysis and Gap analysis for functional variances, exceptions and processing rules.
• Worked with operations to design well integrated process flows, workflows, which include personnel and applications/ functionality for end users.
• Multitasked with complex jobs including some very crucial and high risk information assignments.
• Designed and Developed Activity diagrams, Sequence diagrams process diagrams in Microsoft Visio and MS PowerPoint.
• Created and maintained documentation based on formal methodologies and maintain the company’s procedure manual up to date.
• Worked with almost all members of the project team to ensure that the business objectives are met with.
• Identified and translated business rules to detailed specifications and maintenance of such documents and also reviewed class action database to determine usability for specified purpose.
• Developed the test plan, test conditions, test scripts and test cases to be used in testing based on business requirements.

Confidential, New York, NY

Business Analyst

Responsibilities:

• Prepared Roadmap Design of the project for Money Movement and Margin divisions.
• Worked with Investment SME’s, Financial Analysts as well as other business teams on requirements gathering to write the Business Requirements Documents of all the Business Processes.
• Created use case and process flow diagrams.
• Captured existing workflows of Firm Funding, Cashiering, Retail Cash Management, Banking Services, Funds Transfer, Retirement distributions (401K) and Margin divisions and converted all the workflows to Future State Business Designs in the projected Environment.
• Performed gap analysis on the complete current state to the future state.
• Worked extensively on Equity Derivatives, Cash Equities on trading desk.
• Implemented Straight through processing functionality for new OTC/Equity Derivatives - Prime Brokerage business unit.
• Involved in creating the User Interface (UI) Prototypes for various report documents and statements to detail the completion of the clearance transaction.
• Reported weekly status updates to project management and stakeholders.
• Assessed Credit Risk strategies with various internal credit tools and implemented Basel II strategies to augment Credit availability.
• Mapped financial data, general ledger data, loss event data, transaction data and people reference data from source to target database for creating a central Risk Data Repository as required by Basel II reporting regulations.
• Assisted in creating and executing Test Cases/ test scripts and documented all issues identified during the testing phase and ensured that all incidents were discovered, tracked/ resolved and prepared the UA test cases for end-user testing.