Arpan Patel

Arpan

{

"name": "arpan",

"profession": "information technology",

"likes": ["startups", "saas"],

}

My Work

Automated Tableau Dashboards for Supply Chain Analytics

SQL-Based Data Consolidation and Automation

Portfolio

Project: Designed and deployed interactive Tableau dashboards for Premier Inc. to visualize supply chain KPIs, monitor cost-saving metrics, and track supplier performance.
Technical Details: Integrated data pipelines using SQL to query large datasets, cleaned and transformed data using Python (Pandas and NumPy), and built parameterized Tableau dashboards with advanced filters, calculated fields, and drill-down functionality for enhanced user experience.
Impact: Reduced manual reporting efforts by 30%, ensured real-time insights into inventory trends, and supported data-driven decision-making across multiple teams.

Project: Spearheaded data consolidation efforts at Amazon by automating extraction, transformation, and reporting processes for operational data across AWS teams.
Technical Details: Wrote optimized SQL queries to manage relational databases, implemented Python scripts with libraries like SQLAlchemy and Pyodbc for automated ETL processes, and established error-handling mechanisms to ensure data accuracy.
Impact: Increased data processing efficiency by 40%, provided dynamic SQL-driven reports, and enabled leadership to make strategic decisions based on real-time metrics.

Project: Developed Python-based solutions to streamline medical claims reporting workflows at Golden Care Transportation, focusing on revenue cycle management and compliance.
Technical Details: Created Python scripts to parse, clean, and analyze claims data using libraries such as Pandas and Matplotlib. Automated data aggregation processes and developed scripts for generating error-free summary reports.
Impact: Reduced claim denial rates by 15%, accelerated claims processing by 25%, and ensured compliance with state and federal regulatory standards through meticulous data validation.

Revenue Cycle Automation with Python

About Me

Hi there! I’m a data analytics enthusiast who thrives on uncovering stories hidden within data. With a knack for turning raw numbers into impactful insights, I specialize in using tools like SQL, Python, and Tableau to solve real-world problems and make data-driven decisions.

Portfolio

From designing automated dashboards that save hours of manual work to streamlining processes that drive measurable results, my work has spanned industries like healthcare, supply chain, and tech. Whether it’s optimizing supply chains at Premier Inc. or enhancing reporting systems at Amazon, I love tackling complex challenges with innovative solutions.

When I’m not knee-deep in data, you’ll find me exploring the latest tech trends, brainstorming creative projects, or tinkering with automation ideas. My ultimate goal? To make analytics not just functional but transformative—helping businesses thrive in a data-powered world.