Pablo Echeverria
Verified Expert in Engineering
Transact-SQL (T-SQL) Developer
Guatemala City, Guatemala Department, Guatemala
Toptal member since June 19, 2020
Pablo is a talented database and software developer. He tuned long-running queries in Oracle and SQL Server, achieving an execution time of under one-second, reducing resource usage up to 10% and streamlined processes for a client reducing work time by 50%. He is a critical thinker who is writing a book about Polybase focused on implementation and testing. Pablo loves learning and connecting new technologies and wrote several articles about Oracle and SQL Server providing expert-level insight.
Portfolio
Experience
- Transact-SQL (T-SQL) - 17 years
- Oracle - 17 years
- SQL Server Reporting Services (SSRS) - 14 years
- ASP.NET - 10 years
- Microsoft Team Foundation Server - 6 years
- Windows PowerShell - 4 years
- SQL Server DBA - 4 years
- Java - 3 years
Preferred Environment
Microsoft Business Intelligence (MBI), Business, Machine Learning, Data, Microsoft, TFS, Oracle, Java, Visual Studio .NET, Microsoft SQL Server
The most amazing...
...system I've developed had 500 users create 7,000 letters printed and mailed the next day with PDF, images, databases, FTP, web services, and parallelism.
Work Experience
Database Security Administrator
Industria La Popular
- Contributed to the high availability of the core databases involving the interface with a legacy database system.
- Used Microsoft Power BI and Analysis Services for the management and planning.
- Utilized Microsoft SQL Server on Linux to interface with the manufacturing and distribution locations.
Logical Database Administrator
Atos Information Technology
- Developed an error log monitoring scheduled job written in T-SQL and invoked from PowerShell, which truly indicates if there are issues with any Microsoft SQL Server registered server.
- Tuned several long-running queries in Oracle and Microsoft SQL Server, achieving an execution time of under one second and reducing resource usage by up to 10%.
- Developed a large table cleanup script that does not lock resources and completes in under one second.
- Improved the installation, configuration, and optimization process for new instances, reducing the required time from five days to two hours.
- Created several monitoring processes and user permission scripts that allow one to respond to user requests immediately instead of waiting three business days, which was the norm.
Software Development Senior Specialist
Conduent
- Developed a system where 500 concurrent users create 7,000 letters printed and mailed the next day, and works with PDF, images, databases, FTP, web services, and libraries and technologies with parallel routines all coded for maintainability.
- Led and guided the development team in the use of the architecture of the existing solutions and help them deliver several quality projects on time and below budget.
- Acted as point-of-contact when collaborating among different support teams in the division, including incidents, monitoring, release, networking, and operating systems.
Developer and Analyst
Banco Promerica
- Developed a new user management web site that creates them across all systems such as Oracle, SQL Server, Paradox, DB2, MySQL, FreePBX, Asterix, Cisco, Live Communications Server, and Exchange.
- Integrated an outbound call center web site application with a predictive dialer optimizing agent time and easing call placement.
- Integrated the customer database with a campaign manager, allowing the marketing department to send email campaigns and track their success.
- Streamlined the processes of quality service and accounting departments, making it easier to digitalize information and reduce work time by 50%.
- Created an internet-facing web site allowing to cash points for articles at partner stores.
Developer and Analyst
e-Solutions
- Maintened a CRM web site application used in several national banks and major local enterprises.
- Prototyped an integration application for an international bank with compression and encryption capabilities.
- Created several data access components which were reusable across all projects and customers.
Experience
Author at MSSQLTips and SQLServerCentral
You can view work at: https://www.sqlservercentral.com/author/pabechevb and https://www.mssqltips.com/sqlserverauthor/267/pablo-echeverria/
Hands-on Data Virtualization with Polybase
Author of Oracle tips
Education
Bachelor's Degree in Computer Science and Systems
Universidad de San Carlos de Guatemala - Guatemala
Certifications
Database Administrator Oracle 19c
Talleres Oracle
Course 70-767: Implementing a Data Warehouse Using SQL
Atos
MCSA: Machine Learning
Microsoft
Exam 774: Perform Cloud Data Science with Azure Machine Learning
Microsoft
Course 70-466: Implementing Data Models and Reports with Microsoft SQL Server
Atos
Exam 773: Analyzing Big Data with Microsoft R
Microsoft
Exam 462: Administering Microsoft SQL Server 2012/2014 Databases
Microsoft
Intro to Parallel Programming
Udacity
Advanced Software as a Service
edX | BerkeleyX
Software as a Service
edX | BerkeleyX
Skills
Tools
Data Guard, Microsoft Team Foundation Server, Visual Studio .NET, TFS, Microsoft Power BI
Languages
Transact-SQL (T-SQL), SQL, C#, XML, Java
Frameworks
ASP.NET, .NET, ASP.NET Core, Windows PowerShell, Classic ASP, Hadoop
Paradigms
Oracle Database Architecture, Database Development
Platforms
Oracle, Linux, Unix, Microsoft, Azure
Storage
SQL Server DBA, SQL Server Reporting Services (SSRS), Microsoft SQL Server, SQL Stored Procedures, Database Administration (DBA), Oracle PL/SQL, JSON, Oracle 10g, Oracle DBA, Databases, Oracle 11g, IIS SQL Server, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS)
Other
PL/SQL Tuning, Unix Shell Scripting, SSRS Reports, MCDBA, Data, Machine Learning, Business, Microsoft Business Intelligence (MBI), Ajax, Data Engineering, Dashboards
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring