SUMMARY

• Result oriented professional with 9+ years of experience in financial domain as Business Analyst as well as Business System Analyst.
• In - depth knowledge of Equities, ETFs, Mutual Funds, Options, Fixed Income, Forwards, Futures, Swaps, Collateralized Debt Obligation (CDO), Collateralized Mortgage Obligation (CMO), Asset Backed Securities (ABS), Mortgage Backed Securities (MBS), Credit Derivatives (Credit Default Swap (CDS) and Stock Plan Services.
• Strong experience in application development employing various Software Development Life Cycle (SDLC) methodologies such as Agile Scrum, Waterfall and good knowledge on RUP and RAD.
• Proven expertise in interacting with business team as well as technology to analyze, assemble, and document Business Requirements Documents (BRD); and identified and transformed into Functional Specification Documents (FSD).
• Expertise in identifying requirements as functional / non-functional and created Requirement Traceability Matrix (RTM) for reviewing and tracking requirements.
• Hands on experience in performing GAP analysis to effectively identify existing technologies and document development to meet desired end state.
• Expertise in organizing & participating in project meetings such as JAD sessions to obtain business requirements from project stakeholders and subject matter experts.
• Constructed Data Mapping documents to setup the data load process for data feeds sourced from Bloomberg, Reuters, and Telecurs into Security Master Database.
• Extensive experience in creating UML documentation using MS Vision such as Use Cases, Activity Diagrams, Business Workflow Diagrams, Class diagrams, Sequence Diagrams, and Data Flow Diagrams.
• Extensive experience in executing SQL statements with databases like Oracle, MySQL, and Sybase to conduct data analysis and generate user reports.
• Experience in analyzing risks such as Interest Rate Risk, Default Risk, Volatility Risk, Inflation Risk, Market Risk, and Credit Risk associated with instruments in various markets.
• Excellent work experience and proven track record for executing application development process in Retail, Commercial & Investment Banking, Mortgages, Brokerage and FX trading.
• Good understanding of financial networks & protocols like FIX, SWIFT and FpML.
• Knowledge of financial regulatory compliances like Dodd Frank and Basel II / III.
• Strong understanding of trading lifecycle for various financial products from initiation-to-settlement.
• Experience in actively liaising between end users, development team, and QA team to address system issues and identify the appropriate solution.
• Proficient in supporting QA team in documenting Test Plan, Test Cases, Test Scenarios, Test Scripts to conduct application testing - Functional Testing, Integration Testing, System Testing, GUI Testing, Performance Testing, Load Testing, Stress Testing, Smoke Testing, Regression Testing, and UAT.
• Hands on experience with test management and defect tracking tools such as HP Quality Center Test Director, Bugzilla, JIRA, Rally and Rational Clear Quest.

TECHNICAL SKILLS

Operating Systems: Windows 2000/NT/XP/7, Mac OS, Unix

DBMS: Oracle, MS SQL Server, DB2, DW, MS Access, OBIEE, IBM Mainframe, RUMBA

Languages: C, C++, C#, HTML, Java, Java Script, XML, VB Script, .NET, SQL, PL/SQL

Defect Tracking: Quality Center, Rational Clear Quest, JIRA, Rally, QTP

Testing Tool: Quality Center, QTP, Rally, ALM, JIRA, Rational Team Concert, SOAP UI

Other tools: MS SharePoint, MS Visio, Rational Rose, J2EE, Notepad++

PROFESSIONAL EXPERIENCE

Confidential, OH

Senior Business Analyst, Systems Analyst

Responsibilities:

• Prioritized user stories in Rally according to features and product types to create high level requirements.
• Analyzed existing MS Visio call flow diagrams to understand existing functionalities and features.
• Ran SQL queries in DB2 and DW as well as SQL database to understand existing data mapping fields.
• Created Web Services for Enterprise level Web Services exposing information to clients via Web Methods and Data Power by providing WSDL and XSD.
• Analyzed business requirements by extensively interacting with product owner and SME’s in gathering requirement.
• Created user stories in Rally to track specific requirements and progress.
• Tracked defects in QC and ALM with QA in understanding and closing issues in multiple product lines.
• Performed JAD Sessions with architectural review board, SME’s and stakeholders in developing enterprise solution for different web services.
• Created Data Mapping for different web service operations using Excel Sheets and queering DB2, DW and SQL databases.
• Analyzed Mainframe (RAFT) for all the logic and requirement for any legacy requirements and communicated with SME’s and Analysts for documentation.
• Analyzed on all Mainframe screens for analysis to perform screen scraping technology on Custom Credit clients.
• Evaluated functionalities with requirements in user stories and prioritize in the backlog.
• Conducted and participated in Retrospective meetings and planned for necessary improvements in future sprints.
• Created and sized Product Backlog and participated in Backlog grooming sessions with product owner and Scrum Master.
• Created Call flow diagram for various IVR’s in MS Visio with vendor company Contact Solution and wrote Functional Specification Documentation.
• Executed test cases for IVR and raised defects in Quality Center as well as ALM with communication with Quality Analyst team in defect tracking.

Environment: s: Windows, Java, C#, MS Project, MS Excel, MS Share point, IBM Mainframe, Rally, DB2, SQL Server, Data Warehouse, Mainframe, MS Visio, SOAP, QC, ALM

Confidential, NH

Business Systems Analyst

Responsibilities:

• Analyzed business needs by extensively interacting with business and collected requirements to document in the System Delivery Specifications
• Created data mapping for new functionalities that was in scope through MS Excel spreadsheet from XML & JSON files using Notepad++ tool
• Created and sized Product Backlog and participated in Backlog grooming sessions with product owner and Scrum Master and analyzed Product Backlog according to the prioritization and created Sprint backlogs.
• Involved in Sprint planning sessions with the scrum team and assured that the correct numbers of points are accomplished within the sprint and provided daily status meetings and updated tasks for every sprint.
• Involved in meetings with vendors like Bloomberg, Reuters, Google and Nuance team in managing data for the application.
• Performed and contributed on Show and Tell sessions to the Stakeholders after every sprint with the accomplished functionalities.
• Conducted and participated in Retrospective meetings and planned for necessary improvements in future sprints.
• Participated in triage meetings with the Business and the Technology team in planning and identifying defects according to priority and analyzed it.
• Performed analysis on the Mainframe using RUMBA and worked with the development team and mapped new way of incoming feeds towards the mainframe through bucket mapping and involved in meetings with the IBM team in going through Rule Engine for the GTMS project.
• Performed Unit Testing with the development team in identifying the defects and created Data Dictionary for Phase II of the project.
• Analyzed Web Services on the J2EE for mobile platform on Stock Plan Services.
• Participated and analyzed with the cross-functional team regarding the project and the requirements.
• Worked with Legal Product group in defining and tracking Business Objects in Proof Plus.
• Interacted with the vendor in documenting different Schemas for output transformation in Proof Plus.
• Executed test cases in Quality Center and raised defects in JIRA with communication with Proof Plus team in defect tracking.

Environment: s: Windows, MS Office, Agile, MS Share point, Quality Center, Notepad++, MS Visio, RUMBA, J2EE, OBIEE, JIRA, Perl Script.

Confidential, NY

Senior Business Analyst

Responsibilities:

• Interpreted and analyzed the business need by extensively interacting with traders, operations and SME’s to gather requirements; translated them into system specification, and authored BRD & FRS.
• Analyzed the existing investment management system with the integration of the Credit Derivatives trading system.
• Organized JAD Sessions with the SME’s, stakeholders to develop architectural solution, compared functionalities with the user requirements, analyze & prioritize system requirements.
• Created Workflow and Activity diagrams using Rational Rose.
• Identified the stakeholders, their roles and involvement in the project.
• Documented business rules and business processes using the business requirements document.
• Provided research, data integrity, data analysis and application support by generating adhoc SQL queries and MS SQL and Oracle.

Environment: s: Windows, Visual Basic, MS SQL Server, MS Project, MS Excel, Rational Rose, MS Share point.

Confidential, CA

Business Systems Analyst

Responsibilities:

• Interacted with project team to define system objectives and scope, and to identify constraints and the measures of success for the system to be developed.
• Designed Business Process Model (Activity diagrams, Sequence diagrams and Collaboration diagrams).
• Ensured application forms and reports followed client’s development standards and guidelines in terms of usage, naming conventions etc.
• Conducted workshops for internal users (processors, underwriters etc.) to provide training.
• Performed SQL queries for generating ad-hoc reports, data reconciliation, and data cleansing on downstream data bases for market and reference/static data.
• Hands-on experience in data analysis by identifying, analyzing, and documenting data requirements in data mapping document.
• Identified, researched, analyzed and documented business processes and uses case scenarios.
• Analyzed the business requirements and participated in creating Test Plan for GUI and database testing.

Environment: s: MS Office Suite, MS Project, Windows, MS SharePoint, J2EE, MS Access, PL/ SQL

Confidential, MA

Business Systems Analyst

Responsibilities:

• Organized meeting and presented storyboards to ensure accurate comprehension of the existing situation with rewards to mismatched scenarios.
• Depicted the flow of different kinds of credit mismatch scenarios through activity diagram.
• Developed use case diagrams for every conceivable scenario - such as use case to determine the sales credit mismatch, use case for the matched scenario, allocation etc.
• Supervised the development of the application by simultaneously interacting with the clients and the technical team.
• Formulated SQL queries for the creation of exception reports, trade data files and investigation files to support the traders/users.
• Assisted in developing test case objectives for verifying the accurate functioning of the system with respect to various mismatching under different permutations and combinations of scenarios.
• Involved in UAT process before rolling out to production.

Environment: s: Windows/Unix, MS Project, MS Office, MS SharePoint, Oracle, JIRA.

Confidential, CA

Business Analyst

Responsibilities:

• Providing users with a comprehensive real time report of P/L and risk assessment of municipal bonds, Syndicates, Short-term products, Fixed Income Futures, Bond Options.
• Liaison between the functional and technical teams involved in the project.
• Provided a comprehensive risk analysis of all the active positions and their P/L implications.
• Identify research, investigate, analyze, define and document business processes.
• Analyzed the current systems in place and evaluate their use and scalability in developing the system.
• Involved in performance testing, functional testing and integration testing.

Environment: s: Windows, MS Project, MS Visio, Rational Requisite Pro, SQL

Confidential

Associate Business Analyst

Responsibilities:

• Participated in Requirement review meeting and given feedback on inconsistencies requirements and ambiguous requirements.
• Analyzed and created requirement documents for the technology team and QA team.
• Identified business users and stakeholders for preparing requirements.

Environment: s: Windows, HTML, MS Office, MS SharePoint.