Prajwal Dp

About Prajwal Dp

I am a multi‑skilled Data Engineer with 4.5+ years of experience specializing in Business Intelligence, Data Warehousing, SQL Development, and Azure Cloud. I work across both on‑premises and cloud platforms, helping organizations transform raw data into reliable, high‑value insights.My expertise spans data governance, data modelling, ETL/ELT engineering, data quality, and database administration. I’ve delivered impactful solutions in the Insurance and Banking domains, working closely with business and technical teams to design scalable data architectures and analytical solutions.In my role, I acquire and integrate data from diverse systems, build and optimize pipelines, create validation frameworks, and ensure end‑to‑end data accuracy. I have also contributed to major SQL Server upgrades, data warehouse migrations, and Azure transitions, ensuring secure, compliant, and high‑performance environments.I bring strong experience in IT Service Management, coordinating infra upgrades, managing BI application migrations, and ensuring smooth delivery across Production and Test landscapes. My work includes solution design, root‑cause analysis, stakeholder collaboration, and continuous improvement of BI platforms.Technologies-* MS SQL server* MS Analytics Platform System (AP/PDW)* MS SQL Server Integration Services (SSIS)* Azure DevOps ServerTools-* SSMS (Sql server Management Studio)* TOAD (Tool for Oracle Application Developers)* Visual studio* Azure Data Studio* Tivoli Workload SchedulerData models -* IBM IIW* Anchor Model* Snowflake model* Star Schema modelSDLC-* Waterfall* Agile* SAFe

Experience

1. Associate Consultant Sql Developer

   Capgemini

   Apr 2023 — Present · Bengaluru, IN

   Designed and developed end-to-end data pipelines using SQL Server, SSIS, and APS/PDW for scalable data warehousing needs.Performed database administration tasks including backup/restore, performance tuning, indexing, and security.Executed platform upgrade and migration projects, including SQL Server version upgrades and OS migrations.Led data migration efforts from on‑prem to Azure SQL, ADF pipelines, and cloud services, ensuring zero data loss.Worked on IBM IIW, Anchor Model, Star/Snowflake schema for enterprise data warehouse architecture.Automated job scheduling and monitoring using Tivoli Workload Scheduler and Azure DevOps pipelines.Collaborated with clients for requirement understanding, design walkthroughs, and BI/ETL solution alignment.Provided L2/L3 support, resolving critical issues, performance bottlenecks, and production incidents.Participated in SAFe and Agile ceremonies, sprint planning, and cross-team coordination.

Education

• Green Wood English School

  SSLC

• Maharaja PU College ,Mysore

  PCMC

• NDRK College ,Hassan

  Bachelor of Engineering - BE, Mechanical Engineering