Business Intelligence Manager

• Nov 2022 - Present

Python, Qlikview, Power Query, MS SQL, Alteryx, Selenium Python, Qlikview, Power Query, MS SQL, Alteryx, Selenium

Director

• Aug 2016 - Present

Senior Data Engineer

• Aug 2019 - Nov 2022

-Development work for data migration involving Workday Financials, including migration of various financial data such as Revenue, CashFlow, Profit and Loss (P/L), Balance Sheet, Business Assets, and Supplier data. -ETL and Database Development in Talend, SAP Business Objects Data Services (BODS) and Microsoft SQL 2008R2, 2012 and 2014. -Development of ETL (Extract, Transform, Load) processes for integration in projects utilizing Snowflake and Microsoft Azure Cloud technologies. -Development of Dashboards using Power BI.

Senior BI developer

• Nov 2018 - Jul 2019

Worked on ETL and Integration development projects using a variety of technologies including Talend, SQL Server, Azure SQL Data warehouse, and Power BI. As part of these projects, I have integrated various sources and destinations such as IBM MQ, RabbitMQ, FTP, SQL Server, Azure SQL Data warehouse, XML, flat files in CSV/xls format, and web services in REST/SOAP/JSON formats, as well as Oracle databases. My work also involves managing an Azure-hosted application database, two TAC servers, two Execution servers, and an SVN server hosted on Azure.

Qlikview Developer

• Oct 2017 - Oct 2018

I have been involved in a migration project from SAP Business Object to QlikView, where I have contributed to the development of a new KPI App and extended the MI pack, Bordereau, Claims, and Financial reports on QlikView, Qlik Sense, and Nprinting. • Development, enhancement, testing and maintenance of Qlikview, Qlik Sense applications • Analysing relational database table structures, data modelling, creating ETL load scripts • Writing VB script subroutines to perform tasks with added functionality • Developing, testing and scheduling Reports on Nprinting • Reloading, scheduling and maintaining QVW documents on QMC • Defining and implementing development standards & best practices • Troubleshooting problems users may have and providing general support internally • Training of Qlikview Developers • Development with Agile Methodologies and RAD. Technologies: Qlikview 11.20, Nprinting 16.4, QMC, MS Server 2008, SQL Management Studio, Excel, Notepad ++, SAP Business Objects, Crystal Report, Trello

Qlikview developer

• May 2017 - Oct 2017

Data Operations Manager & BI developer

• Oct 2016 - Mar 2017

Senior Business Intelligence Consultant

• Oct 2011 - Apr 2016

 Migrated data from various sources (PostgreSQL, Oracle, Microsoft SQL, Flat files, Excel) to Oracle and Teradata environment  Created Data Marts for Retention, Billing, Wifi, Fibre and marketing departments  Worked on Extract, Transform and Loading (SAP BODS 4.2, ODI, SSIS) projects  Tuned Sql statements to gain performance on scheduled ETL jobs. (30% job time reduction was gained)  Analyzed of new segmentation model for the marketing department.  Quality Assurance of Oracle Pl/sql and MS sql codes.  Migrated central repository from Ms Sql server to Oracle.  Administrated SAP BODS job server, central management server, repository server.  Developed with Agile Methodologies and RAD.

Senior Data Warehouse Developer

• Jan 2007 - Oct 2011

• Developed ETL projects using PL/SQL. • Designing Data marts, Incremental loading and analysing data. • Development, test, schedule and monitor reports using Hyperion and Excel. • Quality Assurance of Oracle PL/Sql and MS Sql codes. • Creation of data models on Ms Access for financial reports. • Development of Macro in Excel to automate daily routine tasks. • Reduced monthly Legal reporting time from 5 to 2 days by optimization of ETL processes. • Development with Agile Methodologies.

Data Warehouse Developer

• Aug 2005 - Dec 2006

 Worked on Health Insurance Data Warehouse Project  Migrated data from various sources (Oracle, Ms SQL) to Oracle environment  Created Data Marts for new policies and Claim departments  Developed campaign and policy reports (Oracle Forms, Oracle Reports)  Worked on Health Insurance Data Warehouse Project  Migrated data from various sources (Oracle, Ms SQL) to Oracle environment  Created Data Marts for new policies and Claim departments  Developed campaign and policy reports (Oracle Forms, Oracle Reports)

Senior PL/SQL Developer

• May 2002 - Aug 2005

• Worked on Bill collection system (Java, Oracle Forms).• Developed financial reports using PL/Sql. • Developed reporting portal on Intranet. Querying and exporting as csv.• Developed Integration between Reuters Fx system and bank database using (VBA, Excel, ODBC, Oracle 8i).

Senior Software Developer

• Sep 2000 - Aug 2002

Internet Branch, Core banking, Intranet applications