Ed Leonard Email & Phone Number

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.

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.

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.

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.

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.

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.

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.

Pewaukee, Wi, Us

Teaching a class in Database Concepts within the School of Business Information Technology Program.

Instruct classes in Software Development, XML, Database and Social Networking.

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.

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.

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.

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.

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.

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.

M.S., Computing

B.S., Business Administration/ Information Technology

1995, College Prep