I think that one page normally is not enough to describe years of experience in the marvelous and challenging world of IT, this is the main reason for having this page with a very detailed description about my professional experience of fifteen years in roles as a Database Engineer and Software Engineer.
Here I am presenting a detailed view of my last jobs which includes my functions, technologies, and a brief summary of my role there as well as official certifications.
Contents
Skills
Technological Skills: SQL Server 2008-2019, T-SQL and advanced optimization knowledge, SSIS, Relational Database Architecture, MySQL, Cassandra, Redis, Python, C#, GIT, Visual Studio, SSDT, Unit Testing (including on DB), Linux and Windows.
Soft Skills: Communication, Organization, Analytical Abilities, Creativity, Perseverance and Problem Solving.
Work Experience
Lead Data Engineer – LanguageWire (August 2021-Now)
www.languagewire.com Sector: Translation Services Countries: Spain No. of Employees: 300 to 500
Worked in a range of projects which involves the different stages associated with the design and database architecture, also it includes optimization of queries and improvement of Database design of Relational and NoSQL technologies as well as the planning and support to the development of new data pipelines process. Migration of Database platform (MS SQL Server) toward last versions, including the design and support for outcoming a new hybrid Database architecture (on-premises and Cloud). Develop a new standard ILM (archive and purge) solution based on MS SQL Server for applying the data retention policies.
Functions
- Design and support each migration process related to Databases, including from the selection of the best technology and service tier until the plan and post-migration monitoring.
- Develop complex business processes using MS SQL Server like Stored Procedures, Views, Functions, etc.
- Analyze and propose new Relational and NoSQL Database and support developers in the adoption of best practices.
- Review and analyze execution plans related to specific development and advice the best strategy to optimize the performance inside T-SQL solutions.
- Mentoring team members in the implementation of best practices and the use of new tools and features related to our stack of technologies.
- Support in tasks related to architecture and design of new Databases, DW, and processing massive workload.
- Develop new projects for the automation of process as ILM (purge and archive) and any improvements related to Database Automation.
Some technologies applied: SQL Server 2016-2019, Azure SQL, PostgreSQL, SSIS, GIT
Senior Software Engineer – DuckCreek (April-July 2022)
www.duckcreek.com Sector: Technology for Insurances companies Countries: Spain No. of Employees: 500 to 1000
Not too much to say here – Basic Training and one project completed.
Database Engineer – The Workshop (September 2016-March 2021)
www.theworkshop.com Sector: Games Online Countries: UK and Spain No. of Employees: 300 to 500
Worked on a range of projects which involved the optimization of queries and improvement of Database design of Relational and NoSQL technologies as well as the development of new DataWarehouse and ETL pipelines process. Migration of Database platform (MS SQL Server) toward last versions, including the design and support for outcoming a new hybrid Database architecture (on-premises and Cloud). Developed a standard ILM (archive and purge) standard solution based on Python and MySQL code for applying the data retention policies.
Functions
- Develop complex business processes using MS SQL Server and MySQL components like Stored Procedures, Views, Functions, etc.
- Develop new Cassandra DB and support developers in the adoption of best practices.
- Review and analyze execution plans related to specific development and advice the best strategy to optimize the performance inside T-SQL solutions.
- Mentoring team members in the implementation of best practices and the use of new tools and features related to our stack of technologies.
- I have worked on Business Intelligence projects with Microsoft Suite (SSIS and SSRS), including the migration of 2008 solutions to 2016/2019.
- Support in tasks related to architecture and design of new Databases, DW, and processing massive workload.
- Develop new projects using Python for automation of process as ILM (purge and archive) and any improvements related to Database Automation.
Some technologies applied: SQL Server 2016-2019, Cassandra, MySQL, Azure SQL, Python, SSIS, GIT
Software Engineer – Frontiers (April 2015-August 2016)
www.frontiersin.org Sector: Publishing Countries: Switzerland and Spain No. of Employees: 200 to 500
Worked as a member of the Impact Team, contributing to the design, develop and implementation of Databases for processing and storing statistics related to views/download associated with publications and citations of authors published by Frontiers, the process had operations as crawling, cleaning, validation and curation of data and querying in an optimized way a group of big Databases.
Functions
- I was part of the Impact Team, which was in charge of getting and processing a wide range of statistics related to publications, articles, and citations.
- As a member of this team, I was focus in optimize the capture and cleaning process of our data before to store in multiples databases.
- Implementing a new Unit Testing framework that allows us to have a warranty of having validated data before to persists or moves through the pipeline.
- Supporting take of decisions about new Database Servers and spike good technology to incorporate as part of the team’s stack.
Some technologies applied: SQL Server 2012/2014, MySQL, Entity Framework, C#, Web Api, GIT
IT Consultant – Citibank (May 2011 – March 2015)
https://www.citi.com/ Sector: Banking Countries: Costa Rica and Nicaragua No. of Employees: >10000
Worked as a member of the Impact Team, contributing to the design, develop and implementation of Databases for processing and storing statistics related to views/download associated with publications and citations of authors published by Frontiers, the process had operations as crawling, cleaning, validation and curation of data and querying in an optimized way a group of big Databases.
Worked in a group of projects related to improvement to the Core banking system (COBIS) in the Central America area, including new features and platforms for collecting public services payments.
Functions
- Developed a group of projects related to the Core banking system (COBIS) in the central American area, including working through different countries, and integrating new features focuses to improve the service and portfolio.
- Develop and implement best practices for evaluating the impact of new T-SQL code and how to optimize them.
- Completing and reviewing deploy instructions and processes to follow in every new scheduled deployment.
- Coding and testing code that should be integrated as part of the Core system.
Some technologies applied: Sybase, WCF, C#, VB6.0, T-SQL, XML.
Software Developer – Banco de Finanzas (August 2008 – April 2011)
https://www.bdfnet.com/ Sector: Banking Country: Nicaragua No. of Employees: 350 to 500
Worked as a Software Developer, contributing to the design, develop and implementation of new features related to the branch modules and saving accounts.
Functions
- Design and develop automation solutions-oriented to solve problems and cover necessity associated with internal customer requests.
- Documenting all the requests and propose solutions according to software standards and compliance banking framework.
IT Certifications and awards
Everybody knows that the most important in the IT world is the experience, but if you want to companion this valuable experience with certifications, it is so good to step, especially because you will learn so many new topics during the study journey, here I want to share some of my certifications.
Microsoft
I am MCT, MCSE, MCSA, MCTS, in the following link you can access to my official Microsoft validation profile.
Microsoft Official Transcript: https://mcp.microsoft.com/anonymous/transcript/validate TranscriptId: 1090824 Code: geohernandez
Cassandra DataStax
https://certification.mettl.com/datastax/applicant/verify-certification
Email for search: geohernandez at gmail.com
Red-Gate
Awared as Friend of RedGate program during the last five years, you can verify it in the following link
https://www.red-gate.com/hub/events/friends-of-rg/friend/geovanny.hernandez
Speaker Events
I really love to be a speaker, during the last 5 years I have participated in different events from local initiatives to international events as SQLBits.
Nowadays, I am a regular speaker on database technologies and unit testing on DB technologies. I have a strong compromise with the Dev community in Malaga, Spain and it impulses me to give them quality content as part of PASS Malaga chapter.
Here you can see every event that I have participated in from 2019, notice that some sessions are in Spanish and this is because I really love to share with the Spanish and Latin American community.