Objective :
To contribute to the growth of a company and be a next generation leader through exercising the best of my abilities and skills and through constant learning from every experience in life.
Experience :
Working as Sr. MIS Executive in Sri Venkateshwara Auto Agencies from Dec – 2016 to Till Date.
Responsibilities :
** Proficient and Expertise working with Advance Excel and on Google Sheets.
** Prepared monthly Performance Status Reports.
** Collated, analyzed and documented company’s quarterly and half yearly performance details.
** Generated, maintained and analyzed Sales, Quality and Client Service reports.
** Reviewed history of current reporting.
** Monitored implementation of MIS processes and evaluated their effectiveness.
** Expertise on Purchase Requisition, Purchase Order and Invoice Processing
** Maintained and updated all details of service agreements with clients.
** Measured and developed service level targets against Best in class benchmarks.
** Performed Trend Analysis of Data and Automation of reports.
** Prepared variance reports such as Forecast vs. Actual sales.
** Experience and proficiency with a broad range of ERP (Focus & Wings) and applications
** Generate Daily/Monthly/Yearly Sales & collections reports by using advance excel functions.
** Co-ordinate with field team for the completion of sales planning tasks like brand share and sale punch on regular basis.
** Preparing POS based on Replenishment Data and forward to Vendors
** Preparing Brand level GP reports and analysis P&L status.
** MIS Reporting using V-lookup, H-lookup, Pivot, Index, Match functions.
** Working with Pivot tables and making charts
** Updating of Indent/stocks/Sales data and report to Management
** Responsible for Maintain warehouse Stock Vs Indent.
** Data Reports- Maintaining on the excel sheets/Google Sheets
** Analyze the actual sales versus the projected ones for each department
** Managing ERP software for analysis of Sale pricing
** Prepare Price list for Spare Parts in ERP : Focus
** Complete ERP operations (backend) setup for Price / Inventory.
Worked as MIS Executive in Carthero Technologies Pvt. Ltd. from Nov – 2015 to September - 2016.
Responsibilities :
** Download shipments data from CartHero Ops and Prepare consolidate EOD reports on delivered Shipments.
** Prepare MIS report everyday based on EOD report sent from hubs team.
** Coordinating with Manager and sending Final EOD & MIS reports to Central Team.
** Handling multiple reports, working with formulas, pivot tables and various other excel sheet components for accurate data.
** Handling with escalations report on shipments data.
** Excellent in MS Excel Logical Formula-Sum, Sumif, Count, Countif, V-lookup, Charts
Worked as MIS Executive in Venturewise Technologies Pvt.
Ltd. from Aug – 2013 to Oct - 2015.
Responsibilities :
** Work with MS Excel to prepare data sheets to import into the client’s ecommerce portal.
** Work with Custom tools (LinnLive) and software applications to manage customer product data and inventory across ecommerce platforms
** Coordinating with manager and sending daily report
** Receiving and downloading data from different sources and formatting data using MS Word & Excel.
** Handling multiple reports, working with formulas, pivot tables and various other excel sheet components for accurate data.
Worked as an Executive in IL&FS Environmental Infrastructure & Services Limited from Sep-2008 to July-2013.
Responsibilities :
** Managing the entire administration and facilities.
** Assist managers and executives with scheduling appointments and events
** Manage travel and logistics details for staff
** Maintain inventory of office supplies and equipment
** Manage both paper and electronic filing systems
** In charge of Official Travels & Hotel bookings and Printing and stationery
** Assisting the HR team and the VP in their official work.
** Responsible for maintaining Company confidential files & records
** Responsible for maintaining the records of office inventory and handling the petty cash and keeping the records of expenses
Educational Qualifications :
** M.Sc (IS) from Osmania University in 2004-05.
** Bachelor of Computer Applications (B.C.A) from Kakatiya University in 2000-03.
Technical Skills :
Operating Systems : MS- Dos, Windows 95-98 & XP
Packages : MS – Office,Excel Functions, MS-Visio
ERP :Wings & Focus
Typing :50 w.p.m
Languages :English, Hindi, Telugu
Date:
Place: