Data Analyst

Pratik Utpat

Seattle, WA 813-***-**** adjrha@r.postjobfree.com LinkedIn Profile Portfolio Website

SUMMARY

• Analytics professional with 3 years of experience, including data analysis, business intelligence, data modeling, statistical modeling, visualization, programming, object-oriented design and coding skills, SQL development, reporting, implementation, support, and management of software life cycle.

• Good understanding of machine learning techniques, predictive analysis, statistical tests, and python libraries.

• Looking for challenging opportunities to provide data-driven optimized solutions to businesses. PROFESSIONAL WORK EXPERIENCE

Teaching Assistant, Uni. of South Florida (Data Mining and Database Management) February 2020 – May 2020

• Designed and developed the replica of IMDB (internet movie database) using python and SQL.

• Created Reports and Dashboards for student performance trends by using Tableau, Excel, and SQL. Data Science Intern, Yardi Systems May 2019 – August 2019

• Understanding business requirements, analyzing data workflow, performing data analysis, and visualization using Python, SQL, PowerBI, and DAX library on a large amount of data to provide actionable insights.

• Performed exploratory data analysis, machine learning techniques such as regression, classification for identifying patterns in data over time.

• Interacted with real-estate & healthcare clients to provide data-driven insights derived by building data models, performance trends, KPI metrics, interactive dashboards, and daily/weekly/monthly reports. Business Intelligence Engineer, Mythos Technology October 2017 – June 2018

• Identified key criteria in business problems to drive analytical strategies and present recommendations to shape effective metric development.

• Developed complex SQL queries for report generation and performed validation against the database.

• Collaborated with stakeholders and cross-functional teams to ensure an end-to-end operation success and optimize the BI process.

• Owned the design, development, maintenance, and improvement of new/ongoing reports, metrics, and dashboards. Data Analyst, Yardi systems January 2016 – August 2017

• Developed a robust ETL Tool by automating data transformation and improving the performance by over 80%, assuring consistent data flow.

• Designed & developed reports from large data sets to support financial, health, and operational data metrics using SSRS, SQL, excel & BI tools.

• Worked with a team of 10 to develop, maintain and upgrade real estate property management software, distributed & multi-tiered web-based server application using C# framework, MVC architecture, APIs, and SQL server in an agile environment.

• Adopted best practices such as data integrity, root cause analysis, troubleshooting, query and process optimization, identify-Test-resolve client reported program/database issues, ad hoc and A/B testing, data validation, and maintain logs and documentation. EDUCATION

MS - Business Analytics and Information System (Computer Systems Analysis), Uni. of South Florida GPA: 3.7/4 August 2018 - May 2020 MCA - Master’s in computer application (Computer Science), University of Pune, India GPA: 5.5/6 July 2013 – May 2016 B.Sc. - Bachelor of Science (Major - Mathematics), University of Pune, India July 2010 – May 2013 TECHNICAL/SOFT SKILLS

Languages: Python, SQL, C, C++, C#, R, HTML, CSS

Analytics: Pandas, NumPy, SciKit, Matplotlib, Tableau, PowerBI, Looker, Visio, R Studio, exploratory data analysis, data visualization, predictive modeling, classification, linear and logistic regression, decision tree, clustering, T-tests, Chi-squared, statistical tests, hypothesis testing, machine learning techniques, statistical modeling

Soft Skills: Strong Analytical and problem-solving skills, expertise working for multiple clients and projects, organized and detail-oriented, effective verbal and written communication, ability to convey technical terms, and key insights from complex analysis to non-technical person. Certification: AWS Certified Solution Architect – Associate PROJECTS

Analysis of Win Place Position of Player in PUBG Game

• Applied feature engineering concepts to get better and realistic outcomes by reducing the number of similar attributes such as distance traveled by a player in the game, killing methods, and map separation using R.

• Implemented linear regression, and decision trees algorithm to analyze and interpret accurate results using python. Loan Eligibility Prediction

• Performed descriptive and exploratory analysis using R and python.

• Implemented classification models to predict which variables influence the loan eligibility using SAS enterprise miner. Research Project - Effect of Online Advertising for A Cruise Company (Text Mining, Clustering, R, Python, PSM, SQL, Predictive Modeling, AWS)

• Understanding advertising effects on path-to-purchase, predicting conversion of customers based on browsing behavior.

• Improved attribution model by predicting which platform and variables impact the conversion. Analysis of Accidents in Us - Tableau Public Profile

• Click the link - Analysis, visualizations, and storytelling using dashboards

Contact this candidate