Muhammad Irfan Haleem

Muhammad Irfan Haleem -- BI & Data Warehouse Consultant Summary of Work Experience Certifications Business Intelligence & Data Warehouse Consultant Teradata Certified Professional Teradata Global Delivery Center Finance, Telecom and Others Certified Business Intelligence Professional Summary Certified Database Administrator A Certified Business Intelligence consultant and skilled Data Warehouse specialist, having more than 13 years of experience primarily working on BI Solutions (using Power BI, Tableau, Qlik View/Sense, SAP BO, SSRS, SSAS, DAX) and SQL Server, Teradata DWH technologies for Analytics, DI solutions (using Data Lake, Tallend, Informatica, SSIS, ETL, etc.) and other ETL tools. Hortonworks Hadoop Certified Associate Certified Scrum Master Tools and Technical Skills Power BI In different Business Domains, I also have been Designing and Developing Data Warehouse Solutions & Data Lake, Data Integration, Semantic Layer Development & Implementation, Requirement Gathering, High End Business Aggregates Development and Maintenance, Designing and Developing Reports and Dashboards. Advanced Analytics I also have been working as a Freelancer at Upwork and secured the titles SQL of Top Rated & Top 1% Freelancer. I have worked more than 12,500 hours, Teradata 94% Job Success Rate and 100% Client Recommendation. Here is the link Business Objects & Xcelsius To my Impressive Upwork Profile: Semantic Design https://www.upwork.com/o/profiles/users/_~0106e7964a99cb0a96/ Semantic Development Business Analytics Visual Analytics Tableau Azure SSIS Major Areas of Work: SSAS • Business Analysis SSRS • Business Discovery Informatica • Data Architecture DAX • Analytical Reporting Solutions SQL Server • Business Intelligence • Data Visualization • Power BI, SSRS, SSAS, DAX, Qlik View/Sense, Tableau, SAP BO • Teradata • Tallend, SSIS, ETL & Informatica • SQL Server • Teradata ETL design, development & Automation • Transforming requirements to technical solution • Business communications • Project management • Vendor Management Consulting Skills Requirement Gathering UAT Handling Customer Handling Oral Communication Written Communication Time Management Project Engagement Details Spoken Production Writing Responsibilities: • Data Lake Design & Development 1 Beginner 2 Elementary 3 Intermediate 4 Professional Proficiency 5 Full professional Proficiency 6 Master/Native Spoken Interaction 2017 Remote Position Retail Sales Australia SQL Server| Informatica | ETL | SSIS, SSRS, SSAS | Erwin | Data Lake I started working on this project from scratch, from Data Source, Data Lake Development, Data Warehouse Designing & Development, Data Mapping & Modeling and finally preparing the Semantic & Presentation Layers as well as working on new Analytics requirements that needed to be brought into Production. Reading Data Warehouse Design & Development Listening Languages English 5 5 5 5 5 Urdu 6 6 6 6 5 • Data Source & Integration • Data Warehouse Designing • Data Mapping & Data Modeling • Design and Development of New Analytics requirements BS Computer Science • Business Requirement Gap Analysis University of Punjab • ETL Implementation • Unit Testing Education Trainings Delivered Data Lake & Data Warehouse Developer 2018 Remote Position Hotels & Properties Sweden SSIS| Teradata | ETL | Informatica | Data Lake | Power BI This project was about Fetching the Data from more than a dozen different sources, populate the Staging Databases, then transform the extracted data into useful information and finally provide a platform for reporting and analytics. Responsibilities: • Requirement Gathering • Data Sourcing • Data Lake Design & Development • Data Transformation & Integration • Logical & Physical Data Modeling • Semantic Layer Development • ETL Implementation • Unit Testing Data Integration Consultant 2018 Remote Position Bank Vietnam SQL Server | ETL | SSIS, SSRS, SSAS | Data Integration | Data Lake | DWH Initially I was providing technical support to their Legacy and limited Data Mart then they finally decided to move to a proper and customized Designed Data Warehouse. I started working on this project from scratch, from Data Migration from old System, Data Integration with different Sources, Data Lake Development and Data Warehouse Designing & Development. This was a huge project and helped the company to understand the existing state of the business, helped finding customers trends, helped in preparing Marketing Strategies and forecasting. Tableau: Beginner Intermediate Scrum Master MS BI Trainings Attended Tableau: Advanced Customer Interaction Skills SAP Business Objects Responsibilities: • Data Migration • Data Source & Integration • Data Warehouse Designing • Data Lake Design & Development • Gap Analysis • ETL Implementation • Unit Testing • Project Management ETL Consultant 2019 Remote Position The Searle Ltd – Pharmaceutical Company Pakistan SQL Server | ETL | Performance Tuning | Data Integration | Data Lake This Project was an End to End Data Warehouse Design & Development, my role was to fetch the data from 21 difference Sources and populate the Staging Databases, then to transform the Staging Data, Apply Business Rules and populate the Core Layer, then Apply further data manipulation and massaging and populate the Semantic and Presentation Layers for Reporting and Analytics. Responsibilities: • Data Sourcing • ETL & Integration • Data Lake Design, Development & Materialization • Business Rules Implementation • Gap Analysis • ETL Implementation & Data Massaging • Unit Testing • Project Management