Summary
Overview
Work History
Education
Skills
Timeline
Generic

Karunakar Kadari

Hyderabad

Summary

V K Over 4+ years of extensive work experience as a SQL Server Developer and in depth proficient experience in Microsoft Business Intelligence stack, OLTP, Operational Data Source (ODS), Data warehouse, OLAP and Database technologies. Demonstrated expertise in designing, developing and deploying Business Intelligence solutions using SSIS in BIDS. Experience in installation, upgrade and configuration of Microsoft SQL Server databases. Over 5 years of extensive experience in T-SQL Programming in developing Stored Procedures, Views, Triggers, User defined functions, cursors, derived tables, common table expressions (CTEs) XML and Complex Queries on SQL Server 2005/2008/2012/2014. Broad experience in Query Optimization and performance tuning of TSQL stored procedures, functions, SSIS packages etc. Over 1 yearSt rong experience in IBM Cognos and analytics development skills, experience including Matrix, chart, graphic scorecard reports, Performance Summary Dashboards, sub-reports. Experience in creating Adhoc reporting ready universes using Business Objects Universe Designer. Have good understanding of Cognos architecture, development and end user experience. Over 4+ year's experience in utilizing ETL tools, including SSIS, DTS and ETL Package design. Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages through scheduler such as SQL Server Agent. Interaction with the Users and Business Analysts for better understanding of business & reporting requirements. SQL Developer with 2 years of progressive experience in databases and application programming. Dedicated to building customized technical solutions in alignment with operational needs and objectives. Critical thinker, analyst and problem solver known for continuous delivery of quality products across diverse business environments.

Overview

5
5
years of professional experience

Work History

SQL Server Developer /SSIS Developer Lead

Aetna
Hyderabad
10.2022 - Current


  • Worked on different types of Source systems like Documents and Create new packages and matched with the measures of EDW and stored it in SQL Server Database Using SSIS.
  • Prepared technical documentation for every stored procedure and updated those stored procedures with new data elements.
  • Designed & Developed Type 2 Slowly Changing Dimensions in order to maintain the historical changes for the business purposes.
  • Working on the Existing (legacy) SSIS packages and modified the same packages to match it for different sources for integration.
  • Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems.
  • Used OnPostExecute and On Error event handlers to update the each task logging in SSIS log table.
  • Used Script task component and established iterative load for faster retrieval & to improve performance.
  • Used different transformations like lookup, condition split, and row count Transformation, Derived Column, Data Conversion etc.
  • Created Stored Procedures for package Initialization and end package information to update the package log table.
  • Created Package Configuration file with connection information source, staging and destination databases and send mail task connection information and log directory path value.

SQL Server/BI Technical Lead Developer

UKG
Bangalore
01.2021 - 10.2022


  • UKG focuses on audit and assurance, tax and consulting services.
  • Additionally, in the US, UKG concentrates on 16 key industries and provides targeted services that include - but are not limited to - human resources, deals, forensics, and consulting services.
  • They help resolve complex issues and identify opportunities.
  • Responsibilities
  • Interfaced with business analysts, developers and technical support to determine the best requirement specifications.

SSIS/SSRS Lead Developer

Takeda Pharmacy
Bangalore
08.2021 - 10.2021


  • Takeda Phamarcy provides sustainable healthcare technology - solutions engineered to improve patient outcomes while reducing costs - across a complete portfolio of imaging and therapy systems, laboratory diagnostics, and healthcare IT.
  • Responsibilities
  • Stored, retrieved and manipulated data for close analysis of system capabilities.

SSIS/SQL SERVER Developer

QBE
Banglore
03.2019 - 09.2021


  • QBE is a multinational life insurance, pensions and asset Management Company.
  • QBE businesses focus on life insurance and pensions, savings and asset management products.
  • The group is also active in accident and supplemental health insurance and general insurance, and has limited banking activities.
  • Transamerica has major operations in the United States Responsibilities: Working on the Data migration project called ECB (Environmental Control Board) to migrate the ticket finder data from ADABASE, DB2, and MS ACCESS to SQL Server.
  • Assisted with Database design, extensive data analysis of all 3 source systems & implemented the ETL architecture to support the migration.
  • Created ETL Extraction Strategy architecture as part of Development plan to extract & load data from source systems to staging and to ECB Destination servers.
  • Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into target tables.
  • Worked extensively on complete data mapping of all source systems as part of data analysis.
  • Extensively used SSIS transformations such as Script component, Pivot/Unpivot, Multicast, Derived column, Data conversion, Row count and Send Mail task etc.
  • Experience with SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints and scripting with VB.NET in SSIS.
  • Worked on the data archival process by transferring data crossing different platforms, validating data during transferring, and archived data files for different DBMS by creating dynamic SSIS packages.
  • Worked with the application developers and provide necessary SQL Scripts using T-SQL.
  • Involved in the Production support for TLC application & generated the reports based on Case counts, Hearing decisions etc as per Users requirements.
  • Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
  • Interfaced with business analysts, developers and technical support to determine the best requirement specifications.

Education

Master of Science - Internet And Webdesign

Wilmington University
Wilmington Delaware USA
03.2016

Bachelor of Science - Mechanical Engineering

JNTU Hyderabad
Hyderabad
03.2013

Skills

  • SQL Server Tools
  • Enterprise Manager, SQL Profiler, Query Analyzer, SQL Server Management Studio, DTS, SSIS
  • Database
  • MS SQL Server2014, 2012, 2008R2, 2008, 2005, Microsoft Office 2007/2003, MS-Access
  • Language
  • Operating System
  • Windows XP/NT/2000/2003/2008, DOS
  • Tools & Applications
  • Software Documentation Control

Timeline

SQL Server Developer /SSIS Developer Lead

Aetna
10.2022 - Current

SSIS/SSRS Lead Developer

Takeda Pharmacy
08.2021 - 10.2021

SQL Server/BI Technical Lead Developer

UKG
01.2021 - 10.2022

SSIS/SQL SERVER Developer

QBE
03.2019 - 09.2021

Master of Science - Internet And Webdesign

Wilmington University

Bachelor of Science - Mechanical Engineering

JNTU Hyderabad
Karunakar Kadari