Default profile banner
ZS

ZISHANT SRIWASTAWA

@zishantsriwastawa

Data Analyst

New Delhi

Oppo India PvtGNIIT NIIT

Highly experienced professional with expertise in MIS reporting, data analysis, and inventory management. Proven ability to utilize tools like MS Excel, SQL, and SAP to generate detailed reports and insights across various zones. Skilled in coordinating complex logistics, managing stock levels, and providing comprehensive data support to regional and internal departments.

Experience

DIRECT BILLING / Inventory Management

Oppo India Pvt

Full-time•Sep 2022 - Present•New Delhi

Managed direct billing, cross DC IMEI transfer (Reliance, Croma, Vijay Sales). Monitored and managed channel stock levels, coordinating with suppliers, distributors, and internal teams across 26 states. Analyzed and forecasted demand patterns, assisted in developing inventory management strategies, and generated reports on stock performance and trends. Performed various analyses using MS Excel, including pivot tables.

Coordinator/Analyst

Varun Bevarage (Pepsi)

Full-time•Jul 2021 - Sep 2022•New Delhi

Coordinated with NCR and North Zone. Created new Purchase Orders (PO) based on vendor requirements and calculated vendor PO methods. Generated various sales-related reports, scorecards, and reports for Department Managers (DM) and Regional Managers (RM) on daily, weekly, and monthly bases. Tracked daily sales and stock positions.

Operation Associate

Paytm Payment Bank

Full-time•Jan 2020 - Apr 2021•New Delhi

Handled NETC product operations, including DA Validation via Sales Force. Prepared and published daily NETC data. Maintained the Fastag cycle via ECGS portal (NPCI). Handled all types of transaction pull-outs and created detailed Excel sheets. Created and tracked daily reports, providing coordination and training to teammates on process changes.

Data Analyst

Future Group

Full-time•Jun 2018 - Dec 2019•New Delhi

Coordinated with two zones (NCR and North). Implemented and analyzed data to create daily, weekly, and monthly reports. Generated various sales-related reports, scorecards, and analyzed Sales & Margin Trend MC Share in FB Sales Analysis. Tracked daily sales and stock positions across all stores.

MIS Executive

General Motors India Pvt. Ltd

Contract/Off Roll•Nov 2016 - Jan 2018•New Delhi

Received and downloaded data from various sources and all 4 zones using SQL server. Prepared various MIS Reports through DMS and Target Vs. Achievement Reports. Performed various analyses using MS Excel, including pivot tables. Automated and created effective codes using MS ACCESS Tools. Generated sales-related reports and scorecards for AM and RM departments.

Education

J P University Saran

Bachelor of Science (B.Sc.)

Science

Invalid Date - Jan 2010•Grade: N/A

Bihar Intermediate Education Council

Class XIIth

Intermediate

Invalid Date - Jan 2007•Grade: N/A

Bihar School Examination Board

Class Xth

Secondary

Invalid Date - Jan 2005•Grade: N/A

GNIIT NIIT

N/A

N/A

Invalid Date - Jan 2011•Grade: N/A

Skills

MS Excel (Advanced)
MS Word
PowerPoint
MS Access
SQL Server
SAP
SQL
CRM
Inventory Management
Data Analysis
Reporting
Pivot Tables
MIS Reporting