Experience

• 

  Vmt systems india private limited

  Feb 2010 - Feb 2011

  Data analyst

  • By using Advanced excel in 2007• Preparing Customer records statement in excel • Preparing Pivot table, charts,reports in excel• Responsible for daily, weekly and monthly Status reports.• Responsible for preparing in dash boards reports.• Preparing order statement & preparing delivery statement• Preparing Billing/payment statement• Delivery Issue Statement — preparing Damaged Issue, late Issue statement, Missing statement and Duplicate Issue statement. • Internal Quality Auditing Show less

• 

  Aegis global service limited

  Sept 2011 - Jan 2012

  Data analyst

  • Merging duplicates, updating with current information into CRM.• Work with master data management (MDM) and UCM Remediation tasks to be performed as per the project, UCM Database maintenance ( Link & Update, Create New & In Question)• Identity Duplicates Accounts Analysis on Survivor Victim and Account Merges in EBS/SFDC

• 

  Concentrix

  Jan 2012 - Feb 2015

  Data analyst

  Data Validations&Cleansing:• Data cleansing, manipulation & validation, Generating pivot tables, charts and Creating new variables using excel functions• Data Cleansing- Standardizing Names & Address and pushing the data back upstream• Data Alignment- Identifying the Correct address information using different source systemData Mappings:• Locations description and customers info can be mapped using lookup functions from other sheets and quality check for missing values using Pivot tables • Writing various types of queries through SQL to extract the required data from databases• Data validations can be done using SUMIF, COUNTIF or IF functions to ensure the integrity of the weekly data and append it to the master datasetDesigning dashboards:• Involved in designing Excel dashboard for the reports and Creating charts and Pivot reports• Extract data from SFDC and preparing reports • preparing dash boards daily ,Weekly, Monthly and Quarterly Power Point Presentation:• Power point Presentations The review of entire analysis can be presented with the insights using power point presentation on monthly basis for high end clients Show less

• 

  Capgemini

  Mar 2015 - Jan 2016

  Sr.consultant
• 

  Ntt ltd.

  Feb 2016 - May 2023

  Power bi developer
• 

  Aquity solutions india

  May 2023 - now

  Power bi developer