SUMMARY:

• 9+ years of experience in Functional Testing, UAT Testing, Database Backend Testing, ETL Testing, BI Testing, Automation Testing in Web Technologies, server client application.
• Hands on experience on working with huge data using Excel Mapping / Excel Pivots / SQL queries.
• Hands on experience on Automation scripts execution and analyzing scripts using QTP.
• Good knowledge on data warehouse concept, ETL lifecycle, BI reports and writing complex SQL query.
• Writing and maintaining automation script using QTP for regression testing. Expertise in Framework - Keyword Driven, Data Driven, Hybrid, Linear, Functional Decomposition.
• Hands on experience on QC/ALM, Rally, Jira, Clear Quest, Doors.
• Involved in preparing the Test plan, Test Report and Bug Reports.
• Experience in Executing Black box testing and White Box testing according to the test plan.
• Experienced in conducting Test Case Reviews and Preparation of Traceability matrix to identify missing test cases and test scenarios.
• Good at communicating with Leads, Developers and Project Leads to resolve the Testing Issues and Defects.
• Proven ability to work in both independent and team environment with superior problem solving, analytical, presentation, good inter personal skills and self-motivated team player.
• Analyzing skills with a desire to learn and adapt to new technologies and tools.
• Expertise in developing Test strategies, Test procedures, Testing Standards and Requirement Traceability Matrix (RTM).
• Highly experienced in Software Development Life Cycle working from Scratch to Implementation phase in Agile and Waterfall methodologies.
• Excellent problem solving skills with strong technical background having the ability to meet deadlines, work under pressure and quickly master new technologies and skills.

TECHNICAL SKILLS:

Testing Tool: (UFT)QTP, QC/ALM, Rally, Jira, Clear Quest, Doors, TOAD, SQL Developer

Programming Languages: .NET, SQL/PL-SQL, HTML, DHTML, Perl, PHP, Java, Java Script, XML, CSS.

Databases: Oracle, DB2, SQL Server, Teradata, Vertica.

Operating Systems: Windows, Linux

Packages: MS Office (Word, Excel, Power Point)

PROFESSIONAL EXPERIENCE:

Confidential, Washington D.C.

ETL/BI Test Lead

Environment: GreenPlum, Oracle, Informatica Powercenter, Control M, BO, XML, ClearQuest, Linux.

Responsibilities:

• Data Staging, Process and output validation in Hadoop.
• Validating EDI Files
• Validate ETL Source to Target Mapping specs.
• Validate ETL Business Rules, Logic.
• CDC, Data Sync (Incremental, Real Time) Validation.
• Source to Staging, Data mart, View, Report Validation.
• Record count, duplicate key, null values, data types, junk data, data size, Mandatory field, primary key, surrogate key generation, Derived Field check.
• Control M Job run, Physical table structure validation.
• Extract File (XML, CSV, TXT) Validation for downstream application.
• Data migration validation from Oracle to SQL Server.
• Write complex queries to validate source to target data.
• Supporting projects averaging between 150-200 data tables.
• Write stored procedure to automate testing process using t-sql, vbscript, sqlcmd.
• Analyze data model, source to target mapping specs, technical design document.
• Import data from XML, CSV, and Text file into database tables to validate.
• Performed data analysis, troubleshoot, find root cause of bad data.
• Validate fact, dimension tables, SCD types, Historical load, and incremental load.
• Wrote SQL Statements to extract Data from Tables and to verify the output Data of the Reports.
• Writing test data, requirements, test cases, RTM, test plan.
• Responsible for Analysis and Execution of the pre-implemented new release.
• Participated in Peer Review and bug logging.
• Working directly with clients to gather requirements, and analyze them.
• Create application mockups for testing team to analyze requirements, write test cases.
• Create bug reports, test documents, release documents.

Confidential, New York, NY

QA Analyst

Responsibilities:

• Responsible for validating reports in OBIEE and TABLEAU.
• Responsible for writing test plan for data warehouse testing and business application.
• Analyzing the Requirements
• Participating in preparing Test Plans
• Preparing Test Scenarios, Test Cases
• Preparing Test Data for the test cases
• Preparing Test Environment to execute the test cases
• Peer Reviewing the Test Cases prepared by other team members
• Responsible for writing scripts for testing data as well as develop business enterprise data warehouse application
• Handle the tasks of integrating and testing data warehouse for small and large applications
• Perform responsibilities of databases architecture, testing data quality for load systems, and providing data warehouse solutions.
• Handle responsibilities of data modeling and evaluating new technologies to implement in data warehouse testing.
• Performed responsibilities of testing data warehousing systems and maintaining data testing environment.
• Handled the tasks of supporting staff in data post implementation stage and in handling project life cycle phase.
• Prepared test case and performed testing by following standard test methodologies.
• Reviews CI’s and project deliverables per the project’s defined
• Peer Review Matrix
• Test Execution and Defect Tracking
• Escalate risks and issues to appropriate teams/resources to ensure timely resolution
• Ensure that defects and corrected are retested comprehensively
• Handled other job responsibilities as assigned by the data warehouse staff.
• Write complex query in Sql developer and TOAD Data Point in Vertica and Oracle DB.
• Write automation scripts in UNIX using VI editor.

Environment: QTP, ALM, Jira, Perl, PHP, Vertica, Oracle, UNIX, OBIEETABLEAU.

Confidential, Philadelphia, PA

QA Analyst

Responsibilities:

• Responsible for identifying the functional test cases for Regression Testing and automated these scripts using Quick Test Pro(UFT).
• Created Quick Test Pro scripts with Local and Shared Object repositories and maintained them in Object Repository Manager and SVN.
• Used Quick Test Pro to conduct Data Driven Testing by using XML data as a test data source.
• QTP Framework design with automated mail reporting using Outlook Application, Database connectivity, Excel Datasheets, Custom Libraries and Environment files.
• Created Scripts for application business process by analyzing the best candidates for automation with Quick Test Pro, Data Driven Testing as well as Keyword Driven.
• Developed QTP Automation Scripts using Descriptive Programming, Dictionary Objects, Custom Functions, Modular Actions, and Driver Script.
• Used Object Repository, Object Identification, set the Environment variables, Output value, Recovery scenario etc. in Quick Test Pro.
• Performed Functional, System-Integration and Regression testing.
• Attended daily defect status meetings and weekly team status meetings for reporting testing status and shared ideas for improved testing efforts.
• Reviewed, analyzed FRD, developed strategies, test plans, and executed the test cases.
• Developed test cases using design documents, use cases, and Functional Requirements.
• Responsible for Analysis and Execution of the pre-implemented new release and version.
• Analyzed and maintained requirements and created Test Data, Traceability between Requirements and Test Cases.
• Experience in black box testing and white box testing according to the requirements.
• Participated in Peer Review and bug logging using Bug tracking tool- Quality Center.
• Generated Reports, Graphs and live analysis graphs in Quality center.
• Performed analysis, Assessment, Task distribution, Scheduling, Reporting, Meeting scheduling, etc. using MS Project, MS Power point, MS word, MS Excel.
• Distributed or assigned tasks among Managers, Testers, Team Members and Development related personnel.

Environment: QTP, ALM, SQL, Java, JavaScript, .NET, PVC Tracker, DB2, Teradata.

Confidential, New York

UAT Test Engineer

Responsibilities:

• Write test cases based on the functional requirement documents to make sure all requirements are covered and working as designed.
• Wrote Complex SQL queries for data verification and accuracy and validate correctness of new code and backend modifications of requirements.
• Executed queries to maintain integrity and security of the database using SQL, & PL/SQL.
• Interfaces are built and automated the jobs thru scheduling which runs every day by maintaining the data validations with Informatica ETL Power center tool.
• Analyzed the SRS (System Requirement Specifications) for requirements and developed test plan, Test Scenarios, Test Scripts and Test Cases.
• Responsible for analyzing the requirements and the critical areas of the application to setup and execute baseline tests.
• Involved in Designing, planning, manual testing of the application.
• Communicated requirements traceability matrix and tracked requirements status throughout the project.

Environment: QC, Excel, Unix, Windows, .Net, Java, OBIEE, Oracle, Informatica.

Confidential, Columbia, MD

QA Analyst

Responsibilities:

• Worked closely with developers to discuss features, Software design and Implementation Strategies (as well as test, bug and build release workflows).
• Involved in preparation of Integration and System test scenarios based on Business Rules, and System Requirement Specifications.
• Developed and updated Functional Test cases matching the requirements, as well as updating Use Cases for current projects.
• Performed Functional, Integration, System and Acceptance testing and developed automated test scripts for Regression testing using the Mercury tool QTP.
• Wrote and executed SQL Queries for Data validation.
• Created automated scripts for functional and regression testing utilizing Mercury's Quick Test Pro.
• Coordinated with development team members for Bug tracking and testing efforts using PVC Tracker.
• Prepared weekly status reports and participate in weekly software/project meetings.

Environment: QC, Rally, SQLServer, Java, JavaScript, Lync, SVN, TOAD.

Confidential, NY

ETL Tester

Environment: SQL Server, Oracle, Informatica 9.2 & 10.1, SSIS, SSRS, Tableau, HP ALM, Visio, SharePoint, Waterfall, Agile

Responsibilities:

• Writing complex SQL queries, stored procedure to automate data validation based on ETL mapping documents.
• Reviewed, analyzed FDR, DD documents, developed strategies, test plans, and executed the test cases.
• Supporting and manipulating 50-60 data tables daily.
• Responsible for Analysis and Execution of the pre-implemented new release.
• Analyzed and maintained requirements and created Test Data, Traceability between Requirements and Test Cases.
• Wrote SQL Statements to extract Data from Tables and to verify the output Data of the Reports.
• Participated in Peer Review and bug logging using Bug tracking tool- Quality Center.
• Work closely with business users to gather requirements, define project specifications, develop implementation and test plans for the projects & enhancements.
• Designed, created and tested reports to meet business requirements.
• Documented business workflows textually as well as in UML diagrams for the stakeholder review.
• Produced the visual models for the application to create use cases, state charts, sequence diagrams and activity diagrams.
• Documented and maintained RTM to ensure that all requirements are traceable from top to bottom and to provide a basis for test plan.
• Performed Data Analysis, writing SQL Queries for Testing and Troubleshooting against Data Warehouse.
• Created data mapping documents mapping Logical Data Elements to Physical Data Elements and Source Data Elements to Destination Data Elements.
• Maintained documentation related to difficulties, complexities and anomalies that may arise during the ETL process.
• Upgrade from Informatica 9.2 to 10.1 took place.

Confidential, Bridgeport, CT

QA Analyst

Responsibilities:

• Worked as one of the key persons in Requirement gathering, Analysis, assessment and finalizing.
• Reviewed, analyzed, FDR, DD documents, Developed Strategies, Test Plans, Test Cases and executed the Test Cases using Web top applications in Documented.
• Designed, developed and executed Quick Test Pro VB scripts for functional, regression testing.
• Developed Data driven test scripts using Data Table by importing data from Database and external excel files Using Quick Test Pro.
• Major responsibility in testing area was in System, Functionality, Integration, Regression testing.
• Wrote many SQL queries to retrieve/storing data and testing source to target data storage.
• Tested application prior to release as a Final part, keeping the bug trackers status maintained perfectly.
• Analyzed and maintained requirements and created Test Data, Traceability between Requirements and Test Cases.
• Involved in Manual, Negative, Positive, System, Functionality, Integration, Regression, UAT, and Backend testing during the various phases of the application.
• Extensive hands on working with Test Director utilizing this tool most of the time in daily routine work.
• Worked as Team player, involved in daily Agenda, interaction with Managers, Business Analyst, Leads and others, involved in walkthroughs, vendors meeting, testing issues and defects review meetings.

Environment: QTP (VBScript, Descriptive Programming), TD, SQL Dev, Load Runner, HTML, XML, Java, Oracle, INFORMATICA, DB2, TSYS TS2, UNIX, Java scripts.