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.

• 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.

• 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.

• 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.

Charlotte, North Carolina Area

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