Aishwarya Choudhary

Hayward, CA

addr9g@r.postjobfree.com C. 510-***-****

https://www.linkedin.com/in/aishwaryachoudhary/

SUMMARY

Data Analyst with 3+ years of experience interpreting and analyzing data in order to drive successful business solutions. Proficient knowledge in SQL, ML/AI algorithms and Data Visualization. Possess understanding of business operations & analytical tools for effective analysis of data and storytelling. SKILLS

Data Analytics Data Visualization Data Mining Python R SAS SQL Cognos Tableau Cognos BI SSIS SSRS Excel C++ HTML5 BASH Numpy Pandas Scikit Learn Supervised Learning Unsupervised Learning Machine Learning Data Warehousing SAP BO (WEBI) Regression Big Data Analytics Hadoop Hive Text Mining Classification Clustering Recommendation system Neural Networks NLP (Natural Language Processing) K-Means Decision Trees Multivariate Analysis Data Warehousing EDUCATION

M.S. Business Analytics (3.85 CGPA) California State University, East Bay Hayward, CA May 2020 B.S. Computer Science Clemson University Clemson, SC May 2014 DB Schenker, Haryana, India Jan 2017 – Jan 2019

SQL Developer

• Automated s 5-day Month end adhoc reporting process for MIS team utilizing SQL, SSIS and SSRS by publishing dynamic dashboards on Sharepoint with user level security, improving monthly KPI by 30% for 3 teams.

• Built and maintained dynamic Tableau dashboards for Senior VP and C-level Executives.

• Maintained the Enterprise data Warehouse by monthly backups and ensuring smooth data flow pipelines

• Gathered Customer requirements and delivered shipment insights through automated periodic report scheduling using SAP BP.

• Utilised Customer feedback functional data to perform Sentiment analysis and topic modelling categorizing top-performing product and clients that need attention.

• Performed deep dive analysis to understand trends, anomalies and insights that highlighted Customer Pain Points and helped drive operational improvement.

Silverxis, Irving, TX Oct 2015 - June 2016

Programmer Analyst

• Performed exploratory data analysis to identify processes that need improvement for a Healthcare client.

• Built regression model to improve resource allocation by 5% throughout the 13 health centre network.

• Collaborated on the development of insight driven tools and dashboards and provided ongoing support regarding functionality and data integrity.

• Built Scorecards and interactive Dashboards using Cognos and Tableau to optimize in and outpatient process.

• Assisted in report migration from Cognos 10.2 to Tableau. Sigmasoft, Dallas, TX Jul 2014–Jul 2015

Computer Systems Analyst

• Gathered Business Process Requirements from business users, for the reports to be developed and documented functional specifications for reporting requirements.

• Collaborated with multiple stakeholders to establish reporting metrics. PROFESSIONAL EXPERIENCE

• Created and published packages/multidimensional models using Framework Manager from multiple data sources.

• Created dynamic Dashboards, Burst reports, Crystal reports for Company decision making purpose giving insight into Key Performance Indicators (KPI).

BLACK FRIDAY: A Study of Sales through Customer Behavior

• Analyzed a Store's historical data of customer purchases to provide solutions/models in order to increase Sales on Black Friday.

• Built Linear Regression model predict the purchase amount of customer against various products based on past purchases in order to provide in store or online personalized promotional offers like coupons.

• Segmented customers into different Clusters to define marketing strategy based on their spending habits.

• Attempted to associate products from customer transactions to perform product recommendation, provide promotional offers and organize store layout using Apriori algorithm. Customer Review Analysis using NLP (Natural Language Processing)

• Performed Sentiment Analysis on review title and review text for Amazon Products.

• Identified the better metric between review title and text, review title being the better.

• Devised a new Topic Modeling Algorithm based on Most Frequent Adjectives and nouns succeeding them.

• New model had better results as compared to Topic Modelling using LDA. ACADEMIC EXPERIENCE

Contact this candidate