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
Elhaj MohamedElhaj Mohamed
IT Support Engineer at Globalise internationalIT Support Engineer at Globalise international
Jayalakshmi GajendranJayalakshmi Gajendran
Submission/Resubmission Officer - Coding at Aster DM HealthcareSubmission/Resubmission Officer - Coding at Aster DM Healthcare