Parth Patel's Portfolio

Skills

Languages: Python, Java, R, VBA, SQL, MySQL, TSQL, HiveQL, NoSQL, PSQL, Shell Script, Perl
Data Analysis & Modeling: IBM SPSS Modeler, Power BI, Tableau, Oracle SQL Developer Data Modeler, Alteryx, SSIS, Apache Spark, Hive, Pig, Scala, Pandas, Numpy, Scikit-Learn, TensorFlow, Pytorch, Looker, Rapidminer, Adobe Analytics, MiniTab
Data Engineering & Big Data Technologies: Hadoop (MapReduce, Pig, Hive), Cloudera, Hortonworks, Zookeeper
Cloud Platforms: Amazon Web Services (AWS), Google Cloud, Azure Data Factory, Azure Databricks, Oracle APEX, Google Analytics
Machine Learning & AI: Natural Language Processing (NLP), TensorFlow, Pytorch, Scikit-Learn
Visualization Tools: Tableau, Power BI, Looker
Methodologies: Agile, Scrum
CRM & Marketing Technologies: HubSpot, Salesforce, Raiser’s Edge, SAP
Development & Collaboration Tools: Jira, Jupyter Notebook
Design & Multimedia: Photoshop, GIMP

Experience

Popway Software Pvt Ltd | Business/Data Analyst | APR 2021 - JUN 2022

Partnered with cross-functional teams (product, engineering, and marketing) to gather and refine project requirements, translating complex business needs into actionable insights to ensure seamless alignment across all stakeholders
Assisted the development teams by reviewing their test cases and clarifying the requirements to ensure complete coverage.
Responsible for creating and documenting Business Requirements, Functional and Non-Functional requirements, System Specifications, etc.
Designed data pipelines using AWS Data Pipeline and Azure Data Factory to automate data movement and transformation between various cloud and on-premises data sources.
Integrated Perl scripts with Shell commands to automate end-to-end ETL processes, from extraction to loading, ensuring smooth operations across various data sources.
Utilized NLP techniques (e.g., sentiment analysis, topic modeling) to derive insights from unstructured data sources, improving product understanding and customer behavior analysis.
Participated in continuous integration and continuous deployment (CI/CD) pipelines to streamline the development process.
Utilized relational and non-relational tools like SQL and NoSQL to construct data warehouse, data lake, and ETL systems.
Developed and optimized complex SQL queries to extract, manipulate, and analyze large datasets, improving data retrieval speeds and enabling more accurate reporting for business decision-making.
Utilized Python for data analysis and automation, building custom scripts to streamline data preprocessing and reporting tasks, reducing manual effort and increasing the accuracy of insights.
Created data visualizations in Tableau and Power BI, translating complex data into intuitive reports and dashboards, driving strategic decisions and improving stakeholder communication.

Mvation Worldwide Inc | Business/Data Analyst | JAN 2020 - FEB 2021

Developed and implemented an order tracking database using SQL and Python, reducing order processing and tracking time.
Conducted in-depth data mining and predictive modeling using Amazon Redshift and Python, identifying patterns and anomalies in customer behavior, contributing to a 10% increase in sales revenue and improved inventory management.
Implemented robust financial forecasting models, providing actionable insights that informed strategic planning and budgeting.
Led the development and implementation of a new payment system, improving order processing efficiency and customer experience by integrating real-time payment tracking and automation using SQL and Python.
Partnered with sales managers to evaluate revenue optimization opportunities and redesign processes using SQL and Salesforce, achieving a 20% increase in sales efficiency.
Tuned database queries using SQL and T-SQL to enhance query performance and data loading efficiency, improving overall database operation and reporting speed
Collaborated with Sales and lead teams to define and prioritize KPIs using Power BI and SQL, establishing automated reporting systems, enabling real-time monitoring of KPIs, and delivering actionable insights to support strategic sales initiatives.
Optimized existing BI solutions by fine-tuning SQL queries and data models, enhancing performance and scalability to support growing sales data volumes.

Droisys Inc | Business Analyst Intern | JUN 2019 - JAN 2020

Established Business Process flows and workflow diagrams to explain current state and determine future state of rewrite applications.
Developed comprehensive understanding of business processes, defining as-is/to-be business models for effective communication.
Conducted working sessions, interviewed Project Stakeholders to gather Business Requirements & Functional Requirements.
Followed Agile Methodology and participated in Sprint Planning, Daily Standup meetings, and Retrospective meetings.
Tracked/managed action items, issues, incidents, and risks using issue/bug tracking system and test management tools (JIRA).
Engaged in system testing during User Acceptance Testing to help ensure that all functional requirements were bug-free.

Parth Patel

About Me

2015 - 2019

2019

2020 - 2021

2021 - 2022

2022 - 2023

Skills

Experience

Popway Software Pvt Ltd | Business/Data Analyst | APR 2021 - JUN 2022

Mvation Worldwide Inc | Business/Data Analyst | JAN 2020 - FEB 2021

Droisys Inc | Business Analyst Intern | JUN 2019 - JAN 2020

Projects

Education

My Links

Contact Me