SUMMARY

• Around 7 years of experience in Software Analysis, Planning, Design, Development, Testing, Maintenance and Augmentation for various applications in data warehousing, metadata repositories, data migration, data mining, distributed data design, decision support systems and Enterprise Business Intelligence.
• Hands - on experience and strong understanding of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
• Good experience of Quality Assurance methodologies like Waterfall, Agile- Scrum, and TDD.
• Experience in designing, documenting, and executing test plans, test harness, test scenarios/scripts & test cases for manual, automated & bug tracking tools.
• Experience in creating Traceability Matrix to ensure comprehensive test coverage of requirements.
• 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, Performance Testing & Stress Testing.
• Experience in working on Hadoop components like Hive, Sqoop, PIG and Hive.
• Expertise in use of HP ALM/Quality Center & Test Director for writing test cases, test execution, defect management, defect tracking and Bug Reporting.
• Extensive experience in testing and reviewing of dimensional modeling (Star and Snow flake) of data warehouse using Erwin.
• Expertise in querying and testing RDBMS such as Oracle, MS SQL Server, Teradata and Hadoop using SQL, PL/SQL for data integrity.
• Involved in the ETL processes where in the organizations were using Datastage, Informatica, Abinitio and Autosys tools.
• Extensive working knowledge in UNIX/Linux operating systems.
• Experience in testing Business Intelligence reports generated by various BI Tools like Micro Strategy, Cognos and Business Objects.
• Possess excellent team management, communication, and analytical skills.

TECHNICAL SKILLS

ETL TOOLS: Informatica 9.0/8.6, SSIS, AbInitio

BIG DATA TOOLS: HIVE, PIG, SQOOP, HBASE

DATABASES: Oracle 11g/10g/9i, MS SQL SERVER (2012/2008 R2)

BI TOOLS: Business Objects 4.0, Crystal Reports 2011, Cognos 8

TOOLS: HP ALM/Quality Center, TOAD, SQL Loader, Autosys

LANGUAGES: T-SQL, SQL, PL/SQL, JavaScript

OS: LINUX/UNIX, Windows

REPORTING TOOL: SAP BOs, Crystal Reports, Cognos

METHODOLOGIES: Waterfall, RUP, Agile

PROFESSIONAL EXPERIENCE

ETL QA Tester

Confidential, Irving, TX

Responsibilities:

• Followed Agile Testing Methodology for every release of project.
• Involved in communicating with business, support, and development teams to resolve issues during test execution.
• Co-ordinated with development and business teams to help UAT process run smoothly.
• Export requirement, test cases into the Quality Center/ALM, run manual and automation test cases from test lab and log defects from defects module.
• Responsible for updating and maintaining the Quality Center for all the defects found during functional and regression testing and follow up the bug life cycle.
• Worked on writing SQL queries to verify the count and data difference between source tables to landing tables, landing to staging tables and staging to base tables.
• Ran Sqoop export and import scripts and tested the data.
• Verified the transformation logic implemented in PIG and MapReduce Scripts.
• Validating the data that is processed and stored in Hive tables by running Hive queries.
• Extracted data from various sources like SQL Server, Hadoop, Oracle, DB2, XML, and flat files.
• Loading Flat file Data into Teradata tables using Unix Shell scripts.
• Developed UNIX shell scripts for the purpose of parsing and processing data files. Maintained and did trouble shooting for batch processes for overnight operations.
• Wrote SQL and PL/SQL scripts to validate the database systems and for backend Hadoop database testing.
• Wrote several complex queries to validate De-normalized tables and Materialized views.
• Created and maintained test cases forETLmappings and design documents for production support in HP ALM based on the Source to Target documents.
• Worked on developing Requirements Traceability Matrix (RTM) to track requirements.
• Performed analytical activities to resolve or explore root cause on the issues identified in Business Objects reports by downstream application user.
• Worked in Agile Software Development environment, Participated in daily stand-ups.
• Tested theETLInformatica mappings and otherETLProcesses (DWtesting).
• Worked on validatingETLtarget tables in table level and column level looking at the complexity of Source to Target document.
• Extensively tested severalETLMappings using Informatica.
• Tested data migration to ensure that integrity of data was not compromised.
• Verified the error tables and audit post process emails occurred during theETLexecution.
• Involved intestingand monitoring Informatica job run in informatica Workflow Monitor, Verifying logs for workflows and sessions.

Environment: Agile, SQOOP, Hive, PIG, Hive, HBASE, Informatica Power Center 9.5, Oracle 11g, Db2, Unix, Hadoop, SQL Server, Mainframe, HP ALM, Version one, JIRA, Charles, TOAD, Text Pad, Compare IT, Sharepoint, Quality Center, SAP Business Objects 4.0

ETL/Backend DataTester

Confidential, Newark, DE

Responsibilities:

• Attending daily Agile scrum meeting.
• Participated in all meetings with project team members on Overview and Architecture.
• Developed test plans, test scripts and build scenarios workflows according to the user requirements.
• Worked ontestingdata migration, data integration and data transformation.
• Involved in Black boxtesting.
• Performed UATtestingin the UAT environment prior to notify to the customer to start performing UATtesting.
• Used Quality Center to document and open defects and track them from time to time.
• Written test cases to validate theETLInformatica mappings and maplets.
• Executed SQL queries using TOAD to query Oracle database.
• Used Inner join, Outer Join, MINUS operations and Case statements in SQL scripts.
• Used SQL Assistant to write SQL and query the Teradata database tables.
• Created complex SQL queries to validate the initial and incrementalETLloads.
• Used PL/SQL functions to validate some test scenarios.
• Worked with UNIX commands like GREP, LESS and Diff.
• Tested several Informatica Mappings to validate the business conditions
• Written positive and negative test cases for Cognos reports based on report specifications.
• Worked with XML feeds from multiple sources systems and loaded the same into Enterprise data warehouse.
• Exported the Report data from Oracle and Teradata warehouse to Excel and validated using formulas.
• Participated in Project Status meetings and updated QA status and defect status. aInteracted with developers to resolve the ETL and reports defects.

Environment: Agile, Oracle 10g, SQL, TOAD, Informatica 8.6/9.0, SQL Server, Hadoop, Teradata, MS Access, MS Excel, MS Word, XML, SQL Developer, SQL Assistant, SQL Plus, Unix, Quality Center 10/ ALM, JIRA.

ETL QA Tester

Confidential, Minneapolis, MN

Responsibilities:

• Analyzed the Requirements from client and developed Test cases based on functional requirements, general requirements and system specifications provided as JIRA Ticket Number.
• Prepared Test Plans and Test Approach for each JIRA Requirements after analysis and review with BAs.
• Created test requirements and test cases using standard template. Reviewed test cases in excel with tech lead, BSA and UAT resources and obtain sign off before execution.
• Imported test cases to Quality Center and executed test cases in Quality Center and logged defects.
• Effectively coordinated with the development team for closing a defect.
• Perform defect Tracking and reporting with strong emphasis on root-cause analysis to determine where and why defects are being introduced in the development process.
• Assign work to offshore and follow up on the issues or roadblocks faced by the team.
• Handled Android and IOS application for mobile banking.
• Conduct status call with offshore and coordinate among team members.
• Conducted KT (knowledge transfer) session and training to offshore.
• Communicated to delivery team and QA manager about issues, concerns and risks.
• Prepared Test Scenarios by creating Mock data based on the different test cases.
• Performed functionaltesting(Count Verification, data validation, referential integrity test, transformation validation and various constraints check).
• Used MAT (Manual adjustment tool) to perform database insert, update and delete.
• Performed UI/Webtestingfor U.S. Bank Control Panel changes.
• Involved in INTEGRATION and UATTesting.
• Extensively documented test artifacts so as to keeptestinghistory and to avoid miss understanding and confusion.

Environment: Control Panel (U.S. Bank in-house tool for UI), MAT (Manual adjustment tool), Quality Center 10, JIRA, Subversion, Teradata 14, Teradata SQL Assistant, Oracle, SQL developer, Sybase, Unix, Flat files, log files, Xml files, PL/SQL