Seasoned, experienced IT professional equally adept with architecture and hands-on development of database solutions, both relational multi-dimensional, and tabular data models -- primarily within the Microsoft stack.
Demonstrated ability to organize and analyze data to produce actionable information to management in visualizations that are easy to understand and useful for reporting.
Architectural experience includes soup-to-nuts creation of data warehouses of historical data from various large disparate operational data stores including disciplines such as engineering design, logistics, healthcare, HR, warehouse management, and others.
Skills, experience, and training also includes Project Management, leadership of technical teams, and interaction with stakeholders as a Business Analyst
Hands-on development experience includes installation and configuration of SQL Server with an emphasis on T-SQL, stored procedures, functions, performance tuning and optimization, SSIS, SSRS, and SSAS. Extensive development of ETL processes in T-SQL and SSIS including handling of slowly changing dimensions.
Broad base of experience in data centric IT projects enables me to be flexible in the midst of changing priorities and technologies.
Expertise in MS SQL Server database SSIS, SSRS, SSAS, SSMS, and DTS in versions 7.0 through 2014.
Expertise in Transact SQL (T-SQL) programming, and shell scripting.
Experience with Computer Aided Software Engineering (CASE) tools such as ERWin, Embarcadero ER Studio, Open ModelSphere, and Dezign for Databases
Performance and documentation of business process analysis and engineering for automation
Development and documentation of successful enterprise-level technical solutions, blueprints, and roadmaps
Hands-on experience integrating Geographical Information Systems (GIS) data and using the Google Maps API, Excel Power Maps, and MS Power BI for creating data driven maps
Experience in a variety of report generation tools such as: SSRS, SSAS, Excel Power BI tools, Crystal Reports, ColdFusion Report Builder, Qlikview, Cognos Report Studio, and others
Advanced skills in MS PowerPoint, MS Excel, MS Visio, and MS Word
Bachelor of Science - Technical Education / Aviation Maintenance Technology
Texas A&M University - Central Texas
Texas State Technical College
Tyler Junior College
George Washington University - Project Management course
April 2017 to present
Cricket Wireless (AT&T)
Business Intelligence Developer
Contractor, Crystal Equations Corporation
Design, develop, and implement reporting solutions and data sources for self-service reporting based on stakeholder requirements.
Environment: SQL Server 2014, Windows Server 2012, SSRS, SSAS (Multi-Dimensional and Tabular), Agile, Office 365, JSON, XML, DAX, MDX, MS PowerPivot, MS Power View, Power Maps, Power Charts, Visual Studio 2013, 2015, Jira, Git, Code Cloud, Atlassian SharePoint
November 2016 to January 2017
SiteOne Landscaping Supply
Senior Business Intelligence Developer
Design, develop, and implement SSRS reports for C-level staff and others based on requirements documents.
Environment: SQL Server 2016, 2014, Windows Server 2012, SSRS, SSAS (Multi-Dimensional and Tabular), TFS, Office 365, JSON, XML, DAX, MDX, Apex, MS PowerPivot, MS Power View, Power Maps, Power Charts, Visual Studio 2013, 2015.
April 2016 to August 2016
Rainmaker Holdings, LLC
Senior Business Intelligence Developer
Design, develop, and implement ETL solutions using advanced SSIS and T-SQL, install company products on client systems. Develop data warehouse and business intelligence solutions using the Microsoft BI stack.
Environment: Cloud, SQL Server 2016, 2014, 2012 SP 1, Windows Server 2012, AD, SSRS, SSAS (Multi-Dimensional and Tabular), SSIS, C# Code-behind in VS, Office 365, JSON, XML, DAX, MDX, Apex, MS PowerPivot, MS Power View, Power Maps, Power Charts, Visual Studio 2010, 2012, 2013, 2015.
August 2015 to April 2016
Boys & Girls Clubs of America
Senior Business Intelligence Lead
Led design and implementation of data warehouse and business intelligence solutions using the Microsoft BI stack including SSRS, SSAS Tabular, Power BI, Excel PowerPivot, Excel Power Maps, Excel Power View, and Excel Power Charts. Developed Annual Reporting BI data mart and visualizations.
Environment: SQL Server 2014, 2012 SP 1, 2008R2, Windows Server 2012/2003, AD, SSRS, SSAS (Multi-Dimensional and Tabular), SSIS, SharePoint 2007/2013, Office 365, JSON, XML, DAX, MDX, Apex, MS PowerPivot, MS Power View, Power Maps, Power Charts, Visual Studio 2010, 2013, 2012.
November 2014 to April 2015
Regional Technical Manager - US
Authored T-SQL scripts for data validation and performance analysis and tuning of large client databases. Reverse engineered legacy database with 863 tables. Used Dezign for Databases as a data modeling tool to create an ER diagram of entire database, and Apex tool for database comparison and QA. Prototyped a data warehouse in SQL Server and developed prototype BI tools using MS-Excel PowerPivot, Power Chart, and Power Maps. Did hands-on requirement definition/documentation, database design, dimensional and relational data modeling, automated ETL processes, and data models for data warehouse. Used Dezign for Databases as a data modeling tool and Apex for database comparison and QA. Managed a team of Technical Analysts responsible for providing Technical Services to CMO clients and employees in the US region of a global company.
May 2013 to November 2014
Senior Business Intelligence Lead
Worked with the business to coordinate/document requirements and do hands-on development of a global enterprise data warehouse to meet the requirements of the business for analysis, predictive analysis, financial reporting, and other needs. Performed hands-on scripting of complex queries in T-SQL, SSIS packages, SSRS reports, and SSAS cubes and tabular reports. Designed and developed ETL processes for disparate operational data systems to capture and cleanse data, and put it into Star schemas. Performed hands-on report development in SSRS as well as development and utilization of tabular models in SSAS. Used DAX language scripts to improve data models, tailor data connections, and perform calculations.
October 2012 to May 2013
STRATEGIC CONSULTING PARTNERS
Senior Technology Consultant
Worked as a contractor for the Defense Logistics Agency (DLA) Information Operations (Philadelphia).
Performed extensive and detailed systems, process, data flow analysis on the DLA the clothing and textile supply chain and warehouse management systems. Conducted site visits interview personnel and document processes and technology usage. Wrote scripts (T-SQL) to capture database structures, stored procedures, and functions used in data ETL processes in and out of the central data store using primarily MILSTRIP transactions along with some EDI. Authored technology-related sections of Government deliverables on the contract, explaining intricate data interfaces as related to functional process flows. Performed extensive analysis and documentation at the detail level of source code, database design, and data interfaces.
Environment: SQL Server 2012/2008R2, Transact-SQL, SSIS, MS Visual Studio, VB 6.0, C#.Net, MS Office 2013, EDI.
May 2002 to September 2012
SRA INTERNATIONAL, INC.
Technical Director / Technical Architect
Managed the activities of a development group of ten technical personnel and represented the Atlanta office in technical matters to upper management and client management.
Developed a BI solution with over 5,000 users world-wide which also featured GIS integration of Google maps with data warehouse information.
Utilized Agile methodology to rapidly design, develop, and implement an enterprise bar-code based asset management system featuring Win Mobile hand-held scanners.
Performed as Chief Technical Architect on the Logistics Data Analysis Tools (LogDAT) project for the U.S. Army Reserve from conception through sustainment. The scope of the project involved wide-area networking, data integration and ETL processing from over 1400 remote servers, data cleansing, and Master Data Management (MDM). Developed the system blueprint, technical strategy, roadmap for development and implementation, as well as the business cases needed to move the project through the system development life-cycle (SDLC).
Documented and implemented disaster recovery planning, as well as continuous operations (COOP) systems planning and deployment. Authored the system’s project Business Continuity Plan (BCP), Configuration Management Plan (CMP), Service Level Agreements (SLAs), DoD Information Assurance Certification and Accreditation Process (DIACAP) documentation, as well as a number of white papers and position papers to inform and influence client decision makers.
Began on the LogDAT project as a Senior DBA and was the only technical person on the project from my company initially. My initial hands-on development of the data warehouse and web applications resulted in growth of the SRA technical team to a total of ten technical personnel and shaped the outcome of the project. Demand for additional products enabled growth of approximately $1.5M in revenue annually in an 8-year $95M+ contract with United States Army Reserve G4 Logistics Directorate.
April to May 2002
UPS CORPORATE HEADQUARTERS
Senior Database Architect (Contract Consultant)
Developed custom web applications in ColdFusion and SQL Server.
November 2001 to March 2002
ALSTON & BIRD, LLP
Developed custom Intranet and Extranet web applications for law firm.
May 2000 to Nov 2001
PER-SE TECHNOLOGIES, INC.
Manager, Corporate IT Services
Developed corporate Intranet and custom web applications for HR and Sales. Managed Help Desk, Wintel Server Group, Web Development group for corporation.
Aug 1991 to May 2000
LOCKHEED MARTIN AERONAUTICS
Developed custom client-server and web applications for Logistics, Training Systems, HR, and Security. Managed server facility and provided support for Sun Solaris servers hosting Sybase database for customer on-site project teams. Managed desktop support for over 200 engineers and customer on-site project teams. Developed custom user applications in both web-based and client-server environments.
Received Letter of Commendation from U.S. Air Force in 1995 for outstanding work on management and design on the Provisioning Relational Integrated and Distributed Electronic (PRIDE) system. The award was presented by (then) Deputy Secretary of Defense, Oscar Goldfarb.
Business Intelligence Architect Certification (Cognos)
Federal Aviation Administration Pilot and Airframe & Powerplant Mechanic
Adjunct Instructor of Computer Science at Chattahoochee Technical College
Published in “CALS Journal” magazine in Summer 1993 edition
Published papers and presented them at the 14th and 15th Interservice/Industry Education and Training Conference (IITSEC)
Security Clearance – Secret (Inactive)
Founded “R&D Software” company in 1989