SUMMARY:

• Having 6.8 years of experience in testing Data Warehouse/ETL Applications developed by Data Stage and SSIS tools using Sql (Oracle, Sql Server, Netezza), BI reporting developed by Tableau and Cognos
• Experience in testing Big Data problems on Hadoop platform (Hartonworks & MapR distribution)
• Experience in MAPR - FS, DRILL, HIVE, SPARK and other Hadoop components
• Experience in Testing of Development, Conversion, Migration and Maintenance DWH/ETL Projects
• Proficient in Black Box Testing, ad-hoc manual testing, Functional Testing(Data base/Data warehouse testing & ETL testing ), Integration Testing, Regression Testing, GUI Testing, System Testing, Acceptance Testing, end to end testing, User Acceptance Testing (UAT), Negative Testing, Usability Testing, writing and testing using Use Cases
• Involved in entire Software Development Life Cycle (SDLC) - Requirement, Design and Analysis, Development, Testing, Deployment and Support phase
• Expertise in preparing Test Strategy, Impact Analysis & Effort Estimations documents, Test Scenarios, writing and executing Test Cases, and Test Reports for manual tests
• Experienced in writing complex SQL queries, Source to target validations, Job scheduling etc
• Extensive experience in tracking defects using Defect tracking tools such as HP Quality Center, Rational Quality manager (RQM) and JIRA.
• 1.4 Year Onsite experience at TJX Client, USA.
• Point of Contact between onsite and offshore team, Work allocation to team, Coordination with onsite team(Dev, DA, BA) for issue resolution
• Verify the readiness of product for release through release review
• Reviews of QA documents and Status reporting
• A positive attitude team player with excellent Organization, Interpersonal, communications skills and ability to work independently and deliver on time
• Key Individual Accomplishments:

TECHNICAL SKILLS:

• Hadoop Testing Root cause analysis
• ETL/DWH Testing Test Environments
• BI Reports Testing Data Profiling
• Toad for Netezza and Oracle Data management
• UNIX Basic Commands (QA) Integration Testing
• Test Data Management
• Sqoop SQL
• HDFS, MAPRFS IBM Datastage
• Drill, Hive, Spark & Hbase QC ALM
• Cognos, Tubleau IBM CDC
• Zookeeper, Oozie, YARN ICEDQ ETL Automation
• SSH, UNIX

PROFESSIONAL EXPERIENCE:

Confidential

Onsite Test Lead/Data Analyst

• Participated in the requirements review meetings to define QA deliverables
• Prepared the QA estimations based on the requirements and participating in the team building activities
• Performed the Schema and Structural Validation based on Low level design document
• Created the Test Plan, Test Scenarios and Test Cases for review and approval
• Responsible for tracking the resolutions for QA clarifications and Test Readiness Review
• Validated data from source to target at each individual phase by ensuring the right external data source is mapped the right internal data source
• Validated Files in MapR-FS (ODS like) using ETL Automation tool ICEDQ
• Validated tables in Apache Drill using complex SQL queries running in Drill shell against business requirement
• Validated data duplicates between data warehouse and MapRFS and whether there is any real business benefit in duplicating the data
• Validated data is extracted correctly as per business rules
• Performed Hadoop Eco system behavior validation by changing some parameters in Hadoop profile file
• Evaluated in advance number of nodes required in each test environment
• Prepared and used the test data by dumping some masked production data (realistic)
• Performed negative testing by Changing the input data, replicate the data files and validate all possible variations of input data
• Validated QlickView reports against Apache drill data and business requirements
• Validated Hadoop eco system is working as expected after node failure or network failure
• Responsible for defects tracking and publishing the test results
• Responsible for metrics submission and team leading activities

Confidential

Module Leader/Test Lead

• RMS Program - The implementation of Oracle Retail’s Merchandising System (RMS)
• Allocations Program - The implementation of a custom Allocations solution
• Merchandise Planning Program - The implementation of Oracle Retail’s Predictive Application Server System (RPAS)
• Understanding the project requirement by going through Business Requirement Documents, Mapping Documents Gathering user requirement, and prepare and conduct requirement analysis. Analyzing Testing Requirements
• Identify the Scope of testing and approach. Test strategy creation, test plan creation, Design of Test Scenario’s, test case writing, RTM, test data creation, Retesting/Regression testing Writing SQL/PLSQL codes to Verify and validate the Database, Data Mart, DWH data. Monitoring and executing Data Stageand Unix Batch Jobs
• Testing the data in the generated output file and database for different feeds that involved reading flat files and database and
• Populating xml files and database from the downstream application. Defect reporting, analysis and Estimate for testing
• Phase and planning their tests. Preparation of KT documents. Attending Technical review, Test Planning and Defect Review meetings
• Preparing the test Reports, logs and provide it to Project Manager, Development Manager, and QA Manager

Confidential

Sr.Test Engineer

• Analysis and Review of Business Requirements in the specification documents and Technical Design documents
• Preparation of Test Schedule, Test Plan, Test Script and Test cases
• Identification of data anomalies by doing thorough Data profiling Identification of data quality issues and working on designs to address them
• Setting up Test data for complete test coverage
• Validation and testing of ETL Functional testing, Integration testing, System testing, Regression testing, Testing the
• Data warehouse/DataMart data against the business logic requirement  and mapping documentation of
• Test Results (Test report matrix)
• Test estimation for testing requests Adoption of QA Best practices Creating Testing Status Reports, test summary reports
• Providing support during User Acceptance Testing (UAT)
• Used hive to validate huge data files for Merchandising financial data, Retail Management data & Retail price
• Management data from third party oracle and loading into Hadoop Distributed file systems(HDFS) and  validating
• Hadoop data validation (reconciliation) against flat files for correctness of the data in Hive
• Worked on DB Visualizers supports Hadoop ( connection string to Hadoop Clusters)
• Have Knowledge on Hadoop Distributed File system, Map Reduce, File Browser and Job Browser
• Understanding of Hadoop architecture

Confidential

Test Engineer

• Functional Test case and SQL queries preparation and execution based on the Functional specification in POM module
• Analysis of Business requirement for creation of Test Scenario for Test Cases Preparation
• Identify the Scope of testing and approach. Understanding the project requirements by going through System Requirement Specification (SRS), ER Design Documents
• Creating Test Summary Report and maintaining team daily Activity tracker

Confidential

Test Engineer

• Involved in writing Functional Test cases and Test case execution for the functional testing in Engineering module and history module which is the major part of ANA project
• Logged bugs as much as possible for the applications given for testing
• Have got the opportunity to work on test management tool like RQM, defect tracking tool like Bugzilla
• Have tested both online and batch functions which are scheduled in JP1 scheduler
• Have direct interaction with the client for the execution of the Mascot application
• Have got many appreciations and certificate from Client as well as onsite management level
• Have good working skills in database management like SQL, PL-SQL