Principal Consultant
United Kingdom
Principal consultant work in Data Warehousing and Business Intelligence via my own company - 20/20 DATA LTD. Diverse experience across many industrial sectors such as Banking, Insurance, Manufacturing, Retail and Education.Projects included -* SAP BusinessObjects Business Intelligence 4.0 SP4:WebIntelligence Financial Reporting Pack for UK public service & infrastructure provider, using BICS connectivity and BEx queries to report on SAP BW data. Successfully overcame common BEx/BICS/WebI "gotchas" such as: - Disappearing WebI charts when scheduling to PDF; - Period/Month sort order issues within WebI.Utilised merged dimensions to combine data from multiple BEx queries. Less costly than incurring BW development to alter Multi Providers.* Performance tuning/troubleshooting of Data Services, WebIntelligence reports and Universe (XIR2 in banking sector) for ATM data.* Retail Sales Management Information initiative (banking sector). Data Services 3.2.* Customer and product profitability initiative including creation of underpinning Data Warehouse. Technologies: J.D. Edwards (JDE) source, installation of and development in Data Services 4.0 (incl. Information Platform Services in Windows Server 2008 SP2 environment), Universe Designer XIR2 and v4, WebIntelligence XIR2 and v4, SQL Server 2008 R2, Tomcat 6.* Replacement of legacy ETL processing (SQL Server DTS) with Business Objects Data Integrator (alongside Data Services v12 migration) to facilitate Near Real Time supply of data from Harlosh Insurance Faces (IFaces) source system to the Data Warehouse.Chartered Institute of Insurers accredited after passing the FIT exam.* HR Training Compliance tactical mini-project to ensure legal obligations for staff training are fulfilled. Technologies: Data Integrator 11.7 (including performance tuning), Peoplesoft, Oracle, DB2.* Kick-start a financial reporting project. Technologies: BOE 4.0, universe development (Information Design Tool), Sage source data.