ERP Analyst
2018 โ PresentCulligan ยท 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.