Information Technology Management, Engineering , Administration , Architecture, Development , Web, SQL, B.I. (Business Intelligence), OLAP/SSAS (Online Analytical Processing/Analysis Services)

OBJECTIVE

Obtain an I.T. leadership position utilizing over fifteen years of practical experience and education.

PROFESSIONAL SUMMARY

Information Technology Renaissance Man with experience in management, engineering, administration, development and support. Specialize in solving complex and difficult problems, streamlining and automating business processes, reducing dependence on human capital and providing access to information necessary to efficiently operate business. Accustomed to managing multiple responsibilities, organizing project plans, leading team members and prioritizing deadlines. Technical concentrations in Microsoft technology, particularly Databases, Data Warehousing, Business Intelligence, SharePoint, Web design, development and administration using Management Studio, Visual Studio, SQL Server and Internet Information Server. Complimented with strong understandings of all data center functions e.g. storage, networking, security, virtualization etc.

SKILLS & KNOWLEDGE SUMMARY

OLTP Databases : T-SQL, Stored Procedures, Triggers, Cursors, Data Modeling, Indexes, Optimization
BI/OLAP : SSIS, SSAS, SSRS, Star Schema, Snowflake Schema, Cubes, MDX, Pivot Tables
Programming : ASP.NET, VB.NET, C#, HTML, CSS, VBScript, JavaScript, Classic ASP
Application Services : SQL Server, Internet Information Server (IIS), SharePoint, Exchange Server
High Availability & Scalability : Microsoft Clustering Service (MSCS), Network Load Balancing (NLB)
Windows : Servers (NT4,2000,2003,2008), Desktops (3.1,95,98,ME,2000,XP,Vista,7)
Virtualization : Virtual Server, Virtual PC, VMWare
Strategy : Object Orientated (OO), Service Orientated Architecture (SOA), Iterative Development
Storage & Networking : RAID, SAN, NAS, Firewalls, Routing, TCP/IP, NAT, PAT, VPN, DHCP, DNS
Network Security : Active Directory, Group Policy, Juniper/Netscreen, SonicWall, Internet Security & Accelerator (ISA), RADIUS, Internet Authentication Server (IAS), Intrusion Detection (IDS), Intrusion Prevention (IPS), Data Loss Prevention (DLP)

WORK EXPERIENCE

Gateway EDI (Information Technology) St. Louis MO : November 2006 - Current

Web Systems Team Supervisor September 2010 - Current

Technology Used : IIS, ASP.NET, WCF, MVC, SOAP, SQL Server
Responsible for providing focus and strategy to an area of rapidly growing demand, defining future road maps, staffing, mentoring and communicating vision.
Manage a team of 3 web technology professionals.
Led technical teams to resolve capacity issues that eluded them for over a year.
Identified key performance metrics and a system to track them.

System Administration Supervisor September 2008 - September 2010

Responsible for data center, operations, administration, strategic planning, seeking innovative solutions, shaping technology road map, planning and adhering to budgets, policies, procedures, recruiting high end talent, developing high potential talent, prioritizing and balancing resources with initiatives.
Grew team to 8 administrators and 4 desktop support technicians.
Virtualized 90% of data center, several desktops and constructed fully functional DR site.
Lead Business Intelligence technical initiatives resulting in creation of a Data Warehousing department.
Initiated a SharePoint Steering Committee and assigned an administrator to lead meetings.
Empowered departments to create SharePoint sites and fostered a culture of self-reliance.
Implemented network and data security systems; maintained HIPAA & EHNAC compliance.

System Administration Group Lead May 2008 - September 2008

Responsible for a team of 3 administrators and 3 desktop support technicians.
Implemented a measurable, reportable, easy to use, email based workflow system.
Implemented SharePoint, Reporting Services and Team Foundation Server.

System Administration Team : Database Administrator November 2006 - May 2008

Responsible for server administration, 24/7 support and senior level programming deliverables.
Implemented system for logging and analyzing database resource activity.
Consolidated 4 legacy SQL 2000 servers into SQL 2005 high availability cluster.
Advised best practices to development teams.
Responsible for 15 TB of data spread across 300 databases and 5 servers.

BAT Technology Services (Hosting and Development) St. Louis MO : September 1997 - Current

Owner

Launched business that provides hosting, development and software services to small businesses who desire professional grade outsourced services without incurring costs internally.
Consult with clients and manage projects with 4 developers and 1 graphic designer.
Responsible for server/network design, maintenance, back-ups, rollouts, troubleshooting, support software licensing and billing.
Manage class C network for 240 domains, client and site to site VPN tunnel access.
Hosted services under various conditions from 4 locations, managing migrations each time.
Implmented 6 Small Business Server 2003 environments, performed several swing migrations and a consolidation.
Successfully recovered SQL, Exchange and Active Directory databases.

Stifel Nicolaus (Information Technology) St. Louis MO : July 2002 - November 2006

System Engineer : Database Administrator, Web Administrator

Manage the projects of, train and mentor junior administrator/developer.
Provide technical consulting to business subject matter experts; mentor the programming of junior developers to accomplish team goals in highly dynamic environment.
Lead junior developers in BI (creating and supporting data warehouses, data scrubbing procedures, SSAS cubes), intranet tools and reports to provide drill down self-service information access.
Responsible for server administration, 24/7 support and senior level programming deliverables.
Manage and develop the production of SQL and Web environments for 1.5+ TB of data spread across 150+ databases on 6+ SQL servers and 6+ IIS servers to include maintenance, standards, rollouts and permissions.
Design, configure and maintain SQL and Web clusters providing high availability and redundancy.
Created self-healing automated processes to reduce need for use of human capital.
Manage and develop server monitoring systems that send out pages and emails when unexpected errors occur.
Developed system for logging and analyzing database resource activity.
Managed Microsoft Internet Security & Acceleration Firewall.

Huttig Building Products (Information Technology) St. Louis MO : May 1999 - May 2002

Web Developer, Database Developer

Responsible for requirements gathering, lead design, lead development and support for in house developed sql driven web applications.
Trained and lead junior developer on sql driven web application development projects, directing assignments and mentoring programming skills with fast learning results.

Designed, developed and maintained public web sites, intranets and in house developed web applications that increased process efficiency by relieving HR staff of multiple manual processes that created audit trails, self-service reporting and collaborative process flow/tracking applications.
Designed graphics and HTML to dress e-commerce and auction web application interfaces.

Saint Louis University (Information Technology : Student Worker) St. Louis MO : Various time frames

Web Design Instructor June - August 1997 & 1998

Responsible for planning and implementing daily classes.
Designed and delivered a computer camp curriculum that successfully captured the interests of middle school and early high school age children resulting in 50% enrollment increase.

Computer Technician August 1995 - May 1997

Responsible for Software/Hardware installation, configuration, and troubleshooting.
Manned computer lab, performed troubleshooting for undergrad and medical campus faculty and staff.

Edison Brothers (Information Technology : Intern) St. Louis MO : September 1997 - May 1998

Computer Technician

Responsible for software/hardware installation, configuration, and troubleshooting.
Created a batch to build and configure new computer increasing speed ten-fold enabling Windows 95 rollout team to regain time lost due to unforeseen circumstances that would have delayed the project several months.

EDUCATION

Saint Louis University St. Louis, MO : B.A. Computer Science Major, Mathematics Minor : Cum Laude

AAIM Employers Association St. Louis, MO : Supervisory Certification

LRS Education Services Springfield, IL : Course 2074A: Designing and Implementing OLAP Solutions

RECOMENDATIONS VIA LINKED-IN

"Brian is an excellent systems engineer with wonderful technical skills. Anytime I gave Brian a project, I knew that it would be completed at the highest level possible. Brian constantly worked with his co-workers to explain systems that he worked on and to share his wealth of knowledge. From the time that I have met Brian, he has always been able to work with everyone and has had the ability to manage others. I've also had the fortune to work with Brian outside of Stifel Nicolaus and have always found him to be extremely professional with co-workers and clients."
— Mike Payne, Network Manager, Stifel Nicolaus, managed Brian at Stifel Nicolaus

"Brian is a very strong engineer with excellent technical skills in many areas. He also has great people skills, taking the time to explain the systems he manages to others in clear business terms and helping to resolve cross-functional issues in a pleasant and helpful manner. I would recommend Brian for any area where he can put his well developed skills to work."
— Bruce Kane, Exchange Engineer, Stifel Nicolaus, worked directly with Brian at Stifel Nicolaus

"Brian worked with the Human Resources department to develop an in-house benefit enrollment system. He not only had the technical skills to build an easy to use site for all level of employees but he was able to interact and communicate easily with the HR department in determining what was needed to build the system without using IT technical terms and not making the user feel inadequate. He was very detail-oriented and communicated well with coworkers."
— Karen Tauchert, Manager, Benefits and Compensation, Huttig Building Products, worked with Brian at Huttig Building Products

REFERENCES AVAILABLE UPON REQUEST