Sr. Data Engineer Resume

PROFESSIONAL EXPERIENCE

Sr. Data Engineer

Confidential

Technology Used: MS SQL, DB Visualizer, Ruby on Rails for dashboard design, MS SSMS/SSIS/Visual Studio

Responsibilities:

Extracted data from multiple source systems (BIDS - Business Intelligence Development Studio, MySQL, Oracle, Vertica) using SQL Server and DB Visualizer to create and execute complex SQL to provide data used to build reporting dashboards.
Assisted team members to troubleshoot SQL queries and stored procedures to provide suggestions on how to update queries.
Created SSMS/SSIS packages to transform, execute sql commands and event tags used to extract, load data across multiple platforms and identify errors in processing.
Evaluated and modified YAML source code to execute Ruby on Rails application to update dashboards for end user testing and production implementation.
Worked in Agile and Kanban team environment.

Sr. Data Engineer

Confidential

Technology Used: ETL - ODI - Oracle Data Interface, WS FTP - File Transfer Protocol, ECG Cockpit & ECG Gateway for secure data transfers, editing tools: Ultra Editor & Notepad ++, OEM - Oracle Enterprise Manager, LINUX Shell Scripting, PL/SQL,RDBMS

Responsibilities:

Gather requirements, designs, constructs and delivers solutions with minimal team interaction.
Flexible and experienced working as Individual Contributor and as member of a Team.
Provide SQL programming support to ensure the continuous reliability, integrity and improvement of relational databases throughout our organization. This includes, but is not limited to determining database requirements, designing data structures, developing stored procedures and ETL processes.
Participate in hands-on business application design, development, testing and deployment activities.
Interpret design requirements and concepts to produce new or enhanced application functionalities.
Deliver demos and technical documentation.
Lead, developed and deployed new data warehouse products using development technologies to produce daily response file recommendations on how the client should administer payment or denial of claims based on analytics applied during processing.
Interviewed, lead and consulted junior level developer during design and production support while working with Agile and Waterfall environment...
Established relationships with Client, internal business analysts and key developers to deep dive into the data helping develop the business requirements into technical specifications for initial deployments and daily production cycles.
Created ODI and Oracle SQL (ETL) processes to intake data files, loaded to target tables, wrote and enhanced complex SQL, Stored Procedures, Packages, Functions and Triggers to produce response files sent back to the Client for their Claim payment processing to administer how to pay or why to deny a claim or claims on a daily basis.
Collaborated with other internal teams to test enhanced SQL, troubleshoot issues and deployed final SQL into production environment.
Performed troubleshooting techniques on complex SQL, Stored Procedures, Packages, Functions and Triggers to do analysis on production data issues, determine needed performance tuning on existing queries and develop new approaches to support new design concepts.
Wrote and maintained simple to complex UNIX operating s this remote scripts to stage data for test and scrub/load data for production.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship