PROFESSIONAL SUMMARY:

• Business Analyst with over 10 years experience in the financial industry.
• Extensive experience in Requirement Elicitation, documenting Business Requirements (BRD), transforming requirements to Functional and Software specifications and documenting Functional Specifications (FSD) and Software Requirements Specifications (SRS)
• In - depth knowledge of Equity Securities (Common Stock, Preferred Stock, Rights, Warrants), Fixed Income Securities ( Corporate Bonds, Treasuries (Bills, Notes, Bonds), Agency Securities (MBS, ABS, CMO, CDO, TBAs), Money Market (CPs, BAs, CDs), Munis, FX, and Derivatives (Options, Futures, Forwards, Swaps - CDS, IRS, TRS, CLN)
• Strong experience with various Software Development Life Cycle Methodologies (Iterative, RUP, Agile Scrum, XP, Incremental, RAD, and Waterfall)
• Experience supporting Data Modeling team, capturing Data Requirements, documenting ER diagrams and creating Metadata Documents - Data Mapping documents and Data Dictionaries
• Proficient in Project Management tasks - working as a liaison between the client and development teams, managing requirements, maintaining issue logs, status updates, and establishing schedules while adhering to the objectives from the project’s inception through deployment
• Strong understanding of the Trade Life Cycle of financial securities from initiation to the settlement
• Hands-on experience performing GAP analysis to effectively identify the existing technologies and document the enhancement to meet the end-state requirements
• Experience in organizing and participating in project meetings such as JAD sessions to obtain project business requirements from subject-matter experts and project stakeholders
• Extensive experience in creating UML documentation such as Use Cases, Activity Diagrams, Screen Layouts, Wireframes, Data Flow Diagrams and Class diagrams using MS Visio and Rational Rose
• Facilitated in creation of documents that helps clients/users to adhere to the Dodd Frank - Volckers Rule
• Strong understanding of Basel II Accord, Dodd Frank compliance to regulate counter-party/systemic risk
• Good knowledge of financial protocols and message formats such as FIX, SWIFT, FpML
• Hands-on experience in executing SQL queries for data validation and generating ad-hoc reports
• Extensive experience in assisting database design team with Data Modeling to construct ER Diagram by developing Conceptual, Logical, and Physical Data models and identifying Data Integrity rules
• Experience supporting QA Testing Team in documenting Test Plans, Test Cases, Test Scripts and conducting application testing such as Functional Testing, Integration Testing, System Testing, Performance Testing, Smoke Testing, Regression Testing and User Acceptance Testing (UAT)
• Proficient in managing Requirements Traceability Matrix to map & track requirements against test cases
• Valuable Experience in the Defect Tracking Life Cycle Management by identifying, logging, evaluating, prioritizing, and documenting defects for the system

TECHNICAL SKILLS:

OS: Windows 2000/NT/XP/7/2010, Mac OS, Unix, Linux

Databases: Oracle, MS Access, MS SQL Server, Sybase, Management Studio

Languages: SQL, PL/SQL, C, C++, JAVA, J2EE, .NET, HTML, VB Script, XML

Languages / Tools: UML, MS Visio, Rational Rose, Erwin

Business Inteligence: Oracle Business Intelligence (OBIEE), Business Objects, QlikView

QA Tools: Quality Center-QC, QTP, WinRunner, LoadRunner, ClearQuest, JIRA

Project Management: MS Office, MS Project, MS Sharepoint, TOAD, Rational RequisitePro, Confluence, Wiki, IBM iLog, Autosys, Tivoli, Rally, Informatica

PROFESSIONAL EXPERIENCE:

Confidential, MI

Lead Business Systems Analyst

Responsibilities:

• Project is using Waterfall methodology (transitioning into Agile Scrum and Six Sigma), documenting the business requirements and business rules in the BRD, IM-BRD and creating Solution Design Documents
• Performed GAP Analysis to identify redundancies in existing business processes and document respective enhancements in the system as per the priority
• Responsible for verifying and testing pre-trade and post-trade compliances; workflows for Fixed Income and Money Market Securities on both Trading Blotter and Manager Workbench
• Assisting the ETL development team by creating Data Mapping document to map data from various data sources (external data feeds) to targets (databases) and help the team understand the set of business rules
• Created Excel templates to emulate the Data Mapping transformation logics into Excel formulas for data validations between two systems, Investment Accounting system and Treasury system (Camra &Aladdin)
• Assisted Project Manager in preparation of Project Plan, Statement of Work, Responsibility Matrix, Detailed Schedule, Resource Allocation, and Budget Plan
• Playing a responsible role as Point of Contact (POC) for both IT and Business Teams with the processes pertaining to the new system (Aladdin)
• Playing a key role as Liaison between end users and development team, facilitated multiple client interactions to gather requirements, and validated these requirements for completeness & consistency
• Facilitated JAD sessions throughout the project in order to communicate and manage expectations with the Business Users, Development Team and Quality Assurance Team
• Using MS Visio to create UML modeling techniques to depict Use Case diagrams, Written Use Cases, Activity diagrams, Class diagrams, State diagrams, and Sequence diagrams to effectively understand the system behavior from the business user perspective
• Designed and implemented complex SQL scripts for data validation testing and back-end testing
• Worked closely with database design team to assist in Data Modeling for development of conceptual, logical and physical data models to interpret complicated Entity Relationships
• Gained exposure to the FIX protocol from reviewing application messages to the matching agent and corresponding actions taken by the equity securities trading system
• Assisted the QA team with the development and documentation of test plan, test cases, and test scripts for performing end-to-end testing, functional testing, integration testing, system testing, GUI testing, regression testing, performance testing, load testing, smoke testing, and user-acceptance testing
• Actively collaborated between end users, development team and QA team to address system issues and identify the appropriate solution. Created the Requirements Traceability Matrix for reviewing and tracking requirements

Environment: Windows, UNIX, MS Visio, MS Project, MS Access, XML Spy, WinSCP, UML, Oracle, SQL, TOAD, JAVA, Quality Center (QC), Selenium, Autosys, QTP, Requisite Pro, .Net, C#, J2EE, Informatica, Bloomberg, Aladdin, Camra, Eagle, Wiki, Bloomberg AIM

Confidential, NY

Sr Business Analyst

Responsibilities:

• Followed Agile SCRUM, documented the business requirements and business rules in the BRD and created the FSD by transforming the business requirements to functional specifications
• Performed GAP Analysis to identify redundancies in existing business processes and document respective enhancements in the system as per the priority
• Responsible for verifying and testing pre-trade and post-trade compliances; workflows for Fixed Income and Money Market Securities on both Trading Blotter and Manager Workbench
• Assisted the ETL development team by creating Data Mapping document to map data from various data sources (external data feeds) to targets (databases) and defined set of business rules
• Assisted Project Manager in preparation of Project Plan, Statement of Work, Responsibility Matrix, Detailed Schedule, Resource Allocation, and Budget Plan
• Played key role as Liaison between end users and development team, facilitated multiple client interactions to gather requirements, and validated these requirements for completeness & consistency
• Facilitated JAD sessions throughout the project in order to communicate and manage expectations with the Business Users, Development Team and Quality Assurance Team
• Employed UML modeling techniques to create Use Case diagrams, Written Use Cases, Activity diagrams, Class diagrams, State diagrams, and Sequence diagrams in Rational Rose, to effectively understand the system behavior from the business user perspective
• Designed and implemented complex SQL scripts for data validation testing and back-end testing
• Worked closely with database design team to assist in Data Modeling for development of conceptual, logical and physical data models to interpret complicated Entity Relationships
• Gained exposure to the FIX protocol from reviewing application messages to the matching agent and corresponding actions taken by the equity securities trading system
• Assisted the QA team with the development and documentation of test plan, test cases, and test scripts for performing end-to-end testing, functional testing, integration testing, system testing, GUI testing, regression testing, performance testing, load testing, smoke testing, and user-acceptance testing
• Managed the entire Defect Tracking Life Cycle by identifying and logging defects, evaluating and prioritizing defects to ensure a bug-free application
• Actively collaborated between end users, development team and QA team to address system issues and identify the appropriate solution. Created the Requirements Traceability Matrix for reviewing and tracking requirements

Environment: Windows, UNIX, MS Office, MS Visio, MS Project, UML, Oracle, SQL, TOAD, JAVA, Quality Center, QTP, Requisite Pro, .Net, C#, J2EE, Informatica, Bloomberg, IBM iLog, Wiki

Confidential, NY

Lead Business Systems Analyst

Responsibilities:

• Conducted requirement elicitation sessions to gather user requirements and was responsible for design, development and ownership of BRD; translated requirements to system specification and documented SRS
• Created data mapping document for defining data flow between data source and target along with business rules and assisted the ETL development team in setting up data integration process
• Conducted Project Management activities to achieve project milestones such as developing project initiation document, identifying project deliverables, estimating time and cost, resource allocation, developing budget plan, risk plan and detailed work schedule
• Built SQL queries all through the application development process to retrieve data, to generate user’s custom report, and to research underlying data errors
• Employed MS Visio to develop use case diagrams, class diagrams, activity diagrams, data flow diagrams, state diagrams, sequence diagrams, collaboration diagrams, and deployment diagrams to visualize requirements and business workflows
• Performed GAP analysis to document the system’s to-be functionalities in comparison with system’s as-is functionalities
• Participated in JAD sessions; solving problems and documenting new change requirements, researching delays and managing expectations
• Assisted database designers in data modeling and constructing ER Diagrams, by continuous involvement in transition from business data to database models
• Coordinated with the QA team in developing project test plan and test cases for conducting Black-box testing, functional testing, system testing, integration testing, regression testing, performance testing, load testing, and sanity testing
• Coordinated User Acceptance Testing (UAT) with end users and provided necessary training
• Managed defect tracking life cycle by identifying defects, classifying defects (severity and priority), logging defects, generating summary reports to ensure quality software
• Created and maintained Requirement Traceability Matrix to track requirements and testing activities across the project life cycle
• Participated in developing post-implementation documents such as the user manual and training guide for end-users along with providing support on open issues

Environment: MS Project, Requisite Pro, Visual Basic, UNIX, Java, J2EE, HTML, MS Access, Rational Rose, MS SQL Server, Bloomberg, Quick Test Pro (QTP), JIRA, Management Studio, Confluence

Confidential, NY

Sr Systems Analyst

Responsibilities:

• Performed GAP analysis to analyze and document the differences between existing business processes and future business process
• Facilitated client meetings to gather all requirements, formulated business process specifications and application functionalities in order to understand the value proposition(s) of the project
• Designed and documented business requirements; translated them into system specifications
• Created data mapping logic between source systems and enterprise datawarehouse for the ETL development team to effectively perform source system analysis and assess data quality
• Designed business workflow models via UML techniques such as Use Case diagrams, Activity diagrams, and Sequence diagrams
• Responsible for acting as a liaison between technical and business teams for meeting client requirements and clarifying issues to ensure proper understanding
• Drafted SQL queries to extract / access data from Confidential for report validation and testing purpose
• Worked closely with the database development team to assist in constructing data models to interpret the flow of data, also constructed ER Diagrams to distinguish the relationships between entities
• Provided feedback to the development team to facilitate modifications necessary before the final rollout
• Coordinated and facilitated functional testing, system testing, integration testing, performance testing, smoke testing, and user acceptance testing
• Assisted Quality Assurance team in defect tracking by identifying and logging defects in the Quality Center
• Developed a Test Summary Report with a Production Checkout Sign-off after all the test exit criteria were passed
• Identified requirements as Functional or Non-Functional and created the Requirement Traceability Matrix (RTM) for reviewing and tracking requirements

Environment: MS Visio, Requisite Pro, Oracle, PL/SQL, TeraData, Business Objects, .NET, C, C++, C# UNIX, HTML, XML, ClearQuest, Quick Test Pro (QTP), MS Sharepoint

Confidential, NY

Business Analyst

Responsibilities:

• Involved in all the phases of Waterfall Methodology from Requirements analysis to testing and production
• Documented BRDs, SRSs and Use Case document to analyze and understand the business requirements, software specifications, system compatibility and business workflows respectively
• Conducted GAP analysis to analyze, define and prioritize the Business Requirements for the integration of the existing and new systems into the Investment Management Tool
• Co-ordinated work plans between the various Project teams using MS Project
• Used SQL queries for generating ad-hoc reports, data analysis, and data reconciliation
• Assisted the database development team in data modeling and design logical databases to support recommended solutions
• Worked with the Quality Assurance Team to create and manage test cases and reviewed and analyzed the test results
• Tracked & logged Defects for quality assurance purpose and maintained Requirements Traceability Matrix

Environment: s: MS Access, MS Visio, UML, UNIX, Sybase, AquaData, DB Artisan, MS Access, Java J2EE, ASP.Net, C#, C++, LoadRunner, WinRunner, BugZilla

Confidential

Business Analyst

Responsibilities:

• Gathered Business requirements from key stakeholders, clients and subject matter experts
• Created Pivot tables and Pivot charts for tracking and analysis large amounts of data across various dimensions such as products, customers, prices, contacts, activities, assets, opportunities, employees
• Created UML diagrams such as Use Case Diagrams, Activity Diagrams and Sequence Diagrams
• Performed functional testing based on product and business knowledge as well as facilitated UAT testing
• Actively involved in walkthrough sessions and meetings with development team to identify, report & resolve project related issues, defects & enhancements