We provide IT Staff Augmentation Services!

Senior Data Engineer Resume

Des Moines, IowA

SUMMARY

  • Twenty+ years data architecture, development, integration & warehousing experience with solid work history
  • Multi - task oriented, effective working independently or as part of a team, efficient in following through with directives
  • Quick learner with keen analytical ability and initiative; adept in grasping new material. Self-taught in various computer applications and functions
  • Excellent math, oral/written communication and people skills; routinely interact with diverse customer and management levels
  • “Big Picture” thinker considering dependencies and possible issues to determine best course of action
  • Hard working and conscientious, willing to “go the extra mile to get the job done”
  • Passionate about meeting and exceeding customer data needs
  • Continuously striving to improve processes

TECHNICAL SKILLS

  • PL/SQL & T-SQL
  • ETL/ELT (SSIS
  • OWB
  • ODI)
  • Database (Oracle and SQL Server)
  • Database Design
  • Data Warehousing
  • Data Modeling
  • Data Mining
  • Data Analysis
  • Data Mapping
  • Report Design (SQL Server Reporting Services (SSRS) and OBIEE)
  • SVN
  • Teradata
  • Project Management
  • Requirement Gathering
  • Infrastructure & Network concepts
  • Various Development Methodologies
  • MS Office

PROFESSIONAL EXPERIENCE

Confidential - Des Moines, Iowa

Senior Data Engineer

Responsibilities:

  • Currently leading project to build new Azure data strategy including Data Factory, Data Lake, Synapse & PowerBI
  • Gather & Interpret requirements for project requests from all levels of business (Including mapping desired data attributes to various source systems)
  • Manage projects requiring multiple engineers that didn’t have a PM assigned (Including regular touch bases, project planning, coordination & scheduling, project tracking, updates to business partners with milestones, retrospectives)
  • Create & Maintain database objects (Tables, Views, Materialized Views, Procedures, Packages, Sequences, Triggers, Scheduled Jobs, etc.)
  • Create & Maintain data models using SQL Developer Data Modeler
  • Data Integration & ETL using database packages/procedures/jobs, shell scripts, OWB & ODI (migrated from OWB to ODI)
  • Assist/advise team members in troubleshooting issues, development planning, prioritizing workload, etc.
  • Troubleshoot and resolve escalated production tickets
  • Mentor team members within immediate team and other teams in IT
  • Serve as Team Lead
  • Serve as technical lead on many projects and “GoTo” resource for many more
  • Decision Maker/Influencer for data strategy, future tools, infrastructure & design
  • Serve as Liaison between application side of IT and Infrastructure/Networking
  • Create Change Control process, Develop CR form & functionality & Run weekly Change Management meetings
  • Application Administrator, SFTP Administrator and limited Server Administrator

Confidential - Urbandale, Iowa

Business Intelligence Engineer

Responsibilities:

  • Manage projects and communicate with business to translate business needs into technical specifications/requirements
  • Automate time consuming processes, resulting in accurate reporting in critical areas of business
  • Create/Update database tables, views, functions, procedures, triggers, sequences, etc., develop PL/SQL and ETL code, design reports using SSRS or OBIEE
  • Created project sites in SharePoint for central location to track progress, tasks, issues and communication throughout project lifecycle
  • Schedule and lead checkpoint meetings with business throughout projects
  • Track admin tasks and production support tickets using JIRA

Confidential - Des Moines, Iowa

Database Administrator/Developer and Programmer

Responsibilities:

  • Create and maintain Sequel Server databases containing millions of records of high security level data
  • Utilize SQL Server Enterprise Manager, Query Analyzer, Batch Inject, Stored Procedures, Data Transfer, etc.
  • Manage Sequel Server security - users and access levels, processes - CPU and memory usage, DB size and structure
  • Create applications and front-end database access for MS Access and Sequel Server databases using VB6 and VBa including an automatic request/delivery system for Siebel Analytics data, multiple applications for storing/processing data, creating QWS scripts, deciphering flat files, import/export, calculations, creating reports, etc.
  • Automate processes reducing cost by 10% to 25% and increasing productivity by 50% to 75% in many cases
  • Manipulate large quantities of data to reorganize and recalculate systematic errors
  • Install software and hardware, move computers, troubleshoot computer problems software, hardware and user issues
  • Communicate and interact with internal customers and various levels of management on a daily basis receiving a high rate of satisfaction
  • Create and instruct multiple training sessions on MS Access and MS Excel resulting in increased productivity and broader capabilities in other employees.

Hire Now