Aditi Varshney

Project: Reporting and analytics in the gaming domain.

• Designed scalable data architecture to ingest , store and process gaming data .
• Developed ETL pipelines using ADF and data flows for transformations.
• Configured Logic Apps worflows to send email notification for errors and data quality.
• Developed stored procedures to manage job creation and scheduling, ensuring efficient and reliable execution of SQL Server jobs.
• Created data models in Power BI, connecting to data warehouse and defining relationships and measures to support business reporting requirements.

Worked on different POCs:

Version Control for Scripts :
Developed a solution to the latest generated script and replaced it with the previous version in Git using powershell scripting.

PowerBI Refresh :
Developed and implemented a data pipeline leveraging Pyspark that automate the process of checking for new data files, updating Metadata , and triggering a PowerBI refresh so that he reports reflect the latest data.

Designed and implemented functions for calling APIs and refreshing PowerBI datasets, enhancing data reporting capabilities

Configured and managed Azure Data Lake Storage authentication for secure data access within the Spark environment.

• Worked on NLP to find keywords from reviews on different e-commerce sites
• Worked on data trend calculation to find best sellers among each merchant hierarchy using Python.
• Worked on APIs to pull data and used functions to provide reusability to the code.
• Used Pivot table, Pandas, Numpy, Matplotlib like libraries for data transformations.
• Developed custom algorithms to optimize and automate data analysis processes, resulting in improved efficiency