SUMMARY:

• Result - oriented professional with 9+ years of experience in financial industry as Business Analyst
• Strong experience in application development employing various Software Development Life Cycle (SDLC) methodologies such as Waterfall, Agile Scrum, Agile XP, RUP, and RAD
• Strong understanding of trading lifecycle for various financial products from initiation-to-settlement
• Excellent work experience and proven track record for executing application development process in Retail, Commercial & Investment Banking, Mortgages, Brokerage and FX trading
• In-depth knowledge of Bonds, Forwards, Futures, Options, Swaps (plain vanilla swap, basis swap), Collateralized Debt Obligation (CDO), Collateralized Mortgage Obligation (CMO), Asset Backed Securities (ABS), Mortgage Backed Securities (MBS), Credit Derivatives - Credit Default Swap (CDS)
• Proven expertise in interacting with business team to analyze, assemble, and document business requirements in Business Requirements Document (BRD); and identified Functional Specifications and documented Functional Specifications Document (FSD)
• Hands-on experience in constructing data-mapping (metadata) document identifying data sources, target database tables & columns, and required business rules to build end-to-end ETL data load
• Extensive experience in creating UML documentation such as Use Case Diagrams, Activity Diagrams, Business Workflow Diagrams, Class diagrams, Sequence Diagrams, State Diagrams, Swim Lane Diagrams, and Data Flow Diagrams using MS Visio and Rational Rose
• Extensive experience in executing SQL statements with databases like Oracle, MySQL, and Sybase
• Knowledge of financial regulatory compliances like Dodd Frank, CCAR, and Basel II / III
• Good understanding of financial networks & protocols like FIX, SWIFT, and FpML
• Extensive experience in project management - developing project plan; scope management; resource allocation; status updates; settling timelines; and team management
• Hands on experience in performing GAP analysis to effectively identify the existing technologies and document the development to meet the desired end state
• Experience in actively liaising between end users, development team, and QA team to address system issues and identify the appropriate solution
• Expertise in organizing & participating in project meetings such as JAD sessions to obtain project business requirements from project stakeholders and subject matter experts
• Strong experience with Data Modeling - assisting in building ER diagrams, via ERwin data modeler
• Expertise on different risk metrics such as VaR, Duration, and Convexity
• 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
• Knowledge of pricing & valuation model - NPV (Net Present Value), Time Series and Binomial Pricing
• 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, Usability Testing, Performance Testing, Stress Testing, Smoke Testing, Regression Testing, and UAT
• Expertise in identifying requirements as functional / non-functional and created the Requirement Traceability Matrix (RTM) for reviewing and tracking requirements
• Hands on experience with test management and defect tracking tools such as HP Quality Center Test Director, Bugzilla, JIRA, and Rational Clear Quest

TECHNICAL SKILL:

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

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

DBMS: Oracle, Sybase, MS SQL Server, DB2, MS Access

BI: Business Objects, Crystal Reports, OBIEE, Teradata, SSRS, Cognos

Data Vendors: Bloomberg, Markit, Interactive Data, FactSet, Reuters

Testing: JIRA, Quality Center, Bugzilla, JUnit, Selenium, LoadRunner, QTP, Skill Test, Silk

Others: Autosys, IBM Tivoli, Wiki, iLOG, DOORS, MS SharePoint, Confluence, TOAD, Management Studio, DB Artisan, AquaData, Informatica, SSIS, Documentum, Rally, Rational RequisitePro, UML, MS Visio, Rational Rose, ERWin

PROFESSIONAL EXPERIENCE:

Confidential, IL

Senior Business Analyst

Responsibilities:

• Gathered business requirements through workshops and brainstorming with AIP team stakeholders
• Documented existing procedural documents for Asset Coding, Broker-Depo i.e. DPAD
• Major contribution towards building BRD and FRD for AIP (Security Master)
• Active player in organizing JAD sessions with Entitlements, Trade, Entity, CORE and Accounting teams
• Documented and tracked requirements in One Note and Excel
• Generated reports as per stakeholder requirements in Business Objects (version XI)
• Actively participated in testing session part of UAT team and noted defects while UAT sessions, meanwhile also tracking all the defects in defect log
• Created summary reports using MS Excel for senior level executives to track data quality progress
• Wrote test cases from the use cases and uploaded the test cases to HP Quality Center
• Created procedures documents to support operational process changes
• Training downstream users on AIP Shared Service layer to be consumed by downstream users
• Extensively interacted with the stakeholders and the IT Department in finalizing the requirements
• Updating RAID log during team meetings to track if there are any Risks, Assumptions, Issues and Decisions on the ongoing project
• Assisted Data Modeling team to develop ER diagrams - defining entities, attributes, relationships, and business rules
• Supported the testing team to develop test plan, test cases, and test scripts to ensure that test scenarios reflect user’s functional and non-functional requirements
• Worked with the QA team in conducting various types of testing: functional testing, integration testing, system testing, performance testing, smoke testing, regression testing, and facilitated User Acceptance Testing (UAT) with system users in testing front-office system
• Building effective report writing needs using Agile tools creating customized queries as per the requirements

Environment: s: Business Objects, One Note, MS Excel, Bloomberg, XML, UML, Erwin, MS Visio, MS Project, Quality Center (QC), Agile Scrum, Java, Oracle, PL/SQL, Clarity, Tivoli, Selenium, SOAP UI, QTP

Rabo Bank, NY

Lead Business Analyst

Responsibilities:

• Managed, analyzed, validated, and implemented the system following the Agile Scrum methodology throughout the system development process
• Exercised various initiation techniques such as targeted questionnaires and interviews from business users and SMEs to gather business requirements and documented BRD, FSD, and Use Cases
• Interfaced with development team to design the application modules, identify system specifications, and process workflow throughout the application design phase
• Involved in conducting GAP analysis, Feasibility analysis, and Risk analysis for the application
• Assisted Project Manager in managing timelines for project deliverables, resource management, and conflicts resolution to ensure successful project completion
• Worked as a primary liaison between business users and developers to facilitate communication, handle application requirements, issues resolution, and change management
• Extensively employed MS Visio to conduct UML modeling - use case diagrams, written use cases, activity diagrams, screen mock-ups, data flow diagrams, class diagrams, business process flows diagrams, and workflows diagrams, thereby assisting development and QA teams in understanding application
• Built data mapping document to capture data integration process from data source to downstream databases
• Participated in JAD sessions with end users, designers, developers, QA, and project management to gather requirements and identify critical high-risk areas
• Assisted database modeling team in building data model - entity-relationships (ER) diagram and supporting data document defining the entities, relationships, triggers, and database constraints
• Collaborated with QA team in developing test plan, test strategies, test scenarios, test cases, and test scripts ensuring that the final application addressed all the user requirements
• Performed application testing along with QA team - conducted Functional Flow Testing, System Integration Testing, Performance Testing, Load Testing, Regression Testing, Sanity Testing, and UAT
• Created Requirements Traceability Matrix as per business requirements and test cases to ensure that project initiatives meet the expected deliverables
• Constructed complex SQL queries to retrieve data, to conduct data analysis, and to perform data validation

Environment: s: .NET, C/C#, Java, Visual Basic, Oracle, PL/SQL, Confluence, Wiki, iLOG, DOORS, XML, Crystal Reports, FIX, Omgeo CTM, Global Oasys, FXall, Autosys

Confidential, CA

Sr Business Systems Analyst

Responsibilities:

• Interviewed portfolio managers, traders, project stakeholders, SMEs to gather, analyze and document requirements followed by translating them into system specifications, and documenting SRS
• Followed Waterfall methodology guidelines and principles all through the SDLC process
• Conducted GAP analysis to develop, document and analyze “As Is” and “To Be” business processes - to develop migration strategy for transitioning from legacy-to-new platform
• Organized Joint Application Development (JAD) sessions with end users, developers, project manager, and quality analysts to resolve conflicts, schedule releases, prioritize tasks, and design the proposed application
• Conducted various of project management activities such as Work Breakdown structure, Schedule Management, Budget forecast models, Resources & Deliverables Planning, and Scope Management
• Dealt with various data feeds sourced from Bloomberg and Reuters for reference data and market data - created data mapping documents to set-up ETL process to load data into target table in underlying database
• Created Use Case Diagrams, Activity Diagrams, State Diagrams, Sequence Diagrams, Class Diagrams, Data Flow Diagrams, and process flow Diagrams following Unified Modeling Language (UML) guidelines
• Performed complex SQL queries to retrieve data, validate data, and build user reports all through the SDLC
• Assisted Data Modeling team to develop ER diagrams- defining entities, attributes, relationships, and business rules
• Supported the testing team to develop test plan, test cases, and test scripts to ensure that test scenarios reflect user’s functional and non-functional requirements
• Worked with the QA team in conducting various types of testing: functional testing, integration testing, system testing, performance testing, smoke testing, regression testing, and facilitated User Acceptance Testing (UAT) with system users in testing front-office system
• Created and maintained Requirement Traceability Matrix to map requirements of the project against stages in the development lifecycle and to track test cases throughout the testing phase
• Managed complete defect tracking lifecycle: entering defects, generating status reports, prioritizing defects, and maintaining defects log, using Quality Center

Environment: s: Agile, UML, MS SharePoint, Portia, Bloomberg, SQL, QTP, Quality Center QC, Reuters, MS Visio, MS Office, MS Project, Java / J2EE, XML, Oracle, Unix, Wiki, PL/SQL, TOAD

Confidential, CT

Sr Business Analyst

Responsibilities:

• Coordinated and interacted with business users to understand the business need, gather business requirements, analyze workflows, define scope, translate requirements into system specifications, and authored BRD & SRS
• Adopted Rational Unified Process (RUP) methodology in different iterations and phases throughout product development lifecycle
• Performed several project management tasks such as documenting project plan, deliverables scheduling & tracking, and following the project development throughout the process
• Conducted GAP analysis to determine the project scope by documenting the current process and the future process ensuring that system initiatives are met
• Conducted interviews, brainstorming sessions, posted surveys/questioners to collect data from stakeholders
• Organized JAD sessions with the team members to design architectural solution, compare application functionalities with business requirements, and prioritize functional specifications
• Employed MS Visio to document UML diagrams such as written use cases, use case diagrams, activity diagrams, data flow diagrams, swim lane diagrams, business workflow diagrams, and system workflow
• Analyzed, designed, and created Graphical User Interface (GUI) screen mock-ups
• Constructed data mapping documents - defining source, target table / columns names, and data transformation rules for loading data into targeted databases, via ETL process
• Executed SQL queries on underlying databases to generate reports for business users
• Assisted DBAs in creating ER models for underlying database design
• Created test plan capturing test purpose, test timelines & schedule, and test approach; assisted QA team in identifying test scenarios and generated positive & negative test cases
• Conducted functional testing, integration testing, system testing, performance testing, load testing, smoke testing, regression testing, and supported UAT with business users
• Maintained Requirements Traceability Matrix throughout all phases of testing lifecycle

Environment: s: Java, C++, Omgeo, Oracle, PL/SQL, Quality Center, Management Studio, Autosys, MS SQL Server, MS Visio, HTML

Confidential, NY

Business Analyst

Responsibilities:

• Interacted with SMEs and stakeholders to get a better understanding of client business processes and participated in requirement gathering and design sessions; documented BRD and FSD
• Followed the iterative Agile SCRUM methodology throughout the SDLC - facilitated daily scrum meetings, sprint planning meetings, sprint review meetings, and sprint retrospective meetings
• Assisted the Project Manager with developing project plan, project milestones, and project charter while managing the system life cycle in MS Project
• Created Use Case Diagrams, Activity Diagrams, Swim-lanes Diagrams, Class Diagrams, Screen Mock-ups, and Business Workflow Diagrams
• Conducted GAP analysis to analyze and document the existing process flow and proposed process flow; - identifying the variance and determined the requirements to reach desired future-state
• Collaborated with Product Management Group and IT Specialists to prepare a detailed Equity Trading infrastructure for implementing the Equity trading system­­­­ - a diagrammatic flow of accounting updating process, trading, order allocation, account settlement, data feeds and pre-order / post-order compliance
• Conducted functional walkthroughs, JAD sessions with business team and assisted in creating application training document and subsequent user training
• Performed data extraction, data manipulation, and data analysis in Oracle database using SQL queries
• Developed several customized reports for clients querying Oracle database which includes Accounts P&L, Holdings report, Trading data, Accounts Balance report, and Clearing & Settlement report
• Contributed to data modeling, data analysis and data mapping; generated Data Mapping document defining the data source, target, transformation rules, null rules, and business rules to construct the ETL process feeding data into data warehouse and data marts
• Designed and documented comprehensive Master Test Plan, Test Scenarios, Test Cases, and Test Scripts with QA team and assisted in conducting various types of testing - functional testing, integration testing, performance testing, load testing, GUI testing, regression testing, smoke testing, User Acceptance Testing (UAT)
• Developed Requirements Traceability Matrix to develop end-to-end tracking from requirements to test cases to meet expected results in given timeline
• Facilitated the Defect Tracking Lifecycle by logging defects, prioritizing defects, developer follow-ups, re-testing fixed defects, and generating daily summary reports

Environment: s: Rational Requisite Pro, UML, Rational Rose, MS SQL Server, SQL, MS Office, MS Project, Rational ClearQuest, Management Studio, QTP, MS SharePoint

Confidential

Business Analyst

Responsibilities:

• Performed Gap analysis, conducted walkthroughs and acted as a liaison between the business users, stakeholders and the team to perform requirements, quality and risk analysis
• Involved extensively in the inception phase for understanding the scope of the project, feasibility of the implementation and define the risk factors involved in the project
• Gathered business requirements through sessions and analysis by interviewing users and subject matter experts (SME)
• Analyzed business/system requirements using requirement arbitrage and assigned appropriate priorities
• Effectively managed the requirements and requirement change requests during various phases of project life cycle
• Ensured that all requirements, enhancements, and defects for the particular release have been developed, fixed, and tested by creating traceability matrices between all the project artifacts
• Got system approvals by conducting UAT sessions

Environment: s:Windows XP, HTML, Oracle, MS SQL, SQL Script, Quality Center