Kay Chan Email & Phone Number

Pueblo, Colorado, United States

Data and Application analyst

Colorado Springs, Colorado, United States

Boulder, Colorado

Manages the membership program at the Access Fund, including database management, membership drives, member renewals, and member rewards. It is the main point of contact for all membership related questions, including the monthly donation program.

Princeton, Nj

Analyze current business systems and data to recommend, design and implement automated systems and processes to improve and business processes.Successfully designed, developed, and launched an automated database application that enables finance and sales to validate customer data to identify sales trends, pay monthly administration fees and customer rebates based on contracts. The automated system also enables sales to manage sales representatives' territory ownership by zip code and additional customer/product exceptions. >> Database Programmer: responsible for developing database application, report automation, and integrating applications to existing/new databases• Develop processes via MS Access, VBA script, and SQL to import and process customer sales data.• Analyze data to ensure data accuracy• Develop automated and Ad hoc reports that ensures accurate payments of fees and commissions >> Project Manager: responsible for the project life cycle of application and automation release• Define and translate business requirements into technical specifications• Liaison between the various business units, technical team, and 3rd party vendors• Ensuring that all task are met in a timely manor and address any critical issues that may arise.• Responsible for project timelines and ensuring that all stakeholders are kept informed of the projects progress• Responsible for implementing, documenting, training and user testing acceptance

Greater Los Angeles Area

Business analyst responsible for obtaining business requirementsIT Project Specialist responsible for developing project plans with dependencies.Project Manager responsible for ensuring that project timelines are met by all parties and any critical issues are addressed in a timely manorFollowing up with all parties regarding their responsibilities within the projectsLiaison between the business and technical teamSystems analyst responsible for translating business requirements to technical requirements and ensuring that the programming/contractors meet all requirementsData Analyst responsible for internal clients’ data Data Analyst responsible for adhoc reporting via SQLData Analyst responsible for automating data validation via Excel and/or SQLData Analyst responsible for assisting clients in troubleshooting issues regarding data management systemData Analyst responsible for providing training regarding the data management systemCreated documentation for end users on how to use the data management systemProvide training on current system as well as new enhancements

Parisppany, Nj

Created customized reports based on client request/business needs Business Analyst responsible for gathering business requirementsSystem Analyst responsible for translating business requirements to technical specifications Project Manager responsible for ensuring that the programming team complied with the documented requirements in a timely manorPrioritized business requirements based on the individual business impact and the company as a whole.Provide documentation and training as needed on any new enhancement, existing functionality and/or new application.Assisted in QA’ing and analyzing of the new functionality and/or application and providing feedback in a timely manner.Provide technical and business support as the subject matter expert on the application.Developed and Collaborated in enhancement/application role out.

Florham Park, Nj

Built and managed daily, weekly and monthly reports to be analyzed by management to determine sales trendsBuilt web application and automated reports that read, updated, and deleted data from Access and SQL databasesManaged numerous databases that enable users to collect, report, and modify data that can be used and analysis at any given time. Created customized reports based on client request/business needs Created dynamic data-driven web pagesDetermine, prioritized and translated clients’ business needs and objectives. Developed custom web pages using Salesforce.com’s APIs and custom objectsConfigured Salesforce.com to meet the needs of the field.- Customized and developed automated reports within Salesforce.com- Page layout design- Created user profiles within Salesforce.com: Roles vs. Profiles vs. other User criteria for security- FLS - Field level security- Roles, Profiles and other User criteria for securityProject Manage 99% of the application development, automated reports and website.Performed sufficient testing to verify a completed project’s accuracy, reliability and functionality before releasing it to production.Continue to create enhancements and modifications to the web site; organize and maintain the site; assess new standards, technologies and trends, and formulate strategies and plans for enhancing the site; maintain cross-platform. Assisted 1st and 2nd level support in troubleshooting issues pertaining to website content and application.Built applications that assist 1st and 2nd level support in their daily operations. Decreasing the cost and time in resolving a sales associate’s questions and/or problems. Assist in Diagnosing/Troubleshooting other intranet websites within the organization.Interact with various other departments and application to ensure a quality up-to-date product is produced.

Parsippany, Nj

Desktop hardware and software supportLaptop hardware and software supportAutomated CRM reportsCreated adhoc reports via the CRM system

Ms, Management Information Systems

Bachelor Of Science - Bs, Business Administration And Management, Information Systems

Bs, Business

Activities and Societies: Alpha Kappa PsiMember of Alpha Kappa Psi, Computer lab Assistant and MSU Phone Operator