Data Analyst Visualization

RIDHIMA MEHTA

Data Analyst

Chicago, IL Phone: +1-518-***-**** Email: ************@*****.*** LinkedIn Dedicated and results-driven Data Analyst with 4+ years of experience in analyzing complex data sets, generating actionable insights, and driving data-driven decision-making. Proficient in Python, R, SQL, and a wide range of data visualization tools. Strong expertise in data analysis, statistical and data modeling, data-driven decision-making, Data mining, Machine Learning with large data sets of Structured and Unstructured data, Data Acquisition, Data Validation, Predictive modeling, Data Visualization, and critical thinking.

Experience

Data Analyst Progressive Insurance, IL Feb 2023 – Present

Utilized Python and SQL to clean, analyze, and visualize large datasets, resulting in a 25% increase in data accuracy.

Employed predictive modeling to anticipate customer behavior and refine pricing strategies, resulting in a 15% boost in policy retention rates, bolstering profitability and fostering customer loyalty.

Developed interactive dashboards with Tableau, equipping stakeholders with immediate insights and promoting data-centric decision-making throughout the organization.

Oversaw data pipelines and seamlessly executed data cleansing, transformation, and integration tasks using AWS services like S3, EC2, and Redshift, guaranteeing precision and effectiveness in analytical workflows.

Specialized in Property & Casualty (P&C), Workers Compensation Professional Liability, Homeowners/Renters, Commercial Auto, and Personal Umbrella insurance solutions.

Proficient in utilizing SAS and SAP for data analysis, reporting, and statistical modeling to extract actionable insights and enhance decision-making processes.

Performing quantitative analysis in multi-asset investing to refine investment strategies and enhance decision-making processes.

Created and maintained advanced SQL queries and reports, enabling the organization to track KPIs and make data-driven decisions.

Captured requirements and wrote functional specifications to translate business needs into technical solutions effectively. Data Analyst IBM, India Jun 2018 – Jul 2021

Led a team of analysts to develop a predictive model using Python and Scikit-learn, resulting in a 20% reduction in customer churn.

Implemented large-scale data processing techniques using SSIS, Informatica, MicroStrategy, Snowflake, and Teradata to efficiently manage data extraction, transformation, and loading processes within data warehouses and data marts.

Harnessed MS Excel to dissect extensive datasets, construct intricate financial models, and craft interactive dashboards to enhance reporting and visualization capabilities, including SAP integration for financial data analysis.

Leveraged Azure cloud platforms including Azure Data Lake and Azure SQL Database for data processing, storage, and analysis.

Created and maintained OLAP cubes and data models to support multidimensional analysis and reporting requirements.

Leveraged expertise in data visualization tools including Tableau, Power BI, and QlikView to develop and maintain interactive dashboards and data visualizations, resulting in a 30% improvement in data accessibility and user engagement.

Collaborated with the marketing team to track and analyze website performance using Google Analytics, resulting in a 30% increase in online engagement.

Utilized SAP ERP to streamline data integration, enhancing reporting for informed decision-making.

Led the design and implementation of BI solutions, including data modeling, ETL processes, and dashboard development, resulting in a 20% increase in data-driven decision-making.

Skills

Methodology: SDLC, Agile, Waterfall

Language: Python, R, SQL

Business Intelligence Tools: Tableau, Power BI, Teradata, QlikView, Cognos, SSRS, SSIS, MicroStrategy, TM1, Informatica, Advanced Excel, Hyperion

Libraries: NumPy, Pandas, SciPy, Matplotlib, Seaborn, Scikit-learn, SAS Databases: SQL Server, MySQL, Oracle, MongoDB, MS Access Cloud Platforms: AWS: S3, EC2, Redshift, Azure: Azure Data Lake, Azure SQL Database, GCP IDE’s: Spyder, Jupyter Notebook, PyCharm, VS Code, Sublime Text Tracking / Other Tools: JIRA, Git, MS Office, OLAP, OLTP, Google Analytics, ETL, SSIS, SAS, SAP ERP, CRM, Snowflake Soft Skills: Data Integrity, Data Warehouse, Data Pipelines, Data Visualization, Data Cleaning, Data Wrangling, Critical Thinking, Oral and written communication skills, Presentation skills, Problem-Solving, Hypothesis Testing, A/B Testing

Operating Systems: Windows, Linux

Education

Master’s in Business Analytics University of Illinois Chicago, Chicago, IL BTECH (Electronics and Communication Engineering) The NorthCap University, Gurgaon, Haryana, India

Contact this candidate