Sign in

Test Cases Sql Server

Phoenix, Arizona, United States
January 16, 2018

Contact this candidate


Poojitha Jaya

Phoenix, Arizona *****

Cell: 408-***-****

Professional Summary

Strongly skilled and experienced CSharp Dot Net Developer with vast knowledge of a variety of computer languages. Adept at all aspects of web and technical support. Able to present work accessibly to executive-level decision makers.

Core Qualifications

High proficiency in developing and supporting JavaScript AJAX and CSharp Dot Net applications

Excellent knowledge of Windows 2000 2003 and XP for enterprise environment analysis

Strong knowledge of data-intensive website development

Superior proficiency with XML and schema usage

Exceptional ability to multitask and work well under stress

Proven ability to research and solve complex problems unassisted

Sound written and oral communication skills

Proficient in different types of testing that includes Functional testing, System Testing, Integration testing, Interface Testing, Regression testing, Business Process Testing, Conversion Testing & Sanity Testing.

Performed Black Box, Performance, Disaster Recovery and Validation testing during the testing life cycle of the product release.

Experience in designing, documenting and developing Effort Estimations, Test Plans, Test Specifications, Test cases and Automation Test scripts.

Well versed with writing detailed test cases and automation test scripts for functional, regression, system, unit and integration testing.


American Airlines, Phoenix, Arizona 12/13/2016- Present Dot Net Developer

Roles & Responsibilities

•Used N-tier architecture for presentation layer, the Business and Data Access Layers and were coded using C#.

•Designed User Interface System using HTML5, CSS, JavaScript, AJAX, JSON, AngularJS (2.0), Immutable and reactive forms, and Bootstrap(4).

•Used Workflow Services for make the Business flow.

•Used Unit Testing using Karma.

•Architect and developing Enterprise level applications which involved creating Web API.

•Used ASP.NET MVC Page Controller pattern to add functionality to individual pages such that to accept input from the page request, invoke the requested actions.

•It also allows us the flexibility to scale down the software and develop features that are required for our datacenter and our networking needs.

•Created Data Access Layer (DAL) to communicate with the SQL Server Database.

•Created Stored Procedures, Functions, and Triggers using MY-SQL in SQL Server 2012 to insert, update, and delete data inside tables.

•Installing and supporting IIS for use with Web applications.

•Development of enterprise reports by pulling data from various sources and presenting in SQL Server Reporting Services (SSRS).

• Used AngularJS to implement rich functionality in various pages: form validation, CRUD operations, grid, search, multi-selection, advanced directives, authentication, users switch etc.

•Used AJAX module to handle Restful calls to enable communication between view

components and servers.

•Developed Restful Services using Web API that are consumed by various Client applications for routing data between different systems.

•Extensive utilization of XML, XSLT and CSS for front end development.

•Actively participated in several unit tests using MS Test.

Used GIT With TFS for all the source code maintenance among the whole team.

Successfully worked with the client’s quality assurance team to get the document management application tested and ready for production under a tight deadline.

Cogno Labs, India May 14 -Nov 14 QA Tester

Roles & Responsibilities

Prepared detailed test cases by understanding the business logic and user requirements for manual testing

Coordinated onshore/offshore QA team.

Developed and executed test cases in Version One Tool and log defects in Jira Tool.

Participated in Scrum meetings (daily stand-up, planning, review and retrospective meetings).

Identified QA tasks for user stories and provided time estimates.

Discussed ways of improving/adapting the agile process to fit our team.

Demoed the features to product owner in review meetings.

Actively participated in Agile process for SDLC.

Tested the application in multiple browsers: IE 7/8/9, IE Compatibility view, Firefox, Chrome.

Used IE Developer Tool as diagnostic tool for IE Compatibility testing and error messaging.

Tracked and coordinated production road blocks.

Managed production defect calls with clients.

Created and executed SQL queries to perform Data Integrity testing on an SQL Server Database to validate and test data using SQL Server Assistant.

Developed advanced keyword driven automation framework using Rational Functional Tester and Quick Test Pro that allowed beginners to write scripts using the pre-defined keyword library

Participated in Smoke, Regression, Integration and End-to-End testing.

Validated mapping of Informatica using SQL Server Assistant.

Frequently performed SQL queries that include sub-queries and joins (inner, right outer, left outer) to verify data shown on UI and reports matches exactly what is in the databases.

Worked with SQL extensively to cross-check data against multiple schemas and databases.

Created test cases that involved SQL scripts with multiple joins.

Reviewed the log files in UNIX/Linux environment for real-time error messages to identify problems.

Created defects with detail information that includes input test data, expected and received results, and errors in UNIX server logs.

Constantly checked log files for exceptions, performance data, debug information etc.

Tested billing charges based on conference options selected and actual conference results.

Mocked test data in xml files and uploaded to database.

Used Waterfall, Iterative Agile process and Scrum methodology.

Tracked and verified production defects and enhancements in JIRA during product upgrades.

Participated in production support and attended calls to perform general smoke tests.

Developed automated Test scripts using QTP/ UFT to perform Functional and Regression testing.

Used transaction set EDI 837 to transmit health care claims and billing payment information between payers with different payment responsibilities.

Worked closely with the development team.

Used SharePoint to share the documents with in the product development team.

Developed and executed test cases for EWS (Enterprise Web Services) /XML / Soap and Restful services using SOAPUI tool.

Updated WSDL file as needed for Endpoint, Tested request and response XML. Added Assertions to validate the response xml with database.

Environment : HP ALM Quality Center, QTP, Soap UI, HTML, XML, JIRA, SQL, SQL Server, UNIX, Java Script, TFS.

Additional Information


Analysis Tools: IIS, Visual Studio 2010, Firebug, SVN

Programming: R programming, Python, .Net, C#, HTML, CSS, WCF, JavaScript, LINQ, ADO.NET, AngularJs

Software: .Net Framework 4, MS Office, MS Excel

Databases: SQL, Oracle

Datamining: Decision Trees, Market Basket Analysis, Clustering, PCA, Random Forests, Neural Networks

Statistical Techniques: Logistic, Multiple Regression, ANOVA, Hypothesis Testing, Factor Analysis


Master’s – Computer Science 2016

University of Michigan Flint, MI

Bachelor’s – Computer Science 2014

Jawaharlal Nehru Technological University Hyderabad, TG

Contact this candidate