Sai Pratheek Rao Anugu
** ******** ******, ********, **- 06103 • 860-***-**** • adba9w@r.postjobfree.com • LinkedIn Self-motivated Business Intelligence Analyst with first-rate analytical skills, ability and passion to work for company’s vision. Proficient in data visualization, statistics, SQL, Python, Tableau, AWS and can interpret data to drive business solutions. EDUCATION:
University of Connecticut School of Business, Hartford, CT Jan 2019 - Aug 2020 Master of Science - Business Analytics and Project Management GPA -3.70/4.00 Coursework: Statistics in R, Predictive Modeling, Databases (SQL), Data Mining using SAS, Marketing and Digital Analytics
JB Institute of Technology, Hyderabad, TS, India Aug 2014 - May 2018 Bachelor of Technology - Electronics and Communication Engineering GPA – 3.70/4.00 EXPERIENCE:
UCONN Foundation, Hartford, CT Sep 2019 - Present
Business Intelligence Student Analyst Power BI SQL Excel Python Azure Machine learning studio
Worked cross-functionally with technical departments; Developed statistical and predictive models to optimize marketing, digital audience engagement and delivered insightful recommendations that augmented business decision making
Built dimensional data models using SQL and developed ETL procedures to enhance the CRM based data marts/warehouses
Designed intuitive Power BI reports as per organization’s needs. Identified KPI's for clustering of donors based on historical donations and defined key metrics to target donors with an accuracy improvement of 10% Net Impact - Riverfront Recapture, Hartford, CT Jan 2019 – Present Data Analytics Consultant Tableau Excel SQL
Leveraged various techniques in Tableau to construct donor retention models, resulting in decrease of donor churn by 15%
Performed donor segmentation using clustering. Suggested different medium of communications to reach out to customers in different clusters and increased conversion rate by 21%. Optimized marketing expenses and thereby boosted ROMI
Created tableau dashboards to visualize donation trends and forecasted donations by existing donors with 70% accuracy Start-up (PIC), Hyderabad, India Dec 2017 – Jun 2018 Market Research Analyst
Set up a team of 5; Developed SQL scripts for data extraction & preparation, crafted interactive tableau dashboards to track metrics of job market. Connected placement cells of various colleges in Hyderabad and increased on campus jobs among students
Initiated Entrepreneurship cells in various colleges and helped students in building their startups TECHNICAL SKILLS:
Certifications: Tableau Certified Desktop Specialist, Google Analytics Individual Qualification
Languages and Tools: Python, R, SAS Enterprise Miner, Access, Outlook, Salesforce, SAS JMP, Google Analytics, Tableau, PowerPoint, Visio, MS Project, Jupyter, SPSS, SharePoint, Excel, Power BI, NumPy, Pandas, S3, EC2
Databases: Oracle 11g, SQL, MySQL, SQL server, Hadoop, PostgreSQL, Dimensional Modelling, Data Warehousing
Statistical Techniques: Linear and Logistic Regression, K Means Clustering, Naïve Bayes, Random Forests, Decision Trees, KNN, Dimensionality Reduction, A/B Testing, Neural Networks, Gradient Descent, ANOVA, Hypothesis Testing, Classification, SVM, PCA
Analytical Skills: Data cleaning, Data Mining, Text Analytics, Exploratory Data Analysis, Profiling, VLOOKUP, Pivoting, Swim lane, Time series, ARIMA, Gantt Chart, Text Mining, AWS, Azure, Project Management, Risk and Cost Management, FMEA, Visualization ACADEMIC PROJECTS:
Potoo Data Challenge: Leveraged Tableau on historic amazon data and identified correlation between stock price of PLC and variables unit price, sales etc. Provided actionable recommendations to protect brand reputation & sales from illegal sellers
Predicting Hospital readmissions of Diabetic Patients: Analyzed patient history data and provided insights to reduce Gaps in Care. Modelled data with Random Forest method to predict likelihood of patient readmitting and achieved 94% accuracy
Bank Customer Analysis: Constructed classification models to identify factors influencing bank’s customer churn. Implemented Feature engineering, transforming, cleaning and built LGB model with 80% accuracy
Asset Management System: Created swim lane, ERD and prepared database to improve current asset management system AWARDS AND RECOGNITION:
Published a novel “Love Life Tale”
Chair- IEEE Student branch (2017-18), Chair- IETE Student branch (2016-18) and President - college, JBIET, Hyderabad