Business Analyst Data Analysis
Resume:
UMA KARNATI
**********@*****.***
LinkedIn:UmaKarnati
Analytical, organized and detail-oriented with 20 years of diverse experience in the field of Information technology with emphasis on Software Quality Assurance, Systems Analysis, Business Analysis and Product Owner in Datawarehouse, DataLake, Reports, UI and API. Collaborative team player with ownership mentality and a track record of delivering the highest quality strategic Initiatives. Extensive experience in handling business requirements, product development, governance processes, Agile/Scrum and waterfall methodologies, consumer and stakeholder engagement. Experience with AWS concepts and Agile methodologies. Strong SQL skills. Enthusiastic to expand to other domains such as Healthcare, ERP, Government and Fintech.
PROFESSIONAL SUMMARY
Experience as liaison between consumer teams, business and development team to refine the requirements and incorporate features based on consumer demands and OKRs.
Experience in implementation and delivery of Strategic initiatives, Data warehouse, Data Lake, UI, Reporting, API REST/SOAP, both on-prem and on cloud.
Partnered with business cohort teams and product leadership to drive and manage the development backlog and ensure the delivery team understands the direction and vision.
Created and maintained the solution vision, roadmap, and backlog of work for both functional and NFRs through the project's life cycle.
Translated features into user stories within the team's backlog while managing, ranking, and prioritizing this backlog to reflect stakeholder's requirements and creating BRDs.
Involved and driven requirement discussions, walkthroughs, modeling, source to target mappings, scrum work, QA team, Data quality assurance, deployments and consumer testing.
Participated in Devops and ServiceNow activities to assist team in operating more efficiently and effectively
Involved and performed post development UAT and performed demo for consumers.
Applied Agile methods and processes to promote a disciplined and transparent project management process.
Worked closely with various stakeholders such as Governance, Stewardship, Business Operations, support teams leading to the success of many deliverables
Deliver EPDI initiative with 8 external data vendors and B2B teams internally and integrated data for Warehouse.
Mentored junior analysts to enhance their skills contributing to improve team capability and project delivery
Agile experience of key frameworks such as SAFe, Kanban and Scrum and heavy involvement in PI planning
KEY SKILLS
Data Analysis, Data Profiling, Data Quality
Datawarehouse, SQL, Oracle, Redshift,PostgreSQL, SQLServer
Informatica, Ab Initio
HTML, JavaScript, XML, JSON, Python
REST/SOAP API, AWS, ServiceNow
Teradata, Toad, DBeaver, Informatica
Crystal Reports, PowerBI, Tableau, SPLUNK, POSTMAN
Agile/Kanban, Jira, Confluence, Excel, Powerpoint, Sharepoint
Lucid Charts, Data models, Agile, Kanban, Waterfall
Workiva, Collibra, MDM, ERStudio, PowerApps
CERTIFICATIONS
Oracle Certified Associate (OCA)
Certified Scrum Master
Certified Scrum Product Owner
SAFe Product Manager/Product Owner
Release Train Engineer (training)
EXPERIENCE
Aug 2021 – Apr 2025 Lead Business Analyst
Fanniemae, Reston, VA
ESG/Finance/CorporateDataHUB
Work closely with business teams on product needs, create features and roadmaps, work with upstream applications to identify data points, work with data SMEs and data stewards on data anomalies, data gaps and rectify for our needs.
Work with architects, and other cross functional teams to create integrated roadmaps, prioritize features and development with stakeholder engagement, define metrics and equip the business to drive the mission.
Advance analysis for business requirements including gathering and documenting requirements, prioritizing, system analysis, governance process for attribute rationalization and DSETs, logical and physical Modeling, STTM, Data Quality validations and data fixes and stakeholder walk-throughs.
Deep analysis of data for quality checks, data anomalies, variances and work with data SMEs in understanding the patterns which can help us in solutioning for the business needs.
Developed and executed complex SQL queries for data validation, quality checks, and root cause analysis across large datasets.
Created source-to-target mapping documents and also providing the validations with SQL to adhere to the expected results..
Utilized SQL to extract, analyze, and validate data from databases such as Oracle, DynamoDB and Redshift.
Automated recurring data checks and created reusable SQL scripts to improve testing efficiency and accuracy.
Conducted data quality checks, data profiling and gap analysis using aggregate and window functions in SQL to ensure business rule compliance..
Worked closely with data governance teams for any data cleanup.
Worked with Business operations teams for production data updates and making sure full business justification and no impacts to stakeholders with deep impact assessments.
Collaborated with multiple cross-functional sprint teams in the ART during PI planning to deliver prioritized features on time, ensuring alignment with business goals and no disruption to stakeholder operations.
Participated in regular scrum of scrum meeting to make sure teams are connected.
End products included metrics generation, DataHub, API, Data quality, Reports, UI.
Communicate progress and findings to program leaders, management and other key partners via status calls, release notes, and demos.
Worked on both on-prem and AWS cloud projects with heavy involvement in Data
Tools: AWS, Workiva, SQL, Redshift, Tableau, Dbeaver, REST API, POSTMAN, PowerApps, AWS Appstream, Jira, Confluence, Workiva
June 2014 – Aug 2021 Senior Business Analyst
Fanniemae, Reston, VA
Enterprise Data
Advance analysis for business requirements for SingleFamily and Multifamily including gathering requirements, prioritizing, system analysis, governance process for attribute rationalization, logical Modeling, Physical data model, STTM, Data quality checks, Master Data management and stakeholder walk-throughs Delivered multiple data features at every monthly release for various in release cycle
Collaborate with Business and Enterprise Architecture on defining target architecture
Maintain product backlog and plan roadmap collaborating with stakeholders and various sprint teams to align priorities towards consumer goals.
Involved from requirements phase to delivery phase of the multiple high visibility initiatives like CSP, CETS, CECL, PRISM, LAI, SIR, Enterprise Property Initiative (EPDI) on EDL, integrated Finance Data Lake(DDL)
Handled requirements which involved more than 20 data sources relating to Singlefamily, multifamily, DUS, Casefile and providing data to multiple consumers
Written and execute complex SQL queries for data validation, generating expected results, to share with dev teams with deep analysis done to help with development in confidence
STTM involved mapping, logic, transformation, data anomalies, derivations, final expected results along with SQL queries to align with business needs
Delivered multiple deliverables in On-prem and in Cloud using AWS
Delivered Cloud initiative Enterprise Property Data initiative (EPDI) to onboard external data sources to Fanniemae and internal source of Single family and Multi Family data
Part of multiple Legacy applications retirement and onboarded multiple consumers to EDI through multiple iterations of EDI data analysis for consumer needs.
Delivered many consumer requirements for 40+ releases zero defects
Tools: Oracle, SQL, AWS, API RESTful, Redshift, TOAD, Dbeaver, AWS Appstream, Jira, Confluence,PowerApps,PowerBI,MDm
June 2009 – June 2014 Senior QA/ Business Analyst
Fanniemae, Reston, VA
Home Affordable Mortgage Program (HAMP)
(HAMP is part of the President's board, comprehensive strategy to get the economy back on track and help 7 to 9 million families)
Experience working on Obama's Investor Reporting-2 Initiative (HAMP) gaining great knowledge on Loan subject area.
Experience in leading interfaces team of 5 testers
Experience with data analysis and systems analysis
Extensive data validations, system test, regression test, business reviews
Proficient in data profiling using SQL, back end testing
Tools: Oracle, SQL, XML, TOAD, Test Director, PVCS, DOORS
Oct 2006 – Feb 2009 Senior QA/ Systems Analyst
Sprint, Reston, VA
Reporting Platform
Validated large-scale data transformations and loads within Teradata Data Warehouse, ensuring data integrity and business rule compliance.
Developed and executed SQL queries for source-to-target data comparison, duplicate checks, and data profiling.
Conducted regression, system, and integration testing data feed into Teradata from various source systems.
Identified and documented data quality issues and collaborated with ETL developers to resolve transformation logic discrepancies.
Experience with system analysis for reporting purposes
Experience with leveraging existing reports and data for consumer needs.
Data profiling for advance analysis of business requirements
Provided mappings and logic to developers to generate new reports based on business needs and validated for the accuracy via demos and walkthroughs.
Tools: TOAD, Crystal reports, SQL, Teradata
Jan 2005 – Oct 2006 Quality Assurance Analyst
DHSoft (Client : Nextel), Herndon, VA
Datewarehouse
•Executed and validated ETL workflows using Informatica PowerCenter, ensuring data accuracy as per business requirements
•Developed and executed complex SQL queries to perform source-to-target data validation, transformation logic testing, and reconciliation
•Collaborated with ETL developers to verify data mappings, business rules, across large datasets
•Created test cases for recurring data validation scenarios, reducing manual effort and improving test coverage
•Performed regression and system integration testing for ETL pipelines in a Data Warehouse environment supporting reporting and analytics
Tools: TOAD, SQL, Informatica
EDUCATION
Bachelor of Engineering (India)
Sri KrishnaDevaraya University
Contact this candidate