Colin Sobers Email & Phone Number

Kernersville, North Carolina, United States

Kernersville, North Carolina, United States

• Started as a Pomeroy IT Solutions BI Developer consultant, I work with the Entire Microsoft BI Stack for Tanger Outlets on their Data Warehouse project. This is a multi-phase project and Phase 1 went live mid May 2011..
• Documentation of the Data Warehouse and its processes
• ETL using SSIS. Configuration files for Server deployment and SQL Agent job
• SSAS for the Cube and all that goes with OLAP databases, cubes, calculations, sets etc
• Over 60 SSRS and Performance Point Reports, Scorecards, charts, bullet-graphs, trends, KPIs with MDX and T-SQL queries as the source
• Reports published to SharePoint 2010

• As an APEX Systems, Inc. Senior SQL Server Developer consultant, I work creating jobs and scripts for the Bank’s ISS department responsible for reconciliations, SSRS reports, SSIS packages and.Net web apps.
• Created documentation in support of Recons including Visio Diagrams of the development process and the system.
• Performed analysis of the Business Requirement (BRD) Document to determine plan of action for the development.
• Consulted with the Technical Analysts on the project and provided support of the same.
• Created Functional System Diagrams (FSD) and change requests in PAC2000 prior to moving the Recon into UAT and Production
• Created nBalance jobs and Production Assistant Scripts to execute those jobs for the Recons.

• The SetFocus Business Intelligence Master’s Program is an intensive, hands–on, project oriented program where participants add knowledge of and valuable experience putting the Business Intelligence skill set to use in.
• Implemented a Labor Analysis Business Intelligence solution for a national construction company.
• Existing data from diverse data sources were consolidated into a uniform SQL Server 2008 database. ETL capabilities of SSIS were used to define imports of data, build scheduling packages, define integration flow, log.
• Created cubes, dimensions, and business critical KPIs using SSAS representing aggregations in different ways - hierarchically and using custom groupings, that the company will use to analyze performance. Created MDX.
• Developed detail and summary reports, line and pie charts, trend analysis reports and sub-reports according to business requirements using SSRS.
• Implemented Business Intelligence dashboards using MOSS 2007 Report Center and Excel Services producing different summary results based on user view and role membership.

Colography provides Analysis Services to various companies in the transportation and shipping industry.SQL Server Database ProgrammerPreviously worked as a Database Programmer using such tools as SQL Server 2000, MS Access 2003, Analysis Services to provide support for the Colography Analysis staff and their clients.* Programming in SQL Server includes.

Worked as VB Programmer, SQL Server DBA, Windows 2000 Network Administrator, Corporate Network remote access security engineer and Enterprise Reporting Developer.* SQL Server 2000 and 7.0 DBA in support of SAP R/3 ERP solutions using the SD, MM/PP, FI/CO, BW and HR modules.* Installed and configured Business Objects and WebIntelligence datamart. Created.

Business Intelligence Master’S Program (12 Weeks)

Activities and Societies: The SetFocus Business Intelligence Master’s Program is an intensive, hands–on, project oriented program where.

Journeyman Guitarist

Graduated the one year program with honor and Vocational Honor after passing the jury.

Bs, Computer Information Systems

Activities and Societies: Honor Society EDP.Graduated with Great Honor, Magna Cum Laude.