Jeevan Rawat Email & Phone Number

Noida, Uttar Pradesh, India

Currently working with online E-Commerce team and managing the responsibility to prepare various MIS reports to ensure different products fulfillment at PAN India locations for LG’s customers (i.e. Flipkart, Amazon, Appario etc.). Key Responsibilities:· Making daily reports & dashboards to give online platform a quick glance on the current performance of any online LG product vs. the assigned KPI for the month. · Sharing Daily/weekly/Monthly sale in, sale out and inventory report with SCM & online sale team.· Responsible for sharing current pendency details for all Products with all categories stakeholders on a daily basis.· Engaged in sharing pending model details with production and planning team so that production can be align accordingly to fulfill current back orders needs for online platform.· To share visibility on the availability of stocks so that appointment can be taken with customer accordingly.· To conduct stock movements on need basis by doing inter branch transfer when a product is not aligned in production or the product is in transit and the appointment with partners is fast approaching.· Involved in account hold releasing activity with Account’s department so that the material can be bring in open for shipping.· Coordination with branches to ensure the timely off-loading of the online sale products at branches.· Responsible to reply all customers and other stakeholder’s queries as and when required.

Noida Area, India

Rich Experience in data analysis and back office operation. Ability to handle millions of records and can represent in a meaningful summary, Proficient with in-build or customized database Tool/Software like, MS excel [Pivot, Power Pivot, Power Queries, and various excel formulas & functions like HLOOKUP, VLOOKUP, SUMIF, INDEX, MATCH, TEXT FUNCTIONS etc.].· Have Handled 32 members of team and used to conduct team meetings and give process training to new team member.· Strong understanding of advance excel skills, automation, dashboard reporting.· Was responsible to replay to client email regarding their queries and issues.· Ensured 24X7 work coverage for the client and ensured timely completion of job without impacting the client’s deadline.Strong with following reports type:· Daily, weekly Bi-weekly & monthly productivity reports.| Quality reports | Incentive reports for different projects. | Quarterly performance reports |Dash board.· Comfortable with routine reports as well as ad hoc reports.

Gurgaon, India

Mynd Solutions provides a better way to manage important, non-core business processes including Finance, Accounts, payroll, Manpower Outsourcing, Data processing & Record keeping. My Area of responsibilities included:· To monitor the work-in-progress on an ongoing basis.· Preparing & compiling various MIS pertaining to process, tracking, forecasting.· Preparing daily, weekly, monthly, and periodic management reports used in business decision making · Interdepartmental coordination and follow-ups to resolve the issue raised by the vendors/client side.· Coordinate with Business partners to expedite vendor’s payment within specified timeframe.Other responsibility:· Responsible to resolve the invoice related queries escalation from business partner & vendors.· Prepare corporate & internal MIS reports.· Team handling of 20 people sitting at remote PAN India locations and visit there on need basis.

Noida Area, India

• Have worked in the process called “ISS-Investment Support Services”.• We used to manage accounts for various asset types wherein we go ahead and update accounts to their current values based on the asset's particular requirement by applying various permutations and combinations.• Worked as a team coordinator and as a backup for my team in the absence of SME.• Engaged in preparing daily MIS reports of the process, floor support for team & sending query to the client for the entire platform on a daily basis.