SQL

RAVI KUMAR T C Email: *************@*****.***

(Automation Specialist) Mobile: +91-789**-*****

Objective:

To take up any challenging position where my Knowledge in technology can be utilized for the maximum benefit of the organization .Open to new ideas and an attitude as well as potential to grasp & implement new technologies.

Summary:

Graduated on 2014 with Bachelor degree (B.E) in Information Science (ISE).

Highly accurate and experienced Data analyst adept at collecting, analyzing, and interpreting large datasets, developing new pricing models, and performing data management tasks.

Possessing an extensive analytical skills, strong attention to detail, and a significant ability to work in team environments.

Experience Summary:

Company: Amazon.Com

Title: Automation Specialist

Duration: Sep-2014 to present

Experience in automation of Web based E-commerce sites. Analyzed the processed data for mapping coverage/Detail page hit/Crawl Frequency/Crawl Lag/Crawl-Scrape failures and pricing recommendations

Program/configure codes using Java Configuration for Automated Pricing Events. The Main objective is to ensure minimal manual effort in pricing events with ~100% accuracy within the estimated SLAs.

Collected, analyzed, and interpreted PARS attributes from various websites.

2+ years of experience in implementing Object-Oriented Python, Hash Tables (Dictionaries) and Multi-threading. Experience in database related languages like MySQL and ETL query execution.

Excellent experience of element locator X-path and CSS locators and configuring Xpath and Regular Expression into web application.

Carried out various mathematical operations for calculation purpose using python libraries.

Managed large datasets using Panda data frames and MySQL.

Proven skills in Leading and training teams.

Working with business and Management teams to understand and identify all requirements information that is relevant to the project.

Developed Tableau visualizations and dashboards using Tableau Desktop and workbooks from multiple data sources using Data Blending

Core Competency:

Technology

Web technologies,SQL, XPATH, Regex, Html, CSS, Machine Learning, Statistics, Tablue

Programming Languages

C, C++, Java, Python

Web Server

Apache

Operating Systems

Windows, Linux

Tools

Selenium WebDriver, Selenium IDE, TestRail, Eclipse, ETL Manager, SQL Workbench/J

Database

SQL/Redshift

Projects:

Project #1

Title : Retail Systems Platform (RSP)

Role : Automation Analyst.

Duration : August 2017 to September 2018

Description:

The goal of the Retail Systems Platform (RSP) is to bring all business activities into a consistent user interface and to present, organize and prioritize work in one place. Retail Systems Platform's target audience includes core retail roles such as vendor manager, in-stock manager, site merchandiser, the category leader and finance.

Roles & Responsibilities:

Analyzing the Business Requirements.

Actively involved in the designing Test Scenarios, Test Cases and reviewing Test Cases.

Executing the test cases and preparing the post execution document.

Performing Sanity Testing, Smoke Testing, Functional Testing, Regression testing, System Integration and GUI Testing.

Writing SQL queries to validate the target data.

Defect Reporting and tracking using defect tracking tool.

Coordinating with other Testers, Developers, Support Team, Business Analysts and Clients.

Status reporting, progress reporting and review of deliverables and prepared exit report.

Project #2

Title : Automated Error Queue Report (Python)

Role : Automation Specialist

Duration : December 2018 to July 2019

Tools : Python 3.6, Selenium Web driver

Description:

This project is developed to convert a JSON file which contains competitor level error counts to a CSV file and to send it as a report on daily basis

Roles & Responsibilities:

Analyzing the Business Requirements.

All the competitor level errors will be stored in the database. (in .JSON format)

To publish this metrics as our daily reports, it need to be converted into .CSV file

Used Python for JSON processing, data exchange and business logic implementation.

Used python scripts to converts the .JSON file to .CSV file

Reviewing Test Cases.

It has been reported to the management on daily basis.

Detail Page Quality Assurance

Role : Automation Specialist.

Duration : August 2017 to till date

Based on the business requirement trends of the market, the product management team along with key stakeholders defines the roadmap for new functionality / Change of functionality in the Amazon Detail Page.

Project A: Energy Efficiency

Description: This project was undertaken to be in compliance with the Energy Efficiency related legal requirement in US and EU locales. The energy guide sticker (or a link to the sticker) has to appear in proximity to the price in the product detail page.

Project B: Prioritize pBook rental offer pricing on Textbook detail pages - US Textbooks

Description: This project was undertaken to modify buy box logic so that the Print rental offer is prioritized by default on Textbooks detail pages, when a renter offer is available.

Roles & Responsibilities:

Analyzing the Business Problem/Opportunity.

Actively involved in the designing Test Plan, Test Scenarios, Test Cases and reviewing Test Cases.

Executing the test cases and preparing the post execution document.

Setting up Test Environment.

Performing Compare Testing and Analysis of the results.

Performing Prod Traffic Replayer.

Performing Sanity Testing, Smoke Testing, Functional Testing, Regression testing, System Integration.

Gathering Test Data for different locale.

Defect Reporting and tracking using defect tracking tool.

Coordinating with other Testers, Developers, Support Team, Business Analysts and Clients.

Daily status reporting, progress reporting and review of deliverables and prepared exit report.

Attending Sprint Planning, Daily Scrum Status Call, Retrospection Meeting.

Professional Achievements:

I have awarded as best employee (star) of the month for 5 times.

I awarded as a best employee of the year 2017

I received “team hot shot” award for my bias for actions.

I received “day one” award for my consistent performance through the financial year.

Academic Profile:

B.E in Information Science Engineering from Shridevi institute of engineering and technology, Tumkur with 66.9% in 2014.

PU (12th) from Jawahar navodaya vidyalaya,Tumkur with 63.6% in 2009.

SSLC (10th) from Jawahar navodaya vidyalaya,Tumkur with 77.20% in 2007.

Contact this candidate