Shahfaisal Qayyum

BI Consultant

• Job Details:Lead and manage the BI team to develop and deliver data-driven insights and reports for key business stakeholders. Design and implement data models, reporting structures, ETL’s, and dashboards to improve decision-making across departments. Oversee the integration of data from multiple sources, ensuring consistency, accuracy, and timeliness of reporting. Collaborate with cross-functional teams to define business requirements and translate them into BI solutions. Utilize advanced analytics tools (Power BI, Qlik Sense, OBIEE, SQL) to create actionable insights and visualizations. Develop and maintain data governance policies to ensure data quality, security, and compliance with industry standards. Manage BI project timelines, resources, and deliverables to meet business objectives and deadlines.

Senior Consultant - Analytics

• Job Details:Designed and implemented data marts using Snowflake and SQL Server, enabling data scientists, analysts, and business users to access pre-aggregated and structured datasets optimized for analytics and reporting. Utilized Snowflake’s multi-cluster architecture to create scalable data marts, leveraging its performance optimization features like micro-partitioning and result caching for faster query execution. Built dimensional data models (star and snowflake schemas) in tools like Power BI, Qlik Sense and OBIEE, ensuring seamless integration with BI applications for advanced reporting and visualization. Utilized ETL tools such as Talend, Pentaho and SSIS to automate data extraction, transformation, and loading into data marts, ensuring high data accuracy and timely availability.

Senior ETL Consultant

• Job Details:Developed and optimized ETL pipelines using Talend for jobs, ensuring efficient scheduling, monitoring, and error handling of complex workflows. Built production-grade ETL’s to process terabyte-scale datasets, optimizing data transformation workflows and reducing processing times by 30%. Utilized Talend and Pentaho for data extraction, transformation, and loading from diverse data sources, including SQL Server, Snowflake, and AWS S3, into centralized data warehouses. Implemented real-time ETL workflows for streaming data ingestion, enabling near-instantaneous updates to analytics and reporting systems. Automated pipeline monitoring and error handling using Airflow DAGs, improving pipeline reliability and reducing downtime during data ingestion and transformation processes.