Siddhartha Keesara Email & Phone Number

Boston, Ma, Us

Boston, Massachusetts, United States

Ridgefield, Connecticut, United States

• Automated Operational Equipment Effectiveness (OEE) calculations for four drug packaging machines using Process Mining and Predictive Maintenance techniques on real-time PI Vision data, achieving a 30% improvement in accuracy and efficiency• Applied Statistical Analysis to co-develop a Streamlit application that automated retrospective report analysis, increasing reporting accuracy by 25%, boosting operational efficiency by 20%, and reducing weekly manual workload by 14 hours•… Show more • Automated Operational Equipment Effectiveness (OEE) calculations for four drug packaging machines using Process Mining and Predictive Maintenance techniques on real-time PI Vision data, achieving a 30% improvement in accuracy and efficiency• Applied Statistical Analysis to co-develop a Streamlit application that automated retrospective report analysis, increasing reporting accuracy by 25%, boosting operational efficiency by 20%, and reducing weekly manual workload by 14 hours• Employed Databricks Unity Catalog tables to conduct advanced analytics and visualize billing and usage logs, uncovering usage patterns and cost trends for 10+ entities and 125+ workspaces at both aggregate and individual levels• Created a unified SQL data source for Databricks Cost Analytics by integrating and transforming data from five sources and built an ETL pipeline to automate its daily updation in S3, keeping data current for precise cloud cost analytics Show less

Hyderabad, Telangana, India

• Executed data processing and data normalization operations in SQL, to collect, organize and analyze extensive datasets, leading to a 25% increase in data accuracy and a 20% reduction in data processing time• Implemented data validation checks, including cross-referencing datasets and automating data cleaning process, to rectify inconsistencies across multiple datasets, improving accuracy and reliability of business reporting by 30%• Diagnosed and resolved ETL pipeline errors… Show more • Executed data processing and data normalization operations in SQL, to collect, organize and analyze extensive datasets, leading to a 25% increase in data accuracy and a 20% reduction in data processing time• Implemented data validation checks, including cross-referencing datasets and automating data cleaning process, to rectify inconsistencies across multiple datasets, improving accuracy and reliability of business reporting by 30%• Diagnosed and resolved ETL pipeline errors by identifying bottlenecks in data extraction and transformation processes, leading to a 35% increase in data processing speed and overall system performance• Redesigned and optimized a database schema using SQL, streamlining the data retrieval process, and improving efficiency by 33%• Collaborated in cross-functional teams to maintain comprehensive documentation of data processing procedures, enabling effective knowledge transfer, and ensuring continuity in data operations • Recognized with a ‘SPOT Award’ for commitment, enhanced business intelligence and excellence in client interactions Show less

Hyderabad Area, India

• Analyzed user feedback data to identify gaps in data collection, leading to redesigned surveys that improved response rate by 30%• Streamlined data collection process for cafeteria customer feedback, increasing the amount of usable data for analytics by 40%• Migrated data from over 10+ sources into a centralized AWS Redshift warehouse, enhancing accessibility and streamlining analytics

Kharagpur, West Bengal, India

• Analyzed latency performance of an application using AWS CloudWatch logs across multiple data centers by identifying bottlenecks and drove a 35% increase in overall application performance.

Hyderabad, Telangana, India

• Developed a Social Bookmarking Application with a 95% user satisfaction rate using Python and Django framework to categorize bookmarks into word clouds.

Master Of Science - Ms, Data Analytics Engineering, 4.0/4.0

Coursework: Advanced Database Management, Advanced Data Mining, Visualization for Analytics, Fundamentals of Data Analytics, Statistical.

Bachelor Of Technology - Btech, Computer Science, 8.46/10

Coursework: Database Management Systems, Probability and Statistics, Design and Analysis of Algorithms, Machine Learning, Advanced Data.