Abhishek Sharma

Lead Engineer

HCL Technologies•  April 2022 - Present

Working as Data Management Engineer and Developed ETL pipelines to fetch clients data from sources like SharePoint folder , SQL server, Microsoft Azure & Winchill Rest API and created Power Bi Dashboards. Automated Reports ( Extract data, Clean buggy data and fixing errors and optimising query ) for giving insights of client's data using python. Analysed 2M+ datapoints that has been extracted from Windchill Server and identified data variances and managed difference using Power Bi. Developed Python script to automate business process by sending HTTP request using GET/POST/PUT method with REST API to collect data from different web application in XML/JSON and update the information in web application.

Senior Engineer

Jindal Aluminium Ltd.•  June 2021 - April 2022

Analysed reports of Cad data, supplier list and ECR report from SAP HANA to understand business requirement. Developed weekly visual reports, KPI scorecards, and dashboards to get overall project completion stage.

Contract Engineer

BEL•  August 2018 - June 2021

Managed Product data and Product Life cycle Data for MILCOM SBU primarily Defence grade Laptops and servers using SAP-PLM and implemented Power BI for Automated Reports. Used Numpy and Matpoltlib in Python to analyse different Heat tube and their efficiency and help stakeholders to select better products. Built automated ETL pipelines using complex SQL Queries and procedures on SnowFlake which connected to Azure. Developed Python script to automate business process by sending HTTP request using GET method in API to collect data from different web application in XML/JSON. Identified, analyzed, and interpreted Product quality patterns thats helpful for the identification of SIX Sigma process compliance using python. Compiled and Visualize data from SAP - PLM reports to get insights Overall Project status and comparing timeline in different product status like BOM, ECR / ECO process and documenting QTP and vendor management.