Jagadish G

Ernst and Young- GDS 10/2022 – Present

● Delivered actionable insights by creating custom Microsoft Power BI dashboards, visualizations, and 28 interfaces with Microsoft SSRS.

● Worked with Power BI tools like Data visualizations, Data Modelling Creating reports, creating Workspaces, and DAX Functions

● Worked with DAX Time intelligence functions like YTD, QTD,MTD, and aggregated function also,

● Having good experience With Data Visualization like (Pie chart, Bar Chart, Stacked column chart, water fall chart, Map Visual, KPI Chart, Card Chart

● Good Experience with RLS Dynamic and Static,

● Good experience with Edit interaction and working with focus mode also.

● Good Experience with Data Relationship like (One to many, Many to One Many To many etc )

● Good experience with Bookmarks Overlapping(Creating visuals and also Buttons providing the actions for that buttons)

● Having Great Experience with power BI Service, (Creating Workspace, and Dashboards for Streaming data, sharing reports).

● Worked with Azure services such as – Azure Storage, Azure Lake Storage, Azure SQL Database, and Azure Data Factory.

● Collaborated with azure data engineers and operation team to implement the ETL process using Azure Data Factory wrote and optimized SQL queries to perform data extraction to fit the analytical requirements.

● Performed data cleaning including transforming variables and dealing with missing value and ensured data quality, consistency, integrity using ADF.

• Gathering the requirements from business users and analyzing those requirements and providing estimates
• Preparing the Power BI data model as per the requirement by having appropriate relationships
• Having Knowledge on using advanced calculations using power BI desktop
• Extract data from different kind of source systems into Power BI and then cleansing the data by applying business rules and loading it into Power BI
• Develop Power BI reports & Effective dashboards after gathering and translating end user requirement
• Experience in creating dashboards and presentation and graphs
• Experience in Custom visuals and Group's creations
• Experience in Configuring Gateways in the power BI services
• Expert knowledge scheduling power BI reports in online version
• Ensure timely delivery and quality of delivery by adhering to quality process
• Decreased the processing time for 1.5K daily orders by 77% with automation tools like Power BI and SSIS.

• Reduced the time spent analyzing data by 93% through automation of manual processes using Python scripts
• Worked on SQL
• Loader, Writing of .ctl file to perform basic validations
• Database Designing, Created scripts to create new tables, views, materialized views queries for new enhancement in the application using SQL
• PLUS
• Extensively used bulk collection in PL/SQL objects for improving the performing
• Gathering the requirements from business users and analyzing those requirements and providing estimates
• Preparing the Power BI data model as per the requirement by having appropriate relationships
• Extract data from different kind of source systems into Power BI and then cleansing the data by applying business rules and loading it into Power BI
• Develop Power BI reports & Effective dashboards after gathering and translating end user.