Education

Master of Science, Business Analytics, Texas A&M University Commerce May 2018

Masters of Commerce, Management, University of Mumbai April 2016 Bachelors of Commerce, Accounting and Finance, University of Mumbai April 2012 Experience

Graduate Assistant Texas A&M University Commerce May 2017 to May 2018

• Gathered requirements from stakeholders to create static and dynamic dashboards related to student retention, application, admission and enrollment; and created statistical models to predict student enrollment based on business metrics using WebFocus

• Created and analyzing survey data for Institutional Research and assist with State, System and Federal reporting

• Managed and maintained contents on the departmental website using Cascade CMS

• Publication: Critical Factors Related to Retention Discovery through Non-Returning Student Survey Senior Analyst Axience Consulting Private Solutions December 2015 to July 2016

• Extracted real-time structured finance data from Bloomberg and conducted trigger analysis to forecast future receivables.

• Performed data analysis on commercial loans in MS Excel to oversee collateral performance

• Conducted risk analysis and created cash flow modelling for collateral loans Senior Business Associate CRISIL, An S&P Global Company June 2012 to October 2015

• Key member in database migration by tracking past and existing bugs and conducted User Acceptance Testing

• Created and executed SQL scripts to fetch historical and current data to find trends in financial data for ABS Asset Class

• Developed ETL solutions by gathering data from multiple sources to accelerate data integration and provide quick turnaround using Informatica Power Centre, which resulted in 50% reduction in process time.

• Conducted GAP analysis using MS Excel to streamline process workflows and create SOP’s to adhere to SEC audit requirements

• Team Lead Experience:

Initialized change request and statutory request as per the business rules to normalize process flow Managed 15-member team to meet project expectations on weekly and quarterly basis Academic Projects

• Python Project: Created graphical representation and regression analysis to determine the wage of a company’s CEO based on his education, experience and tenure using pandas, matplotlib and statsmodels

• R Projects:

Created statistical model to predict likelihood of payment for virtual goods by a mobile app user using rpart and rpart.plot Performed twitter analysis for Amazon’s top 200 tweets using twitteR, ROAuth and wordcloud

• SPSS: Performed descriptive analysis for movie theatre attendance data to analyse consumer preference

• Data Visualization: Performed exploratory data analysis for a global super store using Tableau

• Datawarehouse: Created dimension modelling and performed ETL using SSIS, SSRS, SSAS

• Capstone Project: Analyzed the impact of KPI's on cost of subscription in online streaming industry utilizing MS Project Skills and Expertise

Analytical skills: Logistic regression, linear regression, linear optimization, association rule mining, decision trees, ANOVA, k means clustering, hypothesis testing

Tools: Informatica PowerCentre, Bloomberg terminal, SPSS, MS Excel, MySQL Workbench, Qualtrics, QGIS, Tableau, SQL Server Programming Languages: R, Python, WebFocus, SQL

Organizational and Leadership Experience

Vice President for Business Analytics Student Club January 2017 to January 2018 Awards & Achievements

Recipient of ISACA scholarship at Texas A&M University Commerce December 2017 Awarded for Service Excellence Award - CRISIL, An S&P Global Company September 2014 Emeryville,

CA 94608 Vidhi Goti

817-***-****

ac5777@r.postjobfree.com

www.linkedin.com/in/vidhigoti

Contact this candidate