MySQL Workbench
Ranjan Das
Kolkata, India
Summary
Results-driven software engineer with over three years of experience specializing in data analysis, machine learning, and full-stack development. Proven track record of delivering innovative solutions for diverse clients, demonstrating a strong ability to tackle complex challenges in dynamic environments. Committed to continuous learning and skill enhancement, with a focus on staying at the forefront of technological advancements. Eager to leverage coding and analytical expertise to drive growth and innovation within an organization, contributing to impactful projects that shape the future.
Overview
4
4
years of professional experience
1
1
Certificate
Work History
System Engineer
Tata Consultancy Services
12.2023 - Current
- Currently working on Mailer services for generation and mailers of TCS Payslips as part of the Digicore Migration program, which is conducted for the tech-stack migration from the oldest technologies using the outdated versions and packages of Java8, Hibernate SQL, Spring Tool Suite. This activity is committed as part of the compliance and security measures for the internal TCS projects.
- Worked on product development to integrate features for compensation letters and payroll-related screens for uploads, modifications, and removal of documents aligned with business requirements.
- Worked on features to improve Root Cause Analysis and collaborated in discussions with several support teams to enhance the delivery process and improve overall delivery timelines.
- Developed different interactive screens using HTML5, CSS3, and JavaScript for admin users to facilitate the process improvement of resolving any help desk or product-related tickets for faster turnaround time and improving user services and satisfaction index by at least 50 percent.
- Worked with Load Testing environments for the integration of the developed code base with concurrent users logging into the production environment to ensure defect-free, on-time incremental deliveries. Have played a crucial role in identifying root causes of pipeline failures during the use of CI/CD services through system integrity verifications and connectivity testing.
- Additionally, I have led a development team for standard security practices and awareness on developing secure code, and improved the overall delivery process by more than 0.6 times faster by applying Agile methodologies during the entire SDLC lifecycle.
Assistant System Engineer
Tata Consultancy Services
12.2021 - 12.2023
- Worked on a project, a payroll-related application based on Angular, where I played a crucial role in developing several UI screens at the front end. Later, I worked on the Back-End API services to create a fully managed product using Java, Spring Boot, and PL/SQL.
- Worked with CI/CD tools for the integration of the developed code base and product features with the current production environment to ensure on-time incremental defect-free deliveries.
- During project development, team productivity increased significantly by improving the short turnaround time for the required User Acceptance Testing of user stories.
- Worked on AIP integrations using Java and File Management Services to protect files with specified permissions during downloads by different role-based users.
Education
B.Tech - Electronics & Communication Engineering
Techno Main Salt Lake
07.2021
Skills
- BigQuery, Data Analysis, Machine Learning
- Programming Languages: Python, JS, Java
- CI/CD Operations: Jenkins
- Tools: Git, Angular, HTML5, CSS3
- Agile methodology expertise
- Database management: SQL, MySQL, PL/SQL
Accomplishments
- Achieved TCS Gems by completing 100% Accessibility Compliance - AODA for Canada Clients for the product within a short time span of development and delivery turnaround time with accuracy and efficiency.
- Become a Contextual Master at TCS to evolve and deliver innovative solutions, accessibility compliance, and process improvements
Timeline
System Engineer
Tata Consultancy Services
12.2023 - Current
Assistant System Engineer
Tata Consultancy Services
12.2021 - 12.2023
B.Tech - Electronics & Communication Engineering
Techno Main Salt Lake
Certification
- Machine Learning Training from IIT Bombay - 2 Months
Software
Jupyter Notebook
Google Cloud SQL
Google Colab
PyCharm
Anaconda IDE
Tableau
Projects
Brazil E-commerce Business Case Analysis(SQL Google BigQuery)
Aug 2025 - Present
Queried and processed 100k+ e-commerce records in SQL (BigQuery) to uncover customer behavior and order trends.
Pinpointed seasonal demand peaks and top regions, enabling 15% uplift in targeted marketing performance.
Built and presented a Tableau dashboard/report that optimized logistics, improving delivery efficiency by 20%.
Skills: SQL · Data Analysis · MySQL · Exploratory Data Analysis
Netflix Data Visualization using Python Libraries
Apr 2025 - Present
Examined Netflix content library with Python (Pandas, NumPy), revealing that 70% of content is movies.
Recommended expansion of TV shows and optimal release timing during Indian holidays, driving higher retention potential.
Visualized viewing trends with Matplotlib & Seaborn, enabling data-driven content strategy decisions.
Delivered audience engagement insights that informed programming and marketing strategies.
Skills: Data Visualization · Python (Programming Language) · Data Analysis · Seaborn · Pandas · NumPy · Matplotlib
INTERNSHIPS
Data Science and BA Intern
The Sparks Foundation
- Worked on prediction using Supervised, Unsupervised Learning, and Decision Tree Classifier for cluster classifications and demonstrations, and computed Exploratory Data Analysis (EDA) on Super Store Data to find insights.
Machine Learning Intern
Internship Studio
- Developed YouTube Adview Prediction model to predict the target variable adviews of any content after analyzing the correlations.
Languages
English
Bilingual or Proficient (C2)
Hindi
Bilingual or Proficient (C2)
Bengali
Bilingual or Proficient (C2)
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Quote
I have not failed. I’ve just found 10,000 ways that won’t work.
Thomas Edison
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Sreya BasuSreya Basu
Procare Analyst at Tata Steel(Tata Consultancy Services)Procare Analyst at Tata Steel(Tata Consultancy Services)
Arun VArun V
Program Manager at Tata consultancy services | Financial Ombudsman ServicesProgram Manager at Tata consultancy services | Financial Ombudsman Services
Naimish AgnihotriNaimish Agnihotri
Assistant Delivery Manager at Tata Consultancy Services, Global Shared ServicesAssistant Delivery Manager at Tata Consultancy Services, Global Shared Services
SWARNA PRAVA BISWALSWARNA PRAVA BISWAL
Service Analyst at TLC WorldwideService Analyst at TLC Worldwide