Director, Application Development and Data Science
2021 - PRESENTPet Supermarket- Led a diverse, three-pronged development team—covering AS400 ERP and Oracle SaaS maintenance, eCommerce with Salesforce, and data warehousing with Tableau and Snowflake—in support of retail, marketing, supply chain, and back office operations.
- Drove the separation of all systems used jointly with Pet Valu as part of separation and divestiture activities. This included standing up new data and application architecture and properly dividing data.
- Managed an external system integrator and acted as architect, implementing a new Salesforce platform—including Commerce Cloud, Service Cloud, Marketing Cloud, and Order Management—which integrated via API/ETL with over a dozen other applications.
- Used SnowPark to replace existing data sources in Python scripts used by data analysts and data scientists and an API server that was used to supplement a non-extensible API of a vendor-controlled SaaS system.
Technologies: Snowflake, Tableau, SQL Server BI, Salesforce, Oracle, IBM Db2, Microsoft Dynamics NAV, WorkdaySenior Manager, Business Intelligence
2019 - 2021Pet Retail Brands- Owned all data within the enterprise, overseeing data—coming into, being produced or processed within, and leaving the organization—for quality, security, consistency, and completeness for marketing, operational, and analytical needs.
- Handled the architecture, development, implementation, and support of the on-premise SQL server and Azure-based Snowflake data lake/warehouse and Tableau reporting system to integrate information from sources across departments and sister companies.
- Evolved the technology through the proof of concept, implementation, and scaling-up phases while simultaneously managing scope changes brought on by M&A activities.
- Trained power users in customer analytics and other departments on the tools, the data, and how best to approach analytics to grow the business.
Technologies: Snowflake, Tableau, SQL Server DBA, SQL Server Integration Services (SSIS), Azure Data FactoryDirector, IT
2018 - 2018MedPro Billing- Oversaw all IT Infrastructure and PHP/.NET application development and maintenance.
- Instituted a data quality program that improved the reliability and consistency of the client-visible data warehouse.
- Performed buy vs. build ROI analysis and ran an RFP/selection process for mission-critical software while overseeing the maintenance of existing custom applications.
- Solidified help desk functions by changing mindset and processes resulting in increased client satisfaction.
Technologies: PHP, MySQL, Azure Active Directory, .NET, Zoho, Web Security, HelpdeskChief Information Officer
2017 - 2018AlphaNet- Handled all data and telecom infrastructure, production systems, and application development.
- Designed and set in motion a three-year plan to transition the company from a customer service organization to one whose data is the primary asset.
- Transitioned the organization from a reactive data quality methodology to a proactive one.
- Implemented revised hybrid cloud and on-premises infrastructure—including O365, VMWare, and Azure—which resulted in additional capabilities and significant CAPEX and OPEX savings.
Technologies: VMware, Office 365, .NET, SQL Server DBA, Helpdesk, Kaseya, AzurePresident
2001 - 2017Grossman Systems Consulting- Founded the firm and led consulting teams specializing in strategic planning, business process reengineering, custom Agile application or data warehouse development—with .NET, JavaScript, or SQL Server—and infrastructure implementation.
- Turned a SaaS startup from an entrepreneurial vision into a concrete framework on which to grow. This included gathering requirements, creating roadmaps, producing budgets, establishing development and QA standards, and leading product development.
- Designed and led the development and implementation of a multi-tenant, HIPAA-compliant workflow management and mobile-enabled BI system to integrate the decentralized staff with central management, pharmacies, physicians, and patients.
- Performed financial analyses and market research, created strategic plans, and coordinated all aspects of the transition to a revised practice model, including EHR and PMS systems implementation for various medical practices.
Technologies: .NET, Business Development, Business Process Analysis, IT Project Management, SQL Server DBA, IIS, MySQL, Financial Analysis, JavaScriptSenior Manager, Application Development
2014 - 2014Aptean- Oversaw the ongoing development of Made2Manage—an ERP, CRM, and e-Commerce product with a customer base of over 1,000 installs—and a 55-member R&D team on two continents using Scrum and Kanban.
- Inherited an unsuccessful conversion to the .NET platform and stabilized the product by introducing a holistic approach to application maintenance.
- Established improved QA controls and instituted testing automation and continuous integration.
- Leveraged other APTEAN products to modernize Made2Manage with minimal investment.
Technologies: .NET, SQL Server 2008 R2, QlikView, IT Project Management, Scrum, KanbanDirector, IT
2000 - 2001Gambro Healthcare Laboratory Services- Established a complete IT department in a business unit that previously used corporate IT and consulting resources.
- Designed and implemented a strategy for collecting and processing a $100 million Medicare billing backlog, which the parent company identified as critical to their stock price.
- Created short, medium, and long-term IT strategies to support the current significant needs of internal and external clients and the migration from legacy to distributed systems.
- Served on the senior corporate management team that oversaw corporate financial strategy, cost control, budgeting, and interdepartmental coordination.
Technologies: MUMPS, OracleSenior Engagement Manager
1992 - 2000Navigant Consulting- Served various roles as the organization evolved. Started as a developer of database management systems and, as systems staff grew, led teams of technical and non-technical personnel in systems development, data conversion, and analysis projects.
- Established a broad-based information technology and eCommerce consulting group servicing the national management consulting practice and providing direct services to outside clients.
- Created and implemented a data integration strategy related to multi-billion-dollar M&A activities for a Fortune 200 utility company.
- Designed, developed, implemented, and maintained an automated bill analysis system installed at multiple Fortune 500 and insurance carrier clients and hundreds of law firms, saving millions of dollars in legal costs.
- Performed analysis of needs of an unautomated document depository. Designed, developed, and implemented the integrated request tracking, scheduling, inventory, and time-and-billing modules, including links to full-text searching and imaging software.
Technologies: Visual FoxPro, IT Project Management, Business AnalysisDirector, Systems
1997 - 1999Insurance Data Resources- Selected to be in a small group charged with starting up a new data collection and statistical analysis organization that was being established to compete with a long-standing monopoly.
- Hired, trained, and led a high-quality team of 40+ persons in application development, quality assurance, and systems operations.
- Planned, designed, and led the development of all client and server processing and data warehousing systems, which interacted with industry-standard legacy systems at the cost of about half our competition's similar effort, saving over $10 million.
Technologies: VB, Oracle, ASP, ErwinConsultant
1990 - 1992Q-M Consulting Group- Engaged as product manager for a multi-user job costing and accounting system, utilizing PC and Macintosh platforms running at over 100 sites across North America.
- Acted as project manager and lead developer for customized system versions for manufacturing and government entities.
- Contributed as assistant to the president for marketing in RFP evaluation, proposal writing, planning, and implementation of new internal procedures to handle the significant increase in company size.
Technologies: FoxBase, Visual FoxPro
Marc G. Grossman
Solution Architect and Developer in Fort Lauderdale, FL, United States
Member since January 20, 2023
Marc is a seasoned business professional with outstanding experience and a track record of success as a hands-on leader and systems architect. In both consulting and management roles, he has enhanced the efficiency of business processes by modernizing or introducing new technology. Marc also has a unique combination of attributes that allow him to be equally comfortable meeting with a board of directors, potential client, or team of programmers.
Marc is now available for hire
Portfolio
- Pet SupermarketSnowflake, Tableau, SQL Server BI, Salesforce, Oracle, IBM Db2...
- Pet Retail BrandsSnowflake, Tableau, SQL Server DBA, SQL Server Integration Services (SSIS)...
- MedPro BillingPHP, MySQL, Azure Active Directory, .NET, Zoho, Web Security, Helpdesk
Experience
- Business Analysis 20 years
- SQL Server DBA 20 years
- Business Management 20 years
- Architecture 20 years
- IT Project Management 20 years
- .NET 15 years
- Tableau 5 years
- Snowflake 3 years
Availability
Full-time
Preferred Environment
Snowflake, Tableau, Azure, SQL Server 2016, .NET, Azure Active Directory
The most amazing...
...thing I've done is lead the separation of all systems used jointly with a sister company as part of separation and divestiture activities.
Employment
Experience
- Divestiture Preparation
Led the separation of all systems used jointly with a sister company as part of separation/divestiture activities.
This project included setting up new Azure-based data and application architecture and designing and implementing the methodology for properly dividing data to meet business and regulatory requirements. I also successfully managed an external system integrator and acted as a functional and technical architect. I implemented the new Salesforce SaaS platform—including Commerce Cloud (Demandware), Service Cloud, Marketing Cloud, and Order Management—which integrated via API and ETL with the corporate ERP, loyalty management system, and over a dozen other specialized applications.
Skills
Languages
Snowflake, Visual FoxPro, VB, Pascal, C++, PHP, JavaScript, MUMPSFrameworks
.NET, ASPTools
Tableau, SQL Server BI, Erwin, Microsoft Dynamics NAV, VMwareStorage
SQL Server DBA, SQL Server 2016, SQL Server Integration Services (SSIS), Azure Active Directory, SQL Server 2008 R2, IBM Db2, MySQLOther
Business Process Analysis, IT Project Management, Financial Analysis, Business Analysis, Algorithms, Architecture, Business Management, Finance, Marketing Mix, Azure Data Factory, Web Security, Office 365, Business Development, IIS, FoxBase, Global Project Management, Workday, Zoho, Helpdesk, Kaseya, VertexParadigms
Scrum, KanbanPlatforms
Salesforce, Oracle, Azure, QlikViewLibraries/APIs
CyberSource
Education
- Master's Degree in Business Administration2001 - 2002Florida Atlantic University - Boca Raton, Florida, USA
- Bachelor's Degree in Computer Studies and Political Science1986 - 1990Northwestern University - Evanston, Illinois, USA
Certifications
- Project Management Professional (PMP)JANUARY 2012 - JANUARY 2024Project Management Institute (PMI)
