Summary
Overview
Work History
Skills
Certification
Skills
Projects
Tools
Timeline
Generic

Madhavi Mittadhoddi

Ashburn,VA

Summary

  • With 18 years of experience in the software industry, I’ve held various roles that have allowed me to continuously grow and expand my expertise.
  • I demonstrated consistent growth at Freddie Mac, moving through multiple roles over time. I started as a Senior Tester and progressively advanced to Test Lead, Senior Analyst, Analysis Tech Lead, Business Lead, Product Owner Manager, and finally to Risk Systems Development Tech Lead.
  • In each role, I played a key part in driving success by contributing to various aspects of testing, analysis, product ownership, and technical leadership, consistently performing at a high level and expanding my responsibilities within the organization.
  • I have worked on a diverse range of web-based and GUI applications on UNIX and Windows operating systems.
  • My expertise lies in Modern Delivery, Agile, and Waterfall methodologies.
  • I have successfully guided product teams of 12 to 25 members, overseeing projects from requirements gathering to deployment and maintenance.
  • Notably, I led a team in refactoring legacy code into cloud-based microservices (APIs), improving scalability and maintenance.
  • I also have experience upgrading databases to MongoDB and Postgres for cloud readiness.
  • I actively engage stakeholders, customers, vendors, and upstream/downstream teams in planning and communications.
  • I design products, develop roadmaps, and translate business requirements into actionable Jira stories. I conduct impact and gap analysis to enhance products and maintain consistency.
  • Additionally, I automate testing processes and maintain test scripts and data.
  • As an SME, I possess expertise in SQL, XML, JSON files, and APIs. I have exceptional attention to detail, strong communication skills, and project management skills. Proactively addressing issues to optimize processes and support team objectives comes naturally to me.

Overview

26
26
years of professional experience
1
1
Certification

Work History

Product Owner/Risk System Development Tech Lead

Freddie Mac
04.2022 - Current
  • Worked as a Product Owner in the IDEA team, focusing on onboarding and optimizing data for model consumption.
  • Collaborated with business stakeholders to define scope, data needs, and objectives, and identified key business cases, impacted processes, and dependencies.
  • Led the creation of a roadmap with milestones and deadlines, and presented design solutions for accurate and granular data analytics.
  • Additionally, documented business and system requirements, collaborated with data modelers to structure unstructured data, and created master data specifications to track data lineage.
  • Guided test data creation, reviewed testing outcomes, and monitored data quality through reports and checks. Finally, you managed the backlog and prioritized tasks to align with business goals

Product Owner/Business Lead

Freddie Mac
03.2020 - 04.2022


  • Worked as an AIM Product Owner within a large portfolio team consisting of two programs and 12 product teams, specifically under the Income Property Asset program.
  • Played a key role in Program Increment (PI) planning, collaborating with business stakeholders and product teams to develop a clear product strategy based on customer-driven design.
  • Defined business requirements based on customer feedback and research, and acted as the interface between customers, stakeholders, and the product team to communicate stories and outcomes.
  • Documented epics, features, and stories in Jira, maintained the product backlog, and organized discovery decks and process flows in Confluence.
  • Resolved technical issues, defining performance requirements, and providing business definitions for new data elements.
  • Additionally, supported the team in testing strategies and test automation, which significantly reduced testing periods.
  • Conducted sprint demos to gather feedback from stakeholders and coached product analysts on best practices.
  • As a Subject Matter Expert (SME), I am the go-to person and cloud compatibility.
  • Collaborated with engineering teams to assess technical feasibility and define realistic project scopes.

System Analysis Tech Lead

Freddie Mac
06.2019 - 03.2020


  • Worked closely with Business Drivers to gather and articulate business requirements, translating them into XML and JSON specifications for data from external vendors.
  • Performed detailed analysis on borrower asset and income data, designed the database, and created mapping documents.
  • Collaborated with architecture, development teams, and DBAs, explained the business context behind data to inform solution designs.
  • Researched and recommended cost-effective solutions, analyzed system issues, and revised logic as needed.
  • Articulated business and system requirements into stories in VersionOne and Jira and worked across development, operations, technical support, and IT teams throughout the project lifecycle.
  • Designed a comprehensive system testing plan and worked in Agile methodology with 3-week sprints.
  • Conducted sprint demos for constant feedback, collaborated with the test automation team to significantly reduce regression testing time
  • Served as a Subject Matter Expert (SME) to the operations team during production issue resolution.

System Analysis Senior

Freddie Mac
08.2015 - 06.2019


  • Collaborated with external vendors to obtain appraisal data from the Uniform Collateral Data Portal (UCDP) and worked on analyzing and documenting detailed system requirements for the Reps and Warranty Service.
  • Partnered with DBAs to design database tables for storing data from both internal and external systems, and maintained mapping documents to track the source and target XPaths of all elements.
  • Used IBM DOORS to formulate detailed requirements and created a Requirements Traceability Matrix (RTM).
  • Coordinated with multiple teams to define roadmaps, assumptions, and milestones, and prepared charts and diagrams to support problem analysis and solution development.
  • Recommended efficient, cost-effective solutions while considering existing systems and technology.
  • Actively involved in all phases of development, collaborating with various teams, and designing a system testing plan to ensure product accuracy.
  • Reviewed and approved test scenarios and results, and performed user acceptance testing to ensure business scenarios were adequately covered.

Test Lead

College Board
01.2015 - 08.2015


  • Adapted to changes in the data feed for answer sheets to accommodate the new College Board's redesign of the SAT assessment in 2016,
  • Thoroughly understood the new business process flow and functional requirements, analyzing the data to identify relationships between tables.
  • Developed test strategies, scenarios, and test data based on the updated requirements and conducted testing of the XML data feed from external vendors.
  • Tested various modules using SOAP UI, performed data transformation testing for the ETL process, and validated data through flux jobs, ensuring both syntactic and semantic accuracy.

Test Lead

Freddie Mac
04.2012 - 06.2014


  • Worked on several key projects, including Gfee, Workout Prospector (WP), and HAMP Step Rates.
  • The Workout Prospector application was designed to modify non-performing loans in default, and I contributed to automating loan modification settlements and liquidation workouts like Short Sales, Deed in Lieu, and Charge Off.
  • Worked in loan processing stages such as approval, settlement, and compensation, and you helped rewrite the old WP application from the 90s to a new, modern version.
  • You participated in requirements review meetings, identified requirement gaps, and provided input for database design and data correction.
  • Wrote complex SQL queries to test backend processes, and prepared comprehensive test plans, scenarios, and documentation.
  • Worked within Agile methodology, attending daily scrum meetings for updates and issue resolution, and utilized ClearQuest to review requirements and develop test strategies. Your testing responsibilities included functional system testing, end-to-end UAT, ETL testing (DB2 to Oracle), and report testing for SSRS and MicroStrategy, writing SQL queries to validate the data and reports.


QA Analyst/Backend Tester

United Parcel Service
04.2009 - 12.2011
  • Calculate Time and Cost (CTC): A web application that provides Transit (time) and Rate (Cost) for a given delivery route
  • Tested the web services using SOAP UI to test the request and the response by creating the test data and checking the actual response to the expected response

Lead Analyst and Tester

Department of Agriculture, AP, India
05.1999 - 09.2004
  • Worked on the data analysis and data collection tool in the Department of Agriculture's official website that provides farmers the latest information on farming practices and collects crop data from them


Skills

  • Certified Scrum Product Owner, Scrum Alliance
  • Certified Scrum Master, Scrum Alliance
  • Product Manager Certificate, Product School
  • Accredited Mortgage Professional, Mortgage Banking Association

Certification

  • CEO Award - received Freddie Mac's highest award
  • Above and Beyond Award - received multiple from stakeholders
  • Spot Awards - received multiple spot awards from team mates


Skills

  • Lead a team of 20+ people
  • Defining the product vision
  • Coming up with OKR's
  • Building bridged between business and tech
  • Identifying Risk and mitigating it
  • Decision making
  • Maintaining Product backlog and prioritization
  • Detailed analysis
  • Release planning & Roadmaps with milestones and dependencies
  • Detailed test scenarios

Projects

Freddie Mac, Product Owner/Risk System Development Tech lead

Innovation data engineering and Analytics (IDEA)


  • Loan Product Advisor (LPA/ULAD)
  • Asset Income Modeler (AIM) Data, Fair Lending Data for Analytics and FHFA reporting
  • Uniform Collateral Data (UAD 3.6) for HVE/CCE/ACE models
  • Uniform Property Data (UPD) for Property Data report (PDR)


Freddie Mac, Product Owner/Business Lead


  • Loan Product Advisor (LPA/ULAD)
  • Asset Income Modeler (AIM) Data, Borrower Capacity Verification Service (BCVS)


Freddie Mac, System Analysis Tech Lead


  • Borrower Capacity Verification Service (BCVS) for AIM


Freddie Mac, System Analysis Senior


  • Loan Collateral Advisor (LCA)/Collateral Day 1 Reps and Warranty


Freddie Mac, Test Lead


  • Workout Prospector, Loss Mitigation Workstation


Freddie Mac, Test Lead 


  • Guarantee fee (Gfee), HAMP Step Rates, Workout Prospector


College Board, Test Lead


  • Assessment Redesign Data Feeds




United Parcel Service, QA Analyst/Backend Tester


  • Calculate Time and Cost


Department of Agriculture, AP, India, Lead Analyst


  • Department of Agriculture Official Website and Data Collection Tool

Tools

  • Database/Tools : Mongo DB, PostgreSQL, Oracle, DB2 SQL Server, Rapid SQL, SQL Toad


  • Requirements tools: Jira, Sharepoint, Confluence, IBM Doors, ClearQuest


  • ETL Tools: Informatica, DataStage


  • Web service tools and files : SoapUI, XML, Rest Client, JSON, APIs, Postman


  • Languages: C, C++,Core Java,SQL, PL/SQL/ XQuery/ HTML, XML,Python


  • Reporting Tools : Tableau, Cognos, Microstrategy, SSRS




Timeline

Product Owner/Risk System Development Tech Lead

Freddie Mac
04.2022 - Current

Product Owner/Business Lead

Freddie Mac
03.2020 - 04.2022

System Analysis Tech Lead

Freddie Mac
06.2019 - 03.2020

System Analysis Senior

Freddie Mac
08.2015 - 06.2019

Test Lead

College Board
01.2015 - 08.2015

Test Lead

Freddie Mac
04.2012 - 06.2014

QA Analyst/Backend Tester

United Parcel Service
04.2009 - 12.2011

Lead Analyst and Tester

Department of Agriculture, AP, India
05.1999 - 09.2004

Similar Profiles

CREATE PROFILE
Madhavi Mittadhoddi