Thejaswi Karra

Background

About Thejaswi Karra

3+ years of experience in Data Modeling, Database Design, Programming, Development and Implementation of Client-Server Applications & Database systems using SQL Server,PowerBI • Extensive experience in using Microsoft BI studio products like SSIS, SSAS, SSRS for implementation of ETL methodology • Expert in Data Warehouse development starting from inception to implementation and ongoing support, Strong understanding of BI application design and development principles. • Extensive working experience in: • Highly experienced in whole cycle of DTS/SQL server integration services (SSIS 2005/2008) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers. • Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages. • Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations • Scheduling and Monitoring ETL Processes using DTS Exec utilities and batch files. • Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, and MSExcel spreadsheets and Power Pivot • Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS generated drill down reports, parameterized reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS 2005/2008. • Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS. • Good knowledge of Data Marts, OLAP, Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling for FACT and Dimensions Tables using Analysis Services. • Excellent analytical, programming and problem-solving skills.