SQL BI Developer

Back-End / Server Programming Sydney, New South Wales, Australia

Profile
Contacts

Summary

Seventeen years of IT experience in Database Development, Migration and Database Administration.
Sixteen Years of ETL and data integration experience in developing ETL routines using SSIS 2019/ 2014/ 2012/2008 R2/ 2005
Good experience in data modelling, database designing both relational and Dimensional databases.
Worked on Azure SQL DB, ADF
Created Dashboards, Data visualization reports using Power BI
Created C# solution
o Using RestSharp API to download data from IBM cloud and inserted them to SQL.
o Using TFS Web API to automate creating azure DevOps ticket.
o For SSIS Custom Components
Experience in OLAP tools like Microsoft Analysis Services (SSAS 2014, 2012) while migrating data from RDBMS to Tabular and Multidimensional data warehouse database and Reporting Services (SSRS 2016/ 2014/ 2012/ 2008 R2/ 2005)
Created dashboards, worksheets & Action reports using Tableau 2019
Seventeen years of experience writing T-SQL Queries, Stored Procedures (Complex and simple), Functions, Triggers using SQL Server Management Studio v18/ 2016/ 2014/ 2012/ 2008 R2/ 2005/ 2000, Indexes creation
Hands on experience with performance tuning the SSIS & SQL Queries
Extensive experience in Extraction, transformation and loading of data directly from different heterogeneous source systems like Flat files, Oracle, SQL Server and Excel
Good analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals.

Expectations

I got very good experience in SQL technologies as T-SQL developer, performance tuning queries, BI-STACK developer and migrating data to Azure cloud database. I am looking for a job that lets me work on these technologies again.