Mohit Agrawal Email & Phone Number

Houston, Tx, Us

Houston, Tx, Us

Spearheaded the development of 20+ Business Intelligence reports, 5+ data models/Dataflows, and 10+ Automation flows, driving around $60 Million in revenue by utilizing Power BI, SQL (Oracle & SSMS), Power Automate and other Data Solutions.• Consolidated 15+ enterprise reports into a single Power BI app, reducing report duplication by 60%.• Enhanced YoY/QoQ reporting, leading to more informed workforce planning and a 15% increase in forecasting accuracy.• Implemented Row-Level Security (RLS) and security groups, improving data access control across key reports and reducing data breach risks for 20+ Business Intelligence reports.• Focusing on providing stakeholders comprehensive organizational view to analyze and improve work culture by using Power BI and Advanced Viva Insights.

London, Other..., Gb

Expanded Power BI’s capabilities by creating unconventional charts like KPIs, Bar charts, Heat Maps, Histograms, etc. across 10+ Power BI reports and 3+ dashboards, resulting in a 25% improvement in data comprehension and stakeholder engagement.• Created SQL scripts to query-fold financial source data, and detect data inconsistencies, leading to improved data quality.• Conducted financial data analysis, utilizing AWS Redshift, Amazon S3, and AWS Lambda for data warehousing and performed ETL processes using AWS Glue.• Developed drilldowns, drill-throughs, Custom KPIs, and bookmarks within Power BI, simplifying data navigation and improving report storytelling, increasing stakeholder satisfaction.• Improved cross-functional team productivity by 30% using Agile methodologies and delivered projects with a 15% reduction in delays through streamlined workflows in a fast-paced environment.

Teaneck, New Jersey, Us

Designed and deployed cloud-based dashboards in Azure and AWS, monitoring 100+ Azure resources and enabling faster issue detection for development and quality testing teams.• Developed custom visuals using Python and Power BI, including advanced AI & machine learning visualizations, KPIs, and custom charts, leading to improved decision-making for key business units.• Configured Databricks clusters and integrated with Key Vault for enhanced security, enabling seamless data management & Data Engineering capabilities.• Built and maintained data pipelines using ADF, processing over 1 million records daily and improving ETL & Analytics efficiency.• Automated patching for 20+ VMs using Azure Automation accounts, saving 10+ hours of manual intervention per month.• Automated provisioning and decommissioning of Azure resources using Azure Automation accounts and GitLab CI/CD, reducing provisioning time by 40%.• Applied advanced Data Warehousing & Statistical Analysis concepts (star and snowflake schemas), optimizing data models, and reducing query execution times from 5 minutes to under 2 minutes.

Champaign, Il, Us

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

Champaign, Illinois, Us

• 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 EmbeddedPower Business Intelligence Solutions. • Designed a Strategy Document that defines the best practices of the Power BI and PowerBI Embedded model.

New Delhi, Delhi, In

Supervised the operations of 20+ drilling oil wells of K.G. Basin by preparing well data reports (SQL & Power BI).• Improved revenue by 8% through project management and strategy optimizations, showcasing strong Problem-Solving skills.• Enhanced the commercial viability of the rig by 15% by collaborating with Cross-Functional teams and by applying various condition-based problem-solving techniques.• 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.

Master Of Science - Ms, Technology Management

Bachelor Of Engineering (B.E.), Mechanical Engineering

Hsc, Pcm