Phi Ho Email & Phone Number

Livermore, California, United States

● Create SSIS packages and Python scripts that automate tasks (e.g., generate files, transfer files,email files, and data ETL).● Create BI solutions for departmental metrics.● Create and maintain SSAS tabular models for Power BI and Excel.● Design, modify, and deploy SSRS and Power BI reports.● Create indexes, store procedures, views, tables, and roles for new databases.● Review alerts and logs for break/fix and system improvement.● Perform requirements gathering, code reviews, code releases in an agile development environment.● Developed Salesforce integration to load data into a database for BI using Python.● Developed Form.com integration for BI and document generation for customer onboarding processusing Python.● Created a web service for a custom site using Python.● Developed integration that bridges Salesforce and Xifin using Python.● Implemented new systems (e.g., iSynergy, CareVoyant, Salesforce, Form.com).● Participate in daily SCRUM meetings and provide status on assignments.● Design and create new databases for new applications.● Submit change requests to change board for approval and apply changes.● Develop and maintain codes using SourceTree and Bitbucket.

• Analyzed over 250MB of data and identified the variances in the Cash Adjustment account that reconciled the account for the first time in a year.• Wrote a macro and implemented a new process in compiling GL numbers for internal auditors that eliminated a step in a three steps process.• Accustomed to three different database systems to investigate transactions and accounts from various subsidiaries to fulfill the biggest departmental audit request from KPMG.

• Trended sales figures and advised Director of Operations on operational decisions, adjusting production to meet demands.• Learned Fishbowl software to assist in the implementation of an inventory tracking process that tracked inventory movement and count.

• Created a comprehensive macro that gathered, processed, and plotted data for the OPG trading strategy, increasing research efficiency by over 75%.• Researched and analyzed stock prices to discover new trading opportunities for statistical arbitrage trading strategy.• Utilized Excel formulas in auxiliary with streaming data feature to create a master file and analyzed technical data from NYSE, NASDAQ, and AMEX in real-time.

• Assisted students and faculty members by troubleshooting their computer related problems. • Repaired computers and printers for the College of Business.• Provided clerical support by answering phones, administering lab availability schedules, and overseeing lab shutdown.

Business Administration, Corporate Finance, Financial Services

• Dean's List • Governor's Scholarship Award

Education record

Education record