DataLemur

⚙️ SQL Query Development & Schema Design
• Demonstrated expertise in SQL by writing over 100 SQL queries for coding exercises.
• Experienced in designing and structuring data schemas and datasets that align with the learning objectives of SQL coding challenges.
• Wrote comprehensive documentation, providing step-by-step explanations to enhance the users’ understanding of solving the SQL challenges.
• Conducted rigorous quality assurance testing to refine problem statements, SQL code, and documentation for improved clarity and precision.

📝 SQL Tutorial Author | https://datalemur.com/sql-tutorial
• Authored SQL tutorials and communicated technical knowledge effectively, enhancing readers' data analysis skills and showcasing strong analytical and communication skills.

🔑 Key Accomplishments
• Played an integral role in the development, launch, and ongoing growth of author Nick Singh's data science platform with a (growing!) user base of 100k users within a year.
• Proactively moderated user feedback, ensuring a seamless user experience with a 24-hour turnaround time for addressing queries, and boosting customer satisfaction and retention.

SQL Consultant | Technical Content Author

Food Market Hub

🛠️ Data Pipeline Development
• Designed a data pipeline from data extraction and processing in Python and BigQuery, to a sales development dashboard in Tableau and integration with Google Sheets for easy viewing.
• Streamlined workflows and improved efficiency through implementation of best practices for sustainable data collection and analysis.

👩🏻‍💻 Data Collection and Analysis
• Led weekly analytical reports for operational teams resulting in a 20% improvement in team performance and efficiency.

📈 Dashboard Creation and Reporting
• Created an interactive investor reporting dashboard for monthly business and operational metrics updates.
• Provided insightful performance results, including monthly active accounts, customer acquisition cost trends, and churn rates to senior management and investors.

Business Intelligence Analyst

Tricor Group

(Merged with Axcelasia in Jun 2020)
Research and Problem Solving
• Enhanced operations efficiency by redesigning accounting processes and automating work procedures by collaborating with other departments and empowering team members
• Improved efficiency of preparation of stock reports by 70% using automation
• Increased accuracy of management report by through dual rounds of managerial review
• Supported clients with Covid-19 initiatives on application to operate during MCO 1.0 lockdown and wage subsidies resulting in earlier business operations and 15% wage savings

Communication and Customer Orientation
• Built relationships with new clients, negotiated meetings, and responded to all questions or concerns within 24 hours
• Explained complex accounting issues in simple, layman terms verbally and in written communication
• Improved provision of information and served as liaison between audit, tax and secretarial departments

Leadership and Organization
• Managed a portfolio of 25+ clients and directed a team of 3 staff by effectively organising financial and accounting reporting and meeting deliverables deadlines ahead of schedule
• Coordinated internal restructuring for merger and led discussions with Payroll and IT on handover of knowledge and integration of systems

Manager, Accounts

• Supported clients with Covid-19 initiatives including application of MITI license to operate during MCO and wage subsidies (“Program Subsidi Upah)  
• Oversee and manage clients’ financial and accounting reporting activitiesincluding treasury, human resources, payroll and administrative
• Timely submission of yearly and monthly accounts, statutory contributions (EPF, SOCSO, EIS, PCB), service tax and withholding tax
• Experienced in full-set accounts using Sage UBS Accounting software
• Effectively plan year and monthly financial and accounting reporting for clients
• Directed a team of 3 staffs with efficient utilization of staff resources and allocation of clients
• Successfully cross-sell internal tax and secretarial services to clients

Managing Consultant

Senior Consultant

AmBank Group

• Responsible for accounting reconciliations, GST submissions, and review of staff claims and company expenditures

Senior Executive, Finance & Strategic Management

PwC Malaysia

• Performed external audits and statutory audits for public listed and SME clients in airline, property, semiconductor, and trading industry.

Audit Associate

Baker Tilly Malaysia

• Conducted external audits for SME clients in furniture, property, and trading industries.

Hello, I'm Katie from Penang! 🏝️

My career journey: Accountant --> Data / BI Analyst --> Data Engineer

🐒 As a SQL Consultant at DataLemur, an online platform specialising in SQL and Data Science Interview Questions, I wrote more than 100 SQL queries, designed data schemas, and authored technical tutorials on SQL functions. 

📊 Prior to this, I was a data analyst at a SaaS startup, where I designed and implemented ETL pipelines from data extraction and manipulation in Python and Google BigQuery, to the creation of dashboards in Tableau.

👩🏻‍💻 I'm also a chartered accountant with 7 years of extensive experience encompassing various domains such as auditing at PwC, banking, accounting, and HR and payroll services.

⚒️ Skills and Technologies
• Language: SQL
• Data Warehouse & Database: Google BigQuery, MySQL
• Spreadsheet: Excel, Google Sheets
• Business Intelligence: Tableau, Looker
• Technologies: dbt

Portfolio: https://github.com/katiehuangx/Portfolio-Guide/blob/main/README.md

Taplio

Katie Huang, FCCA's Linkedin Analytics

Katie Huang, FCCA

Want to drive more opportunities from LinkedIn?

Taplio

.css-1jgreyo{background-image:linear-gradient(284deg, rgba(39,43,72,1) 0%, rgba(33,47,183,1) 100%);color:transparent;-webkit-background-clip:text;background-clip:text;}Katie Huang, FCCA's Linkedin Analytics

Katie Huang, FCCA

Want to drive more opportunities from LinkedIn?

Katie Huang, FCCA's Linkedin Analytics