Rohan Patel

Data Analyst

NY adyh2k@r.postjobfree.com 513-***-**** Linkedin GitHub

SUMMARY

● Around 3 years of experience in Data Analyst, Design, Modeling, Development, Implementation, and Testing of Data Warehouse applications.

● Knowledge of the Software Development Life Cycle (SDLC), Agile, and Waterfall Methodologies.

● Good experience in developing Web Services with Python and R Programming languages.

● Proficiency in working with various Python IDE like PyCharm and Visual Studio Code.

● Well-Versed in using various packages in R and Python-like NumPy, Pandas, Matplotlib, SciPy, and ggplot2.

● Proficient in designing visualizations using Tableau and Power BI software and Storyline on web and desktop platforms, publishing and presenting dashboards.

● Good knowledge of writing queries and subqueries to retrieve the data using SQL from various servers including MySQL, and SQL Server.

● Working knowledge of MS Access Databases, MS Excel, MS Word, and MS PowerPoint.

● Understanding of Data cleaning, Data Wrangling, Statistical Data Analysis, Exploratory Data Analysis, Data Wrangling, and Predictive Modeling using R, Python, and Data visualization.

SKILLS

Methodologies: Agile, Waterfall, SDLC

ML Algorithm: Regression Models, Decision Tree, Random Forests, Sentiment Analysis, Naïve Bayes Classifier, SVM Language: Python, R, SQL

Visualization Tools: Tableau, Power BI, MS Excel

Packages: NumPy, Pandas, Matplotlib, SciPy, ggplot2 Cloud Technologies: AWS

Database: MS SQL Server, My SQL

IDEs: Visual Studio Code, PyCharm

Other Tools: Data Cleaning, Data Wrangling, Critical Thinking, Problem-Solving, Communication Skills, Presentation Skills, Git, Machine Learning, Statical Modelling

Operating System: Windows, Linux

EXPERIENCE

Principal Financial, NY March 2023 - Current DATA ANALYST

● Developing Python Scripts to assist in testing trading functionality.

● Working with various Python IDE like PyCharm and Visual Studio Code.

● Creating various capacity planning reports using Python packages such as NumPy, Pandas, Matplotlib, and SciPy.

● Preparing dashboards, reports, graphs, and presentations using Tableau.

● Conduct data profiling and validation using SQL queries and data analysis techniques, identifying and resolving anomalies and inconsistencies with a 95% accuracy rate.

● Develop and implement ETL pipelines using Alteryx, Pyspark, SQL, and other data analyst skills, resulting in a 20% improvement in data processing efficiency.

● Creating mockups of Dashboards and individual data visualizations in MS Excel.

● Collaborated with the data engineering team to optimize Alteryx workflows, achieving a 20% increase in workflow performance.

● Performing data analysis and maintenance on information stored in MySQL database.

● Leverage PySpark to enhance ETL processes for large-scale data processing, leading to a 25% improvement in data handling efficiency.

● Conducting Data analysis including acquisition, cleansing, transformation, modeling, visualization, documentation, and presentation of results.

Fusion Software Technologies, India Jan 2019 - June 2021 DATA ANALYST

● Worked with Waterfall methodology at the beginning of the project.

● Transformed and merged data as per the requirement for ease of analysis in Excel by using Power Query in Power BI.

● Used Several Python libraries like NumPy, Pandas, Matplotlib, SciPy, and ggplot2.

● Analyzed customer behavior and identified churn indicators using statistical techniques, resulting in a 15% increase in churn prediction accuracy.

● Involved in requirements gathering and source data analysis and identified business rules for data migration and for developing the data warehouse.

● Designed and developed interactive Tableau dashboards to visualize key metrics and trends, providing actionable insights to stakeholders.

● Performed data collection, data cleaning, data wrangling, data analysis, and building machine learning models on the data sets in both R and Python.

● Conducted thorough data validation and quality checks to ensure the accuracy and reliability of data displayed in Tableau dashboards.

● Created visually appealing and informative visualizations that resulted in a 25% increase in user engagement and data comprehension.

● Created functions, triggers, views, and stored procedures using MySQL.

● Worked autonomously, exhibiting excellent communication skills, and demonstrating problem-solving abilities. EDUCATION

Master of Computer Science New York University, NY Bachelor in Computer Science SRM Institute of Science & Technology, Chennai, India

Contact this candidate