SUMMARY:

• Result oriented professional with over 10+ years of experience as a Business Analyst in the financial industry
• Expertise in project management activities in planning, executing, tracking deliverables, scheduling releases, resource allocation, and coordinating team efforts with strict adherence to deadlines
• Comprehensive knowledge of stocks, corporate bonds, municipal bonds, T - bills, T-notes, T-bonds, options, futures, forwards, swaps, mortgage backed securities, asset backed securities, CMOs and CDOs
• Strong understanding of various financial metrics & valuation techniques - VaR, Duration (Macaulay, modified, effective), convexity, yield, yield-to-maturity (YTM), binominal pricing, discounted cash-flow, CAPM
• In-depth knowledge of various types of risk such as Market risk, Interest rate risk, Liquidity risk and Credit risk
• Good knowledge of different financial networks and protocols such as FIX, SWIFT and FpML
• Proficient in financial and accounting regulations & principles such as GAAP, Basel Dodd Frank regulations
• Excellent knowledge of application development employing various Software Development Life Cycle (SDLC) methodologies such as Agile XP and Agile Scrum, Waterfall, RUP, and RAD
• Strong experience in formulating BRD and FSD with proven analytical skills of understanding the business need; gathering, capturing, and documenting business requirements; and translating them into clearly defined functional specifications
• Expertise in performing Gap analysis by understanding the existing legacy system and identifying the enhancements to meet the end state requirements
• Hands-on experience working as a liaison between the client and technical team, managing resources, prioritizing team based activities and establishing schedules while adhering to the objectives
• Proficient in business modeling and UML - Use case Diagrams, Activity Diagrams, Sequence Diagrams, Class Diagrams, Mock-ups, Process workflow and Data flow diagrams using Microsoft Visio and Rational Rose
• Expertise in organizing JAD sessions, user group meetings, walkthrough sessions and change request analysis throughout the application development process
• Proficient in performing data mapping - capturing data requirements, identifying the source, business rules, target tables to setup the Extract, Transform and Load (ETL) process
• Hands on experience performing SQL queries on database for data analysis, report generation, investigate data issues and validate database dependencies
• Proficient in data modeling using conceptual, logical and physical data models; and assisting data modelers with creating the entity relationships diagram
• Expertise in creating Requirements Traceability Matrix correlating baseline documents and tracking the requirements throughout the development and testing process
• Expertise in Quality Assurance - assisted the QA team in preparing the test plan, test cases, and test scripts
• Hands on experience in functional testing, integration testing, system testing, performance testing, regression testing, smoke testing and user acceptance testing
• Proficient in managing the bug life cycle - opening defects, prioritizing, delegating and generating reports
• Self-motivated individual with ability to work independently, influence decisions across cross-functional teams and handle diverse tasks simultaneously adapting to tight deadlines

TECHNICAL SKILLS:

Operating System: Windows XP/Vista/7/8, Mac OS, Linux, UNIX

Database: Oracle, MS SQL Server, MS Access, MySQL, Sybase

Programming: C/C++, C#, JavaScript, Visual Basic, J2EE, ASP, XML, .NET, HTML, Java, JSP, SQL, PL/SQL

Modeling: UML, MS Visio, Rational Rose, Erwin

Microsoft Tools: MS Office Suite, MS Project, MS Visio, MS SharePoint

Testing Tools: Test Director Quality Center, LoadRunner, QTP, Selenium, JIRA, BugZilla, ClearQuest

Analysis: Waterfall, Agile (Scrum), Agile (XP), RAD, RUP, MATLAB, Rational RequisitePro, Confluence, DOORS, iLOG, RALLY, Autosys, Tivoli, Bloomberg, Reuters

PROFESSIONAL EXPERIENCE:

Confidential, NY

Lead Business Analyst

RESPONSIBILITIES:

• Led the analysis of data generated by the bookkeeping and margining engine (GMI), and design of tables and data enrichment processes for the data warehouse
• Adopted Agile Scrum methodology in all phases of the project - maintained the product backlog & sprint backlogs throughout the project and also conducted daily scrum meetings, sprint planning meetings, sprint review meetings and sprint retrospective meetings
• Worked on analysis & design of loading processes and filters for the transactional and reference tables
• Conducted in-depth requirement gathering, analysis, and design of data feeds generated out of the underlying data warehouse
• Responsible for translating user needs into detailed business requirements capturing in BRD and translating requirements to system specs capturing in System Requirements Specifications (SRS)
• Constructed complex SQL queries to generate reports and run DMLs to modify the data according to end-user’s specifications and criteria
• Created various UML diagrams - use cases, dataflow diagrams, business workflows, swim lane diagrams, and state diagrams using MS Visio to communicate, explore, and validate the potential application design
• Performed GAP analysis to identify the existing functionalities and desired end product, documented the gap and developed application development roadmap to fill the variance
• Provided strategic support to the project manager in developing project plan, statement of work, scope statement, work-load management, sprint scheduling, project timelines, and communication plan
• Served as liaison between project stakeholders, development team, and quality assurance team to ensure that business needs are well understood and technical implications are conveyed in user-friendly manner
• Built data views to support generation of client reports
• Conducted comparison, validation, and verification of data feeds from the data warehouse with data from the existing legacy IT system being employed in Barclays
• Built data mapping spreadsheet capturing data requirements as well as identifying data source (respective data vendors / feeds); destination database, tables, and columns; and business rules
• Worked with Data modeling team to design & build database for the application using the Entity-Relationship (ER) diagram defining relational tables, primary & foreign keys, stored procedures, entities, and triggers
• Performed reviewing, running, debugging UNIX Shell Scripts and AutoSys Jobs to load data into the data warehouse and generate data feeds
• Conducted various walkthrough & JAD sessions to define and review the business requirements, to develop an architectural solution, resolve open matters, and handle change requests
• Participated in creating test plan, test cases, and test scripts along with Quality Assurance team to conduct various types of testing such as Functional testing, System testing, Performance testing, Load testing, GUI testing, Usability testing, End-to-end testing, Sanity testing, and Regression testing
• Used Quality Center to manage testing and defect life cycles, and map requirements to test cases
• Closely worked with Quality Assurance (QA) testing team for test automation and design of test scripts
• Collaborated with Business Users and Operations group as part of User Acceptance Testing (UAT) - setup of test environment, test data refresh, test files generation, and defect tracking management
• Developed Requirements traceability matrix (RTM) to illustrate logical link between individual business requirements and other project artifacts including specifications, use cases, test cases, business rules

ENVIRONMENT: Oracle SQL 11.5, Informatica, MS Visio, JIRA, HP Quality Center, SunGard Stream GMI, AutoSys, UNIX Shell Scripting, Perforce, MS SharePoint, iLog, DOORS, MS Project, Web Logic, QTP, TOAD, PL/SQL, Confluence

Sr Business Systems Analyst

Responsibilities:

• Responsible for interviewing end users, subject matter experts at all levels and developing business requirements, captured user stories in product backlog
• Worked alongside the project manager on project management tasks such as developing the project scope, identifying deliverables, estimating & allocating resources, and change management process
• Acted as a liaison between business users and business partners, managing relationships and monitoring all service request submissions to IT group throughout the application development lifecycle
• Adopted Agile Scrum, an iterative methodology to manage the project requirements, responsible for creating storyboards, and conducted brainstorming sessions to understand the client needs
• Performed Gap analysis by identifying existing technologies, and documenting the enhancements needed to meet the end-state requirements
• Gathered requirements from portfolio managers and subject matter experts about portfolio management and customized report generation
• Helped in the design of portfolio analysis tools including hypothetical performance, risk statistics, sector breakdowns, and region weighting among others
• Organized JAD sessions to verify consensus in the team, develop an architectural solution address the business requirements, resolve open issues, and manage change requests
• Analyzed business requirements and employed Unified Modeling Language (UML) to develop high-level and low-level Use Cases, Activity Diagrams, Sequence Diagrams, Class Diagrams, Data-flow Diagrams, Business Workflow Diagrams, Swim Lane Diagrams, using Rational Rose
• Performed data mapping activities such as defining data source, target, and transformation rules to assist ETL team in setting-up the data load process into data warehouse
• Responsible for constructing SQL queries to extract and analyze data from the underlying relational database responding to user’s data requests
• Assisted database designing team in Data Modeling by providing the data requirements and helping in creating Entity-Relationship diagram classifying & identifying entities, attributes, and defining relationships
• Involved with Test team in developing test plan, test design, and test cases to perform Functional testing, Integration testing, End-to-end testing, GUI testing, Performance testing, Usability testing, Smoke testing, Regression testing, and User Acceptance testing
• Worked on Quality Center for Defect tracking and management by logging defects, prioritizing defects, tracking defects, documenting defects, and generating defects summary reports
• Prepared the requirements traceability matrix (RTM) document, to track the test cases back to its business requirements and system specifications, ensuring both forward and backward traceability to make sure requirements are met in all phases of project

ENVIRONMENT: Windows, Requisite Pro, MS Project, MS Office, Java/J2EE, HTML, MS SQL Server, .NET, MS Visio, Win Runner, Tivoli, Confluence, QTP, Quality Center, UNIX, JRules, iLog, Management Studio

Lead Business Analyst

RESPONSIBILITIES:

• Followed RUP methodology and its guidelines for project planning, analysis, design, development, resource allocation, testing, and implementation
• Worked closely with project manager on various project management tasks such as drafting project plan and strategies, managing release schedules, project status tracking, and coordinating resources using MS Project
• Liaised with business and functional owners in high-level review sessions to derive, execute and implement action plans throughout the various stages of application development life cycle
• Interacted with business users and SMEs to conduct GAP analysis to document the existing application and capture the user’s requirements for proposed application
• Conducted JAD sessions with project stakeholders throughout software development life cycle to discuss critical issues, expedite development, and resolve conflicts
• Interfaced with business users to understand the business need; gather, capture, and prepare the Business Process Requirements document (BPR); and convert them in to clearly defined Functional Specifications
• Performed Data Mapping - capturing data requirements, source to target mappings, data validation rules
• Extensive used UML methods to develop use case diagrams, activity diagrams, sequence diagrams, class diagrams, and state diagrams to represent the system work flow and capture bottlenecks in the application
• Executed SQL queries to retrieve data from databases for data analysis, data validation generating reports
• Assisted database modelers in ER modeling by constructing conceptual, logical and physical data models
• Facilitated User Acceptance Testing (UAT) for systems users (front office, middle office, back office) - setting up environment, daily status update, managing defect tracking, and generating summary report
• Created Requirements Traceability Matrix as well as maintained forward and backward traceability throughout the testing and development lifecycle
• Assisted the QA and Test teams in preparing the test plan, test cases and test scripts
• Performed functional testing, system testing, performance testing, regression testing, smoke testing
• Played a key role in defect tracking and management - delegating defects, monitoring status, ensuring timely closures, and generating performance reports

ENVIRONMENT: Java, J2EE, UNIX, UML, Rational Rose, MS Project, Oracle, ERwin, JIRA, RUP, TOAD, Autosys, Wiki, MS SharePoint, Selenium

Senior Systems Analyst

RESPONSIBILITIES:

• Determined goals & objectives of “to be” system, gathered business requirements, documented BRD specifying the project stakeholder equirements, transformed requirements into specifications in FSD
• Followed Agile SCRUM methodology for software development - managing user stories, conducting daily scrum meeting, sprint planning meetings, and sprint review meetings throughout the project
• Extensively liaised with project manager, technical team, business to identify project deliverables, maintain work breakdown structure, identify key milestones, resolve open issues, and develop project schedules
• Performed GAP analysis to compare the actual performance of the legacy system with the potential performance of the system to be developed
• Conducted JAD sessions to obtain valuable inputs and specifications by bringing system developers, SMEs, and users together at different stages in the project
• Developed Use Cases, Activity Diagrams, Swim Lane Diagrams, Activity Diagrams, Process Workflow Diagrams, Data Flow Diagrams, and Business Workflow Diagrams applying UML principles and facilitated object oriented analysis and design (OOAD)
• Constructed data mapping document identifying source attributes, target destination, and business rules to setup the ETL process
• Executed SQL queries on the underlying database to generate reports for end users and perform data analysis on market data for different derivatives products
• Assisted DBAs to create ER Diagrams defining & identifying relational tables, database triggers, data objects, relationships, data attributes, entity integrity rules, attribute integrity rules, referential integrity rules
• Worked with QA team in documenting test plan, test scenarios, test cases, and test scripts to validate all the system requirements and conducting functional testing, integration testing, performance testing, system testing, smoke testing, and regression testing
• Created requirements traceability matrix (RTM) to effectively map and track project deliverables such as business requirements, functional specifications, and test cases
• Worked on ClearQuest to manage defects, generate summary reports, and maintain defect log throughout the development & testing process

ENVIRONMENT: Oracle, MS Visio, ClearQuest, Rational Requisite Pro, J2EE, Crystal Reports, FpML, Windows/UNIX, MS Office, MS Project, Selenium, Tivoli, Wiki, MS SharePoint

Business Analyst

RESPONSIBILITIES:

• Interviewed all stakeholders to understand the business & functional specifications and created BRD
• Assisted the Project Manager to analyze and develop solutions for business challenges with demonstrative leadership and initiative for achieving business results for short term and long term organization goals
• Formulated SQL queries for creation of exception reports, ad-hoc reports, and investigation database issues
• Identify and track project milestones, deliverables, risks, issues, changes and dependencies within the project schedule and budget to assist in project risk management across all phases of SDLC
• Conducted data mapping to setup the data integration process (ETL workflow) to assist with data mediation, data lineage, and data consolidation
• Extensively used MS-Visio for UML to facilitate documenting the environment, requirements and overall design such as use case diagrams, activity diagrams and sequence diagrams to represent the workflow

ENVIRONMENT: Windows/UNIX, .NET, Sybase, Requisite Pro, Rational Rose, MS Project, MS Office, Test Director Quality Center, QTP, DB Artisian, AquaData

Business Analyst

Responsibilities:

• Followed an adaptive process framework in accordance with the principles of the RUP Methodology
• Gathered business and technical requirements and transformed them into a BRD and FSD respectively
• Used Rational Rose for UML to highlight the functionality, workflow and components of the system
• Worked on Quality Center to generate status reports, prioritizing defects and maintaining defects log
• Developed custom reports on SQL for the data analysis and data mining team
• Gained exposure in XML (FpML) to the matching agent and corresponding actions taken by the system

ENVIRONMENT: Oracle SQL, Rational Requisite Pro, Crystal Reports, Windows/UNIX, MS Office, MS SharePoint