Banner Image

Skills

  • .NET
  • Business Intelligence
  • C#
  • Database Design
  • Etl
  • Oltp
  • SQL
  • Ssis
  • Creative
  • Data Management
  • Data Warehouse
  • Database Administration
  • Database Development
  • Database Systems
  • Design

Sign up or Log in to see more.

Services

  • Database Developer

    $60/hr Starting at $2K Ongoing

    Dedicated Resource

    Specializing in OLTP Database design and development, ETL, Data Warehouse development, Business Intelligence, Reporting and Dashboard creation. Experienced in Microsoft technologies (SQL Server, SSIS,...

    .NETBusiness IntelligenceC#CreativeData Management

About

Hi, my name is Allan Fox. I am a seasoned SQL Server Consultant and Developer with over 30 years of experience in designing and developing database solutions in the Financial Services, Health Care and Industrial sectors. I have hands on experience designing, administering and supporting large MS SQL Server databases and related data warehouses. I've developed and tuned ETL processes created to load data into them using SSIS. I'm also proficient at building and maintaining reporting databases and systems using SSAS and SSRS, and creating reports using T-SQL, stored procedures and query languages.

I've also done many small to medium-sized projects that harness the power of Excel and its VBA programming language. I've built spreadsheets with macros and forms for my clients that produce monthly reports or perform sophisticated batch file processing. Other applications I've developed enable clients to do data (order) entry while off-line and then synchronize their orders with a central company database at a later date.

I am a detail-oriented individual with solid communication, problem solving and time management skills.