Alan Lui Email & Phone Number

San Francisco, Ca, Us

San Francisco Bay Area

• Responsible for reporting solution, ODS, ETL process, and enterprise data subjects in Ellucian Banner.• Functional support on ERP - Banner Finance and Banner HR especially on finance system: -Basically, responsible for providing reporting, programming and analytical support for various enterprise systems including Ellucian Banner Finance, Grants, Purchasing and Human Resources, and Ellucian Banner Operational Data Store (ODS) data warehouse. Ancillary system support includes the Evisions Argos, FormFusion and Intellecheck suite, and third party data interfaces and integrations. The duties of this position include maintenance and enhancement of existing system functionality, development of new applications and interfaces, and automation of processes.• Implementing a new enterprise reporting solution – Evision ARGOS to replace the legacy reporting tool - Oracle Discoverer for our ERP system - Banner Participated in the new reporting tools evaluating process and learned the new report tool As the enterprise data expert helped users understand the enterprise data and functional requirements to match with the new reporting capabilities  Converted over 100 reports within 8 months Enhanced the old reports to use new reporting features such as OLAP (On-line Analytical Processing)  Develop new data mappings and Data Blocks for report writing Develop Financial Dashboards for Purchasing, AR, and AP, and GL units  Designed and implement new report security Assisted our Accounting Director and key users on report testing and data verification Trouble shooting and error fixing on ERP operating data vs. ODS data issues Provide classroom training on teaching the new reporting tools and compiling both converted and new reports

Business Intelligence Solution, Enterprise and Finance Reporting, ODS Support, ERP System Support

Hong Kong

• As a Risk Analyst, I led, interfaced, and liaised with different departments, clients, technical and non-technical users on various new/change payment solution for their on-line transactions.• Developed reports, rules, and systems to work with various internal departments to monitor the on-line payment process • Worked with outside payment gateway to setup Risk Management business processes and reports to mentor e-commerce interface data

San Francisco Bay Area

As Subject Matter Expert consultant I provided application support and system development for Pacific Bell telecommunication company.• Supported on Financial application to work as on-site support to investigate on on-line applications, interfaces, and Data Mark batches errors of the Billing and Collections Cluster (BCC), which combines billing, collections, accounting functions, and financial reporting with Oracle Application technology for Pacific Bell Telephone Directory.• Provided data analysis and reporting on AR Payment Lock-box files feeding nightly batches by develop stored procedures in Oracle database to create financial reports and error checking • Developed complex stored procedures, functions, triggers and views in support of the purchase history, product history, and payment logs in the BCC within the CRM system. • Created design documents, functional specification documents, design and execute test plans/cases and production deployment documents.• Collaborated and partnered with clients to develop use cases for functional and user acceptance testing

San Francisco Bay Area

As a key member of the data engine team I was responsible to monitor and analyze the credit report interface data and custom portfolio data for on-line credit approval • Maintained several key data interfaces between the credit bureaus and the in-house Credit Approval Developed Decision Engine and reports by developed PL/SQL package in the database• Utilized MS Query to gather interfaces data, site activities data, or on high risk Customer Credit Reports data to build management reports for Decision Engine Team and marketing decisions reports for marking business need.• Troubleshoot and defined any system error between Oracle databases, the Capstone financial software, interfaces, or outside vendor system issues, then produce detail log of the resolution for the development team. • Acted as user key interface between business users and programming team members• Work with cross-functional teams and outside vendor such as credit bureaus and FICO to define and document key data interfaces between production storefronts and Loan Decision Applications

Bachelor’S Degree, Computer Information Systems

Bachelor’S Degree, Economics