Skokie, Township of Niles, CookMember since April 2, 2025
·
Hire this person
Send a job offer directly to this candidate
About
8+ years of experience as a BI analyst/ Developer with extensive experience in data warehousing, and BI technologies with expertise in Azure, Power BI and Tableau for building, deploying, and managing applications and services through MS Data centers in Agile and Waterfall projects.
Practical understanding of Data Modeling (Dimensional & Relational) concepts like star Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
Experience in Creating different visualization using standard charts (Stacked bar, waterfall chart, clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line and Clustered Column Chart, Map, Slicer, gauge chart) and Custom charts (scroller, tornado, sunky, word cloud visual and radar) in Power BI and Tableau according to the requirements.
Expert in MS Power BI and Tableau - Data design, data cleansing, scheduling the reports to users, managing data gateways, management using DAX language, Role level security access, granting permissions.
Expert at using Power BI tenants to control the PBI API’s extraction from the capacities.
Proficient in data analysis and manipulation using SQL, Python, and R to extract, clean, and transform complex datasets for actionable insights.
Expert in creating interactive reports/ dashboards using Power BI, Tableau, and SSRS.
Expert in end-to-end implementation by using Azure Cloud from Data Lake to Synapse DB through Data Factory, Azure Analysis to do data modeling, and then using the cube in Power BI to improve performance.
Experience in of Page Level Filters, Report Level Filters, Visual Level Filters in Power BI according to the requirements
Extensive database programming experience in writing POWER BI, User Defined Functions, Triggers, Views, Temporary Tables, and Indexes using various DDL and DML commands.
Developed customized Stored Procedures and Queries for data extraction, reports, and other client interfaces.
Implemented Power BI gateway different source to match analysis criteria and further modeling for Power Pivot and owner view.
Experience
8+ years of experience as a BI analyst/ Developer with extensive experience in data warehousing, and BI technologies with expertise in Azure, Power BI and Tableau for building, deploying, and managing applications and services through MS Data centers in Agile and Waterfall projects.
Practical understanding of Data Modeling (Dimensional & Relational) concepts like star Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
Experience in Creating different visualization using standard charts (Stacked bar, waterfall chart, clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line and Clustered Column Chart, Map, Slicer, gauge chart) and Custom charts (scroller, tornado, sunky, word cloud visual and radar) in Power BI and Tableau according to the requirements.
Expert in MS Power BI and Tableau - Data design, data cleansing, scheduling the reports to users, managing data gateways, management using DAX language, Role level security access, granting permissions.
Expert at using Power BI tenants to control the PBI API’s extraction from the capacities.
Proficient in data analysis and manipulation using SQL, Python, and R to extract, clean, and transform complex datasets for actionable insights.
Expert in creating interactive reports/ dashboards using Power BI, Tableau, and SSRS.
Expert in end-to-end implementation by using Azure Cloud from Data Lake to Synapse DB through Data Factory, Azure Analysis to do data modeling, and then using the cube in Power BI to improve performance.
Experience in of Page Level Filters, Report Level Filters, Visual Level Filters in Power BI according to the requirements
Extensive database programming experience in writing POWER BI, User Defined Functions, Triggers, Views, Temporary Tables, and Indexes using various DDL and DML commands.
Developed customized Stored Procedures and Queries for data extraction, reports, and other client interfaces.
Implemented Power BI gateway different source to match analysis criteria and further modeling for Power Pivot and owner view.
Education
Design, develop, and maintain dynamic reports and dashboards using Power BI, SSRS, and Tableau.
Create visually appealing and interactive dashboards and reports using Power BI and Tableau. This involves using DAX expressions, custom visuals, Tableau Calculated Fields, and the Power Query editor to transform and model data effectively.
Connect to SQL, Oracle, SharePoint, and cloud data sources, using Tableau Prep for data cleansing, transformation, and blending.
Designed and implemented Fabric Data Factory pipelines to extract, transform, and load (ETL) data from multiple sources (SQL, Azure Blob Storage, APIs) into Power BI for real-time analytics and reporting.
In SSRS (POWER BI Server Reporting Services), design paginated reports that cater to specific business needs, including parameterized, drill-through, and subscription-based reports. Manage report deployment and ensure they meet performance and usability standards.
Use POWER BI Server Management Studio (SSMS) to write and maintain efficient SQL queries that retrieve, manipulate, and aggregate data from relational databases.
Developed performance metrics and reporting tools to track key performance indicators (KPIs) and monitor operational effectiveness.
Collaborated with cross-functional teams to translate business requirements into actionable data-driven insights and visualizations.
Optimize dashboard performance by extracting data, reducing query load, and implementing indexing while publishing reports on Tableau Server/Online for real-time collaboration.
Utilized Dataflows and Power Query within Fabric Data Factory to clean, aggregate, and optimize data before integrating it into Power BI dashboards for better performance and efficiency.
Querying and Optimizing data in Oracle Databases for enhanced performance.
Developed interactive Power BI dashboards by integrating data from SAP HANA, AWS Data Lake, and Oracle Workbench, enabling real-time decision-making.
Reviews
Similar people near Skokie, Township of niles, Cook
