OMKAR SAWANT

adnpsi@r.postjobfree.com +1-714-***-**** Fullerton, CA LinkedIn Portfolio

SUMMARY

A quick-learning, adaptable Data Analyst with 2+ years of experience in ETL, Data Visualization & Reporting, Data Wrangling, and creating optimized Data Models to produce vital insights that drive business solutions. Experience in implementing projects using the Agile methodology and translating business requirements into technical solutions. EDUCATION

Master of Science in Information System: California State University, Fullerton. (3.81/4) May ‘21 Coursework: Business Database Mgmt., Data Mining for Business Application, Business Data transformation, Principal of BI Bachelor of Engineering in Information Technology: University of Mumbai. (6.11/10) Jun ‘17 Coursework: Advanced DBMS, Big Data Analytics, Data Mining & BI, Software Project Management, Cloud Computing SKILLS

Languages: Python (Pandas, NumPy, Matplotlib, Scikit-Learn, Keras, TensorFlow), R, SQL Database and Analysis tools: Tableau, Talend, MySQL, MSSQL, SSIS, SSRS Advanced Excel, MS Access, AWS Redshift, SPSS, Google Analytics, Power BI, Alteryx, JIRA

Machine-Learning/Statistics: Multivariate/Logistic Regression, Clustering, NLP, ANN, Decision Tress, XG Boost, Random Forest, Ridge and Lasso Regression, Hypothesis Testing, A/B Testing, Chi-squared test PROFESSIONAL EXPERIENCE

Data Science Analyst: AB Bioproducts India LLP July ‘18 – June ‘19

• Performed web scraping and data preparation through ETL jobs on Talend for building regression models.

• Developed Market Mix model and Consumer Promotion model to establish the impact of promotion on sales and volume of sold goods and simulated recommendations to increase Marketing Budget Optimization by 30%.

• Built Market Response Model to analyzed ROI by the effectiveness of marketing activity using A/B testing and presented insights to stakeholders & build business strategies.

• Forecasted demand for procurements of raw materials quarterly using the Arima model, reducing freight cost by 60%.

• Built multiple interactive dashboards in Tableau and generated analytical reports for improving supply chain planning, resulting in a 17% increase in revenue and minimized shipping costs by 8%.

• Collaborated with cross-functional teams to implement and monitor Data warehouse using ETL and handled ad-hoc requests to create data reports using MySQL and Tableau.

Data Analyst: HUDL Aug ‘17 – May ‘18

• Optimized SSIS transformation scripts and re-engineered data flow, handling millions of sports team records resulting in increased data processing by 27%.

• Maintained MS SQL Server databases, tables, views with stored procedures, and joins to streamline clean data to feed Tableau.

• Analyzed current market trends using Tableau with senior management to streamline our customer acquisition strategies, increasing customer base by 20%.

• Developed dashboards to help management teams track KPIs in real time and understand team’s performance through charts and graphs, increasing productivity by 15%.

Business Intelligence Analyst Intern: Testtex India Laboratories Pvt. Ltd. June ‘16 – Aug ‘16

• Collaborated with stakeholders to understand key metrics, construct use cases, and create business requirement documents.

• Modeled Fact and dimensions for Sales dept. to aid in attribution and improve efficiency using dbt & Snowflake.

• Maintained integrity of SQL databases using scheduled procedure & delivered ad hoc reports using SQL to the manager. PROJECTS

Predict Customer Telecom Churn Data Mining (R, Excel)

• Performed data pre-processing on a 10-year telecom dataset, to visualize and perform Exploratory Data Analysis.

• Executed predicted algorithms like ANN, k-NN, Clustering, Random Forest, Logistic regression, CART, and XG-Boost.

• Built predictive models, and study parameters to help businesses identify future churning customers with 92.77% accuracy. Stock Market Portfolio Analysis Data Transformation & Analytics (R, PostgreSQL, Excel)

• Extracted SP500TR data from ‘finance.yahoo.com’ to build custom calendar to build DB, transformed and validate integrity on PostgreSQL, and made authenticated connection to R.

• Forecasted stock indices return for the next 3 months and compared its annualized return and volatility.

• Obtained optimal weights for stock indices which help investors predict and analyze cumulative return and to maximize ROI. Coffee Chain Analysis Data Analytics (Tableau, Python)

• Preprocessed data using python to remove anomalies and created multiple interactive dashboards to determine how factors like marketing, inventory management, seasonality, margin and COGS affected sales and profit of coffee chain in every state.

• Created a presentation to answer the hypothesis question in non-technical form for building a business strategy.