Abbas Jamibollah

Experience

• 

  C-pak Cergas SDN BHD

  Jan 2016 - May 2016

  Electrical Engineering Intern
• 

  H&M

  Jan 2019 - Jul 2019

  Sales Assistant
• 

  LOCUS-T

  Jan 2020 - Apr 2020

  Web Development Intern

  - Update and edit website content, posts and pages.- Assist web development team in troubleshooting issues on web-based systems.- Collaborates with web designers to match intent of visual design and doing image editing using Photoshop and Illustrator.- Provide technical support related to web-based systems to internal teams.

• 

  Asia Online Publishing Group Sdn. Bhd.

  Sept 2020 - Jul 2022

  Jr. Software Engineer

  - Software testing for CRM system(Using EspoCRM)- Prepare/ cutting a database for telemarketer using MS Access Queries for daily purpose- Manage and doing some maintenance for all company websites such as change websites styling using css.- Develop and doing manual testing (UAT) for company CRM system using Dadabik tools that integrate with company database which is MySQL Server.- Work with team leader and human resource team to automate their daily report by analyze data and visualize it using Power BI- Write a requirement document and create a wireframe for each system/ site project using figma based on the requirement from company or client- Getting certificate for Power BI Training- Provide systems administration tasks sure as adding new users and defining access rights in CRM system to give different view for each user level.- Report any identified system issues to the vendors through bug documents such as hosting problem and security breach. Show less

• 

  CARSOME

  Jul 2022 - Nov 2023

  Business Intelligence Analyst

  - Designed and implemented ETL pipelines using Airflow to automate the extraction, transformation, and loading (ETL) of 1M+ daily records from sources like MongoDB into analytics platforms such as Redshift and GCP, reducing processing time by 30% and optimizing workflows for scalability and performance.- Managed ETL and data model updates collaboratively using GitLab, creating Merge Requests (MR) to ensure efficient deployment, version control, and alignment with evolving business needs.- Developed advanced SQL workflows to process and aggregate large datasets, integrating transactional data across sales, profitability, Human Resource metrics, and customer service for actionable insights.- Built and optimized dimensional data models (fact and dimension tables) to support 200+ stakeholders, enhancing query performance by 40% and improving analytics and reporting capabilities.- Automated manual reporting processes, saving over 20 hours/month, ensuring timely delivery of analytics-ready data for dashboards, and reducing operational overhead.- Created Tableau dashboards to visualize key metrics, including sales trends, forecast planning, employee performance, and customer satisfaction, driving a 10% increase in user engagement across three departments.- Conducted performance tuning for ETL pipelines, ensuring reliability and scalability while adapting workflows to meet evolving business requirements. Show less

• 

  GXBank

  Jan 2024 - Jun 2024

  BI Specialist

  - Designed and implemented ETL pipelines using Airflow to automate the extraction, transformation, and loading (ETL) of 1M+ daily records from sources like MongoDB into analytics platforms such as Redshift and GCP, reducing processing time by 30% and optimizing workflows for scalability and performance.- Managed ETL and data model updates collaboratively using GitLab, creating Merge Requests (MR) to ensure efficient deployment, version control, and alignment with evolving business needs.- Optimized SQL scripts for ERP tables in Snowflake, reducing execution time by 40% and enabling data refresh cycles to complete within 5 minutes instead of 9 minutes.- Developed advanced SQL workflows to process and aggregate large datasets, integrating transactional data across sales, profitability, Human Resource metrics, and customer service for actionable insights.- Built and optimized dimensional data models (fact and dimension tables) to support 200+ stakeholders, enhancing query performance by 40% and improving analytics and reporting capabilities.- Automated data workflows for transactional and product data, ensuring 100% on-time refresh cycles and eliminating over 15 hours of manual effort per month.- Developed a Pending Payment dashboard, integrating data pipelines that monitor 10,000+ mobile app transactions daily, ensuring seamless data availability for stakeholders.- Created Tableau dashboards to visualize key metrics, including sales trends, forecast planning, employee performance, and customer satisfaction, driving a 10% increase in user engagement across three departments.- Conducted performance tuning for ETL pipelines, ensuring reliability and scalability while adapting workflows to meet evolving business requirements. Show less