Monika Pawar Email:adg6l1@r.postjobfree.com

www.linkedin.com/in/monikapawar12/ Mobile: +1-623-***-**** Location: Pittsburgh, PA (Open to Relocate)

PROFILE SUMMARY

An aspiring data analyst, with more than 3 years of IT experience as Systems Engineer. Recognized for resolving problems, improving customer satisfaction, and process improvement.

Strong academic background in Data Analysis, excellent analytical and problem-solving skills, able to handle multiple projects while producing high quality work in a fast-paced, deadline-oriented environment.

In industrial analytics capstone course, contributed to research on Improving a client’s advertising service opportunities for a publishing company by using web analytics and machine learning models.

Excellent leadership quality with good presentation, training, mentoring skills.

EDUCATION

M.S., Analytics and Information Management

Duquesne University Pittsburgh, PA, USA

August 2020, GPA 3.87/4

B.Tech., Electronics and Communication Engineering

Rajiv Gandhi Proudyogiki Vishwavidyalaya, India

May 2012, GPA 3.6/4

SKILLS

TOP

Python, SQL, Power BI, Data modeling and data analysis, Machine Learning, Advanced Excel, MS Office

Python Libraries

Scikit-learn, Statsmodels, SciPy, NumPy, Pandas, Matplotlib, Seaborn, NLTK, TensorFlow

Machine Learning

Linear, Logistic, DT and RF, SVM, k-NN, K-mean and Hierarchical clustering, PCA and basic Neural Networks

Statistics

Descriptive Statistics, Hypothesis Testing & confidence interval, Correlation and Causation, Regression Models

Data Analysis

Data Wrangling, Web Scraping, Exploratory data analysis, Data Visualization, Predictive analysis, Web analytics on clickstream data, Social Network Analysis

Other

Agile, SDLC, Data Mining, Data Exploration, Data Transformation, Data Modeling, APIs (REST and GraphQL), CSV, JSON, XML, GIT, Knowledge of ETL

INDUSTRIAL PROJECT (Technology Publishing Co)

MAY 2020 – JULY2020

Data Mining and Analysis – SQL Python Machine Learning models Jupyter Notebook

Goal: Identify high buying power users for client to make advertising personalized.

Performed data sourcing and analysis on multiple data buckets to understand the data better using SQL, Python data analysis libraries and Power BI.

Explored and used statistical learning methods like OLS, Logit to determine user characteristics and view patterns.

Effectively used Clustering and Classification algorithms used to classify users with high buying power and to predict potential buyers.

Collaborated with TPC, Duquesne mentors and team to come up with a roadmap, mitigate any blockers and present the progress frequently.

Presented the recommendations identified to Technology publishing Company.

ACADEMIC PROJECTS

Covid-19. Research Dataset – Kaggle Python NLTK Machine Learning models Jupyter Notebooks

Implemented pipeline to clean the documents consisting metadata of 52,398 articles using text processing, used TF-IDF for vectorization of data.

Implemented PCA, K-means and Hierarchical clustering to predict different clusters of data and feed to the Latent Dirichlet Allocation algorithm to understand the topics covered in each cluster.

Mental Health in Tech Survey – Kaggle Data Modeling RDBMS SQL

Designed ER model, performed data normalization and created star-schema. Analyzed the data using SQL to extract the meaningful insights for raising awareness and improving conditions for those with mental health disorders in the IT workplace.

Hotel Clickstream Behavioral Analysis – Python NumPy Pandas Matplotlib Seaborn Jupyter Notebooks

Performed behavioral analysis on clickstream data of online hotel transactions, determined the right independent variables using existing domain knowledge, analytical reasoning supported with Pearson correlation, OLS, Logistic, Poisson and Negative Binomial regression analysis.

Presidential Candidate’s Support Analysis – Python Pandas NLTK TensorFlow Spyder

Collected data from Federal Election Commission website and blended with flat files to perform descriptive data analysis on 2020 Democratic Presidential Candidates & their contributors.

Implemented data munging using panda’s data frame, imputed ethnicity using last name (TensorFlow) and classified gender using first name (NLTK), to identify the contributor’s affiliation to the respective candidate. Visualized the insights by using matplotlib and seaborn.

Dashboards for Worldwide Importers – SQL Power BI Storytelling

Identified and prioritized KPIs significant for purchasing department of Worldwide Importer database, developed corresponding SQL queries. Presented significance of KPIs using interactive Power BI dashboards with focus on effective storytelling.

WORK EXPERIENCE

Systems Engineer, Tech Mahindra Pvt. Ltd., Hyderabad India (Full Time)

August 2013 – October2016

Extensively used SQL to verify data loading, hygiene and integrity.

Identified and Presented metrics and KPIs by creating reports using Microsoft Power BI to leadership during monthly review meetings.

Provided production and acceptance database support, software installation, administration and maintenance support for Microsoft internal applications, using SQL

Assisted senior DBA in maintenance of the backups, replications, production reporting servers and build non prod environment

Executed Test cases in UAT and PROD environment specified in change management and provided required signoffs

Created knowledge articles for repetitive issues, results in fast and timely response adhering to SLA's.

RECOGNITIONS (Tech Mahindra Pvt. Ltd.)

Bravo Award for Excellent support provided to the Onsite locations.

Awarded Pat on Back (POB) for best performance in project.

June 2016

March 2015

Contact this candidate