Suthirr Preethum Balasubramanian

Associate Software Engineer

OpenClinica•  May 2020 - Present

• Worked on data import feature of the data migration process for OpenClinica systems using Java and Hibernate. o Improved the performance of the large dataset import by decreasing 75% of the processing time with the help of efficient single database hit to load group of relevant data and flushing the values from the ORM to database whenever a sub transaction is complete instead of flushing altogether at the end of a transaction. o Enhanced the data import feature to support XML import thereby allowing users to perform comprehensive data migration process to OpenClinica system. o Worked on improving the data import feature by integrating tabular import with XML import, thereby making the system consistent. • Worked on user authentication system for validating and approving data forms which authenticates the user by sending an access code through mail and verifying the same. • Developed Source Data Verification (SDV) feature for reviewing the form data in the OC system using Spring MVC as Backend framework and JavaScript as Frontend.

Software Engineer Intern

OpenClinica•  August 2019 - February 2020

• Replaced the database access queries from JDBC implementation to equivalent Hibernate (ORM) implementations. • Improved the performance for every API hit by refactoring the codebase to a single module and cleaning the codebase to remove unnecessary API calls between different module and unused legacy code. • Reduced the deployment hurdles by altering the property initialization mechanism to access customer specific properties from external files automatically at application startup in the Java Spring MVC application.

Software Developer

Tata Consultancy Services Ltd•  July 2017 - July 2018

• Created an error tracking and monitoring system using Java Spring Boot with Elastic Search as a data store and Grafana as UI to monitor the performance of various big data components like MQTT, Kafka, Oozie and Zookeeper. o Used by support team for viewing component specific issues and reporting the same. o Used by developers to track errors in the application stack to prevent component failures, boost efficiency and user experience. • Worked on creating a demo POC project to show a visual representation of the data flow from source through various components like MQTT, Kafka, Spark and HBase in the big-data ecosystem which helped the sales team to attract new Customers. • Created a microservice library which can be integrated with any application for generating different kinds of customized graphs (Boxplot, LineGraph, BarGraph) during report generation to gain more information and insight on various parameters. • Reduce the downtime of applications by running bash scripts at regular intervals to check the status of application and restart them automatically in case of system failure after logging the details and sending mail regarding the failure to support team.

Intern Trainee

Zoho Corporation•  May 2017 - June 2017

• Created online sales management system - Portal with three roles (Sen. Manager, Manager, Sales Rep.) for managing and monitoring inventories. When the products are sold, the bill will be sent to customer email in pdf format. • Leveraged Knowledge in Java, JSP, Servlets, RDBMS (Oracle), JavaScript, Html, CSS, MVC architecture