Name : Mukesh Rawat
Experience : 5 Years
Qualification : Bachelor of Art
Email ID : mukesh16462 AT gmail.com
Career Objectives :
Seeking a position to utilize my skills and abilities in the industry that offers professional growth and to be a part of the result oriented professional team, which provides challenging work with growth and promotion opportunities.
Knowledge & Skills :
** Proficient in Advance Excel (Lookups, Advance Filter, Formatting Techniques, Text Functions able to write complex formulas)
** Having strong problem-solving, analytical & Interpretation skills.
** Ability to process large volumes of data into meaningful summaries and presentations.
** Can manage time accurately and undertake complex tasks.
** Advanced level of MS Office applications especially Excel & Access.
** Proficient in MS – Access (Design Queries with Different criteria’s, Complex formulas, Design Macros)
Keyword :
Vlookup, Hlookup, Pivot, Advance Filter, Slicer, Count if & Countifs, Sum if & Sumifs, Counta, Count blank,Sumproduct, Index, Match, Trim, Len, Left & Right, Left with Find, IF, Iferror, Rank, Concatenate, Text, Randbetween, Round, Round Up & Down,Lower & Upper & Proper,Conditional Formatting, Data Validation, etc.
Work Experience :
** Worked as MIS Executive in Competent Synergies Pvt, Ltd. from (Jul-2012 To Dec 2014).
** Presently Working as Data Analyst in Innovative incentive & Reward Pvt Ltd. (Dec 2014 to till date).
Job Responsibilities :
1.Innovative Incentive & Reward Pvt Ltd :
** Managing of redemptions and loyalty programs for different clients (Nerolac, Apollo Tires, JK Cement, Hella, Crompton, Indo Asian, Sarovar Rewards,)
** Handle Packaging and Bulk dispatch.
** Ensuring Compliance of service benchmarks for all the clients.
** Handling Escalation of customer complaints and resolution in given SLA.
** Maintaining and compiling Daily / Weekly/ Monthly primary, secondary and closing sales data of the region.
** Generate Area wise customer wise Sale report and compare with previous Year on daily basis.
** Maintain the records for Crate Reconciliation in every plant.
** Preparation of Customer Service Productivity &Quality Reports as per Management's requirement.
** Coordination with the SCM team for the availability of stock and managing the stock as per Market size and customer base.
** Performance Trend Analysis of Data and Automation of reports.
** Monitoring of all repeated issue and accordingly take action for permanent fix in co- ordination with concern team.
** Bulk Emails and SMS communication to customers and Partners.
2.
Competent Synergies Pvt Ltd :
** Preparing Daily MIS Analysis and Report Generation.
** Maintaining Process Wise Data.
** Handling Dialler of Genesis’ and cube.
** Responsible for Timely Reporting of Allocation status to the Opp. management & Clients.
** Responsible for preparing the data allocation for Outbound Calling which was received on different intervals.
** Responsible for all types of reports, Dashboard.
Personal Details : -
Date of Birth : 12-07-1994
Gender : Male
Marital Status : Unmarried
Address : #400/23, Aadarsh Nagar, Nayagaon, Mohali, Punjab, Pincode 160103
Hobbies : Listening to Music, Playing Cricket.
Date :
Place :