Hemraj Ashtankar
Data Architech and modeler
Dubai
Summary
With over 11 years of professional IT experience, I have developed expertise in Data Analytics, Alteryx, Tableau, Azure Data Factory, Datalake, Databricks, Power BI, Python, Data Modeling, Data Vault, Data Visualization, Business Intelligence, and Reporting. I have successfully applied my knowledge in the insurance and banking , energy industries to drive impactful results. Skilled in creating effective data solutions and providing valuable insights to support business decision-making.
Overview
13
13
years of professional experience
Work History
Data Engineer
Dubai Holding Assets Managment
05.2023 - Current
- Optimized data processing by implementing efficient ETL pipelines and streamlining database design.
- Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
- Working with energy vendor like empower energy to access utility data .
- Ensured data integrity and quality by implementing data validation and cleansing mechanisms.
- Automated routine tasks using Python scripts, increasing team productivity and reducing manual errors.
- Developed end-to-end Power BI dashboards to provide actionable business insights.
- Created visual reports, KPI scorecards, and real-time dashboards using Power BI Desktop.
- Implemented row-level security (RLS) and optimized data transformation for business intelligence.
Data Analytic Consultant
Al-Hilal Bank
10.2021 - 05.2023
- Designed, implemented, and supported Microsoft BI solutions to meet market and client requirements.
- Developed end-to-end Power BI dashboards, visual reports, KPI scorecards, and live dashboards for real-time insights.
- Identified trends and patterns in large datasets, providing valuable insights to drive business growth.
- Introduced innovative visualization tools that transformed complex data sets into easily digestible information for diverse audiences.
- Built and optimized data pipelines using Azure Data Factory (ADF), Mapping Data Flows, Databricks, Azure SQL, and ADLS.
- Designed and managed pipeline jobs, scheduled triggers, and credential security using Azure Key Vault.
- Developed tabular models on Azure Analysis Services (AAS) to enhance reporting capabilities.
- Designed SSIS packages in Business Intelligence Development Studio (BIDS) to extract and transform data from various sources into SQL Server (2012 & 2016).
- Conducted regular reviews of analytical methodologies and technologies, staying abreast of industry trends to drive continuous improvement in data analytics capabilities.
- Provided technical design and coding assistance to the team, ensuring successful project delivery as per scope.
Senior Consultant
HCL Technology
09.2019 - 10.2021
- Analyzed business needs and developed data workflows using Alteryx to automate data transformation and processing.
- Build micros for dynamic task automated and building app in alteryx.
- Served as a client-facing consultant, engaging in daily interactions to gather business requirements and provide data-driven solutions.
- Designed and developed interactive dashboards in Tableau and power bi for senior management decision-making.
- Created interactive filters, parameters, and calculations in Tableau to enhance user experience and data exploration.
IT Analyst
Deutsche Bank Group
07.2018 - 07.2019
- Gathered Business Requirements, interacted with the Users, Project Manager to get better understanding of the Business Processes.
- Worked with tableau server admin while performing activity like upgrade server, licence key activation offline issue.
- Write automation script to exporting data from dashboard to csv file
- Worked extensively in documenting the Source to Target Mapping documents with datatransformation logic.
- Responsible for creating test cases to make sure the data originating from source is making into target properly in the right format.
- Created action filters, parameters and calculated sets for preparing dashboards and worksheets.
- Mastered the ability to design and deploy rich visualizations with Drill Down and Drop-down menu option and Parameterized using Tableau.
- Involved in building financial reports in Tableau so as to have nice look and feel.
Software Engineer
Axon Software
04.2015 - 07.2018
- Developed scalable and maintainable code, ensuring long-term stability of the software.
- Integrated new technologies into existing systems, increasing capabilities and improving overall performance.
- Developed reusable components that significantly reduced development effort on multiple projects.
- Implemented effective debugging strategies, resulting in fewer software defects and increased reliability.
Software Developer
DataPMI Tech Service Ltd
02.2012 - 03.2015
- Improved software efficiency by troubleshooting and resolving coding issues.
- Saved time and resources by identifying and fixing bugs before product deployment.
- Updated old code bases to modern development standards, improving functionality.
- Contributed to a positive team environment through effective communication, problem-solving, and collaboration skills.
Education
Bachelor of Engineering - Computer Science And Engineering
Nagpur University
Nagpur India 04.2001 -
Skills
Alteryx
Power BI
Tableau
Azure
Data Modeling
DWH
Databricks
Pyspark
Data governance
Risk analysis
Technology leadership work streams
Problem-solving abilities
Timeline
Data Engineer
Dubai Holding Assets Managment
05.2023 - Current
Data Analytic Consultant
Al-Hilal Bank
10.2021 - 05.2023
Senior Consultant
HCL Technology
09.2019 - 10.2021
IT Analyst
Deutsche Bank Group
07.2018 - 07.2019
Software Engineer
Axon Software
04.2015 - 07.2018
Software Developer
DataPMI Tech Service Ltd
02.2012 - 03.2015
Bachelor of Engineering - Computer Science And Engineering
Nagpur University
04.2001 -
Similar Profiles
Hunter ThomasonHunter Thomason
Vice President of Commercial Development at Medical Assets Holding CompanyVice President of Commercial Development at Medical Assets Holding Company
Amro BayoumyAmro Bayoumy
Director – Authorities Approvals & Code Compliance at Dubai Holding Real Estate (Meraas, Dubai Properties, Nakheel, Meydan)Director – Authorities Approvals & Code Compliance at Dubai Holding Real Estate (Meraas, Dubai Properties, Nakheel, Meydan)
MOHAMED QASASMOHAMED QASAS
Functional Manager at MERAAS Holding/Dubai Holding Asset ManagementFunctional Manager at MERAAS Holding/Dubai Holding Asset Management
ERICK SAIMON MMBAGAERICK SAIMON MMBAGA
Ramp Operations Team Leader at Dnata, The Emirates GroupRamp Operations Team Leader at Dnata, The Emirates Group
Asma ShaabanAsma Shaaban
Social Media Manager at KcalSocial Media Manager at Kcal