Mohit Agrawal
Sr. Business Intelligence Engineer at Nephos Technologies- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Credentials
-
Advanced Microsoft Power BI
LinkedInJul, 2023- Sep, 2024 -
Career Essentials in Generative AI by Microsoft and LinkedIn
MicrosoftJul, 2023- Sep, 2024 -
Data Engineering with AWS Part 2
LinkedInJul, 2023- Sep, 2024 -
Power BI: Integrating AI and Machine Learning
LinkedInJul, 2023- Sep, 2024 -
Data Engineering with AWS Part 1
LinkedInJun, 2023- Sep, 2024 -
Implementing a Data Warehouse with SQL Server 2022
LinkedInJun, 2023- Sep, 2024 -
Power BI Data Modeling with DAX
LinkedInJun, 2023- Sep, 2024 -
Amazon Web Services: Data Analytics
LinkedInMay, 2023- Sep, 2024 -
SQL(Basic)
HackerRankMar, 2022- Sep, 2024 -
Introduction to Web Development
University of California, DavisApr, 2020- Sep, 2024 -
Data Science Methodology
IBMMar, 2020- Sep, 2024 -
Learning Jira Software
LinkedInMar, 2020- Sep, 2024 -
Open Source tools for Data Science
CourseraMar, 2020- Sep, 2024 -
What is Data Science?
CourseraJan, 2020- Sep, 2024 -
Open Source Tools for Data Science
Coursera
Experience
-
Nephos Technologies
-
United States
-
Information Technology & Services
-
Sr. Business Intelligence Engineer
-
Jul 2022 - Present
Client – DISYS (Realpage) • Stretched Power BI limits to create unconventional Power BI charts such as Grouped Bar Charts, Donut Charts, Bar-in-Bar Charts, Gantt Charts, stacked bar charts, Histograms, Bullets, Heat maps, and some out-of-the-box visualizations. • Lead the migration of on-premises infrastructure to AWS cloud, resulting in cost savings and improved scalability. • Utilized AWS Redshift for data warehousing and performed ETL processes using AWS Glue to extract, transform, and load data from various sources. • Developed and maintained data models and dashboards in AWS QuickSight, enabling stakeholders to access and visualize data insights. • Utilized advanced analysis actions, calculations, parameters, background images, maps, trend lines, groups, hierarchies, detail-level summary report sets, and KPI dashboards. • Developed and reviewed simultaneous SQL queries with the use of join clauses (inner, left, and right) in Power BI Desktop and SSMS to validate static and dynamic data for data validation. • Communicated effectively across multiple platforms and departments by performing various QA tasks and evaluating workflow. • Developed Power BI reports and dashboards from multiple data sources using data blending. • Created Drilldowns, drill through and bookmarks in Power BI reports for easy navigation and story-telling. • Developed SQL queries /scripts to validate the data such as checking duplicates, null values, and truncated values and ensuring correct data aggregations. • Extensively used SQL queries to verify and validate database updates. • Aligned with Agile Methodologies, scrum stories, and sprints in association with data analytics and Excel data extracts. Show less
-
-
-
Cognizant
-
Uzbekistan
-
Education
-
1 - 100 Employee
-
Sr. Business Intelligence Engineer
-
Dec 2020 - Dec 2022
Client – Nestle • Created 20+ Power BI reports across 3 Dashboards by directly fetching the data from Azure Databricks. • Transformed the raw data in Power BI Query Editor to improve the efficiency of reports and quality of the data. • Improved visuals by creating Calculated Columns and DAX Measures. • Published dashboards on cloud and provided Row Level Security, Dashboard level security and scheduled 48 Automatic Refreshes for stakeholders. • Improved performance of data by writing SQL queries that involved JOINS, Windows Functions, SQL Aggregate functions, DATE Functions etc. • Built daily/monthly/reconciled production, inventory, allocation, provisional dashboards of onshore or offshore platforms to monitor production and operational KPIs in Power BI. • Used Power BI, and Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports. • Created Data Models in Power BI to generate visuals of interconnected data. Client – T - Mobile • Lead a team of 15 engineers and developers to carry-out daily Azure & AWS platform activities. • Monitored Azure resources by designing end-to-end Azure and AWS cloud-based analytics dashboards using KUSTO queries for application Development, Quality Testing & Production. • Assisted in the development of data analytics tools and platforms, leveraging AWS services such as S3 and EMR. • Created incremental refreshes for Power BI data sources on Power BI server. • Trained over 20 end users across 5 departments on how to use the Power BI dashboards. • Expertise in designing and creating various analytical dashboards in Power BI to help users to identify critical KPIs and facilitate strategic planning in the organization. • Proficient in creating measures using DAX Formulas and Calculated Columns in Power BI. Used time intelligence functions, logical functions, conditional formatting, variables. • Configured Databricks Clusters and linked the same with Key Vault using secret scopes. Show less
-
-
-
University of Illinois at Urbana-Champaign
-
Higher Education
-
1 - 100 Employee
-
Power BI & Azure Developer (Research Assistant)
-
Feb 2020 - Aug 2020
• Converted text data of a hospital into a relational database by using Python (Pandas). • Analyzed the healthcare data to match standard medicines with prescribed medicines using NLTK, FUZZYWUZZY, and Regular Expression to test the accuracy of prescription. • Extracted, Loaded & Transformed data using Data Flow Feature within ADF and Monitored Data Flow using Triggers. • Authored Mapping Data flow activities by leveraging the Canvas feature of Data Flow in ADF. • Transformed data in Data Flow Feature by using transformation settings such as Optimize, Inspect, etc. • Performed data analysis by writing DAX, SQL, and integrated Machine Learning with Python in Power BI to prepare data for further Text Matching and Topic Modelling. • Worked on Preparing Source to Data Mapping documentation for end clients. • Imported the data from 5 data sources from Files, Cloud, SQL Server, and SAP into Azure Data Lake using ADF. • Created end-to-end solution with Azure Stream Analytics by using Event Hubs. • Migrated real-time data into Power BI by using Azure Stream Analytics to create Power BI Streaming Dashboards. • Performed Azure Data Lake Analytical Transformations on top of Azure Data Lake data using USQL. • Loaded the Transformed data into the Azure SQL Data Warehouse accordingly and created Power BI Dashboards by taking input from the data warehouse. • Divided current data load pipelines into multiple pipelines to load data in smaller datasets. • Re-test all data loads from source systems into the data warehouse. • Oversee the deployment of data to the Data Warehouse. • Monitored Performance Metrics of Data Pipelines in the Data Factory constantly. Show less
-
-
-
-
Sr. BI Consultant, Strategic Operations Department
-
Jan 2020 - May 2020
• Provided strategy consulting for an Educational Institute in the data management industry by using Power BI. • Analyzed data to help clients establish a business model regarding market entry and positioning using SQL and Power BI. • Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging. • Performed data transformation by sorting and filtering over 150,000 rows of data using DAX calculations in Power BI. • Created a comprehensive Power BI reporting system to enhance the operations of the client’s business and make valuable data-driven decisions. • Helped the client in re-defining the business requirements such that it meets the industry standards. • Created a Master Dataset Drop Down for every respective client using Power BI Embedded by writing Filters. • Designed an Application in Visual Studio which uses the client id and application id obtained during the creation of the Power BI App in Microsoft Azure Active Directory to hit the rest APIs of Power BI. • Communicated with the client on a regular basis to provide them the day-to-day knowledge transfer on Embedded Power Business Intelligence Solutions. • Designed a Strategy Document that defines the best practices of the Power BI and PowerBI Embedded model. Show less
-
-
-
Oil and Natural Gas Corporation Ltd
-
India
-
Oil and Gas
-
700 & Above Employee
-
Engineer (Azure & Power BI)
-
Apr 2016 - Jun 2019
• Supervised the operations of 20+ Onshore drilling oil wells of K.G. Basin by preparing well data reports (MS Excel). • Enhanced the commercial viability of the rig by 15% from 2017 to 2018 by collaborating with Cross-Functional teams and by applying various condition-based problem-solving techniques. • Used Power BI with DAX for developing reports and KPIs for the organization and departments. • Converted existing multidimensional cubes to the tabular model, recreated all existing measures using DAX, and release to Azure Cloud analysis service. • Spearheaded the company’s procurement process by creating and enhancing 10+ spare parts procurement reports through writing SQL queries by using functions, JOINS, views, and creating data models. • Collaborated with service providers such as Schlumberger, Baker Hughes, and Weatherford to carry out overall drilling operations. • Enacted delivery upon completion of projects and ensure that delivery adheres to Agile practices maintained by the company. • Improved monthly revenue by 8% through effective project management and strategy optimizations. • Worked with more than 5 TB of data Migration using Microsoft Azure Data Factory Version V2. Show less
-
-
Education
-
2019 - 2020
University of Illinois at Urbana-Champaign
Master of Science - MS, Technology Management -
2010 - 2014
Rajiv Gandhi Prodyogiki Vishwavidyalaya
Bachelor of Engineering (B.E.), Mechanical Engineering -
1998 - 2010
Vivekanand Vidya Vihar
Hsc, PCM
Community
