09560866100 Professional Synopsis:Key Accountabilities & Responsibilities :
** Generate and distribute management reports in accurate and timely manner.
** Provide recommendations to update current MIS to improve reporting efficiency and consistency.
** Perform data analysis for generating reports on periodic basis.
** Provide strong reporting and analytical information support to management team.
** Analyze business information to identify process improvements for increasing business efficiency and effectiveness.
** Produce & recommend new report suites to provide insight & route cause analysis to the wider supply chain departments.
** Handling logistics in co-ordination with Sales force.
** Produce & recommend new report suites to provide insight & root cause analysis to the wider supply chain departments.Knowledge & Skills :
** 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.
** Firm understanding and experience in Microsoft Office and OOD Visual Basic
** Advanced level of MS Office applications especially Excel & Access.
** Well versed in all excel related applications.
** Knowledge of Pivot Table, Chart, Text column & Lookups, Logical functions, V&H Lookup functions, IF Statements, Nested If statement, Date Formula, Index, Match, String Function.
** Able to co-ordinate multiple tasks and meet deadlines under pressure.
** Work as a member of the operational team to achieve the business goals and objectives.
** Compilation and Flow Of Data in Prescribed Time Limit Professional Experience:
MTR FoodsPvt. Ltd.:
Sales Cordinator, July’2014 to Present
** Preparing Daily MIS Analysis and Report Generation..
** Maintaining and compiling daily / weekly/ monthly primary, secondary and closing sales data of the region.
** Preparation of various sales and market analysis report as requirement Zonal Managers and Area Managers.
** Preparation of Trade Claims, and process for approval.
** Generate Area wise customer wise Sale report and compare with previous Year on daily basis.
** Prepare monthly reports and track performance for All the TSOs
** Prepare Sub category , Category wise analysis reports to maintain data
** Prepare Stock and Sales Statement on every month for SecondaryTracking:
** Coordinate with Finance Department for the Claim settlement for Stockiest claims
** Prepare Review format for Analyze the Sales Trendz for the entire zone Sales Team
** Prepare Office Budget , Team Budget and Sales Budget on Quarter Basis
** Prepare Modern Trade Sales MIS report and Presentation on weekly basis (category wise, Store wise)
** Analyze Nielsen Data for Figure Out the trend of Market with competitors. Mother Dairy Fruit & Vegetables IndiaPvt. Ltd.:
Logistics SAP& MIS Executive, Oct’2011 to Jun’2014
** Preparing Daily MIS report for Analysis Daily Sales.
** Generate Territory wise customer wise Sale report and compare with previous date on daily basis.
** Making reports as per higher management requires for Six Sigma Project.
** Handling 35 Doe’s for taking care of Customer Order Booking and Invoice Process.
** Maintain All Doe’s Attendance and their performance report.
** Track Daily basis sale order with previous date to maintain Zero percent Error.
** Analyzed Data of GPS tracking to keep timely dispatch and supply of Transporter.
** Maintain the records for Crate Reconciliation in every plant.
** Responsible for verify All Transporter and All Vendor bills regarding stock supply and return stock.
** Responsible for clear all the credit check issue by coordinating with field force
** Maintain Records for All returns with their respective plant.
** Involve in monthly closing process for SD and MM module in SAP.
** Integration of Inventory Management in Logistic System.
** Integration in Quality Management.
** Creating Invoices of Various Plants.
** Handling Returns in Plants.
** Posting a goods receipt with reference to a return delivery.
** Working With Logistic Invoice Verifications.
** Transportation Monitoring For Inbound / Outbound Planning.
** Analyzing and monitoring the delivery.
** Managing distribution network from milk packaging plants.
** Timely dispatch of Indent from packaging plants.
** Accuracy in collecting Indent from Transporter / Distributors.
** Accuracy in communicating indent to plant.
** Segregation of routes according to best available options through Route mapping.
** Rationalization of routes to make it efficient & market friendly.
** Shifting of supply from one plant to another plant in case of capacity over in one plant.
** Study of insulation effectiveness of vehicles & accomplish necessary corrections. Piramal Healthcare Ltd.(OTC Division),
Zonal Sales Coordinator-MIS, Feb’2007 to Sep’2011
** Responsible for preparing Management Information System Report (MIS) of Customer Service Business Unit and HR Dept
** Generation of Daily/Weekly/Monthly Excel reports and validating the reports according to the QA documents.
** Making Daily Sales Reports.
** Preparation of Customer Service Productivity & Quality Reports as per Management's requirement.
** Consistent Development on New Reports as per Business Alignment.
** Prepares Daily Progress Report to keep track and check on internal targets of Field Force Team associates.
** Preparing Presentations of analyzed reports for Business Development meeting.
** Preparing the Attendance Reports, Incentive and Field Force Performance Reports. Technical Skills:** Operating System : Windows 98/2000/XP/Vista.** MS-Tools : Word, Excel, PowerPoint, Outlook** RDBMS : MS Access, MS SQL, Oracle 9i** ERP : SAP ABAP ( Reporting, Dialogue Programming, dynamic Programming)** Hardware : Windows & Software Installation Educational Qualifications:
** Bachelor of Science (B.Sc IT), from Sikkim Manipal University, Delhi
** Intermediate in Science from UP CBSE BAL Vidaya Mandir with Science & Math.
** High School in Science from UP CBSE BAL Vidaya Mandir with Science & Math.PERSONAL DETAILS :Father’s Name : Sh. Sponsored links :
Mahesh Chandra GuptaDate of Birth : Aug11, 1987Passport No. : P1152796Marital Statues : UnmarriedLanguages Known : English& HindiCurrent Adress : Flat No.-12 E-170, Street no.-3, West Vinod Nagar, New Delhi-92Preferred Location : Anywhere in IndiaE-Mail : prithvipurwar2106 AT gmail.comDate :
1. This is an online resume, managed by the candidate.
2. Create your online resume here.
3. If candidate allows, recruiters can contact the candidate directly.
4. Personal and contact details can be kept private optionally by the candidate.
5. Create a link to this online resume where ever you want in the web.