Business Analytics Power Bi

EDUCATION

YUGAL CHAUDHARY

LinkedIn ******************@*****.*** Hartford (CT) USA +1-959-***-****

University of Hartford,Hartford Connecticut USA August 2023 - May 2025 Master of Science in Business Analytics (MSBA) GPA: 3.83/4.0 Relevant courses: Business Statistics; Python for Business Analytics; Business Data Mining. SQL for Business Analytics; Data Visualization; Business Forecasting; Strategic Business Management. Indira Gandhi National University August 2013 - June 2016 Bachelor of Science in Administration

PROFESSIONAL EXPERIENCE

Expedia.com, Technology Driven online travel platform. February 2020 - March 2022 Business Process Analyst

● Extracted and analyzed large datasets from Silver and Gold customer segments using SQL, Excel, and Integrated Dashboard on Power BI to uncover actionable insights, track key performance metrics and support data-driven decision-making.

● Engineered a system overhaul using the Voyager tool to centralize and streamline 10,000+ customer accounts for technical support, decreased resolution time by 40% and improved customer satisfaction ratings by 25%

● Executed comprehensive promotional strategies for the EXPATS initiative, driving a 35% boost in user acquisition, developed and mentored new team members on client expectations, QA processes, system configuration and test plan development.

Telus Communication, Specializes in AI training data, digital transformation June 2016 -December2019 Marketing Analyst

● Analyzed the performance of marketing campaigns across multiple channels, utilizing analytics tools to measure key performance indicators (KPIs) such as conversion rates, click-through rates, and return on investment (ROI) and provide actionable insights for optimization.

● Leveraged marketing automation platforms to efficiently manage campaigns, segment target audiences and monitor performance, driving greater effectiveness and streamlined execution of marketing strategies.

● Designed, implemented and analyzed A/B tests to evaluate the effectiveness of various marketing tactics, using the results to refine strategies and optimize campaign performance for maximum impact. SKILLS & CERTIFICATIONS

Programming languages and Databases: ‘R’(ggplot2),Python (Pandas,NumPy,Matplotlib,Sklearn),MySQL,PostgreSQL,Oracle. Microsoft Skills: Microsoft Excel (Vlook up, Xlook up, Pivot table, Macros &VBA),Power Point Data Visualization Tools : Tableau, Power BI, Cognos,R Studio, Sisense, Google Charts, Visual.ly Certifications :The SQL bootcamp, Microsoft Power BI Desktop for Business Intelligence,Tableau training for data science PROJECTS

Netflix Movies and Shows SQL Analysis :

● Designed and optimized complex SQL queries to analyze a comprehensive dataset of Netflix movies and shows..

● Leveraged PostgreSQL to efficiently manage and query large datasets, ensuring high performance. Demonstrated advanced proficiency in SQL operations such as JOIN, GROUP BY, ORDER BY, and HAVING to generate actionable insights and identify trends across various dimensions of the data. GitHub Data Mining Project : Analyzed the sale prices of Toyota automobiles using machine learning techniques.

● Explored two key data mining techniques: Linear Regression and Decision tree.

● The Decision Tree Regressor outperforms Linear Regression in terms of Mean Absolute Error (1049.46 vs. 952.61), Mean Squared Error (2002823.32 vs.2050774.56), Root Mean Squared Error (1415.21 vs. 1432.05), and R- squared (0.8499 vs. 0.8463). The results suggested that the Decision Tree Regressor model provides more accurate predictions for the given dataset of Toyota Corolla prices. Machine Learning Project : Reinforcement Learning

● In the project, the Q-learning algorithm is used to teach an agent to navigate a grid world, moving between different states (representing rooms or locations) and reaching a target state while maximizing rewards.

● Gained proficiency in applying reinforcement learning concepts such as the Bellman Equation, policy iteration, and the exploration/exploitation dilemma.

Contact this candidate