Summary
Overview
Work History
Education
Skills
Accomplishments
Certification
Work Availability
Quote
Projects
Additional Information
About Me
Facebook
Instagram
Timeline
ResearchAssistant
Ananya Kapoor

Ananya Kapoor

Data Analyst
Medford,MA

Summary

MS- Data Analyst graduate and MBA in IT Enabled Services with 5+ years total experience , 4 years in Energy, Banking and Retail -healthcare domain. Hands-on programmer for SQL, Python, R, Microsoft Power BI & Tableau.

Overview

5
5

Years of professional experience in Data Analytics

Work History

Analyst Consultant

Barclays Global Service Centre
10.2018 - 04.2019
  • Identified problems through root cause analysis resulting in customer service support system to reduce complaints by 10%.
  • Automate some ETLs (Extract, Transform, Load), run SQL Queries, designed visual dashboards,reporting customer banking behavior & communicate insights to stakeholders which led to product strategy and profitable growth by 12.6%.
  • Developed Predictive models for credit defaults resulting, in deepening customer acquisition, customer retention.
  • Set up different conda/pip environments, create and save code using GitHub to further develop our repositories.
  • Statistic analysis , logistic/linear regressions. Creation of reports of text: such as topic modelling and ngrams counts.
  • Skills worked on- CIS, Oracle mySQL, python, Tableau, Microsoft Excel, Agile ,Scrum work,PySpark, hive, NLP modeling .

Maintenance Data Analyst

Reliance Power -Thermal Energy Power Plant
08.2011 - 05.2015
  • Contributed in Data Science team developing Power Technology , Machine learning models & AI to improve operational efficiency.
  • Automatizing using sensor data, develop algorithms which led to improve productivity by 16 %
  • Implemented business intelligence solutions to increase operational efficiency /process and drive revenue growth by 73%
  • Developed computer simulation techniques used in electric distribution system analysis, including discrete and 8760-hours simulation. Worked on Jira project management tools.
  • Troubleshooting and debugging python codes.
  • Skills worked on- SAP, Powerpoint, Python, C++, SCADA, PLC, AWS, Power BI, R, MATLAB

Education

Master of Science - Data Analytics Engineering

Northeastern University
Boston, MA, USA
05.2023

MBA - IT Enabled Services

Indian Institute of Information Technology
Gwalior, India
05.2018

Bachelor of Science - Electrical, Electronics And Communications Engineering

S. G. S. I . T . S
Indore, India
05.2011

Skills

  • Python
  • R, SASS, BCP, GCP, Azure, SISS, ,Uipath, Alteryx
  • Oracle MySQL
  • NoSQL- Neo4j , MongoDB, Graph database
  • AWS, Snowflake, ETL tools
  • NLP- Data mining , Data Modeling
  • Latex, Microsoft Power BI , Tableau
  • Communication, Presentation, Agile ,Scrum, Machine Learning, AI

Accomplishments

  • Developed solutions to integrate Air Pre heater air electric distribution system to improve operational workflow efficiency by 48hrs.
  • Top 1 Database Management Project- Designed and Developed schema design for Luxury Rental Apartments - awarded for appreciation.
  • Top 1 Data Visualization Project - about Income status and Lifestyle choice impact on Health status in United States Project - award of appreciation
  • Top3 Image recognition Project about developing app for identifying Dog breed by an image - award of appreciation.

Certification

  • Marketing and Sales - IIT Delhi
  • Mutual Fund Agent - NISM-Series-V-A: Mutual Fund Distributors Certification
  • Financial analyst - Udemy
  • AWS - S3 - Certification (in-progress)
  • Apache Airflow
  • Snowflake
  • Microsoft Power BI Data Analyst Professional Certificate

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Quote

Every problem is a gift—without problems we would not grow.
Tony Robbins

Projects

  • Awarded Best Project in Data Visualization in Course - Comp. & visualization - identifying visual insights between unhealthy lifestyle choice & income status- impact on State healthcare policies- https://sites.google.com/view/status-nursinghomeresource/home?pli=1
  • Appreciation for Best Project work in Image & Pattern Recognition -developing app for identifying Dog breeds based on an Image - https://github.com/ananya-kapoor?tab=projects
  • Top 3 Best Database Management Project- Designed and Developed schema design for Luxury Rental Apartments.

Additional Information

Academic Excellence

Worked as a Teaching Assistant - Management Information Systems (MISM)- Data Wrangling for Business Intelligence Course Corporate course for PWC 's consultants & accounting employees

  • Worked in data wrangling and data cleaning& collection techniques for business needs on both structured and unstructured data using industry tools such as Oracle, SQL, statistical programming languages (R/ Python), and visualization tools (Tableau) to identify and solve real-world customer data challenges.
  • Contributed in exploration via APIs- REST Api by data profiling, data retrieval, data cleansing,and data integration.
  • Designed data pipelines to connect to customer database using Oracle SQL, Uipath, Alteryx and ran SQL queries to extract data to produced weekly reports, visualize data and business insights using Tableau & Power BI.
  • Skills worked on - LMS, MIS ,R, Oracle SQL, Uipath, Alteryx , Latex, MySql, XLS, Python,MySQL , Neo4j , MongoDB, Beautifulsoup.

Worked as a Teaching Assistant- Data mining & Data Modeling Machine Learning Course for Consecutive three semesters.

  • Designed and Deployed data models- predictive analytics models , KNN , Naive Bayes ,Logistics Regression, Neural Network to forecast future trends.
  • Debugging python code projects , implementation of data models and model evaluation methods used.
  • Reporting weekly insights on class performance, students improvements.
  • Created simpler & better analytics skills/tools material for future by publishing support material , articles, blogs on python tutorials which led to easy handling of students doubts and improved class performance by 74%.
  • Supported faculty in achieving high success rate by developing remote /hybrid learning & communications to 65+ students per day, grading assignments & exams. Held TA- hours, Data analytics hackathon and conducted online sessions on python , data mining and data preprocessing.
  • Skills worked on - Python, Tableau, R, Datamining , AWS, Snowflake , Microsoft Power BI

About Me

Apart from Being an successful engineer and Data geek, there is a pool of more professional experience and side hustle achievements I have achieved. Check them out at - https://sites.google.com/view/ananyakapoor

Facebook

Follow me on - https://www.facebook.com/ananya.kapoor.90?mibextid=LQQJ4d

Instagram

Whats life without social media - Instagram - https://instagram.com/thekapoor_ananya?igshid=ZWl6Z2NpMWt2MnNi&utm_source=qr

Timeline

Analyst Consultant

Barclays Global Service Centre
10.2018 - 04.2019

Maintenance Data Analyst

Reliance Power -Thermal Energy Power Plant
08.2011 - 05.2015

Master of Science - Data Analytics Engineering

Northeastern University

MBA - IT Enabled Services

Indian Institute of Information Technology

Bachelor of Science - Electrical, Electronics And Communications Engineering

S. G. S. I . T . S
Ananya KapoorData Analyst