SRIVAISHNAVI RAJAGOPALAN Technical Operations Associate- Amazon

Total Work Experience (3.5+ Years)

Phone:

+91-900*******

Email:

vaishuraju@

outlook.com

LinkedIn

BUSINESS SKILLS:

DATA ANALYSIS

TAKING OWNERSHIP

PRESENTATION

LEADERSHIP

CORE

COMPETENCIES:

SQL

PYTHON

MS EXCEL

Area of

expertise

Expert knowledge in MS Excel, MS Word and MS PowerPoint

Proficient in writing and debugging SQL queries and data-mining

Data manipulation, extraction and ingestion based ETL process

Stakeholder management

Python based tool development

Python in data analysis and Machine Learning model

Leading the team, taking ownerships and adapting to new skills

Analysis on large volume of data and taking decisions for the business team Technical

Engagements

Data driven decisions:

Have written SQL queries integrating several tables for data extraction, that includes amazon global product catalogue data and special attributes for better decisions

Data analysis:

Worked on huge volume of data to develop automation tool and performed various analysis through data extraction, manipulation using SQL and Python

Product level comparison and attribute level comparison are performed across various marketplaces with the help of scheduled transform ETL

Carried out de-duping analysis to prove that recursive data was found in the selection catalogue which consumed greater work force and time Statistical inference:

Queried various historic data from the database and performed regression analysis to find the statistical relationship between attributes. This reduced the validation effort by 2.8 FTE saving

Drove 1.6 FTE Saving by replacing the existing queries that required more man-power to integrate the results with a single query, that performs all the integration and provide result

Impact forecast:

Partnered with the Business Analysis team and built several queries which helped in forecasting the business impact on the team cluster

Consolidated historic data and regression analysis is performed with the help of scatter plotting

Technical

Support

Analyst

(Oct 18 –

Present)

Project Context:

Generating product information for different marketplaces - amazon.com, amazon.ca, amazon.in, amazon.sg and amazon.com.au

Drove 1.2 FTE savings by partnering with data engineering team to build an automated computation logic for Anomaly detection, using quicksight.

This involved building a dashboard displaying 7 key certification metrics on Quicksight with tables being loaded as a result of scheduled transform ETL’s.

This eliminated the need of manual querying at marketplace level and reduced email churn as the reports are available for direct one click download.

Performed web crawling and scraping for various websites

Active SME in handling escalations, process oriented tickets and providing RCAs

Framed multiple canned SQL queries during migration period from oracle to redshift (org wide oracle deprecation event) for the associates to extract monthly and periodic data from fact tables and dimension tables in amazon database.

Worked with large amount of numeric data for 1000+ retailers OPERATING

SYSTEMS:

WINDOWS

UBUNTU

LANGUAGES:

ENGLISH

TAMIL

HINDI

Quality

Analyst

(Oct 16 –

Sep 18)

Project Context:

Quality check on digitally-submitted product information to meet “Amazon Catalogue Standards” for amazon.com, amazon.ca, amazon.in, amazon.sg and amazon.com.au

Trained and performed quality check program for the ARM process

Have been a part of ML project (Machine Learning) for building attributes matching logics

As a part of business team, took decisions that had a positive effect on the team’s growth

Given inputs to train an automated AI to map data from various sources to Amazon catalogue

In addition to training the automated AI, performed various RCAs in order to increase the catalogue selection and to improve the quality of data

Built an Excel based macro/VB script to generate finalized ARM audit accuracy report from the audit results. This reduced the report consolidation effort by 1.25 man-hours per audit batch

Written SQL queries to pull data set based on requirements and to execute data analysis

Created the Five-in focus program as a solution to reduce the team defect rate in terms of quality and the defect rate was reduced to 1.33% Accolades

Tech wizard:

Received Tech wizard-2019 award for taking ownership on an analysis performed on the UPC duplicates across the marketplaces

Pure performer:

Received pure performer-2018 award for building multiple scripts using VBA for excel to automate report generation of various audit processes Promotion:

Promoted to Technical Operations Associate in 2years Hiring

Decisions

Actively been part of hiring loop for tech-ops and quality analysts and successfully hired 20+ candidates (level 3).

Educational

Qualification

B. E (ECE)

Dhanalakshmi College of Engineering, Anna University (2012-2016) Aggregate - 79.00%

Awarded the best final year project in the department

Acquired the position of 2nd runner-ups in the Texas Instruments India Analog Maker Competition 2015.

XII Class/HSC

Sri Sankara Vidyalaya Hr, Sec, School (2010-2012)

Aggregate - 84.00%

X Class/SSLC

Sri Sankara Vidyalaya Hr, Sec, School (2010)

Aggregate - 86.00%

Contact this candidate