Scroll To View More
Hire the top 3% of freelance developers
Giovani Santiago

Giovani Santiago

Las Vegas, NV, United States
Member since October 4, 2014
Giovani is an experienced data professional with extensive expertise in data systems such as SQL Server, PostgreSQL, MySQL, and DB2. He is also very familiar with the Microsoft BI stack including SSRS, SSIS, SSAS, Power BI, Azure DW, and Azure DB. He also has AWS experience including RDS, Aurora, DynamoDB, S3, EC2, CloudFormation, Lambda Functions, Step Functions, and VPC set up. He communicates very well and has worked in teams of all sizes.
Giovani is now available for hire
Portfolio
Experience
  • SQL, 6 years
  • SQL Management Studio, 6 years
  • Python, 5 years
  • PostgreSQL, 5 years
  • AWS EC2, 2 years
  • AWS Step Functions, 1 year
  • AWS Lambda, 1 year
  • AWS Database Migration Service, 1 year
Las Vegas, NV, United States
Availability
Part-time
Preferred Environment
Visual Studio, SQL Server Management Studio
The most amazing...
...thing I've coded is a script that saved a company team hundreds of hours of work.
Employment
  • Data Operations Engineer
    2017 - PRESENT
    Planview Inc
    • Migrated dozens of database servers from Oracle running on VMs to Amazon Aurora PostgreSQL.
    • Created Step Functions and Lambda Functions to perform database backup tasks.
    • Utilize Python with Lambda Functions to perform various AWS tasks via the Boto3 library.
    • Create and monitor RDS instances.
    • Implemented a region wide disaster recovery strategy that copies RDS data over to the DR region.
    Technologies: AWS, RDS, Amazon Aurora, Lambda Functions, Step Functions, PostgreSQL, SQL Server, Oracle, Python
  • Enterprise Data Architect
    2015 - 2017
    Boyd Gaming
    • Built an Azure SQL and Power BI POC that was successful. On-prem data would be refreshed nightly into an Azure SQL database, and users could analyze the data via Power BI. The work was widely praised.
    • Built pipelines in Azure Data Factory with the data management gateway to transfer on-prem transactional flat files from into Azure storage. Polybase was used to read the transferred data from Azure blob storage into Azure SQL data warehouse tables.
    • Successfully built an ETL solution to have a new visualization tool consume data from properties running different systems under one data schema.
    Technologies: ETL, SSIS, SSRS, Data Pipelines, Azure DW, Azure DB, SQL Server
  • SSRS, PHP, and MySQL Developer
    2013 - 2014
    R5 Ensino Professional
    • Optimized tools used to put together the company product (teaching software). Discovered and implemented better components.
    • Created an output file for an already existing mouse macro program that automated the image upload process.
    • Created a PHP script to manipulate a Delphi file to extract and save a new file with the component position, a process that would have taken several months by hand.
    • Maintained a client panel with PHP, JavaScript, and MySQL.
    • Created internal reports utilizing SSRS and JavaScript chart libraries.
    Technologies: Delphi, MS SQL, MySQL, SSRS, SSIS
  • Data Warehouse Analyst
    2011 - 2013
    Western Funding, Inc.
    • Created a portal for branch managers to help rank clients at the click of a button, an improvement over the hour-long process that was previously required.
    • Created a reporting book used at every shareholder meeting to show gains/losses across all departments.
    • Supported an ETL process taking data from a 32-bit server into a 64-bit server.
    Technologies: Microsoft SQL Server
Skills
  • Languages
    SQL, Python
  • Tools
    SQL Management Studio, Tableau, AWS Key Management Service (KMS), AWS CLI, Boto 3, AWS Step Functions, AWS IAM, AWS VPC, AWS Push Notification Service (AWS SNS), AWS CloudFormation, Visual Studio
  • Platforms
    Oracle, AWS Lambda, AWS EC2, Amazon Web Services (AWS), Azure
  • Storage
    SQL Server 2012, SQL Server 2014, AWS DynamoDB, PostgreSQL, AWS Aurora, AWS RDS, AWS S3, Microsoft SQL Server, SQL Server 2008 R2, SQL Server 2016
  • Other
    AWS Database Migration Service, AWS Polly
  • Libraries/APIs
    jQuery
Hire the top 3% of freelance developers
I really like this profile
Share it with others