Messages are displayed here to help you navigate the site.

"Foraging in the Fog"
External link to ACM web site
External link to EDS web site
External link to Oracle web site
External link to NetBeans web site
External link to Firebug web site
External link to Macromedia web site
External link to Aptana Studio web site
External link to The Open University web site
Picture of Roy Weston

Hitachi Data Systems (UK)

updated: 2010-04-06

Summary -An intelligent, flexible, competent, creative Software Developer and Support Engineer with a successful background in Web Application development, Oracle and MySQL database design and technical support.

Hitachi Data Systems (UK) Ltd. (Global Data Storage Solutions Provider) Jan 2002-Nov 2004

Information Specialist -Successfully lead, designed, and implemented bespoke web front end, Oracle data warehouse applications, including Oracle Applications 11i integration, Business Objects reporting functionality, as well as technical, application, and hardware support.

Business Intelligence

  • Designed and maintained Business Objects reports, universes and security across both Oracle and SQL Server data sources, including Oracle eBusiness Suite 11i.
  • Evaluated Oracle Discoverer, Oracle Warehouse Builder and Business Objects as part of a global team.
  • Lead team to design new staging and star schemas for the HR business function of a global data warehouse, rationalising over ninety worldwide HR related reports to about twenty with global business definitions for all reporting fields.
  • Specified and built Business Objects v6 infrastructure to investigate new v6 functionality.

Technical Support and Resolution

  • Provided 1st, 2nd and 3rd line support both on-site and off-site for applications and hardware issues utilising Clarify ClearSupport and other tools for issue tracking.
  • Specified, built, configured and maintained Microsoft servers for Business Objects v5, liaising with infrastructure team over the various architectures to ensure best performance for European user base.
  • Performed Business Objects client and server technical maintenance upgrades and system stabilisation tasks.

Analysis, Development and Solutioning

  • Technical Lead and Architect to develop a system and data schema to collect employee related HR data from several different HR systems all over the world into one Oracle HRMS instance in US utilising HRMS PL/SQL api's.
  • Improved ETL month-end performance by a factor of ten through schema and algorithm enhancements as well as providing support and debugging functionality in live production environments, resulting in process completion times dropping from several hours to minutes. Oracle data sources included GL and INV with AOL integration.
  • Designed and implemented schema and algorithms to ensure integrity of data extracted from Oracle Inventory, including use of materialised views, rollups, and data handoff views to Hyperion Planning.
  • Designed, developed and enhanced applications integrating Oracle Applications, Oracle data warehousing, PL/SQL, ASP, JAVA, XHTML, CSS, WSH, Scripting, Excel VBA, and Business Objects technology stacks.

Skills: Technical/ System Architect, ER/ Dimensional Modeling, SQL, PL/SQL, Data integration, Business Objects Reports/ Designer/ Supervisor/ Installation, Problem resolution, Oracle Discoverer User/ Administrator, SQL*Plus, SQL*Loader, Reports2.5, Forms4.5, Oracle Applications10.7/ 11i, Web Technologies, Excel/ VBA, Java, Windows Server Administration/ Configuration, Apache/Tomcat installation & configuration, Oracle Warehouse Builder, Macromedia Studio MX, UI Design, Testing, Installation/ Technical/ User/ AIM documentation.



Hosted by Fasthosts Internet Ltd. Site Design by Roy Weston.
Contact Me