Venkat Nagaraj Karnati
Associate Architect (Database Specialist)
Hyderabad,Telangana
Summary
- 16+ Years of experience in providing robust database solutions in Insurance, Banking and Retail domains
- Delivered Conceptual Logical and Physical data models for Transactional (OLTP) and Analytical (OLAP) use cases.
- Created strategies, processes and best practices for data governance and delivering quality artifacts.
- Refactored and Tuned latent and Database objects, ETL packages and Reports for substantial performance gain for on-premise databases
- Developed, Maintained and Administered variety of application and warehouse databases.
Overview
3
3
years of post-secondary education
16
16
years of professional experience
Work History
Associate Architect
Applied Information Services
Hyderabad, Telangana
09.2021 - Current
Design and develop data build models using data flattening framework to Extract , Load and Parse XML input to snow flake tables.
Manager - Insights and Data
Capgemini
Hyderabad, Telangana
03.2017 - 09.2021
Provide OLTP and OLAP data modeling solutions for Banking (HSBC) and Insurance (AIA Singapore, AIG- UK, Westbend Mutual Insurance ) clients.
Database and Business Intelligence Specialist
Applied Information services
Hyderabad, Telangana
08.2014 - 03.2017
Analyze ,Design ,develop, trouble shoot database application for walmart client.
Senior Analyst Apps Programing
Bank of America Continuum India Pvt.Ltd
Hyderabad, Telangana
06.2013 - 08.2014
Created OLAP Data Model for EMDB transactional Application database Develop SSIS Package for ETL and T-SQL for Adhoc Reports
Senior Software Engineer
Aeries Technology Pvt. Ltd.
Hyderabad, Telangana
10.2012 - 06.2013
Created Data Model for e-discovery product for Billing Event Data Store Database development : Stored Procedures and User Defined Functions.
Lead DBA
Thomson Reuters
Hyderabad, Telangana
02.2011 - 10.2012
Create, Extend and Refactor OLTP data model for Check Point Learning product , Trouble shoot and Performance Tuning of Stored Procedures Provide SQL Queries for Adhoc Reporting , Migrate manual reporting to SSRS Reports.
Lead Engineer
HCL Technologies
Hyderabad, Telangana
07.2007 - 01.2011
Data Modeling , T-SQL Database Development for Insurance Product Engineering , SSIS Package development for Data Fix Engineering in MDM project for Microsoft client.
Senior Associate
eMids Technology Pvt. Ltd.
Bangalore, Karnataka
10.2006 - 07.2007
T- SQL Database Development for Insurance Claims Analysis (Razor Query Management)
Junior Programmer
AxSys Health Tech currently Prcative Health
Hyderabad, Telangana
03.2005 - 09.2006
T-SQL Database Development for Health care product : Excelicare.
Education
Bachelor of Technology - Computer Science And Information Technology
Mahatma Gandhi Institute of Technology (JNTU)
Hyderabad 11.2000 - 04.2004
Skills
Data Modeling (OLTP/OLAP- Facts and Dimensions): Erwin , SAP Power Designer , Visual Paradigm
Timeline
Associate Architect
Applied Information Services
09.2021 - Current
Manager - Insights and Data
Capgemini
03.2017 - 09.2021
Database and Business Intelligence Specialist
Applied Information services
08.2014 - 03.2017
Senior Analyst Apps Programing
Bank of America Continuum India Pvt.Ltd
06.2013 - 08.2014
Senior Software Engineer
Aeries Technology Pvt. Ltd.
10.2012 - 06.2013
Lead DBA
Thomson Reuters
02.2011 - 10.2012
Lead Engineer
HCL Technologies
07.2007 - 01.2011
Senior Associate
eMids Technology Pvt. Ltd.
10.2006 - 07.2007
Junior Programmer
AxSys Health Tech currently Prcative Health
03.2005 - 09.2006
Bachelor of Technology - Computer Science And Information Technology
Mahatma Gandhi Institute of Technology (JNTU)
11.2000 - 04.2004
Similar Profiles
Pratap MohapatraPratap Mohapatra
Module Lead at Applied Information ServicesModule Lead at Applied Information Services
Mattia PupilloMattia Pupillo
Project Manager at Applied Market Information LtdProject Manager at Applied Market Information Ltd
Bryan RodriguezBryan Rodriguez
Production Associate at Applied InformationProduction Associate at Applied Information