Winery Exchange purchased Reiser Reports in 2001, creating a team to develop and operate a new division of their company called TradePulse. TradePulse is a multi source web hosted report repository targeting medium to small size suppliers in the wine and spirits industry. I was contracted for six years to be a member of both the development and operations teams. The organizational structure of TradePulse is Weak Matrix. While TradePulse has a development team, that development team may require the services of members of the operations team. The project manager must coordinate with the production managers to ensure that development projects are completed without the undue interruption of production. I was responsible for providing Industry Knowledge & Expertise, Database Knowledge & Expertise, Product Specifications and Operational Support to the TradePulse teams. I was a senior member of the teams, providing leadership to the teams even though I was not in a formal position of authority. Some of the projects are detailed below:
Project / Create the TradePulse database – Worked with Winery Exchange's technology team to create the new TradePulse database. Using the old Reiser Reports' database as a starting point, we created a new SQL Server database incorporating new fields and tables used to manage the expanded scope of the project. I was able to export from dBase all the historical data that I had received from Southern Wine & Spirits.
Project / Create the TradePulse report set – I worked with the report developer contracted to build the TradePulse version 1.0 report set. The reports were developed using the Crystal Reports development software. This software operated very much like R&R Report Writer, the development tool that I had used with Reiser Reports. The TradePulse version 1.0 was an on-line version of the original paper reports that were used at that time.
Project / Collect data from distributor partners of Coppola – Each new distributor partner required a detailed data request defining each element of data required to produce reports for Coppola. Once the distributor had furnished the data dump file, we had to create a map for the data and a programming package to be executed to read the data dump file and create new data records in the production database. Each new distributor partner was considered a new, unique project.
Project / Code all Coppola products in the system – For each new distributor partner, we were required to properly code each distributor's product codes into product groups as defined by the supplier, Coppola. It was my job to verify that the coding work was done correctly.
Project / Implement all Coppola reports in the system – The process of implementing each new market for Coppola was very time consuming. The set of report templates was copied, and each report within the report set had to be modified in the parameters section. Based on my feedback of the process and my proposal for change, this was a manual procedure that was modified in subsequent report releases.
Project / Breakout National Account Reporting – In response to the advancing needs of the clients, we needed to expand our system's functionality. Our clients wanted to better manage their relationship with the major national restaurant chains. Our answer was to create National Account groups within TradePulse. I lead a team of temp workers that we contracted to clean up and code existing retailers into National Account groups.
Project / Combo Code Conversion – Some distributors use combo codes to sell and deliver a variety of products for suppliers. This created issues within the supplier when individual components of the combo are not combined with the standard product codes. We needed to develop SQL code that could maintain a count of combos sold, yet also report the components with the proper products. I supplied the database technical expertise and knowledge needed to develop the processes, I implemented the processes, and I verified that the code operated correctly, manually checking the results.