SivaPrasadReddy Palle

Experienced professional with over 6.5 years of experience in Agile Project Management, client coordination, data warehousing, Microsoft Business Intelligence, ETL, reporting, data migration, and application development. Seeking a full-time position to utilize strong interpersonal skills, effective time management, and problem-solving expertise. Motivated to make a meaningful impact in a dynamic work environment. Proven track record of successfully managing tasks and collaborating with diverse teams. Confident in thriving in a role that values innovation and fosters growth.

• Experience in data connections using different mechanisms such as Import connection and Direct Query, Live Connection from multiple sources including Flat files, folders, Databases, Online services namely CSV, Text, MS Excel, JSON Files, SQL database.
• Excellent experience in performing ETL tasks including Merge, Append, Pivoting and Un-pivoting Columns, Transpose, Grouping and Aggregating Data/Roll up, Joins, KPI’S using Conditional Columns, Data categories, Data Profiling, Data Privacy Levels at Query Editor Level.
• Performed Custom functionalities which are not supported by Query Editor such as sorting multiple columns at a time, creating the Rolling Calendar, Custom Sorting and etc using M-Language.
• Created Query Parameters, Functions at Query Editor Level and invoked Custom Columns to get locations/Data Points from Web using Bing Map API used Add Tables from Examples to get the data from unstructured and semi-structured data sources and modified the M-Code for web scraping.
• Extensive knowledge in Data warehouse concepts including Primary key, Foreign Key, Cardinality, Star, Snow Flake Schema, Dimension and Fact Tables, Normalization and Demoralization.
• Monitored Active relationships, In-Active relationships and managed the filter flow accordingly from single, both, and cross filter directions and handled Relative Dates relationships Ambiguity by using DAX to achieve data modelling capabilities in Power BI.
• Extensively Worked with Filter functions in DAX and with Number, Text, and Logical, Iteration function categories to create Calculated Columns, Measures, And Calculated Tables.
• Excellent in applying Complex DAX Time Intelligence expressions to perform Calculations including YTD, QTD, MTD, Month Over Month, Quarter Over Quarter, Year Over Year, Fiscal Year Calculations, Moving Averages, Running Totals, Product Demand Value over the time etc.
• Experience in creating dashboards, reports using various in-build visualizations like Pie, Donut Pie, Gauge, and Card, Multirow card, KPI, Slicer, Table, Matrix etc and Custom visuals.
• Created Interactive Visuals using Drill-Through, Groups, and Buttons, Bookmarks, Shapes, Trend Lines, Forecasting, Tool Tips and Conditional Formatting, Lasso Selections on map with Icons etc.
• Performed Performance tuning by optimising the DAX expressions, minimising the elements such as filters on reports.
• Published the Report in to Power Bi Service, created dashboards from various reports, scheduled and maintained the Gateways for refreshing the data. Restricted data for particular users using Row Level Security and created Workspaces, Users, Groups, Subscriptions and the appropriate Permissions for Power BI service logins.
• Experience in working with Power Automate by creating alerts and triggers in Microsoft Flows. Good experience in writing T-SQL queries (stored procedures,functions views, Indexes, cursors etc.) and implementing Business Intelligence solutions using T-SQL