Ashna Patel

Data Analyst | Power BI & Excel Expert| SQL | R |

New York, New York, United States

About

Excited to be on the cutting edge of data analysis! With over 3 years of experience, I specialize in providing deep consumer insights and translating complex data into actionable business strategies across diverse industries. Proficient in Python, SQL, and Tableau, I enhance system operations metrics development, ensuring peak analytical capabilities and performance. Adept in crafting optimized SQL queries for efficient data processing in SQL Server 2008, my expertise extends to executing complex data migration, conversion, and integration processes for seamless data flow. I manage and manipulate data across various databases like MySQL, MS SQL Server, Oracle, and MongoDB, optimizing storage and accessibility. My Tableau proficiency spans Desktop, Reader, and Server, enhancing data presentation and decision-making through sophisticated analysis and dashboards. ☁️ Knowledgeable in cloud platforms like Snowflake, AWS, and Azure, I leverage their capabilities for scalable data storage and analysis. With a strong foundation in business and data analysis, I focus on data profiling, metadata management, and configuration management to support strategic initiatives. Passionate about tracking KPIs, budget analysis, and process automation, I drive efficiency and predictive analysis for informed decision-making. My solid grasp of statistical analysis and data mining techniques uncovers underlying patterns, informing data-driven forecasts.

Experience

  • Data Analyst at Con Edison
    Apr 2024 - Present · 2 yrs 3 mos

  • Data Analyst at Uber
    Jan 2023 - Feb 2024 · 1 yr 2 mos

    Actively involved in multiple projects employing both Agile and Waterfall methodologies. Conducted fortnightly sprint reviews and contributed to the planning phase, leading to a more efficient workflow and a 15% reduction in time to market for new features. Developed machine learning models to predict churn, leading to a 10% boost in customer retention. Implemented GIS and Excel for customer data analysis, created SQL queries and Python scripts for Data reconciliation. Utilized Python-based models to optimize 5 million+ routes, reducing trip duration by 20% and saving on fuel costs. Managed projects using Agile and Waterfall methodologies, reducing time to market by 15%. Highlighted communication, organization, analytic, and PC skills utilized in analyzing business requirements, resolving issues, and delivering impactful solutions. Designed stunning visualizations and interactive reports using Tableau Desktop and Tableau Server to provide insights to business users and Power BI dashboards using Power View, Power Query, Power Pivot, and Power Maps.

  • Data Analyst at KPMG India
    Jul 2019 - Aug 2021 · 2 yrs 2 mos

     Solved complex problems by optimizing multi-layered datasets and existing machine learning libraries, enhancing model efficiency by 30% and reducing computational costs by $50K annually.  Generated intricate MySQL scripts for data manipulation and validation, creating materialized views for remote instances, which improved data processing speed by 25%.  Prepared model data and built both Supervised and Unsupervised Learning Models using R and Python, boosting predictive accuracy by 20% and contributing to a $100K increase in project ROI.  Demonstrated deep understanding of database concepts like locking, transactions, and schema design, leading to a 10% improvement in database performance and reliability.  Conducted thorough data cleaning and exploration using Python and R, resulting in a 20% increase in data quality and a $30K reduction in data-related issues annually.  Elicited and maintained requirements throughout the software development life cycle, ensuring 95% adherence to initial project specifications.