****-*** ********* ***, ***********, Prajeesh KP

ON, L5B3Z1 Email: ad47af@r.postjobfree.com

Availability: Immediate Phone: +1-437-***-****

Summary

Qualified ISTQB certified professional offering an experience of more than 15 years in IT sector, summed up with experience in ETL/Datawarehouse Testing, Database Testing, Software Testing of Varies Domains like Entertainment and media, Banking, Retail, E-commerce, Airline and Collaboration.

Professional Summary

Certified Tester with 15 + years of experience in the field of Information technology with emphasis on Software Quality Assurance.

Well acquainted with Software Development Life Cycle, Test Methodologies, Software Test Life Cycle and worked in Waterfall Model and Agile Projects.

In-depth understanding of Functional Requirements, Requirement Traceability and Design Documents.

Experience in System testing, System Integration testing, UAT testing, End to End Testing, Exploratory, Black box and browser compatibility Testing.

Experience in Writing Testing Scenario, Test Case, Test Script using SQL.

Experience in ETL/DWH Testing, DB Testing, Manuel Testing.

Good knowledge on Data warehouse concepts like Star schema, snow-flake schema, fact and dimension table.

Hands on experience in writing SQL Queries

Having complete Defect Life Cycle knowledge of Data warehousing

Having good Experience on BI Report testing (MSTR, SAP BO Tools)

Experienced in delivering test artefacts like Test Plan, Test traceability, Test scenarios, Test Cases, Test Execution, and Test Reporting.

Hand on experience on Rest API for Test Data Creation of Data Warehouse tables.

Hands on experience in Designing Test Case in TACO using Python scripting.

Hand on experience Project Management tools like JIRA, HP-ALM and qTest.

Experience on Oracle and SQL Server databases

Hands on experience on Oracle Data Warehouse.

Hands on experience on Cloud Data warehouse Snowflake.

Hands on experience on AWS S3.

Extensively used Workflow manager, Workflow monitor in Informatica ETL tool

Experience in Oracle Golden Gate Software.

Good exposure to UNIX Commands.

Good Knowledge on BigData/Hadoop Testing

Good knowledge on BigData Architecture and concepts

Good knowledge on HDFS, Hive, Sqoop, Pig, Flume,

Knowledge about the Software Quality Assurance.

Exposure on Software Development Life Cycle (SDLC).

Exceptionally strong Work Ethics, Flexible and Versatile to adapt to any new environment and work on any project.

Strong problem solving and analytical skills.

CERTIFICATIONS:

ISTQB Certified Foundation Level.

TECHNICAL EXPERIENCE:

Domains

Entertainment and media, Banking, Retail, E-commerce, CRM, Airline and Collaboration.

Test/Defect Management Tools

JIRA, qTest, HP Quality center, HP ALM

Databases

SQL Server, Oracle, Snowflake, AWS S3, Bigdata/Hadoop.

Languages

SQL, Hive, Python, Robot Framework, xml, Json

Integrated Development Environment Tools

PyCharm, Informatica, Snowflake, AWS S3, Oracle SQL Developer, Oracle PLSQL Developer, Beyond Compare,, Excel, CSV

CAREER CONTOUR

Working as Senior Associate at Cognizant (July 2023 to Till Date)

Worked as Senior Quality Analyst at Walt Disney (Via Tek-Systems) (June 2017 – May 2023)

Worked as a Senior Test Engineer at Mindtree Limited, Bangalore. (Dec’2010 –June2017)

Worked as a Test Engineer at Aspire software consultancy, Bangalore (Jun’09 – Dec’10)

Professional Work Experience:

Royal Bank Of Canada (RBC) (July 2023 to Till date) as Sr. ETL Analyst at Associate level

Responsibilities

• Involved in functional study of the application .

• Interact with the application vendor team and understand the database architecture of the application.

• Prepared the mapping spec based on the database architecture.

• Design the SQL script to validate the data migration.

• Source data received as CSV file with pipe separated. Beyond compare tool and python Scripting was used to compare source and target data.

• Transformation logic applied in Source CSV file using V_Lookup formula and compare it with the Target CSV file, downloaded using SQL Query.

• Design Test Case and execution in qTest.

• Defect Analysing and Reporting in JIRA.

• Performed Web application Automation using Python and Robotic Framework.

• Interactions with BA & Dev teams to resolve the issues.

• Report the issues faced during validation with the resolution if any in confluence page for future reference.

• Reporting daily testing status report.

• Prepare Sign off Document with execution details along with screenshots.

ESPN/Walt Disney (June 2017 to May 2023) as Sr. ETL Test Analyst

Responsibilities

• Involved in functional study of the application.

• Prepared Test cases with SQL queries to validate Real Time and Batch load DW Tables (for Oracle DW).

• Prepared Test case to validate MSTR report.

• Prepared Test case to validate SAP BO report.

• Prepared Test case in TACO using Python Scripting using PyCharm.

• Performed ETL Automation using Python scripting.

• Performed column mapping between source & target database using SQL Queries.

• Performed ETL Validation on Cloud Data Warehouse Snowflake Using SQL Queries.

• Performed Validation on AWS S3.

• Data downloaded in excel from both source DB and from S3 bucket then compared using python scripting.

• Performed Test Data Creation Using Web Application and REST API.

• Interactions with BA & Dev teams to resolve the issues.

• Reporting daily testing status report.

• Identified Test Scripts for Regression testing.

• Defect Analysing and Reporting in JIRA.

• Performed lead activities like review SQL script, review Test Cases etc.

TITAN (May 2016 to June 2017) As Sr. Test Engineer.

Responsibilities

• Involved in functional study of the application.

• Prepared test data for testing.

• Prepared Test case with SQL queries to verify Dimensional and Fact tables.

• Running the Jobs/Workflow for ETL process.

• Verifying the data in target database after ETL process.

• Performed column data mapping between source & target database using SQL Querys.

• Performed Source DB and DW Landing table Validation using excel formulae.

• Interactions with BA & Dev teams to resolve the issues.

• Reporting daily testing status report.

• Identified Test Scripts for Regression testing.

P&G (Nov 2014 to May 2016) As Sr. Test Engineer.

Responsibilities

Involved in functional study of the application.

Running the Jobs/Workflow for ETL process.

Prepared and ran sql queries to verify Dimensional and Fact tables.

Verifying the data in target database after ETL process.

Performed column data mapping between source & target database.

Prepared test data for testing.

Verifying the data which is loaded into target database.

Interactions with BA & Dev teams to resolve the issues.

Reporting daily testing status report.

Developed, Reviewed & Executed Test Scripts and Designed test data.

Identified Test Scripts for Regression testing.

Defect Analysing and Reporting in Jira.

LMS [Loyalty Management System] (May 2014 to Nov 2014) As Sr. Test Engineer.

Responsibilities

Test Planning, Test Case Design and Test Execution.

Perform functional testing as per the test plan.

Perform DB Testing as per the test plan.

Perform Web services testing Using SOAP UI tool

Defect reporting using Radar.

Publishing status reports to different stake holders.

Affinion QA (Nov 2013 to May 2014) As Sr. Test Engineer.

Responsibilities

Test Planning, Test Case Design and Test Execution.

Perform functional testing as per the test plan.

Perform DB Testing as per the test plan.

Defect reporting using QC.

Publishing status reports to different stake holders.

Intralinks Client Tools Functional QC (Feb 2011 to Oct 2013) As Sr. Test Engineer.

Responsibilities

Test Planning, Test Case Design and Test Execution.

Designing Input XML for each Test Case.

Defect reporting using JIRA.

Assigning tasks to team members.

Publishing status reports to different stake holders.

South West Airline (Jan 2011 to Feb 2011) As Sr. Test Engineer.

Responsibilities:

Test Script Design using SQL.

Test Case Design and execution.

Publishing status reports to different stake holders.

EDUCATION:

Master of Computer Applications (MCA), Bangalore University, India. (Aug 2005 to Aug 2008).

Bachelor of Science (BSc Chemistry) MG University India (Jun 2002 to Jun 2005).

Contact this candidate