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
04.2001 -
Skills
OBIEE
FAW
FDI
OAS
OAC
SQL
Informatica (9x)
BI APPS (Finance, SCM, ERP)
JIRA
HPQC
Oracle APEX
Source (EBS, Siebel, Eloqua, Certain, etc)
Agile and Waterfall model experience
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 -