strategictech.org empowers nonprofits with technical planning and tactical projects to augment their organization initiatives. We ensure the technology compliments the mission and scales to ensure success.

New England Advisory Board Member at Let’s Get Ready 2/15-present Let's Get Ready provides low-income students with free preparation, admissions counseling and support services needed to gain admission to and graduate from college. • Served on the Gala Committee and on roundtable for career nights with students.• Developed insights into program efficacy using statistical techniques.

Senior Architect at UKG formerly KronosResponsible for distributed data layer on the Google Cloud Platform of new Kronos Workforce Management SaaS product. o Mentored, advised and guided other architects, developers and Database Administrators worldwide to build global capacity and skills across the company.o Created the technical and business roadmap to migrate the product internal databases to Google Cloud SQL to reduce cost and concentrate resources on core business competencies.• Created a multi-tenant distributed persistence architecture for the new product.• Designs and implementations included High Availability, Disaster Resilience, Multi-tenancy, Data Life Cycle, Performance, Robustness, Maintenance and Upgrade.• Designed extensions and wrote the requirements for 3rd party vendor products to be used internally by our product.

Senior Data Architect at Dynatrace formerly Compuware, 4/12-2/15• Mentored geographical dispersed group managers and technical leads.• Presenter at Big Data 2014, Boston System Engineering and user conferences, e.g, General Assembly.• Created the technical data road map of multiple, integrated SaaS platform products.• Evolved the company’s technical architecture to move to the cloud (AWS EC2 and RDS) and horizontally scale high volume operational & intelligence warehouses.• Introduced technology to migrate data centers reducing total cost, risk and downtime from 5 hours to 15 minutes, positively affecting revenue and customer satisfaction.• Implemented the integrated data model and warehouse for cloud and on-premise products. • Led and drove a project to standardize time across product offerings with zero downtime.• Created the Master Data Management of data sources, dimensions, metrics, derivatives, ETL and cost.• Created a Data Access Layer to ensure calculation and performance consistency.• Created a sharded data model for existing database to facilitate scaled, cloud migration.• Solved numerous performance, scale and operational issues involving schema changes, data partitioning, data latency, key conflicts, table, view and stored procedure refactoring.• Implemented distributed queues (using Flume) as a replacement for transactional replication.

Senior Staff Architect at Iron Mountain Digital acquired by HP, 1/10 -4/12The product is Cloud and on-premise based Enterprise Backup, Retrieve and eDiscovery.• Technical lead for combined distributed scrum team in India and US.• Refined requirements and created the database interface and procedures to evolve the next generation product.• Improved performance and maintainability of database retrieval for partitioned Very Large Database.• Designed a conflict resolution algorithm to support distributed, multi-user file synchronization.• Designed next generation server architecture for Enterprise Backup and Legal Hold.

Data Warehouse Architect (Consultant) at DataXu acquired by Roku, 9/09-12/09The project was to build a data warehouse that produces reports showcasing DataXu advertising effectiveness.• Refined requirements and produced detailed engineering spec.• Designed and implemented the architecture, schema and user’s SQL.• Extract, Transformed and Loaded (ETL) from Hadoop and Hive in EC2.

The product was an extensible, highly performant data appliance that was Oracle compatible for application transparency.• Managed a staff of 23 developers/consultants. Hiring and administrative duties. • Defined functional and performant architectural solutions in applying SQL-92 and Oracle vendor extensions, to our proprietary massively parallel database to support our transparency layer.• Researched Oracle, DB2, SQL Server extensions, federated database issues, and Aggregates.• Defined, scoped and ensured timely feature releases and resolved customer escalations issues.

ClearQuest (CQ) is an Enterprise Change Management System, enabling customized schema designs.• Designed the Meta Upgrade for a distributed database with automated new metaschema, and migration of production customer data. Zero data loss or corruption with very little downtime.• Encapsulated database layer tests for ClearQuest. Testing was at the SQL and ODBC-level on multiple platforms for 4 database vendors. This layer of testing was absent in the product before.• Rewired an enterprise customer's down database who had run out of available record ids. This entailed developing software under pressure to ensure that referential integrity was maintained, while freeing up ids to allow continued use of their database. This had never been done before.• Developed a utility to convert deprecated Oracle datatype use. Work involved coordinating both database conversion and application awareness in a distributed database environment.• Documented database metaschema and schema, including explicit and implicit referential integrity. This is the basis of CQ database QE and Support training courses.• Responsible for ClearQuest database and ODBC Globalization project.

Compete, Inc. provides companies quantitative advisory services on competitor activity using web data.• Hired and managed technical staff of 6 including Data Miners, DBA and Developers. Moved Data Mining Group from San Francisco to Boston with no business interruption or downtime. Motivated, mentored and directed staff.• Brought online and productionalized a multi-terabyte Linux/DB2 Data WebHouse and Vertical DataMarts. Focused the business requirements, designed the logical/physical schema, wrote the complex, performant SQL and created templates for data miners. Created queuing system to alleviate concurrent performance issues. Architected and Implemented database abstraction layer in Python that hides the SQL and transport layer complexity (Windows and Unix) from the Business Analyst.

TopicalNet automatically classifies content including Internet pages, text, Corporate Intra/Extranets.• All aspects of technical and administrative management, including interviewing, hiring, layoffs and mentoring and reviews of a 10 person development group containing senior programmers, system administrators, database and web developers. Responsible for putting together a group from scratch that extended client websites (over 300) with our content. Created their technical toolset. • Took company from R&D environment, using Unix/C/C++ to a flexible, product-based environment (Apache, MySQL, PHP). Put together resource plans and project schedules. Managed the technology and defined deliverables for strategic business relationships. Liaison with 3rd party software developers.• Implemented 65% Performance Improvement to Terabyte Oracle Production Data Warehouse, included Schema redesign, table partitioning, indexing, data reduction, SQL and Pro*C optimizations. • Technical Architect and Project Manager of MediaPlanner, the key technical product for the company. Designed the database, and managed the 6 person technical team to create a web-based, layered product that allows Media Planners to incorporate demographics and psychographics in their media campaign. Technology components used are a MySQL database implemented with JSP/JavaBeans and presented in HTML from an Apache Server, to complete the 3-tier architecture..

• Designed and implemented an architecture which allows real-time deployment of our custom content by non-technical webmasters. This entailed creating constantly running processes programmed in C++, with multi-threaded socket calls across redundant servers. The processes update master/slave name-servers and deploy new and changed content displayable at users’ sites. Architecture optimized retrieval while supporting redundant, independent servers. Designed a user-friendly, web-enabled front-end for the process.• Created a Virtual Account Database which used web-spidering to pull information from financial accounts in other databases. Implemented all database access/update routines in C++/SQLServer. • Designed and implemented data parallel algorithms for Oracle applications on shared-memory (SMP) Unix systems. Techniques included named pipes, threads, mutexes, ramdisk, embedded SQL (Pro*C++), Oracle Parallel Query Option, disk striping, advanced SQL indexing and data buffer cache tuning. • Numerous performance improvement projects which included ERP vendors, NASA, FirstUSA and a major pharmaceutical company. Consistently saw performance improvements of 75% scaling efficiency.

• Multiple positions responsible for budgeting, hiring, managing staff and being the senior technical contributor. • Enhanced a financial with a full spectrum of time-series database capabilities. Written in C, included a query compiler to allow screening, joins, sorting, point and bulk updaters, a data definition language, security, auditing, distributed referential integrity and a DBA tool set. Capability enabled $1.5MM annual revenue.• Module Leader for a cliical research system with a distributed clinical trials database. Proprietary internal engine updates and replicates clinical data across multiple databases.• Led a 15 person, cross-functional team in delivering a client/server solution. Numerous software products were integrated in order to deliver a business solution to a major new customer, worth $1MM in revenue.• Directed the development of a major manufacturer’s WorldWide Marketing Information System. • Built strategic planning systems, which investigate product-positioning issues, forecast the long-range marketing plan and evaluate the marketing effectiveness of international operations.• Conceived, developed and marketed a Decision Support System to forecast trends in product life-cycles based on life-cycle costs. These systems mathematically model the acquisition process in order to predict cost, reliability and availability. Co-author of handbook documenting $500 Million life-cycle cost savings.• Designed, developed and brought to market three 4GL products. These products provide financial analysts a distributed, database to enter their budgets flexibly and share information in a controlled, auditable manner.• Designed and programmed a strategic system for a major brokerage. The system mathematically optimizes fixed-income security portfolio selection. The minimization of up-front capital outlay for portfolios ensures timed, sufficient investment returns to meet project cash flow obligations. Written in C++ using IBM SQL.