Ratnesh Kumar Email and Phone Number
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
-
Data ScientistTata Consultancy ServicesNew Delhi, Dl, In -
Data Engineer And AnalystTata Consultancy Services Dec 2021 - PresentNew Delhi, Delhi, IndiaGEM( 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 -
Machine Learning And Nlp InternData Science Club, Gndec Jan 2020 - Jul 2020Ludhiana, Punjab, IndiaMultilingual 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 -
Software Developer InternInfowiz Jun 2019 - Dec 2019Chandigarh, IndiaOnline Electronic Shopping : We are trying to help people to make their lifeeasier buy proving online electronic items for shopping. -
Six Week Industrial TrainingJavatpoint.Com Jun 2018 - Jul 2018Noida, Uttar Pradesh, IndiaATM System : How to interact /successfully transactions functionalitywith this ATM (Automated Teller Machine)
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 CopiesGurugram -
Ratnesh Kumar
Internet Of Things | Founder | Business Leader | Sales & Business Development | Business Strategist | Statrtup MentorBengaluru1thingularitynow.com -
1gmail.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 AccountsBengaluru
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
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.
Start your free trial