Business Analyst Data Warehouse

Career Summary:

Having around * years of IT experience.

Ability to understand & demonstrate Functional requirements

Hands on experience in understanding and managing client expectations

Functional Responsibilities: Requirement gathering, application design, configuration, Test script generation,training end users and production support.

Expertise in SQL queries for backend testing and validated database, comparing data with front end

Worked on both Manual and ETL testing

Extensive knowledge of QA methodology, standards and procedures such as creating test strategy, test plans, test cases, test result documentation for User Acceptance Testing (UAT).

Experience in working with Business and Development teams to coordinate & schedule testing efforts and resolve issues.

Experience in ensuring test environment is ready with all the systems access approvals secured and preparation of Test data without having to waste any time before the execution commences.

Thorough understanding of the entire Software Development Life Cycle and Software Testing Life Cycle

More than 2 years of experience in writing SQL queries using Oracle Database.

Experience in working under Waterfall and Agile methodology

Excellent analytical and problem solving skills have good communication skills and a good team member.

Completed B.Tech in Electronics and Communication branch from Rajasthan Technical University.

Technical Skills:

Operating Systems

Windows

Languages

SQL,C

Database

Oracle

ETL Tool

ESP

Testing Tools

QC, UFT, Load Runner

Domain

Banking(Capital Markets)

Others

Toad, Putty, JIRA

Work Experience:

Worked as an Analyst Programmer in Syntel Ltd, Mumbai

Work Summary:

Project 1 : IMS On-boarding

Job Profile : Business Analyst, Functional and Database Tester

Domain : Banking and Finance

Tools : ESP, My StateStreet

Database : Oracle

Employer : Syntel Ltd

Client : State Street Corporation

Description

The project is in the On-boarding of Investment Management Suite. All the Middle office and Back-office processes of Morgan Stanley is targeted to On-board on State Street’s application. Project involves Testing of Transaction Management, Data Migration, Reconciliation, current application enhancement and End Client Report Generation. Major role involved in Testing of various End Client Reports like Valuation Reports, Transaction Reports, etc. which counts to around 950 Reports.

Responsibilities:

Worked as a Functional Tester and Junior Business Analyst for the End Client Reporting Division.

Responsible for creating appropriate Test Scenarios and Test Cases.

Executing Test Cases and Raising Defects.

Creating Queries in SQL Application for validating the data in End Client Report.

Backtracking of Final Data till Core and Category Level and ultimately till Data warehouse by creating ESP Queries.

Test Management, Defect Management in BUAT phase of SDLC.

Raising Defect for the incorrect implications in Data warehouse for the corporate actions.

Requirement Gathering, analyzing the BSDs and validation of Business (Operating) models.

Skilled in backend testing using SQL queries.

Conveying market fundamentals of various capital markets instruments to the Developers for successful enhancement of IRD (Interactive Report Development) Application as the Report Generation Tool.

Maintaining the conceptual liaise between the Business Acceptance User and Operational Users.

Responsible for delivering the innovative and practical solutions whenever needed.

Creating Report Understanding Document from the BSD Owners.

Understanding the Corporate Action impact on the Data warehouse.

Worked on Reconciliation of Multiple Data like FX-Rates, Price between Client Environment and State Street Environment.

Has worked of Transaction Management activity where Trades has been posted and their flow and brakes has been analyzed.

Contact this candidate