Hi ,
I am ETL/DWH Consultant having more than 7 years of professional experience. I have solid experience of Software development and Data warehousing/Big Data Analytics mainly working in Telecom , Manufacturing and Education Industry , have developed end to end DWH applications using cutting edge industry technologies and delivered business value addition with cost effective , efficient and robust solutions.
I intend to grow in the domain of Business intelligence and Data warehousing & Big Data Analytics
Specialties:
• Data warehousing Solution Methodology
• Big Data Analytics
• ETL Development
• Business Intelligence
• Information Sourcing and Source system Analysis
• TeraData ( Version 12, 13 and 14)
• Informatica Power Centre
• Erwin Data Modeler
• PL\SQL (Oracle 9i , SQL server 2008)
• Horton Hadoop Solutions- Big Data Analytics ( Self Learning)
• J2EE Framework
Senior Datawarehouse Consultant /Solution Architect @ I joined NCBS as senior DWH consultant and am responsible for following
- DWH Solution Architeture
- DWH and ETL Design & Development
- Team management
- Over all project delivery
- Pre sales activities limited to technical proposal writing and business presentation. From October 2014 to Present (1 year 3 months) Saudi ArabiaDatawarehouse Modeller/Solution Architect @ I joined BBI as a Data Modeller/Solution Architect and I am responsible for data model management , Information Sourcing , Data mapping , Application Design and DWH Solution Architecture. From September 2013 to October 2014 (1 year 2 months) Datawarehouse Modeller/Solution Architect (on Behalf BBI) @ I was outsourced on behalf of BBI as a Data Modeller/Solution Architect and I was responsible for data model management , Information Sourcing , KPI analysis and feasibility , Data mapping , Application Design and DWH Solution Architecture, . From September 2013 to October 2014 (1 year 2 months) Data Analyst /DWH Consultant ( with Teradata Corps) @ Telenor is one of top 3 telecom companies in Pakistan having 50 million subscribers. The project aims to replace the existing IN and billing system with new Huawei based System. The objective is to update the dataware house with respect to new IN / billing system for pre-paid and postpaid transactions.
Tahir is working on this project as Data mapper and semantic layer designer involved in data mapping , source to target analysis , Transformation rules identification and key KPI design for semantic layer. From March 2013 to September 2013 (7 months) PakistanPS consultant @ Tahir has strong professional experience in software application development and data warehousing, currently working as a Professional Services Consultant with Teradata GCC since Jan 2010. He has sound knowledge of RDBMS and ETL development, and is highly proficient in writing complex analytical SQL, UDFs and Shell Scripts. He has worked on various projects in the fields of ETL, Business Intelligence, BPM, ERPs and Software/DWH Application Design & Development. His ability to quickly adopt and learn different technologies is evident from his diverse skill set. He is experienced in Custom Reporting using MS SSRS & crystal reports, SQL Query Authoring and Optimization, Data Modeling, Application & Data warehouse Development and Testing. From January 2010 to September 2013 (3 years 9 months) ETL Analyst ( With Teradata Corps) @ Unilever is the pioneer in manufacturing industry this project engagement is against their DWH program.
Tahir is working on this project as ETL Analyst + Release Coordinator. His responsibilities include Defect fixing, Impact Analysis, Performance tuning, Testing and BAU enhancement for the project using the Teradata utilities (BTEQ, SQL, TPT). He is mainly responsible to do development and release management for the code across environments and ensure code integrity with production code having No Impact on functionality and performance. From November 2011 to February 2013 (1 year 4 months) PakistanDWH Data Modeler (With Teradata Corps.) @ O2 is one of top 3 telecom companies in UK. O2 Telecom’s current DWH is in Oracle, which is being replaced with Teradata.
Tahir is working on this project as Data Modeler. His responsibilities include Data Model Management across parallel work streams being developed and Release management of Data model across DEV/TEST/UAT/PROD Environments. He is also involved in helping designers doing the data mapping and performing Ad hoc requests related to BAU work and answering general queries to help out designers for data mapping. From 2011 to 2011 (less than a year) Slough, United KingdomETL Developer (With Teradata Corps.) @ Sunrise is one of top 3 telecom companies in Switzerland. Sunrise Telecom’s current DWH is in Oracle, which is being replaced with Teradata. This project aims at migrating the Data warehouse from Oracle to Teradata, along with modifications in the data model. The ETL engine is making use of Informatica 8.6 with Pushdown Optimization.
Tahir is working on this project as Interface owner / ETL developer. His responsibilities include Data Mapping, ETL development, Bug Fixing, Unit testing and Performance Optimization of Informatica mappings. From 2010 to 2011 (1 year) IT Engineer @ Worked in CPECC as IT Enginner resposible for the T maintenance and support , Development and reporting for construction activities using SQL server and Ms BI Studio. From June 2009 to January 2010 (8 months) Software Engineer @ I worked on BPM solutions developed for Motorola for their process of cost estimation and supply chain management. It is developed using SAVVION BPM STUDIO, JSP , JavaScript & Oracle 9i. From June 2008 to June 2009 (1 year 1 month)
HDE 100 - HADOOP ESSENTIALS, Big Data Analytics / Data Science, Passed @ MapR Academy ( https://www.mapr.com/) From 2015 to 2015 Computer Engineering, Computer Science & Engineering @ University of Engineering and Technology, Lahore From 2004 to 2008 Tahir Aziz is skilled in: ETL, Data Warehousing, Teradata, Data Modeling, SQL, Oracle, Informatica, Databases, PL/SQL, Business Intelligence, Microsoft SQL Server, Data Warehouse Architecture, Software Development, Performance Tuning, Java
Websites:
http://tahir-aziz.blogspot.com/