anindita sen

Data Specialist

Iron Mountain

2022 - 2024

Dubai, ARE

• Designed and implemented data cleaning protocols using power query to identify and rectify inconsistencies and errors in asset databases, ensuring data accuracy for reporting and auditing purposes.
• Establishing best data cleaning practices resulted in a 35% error reduction and a more efficient data processing workflow. Implementing an automation solution for data extraction, transformation, and loading processes helped reduce manual errors and improve business processes.
• Analyzed the sources of data, developed data flows, and built logical and physical models to support analytical models and data visualization models as per project requirements.
• Developed dashboards and created KPIs to track the quality of fixed assets of Dubai Municipality, Emirates School Establishments, and Ministry of Foreign Affairs.
• Collaborating cross-functionally to plan and execute asset tagging and enhance asset quality to extend the lifespan of critical assets driving better data maintenance strategies.

Systems Analyst

Tata Consultancy Services

2020 - 2022

Bengaluru, IN

• Conducted market campaign analytics for an e-commerce retailer to understand different KPIs on customers’ profiles, the effectiveness of campaign advertisement, web performance, and product affinity. Developed KPIs, charts, and matrices on sales, advertisement, website, and marketing performance for a market research client using Power BI, and DAX.
• Worked with an e-commerce retail client with a vision to find correlations between sales and success behind a specific category, product, or various components. The deep dive was done using clustering and key performance analysis, including categories, gender-specific products, merchants/sellers, product origins, etc. Clustering techniques were achieved using different Python libraries (Pandas, Numpy, Scikit-Learn) and Reports implementation was done using Power BI.
• Researched and strategized data collection process from different sources to optimize data extraction, cleansing, and structuring by implementing Power Query Automation using M formula for Transformation Cockpit, COVID Vaccination Dashboards, etc. which helped the automation of data collation and transformation and reduced manual efforts to zero.

Assistant Systems Analyst

Tata Consultancy Services

2018 - 2020

Bangalore, India

• Developed end-to-end analytical tools with the help of Python Flask (web development framework) to visualize data insights per business needs. Complex SQL queries were pushed through the tools to acquire the data from the database to minimize the transactional time between the front end (Angularjs) and the back end (Python).
• Predicted employee churn of a particular tower in the existing company, considering employees’ behavioral and organizational information. Different Python libraries (Pandas, Numpy, Scikit-Learn, SciPy, Py-Torch, Matplotlib) have been used to develop the churn classification algorithm.
• Enabled Chatbot using Dialogflow to assist Ultimatix Datahub-related FAQs. It also assisted with alerts on IT support requests, leave-related FAQs, and change alerts on employee count.
• Established a tool that showcased spending against various suppliers, categories, plants, and geographical locations and calculated the maverick spend against different rules. Assessed tail spends and implemented forecasting on spend using the ARIMA method. Evaluated suppliers, optimized the lead time of vendors.
• Optimized salesforce performance for Telecom & Health Care industries.

Intern at Analytics and Insights

Tata Consultancy Services

2017 - 2018

Bangalore, India

Projects on predictive analysis like Handwritten character recognition, Employee Churn Analysis for the HR department, time-series forecasting, etc.