Summary
Overview
Work History
Education
Skills
Certification
Languages
Timeline
Generic

Saranya R

Oulu

Summary

Highly skilled and adaptable Technical Lead with over 10 years of extensive IT experience in developing, supporting, and optimizing business-critical applications across industries such as manufacturing, telecommunication, banking, and finance. Proven track record of delivering comprehensive business intelligence solutions and cloud-based architectures using Microsoft technologies including MS SQL Server, Azure, SSIS, SSAS, SSRS, Power BI, and Microsoft Fabric. Recognized as a Microsoft Certified Developer, excelling in integrating resources into business operations and delivering innovative technical solutions to complex challenges. Strong experience in Azure environment creation and handling multiple Azure and Fabric projects, successfully collaborating with diverse teams including engagements with Finnish clients for enterprise-level solutions. Proficient in agile development methodologies, skilled in designing and implementing relational database models and managing the full development lifecycle for cloud and data-driven projects. Results-driven data engineering professional with a solid foundation in designing and maintaining scalable data systems. Expertise lies in developing efficient ETL processes and ensuring data accuracy to contribute to impactful business insights. Known for strong collaborative skills and ability to adapt to dynamic project requirements, consistently delivering reliable and timely solutions aligned with business goals.

Overview

2025
2025
years of professional experience
1
1
Certification

Work History

DataWarehouse Specialist

Pinja Solutions Oy
06.2021 - Current
  • Company Overview: Pinja Solutions Oy specializes in Azure-based projects and provides services to various sectors including logistics, procurement, and automotive inspection
  • I played a key role in developing and maintaining an Azure-based database solution for these organizations
  • Designed and established the cloud infrastructure, including setting up Azure environments and managing resource provisioning
  • Spearheaded the integration of data from diverse sources such as AX, CRM, Instawahti, and Smartvateen for the Kouvolanvesi Project, as well as Cloudia for Sansia, Muster source for Akatsasus and blob storage files for carspect
  • Automated the entire ETL process using Azure Data Factory pipelines, eliminating the need for multiple stored procedures
  • I implemented dynamic procedures and functions to handle all ETL operations with Control tables that significantly reducing manual effort and enhancing data transformation flexibility
  • Maintained data integrity, optimized ETL processes, and ensured seamless data flow for Finance, Operational, and Unsolicited Reporting data
  • Collaborated with cross-functional teams to align database solutions with business needs
  • Developed and deployed dynamic power BI reports directly from the data warehouse
  • Implemented detailed logging mechanisms throughout the ETL pipeline—covering every stage from source to staging, BLOB to staging, and from staging to the data warehouse—ensuring robust error tracking and process transparency
  • Pinja Solutions Oy specializes in Azure-based projects and provides services to various sectors including logistics, procurement, and automotive inspection
  • Client 1: Kouvolan Vesi (logistics and procurement sector) is a municipal water utility company based in Kouvola, Finland, responsible for providing clean water services, wastewater treatment, and maintaining the region's water and sewer network infrastructure
  • Client 2: Sansia (logistics and procurement sector) specializes in providing services to public sector organizations, including logistics, procurement, and other administrative support
  • Client 3: A-Katsastus (automotive inspection and registration sector) is one of Finland's largest and most prominent companies in the vehicle inspection and registration sector
  • Client 4: Carspect (automotive inspection and vehicle safety sector) is a leading provider of vehicle inspection services in Northern Europe, handled Sweden, Estonia, and Latvia Carspect project

Data Engineer | Microsoft Fabric Project

Jamk University of Applied Sciences
  • Company Overview: Jamk is a multidisciplinary institution located in Jyväskylä, Finland, offering a wide range of degree programs in both Finnish and English
  • Ingested and stored raw data from multiple sources using Data Factory and Dataflows
  • Transformed and cleaned data, ensuring quality and consistency with Dataflows and Data Factory
  • Created aggregated, business-ready datasets for reporting and analytics using Power BI and optimized for performance
  • Managed scalable storage solutions in OneLake and Lakehouse, leveraging Delta Lake for transactional support
  • Jamk is a multidisciplinary institution located in Jyväskylä, Finland, offering a wide range of degree programs in both Finnish and English

Data Engineer

Diakonia-ammattikorkeakoulu
  • Company Overview: Diakonia-ammattikorkeakoulu, known as Diak, focuses on providing higher education in fields like social services, healthcare, diaconia, and community development
  • Designed and implemented data warehouse architecture in TimeXtender, including DSA, ODX, and MDW layers
  • Developed and maintained the data staging area for capturing raw data from peppi, erp and from external APIs
  • Built and managed ODX layer to store semi-structured data in an operational format
  • Consolidated structured data from multiple sources into the MDW, designing star schemas and dimensional models
  • Utilized SQL/T-SQL for complex data transformations and integration
  • Managed ETL workflows and scheduled jobs to ensure smooth operations across all layers
  • Developed error-handling mechanisms and alerts to ensure data consistency and monitor failures
  • Working on Migrating the project to Microsoft fabric
  • Diakonia-ammattikorkeakoulu, known as Diak, focuses on providing higher education in fields like social services, healthcare, diaconia, and community development

Technical Lead

Chevron Corporation
09.2016 - 11.2019
  • Company Overview: Chevron Corporation is a multinational corporation involved in nearly all aspects of the energy sector, including oil and gas exploration, production, refining, and marketing
  • Designing, configuring, deploying SSIS packages and providing security for packages
  • Designing and developing large number of reports in Power BI, SSRS using the data from ETL Loads and various heterogeneous data sources
  • Creation and the maintenance of Analysis Services objects such as cubes, dimensions and MDX queries
  • Played an important role in implementing Azure Devops to the current operation for SQL database CI/CD
  • Played a potential role in migrating LOWIS database from MS SQL 2008 to MS SQL2012
  • Created many dashboards in Power BI using DAX expressions
  • Query Optimization and Performance Tuning using SQL Profiler and Index Tuning Wizard
  • Working knowledge in Agile/Scrum Environment and used TFS
  • Chevron Corporation is a multinational corporation involved in nearly all aspects of the energy sector, including oil and gas exploration, production, refining, and marketing

Data Analyst and Developer

Larsen & Turbo Infotech
01.2012 - 08.2016
  • Company Overview: Larsen & Turbo Infotech is a global technology consulting and services company, providing IT solutions and services across various sectors
  • Manage and maintain databases/data systems that includes staging, purged databases which holds archived historical data and primary DWH databases
  • Involved in Database Design, Data Modeling (Relational and Dimensional) using Microsoft Visio for logical and physical data models
  • Used tools like MS SQL Profiler, Index Tuning Wizard, and Windows performance for monitoring and tuning SQL Server performance
  • Created Business Development Reports in SSRS and POWER BI for Larsen and Turbo and Explored Data in multiple visualization
  • Developed technical solutions to diverse operational problems
  • Created App Service in Azure
  • Developed web-jobs and deployed to app service in Azure
  • Designed ad-hoc Reports in Excel Power pivot and shared them using Power BI to the decision makers for strategic planning
  • User access management
  • Larsen & Turbo Infotech is a global technology consulting and services company, providing IT solutions and services across various sectors

Education

Bachelor of Engineering - Information Technology

Anna University
Chennai

Skills

  • Azure Data factory
  • Azure SQL
  • Microsoft Fabric
  • Azure Devops
  • Azure databricks
  • Power BI
  • MICROSOFT SQL Server 2008
  • MICROSOFT SQL Server 2012
  • Tableau Reporting Tools
  • Qlik Reporting Tool
  • Timextender DW Tool
  • Microsoft SSIS
  • Microsoft SSAS
  • Microsoft SSRS
  • Data modeling
  • Data pipeline design
  • Data warehousing
  • ETL development

Certification

  • Microsoft SQL Server 2008, Business Intelligence Development and Maintenance
  • DP-500: Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI
  • DP-900: Microsoft Azure Data Fundamentals

Languages

English
Finnish

Timeline

DataWarehouse Specialist

Pinja Solutions Oy
06.2021 - Current

Technical Lead

Chevron Corporation
09.2016 - 11.2019

Data Analyst and Developer

Larsen & Turbo Infotech
01.2012 - 08.2016

Data Engineer | Microsoft Fabric Project

Jamk University of Applied Sciences

Data Engineer

Diakonia-ammattikorkeakoulu

Bachelor of Engineering - Information Technology

Anna University

Similar Profiles

CREATE PROFILE
Saranya R