Madhumitha Manduva

Specialist Data Engineer with 9+ years of experience in designing, developing, and supporting large-scale ETL and data integration solutions in the financial services domain. Strong expertise in Ab Initio, Unix, and Shell Scripting, with hands-on experience in building high-performance data pipelines and batch processing frameworks. Exposure to cloud-based data engineering solutions using PySpark.

Ab Initio Certified

Professional with strong knowledge of data processing, optimization, and enterprise-grade Data Warehouse ETL architecture. Proficient in SQL, Oracle, MongoDB, Hive, and HDFS, with solid knowledge of data warehousing and database management concepts. Experienced in handling complex financial data and working extensively in the credit card domain, with a strong understanding of credit card systems, regulatory reporting, and downstream financial applications.

Adept at ensuring data quality, performance optimization, and delivering reliable, scalable, and efficient data engineering solutions in fast-paced Agile environments.

Specialist Data Engineer - Larsen & Toubro Mindtree (LTM) - Hyderabad, Telangana

(2022-07)

• Worked on CCAR14M – FR Y-14M Mortgages and Cards monthly regulatory reports by developing ETL - Ab Initio workflows to extract data from multiple source teams and load it into target tables for downstream processing.
• Initiated migration of a minor module from Ab Initio to PySpark as part of modernisation and performance improvement initiatives to support scalable and future-ready data processing solutions.
• Designed and implemented scalable solutions to modernise and automate reporting processes for multiple data units such as PROX, BRANDED, COSTCO, and CRS, resulting in nearly 40% reduction in execution time and enabling faster file delivery to downstream consumers by several hours each month.
• Built a unified execution framework to run multiple processes dynamically through sub-plan looping and condition-based execution logic, reducing manual execution efforts and improving process maintainability and operational efficiency.
• Developed and maintained the FR2420 reporting process by extracting data from Hive source systems, transforming and loading the data into output files, and delivering them to downstream applications by utilizing Ab Initio Control Center for workflow orchestration, scheduling, monitoring, and execution management.
• Automated existing workflows by introducing looping mechanisms and parallel executions, which significantly improved processing performance, reduced overall batch runtime by around 35–40%.
• Implemented automated validation checks and post-execution email report generation, eliminating repetitive manual validation activities and improving reporting accuracy and turnaround time for business users and clients.
• Worked extensively with Hive, HDFS, Unix, Shell Scripting, SQL, and Oracle in developing and enhancing enterprise data engineering solutions.
• Worked on MAS649 Singapore regulatory reporting. Involved in analyzing reporting requirements, handling data validations, and ensuring accurate data processing for MAS649 report generation.
• Worked closely with Data Governance teams to ensure compliance with enterprise metadata and quality.

Senior Software Engineer - Accenture - Hyderabad, India

(2020-02 - 2022-07)

• Developed and maintained large-scale Ab Initio ETL pipelines to extract, cleanse, transform, and load PLCC and Dual Card datasets into the enterprise data warehouse, supporting high-volume financial processing.
• Worked on Credit Card Risk Data Governance Project
• Performed advanced data transformations, validation, and enrichment for consumer and commercial credit-card portfolios, ensuring accuracy for analytics, regulatory, and reporting workflows.
• Optimised Ab Initio graphs, plans, partitioning, and parallel flows, improving end-to-end pipeline performance and load times by 20–30% while enhancing system reliability.
• Automated recurring workflows using Unix shell scripting, enabling better file tracking, monitoring, and reduction of manual intervention.
• Performed root cause analysis for production incidents and implemented permanent fixes.
• Reviewed technical designs, code changes, and effort estimates to ensure alignment with project requirements and coding standards.
• Automated retention activities to identify and delete obsolete and unused files, improving storage management and operational efficiency.
• Developed a script to identify unchecked-in and unwanted objects from the sandbox environment and remove them automatically.
• Collaborated directly with business stakeholders for requirement gathering, solution reviews, and approval cycles, received a "Well-Deserved" Recognition Award for high-quality delivery and consistent performance.
• Provided Ab Initio ETL training for entry-level engineers across India entering the data-engineering stream, improving team capability and onboarding efficiency.
• Supported QA Validations and post-production support for the ETL Applications.
• Prepared technical designed documents, mapping specifications, process flows and test plans.

Systems Engineer - Tata Consultancy Services (TCS) - Hyderabad, India

(2016-08 - 2020-02)

• Led the end-to-end migration of complex SAS logic to Ab Initio, building scalable ETL pipelines aligned with banking regulatory and analytics requirements.
• Designed and optimized Ab Initio graphs, plans, and parallel-processing components, delivering measurable performance improvements.
• Built an automated Unix scripting framework that dynamically generated multiple psets based on input templates, significantly reducing developer effort and improving operational efficiency.
• Enhanced workflow orchestration and operational stability using shell scripting, Autosys for scheduling, strengthening automation, monitoring, and error handling.
• Received 'Star Performer' Award for exceptional delivery and technical excellence at the TCS account level.

Bachelor of Technology - Computer Science & Engineering - KAKATIYA INSTITUTE OF TECHNOLOGY & SCIENCES (2016-05)