Digital Marketing Data

Timmegowda Shekar

Bangalore, India, ****** Email: *************@*****.*** Phone: 748-***-****

Professional Experience:

* ***** ** ************ **** experience in IT industry as QA Analyst in database Testing and experience in testing Web based applications.

Hands on experience in ETL testing in backend systems and in Database testing in Digital marketing, Retail and Ecommerce Domain

Hands on experience in Functional testing and RESTAPI testing in Ecommerce and Loyalty program domain using Postman and Fusion API

Hands on experience in Selenium framework using POM with TestNG, GitHub and Jenkin integration

Hands on experience in Retail platforms like Shopify D365 and Oracle ATG

Extensively worked on Dynamic 365 and Manhattan OMS system

Proficient in writing SQL queries on databases on AWS Snowflake, Oracle, and SQL developer

Experience in creating Test Data, Analyzing Defects and interacting with development team to resolve issues.

Familiar with industry business knowledge related to Digital marketing, Ecommerce, Retail and Healthcare.

Hands on experience on ETL Testing, Manual Testing, System Integration, and web application testing.

Supported independently to completion of project

Experience in preparing test documents and analyzing the functionalities or business requirements.

Worked closely with the team to achieve Delivery Excellence by Status Reporting & Quality Metrics.

Work Exposure in Waterfall and Agile methodologies.

Tracking the code defects and Test case execution in quality center tool like MTM, TFS, VSTS and QTest

Tracking progress of the Project, Coordinating between Onsite-Offshore teams.

Technical Skills:

Primary Skills

Database functional testing, ETL/DWH Testing, Manual testing, Selenium testing, Oracle ATG, Shopify, D365, Manhattan OMS, BCC

Database

Oracle SQL, AWS Snowflake, SQL server, Teradata

Tools/Packages

Toad, SQLdeveloper, Putty, MTM, HPALM,TFS,QTEST,VSTS, Selenium, Eclipse

Operating System

Windows, Unix

Programming Language

Core Java

Defect Management Tool

JIRA, TFS, MTM, VSTS, HP ALM

Web Services

FUSION API, POSTMAN

SOFTWARE TESTING COMPETENCIES

Experience on writing & execution of Test cases, Test Scripts

Experience in database functional testing and data migration and manual testing.

Experience in Software Development Life Cycle (SDLC), Software Test Life Cycle (STLC), Bug Life Cycle.

Experience in AGILE process, involved in all phases starting from Scrum meeting, Sprint planning.

Good knowledge on SQL queries and basic UNIX commands

Experience in interacting with Developers, BSA, DBA, technical support and onsite leads.

Supported different phases of testing QA, UAT and Production.

Involved in Functional Testing, Database testing, Regression Testing, UI Testing, Mobile APP Testing.

Have good experience in Requirement Analysis, Design, Execution, Reviews, Defect Reporting and Tracking.

Education Details:

Post Graduation in MCA (Master of Computer Applications) from VTU Belgaum with an aggregate of 73.93%.

Organization Details:

WinWire Technologies Inc as Sr. QA Engineer Nov’19- Present

Ascena Retail Group, Bangalore as Quality Analyst May’19 – Nov 19

Epsilon, Bangalore as Quality Analyst 2 Nov’16- May’19

Netocol systems & solutions, Bangalore as Test engineer Oct 14- Oct’16

Project Details:

Project No#1:

Project Title:

Peets’s Magento to Shopify Migration

Client Name:

Peet’s coffee and Tea

Environment:

Shopify, Dynamic 365

Duration:

Jun20-Present

Description: Peets upgraded its existing platform from Magento system Shopify platform, as part of this migrated all functionalities of existing system to shopify by adding implementations to subscription and standard orders in order to ease the business model and make more interactive ecommerce website.

Roles and Responsibilities:

Analyzing existing Magento functionality and preparing documentation

Writing and executing test cases.

End to end testing on D365 and fulfilling the different types of orders

Validating the backend system for shipdate and Payment journals

Automating the regression suite using Selenium POM

Executing automation script when platform upgrade and fixing the issues

Connect with customers to clarify the business requirements and daily status

Verifying orders with different shipping methods, ship dates and different payment methods

Project No#2:

Project Title:

Peets’s NextGen Analytics

Client Name:

Peet’s coffee and Tea

Environment:

Power BI, AWS Snowflake, Shopify D365

Duration:

Apr20-Jun20

Description : Peets LY data that has been converted from our existing ERP validate the D365 Integration data that has been created as part of the functional testing along with shopify migration of existing platform integration with D365 system with peetnik rewards and subscription module.

Roles and Responsibilities:

Record count between Source and Target (Generate Automated Scripts)

Identify and Report value differences b/w different KPI’s & measures on Source vs Target (Generate Automated Scripts)

Document the steps for reproducing the defects or findings (deep level analysis required)

All raised issues/defects must be tracked via VSTS (DevOps)

Maintain Tracker of the bugs that were created and closed on work week

Re-test (Regression testing) using automated scripts once changes are made to the model/data columns

Modify the existing testing script to accommodate the changes for the changes in models.

Traceback value discrepancies from model back to data warehouse to DAX/D365 (Conversion / Live)

Raise defects to appropriate team once the data discrepancy is identified

Shopify integration and Preparing automation suite for regression testing

Placing orders in Shopify staging and complete the flow with D365.

Project No#3

Project Title:

Gilead EPI Azure Enhancements

Client Name:

Gilead

Environment:

Azure, Teradata, SQL developer

Duration:

Dec2019-Mar20

Description: In August 2019 the PVE Epidemiology Team completed the development of the PVE Azure cloud-based infrastructure. The Epidemiology Team is requesting architectural changes to the existing environment, improvements in process efficiency, the automation of data validation, and supporting technical documentation for future maintenance and upkeep

Roles and Responsibilities:

Analyzing the existing system functionality and designing the test scenarios and test cases.

Data validation in the SQL developer system and comparing with Teradata (Legacy) system

Verifying the data pipelines and data constraints and data types

Involved in coordinating with data Analytics team.

Identifying the key scenarios for testing all life cycle campaigns and specialty programs.

Creating test cases and SQL Queries.

Co-ordination with onsite leads with day to day activities performed

Reporting the defects in VSTS when we face issues while doing Test Execution.

Project No#4

Project Title:

Selling Systems (Ascena Legacy Ecomm)

Client Name:

Lanebryant.com, Shopjustice.com Dressbarn, Maurices

Environment:

Agility Loyalty, Oracle 10g, VSTS, Unix.

Duration:

May 2019-Till

Description: Ascena legacy ATG Ecommerce domain for the Legacy brands for Women clothing sites like Catharine’s, Dressbarn, Maurice’s, Lanebryant.com and Justice.com These sites allow customers to shop all kinds of women and Kids wear allow order items online where the customers has an option of delivering to STH and STS and these orders will be fulfilled by third party vendor and also promotions and offers given to customers who are met threshold in the cart page

Roles &Responsibilities:

Analyzing the existing system functionality and designing the test scenarios and test cases.

Validating promotions in cart and checkout page

Verifying the orders in OMS and PKMS systems

Deploying the changes to BCC based on Product or SKU

Involved in data base testing with end to end application flow

Placing and completing the end to end orders fulfillment

Uploading and executing test cases to qtest and sending the status reports

Daily sanity heath test for the sites

Involving in deployment calls after every regression testing completed

Verifying the orders in backend by writing SQL queries

Project No#5

Project Title:

FedEx Agility Platform

Client Name:

FedEx, USA

Environment:

Agility Loyalty, Oracle 10g, VSTS, Unix.

Duration:

June 2017-Till

Description: Epsilon providing digital marketing solutions and built a CVP platform which is a legacy system and migrated the platform to client on its very own product Agility loyalty (AL system) in order to retrieve the customer data and retrieve all digital points and offers and make the client more effective in terms of better marketing solution AL with the following high-level functional components:

Data migration includes for both US and APAC regions with the existing functionality with the legacy system and integrating Fusion API and CRM for defining the proper moments in the system will distribute the points based on the customer transactions amount, functionality includes the offers and allocation of points based on customers’ offers and tiers.

Roles &Responsibilities:

Analyzing the existing system functionality and designing the test scenarios and test cases

Data validation in the backend using SQL

Validating the ETL process flow across source and target systems

Validating JSON request and response

Involved in End-to-End DB functional testing.

Worked on Agile methodology

Data validation of existing and legacy system.

Involved in Integration testing.

Involved in coordinating with data Analytics team.

Identifying the key scenarios for testing all life cycle campaigns and specialty programs.

Creating test cases and SQL Queries.

Co-ordination with onsite leads with day to day activities performed

Executing and maintaining test cases in MTM and TFS.

Upload the test plan & test results in QA and team site

Reporting the defects in VSTS when we face issues while doing Test Execution.

Running the Jobs/Workflows in WINSCP for test data and extracts process.

Documenting the results and bugs.

Update the weekly/daily status calls

Testing the API requests in Fusion API and Postman tools

Involved in Regression testing

Preparing the reporting queries to test the reports generated by BI team

Implemented Selenium Web driver automation using JAVA for FedEx UI page

Contact this candidate