Shrinivas Masam

Experience

• 

  IBIS SYSTEM & SOLUTION PVT. LTD.

  Feb 2011 - Aug 2014

  SQL Developer
• 

  ABYSS AND HORIZON CONSULTING PRIVATE LIMITED

  Sept 2014 - Mar 2015

  Software Engineer
• 

  TechProcess Payment Services (Part of Ingenico Group)

  Mar 2015 - Aug 2016

  Engineer Analytics
• 

  Capgemini

  Aug 2016 - Jan 2019

  BI Developer
• 

  Trigyn Technologies

  Jan 2019 - Sept 2019

  MSBI Developer
• 

  LTIMindtree

  Oct 2019 - Feb 2025

  • Automating all ETL processes for all the operational source system like NB Dynamics CRM, PolicyAdmin (Wave), CPLUS, QCommision, etc. in such a way that no manual intervention is required.• Automating IT built audit and control procedures to ensure data completeness and accuracy.• Automating business-driven reasonability checks to boost end-user confidence in the data.• Refreshing all data like policy, claims, reinsurance, cashflows, QCommision, etc. data on a daily or monthly basis based on business requirement.• Providing data for analysis at the most granular level.• Involved in Designing, Developing and Testing of the ETL strategy to populate the data from various source systems feeds using SSIS and Azure Data factory. • Created databases and schema objects including tables, views and applied constraints according to the requirements of the project. • Involved in creating Source to Target mapping sheet.• Designed ETL packages dealing with different data sources (SQL Server) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS). • Deployed package successfully on Integration Service Catalogue. • Provide analysis & solution to the complex requirements • Development of Azure Data factory pipelines using snowflake procedures or SQL scripts.• Migration SSIS on premises to Azure data Factory (Cloud).• Similarly converted SQL queries to Snowflake queries as part of our migration project. • Supporting QA in understanding the functionality.• Providing Build and Release using TFS to QA.• Troubleshooting and Bug fixing. Show less

  • Senior Data Engineer

    Jan 2024 - Feb 2025

  • Senior Data Engineer

    Feb 2022 - Dec 2023

  • Data Engineer

    Oct 2019 - Feb 2022
• 

  Apollo Global Management, Inc.

  Feb 2025 - now

  Associate Director