Syed Nizamuddin Zubair
Senior Data Engineer & Project Manager
Abu Dhabi
Summary
· 18+ Yrs. of experience in IT with proven experience in Informatica, Business Intelligence, Data Warehousing / Database Development, ETL, various global organizations
· Experienced Data Warehousing Business Intelligence Consultant, demonstrating in-depth expertise in Data Warehouse/Data mart, ODS, OLTP, and OLAP implementations, teamed with project scope, analysis, requirements gathering, data modeling, effort estimation, ETL design, development, system testing, implementation, and production support.
· Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement gathering, analysis, build wireframe, data mapping and development, unit testing, systems integration, and user acceptance testing.
· Strong experience in Dimensional Modeling using Star and Snowflake Schema, identifying Facts and Dimensions, Physical and logical data modeling.
· Currently associated with ADNOC Gas, Abu Dhabi as Senior Data Engineer Consultant and Analytics Project Manager, garnered domain expertise in Manufacturing, Enterprise Assets Management and Oil and Gas industry Custom solution.
· Proven acumen in steering Analytics/Data Warehousing Solutions (database issues, data modeling, data mapping, ETL Development, metadata management, data migration, dataset management and reporting/dashboard solutions/ERD)
· Hands-on experience in working on Oracle Architecture, PL/SQL, Informatica PowerCenter.
· Good Understanding of Hadoop Distributed File System (HDFS) and Hadoop Framework.
· Good Understanding of Azure SQL Database, Data Factory, Azure Synopsys Analytics and Stream Analytics.
· Good Understanding of Big Data tools like Apache Spark, Apache Hive Pig and Sqoop.
· Strong problem solving & technical skills coupled with confident decision making to enable effective solutions leading to high customer satisfaction and low operational costs.
· Responsive expert experienced in monitoring database performance, troubleshooting issues and optimizing database environment. Possesses strong analytical skills, excellent problem-solving abilities, and deep understanding of database technologies and systems. Equally confident working independently and collaboratively as needed and utilizing excellent communication skills.
Overview
16
16
years of professional experience
3
3
Certificates
5
5
years of post-secondary education
Work History
Senior Data Engineer & Project Manager
International Development Company LLC
Abu Dhabi
01.2019 - Current
- Client: ADNOC Gas, Abu Dhabi
- Finalized ETL Design Approach by doing POC, Informatica ETL Development, Enhancements and Support.
• Co-ordinate and Interface with Source Systems to arrange for appropriate logins in Development, UAT and Production Environments and finalize schedule to can pull data from source.
• Managed Optimizing ETL Jobs by using Performance Tuning and ensuring on time data delivery.
• Developed, Customized complex data models in OBIEE Repository, physical modeling, logical modeling, create facts/measures, dimensional attributes mapping, logical and presentation objects etc.
• Configured security layer using session variables as per business requirements.
• Developed new reports, dashboards for Human Resources, Finance, Procurement, PRISM and Site Operations projects.
• Installed and Configured OBIEE 12c on Linux for Dev, Test and Production servers
• Responsible for Ensuring Data Consistency, Accuracy, Reliability and Onetime Delivery as part of Data Quality.
• Responsible for Creating RPD Data Models, Reports and Dashboards.
• Responsible for Handling BI Security at Data Level, Object Level, Page Level, Dashboard Level.
• Taking care of project Management Activities like creating Change Requests, representing Change Review Meetings, Resource allocations, Tracking Progress and driving status meetings.
• Responsible for Enhancements, Support and Maintenance of Informatica Jobs.
Senior Business Intelligence Consultant
Clear Peaks Middle East LLC
Abu Dhabi
11.2015 - 06.2019
- Client: ADNOC Gas, Abu Dhabi
Sr. Business Intelligence Consultant
IDC Manpower
Abu Dhabi
08.2014 - 10.2015
- Client: ADNOC Gas, Abu Dhabi
Sr. Business Intelligence Consultant
Concept IT and Consultancy
Abu Dhabi
01.2013 - 08.2014
Client: ADNOC Gas, Abu Dhabi
Sr. Business Intelligence
DELL International Services India Pvt Ltd
Hyderabad
03.2007 - 01.2013
- Responsible Design and Implementation of ETL Architecture.
Skills
Data Warehousing
Certification
Informatica Certified Specialist
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Education
M.Tech - Data Science & Engineering
BITS Pilani
Work Integrated Learning Program (WILP) 11.2022 - Current
B.Tech - Electrical, Electronics And Communications Engineering
Guru Nanak Dev Engineering College
Bidar 09.1995 - 10.1999
Quote
There is a powerful driving force inside every human being that, once unleashed, can make any vision, dream, or desire a reality.
Tony Robbins
Timeline
M.Tech - Data Science & Engineering
BITS Pilani
11.2022 - Current
Senior Data Engineer & Project Manager
International Development Company LLC
01.2019 - Current
Microsoft Certified : Azure Fundamentals
12-2017
Informatica Certified Specialist
06-2016
Oracle Certified Specialist
05-2016
Senior Business Intelligence Consultant
Clear Peaks Middle East LLC
11.2015 - 06.2019
Sr. Business Intelligence Consultant
IDC Manpower
08.2014 - 10.2015
Sr. Business Intelligence Consultant
Concept IT and Consultancy
01.2013 - 08.2014
Sr. Business Intelligence
DELL International Services India Pvt Ltd
03.2007 - 01.2013
B.Tech - Electrical, Electronics And Communications Engineering
Guru Nanak Dev Engineering College
09.1995 - 10.1999
Technical Skills
- ETL tools : Informatica Intelligent Cloud Services,Informatica 10.4.0/9.6.0, Abinitio, Data Stage
- BI/Reporting tools : OBIEE 12c, Microsoft Power BI
- Databases : Teradata 6 VR2, Oracle 11g/12c, MS Sql server 2012
- Test Tools : Visual Studio -TFS
- Programming Tools : SQL, PLSQL, UNIX Shell Scripting, HTML, Java Script, Python and R Programming
- Scheduling Tools: Control-M
- Advanced Analytics : Dataiku
- Operating Systems: UNIX and Windows
- Functional Skills : Oil & Gas, Manufacturing, Retail
Personal Details
Date of Birth: 29-04-1978; Passport: T8254366; Languages: English, Hindi, Urdu, Arabic and Telugu
Similar Profiles
Hamza Altaf PirzadaHamza Altaf Pirzada
Mechanical Technician at International Development Company - ADNOCMechanical Technician at International Development Company - ADNOC
AJITH RAHMANAJITH RAHMAN
Accountant at ALM International Development & Enterprises LLCAccountant at ALM International Development & Enterprises LLC
Sanjida NasrinSanjida Nasrin
Administrative Training Coordinator at International Development Group, LLCAdministrative Training Coordinator at International Development Group, LLC