Sign in

Business Intelligence Analyst

Hartford, CT
January 15, 2020

Contact this candidate


Sai Pratheek Rao Anugu

** ******** ******, ********, **- 06103 • 860-***-**** • • 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

Contact this candidate