Daniel Ward

adyhm5@r.postjobfree.com https://www.linkedin.com/in/danielwardsys/

586-***-**** Chesterfield, MI 48051

SUMMARY

Business Intelligence, Business, and Data Analyst.

Information Systems Specialist with 25 years of professional experience.

Data Management leader and professional focused on working with Business and IT in DW/BI/ETL Architecture, Development, and Operations/Support.

Experienced in developing and operating several Enterprise Data Warehouses with large data volumes.

Experienced designing and building complex BI/Analytics systems including dashboards, ad-hoc capabilities, and parameterized reports.

Strong background in Data Administration, Modeling, and Applications Development.

Experienced working with business and technology leaders, BI users, and SMEs to gather data and BI requirements and transform them into solutions.

Industry Experience: Automotive, Retail Distribution, and Freight Transportation.

WORK EXPERIENCE

OneMagnify @ Ford Motor Co. 2014 – July 2023

Senior Data Analyst Dearborn, MI

As a Senior Data Analyst, I acquired, cleansed, and loaded disparate data sources in a Marketing sales and service environment.

Automated processes using workflow software including SAS, Adobe Campaign, Qlik, and Alteryx, Business Intelligence ETL, and reporting.

SQL programming, FTP transfers, and Business Objects Crystal Reports Server.

Collaborated with Product Owners, B.A.s, and Developers to create, modify, and launch new applications and systems.

Transferred data through their lifecycle through product and platform changes upgrades and migrations.

Created, reviewed, and approved advanced system documentation.

Responsible for Campaign Tool, Informatica Enterprise Data Catalog, Change Management communications, and tracking.

Maintained safe and secure PII sources.

Leading Edge Logistics 2004 – 2014

I.T Manager Troy, MI

Systems and Technology Leader for a Third-Party Logistics (3PL) company.

Systems integration, network, hardware, and software management. Transportation Manager Systems (TMS) expert using i2 JDA TMS, Transcore, Keypoint, and other TMS. Integrated systems using Oracle, SQL Servers on Windows Server. Report development in Business Objects Crystal, Access, and TOAD. Scheduled batches for customers, carriers, and internal integrations. EDI integration. Hired Mentored Trained technical and other employees.

Oracle and SQL programming and requirements gathering

i2 JDA TMS integration with custom Crystal Reports.

VBScript, Visual Studio

Handleman Company 1994 – 2004

Senior Programmer, Business Intelligence Systems. Troy, MI

Application developer using Oracle, Oracle Portal, MVS, CA-7, JCL, and COBOL. Developed and launched a successful Data Warehouse for a music retail distribution company, working on mainframe, UNIX, and Windows servers. Cross-Platform ETL and data cleansing. Managing, tuning, and performance enhancement on large volumes of sales records. PMO PMP specialty training.

Oracle, COBOL, JCL, and Syncsort Programming

Unix Scripts

Oracle Business Intelligence and Data Warehouse ETL design

EDUCATION

Oakland University

Rochester, MI April 2004

M.S. in Information Technology Management

Advanced Database Concepts, Software project management, and network management.

Walsh College

Troy, MI April 2001

B.B.A. in Computer Information Systems, Summa Cum Laude

Database design, web page design, application development, statistics, and business communication.

SKILLS

Advanced Business Communication, Team Leadership, Collaboration, Programming, and Project Management. Data Warehouse, SQL, PL/SQL Oracle programming, Data Collection, Analytics, Marketing Campaigns, Optimization, Alteryx, Excel, and Macros. Database Management, Office Suite, VBA, and Hadoop Hive. Workflow Management Software, Reports and Dashboards, Requirements Gathering, ETL and Integration, Transportation Management Software, Integration Applications, and Replenishment Systems.

Contact this candidate