SUMMARY

• Experience in SDLC process and STLC processes and best practices
• Proficient in gathering and analyzing the Business Requirements, documenting System Requirement specification, Functional Requirement specifications, Requirements
• Proficiency in Microsoft Office suite (Word/Excel//PowerPoint),SharePoint.
• Proficiency in IBM RQM system, Creates and executes test cases link and tracks the progress of defects in RQM.
• Developed Test Strategy, Test plan, Test cases, and Test scripts and various other project documentation in Application lifecycle management (ALM)
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server and Flat Files.
• Experience in Automation testing using QTP/UFT.
• Created user defined and custom functions using VB scripting.
• Developed automated test scripts using VB Script to perform Functional and regression testing in QTP.
• Experience in testing and writing SQL and PL/SQL statements.
• Expertise in TOAD, SQL Developer, WinSQL, Davis and BTEQ query tools.
• Expertise in working in Agile Environment (Scrum), Waterfall.
• ETL testing experience and extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing in a corporate - wide-ETL.
• Extensively used Rational's Quality Manager (RQM), Secure FX, Secure CRT, Web Services and SOA, Eclipse, Pegasus, Even Producer, INFOConnect, Eclipse, XML Spy WSDL in order to creates test data files and perform the test executions.
• Solid Back End Testing experience by writing and executing SQL Queries. Performed backend testing for Database integrity by executing complex PL/SQL queries for validating the data in the backend database tables.
• Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL).
• Excellent knowledge of system integration testing, software testing methods, and 508 policy and best practices
• Enthusiastic, Success driven, customer-focused, result oriented, willingness to learn and work hard to achieve the goals, ability to travel extensively, ability to work cooperatively, tactfully and diplomatically with a diverse group of people.
• Strong analytical, good communication skills and the ability to work independently with minimal supervision and perform well as part of a team.

TECHNICAL SKILLS

Data Warehousing: Informatica 9.x

Reporting Tools: Micro Strategy.

Data Modeling: Star-Schema Modeling, Snowflake-Schema Modeling, FACT and dimension tables, Pivot Tables, Erwin

Testing Tools: RQM, UFT/ QTP/ALM, Load Runner, JIRA, TFS, SharePoint

RDBMS: Oracle 11g/10g, MS SQL Server 6.5/7.0, 2000, UDB, DB2, Sybase, SQL Server 12.0/11.x, MS Access 7.0. Selenium.

Programming: VB .NET, Soap, WCF, IIS, JavaScript, ETL, J2EE,UNIX Shell Scripting, Korn Shell, C Shell, Bourne Shell, Bash, SQL, SQL*Plus, PL/SQL, TOAD, C++

Environment: UNIX, MVS, HP-UX, IBM AIX 4.2/4.3, Novell NetWare, Win 3.x/95/98, NT 4.0, Sun-Ultra, Sun-Spark, Sun Classic, and SCO

PROFESSIONAL EXPERIENCE

Confidential, Herndon, VA

Quality Analyst

Responsibilities:

• Participate in requirements gathering sessions
• Create test plans for SIT testing
• Create test cases for SIT testing, including the identification, collection and/or creation of test data
• Involved in developing detailed Test strategy, Test plan, Test cases and Test procedures using ALM for Functional and Regression Testing.
• Execute frontend, and backend tests.
• Writing SQL queries and statements to test database for retrieving information, editing data and inserting data.
• Ensure test scenarios based on business process flows have been created.
• Develop, update and maintain quality testing standards and procedures
• Assist in the planning, creation and control of the test environment(s)
• Facilitate and participate in structured walk-through, and peer reviews
• Lead/participate in the coordination, and execution of release testing
• Mentor other testers on methodology framework testing processes, and application knowledge as appropriate
• Determine and meet time estimates, and schedules for testing efforts.
• Keep management informed of testing progress status regularly.
• Performance CRUD operation and verification ACID Properties with SQL.
• Performed backend testing for Database integrity by executing complex PL/SQL queries for validating the data in the backend database tables

Confidential, Lanham, Maryland

QA/ ETL Tester

Responsibilities:

• Analyzed requirement documentation, functional specification, design documentation and translated the functional requirements into Test cases.
• Creates Test Plan, Test cases, test scripts, Complete the Peer review process, executes test cases execution records(TERs) record test results and attached test artifacts with applicable screen shorts in the RQM.
• Extensively used IBM Rational Quality Manager (RQM)
• Involved in multiple projects and participated in meetings with SME and Business Analysts.
• Followed Agile Methodology to emphasize on real time communication over written documentation and to minimize risk by implementing software test effort in short time sprints or iterations.
• Estimate, prioritize, plan and coordinate testing activities and actively participated in the team meeting with QA lead and Manager .
• Creates Data files in Pegasus for All required Confidential Form.
• Logged into the defects using KISAM and linked the defect with RQM assigned them to corresponding developers..
• Writing SQL queries and statements to test database for retrieving information, editing data and inserting data.
• Performed backend testing for Database integrity by executing complex PL/SQL queries for validating the data in the backend database tables
• Participated in Integration, System, Smoke and User Acceptance Testing and production testing using RQM.
• Ensured weekly deliverables of the requirements as per the Agile Model.
• Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries.
• Reported outstanding bugs, followed up bug fixes, conducted review of existing test scenarios and assessed the need for their enhancement.

Confidential, MD

ETL TESTER

Responsibilities:

• Design and Created test plan, test scenarios and test cases for Data warehouse and ETL testing..
• Involved in daily Scrum meetings (Agile Methodology). Also involved in Iteration/Sprint planning meeting to plan the stories that needs to be developed and tested in the upcoming sprint based on the priority and estimated effort.
• Tested mappings with the Design Documents and also performed testing for various sample data.
• Developed Test Strategy, Test plan, Test cases, and Test scripts and various other project documentation in Application lifecycle management (ALM).
• Exclusively used test plan module to write and test lab module to execute the test cases in Application lifecycle management (ALM).
• Exclusively used requirement module for requirement and defect module for entering the defects in Application lifecycle management (ALM).
• Created, enhanced and maintained high-end test scripts for various functional and regression using Quick Test Professional and VBScript.
• Used Informatica Power Center as an ETL Tool for extraction, transformation and loading (ETL) of data into the Enterprise Data Ware House (EDW).
• Responsible for testing Micro strategy Reports by running the SQL Queries on the database by reviewing the report requirement documentation.
• Exported the results through SQL and documented the test results for test cases, suites executed.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security .
• Involved in promotion of Informatica code and Unix Shell scripts in development and testing phase.

Confidential, Buffalo, New York

QA Analyst

Responsibilities:

• Analyzed requirement documentation, functional specification, design documentation and translated the functional requirements into Test cases.
• Involved in running test cases and documenting the logs and results.
• Uploaded test cases to the Test Plan Module in ALM from test case template.
• Created test sets in Test Lab Module and executed the test cases against the application.
• Involved in Smoke Testing, Functional Testing, Regression Testing, System Testing.
• Logged the defects using ALM and assigned them to corresponding developers.
• Test Scripts in VBScript to test various functionalities using the automated tool QTP/UFT and also wrote manual Test Cases according to functional documents and requirements.
• Involved in Smoke Testing, Functional Testing, Integration Testing and Regression Testing using QTP/UFT.
• Conducted various management activities by analyzing and verifying test results, providing status reports.
• Writing SQL queries and statements to test database for retrieving information, editing data and inserting data.
• Performance CRUD operation and verification ACID Properties with SQL.
• Performed backend testing for Database integrity by executing complex PL/SQL queries for validating the data in the backend database tables.

Confidential, Richmond, VA

QA,TESTER

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Involved in developing detailed Test strategy, Test plan, Test cases and Test procedures using ALM for Functional and Regression Testing.
• Tested functionality of the application by inserting various check points like standard check points, text check points, table check points, image check points, and database check points in QTP.
• Created, enhanced and maintained high-end test scripts for various functional and regression using Quick Test Professional and VBScript.
• Developed automated test scripts using VB Script to perform Functional and regression testing in QTP.
• Actively participated in test case automation using a structured, key word driven framework with QTP.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security.
• Agile Methodologies. Experienced in the use of agile approaches, including Extreme Programming, Test-Driven Development and Scrum.
• Involved in multiple projects and participated in meetings with SME and Business Analysts. Conducted Validation and Verification of bug fix.
• Performance CRUD operation and verification ACID Properties with SQL.
• Performed backend testing for Database integrity by executing complex PL/SQL queries for validating the data in the backend database tables.
• Intensively conductedFunctionality, User Interface,Security, and Regressiontesting during the various phases of the development usingQuality Center.
• Published the final test results as test metrics and upload to specified links where project team has access to verify results
• Monitored adherence to quality standards in development, testing and business processes and able to produce quantifiable metrics to measure success
• Assisted user testing of systems (User Acceptance Testing),developing and maintaining quality procedures and ensuring that appropriate documentation is in place.
• Conducted Functionality testing during various phases of the application using QTP.
• Performed various types of testing such as Functional, Regression, SIT, UAT, Backend.
• Creating Automation Scripts (VBScript) in the sprints and stored them in the Test-Plan module of ALM/Quality Center.