Data Analyst

Anil Kumar

Permanent Address –Village & Post Sheikhupur

Distt- Bulandshahr (UP)

Current Address: FGMF+CM Delta I, Greater Noida, Uttar Pradesh Mob:+91-813*******

Email: adjgzn@r.postjobfree.com

CAREER OBJECTIVE

Seeking a role, where my knowledge and skills can be deployed in the manner which is beneficial for the organization as well as my personal development.

CAREER PROFILE

A confident Experience with proficiency in MS Excel. Possess complete knowledge of working with the excel tools. Fair knowledge of VBA Macros. Undertook training in MS Excel and VBA Macros from one of the reputed institutes in Delhi. Goal oriented and strong analytical skills.Ability to work in time sensitive environment. My determination, fast learning skills, quick adaptability and ability to work in teams makes me a competent and contributing member as an employee in any organization I join.

EDUCATION

● Completed Graduation in Bachelor of science from Dr. Bheem Rao Ambedkar University,Agra in the year 2015 and secured 58.2%

● Passed Higher Secondary Examination (U.P Board) in 2012 and secured 52.6%

● Passed Matriculation (U.P Board) in 2010 and secured 50% TRAINING UNDERTAKEN

● Undertook Certificate Training (Internship) in (Data analyst/MIS analyst )Advanced Excel and VBA Macros at SLA CONSULTANTS INDIA, Delhi

● Tech-Master TNS (Google drive,Google Form,Google Sheet ) TECHNICAL SKILLS

● Advance Knowledge in Excel (Formulae, Pivots, Charts, Lookups, Report Etc)

● Ability to work with Arrays Dynamic Pivot Table, Vlookup, Hlookup, Preparing Dynamic Charts, Conditional Formatting, Dynamic Dashboard, Sumif, Sumifs, Countif, Countifs, If Formula, Sumproduct, Left, Right, Mid, Substitute, Offset, Data Validation, Advance Filter, 3D Referencing, Etc

● Knowledge of creating dynamic named ranges.

● Ability to work with simple pivot and dynamic pivots.

● Full knowledge and understanding of the charting tools.

● Ability to create Dashboards in MS Excel and work on the same.

● Macros & VBA (Visual Basic Automation).

● Google form, Google sheets Google Add-Ons

● Query, import rang If condition

WORK EXPERIENCE

HCL Technologies

(MIS Executive)-2016-2017

Responsibilities:-

● Making report on daily, weekly and monthly basis of the candidates for Management.

● Making report for attendance, leaves and late arrivals of employees.

● Making pivot table and chart.

● Responsible for MIS, Forecasting and Analytics.

● Making report on daily, weekly and monthly based.

● Making and updating Dashboard and presentation to leadership team. Pashupati Overseas LLP

MIS Executive-2017-2020

● Making report on daily, weekly and monthly basis for Client.

● Maintaining data of Mobile Plans provided in UK.

● Interact with clients to clear the discrepancy if any comes during the data compiling.

● Doing data analysis in Database.

● Communicate with the client on daily basis to collect the data and while making reports.

● Making pivot table and chart as per the need of the client.

● Updating excel for Banners Content and convert into pivots.

● Dash Board, Pivot table

● MIS Reporting and Analysis

● All FMS,PMS,MIS,IMS,Goole Form,delegation Form/Sheet, worksheet presses MIS in Google sheets PERSONAL DETAILS

● Father’s Name : Mr.Lokman Singh

● Date of Birth : 10 th-August-1994

● Marital Status : Married

● Languages known : Hindi and English

DECLARATION

● I hereby declare that the information furnished above is true to the best of my knowledge and belief. Date:

Place: Noida (Anil Kumar)

Contact this candidate