SUMMARY:

• Over 9+ years of experience in Development and Quality Assurance in Information Technology.
• Extensive experience in ETL/ Data warehouse/Database testing/Big Data Testing and BI Intelligence reports testing.
• Strong Quality Assurance experience within Agile environment (Scrum/Kanban)
• Strong knowledge in Software Development Life Cycle and QA process.
• Expert knowledge in creating Test Plans, Test Cases, Test Scenarios and Test Strategies.
• Experience in Unix Scripting and Unix - Batch Testing
• Extensive Automation Testing Experience in ATDD Framework using SQL, Ruby, Cucumber.
• Extensive ETL experience in Ab Initio / Cygwin Meta Data Framework /Informatica 8.1.
• Expert in Ab Initio Upgrade Testing (Ab Initio 2.15 to Ab Initio 3.1 Migration)
• Extensive experience on Ab Initio Graphs utilizing the GDE environment and EME
• Extensive used Web-EME to verify the Ab Initio Plans, Monitoring Jobs status.
• Extensive experience in Teradata MLOAD Script and Data Load.
• Extensive worked in Ab Initio Multi-file System (8way Partition) in UNIX Platform
• Expert in using all M* commands in Unix Platform and converting serial files into Multi-File.
• As an innovation, developed a UI based - Automation tool to validate Metadata Hub (MDH) data lineage correction.
• Expert in Test Data Management / Data Mock-up /Data Profiling and Data Scrubbing.
• Excellent Knowledge of Database Systems - Teradata,Netezza,Oracle 10g, SQL server, DB2 and Data ware house concepts.
• Extensive experience in developing SQL scripts to validate the databases tables and reports data for backend database testing.
• Experience in preparing test reports from ALM and prepared daily test status reports to communicate the test status with the team.
• Experience in RDBMS and associated SQL Programming Knowledge.
• Assist in Vendor contract, Resource Management and Project Billings.
• Excellent Knowledge in Ms-Office (Word, Excel, PowerPoint), Ms-Access, MS Visio.

TECHNICAL SKILLS:

Data Warehousing Tools: Ab Initio 3.1, Informatica, SAP-BODS, Talend, Cygwin MDH

Data Base: Oracle 9i, SQL Server 2008,Teradata 12.0, ASA9.0,DB2,Netezza

Data Validation Tool: Platinum (Client owned tool)

Operating System: Windows, Unix

Test Management Tools: Application Lifecycle Management (ALM), Bugzilla, Test Manager

Test Automation Tools: Ruby,Cucumber (ATDD Framework), HP QuickTest Professional

Data Base Access Tools: Query Tool, Win SQL,TOAD

Reporting Tools: Cognos, MSBI (SSRS, SSAS)

Others: Tidal Scheduler, Control - M, MS-Excel Macro

Scripting: VB-Script, Unix Script

PROFESSIONAL EXPERIENCE:

Confidential

Sr.QA Analyst (ETL Tester )

Responsibilities:

• Developed high level test matrix based on business requirements, functional and technical specifications, and development standards for assigned projects/applications
• Developed test cases based on test matrix including test data preparation for Data Completeness, Data Transformations, Data quality, Performance and scalability.
• Developed SQL queries /scripts to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregations.
• Validated Business Transformation logics /Rules.
• Performed Count Validation, Dimensional Analysis, Statistical Analysis and Data Quality Validation in Data Migration.
• Verified Ab initio Graphs and Wrapper Script Execution and Teradata Loads.
• Created M-load script to load the intermediate files in to Teradata table and perform data validation.
• Performed Ab initio Graphs Code checker (CC)& Data Lineage (DL) Validation.
• Performed Web-EME - Metadata Hub Validation.
• Created Automation tool to validate MDH correction.
• Created Automation script to Run all Ab initio wrapper Scripts.
• Performed Test Data Mock-up and Lookup file Data Mock-up.
• Experience in all Ab inito - M * commands
• Created MS-Excel Macro for Data Validation between source and Target.
• Created Macro to validate Table structure between PDM document vs Target Database.
• Walk through the test strategy and Test case to customer and gets their sign-off.
• Attend Daily Stand-up calls and Sprint - Retrospective meetings.
• Identify/request test data for System integration testing (SIT) as well as User acceptance testing (UAT).
• Preformed Data-mock with all positive and negative scenario.
• Capture the defects and log into the defect management tool (HP - ALM) till closer
• Involved in Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.
• Tracking and reporting the issues to project team and management during test cycles.
• Updating and maintaining existing test Matrix and test cases based on code changes and enhancements to assigned applications.
• Contribute in the development of knowledge transfer documentation.

Confidential

Sr.ETL Tester

Responsibilities:

• Understanding the requirement from STTM Document.
• Expertise in End to End Testing and Data validation and data comparison.
• Compared each feeds staging / Target Table structures with production table structure.
• Identified the correct source file name/path used to load into Production Table.
• Copied identified source files to MDF Framework.
• Verified each feeds node chain completeness and correctness.
• Verified incremental data loads in MDF framework.
• Validated Target table record count / data with production table record/ data.
• Prepared the Test Plan and Testing Strategies for Data Warehousing Application
• Preparation of technical specifications and Source to Target mappings
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Written test cases to test the application manually in Quality Center and automated using Quick Test Pro
• Defects identified in testing environment where communicated to the developers using defect tracking tool Mercury Test Director

Confidential

Tester

Project Specific Skills: SAP - BODS, SSRS, SSAS, SQL Server 2008, Quality Center

Responsibilities:

• Managed the entire QA team.
• Analyze and understand the Business requirements & functional specifications.
• Prepared Test Plan, Test Script and Test Cases.
• Prepared Mock Test data with all possible Business Scenario to test the Business rules.
• Performed Data Validation between STG and DWH Layers.
• Performed SSAS - Cubes Data Validation.
• Performed SSRS - Reports Validation.
• Performed Data Model Comparison Between Legacy System and Current System.
• Reporting and tracking the defects using Quality Centre Bug Tracking Tool.
• Sent Daily basis Status Reports to entire QA team.

Confidential

Test Engineer

Project Specific Skills: .Net, Oracle, Quality Center V 10.0,SQL

Responsibilities:

• Prepared Sample Test Data with all possible business scenarios.
• Preformed Data Profiling process.
• Preformed Data Model and Schema Validation.
• Verified the Data validation between Legacy system data and Extracted Data.
• Verified Bulk Loaded Data Validation.
• Assist to design Business Validation Rules / Data Transformations Rules.
• Prepared Mapping document.
• Prepared SQL Scripts using data transformations rules.
• Once build released for Testing - Performed Smoke & Sanity Testing.
• Performed Usability and Negative Testing.
• Reporting and tracking the defects using Quality Centre Bug Tracking Tool.

Confidential

Software Engineer

Project Specific Skills: Talend, Oracle 9i,SQL

Responsibilities:

• Analyzing the functional specifications and user Requirement.
• Participated in different Review Meetings.
• Performed Browser Compatibility testing, Data Base Testing and Graphical User interface (GUI) testing.
• Prepared Test Plan and SQL Scripts.
• Executed Test cases manually.
• Involved SIT Testing, Regression Testing & Acceptance Testing stages.
• Reporting, Analyzing, Tracking and verifying bugs.
• Papered Proof of Testing Document (POT) for reported Issue’s.
• Performed Schema Validation in-between Securian ver 5.0 and ver 5.1.9
• Entered all the issues to Issue Tracking System with proper Issue status.
• Follow-up all the Issues up to Close status.
• Prepared final test documents with Overall test status.

Confidential

Sr. Quality Assurance Professional

Project Specific Skills: Informatica, ASA, Oracle 9i,SQL

Responsibilities:

• Managed the entire QA team.
• Understanding Requirement from HLD & LLD.
• Prepared Test Plan and Test Case.
• Generated/Inserted Test data into Blank Database using DTM Data Generator tool.
• Performed Load Testing and Stress Testing.
• Executed Test cases manually.
• Involved Database testing, System Testing, Regression testing stages.
• Papered Proof of Testing Document (POT) for reported Issue’s.
• Entered all the issues to Issue Tracking System with proper Issue status.
• Follow-up all the Issues up to Close status.
• Performed DATABASE Testing, to check the converted data.
• Verified Extracted data details though back-end.
• Verified Loading Process through back-end.
• Verified Mapping information converted data with Source DB and Target DB.

Confidential

Quality Assurance Professional

Project Specific Skills: Ezlink, ASA, Oracle 9i, SQL

Responsibilities:

• Analyzing the functional specifications and user Requirement.
• Participated in different Review Meetings.
• Prepared Test Case and SQL Scripts.
• Executed Test cases manually.
• Involved in Database Testing, Regression Testing & Acceptance Testing stages.
• Reporting, Analyzing, Tracking and verifying bugs.
• Papered Proof of Testing Document (POT) for reported Issue’s.
• Performed Schema Validation in-between Securian 4.1.3 to SO 5.1.9
• Entered all the issues to Quality Center with proper Issue status.
• Follow-up all the Issues up to Close status.
• Prepared final test documents with Overall test status.

Confidential

Quality Assurance Professional

Project Specific Skills: Ezlink, ASA, Oracle 9i, SQL

Responsibilities:

• Analyzing the functional specifications and user Requirement Documents.
• Performed Data Base Testing and Graphical User interface (GUI) testing.
• Prepared Mapping Document and Test Case.
• Test case Execution.
• Data Validation between Current system and legacy system.
• Performed the Sanity & Smoke Testing.
• Performed Data Comparison in-between Metlife CDS 4.3 and SmartOffice 5.1.3
• Prepared Proof of Testing Document (POT) for reported Issue’s.
• Regresses existing bugs on previous software builds.
• Reporting and tracking the defects.
• Prepared final test documents with Overall test status