Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Pravash Ranjan Sahoo

Azure Data Engineer
Bangalore

Summary

Results-driven Data Engineer with 9 years 10 months of experience specializing in cloud-based data solutions and advanced data processing. Proficient in Azure Databricks, Database, Data Modeling and Azure Data Factory, with a strong track record of designing and implementing scalable, high-performance data pipelines. Strong analytical skills complemented by effective communication fostered collaboration and aligned technical strategies with business objectives.

Overview

10
10
years of professional experience
3
3
Certifications

Work History

Technical Manager

PricewaterhouseCoopers Private Limited
06.2019 - Current
  • Worked on a supply chain project for an FMCG client, handling data related to inventory, service, factory production, material management, flare, and logistics.
  • Led a team of data engineers in delivering end-to-end data solutions across multiple Azure services including Azure Data Factory, Azure Synapse Analytics, Azure Data Lake, and Azure Databricks.
  • Spearheaded full lifecycle project delivery—from requirements gathering and solution design to implementation, deployment, and support—for critical supply chain analytics and reporting platforms.
  • Designed and developed robust ETL pipelines using PySparkto process large volumes of structured and semi-structured data from various sources
  • Implemented data Ingestion, data cleaning and data transformation logic using PySpark DataFrames and Spark SQL to deliver clean, validated, and business-ready.
  • Database Developer with expertise in creating objects, complex optimized SQL logic and performance tuning for efficient data extraction and optimization.
  • Extensive experience in data warehousing encompassing schema design, data modeling with star and snowflake schemas, building data staging areas, and integrating advanced analytics to enable robust reporting and analysis.
  • Designed and developed end-to-end ETL pipelines using Azure Data Factory and Informatica for multiple data sources to enable accurate reporting and analytics.
  • Utilized Azure Data Factory to orchestrate complex workflows and automate data movement across cloud environments.
  • Familiar with Power BI for creating interactive dashboards and visual reports based on transformed data
  • Managed project operations, led pre-sales engagements for multiple clients, and coordinated hiring of resources for Data Engineering and Data Analyst projects.

Data Analyst

IBM India Pvt. Ltd.
11.2018 - 04.2019
  • Worked as a Data Analyst in the Strategy & Planning team, leveraging DB2 to create database objects and develop complex SQL queries.
  • Focused on data performance optimization, ensuring efficient data retrieval and supporting strategic decision-making through analysis.
  • Served as Scrum Master, facilitating Agile ceremonies and ensuring smooth sprint execution through backlog management and team coordination.
  • Managed Jira ticket creation and tracking to oversee development tasks, bug fixing with the testers, product planning, prioritize work, and support continuous improvement.

Software Engineer

CenturyLink Technologies India Pvt. Ltd.
06.2016 - 11.2018
  • Worked for a U.S.-based telecom client, creating and managing databases to support data integrity and reporting needs.
  • Responsible for developing the database code, ETL pipeline using informatica, data warehouse management and reporting using QlikView .
  • Analyzed and closed UAT defects based on client requirements to ensure application quality and functionality.
  • Contributed to application stabilization by resolving issues promptly and supporting smooth post-UAT transitions.

Associate Technical Analyst

Oracle Financial Services Software Limited
02.2016 - 04.2016
  • Provided application support for the Flexcube banking software, resolving issues and ensuring seamless system performance.
  • Analyzed issue and bug tickets previously assigned, identifying root causes and impact.
  • Collaborated with cross-functional teams to troubleshoot, analyze, and implement solutions for smooth banking operations.
  • Monitored ticket progress and followed up to maintain efficient turnaround times.

Principal Coordinator

Quess Corp Limited
10.2015 - 01.2016
  • Worked as a Support Engineer for a leading USA-based credit card provider, handling customer technical queries.
  • Wrote SQL queries to fetch, analyze, and validate data from the system for testing purposes.
  • Monitored files in the UNIX environment using Control-M jobs to ensure timely processing and identify any failures or delays.
  • Monitored and supported 24x7 job processes, collaborating closely with the US team to ensure uninterrupted operations and timely issue resolution.

Education

Bachelor of Technology - Electrical & Electronics Engineering

Biju Patnaik University of Technology, Odisha
Bhubaneswar, Odisha, India
04.2001 -

Skills

    Azure Databricks

    Pyspark

    Azure SQL Database

    Azure Synapse Analytics

    Oracle(SQL/PLSQL)

    Azure Analytical Services

    Azure Data Factory

    Informatica

    Python

    Putty

    Agile & SDLC

    Jira & SVM

Certification

Microsoft Certified: Azure Fundamentals (AZ-900)

Timeline

Technical Manager

PricewaterhouseCoopers Private Limited
06.2019 - Current

Data Analyst

IBM India Pvt. Ltd.
11.2018 - 04.2019

Software Engineer

CenturyLink Technologies India Pvt. Ltd.
06.2016 - 11.2018

Associate Technical Analyst

Oracle Financial Services Software Limited
02.2016 - 04.2016

Principal Coordinator

Quess Corp Limited
10.2015 - 01.2016

Bachelor of Technology - Electrical & Electronics Engineering

Biju Patnaik University of Technology, Odisha
04.2001 -

Similar Profiles

CREATE PROFILE
Pravash Ranjan SahooAzure Data Engineer