DAKSH RAJPAL
London
Summary
Masters in Data Science from University of Bristol.
Data Scientist | Data Visualization | Excel | Power BI | SQL | Business Analysis | Data Expert | Translates Complex data into actionable insights | Perpetual Learner.
Overview
6
6
years of professional experience
1
1
Certificate
Work History
Data Analyst Intern
Vasudha Foundation, NGO (Renewable Energy and Climate Change)
06.2024 - 09.2024
- Conducting research and gathering information for several important parameters, such as Generation, Production, Consumption, Transport, and Transport EV data related to Coal, Gas, Nuclear, Hydro, Solar etc from multiple sources in order to compile all of this data into a single Dataframe.
- Creating a Dataframe for all the 33 states of India (National Level) using Excel and Google Sheets using techniques like Pivot Tables, VLookUp, HlookUp.
- Using Python and it's libraries like NumPy, Pandas and other approaches such as Ollama, Hugging Face, Beautiful Soup, Lang Chain, etc., to design the CHATBOT using the same built Dataframe.
- Developing a User Interface dashboard that lets users compare various parameters and the user can even perform analysis by selecting from a variety of visualization options.
- Used Power BI to visualize user centric data insights for different parameters for every state using various graph kinds.
- Conducted thorough data validation and cleanup, ensuring accuracy and reliability of datasets used for analysis.
- Optimized SQL queries for faster processing times, increasing overall productivity within the team.
- Completed data cleaning and data validation of existing spreadsheets to promote robust data management platform, resulting in accurate data analysis and entry.
- Enhanced data visualization capabilities for better decision-making with the use of advanced Power BI tool.
Data Science Intern
Butterfly Data
06.2022 - 09.2022
- Intensive research was performed to find the datasets, relevant to the age of the distribution of vehicles as the aim was to find the vehicles which are of more than 15 years old that are entering the city center area to check and to calculate the fine/penalty that Bristol city council would be earning per day
- Finding NO2 level relevant datasets to calculate Air Pollution all over Bristol from postcode BS1 to BS49 as our main goal was to find the tentative year when Bristol would be free from pollution and would be a completely clean air zone
- Performed Data Analysis using the datasets to calculate and predict the expected year when there will be a clean air zone in Bristol depending upon the retrieved datasets of the age of the vehicles and the NO2 levels using Python
- Implemented data visualization techniques like Power BI for the insights that were retrieved after performing data analysis to effectively communicate insights to stakeholders.
- Using AWS Cloud Computing to store the datasets in Simple Storage Service (S3) and using tools like EC2, Lambda, etc
- Using GitHub and Docker Hub to store the code and share it with our fellow teammates
- Finally concluding the project by implementing AI tools to the pushed code for further Data Analysis and insights.
- Utilized programming languages such as Python or R extensively throughout the internship – applying relevant libraries and frameworks when appropriate.
- Performed advanced data extraction and data manipulation.
- Optimized machine learning models for improved prediction accuracy and performance.
- Applied appropriate data science techniques to solve business problems.
- Pinpointed meaningful insights from large data and metadata sources.
Engineer
Alliance Infotech Pvt. Ltd. (Department- Software Development)
12.2020 - 09.2021
- Developing and creating an Interactive Voice Response System (IVRS) using PHP coding framework
- The complete preparation of Workflow for IVRS- based systems functioning
- Creating APIs with complete documentation for IVRS Systems that allows systems to interact with humans through voice and Dual-Tone Multi-Frequency (DMTF) tone
- Customer Interaction with Demand Flow and Final Product Delivery.
- Established strong working relationships with clients through exceptional communication skills, fostering trust and collaboration.
- Developed positive working relationships with stakeholders to effectively coordinate work activities.
- Evaluated vendor proposals for equipment procurement, selecting optimal solutions based on performance requirements.
Data Analyst Intern
NTPC Ltd. (A Govt. of India Enterprise)
07.2019 - 03.2020
- Converted raw datasets into meaningful formats by performing extensive pre-processing activities such as normalization and transformation.
- Worked on Module on Data Analysis 'Psychometric Test Analysis using BigData' for the welfare schemes, offered to Employees and their dependents
- Using tools like Hadoop, Spark, and MapReduce have done analysis on the employees' welfare schemes i.e
- Medical Schemes, Loans, Leadership and Technical workshops, Post Retirement Benefits Employee of the month, Club Activities, etc.
- Identified trends and patterns in complex datasets through exploratory data analysis, leading to actionable insights.
- Enhanced data visualization capabilities for better decision-making with the use of advanced BI tools.
Team Leader
NGO, UMEED (A Drop of Hope)
10.2018 - 04.2019
- Worked as a Team Leader of my university for imparting education to young children
- I used to conduct various seminars during my bachelor's degree at my university and used to present presentations showing what we do for the growth of the children staying and living in an NGO
- We used to invest the revenue collected via performing seminars, social gathering events, etc
- For the welfare and growth of the children who were in need and used to give them food, shelter, and books to help them with their education.
- Managed conflict resolution among team members, fostering a positive and collaborative work environment.
- Collaborated with other department leaders to establish shared goals and ensure alignment across teams.
Education
Master of Science - Data Science
02.2024
Bachelor of Technology (B.Tech.)- Computer Science -
09.2020
Skills
- Excel
- Power BI
- SQL
- Python
- MS Word
- Power Point
- Business Analysis
- Data Analysis
- Big Data
- PHP
- Positive Attitude
- Teamwork and Collaboration
- Organized and Efficient
- Attention to Detail
- Relationship Building
- Public Speaking
Certification
- Successfully completed Bristol Plus Award for contributing and working for different NGOs as well as for the welfare of the university of Bristol students.
- Certified:- Entry-Level Python Programmer(PCEP) Certification from Python Institute.
- Completed SQL and PowerBI (DataScience) course from TechnoFine24 Training Institute.
- Artificial Intelligence(AI), training from SkillUp, (Accredited NASSCOM,India), August2020.
- Completed course on Blockchain & Python, training from Edureka, India, 2019.
Timeline
Data Analyst Intern - Vasudha Foundation, NGO (Renewable Energy and Climate Change)
06.2024 - 09.2024
Data Science Intern - Butterfly Data
06.2022 - 09.2022
Engineer - Alliance Infotech Pvt. Ltd. (Department- Software Development)
12.2020 - 09.2021
Data Analyst Intern - NTPC Ltd. (A Govt. of India Enterprise)
07.2019 - 03.2020
Team Leader - NGO, UMEED (A Drop of Hope)
10.2018 - 04.2019
University of Bristol - Master of Science, Data Science
Amity University, Noida - Bachelor of Technology (B.Tech.)- Computer Science,
- Successfully completed Bristol Plus Award for contributing and working for different NGOs as well as for the welfare of the university of Bristol students.
- Certified:- Entry-Level Python Programmer(PCEP) Certification from Python Institute.
- Completed SQL and PowerBI (DataScience) course from TechnoFine24 Training Institute.
- Artificial Intelligence(AI), training from SkillUp, (Accredited NASSCOM,India), August2020.
- Completed course on Blockchain & Python, training from Edureka, India, 2019.
Extracurricular Activities
- Attended Open Source Workshop by Coding Blocks, India, August2018.
- Volunteered in Blood Donation, Rotary Blood Bank, India, September2018.
- Participated in Lawn Tennis in Amity University, Sangathan, Annual Inter Amity Institutions Sports Meet, October 2019.
- Member of Student Organizing Committee for Inter Institution Competition (CodeHunt4.0) for Amity Youth Forum 2020.
- Member of International Conference- "CONFLUENCE-2017"; "CONFLUENCE-2018"; "CONFLUENCE-2019"; on Cloud Computer, Data Science and Engineering.
- Participated in Workshop on BLOCKCHAIN, at Amity University, Noida- September 2018.
Hobbies
1. I am a professional Canter Specialist Horse Rider.
2. I am professional Swimmer.
3. Like playing Lawn Tennis.
4. Like playing Violin.
Post Graduation Thesis
Non-Intrusive Load Monitoring (NILM) using CNN & LSTM.
- Downloaded and installed various packages like TensorFlow, Python, PyTorch, NILMTK which were the basic requirements for the NILM project implementation.
- After rigorous research and findings, the Reference Energy Disaggregation Dataset (REDD) was used for the project, the dataset consisted of 6 different houses (House1- House6) with different number of appliances in every house.
- Machine Learning (ML) models and different neural networks were used to predict the power consumption of each appliance in the household and compare the performance of each appliance along with the total power consumption of the household.
- Implemented various techniques of ML and deep learning methods like CNN, LSTM, and BiLSTM to evaluate the performance and efficiency of each model with different appliances.
- Used different hyperparameters, parameters of different values of epochs, and window sizes also used different activation functions like ReLU, Tanh, etc, and implemented with the help of different neural network models, tested for continuous long hours to predict the best and the most suitable hyperparameters for better efficiency and performance of the models.
- Finally, concluded the Thesis of my Data Analysis insights along with visualization of performances by using different neural networks and ML techniques like CNN, LSTM, and BiLSTM and presented the whole thesis with around 19-20,000 words with approx. 60- 65 referenced research papers that were referred to complete my thesis.
Extracurricular Activities
- Member of Student Organizing Committee for Inter Institution Competition (CodeHunt4.0) for Amity Youth Forum 2020.
- Member of International Conference- "CONFLUENCE-2017"; "CONFLUENCE-2018"; "CONFLUENCE-2019"; on Cloud Computer, Data Science and Engineering.
- Participated in Lawn Tennis in Amity University, Sangathan, Annual Inter Amity Institutions Sports Meet, October 2019.
- Participated in Workshop on BLOCKCHAIN, at Amity University, Noida- September 2018.
- Volunteered in Blood Donation, Rotary Blood Bank, India, September2018.
Hobbies
1. I am a professional Canter Specialist Horse Rider.
2. I am professional Swimmer.
3. Like playing Lawn Tennis.
4. Like playing Violin.
Similar Profiles
Leah De BastosLeah De Bastos
Senior Operations Leader, Compliance and Regulation at Department of Climate Change, Energy the Environment & WaterSenior Operations Leader, Compliance and Regulation at Department of Climate Change, Energy the Environment & Water
Radhika KannanRadhika Kannan
Solution Architect at Dept Of Climate Change, Energy, Environment & WateSolution Architect at Dept Of Climate Change, Energy, Environment & Wate
Fathimath HamlaFathimath Hamla
Computer Programmer at Ministry of Climate Change Environment & EnergyComputer Programmer at Ministry of Climate Change Environment & Energy