Data Warehouse and Business Intelligence Specialist
FIS
Total des années d'expérience :14 years, 3 Mois
FIS (NYSE: FIS) is a global leader in financial services technology, with a focus on retail and institutional banking, payments, asset and wealth management, risk & compliance, consulting and outsourcing solutions. FIS serves more than 20, 000 clients in over 130 countries.
Member of the Information Security team, I was responsible of implementing an IT Governance and Security Compliance decision support system which helps Governance, Risk management and Compliance teams to maintain the highest level of the group’s security, my main duties were:
- Project management
- Implementing, maintaining and designing a Data warehouse to centralize security information data of the company
- Implementing, maintaining and designing SSIS packages and load data from different sources (external databases, flat files, Active Directory …)
- Implementing, maintaining and designing OLAP cubes with SSAS
- Implementing, maintaining and designing SSRS Reports
- Administrating SQL Server database
- TSQL programming
- Writing functional and technical documentations
- SQL Server tuning and performance
CODIX is the software company that has developed iMX, a unique software solution providing businesses with an event-driven system for the management of activities such as Factoring, Debt Collection and Legal, Accounts Receivables, Consumer Finance, Leasing, Credit Insurance, etc.
Member of the Data warehouse and Reporting team, my main duties were:
- Projects management
- Conducting BI training at client side
- Involved in the Data Warehouse architecture and ETL implementation
-- Creation/Modification of Oracle PL/SQL packages, procedures and function designed to feed Data Warehouse Dimension tables and Fact tables
-- Creation/Modification of Microsoft SSIS packages
-- Maintenance and correction of problems related with the daily ETL
-- Various DBA tasks
-- Analysis and tuning of Oracle SQL and PL/SQL to improve daily ETL and reports generation (explain plan, TKPROF …)
- Creation/Modification of OLAP cubes using Microsoft SSAS
- Creation/Modification and support of BI Reports
-- Creation of reports using Oracle Business Intelligence
-- Creation of reports using Microsoft SSRS
-- Creation of reports using CODIX AD Dashboard tool
-- Creation of extranet reports using PLSQL packages and XML
- Writing functional and technical specifications
- Implied in the conception and design of Codix's reporting tool - CODIX AD Dashboard
- IT support and network responsible for Codix Tunisia office