K Santosh Reddy

• 13+ years of experience in the IT industry with a strong background in Data Warehousing , Business Intelligence , and ETL processes using Informatica Power Center .
• Installation and Administration: Installed Informatica Power Center 9.x,10.X on both Windows and Linux environments, configured repositories and integration services, and managed servers for Informatica, OBIEE, and DAC.
• Up-gradation and Migration: Upgraded Informatica from 9.5.1 HF2 to 9.6.1 and 10.1.1 to 10.5.2, ILM from 6.4.1 to 6.5.1, DAC from 10g to 11g, Migrated BI applications from OBIEE 11g to 12c, ILM Data Archive from 6.4.1 to 6.5.1
• Security: Secured OBIEE 12c environments using SSL .
• DevOps Tools: Proficient in using Git , Maven , Nexus , Sonar Qube , Jenkins , Docker , and S3 bucket .
• ETL Design: Designed ETL processes for data warehousing using Informatica Power Center.
• Business Intelligence Solutions: Provided end-to-end BI solutions using Informatica, ODI, OBIEE, and BI Apps.
• OBIEE Development: Developed interactive dashboards, reports, and analytics views with drill-down capabilities, and optimized OBIEE features.
• Testing and Validation: Performed unit, system, and integration testing, and data validation for ETL processes and reports.
• Extensive experience in development, migration, Up-gradation, and support environments, ensuring robust and efficient data management and business intelligence solutions.

Working Experience in Each Product:

Power Center Admin: 9+ Years

ILM Admin: 2 Years

Oracle BI Dev/Admin: 8+ Years

Oracle BI Publisher Admin: 1.5 Years

Alation Data Catalog Admin: 2 Years

Microsoft Power BI: 7 Months