Anil Kumar Kundrapu

About Anil Kumar Kundrapu

With over 9 years of experience, I specialize in designing and developing comprehensive…

Experience

1. Power Bi Developer

   Charter Communications

   Oct 2022 — Present · St Louis, MO, US

   Responsible for creating Technical Design documents, Source to Target mapping documents and Test Case documents to reflect the ELT process.• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Transaction and Data.• Developed scripts for loading the data into the base tables in EDW and to load the data from source to staging and staging area to target tables using Fast Load.• Developed the Teradata Macros, Stored Procedures to load data into Incremental/Staging tables and then move data from staging into Base tables.• Developed procedures to populate the customer data warehouse with transaction data, cycle and monthly summary data, and historical data.• Responsible for designing ETL strategy for both Initial and Incremental loads.• Extensively worked in the performance tuning of the programs, ETL Procedures and processes. • Extracted data from various source systems like Oracle, Sql Server and flat files as per the requirements.• Wrote several SQL Scripts such as finding tables that have Identity Columns, finding tables that do not have primary key. • Automated the SSIS jobs in SQL scheduler as SQL server agent job for daily, weekly, and monthly loads.• Extensively used SSIS transformations such as lookup, merge, derived column, data conversion, conditional split and aggregate for creating SSIS ETL Solution.• Developed custom calculated measures using DAX in Power BI to satisfy business needs.• Embedded Power BI reports on SharePoint portal page and also managed access of reports and data for individual users using Roles.• Management of high-performance production CLUSTERED SQL Server database instances using Active - Passive nodes, and Active-Active nodes clustering.• Implemented Copy activity, Custom Azure Data Factory Pipeline Activities• Creating complex Stored Procedures, Functions, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.