Pablo Echeverria，危地马拉市开发人员，危地马拉部门
Pablo is available for hire
Hire Pablo

Pablo Echeverria

Verified Expert  in Engineering

Software Developer

Location
危地马拉城，危地马拉部，危地马拉
Toptal Member Since
June 24, 2020

巴勃罗是一位天才的数据库和软件开发人员. 他调整了Oracle和SQL Server中长时间运行的查询, 实现不到一秒的执行时间, 减少10%的资源使用，为客户简化流程，减少50%的工作时间. 他是一个批判性的思考者，正在写一本关于Polybase的书，专注于实现和测试. Pablo喜欢学习和连接新技术，并撰写了几篇关于Oracle和SQL Server的文章，提供了专家级的见解.

T-SQL (Transact-SQL)OracleMicrosoft SQL ServerSQL.NETC#SQL Stored ProceduresDatabasesDatabase DevelopmentOracle 11gIIS SQL ServerSQL Server Reporting Services (SSRS)ASP.NETJSONXML

Portfolio

Atos Information Technology
Windows PowerShell, Oracle, Microsoft SQL Server, SQL, T-SQL (Transact-SQL)...
Conduent
SQL Server报表服务(SSRS)， TFS, Microsoft SQL Server, Ajax...
Banco Promerica
Oracle, SQL Server报表服务(SSRS)， Microsoft SQL Server, Ajax...

Experience

T-SQL (Transact-SQL) - 17 yearsOracle - 17 yearsSQL Server Reporting Services (SSRS) - 14 yearsASP.NET - 10 yearsMicrosoft Team Foundation Server - 6 yearsWindows PowerShell - 4 yearsSQL Server DBA - 4 yearsJava - 3 years

Availability

Part-time

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封信打印出来，第二天以PDF格式寄出, images, databases, FTP, web services, and parallelism.

Work Experience

Logical Database Administrator

2016 - PRESENT
Atos Information Technology
  • 开发了一个用T-SQL编写并从PowerShell调用的错误日志监视计划作业, 真正表明是否有任何SQL Server注册服务器的问题.
  • 在Oracle和SQL Server中调整了几个长时间运行的查询, 实现不到一秒的执行时间，并减少高达10%的资源使用.
  • 开发了一个大型的表清理脚本，它不会锁定资源，并且在一秒钟内完成.
  • Improved the installation, configuration, and optimization process for new instances, 将所需时间从5天减少到2小时.
  • 创建了几个监视进程和用户权限脚本，允许立即响应用户请求, as opposed to waiting three business days, which was the norm.
Technologies: Windows PowerShell, Oracle, Microsoft SQL Server, SQL, T-SQL (Transact-SQL), SQL Stored Procedures, Database Administration (DBA), Oracle PL/SQL, PL/SQL Tuning, Unix Shell Scripting, Oracle Database Architecture, Oracle 10g, Oracle DBA, Databases, SSRS Reports, SQL Server Reporting Services (SSRS), Oracle 11g, Linux, Unix, Data Guard

Software Development Senior Specialist

2010 - 2016
Conduent
  • 开发了一个系统，其中500个并发用户创建7,000 letters printed and mailed the next day, and works with PDF, images, databases, FTP, web services, 带有并行例程的库和技术都是为了可维护性而编码的.
  • 领导和指导开发团队使用现有解决方案的体系结构，并帮助他们按时交付几个高质量的项目，并且低于预算.
  • 在部门内不同的支持团队之间进行协作时，作为联络点, including incidents, monitoring, release, networking, and operating systems.
技术:SQL Server报表服务(SSRS)， TFS, Microsoft SQL Server, Ajax, Visual Studio .NET, SQL, T-SQL (Transact-SQL), .NET, ASP.. NET, c#， SQL存储过程，数据库，数据库开发，SSRS报表，IIS SQL Server

Developer and Analyst

2007 - 2010
Banco Promerica
  • 开发了一个新的用户管理网站，可以跨Oracle等所有系统创建用户, SQL Server, Paradox, DB2, MySQL, FreePBX, Asterix, Cisco, Live Communications Server, and Exchange.
  • 集成了一个出站呼叫中心网站应用程序与预测拨号优化代理时间和简化呼叫放置.
  • 整合客户数据库与活动经理, 允许营销部门发送电子邮件活动并跟踪其成功.
  • 精简质量服务和会计部门的流程, 使信息数字化更容易，工作时间减少50%.
  • 创建了一个面向互联网的网站，允许在合作商店的文章兑换现金.
Technologies: Oracle, SQL Server报表服务(SSRS)， Microsoft SQL Server, Ajax, Visual Studio .NET, SQL, T-SQL (Transact-SQL), .NET, ASP.. NET, c#，数据库，数据库开发，SSRS报表，Oracle 11g, IIS SQL Server

Developer and Analyst

2005 - 2007
e-Solutions
  • 维护了一个CRM网站应用程序，应用于几家全国性银行和当地大型企业.
  • 为一家具有压缩和加密功能的国际银行开发了一个集成应用程序原型.
  • 创建了多个可在所有项目和客户中重用的数据访问组件.
技术:Microsoft SQL Server, Classic ASP, SQL, T-SQL (Transact-SQL)， ASP.. NET，数据库，数据库开发，IIS SQL Server

Author at MSSQLTips and SQLServerCentral

http://www.mssqltips.com/sqlserverauthor/267/pablo-echeverria/
为数据库管理员和开发人员提供指导和高级脚本解决方案, 通过易于理解的问题描述和逐步指导来解决现实生活中的问题.
You can view work at: http://www.sqlservercentral.com/author/pabechevb and http://www.mssqltips.com/sqlserverauthor/267/pablo-echeverria/

Hands-on Data Virtualization with Polybase

http://bpbonline.com/products/hands-on-data-virtualization-with-polybase
《欧博体育app下载》一书的作者, where people can learn how to use Docker, Azure, 和Amazon免费应用于SQL Server Polybase, and create Hadoop, Big Data Clusters, etc.

Author of Oracle tips

Author of Oracle tips at my LinkedIn profile, where people can find automated scripts in Bash, software installation in Docker, setup, and tests performed in a controlled environment, among other things.

Languages

T-SQL (Transact-SQL), SQL, C#, XML, Java

Frameworks

ASP.NET, .NET, ASP.. NET Core, Windows PowerShell, Classic ASP, Hadoop

Tools

Data Guard, Microsoft Team Foundation Server, Visual Studio .NET, TFS

Paradigms

Oracle数据库架构，数据库开发

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

2002 - 2006

计算机科学与系统学士学位

危地马拉圣卡洛斯大学-危地马拉

AUGUST 2022 - PRESENT

Database Administrator Oracle 19c

Talleres Oracle

JULY 2019 - PRESENT

课程70-767:使用SQL实现数据仓库

Atos

JUNE 2019 - PRESENT

MCSA: Machine Learning

Microsoft

JUNE 2019 - PRESENT

考试774:使用Azure机器学习执行云数据科学

Microsoft

JANUARY 2019 - PRESENT

课程70-466:使用Microsoft SQL Server实现数据模型和报表

Atos

JANUARY 2019 - PRESENT

Exam 773: Analyzing Big Data with Microsoft R

Microsoft

MARCH 2017 - PRESENT

管理Microsoft SQL Server 2012/2014数据库

Microsoft

MAY 2013 - PRESENT

Intro to Parallel Programming

Udacity

NOVEMBER 2012 - PRESENT

Advanced Software as a Service

edX | BerkeleyX

SEPTEMBER 2012 - PRESENT

Software as a Service

edX | BerkeleyX

Collaboration That Works

How to Work with Toptal

在数小时内，而不是数周或数月，我们的网络将为您直接匹配全球行业专家.

1

Share your needs

在与Toptal领域专家的电话中讨论您的需求并细化您的范围.
2

Choose your talent

在24小时内获得专业匹配人才的简短列表，以进行审查，面试和选择.
3

Start your risk-free talent trial

与你选择的人才一起工作，试用最多两周. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring