Daniel De Sousa Email & Phone Number

Toronto, Canada Area

Toronto, Canada Area

- Participated in the delivery of a Datawarehouse solution in Azure SQL Datawarehouse. Responsible for the delivery of the ETL solution using Azure Data Factory(v2) including acquisition of data from FTP Server and Blob Storage from different data sources using Polybase. Automation of solution and scaling was done through Powershell. Final Solution used Azure KeyVault technology to for security compliance. Created a PowerBi report for reporting and analysis of metadata of data loads.- Currently working on a ELT solution using Azure Data Factory(v2)(including Hosted IR), On Premises SQL Server and Azure SQL db, Azure Data Lake Storage(v2) to retrieve data from multiple sources and store them in the data lake and apply transformations for the required data to supply as source for Master Data Management solution. The smart of the solution is that it is metadata driven requiring minimal changes if any new data source is to be added.

Brisbane, Australia

Delivered ETL solution to populate Microsoft Azure Datawarehouse solution using BIML and SSIS via Polybase and DataVault technology. Solution developed in Visual Studio 2017 with CICD in Visual Studio Online including the automation of Unit Tests using LegiTest. Development of PowerBI reports and dashboards to analyse data loads and generate insights to the business based on the load of the data (inconsistent data between different systems) as well as the data loaded(insights to better the business' revenue).

Brisbane, Australia

Responsible for developing various ETL solutions containing multiple packages to move data from LOB applications (both databases, Rest APIs and file extracts), apply any transformations required and load into data warehouse both On Premises and in the cloud (Microsoft Azure and AWS) using Microsoft SQL Server 2012/2014/2016, Azure SQL db and AWS SQL RDS. Responsible for dashboards and reporting in SSRS(accessing LOB and replicas) and Cognos(accessing datawarehouse). Development of datawarehouseResponsible for the implementation of a security compliance solution using SQL Server Always Encrypted feature including an ETL process to retrieve plain text data from a Blob Storage in Azure, apply data encryption integrated with Azure KeyVault (used to store securely the certificates) and then load securely the encrypted data to be processed to the Data Warehouse which is located in Australia (Azure VM). This project was essential as the company would be liable for any data breach that would be detected. between regions (Europe, Asia and Australia). This project was delivered successfully and on time.I was successfully involved in a project where I had to design, develop and deploy Reporting solutions (Paginated Reports, Mobile Reports and Dashboards) using SSRS 2016, including the management of data driven subscriptions to replace the current reporting solution, which was designed using Cognos and had to be decommissioned for Australia . Responsible for the delivery of an internal BI solution from Planning and Defining requirements, Designing and Building, and making sure Testing and Deployment was performed in an automated way(using powershell).Technologies: Office365, Microsoft Flow, Azure SQL db, AWS SQL RDS, Azure SQL DW, AWS Redshift, Azure VM, AWS EC2, Azure Blob Storage, AWS S3, SSIS, Always Encrypted, SSAS, SSRS, PowerBI, JSON, Cognos, Powershell.

Melbourne, Australia

Melbourne, Australia

Technical Lead responsible for the planning, design, development, deployment and automation of Business Intelligence solutions(Architecture, Data Warehouse, Reporting and Analytics) using Microsoft technologies to measure, display and provide the relevant information to enable businesses to improve their operation, quality and revenue. As a consultant, responsible for the delivery of client projects, making sure they achieved the agreed benefits satisfying client needs in a timely manner, effective cost and applying technical standards. Responsible for database deployment/migration from On premises MS SQL to Azure SQL database.Troubleshooting client’s enquiries providing technical solutions focusing on the improvement/resolution of data quality issues and processes. Provided expert guidance and training to BI Developers on new technologies and solutions as well as being responsible for the documentation of all solutions.I was fully involved in a project to create near real time dashboards receiving data from JADE (OO database) via HL7 messaging and using MS Service Broker on SQL 2012 to process these messages updating the datawarehouse. There are currently 20 dashboards developed using SSRS that run for 5 different locations.

Melbourne, Australia

• Design and development of MS SQL Server database objects and procedural code including writing Stored Procedures, Functions, Triggers;• Develop reports using SQL Server Reporting Services (SSRS);• Establish and execute processes to maximize data integrity:• Create Extract, Transform and Load (ETL) processes;• Optimize and tune MS SQL databases and queries and perform database normalization;• Work with application developers to provide data services for existing and new applications;• Maintain developed source code in the repository for all databases;• Assess and maintain data integrity from various sources;• Database Analysis;• Support and troubleshoot application issues and document solutions;• Migration of DTS packages (MSSQL 2000) to SSIS (MSSQL 2008R2/2012).• Development of reports (Operational, Management and Decision Making reports) using SQL Server Reporting Services• Software development and maintenance using .NET(ASP, VB and C#)• SQL Server (2008R2/2012) Database installation, configuration and maintenance;• Administration tasks such as backups, availability monitoring, disk space management, performance management and data archiving;• MS SQL Server Performance Tuning• Qlikview Development• Qlikview Administration

Epping

Comprehensive SQL Server database management on servers, perform and/or approve database development, improvement of existing database design, develop and maintain data extracts and reports development on existing data using Crystal Reports and Reporting Services. Data migration using integration packages (SSIS) and DTS including migration of DTS packages to SSIS.Reports development (Operational, Management and Business Intelligence-Decision Making reports) using Crystal Reports as well as SQL Server Reporting and Analysis Services gathering data from SQL Server, Oracle, text files, excel spreadsheets.Responsible for the development, testing, implementation and maintenance of iPM(Patient Manager) reports based on Oracle.Development, improvement and maintenance of Oracle stored procedures, packages and functions.Software development and maintenance using ASP.NET, VB.NET and C#.NETSQL Server Database installation, configuration, setup and administration of MS SQL Server 2000/2005/2008;Administratitive tasks such as backups, availability monitoring, disk space management, performance management and data archiving;Design & implementation of database schemas, including stored procedures, SQL Server jobs, ad hoc scripting, data migration;MS SQL Server Performance Tuning* SQL Server 2000, 2005, 2008R2* Oracle 9g and 10g* Crystal Reports 7.5, 8.5, 9, 10, XI, 2008 and XII* ASP.NET, VB.NET and C#.NET

I was involved in a team of 4 developers that were responsible for maintaining and improving the company's major application(developed in Visual Basic .NET). The development was based on a Windows Application, including compact development for Windows CE.I was responsible for any report development using LogiXML(which was an open source solution reducing costs for the clients) from operational reports(such as receipts, basic data, etc) to business-driven reports(like weekly tendencies, provisionings, etc.). In total, I could say that there are between 50 and 60 reports developed for the whole system.Having worked as Database Administrator in previous roles, I started analysing data issues as well as performing SQL Server database installations, configuration, maintenance including updates and service packs. I could also help improving performance by creating indexes, analysing stored procedures, etc.* SQL Server 2005 and 2008R2* Visual Basic .NET* LogiXML

Brunswick, Victoria

Providing 2nd/3rd level supportInstall of equipment(server, desktops, printers, switches, routers, etc) purchase by company's clientsMaintain job logs by updating the jobs details in ticket management systemPerform proactive management of desktop and servers by applying updates and patches frequently using WSUSTroubleshoot various operating system (Windows 2000, XP Pro) related issuesTroubleshoot Microsoft and third party applicationsCreate, manage and troubleshoot VPN connectionsRemote assistance(using VNC, Remote Desktop, GoToMeeting, TeamViewer, etc)

Reports migration from PI HP Openview to Crystal Reports 2008 retrieving data from SQL Server 2005 and 2008

Data migration, update and checking from Mainframe to SQL Server/Access databases; Daily reporting to Divisional and Executive Director as well as the CEO of Western Health; Ensuring accuracy and balance of all reports sent to the Department of Human Services (DHS); Development of Ad Hoc requests on a day to day basis for various Directors / Managers / or other Requestors; Analysis, Development, Maintenance and Support of Internal Systems using MS Access according to user requirements and evaluation;

Sao Paulo

Administer database servers, perform and/or approve all database development, clean up existing database design, develop and maintain data extracts using SSIS and create reports on existing data using both SSRS and Crystal Reports;SQL Server Database installation, configuration, setup and administration;Performed all administration tasks including backups, availability monitoring, disk space management, performance management, data archiving;Migration of payroll and financial databases from SQL Server 2000 to 2005 with multiple data refreshes in the SQL 2005 environment;Design & implementation of database schema, including stored procedures, SQL Server jobs, ad hoc scripting, data migration;Perform substantial data cleanup, restructuring and reporting;Implementation of reporting platform using Analysis Services and Reporting Services 2005;Development, Maintenance and support to both managerial and operational reports using Crystal Reports and Reporting Services 2005; Windows Server 2003 Installation, configuration, setup and management;Hardware and software installation, configuration, support and troubleshooting;Design, develop and maintain systems according to specification and updates required by users.Complete migration of Payroll System from AS400/DB2 to Java/SQL Server 2000/2005; Implementation and upgrade of new versions of the Payroll System of the company; Development, Maintenance and support of several administrative systems using MS Access/VBA and further upgrade to Visual Basic/SQL according to specifications gathered with users;Development, Maintenance and Support of Internal Systems using Genexus; Development of lectures for Microsoft Products such as MS Word, MS Excel, MS Powerpoint and MS Project;

Responsible for the Plannning, Development, Implementation and Maintenance of Technology Information Department; Development and Support of Technical Proposal Control System; Help Desk/support for Consultants; Design, Development and Implementation of Local Network(Windows 2000); Development of lecture about MS Project 98; Consultancy in the following projects: Aliança do Brasil(Brazil Alliance): Project Management Officer; Ferronorte: Responsible for the implementation of SIG (MIS - Managerial Information System).

Advanced Diploma In Information Technology, Networking And Programming

Specialization In Strategic Management Of Information Technology Using Sap/R3, It Management, Post Graduate Diploma

Computer Engineering, Computer Engineering

Activities and Societies: Regional Engineering Council

Bachelor'S Degree, Computer Engineering

Data Processing - Technology, Information Technology