Akash Kumar

Address: B-*, Chander Vihar Mandawali New Delhi-110092

Email_Id: adjwo2@r.postjobfree.com

Phone No: +91-999*******#991*******

Career Objective

I am looking for a challenging job where I can utilize my talent and knowledge, I want to learn from the organization and growth with the organization.

Education Qualification

Name of Qualification

Board/ University

Year of Passing

M.com

Agra University

2008

B.com

Agra University

2006

Intermediate

U.P. Board Allahabad

2001

High School

U.P. Board Allahabad

1999

Professional Training/ Certification

I have completed my "MIS & Data Analysis"(Advanced Excel, Macro, Excel VBA) Course Duration of six months from SLA Consultants India Institute Delhi. Dec 2016- May 2017.

Technical skills

Sum if & Sum ifs, Count if & Count ifs & Count Blank-Count a, Average if & Average ifs & Sum Product & Subtotal etc.

V-lookup & H-Lookup, Index with Match, Hyperlink, Flash Fill, Data Consolidate Date & time function etc.

Lower-Upper-Proper, Len-Right-Left-Mid, Concatenate & Text-to-Columns, Text join & Trim, Clean, Max, Min etc.

Auto & Advanced Filtering, Pivot Table with Charts & Slicer, Conditional Formatting & Data Validation function etc.

knowledge of Power BI.

Basic knowledge of Macro & Excel VBA.

Google Sheet Tools Skills

Good Experience to work on Google sheet formula at Split & Import range & Array Formula & Google translate & Filter, Text join, Concatenate, Unique, Sort & Query, Count Unique, Transpose functions etc.

Knowledge of Google Sheets & Google drive & Google forms.

Ms Access

Basic knowledge of Ms Access (Tables, Form, Query, Report)

Work Experiences

Designation: MIS Executive

Organization Name: Dr. ITM Limited Noida.

Time period: 11th Nov 2011. to 25th March 2014.

Role and Responsibilities-:

Normal Making data of working process sheet of excel etc.

Document Scanning & Data entry Online copy paste.

Normal MIS Reporting of Daily/Weekly/Monthly records.

Normal Preparing sales report State Wise / Brand Wise & Distributor Wise/City Wise.

Working in excel as per data in the filter, Pivot Table, Chart, Slicer, V-Lookup & H-Lookup, Index, Match Function etc.

1.Working as Data entry July-2014 to Jan 2015 (Laxmi Nager Delhi).

Designation: Data Mining Executive & Data Analysis

Organization Name: Kromozones Software Pvt.Ltd Noida. (Mindyourfleet.com)

Time period: 25th Feb 2015. to 30th April 2019.

Role and Responsibilities-:

Data mining from different sources- Linkedin & India Mart, Justdial, Indian Yellow Pages, ask Laila, Web Directory and Online Business Directory & Google Search and Function.

To pull from information (Company Name, Contact Number, Email Id, Person Name, Website, Address etc.). from various sources in the excel format.

Removing duplicate numbers from Data through Excel (Tools and formula).

Data Reports- Maintaining on the excel sheets.

Data searching on the internet.

Preparing Monthly billing & Supporting to clients.

Sharing Data reports (Daily, Weekly & Monthly) with Manager.

Data Analysis using Pivot Table, Lower-Upper-Proper & Trim, Clean-V-lookup, Index, Match functions etc.

1.Working as Data Mining & Data entry from May 2019 to Dec 2019 at (freelance Part time Work).

2.Working as Data Mining from Jan 2020 to Aug 2020 at (freelance Part time Work).

Designation: Data Management Executive

Organization Name: P.P. Jewellers Karol Bagh, New Delhi.

Time period: 2th Sep 2020. to 20th Jan 2021.

To Create Daily Data Entry Google Sheet.

Create Google forms.

IMS Sheet Daily Update & Data entry.

Normal MIS Reporting & Data entry of Daily/Weekly/Monthly records & Data Management.

Area of Interest

MIS Executive

Data Mining Executive

Data Analysis

Data Management Executive

Notice Period

Immediate Joining.

Communication Skills

Having good communication skills in Hindi.

Personal Details

Father’s Name

Shri Pyare Lal

Date of Birth

5th February 1981

Sex

Male

Nationality

Indian

Hobbies

Listing music & Cricket, Internet Surfing

Marital Status

Married

Languages

English & Hindi

Declaration

I hereby declare that all the above information furnished by me is true to the best of my knowledge.

Date: -

Place: - New Delhi (Akash Kumar)

Contact this candidate