Test Cases Sql Server
Resume:
SHRIGOURI SUBRAMANIAN
**********@*****.***
**** **** ************ ******, *** 224, TAMPA, FL 33614 SUMMARY
• Certified Test Engineer experienced in the areas of test strategy preparation, test plan development, test case creation with compliance to quality assurance standards and policies
• Excellent experience with Software Development Life Cycle (SDLC) process and OOAD concepts
• Tested web-based as well as desktop applications with tools like HP’s Unified Functional Testing
(UFT), HP’s Performance Center (PC), Application Lifecycle Management (ALM), Business Intelligence Studio (BI).
• Experience in developing web applications using HTML5
• Experience working with different databases such as Oracle PL/SQL, SQL Server 2008
• Hands on experience in Integrated Development Environment (IDE) such as Eclipse, NetBeans
• Leverage knowledge in User Interaction, Business Analysis, Development, Integration, client interaction, Documentation, Testing, Maintenance and Enhancements of projects
• Performed system, unit, acceptance, regression, load and functional/performance testing on applications using both automated and manual testing methods
• Developed automated regression test suites using automated testing tools.
• Fostered a continuous improvement approach to QA activities.
• Reviewed tools implementations and encourage best practices and sound design principles while remaining practical and deadline driven.
• Worked closely with software developers to perform early testing on components prior to integration builds.
• Ability to handle multiple tasks and to work independently as well as in a team
• Strong interpersonal, mathematical, communication, and writing skills
• Ability to effectively prioritize and execute tasks in a high-pressure environment
• Ability to work independently, with minimal supervision
• Self-motivated, highly committed, versatile team player and a quick learner with a positive attitude
• Have EAD (Employment Authorization) to work in the US with any employer and can start to work immediately.
TECHNICAL SKILLS
Testing tools : UFT(QTP 11.0), ALM, PC, BI, VUGEN
Languages : SQL/PL-SQL, Java, C
Web Design : HTML 5, CSS 3, ASP.Net, XML
IDE and other tools : Eclipse, NetBeans
Database : MySQL, Oracle 11g, SQL Server Management Studio UML tools : Rational Rose, Visual Basic 6.0
Operating System : Windows, Unix
Desktop Application : Microsoft Office suit
2 P a g e
CERTIFICATIONS
• Oracle Database SQL Expert
License Oracle Testing ID: OC1587126
• ISTQB - BCS Certified Tester Foundation Level
Certificate Number: 00314579
• SSGI certified LEAN Six Sigma Green Belt Professional ID Number: 10490356
PROFESSIONAL EXPERIENCE
Infosys Ltd, Chennai, India
Test Engineer Sep 2013 – Oct 2014
PROJECT 1: IN ESSENCE BANK OF INFOSYS
The objective of the project is to test the functionalities and performance of the banking application. The application holds savings and current accounts of the users. One can deposit, withdraw, transfer and also do balance enquiry with this application. The application should also be tested for handling load. The maximum number of user requests it could handle without crashing the system is its capacity.
Responsibilities:
• Review requirements specifications and technical design documents to provide timely and meaningful feedback.
• Estimate, prioritize, plan, and coordinate testing activities.
• Create detailed, comprehensive and well-structured test plans and test cases, execute the application, look for possible combinations of inputs and prepare unit test cases.
• Come up with test design specification, test suite and obtain the test data against which the application needs to be tested.
• The test cases probably tested smooth transition between pages and the ease with which user can navigate between options. It also checked for any constraint violation
• Identify, record, document thoroughly and track bugs.
• Perform thorough regression testing when bugs are resolved.
• Log in the defects using ALM and create a test summary report
• Maintain and update the Reports
Tools: UFT, PC, ALM
PROJECT 2: MAKE MY TRIP WEB APPLICATION
The main objective of the project is to develop a web application. This application allows us to book the tickets, search availability of flights, book hotels, search for vehicles etc. Once a booking is successfully made it should be added to the database, likewise if a booking is canceled the data should be removed from the database. If a user is looking for flights and if its unavailable on that particular day, the application should come up with alternate dates.
3 P a g e
Responsibilities:
• Been a part of the requirement gathering and analysis.
• Review requirements specifications and come up with a user friendly and interactive interface using Windows form designer and web designer.
• The GUI was designed by dragging and dropping the widgets.
• Analyzed the requirements carefully and developed the frontend pages.
• Involved in front-end and back-end development
• Provided web application client support.
• Create SQL scripts to design the Database
• Monitored and reported on client problems and issues. Tools: Visual studio 2010, SQL server 2008
Project 3: AT&T
• Review the requirements with utmost care and design the pages.
• Developed AT&T mobile app pages using HTML 5, CSS 3
• Tested if the pages meet the requirements and is fully functional and fit in the standards.
• Actively communicate with a team leader and peers to discuss/seek best solution of existing problems/concerns to achieve assigned tasks
• Fix various current and/or regression defects that are being assigned
• Manage the defect tracking and report the bugs
Tools: JIRA, TFS, HTML 5, CSS 3
Silver Tongue, Coimbatore, India
Senior Trainer Jul 2011 – Jul 2013
• Have been part of accelerating the skillset of the corporates’ workforce by imparting training to them on areas of soft skills, interpersonal skills, telephone and e-mail etiquette
• Have been an effective source of bringing in walk ins to the institution through effective call marketing.
• Have directly participated in demonstration of the institution’s training services to companies, schools and colleges.
• Have trained graduates to appear for an interview by coaching them on essential skills for cracking an interview
• Responsible for design of aptitude modules for competitive exams
• Trained students on topics like verbal reasoning, logical reasoning, analytical reasoning, accent neutralization and soft skills
• Have trained in-house as well as at corporate offices 4 P a g e
Other Projects
• TITLE: VIDEO SURVEILLANCE: A NOVEL APPROACH USING FACE RECOGNITION TECHNIQUE
OBJECTIVE: To identify unauthorized persons by comparing the images that are stored in database to that of the picture occurring in the video that is captured, using face recognition techniques.
RESULTS:
The images were obtained from video.
It was successfully compared with input image stored in database. Similar images were recognized and alerts were sent successfully. Tools: Eclipse Gany Mede, JMF Studio
EDUCATION
Info Institute of Engineering, Coimbatore, India Aug 2008 – May 2012 Bachelors of Technology in Information Technology
Bachelor of Technology, Passed with Distinction
Contact this candidate