Sourabh Lakhera

Sourabh Lakhera

Student Intern

Followers of Sourabh Lakhera5000 followers
location of Sourabh LakheraDelhi, India

Connect with Sourabh Lakhera to Send Message

Connect

Connect with Sourabh Lakhera to Send Message

Connect
  • Timeline

  • Skills

    Abaqus
    Algorithms
    ANSA
    ANSYS
    Apache Kafka
    Apache Spark
    AutoCAD Mechanical
    Autodesk Fusion 360
    Autodesk Inventor
    Batch Processing
    Bayesian networks
    Big Data
    Big Data Analytics
    Bootstrapping
    Business Requirements
    C (Programming Language)
    Cassandra
    Class Evaluation Measures
    Communication
    Computational Fluid Dynamics (CFD)
    Computer-Aided Design (CAD)
    Computer Science
    Cross-Validation
    Dashboards
    Data Analysis
    Database Administration
    Database Design
    Database Development
    Database Management System (DBMS)
    Data Engineering
    Data Manipulation
    Data Science
    Datasets
    Data Structures
    Data structures and algorithms
    Data Visualization
    Decision Trees & Ensembles
    Distributed Systems
    Docker
    English
    Ensemble
    Extract, Transform, Load (ETL)
    File Handling
    Git
    GNU/Linux
    Google Cloud Platform (GCP)
    Hadoop
    HBase
    Hidden Markov Models (HMMs)
    Jenkins
    Linear Algebra
    Linear Discriminant Analysis
    Linear Regression
    Linux
    Logistic Regression
    MATERIALISE MAGICS
    Mathcad
    MATLAB
    Mechanical Engineering
    Microsoft SQL Server
    Naive Bayes
    Neural Networks
    NoSQL
    NumPy
    Object-Oriented Programming (OOP)
    Open Database Connectivity (ODBC)
    Optimization
    Oracle Database
    Oracle SQL Developer
    Oral Communication
    Pandas (Software)
    Partitional Clustering
    PL/SQL
    Presentations
    Probability Theory
    Problem Solving
    Programming
    PySpark
    Python
    Python (Programming Language)
    Python libraries
    Query Optimization
    Random Forest
    Relational Databases
    Replication (Computing)
    ROC Curves
    Software Development
    Solid Mechanics
    SolidWorks
    SQL
    Statistical Decision Theory
    Subset Selection
    Support Vector Machine (SVM)
    Talend Open Studio
    Terraform
    Transact-SQL (T-SQL)
    Version Control
    Version Control Tools
    Workflow Management
  • About me

    I am a results-driven Data Engineer with a strong background in Python, Apache Spark, and Pandas libraries. My passion lies in implementing and enriching my technical knowledge within esteemed organizations. I thrive in collaborative environments, leveraging cutting-edge technologies alongside highly experienced peers to advance both my professional and interpersonal skills. With expertise in SQL, Linux, Talend, Oracle, and Snowflake, I excel in ETL processes, data migration, and database architecture. By leading successful proof of concept (POC) projects and contributing to client-based data transformation initiatives, I consistently deliver effective solutions, ensuring optimal data quality and performance. Committed to staying abreast of emerging technologies, I actively seek opportunities for continuous improvement. With a proactive mindset and a passion for excellence, I am poised to make a significant impact in a new role, contributing to the success of the organization and my personal growth.

  • Education

    • National Institute of Technology Warangal

      2020 - 2022
      Master of Technology - MTech ADDITIVE MANUFACTURING

      Additive manufacturing (AM) is the process of joining materials to make objects from Computer Aided Design (CAD) model data, usually layer upon layer, as opposed to subtractive manufacturing methods. Additive manufacturing is also called 3D printing, additive fabrication, or freeform fabrication.

    • Vellore Institute of Technology

      2015 - 2019
      Bachelor of Technology (B.Tech.) Automobile/Automotive Mechanics Technology/Technician

      Activities and Societies: cricket, debate team,projects, sae

  • Experience

    • Automotive Research Association of India (ARAI)

      May 2018 - Jun 2019
      Student Intern
    • EinNel Technologies

      Nov 2020 - Jun 2021
      Associate Project Engineer

      During my tenure with MDOX, I successfully applied my technical knowledge to drive innovative solutions in the field of Machine Learning and Data Science. I demonstrated proficiency in automobile engineering concepts and utilized advanced software tools to analyze and optimize BIW components. My expertise in FEA, data extraction, and visualization further enhanced my ability to contribute effectively to complex projects.

    • Phillips Machine Tools

      Jul 2021 - Mar 2022
      Application Project-Intern - Additive Manufacturing

      I gained valuable experience in advanced manufacturing technologies. I became proficient in Autodesk Fusion 360, using it for CAD/CAM/CAE/3D printing. Under the guidance of EOS-certified seniors and peers, I designed for additive manufacturing and learned the nuances of optimizing designs for successful implementation. I also received training on Markforged machines, acquiring hands-on experience in installation, build preparation, and operation. Additionally, I developed knowledge of EOS M290 and EOS M400 systems, understanding their mechanical, optical, electrical, and electronic requirements. Working in a techno-commercial environment, I collaborated effectively with vendors, showcasing my teamwork and communication skills. This internship solidified my interest in advanced manufacturing and deepened my understanding of the practical application of technology in real-world scenarios. Show less

    • HCLTech

      Jul 2022 - now
      Technical Lead

      • Proficient in SQL, Linux, Python, Talend-ETL tool , Cloud Storage and computing - certified from Databricks , AWS• Led 3 successful proof of concept (POC) projects utilizing SQL, Bash, Python, Apache Spark, Kafka, Airflow, Docker, Cassandra• Project Leadership: Led cross-functional teams in executing data migration projects, meeting deadlines and exceeding client expectations.• Designed and developed data pipelines for data migration and transformation from On-Premsie DB to cloud storage.• Expertise in ETL processes, data migration, and database architecture.• Strong problem-solving skills, ensuring data quality and performance, Regular reporting tasks and Root cause analysis in failure senarios.• Stakeholder Engagement: Effectively communicated technical concepts to non-technical stakeholders, fostering collaboration and alignment.• Actively updated with emerging technologies for continuous improvement like Prefect , MAGE , LLMs – Chat bot creation.• Python – Automation - API / Framework expertise with Data wrangling, Data scraping, Data Ingestion using spark, with cloud support from snowflake , AWS S3 , Databricks, BigQuery. Show less

  • Licenses & Certifications

    • TCS ION CAREER EDGE- KNOCKDOWN THE LOCKDOWN

      TCS iON LifeLong Learning
      Jun 2020
      View certificate certificate
    • POWER SYSTEM GENERATION - ELECTRICAL

      Tata Steel Processing And Distribution Ltd.
      Apr 2020
      View certificate certificate
    • TOTAL QUALITY MANAGEMENT

      Tata Steel Processing And Distribution Ltd.
      Apr 2020
      View certificate certificate
    • Fundamental of Hybrid Electric Vehicle

      Skill-Lync
      May 2020
    • Find Your Ikigai with Operation and supply chain management

      Skill-Lync
      May 2020
      View certificate certificate
    • DATA SCIENCE MATH SKILLS

      Duke University
      May 2020
      View certificate certificate
    • DESIGN AND MODELLING OF INDUSTRIAL COMPONENT WITH AUTODESK INVENTOR

      Skill-Lync
      May 2020
    • GEAR TRAIN DESIGN

      Skyfi Labs
      May 2020
      View certificate certificate
    • Evolutionary algorithms and Decision Making Analysis Using MATLAB with case studies

      Vellore Institute of Technology
      Sept 2017
    • POWERTRAIN ENGINEERING

      Automotive Research Association of India (ARAI)
      Jul 2018