SUMMARY

• Senior level business analyst with 6 years experience in requirement gathering, data warehouse, quality assurance and testing in banking and IT.
• Extensive knowledge in Software Developing Life Cycle (SDLC) and software development methodologies such as Waterfall, RUP and Agile in mid - to large-sized projects
• Experience in project management functions including preparing project plan, project milestones, project timeline, cost benefit analysis, feasibility study
• Proficient in gathering and analyzing user requirements, data requirements, usability requirements, user interface requirements, etc.
• Strong writing skills with expertise in preparing Business Requirement Document (BRD), Functional Requirement Document (FRD), Software Requirement Specification (SRS) across the deliverables of a project.
• Skilled in defining the data requirements, constructing Requirement Traceability Matrix, preparing data flow diagrams, data analysis, data dictionaries and data mapping
• Expertise in data visualization using UML to build Use Case Diagrams, Class Diagrams, Activity Diagrams, Sequence Diagrams
• Experience in writing complex SQL queries using PL/SQL Developer and Toad.
• Experience in working with QA team in implementing unit testing, integration testing, system testing, regressing testing, performance testing and developing Test Plans, Test Cases
• Hands-on experience with conducting User Acceptance Testing (UAT) sessions with UAT training manuals
• In-depth knowledge and experience in Equities like Stocks and Preferred Stocks.
• Good understanding of Fixed Income Instruments like Bonds, MBS, CMO and bonds analytics like duration, convexity, partial durations, OAS, etc..
• Excellent understanding in Option Greeks like delta, gamma, theta, vega & Rho. Good working knowledge in Black Scholes Option Pricing Model.
• Involved in gathering requirements for alerts for various Actimize models, including Trade Surveillance, AMLDomain models, Involved in testing various alerts, configuring thresholds and monitoring exception reports.
• Involved in Actimize for trade surveillance (Parking, wash, Price analysis, AML - SAM).

TECHNICAL SKILLS

Proficiency in MS Office: Word, Excel, PowerPoint, Access, Visio, Project

Operating systems: Windows, Macintosh

Database: MySQL, Oracle, PL/SQL

Methodologies: Waterfall, Rational Unified Process (RUP), Agile

Programming Language: SQL, C, JavaScript, HTML, Visual Basic, Python

Tools: HP Quick Test Professional, IBM Rational Functional Tester, HP Quality Center, JIRA(Atlassian)

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

Sr. Business Analyst

Responsibilities:

• Analyzed the complex analytics requirements for OTC Options and Bonds and prepared Data Mapping and Data Dictionary Files.
• Coordinated with upstream providers of analytics and security reference data for equity, fixed income and derivatives to oversee data integrity
• Assisted project manager with identifying project scopes, deciding project participants and preparing project timelines.
• Created mockups and wireframes for analytics and report Aggregation Engine.
• Led scrum meetings as a scrum master to share opinions and track sprint tasks by analyzing Burndown charts
• Conducted Joint Application Development (JAD) sessions with project manager users, developers, quality analyst, legal & compliance representative, and data architect for discussing and identifying issues so that the requirements are clear, concise and unambiguous.
• Broke down the requirements into functional and non-functional requirements to ensure the requirements are buildable, testable and traceable
• Worked with user group in understanding the requirements and various complex financial calculations.
• Assisted in developing QA test strategies and Test Plans /test cases and continuously keep the track of defects identified and prepare the defect trends.
• Managed the change requests and requirements throughout the project life cycle (PLC) - Initiation, Planning, Execution, Control and Closure.
• Developed and Implemented Requirements Traceability Matrices, Project Status reports, Issue/defect management, UAT test plans and User Training documents.
• Organized and executed UAT testing.
• Successfully completed the User training sessions, deployment, production testing and closures.
• Responsible for Issue resolution & developing the issue escalating procedures.

Environment: MS Excel, PL/SQL, Agile, JIRA, IBM Rational Functional Tester

Confidential, Greenwich, CT

Sr. Business Analyst/PM

Responsibilities:

• Involved in developing project plans and project charter along with the schedules.
• Leading a team with multiple projects off shore and giving directions as required to comply timelines and deliverables
• Gathered business requirements through sessions and analysis by interviewing users and subject matter experts (SME) for equity cross reports
• Created a prototype in excel for each rule in Alert monitoring reports and analytics to validate logic provided.
• Involved in on-boarding data from 12 source system and validate based on system requirements, involved in cleaning the data and maintaining day to day calls with upstream for data requirements
• Analyzed Compliance requirements and identified functional and non-functional requirements.
• Prioritized the requirements, developed effective and unambiguous Business Requirement Document and translated them into Functional Specifications.
• Conducted (JAD) Joint Application Development sessions with cross-functional team members for discussing various shared issues to ensure that the business objectives are met with and requirements are understood clearly at all levels.
• Involve in analyzing the data by querying the database, CDC using SQL and run scripts for day to day reports.
• Involved in creating data mapping documents, data dictionary and data validation across the model
• Involved in developing project plans and project charter along with the schedules.
• Implemented business rules to measure, analyze, improve and control business workflow of fixed income reporting process for Futures data using Excels Macros.
• Used SQL queries/scripts for Fixed Income data warehouse and security master.
• Developed the test plan, test conditions and test cases for Compliance UAT and conducted UAT testing in batches
• Involved in production support for all above models from technical as well as functional side.

Environment: Windows, TOAD, MS Project, MS Visio, UML

Confidential, Newport, CA

Business Analyst

Responsibilities:

• Coordinated with upstream providers of analytics and security reference data for equity, fixed income, and derivatives to oversee data integrity and ensure that the risk systems were being provided with all required data for calculating Market & Credit risk.
• Wrote Business Rules and Constraints and actively participated in the entire ETL process.
• Performed and written various data checks, validations and calculations at the master database level to ensure that data quality and integrity for the calculation engine.
• Act as a support team lead in supporting the applications with major issues regarding the specific reporting requirements and complex analytics calculations.
• Gathered business requirements through sessions and analysis by interviewing users and subject matter experts (SME).
• Conducted JAD sessions and translated the user requirements to system specifications.
• Interact with end users to understand their workflow process, calculation processes and requirements.
• Responsible for data mappings, data dictionaries and data validations.
• Assisted the project manager in defining the project plan, charter, scope and timelines for completion of project.
• Worked with user group in understanding the requirements and various complex financial calculations.
• Assisted in developing QA test strategies and Test Plans /test cases and continuously keep the track of defects identified and prepare the defect trends.
• Managed the change requests and requirements throughout the project life cycle (PLC) - Initiation, Planning, Execution, Control and Closure.
• Developed and Implemented Requirements Traceability Matrices, Project Status reports, Issue/defect management, UAT test plans and User Training documents.
• Organized and executed UAT testing.
• Successfully completed the User training sessions, deployment, production testing and closures.
• Responsible for Issue resolution & developing the issue escalating procedures.
• Business continuity & disaster recovery planning & testing.

Environment: MS Office, Oracle, HP Quality Center, Java

Confidential, San Francisco, CA

Business Analyst

Responsibilities:

• Retrieved Fixed Income data through SQL with backend in oracle.
• Gathered business requirements through sessions and analysis by interviewing users and subject matter experts (SME).
• Managed the requirements and requirement change requests through JAD during entire SDLC.
• Implemented business rules to measure, analyze, improve and control business workflow of fixed income reporting process for Futures data.
• Designed SQL training manual for the team and conducted training sessions.
• Involved in developing GUI interface for reports and maintaining documentation.
• Developed the test plan, test conditions and test cases for UAT and conducted UAT testing Developed and Implemented Requirements Tractability Matrices, test case mapping to requirements, Project Status reports, Issue /defect matrices, UAT test plans and User Training documents for derivatives risk.
• Developed the release checklists and participated in implementation and deployment plans.
• Used SQL, MS Word, Oracle, Stored Procedures, MS Excel, MS Visio and MS PowerPoint throughout the software development life cycle (RUP).

Environment: SQL Server, MS Office, WinRunner, RUP, WIndows