Mohit Agrawal Email and Phone Number
Mohit Agrawal work email
- Valid
Mohit Agrawal personal email
Mohit is a result-driven professional with a strong focus on leveraging AI to optimize data management processes. With 5+ years of experience, he has successfully delivered AI-driven solutions, harnessing the power of cutting-edge technologies to enhance business intelligence and reporting capabilities.Key Skills:AI-driven Solutions: Mohit has a proven track record of designing and implementing AI-driven solutions for complex data management challenges. He excels in utilizing various AI technologies to drive business intelligence and analytics.Power BI Expertise: Mohit is highly proficient in leveraging Power BI to create compelling reports and visualizations. He possesses in-depth knowledge of Power BI elements, including Power BI Desktop, Power BI Service, and Power BI Mobile. Mohit uses Power BI's AI capabilities to deliver insightful data insights.SQL Proficiency: Mohit has strong database programming skills, specializing in SQL. He is skilled in creating tables, views, indexes, and joins, and incorporates AI techniques into database operations, enabling advanced data management and analytics.Azure Integration: Mohit has hands-on experience with Azure and AWS, leveraging their capabilities for data management and analysis. He utilizes Azure and AWS services to streamline workflows and enhance data processing efficiency.Experience Highlights:AI-Driven Business Intelligence: Mohit has successfully designed and developed complex reports and dashboards using AI-driven insights within Power BI and Tableau. He effectively communicates highly complex information to diverse stakeholders, enabling data-driven decision-making.Diverse Database Experience: Mohit has worked extensively with SQL databases, including data modeling and optimization. He has also gained experience with Azure's database services, leveraging its scalability and performance for efficient data management.Conclusion:Mohit brings a dynamic approach to leveraging AI for optimizing data management processes. With expertise in Power BI, SQL, AWS, and Azure, he excels in delivering AI-driven solutions for business intelligence and analytics. Mohit's proficiency in Power BI, coupled with his strong SQL and Azure integration skills, enables him to provide impactful data insights and streamline data workflows. He is dedicated to staying ahead of the curve in the ever-evolving AI landscape, ensuring that he consistently delivers innovative and value-driven solutions.
Crown Castle
View- Website:
- crowncastle.com
- Employees:
- 5107
-
Crown CastleHouston, Tx, Us
-
Business Intelligence Engineer IiiCrown Castle Oct 2023 - PresentHouston, Tx, UsSpearheaded 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.
-
Business Intelligence EngineerNephos Technologies Jul 2022 - Oct 2023London, Other..., GbExpanded 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. -
Business Intelligence EngineerCognizant Dec 2020 - Dec 2022Teaneck, New Jersey, UsDesigned 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. -
Power Bi & Azure Developer (Research Assistant)University Of Illinois At Urbana-Champaign Feb 2020 - Aug 2020Champaign, 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. -
Sr. Bi Consultant, Strategic Operations DepartmentBusiness Intelligence Group At Uiuc Jan 2020 - May 2020Champaign, 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. -
Executive Engineer (Bi)Oil And Natural Gas Corporation Ltd Apr 2016 - Jun 2019New Delhi, Delhi, InSupervised 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.
Mohit Agrawal Education Details
-
University Of Illinois Urbana-ChampaignTechnology Management -
Rajiv Gandhi Prodyogiki VishwavidyalayaMechanical Engineering
-
Vivekanand Vidya ViharPcm
Frequently Asked Questions about Mohit Agrawal
What company does Mohit Agrawal work for?
Mohit Agrawal works for Crown Castle
What is Mohit Agrawal's role at the current company?
Mohit Agrawal's current role is Business Intelligence Engineer | Microsoft Power BI Expert | Amazon Web Services (AWS) | Oracle | AI Driven Solutions | SQL | Azure | Data Management Professional.
What is Mohit Agrawal's email address?
Mohit Agrawal's email address is mo****@****ant.com
What schools did Mohit Agrawal attend?
Mohit Agrawal attended University Of Illinois Urbana-Champaign, Rajiv Gandhi Prodyogiki Vishwavidyalaya, Vivekanand Vidya Vihar.
Who are Mohit Agrawal's colleagues?
Mohit Agrawal's colleagues are Katie Merce, Roberto Pena, Ashley Greenspan, Nicole Amodeo, Jeremy Noble, Chris L., Nitsa Crenshaw.
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial