Platooning and Trust for Autobots UW

•Spearheaded the development of the following major projects to production, contributing to a 50% exceedance of Q1 goals and the successful clearing of a backlog.• Engineered a Databricks Notebook in Python to load and process a daily dataset of nearly 10,000 fraudulent bank transactions into Delta Tables in Azure Data Lake Storage. Optimized code using Z-Ordering and partitioning, resulting in a 40% reduction in data retrieval and query times.• Resolved critical production security risks by refactoring code to remove the use of mount.• Utilized PySpark DataFrames in Databricks to convert data from a Delta table to a CSV flat file, developing custom DataFrames to handle inconsistent column counts across datasets. Successfully merged these into a unified structure in compliance with strict business requirements.

• Developed a real-time dashboard feature using Java Spring Boot for the backend, JavaScript for the frontend,with a DynamoDB database. Enabling a major client to monitor the status of their autonomous mobile robots(AMRs).• Implemented efficient API data retrieval and presentation, dynamically displaying tabular and graphical data forover 500 data points per minute with real-time updates.• Enhanced video data storage and retrieval performance, reducing load time from 15 seconds to under 3 secondsfor each event-based recording using S3 buckets and server-side pagination.• Improved application efficiency by 30% by writing an AWS Lambda function to process raw data for faster loads.

• Utilized Java Spring boot and Ecplise to create a web application from scratch designed to monitor all Java Applications at TCI.• Implemented a cache which periodically gets the app data from a MySQL database and stores it in a HashTable.•Created a REST connector which used regex to resolve variables from the cache and uses it makes a call to the API. •Created HTTP and JDBC connectors to check the API response and the database connection. •Packaged the web application as a WAR file so each application can use the HealthCheck. •Utilized GSON to return an easy to read JSON response which depended on the response from the API.

• Created a web app from scratch using Django for the backend with a MySQL database, and React.JS for frontend.• Implemented 2 CI/CD pipelines using AWS ElasticBeanStalk with individual MySQL databases.• Initialized a Github repository and allocated individual branches, then used pull requests to merge the work done.• Utilized Celery to asynchronously send emails for user confirmation, and Redis as a caching database.• Implemented verification for different types of users using JWT token verification and Google oAuth• Connected the frontend in React to the backend using a fetch api.• Followed Agile Development(Jira), and collaborated with a team of developers along with UI/UX designers.• Optimized development process by providing improvements for various user stories.