MICHAEL A. STEIN
Smithtown, NY 11787 – mstein.software@gmail.com
Highly skilled full stack software developer with extensive backend and data management experience. Over 35 years of experience in developing scalable, high-performance web applications. Proficient in a wide range of technologies, with a proven track record of delivering projects on time and within budget. Strong background in designing, developing, and maintaining complex systems and applications, with expertise in front-end and back-end development. Highly skilled in problem-solving and critical thinking, with a passion for creating user-friendly and efficient software. Excellent communication and collaboration skills, with experience working in cross-functional teams and managing stakeholders.
- Communication
- Collaboration
- Time Management
- Problem-Solving
- Attention to Detail
- Adaptability
- Learning Mindset
- Empathy
- Patience
- Customer Service
- Creativity
- Leadership
- Project Management
- Strategic Thinking
- Data Analysis
- Risk Management
- Business Acumen
Software Engineer / Full Stack Developer / Web Developer – HTML, CSS, SASS, FLEXBOX, GRID, JavaScript, React, React Native, Angular, Bootstrap. Node.js, PHP, AJAX, Laravel, C, C++, API, SOAP and REST design and integration.
Back End Design for server data handling and delivery. – 35 years of Database Design and Architecture experience, provides for robust Back End support for all applications. Highly Skilled in SQL Query Design in it’s various flavors. Microsoft SQL Server, Oracle, Postgress, MySQL, MariaDB, Transact-SQL, xQuery and SOQL.
Data Warehousing concepts and technologies, Performance tuning and optimization, Backup and recovery procedures, Version control systems, Data security and privacy standards and protocols, catastrophic data recovery planning. Data Archival, RAID Redundancy, and Security.
Encryption Software, RSA, Elliptical Curve, HASHING, Token Authentication, OAuth 2.0
Windows Development – Application design in C/C++ using the Microsoft Windows SDK Object Library, Microsoft Visual Studio.
Mobile Application Development – Google Android.
Business Intelligence and Data Analytics – Queries, Reporting, Charts, Graphs, Interactive Dashboards, (BI) Business Intelligence, Power Query, Microsoft Power BI, Excel Spreadsheets, Crystal Reports, VBA, SQL, Accounting and Financial Analysis.
WordPress Development – Intimate understanding of the WordPress Engine Back End Architecture. Plugin and Theme design with PHP, JavaScript, bootstrap React and MySQL. WooCommerce, eCommerce, Automated Social Publishing/Facebook/Twitter, Web Scraping, Newsletters, eCommerce, Twilio Texting, SMTP eMail handling and credit card processing.
Web Analytics, and Marketing – Google Analytics, Analytics, Search Console, AdSense, Speed, Ads, SEO.
Development and Integration for the full suite of Microsoft Office Applications using OLE, VBA, OBDC, SMTP and other integrations. (Word, Excel, Outlook, OneNote, Office365, Access, Power Point )
Server Management – cPanel, SSL, Threat Protection, rewrite engine, Apache, WAMP and LAMP Stacks. DOS, DOS shell script, Linux, Microsoft Windows, Windows NT, Red Hat, , Shell script, Ubuntu, UNIX, UNIX Shell, Debian
Version Control – Git, Git Hub, Git Lab, Git Kracken,
Network/Systems Engineer – Network protocols (TCP/IP, DNS, DHCP, SMTP, SNMP), Routing and switching (Cisco, Juniper, BGP, OSPF, MPLS), Network security (Firewalls, VPN, IDS/IPS, NAT, ACLs), Network performance analysis and troubleshooting, Virtualization technologies (VMware, Hyper-V, KVM), Cloud computing (AWS, Azure, Google Cloud), Linux/Unix system administration, Windows server administration, Scripting languages ( Bash, Perl), Network monitoring and management tools (SolarWinds, Nagios, Wireshark), Storage technologies (SAN, NAS, RAID), Disaster recovery and business continuity planning, Network automation and orchestration (Ansible, Puppet, Chef), Collaborative tools and software (JIRA, Confluence, Slack)
- 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.
Bachelor of Science – Computer Science / SUNY New Paltz – New Paltz New York 1988
- The Complete JavaScript Course: From Zero to Expert!
- The Complete SQL Bootcamp: Go from Zero to Hero
- Advanced CSS and Sass, Flexbox, Grid Animations and
- WordPress Dev Course 2023 – Plugins & Themes PHP & Javascript
- Create a REST API using basic PHP with Token Authentication
- Advanced SQL : The Ultimate Guide – Oracle Master Training
- SAP Crystal Reports 2020 (and earlier versions)
- Salesforce Admin certification course
- Using a Third Party API to Send SMS with PHP (SMS) – Twilio
- PHP OOP: Object Oriented Programming for beginners + Project
- The Complete PHP MYSQL Professional Course with 5 Projects
- Learning PHP Data Objects
- PHP Secure Login And Registration System w/ email confirmation
- AJAX: Let’s build a COOL project – Javascript & PHP
- Cryptography and Hashing Fundamentals in Python and Java
- Build CRUD Application – PHP & Mysql
- Complete React Developer (w/ Redux, Hooks, GraphQL)
- QR Codes
- The Git & Github Bootcamp
- Using Excel as a database with VBA
- Excel XML, XPath and XSLT Workflows
- Excel Power Query, Power Pivot, Power Map & DAX
- Excel VBA to PDF Forms Mastery Course
- Microsoft Excel: Business Intelligence w/ Power Query & DAX /
- Visually Effective Excel Dashboards
- Microsoft Excel – Data Visualization, Excel Charts & Graphs
- Microsoft Excel – Excel from Beginner to Advanced