Summary
Overview
Work History
Education
Skills
Work Availability
Timeline
Generic
Sonu Sangam

Sonu Sangam

Lead Software Engineer
Bengaluru

Summary

Dedicated professional with 11+ years of experience in Leading & Delivering projects in Data engineering and Data Warehousing field using Bigdata technologies. Skilled in directing development with creative and performance-oriented approach. Well-organized and customer-focused with proven skills in project management and team leadership.


Overview

11
11
years of professional experience
4
4
years of post-secondary education

Work History

Lead Software Engineer

Epsilon
Bengaluru
08.2019 - Current
  • Designed & developed robust Data Privacy Platform to meet the Privacy requirement - CCPA & CPRA for the company.
  • Currently leading & mentoring team of Big Data Engineers to scale up the Data Privacy Platform and to migrate the Data Privacy Platform to AWS cloud.
  • On Data Privacy Platform we onboard multiple Data assets. PySpark Jobs are executed to load the data assets and to cater the reporting need of the Project. On DPP we also handle opt-out and delete request of the users. DPP is fully automated using StreamSets. Tech stack of the Project includes StreamSets, Hadoop, PySpark, HIVE, Oracle Database, Oracle BI Publisher.
  • Created Data Pipelines in StreamSets to pull data from various sources like AWS S3, Salesforce, Database and implemented event-based solutions using StackStorm, Python, REST API’s.
  • Created data models and developed descriptive metadata schemas to meet functional and technical requirements.

Senior Consultant

Oracle
Bengaluru
09.2017 - 08.2019


  • Lead the team on Data Warehouse Migration project for Outokumpu. Oracle warehouse builder was replaced by Oracle Data Integrator as an ETL tool. We used migration utility provided by Oracle to convert OWB artifacts into ODI objects and developed mappings which couldn't be migrated, and we also developed new set of mapping to meet client's requirement. We conducted SIT, UAT and prod deployment.
  • Troubleshot issues by understanding issue, diagnosing root cause and coming up with effective solutions.

Consultant

KPMG
Bengaluru
01.2015 - 09.2017
  • As Management consultant, worked for Client - Grameenphone, A Telenor Subsidiary in Bangladesh on Grameenphone Enterprise Data Warehouse project.
  • Performed requirement gathering, project estimation, data modelling and developed ODI mappings & Packages, PLSQL procedures to load data in Data warehouse to meet client’s reporting requirement.
  • As Management consultant, worked for Kuwait National Petroleum Company, Kuwait to develop Data Warehouse for their Performance Excellence & Reporting Online (PEARL) application which was used by senior management to track the performance of various Divisions & Department of their company. We had also built scorecards & dashboard, which was directly used by Department heads, Deputy CEO & CEO of KNPC.
  • Delivered outstanding service to clients to maintain and extend relationship for future business opportunities.

Associate IT Consultant

ITC Infotech
Bengaluru
09.2011 - 12.2014
  • Worked on the development of Data warehouse for Sri Lankan Airlines using Oracle data Integrator, Oracle database.

Education

Bachelor of Engineering - Electronics And Communications Engineering

CMR Institute of Technology
Bengaluru
09.2007 - 06.2011

Skills

Agile

undefined

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Timeline

Lead Software Engineer

Epsilon
08.2019 - Current

Senior Consultant

Oracle
09.2017 - 08.2019

Consultant

KPMG
01.2015 - 09.2017

Associate IT Consultant

ITC Infotech
09.2011 - 12.2014

Bachelor of Engineering - Electronics And Communications Engineering

CMR Institute of Technology
09.2007 - 06.2011

Similar Profiles

CREATE PROFILE
Sonu SangamLead Software Engineer