SUMMARY

• Experience in SDLC process and STLC processes and best practices
• Proficient in gathering and analyzing teh 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 teh 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 teh 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 teh data in teh backend database tables.
• Strong working experience in teh Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL).
• Excellent noledge 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 teh goals, ability to travel extensively, ability to work cooperatively, tactfully and diplomatically with a diverse group of people.
• Strong analytical, good communication skills and teh 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 teh 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 teh planning, creation and control of teh test environment(s)
• Facilitate and participate in structured walk-through, and peer reviews
• Lead/participate in teh coordination, and execution of release testing
• Mentor other testers on methodology framework testing processes, and application noledge 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 teh data in teh backend database tables

Confidential, Lanham, Maryland

QA/ ETL Tester

Responsibilities:

• Analyzed requirement documentation, functional specification, design documentation and translated teh functional requirements into Test cases.
• Creates Test Plan, Test cases, test scripts, Complete teh Peer review process, executes test cases execution records(TERs) record test results and attached test artifacts with applicable screen shorts in teh 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 teh team meeting with QA lead and Manager .
• Creates Data files in Pegasus for All required Confidential Form.
• Logged into teh defects using KISAM and linked teh 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 teh data in teh backend database tables
• Participated in Integration, System, Smoke and User Acceptance Testing and production testing using RQM.
• Ensured weekly deliverables of teh requirements as per teh 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 teh 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 teh stories dat needs to be developed and tested in teh upcoming sprint based on teh priority and estimated effort.
• Tested mappings with teh 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 teh test cases in Application lifecycle management (ALM).
• Exclusively used requirement module for requirement and defect module for entering teh 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 teh Enterprise Data Ware House (EDW).
• Responsible for testing Micro strategy Reports by running teh SQL Queries on teh database by reviewing teh report requirement documentation.
• Exported teh results through SQL and documented teh 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 teh functional requirements into Test cases.
• Involved in running test cases and documenting teh logs and results.
• Uploaded test cases to teh Test Plan Module in ALM from test case template.
• Created test sets in Test Lab Module and executed teh test cases against teh application.
• Involved in Smoke Testing, Functional Testing, Regression Testing, System Testing.
• Logged teh defects using ALM and assigned them to corresponding developers.
• Test Scripts in VBScript to test various functionalities using teh 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 teh data in teh 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 teh 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 teh 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 teh data in teh backend database tables.
• Intensively conductedFunctionality, User Interface,Security, and Regressiontesting during teh various phases of teh development usingQuality Center.
• Published teh 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 dat appropriate documentation is in place.
• Conducted Functionality testing during various phases of teh application using QTP.
• Performed various types of testing such as Functional, Regression, SIT, UAT, Backend.
• Creating Automation Scripts (VBScript) in teh sprints and stored them in teh Test-Plan module of ALM/Quality Center.