We provide IT Staff Augmentation Services!

Senior Etl Developer Resume

Folsom, CA

SUMMARY

  • Experienced software, database & ETL developer who understands SDLC and performs well with or without a team and with little to no supervision. Self motivated and able to work under high stress and with changing priorities.

TECHNICAL SKILLS

  • C#.NET, VB.NET, SQL Server, Oracle, MySQL, SQLite
  • ETL, ASP.NET, Azure, Power BI, JavaScript, XML
  • MVC, Bootstrap, Razor, Telerik, Web Services, HTML
  • CSS, Jquery, PeopleSoft, SSIS, SSRS, Agile, TFS, Git, HIPAA, 508.

PROFESSIONAL EXPERIENCE

Confidential - Folsom, CA

Senior ETL Developer

Responsibilities:

  • On contract with the California EDD BSM (Benefits System Modernization) team, participated in all aspects of the ETL project, working with UI, DI and Paid Family Leave systems.
  • Developed multiple, complex SSIS packages for the extraction of data from mainframe systems as well as SQL Server. These packages then loaded this data into target SQL Servers for further analysis and transformation.
  • Created many SQL Scripts used for generating faulty data counts and for translating data as needed.
  • Created C# application that served as an interface to many processes, providing simple ways to upload files for processing, start and monitor SQL jobs, SSIS packages, and Stored Procedures, and download resulting reports.

Confidential - Folsom, CA

SQL Developer

Responsibilities:

  • Developed SQL Server objects and updated C# programs to assist mortgage businesses with data sharing.
  • Worked with many Microsoft Azure applications including Data Factory, Azure SQL, Logic Apps, etc.
  • Split large Json files into separate, smaller tables, and then built views using JSON VALUE to get raw data.
  • Created “Master” report SQL view and Power BI reports to analyze mortgage trends.
  • Worked directly with clients to determine data mapping and conversion.

Confidential - Folsom, CA

ETL Developer

Responsibilities:

  • Developed SQL scripts to extract, translate and load Oracle data into MySQL database.
  • Executed these scripts while documenting row counts, errors, and stage table results.
  • Designed a REGEX REPLACE algorithm that removed all RTF encoding from notes/narratives.
  • Created scripts that extracted individual address fields from free-form addresses and cross-streets.
  • Assisted in the maintenance of a field-level data dictionary and ETL checklists.

Confidential - Sacramento, CA

ETL/Software Developer

Responsibilities:

  • Performed ETL table/field mapping. Created tables to contain this mapping along with most transformations and custom JOIN statements.
  • Created an ETL tool to extract data from legacy Oracle and SQL databases, translate the data, and load into a new SQL Server database.
  • Created databases, tables, fields, indexes, stored procedures and functions in SQL Server.
  • Tested SQL Server upgrades from many previous versions to SQL Server 2017 and performed data validation.

Confidential

Software Developer

Responsibilities:

  • Enhanced and supported an internal web-based product using C#, CSHTML, JavaScript, MVC, Razor, Bootstrap/CSS, HTML, AJAX and Json. Used AJAX calls to send webpage data to routines.
  • Created several Administrative pages to allow web-based access to configuration-related data.
  • Creating stored procedures, views and SSRS reports in SQL Server.
  • Technical lead in monthly software and data updates.

Hire Now