Data Project
Resume:
Vaishnavi RaviSankar Phone:+1-503-***-****
Email: ************@*****.***
Executive Summary
Over 5 years of experience in Software Industry worked as BA/QA Analyst in Investment and Capital Markets Practice. Having grown in the Capital Markets industry, I bring a wealth of Investment Banking, Foreign Exchange, Regulations with an emphasis on Manual Testing and Agile Methodologies.
Professional Summary
Experience in Investment Banking, Regulations and Foreign Exchange.
Expert in sequence diagrams, use cases development.
Holds expertise for CIP (Customer Identification Program), KYC, Counterparty Classification rules, FATCA, Governance, Risk, and Compliance, MIFID, Counterparty Classification, FX Cash, Quote to Cash, FX Options, Orders, Prime Brokerage.
Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Integration, and Metadata Management Services
Strong understanding of Data Modeling concepts, Star & Snow-Flake Schemas, FACT and Dimensions Tables, Physical and Logical Data Models, Stored procedures, Stored Functions, Database Triggers, Packages using PL/SQL.
Experience in developing accurate business process requirements for Banks using curation of procedures, forms and artifacts.
Good Experience in AXIOM SL tool.
Experience in conducting JAD sessions, organize and facilitate meetings with stakeholders and other project members for requirements gathering, analysis and design.
Good in developing functional specification for business process.
Good Experience in creating screen mock ups.
Key strengths include requirements gathering, process analysis, project planning, tracking and delivery, estimation.
Extensive experience in project management best practices, processes, & methodologies, including Rational Unified Process (RUP) and SDLC.
Involved in issue and risk management, comprehensive documentation for all data conversions.
Extensive knowledge in QC, JIRA, Bugzilla.
Team lead skills encompassing user interviews, coordination with Tech Lead, DBAs, Developers, and QA/QC Analysts during the design phase
Skilled at interviewing Subject Matter Experts by asking detailed questions and carefully recording the requirements in a format that can be reviewed and understood by both business and technical people.
Actively involved in Gap Analysis, Business Refinement Process and Change management strategy.
Excellent analytical, problem solving, decision making and presentation skills with ability to coordinate activities in a fast paced team environment.
Good Project Management, Interview, Presentation and Facilitation skills.
Involved in creating user stories, use cases in the Agile Methodology.
Involved in Black Box testing, Integration testing, UAT, Regression Testing.
Experience in working in Web based and Client/Server Application.
Experience in monitoring performance of Webservers using Soap UI.
Experience of working in both SDLC and Agile Methodologies.
Designed and developed Master templates for Requirements, Test Strategy, Test Plan and Reports.
Experience in post installation testing and correction of any conversion problems.
Certifications
ISTQB - Foundation level
NCFM - Financial Markets Beginners Module
NCFM - Currency Derivatives Beginners Module
NCFM - Equity Derivatives Beginners Module
NCFM - Interest Rate Derivatives Beginners Module
NCFM - Derivatives Market Dealers Module
NCFM - Mutual Funds Beginners Module
CSM-Certified Scrum Master
ACAMS-Foundations Of AML
GARP-Foundations of Financial Risk
Skills
Database
SQL
Defect Tracking Tools
Jira, QC, QTEST, BUGZILLA
Testing Concepts
Functional, Web services, Mobile Application Testing, ETL Testing Basics
Other Tools
Calypso, Documentum,Visio
Testing Tools
SOAP UI
Functional skills
Requirement Analysis, Requirement Gathering, Use Cases, Scope Identification, Impact Analysis, SDLC, STLC, Waterfall and Agile
Domain
Regulatory Reporting, Derivatives, Trade Life cycle: (Front office, Middle office, Back office),Dodd Frank Act, Reference Data
Professional Experience
Project 9-Current project
Organization: Cap Gemini Financial Services
Morgan Stanley Oct 2015-Jan 2017
Client Onboarding and Regulations
MORGAN STANLEY
Business analyst of Client Reference Data, client onboarding process and regulatory programs. Analysis and solution design for Business and technical integration of reference data to consumer data systems and teams including business unit and back office functions. Holds expertise for CIP (Customer Identification Program), KYC, Counterparty Classification rules, FATCA, Governance, Risk, and Compliance
Responsibilities : Business Analyst
Understand the functionalities and preparation of use cases.
Acted as a liaison between the business and development team in gathering requirements and supporting the MDM team.
Create Weekly Data Quality Reports for Multi Brands which includes Data Extraction, Business Rules Generation, Compiling and Building Report and Trouble Shooting if any Issues.
Creating Data Dictionary with the Attributes details and definitions.
Documented the complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
Coordinate with the business users and development team.
Designed the FRD (regulatory cookbooks) for some of the regulatory programs with the requirements from the users.
Prioritization of tasks and Involved in Test Case Preparation and Review, Test Case
Execution and Defect reporting.
Involved in Black Box Testing (Regression, Integration and Sanity testing).
Timely logging and tracking of defects in Quality Center.
Coordinated with the offshore and onsite team in submitting a proof of concept for “Cucumber” to the client.
Created a manual “Darwin Dictionary” for the team members to understand the different functionalities of the application they work on.
Involved in writing BDD for automating the test scripts using “Cucumber”.
Worked in both Web based testing and back end testing using “UNIX”,”SQL” and “Stored Procedures”
Worked on several important regulatory programs from the scratch such as “Counterparty Classification”, “Global KYC”, “US KYC”, “UK KYC”,"FATCA".
Prepared monthly remediation review of accounts for examination by internal audit and federal regulators.
Performed counterparty due diligence and conducted negative media related searches to ensure compliance with federal CIP/KYC/BSA regulations.
Interviewed Business Users to gather Requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
Interacted with users for verifying User Requirements, managing Change Control Process, updating existing documentation.
Facilitated the User Acceptance Testing (UAT) with Pega System Administrators and Business Users, documented any issues or defects and eventually got sign off from the right parties.
Developed and Documented timelines for Project Delivery, and managed Projects and Resources to successful completion.
Prepared graphical depictions of Use Cases, Use Case Diagrams, State Diagrams, Activity Diagrams, Sequence Diagrams, Component Based Diagrams and Collateral Diagrams and creation of technical design (UI screen) using Microsoft Visio.
Have extensively used Documentum to handle the complex document workflows associated with the payments process and ensure that information is handled in accordance with regulatory requirements such as “MIFID”, “FIEL”.
Involved in data mapping from one database to another.
Analyzed client/vendor source data.
Performed independent and complex functional data analysis for multiple projects supporting
several data conversions at one time.
Good Experience in AXIOM SL tool for all the regulations implemented.
Project 7
Organization: Cap Gemini Financial Services
FX Options
Morgan Stanley Dec 2013-May 2014
Business Analyst of FX Options Genesis product where the user can select multiple products(Vanilla,Straddle,Strangle) at the same time and submit as a trader and check if it got processed in the blotter application of Genesis.
Responsibilities : Business Analyst
Work was performed in standard Waterfall model.
Prepared graphical depictions of Use Cases, Use Case Diagrams, State Diagrams, Activity Diagrams, Sequence Diagrams, Component Based Diagrams, and Collateral Diagrams and creation of technical design (UI screen) using Microsoft Visio.
Interacted with users for verifying User Requirements, managing Change Control Process, updating existing documentation.
Independently conducted requirements elicitation process with product owners and SMEs.
Conducted requirement walk through sessions to development and testing teams.
Identified and documented existing business process and process flows by identifying entities existent with system encompassing gap analysis.
Gathered specific requirements for new business submission, policy renewal, policy change, cancellation, premium audit and overall end to end processing.
Established partnerships across multiple businesses and functions.
Performed smoke testing on developer release code.
Assisted Developers with development effort and integration needs.
Assisted QA with business validation, knowledge transfer, and QA result validation. Wrote (inbound and outbound) mapping for all the vendors.
Wrote business rules in source to target data mapping document to make it easy and clear for developers and testers.
Created SQL scripts to find data quality issues and to identify keys, data anomalies, and data validation issues.
Documented the complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
Project 6
Organization: Cap Gemini Financial Services Aug 2013-Dec 2013
Client Onboarding
Business analyst of Client Reference Data, client onboarding process.Analysis and solution design for Business and technical integration of reference data to consumer data systems and teams including business unit and back office functions. Holds expertise for the Onboarding application “PIPE” of Morgan Stanley and helped in decommissioning of the legacy client onboarding application.
Responsibilities : Business Analyst
Understand the functionalities and preparation of use cases.
Coordinate with the business users and development team.
Designed the FRD (regulatory cookbooks) for some of the regulatory programs with the requirements from the users.
Played key role in design and gap analysis, gathering business requirements, system requirements.
Created mock ups and prototypes to help facilitate conversion of business needs into technical requirements.
Tested to verify data accuracy in staging area from sources and in delivered extracts to downstream application team.
Designed and documented web based interface UI screens and comprehensive documentation for all data conversions.
Performed data analysis and data validation using complex SQL queries.
Performed independent and complex functional data analysis for the project supporting
several data conversions at one time
Responsible for identifying and documenting business rules and creating detailed use cases, use case diagrams using Visio.
Created test scripts and logged defects/deviations via JIRA and coordinated with the business users and testers and validated their scenarios in different stages of testing.
Work was performed in standard Waterfall model.
Supported conversion testing for any conversion problems
Project 5
Hammer and Blotter,FX Options March 2013-July 2013
MORGAN STANLEY
Business Analyst of Middle Office application of Morgan Stanley, FX Options Desk team to validate the details of the client and book trades internally who want to book trades through Morgan Stanley Matrix. Several option products are available in this application. If the client wants to change his product/allocate the trade before the internal team validates and books it, he can notify it through a mail to the desk team and the product can be changed/allocation of trades can be done accordingly before booking the trade. Analysis and solution design for Business and technical integration of the front office to middle office and teams including business unit and back office functions. Holds expertise for FX Options with a good understanding of the pricing methodology.
Responsibilities : Business Analyst
Coordinate with the business users and development team.
Collaborate with customer product managers to obtain high level business
requirements and aid in scope management.
Aid client product managers to create release plans and gap analysis.
Create BRDs and conduct structured walkthroughs with the development team.
Review the development team’s SRS and guide team to develop user stories.
Manage and groom backlog items as per release plans.
Co-ordinated with the Quality Assurance (QA) team to validate Business
requirements and QA defects and review regression testing reports.
Accountable for End to End UAT management. Manage UAT defects to closure.
Review and aid in creating high level test plans and detailed test cases against
requirements.
Assisted data conversion team working with associates across various functions by preparing detailed documentation for all data conversions involved.
Prepared graphical depictions of Use Cases, Use Case Diagrams, State Diagrams, Activity Diagrams, Sequence Diagrams, Component Based Diagrams, and Collateral Diagrams and creation of technical design (UI screen) using Microsoft Visio.
Updated conversion technical specifications (known as the Data Element Listing) to support the data conversion effort.
Understand data, data relationships, and identity data gaps across multiple sources.
Worked on documenting test cases, perform testing, and document test findings.
Coordinated with clients from trading desk for requirement gathering.
Project 4
Organization: Cap Gemini Financial Services
Ecommerce Servers Feb 2012- March 2013
MORGAN STANLEY
Worked as Business Analyst and Tested different components using FIXTM messages for Options applications by booking trades from “Morgan Stanley matrix” and third party applications “Bloomberg” and checked the end to end flow from front office through middle office till back office FX applications of Morgan Stanley.
Responsibilities: Business Analyst
Preparation of Test Plan, Test Strategy, Test Execution Report and Test Sign off Report.
Aid client product managers to create release plans.
Create BRDs and conduct structured walkthroughs with the development team.
Understand the functionalities and preparation of use cases.
Coordinated with the business users and development team.
Prioritization of tasks and Involved in Test Case Preparation and Review, Test Case
Execution and Defect reporting.
Involved in Black Box Testing (Regression, Integration and Sanity testing).
Timely logging and tracking of defects in Jira.
Analyzed business requirement document.
Standardized a template for sign offs, test plans within FX team in Morgan Stanley.
Created gap analysis.
Extensively designed data mapping and filtering, consolidation, cleansing, integration, ETL, and customization of data mart.
Provided 24 x 7 problem management support to the development team.
Documented various Data Quality mapping document.
Performed small enhancements (data cleansing/data quality).
Coordinated (with business users, data base administrator and testing team) in mirror to production testing.
Project 3
Organization: Cap Gemini Financial Services
Dodd Frank Implementation Oct 2011-Feb 2012
MORGAN STANLEY
Dodd Frank Rules were implemented in all the FX option,FX orders and FX quote to cash applications and their servers. Emerging regulations for over the counter derivative markets demand greater controls for pre and post trade documentation.
Responsibilities: Business Analyst
Preparation of Test Plan, Test Strategy, Test Execution Report and Test Sign off Report
Gathered requirements and created Use Cases, Use Case Diagrams, Activity Diagrams using MS Visio
Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements
Facilitated (JAD) Joint Application Development sessions to identify business rules and requirements and documented them in a format that can be reviewed and understood by all.
Coordinate with the business users and development team.
Prioritization of tasks and Involved in Test Case Preparation and Review, Test Case
Execution and Defect reporting.
Mentored the offshore team members on implementation of the laws in different applications.
Involved in solving the environmental issues.
Created a manual of testing the applications with the dodd frank rules.
Involved in Black Box Testing (Smoke, Integration, Regression, Sanity testing and UAT).
Used MS Visio for business flow diagrams and defined the workflows.
Performed data analysis for the existing data warehouse and changed the internal schema for performance.
Wrote technical papers, gathered technical requirements, and compiled them to help the design system.
Created Use Case specifications, business flow diagrams, and sequence diagrams to facilitate the developers and other stakeholders to understand the business process according to their perspective with possible alternate scenarios
Interacted with the software development team and executive team to liaison the business requirements to ensure that the application under development adheres to the business requirement
Performed data mapping from source to target
Extensively used SQL for accessing and manipulating database systems
Participated in design walk-throughs with SMEs to baseline the business architecture
Facilitated in the overall management of the project including mitigation, status reports, client presentations, defining milestones, deliverables and establishing critical success factors
Worked closely with QA team and developers to clarify/understand functionality, resolve issues and provided feedback to nail down the bugs.
Created Use Case diagrams using UML to define the functional requirements of the application.
Wrote manual Test Cases for checking the application
Used Agile methodology for repeated testing.
Involved in manual testing by checking of various validations.
Created, maintained, and executed manual test scripts.
Developed functional specifications and testing requirements using Test Director to conform to user needs.
Project 2
Organization: Cap Gemini Financial Services
FX-OS Aug 2011-Oct 2011
MORGAN STANLEY
Internal application of Morgan Stanley which helps the Morgan Stanley FX options desk team to
Play with the volatilities of different strategies on a day to day basis.
Book trades.
Make non-auto dealable currency pair trades to auto dealable trades.
Check the number of trades that are being booked externally by the clients and by the desk.
Configure or customize the currency pairs for different clients according to their needs.
Responsibilities :BA/QA ANALYST
Preparation of Test Plan, Test Strategy, Test Execution Report and Test Sign off Report.
Prioritization of tasks and Involved in Test Case Preparation and Review, Test Case Execution and Defect reporting.
Involved in Black Box Testing (Smoke, Integration, Regression, Sanity testing and UAT).
Timely logging and tracking of defects in Jira.
Coordinating with the development team regarding new functionalities.
Maintaining the automation test pack through “Test Complete”.
Analyzed requirements and created Use Cases, Use Case diagrams, sequence diagrams using VISIO.
Extracted the business requirements for E-commerce from various sessions with business leads and maintained them using Requisite Pro, tracing them all the way to the system artifacts
Planned, coordinated, and monitored project levels of performance and activities to ensure project completion on-time
Followed established formats and procedures, created new formats, as well as researched, created, edited technical and business data documents.
Extensively used SQL for accessing and manipulating database systems.
Participated in design walk-through with SME's to baseline the business architecture.
Worked closely with QA and developers to clarify/understand functionality, resolve issues and provide feedback to nail down the bugs.
Project 1
Organization: Cap Gemini Financial Services
MATRIX Jan 2011 –Aug 2011
MORGAN STANLEY
FX Matrix executes a full suite of FX spot, quote to cash, forwards, NDFs, Swaps, Options, and Precious Metals with its seamless execution service. It covers
Booking of customizable trades, consolidate and validate the trades using trade blotters.
Flexible allocations capability with easy percentage based settings.
Auto dealable and non-auto dealable currency pairs
Responsibilities: BA/QA ANALYST
Involved in Test Case Preparation and Review, Test Case Execution and Defect reporting
Involved in Black Box Testing (Smoke, Integration, Regression, Sanity testing and UAT).
Timely logging and tracking of defects in Jira.
Maintaining the options environment in case of any trade failures in the QA plant by checking the various logs, databases and trying to solve the issue along with the dev team.
Maintaining the automation test pack through “Test Complete”.
Worked in all the stages of the Project starting from Smoke Testing, Integration, Regression Testing, Sanity Testing, UAT.
Created a manual which would help other team members to understand the application’s functionality.
Trainings
Business Communication / Trade Life cycle/Testing and Development Life Cycle, Foreign Exchange.
Education
Bachelor Degree in Engineering in Electronics and Communications, Anna University, Chennai, India
Contact this candidate