Data Analyst Python

Manish Kumar New York • 607-***-**** • adesd8@r.postjobfree.com

linkedin.com/in/manish0893/ • github.com/mkumar7

QUALIFICATIONS PROFILE

Offer strong technical skills in data and business intelligence analysis with proven success in developing regression models, testing hypotheses and A/B test, and providing answers to complex questions. Adept at visualizing data and using storytelling techniques to convey valuable information to stakeholders and drive data-driven decision making. Coursework: Data Mining, Database Systems, Algorithms, Machine Learning, Design Patterns, Data Analytics Skills: Data Analysis, Statistical Analysis, Data Visualization and Warehousing, Ad-hoc Analysis, SDLC Data Analysis Tools: Jupyter Notebook, SSIS, SSMS, Google Analytics, ETL, Advanced Excel, RStudio, MATLAB Programming Languages: Python, SQL, NoSQL, Spark SQL, PLSQL, C, Java, R Visualization Tools: Tableau, Jupyter Notebook, Power BI, Advanced Excel, MATLAB Cloud and Databases: PostgreSQL, MySQL, SQL Server, Access, Teradata, Apache Cassandra, Redshift, S3, EMR, AWS. Other: Git, TensorFlow, NumPy, Pandas, SciPy, Matplotlib, Seaborn, Bokeh, Scikit-Learn, Linux Kernel EDUCATION

Master of Science in Computer Science – State University of New York, Binghamton, NY, 2019 Bachelor of Engineering in Electronics & Telecommunications – Savitribai Phule Pune University, Pune, India, 2015 Data Analyst Nanodegree Dashboards and Storytelling with Tableau Certification – Udacity, 2019 EXPERIENCE HIGHLIGHTS

Data Analyst – SystemoneX, MA 10/2019 to 06/2020

Analyze business requirements and provided end to end solution design for Data foundation builds including Data Marts, Data Warehouse. Wrote code as needed for development of reports, analytics and visualization using SQL. Key Accomplishments.

• Build an ETL pipeline that extract data from S3, Amazon Storage. From there, stage the data in Amazon Redshift

• Transform it into a set of fact and dimensional tables for the analytics team to continue finding insights in what songs their users are listening to. Transform, combine, summarize data, and create a clean database.

• Performed data analytics using Python, SQL, Excel, Tableau including extracting, analyzing, and processing data from multiple sources. Performed daily data queries and prepared reports on daily, weekly, monthly, and quarterly basis

• Facilitated data-driven decision making by building interactive Tableau reporting dashboards for team leader.

• Created monthly Excel reports using VLOOKUP, VBA, Macros, index, conditional list, Array function and Pivot tables.

• Completed in-depth analysis for business optimization projects boosting revenue by 18%. Research Assistant – State University of New York, Binghamton, NY, 8/2018 to 8/2019 Played a key role in planning and executing several complex research projects, including:

• Determined most profitable zip codes for short-term rentals for real estate agency by analyzing relationship of Airbnb and Zillow NY rental datasets with zip code, current price, rent to value, weekly price, and monthly price.

− Expertly utilized Python, Jupyter Notebook, SARIMAX model, univariate exploration, bivariate exploration, heat map, plot matrices, and feature engineering.

− Evaluated data quality, cleaned data, documented data wrangling, and forecast average property value for current month.

• Implemented Machine Learning algorithms (Decision Tree, Random Forests, Neural Network, Logistic Regression), used Python for development and debugging, and visualized performance of all deployed algorithms. Data Analyst – World Compliance Technologies, Pune, India, 8/2014 to 7/2017 Gained hands-on experience in data visualization, data wrangling & analysis, and A/B test analysis with this provider of Identity

& Security Management, Global Trade NET & Trade Compliance solutions. Executed exploratory and explanatory visualization storytelling via univariate, bivariate, and multivariate analysis, plot matrices, and feature engineering in Python. Applied APIs to scrape and access data; extracted, filtered, and integrated data from TSV, HTML, txt, and JSON files; and uncovered and categorized data quality issues using validity, accuracy, completeness, and consistency metrics. Reviewed quality and cleaned data using Python; documented wrangling in Jupyter Notebook. Key Accomplishments:

• Drove 25% cost savings by designing interactive Tableau dashboards and recommending cost-benefit analysis.

• Boosted customer retention rate 30% by analyzing customer behavior and billing data for new product and service.

• Enabled 1500+ advertisers achieve revenue growth by creating model to track customer interests using hypothesis testing, T-tests, A/B tests, multiple linear regression, and logistic regression.

• Conducted A/B tests and performed regression analysis to advise on decision to launch new webpage.

Contact this candidate