Derek Olin

Derek Olin Email and Phone Number

Systems Analyst | Senior App. Developer | Integration Lead | ETL Developer | MDM Lead | Data Warehouse | UNIX|Salesforce @ Pacific Life
newport beach, california, united states
Derek Olin's Location
Orange County, California, United States, United States
Derek Olin's Contact Details

Derek Olin work email

Derek Olin personal email

n/a
About Derek Olin

Systems Analyst with deep experience designing mapping documents, interfacing with business and multiple departments, driving the whole SDLC from Design through to Production.

Derek Olin's Current Company Details
Pacific Life

Pacific Life

View
Systems Analyst | Senior App. Developer | Integration Lead | ETL Developer | MDM Lead | Data Warehouse | UNIX|Salesforce
newport beach, california, united states
Website:
pacificlife.com
Employees:
3376
Derek Olin Work Experience Details
  • Pacific Life
    Data System Analyst
    Pacific Life Sep 2018 - Present
    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.
  • Capital Group | American Funds
    Senior Application Developer, Etl And Master Data Management Integration Lead
    Capital Group | American Funds 2015 - 2018
    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.
  • Capital Group | American Funds
    Senior Application Developer, Salesforce Crm Etl Lead Developer
    Capital Group | American Funds 2006 - 2015
    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.
  • Toyota Financial Svc
    Technical Integration Lead
    Toyota Financial Svc 2005 - 2006
    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.
  • Mitsubishi Motors
    Senior System Specialist
    Mitsubishi Motors 1997 - 2005
    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.
  • Brock Control Systems
    Senior Crm Professional Services Representative
    Brock Control Systems 1994 - 1997
    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.

Derek Olin Skills

Oracle Database Software Development Life Cycle Communication Stored Procedures Personal Development Business Requirements Sql

Derek Olin Education Details

Frequently Asked Questions about Derek Olin

What company does Derek Olin work for?

Derek Olin works for Pacific Life

What is Derek Olin's role at the current company?

Derek Olin's current role is Systems Analyst | Senior App. Developer | Integration Lead | ETL Developer | MDM Lead | Data Warehouse | UNIX|Salesforce.

What is Derek Olin's email address?

Derek Olin's email address is de****@****ife.com

What schools did Derek Olin attend?

Derek Olin attended University Of California, Santa Cruz, Ucla Extension, Pasadena City College, Pasadena High School.

What skills is Derek Olin known for?

Derek Olin has skills like Oracle Database, Software Development Life Cycle, Communication, Stored Procedures, Personal Development, Business Requirements, Sql.

Who are Derek Olin's colleagues?

Derek Olin's colleagues are Michelle Nieman, Seth Allen, Ashleigh Long, Sabria Kumagai, Chris Aguirre, Sara Jones, Fernando Ramos.

Not the Derek Olin you were looking for?

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.