Sagar Shirwalkar

Client: A major international bank (Area: Investment Banking, Market Risk). Projects:

• Migration of legacy code from old C# .NET 4.8 services to Java / Spring Boot and Python-based services.

• Migration of business reporting logic workflows from legacy systems due to be decommissioned to new C# .NET and pySpark based services.

• Modernization of the secrets management system, and migration of secrets management vaults from a legacy system to HashiCorp.

Part of the BlueMarble DBSS product unit at a telecom product company. Projects:

• Developed microservices for migrating customer engagement data and order management APIs from existing legacy monoliths.

• Set up schema migration and automated data migration to microservice-coupled databases with Liquibase and Debezium.

• Developed APIs for consolidating data for analytics dashboard components related to billing data.

Projects:

• Java Microservices for converting importer data to the EDIFACT interchange data format, used in subsequent secured communications with the Canadian Border Services Agency.

• Created libraries for country-agnostic EDI parsing and generation, usable with any international customs agency and any

EDI flavor, by creating a custom DSL for interfacing.

• A record management microservice for billing, audit, compliance, and analytics.

Projects:

• Developed and maintained end-to-end data ingestion pipelines with Talend Open Studio to streamline data flow.

• Designed and deployed the first data warehouse for the team, addressing delays in the client's MDM project. OLAP

oriented, with Star and Snowflake schema hybrids.

• ML models for estimating Customer Lifetime Value (CLTV) and Churn prediction to enhance client insights.

• Built Power BI dashboards for effective reporting, improving data accessibility for stakeholders.

Projects:

• Created and deployed an AI chatbot assistant which analyzes messages between our B2B customers and their clients. • ML models for customer churn prediction and lead scoring. • Made dashboards for tracking KPIs for several internal teams, and identified process bottlenecks and opportunities for improving productivity.