Executive Summary

• Data warehouse architect with fifteen years experience in data collection, transformation, loading and information retrieval to end consumer specification.
• Highly motivated team player with over twenty years experience with information systems design through implementation and support.
• History of building strong customer relationships through timely, honest communication and providing the best possible solutions within time and budget parameters.
• Established track record of performance for determining and executing innovative data conversion / data manipulation projects critical to company objectives, without degradation of data integrity.

Professional Experience

Confidential

Confidential

SVP Worldwide is an international company specializing in the design, manufacture and distribution of consumer sewing, quilting and embroidery machines under the brand names, SINGER , HUSQVARNA VIKING and PFAFF .

Data Warehouse Architect

• Performed as a Data Warehouse Architect supporting SVP's financial analysis, budget, forecast and sales reporting systems.
• Developed tested and supported nightly load processes to consolidated daily sales reporting from diverse ERP systems to provide global sales reporting from 31 legal entities. Nightly refresh of sales data is completed in less than 2 hours.
• Developed and supported monthly sales load processed from Excel spreadsheet data supplied by 3 legal entities with proprietary ERP systems.
• Lead support of worldwide consolidated daily sales report suite which is distributed to 95 recipients, including senior management.
• Developed and supported processes to combine monthly forecast data from multiple locations around the globe to provide forecast complete reporting
• Developed database structure required to support sales, budget, product cost and forecast analysis reporting using MicroStrategy.
• Lead support for reporting community with more than 95 users from finance, sales and forecasting areas.
• Upgraded MicroStrategy software to several product releases from 8.0 thru 9.3.1.
• Developed many SQL queries to user specification to fulfill ad-hoc data needs.
• Created Excel workbooks with SQL embedded queries to provide custom data extracts to fulfil specific analytical needs of various business owners. The data selection criteria is changed and refreshed by the business owners.

Software and Tools

SQL server 2000 2005, T-SQL IBM iSeries query and scheduling tools, MicroStrategy business intelligence and Microsoft Office products. Various ETL tools including: SQL Server DTS, IBM Ascential DataStage.

Confidential

MTD Products is worldwide leader of outdoor power equipment for lawn, garden and snow removal under private labels and brand names including: Bolens , Cub Cadet , MTD , MTD Pro , Yard Machines , Yard Man and White Outdoor .

Data Warehouse Analyst

• Performed as a Data Warehouse Analyst supporting MTD's financial analysis, sales, inventory and manufacturing component tracking reporting systems.
• Lead report developer and support for reporting community. More than 75 users from finance, manufacturing, quality control, sales and forecasting areas.
• Automated creation and distribution of the manufacturing component serial number tracking reporting. This reporting package summarizes the effectiveness of each production line in capturing component serial numbers during the assembly process.
• Assumed primary responsibility for supporting Cognos Impromptu production scheduler and supporting the report writing needs of the Impromptu user community.
• Responsible for creation and distribution of the daily sales reporting package. The daily sales report package is distributed to over 150 recipients including senior management.
• Primary responsibility for item maintenance and item hierarchy for the data warehouse. Reduced nightly item load run time from 85 by processing only item additions and changes.

Software and Tools

Oracle PL/SQL, Cognos Impromptu and Cognos Web business intelligence and Microsoft Office products.

Confidential

Cole National was acquired by Luxottica in October of 2004. Luxottica absorbed Cole National's Headquarters and Data Center operations located in Twinsburg, Ohio, and relocated these activities to its new Headquarters in Mason, Ohio. Was offered a position to relocate, but could not because of family commitments. Was subsequently sought out by Luxottica to perform on an Independent Consulting basis.

Confidential

Cole National Corporation was an optical retailer, with stores in Sears , Target , BJ's Wholesale Club , company owned, Pearle Vision and Pearle Vision franchise locations the and the Caribbean. Cole National was acquired by Luxottica in October of 2004.

Data Warehouse Analyst

Performed as a Data Warehouse Analyst supporting Cole National's entire suite of retail vision operations through all phases of development and post implementation support. An integral member of data warehousing team supporting several significant data warehousing initiatives.

• Cole National data expert working with NCR Teradata consultants in designing and implementing new centralized manufacturing replenishment system.
• Member of team developing data warehouse containing multiple dispensing systems sales data as well as manufacturing data in common format allowing centralized reporting of multiple business units and manufacturing data.
• Luxottica Conversion: Key information resource in reshaping Cole data into Luxottica attributes and metrics to feed Luxottica sales, financial, field reporting and replenishment systems.
• Developed user defined physical inventory vs. sales and manufacturing data which was used in defining / refining retail store inventory levels and assortments.
• Created innovative query data delivery solutions matching user needs with desired data delivery vehicle. This included ad-hoc query developed using Cognos Impromptu and MicroStrategy to user defined Excel spreadsheet template.

Project Leader

Managed a team of three persons, in-house employees and contractors, responsible for refining and validating a dispensing system data mart on an AS/400 platform during conversion from and IBM 3090 platform. Led design team in the creation of a manufacturing system data mart integrating the dispensing sales data with the corresponding centralized manufacturing data mart.

• Developed and implemented sales analysis and financial reports using Cognos Impromptu report development tool.
• Developed creative solution to schedule and automate Cognos Impromptu reports delivered in Microsoft Excel spreadsheets to company servers. Integrated Robot Client to allow computer operations staff to control and monitor report creation activity through existing AS/400 based scheduling software.
• Directed activities to develop and implement end user reporting for many functional areas of the company including: finance, sales audit, loss prevention, audit services, real estate development and marketing departments.
• Identified the source of a 3.5 million annual inventory shrinkage , defined changes necessary to implement the go-forward solution.

Software and Tools

• IBM iSeries DB2, iSeries QM Query and Robot scheduling tools, MicroStrategy business intelligence and Microsoft Office products. IBM Ascential DataStage ETL
• Confidential. was a large retail drug store chain with 2,500 stores in the U.S.A. which was acquired by CVS Corporation in 1997.

Project Manager

Managed a team of five persons responsible for collecting customer profiles and dispensing history data from acquired pharmacies and loading this data into Revco's proprietary pharmacy system.

• Directed activities to collect and convert customer profiles and dispensing history data from 442 acquired pharmacies throughout the Unites States.
• Managed acquisition team resources to schedule and successfully complete 96.7 of the data collection and conversion requests from corporate and regional management.
• Prepared the weekly conversion status report for corporate and regional executives.
• Provided verbal project status updates to regional and store personnel during the data collection, data conversion and start-up phases of each pharmacy conversion project.

Software and Tools

Easytrieve query tool for mainframes, MicroStrategy business intelligence and Microsoft Office products. IBM Ascential DataStage ETL