Test Cases Sql

Vamsi Mohan

Phone: +1-864-***-****

Summary:

* + years of experience in Information Technology with extensive knowledge in Application Support, Quality Assurance, Data Analysis and Manual Testing.

Expertise in all stages of SDLC including Requirements Gathering, Project Planning, Analysis, Design, implementation, Testing, Management, Reporting, integration and post development maintenance in Agile Methodology.

Experience in writing complex SQL queries, procedures, functions, packages, cursors, exception handling, triggers, collections and performance tuning.

Expertise in Data Base Design, Application Development & Production Support in Client/Server Environment.

Strong Business Analysis experience on Data Analysis, Business Requirement Documents, Data Migration Documents, User Requirement Gathering, User Requirement Analysis, Gap Analysis, Data Cleansing, Data Transformations & Impact Analysis.

Extensive experience in Design, Development, Implementation & Administration of Database systems using DDL, DML, DCL commands for various business applications.

Experience in database programming in writing T-SQL Stored procedures, Triggers, Constraints (Primary Key, Foreign Key, Unique) Indexes and Batch Scripts using various DDL and DML commands including SQL Queries, joins, functions, trigger, store procedure.

Good knowledge in Tuning SQL queries & improving the performance of the Database and ability to work independently or as part of a team to accomplish critical business objectives.

Experience in Software Quality Assurance and Software Testing of Client/Server Applications and Web based applications and experience in preparing Test Plans, Test Scripts, Test Cases and Test Data.

Good experience in handling various production support roles and programming Skills in Core Java and J2EE Technologies and Hands on experience on tools such as Eclipse, Notepad, Toad, Linux etc.

Excellent written and Verbal communication & interpersonal skills and team player with very good communication skills and leadership qualities.

Attended project meetings and interacted with teams, Project managers, team members /associates, business users and internal customer’s/ end users.

Highly dedicated to produce professional work with highest quality and creativity.

Ability to build and maintain strong working relationship with all levels of management and professional demeanor in high-stress situations.

Technical Skills:

Databases

MS SQL Server 2005/2012, DB2, MySQL, Oracle, MS Access.

Database Tools

Enterprise Manager, Query Analyzer, SQL,Oracle

Languages

SQL, T-SQL, MySQL, C, PL/SQL, HTML, XML, Java

Web Technologies & Servers

Web Services, XML, HTML, WebSphere and Web Logic

Operating System

Windows 2000/2003 /Vista/XP and UNIX, MS DOS

Applications, IDE

MS Visual Studio 2010, MS office2003/2007/2010, HTML, XML, Eclipse

Academic Qualifications:

University of Central Missouri,

Missouri, USA

Master of Science - (3.7/4.0) GPA

Computer Information Systems & Information Technology

2015- 2016

Anna University, Chennai, India

Bachelor of Engineering - (80 %)

Electronics and Communication Engineering

2005-2009

Professional Experience:

Java Application Support/Programmer Analyst

Citi Financial, Fort Mill, SC Oct 2016 – Present

Responsibilities:

Provided production support for the application and coordinated with cross functional teams. Part of production support team, which involved in resolving production related issues.

Prepared and released data base scripts, Involved in bug and code fixes in the existing system and fixed complex production issues for system enhancements

Part of Change/release support and worked with change management and release managers.

Interact with client, advanced business analysts and solution developers to determine and resolve system issues and defects

Coordinated with tier 2 and tier 3 java production support assistants and prepared compiled reports of issues reported through telephone and e-mail

Prepared SQL and PL/SQL scripts to create alter, drop Tables, Views, and Primary keys, Indexes, Constraints, Packages, Sequences, Grants and Synonyms and worked on preparing various DDL, DML, DCL commands.

Investigation of problems including design, code and test and implementation of fixes.

Prioritized and scheduled daily activities for the department and assigned specific duties to each team member

Mentored/ assisted other developers with implementation and debugging problems.

Used GIT as source control management giving a huge speed advantage on centralized systems that have to communicate with a server.

Highly experienced with Java and its umbrella products for different applications

Prepared test procedures according to the features implemented in the programs.

Involved in documenting software defects and track these defects through the test lifecycle to resolution.

Documented all the work that I completed during the project phase and shared the same with the team for future reference and also prepared documents for all programs developed by the team

Provided user support in all phases of SDLC till its successful implementation.

Involved in development, deployment and implementation of dynamic web applications using application servers like WebSphere, Apache tomcat in Windows and UNIX environments.

Worked closely with various teams during UAT and production release with management and business owners of all functionality to ensure that quality standards are met.

Reviewed and analyzed business requirements and functional specifications to establish testing needs.

Worked in agile environment and interacted with developers and business analysts for defect issues and handled all types of production tickets.

Managed Client relationship effectively by interacting with the business team directly.

First line support for Incident for internal and external solutions, covering the full technology stack.

Track incidents and assist the Project manager for planning and delivery of Production defect fixes and Maintenance Releases Write and test codes for Java enabled web application

Resolved production errors and deployed applications for end user

Executed performance review and solicited user feedbacks for applications for web portals

Good Knowledge on the Springs Framework to use with Annotations, Restful Web services, SOAP Web services, EXT.js scripting framework

Involved in critical migration of Reports between different environments.

Wrote SQL, PL/SQL and stored procedures as part of database interaction.

Environment: Core Java, JDK 1.6, J2EE, Spring MVC 3.0, Hibernate 3.0, SOAP, Web services, Rest Web services, WebSphere Application Server, Agile, SCRUM Methodology, JavaScript,, AJAX, JSP, XML, UML, Unix Shell Scripting, Windows, Maven, ANT, Oracle10g, Log4j, Windows, MS-Office, Web sphere, TOAD, Oracle, Java, Web Sphere, SQL, Oracle 10i, Java, XML, UNIX, Windows, Web logic, MS Word, MS Excel, HTML.JSON, Eclipse, WebSphere, spring, Hibernate, Restful web services.

SQL Data Analyst

Department of Revenue, Chelsea, MA Jan 2016 – Oct 2016

Responsibilities:

Worked on producing tables, migrating reports, stored procedures, Triggers and performed complex data manipulations

Created DML statement and queries with Joins, Sub-Queries

Prepared SQL and PL/SQL scripts to create, alter, drop Tables, Views, Primary keys, Indexes, Constraints, Packages, Sequences, Grants and Synonyms.

Worked on SQL*Loader to load data from flat files obtained from various facilities every day.

Created Indexes and used HINTS for faster retrieval and used Import/Export Utilities of Oracle.

Create database objects such as tables, views, stored procedures, Triggers etc.

Design and develop PL/SQL procedures, query performance tunings.

Experience in creating, maintaining and tuning Views, Stored Procedures User Defined Functions and System Functions using SQL Server, PL/SQL.

Performed restores from production to other environments and Ran jobs/create new jobs using SQL Server agent. Also involved in Performing re-building and re-organizing the indexes.

Run trace to identify slow running queries and perform analysis on slow running queries with execution plan.

Expert in writing SQL queries and optimizing the queries in Oracle, SQL Server 2008.

Strong experience in using Excel and MS Access to dump the data and analyze based on business needs.

Experienced working with Excel Pivot and VBA macros for various business scenarios.

Created and added tables to the Oracle database when required using SQL statements.

Managing security by creating and granting Roles and Privileges to users.

Worked on external Tables, Views, Joins, Cluster indexes and Created Public Synonyms, DB Links.

Experience in creation of table partitioning by range, list, hash, composite methods and Indexes for managing large tables.

Database design and development including Tables, Primary and Foreign Keys, Indexes and Stored Procedures.

Generated SQL and PL/SQL scripts to install create and drop database objects, including tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.

Database performance monitoring and identifying bottlenecks hindering the performance of the database.

Tune SQL statements using hints for maximum efficiency and performance, create and Maintain/modify PL/SQL Packages, mentor others with the creation of complex SQL Statements, perform data modeling and create/maintain and modify complex database Triggers and Data Migration scripts.

Created changes in the database according new requirements (new tables in the existing database and fields in the existing tables).

Constructed and implemented multiple-table links requiring complex join statements, including Outer-Joins and Self-Joins.

Created, debugged, and modified Stored Procedures, Triggers, Tables, Views and User-Defined Functions.

Involved in analysis, design and coding of Oracle processes in PL/SQL to build Packages.

Design and Development of data validation, load processes, test cases using PL/SQL, Stored Procedures, Functions, Triggers using Oracle 10g.

Created Indexes and Sequences for faster retrieval of the customer information and enhance the database performance.

Involved in creation of Tables, Join Condition, Nested Queries, Views, Sequences and Synonyms for the business application development.

Developed Database Triggers, Packages, Functions and Stored Procedures using SQL and maintained the scripts for various data feeds.

Created Indexes for faster retrieval of the customer information and enhance the database performance and used Import/Export Utilities of Oracle.

Created the External Tables in order to load data from flat files and PL/SQL scripts for monitoring.

Environment: Oracle, SQL Server 2008, PL/SQL, TOAD, MS Access, MS Excel, Flat Files, PowerPoint

Quality Analyst

Voola Software Solutions PVT LTD, Hyderabad, India Jan 2014 to Dec 2014

Responsibilities:

Worked with cross functional team, and participated formal/ informal meetings.

Participated in creating Test Plans, created Test cases for each release for testing the business rules and functionality of the application.

Perform end to end, functional testing, Regression testing.

Worked on all kinds of scripts to create alter, drop Tables, Views, and Primary keys, Indexes, Constraints, Packages, Sequences, Grants and Synonyms and worked on preparing various DDL, DML, DCL commands.

Verified the data by executing the SQL statements

Reviewed the defects with development team and reported the defects in Test Director

Analyze, design and build testing procedures that deliver the clients goals and provide our clients with maximum value.

Verified if the application is installed correctly on windows, and UNIX.

Created security access matrix and tested the user privileges.

Reviewed the Business Requirements Documents, Functional Design Document and Technical Design Document.

Involved in developing Test Plan, Test Strategies and Test Cases.

Performed Sanity Testing to check for the initial application stability.

Used Test Director for uploading requirements, creating Test Plans, Test Cases, Test Sets and updating Test results.

Performed Installation, up gradation, regression, UAT, and functional testing on various platforms.

Extensively used MS-Excel for creating QA reports.

Analyzed the Functional Requirements and Design Specifications documents to ensure that the system met all of the technical and business requirements of the applications.

Manually generate and implement templates for Test plan, Test Cases, and Test Scripts and performed Manual Testing on the entire application.

Worked closely with software developers, business analysts, Sys admin, and other project management personnel involved in Software Development Life Cycle.

Created Test Cases manually for Functional testing based on the Functional areas and Use Case documents.

Created, maintained and updated test strategy, test conditions, test cases and regression testing based on business requirement.

Developed test cases and scenarios in accordance to the technical specifications and project plans provided by the appropriate business analysts.

Participated in requirements and design specification reviews and technical documentation reviews as essential to performed assigned duties

Executed manual tests, documented results, communicated issues, and verified issues resolved.

Focused on usability, functionality and installation.

Prioritized defects to be fixed using an understanding of the business requirements and the needs of the customer.

Established and maintained documentation of all products and automated tests.

Reported bugs/errors and ensured issue/problem resolution is communicated in a timely and effective manner between Developers.

Developed test plans based on an understanding of the business functionality and the software testing methodology.

Environment: SQL, PL/SQL, Oracle 10g, Flat Files, Excel, PowerPoint, SQL Developer, SQL Loader, UNIX, SQL Developer.

QA Tester/Analyst

Markey International LLC, Bangalore, India May 2009 – Dec 2013

Responsibilities:

Checked the data flow from front end to backend and used SQL queries to extract the data from database.

Worked directly with developers to report discrepancies and to resolve defects and track changes to status.

Involved in planning and creating Test scenarios and Test objectives to ensure that the system modification will meet the specified business requirements.

Participated in collecting and analyzing the business requirements.

Manual Testing was done to perform functional testing on the User interface.

Perform Manual and Back-end testing using SQL in Oracle relational database.

Involved in Manual User acceptance testing with various combinations.

Involved in business meetings with developers and other testers.

Generated test execution reports and release status assessment report.

Review requirements documentation in order to clearly identify priority and impact of test cases.

Extensive experience in running various kinds of tests such as Unit, Functional, Regression, Integration, System, End to End for Client/Server Applications.

Reviewed Business Requirement and Software Specification Requirements to achieve better understanding of the Application.

Prepared Test Plan and Test Cases.

Executed Test Cases and Gathered Test Execution results.

Tested the Functionality of the application through manual Testing.

Developed Test Scenarios and Test Procedures based on the test requirements.

Created Test Cases manually for Functional testing based on the Functional areas and Use Case documents.

Created, maintained and updated test strategy, test conditions, test cases and regression testing based on business requirement.

Developed test cases and scenarios in accordance to the technical specifications and project plans provided by the appropriate business analysts.

Performed calculations on Excel, reported server performance and Performed extensive manual testing on different modules.

Tested the Application compatibility in different Web Browsers and on Multiple Platforms

Manually tested calculations using MS-Excel and cross checked for results data.

Provided test plan, daily reports on the functional or performance testing effort.

Generated the detailed reports of the bugs and pass-fail report.

Involved in Preparation, Reviewing and Execution of test cases.

Involved in writing Test Plan for the web application after analyzing the specifications and business requirements

Performed End-to-End Manual Testing of the application.

Worked on various DDL, DML, DCL commands.

Wrote several Test Cases for testing various functionalities.

Performed compatibility testing on various browsers and operating systems to ensure excellent user acceptance.

Created test cases as well as modified and reviewed test cases developed by other testers.

Worked closely with Developers, Business Analysts, and User Representatives and participated in the product design process including specification and other document reviews.

Perform installation, maintenance, and system support for testing tools. Wrote test cases and test scripts for functional and integration testing.

Performed Performance Testing to identify abnormalities in the web application.

Developed test cases based on business and functional requirement.

Conducted Regression testing, Integration testing and User acceptance testing for various combinations.

Environment: Oracle, Java, HTML, Window XP, PL SQL, Windows, Flat Files, Excel, PowerPoint

Contact this candidate