Milad Araji Email & Phone Number

Toronto, On, Ca

Ajax, Ontario, Canada

Tehran, Tehran Province, Iran

• Developed Power BI dashboards utilizing a variety of visuals such as charts, tables, and more to effectively visualize complex datasets, aligned with market needs and organizational targets, thereby facilitating data-driven decision-making and augmenting business insights to achieve strategic goals.• Developed interactive dashboards with role-based security (RLS) and tailored customization features to meet diverse end user requirements, ensuring personalized insights and seamless access to pertinent data.• Implemented rigorous updates and maintenance for SQL databases and intricate queries, with a strong emphasis on refining procedures to enhance efficiency by up to 50%.• Designed a multidimensional and tabular data model using SQL Server Analysis Services (SSAS), incorporating Data Analysis Expressions (DAX) and MDX for advanced analytics and key performance indicators (KPI).• Defined KPIs based on company goals and enhanced their effectiveness by incorporating measures and calculated columns. Monitored these KPIs meticulously to ensure timely target achievement.• Expertly crafted and executed robust data warehouse solutions leveraging SSIS, Power Query and SSAS, optimizing ETL (Extract, Transform, Load) processes to elevate operational efficiency by up to 30%.• Provided leadership and direction to BI teams working with complex data sets, including large tables with up to 12 million records, to solve various challenging problems.• Reduced manual work by 100 hours monthly by bringing analytical insights to operations and optimizing business processes. Furthermore, conducted weekly meetings to share insights.

Tehran, Tehran Province, Iran

• Leveraged advanced Excel functions to clean and manipulate sales data, implementing scalable solutions to handle large datasets efficiently.• Utilized Excel's pivot tables and charts to create comprehensive reports that provided insights into sales trends and performance metrics, enabling informed decision-making.• Transitioned to SQL Server Management Studio (SSMS) and SQL Server Analysis Services (SSAS) to handle complex data analysis tasks at scale, optimizing database performance and enhancing data modeling capabilities.• Developed KPI-based reports using SSAS, aligning them with both company targets and market needs to provide actionable insights for sales strategies.• Integrated Python and Pandas to automate data processing tasks, enhancing efficiency and accuracy in data analysis by 50%.• Visualized sales data effectively using Power BI, creating interactive dashboards that facilitated real-time monitoring of key metrics and supported strategic planning initiatives.

Iran

• Proven expertise in planning, coordinating, and executing IT projects, ensuring alignment with organizational goals. Collaborates effectively with cross-functional teams to achieve project objectives within established timelines.• Well-versed in evaluating and recommending hardware solutions to meet organizational requirements. Executes routine maintenance and upgrades to hardware components, ensuring optimal performance and longevity.• Experienced in developing and enforcing IT policies and procedures to ensure compliance and security Stays abreast of regulatory requirements and industry best practices to implement effective governance.• Keeps abreast of emerging technologies and industry trends, conducting research to evaluate and recommend new technologies. Contributes insights for strategic decision-making and future-proofing IT infrastructure.