Hrishi Bhargava

Hrishi Bhargava

Data Engineer
Canada

About Me

A Microsoft Power BI Developer with 1 an half years of experience in Data Warehousing, Azure Data warehouse concepts, BI applications design, development and maintenance along with working with pipelines Expertise with S…

Experience

Associate Developer

Jade global Inc
Feb 2020 - Present · 6 years 5 months

· A Microsoft Power BI Developer with 1 an half years of experience in Data Warehousing, Azure Data warehouse
concepts, BI applications design, development and maintenance along with working with pipelines
Expertise with SQL Server in constructing tables, triggers, user defined functions, views, indexes, stored
procedures, user profiles, relational database models
and data integrity.
Well versed in Normalization/ Denormalization techniques for optimum performance in relative and
dimensional database environments.
Write DAX Queries and M Queries in Power BI
Experience in Azure Data Factory, Azure Data bricks , Azure Synapse and also Azure Data Lake
Experience in Fact and Dimensional Data Modeling Star and Snowflake Schemas.
Flexible, enthusiastic, and project-oriented team player with excellent written, verbal communication to develop
creative solutions for challenging client needs.
Hands on experience in calculating columns and measures using DAX in Power BI based on report requirements.
Creating reports using visualizations such as Bar chart, Clustered Column Chart, Waterfall Chart ,Gauge, Pie
Chart, Tree map etc. in Power BI.
Worked with business teams and cross-functional partners to determine true reporting need, align on report, and
tool outputs
Using several types of visualization Like (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart ,Donut
Chart, Line & Clustered Column Chart, Map,
Slicer, Time Brush etc.
Experience with Business Intelligence tools such as Power BI, Tableau.

Data Engineer

Jade Global • Hyderanad, Telengana

Created numerous efficient Stored Procedures to perform data cleansing and loading task when data is loaded into staging area.
Worked in Agile methodology to discuss status of the project twice a week and take further measures which includes scrum meetings daily to discuss product backlog.
Worked on transforming data into user-friendly visualization to give business users a complete view of their business using Power BI.
Provided maintenance and development of bugs fixes for the existing and new Power BI reports.
Installed and configured Enterprise gateway and Personal gateway in PowerBI service.
Design, develop and maintain data management tools that support Sales, product management, supply Chain, and finance teams.
Worked on Azure data factory and Azure data bricks along with some other Azure cloud applications
Developed Reports to generate daily, weekly, monthly, quarterly, yearly Reports using Crystal Reports.
Scheduled the reports to run on daily, weekly basis in the report manager.
Scheduled Automatic refresh and scheduling refresh in Power BI service.
Provided production support on the existing PowerBI Dashboards to resolve the issues quickly and published Power BI Desktop reports created in Report View to the Power BI service.
Published reports to Azure-based Power BI services and schedule subscription & sharing options.
Leveraged Azure Data bricks to set up and manage clusters, create notebooks, and develop Spark jobs, resulting in a 30% reduction in data processing time.
Designed and implemented ETL pipelines using Azure Data Factory, orchestrating data workflows from diverse sources to a data warehouse, enhancing data accessibility and accuracy.
Integrated and transformed data from on-premises and cloud sources, ensuring data consistency and quality while reducing manual intervention by 25%.
Optimized Azure Data bricks clusters and Azure Data Factory pipelines to achieve cost savings of $50,000 annually while improving performance.
Complex SQL queries as per the requirement and exported to Excel, Flat file.
Provided production support on the existing Power BI Dashboards and other ETL processes to resolve the issues quickly.
Conducted meetings with business stake holders, clients and director level members for requirement gatherings and presented various solutions using best practices.
Optimize SQL queries for improved performance and availability.
Configured and monitored database application.
Worked with Quality assurance to develop test plans and test cases to conduct system testing.

Skills

Apache Tomcat Configuration Asp.Net MVC C++ Language (C++) Cobol HTML (Hyper Text Markup Language) Java JavaScript Development JQuery Python Software Engineering Structured Query Language (SQL) XHTML Operational Process Css3 HTML5 Power BI Data Warehousing Azure Data Warehouse SQL Server Tables Triggers User Defined Functions Views Indexes Stored Procedures Relational Database Models Normalization Denormalization DAX M Queries Azure Data Factory Azure Databricks Azure Synapse Azure Data Lake Fact Modeling Dimensional Data Modeling Star Schema Snowflake Schema Communication Business Intelligence Tableau Excel SSAS Agile Methodology Scrum Crystal Reports SSIS CA Rally TFS Jira Microsoft Visual Studio .NET PL/SQL T-SQL
Report this Profile?