Joel Magee Email & Phone Number

Schererville, In, Us

Chicago, Illinois, United States

United States

In my current role, I collaborate with the client user community to define data requirements for integration applications. I document data mapping rules for data movement, following data administration standards. Support extraction and cleansing for corporate data and resolve issues across platforms. I also employ data mining techniques for synchronization, identification, reconciliation, and problem analysis.Some Key Accomplishments Includes:• Building 15 ETL pipelines resulting in a 5% increase in the organization's 35% Dimensional Model usage goal.• Streamlining processes with "Engage" software, resulting in a 90% reduction in process time and an 85% decrease in manual labor for monthly OPS Binder, freeing up 36 hours for strategic initiatives by Q2 2022.• Achieving 100% automation of daily data sourcing tasks through Microsoft Power Automate, Python programming, and Matomo Analytics Web API.• Collaborating with a cross-functional team to ensure data integrity and minimize downtime while implementing migration from on-prem SQL database to Azure SQL Managed Instance.• Collaborating bi-weekly with clients resulting in a 25% increase in moving Power BI data from flat files to Azure SQL Managed Instance data pipelines, improving database performance and leading to ETL gains.• Enhancing database performance and decreasing SQL Server Agent Job failures by 70% in 2023 through optimization of SQL queries and Stored Procedures.

United States

Schererville, In, United States

Greater Chicago Area

In this role, I traveled nationwide to teach technicians AT&T system fundamentals, from installation to testing. I developed new course materials in collaboration with other departments to align with AT&T goals and best practices. I advised clients as a SME for Cisco MSTP, WDM, and other technologies. I also expanded online course delivery using Interactive Video Learning, accommodating up to 50 learners while lowering costs and staying current on all tech advancements.Some Key Accomplishments Includes:• Achieving selection as the Leader Facilitator for AT&T University Design Thinking Level 3 training course, based on client Net Promoter Score of 95% or higher.• Converting 3 Leader Led Courses (MX2020, Flashwave 9500, MX480/960 IPAG) to a virtual format to meet client demands during the pandemic, in collaboration with Design.• Allocating 15% of development time to volunteer partnership with AT&T Field Operations (AFO) in conducting end user interviews for a new ATLAS application, utilizing Design Thinking empathize phase and gaining exposure with Agile standups and Design lifecycles.

Maintained central office equipment operations. Responsible for installation, repair, testing and evaluation of a variety of voice and carrier equipment and circuits, including turn-ups.* Tested and configured all new install circuits using DS0, DS1, DS3 and SONET test boxes under normal and emergency power systems.* Diagnosed and troubleshot all telecommunications equipment and carrier signals, such as DMS-100 switches, and equipment that transports DS0, DS1, DS3 and SONET signals.* Operated and maintained devices, such as generators, rectifiers and storage batteries used to furnish or transmit power for telephone service.* Provided technical assistance for other AT&T departments, including control centers and outside technicians, to successfully maintain the wireline and wireless network.* Performed testing, repair and malfunction analysis procedures; coordinated and assisted other technicians to clear up troublesome systems.* Trained central office technicians in using toll department technologies to maintain the network.

Burns Harbor, Indiana

Estimated costs and created plan drawings for the wiring layout of a lighting project for power house lighting of Boiler No.11. Provided assistance to the department planner and engineer in troubleshooting various machines and the rewiring of the R-5 field supply in the hot strip mill.* Created a database of all motor, breaker and battery information in Microsoft Access.* Participated in the creation of a database for mills breaker/battery cells.* Restructured the engineer drawing database.

Bachelor Of Science - Bs, Electrical And Computer Engineering Technology, 3.2

Activities and Societies: * Instructor Assistant / Tutor - Engineering 140: Tutored students in C++ Programming * Purdue Alumnus Member

Data Engineering With Aws

Learn to design data models, build data warehouses and data lakes, automate data pipelines, and manage massive datasets. Create.

Nanodegree, Sql

Machine Learning - Introduction With Pytorch Nanodegre, Data Analytics, Passed

Full Stack Web Developer Nanodergee, Computer Programming

Nanodegree, Introduction To Programming

This Introductory Nanodegree teaches you the foundational skills all programmers use, whether they program mobile apps, create web pages.

Graduate Studies, Business Administration And Management, General