Ratnesh Kumar

Ratnesh Kumar Email and Phone Number

Data Scientist @ Tata Consultancy Services
New Delhi, DL, IN
Ratnesh Kumar's Location
New Delhi, Delhi, India, India
About Ratnesh Kumar

Data Engineer and Data Analyst ,Government E Marketplace (GeM) at TCS . Love to learn and explore new technology ( Data Science , Machine Learning , Deep Learning ) and opportunities.Some of my skills : - Languages : Python , PySpark ,SQL , Linux Shell Scripting - Data Structure and Algorithm - Cloud : AWS (S3, Lambda, EC2, IAM, EMR, GLUE, ATHENA, REDSHIFT) - Data Lake Architecture : Data Sources (Amazon RDS, Amazon Document DB, ) ,Data Ingestion

Ratnesh Kumar's Current Company Details
Tata Consultancy Services

Tata Consultancy Services

View
Data Scientist
New Delhi, DL, IN
Website:
tcs.com
Employees:
677733
Ratnesh Kumar Work Experience Details
  • Tata Consultancy Services
    Data Scientist
    Tata Consultancy Services
    New Delhi, Dl, In
  • Tata Consultancy Services
    Data Engineer And Analyst
    Tata Consultancy Services Dec 2021 - Present
    New Delhi, Delhi, India
    GEM( https://gem.gov.in/ ): The Government e Marketplace is an online platform for public procurement in India. The initiative was launched August 9, 2016, by the Ministry of Commerce and Industry, Govt. of India with the objective to create an open and transparent procurement platform for govt. buyers.GEM 2.0 : • Data Extraction from PostgreSQL to S3 (Python Script on EC2) Python scriptrunning on an EC2 instance to connect to PostgreSQL database. Fetchincremental data from… Show more GEM( https://gem.gov.in/ ): The Government e Marketplace is an online platform for public procurement in India. The initiative was launched August 9, 2016, by the Ministry of Commerce and Industry, Govt. of India with the objective to create an open and transparent procurement platform for govt. buyers.GEM 2.0 : • Data Extraction from PostgreSQL to S3 (Python Script on EC2) Python scriptrunning on an EC2 instance to connect to PostgreSQL database. Fetchincremental data from PostgreSQL.Write data to an S3 bucket in its raw form.• Data Transformation using PySpark on EMR Launch an EMR cluster withPySpark installed.Retrieve raw data from the S3 bucket.Use PySpark totransform the raw data according to business requirement.Write thetransformed data back to S3 or directly to Redshift.• Loading Transformed Data into Redshift Connect to Redshift cluster fromEMR.Load the transformed data into Redshift tables, including fact anddimension tables.Ensure proper table structure, indexing, and distribution keysfor optimal performance.• Exporting Data for Visualization Use PowerBI to connect toRedshift cluster and create visualization.Design fact and dimension tables tosupport the desired analytics and reporting requirements.• Scheduling with Airflow Use Apache Airflow to schedule and orchestrate ETLpipeline.Define Directed Acyclic Graphs to automate the execution ofPython and PySpark scripts.DASHBOARD(GeM) : • Designed and presented BI Dashboards ,overseeing the maintenance of over 70 app in Qlik Sense. Conducted thorough analysis of reported issue to guarantee the accuracy of data in the dashboards. • Developed and automated over 50N-printing reports on a daily, weekly, monthly, quarterly, semi-annual, and annual basis. Monitored a total of 300+ N-printing reports. • Engaging with various stake holders Internal or External, including Ministries, State Governments, PSU’s, and OEM Sellers, to address KPI/metrices, Dashboards or Custom MIS Data requests. Show less
  • Data Science Club, Gndec
    Machine Learning And Nlp Intern
    Data Science Club, Gndec Jan 2020 - Jul 2020
    Ludhiana, Punjab, India
    Multilingual Speech Conversion (Using Python , ML and NLP ): “Multilingual speech convertor” is being developed in order to convert one language to another by speech. Speech-To-speech (STS) system takes a human speech utterance as an input and requires a speech of words as output . Inspired By:According to Indian constitution officially 22 language presents. For Single people very difficult to learn more than 3 languages… Show more Multilingual Speech Conversion (Using Python , ML and NLP ): “Multilingual speech convertor” is being developed in order to convert one language to another by speech. Speech-To-speech (STS) system takes a human speech utterance as an input and requires a speech of words as output . Inspired By:According to Indian constitution officially 22 language presents. For Single people very difficult to learn more than 3 languages (Regional Languages, National Language - Hindi, Business Language - English). Removing the language barrier between the Two peoples, Two organizations, Two Educational institutions. Show less
  • Infowiz
    Software Developer Intern
    Infowiz Jun 2019 - Dec 2019
    Chandigarh, India
    Online Electronic Shopping : We are trying to help people to make their lifeeasier buy proving online electronic items for shopping.
  • Javatpoint.Com
    Six Week Industrial Training
    Javatpoint.Com Jun 2018 - Jul 2018
    Noida, Uttar Pradesh, India
    ATM System : How to interact /successfully transactions functionalitywith this ATM (Automated Teller Machine)

Ratnesh Kumar Education Details

Frequently Asked Questions about Ratnesh Kumar

What company does Ratnesh Kumar work for?

Ratnesh Kumar works for Tata Consultancy Services

What is Ratnesh Kumar's role at the current company?

Ratnesh Kumar's current role is Data Scientist.

What schools did Ratnesh Kumar attend?

Ratnesh Kumar attended Woolf, Scaler, Guru Nanak Dev Engineering College, Ludhiana.

Who are Ratnesh Kumar's colleagues?

Ratnesh Kumar's colleagues are Anusha Dega, Jineesh K, Kalaiselvi Thanikachalam, Shikhar Jha, M Sameer, Komal Vyas, Vignesh Bala.

Not the Ratnesh Kumar you were looking for?

  • Ratnesh Kumar

    Sustainability I Growth I Strategy | Sales & Ops I Bd# Authored Book For Upsc Examination - Sold Over Lakh Copies
    Gurugram
  • Ratnesh Kumar

    Internet Of Things | Founder | Business Leader | Sales & Business Development | Business Strategist | Statrtup Mentor
    Bengaluru
    1
    thingularitynow.com
  • Ratnesh Kumar

    Function Head Projects At Trident Paper
    Barnala
    1
    gmail.com
  • Ratnesh Kumar

    Business Head Talent Acquisition & Business Operations ,Pan India At Confidential (In Stealth Mode)
    Delhi, India
  • Ratnesh Kumar

    Techno Functional Business Analyst | Iiba Endorsed Agile Business Analysis | Cspo | Csm | Flmi L1- Loma |Ireb- Cpre | Bfsi Domain | Insurance & Annuities | Retail Banking | Retirement Accounts
    Bengaluru

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.