SUMMARY:

• 7+ years of experience as a Business Analyst in the financial & banking industry implementing straight - through processing (STP) application to trade securities such as equities, fixed income, and derivatives
• Solid experience and understanding of different Software Development Life Cycle (SDLC) methodologies such as Agile (SCRUM), Rational Unified Process (RUP), RAD, Agile XP, and Waterfall
• Proven expertise in verbal / written communication skills - gathering, refining, and documenting Business Requirements (BRD), transforming requirements into system specifications and documenting System Requirements Specifications (SRS)
• Proven expertise in building the data-mapping (metadata) document identifying data sources, target database tables & columns, and required business rules to build the end-to-end ETL data load process
• Extensive experience in building and implementing complex SQL queries to conduct data analysis, generate reports, data validation, examine database issues, and assisted in ETL process testing
• Highly skilled in interacting wif business users to identify business need to initiate process changes and in building UML model including Use Case diagrams, Written Use Cases, Activity diagrams, Business Process Workflow, Swim-lane diagrams, Data-flow diagrams, Sequence diagrams, using Rational Rose / MS Visio
• Expertise in conducting GAP and IMPACT analysis and documenting the AS-IS and the TO-BE solutions
• Solid experience in assisting DBAs to build underlying Data Models - designing conceptual, logical, physical data model, and entity-relationship (ER) diagrams (defining entities, relationships, attributes), using ERWIN
• Well versed in facilitating various JAD sessions throughout the project to gather requirements from project stakeholders and to ensure high quality deliverables
• Proficient in assisting Project Manager to conduct the project feasibility study and generated the feasibility report; developed / maintained the project plan and project charter, scheduled the iterations, identified the key milestones, and managed change requests
• Expertise in working as liaison between cross-functional groups - business users and the developers to understand the business processes, requirements, and communicate TEMPeffectively in order to achieve excelling results while adhering to project objectives
• Excellent experience in supporting QA group throughout testing - preparing master test plan, test scenarios, test cases, test scripts; and performing functional testing, integration testing, system testing, black-box testing, performance testing, GUI testing, smoke testing, regression testing, and UAT
• Solid experience in Defect Tracking Lifecycle Management using Quality Center by logging and prioritizing defects, performing root-cause analysis, re-testing fixed defects, and generating defects summary reports
• Proven expertise in building and managing Requirement Traceability Matrix (RTM) throughout testing to keep track of requirements from development through implementation
• Strong knowledge of financial securities such Patelas equity stocks, fixed income ( corporate bonds, treasuries, repos, munis, junk bonds, asset backed securities (ABS), mortgage backed securities (MBS), CMOs, CDOs), secured financing products - repos, reverse repos, tri-party repos, money market securities, options, futures, forwards, swaps (interest-rate swaps, CDS, TRS, CLN), and derivatives
• Proficient wif trading practices for mutual funds, hedge funds, and fund accounting
• Strong exposure in various regulatory compliance acts like CCAR, BASEL III - Standardized & Advanced methods for calculating RWA (Risk Weighted Asset), PD, LGD, and computing credit risk
• Hands on experience dealing wif Market Data, Reference Data, Pricing Data, and Counterparty Data
• Hands-on understanding of trade lifecycle of financial securities from initiation-to-settlement and financial messaging standards, networks, and protocols such as FIX, SWIFT, and FpML
• In-depth knowledge of Dodd-Frank act for financial stability and Compliance/Risk Management
• Exposure of different types of risks like credit risk, counter-party risk, systematic risk, default risk, market risk, interest-rate risk, volatility risk, currency risk; knowledge of risk measurement techniques like duration, convexity, value-at-risk (VaR), and Monte Carlo Simulation

TECHNICAL SKILLS:

Operating Systems: Windows 00/03/XP/Vista/7/8/10, Mac OS, UNIX, Linux

Programming: C, C++, SQL, VB Scripting, Python, Java, J2EE, .NET, JSP, CSS, AJAX, XML, HTML, C#, VB

Databases: Oracle (10g, 11g), MS Access, MySQL, MS SQL Server, Sybase, Erwin, Management Studio, TOAD, PL/SQL, DB Artisan, AquaData

Data Sources: Bloomberg, Reuters, Markit, FTID, Moody, Fitch, S&P, Prime Broker Feeds, Custodian Feed

Business Intelligence: Cognos, Business Objects, Tableau, Teradata, SSRS, OBIEE, QlikView, Micro Strategy

Domains: Wholesale Banking, Retail Banking, Fixed Income, Project Management

SDLC Methodologies: Agile Scrum, Waterfall, Agile XP, RAD, V Model, RUP

QA Tools: Quality Center (QC), JIRA, BugZilla, ClearQuest, QTP, LoadRunner, Selenium, Silk

Tools: MS Visio, MS SharePoint, Confluence, Tivoli, Autosys, UML, Rational Rose, Doors, Rally, Bloomberg, Markit, Interactive Data, Reuters, Informatica, iLog, MS Office, MS Project

PROFESSIONAL EXPERIENCE:

Confidential, NY

Sr Business Analyst

Responsibilities:

• Followed Agile SCRUM methodology for project - created user stories, burn down chart, conducted daily scrum, sprint planning, sprint retrospective meetings as well as managed the product / sprint backlogs
• Conducted GAP analysis by documenting existing technologies, analyzing the current and expected processes; and documenting the enhancements to meet the end-user requirements
• Interviewed project stakeholders to understand the business need and gather application requirements to document BRD; converted the requirements into system specifications and documented SRS
• Gathered specifications for Assumption Rule Builder to maintain them for cash flow forecasting
• Played a vital role in creating aggregation calculator, assumption rule builder, and user interface
• Partnered wif SME’s from Investment, Commercial, Personal Banking and Regulatory departments to prepare high level documents for data sourcing and transformation
• Dealt wif complex SQL queries for creation user reports, data extracts, and issues investigation
• Built data mapping documenting the data sources, target table / columns, and business logic rules to setup the ETL load process for the Data Warehouse; and developed Data Dictionaries and Metadata documents
• Worked wif market data feeds from Bloomberg, Reuters, and Interactive Data for reference data and market data; built data mapping document mapping the data source to underlying oracle database along wif needed business rules to implement quality control
• Applied UML methodology guidelines to create Use Case Diagrams, Written Use Cases, Activity Diagrams, Screen Layouts, Wireframes, State Diagrams, Sequence Diagrams, and Business Workflows
• Wrote use cases for component - assumption rule builder on various position details of product such as deposit, loans, and secured financial products
• Supported DBAs by defining and analyzing the data requirements to build ER (Entity Relationship) Diagram identifying the entities, relationships, data attributes, and data integrity rules
• Assisted Project Manager for performing several project management activities such as maintaining project plan, project scope, project charter, change management, and idea creation request after feasibility analysis
• Worked as liaison between end users and technical team keeping stakeholders up-to-date on weekly progress which enabled them to remain abreast wif system issues, timelines, and planned activities
• Facilitated various JAD sessions wif SMEs & Business users to gather requirements by asking right set of questions, analyzed & documented end requirements
• Collaborated wif QA team in building test plan, test scenarios, test cases, and test scripts; and conducted functional testing, integration testing, system testing, GUI testing, performance testing, load testing, stress testing, smoke testing, regression testing, and supported UAT
• Performed functional testing to prove out LCR calculations for multiple line of business by using excel model
• Also, conducted user acceptance testing for onboarding multiple upstream systems into downstream system me.e. Regulatory Compliance Reporting System
• Managed end-to-end Defect Tracking Lifecycle in system testing phase - running daily status meeting, logging defects, follow-ups, allocating developers, and maintaining defects log
• Maintained Requirement Traceability Matrix throughout the life of the project in order to back trace the business requirements / design specs to the test cases to successfully ensure 100% coverage
• Chaired weekly meetings wif technical team to discuss work plans, open issues, and backlogs; and generated bi-weekly reports for stakeholders on project status

Environment: JIRA, MS Office, MS Visio, MS SharePoint, Oracle 11g, SQL, Java, IBM Cognos, Agile, PL/SQL, Quality Center, WinRunner, QTP, Confluence, iLog, DOORS, Rally, Documentum, TOAD

Confidential, NY

Senior Business Systems Analyst

Responsibilities:

• Conducted GAP analysis to compare the actual performance of the legacy system wif the potential performance of the system to be developed
• Documented goals & objectives of “to be” system, gathered business requirements, documented BRD capturing the requirements, transformed requirements into specifications, and documented FSD
• Implemented underlying application following Agile Scrum methodology guidelines to build artifacts in different sprints and phases of the application development process
• Conducted everyday stand-ups to discuss daily task, progress, issues and solutions
• Arranged sessions wif business users to understand requirements for Matching & Allocation Logic and Market calculations
• Prepared data requirements documents to record and store market data like price, foreign exchange rates, MTM rates, margin calls from clearing broker
• Worked wif different cross functional teams like Reference Data team to leverage the market data for margin calculations
• Executed SQL queries in order to retrieve and validate the data
• Constructed data mapping document identifying source attributes, target destination, and business rules to setup the end-to-end ETL data load process
• Responsible for Change Management by taking the change request from users, analyzing, and implementing those requests if feasible
• Created various UML diagrams such as the Use Case diagrams, Activity diagrams, State diagrams, Process Workflow diagrams, Screen Mockups, Sequence diagrams, Data Flow diagrams, and Business Workflows
• Supported database modeling team to build ER Diagrams defining & identifying relational tables, database triggers, data objects, relationships, data attributes, entity integrity rules, attribute integrity rules, and referential integrity rules
• Constantly played the role of liaison between business users and developers in order to identify & monitor the project deliverables, identify key milestones, and resolve open issues
• Conducted and facilitated JAD sessions to gather inputs from the SMEs, Developers, Business users at different stages of the project
• Closely worked wif QA team in creating master test plan, test scenarios, test cases, and test scripts to validate all the business requirements and performing functional testing, integration testing, performance testing, system testing, smoke testing, and regression testing
• Worked on Rational Clear Quest to manage defects, generate summary reports, and maintain defect log throughout the development & testing process
• Performed functional walkthroughs for users, halped them understand the application, and assisted them in performing User Acceptance Testing (UAT) - environment setup, daily status update, defect tracking management, and generating summary report

Environment: MS Office, UML, Java, MS SQL Server, Rational Rose, Rational Clear Quest, Management Studio, Rational Requisite Pro, Windows/UNIX, MS Project, QTP, MS SharePoint

Confidential, NY

Business Analyst

Responsibilities:

• Implemented Waterfall methodology ensuring that tasks at hand were TEMPeffectively executed
• Documented the business requirements to prepare BRD and converted the requirements into functional specifications to prepare the FSD
• Gathered business requirements by reviewing existing artifacts and interacting wif the end users including Portfolio Managers, Traders, Risk Managers, and Compliance team
• Performed GAP analysis by analyzing legacy system, understanding business processes, and the impact of implementing the proposed application
• Conducted stand-up meetings on a daily basis in order to ensure that the project was flowing in the right direction wif respect to progress, issues, tasks, and resolutions
• Responsible for Change Management by receiving change requests from users, analyzing the same along wif Project Manager to see if the requests are feasible and implementing those requests
• Lead face-to-face meetings wif the Data Architect, Developers, DBAs, and business users to discuss design, issues, and obtained approvals
• Assisted Project Manager in creating Project Plan, Deliverables Scheduling, Status Meetings, Reports, and handling Change Requests
• Acted as a liaison between several teams wifin the business and technology group to meet project deadlines and objectives wif success
• Used SQL queries to generate business reports as per client requirements, performed data validation testing and data analysis
• Built UML model by making Use Cases, Activity diagrams, and Sequence diagrams defining the system functionality and business process workflow
• Collaborated wif data modeling team to build ER Diagrams by identifying data objects and constraints; and created data dictionary & data mapping documents to support ETL process
• Worked closely wif QA team to create test plans, test objectives, test cases and execute functional testing, integration testing, system testing, smoke testing, performance testing, and UAT
• Used JIRA to track defects, report defects, and maintain log for the system

Environment: MS Office, MS Visio, Waterfall, TOAD, .Net, Oracle, Unix, Java, Load Runner, JIRA, MS SharePoint

Confidential

Systems Analyst

Responsibilities:

• Gathered business and technical requirements and transformed them into a BRD and FSD respectively
• Followed the principles of Agile methodology during the entire software development life cycle (SDLC)
• Performed data analysis & data validation by executing SQL queries to validate database dependencies and constraints, to create custom user reports, and to conduct data load process testing
• During the design phase, worked wif the development team to ensure testability, reliability, usability, maintainability and performance of a web-enabled client/server application
• Helped identify the source data systems and the data required in the data warehouse environment to meet the users current and future needs
• Responsible for creating the data mapping document for the source data, target data, and transformation logic required to support ETL process
• Played the role of a consultant to the ETL (Extraction, Loading, and Transfer) team and front-end programmers
• Liaised between business team and technical group to meet the project deadlines and objectives
• Prepared the Use Cases, Object Diagrams, Class Diagrams and Data Flow Diagrams in MS Visio to signify the system workflow and to find out any bottleneck in the system
• Assisted data modelers in developing the database models and reviewed them to ensure that requirements were met
• Designed logical and physical data models by interacting wif data architects and data modelers developed entity relationship diagrams using Erwin data model
• Designed the reports layout as requested by client and communicated to the technical team
• Analyzed legacy system and performed gap analysis between the current state and future data warehouse environment
• Involved in Data Validation/Verification testing using basic SQL Queries to find accounts wif KYC flag, finding different type class code of person and corporate account.
• Assisted QA team to document test plan, test scenarios, test cases, and test scripts; performed various types of testing - functional testing, integration testing, system testing, load testing, regression testing.
• Employed Quality Center to generate status reports, prioritizing defects, and maintaining defects log

Environment: MS Visio, .Net, Sybase, MS Office, Quality Center, DB Artisan