Data Analyst Engineering

Chaitali Sunil Sawant

adch7t@r.postjobfree.com +1-541-***-**** github.com/chaitalis12/ linkedin.com/in/chaitalisawant An aspiring data analyst with proficient knowledge in Probability, Statistics, Analytics, R and Python. Passionate about Analysis and Problem Solving of large data. Interested in Data Analyst, Business Analyst and Operational Analyst positions. Languages: R, Python, Java, C and SQL.

Tools: R-Studio, VS code, R studio, Anaconda, SAP, PeopleSoft, Finacle, Occam, HDM and Advanced Microsoft Excel. Visualization Tool: Tableau and Power BI.

Soft skills: Planning and Negotiation Expert, Intermediator, Forecasting Resources, Operations Management, Management of Information system, Team Building, Analytics, Agile, Linear Programming, Regression Analysis and Data warehousing. Certification: Six Sigma Black Belt, Data Science, Project Management. EDUCATION:

Master of Science in Engineering and Technology Management. Portland state University, Portland Oregon.

Post Graduate Diploma in Management in Operations, May 2015. IES Management College and Research Center, AICTE, Mumbai. Bachelor of Engineering Information Technology, July 2013. Yadavrao Tasgoankar College, Mumbai University, Mumbai. WORK EXPERIENCE:

BUSINESS ANALYST: TIAA GBS – MUMBAI, INDIA. Apr’ 17 – Nov’ 17

• Identify requirements of all departments to process requisition and dispatching purchase order in Peoplesoft.

• Automated vendor verification process on Peoplesoft which improved efficiency by 8%.

• Examining the unique needs of the new business location for process improvement, analyzing and visualizing in Tableau.

• Managing profit and loss by cash control, maintaining inventory and reviewing quarterly financial report. BUSINESS ANALYST: AXIS Bank – MUMBAI, INDIA. Apr’ 15 – May 16

• Forecasting quantities for all departments by analyzing existing data with MySQL and Tableau. Generating reports.

• Optimizing and improving existing data collection techniques to forecast data for HR department.

• Automated approval process by analyzing the existing infrastructure and implemented a new process in Finacle; which improved operation’s efficiency by 20%. Monitoring employee’s productivity and optimizing 15% operational expenditure. SUMMER INTERN (Material Management for retail business): Crompton Greaves-Mumbai, India. Apr’ 14 – May 14

• Segregation of stock of trade and retail business at appliances division improved inventory level for two businesses.

• Defining Re-order quantity and Re-order level of each SKUs based on past 3 months’ data extracted from SAP MM module.

• Preparing and updating MIS report in excel consisting of Re-order Level, Re-order Quantity and Daily stock

• Export SAP data and update the daily stock report and circulate the same across Pan India. ACADEMIC PROJECTS:

Hierarchical Decision Model using R. (github.com/chaitalis12/hdp-r)

• HDM is an Open-Source decision making tool where the decisions can be made based on parent-child relationship model. Proposed and implemented new features and solutions to improve application efficiency. (Tools: R and MongoDB).

• Developed new features such as single file access for ease of translation/localization and improving the tree design by avoiding the overlapping of nodes. Testing sensitivity analysis and enough decimal precision for normalized weights.

• Enhanced tool’s efficiency by 10% for data validation and interpretation. Silver Eagle - Assembly Line Analysis and Enhancement using R. (github.com/chaitalis12/Data-R/Silver_Eagle)

• Real time project for increasing production of TP 60 using R cloud, sensitivity analysis and linear programming.

• Recalculated man-hours and individual task-hours for all the station for reducing slack time and balancing the assembly line.

• Bottleneck at a station was resolved by linear programming and Shadow pricing in R, increased the production by 33.33%. Analyzing Data dependency of variables in Movie Dataset. (github.com/chaitalis12/Data-Mining/Data-Dependency-Analysis)

• Analyzing movie’s profit based on various independent variables like release day, studios, year, budget and genre in Occam.

• Extracted patterns and relationships between variables using Data mining techniques like clustering, modelling (dAIC, dBIC, Inf), binning into buckets, Data Cleaning and then visualizing it. Airbnb Data Mining Analysis using Algorithms. (https://github.com/chaitalis12/data-warehousing)

• Analyzing and predicting best algorithm for predicting prices, property types, room types, super host and seasons based on independent attributes like number of reviews, property descriptions using R.

• Data cleaning, correlation of attributes and implementing algorithms like Naïve Bayes, KNN, Random Forest and Neural Net for prediction.

Contact this candidate