Senior Data Engineer Resume Des Moines, Iowa - Hire IT People

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

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.