Data Analyst
Current• Designed, developed, and optimized ETL pipelines using Azure Data Factory, SSIS, and Databricks, improving data processing efficiency by 30%, which resulted in savings of $100K annually by automating manual workflows and reducing operational costs.• Created 10+ dashboards in Tableau and Power BI with integrated DAX formulas and calculated fields, enhancing KPIs like occupancy rates, APDs, and track vs. actual revenue, thereby providing clear revenue insights for stakeholders.• Utilized Snowflake to store and manage relational and semi-structured data (e.g., JSON, Parquet), enhancing data accessibility and query performance by 25%, supporting cross-functional teams with faster insights and optimizing storage and query execution.• Developed interactive dashboards and reports in Looker, enabling data-driven decision-making by building custom visualizations and optimizing SQL queries, which improved report performance by 30% and enhanced user engagement across teams.• Performed exploratory data analysis (EDA) using Python libraries such as Pandas, NumPy, and Matplotlib, and developed machine learning models with Scikit-learn and TensorFlow. This process improved data understanding and predictive accuracy, leading to actionable insights and more informed business decisions.• Utilized advanced Excel functions, including Pivot Tables, VLOOKUP, and HLOOKUP, to streamline data analysis and reporting processes, enabling faster decision-making and reducing manual data manipulation by 40%• Implemented and optimized data pipelines using AWS services and Redshift, including ETL processes with AWS Glue and data warehousing in Redshift. This setup improved query performance by 35% and streamlined data integration, leading to more efficient and accurate analytics.