Manage report requests and requirements for Risk/Compliance and Departments. Specialize in automation of converting data reports into tools to identify errors and action items. Created an electronic reporting system when Covid required 90% of our staff to work from home and were unable to print reports. Utilized Power Query to enable connecting reports from our multiple systems in response to FDIC requirements. Working with SalesForce reports and Tableau as we are migrating systems to SalesForce.

This is a small but dynamic IT team. Staffing has varied from 7-9 people, but covers Data Center Infrastructure, OTS Enterprise Applications, SW Development, Reporting, Project Management, Facilities, Security, and HelpDesk Support for over 200 people and 90 Applications/Servers/Services.In the last 2 years, we've implemented a modern ticketing, project management, and documentation systems using Atlassian Jira and Confluence products. This had really paid off when the team has been at lower levels and when there have been major projects. We've managed an expansion of our offices to add ~70% additional seats by acquiring the remainder of the floor. As well, Budgets have always be right on target.My main focus for IT is to maximize operational performance/profit for the company while trying to minimize IT costs through efficiency and process improvement.

Responsible for upgrading database systems, monthly reporting, and improving financial/accounting operations efficiency. Limited time with department due to taking IT AVP position within Financial Pacific.

Responsible for Operations of "Sample It" startup product. Managed inventory and ordering for 10 sites across multiple states and from multiple production locations. Developed sales forecasts around new products, marketing initiatives, and normal operations.

• Defining key performance indices.• Organize, synthesize, and analyze data and metrics to develop recommendations.• Redesigning reporting methods to reduce time and improve accuracy. • Utilizing SQL Queries and Excel to obtain and manipulate data.• Documenting processes, analyses, and data definitions/sources.• Writing technical requests for changes to data analysis platforms.

I was in charge of the Corporate IT environment and Facilities for AudienceScience. I transitioned to this in 2010 when the company had leases expiring for the New York, Bellevue, Santa Barbara, and London offices. Additionally the company acquired companies in Germany and San Francisco. For each of the domestic leases, I managed the site selection, leasing process, move, and location set up. After the moves, I managed the contacts with the buildings, and any vendors for the office. For the international locations, I reviewed these same aspects to ensure the move process went smoothly. For all locations, I was responsible for the IT environment: wiring, server room, and connectivity.For Corporate IT, my role was managing the help desk team, budgeting, capital purchases, software licensing, inventory management, and asset disposition. Additionally, our team was responsible for the network and server equipment in each office and their connectivity, as well as the centralized data centers.

• Managed team of six that ran our 24x7 production environment. This covered four customer facing and one processing data centers, which amounted to 35 racks and over 500 equipment nodes in the US and Europe.• Developed and maintained capacity model using databases and spreadsheets to implement changes and work with other departments to ensure operational capacity was available. Reviewed incremental growth, seasonality, customer onboarding, failover, performance of releases, and many more items.• Managed team project to create our “Data Center in a Rack” to replace the sprawl in our customer facing data centers:o Reduced equipment footprint and costs by 50%o Doubled our capacity o Reduce overall customer latency by 25%• Utilized monitoring systems and dashboards to ensure redundancies were maintained within and between customer data centers. Created dashboard and process for 24x7 operations team to monitor each shift and report on any variances.

• Managed CorpIT and Data Center infrastructure.• Maintained ISP Contracts• Create department budget and CapEx plans

• Tracked and managed corporate assets• Acted as project manager for office and data center moves. • Create department budget and CapEx plans

• Acted as project lead in the development of long-range plans regarding expansion, procedures, staffing, equipment, vehicles and products at multiple locations. Included analysis, development (using GIS), implementation, monitoring and maintenance of project to minimize routes dispatched day• Provided feedback and evaluation to management in order to maximize efficiency and productivity. Performed critical evaluation of operations to minimize expenses and ensure customer service levels are maintained.• Met with other support teams to ensure continual support of the project plans and to receive feedback on plans and procedures to ensure continuous improvement.

• Developed and maintained Access database to automate daily, weekly and monthly reports. • Analyzed regular reports as well as other performances, and trends. Provided feedback to management to increase customer service and minimize costs. • Maintained and improved efficiencies on current reports using Excel’s VBA and formulas.

• Managed, developed and improved reporting systems in Access and Excel.• Tracked and analyzed income and expenses on Non-Performing Leases (NPA Leases) to ensure loss account is at the correct balance. Developed Excel and Access models on historical performance to forecast future loss rate and overall losses.• Created and implemented a database process that reduced turnaround time for monthly reporting from 80 hrs of work per month to 28 hours, and increased accuracy.

• Developed cost operational model of production system. Evaluated labor methods and rates, system performance, as well as equipment costs to estimate costs and improve productivity and processes.• Created tools using Excel and Visual Basic for Applications to speed up job tasks.• Evaluated proposed business models’ calculations and expectations (costs and profits) to provide management with errors and inaccuracies.• Developed spreadsheets to analyze internal business models and identify critical revenue and profit points, in a time sensitive manner.

• Implemented a tracking and reporting system for major accounts. • Addressed customer requests and concerns regarding contracts, project development, and implementation. • Converted customer requests to specifications for web developers and other product managers. Tested web pages to ensure specifications were met.• Worked with multiple groups to develop and execute project plans and timelines.

Senior Engineer• Utilized existing models and developed models to evaluate the effects of airplane arrival and departure on the district and the associated costs and savings. • Assigned to recruitment department in San Francisco for two months to assist in testing, hiring, and recruiting applicants. Developed program to speed up the processing of applicant information between Excel and FedEx's mainframe system. Regional Engineer• Developed Excel spreadsheets and macros to automate tasks for engineer. This involved program initiation, planning, development, debugging and testing, documentation, training and distribution. • Acted as one of two leads to develop corporate process to reduce costs within stations. Coordinated and trained engineers in the Region to implement and execute plans • Selected as regional representative on major corporate initiative to improve station operations. This involved creating and testing Excel models within a team of engineers.• Coordinated vehicle assignments for the region (California to Washington). Minimized the amount of money spent on rentals ($1.5 million under budget for FY99) and managed inventory and distribution.• Implemented and maintained department web page using Netscape Composer and MS FrontPage.Associate Engineer• Worked extensively with MS Excel and its VBA program (macros) to aid managers in developing schedules, identifying areas of improvement, and creating reports and graphs. • Created processes to download reports (previously only available as a system printout) and created programs to automate processing and utilizing these reports. • Worked with stations to best utilize their manpower and equipment resources.