Teja Vemulapalli

Background

About Teja Vemulapalli

Highly motivated having 5+ years of Extensive experience in various domains of IT industry as SQL/MSBI/Power BI Developer. Hands on experience in MS SQL Server 2017/2016/2014/2012/2010 with Business Intelligence in SQL Server Integration Services, SQL Server Analysis Services, SQL Server Reporting Services, Power BI Desktop/Server. Extensively used T-SQL in constructing and tuning complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, aliases, user profiles, relational database models, data dictionaries, and data integrity and constraints for various applications in MS SQL SERVER. Used advanced features of T-SQL to design and tune interface with the database and other applications in the most efficient management. Expertise in upgrading from DTS to SSIS ETL packages, Logging, SQL Mail, Check Points, Custom Control Flow, Auditing, Variables Deploying, resolving complex issues and Error Handling in SSIS. Extensive experience in developing tabular and multidimensional SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models, deploying and Processing SSAS objects. Experience in Performance Tuning of SSIS packages by using Row Transformations, Block and Unblock Transformations. Expert in implementing various business rules for Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous Systems using SQL Server Integration Services (SSIS). Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge, and union all.