I am in charge of the data analysis and reporting for 330+ million square feet of commercial real estate in the Silicon Valley market. I created and manage the reports that are behind the monthly, quarterly, and yearly reporting statistics using advanced analysis with SAP Business Objects Crystal Reports, Microsoft Excel (Vlookup, Pivot tables) and Microsoft Access.In my time at Colliers I have reduced the monthly reporting time frame from weeks to 1 day. I have accomplished this through reporting efficiency & better data management while increasing accuracy. I have created a vast set of reporting metrics that has increased the accuracy and reliability of the proprietary database using crystal reports. I also do ad-hoc reporting with Excel & Crystal Reports for 90+ brokers & clients on a daily basis under tight deadlines.

Prepare & audit daily, monthly, quarterly, and yearly reporting statistics for the Silicon Valley Market. I work with brokers on a one on one basis creating customized reporting for their clients needs. I also prepare standardized reporting on a monthly, quarterly, & yearly basis. I created a historical database of the Silicon Valley market to be able to assemble and create historical reports with ease. Most of my day to day activities are centered on database creation & report creation in the department using MS Access, Excel and Crystal Reports.

Experience in preparing and enhancing daily, weekly, monthly operating reports for senior management while maintaining data integrity. Maintain and develop public website and database for repossession subsidiary. Created Microsoft Access database for invoicing and tracking sales for repossession subsidiary. Prepare all lease documentation from application to funding. Document all restructures and deferments. First level of support for all information technology requests

Prepared all commercial lease documentation for transactions from 100k to 3MM. Managed and coordinated transition from paper file to online database project which consisted of over 7k lease files. Created reporting to increase turn around time for $15mm in repossessed assets. Operational duties included calculating lease payoffs and desktop / network computer support.

Successfully managed 3 vendor relationships which included documenting transactions, auditing lease documents, and preparing them to sell to a funding source. Coded lease documents for online database to auto populate fields creating efficiency in documenting new transactions. Managed all desktop / network / website support for Arrow