Data Analyst

ARCHANA JAJU

************@*****.*** +1-657-***-**** Fullerton, CA-92831 www.linkedin.com/in/archana-jaju-0706 PROFESSIONAL SUMMARY

Information Systems student with the experience of data visualization, manipulation, mining & analysis. Seeking to apply my technical skills & business knowledge to develop solutions to drive profitability and productivity. SKILLS

Technical: Data analysis, Data manipulation, Data mining, Data visualization, Forecasting, ARIMA modeling, Time series analysis, Linear programming, Machine Learning, ETL, NLP. Software: AWS, Python, MSSQL, R, PostgreSQL, Tableau, PowerBI, SPSS, MS Visio, MS Access, Excel, Google Analytics Certifications: Using Python for Research (Harvard), Data Analyst Nanodegree (Udacity- Pursuing) EDUCATION

Master of Science Information Systems May 2020

California State University of Fullerton, CA

Bachelor of Technology Textile Engineering July 2011 DKTE College, Shivaji University, Kolhapur, India

RELEVANT PROJECTS

NLP and Deep Neural Network on Yelp data for Starbucks and coffee industry

• Designed database to store yelp data in a structured format for various attributes such as customer details, reviews, business details, etc. collected from Kaggle- Yelp data challenge.

• Performed exploratory data analysis and data cleaning to understand business categories, review ratings, and distribution of businesses throughout the country etc.

• Performed text mining and sentiment analysis to understand various business aspects associated with positive or negative sentiment of reviews. Visualized word plots of the reviews to gain insights about customer feedback.

• Created model to predict star ratings based on review with 93% prediction accuracy. This model can be used as suggested rating feature for user reviews for Yelp and similar businesses Models: RNN, Deep neural network, Naïve Bayes, Keras, TensorFlow, scikit-learn,textblob, nltk, wordcloud, seaborn, pyodbc, pandas, numpy, gmplot, matplotlib, SQL joins, SQL subqueries Data mining to classify as an illegal drug user

• Analyzed data and performed data cleaning to remove overhyped observation using fictitious drug category results and defined outcome variable User-status based on the frequency of drug usage.

• Performed exploratory analysis and applied data mining techniques to understand the relation between variables and outcome.

• Recommended a model for classifying data in the future with 82% accuracy. Models: kNN, Classification Tree, Decision Tree, Logistic regression, Random Forest, Naïve Bayes, Principle component analysis, GGplot

Monoprice – Data Warehouse and BI system Proposal

• Analyzed business processes, user requirements to define project scope, requirement matrix and project deliverables.

• Proposed a DW system for Monoprice, an e-commerce company, to achieve inventory turnover ratio of 4.

• Suggested suitable ETL system and reporting tools to deal with data consolidation and generate data visualization reports to get insights into inventory and sales.

• Recommended a plan to implement Data warehouse & BI system within an estimated budget of $340000. Product mix forecasting using Tableau

• Analyzed external data for various products in the different geographical regions to identify new product mix options for the Bakery chain to resolve profitability issues.

• Used forecasting and trend line tools of Tableau to determine the best product mix to achieve predicted sales growth of 15% in the next quarter.

• Created dashboard to find out correlators, predictors for product lines, market and pricing strategies. EXPERIENCE

Shahi Exports Assistant Manager Merchandising April 2012 – Dec 2017

• Worked as a liaison between customers and the company for managing the complete product life cycle.

• Created and implemented production plans to achieve 92% on-time delivery.

• Collaborated with production, procurement & logistics teams to execute orders and drive operational efficiencies

• Monitored overall operations to proactively identify and resolve bottlenecks to avoid project delays.

• Led a team to work on product development initiatives in conjunction with the customer regarding manufacturing feasibility, costs, and lead time estimates and getting final approvals for the product.

• Created order closure reports and completed root cause analysis of the project scrap to understand potential reasons for rejections, leftover raw materials, delays, short shipments, etc.

• Drove cost negotiations and new vendor qualification initiatives for raw material suppliers.

• Increased sales by half-million units in two years by improving the performance and quality of products. INTERNSHIPS

Aditya Garments Pvt Ltd. Manufacturing Analyst

• Analyzed process flow & identified critical operations to avoid bottlenecks and improve productivity.

• Designed track and trace model to monitor the production status using Excel and achieved 8% higher production and 15% improvement in on-time delivery.

Arihant Corporation Manufacturing Intern

• Implemented lean manufacturing principles like 5S, Kaizen for process improvement, and increased operational efficiency by 3% using process optimization and asset augmentation.

Contact this candidate