Business Intelligence Developer

John R. Shanks

*** ****** **.

Sun Prairie, WI **590

Home: 608-***-****

Summary

A skilled computer professional with a background in analysis, design, programming, and technical trouble shooting. Demonstrated strengths in problem-solving and organization skills. Seeking position, which allows continual professional growth.

Professional Experience

Business Intelligence Developer Aug. 2009-Jan.2016

Trek Bicycle Corp., Waterloo, WI

Design, Develop and implement data warehouse using Microsoft Business Intelligence tools

• Designed and developed ETL process, using SSIS, retrieving data from JD Edwards OneWorld XE ERP system.

• Maintain existing and create new data marts as needed.

• Maintain existing and create new Analysis Services Cubes(SSAS) as needed.

• Developed Reports in Reporting Services(SSRS).

Senior Analyst

Trek Bicycle Corp., Waterloo, WI Mar.2005-Aug 2009

Design, Develop, and implement new business reporting systems, using Business Objects XI.

• Worked with Andrews Consulting Group to implement a Data Warehouse system, using SQL Server.

• Maintain existing and create new data marts as needed.

• Developed reports in Business Objects Web Intelligence, Crystal Reports, and Business Objects OLAPI tool.

• Main contact for worldwide reporting needs, for sales and distribution systems.

Decision Support Analyst

Trek Bicycle Corp., Waterloo, WI Oct.2000-Mar 2005

Design, develop, and implement new business reporting systems, using Showcase Strategy, and Essbase/400.

• Designed and implemented worldwide Data warehouse system.

• Assisted in converting European subsidiaries from DOS FoxPro applications to JD Edwards One World.

Programmer/Analyst

Trek Bicycle Corp., Waterloo, WI Jan.1997-Oct. 2000

Design, develop, and implement new business systems.

• Designed and implemented Domestic Data warehouse system, using Showcase Strategy, and ESSBASE/400.

• Assisted in developing Dealer Extranet, using LANSA and HTML.

• Wrote applications, using LANSA, and RPG, to help business adapt to changing needs.

• Maintain existing HFA applications in order to adapt to changing business requirements.

Developer/Analyst II 1993-Jan.1997

Demco, Inc., Madison, WI

Analyze, Design, develop, and implement new business application systems using CASE technology.

• Maintained existing applications, using LANSA, and RPG, in order to adapt to changing business requirements

• Lead multi-task, single resource projects.

• Contributed to development of systems to continually improve the corporate productivity, quality, and customer service.

• Wrote key business applications to help convert from a Bull DPS700, to an IBM AS/400. Systems included invoicing, credit memos, forecast maintenance.

Computer Consultant (1992-1993) 1991-1993

AGS Information Services, Oakbrook Terrace, IL

On assignment to Washington National Insurance Company in Evanston, IL.

• Answered any technical questions users had.

• Monitored system performance and performed necessary tasks to improve performance.

• Performed network administrator tasks.

• Helped move data center from Evanston to Lincolnshire, IL.

• Helped rebuild a 200-node Banyan network from the ground up.

• Designed and implemented a Paradox database for hardware and software inventory.

Computer Consultant (1991-1992)

AGS Information Services, Rockville, MD

On assignment to IBM participated in the development of software to support the health care industries.

• Responsible for analysis, design, and development of IBM Medical records software using IMAGE PLUS/400.

• Designed and developed Inter Communications Function Software in order to link two medical records systems, on two different AS/400’s.

Software Tester 1989-1991

Winona State University, Winona, MN

Under contract to IBM, Rochester, MN involved in systems development testing of IBM software and hardware.

• Selected to participate because of grades and performance in the classroom.

• Tested software, including PC Support and related intelligent workstation.

• Responsible for developing new test scenarios, and evaluating product usability.

• Maintained system communications.

Education

Bachelor of Science, 1991, Winona State University, Winona, MN

Major: Computer Science

Minor: Business Administration

GPA 3.0/4.0

Technical Skills

Hardware

AS/400, PC, Macintosh

Languages

LANSA, RPG/400, CLP, PASCAL, COBOL, Basic, Assembler

Software

Microsoft Business Intelligence Tools, SSAS, SSIS, SSRS, SQL Server 2008 R2, PowerPivot, Business Objects XIR2, Data Integrator XIR2, Crystal Reports XI, Web Intelligence XIR2, Showcase Strategy, ESSBASE/400, JD Edwards OneWorld, HFA

Contact this candidate