Sarim Aftab Mohammed Email & Phone Number

With over 5 years of IT experience specializing in data analysis and data modeling, I possess a robust understanding of data warehouse and data mart development, SQL, and the analysis of both Online Transactional Processing (OLTP) and Online Analytical Processing (OLAP) environments. I am proficient with major databases including Oracle, SQL Server, and Teradata, and have a deep expertise in data modeling, data collection, data cleansing, and the design of ETL processes. My experience encompasses driving cross-functional analytics projects from inception to completion, including question formulation, data model design, exploratory data analysis (EDA), validation, analysis, machine learning, visualization, and presentation. I have strong capabilities in ER and dimensional data modeling, delivering normalized ER and STAR/SNOWFLAKE schemas using Erwin, and am well-versed in SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), and SQL Server Integration Services. Additionally, I am skilled in ER Studio, EA Studio, Sybase Power Designer, and various ETL design tools such as Informatica PowerCenter. My expertise extends to financial, mortgage, supply chain, material management, healthcare, supplemental insurance, and property & casualty insurance sectors. I am proficient in Google Looker for transforming raw data into actionable insights and have experience with DOMO for business intelligence and data visualization. My technical skills include advanced Excel functionalities, VBA macros, and a deep understanding of SQL for defining, manipulating, and querying data. Furthermore, I provide technical expertise in Informatica products including PowerCenter, MOM (Siperian), IDD (Informatica Data Director), IDQ (Informatica Data Quality), Address Doctor, and Identity Matching, and specialize in Azure Data Factory (ADF) for cloud-based ETL services.