Data Engineer

Overview

Looking for part-time work (4 hours/day)

at $16.00/hour ($1,408.00/month)

Bachelors degree

Last Active

December 24th, 2024 (today)

Member Since

September 23rd, 2019

Profile Description

Alteryx
Underwent bootcamp
and obtained Alteryx Partner and Alteryx Partner Server
Certifications
C#/.Net
Troubleshoot
issues in SSIS packages using Script Task
Developed and
introduced improvements to existing code
Power
BI
Support and
Development of Power BI (.pbix) reports and Power BI Service
reports
Deployment of
reports to Power BI service
Creation and
Maintenance of Workspaces and Report Datasets
Basic DAX
commands
Azure Pipelines
Build dacpac and ispac packages and Deploy database objects and
SSIS packages using Azure pipelines
SQL
Extensive
knowledge and hands-on experience of SQL for querying data from SQL
Server, MySQL, Oracle, DB2 and Netezza Database systems
In SSMS,
developed bug fixes to existing SQL scripts, traced SQL scripts
when investigating issues in existing reports and created reports
using SQL
SQL
Server Management Studio (SSMS)
Running and
investigating queries, Stored procedures, and SQL scripts on
different BI servers
Backup and
restore Databases
Browsing cubes
on Analysis Services
Running and
monitoring jobs on SQL Server Agent
SQL
Server Reporting Services (SSRS)
Deployment and
Development of Reports using SQL and/or MDX scripting
SQL Server
Reporting Services (SSIS)
Troubleshooting
and Deployment of SSIS packages
SQL Server
Reporting Services (SSAS)
Browsing and Troubleshooting of cubes and
tabular models
Minor bug fixing of cube logic and structure
Development work of Tabular model
MDX
Basic
Knowledge and hands-on experience in developing a report using MDX
query
GitPull and push code, cherry pick, troubleshoot code conflicts and
push errors
PowershellDeveloped small scripts to fetch data and configure SSRS
subscription settings via API
Azure DevOpsUsed pipelines to build and deploy .dacpac and .ispac code changes
to higher environments.
Visual
Studio
Basic
knowledge and navigation of SSAS packages for analysis and
investigations
Building and
Deployment of reports and BI objects from Team Foundation Server
Datastage
Knowledgeable
and has hands-on experience in creating Datastage jobs based on
Client’s design document, as well as testing Datastage jobs, and
deployment of jobs to different servers (Dev, Staging and Production
servers)
Has experience
in optimizing Datastage jobs
Troubleshooting
existing Datastage jobs and resolving Datastage job issues within
Service Level Agreement (SLA) time of resolution
Designer
Client, Director Client and Administrator Client
Unix
Scripting
Developed Unix
Scripts for FTP of files, Archiving, and for running Datastage Jobs
using wrapper script.
Python
Acquired basic
knowledge and created simple .py scripts thru online trainings
Developed
Python script to implement SSRS automation project
Pivot
Table in Excel
Creation of
basic reports with or without the use of MDX query
QlikView
Basic
navigation and generation of tables via the Custom Tab
API, DataLake, Azure SQL Server
Hands on experience using as a Power BI datasource