Summary
Overview
Work History
Education
Skills
Websites
Languages
Personal Information
Technical Profile
Timeline
Generic
Ranjit Kumar Das

Ranjit Kumar Das

Bangalore

Summary

With 15+ years of professional experience, I offer a wealth of expertise, including 8 years of hands-on experience in Network Performance and Feature Testing, and over 7 years in Automation, data engineering, and data analysis. Current responsibilities as a Project Analyst include leading the automation of web and Windows applications within DevOps environment while also contributing to data pipeline design, ETL workflows, and large-scale data analysis. My skill set includes extensive experience with automation tools, particularly Python, and database query tools such as MySQL, Click House, PostgreSQL, and Presto. Holding a bachelor’s degree in computer applications, I am well-versed in the technical aspects of testing and adept at adapting to new challenges. My enthusiasm for my work is matched by my readiness to tackle and excel in dynamic professional environments.

Overview

16
16
years of professional experience

Work History

Data Engineer and Technology Lead

Nokia India Pvt Ltd
Bangalore
01.2019 - Current
  • Implemented new changes and features in existing deployed Python code based on customer inputs.
  • Developed and optimized Rule-Based SQL queries for optimization recommendations, tailored to customers such as TMO, BELL, CLARO, and TIM.
  • Enhanced and maintained a deployed tool, adding new features as per customer requirements.
  • Utilized Python, SQL, JavaScript, and CSS to deliver high-quality solutions and improvements.
  • Created and optimized stored procedures, fact/dimension tables, and materialized views for reporting and analysis.
  • Collaborated with customers to understand their needs and ensure the software met their expectations.
  • Contributed to the automation team by continuously improving the tool’s functionality and performance.
  • Handle Extract, Transform, Load (ETL) operations such as Workflow Manager, Workflow Monitor for CM Data and site database for all Customers.
  • Handling the Automation of Network SCF creation for New Integrated sites using Customer Rulebooks.
  • Led the migration of SQL-based ETL processes, stored procedures, and database objects from Amazon to NESC Cloud environment; ensured schema compatibility, optimized query performance, and validated data integrity post-migration.

Technical Lead

Nokia India Pvt. Ltd
Bangalore
03.2011 - 12.2018
  • Analysis of new features and implementing on FIT cluster for trial results.
  • Testing of new software versions and features in both LAB and live network.
  • Testing and analysis of RLF issues.
  • Testing for IFLB and AMLE settings.
  • Analyzing layer 3 for LTE, VoLTE. UL/DL and CSFB devices and to find out reasons for various events like VoLTE drop/ failure, RRC drop/failure and CSFB failure/drop.
  • Directly interfacing with the FO to report KPI results and status of the optimization activities measuring the parameters SINR, RSRP, RSRQ.
  • Ensuring KPIs to be met RSRP, RSRP statistics, DL/UL throughput, Latency.
  • Troubleshooting the problem areas and providing recommendation for the systems performance enhancements based on drive test.
  • Schedule Single site verifications & cluster drive tests using data collection tool in the region and Post process & analyze the logs using EDAT.
  • Bi-weekly Golden parameter discrepancy audit and clearance.
  • Maintaining zero TAC Islands by regular audits and corrections.
  • Driving various hardware related issues like DL BLER, Rx Path Imbalance, VSWR, DU Optic losses, GTP Losses with the field team.

Sr. Engineer

Alcatel Lucent India Pvt Ltd(Nokia India Pvt Ltd)
Bangalore
03.2009 - 01.2011
  • Collecting and analyzing network logs for new feature trials in 5G and LTE(4G).
  • Recommendations of parameters for improving end consumer experience based on log analysis.
  • To analyze Nokia Network Performance Reports and accordingly identifying and implementing pre-post maintenance task.
  • Performing Drive test along the specified route (provided by operators) to check the Mobile under Test behavior for Network related Test Cases Attach to the live network, Throughput KPIs, Different type of Cell Reselections, Handovers, RRC state transitions.
  • Regular traffic analysis of the network and issue plan for hardware additions & deletions i.e. 1800 2G TRX addition as part of capacity optimization to provide congestion free network.
  • Actively involved in implementation of ALU specific features such as IMCRA step 2, IMCTA, Dual cell feature, pure load balancing, 2ms TTI, URA-PCH, and Fast dormancy and direct transition features, UA8.0 to LR13.1W upgrade and KPI comparison.
  • Proposed CEM addition based on board utilization and CEM blocking.
  • Low level analysis using Call trace (CTg, CTn etc.) to find resolution for Call Fail/Drop and missing neighbors across the network.
  • Analyzed log files using Actix analyzer and extracting the failure, drop, pilot pollution reasons etc. / Layer3 tracing & analysis of the log files.
  • Missing neighbor addition 3G-3G/3G-2G.

Education

Computer Science And Engineering - Computer Engineering

DRIEMS
Cuttack, Orissa
08.2008

10+2 - High School Administration

Central Academy C.B.S.E
Surda, Ghatsila
06.2002

Skills

  • AWS (S3)
  • Microsoft Azure (Azure Blob Storage)
  • Data Lake
  • Data Factory
  • Apache Nifi
  • Prefect
  • Apache Airflow
  • SQL
  • ORACLE SQL
  • Python
  • GitHub
  • SQL Server Management Studio
  • Clickhouse
  • Postgres
  • Presto DB
  • Docker
  • Nokia Kubernetes service(NKS)
  • Octant
  • Telecom
  • Data Warehousing Architecture
  • Data Validation and Quality Analysis
  • ETL Best Practices
  • Automation
  • Network Performance and Feature Testing

Languages

  • English
  • Hindi
  • Bengali

Personal Information

Title: Data Engineer and Technology Lead

Technical Profile

AWS (S3), Microsoft Azure (Azure Blob Storage, Data Lake), Data Factory, Apache Nifi, Prefect, Apache Airflow, Apache Nifi, SQL, ORACLE SQL, Python, GitHub, SQL Server Management Studio, Clickhouse, Postgres, Presto DB, Docker, Nokia Kubernetes service (NKS), Octant, Telecom

Timeline

Data Engineer and Technology Lead

Nokia India Pvt Ltd
01.2019 - Current

Technical Lead

Nokia India Pvt. Ltd
03.2011 - 12.2018

Sr. Engineer

Alcatel Lucent India Pvt Ltd(Nokia India Pvt Ltd)
03.2009 - 01.2011

Computer Science And Engineering - Computer Engineering

DRIEMS

10+2 - High School Administration

Central Academy C.B.S.E

Similar Profiles

CREATE PROFILE
Ranjit Kumar Das