Data Analytics Engineer with Snowflake Expertise

MAHITHA KOPURU

****************@*****.*** • 989-***-**** • https://www.linkedin.com/in/mahithaa-k-/

SUMMARY

Data professional with experience designing and supporting scalable data platforms and enterprise analytics solutions. Skilled in Snowflake, DBT, SQL, and Python for building and optimizing data pipelines, transforming raw and semi-structured data, and delivering analytics-ready datasets. Experienced in ETL/ELT development, data modeling, and performance optimization to support reporting and business intelligence. Adept at troubleshooting data issues, improving pipeline reliability, and collaborating with cross-functional teams to deliver high-quality data solutions in fast-paced environments.

EDUCATION

Northwood University, Midland, MI

Master's Degree • Business Analytics • 2023 - 2024

Andhra University, Vishakhapatnam, India

Bachelor's Degree • Electronics and Communication Engineering • 2017 – 2021

EXPERIENCE

Sradha Technologies, Data Analyst TX, USA

Sep 2025 – Present

•Build and maintain end-to-end analytical data pipelines in Snowflake, supporting product analytics, reporting, and research-driven data use cases.

•Develop, maintain, and optimize DBT models (incremental models, snapshots, tests, and documentation) to transform raw and semi-structured data into analytics-ready datasets.

•Process and transform semi-structured data (JSON, VARIANT) using Snowflake SQL and DBT to support behavioral analytics and downstream reporting.

•Improve Snowflake query performance and cost efficiency through query tuning, warehouse right-sizing, and incremental data processing strategies.

•Monitor and troubleshoot production data pipelines, ensuring data accuracy, reliability, and timely data availability for analytics teams.

•Collaborate with data analysts, product teams, and business stakeholders to translate data requirements into scalable data models and transformations.

•Develop Python and Bash scripts to automate data validation, pipeline monitoring, and operational workflows.

•Maintain data documentation, lineage tracking, and DBT model documentation to support transparency and maintainability of data pipelines.

KPMG India, Analyst – TPRM Bangalore, India

Mar 2023 - Jul 2023

•Designed and maintained analytical data pipelines integrating data from SQL Server and Oracle into curated reporting layers.

•Built transformation logic to handle structured and semi-structured risk datasets, enabling accurate compliance and risk analytics.

•Developed and optimized ETL processes to merge risk-related data from multiple systems, ensuring high accuracy and timeliness in risk reporting.

•Designed Cognos reports and SSRS dashboards to visualize vendor performance, audit compliance, and financial exposure across regions.

•Utilized Cognos Framework Manager to build semantic models supporting self-service BI and enterprise analytics.

•Automated recurring data validation, cleansing, and reconciliation processes using Unix/Bash scripting, reducing manual intervention by 50%.

•Collaborated with business and compliance stakeholders to translate risk assessment models into data-driven workflows, ensuring consistent KPIs and metrics.

•Conducted data profiling and integrity checks to identify anomalies, improving data accuracy for executive risk reviews.

•Used Power BI and Excel Pivots to present risk summaries to the TPRM leadership team and supported cross-functional decision-making.

•Participated in Agile ceremonies (stand-ups, retrospectives, sprint planning), ensuring deliverables aligned with stakeholder expectations and regulatory timelines.

•Created comprehensive documentation for ETL jobs, data dictionaries, and control processes, improving audit readiness and governance.

TCS, Data Engineer – ETL & Business Intelligence Chennai, India

Aug 2021 - Feb 2023

•Developed and supported enterprise ETL applications using SSIS and Talend to enable large-scale reporting and analytics workflows.

•Applied software engineering best practices to build reusable ETL components improving maintainability and development efficiency.

•Designed and optimized relational database schemas, indexing strategies, and SQL queries, improving pipeline performance by 25%.

•Participated in code inspections and peer reviews to ensure compliance with quality standards and best practices.

•Built API integrations and supported Angular-based dashboards enabling operational and near real-time analytics visibility.

•Implemented monitoring and observability scripts to improve issue detection and reduce production incidents.

•Troubleshot performance and data quality issues across pipelines and databases, driving root cause analysis and preventive remediation.

•Collaborated with cross-functional engineering and business teams to deliver scalable solutions aligned with enterprise requirements.

PROJECTS

Northwood University - Electric Vehicles Sales Prediction (Capstone Project) MI, USA

June 2024 - Aug 2024

•Built predictive models using R, Python, and SAS to forecast electric vehicle sales trends with 92% accuracy.

•Designed Power BI dashboards for market performance tracking and executive reporting.

•Applied data cleansing and feature engineering to enhance prediction quality.

•Conducted exploratory data analysis (EDA) and feature engineering using Python, Pandas, and SQL.

•Implemented missing value imputation using techniques such as mean, median, and model-based methods to enhance model robustness.

•Applied machine learning algorithms, including regression analysis and decision trees, to build robust predictive models with a focus on scalability and reliability.

•Achieved an impressive 92% accuracy in predicting sales trends, offering actionable insights that could help manufacturers optimize inventory and marketing strategies.

•Presented findings to academic and industry experts, receiving commendations for delivering clear, data-driven recommendations that support future business decisions in the electric vehicle sector.

Gayatri Vidya Parishad – Anti-Theft Fingerprint Ignition System Visakhapatnam, India

Jan 2021 – May 2021

• Developed an IoT-based fingerprint ignition system designed to prevent unauthorized vehicle access using biometric authentication.

• Integrated Arduino microcontroller with optical fingerprint sensor and RFID module to enhance multi-layer security.

• Implemented embedded C and Python scripts to interface hardware components and manage data communication between the sensor and control unit.

• Configured relay control circuitry for engine ignition based on verified user fingerprints, ensuring reliable performance in real-time environments.

• Conducted testing and validation under various environmental conditions, achieving 98% authentication accuracy and significant reduction in false triggers.

• Presented the project at the Gayatri Vidya Parishad Technical Symposium, receiving commendations for innovation and real-world application in vehicle security systems.

TECHNICAL SKILLS

•Data Engineering & Analytics

DBT (incremental models, macros, tests, documentation, scheduling)

Snowflake (clones, pipes, external stages, semi-structured data, performance tuning)

Data modeling (Star, Snowflake schemas)

•Cloud & DevOps

AWS (S3, Glue, Lambda, Redshift)

Terraform (infrastructure as code – foundations)

CI/CD, Git, Agile/Scrum

•Databases & Data Warehousing

Snowflake, SQL Server, Oracle, Amazon Redshift

•Programming & Automation

Modern SQL (CTEs, window functions, query optimization)

Python (data processing, automation, validation)

Unix/Bash scripting

•BI & Analytics Tools

Power BI, Tableau, Cognos Analytics, SSRS, Excel (Pivot Tables, advanced reporting)

•Tools & Methodologies

Git, CI/CD, Agile/Scrum, Data documentation, Data quality monitoring

LICENSES & CERTIFICATIONS

Microsoft Certified Fabric Data Engineer Associate

AWS Certified AI Practitioner

Forecasting & Predictive Analytics – Datacamp

Data Engineering Specializations – LinkedIn Learning, Udemy

Blue Prism Foundation Certification

NPTEL Certification – Operational Integrated Circuit

LEADERSHIP, INVOLVEMENT & EXTRACURRICULAR ACTIVITIES

Active Member – Data Science Community: Participated in machine learning competitions (Kaggle), hackathons, and analytics meetups to strengthen data engineering and model optimization skills.

Indian Students Organization – Northwood University: Engaged in networking and cultural events, fostering collaboration and cross-cultural communication within the academic community.

Team Representative – TCS (DTCC Project): Served as a liaison between development and operations teams, ensuring effective communication and smooth project execution under Agile frameworks.

Event Organizer – TCS: Led the planning and execution of departmental activities, enhancing employee engagement and teamwork.

Member – INTEC & IETE Organizations: Contributed to technical forums and innovation programs promoting advancements in data engineering and electronics research.

Contact this candidate