Deepesh Asthana

Experience

• 

  Tac House

  May 2017 - Jun 2017

  Marketing Intern

  Study on Training & Development of EmployeesDoing Research on training and development of Employees in organisations across different sectors by using primary and secondary data.• Contacting with HR Managers of Companies to gather necessary information for the projects.• Analyse the data using SPSS and MS Excel and determine the findings and write it down in project reports.

• 

  EPCH India

  May 2018 - Aug 2021

  Junior Assistant

  • Doing Market Research and making Reports to measure Export Potential in different countries for different products based on Hs Codes Using primary and Secondary Data to help exporters increase their business.• Organising India’s Handicrafts Exporters’ participation in trade shows abroad which lead them to increase their business and enhancing country’s exports.• Managing an exhibition hall in India’s largest Handicrafts Trade Fair IHGF, Delhi fair which is organised Bi-annually to facilitate trade. • Organising Skill Development programmes for Handicrafts Artisans to shape their art in a better way and make their products competitive in National/International Markets.• Managing and facilitating the activities of EPCH Saharanpur (Regional) Office. Show less

• 

  WNS

  Jan 2022 - now

  Senior Associate

  • Analyzing and deriving actionable insights from diverse datasets, including Veeva CRM data, sales data, and prescription data.• Creating SQL queries to extract and manipulate data from SQL Server, ensuring accuracy and efficiency in data retrieval.• Spearheading the automation of existing reports using SQL queries and Power BI, resulting in a significant reduction in manual processing time for multiple clients.• Developing dynamic and interactive Power BI dashboards to visualize call activity trends, encompassing total interactions, success rates, reach, and frequency, enabling sales teams to make data-driven decisions promptly.• Creating Validation Frameworks to ensure every report undergoes proper quality checks, ensuring data integrity and reliability, thereby fostering trust in the provided insights.• Addressing ad hoc requests promptly, delivering tailored reports and insights based on specific client needs, showcasing flexibility and adaptability in data analysis.• Collaborating closely with sales teams and stakeholders, understanding their requirements, and translating them into comprehensive reports and dashboards. Show less