Ankita Vats
Dallas,TX
Summary
Enthusiastic Bi engineer and dedicated employee with integrity, strong work ethic and great leadership skills. Over 8 years of experience building revenues, improving processes and driving business growth through periods of ranging market health.
Overview
11
11
years of professional experience
6
6
years of post-secondary education
Work History
Business Intelligence Engineer
Autodesk, Inc
11.2020 - Current
- Conducted complex analysis of 3M+ data sets to optimize strategies to drive revenue growth
- Created auto-refreshing dashboards using visual tools to analyze various sales patterns using DAX and Power Queries
- Planned and executed A/B tests on targeting parameters to identify winning variations and enhance overall strategy
- Generated automated reports using Python and Pyspark, reducing Full Time Employee’s efforts by over 50%
- Ingested, transformed, and modeled data from multiple sources into a centralized platform with Snowflake and Azure Data Factory
Business Analyst
Tango Analytics
06.2018 - 11.2020
- Ingested, transformed and modeled data from disparate sources to identify insights and patterns pertaining to missing data
- Created data pipeline to migrate data from multiple sources into Tango data warehouse
- Designed and developed dashboard using Tableau to analyze KPIs for rent roll validation, show the location, demographics and trade areas
- Performed statistical analysis to determine discrepancy between the Tango's rent roll and client data which increased the data accuracy up to 98%
- Communicated with, coached and coordinated with the Tango and client team to understand and develop business opportunities.
Student Worker - Data Analyst
The University Of Texas at Dallas
12.2016 - 05.2018
- Spearheaded and launched resource rotation process to align demand to supply in peak season
- Developed KPIs (Key Performance Indicators), scorecards and reports for student data which helped in speeding process by 5%
- Designed and developed dashboards using Tableau to track roadmaps, resources and timeline for senior management.
Senior Analyst
HCL
07.2013 - 12.2015
- Organized and facilitated Agile and scrum meeting including sprint planning, reports and stand-ups for a Fortune 500 client
- Performed ETL and Build Regression model to determine alerts-based data coming in from 1000 + applications
- Created Organization workflow using Pentaho and SQL script to automate ETL process.
Education
Master of Science - Management Information Systems
The University of Texas At Dallas
08.2016 - 05.2018
Bachelor of Science - Electronics and Communication
Uttar Pradesh Technical University
08.2009 - 05.2013
Skills
Microsoft Office SuiteProject ManagementAgileData MiningProject coordinationStatistical ModelingTableauPower BIExcelPythonR Programing
Looker
Snowflake
Azure Data Factory
Websites
Timeline
Business Intelligence Engineer
Autodesk, Inc
11.2020 - Current
Business Analyst
Tango Analytics
06.2018 - 11.2020
Student Worker - Data Analyst
The University Of Texas at Dallas
12.2016 - 05.2018
Master of Science - Management Information Systems
The University of Texas At Dallas
08.2016 - 05.2018
Senior Analyst
HCL
07.2013 - 12.2015
Bachelor of Science - Electronics and Communication
Uttar Pradesh Technical University
08.2009 - 05.2013