Gowri Haribabu

The KVD Group consists of Kvdbil – Sweden's largest digital player with used cars; Forsbergs - Sweden's largest dealer of motorhomes and caravans, the car valuation companies Bilpriser and Kvdpro, which mediates machines and heavy vehicles in Sweden and the rest of the world.

· Designed and implemented robust Azure Data Factory (ADF) pipelines to efficiently ingest structured data from internal ERP systems (Kastor, Pollux, Evergreen, Planacy) into a centralized Data Lake, facilitating the transfer of raw data and orchestrating data workflows for streamlined processing.

· Developed SQL views in Azure SQL Database to define and encapsulate business logic in the curated layer, leveraging stored procedures to transform and load data into curated tables. Applied a star schema for optimal querying and reporting performance.

· Implemented incremental loading techniques to enhance the performance of data pipelines, reducing unnecessary data processing and significantly improving data refresh times.

· Developed Azure Functions in Python to automate the extraction of data from external APIs (Verendas, Bisnode), integrating these functions into ADF pipelines to streamline data ingestion and reduce manual effort.

· Designed and implemented Logic Apps workflows to automate business processes, including the synchronization of master data between OneDrive and Azure SQL Database, improving operational efficiency and minimizing errors in data updates

· Utilized CI/CD pipelines within Azure DevOps to automate the build, release, and deployment of ADF workflows, ensuring consistent, reliable, and scalable data integration across development, testing, and production environments.

· Managed version control with Git(Azure Repos), implementing effective branching strategies and conducting code reviews to maintain high code quality and consistency.

· Contributed to the development of the tabular model using Azure Analysis Services to analyze Forsberg Company’s sales performance, optimizing analytical insights.

· Automated the Azure Analysis Services tabular model refresh process using ADF pipelines, enhancing real-time data availability for reporting and analytics, and significantly reducing the need for manual intervention in data management.

· Proactively monitored ADF pipelines through Azure Monitor, identifying and addressing performance bottlenecks to improve resource usage and processing times.

· Utilized ADF Monitoring and Alerts to provide real-time visibility into pipeline health, enabling rapid identification and resolution of performance issues, minimizing downtime.

· Worked closely with stakeholders to implement data governance policies, including data quality checks and validation within ADF pipelines, ensuring data accuracy and reliability for decision-making.

· Applied data lifecycle management in Azure Blob Storage, automating data retention and archival processes to ensure compliance while reducing manual data management overhead.

Client Name: Volvo Construction & Equipment

Volvo Construction Equipment is a leading international manufacturer of premium construction machinery. Its headquarters are in Gothenburg, and production facilities are worldwide. The Company manufactures a wide range of wheel loaders, excavators, frame-steered dump trucks, soil compactors and asphalt rollers, pavers, compaction equipment, and material handling equipment.

· Played a key role in developing Volvo Construction Equipment’s Financial Applications, including the Actual Monthly Package App, Estimate Package App, and Financial Summary App in Power BI. Delivered comprehensive financial insights to support financial planning, forecasting, and strategic decision-making, leveraging DAX to create custom KPIs, measures, and metrics for detailed performance analysis.

· Produced accurate and timely financial reports, including monthly closings and quarterly estimates for financial planning and analysis (FP&A). Delivered reliable, actionable data to senior management and key stakeholders to drive data-informed decision-making.

· Implemented row-level security (RLS) in Power BI to safeguard sensitive financial data, controlling user access based on roles and ensuring compliance with confidentiality standards.

· Collaborated with cross-functional teams, including finance, business controllers, and Data Engineering, to integrate financial data from various systems into Power BI, ensuring consistency, accuracy, and a unified approach to financial reporting.

· Provided training and ongoing support to the finance team, promoting best practices for using Power BI dashboards and reports. Fostered self-service BI adoption, empowering teams to perform ad-hoc analysis and improve decision-making.

· Managed and maintained the Power BI environment, ensuring dashboards, datasets, and reports were always up-to-date, optimized, and aligned with the company’s evolving business needs, delivering continuous value and enhancing reporting efficiency

Client Name: Shell, UK

Shell Horizon 3 is an application that allows clients to order new fuel cards, verify transactions regularly, and raise clarifications as needed. With these fuel cards, customers can refuel at Shell stations or third-party locations. This new system has successfully replaced the legacy LCASS system, streamlining the process and enhancing user experience

· Responsible for building a Sales Cube using Star Schema to measure revenue and sale quantity for deeper and faster data analysis.

· Developed MDX queries to support reporting and analytical requirements, enhancing decision-making.

· Monitored cube processing activities to maintain efficiency and reliability in data updates.

· Developed and configured roles in Cube to manage user access and ensure data security.

· Designed and implemented reports with SQL Server Reporting Services to track fuel card spending that surpasses defined thresholds, aiding in fraud detection and prevention.

· Providing solutions to incidents raised from the customer side & ensuring quality data repository.

· Executed ongoing fixes and improvements to boost the reliability and performance of SSRS reporting solutions.

· Implemented performance tuning measures for SSRS, resulting in faster report generation and improved system responsiveness.

· Developed real-time streaming platform with Apache Kafka to process billions of GPS records daily, enhancing location tracking and analytics for fleet management systems.

Client Name: Apra Amcos

The Australian Performing Rights Association (APRA) is a copyright collective representing New Zealand and Australian composers, lyricists, and music publishers. APRA AMCOS offers licensing for Australia and New Zealand for over 800,000 tracks across all styles and genres. Licences issued by APRA AMCOS cover the right to reproduce the musical and sound recording.

The Project Objective is to migrate data from SQL to CRM and integrate data across different streams like AX and CRM.

· Responsible for migrating the data from SQL Source to CRM destination.

· Developed SSIS packages to migrate data from SQL Source to CRM destination for each entity using the third-party tool Kingsway Soft Component.

Client Name: UECC - United European Car Carriers

United European Car Carriers was founded in 1990 and is Europe's leading short sea RoRo operator, dedicated to the needs of the automotive industry. Today the Company transports around 1.6 million units a year, comprising cars, commercial vehicles, high & heavy equipment and trailers. UECC operates a vessel fleet of 21 Pure Car and Truck Carriers (PCTCs), all of which have been designed or adapted to meet the necessary flexibility and efficiency requirements of the short sea market

· Developed customer-to-customer-specific reports and dashboards by implementing row-level security for the top 10 customers of UECC to give a complete snapshot of their business in a single view.

· Developed monthly comparison of forecasted volume vs actual volume for planning capacity and making strategic decisions.

· Developed Cargo Quality Claim report for claim management to define corrective actions to prevent cargo damage

· Developed CO2 and SO₂ Emission reports based on fuel type to improve vessel emissions and efficiency, fuel quality, emission reduction strategies, and environmental performance.

· Developed Payment Performance Report to improve the strategies for dealing with Outstanding Invoices.

· Developed Scheduled Reliability Report to improve on-time delivery and operational processes to reduce delays.

· Developed Transit Time Report to improve the timeliness of shipments and accuracy of estimations.

· Implemented Row Level Security Concepts.

· Supported UAT testing and completed the testing with quick resolve.

· Enhanced the performance of existing reports, significantly decreasing execution time for long-running queries, resulting in a better user experience.

· Troubleshot and resolved production issues related to SSIS jobs, ensuring minimal downtime and maintaining data integrity