I am a Business Intelligence consultant, specialising in the following technologies: SSRS, SSIS MS SQL Server and MS Access/VBA, .Net, Microstrategy
I have 15 years experience in the IT sector working within the following industries:
Automotive, Telecommunications, Travel & Tourism, Managed Print Services, Finance
I have worked in IT in North America and in Europe. Currently I am based in Dublin, IRELAND.
In my current role I am involved in the following range of tasks:
• Developing ETL solutions using SSIS for customer Data Warehousing projects
• Writing complex T-SQL stored procedures which undertake data cleansing and loading as part of data warehousing ETL processes.
• Analysing and performance tuning T-SQL procedures and database design, as part of ETL processes handling large datasets.
• Coding C# SSIS Script Tasks and VB solutions for ETL and EDI tasks.
• Undertaking MS SQL Server DBA and troubleshooting tasks on servers on which BI solutions are developed and deployed.
• Drafting architecture/technical documents for customer ETL and EDI solutions.
• Providing technical advice and support via e-mail and phone to IT and BI teams at customer sites, for the following technologies: MS SQL Server, MS SSIS, MS SSAS, Microstrategy
• Remotely dialing in to customer BI systems to undertake administration, troubleshooting and enhancements
MCTS SQL Server 2008 Database Development