Freelancer profile picture

Aubrey M.

Data Engineer

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

About Aubrey

Phone 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.

244 Profile Views
Report Aubrey

Testimonials

No testimonials to display.

People Also Viewed

Photo of Christine gold Freelancer

Christine N.

Systems Analyst

Johannesburg

R 250 /hr

Photo of Bonolo gold Freelancer

Bonolo B.

Quantity Surveyor

Johannesburg

R 700 /hr

Photo of Munei gold Freelancer

Munei T.

Data Analyst

Pretoria

R 200 /hr

Photo of Nadia gold Freelancer

Nadia R.

Bookkeeper

Cape Town

R 200 /hr