KRISHNA SAI SOMANA
****************@*****.***
*** * ****** **, *********, Kansas, 66762.
www.linkedin.com/in/krishnasaisomana1518
PROFILE
Self-motivated Master's student in Information Technology with a solid foundation in software development and data management, demonstrated through experience as a Programmer Analyst at Cognizant. Proficient in SQL and Informatica Power Center, with successful contributions to data integration projects. Proven leadership skills as President of the Indian Student Organization, complemented by a strong academic background. EDUCATION
Master of Science in Information Technology, Pittsburg State University Expected Graduation: May 2026 USA Current GPA - 3.3/4
Bachelor of Technology in Electrical and Electronics Engineering, Amrita Vishwa Vidyapeetham
2018 – 2022 India
CGPA-7.3/10
PROFESSIONAL EXPERIENCE
Programmer Analyst, Cognizant Technology Solutions 08/2022 – 12/2024 Bengaluru, India
•Created and maintained 30+ ETL tables, mappings, sessions, and workflows using Informatica PowerCenter for enterprise data integration
•Scheduled and monitored daily and weekly workflows, ensuring accuracy on-time data processing and reliable downstream reporting
•Enhanced data extraction, transformation, validation, and performance tuning by optimizing SQL and Teradata queries across extensive healthcare datasets, leading to improved data processing efficiency
•Supported data warehousing and reporting solutions for Horizon Blue Cross Blue Shield, ensuring data accuracy, consistency, and timely delivery
•Collaborated with cross-functional teams to troubleshoot ETL issues, perform data analysis, and enhance overall data processing efficiency
•Worked on importing informatica PowerCenter workflows to IDMC, and did data validation across both with no errors. Intern, Cognizant Technology Solutions 02/2022 – 06/2022 Bengaluru, India
•Trained and certified on SQL, Data structures, Informatica PowerCenter and Informatica MDM.
•Implemented a whole project starting from creating dump source tables to finalizing a golden copy in MDM with middle process of Informatica PowerCenter tools.
Organization Experience
President, Indian Student Organization at Pittsburg State University 09/2025 – Present USA
•Managed planning and execution of multiple university events by coordinating teams, timelines, and resources, ensuring smooth operations and high student engagement PROJECTS UNDERTAKEN
AI-Assisted Legislative Vote Extraction System, Pittsburg State University 09/2025 – 12/2025
•Developed an automated system to extract legislative voting data from Oklahoma House committee and floor vote sources into structured CSV outputs
•Leveraged prompt-driven AI to iteratively design, validate, and improve data extraction logic, ensuring accuracy across multiple file formats
Healthcare Claims Data ETL Pipeline, Cognizant 05/2022 – 08/2022
•Designed an end-to-end ETL pipeline to process healthcare claims data from source systems into a data warehouse
•Built Informatica mappings, sessions, and workflows to cleanse, transform, and load member, provider, and claims data
•Implemented data validation rules, reducing data inconsistencies by 30% SKILLS
ETL Development, Data Engineering, Informatica PowerCenter, SQL, Teradata, Data Warehousing, ETL Workflows & Scheduling, Data Integration, Batch Processing, Data Validation & Data Quality, Performance Tuning, Healthcare Data Integration, Query Optimization, Cross-functional Collaboration AWARDS
2nd prize in Circuit Master,
Vidyut Multi level National Fest at Amrita Vishwa Vidyapeetham 02/2020
1st prize in Slow Descent,
Vidyut Multi level National Fest at Amrita Vishwa Vidyapeetham 02/2020
1st prize in Slow Descent,
Vidyut Multi level National Fest at Amrita Vishwa Vidyapeetham 02/2019
ELIGIBILITY
Eligible to work in United States Of America with valid work authorization, Willing to relocate