Prabir Sahoo

• Led the design and development of TSDS (Strategic Data Store) for marketing and trade surveillance applications using the Big Data Hadoop platform.
• Spearheaded end-to-end development, including SUNRISE activities to successfully launch the TSDS application from scratch.
• Managed and mentored a high-performing Big Data engineering team, fostering a collaborative and delivery-focused work environment.
• Successfully productionized the TSDS platform, enabling real-time data delivery to critical surveillance systems.

• Developed and optimized robust ETL pipelines leveraging Apache Spark and Scala, ensuring seamless data integration from internal and external sources.
• Managed data ingestion processes on Amazon S3, orchestrating data from flat and parquet files into stage tables for efficient downstream processing.
• Executed data mastering techniques for customer data loading into Reltio platform, enhancing data quality and accessibility.
• Collaborated with cross-functional teams to extract and publish client reporting data from CDW Hive tables, aligning with business intelligence needs.
• Led initiatives to improve data processing layers, including Stage, ETL, and publish fact tables, optimizing system performance.
• Led an offshore development team, conducted root cause analysis (RCA) for production issues, and implemented timely fixes.
• Maintained comprehensive design documentation, conducted code reviews, and mentored junior team members to build technical capacity

• Managed the client's enterprise Data Warehouse for Reservations & Bookings, ensuring data availability, integrity, and timely reporting.
• Designed and developed robust SSIS ETL pipeline, optimizing data extraction, transformation, and loading processes.
• Identified and resolved ETL performance bottlenecks, implementing solutions to improve system efficiency and reliability.
• Automated manual reporting tasks, significantly improving productivity and reducing operational overhead.
• Monitored production systems and ensured consistent data availability for reporting applications.
• Performed performance tuning of complex Oracle SQL queries and delivered innovative solutions to improve data processing speed.

• Developed efficient stored procedures /Packages for seamless data retrieval and manipulation, increasing application response time. as per the requirement.
• Contributed to successful project completion by adhering to strict deadlines and meeting client requirements.
• Maintained database documentation for accurate record-keeping and easy reference for colleagues.
• Streamlined data migration processes by developing SSIS ETL tools tailored to specific project requirements.
• Automated tasks with the help of shell scripts, boosting team productivity.

Worked as Electronics and Automation program engineer for developing PLC and SCADA programming.