Data Engineer Resume

SUMMARY

Expert Data Engineer/Report Developer dedicated to constantly improving infrastructure to maximize productivity, minimize system downtime and quickly respond to the changing needs of the business. Extensive knowledge of Business Intelligence Reporting and Data Analytics.

TECHNICAL SKILLS

Python, Spark, Sqoop, Oozie, HDFS, Elasticsearch, AWS, HUE, Hadoop, ETL, SAS, SQL, Tableau, JIRA, subversion, analyst, call center charts, Cisco, Cognos, conversion, Crystal Reports, client, clients, Data Warehouse, databases, database, Direct Marketing, ERP, Focus forecasting, graphs, phone support, HTML, Human Resource, DB2, insurance, international business, team lead, logic, Macros, Mainframe, managing marketing analysis, Marketing, Microsoft Acess, Access, Microsoft Access, Access Basic, Excel spreadsheets, Excel, Microsoft Office, Microsoft Office suite ffice, 97, Outlook, Powerpoint, Windows, Windows NT, Word, MIS, Enterprise, network, ODBC, Oracle, payroll,PDF, personnel, Processes, programming project leader, Quickbooks, reporting, requirements analysis, Sales, SQL Server, statistics, Sybase, Symantec, tables, Tandem, taxes, Technical support phone, travel arrangements, VBA, Visual Basic, VSAM, written, Y2K.

PROFESSIONAL EXPERIENCE

Confidential

Data Engineer

Responsibilities:

Build and maintain an infrastructure for delivering customer insights from structured and unstructured data sources.
Support data and analytic requirements for the development and implementation of an Ecommerce Digital application in an Agile environment.
Develop queries using SQL to extract data from Postgres, SQL Server, DB2 and other legacy databases.
Enhance development of data lake to house agricultural data in an AWS environment.
Research and assist in implementation of Elasticsearch for the Ecommerce platform.

Confidential

Senior Data Engineer

Responsibilities:

Develop entire process for ETL that extracts Oracle data and stores it in Impala tables using Python, Sqoop, Spark and Oozie in a Hadoop environment.
Generate dashboards for high profile applications using Tableau.
Develop automated reporting solutions for business units across the company using SAS, SQL and HTML to present information via a web interface.
Enhance legacy ETL to improve efficiency and performance. This includes data from multiple databases including Oracle, SQL Server and Tandem.
Continually improving data warehousing and system architecture by consolidating and improving legacy code.
Collaborated with product and engineering team members to define and develop new product concepts
Mentor junior members of the team on usage of SAS and SQL and database design.

Confidential

Business Systems Architect

Responsibilities:

Supervised the work of 5 other report developers.
Functioned as team lead assisting with system questions, analysis of data and triaging of work assignments Responsible for development and production of Quarterly Business Review reports for all clients.
Utilized SAS to automate numerous manual processes and generate very complex client reporting.
Architected and developed an infrastructure for a database environment to house historical data and information required to assess data integrity, measure operational performance maintain call center statistics and provide client book of business reports.
Developed and introduced an entirely new suite of operations reports designed to assist in managing the daily operations of the call center.
Created automated employee and client performance scorecards, and developed dashboards for use by Account Management and Operations teams.
Utilized advanced SAS functionality, including SAS macros and SAS Graph in conjunction with SQL to produce numerous operations and account management reports.
Assisted in training the Data Analytics team on more advanced usage of Microsoft Access, SAS and SQL.