SUMMARY:

• Information Technology Professional with a diverse business and technical background. Proven track record of assisting and leading organizations in meeting their business and financial goals (including cost - out initiatives). Ability to effectively communicate Information Technology issues in varying degrees of detail to all levels of personnel within an organization. Excel in areas where strong team-working and thorough communication skills are required. Experienced in manufacturing shop-floor operations through the use of ERP systems, with an emphasis on process improvements. Results-driven project manager and leader on projects of varying levels of complexity. Customer and quality focused with an intense drive for achieving results. Strengths in the following:
• Project Management
• Team Building/Leadership
• Business Intelligence
• Data Warehousing
• Enterprise Resource Planning
• Application Development/Integration
• Data Modeling
• Database Administration
• Training Documentation

TECHNICAL SKILLS:

Business Intelligence: Data Modeling, Cognos Impromptu, PowerPlay Transformer, Metrics Manager, Framework Manager, ReportNet, QueryStudio, ReportStudio, Cognos 8, SAP BI

Data Warehousing: DecisionPoint data warehouse, SCT Banner Operational Data Store (ODS) and Enterprise Data Warehouse (EDW), Oracle Warehouse Builder, Microsoft SSIS, ETL

Databases: Oracle, Microsoft SQL Server, Microsoft Access, DB2, SQL*BackTrack, Oracle Enterprise Manager, SQL*Plus, PL/SQL, ERwin

ERP s: Oracle Applications, SunGard Banner, SAP

Operating Systems: HP-Unix 11i, Sun Unix, Microsoft Windows 95-XP, IBM AIX

Application Development: Unix shell scripting, Access Visual Basic, APL, development life-cycle, PL/SQL, ABAP

Web Development: HTML, Active Server Pages (ASP)

Office Automation: Microsoft Word, Excel, PowerPoint, Access, Project, Visio

Functional: 5S, Value Stream Mapping, Lean Manufacturing, Change Management, Six Sigma, Sarbanes-Oxley, Requests for Proposal (RFP)

PROFESSIONAL EXPERIENCE:

Confidential, Benton Harbor, MI

Business Intelligence/Data Warehouse Architect

• Created and set strategic direction for an enterprise Business Intelligence (BI) environment utilizing the Cognos suite of tools as well as a “home-grown” data warehouse utilizing Microsoft SQL Server Integration Services (SSIS)
• Project Managed a team of 20+ functional and technical personnel in the upgrade of the Banner ERP
• Led the definition and implementation of architectural and developmental best practices with the LINUX, Oracle RDBMS, and SQL Server environments
• Supervised the work of external consultants in aspects of BI and database administration
• Set strategic direction and managed the enterprise ERP upgrade to Oracle 11g

Confidential, Kalamazoo, MI

Data Architect

• Led enterprise initiatives to upgrade university’s BI environment to Cognos 8 and SunGard ODS/EDW 8.1
• Architected/implemented the Cognos ReportNet, Framework Manager, ReportStudio, and PowerPlay environments as well as defined security policies for access to approximately 500 users.
• Utilized SunGard Banner’s Operational Data Store (ODS) as the main data source for creating the Framework Manager data models to be utilized by on-campus report developers.
• Defined business requirements and recommended improvements to SunGard’s Enterprise Data Warehouse (EDW) product.
• Architected business score-carding solutions for senior management utilizing Cognos Metric Designer/Studio.
• Led cross-functional BI team of 12 individuals in the definition, development, and implementation of BI solutions to meet the needs of personnel at all levels of the organization throughout the university.

Confidential, Galesburg, MI

Data Warehouse Manager/Business Intelligence Analyst

• Led 2-year effort, based on a $250K budget, to upgrade EDW to extract data from an Oracle Applications 10.7 to 11i environment. ETL logic included Oracle modules Accounts Receivable (AR), Bills of Materials (BOM), Inventory (INV), Order Entry (OE), and Purchasing (PO).
• Managed ETL and development life cycle of approximately 35 EDW business domains, sourcing data from the Oracle Applications (ERP), with a staff of 6 people. Responsible for the design, definition, and modification of 100+ data models used to define star schema domains in EDW.
• Developed, tuned, and validated Oracle Application (ERP) ETL logic. Defined Cognos Impromptu catalog and ReportNet package data models sourcing data from the Oracle Applications.
• Established IT internship program with WMU which led to eventual hiring of 2 people. Supervised EDW and BI development efforts of 3+ consultants.
• Defined EDW and Cognos BI security models in accordance to Sarbanes-Oxley requirements. Included the development of web-based access request forms utilizing HTML and ASP development.

Database Administrator

Confidential

• Led a functional team of 16+ people in the upgrading of the Oracle Applications environment to a new database release as well as the application of a latest set of mega-patches to ensure a flawless go-live launch to 3 manufacturing sites impacting 150+ users.
• Developed 24x7 availability and disaster recovery processes/procedures for Oracle Applications environment. This included utilizing fail-over technology in the case of hardware failure and database recovery in the case of software malfunction or user error.
• Developed and implemented a Performance Management System for annual performance reviews with Human Resources, impacting 700+ employees. Led 8-member team of peers to identify and recommend methods to improve inter and intra departmental communication to senior management.
• Stream-lined and formalized end-user Oracle problem reporting system through the use of a centralized help desk, a formal change management process, and the establishment of Service Level Agreements.

Confidential, Portage, MI

System Integrator/Developer/Database Administrator

• Implemented a "Process Data Historian" (CIM/21) to record process control parameters throughout division.
• Installed, configured, and designed Microsoft SQL Server and Oracle databases.
• Developed Divisional client/server database and supervised ~6 consultant and contractor developers.
• Used ERwin for data modeling of various databases used for client/server applications
• Established IT internship program with Kalamazoo College. Mentored hired interns.

Computer Systems Engineer

Led effort to install, configure, and maintain a Divisional Local Area Network (LAN) for 700+ network clients and 10+ database and file servers with a team of 4 people. Also led effort to upgrade from Microsoft LAN Manager to Windows NT Advanced Server.

Systems Analyst

Designed, developed, and implemented divisional business information systems which emphasized chemical inventory, production planning, bulk chemical packaging, and forecasting operations. Also performed material planning and production scheduling for 8 different products manufacturing in 3 separate facilities.