Gangadhar Gandham

Sr.Data Analyst

Microsoft•  February 2023 - Present•  Hyderabad

Senior Data Analyst in the Edge team at Microsoft, employed through Ziniosedge. Led the migration of Edge internal data pipelines from XFlow to the Lens platform using PowerShell, significantly improving workflow efficiency and improved scalability. Collaborated with product team to identify and address top churn causes, reducing user churn by 0.5% from the Edge Add-ons store. Collaborated with an external team on the Greencamp project to define key metrics. Developed automated pipeline for PDF Upsell metrics, accelerating delivery time by 60% and improving ease of sharing insights with the Adobe team. Implemented Lexical Search to find semantically similar extensions on Edge Addons Store, improving UX by providing relevant suggestions for 50% of Zero-Search-Results queries. Created comprehensive datasets and dashboards using Power BI to support data-driven decision-making for the EDU team. Collaborated with cross-functional teams to enhance feature performance and support extension developer outreach initiatives. Utilized advanced analytical techniques to interpret Edge telemetry, store data, and Windows data. Assisted in designing and conducting experiments to test new features and measure their impact on user engagement. Handled Ad hoc data analysis tasks as required to support urgent business needs and strategic initiatives. Developed a smart Autofill feature for Edge using language models and user data, enhancing suggestion accuracy and relevance. Implemented a GPT-based prototype and focused on reducing costs with efficient models.

Data Engineer

Zen3InfoSolution a Tech Mahindhra Company•  April 2019 - April 2022•  Hyderabad

Migrated data from an on-premises SQL Server to Azure Data Lake Gen2, collaborating with source teams to extract, transform, and load data into Azure Data Lake Storage (ADLS). Designed and managed complex ADF pipelines for HISTORY and DELTA load operations, using activities like stored procedures, copy, lookup, and For-Each. Configured automatic triggers for scheduling and ensured timely and accurate data processing. Processed large datasets in Azure Databricks using Spark SQL, orchestrated through ADF pipelines, optimizing data operations and reducing processing time. Developed ETL processes to efficiently migrate data from on-premises and cloud source systems to Azure, consolidating data into single-source datasets in Data Lake for analytics and reporting. Created connections from different sources, both on-premises and cloud, to serve as a unified data source for Power BI reports. Coordinated with external teams to troubleshoot and resolve data flow issues, reducing blockers and improving internal workflow efficiency. Handled both development and support activities for various applications, provided end-user support by quickly troubleshooting incidents and resolving issues.