Ratnesh Kumar Email & Phone Number

New Delhi, Dl, In

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

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

Chandigarh, India

Online Electronic Shopping : We are trying to help people to make their lifeeasier buy proving online electronic items for shopping.

Noida, Uttar Pradesh, India

ATM System : How to interact /successfully transactions functionalitywith this ATM (Automated Teller Machine)

Master Of Science - Ms (Online), Master Of Science In Computer Science: Artificial Intelligence And Machine Learning, 4.0/4.0 Gpa

https://woolf.university/id/3625948911

Dsml (Online), Data Science And Machine Learning

Bachelor'S Degree, Information Technology, 7.34 /10 Cgpa