Freelancer profile picture goldlifetime Freelancer

Aubrey M.

BI Developer

  • Hourly rate: R450 /hr
  • Experience: 6 Years

About Aubrey

Premium Freelancer
Phone verified
Payment verified

• I Build end to end BI solutions using SSIS, from extracting data from various sources like Teradata, csv,excel, textfile, Oracle, to loading the data into SQL server •Design and develop SSIS Packages to import and export data from MS Excel, Flat files, and SQL server 2012. creating stored procedures required for SSRS report. Creation of parameterised stored procedures which are used by the various reports to get data. Deployment and uploading of the SSRS Report to the report server or sharepoint portal. •Use ETL (SSIS) to develop jobs for extracting, transforming and loading data. Design SSIS packages to transfer data from flat files to SQL server using business Intelligence Development studio. •Use SSIS Transformation tools such as Lookups, Derived columns, data conversion, Aggregate, conditional split, SQL task, Script task and send email task. •Error and event handling of Fought packages using precedence constraints. •Writing T-SQL statements for retrieval of data •Creation of user defined functions, stored procedures. •Using CTE’s, recursive CTE’s, temp tables to facilitate the creation of SSRS reports and power BI dashboards •Writing T-SQL subqueries and joins for generating stored procedures, user defined functions and views. •Create database objects-Tables, indexes, views, stored procedures according to requirements.

228 Profile Views
Report Aubrey

Testimonials

No testimonials to display.