Sambit Sourav

RPCDF(Regional Projects Cost Data Foundation)

• Took transition of 1.1 million dollar project single handedly from Deloitte, completed remaining development(30%) and sustained it for 1 year whilst in production
• Lead and managed the project alone, keeping all stakeholders on the same page.
• Aggregating and standardizing data of all cost related data to create analytics - Planview, CDMS, SAP, Primavera by creating reports with SQL queries and joins
• Create Data Quality pipelines with Spark and DataBricks
• Maintaining and automating scheduling pipelines, implementing dimension logics like SCD1, SCD2 with ADF for historical changes.
• tailoring the Data model from OLTP to OLAP in snowflake and PowerBi to address to faster analytics demands
• Tools used – Snowflake, SQL, Azure, ADF, Power Bi, Azure technologies and ABC procfwk

EPCDF(Engineering project Cost Data Foundation)

• Aggregating unstructured data or excel sheets into from EPCs, creating recipes in Alteryx or Azure Data Factory, Snowflake, Sigma or PowerBi
• Devising strategies to isolate business logic layer and data layer to create a sustainable product lifecycle and manage resource effectively
• Proactively participated in technical assessment of vendor/tools for the same - Foundry (Palantir), Hexagon Smart Completion, Aveva, Aconex by Oracle etc
• Involved in hiring business data analysts, creating JDs and conducting interviews
• Generated detailed studies on potential third-party data handling solutions, verifying compliance with internal needs and stakeholder requirements.
• skills used - ETL with Alteryx and Azure Data Factory (ADF), vendor selection, conducting interviews, Sigma, PowerBi, Snowflake, Blob storage, Aconex by Oracle, Data Modelling, Data Governance, SQL

EMMA (ExxonMobil market Research Analytics Tool)

• migration from On-Prem to Azure
• Reverse engineered the legacy application's data flow, created visio diagram and lead the migration solely
• Decoupling the WPF application and migrating databases and SSIS jobs into ADF
• Deploying integration runtime, VPNs, Azure SQl databases and blob storages
• Lead the migration project by creating solution diagram, planning the work, estimating timeline using Agile methodology
• skills used - SSIS, Azure integration runtimes, C#, SQL
• Data Models- Reverse engineer vendor applications and develop data models. Ex- Aconex
• Vulnerability remediation to access SQL DBs with VPNs and AD groups to support RBAC
• Other responsibilities:
• Migrating Mulesoft (an API Integration platform) to Azure functions using C# and PGP encryption
• Migrating TFS/ADO repos to Github and create CI/CD pipelines in Github Actions
• Assist in risk assessments, create RASCI charts for support and security models of vendor applications
• Understanding Processes, Security and Compliances to contribute in matured SDLC lifecycle.

Azure Subscription Owner

• Advise and monitor subscriptions and present faster, cheaper, secured and robust solutions to development teams at regular intervals

ABB Ability Analytics Platform (1 yr 8 months) - Industrial IoT 4.0

• Creating machine learning models for time series data like ARIMA, LSTM and regression models. Solving classification problems with models like KNN and XGBoost, Random Forests. Worked on deep learning model-CNNs framework for detecting helmets in factories for safety.
• C# based inference runtime framework to host ML models in Kubernetes and send data and retrieve results from the same using Azure Service Bus, Az storage explorers, Az DataBricks, Kubernetes, schedule triggers
• Writing unit tests and functional tests in C#, improving code quality with SonarCube and UAT testing. Also developed features and fixed bugs.

ABB Ability Edge (6 months)

• C#, Shell scripts for bootstrapping, Mosquitto MQTT Broker for messaging and Docker Swarm based Edge framework to support data ingestion from IOT devices to cloud)
• leading feature development like module communication on local topics, file transfer, fallback for IOT Hub queue stuck and bug fixing of Ability Edge framework built on C# and MQTT broker along with Azure Service Bus, IOT Hub
• KT for use of PYTab(python in Tableau) to facilitate python SDKs in tableau and use Kibana to plot real time analytics on logs along with ELK stack
• Agile and scrum- Scrum master of team with 10 members
• Facilitated the use of RACI analysis, competency matrix for better tracking and management of resources
• Responsible for feature, epic level planning, sprint planning and sizing, retrospective and closure of stories with QA test
• Facilitated FDD, BDD and pair programming at different occasions
• Initiate open source scan with BlackDuck, check code quality with SonarCube and MCSR for open-source components
• Documentation- UML diagrams- architectural, sequence and class diagrams in Ms Visio
• Private and public release documentation, costing, FAQ listing and technical documentation in Azure Wiki and SharePoint
• Publicity- Owner of ABB Analytics User group which targets knowledge sharing and awareness of analytics group inside ABB

LEAF - lightweight Edge Analytics Framework

• Deploy docker containerized ELK(ElasticSearch, Logstash, Kibanna) stack and connecting lightweight pre-trained ML models for fast and accurate predictions on low computing devices. example - Descriptive analytics on Energy usage consumption

• A technical internship which introduced me to the world of cybersecurity, azure and machine learning
• Developed a POC to monitor real time network traffic and pass it through a ML model deployed in Azure
• The model was trained on CICIDS 2017 dataset and with Decision tree, data wrangling and recursive feature elimination, the accuracy score was 78% to predict different types of attack
• Developed a POC with C# and Windows services for cyber asset management team that was hosted in Docker container and sent system data like CPU, drive space, RAM details every 5 mins

• Using Infragistics to create a WPF (Windows Presentation Foundation) project with multi series plots along with dashboards and tables
• Completed research, compiled data, updated spreadsheets, and produced timely reports.
• Sorted and organized files, spreadsheets, and reports.

• Explored various ways to record the attendance of garbage collectors associated with the company in various locations in Bengaluru using apps, GPS devices and calculate the operational and developmental costs for the same
• Generate leads for sales team by contacting various communities and restaurants to sign up for smart waste management options
• Competitor analysis and market research of various solar distributors across Bengaluru with different solutions so as to find the optimum price and create an opening strategy
• Help ops team in route optimization of garbage trucks to travel across different pick up locations and optimize time and cost.