Responsible for the installation and configuration of the Cognos software on both the production and development servers.  Migrated and upgraded all reports, Transformer models, PowerPlay cubes, directory server, portal security and macros to the new environment.  Added drill through capability for all of the PowerPlay cubes.

Developed PowerPlay cubes for tracking policy submissions, loss control representative performance metrics,  daily claims analysis and customer satisfaction survey results.

Performed validation to ensure that the upgraded Cognos software was compatible with SQL Server 2005 and 2008

Modified various reports and cubes to meet the requirements of the new Claim Center application

Converted all of the Data Transformation Services (DTS) packages to SQL Server Integration Services (SSIS) packages

Developed stored procedures used to populate the client’s data warehouse

Assumed responsibility for the development and support of the InetSoft reporting system

Created SSIS packages to extract agent and client relationship information that was used for authenticating access to an online claim inquiry system

Provided PowerPlay Web training sessions for the executives and managers to help them fully utilize the capabilities of the tool

Completely automated the process for running Cognos reports and cubes on a daily and monthly basis

Provided ongoing training and support to the client’s IT staff

Key member of a project team that was responsible for the implementation of a completely redesigned data warehouse and reporting system using the latest Cognos technologies

Heavily involved with the gathering and documenting of the business and reporting requirements 

Created ETL procedures for building dimension and fact tables using Data Manager for the Claims, Providers, Enrollment and Customer Service subject areas

Assisted with the design and development of the Framework Manager model used to support the reporting requirements of the data warehouse 

Created the technical specifications and assisted with the development of over 50 Report Studio reports 

Developed an Analysis Studio cube containing adjudicated claim information based on the business requirements

Created a Framework Manager model containing the metadata for the Bond Adapt Human Resource application.

 Developed a series of Report Studio reports based on the requirements of the Accounting Department

Completed an Executive Dashboard Proof of Concept utilizing Cognos 8 functionality.  

Developed complex reports utilizing ReportNet that contained multiple graphs, crosstabs, videos and lists of various Marketing Research information from different data sources.

 Developed PowerPlay cubes that consolidated information received from various marketing research vendors.

Created Framework Manager models to support the ReportNet reports and the data sources used to populate the PowerPlay cubes.

Developed ReportNet reports and PowerPlay cubes used for Revenue Planning and Price Promotions.

Developed PowerPlay cubes containing retail sales information that provided the capability to analyze the client’s sales volume by Brand, Geography, Distributor, Outlet and Consumer Group.

Used Metrics Manager to create retail sales scorecards that measure different KPI’s based on the requirements of the market area.

Developed PowerPlay cubes and ReportNet reports that were used to demonstrate the capability of the Cognos products to the Executive Group.

Developed PowerPlay cubes to track the effectiveness of the various Miller distributors throughout the country.

Developed technical documentation for all of the PowerPlay cubes, ReportNet reports and Framework Manager models.

Provided technical support and training to the client’s staff and external consultants on an ongoing basis. 

 Responsible for the development of PowerPlay cubes used for tracking Program Participation, Revenue & Usage and Rebate information from the client’s customer information database.

Developed PowerPlay cubes for tracking Time Reporting and Project Costing information using data extracted from the client’s PeopleSoft application.

Developed and modified numerous Impromptu reports that were used to extract detail level information associated with the summarized data selected in the PowerPlay cubes.

Assisted with the Cognos upgrades from version 6.6 to 7.1 and version 7.1 to 7.3.

Provided assistance with the administration of the PowerPlay Enterprise Server and the Impromptu Web Reports Server. 

Developed PowerPlay cubes containing financial information used by the high level executives of the company.

Assisted with the development and testing of ReportNet and Framework Manager.

Developed technical documentation for all of the PowerPlay Cubes, Impromptu Reports and Catalog.

Provided technical support and training to the client’s staff on an ongoing basis. 

 Responsible for the development of a master Customer Grading PowerPlay model that is used as the basis for specific theme cubes.  The client’s users select the dimensions, measures and user class security that should be included in the new PowerPlay theme cubes.

Developed PowerPlay cubes for tracking sales engineer and branch booking information for the client’s Canadian location.  The information was extracted from the client’s Siebel application.

Responsible for the implementation of a PowerPlay cube used to track attendance information for Commercial Sales Events.  The cube also provides the capability to analyze customer activity before and after the events to measure their effectiveness.

Developed PowerPlay cubes used by the Sales Management team to track their performance objectives and sales collaboration efforts.

Assumed responsibility for the ongoing maintenance and support of the Impromptu catalog used for reporting Point of Sale information.  The contents of the catalog were fully documented including the tables, columns, folders, joins, filters and user profiles.  The process for implementing user class security was also reviewed and documented. 

Created Cognos development standards and guidelines that will be used by the client’s IT staff for all PowerPlay and Impromptu applications.

Provided technical support and training to the client’s staff on an ongoing basis. 

Responsible for both project management and technical support for the implementation of distributor sales reporting via PowerPlay for one of the client’s fastest growing divisions

Developed a series of PowerPlay Cubes that were used by the Diagnostic Breakthrough Organization to formulate the company's strategic direction

Worked with key users from various departments to develop a comprehensive list of all existing reports.  This information was loaded into a PowerPlay cube and was a key tool in determining the reporting requirements for the new organizational structure.

Provided assistance with the upgrade of PowerPlay models and Impromptu reports to the latest versions of the Cognos products

Modified the client's contract management PowerPlay cubes to improve their functionality and  completed revisions to numerous PowerPlay Web reports to reflect the changes made to the cubes

Developed a series of Impromptu reports for extracting sales information used for generating PowerPoint presentations for the client’s field representatives

Created numerous PowerPlay Web reports that are used by the regional and district managers for conducting business reviews

Provided technical support to the client’s staff on an ongoing basis 

 Developed a PowerPlay cube used for tracking claims and warranty information for one of the client’s largest divisions

Conducted a performance analysis on a PowerPlay cube used by the client’s Generator division.  The recommended modifications resulted in an 80% reduction in the time needed to build the cube.

Developed a PowerPlay cube used for analyzing point of sales information for the client’s largest retail distributors

Worked with a national marketing firm to define the functional requirements for the development of PowerPlay cubes containing competitor sales and pricing information  

Corrected a problem with the PowerPlay cube used for monitoring claims and defects processed by the client’s Answer Center

Created extract files containing sales by destination and sales by shipping point information that were needed by the Tax Department

Developed an Impromptu report listing historical sales information for the client’s division in France

Used Impromptu and Excel to extract FSC/ETI Invoice Detail information needed by the Accounting Department

Assisted the Information Deployment Team with the completion of overdue projects

 Key member of the technical team involved in an Oracle 11i implementation

Responsible for the conversion of open invoices from the client's legacy system (PL/SQL, SQL*Loader)

Developed and/or modified approximately 100 Oracle reports (Reports 6i) for the following modules: Projects, AR, AP, GL, Order Management, Inventory, BOM, WIP, Purchasing, Shipping and Pricing

Created stored procedures and reports needed to implement an AutoCAD interface to the Oracle application (PL/SQL, Reports 6i, Access)

Developed and/or modified forms as needed (Forms 6i)

Provided ongoing technical support for the Oracle 11i application (TAR's, TOAD, SQL*Plus)

Developed specifications for reports developed by other members of the technical team

Provided 11i training and support for the client's technical staff

 Developed PowerHouse training materials

 Provided onsite training for QUICK, QUIZ and QTP

 Developed and/or modified approximately 100 Impromptu reports

Worked with the client's management staff to develop and/or modify numerous PowerPlay cubes (PowerPlay, Transformer, Impromptu)

Assisted with the implementation of PowerPlay Web and Impromptu Web on the client's intranet

Developed stored procedures to update an Oracle data warehouse containing SAP information (PL/SQL)

Assisted with the design and maintenance of the client's data warehouse

Provided training and technical support for the Cognos business intelligence products (PowerPlay and Impromptu) to the client's technical staff and end users

Key member of the project team responsible for the conversion and implementation of the MFG/PRO application (Progress)

Responsible for the conversion of service contracts, installed base machines, end users, customers, items and bill of materials (Speedware, Access, SigValet)

Worked with the client's management team to develop and/or modify screens and reports to meet their functional requirements (Progress)

Performed a detailed analysis of the client's complicated commission system

Converted numerous custom applications to become fully integrated with the MFG/PRO application (Progress)

 Provided training and support to the client's technical staff

Designed and developed a radio frequency application for picking, shipping and receiving items in the manufacturing plant (LXE, Protos, Quiz)

Modified and supported the client's manufacturing application (AMAPS, Protos, Quiz)

Responsible for the implementation of EDI required for the client's key trading partners

Heavily involved in the modification and support of the application used to track service contracts and medical equipment (UPTIME, Speedware, Cobol)

Modified and supported the client's order entry and financial application (MCBA, Speedware, Cobol)

Provided training and support to the client's technical staff

 Developed PowerPlay cubes used for analyzing the company's sales history (PowerPlay, Transformer, Quiz)

Heavily involved in the modification of a client's warehouse management system (HP3000, Powerhouse, Cobol)

Assisted with the implementation of an RF based data collection system (LXE, PowerHouse, Cobol)

Developed a system for maintaining tracking numbers and PRO numbers for the various carriers utilized by the client (PowerHouse)

Worked with the client's management team to develop over 100 custom reports (PowerHouse)

Developed an interface between the Vitreous Information System and the warehouse management system to ensure that all products were accounted for (PowerHouse, FTP)

Assisted with the conversion of the client's warehouse management system to SAP

Provided technical support for the warehouse management system while the client's staff was working on the SAP implementation

Implemented a fax-based ordering system that was integrated with the company's EDI system (TeleForm, Visual Basic)

Performed EDI mapping for the order entry system (Trading Partner, IBM Mainframe)

Provided oncall support as needed

Overall responsibility for management of Software Development, Micro Information Services and Operations areas

Project management for all software development activities

Responsible for providing ad hoc reporting and analysis capabilities for the organization utilizing products such as Impromptu, PowerPlay and Data Express

Coordinate the evaluation and selection of hardware and software for a wide-area PC network

Directing the Operations area to ensure continuous system availability and performance

Develop strategic plans consistent with the long-term objectives of the company

Perform systems design and programming tasks to meet project deadlines

Develop procedures to ensure that all regulated activities are in compliance with guidelines

Responsible for the installation and technical support of the Blood Operating System, an in-house developed application that was licensed to ten other blood centers around the world

Responsible for all software development functions including systems design, programming, validation, conversion and training

Played an integral role in the design and programming of a comprehensive Clinical Lab System

Provided direction to contracted consultants

Responsible for the installation and technical support of the Blood Operating System

Performed systems design, programming and validation for enhancements to existing applications

Responsible for the installation and technical support of the Blood Operating System

Performed system management functions including operating system upgrades, hardware configuration and performance analysis

Responsible for the implementation of a wide-area network to extend computer access to our fixed sites

Performed systems design, programming and documentation tasks in support of existing systems

Designed and implemented a system for tracking commercial products

Developed a comprehensive materials management system

Successfully installed a new financial accounting system

Responsible for the installation and support of the Blood Operating System

Provided oncall support on weekends and evenings for hardware or software problems

Performed systems design, programming, validation, conversion and documentation tasks during the development of the Blood Operating System

Developed interfaces for automated testing equipment

Provided oncall support on weekends and evenings for hardware or software problems

Responsible for all software development activities

Performed maintenance programming for existing applications

Developed financial accounting system for a multi-company corporation

Worked full-time while putting myself through college