Software ProgrammerAt — M S International Inc.

As part of the your Curricular Practical Training (CPT), the internship will involve hands-on participation in two key research and development projects that are well-suited for academic enrichment and practical skill-building. These projects are designed to reinforce the your understanding of modern software engineering practices, infrastructure automation, and secure communications, while contributing to the MSI’s ongoing initiatives.

Tasks:

Project 1: Serverless Email Generation using SQL Server and Python Containers
You will work on decoupling existing logic embedded within SQL Server stored procedures that handle outbound email notifications. The primary objective is to design and implement a new stored procedure responsible solely for retrieving relevant data. This data will then be consumed by a Python-based microservice running inside a Docker container. The Python service will leverage the Jinja templating engine to dynamically generate HTML email content based on the retrieved data and dispatch it accordingly. The container will be architected to operate in a stateless, serverless fashion, allowing multiple concurrent instances and accepting stored procedure names as runtime arguments, thereby supporting a wide range of data retrieval use cases from SQL Server.

Project 2: Certificate Generation and Profile Provisioning for Secure Wi-Fi Authentication
The second project focuses on developing a user-facing application to automate the generation and provisioning of client certificates used in Wi-Fi authentication via the EAP-TLS protocol. Initial stages of this project will involve command-line based automation for certificate generation using a Public Key Infrastructure (PKI), interfacing with Active Directory Certificate Services (ADCS), and scripting the deployment of Wi-Fi profiles directly onto Linux-based devices. This will require familiarity with system-level components including polkit, secure certificate storage practices on Ubuntu, and methods to ensure the network configuration is accessible across user sessions on the device. The candidate will progressively transition these CLI workflows into a graphical user interface (GUI) application for improved usability and accessibility.

These projects offer you an excellent opportunity to deepen your practical understanding of database integration, containerization, secure communication protocols, and system-level configuration—skills highly relevant in today's software development and cybersecurity landscapes.

Training:

The student will be learning how to use multiple python libraries together in the real world, and how such libraries can be scaled

Separately, this will include an orientation about the company and how our team and his projects fit in the overall plan....

mentorship will be provided by three folks from the company, with weekly meetings, open door discussions

Learning outcome:

By the end of the academic internship, The student will be able to :

apply his learnings, into practical applications
visualize the workflow required to create complete software pipelines
understand how security, databases, languages, compilers, and the hardware stack come together in the real world to help in developing a finished product, that is used by the company.