NARESH MAMIDI

Highly experienced Power BI Developer with 11+ years of expertise in designing, developing, and deploying business intelligence solutions to empower data-driven decision-making. Proficient in creating interactive dashboards, crafting complex DAX queries, and optimizing data models for performance and scalability.

11 years of experience in Data Analysis, Design, Implementation, Administration and support of Business Intelligence using SQL Server SSIS, SSAS and SSRS. Published reports to Azure based Power BI services (Pro) and schedule subscription and various sharing options (workspace, content pack, and Apps). Excellent hands-on experience in groups, hierarchies and measures, KPIs. Expert in working on all phases of Data warehouse from gathering requirements to testing, implementation, and support. Excellent knowledge in Performance tuning methodologies at database level, ETL, and Report Level Proficient in the ER - Data Modeler, for the designing of Conceptual Design, Logical Design, and Physical Design and setting up the database model. Excellent knowledge of Data Warehousing methodologies and concepts, including Star schema, Snowflake, ETL processes, Dimensional modeling and reporting tools. Proficient in applying transformation rules - Data Conversion, Data Cleansing, Data Aggregation, Data Merging and Data split. Expert in generating reports using SQL Server Reporting Services (SSRS). Worked with both live and import data into Power BI for creating reports. Expert database engineer, NoSQL and relational data modeling using Microsoft Sql Server. Proficient with SQL Enterprise Manager, SQL Query Analyzer, scheduling jobs with SQL Server Agent, and SQL Profiler Expert in creating ad-hoc reports by using Report Builder in SSRS. Internally trained on Cosmos, Kusto's. Proficient in writing the Stored Procedures, Triggers, Functions, Indexed Views. Converted unstructured stream to structured stream by Writing Scope Scripts, scheduling jobs in time ranges as Daily/weekly/Monthly, writing merge scripts to merge years of data to represent in trend graphs and publishing the data to cosmos/Kusto's/ Sql according to requirements Good Hands-on experience writing Scope Scripts for Cosmos (Big Data) Azure Services and cloud services. Experience in providing logging, Error handling by using event handler and custom logging for SSIS packages. Extensive use of DAX (Data Analysis Expressions) functions in creating Power BI dashboards, reports and Tabular Models. Experience in Python Development and Scientific Programming, and using Numpy and Pandas in Python for Data Manipulation. Excellent hands-on experience in groups, hierarchies and measures, KPIs. Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests. Created hierarchies in Power BI reports using visualizations like Bar chart, Line chart, etc. Performed transformations like Pivoting, Unpivoting and Splitting of the columns using Power Query. Performed configuration of on-premises Power BI gateway to refresh datasets of Power BI reports and dashboards. Experience with creating ETL processes from source and link data to identify trends and relationships between different pieces of data, draw appropriate conclusions and translate analytical findings into risk management and marketing strategies that drive value. Experience in developing interactive Web applications using HTML/HTML5, CSS/CSS3, JavaScript, JQuery and Bootstrap for Business Intelligence domains and repositories. Hands on experience using the version controls like GIT, project management tools like JIRA, Team Forge. Experienced in client requirement analysis, physical, logical design, development, debugging, testing, deployment, support and maintenance of business applications using SQL Server 2014/2012/2008/2005, SSIS and SSRS 2005/2008/2012/2014/2016. Having good knowledge on Teradata architecture, database features and Teradata tools. Used SQL Loader to load data from legacy system (CORE) and developed PL/SQL programs to dump the data from the staging tables to the interface tables and concurrent programs to get data into oracle base tables.