Mohit Dundu Email & Phone Number

Arlington, TX, US

Arlington, Texas, United States

@ Center for Entrepreneurship and Technology Development - UTA

Arlington, Texas, United States

• Consolidated and analyzed financial data from over 20 Excel sheets, leveraging data analytics techniques. Developed interactive dashboards on Power BI using Data Analysis Expressions (DAX) to monitor and present.
• Boosted UTA research visibility by implementing strategic SEO keyword optimization techniques, resulting in a 10% increase in online presence and improved search engine rankings using Google Analytics.
• Collaborated with Research Office's tech transfer unit, facilitating new patent applications and monetization of 80% existing patents.
• Balanced tasks: 25% Non-Confidential Disclosure creation and 75% market research for emerging technologies, and sent out campaigns using Hubspot CRM.
• Produced weekly stakeholder presentations, including 2+ detailed visual dashboards, after analyzing research materials.

Arlington, Texas, United States

• Ensured outstanding customer service by providing direct IT support to students, faculty, and staff in university activities, by resolving 20+ issues every day on ServiceNow platform.
• Provided first-tier support through effective communication for personal computing devices, server applications, and hardware.

Dallas, Texas, United States

• Developed and maintained Tableau dashboards to visualize key performance indicators (KPIs) and trends in oil and natural gas production, consumption, and distribution.
• Utilized MSSQL Server for efficient data storage, retrieval, and transformation to facilitate data analysis processes.
• Conducted comprehensive data cleansing, transformation, and aggregation to prepare data for analysis, ensuring data accuracy and reliability.
• Analyzed complex energy data sets using advanced SQL queries to derive insights, trends, and anomalies, aiding in informed decision-making for operational efficiency.
• Collaborated with cross-functional teams to identify data requirements and design appropriate data models for effective data storage and retrieval in MSSQL Server.
• Prepared and presented actionable insights from Tableau visualizations to management, enabling data-driven decision-making and strategic planning.

Bengaluru, Karnataka, India

• Senior Project Engineer (Data Analyst) – Wipro Ltd., Bangalore, India [Jul 2019-Oct 2021]Examined sales and campaign effectiveness of push alerts, promotions, and emails for a Fortune 50 retail organization.
• Developed dynamic Tableau dashboards using AWS Redshift to monitor impact of weekly promotions during winter 2020.
• Led large-scale data analysis on email and push notifications using Google Analytics, resulting in a 25% increase in engagement rates. Automated ad-hoc data gathering and quality checks using advanced Excel-based VBA.
• Examined sales analysis of A/B Testing, both in-store and e-commerce, to a 33% increase in data-driven decision-making.
• Impact - Achieved significant cost savings of approximately $300,000 promo amount for clients during holiday season.Test Analysis Support of Automotive Infotainment System for Ford Motor Company, USA.
• Spearheaded development of Python-based analytical tools with 10+ cross-functional teams, using object-oriented programming for data engineer and handling of over 10,000 daily unstructured artifact data files in JSON.

Master Of Science - Ms, Information Systems And Business Analytics, 3.9

Bachelor Of Technology - B.Tech, Electronics And Communication Engineering, 8.48