Data Analyst And Business Intelligence Intern Resume
Morristown New, JerseY
SUMMARY:
Awarded Merit - based Diversity Scholarship for exemplary academic and extra-curricular performance Peer note-taker for a visually impaired student
SKILLS:
Programming languages: SQL, R, Python (Numpy, Matplotlib, Pandas, Sckit learn)
Data Analysis & Visualization: Power BI, Tableau, R, Gephi, Qlik, D3 Library, Machine Learning, Statistical Analysis, D3
Applications: Hadoop, Apache spark, AdWords, MS Project, MS Office, Microsoft SQL Server, Salesforce, Visio, Access, ggmap in R, Advanced Excel with Pivot Tables
WORK EXPERIENCE:
Data Analyst and Business Intelligence intern
Confidential, Morristown, New Jersey
Responsibilities:
- Improved operational efficiency of waste management plants by analyzing data, building dashboards on Power B.I. and presenting actionable insights to help stakeholders take data-driven decisions
- Performed prescriptive analytics to identify KPIs of waste management plants by writing Python scripts and implemented association rules machine learning algorithm to provide strategic direction and improved the plant’s capability
- Collaborated with the team and stakeholders by holding daily SCRUM meetings, weekly meetings for status update and built automated notification system to reduce carbon emission and ensured federal compliance
Analyst & Customer Relationship Manager
Confidential
Responsibilities:
- Assisted and collaborated on data visualization using R and Salesforce to perform digital transformation for an international client to improve market segmentation and online customer engagement
- Programed, trained and tested different classification models (neural networks, Bayesian classifier, support vector machine, decision tree) in R language, to get the most accurate algorithm, predict customer pain point, and decreased customer support response time by 21%
Relational Database developer and Analyst
Confidential
Responsibilities:
- Designed coded, tested and supported database solutions for Confidential in Microsoft SQL server, setup the technological backbone and built a working product from scratch
- Wrote python scripts for the extraction and analysis 19,100 Indian zipcodes to determine the best shipping companies based on geography using extensive data science techniques
- Designed and built a database management system for public bus transportation system by creating entity relationship diagram, normalizing the database to 3rd normal form and satisfied business rules
- Wrote complex SQL queries using joins, grouping aggregation, nested subqueries to extract relevant data on Microsoft SQL server, answer business questions and improved customer retention by 24%
- Designed user-interface along with backend database to improve data extraction, transformation and loading
Confidential
Database developer and AnalystResponsibilities:
- Built a “bag of words” model to analyze restaurant reviews and determined factors that drive customers to give negative feedback and helped restaurants in identifying areas of improvement
- Extracted relevant data using SQL on nation-wide zipcodes and wrote python scripts for the extraction and analysis of open data available on Indian shipping industry
- Built robust machine learning customer churn models to compare the behavior of customers who churn and customers who don’t churn, predict the customers who will churn in future based on their behavior to improve customer attrition
- Deployed KNN algorithm and built a model to classify user response thereby significantly improved and optimized a social media marketing campaign