SUMMARY:

• Information Technology Professional with experience in Application development and Production support using Microsoft - Word and Microsoft-Excel, Oracle SQL, PL/SQL and Crystal reports.
• Good Experience in Software Development Life Cycle (SDLC) including analysis, logical design, Resource Planning, code development, testing, implementing and maintenance.
• Subject Matter Expert in Oracle PL/SQL, Crystal Reports.
• Strong Experience in interacting with users, analyzing client business processes, documenting business requirements, performing design analysis and developing design specifications.
• Expert in backend programming using PL/SQL and SQL.
• Strong Experience writing interfaces, triggers, stored procedures and PL/SQL packages to provide database access and manipulate functionality.
• Extensive experience in Relational Data Base Management Systems (RDBMS).
• Experience in optimization of SQL statements using Techniques like cost based and Rule based optimization and accordingly Generated Explain plan.
• Strong experience in working with multiple projects in high pressure environment.
• Excellent Analytical, trouble-shooting, and problem-solving skills at Mapping Requirements to test cases, providing traceability to requirements, creating and documenting Test plans, Test cases, Test scripts, Test procedures, Test Data from the requirements document for various applications.
• Creating test data, including the Test Input data using Test Management Tools and defining the configurations and expected results for Integration Testing for both positive and negative test scenarios.
• Experience in executing different types of Testing including Smoke Testing, Functional Testing, Regression Testing, System Testing and Performance Testing.
• Application life cycle management including requirements management, test management and business process testing using HP Quality Center.
• Wide exposure to Software Quality Assurance and testing experience in the area of Manual Testing, Automation Testing,
• Testing on Desktop applications, Web applications, Client/Server, E-Commerce and Mobile application.
• Worked on Database concepts and SQL. Load UI functionalities.
• Experience in all phases of Software Development Life Cycle (SDLC), Rational Unified Process (RUP), Agile (scrum) and Waterfall Method that helped in thorough reviewing and understanding of business requirement document and functional specifications.
• Knowledge of VB.Net & HTML & Java programming languages.
• Generate graphs and reports in order to indicate the status and progress of testing efforts, and presented them to stakeholders, and work with developers to troubleshoot them.
• Strong communication skills for interacting with developers, technical support personals, and other department representatives and customers.

TECHNICAL SKILLS:

Testing Tools: HP Quality Center, QTP/UFT, Test Complete

Environment: Web applications, Desktop applications

Languages: VBScript, Java, JavaScript, XML, HTML

Databases: SQL Server, Oracle

Bugtracking Tools: Quality Center, Test Complete

Operating Systems: Windows

PROFESSIONAL SUMMARY:

Confidential

IT Functional Analyst

Responsibilities:

• Performs a quality assurance software manual testing role for the Department of Budget and Management's Central Collection Unit.
• The software tester is responsible for developing functional test cases based on documented requirements
• Develop test data for use during test execution, executing documented test cases, logging results and reporting defects in QA
• Complete and providing regular and on-demand status updates on progress of tasks,Identify, resolve, and proactively communicate potential problems .
• These testing activities include determining if the system operates as intended, responds correctly to all types of inputs, performs its functions within an acceptable time period and achieves the expected results its stakeholders desire.
• The new debt collection system being tested is a Java application with a SQL Server database.
• Peripheral systems include web portals, Interactive Voice Response (IVR), payment processing, dialer and document management.
• Attention to details, good verbal and written skills, experience communicating with technical staff and the ability to work in situations where priorities change.
• Developed SQL reports using complex queries as per client request as a part of production support.

Confidential, MD

Oracle PL/SQL Developer / QA Tester

Responsibilities:

• Participated in reviewing system requirements and studying work flow diagrams in order to make detailed test cases and expected results.
• Continuously test e - commerce website and online payment gateway using various test methodology and tools.
• Documented detail test scripts for various functionalities of WMS in the Microsoft excel according to the requirements.
• Extensively wrote SQL queries (Inner join, left outer join, right outer join, update, select, insert, delete) to retrieve the data from the database and created the test data
• Tested different functions of the system such as Opening, Encoding, Pricing, Cycle Count, Put away, Replenishment, etc. to make sure that the system meets the requirements and expectations
• Cordinated System Integration Testing of the applications for Inbound and Outbound sections
• Used SQL queries for data validation at the backend.
• Manually checked the backend of the system using SQL queries.
• Actively participated in retesting and regression testing.
• Widely involved in inventory validations after executing test scenarios of functional testing, integration testing, and regression testing
• Documented and reported the test results and defects with the test data at the end of the day
• Coordinated with Test Team in order to verify the defects and to replicate the issues
• Participated in training new team members and helped them to understand the business process and system requirements