Data Analyst

RAJDIPSINH ATALIYA

Mobile: 647-***-**** Email: ************@*******.*** LinkedIn: iamrajdipsinh

PROFESSIONAL SUMMARY

Accomplished and results-driven Analyst with 5+ years of experience working on analyzing the data to deliver meaningful and actionable insights at multiple levels in CPG, Retail & Service industry; developing solutions using statistical techniques, various tools & extensive knowledge of generating new methods for data analysis.

SKILLS

Expertise using SAS tools, SQL, Nielsen & IRI analytical tools, Answers Desktop

Learning experience working on Tableau, R, Project Jupyter, Java

Technologically advanced in MS Excel (macros, v-lookups and pivot tables), MS Office

Ability to deliver the right solution to the client using analytical and problem-solving skills

Proficient in Interpreting Data, identifying Trend and deriving actionable consumer insights

Excellency in building and maintaining work relationship through communicating at various level in order to get align with the clients and other teams

Able to communicate proactively and deliver the results on timely manner

A quick learner having an ability to adopt new changes and excited to learning new things

WORK EXPERIENCE

Retail Store Manager June 2019 to till date

Freedom Mobile

Dealing with marketing strategies, merchandising, planning budget for each quarter

Handling customer complaints, issues and questions to resolve their problems which is increasing customers’ satisfaction

Ensuring that customer care is on top priority by delivering great customer service and overall experience to each customer walk in to the store

Creating a positive team environment to encourage them to perform the best of their abilities

Providing frequent training and mentoring team to ensure the success of each employee

Retail Specialist (Part-time) Nov 2017 to May 2019

Freedom Mobile

Delivered quality service by successfully achieving 95% in mystery shoppers’ audit

Consistently top performer of our dealers’ stores in terms of creating more sales

Ensured effective merchandise of products and displays to optimize sales and profitability

Organised and executed special events for mobile launch and trained new employees

Data Analyst April 2015 – May 2017

Tata Consultancy Services

Developed and performed tests on new inspection tool using MS Excel, SQL & Nielsen tools in order to improve the efficiency in analysis which resulted in 20-25%-time reduction

Coordinated with client service, Development & Reference Data team on daily basis for any updates, queries, recommendations & improvement which streamlined the process with 94-97% quality

Defined the problems through the interpretation of trends & patterns by using analytical tools of using Nielsen & SAS and allot to the concerned team in order to reach the solution

Delivered the report on time on weekly basis for the allotted clients as well as responsible for the team delivery being a spoc for the team and managing in absence of Team lead

Conducted brainstorming sessions on new analytical techniques to implement into the checklist which increases team productivity in 2 months

Analyzed the databases thoroughly from Category level to Item level and prepared reports of each client with meaningful and actionable consumer insights

Database Analyst January 2013 – April 2015

Tata Consultancy Services

Created, modified, tested, and deployed database structural as required based on project specifications depending on client requirements and guidelines

Experienced in manual testing, test automation, executing test plans, writing SQL queries in order to deliver the accurate databases

Responsible for raising queries using SQL to raise concern regarding on going issue and maintain the database and assist other teams in retrieving data for their projects

Implementation of relevant information and organize it in a logical and functional manner into database scripts and mapping of characteristics

ACADEMIC BACKGROUND

Certification: Big Data Analytics Sept 2018 - March 2019

York University

Post Graduate: Marketing Management Jan 2018 - April 2019

Seneca College

Post Graduate: Information System Business Analysis May 2017- Dec 2017

Northern College

Post-Graduation Diploma in Management July 2010 - April 2012

Parul Institute of Management

Bachelors of Commerce: Accounting July 2006 - April 2009

M.S. University Faculty of Commerce

AWARDS & RECOGNITION

Freedom Mobile –

Maximum revenue generator 2019

Highest Productivity 2018

Best new Employee 2017

Tata Consultancy Services –

TCS Star Performer 2016

Team Award by Client Nielsen 2015

GOLD award by Client Nielsen 2014

Contact this candidate