Avinish Rai

Experience

• 

  Webel (West Bengal Electronics Industry Development Corporation Limited)

  Jul 2018 - Sept 2018

  Project Trainee
• 

  Ministry of Housing and Urban Affairs

  Dec 2020 - Mar 2021

  Geo-Spatial Data analyst trainee.

  I conducted an analysis of the pore size of the sand in the soil and determined the composition of loam, which consists of silt, sand, and clay. Utilizing R, I created visualizations based on the data and shared the findings with the civil engineering department, ensuring the suitability of the soil for construction purposes.".

• 

  Bosch Global Software Technologies

  Nov 2021 - May 2022

  Software Engineering Intern

  "As an intern at Bosch Global Software Technologies, I was responsible for integrating the database into the data processing workflow, resulting in more efficient data retrieval and significant productivity gains for internal teams. By leveraging my expertise in Python, SQL, HTML, and CSS, I reduced parsing time from 30 minutes to 10 minutes by directly fetching data from the database. Additionally, I designed and created a user interface to streamline data retrieval from the database. Overall, my contributions to the project were critical to its success and had a meaningful impact on the company's operations. The project was developed using Oracle and Enterprise Architect, two industry-leading technologies that I became proficient in during my internship." Show less

• 

  Bosch Global Software Technologies

  Sept 2022 - now

  🛠 Enhanced Python tool with dynamic column detection for web scraping, ensuring adaptability during triggering events.🎯 Developed precise positioning strategies to accurately identify column starting positions, improving data extraction accuracy.💡 Implemented efficient handling techniques for uppercase column names, ensuring seamless integration and data processing.⚙️ Optimized column size settings to zero for intelligent adaptation, enhancing tool functionality and versatility.📈 Achieved improved efficiency, reliability, and data integrity in web scraping tasks, empowering teams with valuable insights.🎯Reduced total code smells from 6000 to nearly 545, including major and minor issues. Addressed specific instances such as duplicated code, long methods, and complex conditions.💡Simplified logic and refactored complex algorithms to enhance readability and maintainability. Broke down complex functions into smaller, more manageable units to reduce cognitive complexity.🔧⚙Developed a Django API to send requests to a Jira board, fetching task and ticket data. This data is then forwarded to a Power BI dashboard, allowing managers to filter and assess team efficiency effectively.🛠Built an internal static website using HTML, CSS, and JavaScript, featuring organizational navigation, training details, and dynamic external links for seamless browsing. Show less Experienced member of the dynamic Tools Development Team at Bosch, a prominent industry leader. Proficient in a range of technologies, including Python, C++, Java, and QVTO, for advanced model transformation. Our primary focus revolves around crafting sophisticated internal tools that empower various departments and foster efficiency.Collaborating closely with the product owner, I ensure that features are seamlessly added or implemented, while working within an agile methodology to enable adaptable development. I bring expertise in essential developer tools such as Git, Jira, Sourcetree, Jenkins, and Bitbucket.In addition to my technical prowess, I have contributed to the team by designing an internal application using Django Rest Framework, writing unit tests, refactoring legacy code, and diligently maintaining Sonar quality standards. My dedication to optimizing code not only enhances its authenticity and integrity but also ensures that it remains comprehensible to other developers. Show less

  • Senior Engineer

    Jan 2024 - now

  • Associate Software Engineer

    Sept 2022 - Dec 2023