Jay P. Hayes Next JS / React JS / ASP.NET Core Web API 2.1 / Visual Studio 2022 / SQL 2019 OVERVIEW Senior Full Stack Developer: Next.js / React.js / Business Intelligence Developer / SQL Developer, using over 20+ years of development experience to implement solutions using current and new technologies, from desktop to mobile, the goal and the focus are to use innovation and technology to make the client's and users' tasks, jobs, and lives better. Marketing Next.JS as the toolset of choice. Next.js is built on top of React.js. Open to opportunities to use both toolsets for creating new applications and solutions. QUALIFICATION SUMMARY 1: Full stack developer with an ability to turn ideas into workable applications from Database Design, API development, Front End Design, and security using current toolsets: Next.js, React.js, API Development (C#, ADO.NET), SQL Server Database Development, and Airtable. 2: Success working with major end-users to define needs and provide data-oriented solutions. Current solution development focuses on innovative, modern responsive design accessing data from a backend database using Power BI, and Web APIs using Microsoft Azure for restful backend service. 3: SwiftUI 4.0 is the latest version of the new toolset from Apple used to build the latest iPhone application. SwiftUI helps you build great-looking apps across all Apple platforms with the power of Swift — and surprisingly, little code. • Full Stack Development with Next.js, Tailwinds CSS, and API with Airtable • NEXT.js, React.js, Tailwind application development APIs with Airtable. • NEXT.js, React.js, Tailwind application development using Enterprise APIs. • Power BI, SQL Server, Dax • SQL Server database Development: Stored Procedures, Views, SSRS TECHICAL SKILLS - Produciton • Next.js, Tailwind.css, HTML5, CSS3 • React.js, Tailwind.css, HTML5, CSS3 • Power BI Dashboard development, data integration and visualization • ASP.NET core / C# / .NET 6.0 • SQL Server 2019/ Database Programming, Views, User Defined Functions (UDF), Stored Procedures • Visual Studio Community 2022, SQL Server Management Studio (SSMS) v18.10 • Database Administration T-SQL, Profiler, Indexing, Performance tuning • Windows Azure (SQL Database / Web API) TECHICAL SKILLS - In Progress • Swift UI CURRENT PROJECTS - Community Lot Lists Vision Tech Now - Full Stack Developer Pelham, AL (Remote) - 07/2022 - Present Next.js / React.js / Power BI / Tailwinds / SQL Server / API Opportunity: We had the idea to present local communities with their designated schools, cities, states, and counties after seeing a scanned PDF document of new residences in a new neighborhood. Major Accomplishment (Next.js / React.js / Tailwinds / API): We saw the chance to present local communities in the area along with their designated schools, city, state, and county, starting with a scanned PDF document of new dwellings in a new sector of a community. Created a relational dataset and API to house the data and image assets using Airtable API, created an Next.js application to read in the API and present the data to users. Implemented security level using Firebase to allow the user to maintain a profile for the application and save their favorite communities. Using Next.js gave us the option to use getStaticProps and the Image component for possible better image optimization and web/mobile speed. Scheduled Features (Next.js / React.js / Tailwinds / API / Mobile / Power BI): Once the data entry team reach a good point, the goal is to create a Power BI shared dashboard Report to show the community stats (Schools to Communities, City to Communities) and Lot listing stats (Lot listing by plans, agents, bedrooms, bath, etc.). Note: as the architect, we implemented the process: Let the Data Tell the Story. FEATURE PROJECTS - Rez Intel Dashboard Visualization ADTRAV - RezIntel Birmingham, AL - 08/2019 – 12/2021 Angular / TypeScript / Qlik Sense / HTML5 / CSS3 / QDT Components RezIntel Enterprise™ helps organizations optimize performance by aggregating, consolidating, and visualizing global travel and expense data from disparate sources, streamlining processes, optimizing spend across broad categories, and facilitating strategic insights. Opportunity: We took ownership of the RezIntel application during the developer team’s transition. Not knowing the current state of the application, we were constantly implementing missing features that were expected to be completed. However, having a good and flexible team, we were able to accomplish the tasks and implement the missing features successfully in production. The development efforts for this application fall into 3 areas • Front End design and development using Angular, HTML5, CSS3 and Foundation for a standard 12 grid layout. • Qlik Visualization Implementations using QDT components and Qlik capability APIs • i18 Language Translations for English, Spanish, and Japanese Major Accomplishment: Over the course of the last 2 years, we have created and implemented several dashboard visualizations based on mockups from the customers’ requests or the graphic designers Adobe XD mockups. Each dashboard has i18 translations for English, Spanish and Japanese. Also, created new KPI components used on Air / Hotel Booking and & Air / Hotel Policy. Dashboards: Front End Design / i18 Translations / Qlik Implementations /Production 1. My Travel Angular / TypeScript / Qlik Sense / HTML5 / CSS3 / QDT Components Major Accomplishment: New Dashboard Visualizations Double sided KPI cards with responsive Design with tab implementation. 2. My Expense: Angular / TypeScript / Qlik Sense / HTML5 / CSS3 / QDT Components Major Accomplishment: New Dashboard Visualizations Double sided KPI cards with responsive Design with tab implementation. 3. Approvals (2 and 3) Angular / TypeScript / Qlik Sense / HTML5 / CSS3 / QDT Components Major Accomplishment: New Dashboard Visualizations Created 3 iteration of the Approval dashboards based on business needs and changes. Implemented custom Dashboard Tip popup with translations 4. Rail Booking Angular / TypeScript / Qlik Sense / HTML5 / CSS3 / QDT Components Major Accomplishment: New Dashboard Visualizations Created dashboard based on business needs and changes. Implemented custom Dashboard Tip popup with translations. (No in production) 5. Air Booking Angular / TypeScript / Qlik Sense / HTML5 / CSS3 / QDT Components Major Accomplishment: New Dashboard Visualizations Double sided KPI cards with responsive Design with tab implementation. Implemented new front end design to show quick charts. 6. Air Policy Front End Design i18 Translations Qlik Implementations Production Angular / TypeScript / Qlik Sense / HTML5 / CSS3 / QDT Components Major Accomplishment: New Dashboard Visualizations Create new chart layouts for Policy compliance. 7. Hotel Booking Angular / TypeScript / Qlik Sense / HTML5 / CSS3 / QDT Components Major Accomplishment: New Dashboard Visualizations Create new chart layouts for Policy compliance.  8. Hotel Policy Angular / TypeScript / Qlik Sense / HTML5 / CSS3 / QDT Components Major Accomplishment: New Dashboard Visualizations Double sided KPI cards with responsive Design with tab implementation. Implemented new front end design to show quick charts. 9. CO2 Emissions Angular / TypeScript / Qlik Sense / HTML5 / CSS3 / QDT Components Major Accomplishment: New Dashboard Visualizations 10. Rez Fan Angular / TypeScript / Qlik Sense / HTML5 / CSS3 / QDT Components Major Accomplishment: New Dashboard Visualizations 11. Employee Meals Angular / TypeScript / Qlik Sense / HTML5 / CSS3 / QDT Components Major Accomplishment: New Dashboard Visualizations 12. HCP Meals Angular / TypeScript / Qlik Sense / HTML5 / CSS3 / QDT Components Major Accomplishment: New Dashboard Visualizations 13. Personal Expense Angular / TypeScript / Qlik Sense / HTML5 / CSS3 / QDT Components Major Accomplishment: New Dashboard Visualizations 14. Source Data Audit Angular / TypeScript / Qlik Sense / HTML5 / CSS3 / QDT Components Major Accomplishment: New Dashboard Visualizations FEATURE PROJECTS : Prototype Application: B.A.T. (Back Office Tool) ADTRAV: Back Office Tool Development React.js / Tailwinds / API C# / .NET Core / SQL Server Opportunity: In our production tool (Rez-Intel), the dashboards user assignments can be issued by the admin screen in the application. However, to initially assigned new dashboards to accounts and users required a manual SQL script to setup and maintain. Created a local tool to maintain and assign Dashboards and user’s access. Major Accomplishment: Front End (React.js / Tailwinds / SQL): Using React.js and Tailwinds, created design and coded the application to assign the users and new dashboards in development. To assign and maintain user accounts and dashboards required a lot of repetitive SQL scripts. Using the front end, allow the developers to run the SQL scripts using the front end and stored procedures. Major Accomplishment: Database (API C# / .NET Core / SQL): The challenge / opportunity here is the database structure was currently in place, but needed a way to search, sort and implement the changes. Most of the manual SQL scripts required manual values, which lead to inconsistent values and label. Using the back-office tool, we were able to implement a consistent change to the Rez-Intel dashboard assignments FEATURE PROJECTS : Prototype Application: Rez-Intel 3.0 Rez-Intel 3.0 Prototype React.js / Tailwinds / API / Enigma.js / Nebula.js Opportunity: The center feature of the Rez-Intel application is the data visualization presented by Qlik Sense chart objects. Qlik is one of the best data visualization tools along with Power BI, Tableau and Sisense. The challenge here is that our Qlik Sense version was extremely outdated. Based on changes implemented by contemporary browsers, this started causing issues with our outdated Qlik implementation. Because of the nature of the data, the current information is sensitive, and we did not want to place any data on a public site. To that end, we created a separate API using mocked data. Major Accomplishment: Front End Application (React.js / Tailwinds / SQL): Using React.js and Tailwinds, to created design and implement a functional, working prototype of one of the existing dashboards. Major Accomplishment: Qlik Sense Dashboards (Qlik Sense / Data Design / API): We have 2 datasets we used in our sample Rez-Intel 3.0 application CO2 Emissions and BHM Flight Arrivals and Departure data. Overall, implemented the dataset design, setup data in an API, create a Qlik Data load, setup the Qlik Sense SaaS and created all the Qlik Chart used in the application. WORK HISTORY Vision Tech Now - Full Stack Developer Pelham, AL (Remote) 07/2022 – Present Next.js / React.js / Power BI / Tailwinds / SQL Server / API ADTRAV (Sr. Data Visualization Engineer) Birmingham, AL 08/2020 – 07/2022 Next.js / React.js / Qlik Sense / SQL Server / HTML5 / CSS3 / Tailwinds CSS / ASP.NET Web API/ SQL / C# / Qlik Enigma.js, Nebula.js ADTRAV (Business Intelligence Developer) Birmingham, AL 08/2019 - 07/2022 Angular 7 / Qlik Sense / SQL Server Southern Company (Alabama Power) Birmingham, AL 01/2019 – 06/2019 Power BI / Oracle 11g / ASP.NET / C# Southern Company (Engineering and Construction Svc) Birmingham, AL 06/2017 – 01/2019 Power BI / SQL Server Reporting Services (SSRS)/Angular 7 / ASP.NET Web API/ SQL / C# Southern Nuclear Birmingham, AL 06/2014 - 06/2017 SQL Server Reporting Services (SSRS)/Angular 4, 1 / ASP.NET Web API/ SQL / C# Ingenuity Business Solutions Birmingham, AL 12/2013 - 04/2014 Kendo Mobile Web / HTML 5 / Bootstrap/ jQuery INTERMARK GROUP Birmingham, AL 05/2013 - 10/2014 C#/ ASP.NET/ MVC/ SQL 2005 / SSRS REGIONS BANK – Wealth Management / Trust Birmingham, AL 11/2011 - 05/2013 C# / ASP.NET 4.0 / SQL 2008 / SSIS / SSRS / Visual Studio 2012 / SSMS 2012 / DevExpress (ASP.NET / Charting) BBVA Compass – Birmingham, AL Birmingham, AL 12/2008 – 11/2011 C# / ASP.NET 4.0, 3.5 / SQL 2008 r2, 2005 DATABASE / SSIS / SSRS Colonial Properties Trust Birmingham, AL 02/2008 - 12/2008 VB.NET / ASP.NET 3.5 / SQL 2005 DATABASE / SSIS / SSRS DAXKO Birmingham, AL 10/2007 - 02/2008 System Support engineer. EBSCO Industries Birmingham, AL 12/2006 - 10/2007 SQL 2005 DATABASE PROGRAMMER NCP Solutions Birmingham, AL 06/2004 - 12/2006 DATABASE DEVELOPER / VB.NET - ASP.NET DEVELOPER EBSCO Industries Birmingham, AL 09/2003 - 06/2004 DATABASE DEVELOPER / VB.NET - ASP.NET DEVELOPER Momentum Business Solutions Birmingham, AL 06/2002 - 09/2003 DATABASE DEVELOPER / VB.NET - ASP.NET DEVELOPER Molton, Allen & Williams (MAW) Birmingham, AL 08/1999 - 06/2002 Database Developer: Visual Basic 6.0 /Active Server Pages / SQL 7.0 – 2000 / Crystal Reports 8.5 / HTML Bellsouth Billing Inc. Birmingham, AL 01/1996 - 07/1999 Visual Basic 6.0 / Web Development / SQL 6.5-7.0 / Crystal Reports / HTML USMC – United States Marine Corp 01/1984 - 01/1996 Cobol programmer / Data Security /