Extended Resume

• Multi-phase Sage 300 ERP Implementation, SQL Implementation.
• This was a multi-year project involving collecting and cleaning data from multiple sources, including Access, Excel, and numerous web resources.
• Built Secondary DataBase to supplement Sage 300, utilizing MicroSoft SQL Server. Design of extensive SQL Query Library, including Stored Procedures and Triggers.
• Design all reports using multiple platforms. Crystal Reports, Microsoft Business Intelligence, and a custom PHP, JavaScript, React delivery system.
• Install and Implement Apache WAMP and LAMP stack system for internal IntraNet content delivery.
• Integrate FedEx and UPS Shipping systems with Sage 300 using API integration. 
• Design, build, and launch company web sites, including Visiontron.com and CrowdControlStore.com using WordPress as a core platform.
• Setup and configure Ecommerce with Credit Card Processing, CAPTCHA and other security measures.
• All Server Web Management using cPanel and WHM. All DNS and Routing configuration.
• Designed Custom Themes and Plugins with PHP, JavaScript, MySql, React and Bootstrap.
• Built Custom Sales Tax Management system to dove tail with Sage 300, in order to provide much more detailed reporting to meet Tax Filing requirements for various states. Expanded Tax Exemption certificate data system. Integrate 44,000 tax codes with US Postal data to correctly break out taxes by County, City, and Special Tax District.
• Created Custom add-on for Sage to correctly run a Cycle Count Inventory system. Design and built Mobile apps for scanning bar codes and managing inventory and orders on the warehouse floor.
• Designed Automatic Graphic charting to display graphicly drawn charts showing the breakdown of Bill of Materials (BOM), Sub-Assemblies, Processes and Labor, involved in costing out the manufacturing process.
• Designed full featured Database Plugin for WordPress. Module reads the Schema out of SQL Tables and creates a fully functioning Data Entry screen for any MySql, SQL Server, Oracle or Postgres table. Form fields are then drag and drop to reposition, and absolute positions are saved to a Form Table.
• Designed and implemented Image Layering system to build composite images from part layers.
• Designed and implemented Product Configuration system that allows you to select all features and colors available on a product, and create database product entries for each of those configurations.
• Design and implement Token Authorization security system for intranet login.
• Built and implemented SMTP Email engine to email various departments and personnel about errors in document completion, and status updates on orders and shipping.

• Designed and created cutting edge Financial Analysis Packages for projections of income and expenses for sophisticated multi-tenanted real estate investment transactions using, Excel, VBA and Power BI to create comprehensive dashboards. 
• Met with accountants and portfolio analysts for major banks, including Dime, Washington Mutual, First National Bank of Chicago, to discuss GAAP requirements, depreciation and statistical market performance to conduct RISK management. Produced Detailed and quality data analysis that helped secure numerous accounts with large equity holders.
• Created multi asset short-term and long-term data models and projections enabling stakeholders to successfully secure institutional financing.
• Designed and coded interactive contact and listing data system to push notifications of suitable properties to correct clients, based on interview criteria using C/C++, SQL and Microsoft Visual Studio. 
• Lead team conducting lease and expense audits.
• Lead the implementation of ETL processes to integrate data from multiple sources to populate data system.
• Managed all salespeople and Employees and oversee day to day business operations.
• Managed website content using WordPress CMS and ensured that it adhered to web accessibility standards and SEO best practices.
• Managed data governance and security policies, ensuring compliance with data protection regulations.

• Designed and implemented network infrastructure solutions to meet business requirements.
• Configured and maintained Cisco routers and switches, firewalls, and load balancers.
• Monitored network performance and identified and resolved issues using network monitoring tools.
• Maintained network security by implementing and enforcing security protocols and policies.
• Worked with cross-functional teams to ensure that network infrastructure aligned with business goals and requirements.
• Designed and implemented DataBases to manage property and owner information..
• Created comprehensive Contact Management system for use in Emails, Correspondence, and Marketing.

Sutton and Edwards, where I was hired to do a full computerization. This included research and purchase of 50 desktops, wiring the entire office for Cat5 and configuring server and client systems to finish up the network. I installed and trained staff on Lotus 1-2-3 and AmiPro, before Microsoft Word and Excel were release, and later converted and trained on Microsoft Products. Sutton was a much bigger company, with about 50 employees, and they handled major investment acquisitions for Banks and REITS. At this time, Windows was taking over and the entire Customer and Listing system was rewritten for Windows, using C, Windows SDK with a DBIII Engine. DBIII was later swapped out for SQL.  In addition, all of the original financial analysis software I built also got a major overhaul, now analyzing full NOI’s of multi-tenanted properties for Investor and Bank Financing. In 1998 I was awarded person of the year ( normally SalesPerson of the year ) for analyzing and breaking down leases, expenses and NOI for 1 million square foot office park, resulting in a sale that earned the company over $5 million dollars in commission.  I was officially given the title of Financial Analyst, and was available to provide detailed financial packages to assist salespeople in closing transactions. I was tasked to hire and manage 2 additional people to help maintain the network and database systems

Raish sold custom software solutions and were responsible for the original systems installation at Generation Realty. After seeing the software I had designed and built, they hired me to work on a contract basis coding what would be later be referred to as enterprise management systems. Complete custom business data solutions. The Senior VP of Raish left, and kept me on.

At this point, I was going in to companies and spending 2 weeks there, interviewing managers and staff to document business flow in the office. We designed coded and installed the new system, recreating all necessary hand written forms as computer generated forms, and trained and supported staff on their new system. I also was contracting for a company called RVC Systems that had custom software for hospital and doctors. I was not on the coding team, but I handled installation and support at Hospitals around the NYC area.

Computer Department Manager, Managed and trained a team of 3 people providing data solutions and reporting for the Commercial Real Estate Industry. I handled interviews and hiring and trained 2 of them to be programmers. I designed and coded a customer data system with automated rotating reminders, to prompt salespeople to regular contact, prospecting, and moving transactions to sales closing. I also created an extensive real estate listing system, before such systems were commercially available, and created advanced search algorithms to match detailed client specifications with an inventory of available space for lease and sale. In addition, I designed advance financial transaction analysis software, to better project carry costs of real estate holdings to assist with acquisition financing.