Aishwarya Nagarajan

Business Intelligence Developer

Chennai, India 6+ yrs exp 55 · Fair

About

No bio added yet

Skills & Expertise

No skills listed yet

Work Experience

Business Intelligence Developer

Ford Motor Company

Apr 2024 - Present

Built and optimized BigQuery ETL pipelines on GCP to transform raw parts sales data into a scalable, analytics-ready data layer, enabling downstream BI consumption. Developed Looker dashboards delivering cross-channel insights on dealers, customers, revenue, and parts across NA and EU markets, improving KPI tracking and business decision-making. Re-engineered legacy Alteryx workflows into automated BigQuery pipelines, enabling efficient ingestion and transformation of vehicle sales data. Implemented automated monthly KPI calculations, eliminating manual Excel processes and reducing reporting turnaround time and errors. Designed and deployed interactive Power BI dashboards delivering trusted, near real-time insights that improved visibility into service and contract coverage across the fleet, cutting manual reporting effort. Integrated Copilot with the underlying semantic model to enable natural-language Q&A, reducing ad hoc reporting requests to the team by 30%. Enabled proactive identification of upsell opportunities across service plans, driving a 45% increase in revenue.

Data and Analytics Consultant

Thorogood Associates

Jun 2021 - Mar 2024

Operationalized complete ETL pipelines using Azure Data Factory and DataBricks notebooks to conceive and execute ingestion of extensive raw datasets utilizing PySpark, contributing to an automated forecast engine to forecast for a leading FMCG brand to improve efficiency and time involved in manual forecast. Integrated the forecasts with Power BI reports, enabling clients to scrutinize finance KPIs and analyze the trend of sales for different markets emphasizing the value of data-driven decision-making within the industry. Pioneered the realization of a solution elevating data governance standards for a world-leading consumer healthcare firm. Engaged in numerous sessions with clients to understand the requirements and engineered intricate Python scripts employing PyApacheAtlas library to architect a dynamic platform facilitating seamless CRUD operations within the Azure Purview tool allowing users to input through excel sheets, alleviating the complexities associated with UI interactions. Spearheaded Power BI dashboard development leveraging basket data collected from duty-free shops for a leading tobacco corporation aiming to provide comprehensive insights encompassing brand comparisons, product evaluations, affinity analysis, enhanced customer profiling and data-driven marketing strategies leading to a remarkable 50% increase in their sales performance. Championed migration of 50+ intricate reports from Tableau platform to Power BI integrating data from diverse data sources for a prominent FMCG firm commendably reducing the Tableau hosting cost by 50% and also entailed a meticulous optimization of the reports within Power BI, thereby elevating overall operational efficacy and data-driven decision-making capabilities. Played a pivotal role in development of predictive models in Azure Machine Learning Studio for a Singapore Airline company. Models were trained for identifying drivers, predicting expected number of passengers for specific flight on a specific date, assessing expected number of passengers across several likely scenarios, especially across different numbers of COVID-19 cases.

Intern

Full Stack Development Intern

Dec 2020 - May 2021

Successfully transitioned Excel-based endowment system into an intuitive web application, employing MVC framework for seamless user interaction. Additionally, automated the ETL process surrounding the system through the utilization of SSIS, resulting in a notable 60% reduction in user workload improving operational efficiency and user experience.

Intern

Web Development Intern

May 2019 - Nov 2019

Redeveloped an existing .NET framework based internal application (Management Information Planning System) as a Single Page Web Application with elevated user experience and heightened system performance. Orchestrated a seamless migration endeavour in Angular 7 aligned with industry benchmarks, introduced new features and expanded the system capabilities, providing an overview of various ongoing projects and detailed leave information of consultants, fostering improved operational insights by managers.