Alan Lui Email and Phone Number
Alan Lui work email
- Valid
- Valid
- Valid
Alan Lui personal email
- Valid
- Valid
Alan Lui phone numbers
• Eight years of report writing and developing experience on ERP system by using Oracle Business Intelligence Discoverer and Evisions ARGOS on Ellucian Banner Finance and HR.• Three years of experience in analyzing, designing, and developing Business Intelligence and reporting solution by using Banner Extract Transform Load (ETL) Tool, Oracle Business Intelligence Enterprise Edition (OBIEE), Discoverer, and Evisions ARGOS on implementing ODS (Operating Data Store) / data warehouse for Banner Finance and HR.• Ten years of experience in using SQL on data analyze and data manipulate.• Experience in reporting and functional support especially on billing system, finance system, Banner Finance, Banner HR, credit card approve system, and, on-line payment process system.• Three years consulting experience working for Amdocs Inc. as a Subject Matter Expert to provide application support and system development on their billing and collection module at Pacific Bell Telecommunication company.• Experience in designing complex reports and ad hoc reporting for financial management system and high volume on-line transaction reports.• Strong at understanding, studying, and, transforming business data, business functionality, and business rules to programming logic for reporting.• Experience with working with various vendors and industry sectors to define and develop interface / APIs with SaaS Company, payment gateway, payment lockbox, Credit Bureaus, and banks.
The J. David Gladstone Institutes
View- Website:
- gladstone.org
- Employees:
- 585
-
Functional And Technical Analyst And Data AnalystThe J. David Gladstone InstitutesSan Francisco, Ca, Us -
Functional & Technical Analyst / Data AnalystThe J. David Gladstone Institutes Dec 2005 - PresentSan 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.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 -
Risk Analyst - Head Of Risk ManagementQuestnet Sep 2004 - Jul 2005Hong 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
-
Subject Matter ExpertAmdocs Jan 2001 - Mar 2004As 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 -
E-Commerce DeveloperCreditland Inc Nov 1999 - Nov 2000San Francisco Bay AreaAs 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
Alan Lui Skills
Alan Lui Education Details
-
Computer Information System -
Economics
Frequently Asked Questions about Alan Lui
What company does Alan Lui work for?
Alan Lui works for The J. David Gladstone Institutes
What is Alan Lui's role at the current company?
Alan Lui's current role is Functional and Technical Analyst and Data Analyst.
What is Alan Lui's email address?
Alan Lui's email address is al****@****one.org
What is Alan Lui's direct phone number?
Alan Lui's direct phone number is +1 415-734*****
What schools did Alan Lui attend?
Alan Lui attended California State Polytechnic University-Pomona, San Francisco State University.
What skills is Alan Lui known for?
Alan Lui has skills like Computer Program, Databases, Finance, Sql, Project Management, Software Development, Systems Analysis, Requirements Analysis, Business, Data Analysis, Windows, Analysis.
Who are Alan Lui's colleagues?
Alan Lui's colleagues are Gui-Qiu Yu, Shijie W., Yasaman Mortazavi, Kanchan Sarda, Reshmi Tognatta, Zohreh Faghihmonzavi, Shanyi Sandy Feng.
Not the Alan Lui you were looking for?
-
1boeing.com
-
2gmail.com, ga-asi.com
-
3gmail.com, ucdavis.edu, boeing.com
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial