Isaam Khan

Data Service Developer @Specialist Motor Finance

Chester, GB

Tasked with maintaining a data warehouse along with completing projects and implementing ETL processes to assist with overall efficiency and automation.• VisualCrono VC contained many data warehouse jobs to help automate important scripts throughout the dayo I was tasked with maintaining these jobs and to ensure nothing would go wrongo If a job failed, then I would either find a solution myself or collaborate with members of other departments to solve the issue• Oracle Cloud Databaseo Worked with several databases that were stored using Oracle cloud o Involved with the designing and implementing of robust ETL pipelineso These pipelines were created using SAS, SQL and Python (Pandas)• Jira API Projecto I was assigned a project to automate ticket submissions onto the Jira boardo This required me to consult with other departments to find out their requirementso I created a solution using Python scripts and an API connection to Jira• SAS SQLo Many projects involved the use of SAS SQLo These involved learning how to use advanced Queries and Joinso SAS SQL involves the Integration of SQL into SAS so several SAS procedures and data steps were used as well