Madhur Nimmagadda

• Involved in Preparation and cleaning of data (data profiling) using Talend data preparation tool, Microsoft Azure machine learning studio tool, Azure data lake and python programming.
• Developing data ingestion processes to bring data from various sources into Azure data storage systems, such as Azure Data Lake Storage, Azure SQL Database, or Azure Synapse Analytics.
• Designing workflows and orchestrating data pipelines using Azure Data Factory or other automation tools to ensure smooth and timely data movement.
• Involved in Tuning and optimizing data pipelines and database systems for improved performance and reduced latency.
• Working on the performance tuning for mappings and ETL procedures both at mapping and session level.
• Responsible for Design, Development, and testing of the database and Developed Stored Procedures, Views, and Triggers
• Developed Python-based API (RESTful Web Service) to track revenue and perform revenue analysis.
• Connected Power BI to Azure Cosmos, Cloud databases and other Azure SQL data tools.
• \Worked on various types of DAX Functions in Power BI like Date and time functions, Time-intelligence functions, Filter functions, Information functions, Logical functions Math and Trig functions, Parent and Child functions, Statistical functions, and text functions
• Worked on improving the performance of queries with modifications in T-SQL queries, by generating execution plan of the long running queries with performance issues, by using indexes, using the select syntax efficiently, creating joins, using where, having clauses efficiently and by eliminated redundant and inconsistent data etc.
• Connected to data sources (Oracle, SQL, Excel), importing data, and transforming data for Business Intelligence.
• Designed and Developed Power BI graphical and visualization solutions with business requirement documents and plans for creating dashboards.
• Created effective reports using custom visualizations such as Gantt Chart, Skyline Chart, Timeline Chart, Gauge, Pie Chart in Power BI.
• Created Tables, Stored Procedures and extracted data using T-SQL for business users whenever required.
• Used advanced features of T-SQL to design and tune T-SQL to interface with the Database and other applications in the most efficient manner and created stored Procedures for the business logic using T-SQL.
• Excellent experience in creating Indexes, Indexed Views in observing Business Rules and creating effective Functions and appropriate Trigg

Involved in Preparation and cleaning of data (data profiling) using Talend data preparation tool, Microsoft Azure machine learning studio tool, Azure data lake and python programming.
Developing data ingestion processes to bring data from various sources into Azure data storage systems, such as Azure Data Lake Storage, Azure SQL Database, or Azure Synapse Analytics.
Designing workflows and orchestrating data pipelines using Azure Data Factory or other automation tools to ensure smooth and timely data movement.
Involved in Tuning and optimizing data pipelines and database systems for improved performance and reduced latency.
Working on the performance tuning for mappings and ETL procedures both at mapping and session level.
Responsible for Design, Development, and testing of the database and Developed Stored Procedures, Views, and Triggers
Developed Python-based API (RESTful Web Service) to track revenue and perform revenue analysis.
Connected Power BI to Azure Cosmos, Cloud databases and other Azure SQL data tools.
Worked on various types of DAX Functions in Power BI like Date and time functions, Time-intelligence functions, Filter functions, Information functions, Logical functions Math and Trig functions, Parent and Child functions, Statistical functions, and text functions
Worked on improving the performance of queries with modifications in T-SQL queries, by generating execution plan of the long running queries with performance issues, by using indexes, using the select syntax efficiently, creating joins, using where, having clauses efficiently and by eliminated redundant and inconsistent data etc.
Connected to data sources (Oracle, SQL, Excel), importing data, and transforming data for Business Intelligence.
Designed and Developed Power BI graphical and visualization solutions with business requirement documents and plans for creating dashboards.
Created effective reports using custom visualizations such as Gantt Chart, Skyline Chart, Timeline Chart, Gauge, Pie Chart in Power BI.
Created Tables, Stored Procedures and extracted data using T-SQL for business users whenever required.
Used advanced features of T-SQL to design and tune T-SQL to interface with the Database and other applications in the most efficient manner and created stored Procedures for the business logic using T-SQL.
Excellent experience in creating Indexes, Indexed Views in observing Business Rules and creating effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.
Created Views, Tables to pull data into Power Bi required for generating reports and dashboards.
Created and developed calculated fields and DAX queries on respective reports in Power BI.
Designed SSIS packages to import and transform data between databases and external data sources using various transformations like Data conversion, File system task, Row counts, OLE DB Source, OLE DB Destination, OLE DB Command, Merge Join, Lookup, Sort, Data flow task.
Designed and created data extracts, supporting SSRS, Power BI, Tableau, or other visualization tools reporting applications.
Reports in Report Manager.

Developed Power BI model used for financial reporting and designed and documented the entire Architecture of Power BI POC.
Expertise in writing complex DAX functions in Power BI and Power Pivot.
Automated Power Query refresh using power shell script and windows task scheduler.
Used various sources to pull data into Power BI such as Sql Server, SAP BW, Oracle, SQL Azure etc.
Installed and configured Enterprise gateway and Personal gateway in Power bi service.
Wrote calculated columns, Measures queries in power bi desktop to show good data analysis techniques.
Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.
Created stored procedures and SQL queries to pull data into power pivot model.
Worked on Database creation (DDL, DML, DCL), database tuning, SQL tuning, performance planning.
Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, Views, T-SQL Scripting and Jobs.
Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.
Created SSIS packages to import data from Access, Excel, XML, OLE DB Source, and Flat Files.
Created Jobs Performance report that queries system tables to track the duration of each job and weekly-average duration using SSRS.
Designed and created data extracts, supporting SSRS, Power BI, Tableau, or other visualization tools reporting applications.
Created Datasets in T-SQL, stored procedures for SSRS.
Developed Excel Power View, Power Query and PowerPivot dashboards for data analysis
Developed confidential proprietary analytical tools and reports with Confidential Excel, and Power Pivot and Power Point.
Created SSIS packages to import data from Access, Excel, XML, OLE DB Source and Flat Files.
Designed SSIS packages to import and transform data between databases and external data sources using various transformations like Data conversion, File system task, Row counts, OLE DB Source, OLE DB Destination, OLE DB Command, Merge Join, Look up, Sort, Data flow task.
Created Parameterized Report, Dashboard Report, linked report and Sub Report by Year, Quarter, Month, and Week.

Involved in Extraction, Transformation and Loading of data using Informatica.
Designed the target load process based on the requirements.
Enhancing the existing mappings where changes are made to the existing mappings using Informatica Power center.
Build the logical and physical data model for snowflake as per the changes required.
Develop Mappings and Workflows to load the data into Oracle tables.
Developed various transformations like Source Qualifier, Update Strategy, Lookup transformation, Expressions and Sequence Generator for loading the data into target table.
Created Workflows, Tasks, database connections using Workflow Manager.
Involved in extracting data from SQL Server and Flat files.
Implemented performance tuning techniques by identifying and resolving the bottlenecks in source, target, transformations, mappings, and sessions to improve performance Understanding the Functional Requirements.
Responsible for identifying the missed records in different stages from source to target and resolving the issue.
Extensively worked on the performance tuning for mappings and ETL procedures both at mapping and session level.
Working on the performance tuning for mappings and ETL procedures both at mapping and session level.
Responsible for Design, Development, and testing of the database and Developed Stored Procedures, Views, and Triggers
Developed Python-based API (RESTful Web Service) to track revenue and perform revenue analysis.
Involved in data mapping sessions to identify data sources and created source code in SQL server to feed the data visualizations in Power BI.
Designed and implemented multiple dashboards using Power BI - PowerPivot & Power Query tools for in house metrics
Utilized Power BI to create various analytical dashboards that depict critical internal KPIs such as billing accounts receivable and payable, customer retention and, vouchering with slicers and dicers enabling end-user to make filters for sales, marketing, finance including top executives
Expertise in writing complex DAX functions, measures, calculated columns, aggregations in Power BI
Designed, developed, and Implemented code in Python to retrieve and manipulate data
Designed complex data intensive reports in Power BI utilizing various graph features such as gauge, funnel, line & bar graphs
Performed complex statistical and analytical calculations and connected to Tableau to create forecasting visualizations to optimize the hardware inventory
Created Tableau Dashboards with interactive views, trends, and drill downs along with user level.
Utilized Power BI to create analytical dashboards and scoreboards depicting critical KPIs.