Yanling Chen Email & Phone Number

Remote

• Led the design and deployment of a Missing Claims Dashboard and Alarm System using AWS CloudWatch and a daily-executing Lambda function. This system systematically queries missing claims data from the AWS Redshift database, emits missing claims metrics to AWS CloudWatch, and triggers an on-call pager alert when the aggregated data exceeds a specified threshold.• Developed SQL queries to retrieve virtual healthcare missing claims data.• Successfully implemented a Lambda function, configuring database secrets and managing IAM permissions to enable seamless access to essential data within the AWS Redshift database.• Configured a CloudWatch Cron job to run the Lambda function daily, dispatching missing claims metrics into CloudWatch on a regular basis.• Established precise CloudWatch alarms correlated with missing claim metrics, implementing automated triggers to activate on-call pager duty when metrics reached predefined thresholds.• Assisted the database team in resolving Redshift IP restriction issues across multiple VPCs, enhancing network security and database access.• Successfully executed the integration of medical claims charging feature.• Collaborated with the product manager to define project scope and timelines, implementing new features based on client and product manager requirements while addressing and resolving client and stakeholder concerns.• Collaborated with the technical project manager to proactively identify and remove technical blockers, while reassessing the priority of tasks to ensure smooth project progression and timely resolution of issues.• Created and maintained technical documentation on Confluence to ensure the project remained up to date.• Engaged in comprehensive debugging, conducted meticulous code reviews, fulfilled on-call pager duties, ensuring software reliability and efficiency in production environments. • Provided dedicated production support, swiftly addressing issues to maintain optimal system performance.

Salt Lake City, Utah, United States

• Analyzed historical data on freight forwarders' rates, import times, and past performance to evaluate and select the most efficient and reliable options, ensuring optimal import operations.• Designed and managed import plans considering terms, rates, and urgency to optimize logistics operations.• Stayed current with evolving import regulations, continuously adjusting import plans to ensure compliance and efficiency.• Managed multiple import projects simultaneously, closely monitoring each project from initial quotation to completion, and provided regular status updates to sales/stakeholders to keep them informed.• Coordinated seamless with customers, freight forwarders, customs clearance agents, railways, and trucking companies to ensure a smooth import process for each project.• Managed Walmart warehouse reefer import project for over 400 containers per year, ensuring timely and efficient delivery.• Organized local/cross border truck deliveries, collaborating closely with trucking companies to prioritize and avoid cargo detention.• Created and updated SOPs for each import project to ensure consistency and efficiency.• Cultivated strong customer relationships by addressing inquiries, explaining and providing solutions for complex situations such as weather delays, rail congestion, and document discrepancies, resolving issues promptly to minimize disruptions.• Reassessed project timelines and costs in collaboration with the sales whenever changes to the project plan occurred.• Verified costs against quotes, resolved discrepancies, and actively participated in dispute resolution to ensure accurate invoicing and financial clarity.• Completed comprehensive job invoicing by the end of each month, ensuring accurate financial records and timely payments.

Salt Lake City, Utah, United States

• Meticulously processed branch documents in strict adherence to compliance guidelines and regulations. Ensured accuracy and completeness in document handling, maintaining regulatory compliance standards.• Effectively addressed and resolved diverse challenges encountered within branch operations, demonstrating adaptability and problem-solving skills to ensure smooth functionality.• Developed comprehensive team criteria founded on personal performance benchmarks, leveraging analytical insights to foster a high-performance culture and guiding team members towards achieving excellence.• Devised and implemented a proprietary methodology aimed at boosting overall performance. This innovative approach led to measurable improvements in efficiency and productivity across operations.

Shanghai, China

• Developed and utilized international networks to procure machinery in line with precise customer specifications.• Led procurement project, orchestrating commercial contract negotiations, budget management, international payments, remote inspections, freight coordination, customs clearance, and local delivery arrangements.• Led and oversaw the bidding project for importing Ferrari spare parts into China.• Led the company’s overseas B2B website project, maintained and optimized Seach Engine Optimization (SEO) strategies on website, enhancing online visibility and driving business growth.• Actively engaged in communication with sales and stakeholders, building strong relationships with customers and vendors to facilitate smooth interactions and enhancing customer satisfaction.

Shanghai, China

• Offered professional import advice while crafting import plans, leveraging expertise to optimize import operations and enhance efficiency.• Managed multiple import projects simultaneously, carefully selecting suitable freight forwarders based on rates and timelines, and actively monitoring cargo movements to ensure on-time deliveries.• Collaborated closely with customs clearance agents to ensure smooth import processes and compliance, facilitating the seamless importation of goods.• Built a customs database using historical customs appraisal tariff data, enabling more accurate predictions of import tariffs and helping customers estimate costs effectively. • Managed budget and risk by successfully navigating import emergencies such as unforeseen high import tariffs or delays, implementing effective solutions to mitigate impacts.• Completed comprehensive invoicing for each project, ensuring accurate financial records and timely payments.

Software Development, Computer Software Engineering, 4.0

Bachelor'S Degree, Marketing

Bachelor'S Degree, Business Administration And Management, General

Bachelor'S Degree, Marketing

Bachelor'S Degree, Business Administration And Management, General