Praveen

PROFESSIONAL SYNOPSIS

• A performance & goal-oriented professional with expertise in Power BI with an excellent understanding of business dynamics

• Having 9+ years of IT experience as Microsoft SQL Server developer implementing SSIS using Microsoft Business Intelligence development studio (MSBI), SQL Server data tools (SSDT) and Power BI

• Developed SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from SQL Server

• Extensive hands-on experience in several Data Flow transformations including DerivedColumn, Script, Slowly Changing Dimension, Look up, Data Conversion, Conditional-Split techniques, Merge, Multicast, Union All

• Expertise in enhancing and deploying the SSIS Packages from development server to production server.

• Experience in creating jobs and schedule SSIS Packages.

• Knowledge on dimensional Star Schema and Snowflakes Schema

• Hands on experience in Performance Tuning, Query Optimization

• Strong Knowledge on Power BI to import data from various sources such as SQL Server, Azure SQL DB, SQL Server Analysis Services (Tabular Model), MS Excel etc.,

• Experience in developing Visualization reports and dashboards using Power BI

• Database creation (DDL, DML, DCL), database tuning, SQL tuning, performance planning.

• Proficient in writing complex DAX expressions to perform complex Business Intelligence logics.

• Having good knowledge on creation and scheduling of SQL server agent jobs to run daily ETL’s.