Shadab

About Shadab

Over 7+ years of IT experience with expertise in analysis, design, development and implementation of data marts using Power BI,Tableau, ETL and RDBMS like Oracle 11g, MS SQL server. • Published Power BI Reports and Made Power BI Dashboards available in Web clients and mobile apps. • Strong ability to analyze user requirements, Business Requirement Specifications. • Expert in Data Preparation, Data Modeling and Data Blending. • Extensive experiencewithDAXFunctions Such as SUMX, CALCULATE, ALLEXCEPT, FILTER Functions. • Worked under Agile Methodology throughout the project, performed decisive role in developing and planning as well as coordinating with assigned sprints. • Expertise in Power BI Desktop, Power BI Service with Pro and Premium capacities • Excellent experience in Data Analysis, Data Cleansing, Data Verification using complex SQL query. • experience in creating advanced chart types, visualizations and complex calculations to manipulate the data as per business need through Power BI and Tableau • Hands on designing and deploying rich Graphic visualizations with Drill Down and Dropdown menu option and Parameterized dashboards using Tableau. • Expert in creating different visualizations using Slicers, Lines, Pies, Histograms, Maps, Scatter, Bullets, Heat Maps, Tree maps, etc. using Power BI and Tableau. • Generated context filters and data source filters while handling large volume of data using Power BI. • Involved in creating Filters, quick filters, table calculations, calculated measures and parameters in Power BI. • Hands on experience with MSBI (SSIS) to extract, transform and load data into database. • experience in Data Analysis, Data Cleansing, Integration, Data Import, and Data Export using ETL tools SSIS. • Experienced working with Excel Pivot, vlookup and other advance options. • Extensive experiencein gathering business requirements and involved in developing projects. • Proactive team player with capability of handling responsibilities independently as well as in a team • Good communication skillsand proven ability to perform both as an individual and as a team player.

Experience

1. Sql Server Power Bi Developer

   Apple

   May 2022 — Present

   Developed calculated columns and measures using DAX in Power BI• Used the tabular model cubes as the source in Power BI to visualize the data.• Created Power BI dashboard and generated reports. • Performed Power BI Desktop Data modeling, which cleans, transforms, mash up Data from multiple sources.• Created multiple transformations and loaded data from multiple sources into the Power BI Dashboard.• Published Power BI Desktop to the cloud. • Created interactive reports customized for the business using Power BI Desktop.• Installed and configured and maintained Power BI Report Server.• Worked Data Modeler and all team within the organization to understand business processes.• Developed complex SQL queries to obtain complex data from tables.• Read source data from HDFS,Azure SQL DB, CSV, ORACLE 11g,SQL Server 2016. through Power BI.• Read different formats of Source data from hive like JSON, ORC, TXT.• 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, • Used DAX table functions including FILTER, ALL, VALUES, DISTINCT and RELATEDTABLE.• Have used Z-order to overlap the reports on each other using Power BI.• Used Power BI, Power Pivot to develop data analysis prototype, and Power Map to visualize reports• Create and customize simple visualizations, Combination charts, Slicers, Map visualizations, Matrixes and tables, Scatter charts, Waterfall and funnel charts, Gauges and single-number cards.• Published Power BI Report and Made Power BI Dashboards available in Web clients.• Created multiple data model and used as a common data source for the reporting purpose.• Used Power BI Gateways to keep the dashboards and reports up to date