25.03.2026 aktualisiert

**** ******** ****
100 % verfügbar

Data Specialist with expertise in SQL Server, Power BI, and ETL processes

Berlin, Deutschland
Berlin +25 km
Bachelor of Engineering: Computer Science
Berlin, Deutschland
Berlin +25 km
Bachelor of Engineering: Computer Science

Profilanlagen

HexaBase GmbH - Deepak Kumar Singh.pdf

Skills

InnovationAsp.NetHTMLJavaScript.Net FrameworkAgile MethodologieApache AirflowAmazon S3Analyse-ToolsData AnalysisAnwendungsarchitekturArchitekturAuditsMicrosoft AzureBusiness IntelligenceBig DataProzessoptimierungC#CSSCloud ComputingBeratungContinuous IntegrationInformation EngineeringData GovernanceDatenintegritätETLDatenmanagementDatenmodellDatenqualitätDatensystemeData WarehousingDevOpsWeb EntwicklungEnergietechnikFinanzenGitHubSteuerungPythonProjektmanagementMicrosoft Data Access ComponentsMultiDimensional EXpressionsWindows Presentation FoundationMicrosoft Sql-ServerAzure SQLVisual Basic .NETMicrostrategyOracle FinancialsPerformance-TuningScrumReengineeringMicrosoft Power BIRequirements EngineeringRisikoanalyseSemantikSoftwareentwicklungStored ProcedureSQLSQL Server Integration ServicesSQL Server Analysis ServicesLagerverwaltungGeschäftsstrategienTransact-SqlUser StoriesWindows FormsModellierungsfähigkeitenDatenverarbeitungTransport Layer SecurityDemonstrations-FähigkeitenLiefer-PipelineIndexerKanbanMicrosoft Fabric (Analytics-Plattform)ÖkosystemeAngularJSPySparkV-modellDeployment AutomationVBA Programming LanguageStar-SchemaDSGVOFront EndOffshore-ArbeitenAzure Synapse AnalyticsSsas TabularAdministration von DatenbankenÄltere SystemeKpi-BerichterstattungDatabricksProgramming Languages
Professional Summary

Results-driven Data Specialist with 15+ years of experience in software engineering, data engineering, and business intelligence across consulting, financial services, energy, industrial services, and audit environments.

Strong expertise in Microsoft data ecosystems including SQL Server, SSIS, SSAS, Power BI, Azure, and Microsoft Fabric. Proven track record of designing scalable data architectures, optimizing SQL performance (up to 70% improvement), modernizing legacy systems, and delivering end-to-end BI and analytics solutions.

Experienced in agile environments (SCRUM, KANBAN) with a strong DevOps mindset, enabling structured, version-controlled, and production-ready data solutions.


Core Competencies

Data Engineering & Architecture
  1. End-to-End ETL Design & Development
  2. Data Warehouse Modeling (Star Schema)
  3. SQL Performance Optimization & Indexing
  4. Medallion Architecture (Lakehouse: Raw / Curated / Serving)
  5. Data Quality & Validation Frameworks
  6. Incremental Processing Patterns
  7. CI/CD for Data Platforms
  8. DevOps-enabled BI Delivery

Microsoft Fabric & Modern Data Platform
  1. Fabric Lakehouse (OneLake Architecture)
  2. Fabric Warehouse (T-SQL Modeling)
  3. Fabric Data Factory (Pipeline Orchestration)
  4. Fabric Notebooks (PySpark)
  5. Power BI Semantic Models (DAX Optimization)
  6. Direct Lake & Hybrid Reporting Patterns
  7. Governance-Ready Modeling Practices

Business Intelligence & Analytics
  1. Power BI Dashboard Development
  2. DAX & MDX Modeling
  3. SSAS Tabular Models
  4. KPI Monitoring & Risk Analytics
  5. Data Model Reengineering
  6. Self-Service Analytics Enablement

Software Engineering Background
  1. .NET (C#, ASP.NET, VB.Net, Windows Forms, WPF)
  2. AngularJS
  3. SQL Server & Oracle
  4. Secure Application Architecture (SSL, Token Auth)
  5. Frontend: HTML, CSS, JavaScript

Project & Delivery Methodologies
  1. Agile (SCRUM, KANBAN)
  2. V-Model (Classical PM)
  3. Requirement Engineering & User Stories
  4. Stakeholder Presentation & Documentation
  5. Offshore Team Coordination

Technical Stack

10+ Years
SQL Server, T-SQL, C#, ASP.NET, Windows Forms, VB.Net, WPF, SSIS, Oracle

5–10 Years
Power BI, SSAS, ETL, DAX, MDX, AngularJS, Azure DevOps, GitHub, JavaScript, HTML, CSS

2–5 Years
Microsoft Fabric, Python, PySpark, Databricks, Airflow, Azure SQL, Azure Synapse Analytics, AWS S3, VBA, MicroStrategy, Exasol, Tabular Editor


Leadership & Mindset
  1. Customer-focused solution design
  2. Strong data governance & GDPR awareness
  3. Continuous improvement & innovation-driven
  4. Collaborative leadership with agile delivery mindset
  5. Emphasis on data integrity and scalable architectures

Erfahrung

Berufserfahrungmehr als 10 Jahre
Freelancer seit2012

Sprachen

DeutschGrundkenntnisseEnglischverhandlungssicher

Projekthistorie

Data Engineer

Financial Services
Leading migration of ETL processes from SSIS packages to optimized SQL Server stored procedures. Streamlining and automating data transformation workflows.

Enhancement Developer

Energy Sector
Leading enhancement of legacy calculation tool/web application originally developed in Excel and VB.Net Windows Forms. Upgrading SQL database structures and modernizing web applications.

Software Engineer

Audit/Consulting
Supporting development of ETL processes and data pipelines as part-time Software Engineer. Collaborating with internal teams to support Power BI dashboards.

Data Specialist

HexaBase GmbH
Designed and maintained ETL pipelines to process large datasets, enabling analytics and reporting. Built dashboards and reports using Power BI, enhancing data-driven decision-making.

BI Specialist

Consulting
Reengineered Power BI data models to improve performance and reduce refresh times. Enhanced Power BI dashboards for risk scoring and fraud detection.

Data Specialist

Zalando SE, Berlin
Developed and managed ETL pipelines, enabling efficient data processing and reporting. Created dashboards and visual reports to present insights and trends for business teams.

Data Specialist

Industrial Services
Designed and developed ETL processes to consolidate data from multiple ERP systems. Ensured data quality by validating input data and automating validation processes.

External Data & Analytics Consultant

Consulting
Designed and developed data warehouse and analytics solutions to support audit processes. Supported migration to automated CI/CD deployments for data analytics applications.

Data Specialist

Consulting
Designed and developed data pipelines to analyze large datasets and generate business insights. Built automated ETL processes and worked with stakeholders to define actionable business intelligence reports.

Technology Manager

Orion Innovation, Berlin
Led ETL migrations from on-premises to Azure Cloud. Designed Power BI dashboards and SSAS data models for business intelligence initiatives.

Senior Software Engineer

IT Consulting
Led development of web applications using AngularJS, ASP.NET, and SQL Server. Created front-end UI designs and back-end logic for key web applications.

Senior Software Engineer

Orion Innovation, Mumbai
Developed web applications using AngularJS, ASP.NET, and SQL Server. Reviewed code, mentored team members, and supported requirement analysis with clients.

Associate Engineer

IT Consulting
Developed and maintained web and desktop applications using .NET technologies. Acted as technical lead for multiple projects and implemented security enhancements.

Associate Engineer

CMC Limited (now TCS), Mumbai
Developed web and desktop applications using C#, WPF, WCF, and SQL Server. Designed secure application architectures with failover and load balancing features.

Kontaktanfrage

Einloggen & anfragen.

Das Kontaktformular ist nur für eingeloggte Nutzer verfügbar.

RegistrierenAnmelden