SUMMARY
Sunny Kiran Gangar
United States +1-469-***-**** *************@*****.*** LinkedIn
Highly skilled Data Analyst with 4+ years of proven experience in designing and optimizing data pipelines, developing advanced visualizations, and building predictive models to drive strategic business decisions. Expertise in leveraging tools such as SQL, Python, Tableau, Power BI, and Apache Airflow to deliver actionable insights and enhance operational efficiency. Adept at managing large-scale datasets (10M+ records), implementing machine learning models with high forecasting accuracy, and optimizing cloud infrastructures using AWS, Azure, and GCP. Strong background in statistical analysis, ETL development, and cross-functional collaboration, with a focus on aligning data initiatives with business goals to unlock revenue growth and cost savings. Passionate about transforming complex data into clear, impactful strategies that empower organizations to make informed decisions. SKILLS
• Programming & Query Languages: SQL, Python, R, MATLAB, SAS
• Data Visualization & BI Tools: Tableau, Power BI, Looker, Google Data Studio, Excel (Advanced)
• ETL & Data Processing Tools: Apache Airflow, dbt, Talend, Alteryx, Informatica
• Databases & Warehousing: PostgreSQL, MySQL, Snowflake, Amazon Redshift, Google BigQuery, MongoDB
• Statistical Analysis & Machine Learning: Scikit-learn, TensorFlow, Predictive Modeling, Time Series Forecasting
• Big Data Technologies: Apache Spark, Hadoop, PySpark
• Cloud & DevOps: AWS (S3, Lambda, RDS), Microsoft Azure, Google Cloud Platform, Docker, Kubernetes
• Security & Compliance: GDPR, HIPAA, Data Quality Management, Role-Based Access Control (RBAC)
• Project Management & Business Analysis: Agile, Scrum, Jira, Confluence, BPMN, UML EXPERIENCE
Phillips 66 Jan 2025 – Present
Data Analyst
• Engineered and optimized data pipelines using Apache Airflow and Talend, increasing data processing efficiency by 40% and reducing ETL runtimes from 12 hours to 7 hours across critical business functions.
• Designed and developed advanced dashboards using Tableau and Power BI for datasets exceeding 1 million records, boosting stakeholder engagement by 60% and influencing strategic initiatives.
• Applied Scikit-learn to build predictive models, improving sales forecasting accuracy by 30%, directly contributing to an estimated $2M in additional revenue opportunities.
• Collaborated with cross-functional teams to translate analytical findings into actionable business strategies, optimizing marketing and operational efforts.
AutoZone Jan 2021 – Jul 2022
Data Analyst
• Developed scalable data workflows leveraging dbt and Alteryx, reducing data transformation timelines by 40% for projects managing datasets of over 10 million records.
• Led the deployment of TensorFlow-based predictive analytics models with 95% forecasting accuracy, enhancing decision-making for a team of 15+ analysts.
• Optimized AWS cloud infrastructure, improving system uptime by 30% and achieving annual operational cost savings of $50K through efficient resource monitoring and allocation.
• Conducted advanced data mining and statistical analysis to uncover operational inefficiencies, supporting process improvement initiatives across business units.
General Motors Aug 2019 – Dec 2020
Data Analyst
• Automated ETL workflows across 10+ multi-source systems using SQL and Python, reducing report generation time by 40% and enhancing data quality by 25%.
• Developed interactive business intelligence dashboards using Looker and Google Data Studio, resulting in a 35% increase in stakeholder adoption and faster data-driven decision-making.
• Implemented machine learning models for demand forecasting, optimizing inventory management across multiple warehouses and delivering annual cost savings of $500K.
• Collaborated with cross-functional teams to define KPIs, build data models, and ensure data governance standards (GDPR, HIPAA compliance).
EDUCATION
University of Texas at Arlington USA
Masters of Science in Business Analytics 8/2022 to 12/2024 University of Mumbai India
Bachelor of Technology in Electronics and Telecommunication 9/2017 to 6/2020