Prabhakaran Sivasubramanian Email: adhwta@r.postjobfree.com

Testing Engineer Mobile No: +91-962*******

A Technology driven professional with 4 Years of experience in Open Source Technologies like MS-Excel and our own product Boom rev and Commerce IQ.

Professional Summary

Having 4 Years of experience as Manual Testing.

Manipulating, cleansing & processing data using SQL and Ms-Excel, Responsible for loading, extracting and validation of client data.

Analyzing raw data, drawing conclusions & developing recommendations Writing SQL scripts to manipulate data for data loads and extracts.

Developing data analytical databases from complex financial source data.

Performing daily system checks.

Data auditing, creating data reports & monitoring all data for accuracy.

Designing, developing and implementing new functionality.

Monitoring the automated loading processes.

Carrying out specified data processing and statistical techniques.

Supplying qualitative and quantitative data to colleagues & clients.

Currently working with international ecommerce based clients like Walmart, Office Depot, Home Depot, Nordstrom and Staples.

Good team player, quick learner and hard worker.

Educational Qualification

Bachelor of Information Technology from Periyar Maniammai University, Thanjavur in the

year of 2015.

Certification Courses

I did my testing certification course in FITA academy

Professional Working Experience

Worked as a Client Data Validation Engineer in Commerce IQ, at 2 Years 9 month of experience

Working as a Client Data Validation Engineer in Lowe’s, since SEP 2019.

Technical Skills

● Programming Languages : Java, SQL

● Automation Tool : Selenium IDE, Selenium Web Driver.

● Bug Tracking Tool : JIRA

● Operating Systems : Windows

● Web Technologies : HTML and CSS

● Development tools : Eclipse

Project Summary

Project : Boomerang Retail Analytics Product

Role : Data Validation (Manual Testing).

Technologies : MS-Excel, Tableau And SQL server

Description : Application to compare client and its competitor’s products based on different match strategies, validation strategies and price variance.

Project Experience Summary:

Project#1 : Data Warehouse of Retail Sales Analysis.

Role : Data Validation (Manual Testing).

Description: This is basically a Data Warehousing project in e-commerce platform. The hardcore functionality of this project is to load the daily catalog data (which will be shared by client itself on daily basis) into a database and perform required analysis with the help of stored data. The application helps the clients to compare their performance against the various competitors by means of a user interface tool.

Description: Boom Rev is a tool used to analyses the daily stream of transactions in the e Retail industry for cost reduction helping the online retailers to optimize their price of raw sales volume and improve margins

●Writing hive queries to process the data and project it according to the Decision making engine (Boom Rev)

●Involved in requirement gathering from clients and analysis.

●Involved in the deployment of code in QA and Production Environment.

●Testing the products Against Generated result's By the Auto Matcher.

Data extraction from source systems, cleansing and transforming the data and Finally loading the data into warehouse schemas.

Once the data is ready, we are clean the data and we have to upload to Jenkins and scraping team people will process.

In Retail brands we have to using Boom Rev product and Brands Promoting we are using CommerceIQ

Project#2 : Brand analysis & Brand marketing

Client : Avery, Kellogg, Movado, Unilever like Ext

Role : Data Analytics (Manual Testing) and Brand Analysis

Description: This is basically a Data Warehousing project in e-commerce platform. The hardcore functionality of this project is to load the daily catalog data (which will be shared by client itself on daily basis) into a database and perform required analysis with the help of stored data. The application helps the clients to compare their performance against the various competitors by means of an user interface tool.

Description: Commerce IQ is a tool used to analyses the daily stream of transactions in the brand details we have to promote the brands in e commerce sites.

Data extraction from source systems, cleansing and transforming the data and Finally loading the data into warehouse schemas.

Once the data is ready, we are clean the data and we must upload to Jenkins and scraping team people will process.

In Brands we must using Commerce IQ to promote the client brands.

Finally, we have to analysis the Project#1 and Project#2 data’s and put it on the tableau.

Personal Details

Name : Prabhakaran Sivasubramanian

Data of Birth : 05-MAY-1991

Address ` : Btm Layout, Bangalore.

Languages Know : English and Tamil

Declaration:

I do hereby declare that all information furnished above statements are true and correct to the best of my knowledge and belief.

Date: SIGNATURE

Place: Bangalore (PRABHAKARAN.S)

Contact this candidate