Solutions Architect running Agile and Waterfall projects and partnering with the business.

• Smoothly integrated off-shore contract support team for ongoing EDW development and support• Jointly re-developed KPI metrics to improve performance, timeliness and accuracy. KPI’s used for Business Intelligence Dashboards, reports for automated analytics.• Seamlessly integrated both on-shore and off-shore development partners for Talend ETL processes• Designed and supported the development of new Asset Warranty capability for mobile application in order to expand warranty support for customer assets.• Expanded Enterprise Data Warehouse to support 5 additional streams from Oracle and MariaDB (AWS) source systems. Created Data Dictionary to document and support Master Data Management (MDM) and data lineage. Implemented logging, error detection and alert process.• Implemented Talend software (open source data integration tool) for all ETL processes using trigger based CDC with exception handling and alerts. Utilized SVN for source code repository. • Designed, supported development and led testing of new Customer Asset (~2M) and Supplier Parts cloud based MariaDB databases. Led to significant improvements in Data Quality and improved financial options for capital replacement, quoting and repair vs. replacement decision-making.• Designed and implemented an Oracle PL/SQL library set of tools to determine Mfg. Date and Age of Assets for 40% of 2M assets.• Led and managed multi-location and diverse Business Intelligence team and implemented Agile best practices after becoming Agile Certified Scrum Master (CSM) in 2018. Team completed 450+ stories and defects.• Led the design and development of the initial Enterprise Date Warehouse (EDW) in Oracle with on-shore consulting team (2016). Reduced initial hourly ETL from 23 minutes to 1 minute. Improved EDW updates from daily to hourly for near real-time reporting. Supported Dev, QA and Prod environments

• Managed Reporting Team with Data Mart and adopted Agile methodology in team.• Evaluated next generation micro-service to de-couple business function from core system.• Supported Accounting applications, reconciliation, reported and audit processes.• Initial design of new Enterprise Data Warehouse in Oracle.• Key member of IT transition team during company merger. Designed and jointly developed application to synchronize major customer between two systems. Supported transition of other customers to new platform and enhancement of new system to support existing customers.• Replaced Impromptu Cognos with SAP Business Objects (BO) for all Scorecards, Reporting and Financial Analysis. Managed licensing, on-site training and implementation.• Designed and implemented PM Compliance application for major customer ($120M Revenue).• Built Client Asset Database (Oracle) of 500K+ assets for two major customers. Provided enhanced Asset data for capital planning and Customer Budget Tool. Designed and developed library tools (PL/SQL) to bulk load, scrub and add warranty information. Initial systems integration w/major restaurant system for asset and service requests.• Member of design and implementation team for Oracle Revenue and Management Billing (ORMB).• Supported 2nd Contact Center to expand capacity and redundancy for FM• Migrated Data Mart from SQL Server to Oracle

• Transitioned to Project Management Office (PMO) as Solution Architect (Business Analyst).• Designed and supported development and testing of billing application in Oracle (PL/SQL) to support multiple customizable billing methods.• Numerous successful projects as Lead Solution Architect working with business on requirements, implementation, testing and support. Supported full SDLC.• Scaled IT platforms to support 250% growth in customer volume. Integrated off-shore software development partner to support growth. • Budget and Licensing for SAP Business Objects for internal and external reporting• Launched Data Warehouse and SAP Business Objects, Xcelsius and Crystal Reports. Provided on-site training courses on SAP Business Objects, WebI and Crystal Reports for all Business Analysts (2010-2011)• Internal training courses of product suite with all Business Analysts. Software development projects managed with JIRA. Upgraded Cisco network for scalability and redundancy.

• Promoted to VP, IT to lead IT team and manage Infrastructure, Development, Telecom and Budget• Updated IVR to increase self-service utilization from 75% to 90%, saving $175K in direct costs annually. Development of automated interfaces with 3rd party systems (Ariba and SAP) and client systems using XML, SFTP and flat file. • Upgraded, increased capacity and provided multi-carrier redundancy for telecom circuits, adding long-distance and local circuits for growth while reducing costs. • Designed Business Continuity/Disaster Recovery Plan which included fail-over, redundancy and scalability for servers, storage and network and telecom circuits. Consistently provided 99.97% systems availability.• Supported the addition of 40+ new customers including 7-Eleven in US and Canada. Enhanced systems to support Canadian market (currency, tax handling). Implemented new Guaranteed Rate client model across all systems. Added new restaurant verticals with multiple, well-known national franchises customers. Designed and developed extensions for Asset and Warranty handling database. Successfully planned, budgeted and implemented full telecom system upgrade of Avaya PBX, Call Management (CMS) VoiceMail system including VoIP implementation. Negotiated 40% savings in Avaya and 52% savings of Oracle licenses.• Coordinated and managed implementation of virtual server architecture with VMware and Dell SAN technology. Integrated company acquisition of telecom and applications. Implemented Oracle Standby DB for both Reporting and business continuity support (BCP). Reporting Data now available real-time instead of nightly refresh and 24-hour lag. • Identified and implemented system integration and reduced license costs. • Provided KPI and Metrics Scorecard for Service Provider performance and Service Center metrics.

• Scaled up Web Site, Contact Center and Telecom platforms to deliver 99.97% availability 24x7x365 • Reduced Telecom Software License cost by 30% while continuing to support growth• Rebuilt IVR using inContact (Web based SaaS) in 2005 for automated Service Provider for 70% of routine Contact Center activity in US.• Implemented Call Recording and Quality Management application. Supported Call Routing, Queue, Staffing and Metrics Reporting for Contact Center.• Supported Enron divestiture with stand-alone systems, network and SW licensing. Implemented new accounting system w/Great Plains in 10 weeks.• Leader of CT Avaya Users Council (2005-2011)

• Managed integration with Enron systems and network during acquisition to provide stable and scalable platform for additional customers. • Launched Performance Measurement Center (PMC) to manage client Sites, Assets & HVAC equipment• Scaled up IT and Telephony platform to support Exxon/Mobil nationwide (9K locations) and other clients.• Reduced Telecom costs by 32% by switching telecom carriers• Led development of automated Financial audit process for invoices. Developed and provided reporting from our OLTP systems to reconcile our financials (2002 and later).

• Through acquisition by HSB, joined senior team to lead IT in new subsidiary, IPT.• Launched new IPT Oracle application and facility maintenance and asset management services to support national customer (Blockbuster) with 9K locations. Supported development of PowerBuilder IPT Work Station (IWS) on client/server 3-tier architecture.• Supported development of IPT web site and IVR for customers and service providers to request repair and manage service activity.• Managed and grew IT team from 2 to 10 full-time with support from outside contractors for data center and telecom. Responsible for systems, network, telecom, security, licenses and budget• Led development of Reporting solution.maintenance.

• Designed and built new Enterprise IPT Oracle DB for Facility Maintenance services system. IPT was designed to support Customers, Service Providers, tracking of Repair and PM activity for 30+ trades in the US & Canada• Oracle DBA and upgraded from Oracle6 to Oracle7 • Project Manager for Client/Server PowerBuilder applications• Development of Enterprise Data Model using Oracle CASE and Erwin LogicWorks• Project Manager and programmer for Oracle Forms application and Expert System

• Utilized Enterprise Data Modeling tool (erwin) to design, develop and document Oracle DB’s.• Development of Client/Server applications using PowerBuilder 3.0• Oracle DBA on VMS for all company Oracle databases.• Founder, leader and member of CT Oracle Users Group (COUG, 1990-1997)

• Responsibilities included Oracle DBA (VMS), LAN Administrator and PC Support• Developed Expert Systems and Oracle DB for Transformer Oil & Gas Analysis (TOGA) and Oracle DB for Equipment Repair• Used Oracle CASE Tools and Oracle SQL*Forms 2.3 and 3.0 to develop R&D Applications • Oracle DBA on VMS, LAN Administrator, PC support, Performance Tuning

• Development of Computer Modeling for Hazard Analysis of Fires (C programming). Integrated w/fuel source properties database.• Implemented first PC based network for HSB (Novell Netware)• Designed and developed National Databases for property insurance line, CAD Information System and Accounting and Quoting system• Setup and configured PC-based CAD system (CADVANCE) with libraries, symbols and macros