ishan sharma

Business Analyst Intern

Zealtech Inc.•  February 2024 - August 2024•  Fremont, CA, USA

Engineered robust ETL pipelines using Apache NiFi to automate the ETL from various sources, resulting in a 50% reduction in manual data processing efforts and ensuring timely data availability. Conducted performance tuning and optimization of the data warehouse using Amazon Redshift and Snowflake, resulting in a 40% improvement in query performance and a significant reduction in storage costs through effective data partitioning and compression techniques. Created a comprehensive database schema for the client, maintaining normalization to the 3rd Normal Form (3NF) to minimize redundancy and enhance data integrity, leading to a highly efficient and scalable database structure. Implemented indexing, query optimization, and partitioning strategies to enhance database performance, resulting in a 50% reduction in query execution time and improved overall system responsiveness. Designed and automated regular backup and recovery procedures, incorporating full and incremental backups, ensuring data integrity and availability, and achieving a recovery point objective (RPO) of under 10 minutes.

Research and Development Engineer

Schneider Electric•  February 2022 - August 2022•  Bengaluru, India

Test Automation and Optimization: Contributed to the automation of test scripts for the improved prototype of the IoT-enabled interoperable architecture and platform, Ecostrxure, by optimizing existing formulations and processes in the HOCI team. This automation reduced manual testing efforts and decreased testing cycle time. Functionality Enhancement: Redefined and implemented 3 new functionalities within Ecostruxure, resulting in a significant reduction of engineering costs and time by up to 80%, and increasing user engagement and satisfaction by 20%. Client-Centric Development: Leveraged client feedback and storyboard scenarios using Test Complete and Cucumber to streamline and optimize test scripts. This approach effectively minimized manual interventions, resulting in more efficient testing processes. Cross-functional collaboration: Worked closely with senior leadership to secure approvals and ensured the timely implementation of new product functionalities within the provided deadlines.

Data Scientist Internship

Alpha AI•  June 2021 - August 2021•  Remote, India

Model Fine-Tuning and Enhancement: Led the fine-tuning and upgrading of existing object detection models using PyTorch and TensorFlow, significantly boosting performance by 87%. This included optimizing hyperparameters and integrating advanced techniques to enhance model accuracy. Exploration of Distributed Detection Systems: Researched and implemented alternatives to traditional monolithic object detectors, such as ADA Boost, by transitioning to distributed YOLO family detectors. This shift, coupled with GPU acceleration tools and libraries, improved detection speed, reducing time to detection by 0.1ms. Data Analysis and Customization: Analyzed datasets across various domains, utilizing Matplotlib for statistical modeling and visualization. Developed customized datasets tailored for specific projects, which contributed to an 80% reduction in training and testing errors.

Software Engineering Internship

Reliance Jio Infocom•  February 2021 - May 2021•  Remote, India

Utilized and configured Crowdin to manage translations and automatically pull new strings to integrate them with the project’s Git repository. Integrated Google Cloud Translation API to provide initial translations for new content and accurate localization. Implemented i18next for handling translations for JavaScript-based Jio Suite of applications. Contributed to the development of automated tests using Selenium and Lokalize QA to verify the applications to verify application of translations and ensure UI components were rendered correctly in different regional languages.