salmaff

Specialized in data engineering, automated data extraction, and system integration to support analytics, reporting, and national accreditation initiatives. Designed and managed 70+ fact and dimension tables using star schema as the core enterprise Data Warehouse architecture. Built end-to-end automated ETL and data ingestion pipelines with Python, Apache Hop, and SQL, integrating data from 10+ heterogeneous sources including REST APIs, PostgreSQL, ClickHouse, BigQuery, CSV/Excel, and web data. Developed Python-based web scraping and external API workflows using Requests, BeautifulSoup, and Selenium to collect, validate, enrich, and integrate structured datasets into the enterprise Data Warehouse. Developed and optimized 60+ complex SQL queries powering 15+ dashboards for institutional and product analytics. Conducted product performance and adoption analytics using BigQuery, analyzing feature usage, user behavior, engagement, and adoption metrics. Monitored ETL pipelines through Jenkins CI/CD and ClickHouse ingestion, maintaining 99%+ data reliability. Collaborated across analytics, product, and engineering teams to translate business requirements into scalable data solutions.

I ensured that articles met the required publication standards. I reviewed article specifications, including formatting, references, and content quality, to align with the journal's guidelines. This effort aimed to maintain the journal’s credibility. Verified references followed the appropriate citation style (e.g., APA/IEEE), ensuring 100% consistency and accuracy across all references. Assessed the clarity, relevance, and academic tone of each article, contributing to the approval of 90% of articles for publication after revisions. Provided detailed feedback to authors on necessary revisions, ensuring that 95% of suggested corrections were properly implemented and addressed in final submissions.

During my internship as a System Analyst, I analyzed user requirements for system implementation. I created BPMN, user flow diagrams, database models, and network plans while also conducting testing to ensure the system met specifications. Additionally, I learned to develop test plans in QA. Designed process flows to visualize and optimize business operations, improving operational efficiency by 20% through streamlined workflows. Developed entity-relationship diagrams to map out the database structure, ensuring 95% data consistency across the system. Contributed to the design of network topologies that defined secure and efficient communication between system components, reducing network latency by 15%. Created detailed test plans outlining testing scope, objectives, strategies, and timelines, ensuring comprehensive test coverage for all system features. Wrote comprehensive test cases for each feature, including expected outcomes and step-by-step procedures, increasing test accuracy by 30%. Performed manual testing based on defined test cases, ensuring the system met 100% of specified requirements and identified over 10 critical bugs before deployment.

Advised on aligning business strategy with IT infrastructure through the implementation of enterprise architecture frameworks. Mapped and analyzed 12+ core business processes and 25+ IT assets, identifying 15 redundancies and recommending architecture realignment. Designed a comprehensive Enterprise Architecture (EA) blueprint using TOGAF framework, leading to a 20% improvement in inter-departmental system integration. Created over 30 visual models, including business capability maps, application portfolios, and infrastructure diagrams using ArchiMate and BPMN. Collaborated with 5 departments to align EA strategy with operational priorities, resulting in a 15% reduction in duplicated software usage.