Sandip Singh
Data Analyst at ADDICOR TECHNOLOGIES PRIVATED LIMITED- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Experience
-
ADDICOR TECHNOLOGIES PRIVATED LIMITED
-
India
-
IT Services and IT Consulting
-
1 - 100 Employee
-
Data Analyst
-
Sep 2020 - Present
DATA ANALYST• Build a prediction model using python libraries and with the help of Data Science team, created Machine learning algorithms to predict ETA which is 30% more accurate than commercial models and resulted in $2.5M cost savings by improved planning.• Identify the opportunity to reduce manual effort by 75%, using API’s from an external partner and executed pipelining on it to automate workflow leading to better quality data.• Work closely with leadership to perform market sizing and supplier segmentation analysis for insurance business and single out the right set of suppliers to target, thereby saving hundreds of hours of manual work of sales team.DATA ANALYST CO OP• Collaborated with cross-functional stakeholders to stand up a value proposition for a new business by performing analytics and sharing the resulting efficiencies in Tableau stories which helped us with 3 new suppliers in one quarter.• Generated reporting infrastructure using Advanced Excel (Macros, Pivots, VLookUp and Visualizations) to support logistics operations while providing visibility into health of business.• Defined and created centralized Data Mart in SQL and sustainable reporting dashboard by embedding refreshable queries in Excel, resulting in 90% less manual effort in daily operational tasks for Inventory Management teams.
-
-
-
Rittal India
-
India
-
Industrial Machinery Manufacturing
-
400 - 500 Employee
-
Junior Data Analyst
-
Apr 2019 - Sep 2020
• Mentored a team of 3 to extract data from multiple databases, transform and load them to produce essential informative data, convert to XML and send them to the front end for viewing in the Sitecore UI.• Slashed data scraping time by 40% by creating a self-acting process in python, to read the SQL files from the git and run all queries in staging and production environment.• Developed tools to extract log files from various server which led to 20% reduction in UAT time for testing team.
-
-
Education
-
Chatrapati Sahuji Maharaj Kanpur University, Kanpur
Bachelor of Technology - BTech