Nadir Khazi Mohammed
Bangalore
Summary
Data engineering professional poised to add significant value through comprehensive experience in developing scalable data solutions. Noted for strong team collaboration and adaptability in fast-paced environments. Reliable in driving results with key skills in data modeling, ETL processes, and cloud-based data platforms.
Overview
9
9
years of professional experience
1
1
Certification
Work History
Sr Data Engineer Specialist
accenture Pvt ltd
05.2021 - Current
- Company Overview: Client: Canada TD Bank, Industry: Bank, Environment: Databricks ADB, SQL, Data Factory, Synapse & Bitbucket
- Creating and managing data shares in Unity Catalog
- Managing data lineage and catalog metadata
- Optimize data pipeline to handle shared data efficiently
- Building ETL Framework to migrate all objects to Databricks under Unity catalog
- Leveraging Role Based Access Control (RBAC) to manage data sharing securely
- Created PySpark/SQL jobs for data transformation and aggregation in Azure Databricks
- Converted large hive SQL to Spark Actions by creating RDD, Dataframe and orchestrating the jobs through ADF
- Created multiple python Configuration files to dynamically run the ETL-framework
- Implemented CI/CD pipeline for code Deployment for higher environments
- Used Python for SQL/CRUD operations in Synapse DB, file extraction & transformations
- Responsible to close all defects identified by QA team and deploy the code
- Review components developed for framework & migration of different (POD)
- Design data processing pipelines through ADF and unit testing all jobs in required environments
- Client: Canada TD Bank, Industry: Bank, Environment: Databricks ADB, SQL, Data Factory, Synapse & Bitbucket
Senior BI Consultant
KPI Partners India Pvt.Ltd
05.2017 - 05.2021
- Company Overview: Client: Air Liquide, Industry: Industrial Gas, Environment: Azure Data Factory, Microsoft Azure Analysis Services-Tabular Model, Power BI, Azure DevOps, Azure Synapse, AWS Athena, Oracle Analytics
- Building Complex tabular model in SSAS/Report Validation/Unit Testing
- Creating multiple DAX functions for the required reports
- Extensive experience in Azure DevOps for Project Management and Azure GitHub for code collaboration & version Control
- Implement row level security on data and understand application security layer models in Power BI
- Developed Data pipelines using PySpark and ADF Dataflow
- Orchestrated the ETL data Load jobs/Scripts with defined dependencies to run automatically
- Develop, Publish and Schedule power Bi reports as per the business requirements
- Client: Air Liquide, Industry: Industrial Gas, Environment: Azure Data Factory, Microsoft Azure Analysis Services-Tabular Model, Power BI, Azure DevOps, Azure Synapse, AWS Athena, Oracle Analytics
Senior BI Consultant
KPI Partners India Pvt.Ltd
05.2017 - 05.2021
- Company Overview: Client: Advantest America Inc., Industry: Manufactures semiconductor and component test, Environment: Azure Data Lake Gen2, Azure Synapse Analytics, Azure Data Factory, Power BI and Oracle SOA
- Understand Enterprise data analytics needs, business value drivers and priority
- Analyze the current platform and opportunities to leverage current investment
- Recommend data analytics and reporting strategy based on business value drivers
- Migrated on premise SQL Server to BLOB Storage using Azure Data Factory v2
- Created dynamic pipelines in ADF v2 for delta Load and transformed data using USQL language
- Create ETL\ELT pipeline in cloud using ADF v2.0 and BLOB Storage for data collector
- Migrate existing packages from on premise to cloud
- Build Multiple Power BI Matrix reports on the Business requirements
- Worked on Row Level/Report Level Security in Power BI
- Experience on shared access signature (SAS) to allow permission to read/write/delete the objects from IP address
- Created Curl command (PUT) for writing files/JSON into ADLS container
- Understand the Performance of DWU (Data warehousing Units) and cost of the usage at different levels
- Worked on Copy Activity/Data flow/Get Metadata/Lookup/Set Variable and different iteration and Condition in Azure pipeline
- Worked on Tumbling Window/Scheduled trigger
- Loaded different types of formats like JSON/ Parquet and .txt
- Client: Advantest America Inc., Industry: Manufactures semiconductor and component test, Environment: Azure Data Lake Gen2, Azure Synapse Analytics, Azure Data Factory, Power BI and Oracle SOA
BI Consultant
Softtek Inc.
06.2015 - 04.2017
- Company Overview: Client: RBI (Burger King & Tim Hortons) – Bangalore, India, Industry: Fast Food Chain Restaurant, Environment: SSMS, Microsoft Visual Studio, SSRS AND SSIS, SQLSERVER 2012
- Made vital contribution for removing client data from SQL and validated the same for business purpose
- Retrieved data from the database by scripting complex SQL queries using joins, sub queries and correlated sub queries
- Safeguarded database optimization by identifying tests and resolving database performance issues
- Assisted consistent data entry into the database by creating opinions to enable easy user interface implementation, and triggers on them
- Tested required queries and reports before publishing
- Tested and debugged the stored procedures besides utilizing triggers to check the validity of the data
- Acted as a key player in designing and establishing monthly, quarterly, and yearly reports at product and client level
- Supervised the workflows through Informatica Power center; examined and identified the job failures in Informatica workflow manager
- Analyzed the business sales and traffic by using tableau reports
- Removed and conveyed the required data from SQL and Netezza to Client
- Client: RBI (Burger King & Tim Hortons) – Bangalore, India, Industry: Fast Food Chain Restaurant, Environment: SSMS, Microsoft Visual Studio, SSRS AND SSIS, SQLSERVER 2012
Education
Bachelor of Technology - Computer Science
Madanapalli Institute of Technology and Science
01.2012
Skills
- ETL Development
- Data Warehousing
- T-SQL
- Synapse
- ADLS Gen2
- Azure Services
- Azure Data Factory
- Databricks
- ETL development
- Advanced SQL
- Data curating
- Large dataset management
- Data-driven decision-making
- Unity Catalog
- PySpark
- Data Management
Accomplishments
Awarded for Aspiration Expediter
Certification
Azure Data Engineer Associate DP-203
Timeline
Sr Data Engineer Specialist
accenture Pvt ltd
05.2021 - Current
Senior BI Consultant
KPI Partners India Pvt.Ltd
05.2017 - 05.2021
Senior BI Consultant
KPI Partners India Pvt.Ltd
05.2017 - 05.2021
BI Consultant
Softtek Inc.
06.2015 - 04.2017
Azure Data Engineer Associate DP-203
Bachelor of Technology - Computer Science
Madanapalli Institute of Technology and Science
Similar Profiles
Bharati PBharati P
Data Engineer/PySpark Developer at Accenture Pvt LTDData Engineer/PySpark Developer at Accenture Pvt LTD
Ajay LAjay L
Content Moderator - Trust & Safety New Associate at ACCENTURE PVT LTDContent Moderator - Trust & Safety New Associate at ACCENTURE PVT LTD
Sreekanth SetturuSreekanth Setturu
Business Process Delivery Analyst at Accenture Pvt LtdBusiness Process Delivery Analyst at Accenture Pvt Ltd