Richa Agarwal

Apt#***,*** *nd Avenue North, Seattle, WA 98109, adkde7@r.postjobfree.com, 206-***-****

COMPUTER SKILLS

Java, Python, C++, Bash, HTML/CSS/JavaScript, MySQL, Git/Github, Linux, MS Excel, MS Word, MS Outlook, LATEX, XML, R, Microsoft Access, MySQL Server, Oracle

EDUCATION

City University of Settle GPA 3.95/4

Master’s in computer science Oct 2018 – June 2020

Visvesvaraya Technological University (VTU), Karnataka, India GPA 3.4/4

Bachelor Electronics and Communication Engineering Aug 2009 – Jun 2013

Data Analyst, Advanced Sterilization Products (ASP)(Fortive ),Everett, WA March 2020-Present

Provided hypercare support to teams around the world by working non-standard work hours and resolved any critical issues as they arise.

Worked closely with Inventory team in order to manipulate, extract and cleanup data load into Salesforce to look for a incoming data and outcoming Shipments.

In order to track incoming and outcoming shipments use of tracker with logistics team check on regular basis.

Collaborated and coordinated with integration project managers, analysts, customer and offshore teams to troubleshoot incomplete or error data and to provide proper solutions.

For visualizing inventory shipments creating a dashboard with the help of Tableau and Excel.

In the Chargeback Cockpit, any distributor sales tracings that are missing the cross-reference for distributor contract to SAP contract gets flagged with errors. To remediate errors to check the already existing cross-reference table in SAP, or to check the end-distributor customer on the distributor contract and map to contract where SAP contract material price matches distributor sell price.

Worked and maintained on Commercial Resource Guide Pager is to provide a reference sheet to the commercial teams to help answer questions about the transition / changes to processes.

Collaborated Service Contract Billing hypercare team to provide to solve sync errors and able to clear up header date issues and constantly checking between SAP and OneASP for missing lines.

Reviewed on Salesforce Case Database manually through categorize the case management buckets.

Updated Customer Master Heatmap. By adding and export unique Sold-to’s and Bill-to’s number or accounts for 50+ countries.

Tools used Excel Power Query, SQL Server, SAP, Salesforce to overcome problems and provide solutions in Commercial Integration Team.

Tools used Salesforce for UAT testing environment, SpringCM to clean-Up data.

Remote managed a team of 5 in India to get reports on end-to-end lifecycle of procuring inventory to final sales.

Data Analyst Specialists, ProPoint (Premera), USA, Seattle Sep 2019 – March 2020

Data Validation of demographic data using SQL, VBA Macro, and Excel formula and Power Query.

Responsibilities include extracting data from an internal system, transforming data using SQL, and loading data in Microsoft Dynamic 365 (CRM).

Visualization of data, creation of dashboard and user telling by using Tableau, ggplot2 and Excel.

Data/Credit Analyst, Univar Solutions, Redmond June 2019 – Sep2019

Created Web Application Report at various cadences (daily, weekly, monthly) using Tableau, MS-Access, Salesforce CRM, MS- Excel, and UVX tools.

Job duties include data extraction, cleanup, and visualization using MySQL, R, tableau, SQL server and visual basic.

Responsibilities also include doing web billing using Intel, SAP and Ariba portal

Responsibilities also include having clear communication with clients on web application reports and web billing issues.

Created KPI reports in Excel.

Use an Agile methodology for completing project

SENIOR DIGITAL ANALYST, SANKHALA INFO SOLUTION, INDIA April 2014- Oct 2018

1. Google Analytics Dashboard Project

Implemented a google analytics tool for relevant data related to website traffic of our client

Created dashboard with the help of Apache Superset

For data visualization use of Tableau

Use SQL to access web traffic data

For persisting data in the blackened use of MySQL database

Analyze potential domestic and international audience for client

Comparison of raw and digital data with the help of A/B testing

2.Local SEO for Sankhala Info Solution Developers

Lead Link Building Team

SEO Proposal Preparation for Clients

Documentation of Team Performance

Implemented an email campaign for website

Track and analysis all incoming and outgoing mail of client

Managing On-page and Off-page Optimization of Websites

Developed quality content for website with help of WordPress

Use different plugins and themes for posting blogs, forum, articles and Press Release on various platform

With the help of quality content leads a valuable traffic through search engine

Edit website content to make it SEO friendly

Monitor site results through tracking tool

Knowledge on HTML assist in SEO friendly website

3. Bestbuy.com

Regulated on monitoring and focusing the goal and growth of audience

Access data through SEM channels

Implemented Ad copy and design for branding products

Calculate the performance of metrices assessment with the help of Google Analytics

Targeted a relevant keyword for website

Perform a PPC campaign for targeted audience and convert them into buyers

4. Freelance with Walmart.com

Lead Link Building Team

SEO Proposal Preparation for Clients

Documentation of Team Performance

Client Communication through Email and Client Report Preparation

Manage On-page and Off-page Optimization of Websites

Provide suggestions about SEO friendly design and development issues

Edit website content to make it SEO friendly

Monitor a site results through tracking tool

Software Engineering Intern, Rar3 Developers, India Dec 2013 – Feb 2014

Developed low-cost, high-impact features by presenting insights on key product drivers to the team

Conceived and owned ’Email Summarizer’, ’Email Priority Classifier’ features into ’Brainbox’. They demonstrated the ability to increase product use by 25 percent by solving a complex user-centric problem

Deployed and released multiple versions of the product by optimizing various features and functionalities

Collaborated with the cross-functional teams and stakeholders across geographies in building a dynamic product

Designed, developed a tool to import test cases, results and various metadata to a test management system using REST API and Python

Researched, discovered and presented how to customize an existing feature instead of building a new feature resulting in saving critical engineering cycles

Spearheaded the project’s progress by building Product (Feature) Requirement Documents, Project Progress Documents, and communicating with the stakeholders

Worked closely with the Manager to estimate cycles, and build the tool iteratively in a pure agile methodology

Collaborated with various teams and engineers to deliver project successfully

ACADEMIC PROJECTS

Data Modeling and Database

Developed Academic database is to store and manage data from university by using Microsoft Access. Implemented tables by forming store data, created through which data can be edited or entered in table, relationships established between tables where queries are modelled in order to take out required information is displayed using reports.

Phone Book Application

For accessing backend data use of MySQL database includes various functionality by using of C++/CLR program and use of various functionalities as edit, remove, print, added and search contacts in phone book.

Feature Extraction in ATM Transaction using Background Subtraction

Developed an approach for video surveillance in ATM kiosks on MATLAB. Background subtraction, head detection and image thresholding were used to extract features in ATM transaction. Extracted features were used to classify motions of humans inside and ATM kiosk.

Attendance Calculator

Designed and developed an attendance calculator for Samsung SEL employees using C# web development toolkit based on html page parsing technique to calculate relevant information based on entries and exits.

Capstone Data Project in R

Developed a model to predict the selling price of given home in Seattle in order to help and assess whether the asking price of a house is lower or higher than the value of house by cleaning, scraping, extracting and visualization of data in R.

Contact this candidate