Business Intelligence Resume
UsA
Summary:
- In a results-oriented career, have led cross-functional teams meeting budgetary bottom-lines and project deadlines, while handling multiple assignments and coordinating deliverables with sponsors and key stakeholders from multiple business units.
- Using a mentoring and creative problem-solving style that marries hands-on leadership with experience and communication to drive team focus toward unified strategies in infrastructure architecture, database solutions, business intelligence, enterprise security, and data center operations.
- Technology Snapshot: Windows Server (00 thru 08 EE-DC ed.), MS SQL Server (6.0 thru 2K8), MS SQL Server Services (SSRS, SSIS, SSAS), Oracle (8i, 9i, 10g RAC), Linux (RHEL), UNIX (bsh), MS Exchange (03, 07), MS SharePoint (MOSS 2K3, 2K7 & WSS 2.0, 3.0), Virtualization (Hyper-V, VM Ware ESX 3.0, 3.5, vSphere 4.0), MS Clustering (2K3, 2K8), MOM (2K5), WSUS, SCCM, SCOM, .NET (ASP, C#), OCS/LCS, TCP/IP, FTP, XML, IIS, DNS, DHCP, WINS, AD, DTS, HTTP, MSMQ, Apache Tomcat, JBOSS
Expertise:
- Extensive experience in ETL methodologies, Enterprise Solutions, and SDLC
- Extensive experience in Planning, Designing, Installing Microsoft and VM based environments
- Extensive experience integrating Architecture, Design, Management, Support, Troubleshooting of Server infrastructure, creating AD and multi- or single Domain environments
- Extensive experience in handling multi-terabyte OLTP, DR, Warehouse production environments
- Extensive experience in planning and implementing SQL 2000 to 2005 to 2008 migrations
- Extensive experience in supporting, migrating, troubleshooting, managing MS Exchange
- Extensive experience in planning, configuring, maintaining and troubleshooting Transactional, Snapshot and Replication
- Excellent Problem solver
Core Competencies/Accomplishments:
- 18+ years Database Administration/Development/Architecture
- 12+ years Strategic IT Planning
- 11+ years Systems Administration
- 10+ years overall IT/infrastructure architecture
- 10+ years Networking
- 8 + years Application Architecture/Development
- 7+ years IT Management
- 5+ years VM Ware Architecture
- Six Sigma Yellow Belt
- ITIL methodologies
- Microsoft White Paper/Case Study (completed, SharePoint)
Professional Experience
Confidential,February 2004 Nov 2009
Manager, Data Center Operations (DBA/SA) March 2005 Nov 2009
- Create a new foundation of organization, procedure, best practices, SLA standards, and resource management in a 24x7 environment.
- Be escalation hub for executive, senior management and staff on emergency issues and resolutions. Work directly with corporate vendors and business units to ensure new technologies meet common goals. Maintain ownership of all AirTran technologies, while managing a staff of 12 (peak) comprised of Systems Administrators and DBA’s, and 5 data centers (2 ATL DC, MCO, SAV, and ATR).
- Present weekly updates to CIO, CTO and Directors on issues, strategy, and budget.
- Architected SharePoint 2K7, intra- and extranet enterprise-wide environment. Entire NLB environment built on Server 2008, SQL 2K5 (A/A Cluster), SRS 2K5, IAG, Exchange 2K7, on ESX Virtual Machines managed, supported, developed web parts, coordinated reporting, integrated Active Directory (security) Microsoft wrote Case Study on SharePoint Environment (“ShareTran”)
- Support and maintain High Availability SQL Server Clustering running in SAN environments for the corporate Intranet.
- Built Load Balanced environments for multiple business units to interact with existing Microsoft environments.
- Built Marketing Sandbox with replication to SQL databases for data mining summary data.
- Running Performance and Index tuning wizard in association with troubleshooting e-commerce, web services, and OO developed Applications.
- Carried the responsibilities for daily database operations, security administration, object administration, and capacity planning of Server environments
- Owner of the capacity planning for both Virtual and Physical server environments, while remaining hands-on in the physical management of IBM & EMC SAN.
- Developed BI solutions that integrated SharePoint, SS Analysis Services, SS Reporting Services and Dashboards for enterprise consumption.
- Re-Architected, installed, supported, managed Exchange 2003 environment to incorporate HA and DR capabilities.
- Designed, built, configured Exchange 2007 test environment, for upgrade in 2010 migrated 6,500 mailboxes, while integrating BES Server, SharePoint 2007/2003, Web Applications and monitoring.
- Recommended and architected strategic move to data center virtualization. Converting 750 physical servers, into 20 farmed environments, on 109 servers, while enhancing our HA, DR, and backup strategies.
- Architected virtualized MS Hyper-V (Server2K8) and VM Ware for Application and Database life cycle environments: Development, testing, Q/A, Staging and Production.
- Created SharePoint Global Knowledgebase for Sys Admins, Field Service, Networking, and Help Desk as part of ShareTran streamlining trouble ticket resolution, asset management, and increased SLA standards.
- Increased security presence with initiatives involving Tripwire (security control), HIPS (host intrusion protection), Stealthwatch (client activity monitoring), SCOM/MOM (enterprise monitoring), In-Trust (e-mail watch-dog), and McAfee (virus protection), which standardized SOX (Sarbanes-Oxley) and PCI compliancy (Credit Card transaction).
- Large Scale initiatives included: AD/GP clean-up; SAN migration from Clariion to CX3-80 to IBM DS4100; DR re-architecture; NAS replacement; Patch Management (WSUS/SCCM) re-Architecture; Enterprise Backup migration from Tape to Electronic; SQL database conversion (environment-wide 2K to 2K5/2K8); assist deployment of CISCO IPCC strategy all core components fundamental for positive IT/corp. growth.
Confidential, February 2004 March 2005
Sr. SQL Server DBA
- The goals set forth were simple protect AirTran Airways most precious asset: Data. Was the decision maker on all database initiatives ranging from OLTP architecture to database optimization, ETL and Architecture.
- Set up, monitor, and support ETL encryption process for credit card transactions and PCI compliance.
- Set up and monitored SQL Server maintenance and alerts.
- Built .NET monitoring tool that employed Exchange to notify for failed and long running SQL Server jobs, as well as database sizing and disk storage usages.
- Monitored, analyzed, and tuned SQL Server database performance and utilization and allocated server resources to achieve optimum database performance using self-developed SQL scripts, Groundwork, Profiler, Dynamic Management Views and Windows Performance Monitor.
- Performed backups, restores, performance tuning, stored procedure writing and tuning, capacity planning, disaster recovery planning, data conversions, data imports/exports, and system upgrades.
- Built and implemented Reporting Services (2K3 and 2K5, Analysis Services) and SharePoint Test & Production Environments (2K3 and 2K7), ad-hoc tools to capture reporting elements built in .NET, C# and HTML
- Implement Active/Active & Active/Passive Database Environments (Win 00/03/08 Servers & SQL 2K/2K5/2K8).
- Developed complex DTS and SSIS SQL data conversions in concert with stored procedures, triggers and indexes (clustered/non) to integrate 3rd party, FAA, and Manufacturing data. Upgraded Oracle 8i to 10g RAC for mission critical Maintenance Program.
- Built Vertical/Oracle 11g Data Warehouse solution for forecast reporting and Data Modeling.
- Aid in System Administration problem solving when emergency issues require assistance, established MOM environment for monitoring, SharePoint environment for dashboard results.
Confidential, LLC. October 2002 February 2004
Principal, Architect
- Developed application (VB/SQL) for calculating and tracking multi-million dollar audits of default Medical practices and large scale Construction firms. Emphasis had to be put on the db design (SQL2K) as this aided financial analysis.
- Monitoring SQL Server logins, logs, activities, connectivity, blocking, SQL Server Agent jobs, database and server performance, and database space and disk space usages using home-grown scripts and Quest Spotlight. Backup and recovery using native backup and SQL-BackTrack. Trouble shooting related database issues.
- Database design, development, implementation and administration using Enterprise Manager, Query Analyzer, Transact-SQL, stored procedures, functions, triggers, DTS packages, etc.
Confidential, May 2000 October 2002
Sr. DBA II
- Develop and implement strategic SQL operations to increase Health Insurance Web Site availability, speed and data security
- Responsible for DBA functions involving development (TSQL, triggers, SP, Profiler).
- Handled strategic planning of database operations and OLTP data mart.
- Created and automated ELT imports (ASP, DTS, BCP data pumps) of carrier data for quoting, rating and retrieving purposes, from multiple health insurance carriers;
- Develop complex TSQL procedures for Production and Development, Web Applications and Reporting, thus created health insurance rating engine;
- Architect and Model (Physical and Logical) database layouts for Production release, Backup plans, SQL Security;
- Install, maintain, and upgrade the following products: SQL Server Enterprise Edition Product Suite, Analysis Services (SSAS), Integration Services (SSIS), and Reporting Services (SSRS).
- Monitoring SQL server, Application logs and analyzing the logs.
- Designed and developed a STAR schema for a Business Intelligence project; developed SSIS packages to extract, transform, and load data from the various OLTP system environments to the data warehouse.
Confidential, March 1999 May 2000
Technical Consultant
- Pre- and Post-Sales Engineering Assess, analyze, install, configure and customize stored procedures (SQL) and VB based Medical record conversion product suite per client site needs
- Analyze and Resolve database requirements before implementation and provide client support (24 x 7)
- Establish download processes for HOST systems on either SQL or Oracle databases (via Unix scripting or BCP)
- Tutor/Train clients on application management and use (all levels of users, per back-end db SQL 6.5 or Oracle 8i Server)
Confidential, December 1998 - March 1999
SQL Server DBA/Systems Engineer
Carry out standard DBA and Network Engineer functions for client customers. Primary client was YUSA, INC. (Japanese manufacturer of rubber hoses and rings for Honda) and oversaw mid-size medical practices.
Projects included:
- Lead DBA specialist, SQL database/server Projects Installs (8), Troubleshoot (10+), Architect/Implement Data Warehouse (5), Oracle builds (6) / migrations (4), Integrations AS400 (2), Product life-cycle builds - (3) SQL Server/NT clustered environments (2-Active/Passive, 1-Active/Active);
- Systems Specialist for Windows Installs (4), Troubleshoot (10+), Design/implement Domain (2)
- Other responsibilities included Analyze data of database reliability per Customer needs, Emergency 24/7 Support, implement Best Practices, data modeling (ERWin), and assist with in-house Network Engineering.
Confidential, Columbus, OH December 1994 November 1998
Data Center Manager / Database Administrator
- Build and manage the network operations for 3 24-hour Call-Centers with 150 CSR, 15 management and 20 administrative workstations, in a Client/Server environment. Managed staff of 5 System Administrators and maintained hands-on responsibilities that included:
- Decision maker on systems, personnel, strategy and direction for Call Center Technologies, of which presented to Executive teams;
- Provide Exec. Management with capacity planning, cost, and project statuses of Call Center Operations;
- Perform ETL migrations, conversions and create SP’s on SQL databases (ver. 6.5 and 7.0);
- Architect, Model, Implement SQL Server databases, in a Call-Center Application environment;
- Data Mining of SQL databases with Crystal Reports (OLAP) analytical reporting for all departments;
- Architect and implement LAN migration from Novell to Microsoft 3.11
- Migrated Email from Lotus Notes platform to Exchange 5.5
- Responsible for site Replication with Corporate office and storage solutions for those offices;
- Managed the Columbus, OH, Atlanta, West Nyack, NY and Chicago Call-Centers - IT operations;
- Execute all Network/Database/Software/Hardware related functions for maintaining operations;
- Up to this point in my career had been object-oriented Developer of VB/SQL client-server applications.
Technical Skills:
Network, DB & Server OS: Windows Server (3.11, 4.0, 2K, 2K3, 2K8), MS Virtual Server (05r2) & PC (04, 07), VM Ware Ent. (3.0, 3.5), Red Hat Linux (7), SCOUnix (5.0.4), , MS SQL Server (6.0, 6.5, 7.0, 2K, 2K5, 2K8, 2K8r2), Oracle (8i, 9i, 10g RAC), MS Great Plains (7.0, 8.0, 9.0), MS Reporting Services (SRS - 2K, 2K3, 2K5), Vertica (Data Warehouse), MS SharePoint (MOSS 2K3, 2K7 & WSS 2.0, 3.0), WSUS/SCCM, ISA (2K4, 2K6), IAG/UAG, MQSeries, TCPIP, DNS, DHCP, FTP, IIS, Apache Tomcat
Applications, Languages & S/W: Microsoft Virtual Server and PC (2K5, 2K7), XML, SourceSafe, Visual Studio.NET (2K, 2K3, 2K5 VB, ASP.NET 2.0, C##), MS Exchange (5.5, 2K3, 2K7), VISIO, Microsoft Project (v4.1, 98, 2K, 2K3, 2K7), MS Prof. Office Suite (XP, 2K3, 2K7), InfoPath 2K7, ERWin, Red Gate, Office Communications Server (LCS2K3, OCS2K7), BusinessObjects 5, Paradox (3.5, 4.0, 4.5, 5.0, 7.0), MS Operations Manager (2K, 2K5), MS Access (95, 98, XP, 2K, 2K3 and 2K7), IIS (1.0, 2.0, 3.0), HIPS (McAfee), SolarWinds, Stealthwatch, SecureFusion, In-Trust (Quest), SpotLight (Quest), Veritas/Symantec BackupExec, NetBackup (5, 6.0, 6.5), Virus Protection (McAfee and MS ForeFront), Tripwire (security management tool), TOAD (Oracle, SQL), SpotLight (Quest), MS LiveMeeting, OpenManage (DELL), PowerPath(EMC), AMM (IBM), Shell Scripting, UNIX (bsh)
HW/SAN: Dell (Servers/Blades/Switches), IBM (Servers, Blades, SAN), EMC SAN (FC4700, CX3-80, Symmetrix, Clariion), NetApp, CISCO (routers, switches), APC (Symmetra 80k, SmartUps), HP DL100 (NAS), Barracuda Load Balancer/Spam Filter (400, 600, 1000 series), Brocade (Fibre switches), Data Domain (backup), Dell DLT Tape, Proteus (DNS appliance).
Education:Confidential