Jesse Roberge

Jesse Roberge Email and Phone Number

SQL Server Database Developer at First Advantage @ First Advantage Tax Consulting Services
Jesse Roberge's Location
Mesa, Arizona, United States, United States
Jesse Roberge's Contact Details
About Jesse Roberge

**Thirteen Years of experience in developing database intensive web applications.**Extensive experience in overhauling improperly designed database schemas including improperly merged entities, improper references between entities, references on the many-side entity failing to reference the full unique key of the one-side entity, and first & second normal form violations.**Expertise in writing code for performance and diagnosing, isolating, and correcting performance bottlenecks utilizing profiler traces, dynamic management views, and application code analysis.**Experience with ETL processes for importing vendor data for e-commerce productss, assimilating bulk job postings, SHRM member loads and re-loads, andintegratingg corporate acquisitions' entire databases.**Bring structure and performance to a programming environment (classic ASP) which normally is lacking, by utilizing my insights and the wisdom of more experienced developers on the team.**Experience in integrating custom business logic structure in ASP.net by extending the page class utilizing inheritance and abstract classes.**Search-heavy web applications that can handle well over a hundred thousand page views per day on each server and databases that handle over 1500 simultaneously logged in application users.**Very good out-of-the-box analytical problem-solver.Core areas of expertise:*Hardcore set-based T-SQL Dev*Database Performance Tuning*Schema Design & NormalizationSpecialties:**SQL Server Database Development**Hardcore T-SQL queries with nested derived tables and complex aggregates.**SQL Server Database Performance Tuning**Database Design & Normalization**Guiding a CEO's brain-stormy thought ramblings and turning them into a ERD**Database Administration**Automating database maintenance, backups, and some policy enforcement.**Application Performance Tuning**Data- or Number-crunchy Middle-Tier Development

Jesse Roberge's Current Company Details
First Advantage Tax Consulting Services

First Advantage Tax Consulting Services

View
SQL Server Database Developer at First Advantage
Jesse Roberge Work Experience Details
  • First Advantage Tax Consulting Services
    Sql Server Database Developer
    First Advantage Tax Consulting Services Jul 2009 - Present
    Atlanta, Ga, Us
    **Solved numerous major concurrency / blocking issues of which most were caused by sub-optimal indexing.**Utilized DMVs to detect worst offending queries without the need to use profiler traces, made possible by the 95+% stored procedure usage environment.**Took over the Aviion data integration project from another developer, bringing the project to completion and starting production migrations.**Solved defects caused by database design problems with the bulk email system and the DocGrid.**Took over the DocGrid project from a departing veteran developer as the primary back-end developer.**Implemented major enhancements and additions to existing systems requiring widespread changes to existing code.**Implemented status codes and fully integrated them into the mesh of existing systems.**Consolidated legacy forms system into the new and enhanced supporting documents / DocGrid system.**Skills used: 80% T-SQL, 15% SSIS, 5% C#.net + VB6; 90% SQL Server 2005, 5% SQL Server 2008, 5% SQL Server 2000; Windows 7, Windows Server 2003
    View
  • Medical Data Express
    Sr. Sql Developer, .Net Developer And Ssis Developer
    Medical Data Express Mar 2009 - May 2009
    **Solved two critical performance issues in aggregate T-SQL queries that caused the data load for EncounterPro and Pend Analyzer to monopolize the CPU on the SQL Server for many hours.**Analyzed profiler traces and SQL Server 2005 DMV data for worst offending queries. Optimize the database and application performance of the EncounterPro addressing poorly written queries and missing and poorly designed indexes.**Helped adapt the data load SSIS packages from one client that uses Oracle for use in a new client that uses Sybase. The SSIS packages utilize variables, expressions, loops, and scripts.**Wrote a NCPDP parser with data-driven schema mapping in VB.Net that has somewhat flexible schema-mapping.**Wrote an EDI parser with data-driven EDI implementation guides that converts EDI files to an identical relational schema in VB.Net. Later T-SQL would convert and aggregate the EDI response data to a star schema for reporting.**Skills used: 65% VB.Net with ADO.net and SQLBulkCopy, 15% SSIS, 10% C#.Net for libraries + SQLCLR, 10% T-SQL; 90% SQL Server 2005, 10% SQL Server 2008; Windows Vista, Windows Server 2003
  • Integreat Concepts
    Senior Sql Server 2000 / 2005 Database Developer, T-Sql Guru, And Database Performance Analyst
    Integreat Concepts Sep 2007 - Feb 2009
    Us
    **Optimized the database and application performance of the IC-Chart electronic health records system addressing poorly written queries, missing or poorly designed indexes, and excessive ADO web-DB round-trips.**Analyzed profiler traces and SQL Server 2005 DMV data for worst offending queries. Optimize the database and application performance of the IC-Chart electronic health records system addressing poorly written queries, missing or poorly designed indexes, and excessive ADO web-DB round-trips.**Wrote complex data scrubbers, particularly on the isapisal table (audit log for HIPAA and CCHIT stuff).**Wrote automated backup and highly configurable index / statistics maintenance stored procedures for both the DEV and client production sites.**Built application customizations for Carle Clinic, Integreat's largest client, with over 1500 doctors over a hospital and dozens of multi-doctor clinics with over 1500 simultaneously logged-in users on their EMR system.**Responsible for the backups for the development and QA servers.**Performed SQL code reviews to prevent poorly written SQL code and queries from reaching production.**Skills used: 75% T-SQL, 20% Classic ASP / VBScript + ADO, 2% C# for CLI, 2% C# for SQLCLR, 1% SSIS; 80% SQL Server 2005, 20% SQL Server 2000; Windows XP, Windows Server 2003
    View
  • Jobing.Com
    Classic Asp Web Developer And Sql Server 2000 / 2005 Database Developer + Administrator + Architect
    Jobing.Com Feb 2001 - Jun 2007
    Scottsdale, Az, Us
    **Refined and expanded the relational database schema design for the job board site.**Optimized queries, refine application code, and tweak indexes to enhance the performance of the job board site.**Designed and coded ASP applications for the new features of the job and resume search engine & agents, mapping, area/category hierarchy system, and many other areas of the job board site.**Coded C# .net applications for automation tasks such as search agents, e-mail notifications, etc..**Performed most of the development DBA duties and some of the production DBA duties including backups, permissions, and performance diagnostics and tuning.**Wrote data import / ETL processes to import and convert SQL Server, CSV flat-file, and MySQL data from bulk job posters and corporate acquisitions.**Designed and implemented the normalized OLTP and dimensional star schema OLAP schema design, T-SQL stored procedures, and classic ASP code for an extensive site traffic and event tracking system and its reports.**Skills used: 40% T-SQL, 40% Classic ASP / VBScript + ADO, 10% C# for CLI & WinForms + ADO.net, 3% ASP.net / C# + ADO.net, 3% JavaScript, 2% DTS, 2% HTML + DHTML + CSS; 80% SQL Server 2000, 20% SQL Server 2005; Windows XP, Windows 2000
    View
  • Allegro Enterprises, Inc
    Classic Asp Web Developer And Sql Server 7.0 Database Developer + Administrator + Architect
    Allegro Enterprises, Inc Oct 1999 - Feb 2001
    Mesa, Az, Us
    **Designed, implemented, maintained, and upgraded the relational database schema and infrastructure for the e-commerce site.**Developed stored procedures for the e-commerce site's bulk interactions with the database.**Coded ASP for the shopping cart, universal promotions, customer login, affiliate tracking, traffic tracking, and many other features of the e-commerce site.**Wrote data import / ETL processes to import and convert flat file CSV data from product vendors.**Administered the SQL Server database backups and security on the database on the production server at DataReturn and the internal development server.**Skills used: 60% Classic ASP / VBScript + ADO, 35% T-SQL, 3% JavaScript, 2% HTML; 95% SQL Server 7.0, 5% MS Access '97; Windows NT
    View

Jesse Roberge Skills

Database Administration Microsoft Sql Server Performance Tuning Sql Tuning T Sql Database Design Asp Ssrs Ssis Data Warehousing Etl Data Modeling Business Intelligence Analysis Services Vb.net Asp.net Databases C# Sql Clr Visual Basic Sql Windows Server Javascript Relational Databases Ado.net Dts Web Applications Stored Procedures Visual Studio Access Mysql Tfs Vbscript Olap Data Migration .net Sdlc Css Data Integration Html Iis

Jesse Roberge Education Details

  • Suny Polytechnic Institute
    Suny Polytechnic Institute
    Computer Science
  • Orange County Community College
    Orange County Community College
    Computer Information Systems

Frequently Asked Questions about Jesse Roberge

What company does Jesse Roberge work for?

Jesse Roberge works for First Advantage Tax Consulting Services

What is Jesse Roberge's role at the current company?

Jesse Roberge's current role is SQL Server Database Developer at First Advantage.

What is Jesse Roberge's email address?

Jesse Roberge's email address is ye****@****ail.com

What is Jesse Roberge's direct phone number?

Jesse Roberge's direct phone number is +160228*****

What schools did Jesse Roberge attend?

Jesse Roberge attended Suny Polytechnic Institute, Orange County Community College.

What are some of Jesse Roberge's interests?

Jesse Roberge has interest in Medicine, Electronics, Exercise, Home Improvement, Reading, Fitness, Travel, Home Decoration, Health.

What skills is Jesse Roberge known for?

Jesse Roberge has skills like Database Administration, Microsoft Sql Server, Performance Tuning, Sql Tuning, T Sql, Database Design, Asp, Ssrs, Ssis, Data Warehousing, Etl, Data Modeling.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.