Tapan Behera
Mobile: +91-813*******
E-Mail: *****.********@*****.***
Objective
To seek the position of a MIS Executive/Analyst with a background of analytical skills along with data extraction, manipulation and analysis, generating analytical reports, dashboard, by using Excel, Macros (base), Reporting etc.
Overview
Expertise in -
Comfortable in Excel with quality, accuracy, and the ability to work without supervision.
Technically sound in MS Excel, Macros automation & advanced functions.
Comfortable in writing SQL queries in MySQL workbench platform.
Skilled in Spreadsheet manipulation, data analysis and summarize huge data using advanced Excel (Conditional formatting, Text to column, multiple Excel functions i.e. Max, Average, V-Lookup, Index, Match, Indirect, Row, Offset, Text, Value, Dated if, If error etc., represent data using pivot table, charts and dashboard.
Reports created & handled -
Excel dashboards, Projections, Target achievement plans, Leadership updates, Timesheet management, Pivot reports & charts, Activity count, time, percentage, agent efficiency calculations, etc.
Note: Reports are based on daily/weekly/monthly/yearly pattern.
Skillset
Proficient on Excel application, formulas, advanced functions etc.
Comfortable in manipulating analytical reports in excel.
Comfortable in writing database queries such as Sql server, mysql workbench etc.
Hands on experience on operating systems like Windows 10, 8, Ubuntu.
Good knowledge of MS Office 2010, 2013 & 2016(Learning).
Excellent problem solving, analytical and planning skills.
Good communication and writing skills.
30-40 WPM typing speed with accuracy.
Professional Experience
Currently working at – JustDial Ltd since August 2017 – current 3 years of experience.
Role: Database Executive – Noida Location
Department: Database Department
Key responsibilities:
Extraction of Market Data and manipulate in Excel.
Creating comparisons of client details for market research.
Validation checks to ensure data accuracy in the system.
Representation of reports within the team.
Creating weekly dashboard, leadership update reports for all the processes.
Academic Qualification
BCA from Bhubaneswar Utkal University.
Intermediate passed (2nd div.) from C.B.S.E in 2012.
High School passed (1st div.) from C.B.S.E in 2010.
Extra-Curricular Activities
Participated in Dance Reality Competition in 2014.
Joined photography workshops last year.
Personal Profile
Date of Birth : 02 October 1995
Present Address : H No- C 60, 1st Floor,C Block, Near Mother Dairy, Sector 22, Noida [201301]
Nationality & Religion : Indian, Hindu.
Marital Status : Single
Languages Known : English, Hindi
Hobbies : Dance, Photography, Filmmaking, Travelling.
Father’s Name : Late Sh. Manguli Behera
Declaration:
I, Tapan Behera, hereby declare that the above furnished information is authentic to the best of my knowledge.
Place: Noida Tapan Behera