Test Cases Sql Server

Baby Srutuhi Mamilla

470-***-**** ******************@*****.***

Professional Summary:

•5+ Years of experience in Software Quality Assurance and Testing for ETL, in the field of Telecom, Retail domains

•Expertise in analyzing Business specification, Use cases, Functional Specification & Technical specification documents

•Well versed with Preparing ETL Test Scripts and Test Execution.

•Experience in working with the various relational databases like Teradata, Oracle, and SQL Server

•Experience in working in UNIX Environment.

•Extensive experience in HP Application Lifecycle Management (ALM).

•Experience in Selenium.

•Knowledge in Hadoop echo system. Good Exposure on Usage of different Talend Hadoop Component like Hive.

•Proficient in creation and execution of Test Plans, Test Scripts and Test Cases using both Manual and Automated testing techniques.

•Extensive experience in Smoke, Sanity, Functional, System and Regression Testing

•Worked in Software Development Life Cycle (SDLC) like Waterfall, Agile Scrum & Dev Ops Models.

•Demonstrated ability to work independently and flexibility to adapt in an ever changing business environment.

•Excellent Team Player with strong written, communication, interpersonal, analytical skills. Capable of working under high stress environment with resource constraint

Technical Proficiency:

Languages

JAVA, SQL, PL/SQL

RDBMS:

Oracle 8i/ 9i/10g, MS SQL Server, Teradata 14

Testing Tools

HP Application Life Cycle Management 12.0, Selenium

Tools

Teradata SQL Assistant, Informatica

Dev Ops Tools

Rally

Operating Systems

Windows, UNIX, DOS

Other tools

SOAPUI, CVS, TOAD, WinSCP, SQL Developer

Project Summary:

Client: Macy’s Systems & Technology, GA

Role: Sr. QA Analyst

Duration : July 2017 - till now

Supported business-wide Oracle data quality and ETL testing for Enterprise Data Management (EDM) system in Macy’s

Responsibilities:

•Creating requirements Traceability matrices and Test plans & Test Cases from Business and functional requirement documents

•Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.

•Analyzing requirements and creating and executing test cases

•Test Case Execution and Adhoc testing

•Performed Integration, End-to-End, system testing.

•Involving in Functional Testing & Regression Testing

•Involving in writing complex SQL queries to verify data from Source to Target

•Performed data validation testing writing SQL queries.

•Used Quality Center for creating and documenting Test Plans and Test Cases and register the expected results.

•Using HP ALM for storing, maintaining the test repository, bug tracking and reporting

•Experienced in retest the existing test cases with the different kind of source systems for different periods of data.

Environment: Informatica 9.1, HP ALM12..0, Oracle 10g, Teradata 14, SQL server SSIS, SQL server SSRS), PL/SQL, Toad, XML, XSD, PERL 5.12.1, XML Spy, Flat Files, Autosys, UNIX, IBM AIX 6.1, Shell Scripting, Windows server

Client: T-Mobile, GA

Role: QA Analyst

Duration : feb 2013 - jan 2015

Analyzing various data sources such as flat files, ASCII Data, EBCDIC Data, Relational Data (Oracle, DB2 UDB, MS SQL Server) from various heterogeneous data sources.

•Involved in complete SDLC (System Development Life Cycle).

•Validated performance utilization charts, optimized and tuned SQL and designed physical databases. Assisted developers with Teradata load utilities and SQL.

•Gathered the required information from the users. Interacted with different system groups for analysis of systems.

•Validated the data into the Teradata database as per the business requirement

•Expertise in performance tuning the user queries execution of frequently used SQL operations and improves the performance.

•Played a major role in setting up different regions - Testing, Integration, Performance, Break fix and Production environment with the Wrapper scripts and setup and folder structure for Teradata scripts to run in UNIX environment.

•Assisted in Batch processes using Fast Load, BTEQ, UNIX Shell and Teradata SQL to transfer cleanup and summarize data.

•Understanding BRD, Data required document and mapping documents.

•Teradata Query man to validate the data in warehouse for sanity check.

•Created test plans and involved in system testing.

•Exposure in selenium testing

.Environment: Teradata12, Business Objects, Hyperion, BTEQ, Korn Shells, MS Visio, Remedy, Kintana, $U and Informatica.

Client: Charter Communications, NC

Role: QA Analyst

Project: Charter SOA

Duration july 2010 - nov 20112

Description:

The Charter Business (CB) product management organization has defined a need for the Migration of a unified web service platform for service delivery to CE devices and the third Party integration efforts. OSB will act as a front door for all Charter backend systems. Requests from OSB will integrations to various backend systems e.g. Adrenalin, Air-Command to support business objectives.

Responsibilities

•Analyzing the Requirements and coordinating with BA’s and any gaps in requirements share those gaps with onsite team and get clarified from them through on Call.

•Interacting with development and QA Teams to ensure overall quality of the Software.

•Help the team to identify the Scenarios to Cover End to End Functionality.

•Performed Web Services testing using SOAPUI Tool.

•Defect reporting and tracking.

•Maintain Traceability Matrix on day to day requirement changes.

•Reviewing Team Defects before assigning to Developers.

•Communicating with client on day to day work status.

•Daily Client Communication and updating the QA status in On Call during Execution Phase.

Environment: SOA OSB, Weblogic, Core java, SQL Developer, CSG, Windows 7, SOAP UI

Educational Qualifications:

•Master of Science in Computers (M.Sc.),Apr 2005, Nagarjuna University, India.

•Bachelors of Science in Computers (B.Sc), Apr 2003, Nagarjuna University, India.

Contact this candidate