Resume

Sign in

Sr SQL ETL Developer

Location:
Torrance, CA
Posted:
March 13, 2020

Contact this candidate

Resume:

Jean Gomont

Torrance, CA *****

646-***-****

adb911@r.postjobfree.com

Sr. SQL Database Engineer (SQL /BI/ ETL)

Overview

•More than 10 years of experience in designing, testing and implementing application software for large and complex database systems.

•More than 8 Years of Experience in ETLs, Data warehousing (DTS, SSIS) for SQL Server Business Intelligence framework (SSIS)

•Experience Troubleshooting SSRS Reports and Data Sources.

•Involved in all areas of Software Development Life Cycle (SDLC) including Requirements Gathering, Architecture, design drafts and proposals, and ongoing staff meetings, testing, implementation, and deployment.

•Created Ad hoc queries, ETL processes and conducted system troubleshooting, and overall system optimization.

•Designed, developed, and managed SSIS packages to extract, transform, and load data coming from multiple data sources.

Technical Skills

•Application Software: Microsoft Visual Studio, SSIS, BIDS, SQL Server Management Studio, SSRS, SQL Profiler, SQL Server Agent, Informatica (Basic Knowledge)

•SQL Scripting (RDBMS): SQL Server 2005/2008/2008 R2//2014/2016

•Operating Systems: Windows 2000/2003/XP/Vista/7/8/8.1/10

•Languages: T-SQL, Knowledge of C#, Microsoft SQL Server

•Version Control Tools: Microsoft Visual SourceSafe, Team Foundation Server (TFS)

•Customer Relationship Management Tools: Sales force, SharePoint, Service Now

Professional Experience

OPTUM, El Segundo, CA December 2017 – Present

Senior Business Intelligence ETL Developer

Responsibilities:

•Creating ETL processes using SSIS (SQL Server Integration Services)

•Processed mostly Claims, Eligibility, Labs, Physicians, Pharmacy related files from ACO (Accountable Care Organization) clients like CIGNA, ANTHEM, UHC, CMS…

•Wrote ad-hoc queries as well as functions, and stored procedures to provide data outputs and reports based on clients or users’ requests

•Created deployment instructions documents and code review templates and collaborated on a weekly basis with QA and the DBA Team to deploy projects to QA and production.

•Created logging tables and triggers to track ETL and SQL job processes successes and errors as well as notifying end users upon completion.

•Worked heavily on cleaning data anomalies ranging from duplicates, optimization, archives, metrics conversion, mappings, and more.

•Took ownership of improving and correcting over ten years of historical data for the lab processes which supported our national data warehouse.

•Provided Analysis for all issues encountered with the labs data by re-organizing tables structures, ETL and code improvement, new business logic implementation, optimization, drafting business requirements and unit testing.

•Participated in weekly to monthly meetings between team members and clients to set up objectives for weekly to bi-weekly deliverables

•Worked with TFS as the main source control tool for all SQL and SSIS related codes.

SCAN HEALTH, Long Beach, CA June 2017 – October 2017

Senior Database Engineer

Responsibilities:

•Creating and Troubleshooting ETL using SSIS (SQL Server Integration Services) through Visual Studio 2012 for Medicare Claims, Labs, Encounters, and Pharmacy data.

•Wrote stored procedures to send mail notifications for Pharmacy files delivered to the clients and business users on a weekly basis.

•Wrote numerous queries, functions, stored procedures, to parse combination of various codes (ICD9, ICD10, Lab, Encounter, etc…) with their respective identifiers and produced outputs for the reporting team.

•Worked with DBAs and the management team to coordinate deployment with documentation and codes to promote processes to production as well as synchronizing all tests, staging, UAT, and production environment.

•Created customized log tables and triggers to track ETL processes errors and SQL job failures to then send notification to the required teams, users, developers, as well as the DBAs.

•Responsible for creating standard guidelines and steps to follow to get proper code development documents, codes, files, and processes ready to facilitate the deployment process which resulted time consuming efforts and the amount code failures in production.

•Engaged in weekly code between peers to discuss impact and issues with mainly SQL based codes such as Views, functions, stored procedures, tables, Indexes, triggers, and more ad-hoc queries.

ZIRMED, Culver City, CA July 2015 – May 2017

Database Engineer

Responsibilities:

•Creating, managing, and supporting various ETL for claims data Integrations.

•Applied ETLs with SSIS to load files (flat file .txt, excel, csv) for claims, pharmacy, lab, diagnosis, disease registries, physician rosters, and members’ enrollment data to the warehouse.

•Worked on aggregating and calculating revenues and payment clients

•Working on C# alongside SSIS to create file transfer processes across the development server platforms and servers.

•Creating Logging and auditing resources for our periodical and ad hoc processes for ETLs using SSIS and stored procedures to skip error prone processes during our multi-client automated run.

•Actively involved in creating and managing daily mail notifications using SQL Server Agent jobs and database mail engine to provide ad hoc reports, insights, status, loggings, and occurring errors. The notifications are used to update the clients and the development team on major processes running periodically.

•Creating store procedures, functions, and tables to accommodate new projects and data for new clients as well as providing code reviews and optimization for improving database usage and processes.

•Troubleshooting and deploying various existing SSRS reports on the report server. Task involves using SQL server profiler to trace reports execution and configuration throughout the server.

Healthcare Partners, Torrance, CA December 2014 – June 2015

ETL Developer

Responsibilities:

• Participated in the integration of client’s healthcare data for different processes such as medical claims, enrollment, eligibility, pharmacy labs, and orders.

• Applied ETLs with SSIS (SQL Server Integration Services) through BIDS 2008 based packages to load client files containing patients’ claims adjustments and integrating the data into the data warehouse.

• Extracted and processed files coming from FTP in CSV formats, as well as data sources coming from the OLTP database to the data warehouse target tables.

• Provided logical procedures and query to identify data anomalies

• Actively engaged in meetings with co-workers for gathering information on the full scope of the project, not just the claims’ process.

• Created and designed the structure for new tables to accommodate new incoming clients’ data.

• Created mappings as well as ETL implementation documentations to facilitate application sharing throughout the whole data warehouse team.

• Established configurations, custom SSIS auditing, email alerts through SSIS Event Handlers.

Provant Health, East Greenwich, RI March 2014 – September 2014

SQL Programmer / Analyst

Responsibilities:

•Worked on coding for stored procedures, functions, and triggers, views, indexes, temporary tables, SSIS packages, C# programs to be used for daily and weekly clients’ processes

•Applied ETLs with SSIS 2012 (SQL Server Integration Services 2012) based packages to load client eligibility files containing customers and employees profile information as well screenings and biometrics.

•Overall ETL process included extracting from flat, CSV, excel as well as data sources coming from the OLTP database.

•Set up queries and algorithm logics to calculate and report appropriate incentives for participants in activities set by the client company protocols for their employees.

•Worked on pulling large volume of data from various clients’ feeds or sources mainly, excel, CSV, text delimited files using various tasks such data flow task, execute SQL task, Script Task, loop containers, Execute Process Task, File System task, and more, but also applied matching logics for incremental load.

•Actively engaged in meetings with the business consultants for requirement gathering.

•Provided assistance with data tuning, optimization, indexes, quality assurance.

Sallie Mae, Fishers, IN March 2013 – March 2014

SQL Server Developer/Data Analyst

Responsibilities:

•Created several tables, views, indexes, functions, triggers, stored procedures, CTEs, temporary tables, result set based upon the functional or business specifications.

•Utilized SSIS (SQL Server Integration Services) to manage Extraction, Transformation and Loading (ETL) process to pull large volume of data from various clients’ feeds or sources.

•Set up various package configurations for package sharing between Teams involved the Development (DEV), Quality Assurance (QA), and Production environment).

•Responsible for creating common module to process all clients’ files into one shared ETL as opposed the previous module which processed clients’ files and ETLs one at a time.

•Provided analysis to establish business and technical plans to troubleshoot system issues.

Education

John College of Criminal Justice, New York, NY

Bachelor’s Degree of Science in Computer Information Systems

TCI College of Technology

Associates Degree of Applied Science in Digital Media Arts



Contact this candidate