Jesse Longoria Email and Phone Number

Leveraging the Microsoft Power Platform to accelerate Digital Transformations.

Assisted with the deployment and adoption of Office 365. Built numerous PowerBI reports and dashboards to provide insights into the company data that helped make imformed decisions.• Examples include sales trends, expense reports, and analytical reports, with drill-down capabilities. • • Created various Apps using MS Power Apps as well as MS Automate (Formerly Flow) to create workflows to optimize business processes. • Leveraged PowerShell scripts, T-SQL, C# in the creation of custom ETL processes. • Worked with stakeholders to analyze true source of data; identify and build data entities, objects, and relationships. Leveraged data dictionary when possible. • Supported SSRS reports for Work Order, Logistics, and Inventory and SQL Server environment, as needed.• Assisted with batch file creation that run modules in MS Access, which load data from Quickbooks into MS Access, then write Access data to SQL Server 2012, using link tables.• Configure connectors to MS Flows/Power Automate, set up Gateway on Tito’s Network to access local resources from external requests: MS Access, SQL Server, Images, Excel files, apply security groups/rules, and data refresh using PowerBI• Troubleshoot and fix new deployment of Dept Code and Account structure utilized by PowerApps and PowerBI reports. This upgrade affected Dept class table rollup used by reports and apps. Reconciled/fixed by creating copy of reports, updated data models with new rollup tables, and tested.• DAX: Used DAX to do financial calculations, summarizations, including year to date – month to month – rolling 12. Also used with ETL’s to create custom columns, create measures, and to build rules used in row level security implementation• Designed row level security implementation• Debug PHP based on-premise application and work with third party to resolve issues

• Setup Web API, Web Front End Azure App Services and an IAAS SQL Server in Azure• SharePoint 2010/2013 developer• SharePoint PowerShell scripts• Maintain agency site and internal applications• Maintain various ETL packages • Create custom solutions in ASP.Net C#/MVC/Web Forms• SQL Server: Create databases, design models for enterprise systems, assist with backup & restore, re-indexing, and other support activities.

• Meet with stakeholders, vendors• Utilized web services/api’s to connect disparate COTS systems such as MiSys (PHP), MS Dynamics CRM • Created SharePoint 2010 proof of concepts to present data from disparate systems• .Net developer at Farm Credit Bank of Texas• Manage SunGard Optimist 8, Mysis (PHP), CME COTS. • Work directly with vendors, Farm Credit Delivery Team and subject matter experts to perform upgrades to COTS. • Utilize MS Dynamics CRM, Optimist 8 and CME web services for integration initiatives.• Utilize SharePoint BCS to surface external data within SharePoint. Setup SharePoint crawl and search site to search external data.• Install/test DocuSign SharePoint plugin.

• Research and Development team member• Analyzed Amazon Cloud Services, Microsoft Azure Cloud Services, and existing Cyberlink Cloud services. Performed price/feature comparison. Providing sample infrastructure setup to team.• Worked directly with a Consulting firm on the implementation of a Home Healthcare project for the company that utilizes, MVC 5, EF 5, Angular, Web API 2, Bootstrap, SASS, Signal-R, SQL Server 2012, etc.• Team Lead working directly with cloud provider to prepare for cloud infrastructure migration.• Manage Database Backups, Manage HL7 configurations using Mirth, manage web application and database deployments including Dev, Staging, and Production environments.• Manage domain registrations and SSL certs.• Managed and updated custom in house .Net solutions.• Worked with current cloud hosting provider to troubleshoot/resolve issues. • Discovered and documented all business workflow processes

I am an on-site .NET Consultant developing custom .NET solutions for TWDB. I am utilizing C#, ASP.Net MVC 4.0, javascript, EF 5.0, nHibernate, Sencha Ext-JS 4.2, jQuery, MS SQL and SSRS. I am filling the role of Developer, Systems Analyst, and Team Lead. I am gathering requirements and creating both Functional Design Documents and Technical Specifications.

Develop solutions in SP 2013 for multiple clients in the Houston and surrounding areas.Assisted in SharePoint migrations, User Acceptance Testing, and custom form development.External Content Types, Custom Forms, SharePoint Apps, Workflows – ASP.Net 4.0, jQuery, Custom Web Parts.

Developed custom ASP.Net web applications utilizing – ASP.Net 3.5/4.0/4.5 c#, jQuery, html, entity framework, MS SQL and Linq for various Harris County departments. Met with stakeholders, assisted in requirement gathering and User Acceptance Testing.Custom solutions included Integration with legacy systems, uploading documents into Sharepoint document libraries via Sharepoint web services and IIS administration/configuration.Developed custom MS SQL reports utilizing SQL Server Reporting Services.Performed a proof of concept for Single Sign on that included setting up and configuring trust between on-site ADFS 2.0 and cloud based AZURE ACS, including multi-factor authentication.

On-site ATS .NET Software Engineer at MD Anderson Cancer center. Customized .net forms that are part of the MD Anderson Clinic Station EMR system.

Developed Custom Enterprise .NET applications.Developed SQL Server ReportsVB6 to .NET Migration