We provide IT Staff Augmentation Services!

Data Analyst And Business Intelligence Intern Resume

2.00/5 (Submit Your Rating)

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 Analyst

Responsibilities:

  • 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

We'd love your feedback!