Mohammad Alam Email & Phone Number

Toronto, Ontario, Canada

• Lead the development and design of MSBI solutions using SSIS, SSAS, and Azure technologies including ADF, Databricks, Data Lake, and Synapse.• Oversee the creation of data warehouses, extraction of data from company servers and cloud platforms, transformation processes, and testing.• Manage the development of complex T-SQL queries, functions, stored procedures, and optimization techniques to enhance database performance.• Automate SSIS batch jobs with Agents and Autosys, ensuring efficient data processing.• Coordinate data integration efforts to consolidate diverse data sets and build robust data pipelines between source and target systems.• Utilize Python scripting (PySpark) in Databricks for efficient data storage and retrieval within Azure environments.• Conduct system architecture analysis, algorithm development, gap analysis, and data profiling for comprehensive pipeline development.• Develop project plans, infrastructure designs, data governance frameworks, and data dictionaries to meet business goals.• Troubleshoot and resolve database-related issues, providing timely resolutions to maintain system integrity.• Implement multi-dimensional SSAS cubes and SSIS ETL packages, and develop analytical Excel cube reports with row-level security and pivot options.• Enhance data warehouse architectures to support stakeholder insights and data behaviors.• Formulate new business data requirements, develop data models, and establish data lifecycle, governance, and metadata policies.• Utilize Azure Data Lake Storage (ADLS), Azure Databricks (ADB), Azure Data Factory (ADF), and Azure Synapse Analytics for cloud data solutions.• Employ Tableau for reporting and support SaaS applications.• Lead and support cross-functional teams to resolve production issues and ensure seamless operations.• Apply VBA and C# for Excel and reporting tasks to enhance data management capabilities.

Toronto, Canada Area

 Developed ETL process following business requirements, analyzed impact and ensured dataQA, privacy and security. Re-Engineered transformation and mapping process according to business process tomigrate database on terabyte-scale datasets. Performed RDBMS integration, SQL tuning, ETL, data profiling, data modelling, datamapping and data transformation. Developed logical and physical data model, data integrity, star schema and slowly changingdimension process. Processed and implemented system enhancement to prevent the reoccurrence of issues. Managed tasks and timelines to ensure project milestones.