Sql Server Test Cases

Shrutika Walunjkar

Email: ************@*****.***

Mobile: +1-425-***-****

To pursue a challenging career in the field of Computer Science that utilizes my ability to

analyze, develop, and implement technology solutions. Wish to be part of a work culture where

self- improvement is cultivated as a habit.

Professional Summary

Allyis Inc – Test Engineer

1.Microsoft, Redmond Jun 2017 – till date

Capgemini India Pvt. Ltd, Pune, India- Associate Consultant Jul 2014 – Oct 2016

1.Morgan Stanley, (US) Jul 2014 – Oct 2016

Accenture Services Pvt. Ltd., Pune, India – Software Engineer Apr 2011 - Jun 2014

1.Vodafone UK, May 2013 – Jun 2014

2.TELUS (Canadian telecom major), Sep 2012-Apr 2013

3.BASF (Global Chemical Majors), May 2011 – Aug 2012

Education

Bachelor of Engineering (B.E.)

75.65% Shri Ram Institute of Technology Jabalpur, India

Skills

Languages – SQL, PL/SQL, Oracle, C#, C++, REST services, Azure services, Azure database

Database - SQL Server Management Studio 2008, Teradata, Oracle, Sybase

Technologies – Azure SQL Data Warehouse, ETL testing, Web testing, API Testing using REST, Test Automation using Selenium, Web services, HTML, XML, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), HP Quality center ALM,UNIX,IQ+ Omegas, VSTS

Enterprise Technologies - Microsoft Dynamics CRM 4.0 2011

Projects

Microsoft, Redmond Jun 2017 – till date

Working on Microsoft Dynamics CRM platform with customization of entities

Designed ETL flows to extract data from CRM application and stored in MS-SQL DB

Developed, executed and documented test plans for Unit and System Integration Testing.

Designed, configured SSIS packages for daily and monthly reporting

Created test strategies, test plan and test cases for weekly and daily pass for Microsoft’s retail In store and online transactions

Responsible to carry out all the Database management activities with the new feature addition to the retail stores

Single handedly performing UI and data exchange activities hosted at remote location

Responsible for CRM maintenance

Morgan Stanley, (US) Jul 2014 – Oct 2016

Experience in the Functional Automation and Performance Automation of the API and the Web services, Web Applications using C#, .NET Framework, AZURE REST APIs, Selenium and SQL Server.

Created the Multi-Dimensional data model (STAR Schema) and enhanced it to meet the growing requirements due to various corporate groups accessing the data.

Validated ETL mappings and tuned them for better performance and implemented various Performance and Tuning techniques

Responsible for scheduling, running and monitoring autosys batches.

Created scheduled tasks in SQL Azure using SSIS packages

Experience in creating SSIS packages to load data from SQL server into Azure SQL datawarehouse

Created the ETL architecture and provided strategy related to data cleansing, data quality and data consolidation

Created test scenarios; wrote and executed test cases, created test data, and managed defects.

Created and debugged complex ETL processes using T-SQL queries, functions, stored procedures.

Created Test Strategy for Enterprise Data Warehouse in ETL framework, including Business Intelligence

Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries

Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security

Experience in defect management and Bug reporting using Quality center, JIRA

Performed functionality, regression, GUI and negative testing and verified transaction entries in database.

Maintained test matrices, conducted defect calls with stakeholders and created test summary report.

.

Vodafone UK May 2013 – Jun 2014

Developed SSIS ETL packages. Testing and deployment for SIT and UAT phases

Involved in validating the ETL mappings from various systems (CRM, OLTP) to transaction history/reporting database

Responsible for data validations for initials/re-load and delta/incremental loads

Writing test cases, test scenarios for various releases using HP ALM tool

Worked on stored procedures and functions to automate the process of generating SSRS reports

Sole point of contact from offshore team and closely worked with client representatives

Provide after sales support through issue resolution and fixing defects

TELUS (Canadian telecom major) Sep 2012-Apr 2013

Participated in end to end ERP application testing along with dashboard testing and data migration.

Worked on regular upgrade and enhancement in the application.

Conducted trainings for the end users as well as assisted while demonstration.

BASF (global chemical major) May 2011 – Aug 2012

Development, testing and maintenance of SSIS packages using SQL Server Management Studio

Skilled in Analysis, Design and Developing test cases for SQL objects verification and testing.

Conducted trainings for the end users as well as assisted while demonstration.

Contact this candidate