← Back to list
Registration: 07.11.2025

Fernando Palacios

Specialization: Solutions / Database Architect
— A Project and Technical Leader with a strong technical and managerial background which includes project management, requirements analysis, design, implementation, testing and documentation for various projects such as big EAI (Enterprise Application Integration) projects. — Experienced with functional, architectural and technical skills required to define strong database structures and sound software solutions. — Managed projects and mentored development teams in ETL technologies like Informatica, DTS and CORBA. — Solutions Architect with Experience developing layered applications, MVC and repository architectures. — Visual C++, object technology and database solutions using SQL Server, Oracle and Sybase databases. — Extraordinary ability to solve complex problems. — Knowledgeable of business processes in order to efficiently translate business models into the database and software solutions. — Experienced with freelance projects and management by objectives. — Industry Experiences includes Pharmaceutical, Finance, Software Development and Education.
— A Project and Technical Leader with a strong technical and managerial background which includes project management, requirements analysis, design, implementation, testing and documentation for various projects such as big EAI (Enterprise Application Integration) projects. — Experienced with functional, architectural and technical skills required to define strong database structures and sound software solutions. — Managed projects and mentored development teams in ETL technologies like Informatica, DTS and CORBA. — Solutions Architect with Experience developing layered applications, MVC and repository architectures. — Visual C++, object technology and database solutions using SQL Server, Oracle and Sybase databases. — Extraordinary ability to solve complex problems. — Knowledgeable of business processes in order to efficiently translate business models into the database and software solutions. — Experienced with freelance projects and management by objectives. — Industry Experiences includes Pharmaceutical, Finance, Software Development and Education.

Skills

Microsoft Azure
DevOps
Python
Project Management
Requirements Analysis
ETL
Informatica
DTS
CORBA
Microsoft Visual C++
SQL Server
Oracle
Sybase
Powershell
Azure SQL
AWS
Visual Studio
C#
OOP
SOAP
REST
API
T-SQL
JavaScript
XML
JSON
MySQL
SSIS
HTML
CSS
Analysis
Algorithms
Linux
Korn Shell
OBIEE
SQL
PL/SQL
Ab Initio
Multithreading

Work experience

Solutions / Database Architect
since 12.2021 - Till the present day |NDA
Azure, SQL, ETL, Python, Powershell
● Design new architectures for applications and integrations. ● Design, performance tune and maintain databases for reporting and analysis. ● Support and manage Azure resources like, but not limited to, Azure SQL databases, virtual machines, storage, webapp, LogicApp and functions. ● Design and develop azure data factory pipelines for ETLs and Enterprise Application Integration. ● Code database objects like tables, stored procedures, functions, triggers and indexes. ● Develop backend processes of information in scripting languages like Python and Powershell. ● Provide support to various internal (developed in-house) and external applications (third party). ● Design and implement integrations with external and internal platforms and applications. ● Perform analysis and reporting of information (forecast, cost, KPI). ● Partner with business units to understand their current and future needs, then collaborate with vendors and in-house team members to ensure those needs are met.
Definity First
01.2019 - 08.2022 |Data Engineer
Azure SQL, ETL, AWS, MongoDB cluster, Kafka cluster, Storm cluster
Virtuoso project: ● Maintained Azure SQL database (user creation, backup restore, permissions, partitions). ● Created Azure Data Factory pipelines to feed information from Agencies to VMS Azure SQL database. ● Developed a validation engine to validate data being feed into VMS database. ● Developed a partition engine to coordinate execution of ETLs to feed VMS database. ● Researched on Neo4j graph database and its application to Virtuoso data mining process. Allied Reliability project: ● Coded new functionality for an iOS and Android app using ionic framework. ● Resolved bugs raised by application user on the app. ● Proposed and developed improvements to current algorithms. Atlantic57: ● Migrate a web application from physical infrastructure in vendor's location to AWS. ● Configure AWS VPC public and private subnets. ● Set up EC2 instances to execute a MongoDB cluster, a Kafka cluster, a Storm cluster and a Rosoka natural language processing service. ● Configure EC2 instances to execute java processes to implement backend services. ● Provide support to AWS infrastructure and work in bug fixes. ● Write draft of failover and disaster recovery plans.
Solutions / Database Architect
08.2017 - 06.2022 |SPY
SQL Server, Visual Studio, C#, OOP, SOAP, REST, API, T-SQL, JavaScript, XML, JSON
Apply significant professional experience and training in information technology and computer programming to the analysis, design, modification, and maintenance of application programs, integrated systems, and/or software solutions. ● Design and Implementation of Spy Optic data warehouse using dimensional models. ● Develop SSIS ETLs using SQL Server and Visual Studio. ● Help define the strategy, architecture and vision of the organizations technology initiatives alongside the Director, IT. ● Provide leadership in areas of the development process, including development standards and practices and architect, design and develop web applications. ● Perform administrator and development functions as dictated by the needs of the business within web applications. ● Partner with business units to understand their current and future needs, then collaborate with vendors and in-house team members to ensure those needs are met. ● Partner with the ERP, Business and Technology teams to develop processes, improve reporting, and provide system enhancement. ● Work with the team to develop features for existing service-orientated .NET application using C# and Object Orientated programming. ● Add functionality to web services either SOAP or REST and integrate API’s. ● Build out data access layer components using T-SQL stored procedures and SQL Server. ● Web Application support new applications including JS/XML/JSON. ● Realize database design, data feeds and data exchange. ● Oversee the implementation, performance and maintenance to internal, external and third-party integrations. ● Creation and execution of SQL scripts against Great Plains databases. ● Administration and Tuning of database environments.
Principal Architect
04.2015 - 07.2017 |NearShore Technology
SQL Server, MySQL, Aqua Data Studio, C#, Visual Studio, PowerShell, SSIS, HTML, CSS, Analysis, Design of Algorithms
● Create and validate architectures and database designs for applications aimed to automate and streamline Nearshore's and Nearshores's client's processes.
Reporting / BI Consultant
since 08.2012 - Till the present day |4thSource
Oracle, SQL Server, C#, Visual Studio, PowerShell, SSIS, HTML, CSS, Linux, Korn Shell, OBIEE, SQL, T-SQL, PL/SQL, Informatica PowerCenter, Ab Inito, Multithreading, Analysis, Design of Algorithms
● Design and implent custom reporting solutions for United BioSource Corportation (UBC) to report on client health, status and service to several UBC clients. ● Architect solutions to automate manual work in order to streamline the complete reporting process.
BI Leader / Architect
05.2010 - 08.2012 |4thSource
Oracle, SQL Server, C#, Visual Studio, PowerShell, SSIS, HTML, CSS, Linux, Korn Shell, OBIEE, SQL, T-SQL, PL/SQL, Informatica PowerCenter, Ab Inito, Multithreading, Analysis, Design of Algorithms
● Architected custom-coded solutions for the Medco Warehouse that enabled them to enter the European market. ● The solution consisted of two data warehouses. One transactional for analysis and daily operations and the other data warehouse was implemented using a dimensional approach for reporting.
Consultant
10.2008 - 05.2010 |4thSource
Oracle, SQL Server, C#, Visual Studio, PowerShell, SSIS, HTML, CSS, Linux, Korn Shell, OBIEE, SQL, T-SQL, PL/SQL, Informatica PowerCenter, Ab Inito, Multithreading, Analysis, Design of Algorithms
● The performance team reviewed all PL/SQL code written for Accredo Health Care and complied with performance standards, which included execution time, disk access and optimization of Oracle resources.
BI Consultant
02.2008 - 10.2008 |4thSource
Oracle, SQL Server, C#, Visual Studio, PowerShell, SSIS, HTML, CSS, Linux, Korn Shell, OBIEE, SQL, T-SQL, PL/SQL, Informatica PowerCenter, Ab Inito, Multithreading, Analysis, Design of Algorithms
● The Global Business Intelligence project implemented the entire suite of Oracle Business Intelligence Enterprise Edition across multiple functional areas including Supply Chain, Order Management, Finance, Human Resources and Sales.
Project Leader
09.2004 - 01.2008 |Softtek
Oracle 9i, Sybase, Transact SQL, PL/SQL, SQL, Perl, Unix, Power Center 8, Informatica, SSIS, PERL, TCL, Shell Scripting, UML, MS Office, Windows XP, Waterfall and GE development life cycle, Analysis, Design of Algorithms
Data Migration: ● Managed a team of developers and testers that migrated the GE Treasury Debt and Derivatives Information from the Infinity system to WTC Systems. ● Managed the project plan and oversaw the fulfillment of the plan goals. ● Elicitated business requirements and converted them into functional specifications. ● Created documentation using relational models and UML notation. ● Designed, implemented, tested and deployed migration modules. Debt and Derivatives (EAI): ● Managed and mentored a technical team of consultants working on developing custom applications. ● Translated business requirements into functional specifications. ● Provided risk analysis. ● Created documentation using UML notation. ● Designed, implemented, tested and deployed applications to grow the debt and derivatives platform for GE Treasury. ● Deployed the applications by using layered, repository and MVC architectures as well as several design patterns. ● Provided oversight and mentoring to an offshore development team. Application Support: ● Managed a project that provides global support to the GE Treasury Debt and Derivatives Platform. ● Led a team of three application support members near shore and five more offshore.
Grader
08.2003 - 12.2003 |The University of Kansas
C++, VB6, Analysis of Algorithms, SQL, Linux, UML
Assisted the associate professor in class preparation and grading of students’ projects. ● Gave exams and homework to students. ● Provided assistance to the students in the development of their projects and homework.
Advisor to the Secretarial of Social Development
10.1999 - 12.2000 |Social Development Ministry
UML, MVC, Repository
1. Application Development: Developed a custom application for the personal use of the Secretarial of Social Development. ● Translated business requirements into functional specifications. ● Created documentation using relational models and UML notation, design, implementation and testing of applications using object technology. ● The applications developed were used in the analysis and processing of social and economic information, and managing personal information and they used MVC and repository architectures. 2. Data Processing: Generated programs to arrange information about Mexican poverty measurement and evolution in order to present it to the Secretarial. ● Compared various methodologies for the measurement of poverty. ● Modeled repositories by applying relational models to efficiently access the information processed.
Departmental Chief
07.1991 - 10.1999 |Statistical, Geographical and Informatics National Institute
OMT Notation, Analysis, Testing
1. Institutional Department of Training: Managed a team of three developers that developed an application for managing the training process of INEGI’s employees. ● Provided documentation using OMT notation, analysis, design, implementation, testing and deployment of applications using object technology. ● Designed modules to keep information about courses, grades, employee information; modules to follow up employees inside a career path; modules to analyze and produce statistical information of the training process. 2. Data Processing and Research: Developed and delivered a Visual C++ application to assist in the research of Mexican poverty. ● Developed this application with layered and MVC architectures. ● Included modules to process statistical and historical information from several sources concerning vital statistical information about Mexican poverty. ● Ran simulation modules to tune up public assistance and modules to present information in different formats at different levels. 3. Payroll and Human Resources: Developed a custom application to assist the human resource process and to generate payroll for INEGI’s employees. ● Developed modules for the hiring process and working affairs. ● Generated payroll and reported payroll information for other governmental institutions.

Educational background

Posgrado, Artificial Intelligence
since 2024 - Till the present day
Universidad Tecmilenio
Computer Science, Software Engineering (Masters Degree)
2001 - 2004
University of Kansas

Languages

EnglishAdvancedSpanishNative