Professional Summary: 5+ years of IT experience in the Data Warehousing and Business Intelligence applications in all phases of software development life cycle (SDLC). Experience in MS SQL Server with SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and T-SQL. Experienced in all phases of software development life cycle SDLC including in-depth knowledge of Agile methodology. Strong development skills SQL , AWS Redshift data warehouse. Strong Experience in all areas of SQL Server development including tables, user functions, views, indexes, stored procedures, functions, Joins, SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Checks, and Unique), relational database models, and data integrity. Expert on creating multiple kinds of Power BI Reports and Dashboards. Based on requirements created, maintained & scheduled various Power BI reports on a Yearly, Quarterly, Monthly, and Daily. Published Power BI reports from Power BI Desktop to Power BI service. Performed data cleaning, data validation, and data analysis using data analysis expressions (DAX), power query, and Power Pivot. Proficient in OLTP, OLAP, and Data Warehousing Design concepts. Good experience building Star Schema and Snowflake Schema based on the business requirements. Worked on Source Data Analysis, Design, and creation of Data Mappings for Extraction of bulk data from sources like Flat files, Excel files, etc.  Used Power BI Gateways to keep the dashboards and reports up to date. Experience in RDBMS Concepts, Database Management Systems, and Database Physical, Logical design, Data Mapping, Table normalization, and Data Modeling. Created various kinds of SSRS reports such as a parameterized report, sub report, Drill Down report, and Drill Through report for the business users.  Involved in complete ETL processing of extracting the data, transforming the data, and loading the data using SSIS package executables and transformations. Scheduled Automatic refresh and scheduling refresh in Power BI service. Worked on all types of transformations that are available in the Power BI query editor. Involved in the publishing of various kinds of live, interactive data visualizations dashboards, reports from Power BI Desktop. Developed and optimized database structures, Stored Procedures, Indexes, Views, and UDF, Common Table Expression (CTEs) to support Power BI and SSRS reports. Worked with Flat Files Data source connections, ODBC data source connections (to SQL server sources), and DB2 data source connections.