About Me

I’m a results-driven Data Analyst and Business Analyst with over 5 years of experience transforming complex datasets into actionable insights that drive strategic decisions. My expertise spans data management, BI, and predictive analytics across telecom, healthcare, and manufacturing industries.

I build automated data pipelines, interactive dashboards, and machine learning workflows that drive performance and efficiency. I’m passionate about translating data into decisions that create measurable business impact.

šŸ“„ View Resume
Sathish Profile

Experience

Projects

Data Warehouse Implementation & Analysis (GCP, DAGs, Cloud SQL, ETL)

Designed and implemented a robust data warehouse leveraging Google Cloud Platform. Using Google Cloud Composer, I architected three scalable environments and established a secure Virtual Private Cloud for Cloud SQL. Developed and orchestrated ETL pipelines using DAGs, ensuring smooth ingestion, transformation, and storage of large datasets. The project improved workflow efficiency, automated data processing, and provided secure, scalable analytics capabilities for cross-functional teams.

Financial Trends Dashboard in Food Sector (Snowflake, Power BI, ETL)

Developed an interactive financial analytics dashboard to monitor revenue trends, profit margins, and market performance in the food sector. Extracted large datasets from multiple sources using Snowflake and performed ETL processes for clean, consolidated reporting. Designed dynamic KPIs, time-series analyses, and visualizations in Power BI to identify growth opportunities and optimize strategic business decisions. This project resulted in a 20% improvement in strategic business insights for the client.

Sales and Revenue Analysis (Power BI, SQL, Data Visualization)

Built interactive Power BI dashboards to analyze regional sales performance and customer segmentation. Leveraged SQL for data extraction, cleaning, and transformation. Implemented KPIs, drill-down capabilities, and trend analyses to monitor revenue, profit margins, and sales efficiency. The solution helped business leaders quickly identify underperforming regions, optimize sales strategies, and make data-driven decisions, improving operational efficiency.

Customer Retention & Churn Analysis Platform (Python, SQL, Tableau, Azure)

Led the development of a predictive analytics platform to identify high-risk customers and reduce churn. Processed 5M+ customer records from CRM and transactional systems, applied exploratory data analysis, and built predictive models to assess churn probability. Developed automated ETL pipelines and Tableau dashboards to visualize customer segments and retention metrics. Collaborated with marketing and customer success teams to implement retention campaigns, achieving an 18% reduction in churn and saving ~$400K in recurring revenue.

Skills

Python
R Programming
SQL
Power BI
Tableau
Excel
AWS
Azure
PySpark
Databricks
Snowflake

Contact Me

šŸ“§ Satyanarayana.m9813@gmail.com
šŸ“ž +1 (630) 463-9897
šŸ’¼ LinkedIn Profile
šŸ™ GitHub Profile

Ā© 2025 Sathish Mekarthi | Built with šŸ’” & Data