Ed Leonard

Ed Leonard Email and Phone Number

Lead Data Analytics Engineer at Northwestern Mutual @ Northwestern Mutual
Ed Leonard's Location
Greater Milwaukee, United States, United States
Ed Leonard's Contact Details

Ed Leonard personal email

n/a

Ed Leonard phone numbers

About Ed Leonard

Progressive and successful experience in Database solutions; programming, analysis, administration and development using technology to deliver solutions to end-users in order to make their decisions faster and more accurate, having worked serving audiences of varying sizes in corporate and higher educational settings. Key strengths include adapting to new technologies, solving database issues and using innovative business intelligence to improve existing procedures, resulting in tangible improvements to time and income.Specialties: SQL Server 2005 - 2016 Database, Oracle Database, Data Warehousing,SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SAP Crystal Reports, SAP Business Objects Enterprise (BOBJ), COBOL, JCL, Microsoft Excel, PowerBI, PowerPivot and Microsoft Access, XML, Epic Clarity, Epic Cogito Data Warehouse.

Ed Leonard's Current Company Details
Northwestern Mutual

Northwestern Mutual

View
Lead Data Analytics Engineer at Northwestern Mutual
Ed Leonard Work Experience Details
  • Northwestern Mutual
    Lead Data Analytics Engineer
    Northwestern Mutual May 2021 - Present
    Milwaukee, Wi, Us
    Lead large project efforts to acquire, analyze, combine, synthesize, and structure data for analytical consumption. Consult with data consumers and leaders to identify meaningful datasets for analytical consumption. Lead the design and application of engineering best practices to analyze, design, develop, deploy, and support data products. Mentor the team on solution and quality standards. Leads the development of analytical data products using continuous deployment and integration practices with SQL, Netezza, DB2 database management systems and AWS data sources and destinations using SSIS, SQL and Python.
  • Northwestern Mutual
    Senior Data Engineer
    Northwestern Mutual Sep 2018 - May 2021
    Milwaukee, Wi, Us
    Accesses, combines, synthesizes, and stores data from a wide range of internal and external sources for analytical purposes. Working side-by-side with analysts to assemble datasets required to derive business insights from data. Working to expand the company’s analytical data universe using ETL tools such as Informatica and SQL Server Integrations Services (SSIS) and various database platforms including SQL Server, MySQL, Netezza, IBM DB2 UDB/zOS.
  • Northwestern Mutual
    Senior Engineer - Business Intelligence And Data Services
    Northwestern Mutual Jun 2017 - Sep 2018
    Milwaukee, Wi, Us
    Working within the Infrastructure and Operations area, lead the deployment and upgrades of Business Intelligence and Database systems within the enterprise while working in a SAFE Agile methodology. I was involved with many projects, such as on premise to cloud database migrations, development of new Splunk infrastructure as well as maturity of Microsoft Power BI and Microsoft Business Intelligence. I served as a mentor to new team members and assisted with their recruitment through the hiring phase.
  • Northwestern Mutual
    System Administration Senior Specialist
    Northwestern Mutual Nov 2014 - Jun 2017
    Milwaukee, Wi, Us
    Working in a role on the BI Tools Team as part of Service Operations within Enterprise Technology Management to support and administer Business Intelligence Tools such as Microsoft SQL Server BI, Business Objects, Informatica, Rochade, Crystal Reports, PowerBI and Splunk.
  • Northwestern Mutual
    Interim Team Leader
    Northwestern Mutual Feb 2016 - Sep 2016
    Milwaukee, Wi, Us
    Interim team leader for BI Tools Support team in 2016 assigning work, following through on management directives, adjusting assignments due to unforeseen resource changes and aligning team members for maximizing work efficiency.
  • Marquette University
    Adjunct Instructor
    Marquette University Aug 2018 - Present
    Milwaukee, Wi, Us
    Teaching an Introduction to Information Systems class providing future information systems users with a broad overview of information systems and applications used in organizations including the software development life cycle, introduction to databases, business intelligence and analytics, introduction to enterprise architecture, innovation, infrastructure, networking, security, ethical use of information systems, and other business software applications.
  • After Hours Coders, Llc
    Principal/Senior Business Intelligence Developer
    After Hours Coders, Llc Jan 2010 - Present
    Muskego, Wi, Us
    Working outside of business hours on evenings and weekends, operating an Information Technology consulting firm providing services to increase the value of companies through enhanced solution in the form of database administration, application development, database reporting and general computer support. Successfully serving over fifteen clients throughout the United States, leading their technology initiatives and helping them meet their strategic goals.Providing consulting solutions using SQL Server Database/Business Intelligence, Crystal Reports, Business Objects, SharePoint, Microsoft Office and Azure technologies.
  • Waukesha County Technical College
    Adjunct Instructor
    Waukesha County Technical College Aug 2017 - Jul 2018
    Pewaukee, Wi, Us
    Teaching a class in Database Concepts within the School of Business Information Technology Program.
  • Itt Technical Institute
    Adjunct Instructor
    Itt Technical Institute Dec 2015 - Sep 2016
    Instruct classes in Software Development, XML, Database and Social Networking.
  • Prohealth Care
    Database Administrator
    Prohealth Care Feb 2013 - Nov 2014
    Waukesha, Wi, Us
    Working as a SQL Server Database Administrator balancing project activities and proactive maintenance in a healthcare environment, responsible for over 1200 databases on over 100 physical/virtual servers, in a clustered and high available deployment of Microsoft SQL Server, supporting third party applications vital to patient care and administration. Administer multiple SQL Server Reporting and Analysis Services environments and administer SQL Server Integration packages.Support the Epic Clarity Reporting database and administer ETL, designing Clarity environments and ETL solutions for release and version upgrades, performing analysis between release and version levels to identify and document differences and building custom Clarity ETL solutions to satisfy data requirements outside of the standard Clarity ETL extracts.As an administrator for the Epic Cogito Data Warehouse (CDW), responsible for the ETL refreshes, maintenance, installations and upgrades of the database and application for this product in three environments, including one the first production instances implemented worldwide.
  • Marquette University
    Database Administrator/Business Intelligence Developer
    Marquette University Sep 2007 - Feb 2013
    Milwaukee, Wi, Us
    Develop business intelligence solutions for data warehouses, and other unique business processes using SQL Server Integration Services (SSIS) and SAP/Business Objects Data Integrator. Administer SQL Server 2005, 2008, 2008R2 databases including Implementation of databases and environments, procedures for quality assurance, restart/backup & recovery, change control, and performance monitoring. Cross trained as in Oracle Database Administraton to create, backup, move and apply patches to Oracle databases on Unix/Linux platforms.Application Specialist for SAP/Business Objects Enterprise Reporting system and develop Crystal Reports.Installed, deployed and administer enterprise SQL Server Reporting Services environment and develop SSRS reports.
  • Marquette University
    Advancement Project Manager
    Marquette University Apr 2005 - Sep 2007
    Milwaukee, Wi, Us
    Worked as a project manager for multiple priority projects within the University Advancement department.Developed, formatted and facilitated data transfers, including imports of data from within the university and external vendors and clients, provided clients with end-user capability for access to custom reports, managed projects and lead teams, adhering to Project Management Institute (PMI) methodologies.
  • At&T
    Analyst
    At&T Jun 1999 - Apr 2005
    Dallas, Tx, Us
    Worked as a COBOL/JCL/Assembler developer in the billing services section. Assigned project work based off the needs of the business. Provide clients with timely and accurate representation of the customer database, delivered in many different forms of media. Assigned as project manager, responsible for the comprehensive development of requirements from the client through the successful deployment of projects. Completed multiple COBOL/JCL/Assembler projects under expedited time frames, exposure to diverse programming languages and environments on client- server and mainframe, worked on projects mandated by top leadership, reporting database information to auditors.
  • Boston Store
    Sales Associate
    Boston Store Aug 2001 - Sep 2002
    Donora, Pennsylvania, Us
    Worked part time in the as a sales associate serving customers in a retail environment. Duties included helping to increase sales in the department meet new credit sales expectations. Also helped train new associates.
  • Medved Autoplex
    Office Worker
    Medved Autoplex May 1998 - Aug 1998
    Wheat Ridge, Co, Us
    Worked in the business office at a large automobile dealership, updating programs in Reynolds & Reynolds computer system, working as Accounts Receivable clerk and other miscellaneous duties.

Ed Leonard Skills

Databases Microsoft Sql Server Data Warehousing Business Intelligence Ssis Sharepoint Ssrs Crystal Reports Etl Business Objects Xml Integration Oracle Data Integration Access Sql Server Integration Services Java Management Splunk Sql Server Sql Server Reporting Services Microsoft Excel Html T Sql Microsoft Word Analysis Services Tableau Informatica Administration Power Bi Windows Server Informatica C# Excel Cobol Jcl Sap Word Powerpoint Epic Systems Clarity Powerpivot Sql Azure Azure Powerbi Github Ansible Mysql

Ed Leonard Education Details

  • Marquette University
    Marquette University
    Computing
  • Marquette University
    Marquette University
    Business Administration/ Information Technology
  • Kent Denver School
    Kent Denver School
    College Prep

Frequently Asked Questions about Ed Leonard

What company does Ed Leonard work for?

Ed Leonard works for Northwestern Mutual

What is Ed Leonard's role at the current company?

Ed Leonard's current role is Lead Data Analytics Engineer at Northwestern Mutual.

What is Ed Leonard's email address?

Ed Leonard's email address is ed****@****tte.edu

What is Ed Leonard's direct phone number?

Ed Leonard's direct phone number is +141428*****

What schools did Ed Leonard attend?

Ed Leonard attended Marquette University, Marquette University, Kent Denver School.

What skills is Ed Leonard known for?

Ed Leonard has skills like Databases, Microsoft Sql Server, Data Warehousing, Business Intelligence, Ssis, Sharepoint, Ssrs, Crystal Reports, Etl, Business Objects, Xml, Integration.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.