SATYA MURTY K V

Results-driven Lead Engineer with expertise in SQL optimization, data analysis, and system migration. Demonstrated success in Guidewire ClaimCenter and BillingCenter upgrades, as well as DuckCreek DMS migration. Proficient in enhancing database performance, integrating systems, and driving operational efficiency. Dedicated to delivering high-quality solutions and measurable results while advancing database technologies, and improving overall performance.

• Duck Creek DMS Implementation

US Based Client, 01/22 to present, Duck Creek DMS, SSIS, SQL Server, SSMS, T-SQL, EMC agency management functions are managed through a legacy ADM and Commission systems. As part of the strategic initiative to modernize Agency Management functions, EMC has decided to move to Duck Creek Distribution Management Solution (DMS) from current legacy system., Develop SSIS Packages for New Reports, Supporting the Agency data migration activities specific to DMS needs from respective source systems., Performance tuning of SQL’s., Coordinate with testing team for the defect fixes and retesting of the fixes., Prepare and ensure that all process documents and sign off mails are available for data conversion audit., Provide active participation in the clarification call on daily basis with team to close the open clarification.

• Guidewire BillingCenter Upgrade

 THE HANOVER INSURANCE GROUP, 01/19 to 12/21, SQL Server, SSMS, T-SQL, SSIS, Hanover is an insurance project and the role of Data Conversion team is to upgrade the current Billing Center System from Version 3.x to BillingCenter Version 10.x with existing production database being upgraded from BC3 to BC10. This upgrade happens in two iterations., Leading entire offshore team and took the responsibility of deliverables., Performance tuning of SQL’s., Writing Gosu Triggers for copying the existing production data in case of any data model changes., Working on Guidewire Database Consistency checks that occur during upgrade., Working on Version Check Errors that we get during Upgradation Process., Worked on Guidewire Upgrade Tool to identify major changes across the versions., Coordinate with testing team for the defect fixes and retesting of the fixes., Performance tuning the SQL queries. Moving the Data from prestaging to Staging.

• Guidewire ClaimCenter Data Migration

 QBE, 12/17 to 01/19, SQL Server, SSMS, T-SQL, SSIS, QBE undergoing a transformation with the goal of moving towards a faster, smarter, and more streamlined organization through simplified service delivery to Customers., Define optimal developmental solutions., Co-ordinate with development team to deliver technical solution., Review the developed code., Design ETL flows and Databases., Performance tuning the SQL queries. Moving the Data from prestaging to Staging and involved Code Review., Fixing Integrity Check errors and load data to CC.

• PolicyCenter Migration

Safe Auto, US, 08/16 to 06/17, Senior Developer, SQL Server, T-SQL, SSIS, The objective of project is to migrate all Policies, Billing and Claims maintained in legacy system to Guidewire product., Involved in development of Conversion Framework, Data Migration for Property & Casualty module and involved Code Review, Performance tuning the SQL queries., Moving the Data from prestaging to Staging, Integrity Checking and load data to CC.

• ACES – ClaimCenter Data Conversion

WSIB, Canada, 02/14 to 06/16, Senior Developer, SQL Server, T-SQL, HCL Conversion Framework, The objective of ACES project is to convert all Accounts, Policy, Billing and Claims maintained in legacy system to Guidewire product., Involved in development of Conversion Framework, Data Migration for Worker’s Compensation module and involved Code Review, Performance tuning the SQL queries., Moving the Data from prestaging to Staging, Integrity Checking and load data to CC.

• State Street – MRK

State Street, Japan, 01/12 to 02/14, Senior Developer, As part of the data/system optimization, GPIF has decided to implement a new scheme of MRK (Master Recordkeeping)., Involved in Developing procedures, functions, Packages as per the FSD., Resolving issues as per norms and enabling them to run their business smooth, Providing RCA (Root Cause Analysis), analysis and study of Impact., Oracle 10g, PL/SQL, Toad

• ERP – Receivables Management

ITC, India, 10/10 to 10/11, Developer, The objective of ITC project is to develop ERP for ITC’s Receivables and Payables management., Involved in Analyzing the Defects and fixing it by appropriate changes in product., Unit Testing and Documentation., SQL Server, T-SQL, Ramco Virtual Works

• Passport Number: Available
• Father's Name: ANANDA RAO K
• Gender: Male
• Nationality: Indian
• Marital Status: Married