Harish B

• Supported enterprise ERP migration and modernization initiatives involving Infor LN ERP, Oracle ERP platforms, and enterprise data integration environments.
• Worked on technical data migration activities including data extraction, transformation, validation, reconciliation, and post-load verification across ERP master and transactional datasets.
• Supported Infor LN-to-LN full database migration activities using Infor DCA, focusing on technical migration setup, data model comparison, conversion object support, and validation.
• Assisted with source and target application setup in DCA Studio and imported source and target LN data models for migration analysis.
• Performed source-to-target data model comparison to identify table-level and field-level differences between source LN and target LN environments.
• Supported analysis of table structure differences, target-only fields, and default value handling required during migration preparation.
• Assisted with conversion objects used for source-to-target value conversion and technical data transformation during LN migration.
• Participated in the Logic Pack build and compile process, preparing migration logic for downstream extraction and loading activities.
• Worked with output files generated by the Dump Engine, including physical flat files/data files used for target loading through the Load Engine and bulk loading process.
• Supported source-to-target validation and reconciliation using SQL, Excel, and Python/Pandas to compare migrated data, identify mismatches, and support correction activities.
• Participated in migration testing cycles including SIT, UAT, mock cutovers, production validation, and post-load issue resolution.
• Collaborated with migration teams, business analysts, and functional consultants to support technical migration workflows without owning functional configuration.
• Worked closely with reporting and analytics teams to support migrated ERP data availability for downstream reporting and enterprise analytics systems.

Technologies & Tools:
Infor LN ERP, Infor DCA, DCA Studio, Logic Pack, Conversion Objects, Dump Engine, Load Engine, SQL Loader, SQL, Python, Pandas, Excel, ERP Migration, Data Validation, Data Reconciliation, Oracle, ETL

• Designed and developed Oracle Integration Cloud (OIC) integrations for inbound and outbound interfaces across Oracle Fusion ERP/HCM environments.
• Built end-to-end integration workflows supporting employee lifecycle events, supplier synchronization, AP invoice processing, payroll interfaces, and financial data integrations.
• Implemented REST/SOAP and file-based integrations supporting both batch and real-time enterprise processing.
• Developed outbound integrations using BI Publisher and SOAP adapters for downstream enterprise systems.
• Implemented inbound integrations using Oracle ERP/HCM adapters, REST APIs, SOAP services, and FBDI/HDL frameworks.
• Extensively used REST APIs for real-time employee, supplier, and financial data synchronization, validations, and corrections.
• Configured OIC adapters including REST, SOAP, FTP, and File adapters for structured and unstructured enterprise data processing.
• Designed integrations using App-Driven Orchestration and Scheduled integration patterns.
• Implemented ESS job orchestration, automated scheduling, notification frameworks, and retry mechanisms improving operational reliability.
• Collaborated with Finance, HR, and Supply Chain teams to deliver scalable integration and reporting solutions aligned with enterprise business requirements.
• Technologies & Tools: Oracle Integration Cloud (OIC), Oracle Fusion ERP/HCM, FBDI, OTBI, BI Publisher, REST/SOAP APIs, OCI, SQL, Git, Jenkins

• Worked as data migration analyst in the upgrade project for transitioning Infor ERP from its legacy to on-premises.
• The primary responsibility was data extraction and transformation of data.
• The project involved migrating data from different companies to a single logistic and multi finance company.
• The complexity of this project stemmed from the need to ensure accurate migration of data for each company, preserving all essential information during the data transformation.
• Collaborated with business analysts, migration teams, and functional consultants to analyze legacy data structures and convert business requirements into technical migration workflows.
• Assisted in resolving migration defects, reconciliation mismatches, and post-load correction activities to ensure smooth production deployment.
• Participated in migration testing cycles including SIT, UAT, mock cutovers, and production validation activities.
• DCA tool is used for migration of data for both extraction and loading.

• Involved in all phases of the BI project lifecycle: requirements gathering, design, development, testing, and deployment.
• Designed logical models, hierarchies, and calculated measures in OAC to deliver interactive dashboards and self-service analytics.
• Developed advanced time-series measures (Month Ago, Year Ago, YTD, MTD) using OAC time functions for trend and performance analysis.
• Implemented row-level and object-level security in OAC using repository/session variables and initialization blocks to secure sensitive data.
• Built OAC dashboards with prompts, charts, pivot tables, and KPIs for executive and departmental reporting.
• Defined and implemented ELT architecture in ODI to integrate real-time and batch data into the data warehouse.
• Developed ODI mappings, packages, and procedures to load and transform data into a star schema warehouse.
• Created and tested PL/SQL procedures to validate, cleanse, and load staging data into target warehouse tables.
• Designed data integration workflows in ODI to pull data from diverse sources (text, XML, Excel, SQL Server) and populate Oracle 11g.
• Applied performance tuning strategies in OAC (aggregate navigation, caching, indexing) to improve dashboard response times.
• Built KPI scorecards in OAC for business performance reviews and decision-making.
• Performed reverse engineering and physical modeling of databases, creating schema objects like tables, views, indexes, and constraints to support analytics.
• Technologies and Tools: Oracle Data Integrator 11.1.1.9.0, 12C, Oracle Analytics Cloud (OAC), Oracle 11g, SQL Server 2008, PL/SQL, SQL Developer, SSIS

• Interacted with business representatives and business analysts for requirements analysis and to define business and functional specifications.
• Analyzed the Reporting Requirements and participated in the documentation of Business Requirements.
• Developed OBIEE BI Metadata repository using BI Administration tool.
• Developed interactive Dashboards and Reports in Oracle BI Answers as per the reporting specifications.
• Defined and created Initialization Blocks, Repository and Session Variables for generating filters and defining security.
• Created Hierarchies, Levels, and implemented Business Logic by creating level-based measures in OBIEE business model & mapping layer.
• Developed measure for time comparison using time functions, To Date and Ago.
• Implemented security based on LDAP Authentication.
• Configured Measures in the Business Model Layer and mapped to multiple logical table sources.
• Developed Multiuser Development Environment (MUDE) by using BI Admin Tool.
• Created several ODI Interfaces to implement Business Logic with ODI Graphical (Designer, Topology Manager, Operator, and Security Manager) & Knowledge modules (Reverse-engineering, Journalizing, Loading, Check, Integration and Service).
• Created ODI Interfaces using LKM, CKM & IKM Knowledge Modules.
• Created ODI Variables and used it into ODI interface, Procedure and Packages.
• Created Process flows using ODI Packages for loading data from source system to staging area, staging area to dimension and fact tables.
• Creating reports/prompts in Answers and dashboard/links for the reports.
• Setup Usage tracking option to monitor frequently run reports to provide caching for the reports and perform database optimization by analyzing query performance
• Environment: ODI 11g, OBIEE 11.1.1.7, SQL, PL/SQL, Oracle 11g, SQL Developer, people soft (HR Module)

• Collaborated with business analysts and data modelers to gather reporting requirements and translate them into OBIA subject areas and ODI data flows.
• Configured and customized OBIA repository layers (Physical, BMM, and Presentation) to support business needs, including facts, dimensions, hierarchies, and logical joins.
• Designed and developed ODI mappings, interfaces, and packages to extract and stage data from Oracle EBS base tables into data warehouse fact and dimension schemas.
• Implemented star schema data models for finance and operational analytics, enabling accurate aggregation, drill-down, and reporting performance.
• Built interactive dashboards and ad-hoc reports in Oracle BI Applications (OBIA) using prompts, KPIs, charts, and pivot tables to support business performance tracking.
• Configured security models in OBIA, including object-level, data-level, and role-based access controls, ensuring protection of sensitive enterprise data.
• Automated ETL data loads and reporting schedules using ODI load plans and OBIA scheduler configurations.
• Developed and validated ETL logic in ODI, including PL/SQL-based transformations, to cleanse, transform, and load data into staging and warehouse layers.
• Integrated OBIA with Hyperion Essbase for multidimensional (OLAP) analysis, enabling advanced financial and operational reporting.
• Supported testing, QA, and performance tuning of ODI ETL processes and OBIA dashboards, improving query performance and system reliability.
• Technologies and Tools: Oracle BI Applications (OBIA 11g), ODI 11g/12c, Oracle EBS, BI Publisher, SQL Server, Hyperion Essbase 9.x, PL/SQL, SQL Developer

• Partnered with business analysts to gather and translate reporting and integration requirements into ODI data flows and warehouse structures.
• Designed and developed ODI interfaces, mappings, and packages to extract, transform, and load data from multiple sources (Oracle EBS, flat files, SQL Server) into a star schema data warehouse.
• Implemented ODI load plans and scenarios for both batch and incremental loads, ensuring data consistency and reliability.
• Developed PL/SQL procedures, functions, and performance tuning strategies to optimize ETL jobs and improve data pipeline efficiency.
• Built and customized fact and dimension tables in the warehouse, supporting drill-down and time-series analytics.
• Configured error handling, logging, and restart ability in ODI to ensure robust and recoverable ETL processes.
• Coordinated with QA teams to validate data quality, reconcile ETL results, and resolve defects during UAT cycles.
• Performed repository management in ODI, including migration of objects from Development to Production environments.
• Minimal OBIEE involvement: integrated a few ODI-sourced datasets into OBIEE dashboards and BI Publisher reports for business consumption.
• Technologies and Tools: ODI 11g/12c, Oracle EBS, Oracle 11g, PL/SQL, SQL Server, OBIEE 11g (limited), BI Publisher