Data Sql Server

Executive Summary

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.

Skills Summary:

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

Hands-on web application development in ColdFusion, HTML, JavaScript, CSS, AJAX, XML

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

Education:

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

Experience:

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

CMO-COMPLIANCE, LLC

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.

Environment: Cloud, SQL Server 2014, 2012 SP 1, 2008R2, Windows Server 2012, Visual Studio 2013, 2012, and 2008R2, Cloud hosting, SaaS, IIS, AD, SSRS, SSAS, SSIS, JavaScript, Dezign for Databases, SharePoint 2013, Office 365, Jira, JSON, XML, Apex, Jira, Atlassian,

May 2013 to November 2014

MANHATTAN ASSOCIATES

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.

Environment: SQL Server 2012 SP 1, 2008R2, Windows Server 2012, 2008R2, MS Team Foundation Server (TFS), MS PowerPivot, MS Power View, SSIS, SSAS, C# Code-behind, JavaScript, Visual Studio 2013, 2012, and 2008R2. Embarcadero ER Studio. SharePoint 2007 and 2013, Salesforce, XML.

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.

Performed hands-on design and development of automated systems in ColdFusion, JavaScript and T-SQL, creating automated extraction of data from Government data systems and ETL processes for loading it into a dimensional data model for advanced analytics.

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.

Environment: SQL Server 2000/2005/2008R2, Transact-SQL, SSIS, SSRS, SSAS, Visual Source Safe, MS Visual Studio 2010, Erwin, Embarcadero ER/EA Studio, Red Gate SQL Tool Kit, Oracle 10g, Data normalization, Star Schema, dimensional data modeling, C#.NET, ColdFusion 8/9, JavaScript, AJAX, Adobe CS4 Web Premium, Google Maps API, Bing Maps API, Windows Mobile 6.1, SQL Server Compact Edition, Windows Server 2000/2003/2008R2, Java Applets integration, Adobe Flash CS4, Metis Enterprise Modeling tools, AIT, passive RFID, GlobeRanger WMS middleware, Cognos, Crystal Reports, ANSI EDI x.12, Gentran, LOGSA, DLMS, SAMS-E, PBUS-E, SARSS, USAFMSA, DRRS, D035K and DSS.

April to May 2002

UPS CORPORATE HEADQUARTERS

Senior Database Architect (Contract Consultant)

Developed custom web applications in ColdFusion and SQL Server.

Environment: SQL Server 2000, T-SQL, Cold Fusion, HTML, DHTML, XML, JavaScript, Visio, Erwin

November 2001 to March 2002

ALSTON & BIRD, LLP

Web Architect

Developed custom Intranet and Extranet web applications for law firm.

Environment: ColdFusion 5, JavaScript, HTML, DHTML, XML, SQL Server 2000, T-SQL, Cluster Cats, Crystal Reports

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.

Environment: ColdFusion 5, JavaScript, HTML, DHTML, XML, SQL Server 2000, DTS Transact-SQL, Visual Source Safe, Adobe Photoshop, Macromedia Dreamweaver, Macromedia Fireworks, Windows Server 2000, PeopleSoft, Kronos, Salesforce

Aug 1991 to May 2000

LOCKHEED MARTIN AERONAUTICS

Solutions Developer/Architect

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.

Environment: ColdFusion 4.5, JavaScript, HTML, ASP, XML, Erwin, Rational Rose, Visual FoxPro, Windows NT Server 4, Novell Server 4.11, Solaris, SQL Server 7, Sybase, Oracle, Clipper, DB2, T-SQL

Other:

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

Contact this candidate