Business Intelligence Developer / ERP Syteline Developer
Aréo-Feu Ltée
Total years of experience :23 years, 8 Months
• Developed dashboards for management and various company departments (Sales, Purchasing, Management, Finance, Marketing) using Power BI
o Data loading, data cleaning, and data
transformations in Power BI using Power Query
and SQL scripts
o Build optimized data models by applying best
practices in data modeling
o Produce metrics and KPIs using advanced DAX
formulas
o Produce reports using visuals that are easy for
users to understand
• Completed more than 140 developments in the Infor Cloud Suite Business ERP (Syteline) system to support the efficiency of business processes and meet the needs of internal customers (Purchasing, Sales, Services, Finance, Management)
o Customization of user interface screens
(creation of new fields, new grids, ...) to meet the
needs of internal customers
o Development of new stored procedures,
triggers, VB .NET scripts for the Backoffice part
of the developments
o Update existing stored procedures (EXTGEN)
to meet customer needs
o Create/Update Workflows and IDOs
o Create/Update Existing Infor Reports (SSRS,
Forms)
• Large contribution in project of setting up our new transactional website which is 100% integrated with Infor Syteline
o Implementation of the technical infrastructure
for the deployment of the website
o Migrating data from Infor Syteline to the
website
o Infor Syteline developments that were
necessary as part of the Website project
o Developed SQL script to create reports that will
be displayed on the website's customer portal
• Perform various development related to Syteline ERP (Infor Cloud Suite Business) to support the efficiency of the company's processes
• Implementation of the bank transfer payment system via Syteline ERP
• Develop, review and ensure continuous improvement of business processes through Syteline ERP.
• Design processes that meet the company's business needs, which must take into account the company's limitations (technological architecture, applications, costs, available resources) and the impacts on the processes already in place.
• Act as a resource person for all issues/questions related to ERP functionalities or business processes of the company.
• Manage various budgets, within the parameters established by management (external IT consultants, ERP support and training, etc.).
• Coordinate and continuously update the user guides (training manuals) related to Syteline ERP.
• Document the company's information systems.
• Ensure the control of program modifications and the integrity of the company's databases.
Context and Achievements:
• Successfully developed scripts and reports to identify international voice traffic fraudulent customers, and then immediately cancel them. This allow the company to daily cancel 90% of this kind of customers and then increase traffic turnover by 15%
• Dramatically increased the turnover of Morocco Telecom by setting up a new and effective billing control process
• Led Convergence Data Base Project for Morocco telecom to have compliance between Intelligent Network Data base and Billing system Data Base. Over 30 Million cellular customers concerned
• Managed the Decisional Reporting team (8 analyst programmers )
• Led Decisional Reporting project that gathered and analysed the different business users needs and requests and then created the adequate Business Objects XI universes and reports to provide them final reports and more insight
• Participated to project Data Mining for Morocco Telecom by providing all customers traffic voice and data needed
• Provided critical and decisional data to the top level manager
• Analysed and developed scripts to satisfy the top level manager complex queries that concerns Morocco Telecom customers (over 30 Millions) calling traffic (voice, data, sms, …)
• Developed complex SQL and PL/SQL scripts using voice and data traffic huge database (billions calls every month)
• Produced key performance indicators to the top level manager to help him take major and business decisions for the Company
• Performed complex ad-hoc SQL queries when immediate access to data was required.
• Extracted high value data from several databases and transformed this raw data in marketing and trading indicators
• Developed and scheduled automatic launch(with crontab) of complex SQL and PL/SQL scripts to satisfy customers requests
• Analysed the Billing System production incidents and define the appropriate solutions
• Developed the billing control tools and reports in order to anticipate billing anomalies
• Analysed the Billing System database in order to identify the data inconsistency in order to avoid income losses
• Developed scripts to identify and correct data inconsistencies between Commercial Billing system and Intelligent Network databases
Context and Achievements:
•Prepared and Validated project documents and collecting customers functional needs before project launch
•Prepared and Validated project’s planning
•Organized and Animated workshops with different stakeholders (IT, customer, integrator)
•Validated requirement and Integrator Technical documents
•Validated the solution and the global functional architecture proposed by integrator
•Developed status reports for project and ensured timely updates on project status.
•Planned, coordinated and monitored technical an software tests
•Setted up new procedures and Ensured change control
•Planned user’s trainings
Context and Achievements:
•Developed Supervision Traffic system that generates reports about traffic alerts
•Maintained and developed the Measurement Plans and supervision Templates system using C language, Unix, Java
•Developed scripts and reports around database like Network Topology, Network Display and Alarm System
•involved in development of A1340 traffic supervision system : A1340 Traffic Management is Alcatel software for collecting and processing traffic measurement data for Telecommunications network
Computer science Engineer
Preparatory classes to prepare competitive entrance to French Engineering Schools : Intensive undergraduate courses in Mathematics, Physics and Mechanical Engineering