Ishani Patel

About Ishani Patel

5+ years of IT Experience in data analyst and visualization with experienced in Tableau, mysql.• A motivated data analyst with vast experience interpreting and analyzing data in other to drive successful business solutions.• Driven by bottom line of any organization coupled with Core Technology skills to delivering exceptional services.• Seeking a position as a Data Analyst | Tableau Developer utilizing knowledge of relational database, MySQL and Business Intelligence models to improve on efficiency and effectiveness of organization\'s IT functions towards achieving an ultimate goal.

Experience

1. Data Analyst

   Publicis Groupe

   Jul 2023 — Present · NY, US

   Used Excel to format, filter, and clean up healthcare data sets by removing duplicate entries if there were any present.Worked daily with large amounts of Pharmaceutical data that Pfizer clients provided to us such as Meta, Google, Yahoo and Pinterest, including social media platforms and celebrity partnerships.Worked with GCP to ensure data is flowing and integrated the data into Tableau.Experience working with GCP with Tableau to analyze data in real time.Performed daily data validations and used excel functions to help analyze the data such functions as ( SUM, AVERAGE, VLOOKUP), along with using pivot tables.Created different chart types (Line, Bar, Pie) in Excel to help analyze the data for data analysis.Performed data quality assurance on all the incoming data on a daily basis, making sure all the data is accurate.Performed data transformations using Power Query Editor, created and worked with DAX formulas for data analysis.Ability to create different types of visualizations in Power BI desktop.Ability to perform advanced data transformations using SQL and Excel, including the creation of SQL queries that identify outliers and change in business metrics.Worked directly with Pfizer clients to present insights from dashboards using PowerPoint presentations weekly.Used Redshift and connected it to the Coginiti interface to create complex SQL queries, views, and data tables that would help build the dashboards.Went over all SQL queries thoroughly on a daily basis in order to help analyze the data.Used Looker to make data more visible for everyone.Used Alteryx tool to analyze large amounts of data and then created different types of visualizations based on Pfizer client requirements.Used Alteryx for data blending and creating data automation reports once visualizations are made.Used JIRA platform as work management tool to keep track of all the tickets that Pfizer clients assigned to our team.

Education

• Queens College

  Bachelor's degree, Computer Science

  2016 — 2019