Jonathan Tan Teck Yang Email & Phone Number

Shah Alam, MY

Malaysia

• Tableau Dashboard Management: Maintain and enhance interactive dashboards to ensure data accuracy and deliver a seamless experience for stakeholders and marketing operations.
• Market Analysis & Reporting: Generate actionable insights through reports and market analysis to support strategic decision-making processes.
• ETL Pipeline Development: Build and manage automated data pipelines for efficient ETL processes, ensuring data cleaning, validation, and smooth report generation with live dashboard updates.
• SQL Query Optimization & Data Manipulation: Develop complex SQL queries for data extraction, transformation, and reporting while optimizing performance to handle large datasets efficiently.
• Data Warehouse Optimization: Enhancing Snowflake data warehouse operations, optimizing data aggregation and reducing query load times to improve performance.
• Collaboration & Stakeholder Engagement: Work closely with cross-functional teams to identify data needs, enhance reporting capabilities, and ensure alignment with business goals.

Malaysia

• Utilized WinSCP, MySQL, and Python for the processes of Extract, Transform, and Load(ETL).
• Building data pipelines by automating the flow of data from source to destination using written scripts from Python and MySQL.
• Using various programming techniques to improve and standardize the readability of raw data to approximately 98%.
• Conducted data cleaning, data enrichment, data analysis, and data validation.
• Successfully deployed over 7 businesses, effectively achieve objective of weekly quota by 20%.

Puchong, Selangor, Malaysia

• Demonstrated a comprehensive understanding of each department's data processes, overseeing and optimizing their operations.
• Developed efficient data structures tailored to the unique needs of each department, ensuring smooth information flow and accessibility.
• Employed advanced data cleaning and transformation techniques, successfully enhancing data quality and usability for four departments.
• Utilized powerful data visualization tools and dashboards to analyze historical data, uncovering valuable insights that guided strategic decision-making.
• Presented compelling findings and implemented successful business strategies based on thorough analysis of past data, driving impactful outcomes.
• Served as a trusted advisor to department heads and the CEO, leveraging data-driven insights to provide valuable guidance and inform strategic direction.

Puchong, Selangor, Malaysia

• Orchestrated daily E-commerce activity reporting, analysis, strategy formulation, and comprehensive reporting.
• Proficiently utilized Adobe Photoshop and Illustrator to craft marketing collateral including advertisements, e-commerce templates, and brochures.
• Enhanced retail customer retention by 15% through the integration of product specifications and design within retail price tags.
• Played a key role in organizing a successful lucky draw marketing campaign, leading to an impressive 80% increase in online sales.

Kuala Terengganu, Terengganu, Malaysia

• Provide comprehensive oversight for the entire E-commerce department, steering strategic initiatives, optimizing operations, and ensuring seamless coordination for successful business outcomes.
• Design and implementation of a robust e-commerce platform, utilizing expertise in electrical appliances to enhance online operations, streamline transactions, and elevate the overall customer shopping experience.
• Established standardized product image templates for e-commerce using Adobe Photoshop and Illustrator, ensuring a cohesive visual brand identity and enhancing the overall presentation of product listings.
• Implemented a strategic e-commerce system, resulting in an impressive 260% increase in business revenue. Demonstrated a proactive approach to optimizing operations and driving substantial financial growth.

Petaling, Selangor, Malaysia

• Responsible for content creation for online & offline marketing.
• Utilized strategic planning and creative thinking to develop engaging and impactful content.
• Achieved remarkable results by successfully increasing Instagram followers by an impressive 300% within a span of just three months.
• Demonstrated exceptional graphic design skills by creating and posting over 70 visually captivating posters within the same three-month period.
• Collaborated closely with cross-functional teams to ensure cohesive branding and messaging across all marketing channels.
• Maintained a keen eye for market trends and audience preferences, continuously refining content strategies to drive maximum engagement and conversion.

Selangor, Malaysia

Bachelor'S Of Business Analytics, Second Upper Class

I have learned the theory & fundamental skills of being a business analyst with many hands-on studies of data analysis and data mining.

Diploma In Business Administration

I’ve learned the theory of the core basic roles & responsibilities of an admin in a business, which includes HR Management, Marketing.

11

8-11

4

1-3