Personal Details

: 937-***-****

922-***-****

: adx3mv@r.postjobfree.com

Address: C/6, Jay Bharat Housing

Society near Santoshi Mata

Mandir Sunder Bag Kamani Kurla

west

ARUN NARSING DARVESH

Data Analyst

WORK KNOWLEDG & EXPERIENCE

{9 YEARS AND 2 MONTHS}

{DATA AND BUSINESS ANALYST}

ADVANCE EXCEL AND

DASHBOARD

GOOGLE SHEET AND GOOGLE

STUDIO

MACRO

POWER BI

SQL {Pursing Course}

EDUCATION

MBA IN FIANACE (Armiet College of

Management} {2015; 67%}

T.Y.B.M.S {Patuck Gala College of

Commerce & Management} {2012;

63%}

XII Marceline junior college {2008; 61%}

X Kartika High School {2006; 46%}

WORK EXPERINCE

Worked in I-PROCESS (15th

April 2012 to 15th January

2013) {10 MONTHS}

Worked in ANUJA

ENTERPRISES. (18th March 2015

to 15th APRIL 2018) {3 YEARS

and 2 Months}

Worked in KAE Management

Services (20th April 2018 to

31st October 2022) {4 Years, 7

Months}

Working In Electronic and

Devices {From 03st November

2022}

ROLES AND RESPONSIBILITIES

Creating reports & Analyzing for In house 3 Departments (Sigma Cap seal, Sigma Weld, Sigma Term) Such as a Sales Analysis, Gross Profit Analysis, Production Reports, Mechanical Parts Planning Analysis, PCB Component Planning Analysis, Breakdown & Service Reports Analysis And Many More.

Hands-On Using Advanced-Level Calculations on The Larger Data Set. create Dashboards and Interactive Visual Reports Using Google Data Studio Power BI.

Contributing to the Development of Sales Plans and Objectives. Monitoring and Analyzing Competitive Activity, Customer, and Market Trends

Monitoring and Evaluating Sales Performance. Making Data of working process Google sheet {Form Mule, Auto-Crat, Pre-Filled, Selection Wise, Google Form Add-on Image and Video Google Data Studio, F.M.S, P.M.S, P.C.B Process Flowchart}, and Excel. Etc}.

Prepare corresponding & sending regular reports via email. Advanced MS Excel Knowledge (Conditional Formatting, V-lookup, H- lookup, IF Function, Count Function, Sum Function, Index Match, Data Validation, Data Sorting) Working in Google Sheet & Excel as per data in Filter, Pivot table, & V-lookup.

Preparing Reports and Dashboards for client and central management. MIS Preparation of Daily/Weekly/Monthly records & data management as company required

Prepare Delegation Sheet and Follow-up Pending Task Making Sales Invoice as per GST & Generating MIS Reporting as per company requirement. And Maintain and update records with accuracy

& To keep records and information about deals with clients.

Analyze the actual sales versus the projected ones for each department. Supporting the field sales team regarding his performance, new product information, upcoming product internal support etc.& Utilize graphic design tools and software to develop create custom PowerPoint presentations and templates from pre-generated content & Developed and maintained Microsoft Access database. Create powerful queries to extract large database information from Excel to Access

Contact this candidate