Siddharth Arya

Managed a team of Engineers, Executives, and Business Operatives, collaborating with various departments, managers, C-suite executives, and third-party stakeholders to deliver outcomes with a 95% efficiency rate daily Led the organization's migration from legacy systems to a cloud-based environment, automating all business processes by transitioning from Excel to Power BI, Looker, Python. Developed data standards, documentation, and conducted extensive employee training through workshops, live projects, and shadowing sessions Directed 5 business areas in producing yearly volumetric assumptions, demand plans, and resource allocations using R, SQL, GA, and Looker. Communicated weekly with internal and external stakeholders, successfully maintaining performance, reports to drive positive scheme, policy changes impacting millions of people Utilized Power BI/Tableau, Python/R, SQL, Dbt to create KPIs, interactive dashboards to communicate and assist senior management, CEOs by enabling real-time access to allocation performance data and improving customer satisfaction by 50% Controlled and optimized allocation of 2 billion in Government funds across stakeholders using data analysis using Power BI, R, GA, and financial forecasting, regression analysis and clustering to optimize allocation strategies

● Conducted data analysis using Advanced Excel, R,SQL,Power BI/Tableau, regression analysis and clustering to optimize allocation strategies ● Utilized Power BI/Tableau, Python/R, SQL, Dbt to create KPIs, interactive dashboards to communicate and assist senior management, enabling real-time access to allocation performance data and improving customer satisfaction ● Implemented GDPR guidelines, data encryption, access control, streamlined ETL process in collaboration with IT/Data stakeholders, reducing processing time by 20% and safeguarding sensitive allocation data ● Employed GPT-based language models for NLP tasks, including text classification, named entity recognition, sentiment analysis, and summarization for 20% improvement in accommodation allocation

● Utilised SQL, R/python, dbt, Power BI/Tableau to analyse 10+ million customer invoice records and developed ML and testing models resulting in a 20% increase in sales and surpassing quarterly targets for underperforming products ● Led end-to-end development of ETL pipelines using R/Python, Alteryx, AWS, SQL, Dbt and Snowflake to analyse consumer response to advertising campaigns, leading to a £10,000 revenue increase ● Collaborated in a cross-functional team to maintain a suite of 20+ company-wide Tableau/Power BI dashboards, ensuring data quality, robust UAT, and code-base review on github ● Presented weekly insights to C-suite executives and facilitated iterative improvements. Led a team of 10+ members to scope requirements for financial, marketing, and marketing growth projects. ● Developed KPI reporting suite within tableau/ Power BI, including 20+ metrics from 5+ domains and several sources, ensuing scalable data pipelines. Conveyed insights to stakeholders through engaging visuals weekly and worked with product/tech teams in a scaleup environment using agile methods to identify and automate repetitive tasks.

• Exporting Data to MS Access and Excel for periodic and exceptional reporting. Creating various types of graphs and summaries • Interacting and communicating with colleagues for routine and ad hoc tasks to achieve objectives efficiently • Introduced an idea of starting a new sales channel among a team of 10; brainstormed implementation process, generating 5% additional revenue

GLOBAL VOLUNTEER PROGRAM with AIESEC - During the program, I contributed to the UN Sustainable Development Goal of Industry, Innovation, and Infrastructure. As part of this internship, I extensively worked on leadership based project with people of diverse countries. Developed the official website, reservation system, and mobile app for the company, ELMAHTA which is a start-up providing co-working space & library to students.