Summary:

• Senior level data architect specializing in data warehousing, systems integration, business intelligence, and web application development with hands-on design, development and Project Management experience.
• Recent experience in bar-coding, electronic data interchange EDI and passive radio frequency identification pRFID technologies.
• Hands-on programmer, system administrator, and DBA.
• Demonstrated flexibility, versatility, and the ability to adapt to changing situations and overcome obstacles.

Skills Summary:

• Expertise in MS SQL Server database SSIS, SSRS, SSAS, SSMS, DAX, MDX, DTS versions 7.0, 2000, 2005, 2008R2, 2012
• Microsoft BI stack including Power Pivot, Power View, Power Map and DAX, MDX, and M languages.
• Web application development in ColdFusion, HTML, DHTML, JavaScript, CSS, AJAX, XML, and XHTML.
• Development of successful enterprise-level technical solutions, blueprints, and roadmaps
• Business process analysis and engineering for automation
• Expertise in Transact SQL T-SQL programming, and shell scripting.
• Experience with Computer Aided Software Engineering CASE tools such as ERWin, Embarcadero ER Studio
• Technical expertise in applying Automated Identification Technologies AIT such as: RFID, pRFID, bar-coding in large enterprise environments.
• Advanced skills in MS PowerPoint, MS Excel, MS Visio, and MS Word.

Experience:

Confidential

Senior Business Intelligence Analyst

I work with the business to coordinate/document requirements and do hands-on development of a data warehouse to meet the needs of the global business for analysis, predictive analysis, financial reporting, and other needs. I perform hands-on scripting in T-SQL, SSIS packages, SSRS reports, and SSAS cubes and tabular reports. I design and develop interfaces to operational data systems to cleanse and capture data and put it into Star schemas dimension and fact tables. I develop reports in SSRS as well as cubes and tabular models in SSAS.

Environment: SQL Server 2012 SP 1, 2008R2, Windows Server 2012, 2008R2MS Team Foundation Server, MS Power Pivot, MS Power View, MS Power Map, DAX, MDX, M, Visual Studio 2013, 2012, and 2008R2.

Confidential

Senior Technology Consultant

I work as a contractor for the Defense Logistics Agency DLA Information Operations Philadelphia to analyze their current operational data systems and processes used in the clothing and textile supply chain and warehouse management systems.I conducted site visits to retail distribution and warehousing locations to interview personnel and document functional processes and technology usage. I also 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. I authored technology-related sections of Government deliverables on the contract, explaining intricate data interfaces as related to functional process flows. I performed extensive analysis and documentation at the detail level of source code, database design, and data interfaces.

• A blueprint consisting of extensive documentation of supply chain and warehouse management functional processes, supporting data, technologies, and information architecture
• A requirements traceability matrix RTM
• Alternative architectures options
• A roadmap for sun-setting the legacy systems

Environment: SQL Server 2012/2008R2, Transact-SQL, SSIS, MS Visual Studio, VB 6.0, C .Net, MS Office 2013

Confidential

Technical Architect/Technical Lead

• I worked as a contractor for the Defense Logistics Agency DLA Distribution Branch to capture data from passive RFID pRFID readers at DLA Depot sites and operational systems and have developed data warehouses to use the data for Business Intelligence BI and reporting. I developed a business case for eliminating the RFID COTS middle-ware product and bringing the functionality to an existing in-house programming group to manage/maintain. I had oversight of the development of prototypes, system test, and enterprise testing.
• I designed and developed automated systems in ColdFusion and T-SQL, creating automated extraction of data from Government data systems and an ETL process for loading it into a dimensional data model for advanced analytics. As part of this process I designed and developed a master data set for item identification by NSN, NIIN, CAGE, MROs, and DoDAACs.
• As Chief Technical Architect on the Logistics Data Analysis Tools LogDAT project for the U.S. Army Reserve, I was the chief designer for an enterprise-level data warehouse system 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 .
• I developed the system blueprint, technical strategy, roadmap for development and implementation, and business cases as necessary to move the project through the system development life-cycle SDLC .
• I documented and implemented disaster recovery planning, as well as continuous operations COOP systems planning and deployment. I 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.
• Once the system was operational, I managed sustainment of the data warehouse and related OLTP and BI solutions including day-to-day operations, capacity planning, end-user training, and system health monitoring. The system has over 5,000 users nationwide.
• I began onthe LogDAT project as a Senior DBA and was the only technical person on the project from my company. 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.
• I used agile methodology to rapidly design, develop, and implement an enterprise bar-code based asset management system featuring Win Mobile hand-held scanners, and had the initial operating capability fielded in 60-days.I performed hands-on installation and configuration of Windows Server 2000/2003/2008/2008R2, MS SQL Server 2000/2005/2008/2008R2, MS SQL Server SSRS SSAS, and other server-side software and services.

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, 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 middleware, ANSI EDI x.12, Gentran, LOGSA, DLMS, SAMS-E, PBUS-E, SARSS, USAFMSA, DRRS, D035K and DSS.

Confidential

Senior Database Architect Contract Consultant

Designed, developed, and refined very large data marts and data-driven enterprise-level web applications and reporting tools for the Business Information Analysis group. Using minimal verbal requirements definition, I developed custom web user applications in ColdFusion for data marts using advanced ColdFusion, DHTML and JavaScript programming.

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

Confidential

Web Architect

Managed and directed a team of nine 9 ColdFusion web developers in the Knowledge Services group of a large law firm, building large-scale data-driven web applications and Data Warehouse solutions for the Firm's internal use and for the Firm's clients. I performed hands-on coding as well as database and Data Warehouse design and optimization SQL Server 7.0/2000 , and authored design specifications and development and coding procedures.

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

Confidential

Manager, Corporate IT Services

• Started at the company as Web Services team lead and grew the team from two to nine developers while building-out the company intranet and enterprise web applications for HR, payroll, client management, time keeping, Business Intelligence, predictive analytics, and other beneficial areas.
• I developed a number of robust data-driven web applications for the company intranet using a SQL Server backend, such as online human resource data changes for employee contact information, status change, online annual reviews, with integrated work flows and approvals. Using SQL Server DTS and T-SQL, I integrated the company's PeopleSoft HR, Kronos Payroll, and Salesforce CRM data into a corporate data warehouse. I also created master data sets for clients and practices as well as a web interface for Master Data Management MDM .
• I was promoted to Manager of Corporate IT Services within nine months, to manage a staff of 26 personnel performing day-to-day operations of IT Services including servers, desktop, helpdesk, and web services supporting a global Corporation of 5,000 employees.
• I performed hands-on installation and configuration of Windows Server 2000, MS SQL Server 2000, and other server-side software and services.

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

Confidential

Senior Project Manager - Information Technology Solutions Group

• Starting as a hands-on analyst/programmer on the F-22 Advanced Tactical Fighter project, I went on to lead a very successful 2M systems development effort to automate the spare parts provisioning for the air vehicle featuring integration of vendor/government systems for a huge reduction in cost, as well as improvement in just-in-time spares capability and operational readiness.
• Working extensively with the Logistics Support Analysis Record LSAR Mil-Std-1388 data and systems development, I developed broad experience in Integrated Logistics Support ILS disciplines.
• I developed a web-based enterprise system and master database for Human Resources to enable personnel to make changes to their personal information name, address, phone, etc. company-wide on the intranet, as well as to schedule training classes and account for each employee's training history.
• I supported the Royal Air Force of the United Kingdom and the Royal Australian Air Force of the Commonwealth of Australia project teams withnetwork connectivity, desktop support, network servers and databases while they were at our facility during the manufacture of their new aircraft.
• I designed and prototyped a successful collaborative ecommerce solution for marketing of spare parts and tracking of spare parts through the repair cycle using cloud type technology.
• In response to a significant world-wide demand forLockheed memorabilia caps, t-shirts, pins, pictures, etc. , I implemented an online company store to sell these items over the internet. I developed and deployed a shopping cart application and set it up,resulting in increased in orders, reduced turn-times, and a 30 percent. increase in sales.
• I designed and built a repository of document images, aircraft drawings and an interface to the engineering Product Design Data System PDDS to create a Bill of Material data system tailored for logistics that included the ability to view engineering drawings and other technical documents on the user's PC.

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

Confidential

Senior Manager Product Support and Service Engineering

Hired as Service Information Manager to implement computer technologies and data integration. Later, promoted to Senior Manager of Product Support to manage and direct a staff of 20 supporting over 96K Piper aircraft in the field. I developed data marts for integration with FAA data systems such as the Service Difficulty Report SDR system, and FAA Registered Owners lists. I also integrated the SDR data and internal Warranty data system mainframe for modeling and safety of flight decision support to identify problem vendor parts and aircraft design issues.

Environment: Clipper, Dbase III , FoxPro, Professional File, Professional Write, Novell Netware

• Security Clearance Secret
• Federal Aviation Administration Pilot and Airframe Powerplant Mechanic
• Business Intelligence Architect Certification Cognos
• Adjunct Instructor of Computer Science at Chattahoochee Technical College
• Published in CALS Journal magazine in Summer 1993 edition
• 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.
• Published papers and presented them at the 14th and 15thInterservice/Industry Education and Training Conference IITSEC
• Founded R D Software company in 1989