Samarth Gupta Email & Phone Number

Seattle, Wa, Us

Toledo, Ohio Metropolitan Area

• Automated reporting and visualized KPIs by integrating Microsoft Teams with Power BI, improving progress tracking across 2 regions, and currently expanding to 7 additional locations.• Enhanced production efficiency and product quality by implementing anomaly detection model in TwinThread, and developed 5+ monitoring dashboards to proactively address production issues.• Reduced unplanned downtime in 4 regions by analyzing plant data with Seeq and Excel, implementing predictive maintenance.

Toledo, Ohio Metropolitan Area

• Automated reporting and visualized KPIs by integrating Microsoft Teams with Power BI, improving progress tracking across 2 regions, and currently expanding to 7 additional locations.• Enhanced production efficiency and product quality by implementing anomaly detection model in TwinThread, and developed 5+ monitoring dashboards to proactively address production issues.• Reduced unplanned downtime in 4 regions by analyzing plant data with Seeq and Excel, implementing predictive maintenance.• Standardized remote monitoring tags by creating a data dictionary with 1000+ tags, enhancing scalability.• Developed a scalable solution for visualizing sensor data by creating hierarchical custom asset trees and Python-based plots using NumPy and PyPlot, implemented across 3 plants with scalability for 30 more.

India

•Developed complex SQL queries to extract, transform, and load Salesforce data from multiple sources, improving data accessibility for stakeholders.• Built dynamic Excel macros to streamline repetitive data extraction and cleansing tasks, reducing processing time by 20 hours per month.• Configured Salesforce to manage case tracking, timesheet data processing, task delegation and other use cases to improve overall process efficiency.• Innovated solutions for client challenges, leading to a prototype that secured a $20 million contract renewal.•Formulated and executed a data modeling strategy, creating schema with 50+ relational entities, which achieved data normalization.•Automated the lead generation process on Salesforce Platform, leading to a 22% improvement in financial operations, by processing timesheet data efficiently.•Coached and mentored three new team members, resulting in an increase in project completion rate, allowing the team to deliver client-specific solutions on time.

Pune, Maharashtra, India

• Engineered RESTful API integrations between Salesforce and Adobe Sign, automating contract generation and enhancing PowerBI reporting, resulting in increased workflow efficiency.• Executed end-to-end functional and regression testing on critical solutions, with less than 10% of cases requiring bug fixes post-deployment.• Designed and implemented CI/CD pipelines using Copado, facilitating smooth transitions of change set from development to production environments and ensuring robust post-migration support.• Maintained a comprehensive data dictionary for the Salesforce platform, documenting over 10000+ fields and 30+ objects to ensure data clarity and consistency.

Pune

• Data Preprocessing: Learned how to clean, preprocess, and transform raw data into a suitable format for machine learning models. This includes handling missing values, outliers, and data normalization.• Exploratory Data Analysis (EDA): Gained experience in visualizing and exploring data to identify patterns, trends, and insights that can inform the machine learning model selection and feature engineering.• Feature Engineering: Worked on creating and selecting relevant features from the data to improve model performance. • Model Selection: Learned how to choose the right machine learning algorithms for different types of problems. Experiment with various models such as linear regression.

Mumbai

• Elevated operational efficiency by 55% by designing and automating manual tasks into scheduled workflows for network metadata storage.• Harnessed a Hadoop to extract critical network department data, improved connectivity and metadata analysis, and integrated enhancements that increased departmental efficiency by 20%.

Master Of Science - Ms, Information Technology, 3.72

Coursework for Fall'24 semester: 1.Data Visualization. 2.Spreadsheet Modeling. 3.Tech and New Product Development. Coursework.

Bachelor Of Engineering - Be, Electrical, Electronics And Communications Engineering, 3.40