Banner Image

Skills

  • Creative Design
  • Extract Transform and Load
  • Microsoft Access
  • Microsoft Excel
  • Microsoft SharePoint
  • Power BI
  • SQL
  • SQL Server Integration Services (SSIS)
  • SQL Server Reporting Services (SSRS)

Services

  • BI | DW | ETL | T-SQL | SSIS | SSRS | SS

    $50/hr Starting at $25 Ongoing

    Dedicated Resource

    More than 15 years’ experience in IT BI/SQL Developer specialising in all MS BI Suite components (SSIS, SSAS and SSRS) Creating Dashboards in SSRS, Power BI, Excel and Access Services deployed to Sharepoint...

    Creative DesignExtract Transform and LoadMicrosoft AccessMicrosoft ExcelMicrosoft SharePoint

About

Solely delivered a diverse number of web and client server corporate applications. Was a key team member providing a variety of components for mission critical applications.

Coates Hire Sep 2016 to Jul 2019
Position: Developer - BI
Responsibilities:
? Establish detailed program specifications to meet requirements
? Effectively manage various development work streams
? Accurately anticipate possible problems and devise solutions
? Deliver the development of items within estimated times; ensure quality and accuracy
? Analyse and diagnose system / data related issues and appropriately resolve them
? Source to Target Data Mapping
? Ensure documentation of all solutions is kept up to date
? Design and development of ETLs.
Achievements/Legacy
? Gained experience and knowledge in functioning, integration of and reporting from the major company systems: MS Dynamic CRM, Base Plan and Data Warehouse.
? Created database driven SSRS templates with standard corporate look and feel.
? Created corporate Power BI template with standard corporate features, look and feel
? Created Powershell scripts automating data extraction from IE logs, third party security database required for SSIS package.
? Created Excel template for data extracts using VBA and external UDL connectivity.
? Developed Powershell scripts for creating a folder on, uploading files to Sharepoint 365 Document Library (currently in use by sysadmin).
? Created Powershell script for generating a report of Sharepoint 365 Document Library (currently in use by sysadmin)..
? Created stored procedure and user defined function describing attributes of which resides on remote server using Link Service. (currently in use by DBA).
? Created stored procedure which dynamically transposes an object (Table or View) by swapping rows and columns around (reusable by several SSRS reports).
? Created stored procedure which splits SSRS XML into chunks and store it as temporary table records (in use when deployment audit is required).
? Created stored procedure parsing MDX by dynamic query and storing the result in a temporary table (in use by several SSRS reports).

Work Terms

Working hours: 9am - 6pm. Payments to my PayPal.

Attachments (Click to Preview)