SUMMARY

• Experience performing Business Analysis work for multi - tier Banking, Pricing, and Trading Applications within Commercial Banking, Wholesale Banking, Money Market, Capital Market, and Investment Banking Technologies
• Working experience in Software Development Life Cycle (SDLC) including SDLC methodologies - Agile and Waterfall
• Experienced in writing Business Requirement Documents (BRD) and Functional Requirement Documents (FRD) after collecting the requirements from the stakeholders
• Performed GAP Analysis and Impact Analysis involving current and proposed state of the applications and provided feedback for improvement
• Collaborated with stakeholders to obtain requirement sign-off and managed the requirement changed request after the sign-off
• Elicited and documented requirements as user stories in TFS, QC/ALM, & JIRA
• Experienced in developing detail use case documents and data dictionary
• Experienced in creating prototype/mockups and application flow diagram
• Worked with SMEs, technical teams, and other functional teams throughout project life cycle
• Experienced in writing complex SQL queries and advanced excel formulas
• Experienced working with cross-functional team to complete project work
• Experienced working with internal and external trading applications/Order Management System (OMS) including Confidential Bond Market, MLEdge, ECNs (i.e. Trade Web, Knight BondPoint), Bloomberg
• Experienced working in Trade Lifecycle from Order Entry to Order Execution to Trade Booking
• Experienced working with reference data and Bloomberg market data
• Experienced working with Fixed Income Securities (i.e. Corporate Bonds, CMO, MBS, Certificate of Deposits, Commercial Paper, Market Linked Investment, Structured Products, T-Bills, and etc.) and equities
• Excellent understanding of the Fixed Income Product Pricing and its underlying factors
• Extensive knowledge about financial derivatives such as options, future, forwards, & swaps
• Excellent understanding of the Option pricing models (black Scholes/binomial) and options trading strategies
• Excellent understanding of market risk, credit risk, interest rate risk, & other risks in financial market
• Experience working with messaging infrastructure such as Tibco RV, MQ Series messaging, and XML messaging
• Knowledgeable about FIX Protocol/ FIX Messages
• Experienced working on firm wide broker dealer separation (BDS) project
• Experienced in developing QA Test Strategy, Test Plan, Test Scenarios, Test Cases, Test Scripts, RTM and Test Data
• Log and manage defects in HP ALM (QC), JIRA, and Team Foundation Server (TFS)
• Experienced in reviewing trade logs/data/messages on the backend servers using Linux Commands
• Experienced in performing functional testing, smoke testing, integration testing, database testing, back-end testing, user acceptance testing (UAT), and etc.
• Excellent interpersonal and communication skills with the ability to learn quickly and adopting to new technologies and environment

TECHNICAL SKILLS

Tools: HP ALM, HP Quality Center (QC), JIRA, Team Foundation Server (TFS), Quick Test Professional (QTP), TOAD, PuttY, MS Word, MS Excel, MS PowerPoint, MS Visio, Balsamiq Mockups, SharePoint, and etc.

Operating Systems: Unix/Linux, Windows 2000, XP, and 7

Browsers: Internet Explorer, Firefox, Chrome, and Safari

Languages: VBScript, VBA, Java Script, PL/SQL, SQL, XML, HTML, CSS, Python, R, and C++

Databases: MS Access, Oracle, and SQL Server

Environment: s: Agile and Waterfall

PROFESSIONAL EXPERIENCE

Business Systems Analyst

Confidential, New York, N.Y.

Responsibilities:

• Prepared Functional Requirement Documents (FRD) and Business Requirement Documents (BRD) after collecting requirements from Traders, Marketers, and Financial Advisors
• Performed needs assessments and gathered requirements through interviews, workshops, questionnaires, prototype, and etc.
• Elicited and analyzed business requirements, functional requirements, and system requirements in an agile environment
• Performed GAP Analysis and Impact Analysis involving current and proposed state of Confidential Fixed Income Trading Applications
• Worked closely with the stakeholders to obtain requirement sign-off and managed changed request after the sign-off
• Worked with SMEs, technical teams, and other functional teams throughout the project life cycle
• Experience writing requirements involving ECNs and other vendor applications
• Validated trade data through Trade Lifecycle from Order Entry to Order Execution to Trade Booking
• Validated trade data across multiple trading applications including MLM, MLEdge, ECNs (i.e. Trade Web, Knight BondPoint), Bloomberg
• Reviewed the orders submitted through MLM or MLedge are executed against Best Bid and Offer (BBO) Price
• Wrote advanced SQL queries to verify offers, orders, and trades information in database(s)
• Wrote advanced excel formulas to validate trade data across multiple applications
• Analyzed data in trade blotter and reports generated from the system using excel pivot
• Execute stored procedures to verify data in the reports are as per as business requirements
• Utilize reference data and Bloomberg market data to setup offers for products such as MBS, CMO, Corporate Bonds, Retail CD, Commercial Papers, T-Bills, Market Linked Investment, and etc.
• Used HP ALM (Quality Center) to document Test Cases, and JIRA to log and manage defects
• Performed Root Cause Analysis for certain critical issues before development team acts on the issues
• Reviewed back-end inventory/trade servers logs for performing root cause analysis using Linux commands
• Analyze the test results to make sure requirements and exit criteria have been met, and provide QA signoff
• Planned and performed UAT testing and documented any issues found during the testing
• Planned and performed smoke testing before each releases

System QA Analyst

Confidential, New York, N.Y.

Responsibilities:

• Develop, maintain, and execute: QA Test Plan, Test Scenarios, Test Cases, and Test Data through Software Development and Testing Life Cycle using Functional Specification Documents
• Perform black-box testing, functional testing, system testing, regression testing, integration testing, GUI testing, and etc.
• Validate flow of data across multiple integrated applications
• Wrote and executed SQL Queries in Oracle Developers
• Used HP ALM (QC) to log and manage defects with detailed, accurate and concise steps to reproduce

Business Systems Analyst

Confidential, New York, N.Y.

Responsibilities:

• Prepared Business Requirement Documents (BRD) and Functional Requirement Documents (FRD) after collecting requirements
• Documented requirements as user stories in TFS for pricing applications and deal management application
• Performed needs assessments and gathered requirements through interviews, questionnaires, prototype, and etc.
• Performed GAP Analysis and Impact Analysis involving current and proposed state of the application
• Communicated business requirements and functional requirement to development and QA team
• Created prototype/mockups for development feasibility using Balsamiq Mockups and application flow diagram using MS Visio
• Managed release items and work items in TFS
• Performed Root Cause Analysis for certain critical issues before development team acts on the issues
• Partnered with the project stakeholders to manage requirement change requests throughout project life cycle
• Utilize reference data and Bloomberg market data in development of pricing application
• Lead QA Test Strategy, Test Plan, Test Case and defect review meetings with Program Manager, Business Analysts, Developers, and QA Team Members; and worked closely with them to ensure the quality of the product under development
• Demo new changes to the QA team before they can execute the test plan and acted as QA point of contact during testing
• Manage offshore and onshore QA resources
• Planned UAT testing and provided support to the UAT users
• Regularly coordinated with UAT users, and documented/tracked issues found by them
• Developed complex SQL queries to check data integrity and data mapping
• Planned and performed smoke testing before going live

Business Systems Analyst

Confidential, Charlotte, N.C

Responsibilities:

• Coordinated with business and technology partners, and SMEs to identify project scope and deliverables
• Performed GAP Analysis and Impact Analysis involving current and proposed state of the application
• Prepared Functional Requirement Documents (FRD) and Business Requirement Documents (BRD) after collecting requirements
• Reviewed business requirements and functional requirements with development and QA team members
• Wrote SQL queries for data analysis
• Performed Root Cause Analysis for certain issues before development team acts on the issues
• Planned and performed UAT testing and documented any issues found during the UAT testing
• Managed and reviewed defects in Quality Center/ HP ALM