PROFESSIONAL SUMMARY:

• Over 7+ years of IT experience in Software Analysis, Planning, Design, Development, Testing, Maintenance and Augmentation for various applications in data warehousing platform. Focusing on business needs and conceptualizing then in technology perspective and translating them into viable technical solutions using current technologies.
• Hands - on experience and strong understanding of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
• Possess excellent team management, communication, documentation, analytical and problem solving skills. Good exposure to various SDLC methodologies including Agile (Scrum), TDD and Water Fall. Ability to learn new technologies quickly, excellent communication skills and versatile team player.
• Experience in analyzing Business Requirement Document (BRD), Functional Requirement Specification (FRS) and developing TEST PLAN.
• Expert in different types of testing that includes Black Box testing, Smoke testing, Functional testing, System Integration testing, End-to-End Testing, Regression testing & User Acceptance testing (UAT) & Involved in Load Testing.
• Experience in Web Services Testing using SOAP UI and REST UI.
• Experience in creating Requirements Traceability Matrix to ensure comprehensive test coverage of requirements.
• Expertise in use of HP ALM/Quality Center for writing test cases, test execution, defect management, defect tracking, analyzing, reviewing and Bug Reporting.
• Expertise in querying and testing RDBMS such as Oracle, MS SQL Server and Teradata using SQL, PL/SQL for data integrity and good knowledge in UNIX/Linux operating systems.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica and SSIS.
• Very good Experience in working with Product Owner, Business Analysts, Development team and End Users
• Good interpersonal skills, committed, result oriented, hard working with a quest and zeal to learn new technologies.

PROFICIENCY IN:

ETL Tools: Informatica 9.0/8.6, SSIS

Testing Tools: HP ALM/Quality Center, Informatica DVO and HP QTP/UFT

RDBMS and Tools: ORACLE 10g/11g, SQL*PLUS, Teradata, MS SQL SERVER (2012/2008 R2), TOAD, DB2

Operating System: UNIX, LINUX, Windows

Front end/Languages: JAVA, XML, HTML, Java script, .Net, Shell scripting

Design Tools, IDE: Eclipse, MS-Visio 2000

Web server & ServletEng: Tomcat, WebLogic

Test Management Tools: Rally, JIRA, HP/ALM

Communication: Web services, REST and SOAP, XML, CSS

Version controls/ Tracking: Clear Case, TFS

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

QA Analyst/SQL Tester

Responsibilities:

• Analyzed the Functional requirements using Scenarios & DDD (Detailed Design Document).
• Responsible for implementing Test Driven Design (TDD) approach in one of the projects.
• Extensively involved in Developing Test Plans, Test Scenarios, Test Strategies and Test Cases with inputs from the assigned Business Analysts. Tested functionality across applications and workflows.
• Ran SQL queries to verify the number of records from Source to Target and validated the referential integrity, Time variance, Missing records, and Nulls/Defaults/Trim spaces rules as per the design specifications.
• Executed the Test Scripts in TOAD and documented the results in RTM. Involved in test designing and development of Data warehouse environment.
• Worked with XML feeds from multiple source systems and loaded the same into Enterprise data warehouse.
• Compared query result sets from different database systems using UNIX diff command.
• Performed data analysis and data profiling using SQL and Informatica Data Explorer on Oracle.
• Involved in various testing phases like Unit Testing, System Integration Testing, Validation Testing, User Acceptance Testing, Parallel Testing, Performance Testing and Regression Testing. 
• Tested web services by generating XML SOAP UI Requests and validated the corresponding XML SOAPUI Responses.
• Worked with data validation, constraints, record counts, and source to target, row counts, random sampling and error processing.
• Follow up with the developers on defects status on a daily basis, and generate defect reports for managements.
• Agile methodology followed in software life cycle. Involved in PROD deployment preparation and QA sign off.

Environment: Agile, TDD, Oracle 11g, TOAD, SQL Server, SQL, XML, Soap UI, Unix, SQL Server, HP ALM/Quality Center.

Confidential, Pennington, NJ

QA Functional Tester

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center 9.0.
• Used my web service expertise in testing web services via SOAP UI, using the open source testing tool Soap UI.
• Import and export the loss event records using SOAP UI.
• Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and SQL Server.
• Used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
• Responsible to verify data completeness, data transformation, data quality, integration testing, UAT & regression testing.
• Tested and developed the mapping for extracting, cleansing, transforming, integrating, and loading data using Informatica.
• Worked on Informatica to resolve production issues perform testing and debugging of mappings and reports Extraction of test data from tables and loading of data into SQL tables.
• Performed Verification, Validation, and Transformations on the Input data (Text files, XML files) before loading into target database.
• Monitored the Informatica workflows using Power Center monitor. Checked session logs in case of aborted/failed sessions.
• Performed Web Services testing and Validated XML request/response data using SOAP UI.
• Perform Functional, Data Validation, Integration, regression and User Acceptance testing.
• Created test cases and executed test scripts using Quality Center.

Environment: HP ALM/Quality Center, Agile, SOAP UI, SQL Server, XML, .Net, Restful Web Services, WSDL Oracle 11G, Web Sphere7, HTML,TOAD, Clear Case and Clear Quest.

Confidential, Newark, DE

QA Analyst

Responsibilities:

• Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes in reference to business requirement document.
• Participated in daily Scrum Stand-ups for QA updates and defect status.
• Analyzed the data mapping document and developed test scenarios and strategies to verify the data migration from different data sources also researched various production issues.
• Performing back-end testing of the DB by writing SQL queries to test the integrity of the application and Oracle databases.
• Tested the source data for data completeness and data correctness.
• Writing complex SQL queries for checking the counts and for validating the data at field level and row level.
• Prepared sample test data by inserting data into staging tables.
• Written and executed the functional and regression test scripts.
• Worked with UNIX commands like GREP, LESS and Diff.
• Tested data from various sources like Oracle, flat files and SQL Server.
• For tracking the Defects used the tool HP Quality Center 11. Performed Black Box, Integration, and Regression Testing. Investigated and reported bugs to the developers.

Environment:, HP Quality Center 11, Unix, SQL, Oracle 10g, PL/SQL, XML, Teradata V2R5, Flat Files.

Confidential, Flexxperts, MA

QA Analyst

Responsibilities:

• Interacted with the Business Clients, Product Owner, Developers and QA Manager for clear exposure to trickle down the technical/functional User Requirements & Change Requests to Test Plans and Test Scenarios.
• Identified the Test Scenarios based on Functional Specifications and Business Requirements.
• Perform Functional Testing, Regression Testing, and System Integration testing and End to End Testing.
• Identified test cases to automate and automated those test cases using Selenium Web Driver.
• Used Selenium Web Driver API to automate tests on cross browser and cross platform environment. Sound knowledge on Object Oriented Programming concept and Java Language.
• Responsible in executing Selenium test scripts on different browsers and checked for compatibility. Tested the application in highly dynamic environment with sprint team using agile methodology.
• Created and enhanced numerous test scripts to handle changes in the objects, in the tested application's GUI and in the testing environment using Selenium Web Driver.
• Used firebug to identify object's ids, Name, X-Paths, links in the application.
• Provide all data validation through SQL queries to perform Back-end testing
• Participated in Walk through and defect report meetings periodically.
• Responsible for keeping up with the test schedule and interacting with software engineers to ensure clear communications on requirements and defect reports
• Involved in user acceptance testing and helped to promote into prod environment.
• Maintain the test scripts in the source repository.

Environment: QC, SoapUI, TOAD, XML, HTML, SOAP, JAVA/J2EE, Selenium and Rest Web Services, LOG4J, Oracle 9i, Stored procedure, Star Team as a version controller.