Warren K. Email & Phone Number

Providing facilities and expertise to all areas of Pinewood Derby Car building and racing.

Minnetonka, Minnesota, United States

• Migrate the Cornerstone DataStage sequences and supporting jobs from version 11.3 to version 11.7, which reduced monthly bill back for DataStage usage.
• Performed technical review of changes between the versions and which type of stage would need to be modified.
• Identified some detailed process changes that would be needed to allow the new version to function correctly due to some technical behind the science changes to the stages. The 11.3 version has different default.
• Performed the technical Proof of Concept to demonstrate that the migration could be done in a direct manner.
• Worked with off-shore team members to bring them up to speed on the steps needed for the migration effort.
• Worked with Corporate Application Support to resolve some issues outside the scope of the DataStage Migration.

Oakdale, Minnesota, United States

• Developed a cohesive data model of the POS data from thousands of convenience stores using a common loyalty system for promotions and vendor reimbursement system.
• Implemented streamlined PostgreSQL functions to speed up the real time processing of loyalty transactions from the store POS systems. This allowed for the growth from 23 promotion types to 60 types.
• Implemented specialized PostgreSQL functions and C programs to handle pay-at-the-pump and pre-pay situations to properly display the actual discounted prices on the pump and handle over payment if a pre-pay.
• Developed SQL functions to update PostgreSQL databases to provide summarized business views.
• Performed Analysis and created data-mart tables of data from source data for rapid reporting.
• Redesigned the processing of nightly loading of the individual store transactional data in XML to load into a cohesive data model. This reduced the nightly load time by 8 hours and increased the data quality so the.

Greater Minneapolis-St. Paul Area

• Digi-Key (Contractor) June 2019-Present Senior Data Analyst
• Developed SQL for Informatica jobs to load multiple source data into a Business Intelligence Warehouse to provide business views.
• Performed Analysis and created update request documents for migration of data from source system through staging and into the warehouse.
• Mentored internal staff on advanced SQL practices.
• Migrated legacy C++ programs to supportable PL/SQL and Informatica processes to load forecast data into warehouse.
• Generated SQL to allow for Informatica migration from non-normalized data structures to support newer normalized schemas.

Shoreview

Develop DataStage sequences and supporting jobs to load multiple source systems’ data into a Business Intelligence Warehouse to allow Cognos to provide business views. Generated combined corporate wide manufacturing reporting information and several other summary table generation processes.Mentored internal staff on the best practices for DataStage and.

Eden Prairie

Develop DataStage sequences and supporting jobs to load pharmacy claims data into a summary business view and updating the data refresh log tables, which spurred the rewriting of several other summary table generation processes Create datasets in the same hash method and sort as they are next needed to avoid re-hashing and sorting Responsible for proper.

Hopkins

Decision Support Systems/Data Warehouse

Innuity provided small- to medium-sized companies Web services, including creating and hosting web sites, online stores, and online transactions through an Oracle-based patented workflow processing system that automates the fulfillment of any type of electronic product.Architected multiple databases to increase efficiency and improve productivity in.

Technical and project lead for primary analysis and design of corporate Information System projects that encompassed all phases of the development cycle which included data architecture and design, data analysis and conversion and project management.