Ian Cockcroft

Previously, developed Business Intelligence solutions for various Clients. Designing, developing, testing, debugging, and documenting extract, transform, load (ETL) data processes and data analysis reporting for enterprise-wide data warehouse implementations. Working closely with business and technical teams to understand, document, design and code ETL processes; working closely with business teams to understand, document and design and code data analysis and reporting needs; translating source mapping documents and reporting requirements into dimensional data models; designing, developing, testing, optimizing and deploying server integration packages and stored procedures to perform all ETL related functions; develop data cubes, reports, data extracts, dashboards or scorecards based on business requirements. Developing, analysis and testing data warehouses and all the ETL associated with loading them, in SQL Server. Reporting off data warehouses using Pivots and Power pivot in Excel, Reporting Services. Developing cubes in Analysis Services. Translating business requirements into technical requirements. BI project lifecycle and management. User education and training. Communication and consultation with business users.