* Developed and implemented OTBI Dashboards for HCM data, including Active Employee, New Hire, and Benefits Reports.* Created and scheduled various reports, including ad hoc reports, to meet dynamic business requirements.* Configured and migrated setups, developed reports using OTBI, Smart View, and FRS, and performed data conversions using web services and File-Based Data Import (FBDI).* Engineered PL/SQL packages for lookup value retrieval, email generation, data validation, and transformations.* Prepared data files using Oracle Fusion's predefined FBDI templates, ensuring data accuracy, completeness, and compliance with validation rules.* Implemented interfaces and conversions using Oracle Cloud Integration and FBDI for seamless data migration.

• Developed custom OTBI and BIP reports using complex SQL queries and subject areas, tailored to client requirements• Implemented data security for custom BI reports in Oracle Fusion Financials Cloud, including FINS Security with MOAC• Created cross-subject area OTBI reports and generated reports through scheduled processes and agents• Engineered AR Auto Invoice interfaces between third-party systems and Oracle AR Cloud for streamlined operations• Implemented AR Lockbox using FBDI process and developed AP Payments integrations in NACHA format for various banks• Designed reports using Financial Report Studio and implemented GL Journal Interface for data synchronization• Expertise in Oracle Cloud ERP, financial reporting, data security, and system integration

• Collaborated closely with functional teams and business users to deliver tailored solutions within tight deadlines• Executed data conversions for Supplier, Payables, and General Ledger (GL) using File-Based Data Import (FBDI)• Developed multi-tab reports for VAT Returns and Customer Collection Aging, meeting specific client requirements• Created complex Fusion BIP Reports and BI Publisher reports with RTF layouts and bursting capabilities• Designed OTBI analyses and dashboards to enhance business intelligence and decision-making• Managed Enterprise Scheduler Service (ESS) jobs for efficient data movement into Fusion Applications base tables• Led project teams in delivering high-quality reports, interfaces, and data conversions• Provided regular status updates and issue reports to project managers and clients• Expertise in report bursting for automated email distribution, improving information dissemination