نبذة عني
Results-driven and technically accomplished Oracle Analytics Specialist with over 12+ years of progressive, hands-on experience across data warehousing, business intelligence, and enterprise analytics platforms. Demonstr…
Results-driven and technically accomplished Oracle Analytics Specialist with over 12+ years of progressive, hands-on experience across data warehousing, business intelligence, and enterprise analytics platforms. Demonstrated ability to take complete ownership and independently lead analytics initiatives — from architecture and design through to production deployment — without the need for constant supervision.
Proven expertise in Oracle Analytics Cloud (OAC), Fusion Analytics Warehouse (FAW), Fusion Data Intelligence (FDI), Oracle EPM / EPCM Cloud, OBIEE, and BI Publisher. Skilled at independently architecting semantic model extensions, data augmentation pipelines, and validation frameworks. Trusted by global stakeholders as both a hands-on technical contributor and a subject-matter expert who can lead requirements workshops and deliver solutions with minimal escalation.
الخبرة
Senior Technical Application Specialist
<ul><li>Own and provide end-to-end technical leadership for Oracle FDI, ADW, OIC, OAC, OTBI,ODI,ERP and EPM platforms, ensuring platform stability, operational support, system currency, integration health, and alignment with Finance Platform objectives.</li></ul><p></p><ul><li>Lead complex technical initiatives and strategic projects, including Alternative Hierarchy Automation, User Access Management transformation, Oracle FDI modernisation, ADW upgrades, and Frequent Data Refresh (FDR V2) implementation activities.</li></ul><p></p><ul><li>Act as the primary application SME, providing expert guidance on application architecture, data flows, integrations, security design, troubleshooting, and technical decision-making across multiple Finance reporting platforms.</li></ul><p></p><ul><li>Drive Disaster Recovery (DR) readiness and resilience improvements, including ADW DR enablement, replication validation, recovery testing, production-to-DR synchronisation, DR deployments, and business continuity planning.</li></ul><p></p><ul><li>Design and implement secure access control solutions, including management of FDI User Access Management, AD Group governance, Management Unit Security, Cost Centre Security, Legal Entity Security, and role-based access controls.</li></ul><p></p><ul><li>Translate business requirements into technical solutions, producing solution designs, impact assessments, implementation plans, technical specifications, and governance controls that support business and regulatory objectives.</li></ul><p></p><ul><li>Lead production changes, releases, upgrades, and deployments, including implementation planning, CAB support, deployment execution, rollback planning, post-deployment validation, and operational sign-off activities.</li></ul><p></p><ul><li>Drive automation and simplification initiatives, delivering automated hierarchy integrations, data validation frameworks, reconciliation controls, and process improvements that reduce manual effort and improve operational efficiency.</li></ul><p></p><ul><li>Provide technical leadership during incidents and problem resolution, performing root cause analysis, coordinating Oracle Support engagements, managing service recovery activities, and ensuring platform reliability and performance.</li></ul><p></p><ul><li>Collaborate with business, engineering, infrastructure, Oracle, ACE, reporting and finance stakeholders, while mentoring colleagues, producing technical documentation, sharing knowledge, and continuously improving platform governance, resilience, and technical capabilities.</li></ul><p></p>
Senior Engineer – L2
<p>Designed, developed, and maintained enterprise analytics solutions using OBIEE, OAS, OAC, and BI Publisher across Emerson Process Management worldwide business units.</p><p>Built and administered RPD (Repository) across Physical Layer, Business Model & Mapping (BMM) Layer, and Presentation Layer using OBIEE Administration Tool.</p><p>Developed Logical Star Schema and Snowflake data models in consultation with Data Modelers and Business Analysts.</p><p>Identified and defined Facts, Dimensions, Levels, and Hierarchies for dimensional modeling across multiple subject areas.</p><p>Created logical columns, dimensional hierarchies, calculated measures, and aggregate mappings in the BMM layer as per business requirements.</p><p>Developed and maintained ETL pipelines using Oracle Data Integrator (ODI) for data extraction, transformation, and loading into the data warehouse.</p><p>Designed and delivered interactive Dashboards and Reports with Drill-Down, Pivot Tables, Charts, Column Selectors, and Tabular views with global and local filters.</p><p>Created Action Links and Master Detail reports for cross-report navigation and guided analytics.</p><p>Developed BI Publisher reports with complex layouts and implemented writeback functionality.</p><p>Built Time Series reports for trending, comparative, and period-over-period sales and financial analysis.</p><p>Configured Analytics Agents to automate conditional delivery of reports and alerts to groups and selective recipients on daily and weekly schedules.</p><p>Performed performance tuning of dashboards and reports in collaboration with Business Analysts and DBAs.</p><p>Implemented end-to-end Data Warehouse solutions — including star schema design, fact and dimension table creation, and physical/logical data modeling.</p><p>Developed and maintained ETL workflows using ODI for multi-source data integration from Oracle ERP (Fusion & EBS) source systems.</p><p>Managed data extraction and transformation from Oracle Financials, Order Management, Manufacturing, and Inventory modules.</p><p>Created datasets and maintained data pipelines supporting Finance, Sales, Procurement, and Inventory analytics.</p>
المشاريع
Alternative Hierarchy Automation Solution (OIC, EPM, ADW & FDI)
<p>Designed and delivered an automated hierarchy management framework for Cost Centre Aggregation, Account Hierarchy, and IM Account Hierarchy data using Oracle Integration Cloud (OIC) to move hierarchy data from EPM into ADW and FDI. This replaced manual processes and improved governance across Finance reporting platforms.</p><p></p>