Vybhav R

Experience

• 

  L&T Construction Equipment

  Feb 2014 - May 2014

  Intern

  Carried out a project for the IT department of L & T Construction Equipment called 'Calibration Management System'

• 

  Apex Decisions

  Jul 2014 - Dec 2015

  Data Analyst

   Predictive Data Modelling• Using SQL and Excel to extract transform and load data from various sources • Analysing and interpret raw data, analysing results using statistical techniques and drawing conclusions to develop recommendations• Create data models which follows Predictive Modelling approach with Clustering and Segmentation techniques for US clients (Tool based and Manual)• Preparing power point presentations for client meetings• Responsible for monitoring performance and quality control plans to identify improvements• Responsible for documentation of processes Time Series Forecasting• Preparing timely monthly and quarterly time series forecasting reports for clients (Using Excel, VBA, Pivot tables and charts, SQL etc.)• Worked on Projects called ‘Financial Projection’ , ‘Markdown Optimization’ and ‘Data Replenishment’• Develop stored procedures, Views and triggers to assist creating reports• Monitor server databases and take timely backup and carry out timely routines Show less

• 

  Knoema IT Solutions

  Dec 2015 - May 2017

  Data Analyst

  • Acquire data from primary and secondary sources and maintain datasets, identify analyse and interpret trends or patterns in complex datasets by following ETL (Extract, Transform, Load) process and perform data analysis• Data manipulation and cleansing (SQL, advanced Excel)• Perform quality check and correctness of data by performing data validation (Excel)• Create and deploy Data Representing maps (Geojson and SVG)

• 

  WNS

  May 2017 - May 2021

  Assistant Manager

  • Responsible for creating and quality checking ad-hoc campaigns for different channels like Email,mobile channel or direct mail as per the business requirements• Involved in development of a major campaign which is a customerexperience sharing campaign, which helped improve business and improve customer base for the Loyalty Management program.• Worked Onshore in London on campaign execution and delivery of data for 3 months • Worked Onshore in London on Migration of data and campaigns to a new environment • Received client appreciation for the work done during my business visit in London • Worked on lots of survey based campaigns to help understand the customer and improve relations with the customer• Worked on selecting qualified customers and issuing points to customers based on their campaign response• Worked on many campaign automations to ensure delivery of campaign data to onshore team without manual intervention• Received client appreciations multiple times for the dedication and effort put in to deliver quality campaigns• Working for one of the largest Hollywood Studio to improve sales accuracy of DVD and Blu-ray products across US and Canada• Perform Regional Segmentation and quality analysis using Excel and R on new movie DVD and Blu-ray releases for different US and Canada retailers• Derive meaningful insights from analysis and perform Allocations• Measure Data Model accuracy using MAPE technique and provide ideas on process improvement Show less

• 

  Epsilon

  May 2021 - now

  • Lead Business Systems Analyst

    Oct 2023 - now

  • Senior Business Systems Analyst

    May 2021 - now