Chevva Raju

Background

About Chevva Raju

Extensive IT industry experience, specializing in Data Factory and Power BI focusing on Data Warehousing environments and proficient in Microsoft Business Intelligence tools. • Proficient in designing and implementing data solutions leveraging Azure Data Factory (ADF) for ETL workflows, Python for scripting automation, PySpark for big data processing, and Databricks for scalable data analytics, ensuring efficient data management and actionable insights. • Designing and developing dynamic ETL processes using SSIS, including incremental loads and data cleansing techniques, ensuring data integrity and efficiency. Utilizing ER diagram-based data modeling techniques and implementing effective functions and triggers for streamlined data manipulation. Writing complex T-SQL queries, stored procedures, functions, views, indexes, and triggers for efficient data retrieval and manipulation. • Deploying and processing SSAS cubes, modifying MDX Cubes and Dimensions, and optimizing SSRS reports for performance. Organizing and populating Oracle database tables, ensuring smooth data migration and adherence to validation guidelines. Implementing effective data loading techniques from diverse source systems into Oracle tables, overcoming data type compatibility issues. • Utilizing SSRS Report Manager for data-driven subscriptions, enabling automated and customized report delivery. Crafting intricate SQL queries and stored procedures, utilizing the SOLIX tool for database performance optimization. Spearheading data migration solutions to integrate data from various sources into SQL Server databases. Managing errors in ETL packages to enforce data dependability and integrity. • Proficiency in SQL queries, Python scripting, and DAX formulas for data manipulation, analysis, and visualization. Implementing incremental load strategies and deploying SSIS packages for prompt data transfer and processing.