Prithvi Purwar
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 Secondary
Tracking:
** 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.
Mahesh Chandra Gupta
Date of Birth : Aug11, 1987
Passport No. : P1152796
Marital Statues : Unmarried
Languages Known : English& Hindi
Current Adress : Flat No.-12 E-170, Street no.-3, West Vinod Nagar, New Delhi-92
Preferred Location : Anywhere in India
E-Mail : prithvipurwar2106 AT gmail.com
Date :
Place :