IVÁN SALOMÓN HERNÁNDEZ GIL

Improvements:

• Collaborated with cross-functional teams to achieve project goals on time and within budget.
• Improved customer satisfaction rates through proactive problem-solving and efficient complaint resolution.
• Followed all company policies and procedures to deliver quality work.
• Championed the adoption of new software tools that streamlined workflows across multiple departments.
• Support for possible failures and solutions regarding implemented projects

Implemented projects:

IBW Mexico: Migration of the File Server service in Windows Server 2012 to SharePoint Online.

Technologies used:

• SharePoint Online
• PowerShell scripts
• Power Automate
• OneDrive
• Windows Server 2012

IBW Mexico: Development Outlook Addin to copy attachments to SharePoint Library.

Technologies used:

• SharePoint Online
• Visual Studio .Net
• Microsoft Graph
• HTML, CSS, JavaScript
• RESTful APIs

Fronterra: Migration of Google Workspace and Google Drive Mailboxes to Microsoft O365.

Technologies used:

• Google WorkSpace
• Google Drive
• OneDrive
• Exchange O365
• Outlook Client
• Microsoft Migration Manager
• Microsoft SharePoint Migration Tool

DIF Estado de México: Automation of sending mental health course certificates to participants.

Technologies used:

• SharePoint Online
• Power Automate
• Outlook Client
• Excel Template

Kippling: Migrate VmWare virtual servers to Microsoft Azure Virtual Machine.

Technologies used:

• Microsoft Azure
• Azure Migrate
• Azure Momitor
• Azure Backups
• Azure Site Recovery
• Windows Server 2008 - 2022
• IIS Applications
• SQL Server 2016
• SharePoint 2019

Improvements:

• Responsible for the development business area, overseeing technological implementations with Microsoft solutions both in the consultancy's internal projects and with the client portfolio in Latin America.
• My main functions are to understand cloud technologies such as Microsoft Azure, and On-Premises services, to promote the best appropriate solutions to meet customer needs, as well as create and implement internal administrative and technical processes for monitoring and compliance to projects in a timely manner, both around pre-sales, developments and implementations and post-implementation service to identify areas of continuous opportunity with clients.
• Evaluated emerging technologies to stay current on industry trends, making informed decisions for technology adoption.
• Developed comprehensive documentation for technical specifications, project plans, and user guides, streamlining communication across teams.
• Maintain the continuity of the applications implemented with clients to resolve possible failures and new requirements in both On-Premise, cloud and hybrid environments.

Implemented projects:

Komatsu Mexico: Migration of virtualized infrastructure in VmWare and On-Premise applications to Microsoft Azure.

Technologies used:

• Microsoft Azure
• Azure Migrate
• Azure Momitor
• Azure Backups
• Azure Site Recovery
• Windows Server 2012 - 2022
• IIS Applications
• SQL Server 2019
• Integration of legacy applications in a hybrid environment.

Optoflux Mexico: IInventory and warehouse management integratio.

Technologies used:

• Microsoft Dynamics Bussines Central
• Power Apps
• Power Automate
• .Net

Lundin Gold: Automation of the attention call process in Human Resources.

Technologies used:

• Power Apps.
• Power automate.
• Power BI
• SharePoint Online
• PowerShell Scripts

Navega Training & Consulting: Migration of Centralized Document Management to SharePoint Online.

Technologies used:

• SharePoint Online
• PowerShel Scripts.
• OneDrive
• Power Automate
• Teams

Connective IT Solutions: Implementation of improvements to the Internal SharePoint Portals.

Technologies used:

• SharePoint Online
• HTML5
• JavaScript
• .Net
• SharePoint 2019 On-Premise
• Master Page, Page Layouts
• WebParts
• PowerShell Scripts
• SharePoint Designer Workflows.
• Power Automate
• Power Apps
• Microsoft SQL Server 2019

Central de Mangueras: Implementation of a high availability database architecture.

Technologies used:

• Microsoft SQL Server 2022
• Always On Technology
• Windows Server 2022
• Failover Clustering Services in Windows Server
• Active Directory objects
• Log Shipping Technilogy
• PowerShell Scripts

Improvements:

• Recommended robust architectures based on best practices to resolve specific needs with the client.
• The role I played was L4 level Architect, for resolving incidents at lower levels, as well as implementing solutions in migrations of On-Premises services to the cloud and native, supervising a work team of people under the Agile-Scrum methodology, with the objective of maintaining control in each work team of the activities to be carried out and executed in each client project.
• Attended team meetings to resolve technical and project issues and review project schedules.
• Maintained strong communication with clients throughout the design process to ensure alignment between their vision and the final product.
• Applied creative problem-solving skills to address unique challenges in the architectural design process.
• Developed comprehensive project documentation, including site plans, elevations, sections, and details for clear communication of design intent.
• Additionally, as part of my additional responsibilities, I was to help guide other work teams from different projects to solve problems.

Assigned client:

Hitachi Switzerland and USA: Mainly in technical matters, I was in charge of creating solution architectures for the client's internal projects, in terms of migrations of legacy applications, developments towards Microsoft technologies with cloud services, as well as hybrid integrations On-Premise and cloud..

Activities:

• Migration of automated processes in Lotus Notes using SharePoint Online, Power Automate, Power Apps, Web Services, Rest APIs, Azure Databases, SQL Server, Oracle, SAP.
• Migration of SharePoint On-Premise Sites to SharePoint Online, using Powershell Scripts, SharePoint Migration Tool
• SharePoint Designer, .Net Workflow Migration with Power Automate,
• Migrate WebParts and applications hosted on SharePoint On-Premise with Power Apps
• Migrate File Share to OneDrive with Microsoft O365 Tool and PowerShell Scripts.
• Implementation of backup and restore architectures for databases in SQL Server, SharePoint On-Premise and SharePoint Online, using PowerShell Scripts, Maintenance plans with SQL Server, Microsoft O365 tool
• Provide support to end users and those responsible for post-migration applications.
• Troubleshoot and track issues using a ticketing tool
• Resolve and track issues with a ticketing tool for Microsoft O365 services, SharePoint On-Premise Farms, SQL Server
• Development of applications and scripts with PowerShell for administrative and monitoring tasks.

Improvements:

• Mentored junior consultants, helping them enhance their skills and contribute more effectively to projects.
• Prioritized projects and project tasks depending upon key milestones and deadline dates.
• Troubleshot issues by understanding issue, diagnosing root cause and coming up with effective solutions.
• Collaborated with internal teams to develop customized solutions that addressed unique client needs.
• Built strong relationships with client through consistent communication and proactive problem-solving efforts.
• Increased client satisfaction by providing tailored consulting services and effective problem-solving strategies.
• Identified key areas in need of improvement and implemented plans to rectify issues.
• Delivered high-quality solutions for client through comprehensive research and analysis of industry trends.
• Evaluated existing business processes, recommending improvements that led to increased operational efficiency.
• Streamlined project management processes, improving efficiency and reducing overall costs.
• Presented findings and recommendations to executive-level stakeholders, effectively communicating key insights and action plans.
• Developed custom solutions based upon clients' strict requirements.
• Generated reports detailing findings and recommendations.
• Created and managed project plans, timelines and budgets.
• Maintained database systems to track and analyze operational data.
• Gathered, organized and input information into digital database.
• Collected, arranged, and input information into database system.
• Observed packing operations to verify conformance to specifications.

Activities:

• SharePoint Administrator, SQL Server. Management of SharePoint 2010 until 2019 farms, at the server and application level.
• SQL Server administrator in 2008 until 2022 version at the server and application level.
• .Responsible for sizing new architectures with the most recent versions of SharePoint and SQL Server in High Availability and Disaster Recovery.
• Responsible for defining, based on best practices, the implementation of environments at the development, testing, and production levels for SharePoint and SQL Server.
• Implementation of automation of internal processes with Microsoft technologies, such as flows with SharePoint Designer, .Net, PowerShell, SQL Integration Services
• Implementation of SQL Server backup schemes and SharePoint Farms
• Automate administrative tasks for SQL Server, SharePoint On-Premise, and SharePoint Online, and OneDrive with PowerShell.
• Design and implementation of hybrid schemes with SQL Server, SharePoint, and cloud services, among other applications.
• Execution of error remediations after updating SQL and SharePoint instances.
• Application of cumulative updates in SharePoint farms after previously carrying out an assessment of the environments.
• Evaluate and recommend improvements to previously installed and configured SQL Server, SharePoint On-Premise, and SharePoint Online environments.
• Review and apply security patches to SharePoint farms and SQL Server instances.
• Implementations of solutions developed in SharePoint On-Premise and SharePoint Online.
• Monitoring SharePoint farms and SQL Server instances
• Soporte a usuarios finales para soporte en SharePoint Sites On-Premise, SharePoint Online, Power Platform, O365 y SQL Server
• Perform troubleshooting analysis to resolve issues in SharePoint and SQL Server farms, as well as deregister services from both technologies when they are out of use.

Some of the most outstanding achievements are:

• Migration of SharePoint 2007 until 2019 from the CNSF Portal and Intranet from a stand-alone environment (Two Tier Topology) to a 3-level environment (Three Tier Topology).
• Implementation of centralized administration of 600 computers with McAfee Antivirus ePO 4.6.
• Automation of information upload processes to the CNSF Portal
• Process automation for EIQ reports.
• Automating AD administrative processes with PowerShell.
• Sizing and implementation of environment for development, testing, and production for SharePoint 2013 until 2019, SQL server 2014 until 2019, and CRM 2013.
• Sizing For the productive environment considering High Availability in SQL Server 2014 until 2019, SharePoint 2013 until 2019, CRM 2013, as well as a DRP in an alternate site.
• Automation of the installation and configuration of stand-alone and high availability SQL Server Instances, as well as SharePoint Farms with Windows Forms made with Powershell scripts

Improvements:

• Participated in different projects, developing and implementing technologies such as SQL Server, Visual Studio .NET C#, SharePoint, Business Intelligence with SQL Server, System Center Services, Office suite Developer, Windows Server, PowerShell
• Performed roles such as project leader, developer, presale, architect of solutions, and implementer.
• Performed proof of concept demonstrations, instructing potential customers on benefits of SharePoint, SQL Server, System Center, Process automation, Navisión, etc.
• Recommended specific Microsoft products to customers based on unique technical requirements of each.
• Created detailed documentation for each project, ensuring seamless handover to support teams upon completion.
• Inspected products as part of adherence to quality standards.
• Worked closely with senior leadership to complete projects and solve complex issues on strict schedules and budgets.
• Improved project completion time, utilizing multiple painting materials and processes.
• Managed diverse projects and resolved complex issues to support timely completion.
• Resolved customer issues quickly and efficiently to enhance overall customer satisfaction ratings.
• Evaluated diverse organizational systems to identify workflow, communication, and resource utilization issues.

My participation in most notable projects are:

Anáhuac University Campus State of Mexico.
Implementation of 3 portals with searches for the school area and Digital Services.
Technology Used: SQL Server 2008 R2, SharePoint 2010, FAST Search 2010 for SharePoint, Visual Studio 2010.
Role: Search implementer for Intranet sites, Digital Platform.

GBM – Microsoft MCS
Implementation of the automation of the generation process of GMB Client Portfolios.
Technology Used: SQL Server 2012 RC0, SSIS 2012, Excel 2010, Visual Studio 2010, SSRS 2012.
Role: Implementer of integration and reporting packages.

HERDEZ Mexico
Participation in the implementation of a BI solution to manage management reports.
Technology used: SharePoint Portal Server 2010, SQL Server 2008 R2, SSAS 2008 R2, SSRS 2008 R2, Excel Services, Silverlight 4.0.
Role: Developer, Project Leader.

Microsoft Mexico
Participation in the restructuring of a Campaign registration tracking system for Microsoft.
Technology used: SharePoint Server 2010, Silverlight, SQL Server 2008, .NET VB, Access 2010. Role: developer.

GPTW-Mexico
Participation in the Migration of a SharePoint 2007 site
Technology Used: SharePoint Portal Server 2007, SQL Server 2005, Windows Server 2008 x64, Office Web Components, OLAP Cubes.
Role: Project Leader and implementer of part of the Solution.

Participation in developing a data transformation application (ETL), in order to generate a BI based on Excel templates.
Technology Used: SQL Server 2005, Visual Studio .Net C#/VBasic, SQL 2005 SSIS, SharePoint 2007
Role: Project Leader and solution implementer.

Scappino Mexico
Participation in the Migration at the database level of your ERP.
Technology Used: SQL Server 2005 x86, SQL Server 2008 x64, Windows Server 2003. Windows Server 2008, Microsoft Navision 4.0. Role: Project Leader. Participation in the Implementation phase.
Participation in the preparation of Technical Area Reports.
Technology Used: SQL Server 2008 x64, Crystal Reports 10, Microsoft Navision 4.0, Visual Studio 2008 C#
Role: Project Leader, Participation in the analysis and implementation phase

Improvements:

• Contributed to team success by completing jobs quickly and accurately.
• Participated in different projects, developing and implementing technologies such as SQL Server, Visual Studio .NET C#, SharePoint, Business Intelligence with SQL Server, System Center Services, Office suite Developer, Windows Server, PowerShell, SharePoint Designer, InfoPath, HTML, CSS, JavaScript
• Performed roles such as developer, presale, and implementer.
• Collaborated with cross-functional teams to successfully deliver comprehensive solutions for clients.
• Managed client relationships through regular check-ins and updates on project progress.

The most representative projects are:

ING Mexico
Creation of a Weekly Electronic Bulletin, with the main functionality of sending it to ING users via email, as well as configuring an approval flow for news generated for the bulletin and a review flow for said Bulletin. The technologies used SharePoint Portal Server 2007, SQL Server 2005, Visual Studio 2008, SharePoint Designer, Outlook 2007 and 2003.

AXA Insurance
Creation of a portal in Sharepoint 2007 for Claims administration, using Excel Services, Workflows

Santander Bank
Provide an end-user solution for your product process that offers a friendlier, easier-to-use interface by developing web-compatible InfoPath forms.
The technologies used were: MOSS 2007, VB.Net C#, office 2007 (InfoPath 2007), Office 2003 (Word, Excel), Forms Services.

Pfizer Intranet (Pfizer SA de CV)
Implementation of MOSS 2007 for the Pfizer Intranet, with the aim of providing reliable and up-to-date information to the users of said Institution, as well as control of its business documentation. And custom MOSS design.
The technologies used were: MOSS 2007, VB.Net, C#, HTML, CSS, Office 2007, SQL Server 2005, Custom Webparts for MOSS 2007, SharePoint Designer 2007.