Fähigkeiten
Zusätzliche Fähigkeiten (19)
Branchenkenntnisse
Shahzad in wenigen Worten
Result-driven and hands-on data analyst and engineer. With more than 9 years of experience in building data pipelines, my expertise lies in extracting, cleaning, processing and modeling data from diverse sources and platforms. Having owned investor and auditor reporting for a private debt platform company (CrossLend) for several years, I have become a resilient while pragmatic, and therefore valued, contributor to 10+ successful cross-European securitisation deals. My strengths are in batch-processing using Python & SQL as well as Pentaho & Airflow. Yet, since having worked for M^0, I’ve also reached a solid knowledge in event-streaming. The combination of these experiences let me nowadays be a well-rounded professional, bringing the necessary skills and personal attributes to successfully contribute to and support any data-driven initiative out there. Feel free to reach out!
Projekt- und Berufserfahrung
- CrossLend GmbHSenior Analytics & Business Intelligence EngineerFebruar 2023 - Heute (2 Jahre und 1 Monat)Berlin, Germany• Designed and implemented scalable data models and centralized data warehouses to streamline reporting and analytics.• Automated ETL pipelines with Python and Airflow, ensuring consistent data processing across European markets.• Managed off-chain data for US Treasury and banking data, supporting accurate proof-of-reserve for token minting.• Developed data streaming solutions, including Banking and Security Readers, optimizing data extraction and processing.• Built and deployed Python-based Kafka connectors for real-time data streaming.• Utilized AWS S3 and Docker for scalable cloud-based solutions.• Led SCRUM-based project management, working closely with product teams to prioritize tasks.• Contributed to event-streaming projects, using Mermaid for data flow visualization and processing TreasuryDirect data. Key Achievements:• Streamlined treasury data processing, ensuring timely payment schedules for treasury bills, notes, and bonds.• Resolved delays in cash transaction visibility, improving reconciliation and operational efficiency.• Constructed scheduled payment processes with ksqlDB, enhancing operational reliability. Tech Stack: Kubernetes, ksqlDB, AWS S3, PyCharm, Docker, Python, Kafka, JIRA, Confluence.
- CrossLend GmbHSenior Analytics & Business Intelligence EngineerApril 2017 - Januar 2023 (5 Jahre und 10 Monate)Berlin, Germany• Owned the Python-based reporting engine, significantly reducing manual effort and becoming a key USP of the product.• Managed end-to-end data stack, including developing ETL processes with Pentaho, integrating data from Salesforce, Mailchimp, and UMS.• Modeled and centralized data for reporting and analytics, ensuring seamless access for teams and external auditors.• Developed Python scripts for automated validation, improving data accuracy and streamlining checks with YAML for standardization.• Created custom dashboards for real-time insights, supporting data-driven decision-making.• Standardized reporting for 10+ cross-European securitization deals, improving data consistency and integration.• Conducted originator portfolio analysis, assessing performance and risk for improved investor transparency. Key Achievements:• Automated report generation, reducing audit preparation time from 3 months to 2 weeks.• Improved data accuracy and integrated real payment data for clearer investor insights.• Developed delta tables for loan-level analysis, ensuring reliable and high-performing reporting.• Enhanced data validation, exceeding standard checks for greater integrity. Tech Stack: Python, Shell Scripts, SQL, MySQL, Pentaho, AWS S3, NewRelic, JIRA, PostgreSQL.
- CrossLend GmbHAnalytics & Business Intelligence EngineerJanuar 2016 - März 2017 (1 Jahr und 3 Monate)Berlin, Germany• Designed and implemented ETL workflows using Pentaho Data Integration (PDI), integrating data from multiple sources into relational databases.• Developed interactive dashboards and reports in MicroStrategy, enhancing decision-making with dynamic data visualizations.• Enabled self-service BI, improving data accessibility and operational efficiency across departments.• Produced reconciled reports for regulatory compliance and audit readiness.• Developed ETL processes in Python and Kettle to parse JSON/XML data and created multidimensional cubes for analysis. Key Achievements:• Empowered departments with self-service BI capabilities.• Improved data integration and reporting, streamlining processes and enhancing accessibility. Tech Stack: Pentaho, MicroStrategy, SQL, Python, Kettle, MySQL.
Externe Empfehlungen
Ausbildung und Abschlüsse
- Master of Computer ScienceDarmstadt University of Applied Sciences2015Master of Computer Science (M.CS)
- Bachelor of ScienceUniversity Of Peshawar2008BACHELOR OF COMPUTER SCIENCE (B.CS)