Vibhesh Kumar

Vibhesh kumar

bookmark on deepenrich
location of Vibhesh KumarSouth Delhi, Delhi, India
Followers of Vibhesh Kumar73 followers
  • Timeline

  • About me

    Unit Manager

  • Education

    • Indira gandhi national open university

      2008 -
      Master of computer applications (mca)

      • MCA From IGNOU• B. Sc(G) from Delhi University• Diploma in Advance Software Technology from CMC

  • Experience

    • Wunderman

      Jul 2009 - Jan 2010
      Database analyst

      Responsibility : - • Extracting of Data as per Request by using SQL or Tool(EMMA) • Presently working for Microsoft in MSC (Marketing Service Centre) Team.• Extensively involved in running campaigns for “Global Marketing Operations” of Microsoft (PRAGUE AND FRANCE). • Responsible to extract data from different Microsoft Exchange Servers and upload them into CRM.• Writing queries for different subsidiaries according to their business rules and specifications. • Responsible to work with data management operations team to organize MSI and MSO database. • Worked on scripts for data cleansing to make the data hygienic. • Creating Newsletters and Electronic Direct Mailers, uploading the worldwide data through data enrichment tool and generating the reports. • Pulling required information from the database by using SQL or by using assigned tool. Cleaning and Filtering the information as per request. • Manipulating huge data by using Import/Export function, SQL Server and Access• Creating User Defined Function and Macro in excel to automate the task.• Making Macro to automate the repetitive task. Show less

    • Nokia siemens networks

      Jan 2010 - Apr 2013
      Performance management engineer

      Tools and Environment: - Vb.Net, Oracle Scripting, VBA, MYSQL (Database) and Excel ReportingResponsibility : - • Creating Oracle Scripts to fetch the raw data for the reporting.• Creating stored procedure to Customized the Raw data as per requirement.• Having good command over the SQL, Store procedure, and functions.• Working as Performance Management Engineer (Performance Management is a team of Reporting and first level analysis of mobile network)• Working in TTSL(Tata Tele Services Ltd) Project. • To Automate the Report by using VB.Net as Front-End and MySQL as Back-End.• Creating Oracle Scripts to fetch the data directly from Main Oracle Database(OSS)• Creating VBA (Macro) to Automate Excel Report by taking input data from Excel Raw file, text file etc• Data Analysis using advance Excel and other source. Show less

    • Times internet limited

      May 2013 - Oct 2013
      Production support analyst

      Working as Lead Automation analyst and responsible for automating all the manual task of Production Team (Responsible for uploading and updating backend data of Indiatimes Shopping Site) . Technology used for automation is Excel, VBA MACRO, MYSql, MS Access

    • Metlife

      Jun 2018 - now

      - Main responsibility to provide the best solutions to the customer.- Implementation of end to end consulting projects based on Excel, VBA, Accesss, Macro, SQL etc- Data analysis and reconciliation of data.- Assessment of IT service cost for planning, budgeting and forecasting using Apptio Business Intelligence tool- Automation of the process of calculating the planning budget of the company and comparative analysis of the budget in order to figure out the changes in the services- Use of Proc Sql to create data set summary, perform queries, reconcile databases on SAS- SAS Macros and automation of analytical processes such as appending datasets to create a master dataset, segregating variables in to numeric and character variables- Automation of manual reports using VBA and SQL so as to improve manhour requirements- Preparation of monthly Service Cost Metrics report using excel which provides details of the expenses of the global services- Preparation and analysis of the Top Application report using excel for the topmost applications hosted globally Show less

      • Unit Manager

        Sept 2021 - now
      • Assistant Manager

        Jun 2018 - Aug 2021
  • Licenses & Certifications

    • Base sas certification

      Pearson vue
      Dec 2014
    • Advanced sas programming concept

      Pearson vue
      Dec 2015
  • Honors & Awards

    • Awarded to Vibhesh Kumar
      GEM Award for excellent performance Metlife GOSC Jul 2014
    • Awarded to Vibhesh Kumar
      Champion Award for Excellent Performance Keane Worldzen Oct 2007