Yashwant Umredkar

About Yashwant Umredkar

Having 3+ years of experience in Analysis, Understanding, Development, Validating and Implementation of Business Intelligence reports using Tool Power BI. Experience in interacting with various business stakeholders and able to gather the business specifications and translate into data visualizations for effective decision-making. Well understanding the business requirements, business solutions, and creating the Technical and Functional documents as per client request sheet. Extracted the data from non-database sources (Excel, XLS, CSV file, SharePoint, MS Fabric and Online services), Database sources (SQL Server, SSAS) and Developed Visualizations by using Power BI, Worked on Direct Query / Import Methods & Live Connection for connecting Data. Developed the Dashboards using Growth rate calculations (YTD, MTD and YOY etc.…) 6. Worked on Row-level security (RLS)in Power BI. Worked on various DAX functions in Power BI for creating calculated columns & table\'s. Experienced in creating different visualizations using Bar charts, Line charts, Pie Charts, Tables, Matrix Tables, Maps, Graph, Tree Map, Drill Down and creating KPI\'s using KPI visuals. Designing, building and deploying, publishing data analysis reports/dashboards for large volumes of data. Experience in SQL and T-SQL Developing skills including Creating Tables, Functions, Views, Constraints, Stored Procedures, and other objects like CTE’s, Temp Tables, etc. Developed and maintained ETL (Data Extraction, Transformation and Loading) mappings using SSIS to extract the data from multiple source systems. Published reports into Power BI publisher and schedule the data sets, providing row level security. Create Data Flows and Shared dashboards to users through Office 365. Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team and Involved in requirements gathering. Experience in Designing customized interactive Dashboards on Power BI Service. Good knowledge on data warehouse concepts Star Schema/Snow flake Schema. Worked on Insurance, Banking and HR domain. Working knowledge in Agile Methodology.

Experience

1. Business Intelligence Analyst

   Genpact

   Jul 2024 — Present · Gurugram, IN

Education

• Rashtrasant Tukadoji Maharaj Nagpur University, Nagpur

  Bachelor of Commerce - BCom

  2016 — 2019