Joshy Gallant🧋 Email & Phone Number

• Strategized update of dbt SQL data transform for Data Mart for SEM marketing team which actionable insight increased SEM spend profit by $10k+/week.
• Implemented CI/CD for improved SQL data modeling using GitHub for version control with a peer review process, including moving persistent derived tables, and hard-coded LookML logic to dbt SQL data transforms which.
• Managed end-to-end migration from Google AdWords to Google Ads from AWS S3 buckets through Fivetran to Snowflake, transformed in dbt SQL data transforms to a Data Mart accessed through Looker.
• Streamlined communication, and deliverables through refinement sessions, office hours, working sessions, and directing project and production support requests through limited channels.
• Implemented documentation of data, and definitions including identification of cross-functional KPIs.

Charlotte Metro

Charlotte, North Carolina Area

• BI Architect for Pro Builder’s 2020 Builder of the Year & Largest Personal Home Builder in the Carolinas.
• Improved SQL stored procedures, SQL views, and SQL user-defined functions (UDFs) by using SQL query optimization, and SQL performance tuning for SSIS ETL packages used for SSRS/Power BI reports for C-suite executive.
• Implemented best practices, including ANSI standard SQL code, created standards for readable SQL code, eliminated deprecated SQL features, implemented UAT process, and set up a roadmap for improved policies and.
• Improved team culture and morale by exemplifying synergistic characteristics.

Miami/Fort Lauderdale Area

• Implemented the integration of new student financial system SQL data, and existing student CRM system SQL data to automate, and track all student communications, file, and account status changes.
• Managed projects and the training for other senior level team members including producing troubleshooting guides for the migration of SSIS ETL packages and SQL stored procedures from SQL Server 2008 to SQL Server 2012.
• Improved SQL query optimization and performance tuning of SQL stored procedures, SQL views, SQL indexes, and SQL UDFs for improved application and reporting processes.
• Production support for application errors, SSIS ETL SQL integration errors, and SQL data cleaning.

Palm Beach Gardens, FL

• Managed the day-to-day operations of the previous data team the for REO project for Ditech as the sole SQL data resource on a skeleton crew working on a contract in the interim before offshore resources took over.
• Streamlined processes and procedures for offshore resources by improving existing manual tasks of the previous data team by implementing SSIS ETL integrations, creation of scheduled BI reporting, and documentation of.
• Managed the training of offshore resources starting with basic SQL training, and providing very detailed, step-by-step production support documentation.

North Palm Beach, FL

• Improved HL7 integration, implementing changes for in-house policies, and state and federal laws.
• Made significant changes to application forms for ease of use, fixing application errors, and updated SQL stored procedures, SQL views, indexes, and SQL UDFs for faster processing.
• Improved reports by completing extensive analysis and design based on working sessions.
• Managed project from data discovery of over $1 Million in un-submitted charges, including training staff on the process for insurance submittal within an application.

Anchorage, Alaska

• Implemented front-end and SQL updates for Meaningful Use Stages 1 and 2, as well as requirements for the Commission on Accreditation of Rehabilitation Facilities through rapidly changing priorities and requirements.
• Improved SQL stored procedures, SQL views, SQL UDFs, and front-end code for ease of use, and performance of applications, and SSIS ETL integrations for internal cross-functional, state, and federal reporting.

Anchorage, Alaska Area

• Implemented working sessions with cross-functional teams to perform a full analysis and design, and the eventual creation of training for departmental and agency-wide SQL reporting.
• Strategized the improvement of KPIs by clarifying, and simplifying agency definitions, and creating documentation of how KPIs are recorded, tracked, and reported.
• Streamlined required state, federal, and internal quarterly SQL reporting system by implementing new standards, and creating and documenting a system that increased ease of use, and speed of delivery.

Halifax, Canada Area

• Implemented automation of database tasks for TUFTS Health Plan in a UNIX environment on an HP3000 database system using IMAGE/SQL.
• Generated BI reporting for cross-functional teams.
• Production support for data cleaning

Post-Graduate Diploma, Business Information System Development, 88%

BISD-5200 0910 Structured Programming Concepts BISD-5300 0910 Java Programming, Part 1 BISD-5350 1130 Java Programming, Part 2 BISD-5400.

Bachelor'S Degree