SPANDANA KUNAMANENI
Data Engineer
Cincinnati, OH +1-513-***-**** ********************@*****.*** LinkedIn PROFESSIONAL SUMMARY
• Data Engineer with 4+ years of experience building cloud-native ELT/ETL pipelines on AWS, Azure, and Snowflake, processing 1M+ records daily and enabling near-real-time analytics for finance, supply chain, and consulting domains.
• Proficient in Python, SQL, PySpark, dbt, and Airflow; builds ML-ready pipelines and AI-driven automation that reduced data latency by 35–40% and improved downstream model data reliability.
• Skilled in data governance and security (RBAC, row-level security, encryption, data masking), supporting PCI, SOX, and GDPR compliance for enterprise data platforms.
• Automated CI/CD using Git, Azure DevOps, Jenkins, Terraform, and ARM templates, including AI-assisted code review workflows, cutting deployment errors by 90%.
• Delivered cost-effective warehousing and analytics with Snowflake, Synapse, Redshift, BigQuery, Power BI, and Tableau, powering fraud detection, risk scoring, and operational reporting. TECHNICAL SKILLS
Languages: Python (Pandas, NumPy, Scikit-learn), SQL (advanced querying, tuning, stored procedures), PySpark, Spark SQL
Big Data & Streaming: Apache Spark, Hadoop, Apache Kafka, AWS Kinesis, Azure Event Hubs, Stream Analytics, Delta Lake
ETL & Orchestration: dbt, Apache Airflow, Fivetran, AWS Glue, Azure Data Factory, Talend, SSIS, Logic Apps Cloud – AWS: S3, Glue, Redshift, EMR, Lambda, Kinesis, Athena, DynamoDB, CloudWatch, IAM Cloud – Azure / GCP: Databricks, Data Lake, Synapse Analytics, Data Factory, Key Vault, Monitor; GCP BigQuery Databases & Warehousing: Snowflake, Redshift, BigQuery, Azure Synapse, SQL Server, Azure SQL, PostgreSQL, MySQL Data Modeling: Dimensional Modeling, Star & Snowflake Schemas, SCD Type 1 / Type 2 CI/CD & DevOps: Azure DevOps, Jenkins, GitHub Actions, AWS CodePipeline, Terraform, ARM Templates, Git ML / AI: Scikit-learn, Spark MLlib, XGBoost, LightGBM, LLM APIs (OpenAI, Hugging Face), LangChain BI & Visualization: Power BI, Tableau, Looker, SSRS, Excel Governance & Security: RBAC, Row-Level Security, Data Quality, Data Masking, PCI, SOX, GDPR Methodologies & Tools: Agile/Scrum, Kanban, JIRA, Azure Boards, Microsoft Teams; A/B Testing, Time Series Analysis PROFESSIONAL EXPERIENCE
CGI Jan 2025 – Present
Data Engineer Ohio, USA
• Designed and automated end-to-end ELT pipelines using Snowflake, dbt, and Fivetran, orchestrated with Apache Airflow, reducing reporting latency from days to hours for Pricing and Supply Chain teams.
• Led modernization from SQL Server, SSRS, and SSAS to Snowflake + dbt, migrating legacy reports and cubes, standardizing transformation logic, and reducing dependency on on-premise infrastructure.
• Developed and optimized SQL scripts, stored procedures, and dbt models, improving query performance by 35–40% and lowering Snowflake compute costs.
• Implemented row-level security, RBAC, and data governance standards in Snowflake and Azure, meeting internal policy and external audit requirements.
• Built CI/CD pipelines with Git and Azure DevOps to automate deployment of dbt models and SQL objects, reducing manual deployment errors by 90%.
• Created automated validation and reconciliation frameworks for ETL testing, reducing QA effort by 30%.
• Integrated LLM-based automation to summarize data quality issues, pipeline failures, and metadata, speeding up triage for engineering and business teams.
• Automated code review and approval workflows by integrating AI agents with Git, dbt, and CI/CD pipelines, cutting review cycle time by 40–50%.
• Collaborated with Supply Chain, Pricing, and IT Architecture teams in Agile sprints, managing backlogs and releases in Azure DevOps to deliver data solutions on schedule. RedSun Solutions May 2024 – Dec 2024
Data Engineer Ohio, USA
• Developed ETL pipelines using Azure Data Factory, Logic Apps, and Azure DevOps to ingest and transform 1M+ records daily, saving 15 hours of manual effort per week.
• Built real-time CDC pipelines with Azure Data Factory and Delta Lake, reducing transaction data latency from hours to under 15 minutes.
• Optimized big data workflows with Azure Databricks and PySpark, enabling near-real-time analytics on large-scale financial datasets.
• Implemented streaming pipelines with Azure Event Hubs and Stream Analytics for low-latency financial event processing.
• Designed SCD Type 1 and Type 2 pipelines in Azure Synapse for accurate historical tracking of customer, account, and transaction data.
• Built ML-ready feature engineering pipelines in Synapse and Data Lake, delivering governed datasets for fraud detection, risk scoring, and customer analytics models.
• Implemented automated data validation and drift-detection checks in SQL and Python, catching 95% of data inconsistencies before they reached production ML models.
• Secured sensitive financial data with Azure Key Vault encryption, dynamic data masking, and auditing; set up monitoring and alerting with Azure Monitor and Log Analytics.
• Enhanced CI/CD automation with Azure DevOps, Terraform, and ARM templates for consistent, auditable deployments.
Coforge Jul 2021 – Jul 2023
Data Engineer India
• Designed ETL pipelines using AWS Glue, Talend, and Apache Airflow across structured and unstructured sources, improving data consistency by 30%.
• Architected a layered S3 data lake (Raw, Processed, Analytics) supporting scalable ingestion, transformation, and downstream analytics.
• Developed PySpark batch and streaming transformations on EMR, improving processing efficiency for large datasets by 50%.
• Built real-time ingestion with Kinesis Data Streams and event-driven Lambda triggers, cutting ingestion latency by 50% and processing delays by 70%.
• Implemented CDC pipelines with AWS Glue for near-real-time sync of transactional databases at 99.9% data accuracy.
• Automated pipeline deployments with AWS CodePipeline and Jenkins, shortening release cycles by 50%.
• Set up CloudWatch monitoring and alerting, reducing pipeline downtime by 60%.
• Configured IAM roles, bucket policies, and RBAC to enforce secure, compliant access, passing all internal security audits.
• Partnered with data scientists, analysts, and business stakeholders to define data requirements, increasing project delivery speed by 20%.
EDUCATION
University of Cincinnati Cincinnati, OH
Master of Engineering, Computer Engineering