Data Analyst Intern Resume
Dallas, TX
TECHNICAL SKILLS:
Languages: R, SAS, Python, STATA, C, SQL, HTML
Analytics Tools: Rattle, SPSS, Alteryx, SAS EMiner, Tableau, Shiny, Qlikview, MS Excel, Adobe Analytics, CRM
Certification: Data science and machine learning with R, Google Analytics IQ, Confidential
Database: Teradata, Oracle, MySQL, SQL Server
BI & Analytics skills: Visualization, Statistical Analysis, Predictive Modeling
Data Mining: Customer Segmentation techniques, Time series analysis, Forecasting, Clustering
Machine Learning: Decision tree, Random forest, Bagging, Boosting, SVM, Neural networks, A/B testing, Churn Analysis
PROFESSIONAL EXPERIENCE:
Confidential, Dallas, TX
Data Analyst Intern
Responsibilities:
- Developed a statistical forecasting model for predicting customer and baggage demand using Alteryx and R, combining 5+ data sources for data extraction and creating visualization for operations performance metrics in Tableau
- Designed 20+ automated interactive dashboards to analyze baggage load and transit performance to help reduce analysis time by 70%
- Executed complex queries to perform data analysis using SQL Server and Teradata to build baggage handling system’s capacity and demand indicators
- Analyzed 10 years historical data to find trends and seasonality of workforce utilization and optimized gate operations performance metrics for all the airport using R to present findings to management executives
Confidential, Pleasanton, CA
IT Systems Intern
Responsibilities:
- Develop Reports and Dashboards using Google Analytics with end users to analyze usage patterns, effectiveness of website changes, and productiveness of news stories and articles.
- Apply Image & display analytics.
- Design pages using Kentico with additional tags and keywords to improve search and usability of intranet.
- Identify KPIs by gathering requirements and measuring their success to analyze Company’s intranet usage.
Confidential
Data AnalystResponsibilities:
- Develop NBD Regression predictive model in SAS and identify key variables to determine the consumer
- Predict purchase behavior of customers purchasing books from Confidential & Confidential .
- Ingest customer dataset to transform after performing data cleaning, integration, transformation and reduction in SAS.
Confidential
Data AnalystResponsibilities:
- Perform data analysis & manipulation to find trending investment locations, funding types, rising Confidential hubs and market categories for Confidential .
- Enhance visualizations and analyze integrated data with exploratory data visualization techniques using sorting, grouping, filtering, calculated measures like ratios, small and using ratios - mean-median-dot plots.
- Locate market clusters for Confidential by using functionality with R.
- Create data visualizations using Tableau to provide key insights.
Confidential
Data AnalystResponsibilities:
- Process more than a million scanner data points spread over 10 years for butter’s retail market of the Confidential
- Assess brand loyalty patterns and price elasticity metrics to find insights for top 3 brands of butter
- Recommend target marketing plan for 2nd best brand, based on competitor and customer profiling
Confidential
Data AnalystResponsibilities:
- Perform predictive analysis on 100,000 data points to identify customers that are most likely to churn
- Identify 10 most important factors (out of 173) influencing churn using principal component analysis
- Predict a logistic regression customer churn model (60% accuracy) and recommended solutions to churn
Confidential
Data AnalystResponsibilities:
- Manage a Confidential campaign to help improve traffic and increase customers for an online delivery company.
- Analyze website traffic and usage using Google Analytic. Track ROI for the online marketing campaign.
- Identify Advertising goals and KPIs to define a marketing strategy.
- Create ads matching with the website’s keywords for both display and search networks to increase conversion.
Confidential
Data AnalystResponsibilities:
- Propose enhancements to the existing Confidential Package using analytics in terms of setting permanent preferences for a profile and applying filters on recommendations, sharing content via social media.