Adrian Boulton Email & Phone Number

Oakland, California, United States

• Work with cross functional teams to develop complex Tableau reports, writing SQL (Oracle and SQL Server)to create datasets from a variety of externally owned databases.• Publish a suite of reports implementing extensive QA procedures to ensure accurate reporting.• Respond to ad-hoc requests for data, analyses and reports in an accurate and timely manner.• Deliver presentations to demonstrate report functionality and to garner feedback for report improvement

Oakland, Ca

• Implemented full report development cycle to gather business requirements, develop data processing,perform metadata modeling with Framework Manager/Transformer and develop sophisticated reports anddashboards using Cognos Analytics.• Wrote full documentation describing reports and their production and QA processes for backupimplementation by other team members.• Delivered in-company training on Cognos report development supported by extensive training materials.Continued to act as a consultant for other Cognos report developers.• Regular presenter at Northern California Cognos User Group meetings.

Emeryville, Ca

Delivered worldwide analytical and business reporting services for a multinational, online,digital imaging, sharing and retail company.• Performed in-depth business analysis of marketing campaigns and promotion performance to inform business critical sales and marketing plans using SQL, R and Excel.• Reduced time to produce Weekly Sales Report from 2 days to 1 hour by using Excel macros/VBA to automate data processing and report production and delivery.• Created sophisticated custom Excel applications using extensive macros/VBA.• Performed detailed regression analyses and data modeling to produce a ‘bottom up’ forecast.• Transformed user specified reporting and analytical requirements into detailed business specifications, reports and analyses.• Wrote complex SQL (Sybase IQ, MySQL, Oracle) to create datasets from multiple data sources for reporting in Business Objects, Crystal Reports, MS Excel and R.• Developed complex ad hoc reports with results presented in an easy to understand format.

San Ramon, Ca

• Marketing analysis and report automation with extensive SQL (SQL Server 2005) to create tables linked to Access as a reporting tool using macros/VBA to automatically format reports.

Novato, Ca.

Provided company-wide business intelligence through in-depth analytics, and ad-hoc andperiodic reporting for a national mortgage company on commercial and residential loanorigination. Supplied key metrics and reporting to Finance.• Automated reporting using macros/VBA.• Maintained and developed 40+ databases providing fully automated daily, weekly, monthly, quarterly and yearly production reporting posted to the company intranet.• Performed complex analyses and produced ad-hoc reports at very short notice.• Implemented full report development cycle to produce complex Siebel Analytics reports for executive management from initial business specification, requirements gathering, technical specification, report development, quality control, certification and deployment.• Developed an extensive quality control procedure for a Siebel Analytics off-shore team and managed the relationship with this team.

San Francisco, Ca.

• Resolved all compatibility issues between Access/Excel 97 and 2003 in over 100 databases and spreadsheets across 22 departments over four sites, when upgrading from Windows NT to XP.• Performed in-depth business assessment and analysis to establish scope of upgrade project.• Wrote VBA code to replace out of date dll links and update database structure from DAO to ADO object model.• Coordinated inter-departmental user acceptance testing supported by full documentation detailing test procedures, all changes made to spreadsheets and databases and sign offs.

San Francisco, Ca.

• Combined all the Trust’s archived records information by creating a sophisticated, multi- tiered relational database for archiving.• Significantly reduced processing time of real estate taxes and refunds by creating a complex financial tracking database and reporting tool replacing a manual process.• Consolidated employees’ time sheets by creating a time sheet entry and tracking database resulting in much faster, more accurate completion of time sheets.• Streamlined expense reporting by replacing paper-based claim forms with an Excel spreadsheet with extensive macros/VBA. Gathered functional requirements from all users. Developed, tested and documented application and posted to the Trust’s website to download and complete.

3M European Distribution Centre, Bedford, England.

• Administered warehouse shipping and receiving database (Oracle 9i).• Significantly reduced turnaround time by implementing a computer-based dispatch system replacing a manual system.

Latina, Italy; Istanbul, Turkey; Tarragona, Spain

• Created SQL Server 7.0 database to manage schools’ administration and to analyze and distribute students’ exam results for individual curriculum development and progress.• MS Office (Excel & Access) trainer and consultant to teaching and administration staff.• Founded and managed a volunteer teacher program for homeless street children in Istanbul. Recruited and trained staff. Sought and obtained funding from large corporate sponsors.

Bedford, England

• Collated and managed survey inspection data on road and rail bridges and other structures for incorporation into an Oracle 8 database• Designed and produced inspection reports and structure repair schedules.

Hnc, Electrical And Electronic Engineering

Application Developer (Siebel 7.7) Ed 1

Marketing Planning

Essentials Of Marketing

Microsoft Sql Server

Perl Programming

Java

Vb.Net