Summary
Overview
Work History
Education
Skills
Certification
Timeline
Nagarjuna Peddakotla

Nagarjuna Peddakotla

FDI OAC OBIEE Certified Professional
hyderabad

Summary

  • An IT professional with 16 years of total work experience in FDI, FAW, OAC, OBIEE 10g, 11g, 12c, BI APPS, SQL.
  • Certified professional in FDI, OAC, OBIEE
  • Currently working on FAW/FDI with 3+ Years of experience and attended FAW/FDI Bootcamp.
  • FDI experience in creating high-performance custom workbooks, canvases, and custom metrics.
  • Experience in implementing Data Pipeline, Data Augmentation Semantic Model Extension and FDI custom security.
  • Collaborated with clients to understand their business objectives, data sources, and reporting requirements
  • Highly skilled in problem identifier and troubleshooter.
  • Have experience in 3 complete life cycle projects and 6 Enhancement projects with onsite experience.
  • Extensive experience in OBIEE RPD modeling, OBI Answers, OBI Intelligent Dashboards, OBI Publisher, Delivers, Agents and implementation of Objects/ Data level security.
  • Extensive experience in BI upgrade, retrofit components at different OBIEE layer like answers, OBIEE RPD and underlying configuration files.
  • Worked on RFC's, converting BRD's to technical design documents.
  • Has worked in all phases of BI life cycles including analysis, design, development, testing, deployment, post-production support/maintenance, documentation, and end-user training. Experience in implementing Security, Using EM, Web logic Admin and Oracle Stack Architecture.
  • Experience in Administration, RPD, Web-cat migrations, Installation, and configuration of the entire BI Apps stack in Windows and Unix environment.
  • Delivered projects successfully in different domains (Telecom/ Postal/ Marketing/ Material Management/ Supply chain/ Inventory /oil).
  • Strong expertise with full lifecycle Implementation of Business Intelligence with Star and Snowflake Schemas using OBIEE and Informatica.
  • Experience in enhancing the performance of Reports/Dashboards by implementing the Aggregate tables, Aggregate Navigation, Proper indexes, implemented Cache purge strategy and query cost optimization techniques.
  • Strong Experience in report/dashboard tuning by examining the execution plans.
  • Good at understanding existing Stored procedures and packages. Experienced in Object/ Data level security to provide right access to user and to secure data privacy.
  • Experienced in RPD and web catalogue migration.
  • Analyzing the root causes for repetitive break fixes and thereby providing the permanent fix by developing/customizing the PL/SQL code Debugged production issues within SLA Quick learner and very good at exploring grey areas.
  • Automation solution made to trigger ODI jobs through OBIEE dashboards for flash activity for user.
  • Experience in upgrading OBIEE application platform from 10g to 11g.
  • Expert in Client interaction, requirement analysis and contribution to system study and analysis.
  • Interactions with multiple business and technical teams to carry out the design activities.
  • Responsible for estimation of team deliverables/projects Worked as a BI Capability expert within a large global organization.

Overview

17
17
years of professional experience
4
4
Certifications

Work History

Consulting Technical Manager (P4)

Oracle
09.2024 - Current
  • Handling team of 10 members
  • Certified professional in Oracle Fusion Data Intelligence
  • Created dashboards and reports that provided stakeholders with real-time data visualizations.
  • Performed ad hoc analysis to answer business-specific questions and provide insights for strategic initiatives.
  • Worked closely with stakeholders to understand business needs and designed customized BI solutions accordingly.
  • Provided ongoing support and troubleshooting for BI solutions, ensuring smooth operation of reporting tools and systems.
  • Developed and customized FAW extensions and Oracle Analytics Cloud (OAC) dashboards
  • Enhanced semantic models to support complex business reporting needs.
  • Work in close collaboration with onsite teams, business analysts, and functional leads to gather requirements and ensure timely project deliverables.

Senior Specialist Data Engineering (P4)

LTIM
03.2022 - 09.2024
  • Handled team of 5 members
  • Attended FAW/FDI Bootcamp
  • Analyzing Power BI reports and creating mapping sheets.
  • Involved in client meetings to get the requirements and to understand the business.
  • Created high-performance custom workbooks, canvases, and custom metrics.
  • Implemented Data Pipeline, Data Augmentation Semantic Model Extension and FDI custom security.
  • Collaborated with clients to understand their business objectives, data sources, and reporting requirements
  • Deep dived into Power BI reports and converted them into FDI reports.
  • Mentored team in successfully delivering the FDI reports within the timelines.
  • Had calls with Oracle CEAL team for product support and SR’s.
  • Defect fixing and migration activities for FAW reports.
  • Developed and customized FDI extensions and Oracle Analytics Cloud (OAC) dashboards
  • Enhanced semantic models to support complex business reporting needs.
  • Work in close collaboration with onsite teams, business analysts, and functional leads to gather requirements and ensure timely project deliverables.

Technical Lead (IC4)

Oracle
02.2017 - 03.2022
  • Worked with GMSS team to deliver Cloud, Infinity, Horizon projects, other integration and enhancements to help marketing team to see the insights of business.
  • Interacting with senior directors, VP’s and users to understand their current process and future expected reporting needs.
  • Performed RPD modeling by integrating multiple data sources data and built OBIEE reports which drove deep insights into data of multiple data sources.
  • Performed activities on RPD modeling and reports and database tables to overcome ongoing performance issues.
  • Provided customized reports to users which added business value to customer.
  • Build Oracle SQL stored procedures to load transformed data into BI tables.
  • Enhanced existing stored procedures to add more value to business as per business requirement documents.
  • Weekend support to monitor data loads from multiple sources to BI Layer.
  • Attended BI SUMMITS in ORACLE HQ to discuss the ongoing and upcoming projects.
  • Collaborated with multiple source teams to understand the business needs and functionality.
  • Have taken care of RPD deployments from development to stage environments.
  • Assist with deployment, implementation, and enhancement.
  • Created Ibots to deliver ETL load performance monitor reports to Team.
  • Have been part of OBIEE 12c to OAS and OAS to OAC migration activities to make sure on-premises system runs smooth and to streamline performance issues.

Team Lead

Accenture
12.2012 - 01.2017
  • Worked with KPN, POSTE, USS clients on Implementation & Enhancement projects.
  • Onsite Experience
  • Agile experience used Jira to track backlogs, sprints& pocking Work.
  • Interacting with clients to get requirements and functional knowledge.
  • Prepared design documents with the help of Business Requirements
  • Had worked on Informatica of all layers SILO’s, Stage and data warehouse to extract, transform and load data to BI tables.
  • Performed RPD modeling and delivered OBIEE reports as per business requirements by following OBIEE standards.
  • Configured usage tracking to track user reporting interesting areas.
  • Secured data using data level and object level security by creating application roles and providing right access to users.
  • Performed OBIEE application & artifact upgrade from OBIEE 10g to OBIEE 11g.
  • Responsible for connecting to different product owners to understand functional requirements and business process such as Material management.
  • Created SCD’s in informatica to keep ongoing and historic data in data warehouse.
  • Built Informatica mappings and OBIEE reports as per requirement.
  • Understanding functional requirements, manage/convert data accordingly to provide best fit results.
  • Managing technical tasks, assigning it to team members and providing technical guidance.
  • Coordinated across cross functional teams across partners and vendors.
  • Handled SLA, client expectation and handled escalation.

OBIEE Developer

Future Focus Infotech
06.2011 - 10.2012

Engineer (SQL / ERP)

MYHOME Industries ltd
10.2008 - 07.2010

Education

B-Tech - Mechanical Engineering

JNTU, Hyderabad, India
04.2001 -

Skills

OBIEE

Certification

Oracle Fusion Data Intelligence 2024 Implementation Certified Professional

Timeline

Consulting Technical Manager (P4) - Oracle
09.2024 - Current
Senior Specialist Data Engineering (P4) - LTIM
03.2022 - 09.2024
Technical Lead (IC4) - Oracle
02.2017 - 03.2022
Team Lead - Accenture
12.2012 - 01.2017
OBIEE Developer - Future Focus Infotech
06.2011 - 10.2012
Engineer (SQL / ERP) - MYHOME Industries ltd
10.2008 - 07.2010
JNTU - B-Tech, Mechanical Engineering
04.2001 -
Nagarjuna PeddakotlaFDI OAC OBIEE Certified Professional