
Ali Akbar
Senior Data Engineer | ETL & Cloud Data Solutions
Salary / Daily rate
Islamabad, Islamabad Capital Territory, Pakistan
Freelance, open to permanent contract
Can come onsite
Skills
Languages
About me
Intro
AWS Certified Data Engineer with 10+ years expertise in ETL optimization, cloud data solutions, and enterprise analytics. Delivered 35% performance improvements using Airflow, PySpark, and Snowflake across multi-million dollar operations. Specialized in building scalable data pipelines and predictive analytics that drive measurable business outcomes.
Work experience
Senior Data Engineer
TechnoSpyre Inc
Oct 2024 - Present
2 years 1 month
Islamabad, Islamabad Capital Territory, Pakistan
Data Pipeline Development & Orchestration: Designed and optimized complex data pipelines using Apache Airflow, collaborating with technical teams and business stakeholders for seamless, scalable data integration. ETL Process Automation: Built and maintained ETL workflows using Talend, SQL, Python, and PySpark, enabling efficient data extraction, transformation, and loading from diverse sources. Cloud Data Solutions: Designed multi-layered data warehouse and lake architectures (staging, temp, semantic layers) using Snowflake, AWS Redshift, and Databricks, supporting structured storage, advanced analytics, and real-time insights. SQL Optimization & Database Tuning: Improved ETL efficiency and reduced data load times by optimizing complex SQL queries and tuning database performance. Big Data & Streaming: Applied PySpark, Kafka, and cloud-native services for large-scale data processing and real-time data streaming solutions. Predictive Analytics: Leveraged historical and real-time data to build predictive models, enhancing data-driven decision-making and business strategy. Legacy Data Migration: Retrieved, standardized, and integrated legacy data from multiple branches, ensuring consistent, high-quality datasets for enterprise-wide analytics. Business Intelligence Enablement: Centralized enterprise data assets into a unified warehouse, empowering advanced BI reporting, deep analytics, and actionable business insights
Data Engineer
Interloop Limited
Feb 2022 - Oct 2024
2 years 9 months
Faisalabad, Pakistan
ETL Process Optimization with Talend: Streamlined ETL workflows using Talend, reducing data processing time by 35% and significantly boosting overall system efficiency. This optimization underscores the critical role of data engineers in ensuring seamless data operations. Waste Analysis Dashboard Development: Engineered a robust data pipeline to support the creation of a comprehensive Tableau dashboard for waste analysis. This involved integrating and processing data from multiple sources, resulting in a 30% reduction in waste through enhanced data visibility and actionable insights. This project underscores the critical role of data engineering in building scalable data solutions and enabling effective data-driven decision-making. Machine Performance Monitoring Solution: Developed and implemented a machine performance monitoring solution, enhancing operational efficiency by 35% and reducing downtime through real-time performance data and predictive maintenance insights. This achievement reflects the vital contribution of data engineers in advancing operational excellence and reliability. Advanced Data Integration: Utilized SQL and Talend to perform complex ETL and ELT processes, integrating data from multiple sources and improving data accuracy by 25%. This role demonstrates the essential skills of data engineers in managing and transforming large datasets for meaningful analysis.
Data Analytics Engineer
Kamal Mills
Oct 2020 - Mar 2022
1 year 6 months
Faisalabad, Pakistan
Cost Reduction through Automated KPI Dashboards: Developed automated KPI dashboards using Oracle Apex and OBIEE, enabling stakeholders to reduce operational costs by 15% through improved resource allocation and process efficiencies. Time Optimization with Real-Time Data Insights: Created real-time data visualization dashboards that streamlined report generation and data validation, reducing analysis and decision-making time by 30% through efficient ETL processes and optimized SQL queries. ETL Development: Leveraged Talend for automated extraction, transformation, and loading (ETL) processes, reducing manual work and ensuring data accuracy and scalability using Informatica PowerCenter
Senior Oracle Developer
H.A.R. Textile Mills Limited
Aug 2018 - Oct 2020
2 years 3 months
Faisalabad, Pakistan
Client Requirements Analysis: Engaged with clients to understand their needs and developed user-friendly programs, resulting in a 30% increase in user satisfaction. Program Testing & Quality Assurance: Conducted thorough testing of programs before delivery, ensuring 100% adherence to prerequisites and reducing post-deployment issues by 25%. Oracle APEX Development: Designed and maintained Oracle APEX Forms and Reports, streamlining data presentation and enhancing usability by 20%. Oracle Developer 11g Expertise: Developed 15+ forms and reports using Oracle Developer 11g, improving data management efficiency and reporting accuracy. Problem-Solving & Decision-Making: Applied critical thinking to break down complex problems and evaluate solutions, leading to a 20% reduction in issue resolution time. Proactive Issue Resolution: Identified and analyzed issues, providing effective solutions that improved overall system reliability by 15%. Professional Support: Delivered expert services and support in a dynamic environment, contributing to a 40% improvement in client support response times. Interpersonal Skills: Fostered strong relationships with colleagues and clients, enhancing team collaboration and communication by 25%.
Oracle Developer
Sadaqat Limited
Apr 2015 - Jul 2018
3 years 4 months
Faisalabad, Pakistan
Enhanced System Performance: Upgraded legacy codebases to align with modern development standards, resulting in a 20% improvement in system efficiency. Client Communication: Acted as a key liaison with clients, translating their needs into actionable requirements and ensuring the successful delivery of tailored solutions. Quality Assurance: Executed comprehensive system testing, which increased program reliability by 15% and ensured that all client-required functions were consistently met. Oracle Developer Expertise: Designed and developed over 30 forms and reports using Oracle Developer 10g and 6i, enhancing data accessibility and user experience. Data Modeling & Implementation: Utilized TOAD and other third-party tools to design, code, and document data modeling features, contributing to a 25% increase in data accuracy and reporting efficiency. SAP ABAP Customization: Developed customized reports and screens, optimizing SAP ABAP functionalities and improving report generation speed by 18%. Lifecycle Collaboration: Partnered in all stages of the systems development lifecycle, from requirements gathering to production releases, ensuring seamless project execution. Performance Optimization: Corrected, modified, and upgraded software, which led to a 30% enhancement in overall performance.
Computer Science lecturer
Schools & Colleges
Oct 2011 - Oct 2014
3 years 1 month
Faisalabad · On-site
Effective Instruction: Taught computer science concepts to diverse student groups, resulting in a 20% improvement in student performance on standardized assessments. Hands-On Learning: Facilitated practical exercises and projects, helping students develop real-world skills and achieving a 25% increase in student project completion rates. Student Support: Provided individualized support and mentorship, leading to a 15% increase in overall student satisfaction with the learning experience. Educational Technology Integration: Incorporated modern educational technologies and tools into the classroom, boosting student interaction and learning efficiency by 20%
Education
University of Agriculture, Faisalabad
MS
2016 - 2018
2 years 1 month
Government College University, Faisalabad
BS
2010 - 2014
4 years 1 month