Data Sql Server

Name: Srav Cell: 416-***-****

Email: ********@*****.*** Location: Toronto,Canada

Experience Summary

Dynamic Software Testing professional in Information Technology & Services industry having the domain knowledge of Banking and Telecom Billing applications.

Highly accomplished, solutions-driven professional in QA planning, functional and automation testing of Client/Server, GUI, Web based, .Net, Datawarehouse, SSIS and ETL Packages.

Good knowledge in all stages of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).

Proficient in Requirement gathering, Strategy Decision making, Estimation, Scenario preparation, Test planning, Test data Preparation, Test execution, Analyzing Test results and Reporting.

Thorough hand on experience with all levels of testing including Smoke Testing, Ad-hoc Testing, Functional Testing, System Integration Testing, Regression Testing, End to End Testing, ETL Testing, Incremental Testing, Database Testing,XML Testing,Web Services Testing and User Acceptance Testing.

Extensive ETL testing experience in SSIS/SSRS.

Excellent Knowledge of Database Systems – SQL server, Oracle 10g and Dataware house concepts.

Extensive experience in developing SQL scripts to validate source and target database tables and reports data for backend database testing.

Proficient in troubleshooting database issues and experienced in using performance monitor/profiler to solve dead locks/ long running queries.

Experience in RDBMS, Microsoft SQL Server (T-SQL).

Extensive Working experience in applying Relational Database Concepts, data normalization and OLTP/OLAP systems.

Experience in testing Webservices, Compare the data in the webservices by using SOAP UI

Extensive experience in tracking bugs using Bug tracking tools such as HP Quality Center, Test track Pro, and JIRA.

Hands on experience in Project change control mechanisms, Impact Analysis, Risk Analysis, Defect Management, End to End Testing, pre and Post Production activites

Experience in Troubleshooting the Applications issues in Automation Scripts and SQL Transactions

Extensive experience in leading QA projects in Onsite-Offshore delivery model.

Dedicated, conscientious individual with strong sense of responsibility, work flexibility and quickly adapt to changing environments professionally and personally.

Academics

Bachelor of Engineering, Nagarjuna University

Technical Skills Set

Testing Areas:GUI Testing, Functionality Testing, Integration Testing, Regression Testing, Business Requirement Analysis, System Testing, White and Black Box testing techniques And Manual Testing, Automation testing, Webservices Testing, ETL Testing, Data base Testing

Tools: SSIS, SSRS, Informatica, Hadoop, Big data, MSBI, QTP, Selenium, Eclipse, WebLogic, Websphere, UFT 11.5

Configuration Management: SVN, TFS, Visual Source Safe 6.0, Share Point

Operating systems: Windows (7/XP/2000/NT/98/95), Windows2000/NT, Server, UNIX and MS DOS, VMWare.

Bug Tracking: HP Quality Center, JIRA, Test Track, Test Director, HP ALM

Internet Technologies: HTML, JScript, XML

Languages: C, C++, VB, VC++, .Net, Java, SQL

Databases: SQL Server 2008/2012, Oracle9i, MS Access, Toad

Tools and Packages: MS Office Suites, Microsoft Share point, Microsoft Project, Microsoft Office, and Visio, Tools built on Shell Scripts, VBScripts, Share Point

Annexure

Client: Bank Of America, USA 06/15-06/16

Project: NexOS

Role: SR QA Analyst

NexOS is primarily a data capture and integration platform for selling, originating of mortgage loans. functionality includes loan registration, underwriting, Processing, document generation, pre-closing and funding.

Responsibelities:

Gathered and customized Analyzed business requirements, functional specifications and design specifications to create the functional test decomposition to provide accurate test estimates for test case creation and Execution phases.

Effectively used the Functional Decomposition Methodology to identify test scenarios for validating all functional areas within the application.

Participated in Risk Assessment meetings and developed the risk analysis for the testing effort.

Worked with the management to change the process and add in new requirements asked, for the functional specifications.

Effectively used the Functional Decomposition Methodology to identify test scenarios for validating all functional areas within the application.

Participated in Risk Assessment meetings and developed the risk analysis for the testing effort.

Used HP QC for bug reporting, test execution and maintaining regression traceability.

Worked closely with the Development Team and the Business team to resolve defects.

Developed Regression Test Cases to validate enhancements delivered by the Development Team.

Validated XML files in Webservice Request and Response call to find the root cause of the defects

Validated the load process of Mortgage ETL to make sure the target tables are populated according the data mapping provided that satisfies the transformation rules.

Executed SQL queries for validation of data and used TOAD for SQL Server to write SQL queries for validating data integrity constraints and back-end testing

Performed data validation of duplicate Loan data is not loaded, NULL value fields and record count match

Build and executed complex SQL queries to validate source data to migrate from source to Target database.

Created various test suites to test Webservices for Mortgage application by using SoapUI Tool

Validated Webservices, Compare the data in the webservices by using SOAP UI

Provide project deliverables relating to PT according to project schedules.

Coordinate and conduct the analysis of test results Identify and report all testing related issues and risks.

Developed and maintained the Requirement Traceability Matrix.

Analyzed Test Results to determine the quality of the deliverable.

Created various test suites to test Webservices for Mortage application by using SoapUI Tool

Participated in Risk Assessment meetings and developed the risk analysis for the testing effort.

Participated in steering committee meetings and updated QA process status updates to the management.

Performed Post Implementation Verification Testing to make sure the quality of build deployed into Production is acceptable.

Obtained feedback and sign off from the business sponsor, and documented the Post Mortem Analysis document and the Lessons learnt Document and submitted it to the Management.

Worked closely with the Development team and Business Analyst while planning test activities.

Involved in Regression and String Testing of Various Releases using Agile Methodology.

Identify, create and maintain automated Functional and GUI based tests

Wrote SQL queries in Query analyzer to perform back end data validation

Worked extensively with Off-Shore team in India

Lead bug triage meetings and communicated risks to all necessary parties.

Conduct complete TCM and Test Case Review process and address all findings before delivery.

Environment: ASP.NET, XML, Windows XP/7, HP Quality Center 9.2, SQL Server 2012, Toad11.0, Visual Studio2013, Log miner, Log Viewer.

Client:Bank Of America, USA 09/13- 12/14

Project : iOriginate - AS/400 PLS loan Pool import to iO ETL

Role: Analyst

Loan origination system plans to integrate or build significant contact management and features for a variant of the product in the Bank, SQL Server Integration Services (SSIS) tool is being used in FRP project as an ETL tool to Import/Export data between heterogeneous database, and in various formats.

Responsibilities:

Participated in testing of migrating All Mortgage ETL jobs in different applications that are Implemented in SSIS,SSRS and MSBI from SQL Server 2008 to SQL Server 2012

Performed validation check on data on staging database for final migration to MortgageLoan application in the ETL process

Extensively worked on E2E testing of New ETL jobs from initial deployment to Production deployment

Worked closely with development team to ensure all the defects are ‘fixed’ or made ‘inactive’ by following up on every release going in production using Quality Center.

Reviewed the Business Requirement Document to understand the process and write Test Plan and Test Cases

Tested various Reusable ETL Transformations which facilitate Daily, Weekly & Monthly Loading of Data.

Validated data in between source and target after running ETL jobs

Executed and managed test cases and reported bugs in Quality Center.

Worked on validating the (ETL) Extract, transform and load process, by executing SQL queries to make sure the changes implemented correctly or not

Verified that all field data is loaded without any truncation and rejected data with proper error logs

Testing of ETL jobs that are scheduled for file transfers from Operational Data Stores to designated file systems/directories.

Verified data integrity check on the tables for Primary Key and Foreign Key relationship.

Responsible for communicating with Development Team and System Analyst Team in order to resolve the issues.

Tested Complex ETL Mappings based on Business requirements and business rules to load data from legacy source flat files and RDBMS tables to target tables

Performed data validation of duplicate data is not loaded, NULL value fields and record count match.

Used Toad for Data Base validation and SQL Server 2012 for ETL packages Validation.

Prepared and executed test cases ensuring that specified technical requirements were achieved Involved in various data pulls for OLAP for reporting.

Participated in Preparing the Test data to test the ETL transformation

Verified the ETL package flow in Relational databases flow by using visual studio

Involved in bug tracking meetings and other test planning meetings. Ensured that no defective products are moved to production.

Validating different real time and batch jobs which were executed by SQL server agent

monitoring the Job execution, exceptions and analyzing data Issues

Wrote simple to complex SQL queries to verify the database tables for the data inserted from the GUI.

Validated all the test deliverables (test cases, test reports, defect log reports etc) and sign off.

Environment: SSIS, SSRS, SQL Server 2012/2008, TOAD 11.0, TFS 2013, Visual Studio, Quality Center 9.2, Windows XP

Client: Bank Of America, USA 11/10-09/13

Project: Fulfillment

Role: QA Analyst

Fulfillment is a web based application that provides an end to end solution for the FFRP system will significantly reduce the Mortagege Loan processing time, It is a replacement system for the existing system in production

Responsibilities:

Analyzed Functional Specification document and derived necessary test scenario to evaluate the software product.

Attended requirement gathering meetings with Project Manager, Business Analysts, Architecture team and Development team.

Interacted with the testing and development team to resolve issues and worked with developers to resolve them.

Validated XML files to find the root cause of the defects

Validated Webservices, Compare the data in the webservices by using SOAP UI

Participated in Data base and Back end testing by executing the SQL quries

Extensively Used Automation Test tool Selenium for execution of Regression Test Suite on New Builds

Experience in automation testing using Selenium IDE/Webdriver

Participated along with the test lead in creating and maintaining Testing project schedules with respect to Project releases

Prepared Requirements Traceability Matrix to ensure comprehensive test Coverage of Requirements

Monitor of the Production fixes and provide them to Business team, allocate those fixes for testing with in the time lines

Perform Build Verification Test and reported the results to Team.

Defects were tracked, reviewed, analyzed, compared using JIRA and Defect Testing, Re-Testing the Defects

Reported defects and generated QA status reports with exit criteria were determined for signoff.

Preparation of test cases, schedule them in cycle and execution.

Validated E2E scenarios based on the various business flows and impact on different Downstream systems and also prepared final report of the high priority scenarios for the business need and also examine those results with them

Presented Daily and weekly reports with regards to the outstanding defects, their status and resolution for metrics creation used in measuring the Process and Product Quality

Environment: ASP.NET, XML, Quality Center,SQL 2008, Toad11.0, Jscript, Java, Visual Studio2013,JIRA, TFS, Selenium, Log miner, Log Viewer.

Client: Highland Lakes Software (HLS), USA,India 11/08-11/10

Project: CAS Liberty

Role: Software Engineer

CAS (Communication Accounting System) supports the processing and billing of different sort of usage like calls, internet, etc. Telecomm industries can use this software to process the telephone usage, rate those usages,generate bill statements and process Payment for the customers. CAS requires that user should provide enough information about the customer to render a correct bill, in the format desired. So we should be able to setup the customer in the system. User should get the data for the customers and feed into the system. We should be able to group the customers into departments. Once we setup the customer then each customer can have one or multiple phone numbers. We talk about phone usage, eventually usages will be associated with the phone numbers. If customers are having multiple phone numbers then it can be grouped into departments.

Responsibilities:

Create and Review Functional test plan, test cases, conditions and scenarios for Rating module

Responsible for End to End Testing and User Acceptance Testing for overall scenarios for the CAS Client/Server Application

Performed adhoc Testing,Functional Testing,Integration Testing and Regression Testing

Prepared UAT/E2E Test Plan, Test Scenarios and Test Case's based on Business Requirement Document/Design Document

Identified application error and Ensured that all high-Prioriy bugs are fixed prior to deployment

Interacted with Business Users to find out exact Functionality of Application

Praticated in generating the new build activities for the latest code by using Viper

Performed Usability Testing and Pilot Testing to signoff UAT Testing phase.

Participated in Weekly Status meetings with Project manager, Developers, Test Manager and other Team Members.

Defect reporting and tacking of defect fixes using JIRA

Maintaining and setting up application/test environments, test data and other prerequisite before starting the testing efforts.

Environment: Windows XP, Test track pro,.Net, Oracle,MS SQL, Viper

Contact this candidate