Intern
no image
Location: Dallas, TX, United States
School: the university of texas at dallas
Major: business analytics

Intern

EDUCATION
The University of Texas at Dallas, Richardson, TX May 2018
M.S., Business Analytics GPA 3.72
The University of Delhi, Delhi, India May 2015
Bachelors in Commerce (Hons) GPA 3.96
TECHNICAL SKILLS AND CERTIFICATIONS
Certifications : Managing Big Data with MySQL, Data Visualization and Communication with Tableau
Programming : SAS, HTML, STATA, R, SQL, Oracle PL/SQL, Python
Data Mining Tools : Advanced MS Excel, R, SAS Enterprise Miner
Reporting Tools : Tableau, MS Excel, CA Erwin, MS Visio, DB2, SAP Business Intelligence, Alteryx
Databases : MS Access, Teradata, SQL Server
Windows : Windows XP, Windows 10, Windows 7, Windows Server 2008/2013
Analytics Tools : Microsoft BI Suite (SSIS, SSAS, SSRS), Predictive analytics, Descriptive analytics
ACADEMIC PROJECTS
Predictive Marketing Analytics January 2017 – Present
• Exploring and analyzing data using segmentation and clustering to boost revenue of the company by ~ 17%
• Performing models like logistic regression and panel regression to create market basket analysis to navigate customer buying in a segment in SAS
Data Visualization Using Tableau January 2017 – Present
• Evaluated salary dataset of the US Department of Labor’s Office and drafted SPAP structure to create analysis plan for business analysis and for transformation of data
• Developed ad-hoc reports and dashboards using data blending and data manipulation to identify states with highest paying data-related jobs and the change in salaries based on visa status
• Elucidated solutions of business questions by delivering effective presentations using data stories and dashboards
Data Warehouse Design January 2017 – Present
• Responsible for logical, conceptual and physical design of a data warehouse and universe using Business Objects, Mined data using OLAP cubes, dimensional Modelling and mapped those to Web Intelligence for creating reports
• Created dimensional modelling, star schema/ snowflake schema, SSAS, SSPS and created OLAP cubes/ data marts
Business Intelligence Using SAS August 2016 – December 2016
• Interpreted Lending Club’s loan dataset and prepared models to predict status of loan with 85% accuracy
• Built Regression, Neural Network and Decision Tree and observed best model for prediction using misclassification rate method
• Identified neural network model as the best model for prediction with misclassification rate of 0.00
PROFESSIONAL EXPERIENCE
PANDLL INTERNATIONAL LTD., India January 2016 – June 2016
Business Intelligence Intern
• Created 1000+ spreadsheets in MS Excel and performed statistical algorithms and competitive analysis to identify the target market
• Responsible for validating quantitative and qualitative customer feedback data to ensure customer satisfaction and to make business recommendations and drive solutions
• Wrote and executed SQL queries and table aggregation statements that retrieved, sorted, combined, & manipulated records from multiple table to retrieve data from database
• Designed relational databases using entity relationship diagrams and relational schema in SQL
LEADERSHIP EXPERIENCE AND ORGANIZATION
Enactus, UT Dallas Chapter – Team Head August 2016 – Present
Intelligence Analytics Society, UT Dallas – Audit and SOC Officer August 2016 – Present
Voice of Intellectual Man, International Journal – Editor and Member May 2015 – August 2016

intuitive data junkie