Business Intelligence Developer

Ankita Srivastav

Dallas, TX 682-***-**** adcl8s@r.postjobfree.com www.linkedin.com/in/ankita-srivastav PROFESSIONAL SUMMARY

6+ years of experience as a data analyst and data engineer in telecom, banking and airlines domain EDUCATION

M.S. in Information Technology Management, University of Texas at Dallas, Richardson TX May 2018 B. Tech in Computer Science, Jodhpur Institute of Engineering and Technology, India May 2012 PROFESSIONAL EXPERIENCE

American Airlines – Business Intelligence Developer August 2018-Present

Strategic analysis & visualization using Teradata, Alteryx, Tableau and Power BI to resolve complex business needs, working directly with the Training Technical Operations Director

Implemented data science algorithms in the customer funds spoilage project to create an accurate prediction of spoiled revenue 12 months out. The error rate that was achieved was up to 3% which resulted in $700K in savings

Created predictive statistical data model to find the saturation point of required trained personnel for each qualification at each station based on various factors

Developed and customized complex Tableau reports providing critical CRM data insights, improved Email Campaign and Opportunity efficiency by 39%

Southwest Airlines – Data Analyst Intern January 2018-May 2018

Performed quantitative analysis and developed python application on unaccompanied minor data for deploying optimum escorts for accompanying them

Created a data model using raw data to provide insight into project portfolio performance and analytics allowing leaders to make data-driven resource and planning decisions ACL mobile – Data Analyst November 2014 – July 2016

Built and automate process for revenue and sales forecasting on daily basis and visualize using R and Power BI

Creation and execution of stored procedure in SQL for improved performance and reusability CresTech Software Systems – Data Engineer May 2012 – October 2014

Configured and generated SPSS reports on different parameters for data model confidence testing

Utilized R-Shiny, Tableau to create an interactive dashboard to examine the demographic breakdown of customers with different portfolio of products. Integrated data from databases into R for data analysis RELEVANT ACADEMIC PROJECTS

Airline Flight Delay Prediction (SAS Enterprise Miner) January 2017 - May 2017

Analyzed data by using methods like Regression, Decision trees and K-means Clustering to predict if a flight will be delayed in the future or not due to weather conditions Data Visualization January 2017 - May 2017

Did in-depth research on over a million data of natural disasters occurrences in past 50 years in the USA and created an interactive recommender system to help people choose an insurance based on their location using ggplot2, D3, Tableau and Power BI

Business Data Warehouse January 2017 - May 2017

Designed and developed entity-relationship data model for Airbnb using ERWIN, Universe using Universe Design Tool and relational database in MS SQL relevant to functional areas for Airbnb. Related reporting using Web Intelligence Rich client and Tableau

TECHNICAL SKILLS

Programming: Python, R, C++, NumPy, Panda,

Databases: Teradata, Oracle 11g, SQL Server, MySQL, MS Access Tools: SAS Enterprise Miner, Tableau, SAP Business Objects, STATA, QlikView, D3, ggplot2, Power BI, Google AdWords, Google Analytics, GIT, Power BI, Cognos

ORGANIZATIONS

Dean’s Excellence Scholarship Graduate Student August 2017-May 2018

Teaching Assistant(BA with R and SAS) Graduate Student August 2017-December 2018

Contact this candidate