Data Warehouse Business Intelligence

Majid Askari Tehrani

Toronto, ON 416-***-**** *************@*****.*** LinkedIn

Business Intelligence Analyst

SUMMARY OF QUALIFICATIONS

As a highly skilled data warehouse architect with over 20 years of experience, I excel at creating and maintaining scalable, efficient, and reliable data warehouses. My expertise lies in designing data models, building ETL processes, and creating reporting and analysis tools that enable businesses to make informed decisions. My approach to data warehouse design is centered around understanding the unique needs of each client and designing a solution that meets their specific requirements. To achieve this, I work closely with stakeholders to gather requirements, identify data sources, and design a schema that aligns with the organization's goals. With extensive experience working with a variety of data warehousing technologies, including Oracle and SQL Server, I am well-versed in BI services such as SSAS and SSIS. My deep technical knowledge enables me to design and implement data solutions that maximize efficiency and effectiveness for my clients. TECHNICAL SKILLS

• Data Warehouse Architecture: Proficient in Dimensional Modeling, Data Vault and EDW architecture

• MS BI Stack: ETL: SSIS, OLAP: SSAS, Tool: Power BI

• Programming: DAX, Asp.net, C#.net, MDX, VB.net, CSS, JavaScript, Ajax, JSON, T-SQL, PL/SQL

• Databases: Microsoft SQL Server, Oracle

• UML Methodologies

• System analysis

• Advanced Visualization

• Storage: Data Lake, DM, RDBMS

WORK EXPERIENCE

Principal Data Architect

Mabna Consultants Co., Full-time

Aug 2003 - Nov 2023

• Worked as an Analyst, Designer, and project manager for the implementation of the Mabna BI & Management Dashboard Application.

• Lead the design and implementation of large-scale dimensional data warehousing solutions that integrated data from multiple sources.

• Established and executed optimal strategies for data administration and integration throughout the organization, culminating in refined procedures and heightened data precision.

• Collaborated with business stakeholders to recognize and prioritize KPIs (key performance indicators) and requisites, ensuring that the data repository aligned with their needs and business objectives.

• Supervised teams composed of software engineers, business intelligence developers, and business analysts; offering guidance on both technical predicaments and project oversight.

• Introduced agile methodologies and prime practices, culminating in elevated efficiency, productivity, and client contentment.

Industry Sectors and clients:

o Banks (Data Mart: GL, HR, Deposit, Loan, NPL and etc.)

Maskan Bank

Over 5M transactions/day.

Eghtesad-e Novin Bank

Over 5M transactions/day.

Mellat Bank

Over 10M transactions/day.

Tose Bank

Over 5M transactions/day.

Post Bank

Over 15M transactions/day.

E-Farda Co. (ISP)

Over 5M transactions/day.

National Development Fund of Iran

o Insurance Company

Persian Insurance Co

Day Insurance Co.

o Oil and gas (holding)

National Iranian Gas Co.

National Petrochemical Company Co.

o industrial

Iran Dairy Industries Co.

Iran International Engineering Co. (IRITEC)

o IT

Iran Information Technology Org.

o Other organizations Such as Finance, University & Research, Engineering and so on.

Technologies: MS SQL Server/Oracle Querying and Programming, SSAS, SSIS, company’s proprietary visualization tool or Power BI Senior System Designer

Industrial Management Institute., Full-time

Jul 1998 - Dec 2002

• Conducted detailed analysis of business requirements and translated them into technical specifications for system development.

• Worked closely with software developers to ensure that system design and development aligned with business requirements.

• Designed and implemented testing strategies to ensure that system changes met quality standards.

• Worked closely with business stakeholders to ensure that system changes met their needs and were aligned with business goals.

• Developed and maintained system documentation, including user manuals, technical specifications, and test plans.

Industry Sectors and clients:

o Bookkeeping, Inventory and inventory accounting application

Iran Chemical Industrial Co.

Razi Broadcasting Co.

Iranian Diesel Engine Manufacturing Co. (I.D.E.M)

Mazandaran Wood & Paper Industries

Central Bank of the Iran

etc.

Technologies: Unified Modeling Language (UML), Rational Rose Enterprise Edition, Visual Basic Others company:

Technical Solutions Architect in Nazmavaran-e Pouya Co. Jul 1996 - Aug 1998

• Designed and developed software applications using a variety of programming languages and technologies.

• Conducted unit testing and resolved software defects.

• Worked closely with system analysts to ensure that software development aligned with business requirements.

• Collaborated with other IT teams to ensure that software development was aligned with overall IT strategy.

• Maintained documentation for software applications, including user manuals and technical specifications. Technologies: Borland Delphi, Visual Basic, Microsoft SQL Server, InterBase Software Developer in Pars System Consultants Co. Oct 1992 - May 1996

• Designing, modifying, and testing technical architecture

• Provide supervision and guidance to development teams

• Designed and developed software applications using a variety of programming languages and technologies

• Maintained documentation for software applications, including user manuals and technical specifications Technologies: FoxPro, Paradox, dBase

EDUCATION AND PROFESSIONAL DEVELOPMENT

• B.S in computer science

Arlington International University

Jul 2005 - Jul 2009

• Certified as Principal Data Architect with EU Blue Card Network Credential EU Blue Card Network - Profile: Credential ID 202644 Jul 2023

• Certification in Data Mining Application in Finance and Banking TÜV Rheinland Academy Issued, Credential ID AMM-09/01 22 Jan 2009

• Certification in Modern Management in 21st Century Brian Tracy International

Apr 2007

• Certification in Negotiation Techniques

Iran Management Consultants Association (IMCA)

Feb 2006

• Certification in Experience system analysis and design by UML Industrial Management Institute

May 2002

• Theory and Practical Certification of Systems Thinking Industrial Management Institute

Aug 2001

• Certification in Supply-chain management

Industrial Management Institute

Feb 2001

• Certification in Customer Relationship Management (CRM) Industrial Management Institute

May 2000

Contact this candidate