Ananya Kapoor

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.

• 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.

• 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

• 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.

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

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

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

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