Geraldo Diaz

Lead Data Engineer at ERC (Enhanced Resource Centers)
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Santo Domingo, Dominican Republic, DO
Languages
  • Español Native or bilingual proficiency
  • Ingles Professional working proficiency

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
Join now
You need to have a working account to view this content.
Join now

Credentials

  • Exam 762: Developing SQL Databases
    Microsoft
    Dec, 2020
    - Nov, 2024
  • MCSA: SQL 2016 Database Development - Certified 2020
    Microsoft
    Dec, 2020
    - Nov, 2024
  • Exam 761: Querying Data with Transact-SQL
    Microsoft
    Oct, 2018
    - Nov, 2024
  • Exam 461: Querying Microsoft SQL Server 2012/2014
    Microsoft
    Mar, 2014
    - Nov, 2024
  • MCPS: Microsoft Certified Professional
    Microsoft
    Mar, 2014
    - Nov, 2024

Experience

  • ERC (Enhanced Resource Centers)
    • United States
    • Outsourcing and Offshoring Consulting
    • 100 - 200 Employee
    • Lead Data Engineer
      • Jan 2017 - Present

      -Design, Build and managing the ETL processes by leveraging T-SQL and SSIS to deliver information effectively to and from data structures while following the SDLC process.-Migration of SSIS packages from file system to SSIS Catalog. Splitting clients process by projects.-Build, Integrate customer ETL to NeuAnalytics solutions.-Create/Maintain SQL objects Procedures/Functions/Triggers/Views.-Generate and maintain queries and stored procedures using Transaction SQL.-Develop, test, and maintain the code required to process data.-Participate within an Agile (Scrum) development team.-Contribute to technical design discussions and hands-on solution implementations.-Work with other developers with a constructive, results-oriented approach.-Update SQL objects in Source control.-Create SSIS packages for data integration of new client interfaces to our Legacy system.-Create SSRS Reports.-Manage work assignments to SQL developers.-KPI development to measure developer performance.-Creation of monthly reports of SQL tickets worked and bugs resolved.

    • SQL Developer
      • Mar 2016 - Jan 2017

      -Jira, TFS, GIT, OSTicket, Scrum, TSQL, MySQL, C#, CLR-Customization and implementation of ticketing system OSticket (Open Source). -Development of data layer in important projects. -Optimization, creation and maintenance of database objects including procedures, views, functions. -Developing SSIS packages for data transfer between us and important American clients. -Troubleshoot existing data issues and recommend data management strategies.-Designs, develops, and enforces new EDI procedures and the changes to fresh and active EDI clients.-Design and document data processes.-SSIS package Developer.-Troubleshoot, Developing and optimizing Store procedures and views. -Developing reports in SQL Server Reporting Services (SSRS)

  • BluebirdTek
    • ETL Developer
      • Jul 2020 - Sep 2021

      * Create and maintain ETL process built on Talend Data Service Platform.* PL/SQL Oracle, MYSQL* Ethos Integrations* RabbitMQ Message BrokerDuring this time I participated in the following projects:• Project: Automate Covid test process (Feb 2021 – April 2021)Build a data pipeline to process covid test results files into legacy system.Main tasks executed in the project:  Create new data pipeline based on mapping provided to process covid results into legacy system. Build rule engine validations based on date range to identify covid test #. This process replaced a manual data ingestion which was prompt to error and time consuming for end users. Technologies: PL-SQL, Talend data service, SQL Server • Project: Data pipeline maintenance (Sept - 2020 – Sept 2021)Maintenance to existing data pipeline built on Talend Data service per client request.Main tasks executed in the project:  Update existing data pipeline built on Talend data service. Performance tuning existing Stored procedures on PLSQL and SQL Server. Create complex queries on MYSQL. Troubleshooting and fixing production issues.Gives support to production environment, troubleshooting and maintain ETL updated to meet business request. Technologies: MySQL, PLSQL, SQL Server, Talend data service, RabbitMQ, Ethos.

  • StateTrust Life and Annuities
    • United States
    • Insurance
    • 1 - 100 Employee
    • Software Developer
      • Jul 2015 - Mar 2016

      During this time I participated in the following projects:• Project: Medicine Insurance customer notifications (Jan 2016– March 2016)Integration of “Thunderhead journey orchestration” into SQL Server to trigger notifications to the customers through SMS/Email for send templates to welcome new users, new Insurance policy, Claims, and so on.Main tasks executed in the project:  Data modeled structure needed per requirements. Create procedure to handle logic for fields needed on each template. Implement asynchronous triggers using SQL Service brokers. Consume Thunderhead API using SQL CLR through SQL Triggers.During this project we had a lot of pressure, since we had a tight SLA. We worked near to 12 hours per days for 3 weeks back-to-back. Technologies: C#, TSQL, SQLCLR, web API.• Project: Atlantica Client site (July 2015– December 2015)Help to create business line client site for Atlantic vehicle Insurance.Main tasks executed in the project:  Data modeled structure needed per requirements. Create procedures to handle CRUD. Helps to create REST API to consume procedures for CRUD. Create views and models on ASP MVC for client site.I helped working on models and views on ASP MVC, and create all the SQL components (Tables, views, procedures). Technologies: C#, ASP, MVC, TSQL.

  • Hunter Peru
    • Peru
    • Security and Investigations
    • 100 - 200 Employee
    • DBA
      • Oct 2014 - May 2015

      -Maintenance of indexes.-Improvement of Stored procedures and tables structures.-Development CLR Stored Procedures.-Defining the storage structure and access methods.-Modifying the scheme and/or physical organization when necessary.-Granting authorization for data access.*Achievements*-Development and implementation of Recovery strategy of databases.-Development and implementation of Backup plan.-Design and development of Sales Data Warehouse.-Design and development SSAS Cube for Sales and ETLs for load the data.

    • Software Developer
      • Apr 2012 - Oct 2014

      *Application Developer (C#, WinForm Aplication, Console Applications, Windows Services)*Debug, and integrate modifications on Production.*Planning and monitoring development projects.*Application Migration.*Planning and Development Data Warehouse.*Designing and development Packages in Business Intelligence Development (SSIS).*Cube Development with SSAS Multidimensional Models.*Reports development with Reporting Services (SSRS).*Achievements*-Development and migration of Inventory system in WinForm(C#).-Migration of sales system.-Development of Human resources notification system using API of finger print device. (Notify when an employee was late and how many hour worked during the week)

Education

  • Universidad Tecnológica de Santiago
    Engeneer, Software Engineering
    2008 - 2012
  • Universidad Dominico Americana
    Diploma in Formulation, planning and evaluation of Projects.
    2015 - 2015
  • Universidad APEC
    Diploma in Development and Implementation of Business Intelligence
    2013 - 2013
  • Instituto Tecnológico de Santo Domingo
    Diploma in Application Development in .NET
    2012 - 2012

Community

You need to have a working account to view this content. Click here to join now