Power Bi Data Analyst

Kanika Moondra

***************@*****.*** - www.linkedin.com/in/kanikamoondra05 - +1-385-***-****

Work Experience

Goldman Sachs & Co March,2020-Present

Vice President; Data Analytics

● Build, maintain, and optimize data visualization dashboards, empowering the leadership team to access actionable insights (Tableau, Business Objects, Alteryx, SQL, Python/R, Power BI)

● Led the migration of Application Tracking System by implementing and maintaining data architecture (ETL) around automated ingestion, data security, compliance and governance

● Created predictive data model to improve hiring strategy for the firm by 80% thereby cutting down the manual efforts in excel

● Collaborate with data engineers and business stakeholders to understand data requirements and translate them into scalable data solutions

● Partner with key business stakeholders, cross functional teams to define key business KPIs and provide strategic recommendations that help in decision making

● Lead quarterly headcount planning process with Finance and HR leadership team

● Manage multiple projects by creating timelines from conception to completion using JIRA FireEye Inc.May-November,2019

Data Analyst Intern Milpitas, CA

● Analyzed Engagement Survey data to empower Business Partners with high-quality data insights using Tableau, Power BI and SQL to spot the trends of company-wide initiatives like Inclusion and Diversity, One Team etc.

● Created Tableau reports for Quarterly Business Review in order to analyze company-wide data like headcount, recruiting metrics, turnover rates, demographics etc.

● Automated Engagement Survey data transformation process thereby increasing the efficiency by 98% Cross Creek Advisors-Venture Capital January-April,2019 Finance Data Analyst Intern Salt Lake City, UT

● Created Power BI dashboards to determine the feasibility of different startup financial models by looking at revenue growth drivers, implied financial ratios, and burn rates matched with runway.

● Audited the bank statements and financials for potential acquisitions.

● Analyzed company financials, identified key operating metrics, determined potential exogenous risks and cost drivers Education

University of Utah; David Eccles School of Business December,2019 Master of Science in Information Systems and Graduate Certificate in Business Analytics; GPA: 3.8 Salt Lake City, UT Courses: Database Management System, Business Analytics, Data Visualization, Statistics and Predictive Analytics, Data Mining, System Analysis and Design, Python for Data Science, Digital Marketing, Big Data (Hadoop), Deep Dive with TensorFlow, Big Data with PySpark Rajasthan Technical University; Poornima College of Engineering May,2016 Bachelor of Technology in Electrical Engineering Jaipur, India Technical Skills: R, SQL, Python, Tableau, Power BI, Hadoop, PIG, HIVE, PySpark, Domo, QlikView, Google Analytics, SAS, Alteryx, Business Objects, A/B Testing

Academic Projects

University of Utah Sports Athletics; Women Soccer Team (vue.js, SQL, Power BI, R)November,2018-December,2019

● Built user friendly web forms to gather performance data of players and pushing this data to SQL Database

● Tracking key performance indicators of the players to analyze their performance trends as well as predicting future risk of injury to improve wellness of players.

Stock Price Prediction based on Tweets and News Headlines (Python)February-May,2019

● Scraped data from Twitter API and NASDAQ to get tweets and news related to 5 big brands and visualizing the trend of stock price

● Applied sentiment analysis and Machine Learning algorithms on the tweets and news feed to predict the change in stock prices. Kaggle Competition: Predicting House Prices in Ames, Iowa (Using R)October-December,2018

● Summarized, cleaned and performed exploratory data analysis on train data set to predict the final sale prices of each home on test dataset using automatic variable selection to pick out the best predictors and applied multiple regression methods to find out the best model with lowest error in order to predict the value of Sales Price in test dataset

● Achieved RMSE (Root Mean Squared Error) =12500 and R^2=0.85 which led to a real time Kaggle score=0.15 (0 being highest) Database Prototype of a Company (https://prezi.com/p/27nlwo6mailc/) (SQL)September -October,2018

● Created a conceptual and relational model of company “US Career Services” which would provide information on multiple attributes like courses and degrees offered, total number of students enrolled, overall ranking, Infrastructure details etc. of different Universities.

● Implemented SQL queries to create a University database which would help the students compare attributes of different Universities and choose a particular University to apply for in order to fulfill their career goal.

Contact this candidate