Ibtehaj Ul Haq

Ibtehaj Ul Haq DOB: 25 July 1992 || Nationality: Pakistani || Gender: Male || Cell: (- ||Email:-|| Address: 9 / 2, Sheet 13, Model Colony, Karachi 75100, Pakistan || LinkedIn: https://www.linkedin.com/in/ibtehajulhaq/ About me: More than 4 years of experience in the field of Business Intelligence, Data warehousing, Data Analysis Hands-on experience in implementing Star and Snow flake schema with implementation of slowly changing dimensions (SCDs) Extensive experience in front end tool Power BI. Developed complex dashboards using Power BI. Having strong technical skills along with good interpersonal skills. Develop use cases, user interface specifications, and user requirement specification documents. Good experience in MS SQL Server (SSIS, SSAS), developing T-SQL queries, stored procedures and triggers. Data Migration through tools (SSMA), Package development with SSIS and Tabular Cube for Azure with SSAS. TECHNICAL SKILLS Power BI Microsoft SQL Server (SSIS, SSAS) Azure (Fundamentals : Data Factory, Data Bricks, Hive) Visual Studio GitHub Microsoft Office Crystal Reports Java Script, HTML HiveQL (Data Bricks) PL/SQL (Oracle) Oracle 10g, 11g C#.Net Power Apps Expertise in: 1. Power BI Data Modeling 2. Advance DAX 3. Performance improvement 4. Data Warehouse 5. ETL 6. Understanding of Power Platform WORK EXPERIENCE 07/11/2019 – CURRENT – Karachi, Pakistan CONSULTANT DATA ANALYST – SYSTEMS LIMITED Business and System requirement analysis with direct client interaction. And develop initial requirement documentation. Analyzing and understanding data flow of client’s legacy systems. Based on requirements, design and develop data warehouse from multiple data sources. Build semantic layer for consumption purpose at business users’ side. Creating, designing, configuring, scheduling, deploying of SSIS packages for ETL Jobs Ensuring data quality by testing and data validation from source to data warehouse. Created complex data models and dashboards in Power BI. Developed Power BI reports and dashboards involving complex DAX expression and RLS Technology which I have used Microsoft Azure SQL Server, Power BI, Microsoft Dynamics Data pipeline written in SSIS to extract the data from their ERP system (Dynamic AX) Coordinate with business users for requirements and functional specification document Developed and maintained Analysis Service Tabular Cube on Azure. Developed complex logics in Cube as DAXs Developed complex Dashboards for Retail business. Address performance issues in Data Warehouse, Cube Model and DAX Been part of UAT and successful go live activity. Developed data warehouse and dashboards for Human Capital Management System. Created dashboards for senior management to monitor employee timesheets and project allocations. Developed Accrual dashboards for project leads. Working as independent resource on the project, developing dashboards on OPEX & CAPEX business. Interacting with client for requirement gathering, converting business requirements into dashboards. Working with IBM db2 database, developing reports on Power BI dashboards and implemented Power BI report sever for first time in DIB. Conduct UAT and approve project design Conducted UAT with business users, including Head of IT and deploy dashboards successfully for organization. Managing training of fresh graduates and trainees for data analytics department. 02/08/2019 – 01/11/2019 – Karachi, Pakistan BUSINESS INTELLIGENCE ASSOCIATE – DARAZ.PK (JADE E SERVICES PAKISTAN PVT LIMITED) Worked on AliBaba Cloud services as Business Intelligence expert. Created complex queries on HiveQL in Seller support department for E-Commerce organization. Part of implementation team of XSpace in Daraz Developed dashboards for senior management, crucial for decision making. Train junior resource on the E-commerce business and dashboard development. Developed dashboard on E-commerce, Package journey and Customer support performance 19/02/2017 – 01/08/2019 – Karachi, Pakistan ANALYST PROGRAMMER - BUSINESS INTELLIGENCE – CENTEGY TECHNOLOGIES PVT. LTD. Contribute software engineering expertise in the development of products through the software development lifecycle, from requirements definition through successful deployment. Understand business requirements and design processes according to client’s needs and market standards. Contribute in R&D team for Business Intelligence application and data warehouse development. Provide technical support to client for Business Intelligence application. Develop strategic data visualization. Lead and train the team for BI development ETL (Extract, Transform and Load) development Design and develop dashboard on Power BI Worked on Core Banking and Retail business MS Computer Science – Institute of Business Management 4 Sep 2018 – InProgress Karachi City, Sindh, Pakistan https://iobm.edu.pk BS Software Engineering – University of Karachi 4 Jan 2012 – 31 Dec 2015 Karachi City, Sindh, Pakistan https://uok.edu.pk Good understanding of Data Warehouse design, SCD and ETL development. Hands-on Experience with SQL query writing, Stored Procedures, DDL, DML and query optimization. Good working experience on finding insight, relations and valuable information from data. And hands-on experience in Data validation. 2+ years working experience with advance Power BI concepts, Data Modeling and Relations. Working with advance DAX and DAX performance optimization. Experience with managing Power BI services, publishing and maintaining reports, data gateways, providing access, and auto refreshing data. Also implemented RLS for data security and supervised Power BI embedding. Worked on several business domains like Retail, finance, call center, HCD et al. Business Intelligence Applications: Unilever Pakistan (Retail) Noor Bank (CSR performance) Emirates National Oil Company, Dubai. (CRM utilization, Sales Order) Khaadi (Zoho Desk) Internal HCD dashboards. BankCA (Dynamics 360, CRM for Banking domain) Servaid (Medical Stores / Retail) Dubai Islamic Bank, Dubai (OPEX & CAPEX) Ali Baba XSpace L’Oréal Global (Retail) Banking Applications: Bank of Khyber (Core banking application) Habib Bank Limited (Remittances application) LANGUAGE SKILLS Mother tongue(s): Urdu Other language(s): English