Nagaraju Rapelli

Background

About Nagaraju Rapelli

Overall, 7.6 years of experience in the domain of Oil and Gas industry.• Having 3.5 years of experience in Power BI, SQL Server, Data Warehouse and SQL Server integration services (SSIS).• Working knowledge on Power BI objects like Reports, Power Views, Creating Workspaces, Sharing dashboards, Row Level security Implementation.• Implemented dynamic calculations using the DAX functions like Calculate, Filter, Min, Max, Sum, Count, MTD, QTD, YTD etc.• Developed different types of reports like Line chart, Bar charts, Pie chart, Drill through, Drilldown reports, Matrix reports etc.• Strong knowledge in SQL server (SQL and T-SQL).• Experience in Developing ETL Packages using SSIS.• Performed data cleansing to rectify any incorrect data (duplicate data, obsolete records) etc.• Experience in Data Warehouse designing with different schemas - Star and Snowflake schemas.• Good Understanding of Data warehousing concepts includes Dimensions, Fact tables, Schemas and its Relationships.• Experience in Full Loading and Incremental loading of data using ETL.• Developed various SSIS Packages using Stored Procedures and Complex SQL Queries.• Expertise in Using different Transformations like Lookups, Derived Column, Merge Join, For Loop, For Each Loop, Conditional Split, Union all and etc.• Ability to learn and adopt to new tools.