Majid Zerang Email & Phone Number

Tehran Province, Iran

Tehran Province, Iran

Tehran Province, Iran

• Built a 𝐝𝐚𝐭𝐚 𝐩𝐢𝐩𝐞𝐥𝐢𝐧𝐞 using 𝐀𝐢𝐫𝐟𝐥𝐨𝐰, ETL processes, and 𝐄𝐥𝐚𝐬𝐭𝐢𝐜𝐒𝐞𝐚𝐫𝐜𝐡 to analyze tweets related to the banking sector from X (formerly Twitter). Leveraged 𝐍𝐞𝐭𝐧𝐨𝐠𝐫𝐚𝐩𝐡𝐲 to capture user sentiments, with insights from Text Mining and Machine Learning provided as resources for downstream experts, enhancing risk management and decision-making in 𝐛𝐮𝐬𝐢𝐧𝐞𝐬𝐬 and 𝐜𝐲𝐛𝐞𝐫𝐬𝐞𝐜𝐮𝐫𝐢𝐭𝐲.• Designed and implemented an 𝐈𝐓 𝐒𝐞𝐫𝐯𝐢𝐜𝐞 𝐌𝐚𝐧𝐚𝐠𝐞𝐦𝐞𝐧𝐭 (𝐈𝐓𝐒𝐌) 𝐁𝐈 𝐬𝐨𝐥𝐮𝐭𝐢𝐨𝐧, enhancing operational efficiency and developing user-specific Power BI dashboards for tailored insights across various roles (managers, sales, marketing).• Implemented comprehensive financial dashboards by extracting data from 𝐒𝐲𝐬𝐭𝐞𝐦 𝐆𝐫𝐨𝐮𝐩'𝐬 𝐑𝐚𝐡𝐤𝐚𝐫𝐚𝐧 𝐄𝐑𝐏 𝐬𝐲𝐬𝐭𝐞𝐦, optimizing data models, and integrating data from 𝐞𝐢𝐠𝐡𝐭 𝐬𝐮𝐛𝐬𝐢𝐝𝐢𝐚𝐫𝐲 𝐜𝐨𝐦𝐩𝐚𝐧𝐢𝐞𝐬 for effective analysis and actionable insights.

Tehran Province, Iran

•Streamlined and integrated data from 10 subsidiaries, significantly enhancing reporting accuracy and relevance.•Implemented 𝐫𝐨𝐰-𝐥𝐞𝐯𝐞𝐥 𝐬𝐞𝐜𝐮𝐫𝐢𝐭𝐲 and 𝐜𝐮𝐬𝐭𝐨𝐦𝐢𝐳𝐞𝐝 Power BI Reporting Service, effectively enhancing data security and user management.• Analyzed intricate business requirements, identified key performance indicators (KPIs), and seamlessly integrated data from diverse sources.• Deployed analysis services using Tabular Mode (DAX) across multiple data marts, ensuring streamlined and efficient data processing.• Designed and scheduled ETL processes, optimizing data transfer and implementing a Custom Report Service with Role Level Security.• Developed impactful dashboards to motivate sellers, contributing to notable improvements in performance metrics.• Collaborated seamlessly with cross-functional teams to align BI solutions with specific business requirements.• Contributed to the success of 𝑪𝑫𝒐𝒐𝒓, 𝑱𝒆𝒂𝒏𝒘𝒆𝒔𝒕, 𝑺𝒂𝒎𝒂𝒏 𝑰𝒏𝒔𝒖𝒓𝒂𝒏𝒄𝒆, 𝒂𝒏𝒅 𝑴𝒂𝒉𝒂𝒏 𝑯𝒐𝒍𝒅𝒊𝒏𝒈 Company by optimizing ETL processes for efficient and streamlined data processing.

BI Developer in E-Government platform at Ideagostar➢ Developed ETL processes using SSIS tools and implemented Analysis Services in Multidimensional Mode (MDX).➢ Provided maintenance, support, and development for existing databases within the e-government platform.

Tehran

.Net and GIS Developer in E-Government platform at Ideagostar➢ Integrated GIS technologies into development, incorporating geospatial data and analysis within E-Government applications.➢ Designed and architected .NET and GIS-based solutions.