Mahidhar Reddy Lankireddy

About Mahidhar Reddy Lankireddy

I am a Technology Consultant at Infosys with a Master’s degree in Computer Science from…

Experience

1. Technology Analyst

   Infosys

   Jun 2025 — Present · Quincy, MA, US

   Client : State Street Corporation • Collaborated with cross-functional teams, including development, data engineering, and product owners, to review user stories, clarify requirements, and define test strategies and plans.• Designed and executed test cycles, built scripts, and performed end-to-end regression testing for client onboarding projects (e.g, Invesco, N91, HSBC, LGIM).• Prepared and loaded client reference and historical data into reference tables using the ESP tool in UAT/BUAT environments.• Posted various transactions, including Security, Cash, Stock Equity, Fixed Income, Term Deposit, FX Forward/Spot via RKS Producer, and batch transactions via OSA RMG tool.• Validated transaction flows from RKS Producer to SSCD consumption mart tables.• Wrote complex SQL queries in Oracle and Snowflake to validate ETL logic and ensure data quality across environments.• Identified and resolved data discrepancies, ensuring data consistency and integrity.• Verified daily EOD, SOD, ITD, WE, and ME extracts in Data Lake Blob Storage Account for each client.• Inspected metadata, extract configurations, alerts, state monitors, workflows, and event logs in Azure Cosmos DB and Swagger.• Validated API messages using SoapUI and Insomnia tools.• Monitored SLA trackers, extract monitors, reference data uploads, exceptions, and alerts using the ESP UI dashboard.• Logged and tracked defects in JIRA, ensuring timely resolution and documentation.• Captured testing artifacts, provided test reports, and ensured alignment with Agile deliverables.• Actively participated in Agile Scrum calls, Sprint planning, Backlog grooming, Sprint demo, retrospectives, and team meetings.