Kenneth J. Ammann

  • Azure Data Architect
  • Los Angeles, CA
  • Member Since Mar 18, 2023

Candidates About

    Kenneth J. Ammann

 

 

 

Leadership:

 

 

§  A technology consulting leader with over 20 years working between business owners, stakeholders, C-level executives, agency directors, and technology teams to achieve results that meet strategic business objectives in both public and private sectors.

 

Areas of Expertise:

 

§  Microsoft Azure and Azure Data Architectures

§  Healthcare Analytics, Pharmacy, and Business Application Technical Leadership

§  Microsoft SQL Server Data Platform and Data Warehouse Development

§  Microsoft Enterprise Solutions (SharePoint, Dynamics CRM BizTalk, and SQL Server)

§  Microsoft Business Solutions (GP, AX, and CRM)

§  Integration Architecture (eConnect, Azure Data Factory, SSIS)

 

 

 

Certifications:

 

§  Microsoft Certified Solution Expert SQL Server

§  Microsoft Business Solutions Expert (GP, AX, and CRM)

§  MCTIP and MCTS SQL Server 2008\2005 Database Developer and Administrator

§  Microsoft Certified Application Developer (.NET)

§  Microsoft SQL Server 2012\2008 Certification Exam Writer and Alpha Test Reviewer

 

 

 

Solution Platforms:

 

§  Microsoft Azure – Azure Data Warehouse Terabyte Scale– Azure Data Factory

§  MS SQL Server 2014\2012\2008\200x\ (Analysis Services, Reporting Services, and T-SQL)

§  Dynamics 365 – GP - CRM

§  Microsoft Visual Studio 2017\2015\2012\2010\2008\2005 (VB, .NET, and C#)

§  Microsoft Business Solutions (eConnect, Integration Manager, Scribe and BizTalk)

 

 

 

Special Achievements:

 

§  Hewlett Packard Inc. HPI Azure technical consumption lead, KAI project, $50 Million Hadoop/Azure global data warehouse lift and shift from legacy system to Microsoft Cloud including multi-terabyte Azure Data Warehouse and Microsoft Analysis Services. Architecting and coordinating development activities onshore and offshore as well as working directly with Microsoft product teams.

§  Engagement Manager and Technical Architect for California Department of State Hospitals Dynamics CRM implementation, encompassing five hospitals and affecting all 58 counties and superior courts. State award-winning project and Microsoft funded case study on multi-hospital pharmacy analytics and clinical dashboard data warehouse.

§  Senior Consultant for Microsoft .Net eCommerce site, processing 25,000 orders annually and $8-$12 million dollars per month in sales, with real-time integration between ERP, Dynamics GP, Acellos, and custom .Net Systems.

§  Developer of multiple high-volume and mission-critical financial system integrations, processing up to 20,000 daily transactions utilizing EAI, web services, and Microsoft BizTalk/SOA.

§  Director of 15 developers and database administrators as architect, lead developer, and SME in multiple engagements with national and international scopes.

§  Designed and developed 90 applications, ranging in size from single user to enterprise-wide.

Experience:

 

 

2015 – Present

 

TechInnovo

Azure Data Architect – Managing Partner

 

 

§  HP, Inc./Deloitte/Microsoft – Implementation of HPI Global multi-terabyte data warehouse on Microsoft Azure SQL Data Warehouse.  150 GB of data loading 3 times per day spanning Finance, Sales and Supply Chain business domains.

§  Developed HPI global data warehouse development and operational run-book in coordination with Microsoft Azure Data Warehouse product team.

§  Architected custom Azure Data Factory generation tool that programmatically created 150 ADF pipelines and components for production data loading.

§  Enterprise Architect – Boral North America - Eldorado Stone Inc. Designed and developed Dynamics GP data warehouse for international homebuilder supply, focusing on Sales Order Processing modules utilizing Microsoft SQL Server 2012 and SharePoint Performance Point Services to deliver dashboards, reporting, and advanced analytics.

§  eCommerce Application Manager- .Net eCommerce application with eConnect Integration to Dynamics GP.

§  Warehouse Management System Integration Architect and Developer – Developed .Net Application between Radio Beach and Dynamics GP utilizing eConnect.

§  PowerBI – Developer to Dynamics GP Data Warehouse.

 

 2009 - 2017

 

  Planet Technologies

 

Responsibilities:

 

Practice Manager (Data Analytics and Microsoft SQL Server): 2013 – 2017

Senior Microsoft Consultant and Data Architect: 2009 – 2013

Microsoft Managed Partner and technology leader developing enterprise solutions for private and educational institutions and for federal and state government agencies.

§  Technical Architect – University of Tennessee, Haslam Graduate School of Business.  Implemented and integrated Dynamics AX 2012 R3 and Dynamics CRM 2015.

§  Engagement Manager and Enterprise Architect – California Department of State Hospitals.  Upgraded Pre-Admission Reservation and Tracking System by developing a Dynamics CRM (xRM) application aiding in the standardization and modernization of the State Hospital Admission and Court Commitment process with integrated Business Intelligence to facilitate process improvement. Provided leadership to executive steering committee and project directors to scope and deliver the project. 

§  Pilot Program Enterprise Architect and Trainer – US Federal Agency. Developed pilot program now replicated across the country that quickly empowers both public and private organizations to realize additional value from Microsoft software they already own.  Resulted in over $1 million in new licensing revenue and $500,000 in consulting revenue.

§  Pilot Program Architect – County of Riverside Office of the Tax Assessor. Developed pilot program for countywide Business Intelligence reporting during transition from mainframe system, resulting in new reporting tools and reduction of mainframe migration costs.

§  Project Manager and Data Architect – California Department of State Hospitals. Created a Pharmacology and Pharmacy Cost Data Warehouse to consolidate all patient pharmacy dispensing records for executive dashboards and data mining.  Microsoft published whitepaper for medical data and “big data.”

§  Project Leader and Technical Architect – U.S. Department of Energy (Oak Ridge National Laboratories). Designed and led the development of health care research data tracking and distribution system for Center for Medicare Services utilizing Microsoft Dynamics CRM, Microsoft SQL Server, and SQL Server 2012, Hadoop, and Microsoft .NET.

§  Technical Architect – U.S. Department of Energy (Office of the CIO). Designed, developed, and implemented the first Sharepoint web-based business automation project contract administration and approval, encompassing the IT operations across the entire Department of Energy.

§  Technical Architect – U.S. Department of Energy (Office of Electricity). Designed, developed, and implemented the first externally facing SharePoint web-based developed and implemented application collecting information from private and public entities across the U.S. for Recovery Act grant administration.

§  Technical Architect and Project Manager – Orange County Community Resources. Managed upgrade of SharePoint 2007 to SharePoint 2010 and implementation of enterprise-wide Business Intelligence platform. Created C-level to field-level dashboards and Business Intelligence tools.

§  Project Leader and Technical Architect – West Virginia Governor’s Office of Technology. Utilizing Microsoft SQL Server 2008, Analysis Server 2008, Integration Services 2008, Reporting Services, SharePoint, and Performance Point, deployed final system with 20 million records integrated with IBM DB2 mainframe for up-to-date dashboard reporting.    

§  Lead Technical and Functional Consultant – Liberty University. Provided leadership, planning, and hands-on development for one of the largest implementations of Microsoft Dynamics CRM (3.5 million contacts).  Managed XRM implementation spanning multiple departments, user groups, and activities that utilize multiple integrations including telephone system integration, CRM SDK customizations, and Scribe toolset.

 

 

 

 

2005 - 2009

 

Nexus Innovative Designs

 

 

Principal Consultant and Managing Partner

Responsibilities:

 

Microsoft Business Solutions Partner, ISV Application Architect, and advanced technology consultant serving clients ranging from Fortune 500 corporations to emerging companies.  Provide comprehensive financial system support and technology services, with special focus on system implementation and integration, data warehousing, advanced reporting, Sarbanes-Oxley solutions, and business process improvement through automation.

 

§  MBS ISV Application Architect: BTConnect – BizTalk 2006 and MBS Great Plains eConnect integration.

§  MBS ISV Application Architect: Accelerated Compliance Management System for MBS Great Plains security reporting.

§  Project Manager and Technical Leader: International MBS development outsourcing.

§  Technical Architect and Development Leader: data warehousing, Dynamics Great Plains (GP) integration, Dynamics CRM integration between Dynamics GP and Microsoft Commerce Server, and Dynamic CRM implementation and customization with BizTalk integration to external systems.

§  Microsoft SQL Server 2008 Exam SME and question author.

 

 

 

 

2003 - 2005

 

FMT Consulting

 

 

Senior Technology Consultant

Responsibilities:

 

Microsoft Business Solution Partner and Microsoft Gold Partner implementing Microsoft Great Plains, eCommerce Solutions, MS CRM, DBA services, and custom application development.   Managed multiple clients and development projects while participating in internal product development and direction. 

 

§  Custom .NET application development, web app, and web services.

§  Database administration, schema design, and development.

§  Custom supply chain application: Microsoft thin-client web application utilizing Visual Studio and internet information server.

§  MS SQL Server Data Mart and Data Warehouse.

§  Great Plains BizTalk/eConnect system integration.

 

 

 

1999 - 2002

 

Application International Corporation (AIC)

 

 

Chief Technology Officer

Responsibilities:

 

Led through hands-on development of a multi-module, enterprise-wide, web-based application now utilized by Ford Motor Company, FedEx Ground, Eaton, Cooper Industries, Tower Automotive, and other Fortune 1,000 corporations spanning over 40 countries. Included an extensive set of application reports, automated process enforcement tools, and a Data Mart with the application.  Provided strategic technological vision, managed development staff, delivered technical sales presentations to prospective customers, coordinated with clients for implementation, and directed ongoing customer support. 

 

§  Managed 16 person offshore development team. 

§  Oracle and MS SQL Server development (triggers, stored procedures, schema design, and managed hosting center and disaster recovery).

§  Microsoft COM N-Tier architecture design and development (Visual Basic and .NET interoperable application).

§  Microsoft N-Tier COM+ thin-client web application development.

§  Oracle and MS SQL Server Data Mart development.

 

Education:

 

 

§  University of Southern California, Graduate School of Economics

§  University of Southern California, Bachelors of Arts in East Asian Studies (Emphasis on Japanese Language)

§  University of Southern California, Bachelors of Arts in Economics

§  Tokyo International University, Japan, Exchange Program

 

Technology Keywords:

Microsoft Business Solutions, Great Plains, Dynamics GP, Axapta, Dynamics AX, Solomon, Dynamics SL, CRM, Dynamics CRM, SQL Server, Visual Studio, BizTalk, eConnect, Scribe, Integration Manager, Web Services for Dynamics GP, VB.net, C#, SQL Reporting Services, Analysis Services, DTS, Integration Services, Dexterity, Visual Basic for Applications, SharePoint, Oracle, SQL Server Analysis Services, SQL Server Reporting Services, SQL Server Integrations Services, Microsoft Office SharePoint Server, PerformancePoint Server, Business Intelligence, SQL Server 2012

 

 

  • Experience:
    20 Years
  • Birthday:
    12/31/1969

Contact Us

This website requires cookies to provide all of its features. By using our website, you agree to our use of cookies. More info