Brian Macfarlane Email & Phone Number

For a national drug testing company functioned as a Database Administrator and Developer.•Designed and implemented a custom ASP.Net Document Management system.•Designed and implemented a custom ASP.Net Breath Alcohol testing system.•Designed and implemented a custom ASP.Net Back Ground Investigation application.•Maintained all SQL Server Databases for the South East Region.•Developed SQL Stored procedures to facilitate backend processing.•Wrote technical and functional documentation and lead end user training sessions.

For a large reinsurance company implemented a financial planning application using Hyperion System 9 Planning Applications.•Lead a team of consultants and client employees though a Hyperion installation and implementation.•Created extensive project documentation and lead team meetings.•Configured and Hyperion Planning Dimensions and Data Forms.•Created and configured SQL Server databases.•Developed the ETL process for loading all financial data SQL Server Star schema.•Developed the ETL process for loading all financial data to Hyperion Analytical Services cubes.•Created custom Hyperion cube extract used to populate a SQL database..Net and SQL Server Developer and Team Lead•For a large bottling company helped create a windows-based beverage planning system, as well as a maintenance application that supports the planning system for a large beverage company.The solution was built using Microsoft VB.NET (version 2.0), and SQL Server.•Team lead for the Windows Forms .Net Planning Maintenance application which was used to configure and maintain forecasting and planning data and models.•Helped developed the Windows Forms .Net Planning application that accessed a SQL server.•Worked with team members designing code layout and architecture as well as collecting requirements from end users.•Created custom reports using the embedded Microsoft Reporting controls inherent to Visual Studio.•Wrote technical documentation and lead end user training sessions.•Developed SQL Stored procedures to facilitate backend processing.•Created windows installation package for the new forecasting software.

for multiple corporate data transformation jobs using the Informatica 9x suite of tools•Created new Informatica mappings and workflows to move employee data between databases.•Analyzed Informatica mappings and workflows to optimize and improve performance of existing jobs.

for multiple applications/software package installs for a nation-wide energy company.Responsibilities included legacy application rewrites/refreshes, support of custom applications and support of third-party vendor installations and new applications.Acted as primary and secondary support for a number of existing and newly written applications.Acted as primary and secondary support for a number of third-party tool implementations including digital signage software, print center software, and reporting applications.

For a county government implemented a data warehouse and reporting website using ASP.NET, VB.NET, JavaScript, Microsoft SQL Server, Microsoft DTS, Microsoft IIS, and Windows Server.•Helped developed a .NET-based reporting system that accessed the data warehouse which integrated data from the several source systems and later.•Developed the ETL process for retrieving daily extracts of source data from the original systems into the newly-developed data warehouse.•Created multiple stored procedures and SQL queries to support the data warehouse reporting environment and extraction process.•Performed database tuning and query optimizations for better warehouse performance.•Developed and administered a Business Object Universe for internal web based reporting access allowing users highly customizable, fast and focused reporting.•Designed and administered a hierarchical security model managing roles and permissions using Business Objects Supervisor.•Created several monthly, daily and quarterly web reports from the data warehouse that combined several data sources for internal and external customers using Business Objects and VB.NET.

Charlotte, North Carolina Area

A versatile Information Technology Consultant specializing in Database Management, Business Intelligence Solutions and Microsoft .Net Applications.