Humberto Francillard Email & Phone Number

United States

Accomplished leader with extensive experience managing Microsoft Hybrid Cloud infrastructure, ensuring secure and scalable IT services across both cloud and on-premise environments. Proven success in implementing modern and traditional technology stacks, delivering innovative solutions while seamlessly integrating legacy systems.Specialized in providing comprehensive support across the customer base, from endpoints and network infrastructure to VPN and security requirements, ensuring consistent service delivery and operational resilience.Expert in portfolio management, IT prioritization, and budget management, aligning IT strategies with business objectives to maximize ROI. Skilled in team mentoring and development, fostering a culture of innovation, growth, and continuous improvement.Committed to driving technology innovation and delivering solutions that enhance business performance, customer satisfaction, and enterprise growth.

Digital

FrancCo is the Marketing name I use when working as a freelancer or on personal projects. Some projects that I have developed are:- PepsiCo LatAm resources consumption dashboard: A data-driven solution that helped the LatAm Beverages division of PepsiCo to track water and resource consumption. Developed using MS Analysis Services with a Front End in ASP .Net and Charting from Dundas charts.- www.mesaderegalos.com. An ASP .Net application that was designed for the wedding of a friend that distributed links to users that allowed them to access and have select from the wedding gift list and to select one from the available ones, pretty much what is offered from big stores. - www.muebleriadiana.com. A web portal that was setup using the Shopify environment and Liquid code to provide an Internet sales channel to a furniture store that already had a direct sales channel.- www.miclubcinegetico.com. Project to develop a solution to manage and report associates of a shooting club to manage their subscriptions.

Chicago, Illinois, United States

As Integration Architect/Manager define the road map of the integrations for the customer to which I am helping. This includes R&D, Prototyping, Documentation, Design, Development, Implementation and Support.Below is a list of projects and achievements I have worked on:Implementation of a Boomi Molecule includes the design, setup, and configuration of storage accounts, virtual networks, virtual machines, load balancers, public IPs, DNS entries, and point-to-point connections. Also included the installation and set up of the actual Boomi molecule, and the testing and migration of the customers from an atom instance to the molecule. Designed and implemented multiple processes using a wide array of connectors such as NetSuite, DB, DBV2, FTP, SFTP, Salesforce, Disk, and Disk V2. Using all kinds of shapes to manage different XML, JSON, Flat File, and DB Document profiles.Created multiple APIs and API endpoints using REST best practices and integrated them into all kinds of APIs, REST and SOAP alike. Developed and implemented changes to Flow Apps by integrating them into multiple API requests and process routes results to allow our customer to access their Point of Delivery app on the go.

Greater Chicago Area

As a Solutions Architect I am in charge of defining the future road map of technical implementations for the company. This includes R&D, Prototyping, Design, Development, Implementation and Support of the solutions helping the operational execution.Bellow you will find a brief descriptions of the projects and technologies that I'm involved with:• Design and development of a platform that will help our customers to get data for Analytical Dashboards thus creating a competitive advantage by showing how they perform against the market in specific industry KPIs.For the project he following technologies are in use, Power BI, Power BI Embedded, DAX, ASP.MVC, Bootstrap, SQL and R project .• Plan and migration of the whole E-Commerce site, back end and front end, from the on premise servers in LA to the Excalibur Technologies cloud using IaaS.• Data migration from a company to another using transformation packages to create the data with the new identifiers.• SQL databases code structure creation to store the DBs as projects in TFS and from there being able to keep track of DB changes.• Migration and implementation of the report base stored in SharePoint to Reporting Services, setup of mailing and subscriptions for the reports to run automatically with different outputs (PDF, CSV, XLSX) for different resources.• Implementation of code modules for the Microsoft Dynamics 3rd party solution called SANA which will ultimately replace the current site.Technologies: T-SQL, MS SQL, Reporting Services, Linked Servers, Integration Packages, IIS Applications, SQL Servers, IaaS, C#. ASP MVC, X++, MS Dynamics AX, AIF

Colima

Migration of all production platform to Microsoft Azure IaaS, releasing the current production hardware and avoiding a 200k+ USDs investment for the required hardware.Migration of the old Excel reporting platform to MS Reporting Services obtaining a time to market increment of 300%.Team consolidation by adding resources to the current team structure of 3 allowing us to handle a bigger workload and a faster turnaround time for the stakeholders.Implementation of formal Software Development best practices such as Code Reviews, Proper Version Control, TFS configuration for SCRUM.Migration of desktop platforms to ASP MVC for higher availability and flexibility resulting in a big application launched to the Internet that is able to deal with multiple customer in house and external.Implementation of various Windows Communication Foundation services for targeting multiple sources such as Microsoft Great Plains, SQL databases and some legacy systems that are running thru DLLs, thus helps the company to increase the cross compatibility and communication of multiple platforms.Using MVC and Scaffolding the quick implementation of data solutions to help the business to deal with the multiple configurations that IT and themselves were needing to do manually.Implementation of multiple data replication processes and MS Integration Packages in order to distribute the data among different systems in order to provide automation to multiple processes increasing the revenue collection.

Zapopan Y Alrededores, México

Successfully changing the Shop Floor Control System for a multi million customer over the Guadalajara and Malaysia sites helping the customer to meet its revenue goals in increasing the marginal throughput by 20%.Operational support to many plants around the globe having them improving their operational performance across the departmentsImplementation of a software system that helps the shop floor to decrease the packing issues by 35%Implementation of an interface for the inserting machines that helps a property system to understand the quantity of components that were placed, decreasing the production line stops by 5%Implementation of a Security System to keep track of the access to a restricted area, thus helps security department to decrease shift changes from 50 to 10 minutes

Zapopan Y Alrededores, México

Teaching the topics of Advanced Programing, Data Warehousing and Distributed Databases at a Bachelor level

Zapopan Y Alrededores, México

Implemented the Configuration Management Process as per the CMMI level 4 was required helping the company to achieve the certification of such levelImplemented a 3 Tier architecture on a project that was being delayed in order to speed up the development and gain customer trust.Implementation of custom controls as a control library accessible from the toolbox of the Visual Studio environmentDesign and architecture of a SOA solution that help us to manage to delivering a standard accessible library for a whole solutionSCRUM methodology implementation for the projects I was working at.

Zapopan Y Alrededores, México

Design and Development of a solution for improving the image reading of Ink Cartridges evaluation, this helps the business to increase the testing volume by 10%Replacement of the standards ASP Data Grid for the Telerik Data Grid by doing this we get a higher acceptance in the launched productReplace of a standard hard-coded configuration module by one based on XML allowing the IT support to add configuration by changed the XML nodes

Tlajomulco De Zuñiga

Design and Development labeling system using ZLenguage that allows the user to print out custom labels for the classification of the production Line Stencils allowing the department to decrease the lead contamination by using color codingMigration of Excel macros to a Desktop system supported by SQL databases helping the department to grow the solutions easierDesign and Development of a solution for managing the Stencils turn around cycles using the labels that the other system was printing outDesign and Development of an application that helps the tool crib to manage the tooling for the Plant decreasing the tools losses and wastes by 20%

Master'S Degree, Computer Science

The graduate of this program is a professional not only capable of keeping pace with rapid technological advancements but also.

Bachelor In Computer Science, Computer Software Engineering

Activities and Societies: CUSoftware CongressThis bachelor's degree program is designed to equip students with the skills required.