Wei Pan Email & Phone Number

Guangzhou, Guangdong Province, CN

Guangzhou, Guangdong, China

• Rationalized structured data in a Banking and Financial Reporting context, using SQL stored procedure integrated with Coric application suite to generate investment performance reports
• Built data models and PoC to assist project manager to validate requirements; coordinated team’s development works to production release and held reputation to quickly respond on urgent data issues
• Practiced Agile methodology and DevOps journey on a daily basis, familiar with Continuous Integration / Continuous Deployment (CICD) pipeline to automate and streamline change deployment process
• Appointed as many roles (presenter, designer, coordinator, BA) to showcase departmental deliveries to senior management or HSBC global presence

Tucson, Arizona Area

• Consulted interface design for Self-Service Portal, enhanced user experience of 14,000 employees
• Conducted surveys to 500 target users and created product backlog with prioritized user stories
• Reviewed 4032 tickets to refine ticket categories, revamped knowledge management under ITIL framework
• Increased 25% usability of Self-Service Portal in result of decreasing ticket submissions

Tucson, Arizona Area

• Systemized company’s operation model from Excel to Oracle SQL, covering client, employee, contract management and so on, centralized information in one for better resource planning
• Delivered the final project in time by managing project timelines and work distributions within the team, ensured quality by constantly communicating with client’s expectation
• Designed Entity Relationship Diagram with high complexity and translated technical terms to business terms for mutual understanding across 4 teams, eventually transformed the ERD to Oracle SQL
• Became the only project in class that had client publicly announced their recognition, kept long-term connections

Hangzhou, Zhejiang, China

• Achieved 12% increase in conversion rate in B2B outreach marketing through data-driven strategies
• Analyzed firmographic data, defined needs-based segmentation and provided tailored value propositions
• Revised marketing contents to target segments for the use of 52 sales representatives

Hangzhou, Zhejiang, China

• Assessed credit risks for 8 large-scale companies to reduce potential bad debts of loans
• Measured the 5 C’s of credit for each company to assist lending decision for over 500 Million RMB
• Coordinated and assisted in-person interviews with borrowers to validate information authenticity

Master'S Degree, Management Information Systems, General

Bachelor'S Degree, Management Information Systems, General