Hemashruthi Ganesh

● Achieved 99% load time improvement and near real-time data sync between SAP ECC and Azure using Azure SAP CDC connector. ● Dynamically loaded and transformed 150+ SAP tables in one shot by developing pipelines and mapping data flows in Azure Synapse. ● Leveraged Pyspark to replicate SAP ABAP logic for over 450 fields and automated the end to end load using Delta Live tables (DLTs).

● Analyzed 20 years of financial statements (10Ks) and commercial real estate data using Python (Numpy, Pandas) to support research. ● Extracted data through web scraping, cleaned the data, conducted statistical analysis, and created dynamic dashboards to showcase findings.

● Spearheaded a 3-member team in refining an ETL system, managing code reviews, and supervising both development and deployment phases. ● Liaised directly with the business stakeholders to understand the business requirements and formulated the optimal design approach. ● Helmed the weekly checkpoint calls with business users.

● Orchestrated data extraction and transformation using Azure Data engineering tools – including Azure Data Lake, ADF, Databricks, SQL Server Database, SQL Data Warehouse - and developed Power BI dashboards to facilitate Revenue management for a Fortune 100 FMCG company. ● Gained hands-on experience in Data architecture, ETL and Data pipelining, Database management, Big data processing, Data modeling and Warehouse design, Data governance, Version control, DevOps integration and Data Visualization. ● Achieved a notable 90% reduction in processing time through a Databricks-empowered cloud migration of an on-premises ETL framework. ● Built an ASP.Net MVC Framework-based web application for a leading CPG manufacturer, driving Pricing analytics through retail and ecommerce insights. Achieved a 70% improvement in processing time via advanced SQL query optimization techniques. ● Developed a predictive algorithm using SAP supply chain data to identify and manage “Stocks at risk of expiry” for a global Pharma company, enabling a remarkable $10M+ annual reduction in the write-off amounts caused by obsolete stocks. ● Owned the end-to-end deployments of a critical BI system for over 15+ Agile sprints by designing the Devops repository and build/release pipelines to streamline Continuous Integration and Continuous Deployment (CI/CD). OTHER HIGHLIGHTS: ● Trained 50+ new hires on various technologies in Azure BI stack and Azure Devops ● Curated content for several virtual training sessions and marketing campaigns. ● Mentored and provided technical guidance to 3 interns ● Bagged 4 Star performer awards and 1 Passion award for various projects, having been nominated by managers and teammates alike and achieved 2 fast-tracked promotions.

● Saved 200+ man-hours by building an Azure Resource Provisioning tool (using ASP.Net framework) to automate the provisioning of various Azure services through PowerShell scripts and customized ARM templates using Infrastructure as Code (IaS) model. ● Drove a 20% decrease in internal cloud spending by building a custom Power BI dashboard to analyze and optimize cloud infrastructure costs. ● Engineered 15+ robust Extract Transform Load (ETL) pipelines utilizing SQL and SSIS, transforming the CRM landscape of a Tobacco company.

PROGRAM REPRESENTATIVE - School of Electrical engineering at VIT ● Acted as the spokesperson for students and represented the School of Electrical Engineering in several inter-school discussions ● Liaised with the Career services center on behalf of the students ● Attended several quality circle meetings to discuss various issues and represent the interests of the student body

● Bharat Heavy Electricals Limited (BHEL) owned by the Government of India, is India’s largest power plant equipment manufacturer. ● Gained an overall understanding about BHEL's working structure and its product manufacturing processes and electrical maintenance practices working under the guidance of Mr. P.Ganapathi Raman, Deputy Manager (Shop Electrical Maintenance and Service Dept.), ● Performed a comprehensive study on the Electrical maintenance system for Air pre-heaters and Fan production - which are the two key components of any thermal power plant.

Courses : 1) Mathematical Foundations for Data Science 2) Statistical Foundations for Data Science 3) Databases and Computational Tools Used in Big Data 4) Data Mining and Analysis 5) Machine Learning 6) Statistical Computing with R and Python 7) Applied Analytics 8) Deep Learning 9) Capstone Project 10) Artificial Intelligence

Position of Responsibility: • Program representative - School of Electrical Engineering (2018-19) • Organizing member - International Conclave on Managing Disruptive Trends and Technologies (ICDIT) (2017) Achievements: • Gold medalist (Batch of 2015-19), School of Electrical Engineering • Recipient of Chancellor's meritorious award and scholarship for outstanding academic achievements for 3 consecutive years (2016, 2017, 2018) • Won 1st place in Paper Presentation at International SEED Conference in technoVIT'18 (Sep 2018) Conferences: • Presented a paper on "Mobile Tower radiation on Biological Impairment" in the International Conference on Bioengineering on Health and Environment (ICBHE'18) Workshops: • Workshop on "PLC based Industrial Automation" conducted by Indus Auto Technologies (2017) • Workshop on "PCB Design and Fabrication" by Livewire training services (2015) • National workshop on "Electronic circuits using snap kits" conducted by IEEE VIT Chapter

Position of responsibility: Served as the School Pupil Leader (2013-14) • Hosted general assembly for classes 6-12 every week • Liaised with the staff coordinators to curate the content for each assembly • Chaired the monthly meet with class prefects to discuss various issues and formulate plans for upcoming events, workshops etc., • Planned and organized the weekly Inter House activities • Acted as the student spokesperson and collaborated with the administration to identify, analyze and solve various issues Achievements: • Merit based scholarship - Received a full tuition waiver for the academic years 2013-14, 2014-15 • Secured 1st place in the State level Mathematical Quiz conducted by Mathematics Association, VIT (2013) • Secured school 1st in Computer Science in the 12th Board exams (2015)

Position of responsibility: • House Vice-Captain (2013) • Class prefect for the years 2009, 2010, 2013 Achievements: • State level 2nd Rank in the class 10 Board exam (2013) • Awarded Best outgoing student (2013) • Secured State Level Rank 8 in the International Cyber Olympiad (2009) • Class Topper (2008-2013) Participated and won accolades in various competitions and inter-school events throughout my schooling period. Organized and took part in various cultural events and activities.