Smruti Shah's Photo

Hi, I'm Smruti Shah

I am a Data Analyst who loves working with data to find useful insights. I have experience in cleaning, analyzing, and visualizing data using tools like SQL, Python, Tableau, and Power BI. I also work with databases and create dashboards to help businesses make better decisions.

I enjoy solving problems and have worked on projects like web scraping Amazon products and designing dashboards to track IT performance. I focus on ensuring data quality and presenting clear insights that others can easily understand.

I believe in working hard, paying attention to details, and always learning new things. Let’s connect and talk about how I can help with your next project!

Skills & Expertise

Data Analysis & ETL

Skilled in ETL processes, API integrations, and data visualization.

ETL Data Cleaning API Visualization

Programming Languages

Proficient in multiple languages for data and web development.

Python SQL JavaScript HTML & CSS

Data Visualization

Experienced in creating insights using advanced tools.

Power BI Tableau Excel

Database Management

Expert in relational and dimensional modeling.

MySQL MongoDB

Automation

Automating workflows for reporting and efficiency.

Workflow Design Reporting

Financial Analysis

Forecasting and providing actionable business insights.

Metrics Analysis Revenue Forecasting

Security & Troubleshooting

Ensuring secure and efficient dashboard operations.

Data Access Groups Dashboard Management

Tools & Technologies

Proficient in modern tools for development and collaboration.

Git Linux Microsoft Office

Projects

...
Amazon Sales Analysis Using ETL, OLAP, and ODI

  • Designed and implemented an ETL pipeline to extract, transform, and load Amazon sales data into a data warehouse.
  • Created a multidimensional OLAP cube using Oracle Analytics Workspace Manager to analyze sales trends, vendor performance, and regional insights.
  • Automated ETL workflows using Oracle Data Integrator (ODI), improving data processing efficiency and reducing errors.
  • Developed and optimized data models, including star schemas and entity-relationship diagrams, for seamless data organization and analysis.
  • Enabled efficient querying and reporting to support data-driven business decisions.

View Project
...
ABC Company IT Dashboard Analysis

  • Designed and maintained a Power BI dashboard to track IT metrics using a star schema for efficient analysis.
  • Developed interactive visuals for IT operations, cybersecurity, and cloud performance, providing insights into key trends.
  • Analyzed operational trends, such as high MTTR and weekend downtime, offering actionable recommendations for improvement.
  • Automated report generation, reducing manual workload and improving efficiency in IT performance tracking.

View Project
...
ETL Pipeline Development

  • Created an ETL (Extract, Transform, Load) process to move data from the Wide World Importers operational database to a data warehouse.
  • Extracted data from tables like Customers, Products, Orders, and more using SQL scripts.
  • Transformed the data by cleaning, normalizing, and preparing it for analytics and reporting.
  • Loaded the transformed data into a structured data warehouse with dimension tables (e.g., Customers, Products) and fact tables (e.g., Orders, Sales).
  • Validated the ETL process with SQL scripts to ensure data accuracy and consistency.
  • Designed an ETL process flow diagram to explain the data movement and transformations.

View Project
...
AI-Powered Business Directory with Web Scraping

  • Implemented a Python-based solution using BeautifulSoup to extract, clean, and store business details such as website name, category, description, and location.
  • Developed a Flask-based REST API to manage business data efficiently, enabling users to search businesses by location, category, or website URL.
  • Integrated OpenAI API to provide AI-driven business recommendations, analyzing user preferences and suggesting relevant businesses.
  • Designed a frontend tool using HTML, CSS, and JavaScript for real-time business search, filtering, and visualization.
  • Utilized MongoDB to store structured business data, ensuring fast retrieval and scalability.
  • Cleaned and structured extracted data using Pandas, handling missing values and ensuring data consistency.
  • Built a scalable, real-world application that combines web scraping, AI-driven insights, and API-based data retrieval.

View Project
...
Airbnb Tableau Dashboard

  • Implemented a Python-based solution using BeautifulSoup to extract, clean, and analyze e-commerce product data.
  • Created a frontend tool using HTML, CSS, and JavaScript for real-time data exploration and visualization.
  • Cleaned and structured extracted data with Pandas, handling missing values and ensuring data consistency.

View Project