Amber Huang

Managed and developed large distribution solutions across Azure, AWS, and on-premises environments for various clients.

• AWS Serverless ELT System: Designed and maintained a scalable, serverless ELT pipeline that extracts data from multiple sources into a centralized data warehouse, utilizing AWS services such as EC2, RDS, Athena, Lambda, and Step Functions. This solution streamlined the generation of financial reports for users and was optimized to manage increasing data volumes over time.
• Business-Critical Websites: Developed and maintained three essential WordPress websites with integrated databases, ensuring seamless resource access across business units. Implemented resilient CI/CD pipelines and disaster recovery solutions with Jenkins and Docker to minimize downtime for critical systems.
• Azure Data Transformation: Built and supported data transformation workflows using FiveTran, DBT, Snowflake, and Hightouch, enabling business users to query customer data from various systems and generate financial reports in PowerBI.
• Security & Monitoring: Led design and implementation of monthly patching and monitoring solutions, addressing recurring penetration testing issues to ensure security and compliance across all environments.
• Training and Mentorship: Delivered training sessions to both internal and external users. Mentored junior team members, providing guidance and support to enhance their skills and confidence in their roles. Fostered a collaborative learning environment.

• Payment Return System: Contributed to the development of the Casi system for creating, managing, and tracking payment issues, enhancing investigation processes as part of the NPP solution.
• SharePoint Business Sites Development: Collaborated with key stakeholders to design and implement SharePoint sites, enabling access to essential resources.
• Cloud Migration to Azure: Planned and executed the migration of on-premises infrastructure to Azure. Designed, built, and deployed Microsoft solutions centered around Azure, including the Enterprise Mobility Suite (EMS), Identity and Access Management, and corporate applications.
• Settlement Transaction System: Maintained and managed a settlement transaction system for the internal settlement and financial teams, facilitating daily reconciliation processes and cash flow report generation.
• User Training and Support: Provided user training and technical support for business-critical applications across multiple systems and platforms for ASL staff and members.