Mounika Koduru
Antwerp
Summary
Results-driven Software Engineer at Tech Mahindra, adept at enhancing ETL processes and automating workflows, achieving a 30% efficiency boost. Proficient in SQL and data transformation, I excel in stakeholder reporting and collaboration, delivering actionable insights through advanced analytics and visualization tools like Tableau and Power BI.
Overview
1
1
year of professional experience
1
1
Certification
Work History
Software Engineer
Tech Mahindra
Bangalore
06.2022 - 01.2023
- Developed and optimized Snowflake procedures for branching and looping operations, improving ETL efficiency by 30%.
- Bulk-loaded and transformed Salesforce CRM data into Snowflake and Treasure Data, ensuring data integrity and high performance.
- Conducted comprehensive data validation using information_schema, significantly reducing reporting errors.
- Automated workflows and table updates via Postman and Treasure Data CLI with API integration, saving manual effort.
- Performed data analysis using HiveQL and SQL queries to provide actionable insights for stakeholders.
- Resolved complex data conversion challenges, enabling accurate and timely reporting.
- Collaborated with cross-functional teams to implement user stories, manage sprints, and meet client expectations.
Education
B.Tech - Electrical & Electronics Engineering
JNTU University
India01.2013
Skills
- SQL
- R
- Excel
- Tableau
- Google Sheets
- Tidyverse
- Dplyr
- Ggplot2
- Data cleaning
- Data transformation
- Tableau dashboards
- Excel charts
- Snowflake
- Treasure Data
- SQL Server 2008/2012
- Oracle 11g
- SSIS
- SSRS
- Power BI
- SnowSQL
- HiveQL
- Problem-solving
- Communication
- Collaboration
- Stakeholder reporting
Certification
- Google Data Analytics Professional Certificate, Coursera
- AI For Everyone, Coursera (Andrew Ng)
Projects
Bellabeat Case Study (Capstone Project), Analyzed smart device fitness data for usage patterns, customer segmentation, and trends., Cleaned and transformed raw datasets using R (tidyverse)., Built interactive Tableau dashboards for stakeholders., Recommended product strategy and marketing approaches based on analysis. Penguin Species Analysis (R Programming), Explored Palmer Penguins dataset with data cleaning, visualization, and statistical analysis., Created scatterplots, summary statistics, and storytelling dashboards., Delivered insights on species characteristics and relationships. Hotel Booking Data Exploration (SQL + R), Queried large datasets using SQL and performed exploratory analysis in R., Identified booking patterns, peak seasons, and cancellation trends., Developed dashboards and reports to aid business decision-making.
Additional Highlights
- Experienced in building dashboards and BI reports for stakeholder presentations.
- Strong understanding of ETL processes, data warehousing, and SQL development.
- Skilled in handling large datasets, performing cleaning, and generating actionable insights.
- Familiar with both supervised and unsupervised AI models for business applications.
Languages
English
First Language
Dutch
Beginner
A1
Timeline
Software Engineer
Tech Mahindra
06.2022 - 01.2023
B.Tech - Electrical & Electronics Engineering
JNTU University