Andy Yu Email & Phone Number

Irvine, Ca, Us

Irvine, Ca, Us

Irvine, Ca, Us

* Developed Tableau reports by collaborating with leadership and various departments* Collaborated closely with the Director of Decision Support to develop and enhance the School of Medicine's data warehouse used for financial and employee analytics.* Created data models to support the self-service business intelligence needs of the School of Medicine* Lead individual projects and provided consultation services to various departments.* Decreased data warehouse cycle 40% by performance tuning ETL process.* Reduced manual data processes 50% by creating SSIS packages* Managed and maintained Tableau Server for over 200 users.* Led training sessions to business analysts to assist with creating their own Tableau reports.

* Developed and designed processes using Informatica Data Quality (IDQ) to standardize, cleanse, and match records to prevent duplicate records being created.* Created, tested, and validated results of various Cognos reports relating to the University's campaign business goals* Discussed with end users to define data elements for reports and design appropriate report solutions.* Developed ad-hoc queries for department end-users and assisted with production related issues relating to reports.* Collaborated with DBA to create stored procedures and views for reporting purposes for SQL Server 2008 and Oracle databases.* Created and tested new and existing Informatica mappings and workflows using PowerCenter and Workflow Manager for data warehouse processes and data integration.* Developed UNIX shell and Windows batch scripts to automate execution of various processes.* Programmed and documented quality assurance scripts using QTP for regression testing PeopleSoft application.

Montreal, Quebec, Ca

Los Angeles County Payroll and Human Resource Project* Wrote complex SQL queries to extract employee personnel and payroll related data used by various County departments and external vendors.* Developed and designed 30 system interface programs for the Los Angeles County Human Resource and Payroll system to retrieve and send personnel and payroll related data to over 60 external vendors.* Designed, developed, tested and implemented 34 conversion data maps to migrate legacy data for over 100,000 employees.* Planned, coordinated, and worked with client to update 13 system interface programs affecting employee payroll data sent to 14 external vendors.* Assisted with monitoring of data warehouse and updates to ETL software.* Discussed with business process owners to gather requirements and create specifications for detail design documents.* Worked with users and functional team to develop and execute test scenarios in various phases of testing (e.g., Integrated System Test, User Acceptance Test, and Performance / Simulation Test) and documented any defects found.* Created ad-hoc SQL reports and data extracts to assist users for data verification during data conversion* Created UNIX shell and Perl scripts to automate system interface processes.* Trained new team members with application tools used and assisted them with functional knowledge of the application.* Conducted and provided training sessions and knowledge transfer sessions to client technical team.* Provided cutover and post-implementation support to clients.Los Angeles County Inventory Management Project* Created 6 system interface programs for the County of Los Angeles to manage inventory resources across various departments.* Developed and designed 5 PDF forms used by County departments.* Discussed with clients to gather business requirements and wrote specifications for functional designs.

Pasadena, Ca, Us

- Performed regression testing to ensure all user requirements met functional specifications.- Documented defects found while testing requirements and communicated with developers to ensure resolution.

Los Angeles, Ca, Us

* Developed reports using Crystal Reports based on user’s functional requirements.* Wrote automated test scripts for regression testing of an internal application using WinRunner.* Communicated with technical and functional team members to make updates to end user processes and procedures.