Resume

Production Support Business Intelligence

Location:

Greensboro, NC

Posted:

August 23, 2023

Contact this candidate

Resume:

Viru Ponnam

Ph no:480-***-****

E-mail:ady51a@r.postjobfree.com

Experience summary:

Sixteen plus years of experience as Oracle OAC/BI Publisher/BI Cloud/OTBI/FRS (Financial Reporting Studio/Essbase/Smart View/EPM/Siebel /XML Publisher/EPBCS/FCCS/Primavera Unifier and experience in gathering Business Requirements, performing GAP Analysis, Design / Data Modeling, Development, Testing, Implementations and Documentation of various functionalities of Data Warehouse / Data Marts and Business Intelligence using agile development techniques.

Experience with Financial Extracts/OBI Reports/OTBI Analytics for FAW, Financials, Order Management, HCM application in cloud environment

Developed BI Reports/OTBI/Smart View/FRS in Oracle Fusion Cloud and scheduled the reports with to be delivered to Email and FTP sites.

Prepared several OTBI reports including customized reports for Financial modules and Security configuring object level and database level security.

Experience in Batch Processing tools like FBDI, BI Reports and ESS jobs for Fusion Applications.

Integrating the cloud and on premise application through OIC (Integration Cloud Service) and SAAS, PAAS integration through SOAP, REST & DB Adaptors.

In OIC integration, reading the source data from FTP Server/DB and doing the required transformation and conversion which is required for target application like Fusion FBDI template format, this type of conversion are handled in OIC integration itself without any staging DB.

Oracle EBS source tables, consolidate and integrate from the existing Finance, Manufacturing repositories into a centralized warehouse repository and re-built the Ad-hoc and User reports/dashboards.

Involved in complete life cycle of BI implementation for multiple projects in requirements gathering, perform initial analysis, data modeling, development, testing and production support.

Redesigning the data modeling directly on SAAS/Cloud fusion/OLTP transactional EBS tables by developing the repository in Administration tool and the reports in BICS without ETL, DAC and DWH tables.

Strong experience in development, production support and administration-oriented tasks of Hyperion EPM products.

Worked on Migration project related to Hyperion Planning Classic Applications to Enterprise Performance Management Architect (EPMA).

Experience in writing complex Business rules and creation of business rule sets as per requirement.

Migration of applications and components in different environments by using utilities like LCM.

Experience in managing user/group security in shared services, creation of ASO/BSO applications.

Clustering,Load Balancing, Configuring delivers, bots,Cache management, performance tuning at report level, database level .Installation,development,administration,production Support of OBIEE

Experience in installing and configuring Oracle Bi Applications(informatica,DAC,OBIEE) and integrated with Oracle EBS, FAH,Oracle e-Business suite (Oracle Process Manufacturing, Oracle Inventory, Oracle Purchasing and Oracle Sales).

Expertise in configuration of Oracle BI Analytics Repository, DAC (Execution Plans, Subject Areas, Containers, Design, Setup, Execute etc.,), Create/Manage Intelligent dashboards

Expertise in working with Process Manufacturing, Financial,PPM, Projects and Billing, Sales, Marketing, pharma, HRMS,Time and Labor(OTL),Order management Analytics.

Experience in BigData,Data Analysis & Warehousing using Informatica. Primavera, Strong understanding of Dimensional Modeling, Hyperion, Smart view Star and Snowflake Schemas and Dashboard Reports.

Extensive experience in configuring Interactive Dashboards with drill-down capabilities using global and local Filters,MICR fonts, Siebel Security Setup (groups, access / query privileges), Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports).

Knowledge on BIRT Framework and Web Java development.

Excellent people management, team building, presentation, facilitation techniques, motivation & leadership skills. Ability to learn and adapt to new technologies,

Coordinated with offshore development team members to resolve issues,Provided regular status reports and interacted directly with client leads.

Technical skills:

BI : OAC/BI Cloud/BICC/OBIEE12c/EPM/FRS/ 11.1.1.9/1.6/1.5/10.1.3.4/OAC/Siebel Analytics8.0/7.8/7.7//crystal reports/Cognos

ETL : Informatica Power Center/Power Mart 8.6/8.1.1/7.1.4/6.2

RDBS : Oracle 10g/9i, EBS,OPM,SQl Server

Modeling : Erwin, Dimensional Data Modeling-R Modeling

Scheduling : DAC 7.8.5v, CVS, VMS

Tools : .Net,SQL,SSIS, PL/SQL, ESSBASE, Hyperion,Cloud LastPass

Web Servers : Apache, IBM Web Sphere, Web Logic, and IIS

Integration Services : Oracle SOA suite

Operating Systems : Win XP, Red Hat Linux, UNIX

Summary of projects:

Client:Stations Casinos inc(Las Vegas,Nevada Nov ’21– Till date

Role: Sr. Oracle Fusion Cloud(OTBI/BIP/FRS/Smart view/PBCS) Consultant

Responsibilities:

Identify/Discover the Oracle fusion source tables for Financials//Inventory, PPM,consolidate and integrate from the existing OAC Finance, OM into a centralized warehouse repository and re-built the Ad-hoc and User reports/dashboards.

Oracle OBIEE BICS/Dbaas/Oracle(OAC/BICC),APEX,OBIA 11g/12c BICS Financials(AR,AP,GL,SL,FA), HCM,Procure and Spend,, Project Analytics functional and technical guidance and design role.

Developed Financial Extracts/OBI Reports/OTBI Analytics for Financials,Order Mangement application in cloud environment

Extensive FAH experience to External Applications with Oracle GL through configure complete event Data Modles

Implementing FAH for integrating various applications with Oracle EBS/GL,Projects for client accounting needs

Developed BI Reports/OTBI/Smart View/FRS in Oracle Fusion Cloud and scheduled the reports with to be delivered to Email and FTP sites.

Prepared several OTBI reports including customized reports for FAW,Financial modules and Security configuring object level and database level security.

Experience in Batch Processing tools like FBDI, BI Reports and ESS jobs for Fusion Applications.

Integrating the cloud and on premise application through OIC (Integration Cloud Service) and SAAS, PAAS integration through SOAP, REST & DB Adaptors.

Worked on various reports for financials AR Customer statement, AR Transactions report, Transfer order report, shipment details query and data model for customized BIP report development, Invoice and Credit Memo detail report, shipping and selling price item report,all report customizations based on customer billing document and forms,FA depreciation water fall report etc.

Worked on building BI Publisher report for extracting data from Fusion SaaS to PaaS using standard and custom templates for various tables and used techniques like report bursting, grouping, parameter list values for extracting data

Have used Oracle Transactional Business Intelligence (OTBI) report to analyze and report HCM data for employee details

Worked on preparing technical design documents after gathering client requirements

Involved in complete life cycle of BI implementation for multiple projects in requirements gathering, perform initial analysis, data modeling, development, testing and production support.

Redesigning the data modeling directly on OLTP transactional EBS tables by developing the repository in Administration tool and the reports in BICS without ETL, DAC and DWH tables.

Working on various BI Publisher Data model and SQL interfaces for the application.Using bursting capability for Batch Reporting

BI Publisher Report Development Report Templates Formatting Engine Report Output Familiar desktop tools for layout customization

Develop Web proxy call for running the batch processing of reports using Oracle BI Publisher with XML supersets, services and database as data sources

Designed and modified Smart view reports /FRS database outlines for better performance and for dynamic calculations.

Created load rules for PBCS dimension building and data loading, comprehensive experience in developing scripts using MaxL.

Experience in application backup using LCM and MAXL in creation and modification of reports using FR studio.

Strong experience in scripting languages like VBScript and Batch script to automate the process.

Environment: Oracle Cloud Analytics,OAC, PPM, EBS,Cloud Fusion,FCCS, BI Publisher12c,Template Builder, Oracle BI Server, BI Publisher Enterprise,SQL developer,TOAD, Oracle 12c

Client: Diebold Nixdorf inc,Canton,OH(Implementer:Accenture) Sep ’20– Oct’21

Role: Sr. Oracle Cloud BI(OAC)/OTBI/BI Publisher/SmartView/FRS Consultant

Responsibilities:

Identify/Discover the Oracle EBS source tables for Order Management/Inventory, consolidate and integrate from the existing OAC Finance, OM into a centralized warehouse repository and re-built the Ad-hoc and User reports/dashboards.

Oracle OBIEE BICS/Dbaas/Oracle(OAC/BICC),OBIA 11g/12c BICS Financials(AR,AP,GL,SL,FA), HCM,Procure and Spend,, Project Analytics functional and technical guidance and design role.

Developed Financial/HCM Extracts/OBI Reports/OTBI Analytics /APEXfor Financials,Order Mangement application in cloud environment

Developed BI Reports/OTBI in Oracle Fusion Cloud and scheduled the reports with to be delivered to Email and FTP sites.

Prepared several OTBI reports including customized reports for Financial modules and Security configuring object level and database level security. .

Worked on various reports for financials AR Customer statement, AR Transactions report, Projects,PPM,Transfer order report, shipment details query and data model for customized BIP report development, Invoice and Credit Memo detail report, shipping and selling price item report,all report customizations based on customer billing document and forms,FA depreciation water fall report etc.

Involved in complete life cycle of FAW BI implementation for multiple projects in requirements gathering, perform initial analysis, data modeling, development, testing and production support.

Redesigning the data modeling directly on OLTP transactional EBS tables by developing the repository in Administration tool and the reports in BICS without ETL, DAC and DWH tables.

Working on various BI Publisher Data model and SQL interfaces for the application.Using bursting capability for Batch Reporting

BI Publisher Report Development Report Templates Formatting Engine Report Output Familiar desktop tools for layout customization

Develop Web proxy call for running the batch processing of reports using Primavera unifier Oracle BI Publisher with XML supersets, services and database as data sources

Worked with database administrators to optimize report performance through database tuning. Created Meta Data repositories using OBIEE administration tool.

Created OBIEE subject areas based on reporting requirements and built them into the physical layer of the OBIEE repository.

Extensive work experience on Business Intelligence solutions through the complete project lifecycle from requirements analysis, design, development solutions to implementation and delivery of the overall project using Essbase technology.

Strong experience in development, production support and administration-oriented tasks of Hyperion EPM products.

Worked on Migration project related to Hyperion Planning Classic Applications to Enterprise Performance Management Architect (EPMA).

Experience in writing complex Business rules and creation of business rule sets as per requirement.

Migration of applications and components in different environments by using utilities like LCM.

Experience in managing user/group security in shared services, creation of ASO/BSO applications.

Experience in pushing data from one application to other using Essbase replicated partition, archiving BSO data into ASO application also troubleshooting data related issues.

Creation of calculation scripts for currency translation, allocations and for complex calculations using calculation script editor.

Designed and modified Essbase database outlines for better performance and for dynamic calculations.

Created load rules for dimension building and data loading, comprehensive experience in developing scripts using MaxL.

Experience in application backup using LCM and MAXL in creation and modification of reports using FR studio.

Strong experience in scripting languages like VBScript and Batch script to automate the process.

Environment: Oracle Cloud Analytics,EPBCS,OAC, PPM,EBS,Intelligence(OBIEE)12c, BI Publisher12c,Template Builder, Oracle BI Server, BI Publisher Enterprise,SQL developer,TOAD, Oracle 12c

Client: PPD Inc,Wilmington,NC(Implementer:TCS) Feb ’20– Aug’’20

Role: Sr. Oracle Financials/OAC/OTBI/BI Publisher Consultant

Responsibilities:

Involved in creating Oracle Cloud OTBI, OAC, FAW and BI PublisherFinancials) applications in accordance with existing applications. Created Dash boards in PBCS using forms, FR Reports (AR,AP,GL,FA)etc, POC for Valid Intersection in PBCS(Balance Sheet, forms.

Prepared new feature documents for PBCS for FP&A users for their ease of PBCS use, knowledge on the metadata management and data integration with PBCS.

Automated tasks (metadata updates, data loads, import/export) using EPM Automate, Created Calc manager rules in both PBCS and On-Premise Planning.

Involved in Hyperion Planning development activities such as Webform, Calculation Manager Rules etc.

Worked closely with FPA users for successful UAT for Essbase applications, Developed and modified calculation scripts, business rules in Hyperion Essbase, Planning apps 11.1.2.4.

Created complex webforms with Validation rules and adhoc grids.

Strong experience in development, production support and administration-oriented tasks of Hyperion EPM products.

Involved in creating Oracle Cloud PBCS and EPBCS(Financials) applications in accordance with existing 11.1.2.4 applications.

Created Dash boards in PBCS using forms, FR Reports etc.POC for Valid Intersection in PBCS forms.

Prepared new feature documents for PBCS for FP&A users for their ease of PBCS use.

Have knowledge on the metadata management and data integration with PBCS.

Automated tasks (metadata updates, data loads, import/export) using EPM Automate.

Created Calc manager rules in both PBCS and On-Premise Planning.

Involved in Hyperion Planning development activities such as Webform, Calculation Manager Rules etc.

Worked closely with FPA users for successful UAT for Essbase applications.

Developed and modified calculation scripts, business rules in Hyperion Essbase, Planning apps 11.1.2.4.

Created complex webforms with Validation rules and adhoc grids.

Involved in DRM application development for metadata build and automation. Using Extended Analytics, loaded data from HFM to Essbase application.

Worked on Migration project related to Hyperion Planning Classic Applications to Enterprise Performance Management Architect (EPMA).

Experience in writing complex Business rules and creation of business rule sets as per requirement.

Migration of applications and components in different environments by using utilities like LCM.

Experience in managing user/group security in shared services, creation of ASO/BSO applications.

Client: Volvo Inc, NC Greensboro,NC(Implementer:Keste Inc) May’17– Jan’20

Role: Sr. Oracle Cloud/OBIEE /BI Publisher/OTBI Consultant

Responsibilities:

Performed in-depth analysis and documentation of business logic and requirements. Developed high level design documents for reporting and analysis projects. Extensive experience in working with Multi User Development in OBIEE Cloud Connector,BICC,OAC Environments

Migrate IaaS, PaaS and SaaS instances between public and private clouds - Java, J2EE, .NET, Ruby, LAMP, Apache, RDBMS, Oracle, SQL, MySQL, Unix/Linux, NAS/SAN, LAN/WAN VPN, Security, IDS, Firewalls and Encryption.

Oracle BI Publisher12C installation, setup and configuration, migration to various environments.

OBIEE12c Caching, OBIEE parameters & other settings (reviewed best practices, etc), OBIEE Security integration, and performed usage tracking various other related reports.

BI Publisher reports are triggered by Big Data usage along with the real time Production issues based on OTBI BI publisher scheduler and configuration for printing reports.

Deployed the RPD from MUDE to DEV, QA and production environments

Designed and implemented Physical and Logical Star Schemas using Facts, Dimensions, Alias, Metrics and Extension tables provided with Foreign and Complex joins.

Converting OTBI, Cognos, brio, PeopleSoft crystal reports in Oracle Reports for Financial (AR,AP,GL,SAL,FA),HR(Benefits) and new reports.

Using RTF and BI Publisher Engine with OBIEE Interface.

Working on various BI Publisher Data model and SQL interfaces for the application.Using bursting capability for Batch Reporting

Conversion from Crystal Reports to BI Publisher, as well as work with the database to create stored procedures, functions and views

BI Publisher Report Development Report Templates Formatting Engine Report Output Familiar desktop tools for layout customization

Develop Web proxy call for running the batch processing of reports using Oracle BI Publisher with XML supersets, services and database as data sources

Worked with database administrators to optimize report performance through database tuning. Created Meta Data repositories using OBIEE administration tool.

Created OBIEE subject areas based on reporting requirements and built them into the physical layer of the OBIEE repository.

Managed ODBC connections with created Meta Data and Repositories according to needed Subject Areas.

Created schedules to seed and purge cache for cache management. Implemented security by creating roles and web groups, and defined Object Level and Data Level .Defined and created Initialization Blocks, Repository and Session Variables for generating filters and defining security.

Designed and built the physical and logical models in Physical and Business Model & Mapping Layer in the OBIEE Administration tool.

Worked on RTF Templet and interactive template for migrating reports from 10 G to 11G.Worked on RTF Template, OAF(Oracle Application Framework),and interactive template for migrating reports from 11G to 12C.Worked on scheduling BIPublisher reports basing on user requirement.

Performed monitoring and analysis on OBIEE report usage. Established and followed processes for OBIEE access requests, new report requests, report changes, and other ongoing maintenance.

Participated in the Modeling of several multi dimensional including surrogate key design and index placement.

Experienced in Data warehouse/Data Mart Development Life Cycle and performed ETL procedure to load data from different sources into data- warehouse using Power Center, Repository Manager, Designer, Workflow Manager and Workflow Monitor.

Worked in Production Support Environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.

Developed test cases and performed Unit Testing and Integration Testing of the Repository and Web Catalogs.

Used Oracle Data Integrator ODI to extract relevant data from Oracle EBS and map it to Siebel interface tables.

Used Oracle Data Visualization Desktop to connect to Oracle Cloud Application OTBI environments to get data

Involved in modification of local object mask to simplify the creation of more number of interfaces

Created and Configured ODI Repositories, Interfaces, Packages, Procedures and Scenarios.

Environment: Oracle Business Cloud,Intelligence(OBIEE)12c, BI Publisher12c,Template Builder, Oracle BI Server, BI Publisher Enterprise, SSRS,Oracle Data Integrator (ODI) v.12.1.1.1/v.11.1.1.7,SQL Developer,TOAD, Oracle 12c

Client: KPMG(End client:State Client),Saramento,CA Mar’15– June’17

Role: Sr. Oracle OTBI/ BI Publisher Report

Responsibilities:

Oracle OTBI,BI Publisher12C installation, setup and configuration, migration to various environments.

OBIEE12c Caching, OBIEE parameters & other settings (reviewed best practices, etc), OBIEE Security integration, and performed usage tracking various other related reports.

BI Publisher reports are triggered by BigData usage along with the real time Production issues based on OTBI BI publisher scheduler and configuration for printing reports.

Experience with Oracle BI Apps SQL Server, Financial Reporting studio11.1.2.3,, BI Publisher integration with BI presentation services environment.

Working with state client for billing, report and notices generation using BI Publisher and integrating with Siebel environment.

Developing templates related to,cconnector, notices, approval and denial documents.

Working with the business users to resolve production issues related templates, xml conversions, XSLT transformations, binary decode and encode load data to test the layouts of reports.

Converting crystal reports in Oracle Reports and new reports.

Using RTF and BI Publisher Engine with OBIEE Interface.

Working on various BI Publisher and SQL interfaces for the application.Using bursting capability for Batch Reporting

Conversion from Crystal Reports to BI Publisher, as well as work with the database to create stored procedures, functions and views

BI Publisher Report Development Report Templates Formatting Engine Report Output Familiar desktop tools for layout customization

Develop Web proxy call for running the batch processing of reports using Oracle BI Publisher with XML supersets, services and database as data sources

Develop and support forms generated using legal pre-printed forms through Oracle BI Publisher

Work as an Oracle Business Intelligence Publisher specialist in Data Architecture and Reporting team

Design Oracle BI Publisher Data Models, Data sets and Templates / sub templates which will be used by business in daily basis.

Analyze Medicaid data, XML supersets to develop XML, XSLT, SQL coding to create Client Facing Documents through OBIP.

Design complex RTF, PDF, Adobe Flex and Excel templates for Oracle BI Publisher

BI Publisher Integration with Siebel I/O’s, create report layouts, report layout deployment and administration

BI Publisher Engine usingXSL, BI Publisher Client, BI Publisher Engine, XSL Siebel Application Web Services, BI Publisher Server Siebel & OBIEE BI Publisher Client BI Publisher Engine XSL OBIEE Server Any Siebel Version Data

Involved with production support for Notices and reports.

Environment: OBIEE12c, 11g,BI Publisher 11g,Discoverer,, Siebel tools,, SSIS,Oracle OTL, Oracle EBS,SQL Development

Client: JEA(Jacksonville Electricity Authority),FL July’14– Feb’15

Role: Sr. Oracle BI /Cognos Report Consultant

Responsibilities:

OBIEE Caching, OBIEE parameters & other settings (reviewed best practices, etc), OBIEE Security integration, and performed usage tracking various other related reports.

Conversion from Cognos to BI Publisher reports for Oracle CC&B usage along with the real time Production issues based on BI publisher scheduler and configuration for printing reports.

Experience with Oracle BI Apps SQL Server, Crystal Reports BI Publisher, Conversion and Migration of report from BI Publisher integration with BI presentation services environment.