Data Analyst - SQL, Python, Power BI, Azure Synapse

SAI LASYA YADALA

***********@*****.*** 954-***-**** Github Linkedin

Professional Summary Analytical and detail-oriented Data Analyst with 4+ years of experience in data analytics, engineering, and visualization within financial services, technology, and hospitality domains. Skilled in leveraging SQL, Python, Power BI, Tableau, and Azure Synapse Analytics to extract insights, optimize data pipelines, and drive strategic growth. Proven success in automating ETL workflows, building predictive models, and translating complex data into actionable business recommendations that enhance customer acquisition, engagement, and retention. Strong communicator with a solid foundation in data storytelling, cross-functional collaboration, and performance optimization aligned with business goals. Technical Skills

Data Analysis & Visualization: Advanced SQL (joins, window functions, CTE’s, performance tuning), Power BI, Tableau, Excel (VBA, Pivot, Power Query), Statistical Analysis, A/B Testing, Forecasting & Predictive Modelling, visio. Programming Skills: C, C++, OOPS, Python (NumPy, Pandas, Scikit-Learn, TensorFlow) R, Linux, MATLAB, Spark ETL & Data Engineering: Azure Data Factory, snowflake, Databricks, SSIs, Data Warehousing (star Schema, Dimensional Modelling), Git, API Integration. Data Pipeline Automation & Optimization (ETL/ELT, Batch), Data Quality & Governance. Cloud Platforms: Microsoft Azure, AWS, Google Cloud Platform. Certifications: Google Data Analytics, Microsoft Certified: Power BI Associate Data Analyst (PL-300). Professional Experience

Seminole Hard Rock Casino & Hotel, Florida, USA May 2024-Present Marketing Data Analyst

• Developed and maintained automated reporting solutions using SQL, Power BI, and Excel to monitor customer transactions.

• Led the creation of standardized reports, aligning with KPIs and performance benchmarks to provide insights to senior leadership in marketing, finance and Player Development teams.

• Utilized CRM for customer segmentation to guide strategic decisions on campaign targeting, A/B email testing, and timing, enhancing ROI across multiple marketing initiatives.

• Conducted detailed analysis of marketing performance and customer behaviors using Salesforce for web and direct marketing analytics, driving improvements in revenue growth and operational efficiency.

• Automated key ETL processes using Python, reducing data load time by 25% and improving overall reporting efficiency.

• Built time-series forecasting models using python to predict customer engagement and revenue trends improving campaign planning accuracy by 18%.

Proximate Technologies, Remote, USA February 2024-May 2024 Data Analytics Engineer

• Engineered data solutions by analyzing data interface requirements, creating data design, and mapping sheets, resulting in improved data accuracy and 40% faster data processing times.

• Orchestrated end-to-end ETL pipelines in Azure Data Factory, ingesting 1-2 GB daily, monthly, and quarterly files from diverse sources into Azure Data Lake Gen2, ensured seamless data consolidation.

• Transformed terabytes of data into data bricks by crafting complex SQL queries and python scripts according to business requirements, resulting in 79% efficiency.

• Created 3 dashboards using Power BI with KPI’s that show the trend of their sales and business insights based on regions.

• Designed and Optimized snowflake data warehouse schemas for improving query performance and scalability for analytics across multiple regions.

Federal Soft Systems Inc, Remote, USA September 2023-February 2024 Data Analyst

• Collected and transformed large datasets from Salesforce and relational databases to ensure data accuracy and integrity.

• Built optimized data models and interactive dashboards in Power BI to track KPIs and make data-driven decisions.

• Conducted trend analysis and forecasts that identified key sales drivers, contributing to a 15% increase in sales performance.

• Partnered with cross-functional teams to translate business requirements into actionable reports, improving operational efficiency and decision-making speed.

HCL Technologies Limited, Chennai, India. January 2020-December 2021 Software Engineer, Client – Cisco

• Automated python scripts using Python framework, reducing efforts of manually testing Cisco Network Device by 70%.

• Collaborated with cross-functional teams and built scalable data models to support network performance monitoring and reporting, improving the efficiency of incident resolution by 30%.

• Conducted root cause analysis for network issues, identifying and resolving critical bugs, improving system reliability.

• Designed and executed automated test scripts in Python and PyATS framework increasing test coverage and reducing defects.

• Performed testing on large-scale network device, ensuring accuracy, reliability and compliance with cisco’s quality standards. Education

Master’s in data science, University of Texas at Arlington Texas, USA Bachelors in Electronics and Communication Engineering, R.M.D. Engineering College Tamilnadu, India.

Contact this candidate