Mounika Chandakanna

Data Engineer with 7+ years of experience in data engineering, ETL development, SQL Optimization and production support within banking and analytics domains. Strong hands-on expertise in SQL, ETL Pipelines, Hadoop/Hive and Autosys. Experienced in building and supporting enterprise-scale data pipelines, troubleshooting production issues, performing Root Cause Analysis (RCA), and improving data quality and operational efficiency.

Data Engineer at Bank of America (2022-06 – Present)

• Designed and maintained ETL pipelines using SQL Server and SSIS for analytical and reporting systems.
• Optimized SQL queries and ETL workflows, reducing ETL processing time by 50%.
• Improved data accuracy by 10% through automated validation and reconciliation processes.
• Implemented big data ingestion using Hadoop, HDFS, and Hive for structured datasets.
• Automated daily data loads and validations using AutoSys scheduling.
• Built Python-based utilities and VB.NET automation scripts to streamline data operations and reduce manual effort.
• Performed production support, troubleshooting, and incident resolution activities.

Senior Software Engineer at Bank of America (2020-12 – 2022-05)

• Provided production support for mission-critical banking and trading applications.
• Monitored and managed batch workflows using AutoSys, ensuring SLA compliance and system stability.
• Analyzed and resolved job failures, long-running processes, and data issues using SQL and Unix.
• Performed detailed root cause analysis (RCA) to prevent recurring production incidents.
• Supported application releases and deployments with post-release validation.

Senior Data Analyst at Envestnet Yodlee (2016-05 – 2019-10)

• Worked on high-volume financial transaction data within the Transaction Data Enrichment (TDE) platform.
• Performed data cleansing, enrichment, and transformation using SQL and Excel.
• Delivered ad-hoc and recurring data extracts to internal and external stakeholders.
• Investigated data discrepancies and partnered with engineering teams to resolve defects.
• Ensured adherence to enterprise data standards and governance policies.

Bachelor of Technology in Mechanical Engineering – Godavari Institute of Engineering Technology (JNTUK)