SUMMARY:

I am an information technology professional who has provided innovative business solutions for many Fortune 500 and mid - market companies. I have 23 years of combined experience in the automotive, aviation, banking, distribution, logistics and manufacturing industries.

SKILLS:

Data Warehousing: Oracle Warehouse Builder 10g, Optum

Business Intelligence: Cognos Impromptu, Cognos ReportNet, Cognos 8 BI, Cognos 10 BI, Cognos Analytics, Cognos Framework Manager, Business Objects XI, Spotfire

Databases: Oracle 8i/9i/10g/11g, MS SQL Server, MS Access, ODBC compliant

Programming: C, COBOL, Pascal, SQL

Environment: AS400, UNIX/Solaris, HP3000, Windows NT, Windows Server

PROFESSIONAL EXPERIENCE:

Confidential, Cincinnati, Ohio

Senior Consultant

Responsibilities:

• As the BI lead developer I interacted with end users across the organization, drove business requirements, defined best practices and mentored all developers new to the project.
• I provided metadata modeling and report development for an Oracle data warehouse and collaborated with database and ETL developers to ensure reporting accuracy and consistency across multiple database environments.
• I developed reporting and metadata modeling standards as well as testing procedures to comply with the client’s data export control policies.
• I performed report migrations and version upgrades from Cognos ReportNet to Cognos 8 BI to Cognos 10 BI in the eight years I was engaged on this project.
• Many of the business requirements were fulfilled through the use of creative thinking and utilizing the capabilities of Cognos to the fullest extent.

Confidential

Solution architect

Responsibilities:

• I assisted in the migration of several servers for the Confidential Power division.
• I was responsible for providing effective communication between asset owners, application owners and internal team members to ensure successful server migrations.
• Daily responsibilities included answering technical questions, hosting meetings, scheduling migrations, tracking and updating servers in a collaborative environment.

Confidential

Data Analyst

Responsibilities:

• Responsibilities included gathering requirements, providing in depth analysis and identifying root causes across several key areas of the business.
• I created several interactive visualizations using Tibco Spotfire to present the analysis to the client.

Confidential, Cincinnati, Ohio

Consultant

Responsibilities:

• Provided all ETL development using Oracle Warehouse Builder 10g R1. Responsible for all related OWB functionality, including the creation of the warehouse project, runtime repository, source and target modules, file locations, schemas, as well as the extraction and transformation of source data in both development and production database environments.
• The marketing data mart contained several terabytes of data and encompassed several business divisions.
• The data from the logistics & manufacturing data mart was derived from seven different source systems.
• Pre-processing of all source files was performed through the use of Perl scripts.
• Created Autosys jobs in conjunction with the SQL Plus Exec template script to schedule the process flows created in OWB.

Confidential

Responsibilities:

• Assisted in the development and implementation of a data warehouse.
• Performed all ETL development using Oracle Warehouse Builder 10g R2.
• Responsible for Oracle 10g database creation and Oracle Workflow integration.
• Assisted in the development of Oracle OLAP dimensions and cubes.
• Provided Oracle Warehouse Builder 10g training to key personnel.

Confidential

Responsibilities:

• Assisted in the migration from Cognos ReportNet 1.1 to Cognos 8.1 BI.
• Responsible for all report migrations and validations.
• Provided Oracle Warehouse Builder 10g training and performed advanced report writing and catalog maintenance using Cognos Impromptu.

Confidential, California

Consultant

Responsibilities:

• Prepared facility for daily startup operations, responsible for all on site systems
• Supported a local area network running Windows 2000 Server and Windows NT 4.0
• Provided technical support to the warehouse operations using AS400
• Supported a radio frequency network using Teklogix
• Ensured report generation using Compleo, Arpeggio and MS Access
• Managed tape operations and off-site storage
• Created and maintained technical documentation
• Hardware support - Dell PCs, HP, Lexmark and Zebra printers
• Software support - Brio, Microsoft Office Suite, Lotus Notes, Rumba, Tandata
• Created Battery and Direct Conveyance Route databases using Microsoft Access

Confidential

Responsibilities:

• I developed this database to ensure accurate battery rotation and maintenance for all powered equipment in the facility.
• This database replaced the manual method of writing information into a log book.
• The database tracks the equalization status and water level of the battery and informs the user if maintenance is required.
• It tells the equipment operator which battery to pull from the charging station depending upon the station, battery type and duration of charge.
• The employee information is gathered by using a card reader and the remainder of the data is scanned into the database by bar codes, such as the battery station, the equipment id and the battery id.
• It also contains reports that allow maintenance personnel to track the maintenance history, location and status for each battery. Security features prevent unauthorized users from accessing the database main menu.
• I developed this database to track inbound and outbound shipping conveyance in order to report accurate case counts, track outbound destinations and measure the elapsed time for each transaction. This database provides analytical reports and allows management to input targets to measure employee performance.
• Users can remain seated on their equipment. All data is gathered by scanning bar codes for user id, transaction type, destination(s) and case count per destination and has the ability to complete or reset the transaction without the use of a keyboard or mouse.

Confidential, Hebron, Kentucky

Application Support Engineer

Responsibilities:

• Supported a warehouse management system running on an Oracle/Unix platform
• Maintained warehouse control and transportation management system interfaces
• Investigated and resolved data integrity errors
• Collaborated with management staff to improve existing processes
• Provided analytical report writing using Oracle SQL Plus
• Responsible for the testing and implementation of all system patches
• Created International Organization for Standard (ISO) compliant technical documentation
• 24-hour system support
• Created Label Tracking database using Microsoft Access

Confidential, Cincinnati, Ohio

Network Control Supervisor

Responsibilities:

• Supervised a technical staff supporting an electronic fund transfer network
• Provided technical support for thousands of merchants and financial institutions
• Responsible for diagnosing and resolving hardware and communication failures
• Coordinated the daily activities for system maintenance and upgrades
• Interviewed and hired employees
• Evaluated and ensured employee performance