SB

Shivi Bhatt

Business Intelligence Developer Intern · Autodesk Inc

Sunnyvale, CA

Work Experience

Business Intelligence Developer Intern

Autodesk Inc

2021 – 2021

• Automated Revenue Analysis ETL pipeline using Alteryx saving 80 hrs of manual effort per year • Analyzed education user data and created spreadsheet report to provide revenue analysis of the users who subscribed to commercial product from trial version, this report was presented to CEO • Created PowerBI decomposition dashboard to derive data insights of unverified education users based on dimensions

Data Analyst

Power School India Pvt. Ltd

2017 – 2019

Developed a classification model in python to forecast students at risk of dropping school, collated 3 machine learning models, with Random Forest Model generating best F1 score value 0.81 • Led a team of 5 engineers to design star schema based model satisfying KPI in order to facilitate decision making for student intervention programs • Constructed Talend ETL jobs which performed parallel bulk copy program (bcp) on transformed data to load data 10x times faster than conventional means, into target database using azure cloud blob storage • Performed diagnostic analysis using MSSQL & Power BI to identify students scoring less in state assessments, provided strategic recommendation to change student outcome, achieved 54-point increase in assessments • Enabled customers to get a comprehensive view of student performance by building Power BI dashboards and ad-hoc utilities to generate reports

Data Analyst

Capgemini India Pvt. Ltd

2014 – 2017

• Structured 20+ SQL scripts, interacted with clients to resolve financial app queries, succeeded 100% end user satisfaction • Delivered 12+ ETL jobs, with slow changing dimension (SCD) type 2 technique based on business rules • Modified SQL queries to optimize system using indexing techniques to make system 5x faster in production environment

Education

Bachelor of Technology in Computer Science

Jayoti Vidyapeeth Women's University

2014

Bachelor of Technology in Computer Science

Master of Science in Information Systems

Northeastern University

2021

Master of Science in Information Systems