Mengchen Qu Email & Phone Number

Irvine, California, United States

Led communications with department leaders and engineering teams at WhoisXML for the database migration to AWS project, delving into business requirements and technical challenges to determine migration strategies.Designed and executed an automated data processing pipeline for transferring and transforming data from the original database to AWS S3 buckets, ensuring data security and integrity. Collaborated closely with the QA team to maintain high standards and accuracy during the data migration process.Leveraged AWS Lambda, API Gateway, and Cognito to develop secure data access points and robust user authentication systems, enhancing data access flexibility and system security through pre-signed URLs and token-based API access.Developed a real-time dashboard to monitor the progress and performance of data migration, providing key project insights to the management team.

Plano, Tx

Met with operational leaders and senior engineering managers to understand business operations and collect business challenges, identified electricity scope for model standardization and implemented the digital solutions in building analytics frameworkImplemented automated data ingestions and transformation pipeline in SSIS to extract historical usage data from SAP HANA and migrate to OLAP database for analytics purposes, collaborated with QA teams on data validations and productionsTrained Feature Selection to prioritize member, usage, and transactional attributes and applied Augmented Model to classify customer groups and generate the lower and upper boundary to produce dynamic threshold for utilization performances analysisPartnered with business and DevOps teams to design appropriate views, add calculated fields and dynamic parameters, and develop Tableau Executive and Detailed usage dashboard to track and compare the customer activities and utility performancesCreated the root cause analysis across electricity systems based on abnormal activities reflected in the daily dashboardDeveloped Time Series model in Python to monitor and forecast usage seasonality data to track customer behaviors regarding electricity utilization, this forecasting model helped leadership teams to prevent utility stealing activities

Orange, Ca

Generated go-to-market strategies to incorporate model results with business summary to deliver the customized marketing, operations, and customer strategies within network marketing channels and segmentations, resulting in revenue increase by 20%

Dongguan, China

Interfaced with the investment team, financial team, and technical teams to ensure delivery of financial requirements and evaluate the risks of investment packages under bank policy changes, designed the portfolio criteria for customer investment plansGathered clients’ investment goals and adjusted the risk from business and personal purposes such as small business, education, retirement, and other financial products, documented client profiles monthly for checking/saving accounts to build relationshipsDetermined the short-term and long-term goals for investment strategies, and customized the investment plans to valued customers, and follow up with individuals to increase 30% customer satisfaction rates under overall financial center experiences in Grand ChinaWorked closely with branch managers and customer relationship managers to document the customer needs and create the reports regarding the customer investment details, generate the investment promotion plans to help branches to reach investment goalsWorked closely with financial advisors at Bank of Dongguan headquarters to document and prepare the investment plans with keys to sale to provide customers with accurate and valuable information to make next-phased decisions

Master Of Science - Ms, Business Analytics

Activities and Societies: The Predictive Power in Marketing Analytics project, Orange, CA Florida Hacks with IBM Project of Saving Energy.

Bachelor Of Science - Bs, Computer Science And Mathematics