Ajay Kumar Deekonda - Senior BI and Analytics Engineer

Q: Where is Ajay Kumar based?

Ajay Kumar is based in Erlangen, Germany and prefers 100% remote projects.

Q: What languages does Ajay Kumar speak?

Ajay Kumar speaks the following languages: English (Native), German (Elementary) .

Q: How many years of experience does Ajay Kumar have?

Ajay Kumar has at least 13 years of experience. During this time, Ajay Kumar has worked in at least 5 different roles and for 5 different companies . The average length of individual experience is 3 years and 8 months . Note that Ajay Kumar may not have shared all experience and actually has more experience.

Q: What is Ajay Kumar's latest experience?

Ajay Kumar's most recent position is Senior BI and Analytics Engineer at Novartis .

Q: What companies has Ajay Kumar worked for in recent years?

In recent years, Ajay Kumar has worked for Novartis and Capgemini .

Q: Which industries is Ajay Kumar most experienced in?

Ajay Kumar is most experienced in industries like Pharmaceutical , Healthcare , and Information Technology . Ajay Kumar also has some experience in Professional Services .

Q: Which business areas is Ajay Kumar most experienced in?

Ajay Kumar is most experienced in business areas like Business Intelligence and Information Technology .

Q: Which industries has Ajay Kumar worked in recently?

Ajay Kumar has recently worked in industries like Information Technology , Professional Services , and Pharmaceutical .

Q: Which business areas has Ajay Kumar worked in recently?

Ajay Kumar has recently worked in business areas like Business Intelligence and Information Technology .

Recommended expert

Erlangen, Germany

Check rate

Experience

Mar 2024 - Present

2 years 5 months

Erlangen, Germany

Senior BI and Analytics Engineer

Novartis

Led enterprise reporting modernization by migrating legacy SSRS reporting solutions to Power BI, supporting 500+ business users while ensuring full GDPR/DSGVO compliance.
Designed and optimized Power BI and Microsoft Fabric semantic models using star schema, dimensional modeling, advanced DAX, and performance optimization techniques, reducing query latency by 25%.
Delivered 20+ executive and operational dashboards featuring KPI scorecards, drill-through, bookmarks, and row-level security, improving reporting efficiency by 20%.
Enabled self-service analytics through governed Power BI datasets, dataflows, and gateway architecture, increasing business-led reporting adoption by 35%.
Configured an incremental refresh policy and query folding for a 50+ million row sales dataset, reducing daily report refresh times by 85%.
Deployed automated ETL/ELT pipelines using Azure Data Factory, Microsoft Fabric, and Snowflake, reducing reporting delivery timelines by 40% through workflow automation.
Spearheaded Microsoft Fabric analytics modernization initiatives including lakehouse architecture, OneLake integration, and centralized data platform development, reducing data latency from 2 hours to 20 minutes.
Translated business requirements from 15+ stakeholders into scalable Power BI semantic models and dashboards, improving reporting consistency and reducing ad-hoc reporting requests by 25%.
Applied Microsoft Copilot and generative AI tools to accelerate SQL development, DAX authoring, technical documentation, and testing activities, reducing development effort by approximately 15 hours per week.

Dec 2020 - Mar 2024

3 years 4 months

Hyderabad, India

Senior Data and BI Engineer

Capgemini

Developed 57+ advanced DAX measures using CALCULATE, SUMX, and time intelligence functions, improving reporting efficiency and contributing to estimated client savings exceeding €645K across multiple engagements.
Integrated 45+ enterprise data sources and APIs into 90+ Power BI reports via Power Query M transformations and T-SQL rewrites, raising reporting accuracy by 25%.
Built executive KPI frameworks and semantic models (star schema, CALCULATE, time intelligence, filter context) for a €1.2M project portfolio, accelerating leadership decision-making by 20%.
Engineered enterprise data pipelines using Informatica Power Center, Azure Data Factory and cloud-based ELT patterns, automating the ingestion of 2 TB+ of data to support analytics across 4 business domains.
Implemented enterprise CI/CD and deployment pipelines across dev, test, and prod environments using Fabric and Azure DevOps, accelerating release cycles by 30% and reducing deployment errors by 40%.
Transformed complex DAX measures, semantic models, and report performance using DAX Studio, Tabular Editor, VertiPaq Analyzer, and Performance Analyzer, reducing dashboard render times by over 30%.

Feb 2020 - Nov 2020

10 months

Career Break

Career break

Focused on advanced training in Microsoft Azure, Power BI, cloud data platforms, and analytics engineering technologies during the global COVID-19 period.

Nov 2017 - Jan 2020

2 years 3 months

Hyderabad, India

Senior BI Developer

ICON Clinical Research

Migrated 30+ SAP BusinessObjects reports to Power BI and Tableau, reducing report maintenance effort by 35% and improving dashboard adoption across global clinical teams.
Translated 12+ complex business requirements into SAP BO technical specifications, setting project milestones that improved on-time delivery by 22%.
Administered 10+ SAP BO universes (IDT/UDT, aggregate awareness, contexts) connecting Oracle, SQL Server, and SAP BW/HANA, serving 500+ global clinical users for Novartis.

Mar 2013 - Nov 2017

4 years 9 months

Hyderabad, India

SAP Business Objects Developer

PAREXEL International

Directed SAP BusinessObjects XI 3.1 to BO 4.2 migration of 60+ reports and universes with zero production incidents across clinical and financial reporting.
Boosted SAP BO universe performance by 30% via aggregate awareness, contexts, and OLAP query tuning for enterprise clinical reporting.
Established 4+ years of deep SAP BO expertise (Infoview, Web Intelligence, BI Launchpad, CMC) integrating IMPACT, Rave Medidata, and EDC data sources for global clinical trial operations.

Industry Experience

See where this freelancer has spent most of their professional time.

Experienced in Pharmaceutical, Healthcare, Information Technology, and Professional Services.

Pharmaceutical

Healthcare

Information Technology

Professional Services

Business Area Experience

See which departments and functions this freelancer has contributed to most.

Experienced in Business Intelligence and Information Technology.

Business Intelligence

Information Technology

Summary

Senior BI & Analytics Engineer with 12+ years of experience delivering enterprise reporting, semantic modeling, and analytics solutions across pharmaceutical, life sciences, retail, and financial services organizations. Expert in Power BI, Microsoft Fabric, DAX, SQL, Azure Data Factory, SAP Analytics Cloud, and SAP BusinessObjects modernization. Delivered reporting platforms supporting 500+ users, optimized Power BI performance by up to 85%, and built governed self-service analytics environments aligned with GDPR requirements. Experienced in migrating legacy SAP BO, SAP BW, and SSRS ecosystems to modern cloud-based analytics platforms while partnering with business and technical stakeholders.

Skills

Analytics & Bi: Power Bi, Dax, Power Query (M), Semantic Models, Tabular Models, Star Schema, Data Modeling, Kpi Reporting, Paginated Reports, Power Bi Service.
Microsoft Fabric: Onelake, Lakehouse, Data Warehouse, Direct Lake, Dataflows Gen2, Deployment Pipelines, Fabric Capacity.
Data Engineering: Sql, T-Sql, Python, Pyspark, Azure Data Factory, Etl, Elt, Data Pipelines, Delta Lake.
Cloud & Enterprise Platforms: Microsoft Fabric, Azure, Snowflake, Sap Bw/Hana, Sap Analytics Cloud, Sap Businessobjects.
Governance & Delivery: Azure Devops, Git, Ci/Cd, Row-Level Security, Gdpr/Dsgvo, Data Governance, Jira, Confluence, Agile, Scrum, Stakeholder Management.

Languages

English

Native

German

Elementary

Education

Aug 2002 - Jul 2007

Jawaharlal Nehru Technological University

Bachelor of Technology · EEE · Hyderabad, India

Certifications & licenses

Microsoft Certified: Azure Data Engineer Associate (DP-203)

Microsoft Certified: Azure Enterprise Data Analyst Associate (DP-500)

Microsoft Certified: Power BI Data Analyst Associate (PL-300)

Statistics

Experience

Total positions 5

Experience in Pharmaceutical 9 y

Avg length 2 y 8 m

Longest experience 4 y 8 m

Global Experience

Countries worked in 2 (India, Germany)

Primary country India

Expertise

Recent roles Senior BI and Analytics Engineer, Senior Data and BI Engineer, Career Break

Main industries Pharmaceutical, Healthcare, Information Technology

Main business areas Business Intelligence, Information Technology

Qualifications

Highest degree Bachelor

Certifications earned 3

Profile

Created

July 2026

Need a freelancer? Find your match in seconds.

Try FRATCH GPT

Frequently asked questions

Have questions? Find more information here.

Where is Ajay Kumar based?

Ajay Kumar is based in Erlangen, Germany and prefers 100% remote projects.

What languages does Ajay Kumar speak?

Ajay Kumar speaks the following languages: English (Native), German (Elementary).

How many years of experience does Ajay Kumar have?

Ajay Kumar has at least 13 years of experience. During this time, Ajay Kumar has worked in at least 5 different roles and for 5 different companies. The average length of individual experience is 3 years and 8 months. Note that Ajay Kumar may not have shared all experience and actually has more experience.

What roles would Ajay Kumar be best suited for?

Based on recent experience, Ajay Kumar would be well-suited for roles such as: Senior BI and Analytics Engineer, Senior Data and BI Engineer, Career Break.

What is Ajay Kumar's latest experience?

Ajay Kumar's most recent position is Senior BI and Analytics Engineer at Novartis.

What companies has Ajay Kumar worked for in recent years?

In recent years, Ajay Kumar has worked for Novartis and Capgemini.

Which industries is Ajay Kumar most experienced in?

Ajay Kumar is most experienced in industries like Pharmaceutical, Healthcare, and Information Technology. Ajay Kumar also has some experience in Professional Services.

Which business areas is Ajay Kumar most experienced in?

Ajay Kumar is most experienced in business areas like Business Intelligence and Information Technology.

Which industries has Ajay Kumar worked in recently?

Ajay Kumar has recently worked in industries like Information Technology, Professional Services, and Pharmaceutical.

Which business areas has Ajay Kumar worked in recently?

Ajay Kumar has recently worked in business areas like Business Intelligence and Information Technology.

What is Ajay Kumar's education?

Ajay Kumar holds a Bachelor in EEE from Jawaharlal Nehru Technological University.

Does Ajay Kumar have any certificates?

Ajay Kumar has 3 certificates. These include: Microsoft Certified: Azure Data Engineer Associate (DP-203), Microsoft Certified: Azure Enterprise Data Analyst Associate (DP-500), and Microsoft Certified: Power BI Data Analyst Associate (PL-300).

What is the availability of Ajay Kumar?

Ajay Kumar is immediately available full-time for suitable projects.

What is the rate of Ajay Kumar?

Ajay Kumar's rate depends on the specific project requirements. Please use the Meet button on the profile to schedule a meeting and discuss the details.