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.
• 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.

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.
• 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.
• 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.

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