LiveCareer-Resume

sr etl developer resume example with 7+ years of experience

JC J S S JS J S S JS J S S JS J S S JS J S S JS J S S JS
Jessica Claire
, , 100 Montgomery St. 10th Floor (555) 432-1000, resumesample@example.com
Professional Summary

Effective at supporting team needs with high-quality code, subject matter expertise and collaboration skills. Skilled programmer and complex problem-solver experienced in data analytics and report writing.

Skills
  • Databases Tools
  • SQL Server Management Studio, SQL Server Data Tools, SQL Profiler, Business Intelligence Development Studio, T-SQL, PL/SQL, OLAP, OLTP
  • ETL Tools
  • SQL Server Integration Service (SSIS), Visual Studio 2015/2017/2019
  • Reporting Tools
  • SQL Server Reporting Services, Power BI, Tableau MS Access, MS Excel
  • Data Warehousing/BI Tools - SQL Server Business Intelligence Development – SSIS, SSRS, DTS, BI Stack along with (Power pivot, Power query, Power map)
  • Application Packages- Microsoft Office Suite, SSIS, SSRS
  • Modeling Tools
  • SQL Diagrams
  • Programming
  • T-SQL, VB.Net, XML, HTML
  • Web Technologies
  • HTML, XML, Java Script (Validation), CSS
  • Operating Systems
  • Windows 10/8/R2/2003/XP/2000/98 programing/ Server (64/32 Bit), Linux
  • Languages
  • Basic knowledge of - C, C++, Java, visual basic, Work Shelf, Adobe Software
  • Other Tools
  • MS Office Suite (Microsoft Word, Power Point), OLAP & OLTP, One Note, MS Outlook
  • Data Conversion, Money, Reconciling
  • Data acquisition, Mail, QA
  • General ledger, Migration, Tables



Work History
08/2021 to Current Sr. ETL Developer Honeywell | , , Arlington, VA
  • Designed/developed SSIS packages to extract, transform, load data into Target and generate outbound files for various vendor.
  • Designed and created ETL code installations, aiding in transitions from one data warehouse to another.
  • Developing Ad Hoc reporting solutions using SSRS and Power BI.
  • Create interactive visuals shared with others by bringing multiple charts and text.
  • Created User Defined Functions, Views to store data into appropriate tables as and when data arrives and created indexes to tables that have least updates to improve query performance.
  • Tune SQL queries and database performance by improving overall table design, indexing, query plan analysis and refactoring.
  • Create database design documentation at architectural and functional level.
  • Review database objects for data integrity, quality, security, recoverability, scalability, maintenance and capacity recommend changes as necessary.
  • Identified and eliminated duplicate datasets and performed Columns, Primary Key, Foreign Key profiling
  • Involved in performance tuning of ETL process by addressing various performance issues at extraction and transformation stages.
  • Documented mappings used in ETL processes including Unit testing and Technical document of mappings for future reference.
  • Participated in unit testing to validate data in flat files that are generated by ETL Process.
  • Developed Tabular Reports, Sub Reports, Matrix Reports, Drill down Reports and Charts using SQL Server Reporting Services (SSRS).
  • Collaborated with business intelligence staff at customer facilities to produce customized ETL solutions for specific goals.
02/2019 to 06/2019 SQL Developer Computer Aid | , , Reston, VA
  • Developed, implemented and optimized stored procedures and functions using T-SQL.
  • Performed database backups and restore from Production server to test server as refresh backup as part of testing whether backup is restorable or not.
  • Security Management - Creating Login and user and manage security.
  • Check error logs from SQL Server agent and windows event viewer and trouble shoot and resolve problem.
  • Applied Service Packs patch and hot fixes.
  • Exporting file from database to Excel for various uses.
  • Monitor SQL Server Error Log, space usage (data and log file).
01/2014 to 04/2017 Application Support Analyst Computer Aid | , , Saint Cloud, MN
  • Explained technical information in clear terms to non-technical individuals to promote better understanding.
  • Responded to support requests from end users and patiently walked individuals through basic troubleshooting tasks.
  • Installed, modified and repaired software and hardware to resolve technical issues.
  • Documented transactions and support interactions in system for future reference and addition to knowledge base.
  • Assessed system hardware and software and suggested modifications to reduce lag time and improve overall speed.
  • Configured hardware, devices and software to set up work stations for employees.
  • Managed customers' expectations of support and technology functionality in order to provide positive user experience.
Education
Expected in 2014 to to Bachelor of Science | Information Systems St Cloud State University, St Cloud, GPA:

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

Your data is safe with us

Any information uploaded, such as a resume, or input by the user is owned solely by the user, not LiveCareer. For further information, please visit our Terms of Use.

Resume Overview

School Attended

  • St Cloud State University

Job Titles Held:

  • Sr. ETL Developer
  • SQL Developer
  • Application Support Analyst

Degrees

  • Bachelor of Science

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

*As seen in:As seen in: