IFS Techno-Functional Consultant

Hi, I'm Rifas Raja

10+ years turning complex ERP requirements into working PL/SQL, integrations, and Business Intelligence โ€” across Supply Chain, Manufacturing, Finance, and HR.

๐Ÿ“ Dubai, United Arab Emirates

Professional Summary

Seasoned IFS Techno-Functional Consultant with over 7 years of experience, currently working at Culligan since 2018. Demonstrated expertise in PL/SQL development, data migration, reporting, integration projects, and functional consulting. Proficient in IFS ERP, Oracle, Power BI, and data tools. Strong ability to bridge the gap between business needs and technical solutions with a hands-on approach to implementation, troubleshooting, and end-user support.

What I Work With

ERP & Functional Consulting

  • IFS Technical Development (CRIM)
  • Supply Chain Management
  • Maintenance
  • Manufacturing
  • Finance & HR
  • Incident & Change Management (ServiceNow)

Integration

  • Dell Boomi
  • Salesforce CRM
  • LIMS (Labware)
  • Oracle Gateway
  • IFS Connect
  • APIs

Data & Business Intelligence

  • SQL
  • PL/SQL
  • Toad
  • Power BI
  • SSIS
  • SSAS (MDX)
  • Data Migration & Analysis
  • Data Warehousing

Tools & Platforms

  • Oracle
  • Crystal Reports
  • IFS Report Designer
  • IFS Business Analytics
  • Visual Studio

Work History & Key Projects

ERP Analyst

2018 โ€” Present

Culligan ยท Dubai

Key projects:

  • End-to-End IFS Implementation
  • IFS Version Upgrade (Apps 9 to Apps 10)
  • Implementation of IFS WADACO and IFS MWO
  • Implementation of Dell Boomi Integrations
  • Implementation of Data Warehousing and Power BI
Technical Consultant
  • Developed and modified PL/SQL packages, order reports, and quick reports.
  • Designed and maintained custom reports using IFS Report Designer, Crystal Reports, and IFS Business Analytics reports.
  • Built data migration scripts using Excel interfaces and PL/SQL within IFS.
  • Created custom objects, menus, events, tabs, and roles/permission sets to meet business requirements.
  • Monitored background jobs and batch queue configuration; debugged and resolved bugs in the IFS application.
Integrations
  • Integrated IFS ERP with Salesforce CRM using Dell Boomi.
  • Integrated IFS ERP with Labware LIMS using Oracle Gateway.
  • Integrated IFS ERP with SharePoint using IFS Connect.
Functional Consultant
  • Provided consulting across IFS modules including Supply Chain Management, Maintenance, Manufacturing, Finance, and HR.
  • Gathered business requirements, wrote functional and technical specifications, and configured applications to meet organizational needs.
  • Conducted end-user training, unit testing, and user support.
Data Analyst
  • Designed complex SQL queries to manipulate large data sets.
  • Built dashboards and on-demand reports using Power BI.
  • Developed ETL packages in SSIS and cubes in SSAS with MDX queries.
  • Implemented dimensional models (Star & Snowflake schemas).
  • Managed installations for SQL Server, Power BI gateways, and other data tools.

Senior Programmer

2014 โ€” 2018

Al Mulla Group ยท Fujairah

  • Led the design, development, and optimization of Oracle-based enterprise applications for performance, scalability, and maintainability.
  • Developed complex PL/SQL procedures, functions, packages, and triggers for business-critical processes across finance, supply chain, and manufacturing.
  • Customized and enhanced Oracle ERP modules to align with evolving business requirements.
  • Designed and implemented data migration strategies, ensuring data integrity during system upgrades.
  • Provided mentorship and technical guidance to junior developers.

Oracle Developer

2011 โ€” 2014

Roadmap IT Solution ยท Chennai

  • Developed enterprise applications using Oracle Forms and Reports.
  • Wrote complex SQL queries and used PL/SQL collections, REF cursors, and BULK COLLECT to optimize performance.
  • Designed and developed stored procedures, packages, triggers, views, and indexes.
  • Handled end-to-end project responsibilities, including UI design and backend database architecture.

Bachelor of Engineering in IT

2006 โ€” 2010

Annamalai University ยท Chidambaram

Let's Talk

Open to ERP, integration, and BI opportunities. Reach out any time.