Himanshu Thappa, Developer in Helsinki, Finland
Himanshu is available for hire
Hire Himanshu

Himanshu Thappa

Verified Expert  in Engineering

Data Strategist and Developer

Helsinki, Finland

Toptal member since March 24, 2025

Expertise
Data WarehouseData MigrationData EngineeringAPISQLOracle DevelopmentDatabaseCRMBusiness Intelligence DevelopmentPythonNoSQLPostgreSQL
Bio

Himanshu is a goal-oriented data and cloud advisor with over 17 years of experience in data engineering and customer experience. He excels in crafting enterprise data solutions in the energy, telecom, fintech, and public sectors. Certified in SAFe methodologies, he has spearheaded customer data platform (CDP) development on Azure Databricks and microservices using REST API and GraphQL.

Portfolio

Fortum
Azure API Management, Azure Databricks, Data Quality, Performance Testing...
Sofigate
Data Architecture, Enterprise Data Warehouse (EDW), RDMS, ELT, Data Modeling...
Capgemini Finland
Scaled Agile Framework (SAFe), Oracle Data Integrator (ODI), Siebel CRM...

Experience

  • PL/SQL Developer - 16 years
  • Data Warehousing - 16 years
  • Oracle - 15 years
  • Data Migration - 15 years
  • ELT - 13 years
  • Data Architecture - 13 years
  • Data Strategy - 13 years
  • Azure Databricks - 5 years

Availability

Full-time

Preferred Environment

Python, Azure Databricks, Data Warehousing, Oracle, ELT, Data Architecture, API Testing, Oracle Data Integrator (ODI), PostgreSQL

The most amazing...

...thing I've built: a business intelligence and analytics system for POLISSI, Finland. I contributed to time-series-oriented solutions in data using Data Vault.

Work Experience

Data Architect

2024 - PRESENT
Fortum
  • Developed a data model for various energy business functions, including customer, revenue, and sales data models in the Databricks gold layer.
  • Established a QA framework for data quality and validation for business-critical flows and analytical models in the CDP platform.
  • Performed PySpark and SQL-based notebooks for data validations, referential integrity, and Index creations for performance tuning.
  • Enhanced the data quality of multidimensional data models in the Databricks platform based on semantic and syntactic data.
  • Built automation testing practices for data quality using pytest and Azure DevOps pipelines.
  • Built PostgreSQL objects for time-series data actively.
  • Was a quick learner in adapting new tools/technologies, bringing value to customers by offering strategies and approaches to build a continuous solution in the data platform.
  • Used a modern cloud platform based on Azure Data Factory and Databricks architecture for transformation/loading into the gold layer for analytical purposes.
Technologies: Azure API Management, Azure Databricks, Data Quality, Performance Testing, PostgreSQL, Testing Strategy, Load Testing, Confluence, Jira, Stakeholder Management, API Testing, Data Engineering, Azure Data Factory (ADF), PySpark, Data Transformation, Databricks, Pandas, SQL, Azure, Azure SQL, Data Validation, ETL Tools, Machine Learning, Business Intelligence (BI), Database Management, Database Optimization, NoSQL, Relational Database Design

Data Architect

2022 - 2024
Sofigate
  • Delivered AI-enabled data assets for Finnish national security on Oracle Cloud, integrating various public sector applications.
  • Designed a data strategy for handling batch and streaming data for transactional applications. Defined data models, estimations, database objects, and solution approaches using data vault concepts.
  • Developed a testing framework for analytical reports built on Power BI apps.
  • Executed various roles encompassing database design, data mart designs, and the development of master data management solutions to manage codes and static/hierarchical data effectively.
Technologies: Data Architecture, Enterprise Data Warehouse (EDW), RDMS, ELT, Data Modeling, Dimensional Modeling, Python, Big Data, XML, Oracle Analytics Cloud (OAC), Microsoft Power BI, Data Engineering, SQL, Database Replication, Azure, Azure SQL, Data Validation, ETL Tools, Business Intelligence (BI), Database Management, Database Optimization, Relational Database Design

Senior Data Engineer

2017 - 2021
Capgemini Finland
  • Spearheaded a data analytics solution for POLISSI with timely increment deliveries and sprint demos.
  • Demonstrated a reporting solution on the data vault concept to handle customer KPIs like case handling time, active case distribution across the Finland region, and predictive analysis of case types.
  • Designed and developed an end-to-end data warehouse solution for an operational system with zero downtime for data migration from batch to streaming pipelines.
  • Headed program increment ceremonies, customer relationship management (CRM) sprint planning, and product backlog while collaborating with customers and team leadership.
Technologies: Scaled Agile Framework (SAFe), Oracle Data Integrator (ODI), Siebel CRM, JavaScript, PL/SQL Developer, XML, Data Vault 2.0, Data Pipelines, Change Data Capture, Data Engineering, SQL, Database Replication, Data Validation, ETL Tools, Business Intelligence (BI), Database Management, Database Optimization, Relational Database Design

Solution Consultant

2015 - 2017
Mastercard
  • Formulated a solution roadmap for modernizing service applications and reporting solutions.
  • Developed analytical solutions based on CRM data integration and Microsoft BI products.
  • Contributed to reports development for business metrics, improving cardholder retention and card services.
  • Participated in pre-sales, software demos, and multivendor management.
Technologies: Data Analytics, Project Services Management, Microsoft Power BI, Stakeholder Engagement, Business Technology, Databases, SQL, Data Validation, Business Intelligence (BI), Tableau, Relational Database Design

Tech Lead

2011 - 2017
Accenture
  • Oversaw a team of ETL experts in delivering and designing transformation solutions based on multiple legacy applications for Vodafone UK.
  • Increased call center agents' productivity in improving customer handling and order management processes using bulk order workflow development in CRM for prepaid and postpaid customers.
  • Proposed and designed solutions for data syncs across telecom BSS stack apps during new telco product launches.
  • Developed a custom solution for a seamless preactivation experience for customers. Improved customer retention using the churn solution.
  • Led the delivery of essential reporting to telecom tower leads at Vodafone UK, leveraging leadership expertise.
Technologies: Data Migration, Telecom Business Support Systems (BSS), Siebel CRM, ETL Tools, Requirements & Specifications, RDBMS, Shell Scripting, PL/SQL, Database Performance, Application Management Services (AMS), Order Management, Data Mapping, SQL, Database Management, Relational Database Design

Experience

ETL Pipeline Automation

Handled incremental data loading from source to different data warehousing layers based on a custom solution using key columns to identify start and end dates besides storing data volumes of pipeline execution.

SIM Cards Pre-activation

Designed a solution for prepaid customers across the telecom BSS stack to experience uninterrupted services offered during new sim purchases. The entire solution involves CRM workflow, billing activation, product registration, inventory management, and automatic order orchestration.

Consumer Solution Data Platform

http://Fortum.com
I am currently scaling a highly distributed data platform based on the Delta Lakehouse concept using Azure and Databricks components. The platform provides data as a service to downstream systems for analytical purposes and front-end web/mobile apps for data references. My work involves ensuring data architecture support in terms of building logical and dimension models in gold and silver layers in Databricks. I also support the development team in writing optimized SQLs, transformation logic, and database setup for handling complex data relationships.

Education

2001 - 2005

Bachelor's Degree in Computer Science

University of Jammu - Jammu, India

Certifications

MARCH 2025 - PRESENT

Databricks Machine Learning Fundamentals

Databricks

AUGUST 2024 - PRESENT

Microsoft Certified Professional

Microsoft

JUNE 2024 - PRESENT

Certified Scrum Product Owner

Scrum.org

NOVEMBER 2021 - PRESENT

Oracle Database Vault

Oracle

Skills

Libraries/APIs

Pandas, Azure API Management, PySpark

Tools

Siebel CRM, Microsoft Power BI, Postman, Confluence, Jira, Tableau

Languages

SQL, Python, C++, XML, JavaScript

Paradigms

Business Intelligence (BI), Dimensional Modeling, Load Testing, Database Design

Platforms

Oracle, Oracle Data Integrator (ODI), Azure, Databricks, Oracle Analytics Cloud (OAC), Zephyr Scale

Storage

PL/SQL Developer, Database Replication, Data Validation, Database Management, PostgreSQL, Azure SQL, NoSQL, Data Pipelines, RDBMS, PL/SQL, Database Performance, Azure SQL Databases, Databases, SQL Server Management Studio (SSMS)

Frameworks

Scaled Agile Framework (SAFe)

Other

Data Warehousing, Data Strategy, ELT, Data Migration, Data Architecture, ETL Tools, API Testing, Data Engineering, Database Optimization, Relational Database Design, Azure Databricks, Azure Data Factory (ADF), Data Transformation, Enterprise Data Warehouse (EDW), RDMS, Data Modeling, Big Data, Data Quality, Performance Testing, Forecasting, Testing Strategy, Data Vault 2.0, Change Data Capture, Stakeholder Management, Telecom Business Support Systems (BSS), Requirements & Specifications, Shell Scripting, Application Management Services (AMS), Order Management, Data Mapping, Certified Scrum Product Owner (CSPO), Machine Learning, Complex Problem Solving, System Architecture, Data Analytics, Project Services Management, Stakeholder Engagement, Business Technology, Digital Transformation

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring