Tom Ingram, PMP, SharePoint "Hands-On" Specialist in Migration, Architecture, Development (No-Code and Coded Solutions) Technical BA, Technical PM
Dallas, Texas,
- 34 SHAREPOINT PROJECTS: Since 2004 have personally led two global, 13 national / regional and 19 Smaller Projects using SharePoint Online, SharePoint 2016, 2013, 2010, 2007, 2003, all versions and associated technologies.
- SHAREPOINT ROLES, TECHNICAL, HANDS-ON SKILLS: Migration Specialist, Technical Architect, Solution Architect, installer, admin, power user trainer. Coded and No-Code solutions developer including SharePoint Designer Workflows, Nintex Workflows and Forms, InfoPath, Flow, Power BI, PowerApps, PowerPivot, SQL Server 2008, 2012, 2014, SSRS, SSIS, SharePoint Synch Tools, getting data from big systems, integration including SAP, Workday, BAAN, Oracle. Server 2008, 2012, 2016, Azure Hosting and related network technologies. Javascript, Jquerie .NET, HTML site development with Dreamweaver and Muse, conventional IIS web sites. I own and manage a dual server on premise SharePoint 2013 and 2016 development/test/hosting system, a SharePoint Online/Office 365 dev/test system and an Azure hosting dev/test/backup system. These systems have provided test / dev / prototype / backup and production solutions to 20+ clients.
- BUSINESS ANALYST, TECHNICAL PM SKILLS include advanced process mapping, process improvement, extensive requirements definition, specification writing, project planning, Agile and Waterfall methodologies, issue, task, status management on project budgets up to $10 million. BA and PM skills learned during successful previous career in conventional IT Projects (small, medium and large.)
- CREDIBLE WITH senior business executives, users and technical peers due to technical skills, rapid results, business experience and performing as promised. See http://www.tia4.tiainc.net/Public/TomIngramResumeMaster.pdf for full details on all projects.
Employment Chronology (Project Details Below)
2013-Present: Tom Ingram & Associates, Inc., Dallas, TX, owner of small consulting firm. SharePoint consulting and contract roles as Solution Architect, developer (of No-Code solutions), installer, administrator, technical BA, technical “hands-on” PM for Exeter Finance, Mitel, a Private Equity Manufacturer, Frontier Telecom, OCI Chemical, Golden Spread Electric COOP, TIA Hosting Service, Graphic Solutions Group, Brooks Consulting, Morrison Wholesale Distribution, Citizens Business Bank, Pacific Union Mortgage, J.F.Shea Mortgage Company / Homebuilder and Caliber Mortgage. As Technical PM / BA, led a large cloud-based, Azure Website Project for Golden Spread Electric COOP.
2012-June, 2013: Cognizant, Dallas, TX, Associate Director in SharePoint Practice. SharePoint consulting roles as Solution Architect, developer (of No-Code solutions), technical BA, technical “hands-on” PM, pre-sales for Hyundai Motors, Celgene, Baxter Healthcare and Johnson Controls.
2001-2012: Tom Ingram & Associates, Inc., Dallas, TX, owner of small consulting firm. SharePoint consulting and contract roles as Solution Architect, developer (of No-Code solutions), installer, administrator, technical BA, technical “hands-on” PM for Responsive Education, Ettinger Rosini, Vista Machining, City of Kennedale, TX, Ruhrpumpen Manufacturing, Flowserve Manufacturing, Level 2 Design, Handleman and Crossmark. Also led conventional IT, PM, BA and Expert Witness Projects for City of Carrollton, TX, Renaissance Capital, First Command Financial, Engineered Air Balance, Grote Consulting.
2000-01: Decision Consultants, Inc., Dallas, TX, Director of Delivery supervising 160 consultants. Hands-on Program Manager, technical Project Manager, technical BA consulting roles for Nortel and Verizon.
2000, Prior To: Cambridge Technology Partners, Dun & Bradstreet Software, Xerox, IBM Management Team-Led Startup (Amerisource) Unisys, TIA in Dallas, TX. Roles included technical PM, technical BA, technical Sales and Reengineering Consultant for City of Fort Worth, TX, Alliance Data Systems, Celanese, Johnson & Johnson subsidiary, Federal Express, Texas Instruments, Northern Trust, Frito Lay, MCI, State of Texas, Union Pacific Railroad (natural gas), Kidder Peabody, George K. Baum Financial and Farmland Industries.
Education, Certifications, Professional Contributions:
· Iowa State Univ. – BS, Business Admin, minor work in Electrical Engineering
· PMP Certification by Project Management Institute, 1994
Selected SharePoint Projects
Exeter Finance (Sub-prime Auto Lender) CEO Dashboard in Place in 10 Days using SharePoint Online, Office 365, SSRS, SSIS, SQL Server, SQL Reporting Server, Excel Services and Visio Services. Power Pivot, Power BI, Sharepoint 2016 Solutions Mapped Out for Dozens of Huge Excel Files to Auto-Refresh and Present Graphs in Executive Dashboard
(May 2017)
ROLE: SharePoint Architect, Consultant, BA, Technical PM, No-Code Solutions Developer
KEY WORK: Site Architecture, Standard Site Templates, No-Code Solution to previously custom-coded SharePoint 2010 on premise system, SQL Server, SSRS, SSIS, SQL Reporting Server, Power Pivot, Power BI, Sharepoint 2016, Excel Services, Visio Services Solutions to Difficult Auto-Refresh Problem
BUSINESS RESULTS SUMMARY: CEO Dashboard provided CEO with a “One-Click”, auto-refreshed path to key measures for business – no matter where information located in company. E.g. graph showing percent of first payments received within five days was best leading indicator of future defaults. Project put on hold due to company-wide license cost of Office 365.
TECHNICAL RESULTS SUMMARY: Release 1.3 of CEO Dashboard, a fully functioning prototype, in place and used by CEO in 10 days. Extensive, fragmented, difficult to find and use reports already existed in SSRS and Excel using SQL Server, SSIS, etc. Data required extensive labor to refresh and was not available to CEO until 11 a.m. each day. Releases 2.0 and 3.0 designed to auto-refresh, making data up to date and available to CEO at 6 a.m.. Found no-code solution to previously coded customization of Sharepoint 2010, designed site hierarchy, standard site templates, cosmetic look and feel and project plan for six month rollout to 1500 employees.
Mitel (Telecom Hardware and Software Manufacturer), Migration, Clean-up, Consolidation of SharePoint 2003, 2007, 2010, 2013, Google Sites, Lotus Notes for 5500 Global Employees to SharePoint Online (Office 365) with Advanced SQL Server, SSRS, SSIS Applications, Project Online, Project Server
(November 2015 to April 2017)
ROLE: Primary Technical Architect, No-Code Solution Developer, Trainer, Consultant, BA, Technical PM, minor work with SharePoint 2003, 2007, 2010, 2013 On-premise
KEY WORK: Migration included Google sites (200 GB), twelve on-premise SharePoint servers (400 GB), three home-grown intranets, 1,000+ Lotus Notes databases, network file shares (500 GB). Advanced no-code solution development. Significant cosmetic overlay software. Extensive external sharing with third parties. Six advanced project management applications (PMO) with advanced scripts, integration to SAP, Work Day with SQL Server via SSIS, SSRS, Power BI, Flow, Power Apps, Excel Services, Visio Services for executive dashboards. Advanced InfoPath, Designer Workflows. Advanced document management workflows. Extensive Power User Training, 50+ advanced apps developed by power users.
DEPARTMENT SOLUTIONS FOR: R&D, Engineering, Sales, Pre-sales, Channel Support, Project Management, Operations, Quality Management, Professional Services, Product Management, Customer Service, Training, Competitive Intelligence, Marketing, HR, Legal, Finance and IT, Cloud, On Premise and Mobile Divisions.
BUSINESS RESULTS SUMMARY: SharePoint Online acceptance is so strong client is now decommissioning a dozen+ other legacy applications and migrating the apps to SharePoint Online. Savings to IT dept. between $500,000 and $1 million over 5 years. Applications and Sub-projects are identified and underway totaling approximately $2,750,000 in payback from approximately $1,000,000 in total cost. A single power user (Max) has completed a $100,000 payback migration and is currently working on 15 more apps totally $500,000+ 5-year payback. 30 other power users trained and developing similar solutions. License cost saving and project outcomes improvement of $2.5 million/year on Mobile project management redesign. (Cost and paybacks are estimates.)
TECHNICAL RESULTS SUMMARY: Led project from basic Office 365 implementation with five SharePoint Site Collections to 50 site collections and 500+ sites. Extensive use of Metalogix, DocAve, ShareGate tools to complete the primary work of migration and integration of: Approximately 200 GB of user sites, pages and files from Google Sites, Twelve On-Premise SharePoint systems (2003, 2007, 2010) totally 400 GB, User sites, pages and files from three home-grown intranets and numerous network file shares (500 GB), Over 1,000 Lotus Notes databases including some 200 complex apps. Converted multiple “Franken-Apps” to solid, documented, backed-up applications. Apps included color dashboards with link to detailed records. Prototyped Power BI, Flow, Power Apps, Excel Services, Visio Services and put dozens of apps in production for executive and other dashboards. Redesigned a fragmented, fragile, difficult to use project financial reporting and management system used to manage $25 million+ in projects FROM a SQL Server, SSRS, SSIS, Project Server, Project Web Apps system to a stable, easy to use SharePoint Online, SQL Server SSRS, SSIS based system with estimated license cost saving and project outcomes improvement of $2.5 million/year.
Case study http://www.tia4.tiainc.net/Public/TelecomHwrSwrCloudMobileMfrSuccessStory50MASTER.pdf (password required)
Private Equity Owned Textile Manufacturing Company, SharePoint 2013, Integration and Update of Plant ERP Systems from 25-year-old Custom System and 15-year-old BPCS to Current Cloud-based Solutions, Migrate, Recreate Super-Low-Cost Online Order Entry System for Retailers, Integrate Orders from Six B-to-B Websites Using SQL Server, SSRS, SSIS, Datasynch Studio.
(November 2016 to March 2017)
ROLE: Consultant, BA, Technical PM, Minor SharePoint No-Code Solutions Development
BUSINESS RESULTS SUMMARY: Used Earned Value project accounting and management to show private equity investors that project would cost $500,000+, people were not completing assigned tasks and milestone goals were hopelessly optimistic. Further analysis concluded the project was not cost-justified. Project was scaled back and taken in-house.
TECHNICAL RESULTS SUMMARY: Conducted analysis, business process definition, mapping, use case definition, requirements, defined business outcomes needed, developed prototypes with SQL Server, SSIS, SSRS, Datasynch Studio and SharePoint to demonstrate solution to migrating super-low-cost order entry system to current technology. Consolidated all information and specifications to a single work management SharePoint site, tracked action items for numerous technical and management team members.
Frontier Telecom, SharePoint 2013, Clean Up, Consolidate, Document Multiple SharePoint Farms for 15,000+ Users, 15,000 Key Words in Term Store, Enormous Merger Integration Problems, Integration Problems with 20 SharePoint Servers, SQL Server Queries, Reports on “Who Using What” in SharePoint, Company Wide.
(August 2015 to October 2015)
ROLE: Business Analyst, Technical Documenter, No-Code Developer, SQL Server, Queries
TECHNICAL RESULTS SUMMARY: Documented architecture, servers, accounts, passwords for 3 farms including 20+ servers. Determined Term Store problems due to 15,000 key words, old systems never cleaned up, consultant make-work, etc. Developed No-Code solution with InfoPath and Quick Apps to manage change requests.
Golden Spread Electric Utility, Office 365, SharePoint Online, Initial Deployment, Company-wide
(August 2014 to July 2015)
ROLE: Solution Architect, No-Code Solution Developer, Consultant, BA, Technical PM
KEY WORK: Design architecture, single sign-on (OKTA), Exchange 2013 and ADFS integration for full Office 365 deployment, 100+ users, extensive power user training, coded and No-Code Solutions, oversee vendor development as technical BA/PM
DEPARTMENT SOLUTIONS FOR: Company-wide Employee Portal, HR, Compliance, Regulatory Issue Tracking, Legal, Admin, Field Operations, IT.
BUSINESS RESULTS SUMMARY: $500,000 project, on-time, on-budget, user and executive management delighted, SharePoint adopted company-wide with a dozen power users continuing to build solutions. Employee portal widely used, reinforcing corporate values daily. 25+ applications put into production, being maintained and enhanced by power users. Other utilities have spent $2 Million+ to accomplish similar projects.
TECHNICAL RESULTS SUMMARY: Agile / Iterative development used to manage $500,000+ of vendor services. Pilot (using on premise Active Directory / Exchange 2008) through full production roll out with OFFICE 365 EXCHANGE 2013, ACTIVE DIRECTORY FEDERATED SERVICES. 5 site collections and Project Online (Project Web App.) Personally developed 15+ additional site collections and solutions for applications not provided by vendor. Cosmetic look and feel customization. Enforced rigorous TEST/DEV to PRODUCTION CODE and RELEASE MANAGEMENT discipline including TECHNICAL and user DOCUMENTATION for new features. SINGLE SIGN-ON implemented with OKTA SSO. Produced SITE MAP of all 40+ SharePoint sites (development and production.) PERFORMANCE TESTING, FEATURE TEST LAB, STANDARD LOOK, FEEL, COLOR PALATE AND TOP LEVEL DEPARTMENT SITE implemented. MOBILE DEVICE SUPPORT for all apps. STANDARD PROTOCOL FOR O365 USER SETUP. TECHNICAL DOCUMENTATION and self-sufficiency for client. NUMEROUS ADVANCED NO-CODE SOLUTIONS SUCH AS RAPID TIME SHEET SOLUTION WITH PROJECT COSTING. ADVANCED PROJECT MANAGEMENT TOOLS and compliance with PMO standard methods. MIGRATION OF NETWORK FILE SHARE. SEE TECHNICAL CHALLENGES below.
Golden Spread Electric Utility, Conventional IIS Website, Multi-server, Azure Hosted, Advanced Public Dashboard
(August 2014 to July 2015)
ROLE: Technical Project Manager, Azure Architecture, Install, Critical Hands-on Technical BA Contribution (designed primary screens.)
KEY WORK: Develop Conventional Public Website with Confidential Section Displaying Real-Time Power Generation Dashboard, Responsive Design for Mobile Devices, Azure Hosted
BUSINESS RESULTS SUMMARY: $500,000, 6 month project completed on time and on budget. Received commendations from executives on success of project and SIGNIFICANT IMPROVEMENT in how the company is perceived by external board members and customers. EXTENSIVE SENIOR EXECUTIVE PARTICIPATION. See commendation from executive.
TECHNICAL RESULTS SUMMARY: Updated the company to current website technology including responsive design for mobile devices, ease of update and executive dashboard showing real-time power generation. Solved problem that old website was so antiquated and difficult to update that company was losing credibility with external stakeholders. Received commendation for second large success precedent for Agile development. Overcame technical challenges due to Azure, SSO, interface to legacy SCADA system, slow performance. Enforced TEST/DEV to PRODUCTION CODE and RELEASE MANAGEMENT discipline.
TIA Hosting / Cloud Service, SharePoint 2003, 2010, 2013, 2016, SharePoint Online, Production and Test / Dev Services to Clients, SQL Server, BCS, SSRS, SSIS Integration to Big Systems
(June 2005 to Present, Part Time)
ROLE: SharePoint 2003, 2010, 2013, 2016, SharePoint Online Architect, Developer, Admin, Installer
KEY WORK: Migration and Upgrade of 8 GB Content Databases, SharePoint 2003 to 2010 to 2013 to 2016, Single Server to Dual Server, Outsourced to In-House, Virtual Development / Production Servers Supporting Multiple Customers. Office 365, SharePoint Online development environment.
BUSINESS RESULTS SUMMARY: Provided private cloud, hosted SharePoint to a dozen+ clients. Rapid Results, clients able to build prototypes same day engagement agreement signed. Included all 2010 and 2013 advanced features. All sites, content databases, site collections and dozens of applications successfully upgraded and improved (with no loss of data) backed up and 100% client satisfaction with hosting service.
TECHNICAL RESULTS SUMMARY: Personally architected, installed, configured and administrated SharePoint Hosting Services for a dozen clients over 10 years. Began in 2005 using hosted SharePoint 2003 service. Declined to upgrade to SharePoint 2007 due to stability concerns and served numerous customers until 2010 when I purchased server space in a data center and migrated the content to SharePoint 2010. In 2014 I purchased servers, installed them in-house and completed a full conversion / migration of six SharePoint CONTENT DATABASES totaling 8 GB from SharePoint 2010 to 2013 Enterprise with all primary features installed and available to clients. Installed and configured SHAREPOINT ONLINE to further support clients. Installed SharePoint 2016 (VMware) in April of 2017.