Power Bi Business Analytics

SUMMARY

Dharmesh Dondapati

ad8aks@r.postjobfree.com 475-***-**** www.linkedin.com/in/dharmesh-d-0454b119b/ With four years of experience in the IT sector and advanced education in Business Analytics, I possess a unique mix of technical skills and analytical insight. I am skilled in analyzing data, managing projects, and using data to improve business strategies. My ability to apply analytical tools and techniques makes me well-suited for roles that demand both software engineering and business analysis skills. I aim to drive organizational growth and efficiency by leveraging data and technology. EDUCATION

Master of Science (MS) University of New Haven, West Haven, Connecticut May 2024 Concentration: Business Analytics GPA: 4.0/4.0

Bachelor of Engineering (BE) Anna University, Tamil Nadu, Chennai, India May 2017 Concentration: Electronics and Communications

TECHNICAL SKILLS AND TOOLS

R Studio, Tableau, Power BI, SQL, Python, C, C++, SPARK, Snowflake, Marketing, Finance, Problem Solving, Sports Analytics, Data Visualization, Data Mining, Operations Management, Machine Learning, Forecasting Techniques, ServiceNow, Microsoft Azure, Microsoft Excel, Citrix Workspace, Splunk, Customer service management, Regression Analysis, Customer Relationships, Quality Assurance, Data Mining, and Analytical reporting, Project Management, Crystal reports, Data Science, Expense management. WORK EXPERIENCE

IQVIA Durham, North Carolina

Senior IT Analyst July 2020 - July 2022

• Performed the extraction and analysis of detailed healthcare datasets within IQVIA IMS, focusing on critical metrics such as employee headcount (5,000+), Net Promoter Scores (NPS), weekly clinical trial counts (50–100 trials), and comprehensive financial reports. Utilized Power BI, R Studio, Tableau, and SQL to query large datasets, transforming raw data into insightful visualizations and reports. Delivered data-driven recommendations that led to a 15% boost in department operational efficiency.

• Developed complex SQL queries to optimize the extraction and analysis of large datasets, significantly reducing data processing times by 20%. Leveraged SQL to perform advanced data mining and analysis, ensuring data integrity and accuracy while analyzing multi-terabyte databases.

• Managed over 200 IT service requests per month via ServiceNow, maintaining a 95% resolution rate within SLA. Handled high-priority issues such as software malfunctions and licensing conflicts, ensuring business continuity by resolving critical weekend incidents within 2 hours on average.

• Automated the onboarding process for over 100 new employees by developing SQL-based workflows for data access, user provisioning, and IT tool allocation, cutting setup time by 30%. Created automated reports to track onboarding progress and tool utilization, improving efficiency and transparency across departments.

• Played a pivotal role in cross-functional IT service management by collaborating with the data engineering and IT operations teams. Utilized SQL to integrate multiple data sources, improving data accessibility and providing actionable insights through real-time dashboards, which supported decision-making for senior leadership. 247.ai New South Wales, Australia

Technical Analyst May 2018 - July 2020

• Played a key role in managing and resolving over 500+ technical issues for customers across NSW, Victoria, and Queensland, using ServiceNow for efficient incident and problem management. Achieved a 98% resolution rate within SLA by promptly diagnosing and addressing technical issues, minimizing downtime for clients, and enhancing service reliability.

• Coordinated with regional technical associates and cross-functional teams to ensure swift resolution of incidents, often resolving critical problems within 4 hours on average. Implemented escalation protocols and provided real-time updates to stakeholders, ensuring transparency and timely issue resolution.

• Analyzed billing data and identified patterns using Power BI, enabling more accurate forecasting and corrective actions. Created detailed daily reports and interactive dashboards to visualize key performance indicators (KPIs) such as resolution times, ticket volumes, and service reliability across regions. This data-driven approach helped reduce recurring billing issues by 10% and improved overall service delivery.

• As part of a 32-member technical support team, maintaining high service reliability, handling over 1,000+ service tickets monthly. Contributed to a 15% increase in customer satisfaction by streamlining technical support workflows, ensuring quick response times, and delivering consistent service quality. ACADEMIC PROJECTS

Statistical Insights in NBA Games

• Led a statistical analysis project on NBA games to determine factors influencing athletes' playing time, focusing on key performance metrics. Applied polynomial regression to analyze and visualize data on Game metrics. Quality Analysis of American Airlines

• Led a comprehensive quality analysis of American Airlines for a class project, integrating diverse metrics such as stock performance, customer reviews, Business Forecasting, and control charts. Walmart Store Sales Forecast & Factors Affecting Sales

• Conducted a comprehensive business forecasting project for Walmart store sales, identifying the most effective forecasting techniques. Analyzed key factors affecting sales such as CPI and fuel prices, using data visualization and Regression Models.

• Evaluated various forecasting models (ARIMA, Exponential Smoothing, Linear Regression, Seasonal Naïve) to predict future sales, emphasizing the accuracy and reliability of the models. Group Employee Analysis using Power BI

• Led a dynamic project focused on Employee Satisfaction Analysis, incorporating insightful graphs and analysis. Sales Performance Analysis of a Retail Store Chain using Tableau

• Led a Tableau project conducting a comprehensive Sales Performance Analysis for a Retail Store Chain.

• Employed advanced data visualization techniques to analyze sales data, identifying key factors influencing revenue and growth rates.

Revenue Growth Model: Adidas Sales Analysis

• Developed a comprehensive Revenue Growth Model for Adidas, providing in-depth sales analysis across major US regions to identify key market trends and growth opportunities.

• Utilized rigorous data preprocessing and exploratory data analysis to optimize pricing, product positioning, and marketing strategies. The project highlighted the importance of seasonal sales fluctuations and regional variations in consumer behavior, leading to strategic recommendations for enhancing Adidas' market dominance.

HONORS AND AWARDS

• Beta Gamma Sigma International honor society for collegiate schools of business membership (2024)

• High Scholastic achievement Recognition award in the University of New Haven for the Classes of 2024.

• Invited to Dr. Densen Cao's Spring Symposium focuses on the use of Forensic Investigative Genetic Genealogy in Criminal Investigations (2023)

• Certification in Data Analysis by Microsoft (2023)

• Certification in Data Science in Python from Data Camp (2023)

• Received the highest NPS employee award from Optus Telecommunications in the Bangalore region, India (2020)

• Certification in Cisco Certified Network Associate Routing and Switching (CCNA)

• Member of the Institution of Engineering and Technology (IET) and presented a paper of research on recent advancements in Signal Processing and Communications (2016)

• Conducted Xplore Robotics National Level Workshop in Chennai, India under the guidance of IET (2015)

Contact this candidate