Vikas Kumar

VIKAS KUMAR Email: vikas.hex@rediffmail.com Data Analyst – Supply chain Phone: - Address: H.no 113 Uttam Nagar New Delhi 110059, India To pursue a career which provides continuous learning & growth prospects, in a highly motivated environment involving good growth for the company and opportunity to learn new skills & upgrade existing ones. PROFESSIONAL ABRIDGEMENT • • • • • • • • • • Working for Vision Spring Pvt Ltd, Noida, India – Supply chain Dept. Worked for Jindal Intellicom Ltd, Delhi, India – Quality Dept. Worked for Renovision Automation Services Pvt Ltd. (RASPL), Delhi, India – Service & Projects Dept. 5+ Years of exp - in MIS Reporting and Automation, Sales & Production analysis, Data Management. Expert in Performance review data, Goal sheet, Score card, WFM (AHT, Forecast, Time management). Expert in Data Analysis, Automation and Dashboard, BI, KPI Trend, Google Sheet, Smart sheet. Expert in logistics, pre-post shipment documentation, dispatch, package address labels of courier. Expert level skill in Advance Excel, Formulas, Look-up functions, count-if & Sum-if, Pivot, Formatting, Chart, Graph, Index, Match, Data Validation, slicer, Len, Right, left, Mid, conditional formatting, Presentation prepare, Macros, Automated code, Mail-merge, Dynamic formulas and create hyperlink. Expert in Inventory Management & Optimization. Expert in Salesforce and SAP-ERP. AREAS OF EXPERTISE • • • • • • • • • • • • • • Designed automated report to measure performance ranking and trend analysis of team. Created VBA macros used to simplify tasks or easy way to work for management. Developed Dashboard to monitored performance of target, achievement, any highlights for respective department. Designed and automated business intelligence dashboard and reports. Designed regular and ad-hoc reports for development of campaign data. Preparation of SOP's & Flow-chart for department to streamline the process. Created training manuals and conducted training sessions to train the whole teams and inform management on new report functionality. Data integrations of products and upgrades that Involves in-depth analysis on a regular basis. Managing movement and storage of raw materials, work-in-progress inventory, and finished goods from point of origin to point of consumption. Work closely to create all targeting/Projects/fulfillment data as required. Monitored implementation of MIS processes and evaluated their effectiveness. Well versed in KPI and On-time delivery and followed TAT, managed multiple projects independently. Well versed in data management reporting with good analytical skills. PROFESSIONAL EXPERIENCE VisionSpring Pvt Ltd, Noida, India (June’ 2017– till date): VisionSpring is a social entrepreneurship continuously working with the goal of reaching and providing affordable, quality glasses to the 2.5 billion people worldwide who need them. Role in the Organization: Worked in supply chain department as Data Analyst – Supply Chain . • • • • • • • • • • • • • • • • • Management Information System (MIS) support for all cross-function teams. Making reports of sales (In and out) in SAP and run module PR, ITR, Bills of vendor. Designed dashboard, automation reports, required as per client & HOD. Manage courier documents to prepare package address labels, invoices and other required documentation correctly. Coordination with partnership team, Eye camp team, sales team and collecting all data of eye camp and then tracking all project and dispatch timely. Prepared daily RX data sheet for higher management on daily basis. Prepared presentation of respectively department Prepared SOP’s of Lab production process also make flow-chart. Forecasting inventory all projects wise making report On Daily Basis. Maintain data of Incentive plan for team member department wise. Prepared dashboard to collecting and compiling all project order and giving fulfillment which help us to know projects status. Daily/ Weekly/ Monthly Inventory, Dispatch, Team performance reports to management. Prepared variance reports such as Forecast vs. Actual delivered. Monitored inventory level requirements diligently and worked to ensure a minimum stock level for all materials are maintained. Performed Trend Analysis of Data and Automation of reports project wise. Coordinate with Sales team for sales data, Collecting & Maintaining Sale Data from External and internally To provide Ad-hoc report and new tracking dispatch reports by using various tools i.e. VBA, Macro, MS Excel with accuracy and timeliness for Projects. SAP-ERP work & Responsibility: • • • • • • Generate Inventory transfer request(ITR) Run production module for multiple entity. Generate Stock Keeping Unit (SKU) code. Stock movement entity wise. Generate Purchase order(PO) in multiple entity. Collecting data & Prepared sales MIS report. Salesforce work & Responsibility: • • • • • Extract report, managing project wise. Escalation handling and resolving. Create dashboard and KPI. Data analysis and prepared MIS. Data import & check status on daily basis. Jindal Intellicom Limited, Delhi, India (November 2015 – June 2017): Jindal intellicom is leading Information technology and Business Process Outsourcing company providing cutting edge costeffective solutions across the domains of Software Development, Data Analytics and BPO/ KPO. Role in the Organization: Worked in Quality department as MIS Executive – Quality. • • Handling QA Team and make performance report of Quality Team. Prepared QA Team Goal Sheet to on Daily Basis. • • • • • • • • Maintain and Update Feedback Tracker of Quality Team. Prepared data of agent performance to improve quality score. Prepared TOP & Bottom agent performance report on daily basis on process wise. All process prepared data categories report and calibration report process wise. Prepared data of Quality & QA team review on Fortnightly or Monthly Basis. Maintain data of attendance, Cap Tracker, Complain Log, of quality team on daily basis. Design dashboard of agent performance, process improvement, department quality scoring for higher management. Prepared AHT report to improve agent performance. Renovision Automation Services Pvt Ltd, Delhi, India (August 2014 – November 2015): RASPL are top notch IT service provider. RASPL largest service partner is India’s IT Giant-WIPRO Infotech Limited. RASPL service Mobility & computing, Manpower outsourcing, Data Center solutions, Managed printing Solution, Project management and compressive maintenance services. Role in the Organization: Worked in Project management department as Project coordinator - Projects • • • • • • • • • • Handling resource for projects on 21 district location in Haryana . Preparing MIS reporting by using MS Excel on daily basis. Preparing attendance and report on daily basis location wise. Prepared salary sheet and incentive data end of the month of all resource’s locations wise. Maintained data of infrastructure, systems, which is using in locations. Meeting with DETC & ETO officers for signoff and data provide on all locations. Planned strategy to complete data with TL and team member on daily basis. Prepared data of resource productivity on daily basis. Follow-up with TL to complete data as per location wise. Data collect from CRM check and validate. Education • • • Graduation in Bachelor of computer applications from Ignou University. Intermediate – from CBSE Board in New Delhi. Matriculation – from CBSE Board in New Delhi. Professional Training • • Successfully complete 3 months course of MS Office and computer applications. Successfully complete 3 months course of Tally-ERP accounting applications. Achievement • • • Dexterously participated in Game and quiz and winning medal and Certificate from Visionspring Pvt ltd. Successfully conducted Session of excel classes for team in Jindal Intellicom Limited and giving award. Successfully implemented training programs of SAP, Production module, Sales and distribution. Personal Profile Father Name Languages Known Nationality Marital Status Date of Birth Current Address Jeet Bahadur English & Hindi Indian Married 01st August 1995 H.no-113 Uttam Nagar New Delhi