Himanshu Khasdev Email & Phone Number

Gurugram, Haryana, India

•Develop scripts using Python and SQL to transform data in a clear and understandable way, saving my team 18 hours per week.•Working on pharmaceutical data for incentive compensation, which involves goal and credit analysis, generation, and forecasting to maximize product sales.•Extract, Load and Transform data using Python and SQL from both a database and excel sheets within Power BI to analyze trends in sales, eCaps for different geography.•Build MS Excel templates to analyze data and use power query editor to automate reports for further analysis and representation to the clients.

Goa, India

•Data Pipelining for different dashboards and trackers to track sales and spends. •Analyzing marketing data for meaningful insights and optimize spends. •Accountable for data extraction from different sources like Shopify, Google Analytics, Clevertap etc in organization's format. •Cleaning data for analysis (EDA). •Developed crawlers to scrap data from different sources of our products, to check the status and ranking on different websites using python and selenium. •Build models and scripts to transform data in presentable manner using python and SQL. •Extract, Load and Transform data from both a database and Google Sheets within Power BI to examine trends in sales, orders, and ROI.

Bengaluru, Karnataka, India

•EDA and Visualization of Global Terrorism Dataset using Python librariesPandas, Numpy, Matplotlib and Seaborn to gain insights about terrorism hotspots and security questions.

Bhopal, Madhya Pradesh, India

-Accountable for handling client files and their respective deliveries.-Responsible for collecting and analyzing categorical and other data from websites.-Quality check of existing records to achieve accuracy of data with rules and guidelines.-Accountable for categorizing the enriched data based on categories mentioned in the taxonomy.-Worked on several reports i.e. Weekly & Factory Metrics, Daily Reports and forecasting metrics.

Bhopal, Madhya Pradesh, India

-Worked as an Jr. Data Analyst, I had performed enrichment task which includes data manipulation, data cleaning, adding valuable details, etc.-Research about product and other details using a variety of strategies and methods including simple web searches.-Enrich or modify data records with valuable product attributes to a very high degree of precision against pre-determined guidelines and rules.-Analyzing data on Microsoft Excel using Pivot Tables, VLOOKUP, HLOOKUP and other excel functions.

Indore, Madhya Pradesh, India

•Worked on Selenium and Beautiful soup using Python programming language to automate the downloading of ETF files from google and data bases and convert/save them in csv format.•Worked on SQL for collecting and uploading the data on databases.

Bhopal, Madhya Pradesh, India

Worked on Machine Learning tasks using supervised and unsupervised ML algorithms.

Hyderabad, Telangana, India

Worked on real time project named “Smart AI Assistant” and also implemented machine learning algorithms.