Pawan Srivastava


Work History

Work History
Mar 2014 - Present

MIS Co-Ordinator

ZTE Telecom India Pvt.Ltd,
  • Update & Circulate Projects Master Tracker with all details.
  • Update & Circulate Zonal DPR.
  • Update & Circulate Core & Ran Tracker.
  • Update & Circulate Daily MW Tracker.
  • Circulate Daily Zonal Plan Vs Achievement Report to Zonal.
  • Circulate Weekly Gap Analysis report to Zonal.
  • Circulate Vendor wise weekly achievement report.
  • IPR & PO Management for Vendors.
  • Upload Important documents like ATC,RFI Reports etc. in SharePoint
  • Update & Circulate failure reasons for not achieved Sites.
  • Update & Circulate Infra Tracker with all details.
  • Update & Circulate TI Activity Tracker with all details.
  • Update & Circulate Various Plan Vs Achievements Tracker.
  • Update & Circulate Complains Rectification Tracker.
  • Verify Vendors Work Competition Certificate.
  • Prepare Project Data for Meetings.
  • Analysis Gaps Between all activity done in project time to time, Like gap between Sites HO & Material dispatch, Material Dispatch & BTS installed etc..
  • Co-ordinate with Vendors & Internal teams for updates and information.
  • Prepare documents for RFI Reports Submission & ATP Offer.
  • Prepare various reports as per requirement.
  • Upload Reports to P6 SharePoint.
  • Excel Trouble shooting.



Dec 2010 - Mar 2014

MIS Executive

Alcaltel-Lucent India Pvt.Ltd.
  • Prepare and circulate Site wise NWA for IP colo Sites.
  • Collect remarks for sites not achieving bench-mark NWA from Cluster Lead.
  • Categorize remarks and mail to IP Colo Vendors for their issues.
  • Download raw reports on Daily basis.
  • Prepare and circulate Busy Bouncing Hour (BBH) report.
  • Edit and circulate Cell performance reports (RAN Reports) for Circle.
  • Prepare and circulate MSC wise & BSC wise total traffic report
  • Maintain DPR for New MW hops and circulate it.
  • Contact area manager to know reason for outage.
  • Prepare and circulate Outage Report of swapped sites.
  • Prepare and circulate Weekly Outage report of IP Colo sites.
  • Co-Ordinate with Project Team.
  • Prepare and circulate NBH, BBH, DBBH, DBH and 24HR. report of ZTE site.
  • Prepare and circulate Data payload report.
  • Prepare and circulate Daily & Weekly 0 Call Cells Report
  • Prepare WCC of Completed Project.
  • Prepare and circulate NQI Calculation Report of 3G
  • Prepare and circulate Weekly 3G Congestion & Throughput Report
  • Prepare and circulate Weekly 3G Utilization town wise report.
  • Prepare and circulate Weekly CTO Dashboard presentation for 3G.
  • Prepare and circulate Weekly 3G Presentation.
  • Prepare and circulate other reports like 2G swap integration, 2G to 3G Swap Tracker, 2G and 3G RTL

Acceptance Tracker etc.

  • Prepare EMF Data Sheets.
  • Maintain EMR records.
  • Excel trouble shooting.
  • Updating sites info on RFM Portal.(If Required).
  • Prepare and circulate Ater Utilization Report (If Required)
  • Create Plan Event on portal.(If Required).
Oct 2008 - Dec 2010

Data Entry Operator

GTL Infrastructure Ltd.
  • Maintaining all records like GRIN, GRN, DC, and SRN.
  • Maintaining stock inventory at Oracle.
  • Keeping & maintaining records of Invoices ensure that organized Invoices along with GRN are send to Corporate Office.
  • To ensure that there is no duplication of MRNs or any material.
  • Maintaining MIS for Warehouse.
  • To create and send MISS. Report Like –Daily dispatch detail, Weekly stock report, Monthly Stock

Statement, etc.

  • To assist the Warehouse In charge.

Excel trouble shooting

Oct 2007 - Oct 2008

Caf Auditor (MIS)

Tata Teleservices Ltd.
  • To provide CAF (Customer Application Form) receiving report.
  • To audit physical cafs and software entries
  • To send CAF and POS audit report to Circle Office.
  • To create CAF pendency to locations
  • To call to locations and ask for CAFs.
  • Maintaining important records like ESN of handset, and data card, address change document and details etc.
  • Collect the CAFs from locations and dispatch all the complete CAFs to circle warehouse.
  • To create service request for customer service.
  • To provide other reports asked by circle office.
  • To do the order entry with the Data Entry Operator.



Jul 2008 - May 2014


Jul 2002 - Jun 2004


C.M.Anglo Bengali Inter Collage
Jul 2000 - Jul 2002

High School

C.M.Anglo Bengali Inter Collage