Creating CRM Legal Software for law firms using Blazor. Project done in .Net Core Blazor, C#, T-SQL, ETL, J Query, .NET Core 8, T-SQL, Entity Framework, ETL, Reporting, Azure SQL Database, Web API, Azure, Dev Ops, Power BI Reporting, Converting old application while providing production support.

Equal Petition Application created in Blazor .Net Core. Campaign Finance done in ASP.NET MVC .NET Core, Identity Core, C#, Entity Framework, Built the ETL process for loading the Campaign Finance Reporting Data Warehouse. Built SSRS reports for Campaign Finance. Performed Database Migrations for the development teams and different databases. Redgate SQL Compare/SQL Data Compare for schema changes and migrating databases from DEV to QA to PROD. Also migrated data from prod to dev when needed with necessary safety changes needed (example email ect.) Performed backup and restores. Index Tuning(Clustered and Non Clustered Indexing). Query Execution Plan, SQL Profiler. .Net Core Blazor, Docker, .Net Core 7, SQL Server 2019/2022, ASP.NET MVC Core, T-SQL, Stored Procedures, SSIS, ETL, SSRS, Web API, Redgate Products, Postman, Dev Ops Teams, TFS, Test Driven Development, Unit Testing, HTML 5, CSS, JQUERY, Bootstrap.

• KAR has over 17,000 employees and capitalized 7.5 Billion in 2018 according to Forbes Magazine. KAR has many lines of business and owns many business operations.• KAR is focused on Migration to the Cloud with Application Development. Involved with migration from Sales Force Application to new financial quote application using Azure Cloud, Docker, Azure Functions, Microservices and Angular 8 development with SQL Server and ASP.NET MVC. C#, Microsoft .NET Core 2.1, HTML5, JavaScript. REST, API, JSON, Bootstrap, Angular Material. 100% Cloud Development with Angular 8 and Azure Functions. Built the base of their new KAR Quote application.• SSIS/ETL migration from Sales Force API to SQL Server and Data Modeling for new SQL Server database in the Azure Cloud.

• Created POC using the Accela Construct API in the AWS cloud and Restful Services, Cloud Formation Templates, JSON, ASP.NET MVC, JavaScript, CSS, Bootstrap, HTML5, JQuery• SSIS Migration and ETL from Cloud Accela Construct API to SQL Server.• SSIS with TFS API and Accela Cloud software.• Accela batch script ETL• Worked with a team in planning the migration of Accela Permting Software to the cloud and AWS.• Skills Used: SQL Server, SSIS, T-SQL, Restful Services, Cloud Accela Construct API, Team Foundation Server API, Dev Ops, Microsoft Visual Studio 2019. Microsoft ASP.NET MVC, AWS, Cloud Formation Templates, JSON, C#, .NET Core 2.1, BootStrap Web API

• HL7 Healthcare, Biztalk into Microsoft SQL Server using C#, T-SQL, Data Modeling, Microsoft Visual Studio and SSRS Reporting. Also 837 EDI enrollment with SSIS and Biztalk server.• SSIS ETL Integration assignment dealing with Healthcare Provider Portal SQL Server and Care Radius Oracle database using SSIS, SQL Server, Oracle DB, C# T-SQL and PL/SQL.• Full Stack Web development dealing with the Healthcare Provider Portal Project using ASP.NET MVC, .NET Core 2, C#, T-SQL, Microsoft SQL Server 2016, LINQ, CSS, HTML5, JavaScript, JQuery, BootStrap, WEB API, TFS and GIT.

• IVR/TDD Project – Consultant. SOA/Biztalk Development Team. 270 and 271 EDI Eligibility Benefits and response. SOA development and unit testing with Biztalk Services, XML, EDI Healthcare, Hewlett Packard Services, T-SQL, CRM. C#, WCF Services, Asynchronous programming, TPL(Task Parallel Library), HIPPA EDI XML, WCF Restful Services, T-SQL, SSIS, SOAP UI, NUnit, WPF/MVVM for testing and analysis of xml files. SAML security piece with McKesson Healthcare.• Backend SOA development for Healthcare Enrollment.using WCF, C# and T-SQL, SQL Server.

• ADOT Police – Registration Compliance - 12 month project –Primary Developer of a team of 3. ADOT has its own Police Department. This specialized police department is focused completely on registration compliance with vehicles. I was the main developer for Registration Compliance, which is ADOT’s police management software. This software is used by laptops inside the police cars and the central office. The software manages tickets and violation warning, mass mailing, and GIS location.Project uses C#, Microsoft ASP.NET MVC, JQuery, Dojo, ArcGIS, HTML5 / JavaScript WCF Data Services,Oauth, ODATA, SQL Server T-SQL.• ADOT Security Logon Client Application –developer for IAMDB Security Web Client Application. Application can plug into any application with an IFrame. Application centrally manages all ADOT applications and user maintenance and login security.Project done in C#ASP.NET MVC JQuery, JavaScript SQL Server 2008, Entity Framework, LINQ• ADOT Aircraft Registration Project 10 month project - Lead/Primary Developer for Aircraft Registration team project with the MVD. Aircraft Registration is the same as auto registration at the MVD. Aircraft Registration manages the collection of over $17,000,000 in registration fees each year. Software calculates taxes and exemptions very similar to turbo tax with different types of aircraft. Software also manages mass mailing of renewal notices and decal stickers. 10 month project.Project used WPF/XAML for 80% of the software (business side) and ASP.NET MVC to collect online payments from aircraft owners and reporting. Used WCF, Entity Framework, LINQ, C#, MVC, JQuery, AJAX, CSS, XML files, JavaScript, SQL Server 2008 and SQL Server 2014, DTS, T-SQL, Java Script, SSIS, Visual Studio 2012, ArcGIS Mapping for WPF using SOA design(Service Oriented Architecture). WPF designed using PRISM Microsoft Patterns and Practices using dependency injection (Bootstrap and Modules). Integrates with ARMANI Mainframe.

• WPF Windows/XAML Developer, WCF RIA, Entity Framework, LINQ, Windows Workflow, C#/VB.NET, MVC, JQuery, AJAX, CSS, XML files, SQL Server 2008, SQL Server 2014, ORACLE, T-SQL, PL-SQL, SOA, WCF, Java Script, SSIS, Visual Studio 2010.• Avnet produces over 14 billion $$$ in sales each year. Currently, AVNET is performing a $60 million upgrade of IT systems world wide. Large team environment. We are rebuilding their CRM Order Management software. Building Enterprise SOA application using WPF with WCF RIA, LINQ and MVC. Microsoft Workflow is used to pass orders to Quote to Order which is Java/Oracle. 1 year project.

• Paramedic Medis re-write using the NEMSIS national standards and data dictionary. Designed for traveling paramedic agencies.• Built STEMI CARDIAC software for the State Hospital.• Senior Developer for Healthcare and Behavioral health software development- used HIPPA standards HL7 Medical EDI files,,C#, SSIS/ETL, XML, Web Services, AJAX, JavaScript, ASP.NET, Visual Studio 2008, BizTalk Server 2006, SQL Server, SSIS, Reporting Services, JQuery, and ORACLE in an SOA enterprise environment. Team Project - Developing a new information system for a large team of Epidemiologists at the Federal, State, County, City level in relation with Disease control and national security. Project is federally funded by BioTerrorist grants from the September 11 (911) attack in New York. System allows epidemiologists and doctors a standard way of reporting medical disease outbreaks and anthrax scares. • Converted the entire work flow and business flow of the Office of Human Rights into an online internet business process. Software System integrates the phone department with outside Advocates in distance medical facilities to communicate and function coherently. Call center can document cases and conversations with clients and interact with one another through case assignments and management. Legal Form submittal and approval process has also been converted to an online process. I performed all phases of this 6+ month development project including gathering business requirements, design and architect, building, deploying, and maintenance. Project done in C#, ASP.NET, ORACLE, PL/SQL.

• Large Team Project. Developing Healthcare Professional Billing System in relation with changed government standards. System manages the accounting and financial transfer of funds between the federal government, the state, insurance companies and disabled citizens. Involved with designing Encounters using 837 EDI Files, and Trading Partner which all deal with customers, clients, and partners and financial reimbursement from federal government through AHCCCS (Federal Department) and Federal Healthcare HIPAA standards. Similar business process that Obama wants to use to re-standardize U.S. Healthcare Insurance. 5+ year project. 271/270 834 xml files used for integration. Biztalk Admin.• Project done with ASP.NET, C#, BizTalk Server 2000,, XML, Web Services, SQL-Server 2000, DTS Packages,ETL, stored procedures, T-SQL, JavaScript. Enterprise software used in several DES offices around the state. Follow all steps in life cycle.