Data Warehouse & BI Architect (Oracle Expert)

Narasimhan Rajagopalan

Data Warehouse & Business Intelligence

**********@*****.***

919-***-****

linkedin.com/in/narasimhanrajagopalan

SUMMARY:

•Highly accomplished Data Warehouse and Business Intelligence Architect with over 20 years of experience designing and implementing comprehensive analytic solutions across enterprise domains.

•Proven expertise in Oracle Fusion Data Intelligence (FDI), Oracle Analytics Cloud (OAC), OBIEE, and reporting tools including Tableau and Power BI.

•Successfully led data migration projects, managed ETL and reporting delivery, and developed high-level designs for data integration and data modeling across Healthcare, Retail, Higher Education, and Financial Services sectors.

•Deep hands-on expertise in Oracle BI Applications (OBIA 7.x / 11g / 12c) covering Financial, HR, Supply Chain, Procurement, Sales, Project, and Manufacturing Analytics.

•Experienced in cloud data architectures using AWS, GCP, Azure, OCI, Snowflake, Fivetran, and dbt for modern data platform implementations.

•Implemented Collibra Data Governance across multiple engagements, covering Data Catalog, Data Dictionary, Business Lineage, and ETL Lineage (Lineage Harvester).

•Adept at optimizing data governance, ensuring robust reporting strategies, leading RFP/RFI responses, and providing high-level effort and timeline estimations for project proposals.

•Strong leadership track record managing teams of 4–40 resources across onshore and offshore delivery models, driving cross-functional collaboration and delivery excellence.

•Experienced providing operational ownership of Oracle ERP and EPM platforms including user access management, security role configuration, production issue resolution, and coordination of outsourced support resources to ensure SLA adherence and ongoing system stability across enterprise Finance environments.

•Brings direct Oracle product expertise from 12+ years as an Oracle employee, with in-depth knowledge of Oracle license structures, vendor engagement models, support escalation pathways, and product roadmap alignment — a level of vendor insight no external candidate can replicate.

•Supported Oracle Fusion Cloud quarterly patch evaluation and upgrade planning, coordinating regression testing and validating functional impacts across FDI, OAC, and ERP modules to ensure minimal production disruption and seamless continuity of Finance operations.

•Designed and maintained integrations between Oracle Fusion ERP and EPM platforms and third-party enterprise systems including CRM, procurement, and financial applications, managing data feeds, inter-module ETL workflows, and reconciliation processes to ensure data consistency and downstream reporting accuracy.

TECHNICAL SKILLS:

Category

Skills

BI & Reporting Tools

OAC, FDI, FAW, ADW, OAS, OBIEE 12c/11g/10g, Siebel Analytics 7.7 (Maui Release), Business Objects, Tableau, Power BI, Incorta, OTBI, BI Publisher

Oracle BI Applications

OBIA 12c, OBIA 11.1.1.x, OBIA 7.9.6.3, OBIA 7.9.6.4

Cloud Technologies

OCI, OAC, Fivetran, Snowflake Cloud, dbt, GCP, AWS, Azure, GitHub

ERP Systems

Oracle EBS, PeopleSoft Finance/HR/Supply Chain/CRM/ELM/CS, Oracle Fusion Cloud, JD Edwards, Ellucian Banner, Salesforce

ETL Tools

Oracle Data Integrator (ODI) 11g/12c, Informatica 9.x, Oracle Warehouse Builder (OWB) 9g/10g, Ascential DataStage 7.2/7.5/8.0, Alteryx, Talend, Pentaho

Data Governance

Collibra Data Governance, Data Catalog, Data Dictionary, Data Quality, Business Lineage, ETL Lineage (Lineage Harvester)

Data Modeling

Dimensional Modeling, Data Vault 2.0, Relational Data Warehousing, MDM (Informatica MDM, Dell Boomi), ERWin Data Modeler

Big Data

HDFS, Hadoop, Hive, Impala, Spark

Databases

Oracle, DB2, SQL Server, Teradata, SQL, PL/SQL

Programming Languages

C++, Java, Python

Project & Delivery Tools

JIRA, Azure DevOps (ADO), Collibra, RFP/RFI responses, Burn-down charts, Effort estimation

Operating Systems

Windows NT/2000/XP, IBM/AIX 5.1, UNIX

EDUCATION:

Master of Computer Applications – Bharathiar University, India (Nov 2000)

CERTIFICATIONS:

Oracle FDI Certified Expert – Oracle (2024)

Managing IT Projects Certified – George Washington School of Business (2013)

OUM Level 3 Certified – OUM Training and Accreditation Program

Oracle Bravo Award – Q1 FY13, GSD NA-TAG Team

ACE Award for Outstanding Contribution – 2005

EPM ND Best Team Award – EPM Product Development (2004)

PROFESSIONAL EXPERIENCE:

Software Developer

Client: ODOT – State of Oklahoma Agency Apr 2025 – Present

Project Description: Implemented Fusion Data Intelligence (FDI) solutions across Oracle Fusion SCM, HCM, and ERP modules, covering Inventory, Procurement, Supply Chain Planning, Workforce, Benefits, Finance, GL, AP, and AR analytics for enterprise clients.

Responsibilities:

•Implemented Oracle Fusion SCM Analytics for Inventory, Procurement, Supply Chain Planning, Shipping/Logistics, and Quality modules.

•Implemented Oracle Fusion HCM Analytics for Workforce, Benefits, and Compensation modules.

•Implemented Oracle Fusion ERP Analytics for Finance, General Ledger (GL), Accounts Payable (AP), and Accounts Receivable (AR) modules.

•Leveraged FDI and Oracle Analytics Cloud (OAC) as primary reporting and analytics platforms.

•Supported Oracle Fusion Cloud quarterly patch reviews and release validations across FDI, OAC, ERP, and EPM modules, ensuring production environment stability and continuity of Finance analytics operations.

•Managed user access, security role configurations, and system health monitoring across Oracle Fusion ERP and EPM environments, providing day-to-day operational support aligned with enterprise SLA requirements.

Environment: Oracle FDI, FAW, ADW, ODI, OAC, OBIEE, Snowflake, Oracle Fusion Cloud, OTBI, GCP, Oracle ERP/HCM/SCM Analytics, ADO, JIRA

Solution Architect

Client: Windriver Aug 2024 – Feb 2025

Project Description: Responsible for the design, implementation, and architecture of very large-scale data intelligence solutions around Oracle BI Applications, leveraging Oracle EBS R12.2.x and Oracle Fusion Cloud as source systems.

Responsibilities:

•Designed and implemented Oracle Analytics Cloud solutions utilizing Oracle EBS R12.2.x and Oracle Fusion Cloud as source systems, directing a team of 4 resources.

•Worked on SQL queries in dimensional and relational data warehouses; performed data analysis and data profiling using complex SQL across various systems.

•Troubleshot and resolved data processing issues; proactively engaged in data modeling discussions.

•Developed Oracle Fusion SCM Analytics covering Inventory, Procurement, Supply Chain Planning, Shipping/Logistics, and Quality.

•Integrated Oracle Fusion HCM Analytics for Workforce, Benefits, and Compensation.

•Built Oracle Fusion ERP Analytics for Finance, GL, AP, and AR.

•Designed ETL processes from various sources into Oracle Data Warehouse for analysis and further processing.

•Built customized interactive reports, worksheets, and dashboards in OAC.

•Coordinated integration data flows between Oracle Fusion ERP modules and downstream reporting systems, troubleshooting data feed and reconciliation issues to ensure accuracy and consistency across Finance and SCM analytics platforms.

Environment: Oracle EBS R12, ODI 11g/12c, OBIA 11g/12c, OAC, OBIEE 12c, Incorta, Snowflake, Oracle Financial/SCM/HR Analytics

Associate General Manager – Data Practice Head

Client: Expleo Group Apr 2023 – Mar 2024

Project Description: Led the data strategy practice, managing RFP/RFI responses, high-level design documents, and data governance implementations while overseeing reporting validation and cross-team delivery across Tableau, Power BI, and Collibra platforms.

Responsibilities:

•Managed and directed data strategy initiatives as Data Practice Head.

•Authored responses to RFPs/RFIs and developed robust solutions for new business opportunities.

•Generated high-level effort and timeline estimates for project proposals; collaborated with the Sales Team to finalize commercial agreements.

•Mitigated potential risks by proactively identifying issues and implementing corrective strategies based on burn-down charts.

•Developed high-level design documents and guided the creation of data mapping documents through ETL processes.

•Validated Tableau and Power BI reports by implementing comprehensive testing strategies using commercial tools.

•Implemented Collibra Data Governance encompassing Data Catalog, Data Dictionary, Business Lineage, and Lineage Harvester for ETL.

•Acted as trusted technical advisor to Finance and business stakeholders, translating complex Oracle platform requirements into actionable roadmap items and delivery plans aligned with enterprise technology standards.

Environment: ODI, Informatica, Snowflake, OBIEE, AWS, GCP, Azure, Data Vault 2.0, Tableau, Power BI, Collibra, JIRA

Enterprise Data Architect

Client: Inchcape Shipping Services Aug 2022 – Mar 2023

Project Description: Architected high-level data integration designs across heterogeneous source systems, delivering dimensional models, MDM implementation, and cloud data ingestion using AWS and Alteryx ETL for a global shipping services firm.

Responsibilities:

•Designed a dimensional model to integrate data from Dell Boomi and other applications via Master Data Management (MDM).

•Architected high-level designs for data integration across heterogeneous source systems.

•Extracted and ingested data into AWS ODS layer utilizing Alteryx ETL; executed data transformations for dimension and fact tables.

•Validated Tableau and Power BI reports through rigorous testing strategies.

•Integrated Single Sign-On (SSO) on Azure B2B/B2C tenants to manage access for internal and external users.

•Oversaw the implementation of MDM across all applicable subject areas.

•Implemented Collibra Data Governance encompassing Data Catalog, Data Dictionary, Business Lineage, and Lineage Harvester for ETL.

Environment: Alteryx, Informatica MDM, Snowflake, Data Vault 2.0, AWS, GCP, Azure, Tableau, Power BI, Collibra, JIRA

Business Layer Data Architect

Client: Logitech Nov 2019 – May 2022

Project Description: Led the Logitech Engineering and Designs Customer Sales Project, managing a team of 24 resources and 2 Data Scientists. Delivered Oracle EBS Finance, Supply Chain, and Salesforce integrations into a cloud data architecture using AWS, Snowflake, and Denodo.

Responsibilities:

•Led the Logitech Engineering and Designs Customer Sales Project, managing a team of 24 resources and 2 Data Scientists.

•Managed the implementation of Oracle EBS Finance, Supply Chain and Order Management, and Procurement and Spend source systems.

•Integrated Salesforce source systems into the data architecture.

•Leveraged cloud resources including AWS and Snowflake; implemented the Denodo Data Virtualization Platform.

•Utilized reporting tools including OBIEE 11g, Hyperion, Tableau, and Power BI.

•Deployed Collibra Data Governance Tool for Data Catalog, Data Dictionary, Business Lineage, and Lineage Harvester for ETL.

Environment: Pentaho DI, ODI, Informatica MDM, Oracle EBS, AWS, Azure, GCP, Snowflake, Fivetran, Tableau, Power BI, OBIEE, Hyperion, Denodo, Collibra, Python, JIRA

Senior Principal Analyst

Client: Oracle Oct 2015 – Nov 2019

Project Description: Implemented Oracle BI Applications across Finance, Supply Chain, HR, and Procurement & Spend Analytics for Healthcare and Retail domains. Delivered Oracle Analytics Cloud and Fusion Analytics Warehouse implementations, and led a major ETL migration from OWB 9g to ODI 12c.

Responsibilities:

•Implemented Oracle BI Applications on Finance, Supply Chain, HR, and Procurement & Spend Analytics for Healthcare and Retail domains.

•Deployed Oracle Analytics Cloud solutions leveraging Oracle EBS R12.2.x and Oracle Fusion Cloud as source systems, leading teams of 4–5 resources.

•Developed Oracle Financial Analytics (OFA), Oracle Procurement and Spend Analytics (OPSA), Oracle Supply Chain and Order Management Analytics (OSCOM), Oracle HR Analytics, and Oracle Project Analytics (PA).

•Successfully executed a Data Migration Project from OWB 9g ETLs to ODI 12c ETLs, achieving a 65% project margin with 9 resources.

•Completed the OWB upgrade from 9g to 10g using the OWB Upgrade Utility; manually refactored 40% of ETL processes.

•Utilized the Migration Run Utility to convert OWB 10g ETLs to ODI 12c ETLs; manually refactored 60% of ETL processes.

•Delivered Oracle Fusion Analytics Warehouse (FAW) and OTBI implementations.

Environment: ODI 11g/12c, OBIA 11g, OBIEE 12c, OAC, Oracle EBS R12, OCI, Oracle Fusion Cloud, OWB 9g/10g, OTBI

Manager

Client: KPI Partners Aug 2014 – Mar 2015

Project Description: Implemented Oracle BI Applications 7.9.6.x on Finance, Supply Chain, HR, and Procurement & Spend Analytics for Healthcare and Retail domains, utilizing Oracle EBS R12.1.x as the source system and managing a team of 6 resources.

Responsibilities:

•Implemented Oracle BI Applications 7.9.6.x covering Manufacturing Analytics, Financial Analytics, Procurement and Spend Analytics, Supply Chain and Order Management Analytics, and Loyalty Analytics.

•Managed a team of 6 resources across the full implementation lifecycle with Oracle EBS R12.1.x as the source system.

Environment: ODI 11g, OBIA 11g, Informatica, DAC, OBIA 7.9.6.x, OBIEE 11g, OAC, Oracle EBS R12

Principal Consultant

Client: Oracle Jun 2010 – Jan 2014

Project Description: Implemented Oracle BI Applications across Finance, Supply Chain, HR, and Procurement & Spend Analytics for US Higher Education, Healthcare, and Retail domains. Led PeopleSoft EPM Data Mart implementations at multiple US universities and managed the Centre of Excellence (COE) for Oracle BI Analytics.

Responsibilities:

•Led the implementation of three Data Marts at US Higher Education Universities utilizing PeopleSoft EPM 9.0.

•Implemented Oracle Financial Analytics, Procurement and Spend Analytics, Supply Chain and Order Management Analytics, and HR Analytics using Oracle EBS R12 and JD Edwards as source systems.

•Delivered Oracle Student Information Analytics with Ellucian Banner 8.0 as the source system, leading a team of 12 resources across Student Admissions, Financial Aids, and Student Records.

•Developed 3 Data Marts using PeopleSoft EPM 9.0 (Financials Warehouse, HCM Warehouse, Campus Solutions Warehouse) with a team of 4 resources.

•Managed the Centre of Excellence (COE) team, conducting BI Analytics sessions on Oracle BI Applications 7.9.6.x and 11g.

•Actively involved in customization of ETLs and reports for OBIA 11g using ODI 11g/12c and OBIEE 11g/12c/OAC, and for OBIA 7.9.6.x using Informatica and DAC.

•Participated in PeopleSoft Campus Solutions implementations for US higher education clients including Arizona State University.

Environment: ODI 11g, OBIA 11g, OBIEE 10g/11g, Oracle EBS R12, Informatica, DAC, Ellucian Banner 8.0, OATS, Ascential DataStage

Lead Consultant

Client: Computer Sciences Corporation (CSC) Jul 2009 – Jun 2010

Project Description: Managed PeopleSoft EPM ETL Warehouse implementations for a US Healthcare account, delivering four Data Marts across Financials and Supply Chain Management with a team of 4 resources.

Responsibilities:

•Implemented Financials – General Ledger and Profitability Mart.

•Implemented Financials – Accounts Payable Mart.

•Implemented Supply Chain Management – Inventory Mart.

•Implemented Supply Chain Management – Procurement Mart.

Environment: PeopleSoft EPM 9.0, Ascential DataStage, OBIEE

Associate Technical Architect

Client: Target Jul 2008 – Jun 2009

Project Description: Provided high-level design for ETL development at the Technical Architect level for Target Retail's BI program, leading the Expense Management Initiative and directing ETL and reporting delivery across cross-functional teams.

Responsibilities:

•Managed the BI Program for the Retail Warehouse, providing high-level design for ETL development at the Technical Architect level.

•Led the Expense Management Initiative program within Target Retail as the primary technical architect for business solutions.

•Contributed to RFPs/RFIs, formulating solutions for new business opportunities; provided high-level effort and timeline estimations.

•Directed delivery of ETL and reporting solutions across cross-functional teams.

•Mitigated risks by identifying potential issues and implementing corrective strategies through burn-down chart analysis.

•Authored high-level design documents and guided creation of data mapping documents through ETL processes.

Environment: IBM DataStage, Microstrategy, ERWin Data Modeler

Senior Applications Engineer

Client: Oracle Apr 2004 – Feb 2008

Project Description: Developed and implemented Fusion Analytics Warehouse solutions using Siebel Answers Maui Release, delivering multiple Financial, Supply Chain, and Campus Solutions Data Marts. Led PeopleSoft EPM 8.9 integration projects across CRM, FSCM, and HCM modules, managing a team of 40 resources.

Responsibilities:

•Developed Financial Data Marts: General Ledger and Profitability, Accounts Payable, and Accounts Receivable.

•Built Supply Chain Management Data Marts: Inventory and Procurement.

•Developed 3 PeopleSoft EPM 9.0 Data Marts (Financials Warehouse, HCM Warehouse, Campus Solutions Warehouse) with a team of 4 resources.

•Delivered Campus Solutions Warehouse Data Marts: Student Admissions and Recruitment, Students Financial Aids, Student Records, and Campus Community — managing a team of 12 resources.

•Executed integration update projects for CRM, FSCM, and HCM modules to EPM 8.9 across multiple versions (8.4, 8.8, 8.9), involving 8 resources.

•Contributed to the Oracle/PeopleSoft EPM 8.9 initiative developing CRM, ESA, FMS, HCM, SCM, ELM, and JD Edwards Warehouses, managing a team of 40 resources.

Environment: Ascential DataStage, OWB, Informatica, Oracle EBS 11.5, Siebel Analytics Maui Release 7.7, Cognos, Business Objects, PeopleSoft EPM/CRM/HCM/FSCM/ELM, JD Edwards

Contact this candidate