概要

Vigilant to data revolution, seeking a role for providing quality solutions for data analysis and information data control functions in a renowned data analytics enterprise for professional sustainability in emerging data engineering &ETL/BI field. I am a computer technology researcher and Data Engineer (ETL/BI).

项目

Fake News Analyzer(Web base data science project)

工作经历

公司标识
Data Engineer
Analytics Private Limited
Sep 2020 - 代表 | Lahore, Pakistan

Working with ETL/BI tech stack.
✪ Migrated user events from Excell to Mysql & Quickbook/SalesForce to Snowflake.
✪ Implement the whole ETL pipeline using Talend Open Studio & Talend Cloud Integration for data integration tools.
✪ Use Talend Cloud for ETL job publish & schedule.
✪ Developed & Maintain Data Warehouse dimensions and fact tables through complex SQL queries & Complex complete ETL cycle.
✪ Build new fact and dimension tables as the business is growing day by day.
✪ Using MySQL/SnowFlake as database/Datawarehouse, worked with complex queries, view, materialized view, query updates etc.
✪ Develop complex SQL scripts to build reports on the Semantic (Business) layer.
✪ Build stunning dashboards using Tableau Desktop & Tableau Online which help marketing and growth Client to make decisions.
✪ Use Tableau Server to publishing & schedule the dashboard automatically.

公司标识
ETL/BI Developer
Kavtech Solutions (Private) Ltd
Jun 2019 - Jan 2020 | Lahore, Pakistan

A detail-Oriented ETL/BI Developer with Professional Experience and with full of technical skills.
 
Project: YLOPO (Data Integration Service) Implement RETS base source which is using Data extraction, Data Cleansing And data mapping for required fields which display on client Property Site like ‘Realtor.com’. Enhancing Data mapping and data transformation for retail real_time data
 
Project: Chemcopharmacy.com A pharmacy based in Ireland having a Data warehouse of twenty stores with separate Databases for each store. As a BI Analyst, I am using analytics to drive strategic business decisions. Wrote Optimized SQL Queries for quick analysis. Made Trigger, Views, Store Procedure and SQL Jobs for tasks automation Made Pentaho Jobs for Data Integration to push data from different sources to SQL tables within the warehouse(Dimensions, Fact Tables)
 
Making and provide support of Buisness Intelligence base reporting ,dashboards,KPI\'s on Tableau
 
Reporting on (Tableau,MS Power BI) ,Databases (PostgreSQL,Microsoft SQL Server), ETL (Pentaho), Data Monitoring(POSitive Retail))

公司标识
Business Intelligence Analyst
Genei Technology-IDM Team
Dec 2018 - May 2019 | Lahore, Pakistan

Yahoo Clicksco Affiliate Marketing BI & ETL Services
 
Data analysis and reporting using an in-house analytics tool, Loss Manager and as well as MS Excel, MS Power BI.Tableau. Dashboard Design/KPI Design/multi-layer dashboards
 
Reporting on (Excel,Tableau,MS Power BI) ,Databases (PostgreSQL,Oracle SQL developer), ETL (Pentaho), Data Monitoring(Loss-Manager(In-house tool))

学历

COMSATS University Islamabad,Sahiwal Campus
学士, 理工学士, Software Engineering‎
Database System, Data Mining, Data Warehouse, Data Analyst
CGPA 3.0/4
2018

技能

熟练 Data analysis/understading
中级 Data Warehouse
熟练 Databases
中级 ETL (Pentaho)
中级 MS Excel
熟练 Multiple dashboards
熟练 Multiple Reports
中级 Pentaho (PDI)
中级 Power BI
中级 Semantic Layer
中级 Snowflake
熟练 SQL
中级 Tableau
中级 Talend Cloud
中级 Talend Cloud Integration
中级 Talend Open Studio

语言

熟练 乌尔都语
中级 英语

关注的公司