• Participated in the user requirement gathering and Design meetings with various Airport General Managers, Directors and Stakeholders to develop their business data into meaningful insights using Power BI.• Read source data from APIs, Data Bricks, SharePoint, SolarWinds, ServiceNow, Safety Culture, Monday.com, Excel, Azure SQL DB, CSV, ORACLE, and SQL Server through Power BI.• Generated context filters and data source filters while handling large volume of data.• Hands on experience in utilizing DAX functions which includes Aggregation, Counting, Logical, information, Text and date functions in source data.• Used DAX table functions including FILTER, ALL, VALUES, DISTINCT and RELATEDTABLE.• Create and customize simple visualizations, Combination charts, Slicers, Map visualizations, Matrixes and tables, Scatter charts, Waterfall and funnel charts,• Designed Power Automate flows for internal users to refresh their own data sets when the reports they own the data need validation and data clean up before the next meeting.• Utilized Power BI to create dynamic reports and dashboards with Drill down, Drill through, maps, calculation groups & perspectives.• Design Power BI data visualization using cross tabs, maps, scatters plots, density charts • Extensive Experience in using Power Query Editor to transform /edit the data into the shape before they are loaded into the Power BI.• Developing visual reports, dashboards and KPI scorecards using Power BI desktop. • Deploy and share the reports to Power BI Service and setup gateways, row level security for end user interaction. • Adept in developing, publishing and scheduling Power BI reports as per the business requirements. • Support ETL and Data Warehouse production, development & test environment • Work on client problems understanding their requirement, building, documentation, and translation of the requirements into dashboard solutions.

• Meet with Product Owner, Scrum Master, and business users, gathered business requirements and prepare documentation for analysis and Data Models • Working in an agile environment/team and usage of Azure DevOps for Application Lifecycle Management.• Worked on Dashboards and report deployments at scale using Deployment Pipelines.• Configured Azure DevOps Parameterizes Pipelines that controlled the CI/CD Integration based on YAML Scripts, which were pushed between the Development-UAT-Production environments.• Used PowerShell cmdlets & REST API to handle Power BI administrative task around Datasets, Dashboards, Workspaces and User controls.• Developing visual reports, dashboards and KPI scorecards using Power BI desktop. • Work on require analysis, design and development of production apps using Power BI • Implemented DAX functions of company KPIs mention sales, revenue (year to year), purchasing lead time and inventory, production (cycle time, production cost, Rework and Reject cost) profit & sales performance of energy usage based on geography for commercial users. • Performed detail data analysis to derive insights and deliver operational mechanism such as dashboards or ad-hoc reports • Utilized Power BI to create dynamic reports and dashboards with Drill down, Drill through, slicers, maps, calculation groups & perspectives, and power apps.• Design Power BI data visualization using cross tabs, maps, scatters plots, density charts • Adept in developing, publishing and scheduling Power BI reports as per the business requirements. • Building, publishing customized interactive reports and dashboards, report scheduling using • Review and resolve issues that arise in the current reporting, including and not limited to debugging and fixing current and new reports. • Build SSIS Package to import data from external source like Excel, Access, Flat file, Oracle to MS SQL Server by using BCP, SSIS and DTS utility.

• Maintained databases, performed software installation and upgrades, monitored database performance, performed capacity planning and SQL Server clustering, managed database quality assurance including database consistency check using DBCC commands. • Standardized company reports by implementing SQL Server Reporting Services.• Developed Chart Reports, Drill Through Reports, Master Detail Reports and Multiple Reports.• Created different type of reports including: A Cross-tab, Conditional, Sub report, Drill-down and Parameter prompts, linked reports and deployed and scheduled Reports in Report Manager using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.• Generated the various kinds of reports using Graphs and Images• Develop Functional/Technical specifications for SQL Server Reporting Services reports.• Researched, planned, installed, configured and at times created software interfaces.• Analyzed the Data quality, Data validating, Data mapping to migrate data to SQL server Datawarehouse to over 60 tables.• Collected business requirements from users and translated them as technical specs and design docs for development.• Identified various data sources, formulated data dictionaries, design and develop data models (physical/logical data models) based on the given specs and requirements. • Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints etc on various database objects to obtain the required results.• Bulk data migration using SSIS from flat files. • Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files etc to SQL Server using SSIS/DTS using various features like data conversion etc. Created derived columns from the present columns for the given requirements.• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.

• Maintained databases, performed software installation and upgrades, monitored database performance, performed capacity planning and SQL Server clustering, managed database quality assurance including database consistency check using DBCC commands. • Standardized company reports by implementing SQL Server Reporting Services.• Developed Chart Reports, Drill Through Reports, Master Detail Reports and Multiple Reports.• Created different type of reports including: A Cross-tab, Conditional, Sub report, Drill-down and Parameter prompts, linked reports and deployed and scheduled Reports in Report Manager using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.• Generated the various kinds of reports using Graphs and Images• Develop Functional/Technical specifications for SQL Server Reporting Services reports.• Researched, planned, installed, configured and at times created software interfaces.• Analyzed the Data quality, Data validating, Data mapping to migrate data to SQL server Datawarehouse to over 60 tables.• Collected business requirements from users and translated them as technical specs and design docs for development.• Identified various data sources, formulated data dictionaries, design and develop data models (physical/logical data models) based on the given specs and requirements. • Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints etc on various database objects to obtain the required results.• Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files etc to SQL Server using SSIS/DTS using various features like data conversion etc. Created derived columns from the present columns for the given requirements.• Developed, monitored and deployed SSIS packages.• Involved in creating Cubes using SQL Analysis Services (SSAS) • Responsible for maintaining versions of source code using Team Foundation Server.