- Support the old system DWH and SSIS ETL proccesses
- Building the new DWH in Microsoft Azure to contain all factories in the Schlemmer group
- Migrating & converting Old ETL (batch scripting and SSIS) to new DWH using Azure Data Factory
- Migrating Old Reports to Power BI
- Creating new reports in Power BI
- Use DAX formulas
- Create VBA macros in Excel for enhanced features
- Source System ERP - IFS
- Build the Azure Data Factory pipelines
- Extract data from Oracle & other sources to Azure Data Lake using ADF
- Transform and import data from Data Lake to Azure Data Warehouse.
Achievements: First time working with Azure.
Technologies: Microsoft SQL server, Oracle Server, Microsoft Azure, Azure Data Factory, Pipelines, SSIS, Cognos
IBM, Oracle Server, IFS.
Betfair). Paddy Power had it’s data warehouse in Microsoft and Betfair had it’s data warehouse in Oracle and they
wanted to merge them into a single data warehouse in AWS Redshift. I worked for them on a temporary contract.
Achievements: First time working with AWS.
Technologies: Microsoft SQL server, Oracle Server, AWS Redshift, PostgreSQL,Talend, Mediation Zone,
Companies like Lyca Mobile, Vodafone, Go or IPTV Companies. Our clients were from East Asia(Malaysia,
Cambodgia, Brunei, Filipine, India, Bangladesh, etc), Australia, Middle East, South Africa, etc.
I was in the support team. My day to day responsability was to solve tickets. We had weekly or realtime
campaigns and my job was to intervene when there was errors or something went wrong. Our databases
were from a few tens of Gigabites to a few Terabites. Our logs where tens of terabites. Some of our clients had
hundreds of milions of record and milions of subscribers. Our database tables had hundreds of tables and
hundreds of stored procedures. The whole core of our products was in MS SQL.
Also here I was tasked with the creation of a monitoring system. I created a lot of procedures that checked
everything from the disk space to the number of sms's in the queue and to the number of rewards. I scheduled
this stored procedures in jobs with sql agent. This procedures sent Email, SMS or to write in a file and then
with a batch file that was run perioadicaly with windows scheduler i moved those files to a network location.
Also while I was working for BLS O was sent to our Clients in Malaysia for a period of 3 months working
closely with our client in order to migrate their products from one set of servers to another.
I created a successful monitoring system that helped us to our job easier
Technologies: TL/SQL, Microsoft SQL Server, BI.
for all data and all reports. We communicated daily in scrum and any other meeting necessary. The sprint was two
weeks long. For any new requirements document we had a skype meeting with our client and discuss everything
and all changes.
My major achievement was to keep the communication opened with all team members which were spread all
over Europe, and also to be able to work on Eastern US timezone 14:00-22:00
Technologies: Microsoft SQL Server.
one country from different sources, we cleaned the data through sql queries and regular expressions for the
different sources in particular, after this step was done the following step was Double Search. In this step we
searched for the matched records from the different sources and try to make one complete final result with all the
details from the different sources.The company had one business directory for almost every country.
Here I had also other responsabilities, like teaching SQL to students from our university program and managing a
whole business directory with the chosen students that were elected to continue working with us.
Achievements: Becoming a co-TL and creating a really difficult script to correct wrong collected data.
Technologies: MS SQL, MYSQL, PHP, Drupal.
Competence and social abilities:
- Microsoft SQL Server 2008, Database Development (70-433) Certification
- Team spirit
- Capacity to adapt to different situations
- Good communication skills
- Eager to learn new things
- Positive attitude
- I accommodate easily to the project
- I also worked with diverse clients.
On Remote Clients: site Clients: Celcom, Robi, MC Energy, Telstra, Astro, Celcom, Maxis, Axis, CelC