Implemented Oracle BI Cloud Connector, Oracle Cloud Infrastructure, Oracle Functions, Oracle Integration Cloud, BIP and AWS S3 to automate the process of exporting data from SaaS Oracle ERP Cloud to AWS S3. Also, created OIC integration to execute the custom BI Publisher report as a service.
CLEVELAND CLINIC HOSPITAL
Created OTBI reports & Dashboards for various Oracle Financial-linked systems. Implemented and integrated cloud service for file-based integrations with the help of Universal Content Management (UCM) Webservices. Also, developed Cloud File Based Data Import (FBDI) and OIC extracts from Lawson to the SaaS cloud.
UNIVERSITY OF INDIANA MEDICAL HEALTH
Created Financial Extracts for Global HR and Payroll, using OCI, SOAP, REST APIa Medical Health. Managed Financial lineage from Lawson source tables. Designed an end-to-end HCM solution and set up Oracle Identity Cloud Service.
Conducted the Development of Fusion Cloud BIP and OTBI reports using various procedures. Designed Custom Security for Oracle HCM Cloud, including Create/Modify Data roles and its Security Profiles. Also, devised custom BIP reports for Financials/ SCM/HCM.
Collected Core HR (Enterprise), Compensation, Absence business requirements (BRD) and mapped them to Oracle HCM Cloud functionality. Materialized the OTBI and BIP reports in Oracle Fusion Cloud. Completed Life Cycle implementation experience of Enterprise Business Intelligence (EBI) using Oracle BI.
USAF DEAMS PROJECT
OBIA full stack implementation, detailed ODI/ETL architecture, agents scenarios, packages, data mapping, data extractions, transformations and validations. Implemented Oracle E-business Suite. Implemented Golden Gate for use by ODI.
Installed and implemented complete OBIA modules, customized ODI inital loads, Performance tuning of Oracle E-business Suite and OBIA , extensive Oracle Data Integrator(ODI) development. Implemented BPEL and SOA.
Implemented and configured OBIA. ODI integration with Apache HBase on top of Hadoop. Extensive customization of OBIA Intelligence Dashboards. Implementated of E-Business Suite.
Installed and configured OBIA, Performance tuning, custom BI Publisher Reports, converted Oracle Discoverer reports to Oracle Business Intelligence reports.
UNIVERSITY OF MIAMI
Configured analytics platform environment, upgraded Oracle Campus Solutions, configured Active Directory Weblogic integration and developed custom Campus Solutions dashboards and reports.
Implemented and configured E-Business Suite. Implemented and configured OBIEE/OBIA. Migrated Informatica ETL’s to ODI. Performance tuning of OBIEE Dashboards/Reports.