Ratnesh Kumar

Data Engineer and Data Analyst

Tata Consultancy Services | June 2023 - Present

Gem Project ( https://gem.gov.in/ ): The Government e Marketplace is an online platform for public procurement in India. The initiative was launched on August 9, 2016, by the Ministry of Commerce and Industry, Government of India with the objective to create an open and transparent procurement platform for government buyers. Data Warehouse : Taking the data 10+ different modules using Node.js ETL Scripts , Storing the data using PL/SQL Sql procedure scripts at 3rd Layer architecture and sending the data to 10+ modules using Node.js , Python & Libraries Scripts. Resolving Jeera Tickets . Data Lake Architecture : Data Sources (Amazon RDS, Amazon DocumentDB, ) ,Data Ingestion (Amazon EMR) ,Data Capture (Amazon S3), Data Curation , Data Provision ( Amazon S3 , Redshift) Dashboard : 37+ BI Dashboard using Qlik Sense , Qlik Views , N-Printing ,Resolving Jeera Tickets .Gem Project ( https://gem.gov.in/ ): The Government e Marketplace is an online platform for public procurement in India. The initiative was launched on August 9, 2016, by the Ministry of Commerce and Industry, Government of India with the objective to create an open and transparent procurement platform for government buyers. Data Warehouse : Taking the data 10+ different modules using Node.js ETL Scripts , Storing the data using PL/SQL Sql procedure scripts at 3rd Layer architecture and sending the data to 10+ modules using Node.js , Python & Libraries Scripts. Resolving Jeera Tickets . Data Lake Architecture : Data Sources (Amazon RDS, Amazon DocumentDB, ) ,Data Ingestion (Amazon EMR) ,Data Capture (Amazon S3), Data Curation , Data Provision ( Amazon S3 , Redshift) Dashboard : 37+ BI Dashboard using Qlik Sense , Qlik Views , N-Printing ,Resolving Jeera Tickets . Skills: Qlick Sense · Apache Spark · AWS · Data Visualization · Pandas · NumPy · Data Analytics · Tableau and Excel · SQL · Python (Programming Language) · MySQL

Assistant system engineer

Tata Consultancy Services Ltd | December 2021 - May 2023

IT/Support Analyst Project : GSK (https://www.gsk.com/en-gb/ ): GSK a global biopharma company with a purpose to unite science, technology and talent to get ahead of disease together. GSK an acronym from its former name GlaxoSmithKline plc, is a British multinational pharmaceutical and biotechnology company with global headquarters in London.Established in 2000 by a merger of Glaxo Wellcome and SmithKline Beecham. GSK is the tenth largest pharmaceutical company. Pinnacle : User creation, Study and project creation, Access request which we used to receive in Snow and emails. Harp: Based on ServiceNow Incidents: Access request, RE Deletion, RE Archiving. Citrix groups: Only Access request. TOO: Access request, which is going to be decommissioned this year, Access Audit Process. PULSAR: Working on this. Additional Task: P21 Access Audit, Harp Access Audit, ToO Access Audit, Harp UAT, SSDR UAT, P21 UAT, Documents. Archiving Task for PULSAR, DOMINO, RAPIDO, HIF and ToO etc. HIF:Access Management and Revocation, Adobe Isign : Rapido, Space. Data Migration MSR : Every Month Rapido UAT(Regression Testing): WIPProject : GSK (https://www.gsk.com/en-gb/ ): GSK a global biopharma company with a purpose to unite science, technology and talent to get ahead of disease together. GSK an acronym from its former name GlaxoSmithKline plc, is a British multinational pharmaceutical and biotechnology company with global headquarters in London.Established in 2000 by a merger of Glaxo Wellcome and SmithKline Beecham. GSK is the tenth largest pharmaceutical company. Pinnacle : User creation, Study and project creation, Access request which we used to receive in Snow and emails. Harp: Based on ServiceNow Incidents: Access request, RE Deletion, RE Archiving. Citrix groups: Only Access request. TOO: Access request, which is going to be decommissioned this year, Access Audit Process. PULSAR: Working on this. Additional Task: P21 Access Audit, Harp Access Audit, ToO Access Audit, Harp UAT, SSDR UAT, P21 UAT, Documents. Archiving Task for PULSAR, DOMINO, RAPIDO, HIF and ToO etc. HIF:Access Management and Revocation, Adobe Isign : Rapido, Space. Data Migration MSR : Every Month Rapido UAT(Regression Testing): WIP Skills: CSS3 · SQL · MySQL · React.js · Node.js · Express.js · MongoDB · JavaScript · HTML

Woolf University

Master of Science in Computer Science: Artificial Intelligence and Machine Learning, MS | August 2022 - Present

Master of Science in Computer Science: Artificial Intelligence and Machine Learning (Online) Skills: Probability and Statistics · Matplotlib · Big Query · SAS · Tebaua and Excel · ML OOPs · Data Science · NumPy · Panadas · SciPy · Seaborn · Data Analytics · SQL · Artificial Intelligence (AI) · Deep Learning · Natural Language Processing (NLP) · Computer Vision · Neural Networks · Machine Learning · Python (Programming Language) · Microsoft Power BI · Data Structures · Algorithms

Scaler

Data Science, MS | August 2022 - Present

ScalerScaler DSML, Data Science and Machine Learning DSML, Data Science and Machine Learning (Online) Skills: Probability and Statistics · Big Query · SAS · Pandas · Tebaua and Excel · ML OOPs · Data Science · NumPy · Mataplotlib · SciPy · Seaborn · Data Analytics · SQL · Artificial Intelligence (AI) · Deep Learning · Natural Language Processing (NLP) · Computer Vision · Neural Networks · Machine Learning · Python (Programming Language)

Guru Nanak Dev Engineering College

Information Technology, B.Tech | July 2016 - July 2020