Hrishi Bhargava

Hrishi Bhargava

Data Engineer
Canada

نبذة عني

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…

الخبرة

Associate Developer

Jade global Inc
Feb 2020 - حتى الآن · 6 سنوات 5 أشهر

· 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.

المهارات

تكوين Apache Tomcat Asp.Net MVC لغة C++ كوبول لغة ترميز النص الفائق جافا تطوير JavaScript جي كويري بايثون (لغة برمجة) هندسة البرمجيات لغة الاستعلامات الهيكلية (SQL) اكس اتش تي ام ال (لغة ترميز) عملية التشغيل CSS3 إتش تي إم إل 5 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
الإبلاغ عن هذا الملف الشخصي؟