Devika Chatterjee

Data Analyst
Kolkata, IN.

About

Highly analytical Data Analyst with a proven track record of leveraging machine learning and advanced data techniques to extract actionable insights and drive strategic business decisions. Expert in data manipulation, visualization, and predictive modeling, adept at translating complex findings into clear, impactful recommendations for stakeholders. Successfully reduced attrition and optimized reporting processes, demonstrating a strong ability to enhance operational efficiency and achieve measurable business outcomes.

Work

Bharti Airtel
|

Data Analyst

Gurgaon, Haryana, India

Summary

Spearheaded data analysis and predictive modeling initiatives for HR, significantly reducing attrition and enhancing operational efficiency through data-driven insights and automated reporting.

Highlights

Achieved a 4% reduction in women's attrition within 4 months by developing and integrating machine learning models into Power BI dashboards, enabling actionable insights for targeted interventions.

Enhanced data quality and integration by 60% using Python, cleaning, and transforming over 20,000 records from disparate sources into a unified dataset, significantly improving reporting accuracy and streamlining BAU processes.

Reduced monthly manual reporting efforts by 50% through the automation of HR KPIs, including Turnover Rate, Diversity, Headcount, and Engagement Score, across functions using Power BI.

Executed rigorous data cleaning and preprocessing with Python libraries and SQL, ensuring data accuracy and integrity across workflows and significantly reducing data-related errors in downstream analytics.

Conducted comprehensive exploratory data analysis (EDA) leveraging statistical techniques with Python and SQL to identify critical trends, patterns, and outliers within large datasets, informing strategic decisions.

Capgemini
|

Senior Software Engineer

Pune, Maharashtra, India

Summary

Led automation testing initiatives for Open Banking at Bank of Ireland, improving product quality and testing efficiency through advanced API and UI automation frameworks.

Highlights

Directed automation testing for Open Banking initiatives using Postman for API and Selenium for UI automation, achieving a 50% reduction in manual testing efforts.

Resolved critical API defects, elevating product quality by 15%, and managed comprehensive defect tracking via JIRA, contributing to functional and non-functional testing, including CI/CD integration.

Developed Tableau dashboards for data visualization and performance monitoring, providing critical insights for quality assurance and defect resolution.

Tech Mahindra
|

Software Engineer

Pune, Maharashtra, India

Summary

Enhanced software testing efficiency and product reliability for telecom applications of AT&T through advanced automation frameworks and streamlined defect management.

Highlights

Improved testing efficiency by 25% by implementing a robust testing framework with Selenium, Java, and JUnit for functional, regression, smoke, and sanity testing for AT&T telecom applications.

Contributed to a 15% reduction in production defects through proactive detection and automation, significantly enhancing product reliability and customer satisfaction.

Streamlined test data management and optimized bug reporting and tracking processes using JIRA, improving team productivity and issue resolution timelines.

Education

Boston Institute of Analytics
New Delhi, Delhi, India

Certification

Machine Learning and AI

Techtip24
Virtual, N/A, N/A

Certification course

Business Analytics

Praxis Business School
Kolkata, West Bengal, India

PGP

Data Science

Sur Tech Institute of Technology and Management
Kolkata, West Bengal, India

B.Tech

Computer Science and Engineering

Certificates

Accenture North America Virtual Internship

Issued By

Forage

PwC Switzerland Virtual Internship

Issued By

Forage

Goldman Sachs Virtual Internship

Issued By

Forage

Skills

Data Visualization Tools

Power BI (DAX), Tableau, Advanced Excel (Lookups, Pivot charts), KPI Reporting.

Technical Skills

Pandas, Matplotlib, Spark, Automation, ETL, Statistical Analysis, Hypothesis Testing, Predictive Modelling, Machine Learning, Python, Java, JUnit, Selenium, Postman.

Database Technologies

Oracle, MySQL, Advanced SQL, Data Modeling, Data Warehousing.

Project Management

Jira, Git, Trello, Agile Methodologies (Scrum), Cross-functional Collaboration, CI/CD Pipeline Integration.

Projects

Credit Risk Modelling

Summary

Developed a comprehensive Credit Risk Modeling solution by performing extensive feature engineering on variables such as Credit_Score, CC_utilization, tradeline history, and delinquency history.

Used Car Prize Prediction

Summary

Conducted extensive Exploratory Data Analysis (EDA) to uncover relationships between Mileage, Engine Volume, Car Year, and Price.