Barry Cunney
  • Ireland,
  • Ireland
Member Since: 2000/08/30
Top Skills:
Tech Certifications:
View All
Sage

Provide a quick, creative biography in 140 characters or less.

More bio
Activity
Points this month0
Total points647,840
Questions: 149
Solutions: 461
Articles:
Videos:
Courses:
Posts:
Group Discussions: 3
Professional Background
Business Intelligence Consultant/Developer
Avnet Client Solutions
May 2011
•      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.
Reporting/Database Developer/Programming Analyst
Xerox Europe
December 2009 – December 2011
•      Developing and supporting corporate reports and reporting systems driven by Microsoft technologies such as SQL Server and SQL Server Reporting Services.
•      Designing SSRS reports using Report Builder 2.0/3.0 and BIDS and editing/coding raw RDL.
•      Writing VB.Net custom code(Class objects, Hashtables) in Report Builder to extend the business logic provided by internal systems.
•      Coding business logic in MS Excel dashboard type reports using VBA.
•      Requirements gathering for the purpose of improving the reporting function to all areas of the business: Commercial/Business Cases and Propositions, Finance, Supply Chain, Service Desk.
•      Designing SQL Server databases(including T-SQL Stored Procedures and functions) for Business Intelligence purposes and MS Access front end interfaces  which communicate with such back-end databases using ADO.
•      Analysing and documenting cross business processes which are part of and feed into the reporting function.
Application Support Specialist
VRX Studios
November 2007 – November 2009
•      Developed and enhanced MS Access applications which generate and collate content and hosted content integration scripts, programming in VBA and T-SQL stored procedures
•      Provided technical support to sales team, end customers and internal development team.
•      Undertook troubleshooting of virtual tour and other web content in ASP.net, traditional ASP and other web related technologies such as Flash.
•      Administered SQL Server 2000/2005 databases and automating routine tasks, such as producing monthly content tracking reports, utilising T-SQL, Jobs, VBS, DTS and Replication.
•      Coded some enhancements and bug fixes to existing C#/.NET applications.
Support Analyst/Programmer
ADP Dealer Services Ireland Ltd.
January 2003 – January 2007
•      Supported software applications for the automotive industry on the following Operating Systems: UNIX, Linux, Windows.
•      Designed and programmed EDI applications which interfaced with core applications
Developed interface applications using KCML (a language developed by Kerridge – Kerridge C Macro language – a language based on the C language with syntax very similar to Visual Basic) which constructed EDI files in various formats, including EDIFACT and transmitted such files via FTP.
•      Involved in projects concerned with producing handheld scanning/Bluetooth printing solutions for scanning of vehicle information in compounds of vehicle importers. This involved the following technologies and devices: Pocket PC, Embedded VC++, Bluetooth, Intermec, Symbol PDA’s and Intermec portable Bluetooth printers.
Support Consultant
Worldlink Information Technology Systems
June 2000 – June 2002
•      Supported Mobile/Wireless PDA based applications which streamed Real-Time Financial Market information to the following Operating Systems: Windows CE, Pocket PC, Palm OS.
This involved dealing with customers over the phone and via email, troubleshooting issues related to mobile dial-up connections and device configuration.
It also involved the monitoring of the server-side service software and technology which provided the streaming real-time financial ticker and quote data from Standard and Poor’s, identifying and correcting any problems with this service. This involved the following technologies and operating systems: Windows NT/NT Services, MS SQL Server, CSP Satellite Servers, T-SQL, SQL.

•      Developed Service Monitoring applications in MS Visual Basic 6.0 and MS Visual C++ 6.0:
Designed and programmed and application that monitors Financial Market Data Feed into MS SQL Server 7.0 database and provides  
alerts by way of SMS, console messages and audio signals.
Support Consultant
Olympic AMIS Ltd.
March 1997 – March 2000
•      Supported IBM AS400 based Data Warehousing Server software and related Windows based OLAP Client software. This support involved troubleshooting problems encountered by clients when using the software as well as advising clients, on how they could manipulate the software, to achieve results necessary in their unique situation.

•      Designed and developed MS Access customer services and call logging database application for Olympic Amis Call Centre. This application contained extensive functionality for the purpose of call logging, call escalation, and call reporting. It also contained search utilities for extracting client and call data.  These applications were written in MS Access VBA and interacted with MS Office Applications: MS Word, MS Excel, MS Outlook.

•      Designed graph and data reports using Crystal Reports, as part of a project which developed an executive web front end utility, to interrogate and extract data from the server side database software on the IBM AS/400
More
Education
Galway-Mayo Institute of Technology
BBS H2.2
Business, Accounting, Information Technology Degree
1995 – 1996
More
Full Biography

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

More
Languages
No Languages shown

Level Progress

Current: Level 17
Barry needs 160 points to level up.
LVL 18
  • Overall
    17
  • Microsoft SQL Server
    13
  • Microsoft Access
    10
  • Microsoft SQL Server 2008
    8
  • Microsoft SQL Server 2005
    7
  • Query Syntax
    5
  • .NET Programming
    4
  • Microsoft Excel
    4
  • Microsoft Development
    4
  • SSIS
    3
  • Databases
    3
  • Microsoft Applications
    3
  • Powershell
    3
  • SSRS
    3
  • Visual Basic Classic
    2
  • Microsoft Office
    2
  • SSAS
    2
  • Visual Basic.NET
    2
  • C#
    2
  • VB Script
    2
  • Windows Server 2008
    2
  • ASP
    2
  • Oracle Database
    1
  • Programming
    1
  • MySQL Server
    1
  • VBA
    1
  • Windows Server 2012
    1
  • ASP.NET
    1
  • DB Reporting Tools
    1
  • Active Directory
    1
  • Azure
    1
  • Cloud Computing
    1
  • Outlook
    1
  • Microsoft Word
    1
  • SBS
    1
  • JavaScript
    1
  • Exchange
    1
  • Scripting Languages
    1
  • WCF
    1
  • Software-Other
    1
  • C++
    1
  • Application Servers
    1
  • FoxPro
    1
  • Google Apps
    1
  • Microsoft Dynamics
    1
  • Networking
    1
  • PHP
    1
  • SOAP Protocol
    1
  • Web Languages and Standards
    1
  • Windows Batch
    1
  • Windows Server 2003
    1
  • XML
    1

Profile Validation

Email Verified
Expert Level Achieved