Derek Olin Email & Phone Number

Southern California

Detailed design of multiple integration processing with Life and Mutual Fund applications. Author of detailed mapping specifications for Informatica PowerCenter development. Design/coordinate Quality Assurance testing, project management full SDLC. Designed detailed integrations with Peoplesoft GL. Performed data analysis ensuring accurate processing, relational integrity, error processing, restartability and visibility of behavior of the nightly cycle. Provide visibility of data foot print at each step of the integration to yield a verifiable, auditable, robust integration processes. BMC Control M Scheduler Design.

Irvine, Ca

Technical lead responsible for overall design and approach of loading data into a Informatica Master Data Management application. Lead developer having oversite of all mappings using PowerCenter 9.6 and LINUX. Production support of MDM application that keeps up to date marketing and sales data supporting business operations with $1.6 trillion assets under management. • Provided critical business capabilities such as deduping and determining the most reliable data from various sources.• Designs overall batch cycle under Autosys Job Scheduler, reducing run time by 30%.• Designed reusable delta processing framework to capture insert, update and delete events. Configuration of MDM schema, mappings and batch groups. Programmed Java cleanse functions integrating with MDM, to standardize data before update in MDM.• Coordinated multiple teams including Architecture, Quality Assurance and Business Users to deliver clean, deduped, customer data to the business.• Modified Java RESTful Web Service modification to support real time calls to MDM.• Utilized Splunk log monitoring to troubleshoot and solve complicated production issues.

Irvine

Lead developer integrating Salesforce with multiple external applications. Performed Salesforce configuration, schema modification, validation rules as well as batch compliant Apex batch routines.• Initial migration of Siebel CRM to Salesforce and subsequent ongoing modifications to Salesforce schema, and ETL processing. • Designed and programmed complete ETL job streams, including PowerCenter 9.1, Autosys Job Scheduler and LINUX scripting. • Designed robust error handling routines ensuring every record is accounted for, providing visibility to data exceptions. • Enabled 1000+ business users to have high availability access to accurate view of Accounts and Contacts data.

Torrance, Ca

High visibility Technical Integration Lead with accountability over implementation of new Recovery Management project involving multiple software engineers. Integration between a custom Recovery Management System with multiple boundary systems including : Shaw Retail Loan/Collections, LeaseMaster and Siebel utilizing Informatica Powercenter, Oracle and TIBCO middleware. Responsibilities include: Low level interface design, batch performance, job dependencies, data integrity, exception handling, alert/escalation procedures, complete system documentation and ensuring high data availability. Close interaction with multiple internal departments and outside vendors to ensure deliverable deadlines were achieved.

Cypress, Ca

Technical Architect in support of a 400 user Siebel 7.5 CRM Call Center. Main duties include: Screen Configuration, Work Flow, Business Service and eScrpt programming. Created AIX shell script temples used by five developers in batch EIM processing. Programmed Oracle PL/SQL stored procedures, extracting fulfillment requests to outside vendors. Designed and monitored EIM scripts importing data into Siebel. Audit of Batch processes to maintain data accuracy.Technical Architect Epiphany Data Warehouse/Analytic Platform. Team Lead over large Data Warehouse utilizing MS SQL Server/T-SQL. Designed star schemas to accurately render multiple fact and dimension relationships. Created measures, aggregates, attributes and filters in presentation layers to satisfy complex business requirements. Supervised team of four developers. Developed programming standards used throughout Mitsubishi.

Southern California Area

Design, implementation and customization of Brock CRM application for multiple clients including Mitsubishi Motors (Cypress) and Balboa Capital (Irvine). Extensive SQL/PLSQL programming using Oracle and Informix data bases. Advanced UNIX scripting to automate routine file processing and transfer tasks. Programmed modules using the C language to store BLOB object inside an Informix DB.

Bachelor'S Degree, Psychology

Graduated with Honors

Computer Science

Coursework in: UNIX, C, Pascal

Associate Of Arts - Aa, Music/Computer Science

Diploma, Physical Sciences, B