Data Analyst

KIRAN VENKATESH

DATA ANALYST

Location: IL • Phone: +1-872-***-**** • Email: **********@*****.***

SUMMARY

● Accomplished as a Data Analyst with over 5 years of experience in analyzing, transforming, and visualizing large-scale datasets to drive strategic business decisions across cloud and on-premise environments.

● Skilled in developing ETL workflows, data models, and dashboards using SQL, Python, and Tableau, delivering actionable insights that improve operational efficiency, customer engagement, and revenue forecasting.

● Hands-on experience working with cloud platforms such as AWS (Redshift, Glue, Lambda, Athena), GCP (BigQuery, Dataflow), and Azure (Synapse, Data Factory) to build scalable reporting and analytics solutions.

● Proficient in data cleaning, statistical analysis, and predictive modeling using pandas, NumPy, scikit-learn, and PyTorch, enhancing data-driven decision-making across cross-functional teams.

● Adept at implementing data governance, improving data accuracy and compliance by designing consistent data definitions, quality frameworks, and lineage documentation.

● Familiar with CI/CD practices and workflow automation using Airflow, Jenkins, and Docker, enabling efficient data preparation and timely delivery of business reports. PROFESSIONAL EXPERIENCE

Saayam For All IL, USA

Data Analyst Feb 2025 – Current

● Architected and implemented foundational AWS S3 infrastructure for storing fraud and help request data, designing scalable data models and planning downstream analytical workflows in Python, improving data retrieval time by 30% and supporting data-driven decision-making.

● Implemented fraud detection logic within AWS Glue transformations and Pyspark, segregating fraud and non-fraud records into separate S3 buckets, which improved fraud detection analysis efficiency by 25%.

● Integrated Snowflake using Snowpipe and SnowSQL to automate batch ingestion of transformed data from S3 into the data warehouse, reducing manual loading efforts by 90% and accelerating report generation by 20%.

● Collected, validated, and enriched nonprofit organizational data from trusted third-party sources like Charity Navigator using SQL and Python to support educational initiatives and quality improvement reporting, improving data accuracy by 15%.

● Collaborated with stakeholders to define and iterate on KPIs, focusing on fraud detection effectiveness, user response times, and educational content delivery impact, improving fraud detection accuracy by 25% and aligning reporting objectives with organizational goals.

Illinois Institute of Technology IL, USA

Graduate Teaching Assistant Aug 2024 – Dec 2024

● Mentored 40+ students in Cloud Data Engineering concepts, focusing on ETL development, cloud data warehousing, and big data technologies (Hadoop, Hive, Spark, Kafka, Snowflake).

● Designed and integrated Python-based data engineering projects, fostering collaborative problem-solving to enhance engagement for 25+ graduate students, resulting in 15% higher course satisfaction scores.

● Facilitated hands-on workshops on SQL, Hadoop, and Spark, leveraging clear communication to improve technical proficiency with students successfully completing real-world data pipeline assignments.

● Explained cloud platform architectures (AWS) through adaptable teaching methods, resulting in 15% higher course satisfaction scores.

● Designed dataset generation scripts using Python and SQL, cutting manual preparation time by 50% and enabling students to focus on advanced data transformation techniques. Treevah IL, USA

Data Analyst Intern Jun 2024 – Aug 2024

● Crafted Power BI dashboards using test user data, incorporating 5+ KPIs (file access frequency, storage efficiency) to monitor file management trends and system performance, enhancing data visualization clarity for 200+ active users.

● Formulated R language to perform statistical analysis on file usage patterns, creating visualizations with ggplot2 to identify bottlenecks in file navigation, optimizing workflows across 10 key processes.

● Collaborated with cross-functional teams via Git to analyze system performance metrics, streamlining Agile workflows for 5 sprints and shortening deployment cycles by 2 days. DXC Technology India

Data Analyst Jun 2020 – Nov 2022

● Developed dynamic Power BI dashboards to visualize KPIs, automate reporting processes, and enable stakeholders to track real-time metrics across finance and operations.

● Extracted and analyzed large datasets using SQL from AWS Redshift and PostgreSQL, delivering actionable insights on customer behavior, operational efficiency, and product usage trends.

● Conducted data cleaning, transformation, and validation using Python (pandas, NumPy) and AWS Glue, ensuring accuracy and reliability of data used for reporting and analysis.

● Utilized Microsoft Excel (pivot tables, VLOOKUP, Power Query, and advanced formulas) for ad hoc data modeling, variance analysis, and performance reporting, improving business decision-making.

● Applied statistical techniques such as regression analysis, A/B testing, and hypothesis testing using Python to evaluate product changes and business initiatives.

● Participated in Agile sprints, working closely with cross-functional teams in Scrum-based environments to align analytics delivery with business objectives and project timelines.

● Automated recurring data processes using Python scripts and Excel Macros, reducing manual reporting time by 20+ hours per month and increasing overall team efficiency.

● Supported data governance by creating and maintaining data dictionaries, transformation logic documentation, and lineage diagrams, ensuring data transparency and consistency.

● Collaborated across the SDLC for BI solutions, contributing to requirement gathering, user acceptance testing (UAT), production support, and documentation for analytics deliverables, ensuring timely delivery and high-quality insights for stakeholders.

Airbnb India

Data Analyst Aug 2019 – May 2020

● Maintained data integrity and optimized data processing across AWS S3 repositories using PySpark, reducing data discrepancies by 20% and ensuring compliance with regulatory standards.

● Implemented data mining and fraud detection models using PySpark, processing 10K+ transactions to uncover fraud patterns, improving fraud detection efficiency by 15%.

● Created interactive dashboards in Tableau to visualize occupancy, cancellation trends, and customer satisfaction, reducing report turnaround time by 35%, supporting data-driven decisions for marketing campaigns.

● Spearheaded data engineers to design and automate ETL pipelines using Apache Airflow, AWS Glue and SQL, ensuring high-quality data extraction, transformation, and loading (ETL), and ensuring high-quality data reporting.

● Supervised guest behavior datasets using AWS Redshift and SQL, identifying trends in booking patterns and revenue across 10+ markets, enabling data-driven decision-making and insights generation for marketing and product teams. TECHNICAL SKILLS

Programming Languages: Python, Scala, SQL, R, Shell Scripting Database Management: MySQL, PostgreSQL, SQL Server, Cassandra, Azure SQL DB Big Data Technologies: Hadoop, Apache Airflow, Apache Spark, Hive, AWS Glue, Kafka, HDFS, PySpark Data Warehousing: Snowflake, Amazon Redshift, Data Warehousing, Data Governance, Data Mining, Data Modelling ETL Tools: Alteryx, Databricks, Azure Data Factory, Informatica, Talend Machine Learning: Supervised/Unsupervised Learning, Neural Networks, Deep Learning, Fraud Detection CI/CD & DevOps: Docker, Terraform, Jenkins, Kubernetes, GitHub Actions Data Analysis & Visualization: Tableau, Power BI, SAS, Excel, Looker Version Control & Collaboration: Git/GitHub, JIRA

Cloud Services: AWS (S3, EC2, Lambda, IAM, Athena, Redshift), GCP (BigQuery, Dataflow, Pub/Sub), Azure (Databricks, Synapse Analytics, Data Factory, Azure Event Hubs, Blob Storage) Methodologies: SDLC, Agile, Scrum

EDUCATION

Master of Science in Computer Science Jan 2023 – Dec 2024 Illinois Institute of Technology IL

Bachelor of Engineering in Information Science & Engineering Aug 2016 – Sep 2020 JSS Science and Technology University India

PROJECTS

● Atliq Hardware Business Analysis – Power BI Reporting: Developed a comprehensive Power BI dashboard for Atliq Technologies, integrating finance, marketing, sales, and supply chain views. Enhanced data visualization with interactive tooltips, page navigation, and bookmarks, enabling real-time insights and efficient decision- making for business teams.

● Mitron Bank Credit Card Strategy – Power BI Reporting: Designed an interactive Power BI dashboard using customer behavioral data to deliver actionable insights for credit card segmentation and market targeting. Collaborated with stakeholders to identify key metrics, performed data cleaning in Excel, and crafted data-driven recommendations to support product strategy and executive decision-making.

● Movie Booking CDC Data Real-Time Analytics using Snowflake and Streamlit: Designed and implemented a real-time data aggregation pipeline using Snowflake Dynamic Tables, Streams, and Tasks to process CDC

(Change Data Capture) data for a movie booking platform. Optimized data processing workflows, reducing query latency by 30%, and ensured seamless real-time updates. Integrated Streamlit dashboards for interactive data visualization, enabling business stakeholders to monitor key booking trends, KPIs in real time.

Contact this candidate