Salt Lake Data Analyst

Sai Jaganathan Sadhankumar

Salt Lake City, Utah, United States 385-***-**** **************@*****.*** www.linkedin.com/in/saisd2804 Portfolio

SKILLS

Databases/Big Data: SQL Server, MySQL, Hive, Excel, Access, PostgreSQL, Oracle, Azure DB, Mango dB, Cassandra Analytics/Visualization/CRM: Tableau, Adobe Analytics, Google Analytics, Looker, Domo, Salesforce, Salesforce Reporting Web Tools/Technologies: HTML, Alteryx, SQL Server Management Studio Programming: R, Python, C++, Java, Java Script, SQL, SOQL Languages: English, Tamil

EXPERIENCE

Utah’s Promise – 211 Utah Salt Lake City

Data & Reporting Director / Data Analyst III Nov 2023 – Present Companies Collaborated: Stand together Foundation, University of Utah, Utah Department of Health and Human Services, Unite US, Utah Transit Authority

• Served as Salesforce expert, leading a team of super users to elevate Salesforce proficiency across the organization.

• Created comprehensive dashboards and visualizations in Tableau, Domo and Power BI, enabling stakeholders to better understand trends and performance metrics.

• Conducted Financial analysis of all existing expenses and cut down $65000 every year by eliminating overnight coverage provider for 211.

• Enhanced data accuracy by 56% by implementing validation measures, increasing overall accuracy from 23% to 79%.

• Piloted an AI project with University of Utah for a referral recommendation model.

• Developed and implemented new data measures, resulting in improved data disaggregation and enhanced team understanding of data usage.

• Led the preparation of data content for grants and annual impact reports about 211, driving the organization’s ability to secure funding and demonstrate program effectiveness.

• Led strategic planning initiatives for the 211 State system, aligning measurement frameworks with 5-year strategic goals to enhance statewide impact.

• Participated in internal and external data committees, contributing to the development of data governance practices and collaborative data strategies.

Financial Marketing Institute, Clients: American Century Investments, Nuveen Remote, Salt Lake City Data Scientist Sept 2022 – Feb 2023

• Facilitated the data collection and reporting process for 300+ clients from 7 different verticals over 8 different platforms.

• Utilized Python to conduct data modeling which attributed distinct weights to different attributes of each variable.

• Cleaned data in Power Query and built measures which resulted in increased accuracy for visualizations.

• Created dashboards in Power BI, resulting in better client understanding about their marketing efforts, benchmark performance, and trends in different platforms.

• Provided recommendations to improve dashboard aesthetics, providing more clear understanding of metrics for clients. University of Utah Campus Store Salt Lake City, Utah Data Analyst Intern May 2022 – Sept 2022

• Created visualizations of KPIs for gross margin reporting in Tableau to equip business leaders with decision power.

• Analyzed Starbucks data to find peak hours, which resulted in a decrease in wait time for customers of 45%.

• Created pivot tables to visualize customer surveys, analyzed data to bring in high-demand products, and utilized Power BI to determine the success of the new products.

• Compiled insights and learnings into a dashboard that was presented to managers for more effective decisions making.

• Supported data-driven decision-making processes for various departments in the organization. Dynamic Products India Pvt Ltd Chennai, India

Product Analyst Mar 2021 – Nov 2021

• Worked with the analytics team to gather insights for a new product to be launched, created reports in SSRS.

• Led research efforts to inform organizations of consumer behavior to increase product performance.

• Collected business user requirements and translated them into functional and technical specifications.

• Monitored the product’s performance and provided recommendations, which helped increase sales by 4%.

• Collected and stored user reviews of the product to implement it for upcoming product models. PROJECTS

Predict Customer Success – University of Utah / Swire Coca-Cola

• Conducted research for client organizations Swire Coca-Cola, to predict the popularity, longevity, and total 3-year sales volume of new customers, provided opportunity for client to make stronger decisions for funding and pricing of the business.

• Conducted EDA and Modeling in Python to gain an understanding of the data and to remove unnecessary predictor variables, which resulted in a model with 94% accuracy.

• Utilized PowerPoint and Tableau to create a presentation of our findings with a forecasting dashboard. Database Implementation - University of Utah

• Reverse engineered the Uber Eats application requirements in order to design a database in PostgreSQL and model a conceptual, logical, and physical model for the Uber Eats Application.

• Cleaned and visualized data for Uber Eats during their peak delivery times. Super Bowl Game Day Ad Analytics Competition, 3rd Place - University of Utah

• Analyzed ~1 million lines of Twitter data during the Superbowl, cleaned data in R and presented as an infographic.

• Used tools including MongoDB, Twitter API, Alteryx, and Tableau to analyze and visualize data.

• Created a KPI report and a sentiment analysis to show the best-performing ads with the most negligible production value and highest returns.

EDUCATION

University of Utah, David Eccles School of Business Salt Lake City, UT Master of Science, Business Analytics May 2023

ANNA UNIVERSITY India

Bachelor of Engineering, Computer Engineering May 2021

Contact this candidate