Jeff Andersen Email & Phone Number

ETL process design and development to provide e-book retail sales data to the Oracle financial system and the data warehouse.

Team lead for the Futures and Foreign Exchange group in the migration from FMC Pacer to SimCorp Dimension through the UAT, cutover and post-cutover phases; coordinated the validation of SimCorp system functionality, converted data, inbound/outbound data-flow processes and management reports.

Assigned to the Mars Incorporated Data Warehouse department, I was on a 2 person team that provided Business Objects administration and support services to all of the North and South American business units.Responsibilities included: support and administration of the Business Objects application and servers, diagnosing and assisting in the resolution of IT.

As a programmer/analyst assigned to the Shell Canada EP Blueprint project, I was responsible for extracting Plant Maintenance data from JDE and organizing it for loading into SAP, including records representing Work Orders, Functional Locations, Bills of Materials, Task Lists, Long Text Attachments, etc.Responsibilities included: meeting with business.

As a programmer/analyst assigned to the Shell Canada Data Warehouse department, I was responsible for designing, building and maintaining interfaces that transfer data periodically to and from numerous sources. I was required to analyze the structure and content of a given data source and then bring that data into the data warehouse organized in such a way.

As the ETL Specialist assigned to the implementation of a Customer Information File (CIF) for Alberta Treasury Branch (ATB), I was responsible for the one time migration of customer account and personal data from each of ATB’s product focused banking systems. In addition, I am nearing the completion of an assignment to design, program and automate the.

Led a 4 person team of programmer analysts in the extraction and conversion of data from three legacy systems: Oracle on Solaris, Oracle Financials on Solaris, and DB2 on AS/400 to be loaded into an enterprise-wide PeopleSoft Financials and CRM system.Responsibilities included: business requirements gathering and documentation, data modelling, data.

Designed a custom VisualBasic on Oracle 7 (client/server) Task Management System to replace a Tibco InConcert Workflow system. The new system incorporated reminders and activity logging into the existing province-wide customer management system, and also provided users with a 50-fold increase in response times over the old system which allowed users to.