Nishant Kumar | Data & IT Professional

About Me

I am an IT and Data professional based in Uttar Pradesh, India. Currently working as a System Engineer at TCS, I specialize in statistical analysis, data cleaning, and system integration.

I am passionate about creating environments where diverse perspectives are valued and teamwork is fostered.

4+ Years Experience

2+ Global Clients

Education

Kurukshetra University

B.Tech in Computer Science

Aug 2015 - July 2019

CGPA: 8.0

Work History

System Engineer

Tata Consultancy Services • Apr 2021 - Present • Noida, UP

Designed and optimized PL/SQL queries, stored procedures, and functions for large-scale data processing, improving reporting performance.
Performed exploratory data analysis (EDA) on customer and operational datasets to uncover trends, outliers, and actionable insights for client stakeholders.
Collaborated with cross-functional teams to gather business requirements and develop automated data workflows that reduced manual reporting effort.
Led a data migration initiative, ensuring seamless transition of client data while maintaining data integrity, reducing post-migration issues.
Integrated data validation checks, audit logs, and integrity constraints into database systems to support compliance and governance.
Delivered real-time demos and walkthroughs for global clients, translating business needs into technical deliverables.
Executed end-to-end development lifecycle activities, from requirements gathering to deployment and support.
Conducted comprehensive SQL tuning using explain plans and trace files, resolving performance bottlenecks and enhancing overall system responsiveness.
Accomplished database performance tuning and optimization using AWR and ADDM reports.
Worked on a data migration project that required system configuration for client data management and transfer to improve infrastructure resilience.
Implemented indexing strategies and materialized views (mview) to accelerate data retrieval.
Worked closely with clients to comprehend their needs and assist them by offering efficient solutions.

Leadership & Collaboration

Effective Training & Supervision

Trained and supervised new employees, boosting team performance and ensuring project success through effective mentorship.

Team Collaboration

Proven ability to work well with others, fostering teamwork, and creating an inclusive environment where diverse perspectives are valued.

Featured Projects

View GitHub Profile

Personal Project

Nifty 50 Momentum Analyzer

Built a Real-Time Technical Analysis Engine using Python and yfinance. Ingests 2 years of data to calculate RSI and Volatility, delivering actionable trading signals via a dynamic Streamlit dashboard.

Python Pandas Streamlit yfinance

Personal Project

Indian Telecom Churn Prediction API

End-to-End Machine Learning System for the Indian Telecom market (Jio, Airtel, Vi, BSNL). Dockerized API that predicts subscriber churn probability for the upcoming month.

Machine Learning Docker API Python

2023 - Present

Lloyds Banking Group (UK)

Focused on data analysis, performance optimization, and batch development. Optimized database tuning for bulk data and developed modules per client requirements.

Python PL/SQL Data Tuning

2021 - 2023

China CITIC CNCBI

Handled Event-Driven Testing and Corporate Action Sanity Testing. Utilized Jenkins, ALM, and JIRA to streamline development and manage workflows.

SQL Java Jenkins

Technical Arsenal

Languages & DB

Python SQL PL/SQL PostgreSQL Basic Java

Data Science & ML

Pandas Numpy Scikit-Learn TensorFlow PyTorch SciPy Matplotlib

Tools & BI

Power BI Tableau JasperSoft PL/SQL Developer VS Code Eclipse Anaconda

DevOps & Methods

Linux Jenkins Git/GitHub Agile CI/CD Pipeline ETL Data Migration Debugging

Beyond the Code

Travelling

Explore new cultures and destinations to broaden perspective and foster growth.

Physics & Cosmos

I am interested in concepts of Cosmos considering mathematics and logic as the language of Universe.

Hello, I'm Nishant Kumar