SUMMARY:

• 7 years of experience in Software Quality Assurance with expertise in ETL Testing/Data warehouse testing and data analytics
• Experience working on Big data, Hive, Denodo projects
• Vast work experience in Banking & Health care domains
• Certified in ISTQB, Teradata 12 professional
• Experience working in Waterfall and Agile Testing Methodologies
• Expertise in creating and reviewing Estimates, Test Strategy, Test Plans, Test Scenarios, and Test Cases/Script, Test Closure documents.
• Expertise in ETL testing, Report testing. Hands on experience in Security testing
• Hands on experience in Master Data Management(MDM) concepts
• Experience in testing of Data Warehouse/ETL Applications developed in Informatica, Data Stage using SQL Server, Oracle, DB2, Netezza, Teradata and UNIX and ability to evaluate ETL/BI specifications and processes.
• Strong experience in OBIEE, SAP Business objects report testing
• Experienced working in data analysis tools - SAS, Alteryx
• Hands on experience in automation through VBA macros. Developed simple macros for Data Generation, Data Validation, QC reporting.
• Extensive knowledge in HP ALM to log, track the defects, Requirement traceability, Testcase uploading and execution, Defect vs Testcases mapping, QC reporting
• Ability to develop complicate, multi-layered SQL script for data validation/comparison
• Hands on enough knowledge in C, C++, Java, .net
• Ability to learn and adapt to new tools and technologies very quickly.

TECHNICAL SKILLS:

Database systems: Teradata, DB2, Microsoft SQL Server, Netezza, Oracle, Hive

Defecttracking software: HP Quality Center/ALM11.0

Tools: and Utilities: Teradata SQL Assistant, Advanced Query Tool, Alteryx, SAS, Putty, WinSCP

ETL Tools: Informatica, Data Stage

BI Tools: SAP Business Objects, OBIEE

Job Scheduling Tools: Robot Schedule

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Test Analyst/Lead

Responsibilities:

• Experience working on Agile methodology based ETL projects
• Test Plan, Test Strategy, Test Cases and Test Scripts preparation for System, System Integration, User Acceptance Testing
• Estimates, test plan, test case reviews with Project team and acquiring approval for QA documents
• SQL queries preparation for data validation across different layers using Teradata
• Hands on experience in Rally for Defect management, test case management
• Interaction with multiple teams (i.e., System Analyst, Business Analyst, Developer, UAT teams) to implement the project in Production
• Enhanced support to the UAT teams
• Demonstrated experience in VBA(or)Excel Macros

Environment: Data stage, UNIX, Teradata, Rally, VBA/Excel macros

Confidential

Sr. Test Analyst

Responsibilities:

• QA estimates preparation upon requirement gathering
• Test Plan, Test Strategy, Test Cases and Test Scripts preparation for System Testing
• Estimates, test plan, test case reviews with Project team and acquiring approval for QA documents
• Test Data Management team co-ordination (or) test data preparation for system testing
• SQL queries preparation for data validation across different layers using DB2, Teradata, Oracle.
• Used SAS to simplify the re-usable parameterized queries
• Involved actively in Functional system testing, System integration Testing, Regression testing
• Hands on experience in SAP - Business Object reports testing, OBIEE
• Defect logging and management through HP ALM, HP QC
• HP ALM Monthly Test case reporting, Defect reporting, RTM
• Used Robot Schedule to run/Schedule the data stage jobs
• Responsible for circulating QA weekly/monthly status reports, preparing test closure reports
• Interaction with multiple teams (i.e., System Analyst, Business Analyst, Developer, UAT teams) to implement the project in Production
• Enhanced support to the UAT teams
• Demonstrated experience in VBA(or)Excel Macros
• Experience working in Master Data Management(MDM) projects

Environment: Informatica, Data stage, SAP Business Objects, SAS, HP ALM and UNIX, DB2, Teradata, Oracle, Alteryx, Hive, Pig, Denodo Views, VBA/Excel macros

Confidential

Test Engineer

Responsibilities:

• Review and understand the ETL processes, functionality & identify test requirements and coverage.
• Involved in creating Test plans/Test cases based on BRDs and SRS’s
• Extensively used Quality Center for Defect tracking, reporting, Requirement Traceability
• Worked on BTEQ queries invoked by Mainframe systems
• Used Linux job scheduler to schedule/run the data stage jobs
• Involved in testing the Business Object reports (Drill down, Drill up, Drill across reports) by writing complex SQL queries to validate the business/system requirements.
• Involved in System testing, System Integration Testing, User Acceptance testing
• Used Putty to connect the UNIX environment to download, transport test data files
• Performed file validations using UNIX utilities
• Interacted with Architect, DBA, System Analyst, Developer in the process of QA testing
• Involved in System and System integration testing
• Worked on different types of banking data ware house applications
• Responsible to circulate the Daily (or) weekly status report to the project stake holders
• Responsible for preparing test closure report(TCR) for System/System integration testing

Environment: Informatica 8.X, BI Business Objects, HP Quality Center, Oracle, Teradata BTEQ, Mainframe, Unix