JOHN F. SWANSON

adkm5l@r.postjobfree.com

Telephone: 708-***-**** Alternate: 708-***-****

PROFILE Innovative and results-driven IT professional with extensive experience developing and integrating technologies to support broad-ranging operating, financial and organizational Business Intelligence needs. Used SSRS to create interactive reports and SSIS to load data warehouse tables. Combines cross functional, experience in planning, analysis, design, programming and problem solving, partnering with both users and developers. Successful in delivering tangible, measurable results.

CERTIFICATIONS

•Certified Data Management Professional

•Certified Computing Professional

•Certified Service Oriented Architecture Class (5 days)

•Attended Microsoft Business Intelligence Suite 2008 Class (4 days)

•Certified Business Intelligence Professional

•Certified Targit 2011 Class (5 days)

•Certified ITIL Foundations Class (5 days) Fall 2018

•MS 70-779 Analysis with Excel

•MS 70-778 Analysis with Power BI

TECHNICAL EXPERTISE

Methodology

ERD Modeling

Data Modeling

Process Modeling

Modeling Tools

Information Engineering Function (IEF)

Application Developers Workbench (ADW)

DMR'S OPAL Process Modeling Methodology

Reporting Tools

MS Reporting Services 2008/2016 (SSRS)

GIT Repository

JIRA

Schema Design

Star Schema

Relational Schema

Multidimensional Schema

Business Intelligence Tools

Power BI

Targit

Cubes: Logical & Physical Design,

MS Analysis Services 2008/2016

Databases: * SQL Server Logical & Physical Design, DDL, DML, Stored Procedures

EXPERIENCE

SIMS RECYCLING SOLUTIONS (a subsidiary of Sims Metal Management of Australia); West Chicago, Illinois

Multi national electronics recycling and refurbishing company.

September 2012 - June 2019 – Employee of Sims

February 2011 – September 2012 consultant with Robert Half

Report Developer: Developed over 120 reports for MS Navision / Enwis (an add-on written in Germany). Many with drill down components, using Visual Studio BIDS SSSRS and T-SQL stored procedures, used JIRA to track progress, and GIT to save the reports. Maintained the reports as new functionality was added or the Navision application was moved to a newer version. Coached new members of the team on database logic. Maintained Targit 2011, a BI tool; assisted in creating database cube structure; and wrote reports for Targit. Wrote views and reports for MS Power BI.

OMEDA COMMUNICATIONS, Northbrook, Illinois

Feb 2010 – Dec 2010 Maintained subscription data and periodical archives for publishers.

Report Developer: Designed and implemented Deployment Subscription, and Audit reports using MS Reporting Services 2008 (SSRS). Wrote SQL Server T-SQL and stored procedures for the reports. Designed and implemented publishing data reports including Magazine Pre-Close, Issue Close, and Audit Bureau reports using MS Reporting Services 2008. Wrote SQL Server T-SQL and stored procedures. Designed summary tables and ETL routines to improve report performance.

WUNDERMAN, Chicago, Illinois for Aquent (Contract Ended)

Jul 2008 - Feb 2009 Large direct marketing firm with offices in 55 countries.

Data Analyst: Designed and implemented Customer Promotional data warehouse in SQL Server 2005 for a client, including Tables, Views, & Extracts of 14 unique promotions using MS Integration Services (SSIS); T/SQL for list pulls and customer research; MS Reporting Services (SSRS) and Report Builder for reports.

Results: Market analysts viewed all customers across all promotions making improved targeted email marketing choices.

ROYAL PERFORMANCE GROUP, Lisle, Illinois for Robert Half Technology

Aug 2007 – May 2008 Small young global gift card marketing company. (Contract Ended)

Report Developer: Designed and implemented a Financial Summary data warehouse in SQL Server 2005 and MS Visio. Wrote SQL Server Integration Services 2005 routines to pull data from 3 sources. Designed coded, tested, and productionized Financial and Sales reports for the US and German offices using T/SQL and SQL Server Reporting Services 2005. The reports employed drill down to greater detail and drill through to a relational database and sub reports. The SSIS routine had parent / child packages.

Results: Marketing and Sales managers had monthly and daily BI reports for the first time. German office had Invoices and Packing Lists that met their government standards.

SANFORD BRANDS, Oak Brook, Illinois for Copley GS (Contract Ended)

Apr 2007 - Aug 2007 $1.6 billion manufacturer of fine writing instruments and office accessories.

Report Developer: Designed and implemented Customer Supply Chain Data Warehouse using T/SQL and SQL Server 2005. Wrote MS Integration Services routines to pull data. Designed and wrote MS Reporting Services reports for error delays and tracking with drill down to greater detail and text lookup to standardize error messages.

Results: CSC had reports of Sales Cycle Time and Errors that allowed management to make informed decisions. Uncovered discrepancies between data sources because of differences in extract process.

NAVISTAR INTERNATIONAL CORP., Warrenville, Illinois

1996 to 2006 $10 billion global manufacturer of trucks, busses, and engines; Information Week Top 500 for last 5 years.

Technical Analyst (2002-2006) Designed and coded Hyperion Essbase BI cubes with Alphablox reporting systems (web based Java environment with Alphablox servlets embedded in JSP and Javascript) using SQL for data extracts.

•Ensured proper loading of data marts and Essbase cubes by developing SQL for data testing from DB2 base tables on a mainframe to BI cubes and Oracle dimensional schemas on HP-Unix.

•Advised business users, report developers, analysts, modelers and supervisors in scripting

•BI reports, extending model data structures and the merits of various alternatives. Trained small groups and individual business users in selecting dictionaries, procedures and quality assurance of reporting tools.

Project Highlights: Performed a combination of conceptualizing, designing, analyzing, prototyping and implementing of various systems and applications, developing data warehouses that were efficient and robust. Designed and created Essbase cubes and data marts using JAD sessions, ERwin CASE tool, database engines, reporting tools, web programming & scripting languages, metadata research and data standards for:

•Truck Order & Delivery Data Warehouse

•Special Pricing Request Response Reporting System w/Detail Drill Through

•Customer Quality & Dependability Web Based Reporting Application

•Competitive Product Market Segmentation Web Based Reporting Application

Results:

Reduced in-house development costs 40% by coordinating offshore consultants. Improved performance of the Sales & Marketing Data Warehouse by re-engineering the data warehouse, i.e., removing numerous joins while satisfying referential integrity rules. Reduced existing software costs by leading Sales & Marketing IT Group to develop Essbase/Alphablox reporting within expected budgets and deadlines.

Senior Data & Resource Analyst (1999-2002)

•Established best-in-class reporting tools by installing working demos for Business Objects, Brio and other tools featuring Universes and reports mimicking the old tool's dictionaries and reports.

•Mapped data fields from legacy system to reporting data structures using System Engineer. Data & Resource Analyst (1996-1999) Managed a truck order reporting database with five subject areas and 130 users.

•Achieved two staff reductions by minimizing ad hoc requests through re-engineering of the reporting data warehouse, nearly doubling number of data fields and rewriting dictionary procedures. - Reduced obsolete server maintenance costs 40% by moving the reporting database to Unix server.

•Rewrote manual loads using automated routines with DB2, SAS and Korn shell script routines.

•Partnered with Sales Department to achieve a $1 million additional discount by designing a spreadsheet reporting system to track dealer, customer and supplier competition.

EDUCATION

B.S. - Mathematics/Computer Science, ILLINOIS INSTITUTE OF TECHNOLOGY

Hyperion Essbase 7.1 New Features 2005

Hyperion Essbase 5.x Bootcamp 2002

Alphablox 3.x Bootcamp 2003

Service Oriented Architecture 2007

Informix Extended Parallel Server & Advanced Features 2000

Microsoft Implementing and Maintaining SQL Server 2008 Reporting Services, Analysis Services, and Integration Services

Microsoft Certified Solutions Associate BI Reporting

ITIL Foundation Certificate in IT Service Management

Contact this candidate