Sudhakara Reddy Medagam

Requirement Analysis: Gathered business requirements and authored comprehensive Technical Design Documents (TDDs) for seamless implementation of reporting and data integration solutions.

• Team Leadership: Led a team of over 10 members, ensuring project timelines were met and fostering a collaborative work environment.
• Reporting Solutions: Designed and delivered customized reporting solutions to meet diverse business needs using Oracle Analytics Server (OAS).
• ETL Customization: Developed and optimized custom ETL processes using Oracle Data Integrator (ODI) to integrate and transform data efficiently.
• RPD and Report Development: Created and maintained RPD models and dashboards, enabling actionable insights and improved decision-making.
• Code Migration & Release Support: Managed code migration activities via GitHub branches, providing on-call support for successful system releases.

Key Achievements:
Streamlined code migration processes, reducing release preparation time by 1 hour.
Delivered optimized ODI mappings, resulting in a Y% improvement in ETL performance.
Played a critical role in resolving system test issues, ensuring zero post-production defects.

• Analytical Report Development: Designed and implemented analytical reports using Incorta, delivering insights to support lease management decision-making.
• Schema Creation: Developed Physical and Business Schemas in Incorta, enabling efficient data organization and reporting.
• Datamart and ETL Setup: Configured DataMart's and built pipelines using Azure Data Factory (ADF) to load data into Azure SQL Server databases, ensuring seamless data integration.
• Power BI Visualization Enhancements: Enhanced Power BI dashboards by creating new columns and measures using DAX, improving data visualization and usability.
• User Access Management: Controlled report and dashboard access by implementing role-based security, ensuring data integrity and compliance.

• OBIEE Report and Dashboard Development: Designed and developed interactive reports and dashboards in OBIEE (OAC), providing actionable insights for business decision-making.
• RPD Data Model Creation: Developed RPD data models to ensure efficient data organization and accurate reporting in OBIEE.
• ETL Integration: Worked on Informatica mappings to pull data from multiple data sources into the data warehouse, streamlining data integration processes.
• Created comprehensive reports in I Analyze and SAP Hubwoo to support business analysis and reporting needs.
• Power BI Data Modelling and Report Development: Created and managed data models in Power BI, developing reports and dashboards to present key metrics and trends.
• Publishing Power BI Reports: Developed and published Power BI reports and dashboards on the Power BI server, ensuring accessibility and data-driven decision-making across the organization.
• Data Security Implementation: Implemented role-based data security to ensure appropriate access to sensitive data in reports and dashboards.
• Agile Methodology: Collaborated in an Agile environment, participating in sprint planning, stand-ups, and retrospectives to ensure timely delivery of business intelligence solutions.
• Oracle APEX Applications: Developed and maintained Oracle APEX applications to provide custom data entry, reporting, and dashboard functionalities for business users.

• Report and Dashboard Development: Developed reports and dashboards in OBIEE, providing actionable insights and enabling data-driven decision-making for business stakeholders.
• Data Validation: Conducted data validations for reports, ensuring data accuracy and consistency across different reporting platforms.
• Data-Level Security: Implemented data-level security in OBIEE, validating access controls and ensuring compliance with organizational requirements.
• Informatica Mapping Development (SCD Type 2): Developed Informatica mappings for Slowly Changing Dimensions (SCD Type 2), supporting data warehousing and integration efforts.
• Report Performance Tuning: Involved in performance tuning of OBIEE reports, improving report load times and enhancing user experience.

• ETL Development: Developed Informatica mappings to create aggregate tables, optimizing data processing and improving report performance.
• Variables and Initialization Blocks: Created and implemented variables and initialization blocks in OBIEE to enhance dynamic data filtering and improve reporting flexibility.
• Performance Tuning: Contributed to report performance tuning by implementing aggregate table navigation, reducing report load times and improving user experience.
• Agent Automation: Implemented agent automation to trigger jobs and workflows after successful ETL loads, ensuring data availability for reporting.
• DDR Reports: Worked on DDR (Detailed Diagnostic Reports) to monitor and troubleshoot performance and data accuracy issues across the BI system.
• ETL Failure Troubleshooting: Diagnosed and resolved ETL failures, ensuring timely data integration and minimizing downtime.
• Cache Purging: Managed BI Server cache purging using OBIEE agents, ensuring data freshness and accuracy for end users.
• DAC Execution Plans: Created and maintained System Agent (SA) and Execution Plans in DAC (Data Warehouse Administration Console) to automate ETL load schedules and ensure smooth data processing.

• Security Implementation: Implemented Object and Data level security within OBIEE to ensure data access control and compliance with organizational policies.
• Report Development and Tuning: Involved in the development of OBIEE reports, utilizing variables and initialization blocks for dynamic data filtering. Performed performance tuning on OBIEE reports, optimizing execution times and report load speeds.
• Master-Detail and Action Links: Applied master-detail linking and action links in OBIEE to enhance report interactivity and improve user navigation through data.
• Presentation Variables and Prompts: Created and used prompts and presentation variables to allow users to filter and customize reports, improving usability and flexibility in reporting.
• RPD Data Modelling: Involved in RPD data modelling, including the creation of level-based measures and establishing relationships between data elements for efficient reporting.
• ETL Monitoring and Troubleshooting: Monitored ETL processes and troubleshot failures, ensuring timely data loads and system reliability.
• Fact and Dimension Modelling: Built new fact tables using Informatica mappings, establishing primary-key/foreign-key (PK-FK) relationships for accurate data modelling and reporting.
• QlikView Data Integration: Developed Informatica mappings to load data into external files (.qvx), which were then used as data sources for QlikView reports, enabling enhanced analytics and visualization.