Data Engineer Analyst

Reuben Ellman

**** ********* **, ********, ** ***85 734-***-**** ****@*******.***

PROFESSIONAL SUMMARY:

Mr. Ellman is a data analyst with more than 25 years in the Information Technology Industry. He has strong skills in: Power BI, Power Query, Microsoft SQL, Microsoft Excel, VBA automation, customer service, data manipulation, statistics, and providing user-oriented reports. He has led teams and trained fellow staff members. Mr. Ellman has a Bachelor of Business Administration with a focus in Computer Science/ Business Management.

EXPERIENCE:

Robert Half –Southfield, MI – 2/2024 – 4/2025

Position: Data Engineer / Reporting Specialist

· Data engineer via Oracle SQL data pulls within the JDE automotive environment.

· Develop pipelines and data connections with Microsoft Azure Data Factory.

· Data engineer capture of data from JDE and Ford DataMart for reporting.

· Develop reports via ReportsNow DAS.

· Create and leverage Power BI visuals for parts tracking, employee work, and HR/Financial reporting.

· Oversee the Azure data environment and development.

· Used GitHub as a repository for pipeline, trigger, and SQL code storage.

· Made use of data engineering techniques within Azure, Data Factory, Azure SQLDB. stored procedures and pipelines.

Guardian Alarm Company –Southfield, MI – 2/2022 – 2/2024

Position: Data Engineer / Reporting Specialist

· Worked within the Azure Environment using data engineering techniques associated with the Azure Data Factory.

· Leveraged the Azure pipeline system to develop ETL strategy.

· Leverage Microsoft Power BI for visual reporting via data engineering techniques.

· Develop and update SSRS reports.

· Via data engineering techniques make use of PowerQuery for data manipulation, translation, and loading.

· Perform ETL activities within the Microsoft SQL environment.

· Create documentation for review and accreditation of data.

· Perform User Acceptance Testing (UAT).

· Assisted the Marketing Department in creating PowerBI reports and visuals to assist in campaigns.

· Created PowerBI reports and visuals based on Microsoft D365 CRM data for Marketing and Customer Service.

· For the Customer Service group I generated SSRS and PowerBI reports.

· Developed and deployed senior management level SSRS and PowerBI reports and visuals.

· Made use of the Azure Data Factory to port data from an existing SQL system to the Azure cloud system.

· Employed data modeling in order to provide cohesive and expedient reporting objects.

· Gather requirements for reporting and tool development.

· Produce documentation concerning the project: requirements, logic, use cases, results.

FastTek/FastSwitch, Inc. – Consumers Energy, Jackson, MI – 3/2020 – 1/2022

Position: Data Engineer

· Leverage Microsoft Power BI for visual reporting.

· Work in a SingleStore (MemSQL), MySQL, and T-SQL environment.

· Make use of PowerQuery for data manipulation, translation, and loading.

· Use R-script to automate data loads.

· Automate Microsoft Office via VBA programming.

· Generate Tableau visuals for management level reporting.

· Translate Oracle PL/SQL and MySQL into Microsoft T-SQL.

· Perform ETL activities within the Microsoft SQL environment and R-Script.

· Leverage PowerQuery’s ETL functions for data setup for reporting.

· Work with SAP HANA, SAP Business Objects, Microsoft SQL Server data loads, and flat files.

· Create documentation for review and accreditation of data.

· Perform User Acceptance Testing (UAT).

· For the executive team I created PowerBI reports for decision-making purposes.

· Data modeling was used in order to deal with large data sets in order to organize and speed up reporting.

· Leveraged Agile methodologies for project management.

· Gather requirements for reporting and tool development.

· Produce documentation concerning the project: requirements, logic, use cases, results.

Ciber Global, Inc. – Ford, Dearborn, MI – 2/2017 – 1/2020

Position: Visual Basic Developer / Data Engineer

· Create Excel based automotive reporting tools using VBA.

· Update VBA within homegrown automotive reporting tools.

· Create SharePoint and Excel interactive automotive reporting tools.

· Leverage Excel Tables, Microsoft SQL, and VBA to automate reporting tools.

· Generate data results using Microsoft PowerQuery.

· Perform data analysis functions within the Ford Production Development Center (PDC).

· Work with the benchmarking team to provide Excel and web-based tools for product trending.

· Provide Excel based solutions for the metrics team for part tracking.

· Perform ETL activities within the Microsoft SQL environment.

· Leverage Microsoft Office VBA’s ETL functions for data setup for reporting.

· Leverage JSON, QlikView, Alteryx, Tableau, and web tools to create repeatable reports for the client.

· Create interactive dashboards via QlikView.

· Manipulate incoming data sources to create a standard data set via Alteryx.

· Developed QlikView and Excel reports and visuals for the Parts team.

· For management team members I created QlikView for decision making purposes.

· Made use of data modeling in various reporting and visualization tools.

· Gather requirements for reporting and tool development.

· Produce documentation concerning the project: requirements, logic, use cases, results.

Genoa Employment Solutions, Inc. – FordDirect, Dearborn, MI – 6/2014 – 01/2017

Position: SQL Developer and DBA / Data Engineer

· Create routines for ETL based on third party flat files and XML messages.

· Generate SQL to provide data for websites.

· Manage Microsoft SQL Databases.

· Provide user access to Microsoft SQL Databases.

· Design objects within Microsoft SQL Databases.

· Analyze large data sets for patterns and provide summary reports.

· Project manage data retrieval from SQL servers for online dashboards.

· Develop stored procedures for web-based tools for automotive dealership tools.

· Design financial based tools in Excel and Access 2010.

· Redesign current tools for upgrade into Excel and Access 2010.

· Perform ETL activities within the Microsoft SQL environment.

· Leverage Microsoft Office VBA ETL functions for data setup for reporting.

· Make use of Visual Basic in Microsoft Office for tools.

· Provide financial reporting tools for the client.

· Create documentation for user-based tools.

· Converted Microsoft Excel and Access VBA from 2007 to 2010 for more robust functioning.

· Quality Assure software tools.

· Provide User Acceptance Testing (UAT) for the client’s financial tools.

· Provide feedback from testing and building tools.

· Create store procedures to capture user requested data for reporting.

· Provided procedures that reduced the work time or a project from a day to minutes.

· Created Stored Procedures in Microsoft SQL Server for data retrieval.

· Developed SQL Queries for data capture in reporting financial information tools.

· Participated in meetings to develop financial tools built within Microsoft Office.

· Make use of Microsoft’s Bulk Copy Program (BCP) to load and retrieve data and produce format files.

· Leverage Microsoft Visual Studio and tools in a SVN/TSF environment.

· Provide support for TalenD operations.

· SQL Server Reporting Services (SSRS) for minor static reports.

· SQL Server Integration Services (SSIS) for non-critical data imports.

· Data modeling.

· Tableau for analytics.

· Administer access to Windows 2012 RT servers.

· Gather requirements for reporting and tool development.

· Produce documentation concerning the project: requirements, logic, use cases, results.

Epitec Inc. – Blue Cross Blue Shield of Michigan, Detroit, MI – 9/2012 – 3/2014

Position: Data Engineer / SQL Developer

· Reduced ad hoc reporting turn-around times through VBA and T-SQL standardization.

· Made use of Project Management methodologies to create corporate wide reports and reporting tools.

· Provided customer oriented self-service web reporting tools via ColdFusion, JavaScript, and T-SQL.

· Created dashboards in Microsoft Access, Microsoft Excel, and ColdFusion.

· Successfully developed PivotCharts and Analytic views within Excel and Microsoft Access.

· Developed reliable data capture and return from a SharePoint location into Microsoft Excel and Microsoft Access.

· Worked within SQL server environment creating queries and data capture routines.

· Provided test cases, routines, and documentation for products developed by the team.

· Discussed, planned, and completed UAT for products developed by the team.

· Lead JAD sessions for projects to determine requirements, time, expected results, development scope.

· Communicated with Information Security personnel to obtain access to systems for tools.

· Followed System Development Methodology (SDM) for maintaining tool lifecycle.

· Maintained change control logs for projects.

· Perform ETL activities within the Microsoft SQL environment.

· Leverage Microsoft Office VBA ETL functions for data setup for reporting.

· Created report designs and finished reports in Cognos.

· Successfully transitioned legacy Microsoft Access and Excel tools to web versions or improved functionality.

· Produced training documentation for report tool use.

· Created Technical documents for tools.

· Adhered to Service Level Agreement (SLA) requirements.

· Created Key Performance Indicators (KPI) dashboards.

· Provided in person and over-the-telephone training for reporting tools.

· Developed tables and views within the SQL server based on client requirements.

· Made use of Agile methodologies to ensure efficient and responsive tools.

· SQL Server Reporting Services (SSRS) for minor reports.

· Data modeling.

· Captured data and design cues from Crystal Reports for display in Microsoft Office.

Anthelio Healthcare Solutions, Inc. - Detroit Medical Center (DMC), Detroit, MI – 9/2006 – 8/2012

Position: Data Engineer / Data Analyst

· Create databases as tools for data reporting and manipulation

· Administer databases used in reporting

· Interact with various DMC system databases and record storage for data capture

· Work with SQL servers performing queries and data capture

· Lead the data management team in streamlining all process across all databases and reporting engines.

· Work with transferring Microsoft Access designed tools into SQL Server functions and tables.

· Work with converting Microsoft Access designed tool into Web based interactive items.

· Develop automated routines in Excel and Access to reduce reporting time

· Develop various Excel charts for management level reporting

· Tracked projects within Microsoft Excel and Access

· Maintained project timelines based on the project requirements.

· Developed and delivered requirements to team members based on client meetings

· Create automated tools to reduce the number of reporting errors

· Interface with third party software vendors to develop a strategy for future reporting aspects

· Work within the Citrix environment

· Perform daily reporting for clients

· Work with Ascent Cerner/CIS to develop reporting tools for client

· Data modeling

· Through Agile methodologies, build tools that can be modified on the fly

SAIC, Inc. – USDA-APHIS-PPQ, Brighton/Romulus, MI - 11/2002 – 8/2006

Position: Information Support Specialist / Data Engineer

Computer Methods Corp. – Ford Motor Co., Dearborn, MI - 5/2000 - 6/2002

Position: Quality Assurance Software Engineer / Data Analyst

EDUCATION:

Northwood University

Major: Computer Science/ Business Management

Associate of Arts (1995)

Bachelor of Business Administration (1997)

SKILLS AND ABILITIES:

Data Engineering, JDE Environment, ReportsNow DAS, Oracle SQL, Windows, Microsoft Server, Microsoft SQL Server, Microsoft Word, Adobe PDF, Microsoft Excel, Microsoft SQL, ETL, Microsoft Access, SSRS, SSIS, SSAS, Data Warehousing, Microsoft Power BI, SQL, VBA, Microsoft Office, TCP/IP, LAN Administration, Network design, Nortel Phone/Voicemail system, SharePoint, FileZilla FTP, Microsoft Project, Microsoft PowerPoint, Cerner’s Ascent Capture/Image processing system, PowerQuery, HTML, JavaScript, XML, Macromedia Flash, ColdFusion, Adobe Dreamweaver, JSON, Quality Assurance, Management, Personnel Training, Team Lead, Project Management, QlikView, Tableau, Alteryx, R-script, SAP Hana, MySQL, SingleStore (MemSQL), SAP Business Objects, Microsoft SQL Server ETL features, PowerQuery ETL features, Microsoft Azure Environment, Microsoft Azure Data Factory, Data Pipelines, FetchXML, M, DAX, Requirement Collection, Project Documentation

CERTIFICATIONS:

· MCSA/E 2003 Trained and Tested (5/2005)

· Microsoft Certified Professional (5/2005)(C401-5693)

· Comptia A+ Certified (1/04/03) (COMP001000106011)

Contact this candidate