Parkash Chand

Data Analyst

ZUPE TECHNOLOGY PVT LTD•  May 2021 - Present

Carried out all duties as Data Analyst. Collecting/ Extracting Data from different sources and compiling it. Removing corrupted Data and fixing coding errors and related problems. Cleaning Data, managing outliers/Normalization of Data, Scrub for Duplicate Data etc. Auditing the Data to provide the accurate Data to management. Used statistical techniques for hypothesis testing to validate Data and interpretations. Visualizing the Data as Charts/Tables using Various tools. Successfully interpreted Data in order to draw conclusions for managerial action and strategy. Filter Data by reviewing reports and performance indicators to identify and correct code problems. Presented Data and conclusions to team in order to improve strategies and operations. Proposed solutions to improve system efficiencies and reduce losses. Preparing Analysis on Daily / Weekly & monthly Basis. Created Macros with help VBA editing to automate daily activity process of Excel. Analyzing, Validating Clients Payments Data and raising claims in case of missed payments. Variance Analysis -Missed Payment Claimed vs Reported. Generating & maintaining day to day MIS Data and updating the management. Preparing staff incentive and commission sheets. Analyzing and validating Quarterly Rebate Data and reporting variance for Rebate. Managing Staff Roster and Shift adherence analysis. Managing Stock Valuation Analysis

Data Analyst

BRIDGING HEALTHCARE TECHNOLOGIES PVT LTD•  November 2020 - April 2021

Carried out all duties as Data Analyst. Successfully interpreted data in order to draw conclusions for managerial action and strategy. Used statistical techniques for hypothesis testing to validate data and interpretations. Presented data and conclusions to team in order to improve strategies and operations. Proposed solutions to improve system efficiencies and reduce losses. Preparing Analysis on Daily / Weekly & monthly Basis. Created Macros with help VBA editing to automate daily activity process of Excel. Generating & maintaining day to day MIS Data and updating the management. Exporting the Data using MySQL for the different analysis and Reports.

MIS Officer

ORIGO COMMODITIES INDIA PVT. LTD•  June 2019 - November 2020

Carried out all duties as MIS officer. Collating data from the cluster MIS and maintain master database. Auditing the data to provide the accurate data to management. Created database reports for management evaluation. Generate timely and accurate reports for analysis. Handling the back-end operations works. MIS reporting by using MS Excel at Operational level. Preparation of various MIS reports. Preparing MIS on Daily / Weekly & monthly Basis. Created Macros with help VBA editing to automate daily activity process of Excel. Generating & maintaining day to day MIS Data and updating the management. Implement and analysis data to create daily, weekly, monthly, and quarterly reports. Supported MIS manager with technical and managerial functions. Maintained and supported servers and workstations as per MIS manager’s direction. Sharing Daily track of Capacity of Region Wise, Cluster Wise and Warehouse Wise to Upper Management like CEO and Managing Directors of company. Sharing Current Stock declaration value on Weekly basis with Management and Finance Head to insure the actual stock value of warehouse. 1 Preparing monthly NFA on behalf month end stocks and sharing it Insurance company to prevent any kind of loss due to change in sum insured value Preparing monthly stock position of warehouse to predict about SLS and SGS. Preparing yearly reports to track performance of Warehouses, Clusters and Regions. Helping Cluster MIS in any kind of challenge related to reports format and system. Created Google Forms to capture real time transaction records of stocks in warehouses along with Soft Copy of CAD and CDD documents.

ASSOCIATE CUSTOMER SUPPORT (BACKEND EXECUTIVE)

Tech Mahindra •  March 2016 - March 2018

Handling the back end operations works. Validating Customer Application Form with their documents and SCP of Globe Telecom. Encoding data in web software of the Client and generating their plans along with add on services with 100% accuracy target. Communicating the sales team about Rejection or Approval of application by email. Updating the data in Google Sheet which can further used to calculate SLA, productivity, Quality Analysis and WFM (Work Force Management). Preparing the reports of work done in excel and sharing with Team Leader on EOD