SUMMARY:

• 10 years of strong experience in carrying out Manual End to End Functional testing
• Excellent understanding of SDLC and STLC Concepts.
• Experience in preparing Traceability Matrix, Test plan, Test estimation.
• Good at data analysis, data mapping preparation and data validation.
• Sound Knowledge and experience inMetadata and Star schema/Snowflake schema. Analyzed Source Systems, Staging area, Fact and Dimension tables in Target D/W.
• Thorough Knowledge of Data Warehouse & ETL Concepts and worked as ETL tester/Lead.
• Tested the ETL mappings and ETL transformations in all layers of DWH (Data Warehouse Testing)
• Experience in creatingTest Readiness Review(TRR), Requirement Traceability Matrix(RTM)documents.
• Expert in preparingTest Strategy, developingTest Plan, Detailed Test Cases, writingTest Scriptsby decomposing Business Requirements, and developingTest Scenariosto support quality deliverables.
• Expertise in Functional Testing, ETL Testing, DWH testing, BI (Business Intelligence) Reports & Dashboards Testing, System testing, GUI Testing, Regression Testing, System Integration Testing and UAT.
• One and half Years of experience in Hadoop Bigdata development environment. Experience in Big Data development using open source tools including Hadoop Core, Sqoop, PIG, Hive, Map Reduce, Scala and Spark
• Rich experience in performing functional testing of ERPs SAP and PeopleSoft.
• Enhanced experience in Defect Management Tools - Quality Center 10.0/ALM.
• Well-versed with all the stages of Defect Tracking Life Cycle.
• Participated in the Review meetings to discuss about ongoing project with Team Members and Test Manager.
• Quick learner and excellent team player, ability to deliver on time and work efficiently.
• Working as a Test Lead and handling a team of 6 resources and managed 10+ resources as a UAT Lead.
• Hands on experience in task allocation to the team members on daily basis and monitoring of tasks and reporting the status to onsite coordinators and managers.

TECHNICAL SKILLS:

Operating System: Windows 98, Windows XP

Programming Languages: Java Script, Python

Applications: MS, Web, Windows, ERPs: SAP, PeopleSoft

Databases & Tools: SQL, Oracle 9i, SAP CRM/ FI/ SD/ BODS, Informatica, Azure cosmos DB, Google cloud, DB2, MS SQL Server, Power BI, IBM COGNOS, MS SSIS/SSRS/SSAS, PeopleSoft HCM 8.1, 8.9,9.1, SD and Financials

Other Utilities: HP Quality Center, ALM, IBM Clear quest, JIRA

AREAS OF EXPERTISE:

• Data Migration, Data Warehouse and ETL Data Reconciliation (testing) and Validation of BI (Business Intelligence) reports and dashboards
• SAP Financials (FI), Sales & Distribution, CRM business processes
• PeopleSoft HCM business processes
• Functional, Non-Functional web/ windows/ COTS applications testing

PROFESSIONAL EXPERIENCE:

Confidential, Arkansas

Test Lead

Responsibilities:

• Worked in Agile environment, reviewing the User Stories to gain understanding of POS implementation
• Attended the sprint plan meetings, daily stand-up meetings, Bug review meetings, weekly status meetings, retrospect meetings and walkthroughs and interacted with Business Analysts and Developers for resolving Defects.
• Experience in testing of Data Warehouse/ETL Applications developed in Informatica, Ab initio using SQL Server, Oracle, Hadoop, DB2, and UNIX and also have ability to evaluate ETL/BI specifications and processes.
• Experience in UNIX, RDBMS, Hadoop, HIVE (HQL), Oracle (PL/SQL), MS Access.
• Responsible for creating completetest cases,test plans,test data, andreporting statusensuring accurate coverage of requirements and business processes.
• Analyzing requirements and creating and executing test cases
• Involved in ETL process testing
• Well versed in Hadoop ecosystem - Map Reduce, Pig, Hive, HBase, Oozie and Sqoop..
• Performed Integration, End-to-End, system testing
• Involving inFunctional Testing & Regression Testing
• Developing AutomatedTest Scriptsto perform data migration Testing, Performance Testing, IntegrationTesting, Stress Testing, System Testing, User Acceptance Testing, Regression Testing
• Experience writing Hive Queries for analyzing data in Hive warehouse using Hive Query Language (HQL).
• BIG DATA testing Experienced
• Involving in writingSQL queriesandDatabase Checkpointsto verify data quality, data transformations and calculations.

Environment: /Applications: J2EE, Core Java, Windows7, IBM RTM, Confluence, Postman, SQL, Oracle10, HP ALM, UFT, SOAP UI, SAP BODS, Python, Azure, Cosmos DB, Google cloud.

Confidential, Barrington, IL

Test Lead

Responsibilities:

• Worked as an ETL Test lead and handling team at offshore
• Performed data validation testing writingSQL queries.
• Wrote complex queries in Oracle DB to check the data from Source and Target.
• Creating complex SQL scripts using SQL Management Studio in order to prepare automated test scripts for the data reconciliation of Data Vault layer of the Data Warehouse environment
• Creating automation test scripts in “MS LegiTest” suite to perform data reconciliation.
• Working onQuality Centerfor creating and documentingTest Plans and Test Casesand register the expected results
• Experience assessing testing processes, creating and implementing testing strategies inUATphase.
• Skilled in using Zookeeper and Apache Oozie Workflow Engine for coordinating the cluster, automation and scheduling workflow jobs
• UsingALMfor storing, maintaining the test repository, bug tracking and reporting
• Preparing documentation for some of the recurring defects and resolutions and business comments for those defects
• Coordinated various project specific access requests related toHadoopcomponents like Edge node and HDFS directories, Hive tables, Autosys instances, Mainframe LPARs.
• Developed MS SSIS packages for the automated data validation between sources and target
• DevelopingTest Matrixto give a better view of testing effort
• Experience in creatingTest Readiness Review(TRR), Requirement Traceability Matrix(RTM)documents.
• System testing
• Compare data from source files/ systems to Staging and Data Mart layers of DWH
• Validate different transformation logics as per the mapping document, if found any discrepancy then log defect in ALM.

Environment: /Applications: SQL, Oracle10, HP ALM, UFT, SOAP UI, IBM Data Stage, MS SSIS

Confidential, Chicago, IL

Test Lead

Responsibilities:

• Followed Agile/Scrum Methodologies for all the project activities and attended daily standup meetings, reviewed user stories.
• Was involved in creating the Test plan based on BRD and User Stories.
• Off-shore team monitoring and managing activities like resource estimation, workload forecast and tracking the timelines.
• Collaborate with Product Owners, Business analysts, Developers to test new software applications.
• Working as a manual test engineer and completed on Big Data Hadoop in snp technologies.
• Good knowledge in installing, configuring and testing Hadoop ecosystem components.
• Responsible/Accountable for Functional, Integration, Regression, End-to-End, API and Mobile tests planning and execution.
• Roll up my sleeves to create and execute the tests during hotfix releases and critical situations.
• Evaluating team member's skills and loading the resources as per the testing needs.
• Facilitating daily scrum calls with the scrum teams to go over daily updates, following up on tasks and action items captured during meetings.
• Managing progress reports, burn-down charts and status reports in version one and from HP ALM.
• Compare data from source files & data stores to the target Data Warehouse
• Validate different transformation logics as per the mapping document, if found any discrepancy then log defect in ALM.
• Accountable for the test environment readiness, test case preparation, execution and Test team reports and artifacts to the project team.

Environment: /Applications: SAP BODS, Java, SQL, Oracle10, HP ALM, UFT, SOAP UI, Teradata studio. J2EE, Core Java, Windows7, IBM RTM, Confluence, Postman, Selenium (IDE, TestNG, Web driver), HPQC, Eclipse Luna, Maven, Jenkins

Confidential, Pittsburgh, PA

Test Lead

Responsibilities:

• Understanding the Business Specification Document.
• Analyzed system requirement and business requirement documents and developed test cases and test scripts.
• Worked in Agile Methodology and attended sprint planning meetings.
• Developed and executed test cases in Quality Center.
• Actively involved in UI, functional, database and System Integration testing of the application
• Extensively performed smoke and sanity testing.
• Extensively used Quality Center for test management.
• Created & executed SQL Queries to validate the data stored in database.
• Extensively performed end to end to ensure data flow.
• Performed regression testing of the stories completed in previous iterations.
• Created and executed detailed test cases for the assigned area.
• Prepared test data for positive and negative test scenarios for Functional testing.
• Executed test cases manually to verify actual results against expected results.
• Defect Reporting, Analyzing, Tracking and Report Generation using HPQC.
• Prepared weekly status reports on test case execution, defects, RTM etc. Tracked progress of defects through to resolution.
• Used Toad to manipulate SQL queries for back-end testing.
• Compare data from source files & data stores to the target Data Warehouse
• Validate different transformation logics as per the mapping document, if found any discrepancy then log defect in ALM.
• Accountable for the automation team to evaluate various test automation and management

Environment: ETL, Windows XP, Java, SQL, Oracle10, HP ALM, UFT, SOAP UI, Teradata studio, J2EE, Core Java, Windows7, IBM RTM, Confluence, Postman, Selenium (IDE, TestNG, Web driver), HPQC, Eclipse Luna, Maven, Jenkins

Confidential, Mclean, VA

ETL & Automation Test Lead

Responsibilities:

• Worked as ETL QA on Mortgage domain
• Loan origination and Functionality covering (Loan processing, verification of Mortgage, Credit checking, Enquiries.
• Compare data from source files & data stores to the target Data Warehouse
• Validate different transformation logics as per the mapping document, if found any discrepancy then log defect in ALM
• Worked with data analysts to implementInformatica mappingsandworkflows,shell scriptsandstored proceduresto meet business requirements.
• Performing backend testing of the DB by writingSQL queriesto test the integrity of the application and Oracle databases.
• Wrote and modifiedSQL validation scripts, and writing scripts in SQL to validate the outputs.
• Wrotecomplex queriesto compare the counts and data from source to target.
• Testing Metrics in the BI Reporting (SAP BO and Spotfire) reports and dashboards.
• Formulating the QA plan forblack boxtesting of the application includingFunctional,Regression,Integration,SystemsandUser AcceptanceTesting.
• Performingdatabasetesting to verify backend database transactions.
• Wrote complex queries inTeradata SQL assistantto analyze the data
• Requirement analysis of the new tasks
• Preparation of traceability matrix, Test plan and test case point estimation
• Creation of Test Scenarios and Test cases

Environment: ETL/Informatica cloud, Windows XP, Java, SQL, SQL server, Oracle10, Toad, ALM.

Confidential, Charlotte, NC

Test Lead

Responsibilities:

• Worked as QA on Mortgage (Point of Sale and Loan Origination system), Banking (Treasury - Check Processing system), Retail (Point of sale)
• Loan appraisal and Functionality covering (Loan processing) is Application Process, verification of Selected the Test Cases to be automated and performed functional testing of the front end using Selenium Web Driver and testNG.
• Involved inwriting SQL statementsto create test data for test cases and datavalidation teststo extract data from the tables.
• UsedMS SQL Server to create source to target data validation.
• ComparedSQL resultswith application results by writingSQL queries.
• UsedSQL queriesto test themigrated database for Back End Testing.
• Backend testing of the DB by writingPL/SQL queriesto test the integrity of the application and Oracle databases usingTOAD.
• Preparation of traceability matrix, Test plan and test case point estimation
• Creation of Test Scenarios and Test cases
• System testing
• Reporting Daily and weekly status of ongoing projects with team members, Onsite coordinators, Project Leads and Project Managers.
• Executing the test cases in ALM (Application life cycle management)
• Verify the data displayed in DataMart’s and done data validation between source system and target system.

Environment: ETL/ MS SSIS, SQL, Windows XP, Java, Talend, ALM.

Confidential

Test Consultant / Test Lead

Module: SAP SD/FI/ CRM

Project Methodology: Waterfall

Responsibilities:

• Login to Quality Center retrieved the data from Test Lab, strings, OQ/PQ dry run, OQ/PQ formal, Regression data and tested manually in SAP Portal
• Manually tested CRM Middleware Delta Download (Synchronization) for changes made in ECC Customer Master.
• Manually tested ability loading of Business partners, Contract persons, Prospects from legacy to SAP CRM System.
• Manually tested uploading the master data into MDM and mapping with SAP.
• Writing and executing test cases to verify SAP UAT Pre-requisites and Test Data behaving, conforming to Business Requirement.
• Executed test manually from creating sales order (VA01) through billing (VF01). ( Order, Delivery, Batch Split, Batch Determination, Shipping, Pick & Pack, GI ( Goods Issue) and ASN and Billing )
• Manually tested verify the domestic debit memo accounting document for document type, field, payment field, and assignment field and payment terms
• Manually executed International Billing and Invoices with Order Type ZEX and tested Shipping point and route information displayed and recorded
• Manually Tested inbound IDoc with T.Code we02 for shipping notification and segments
• Manually tested Generate Invoice-Basic Material billing through cash processing for basic
• Manually tested Order Types like ZOR, ZEX, ZCR, and ZDR whether the output is as per expected results like Standard Order Overview screen is displayed.
• Documented the TPR in Quality Center and assigned to related authorities, as when fix the TPR re- executing the test and closing the defects in QC.
• Conducting the daily TPR meeting with Functional Team, SME, and Business owners