ADITHYA S PRASAD

Mission Hill, Boston, MA 857-***-**** adh7fu@r.postjobfree.com https://www.linkedin.com/in/adithya-prasad-b42632168/

EDUCATION

Northeastern University, Boston, MA August 2020

Master of Science in Data Analytics Engineering GPA: 3.8/4.0

Coursework: Data Warehousing, Data Mining, Database Design, Machine Learning, Economic Decision Making, Operations Research.

Visvesvaraya Technological University, Bangalore, India June 2017

Bachelor of Engineering in Electronics and Communication GPA: 3.5/4/0

SKILLS

Programming Languages: Python ( Pandas, NumPy, Seaborn, Plotly), R( GGplot, Dplyr, Caret), PostgreSQL, Java, C++.

Business Intelligence Tools: Tableau, Power BI, SSIS, SSAS, Talend, Informatica, Alteryx, QlikView, Flourish, Looker, Domo.

Other Competencies: MS office, Salesforce, JIRA, Confluence, Google Ads, AWS-Suite, GIT, Google Ads, Marketo.

Certifications: Tableau Desktop Certified Associate, AWS Cloud Practitioner, Six Sigma Green Belt.

PROFESSIONAL EXPIRIENCE

Framework Homeownership LLC, Boston, MA June 2019 – March 2020

Data Analyst Co-op

Spearheaded the development of Power BI dashboards for visualization of KPIs such as revenue growth rate, net profit margin, ROI, and refund rates across regions, market segments, and demographics leading to incremental sales growth by 20%.

Designed a Snowflake schema-based data model and developed ETL pipelines to transfer Framework’s data in Zendesk, PayPal, LMS, and Salesforce into SSMS using data flow tasks in SSIS replacing hand-coded techniques saving about 2 hours per run.

Automated 10+ product sales and financial reports using R and DAX in Power BI saving over 20 hours a week of manual reporting.

Created user stories for tracking functionalities such as weekly downloads, daily and monthly active users, user retention rates, referring sources, and financial factors for newly launched products and deployed complex SQL queries (joins, triggers, views) for reporting.

Successfully implemented and launched JIRA across all business units by working closely with CTO to schedule meetings with different teams to train them on JIRA and help them in migrating projects to the platform.

Accomplished projects using Agile methodology, participated in sprint planning, daily scrums, retrospectives, and code reviews.

Mojhi Technologies, Bangalore, India April 2017 - August 2018

Business Analyst

Analyzed different pay per click bidding strategies and was responsible for the transition from the maximum click’s strategy to a Targeted Cost per Action approach which enhanced sales figures by 35%.

Collaborated with stakeholders to create Power BI dashboards for reporting on KPIs such as customer acquisition costs, retention rates, conversion rates, and return on ads across marketing channels to drive customer engagement, retention, and loyalty.

Analyzed and mined user browsing datasets and conducted data-driven A/B tests to scale strategies across European and Asian markets.

Utilized optimization techniques like geo-targeting, dayparting, SEO analysis, and remarketing audiences to achieve ROI targets.

Analyzed the sales pipeline metrics and improved sales team response rate by 30% by driving the onboarding of a lead management software called Asana which could be used by teams to organize, track, and manage leads in the sales funnel.

Derived incremental impact of the Pay-per-click ads over organic Google Search results using Bayesian time series forecasting in R using European, Asian market traffic, and conversion data driving sales growth by 25%.

ACADEMIC PROJECTS

Medicare Providers Data Warehouse (Tools Used: SSIS, SQL, Power BI, SSAS, R, ER-Studio) January 2020 – May 2020

Profiled Medicare data using SSIS and created a snow-flake schema using ER-Studio to understand the required facts and dimension tables required for the warehouse and used Tableau to create interactive visualizations and to draw insights.

Developed a dynamic data warehouse using data flow tasks such as for-each loops, lookups, and SCDs in SSIS to compare the performance of a medical center for various conditions against the national average in terms of costs and quality of service.

Framework Course Sales Prediction Model (Tools Used: Python, Power BI, PostgreSQL) July 2019 – January 2020

Developed an exploratory predictive analytics model using pattern recognition techniques to identify trends in time-series data such as customer’s age, gender, and education level achieving an 85% AUC under random forests.

Extracted data using real-time SQL queries, transformed, cleaned, visualized, mined data of 2M customers using pandas, and visualized the predictions using Power BI while working with marketing to create marketing strategies based on the predictions made.

Social Media Database Management System ( Tools Used: Oracle SQL, Tableau, ER-Studio) January 2019 – March 2019

Developed SQL queries to identify customer purchasing patterns to reduce customer acquisition costs of companies by marketing products based on their social media history from a Database of more than 20 tables normalized to the third normal form.

Created a dynamic database by collecting raw data, creating ER diagrams, and obtain actionable insights by querying using Oracle.

Heart Disease Detection Model Using Unsupervised Learning( Tools Used: R, Power BI) September 2018 –December 2019

Developed a machine learning model in R which used K-means and hierarchical clustering to cluster patients according to heart disease symptoms to aid doctors in faster identification and diagnosis of heart disease.

Contact this candidate