Dushyanth Ramisetty

Experience

• 

  HCL Technologies

  Oct 2014 - Nov 2016

  Client owned Guidewire ClaimCenter product to power their business to optimize their operations, increase engagement and to drive smart decisions. So, it was aimed to migrate whole Claims data from legacy system to Guidewire ClaimCenter operational tables.Roles & Responsibilities:  Worked in Landing to Target Conversion & data quality frameworks Handled complex transformation logics using T-SQL Developed sophisticated reconciliation framework along with a team of 3. Prepared final Reconciliation reports which will be presented to clients Have experience in fixing the ClaimCenter load errors during data migration Performed thorough data analysis to identify data migration risks in the early stage of project Assist the team in understanding the business requirements Show less  Make efforts to understand the business needs and designs the programs accordingly Has developed complex ETL mappings for ClaimCenter prestaging entities using Informatica Power Center 9.x Performed Extensive Unit testing & debugging the developed mappings Involved in creating technical documentation in the work assignments Played a crucial role in Data migration production phase Involved in data cleansing and masking the Legacy data. Trained in building solutions for Guidewire Data Hub using ETL tools. Show less

  • ETL Developer

    Nov 2015 - Nov 2016

  • ETL Developer

    Oct 2014 - Nov 2015
• 

  EY - Guidewire Data Management Practice

  Nov 2016 - Mar 2020

  Client owned Guidewire ClaimCenter product to power their business to optimize their operations, increase engagement and to drive smart decisions. So, it was aimed to migrate whole Claims data from legacy system to Guidewire ClaimCenter operational tables.It was aimed to integrate ClaimCenter to a Third-party system NETREVEAL which is technology platform for compliance and fraud that drives speed and efficiency and combines the best of advanced analytics and human expertise.Aimed to do Claims predictive analytics POC as this is the first implementation in UKRoles & Responsibilities:  Interacting with Clients on Solution design as per the business requirement Analysed legacy data designed and developed 50% ETL mappings overall in SAP BODS/Data services 4.2 to perform Claim Center intermediate staging load. Analysed and Fixed Integrity, Reconciliation and Legacy consistency issues.  Worked as technical architect for Migration End to End Control Job & Batch framework which automated 70 % migration process Involved in technical design for all CC Entities as a lead developer from onshore in scope for migration. Involved in preparing LLD, Batch and Audit framework, Attribute & Type List mapping docs. Involved in creating BODS batch job to track the Performance and introduced a special error handling mechanism which was not followed in any CC migration implementation so far. Show less Roles & Responsibilities:  Analysed legacy data designed and developed 50% ETL mappings overall in SAP BODS/Data services 4.2 to perform Claim Center intermediate staging load. Worked on Guidewire System Tools and Table import batch commands. Analysed and Fixed Integrity, Reconciliation and Legacy consistency issues.  Involved in creating BODS batch job to track the Performance and introduced a special error handling mechanism which was not followed in any CC migration implementation so far. Generated 3 migration related accelerator ideas, designed and implemented the same which saved almost 200+ hours in a 12-sprint project. Worked in Data Integration of CC with third party system NETREVEAL which is a technology platform for compliance and fraud. Worked in Predictive analytics POC as this is the first implementation in U.K Show less

  • Data Migration Consultant

    Oct 2018 - Mar 2020

  • Senior ETL Developer

    Nov 2016 - Oct 2018
• 

  Vertafore

  Mar 2020 - Oct 2021

  Data Integration Specialist

  Working with Insurance Brokers to integrate their Management systems like AMS360, EPIC, Sagitta & TAM to RiskMatch to power their business by increasing their growth opportunities, To Monitor Agency Relationship overtime with Carriers etc.Roles & Responsibilities:  Interacting with Clients during Data walkthrough call to gather Data Integration requirements Analyzed Agency data like and wrote Assembler code (In MySQL + Groovy) which extracts the Agency data and generates Canonical XML which is followed by Dataflow run to push XML data to Risk Match Does data True-up process for every Agency post Data Integration with RiskMatch by comparing Agency Product Report and RiskMatch dashboard Enhanced SQL queries which generate Data Quality Reports for Insurance Agencies Involved in preparing Metrics doc to present Clients with the Onboarding process for their respective systems. Expert in Data Integration for Top 5 Agency Management systems like AMS360, EPIC, Sagitta, TAM and HawkSoft in USA Show less

• 

  ZENSAR TECHNOLOGIES (UK) LIMITED

  Oct 2021 - now

  Senior Developer