Business Intelligence Project Management

Robert W. Coen, Jr.

**** ***** ******

Homewood, IL 60430

Home: 708-***-****

Cell: 708-***-****

******@******.***

OBJECTIVE

Seeking a full-time business intelligence position where I can utilize and enhance my technical, troubleshooting, and managerial skills leading to an opportunity for success and career advancement.

EXPERIENCE

St Paul Lutheran Church and Preschool, Matteson, IL

Head Elder (1/2014 – present)

Leading a team of twelve, assisting Pastors, and managing worship operations

Active member of Board of Directors, Leadership Team, and Missions Board

Key member of the Technology team running business intelligence, soundboard, computer setups, and troubleshooting

Habitat for Humanity, Chicago Heights, IL

Project Coordinator (3/2011 – 11/2013)

Manage and assist volunteers to match their talents to current open projects

Successful completion of ten homes

Business Intelligence Group, Ltd.

Independent Consultant (1/2009 – 9/2010)

Business Intelligence consulting

Successful completion of projects for pharmacy software and accounting firms

Hewitt Associates (now AON), Lincolnshire, IL

Senior Business Intelligence Manager, GBS Financial (8/2006 – 6/2008)

Oracle DBA for Computerized Facility Management system

Process automation uploading TM1 from data warehouse

Designed and developed business intelligence to inform management of their financial standing, computer usage, and meeting room usage information from TM1 and the data warehouse

Business Intelligence Manager, Real Estate Strategy and Planning (4/2002 – 8/2006)

Key initiatives included:

Built data warehouse and ETL automation for cost allocation processes

Software enhancements including implementation of Crystal Enterprise, CIFM (FIS/FAMIS) version upgrade, and certification of all RE software for firm-wide operating system upgrade

Created dashboard web page GUI using Dreamweaver, HTML, and ASP for report distribution

Implemented Crystal Enterprise dashboard

Design and implementation of Lotus Notes Splash Pages

Firm wide virtual employee/new hire process project

Reporting Specialist, Real Estate Practice (9/1999 - 4/2002)

Project technical lead responsible for the entire project plan, timeline, and execution

Interacted with upper level management to determine needs and create BI reports giving RE leadership information to successfully run their business

Setup Crystal Reports to run against PeopleSoft FN7.5, CIFM, EBMS, Remedy (ORG), and Lotus Notes on Oracle and Informix platforms

Business Systems Analyst, TBA Technology Practice (4/1998 – 9/1999)

Completed reporting projects for BP Amoco, Boeing, Chrysler Canada, Dayton Hudson, and Monsanto.

Created query based extracts passed along to Hewitt’s form design team for creating client participant communication forms with a focus on business intelligence and technology

Created stand/alone extracts for clients and vendor use

Robert W. Coen, Jr. – Page Two

Systems Developer, TBA Technology Practice (5/1997 – 4/1998)

Completed projects for our Diamler Chrysler client.

Extensive knowledge of COBOL/Object Oriented Cobol (COOL) programming and Human Resources methodologies and practices

Worked with a variety of client Health and Welfare plans and Defined Benefit plans

Created programs to extract client data from Total Benefits Administration system for synchronization with client HR tracking system and various client participant forms

Andersen Consulting (now Accenture), Chicago, IL

Programmer (2/1997 – 5/1997)

Completed year 2000 compliance projects for Allstate Insurance.

Extensive assembler programming, methodology, and organization

Became MS Access application expert within Claims department in charge of setup, maintenance, reporting, and training on client issues database

Analyst (6/1996 – 1/1997)

Setup mainframe environment and became application expert for usage of System Vision and PM/SS for analysis of year 2000 compliance of all claims related mainframe software

Extensive element analysis, focusing on element inventory and date logic

Team tasks and challenges documented in an article by The Wall Street Journal

Elek-Tek, Inc., Rolling Meadows, IL (10/1995 - 6/1996)

Sales Consultant

Hardware and software consulting, sales, and post-sales support

EDUCATION

Bradley University, Peoria, IL

Bachelor of Science: Business Management and Administration

COMPUTER SKILLS

Operating Systems

Windows XP-10, Windows Server, WHS 2011, MVS, VM, SCO UNIX, Linux

Languages

PLSQL, MySQL, HTML, Object Oriented Cobol (COOL), COBOL, JCL, BASIC, Assembler

Databases

Oracle, SQL Server, DB2, Informix, Lotus Notes/Domino Design, Remedy, IMS, and MS Access

Software

Event Business Management System, Computerized Facility Management system, PeopleSoft Financials, PeopleSoft Query Tool, TM1, Control It, Dameware, MS Office, MS Project, MS Front Page, Brief, Rumba, Dreamweaver, MapPoint, Project Workbench, Groupwise

Business Intelligence

Crystal Reports, Crystal Enterprise, Business Objects, Cognos

TRAINING

People Soft - Budgets Explorer, Financials, Project Costing, SQL/SQR; Business Objects – Basic, Advanced, Enterprise Administration, Enterprise Web Development; Oracle – SQL; Dreamweaver – Intro and Advanced; Methodologies – Business Needs Modeling, Activity Modeling, Logical Data Modeling; Project Management: Intro and Framework for Success

HOBBIES

Building computers, networking, streaming, Kodi, Hyperspin, security surveillance, youth internet safety, smart phone management, technology

Contact this candidate