Singampalli Ajay Kumar

✓ A growth-oriented professional, with 3.5 years of Experience in IT Industry along with 3+years of Power BI and SQL experience in developing various reports and dashboards. ✓ Hands on experience on Power BI Desktop, Power Query and Power BI Service, DAX, SQL, with basic knowledge on Azure ADF services and snowflake Datawarehouse. ✓ Proficient in SQL query writing with Basic DDL, DML, DCL Commands for data retrieval. ✓ Expertise in writing complex SQL queries, including joins, subqueries, window functions, CTEs (Common Table Expressions), and set operations to extract, manipulate, and analyze large datasets. ✓ Proficient in designing and optimizing relational database schemas, including normalizing data and creating efficient table structures. ✓ Experience with indexing and query optimization for faster data retrieval. ✓ Experience in creating Charts like Pie Charts/Donut/Word/charts/cards/gauges/slicers etc. and working with custom visualizations using Power BI. ✓ Good knowledge on Data warehousing concepts like Star schema, Snowflake schema and identifying the dimension and fact tables. ✓ Extensively used transformations like Merge Queries, Append Queries, Pivoting the Column, Un Pivoting Columns, Adding Custom Columns, Splitting the Columns, Merging the Columns etc. ✓ Experience in connecting with multiple data sources like SQL Server, Json, csv and Excel from Power BI to build complex Datasets. ✓ Skilled in SQL and Power BI (Power BI Desktop, Power Query Editor and Power BI Service). ✓ Proven experience in extracting data from heterogeneous sources, transforming and loading (ETL) process using Azure Data Factory services with different Control Flow Tasks and Data Flow Transformations. ✓ Extensively used different Categories of DAX functions like Time Intelligence Function, Filter Functions, Date Functions, Logical Functions, Text Functions, Number and Statistical Functions for Creating New Information. ✓ Published Power BI Reports in the required originations and made Power BI Dashboards available