Shivi Bhatt
Business Intelligence Developer Intern · Autodesk Inc
Sunnyvale, CAWork Experience
Business Intelligence Developer Intern
Autodesk Inc2021 – 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. Ltd2017 – 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. Ltd2014 – 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 University2014
Bachelor of Technology in Computer Science
Master of Science in Information Systems
Northeastern University2021
Master of Science in Information Systems