Summary
Overview
Work History
Education
Skills
Timeline
Generic
Thomas Clougherty

Thomas Clougherty

Sunny Isles,FL

Summary

Thomas is Senior Informatica Developer with more than twenty years of professional technical experience implementing various Informatica Cloud & On Premise, Oracle, and Microsoft projects. He is knowledgeable of multiple cloud solutions and database management systems, having completed dozens of successful projects including Oracle, Microsoft, and Amazon technologies. His background includes consulting and technology integration for Fortune 500 Companies. Vertical industry experience includes Hospitality, Health Services, Pharmaceutical, Insurance, Life Sciences, Consumer Goods and Financial Services.

Overview

33
33
years of professional experience

Work History

Lead, Siebel Developer

ViaCord LLC
  • Medical Research Company, automation project for Siebel Call Center consisting of two phases, Products/Database: Siebel Call Center 7 & 2000 / Microsoft SQL Server
  • Developed and implemented lead automation for multiple channels and all stages of the opportunity cycle for Marketing, Sales and Customer Service departments
  • Customized SQL Server DTS jobs and SQL scripts for automatic import and assignment of Web based inquiries
  • Customized Assignment Manager and Visual Basic code for automatic assignment of BRC leads from the Data Entry team
  • Developed routing rules for inbound 800 call center referrals
  • Development involved the configuration of several new Workflow Process components using Siebel Tools
  • Reconfigured the multi-channel lead distribution including EIM, Assignment Manager, Workflow Manager, Assignment Attribute Extension, Smart Scripts, User Interface Configuration and Extension of SQL Server database.

Software Development

Information
  • Firm specializing in Data Modeling tools

Senior Informatica Developer

The Pennsylvania State University
04.2022 - Current
  • With more than twenty years of professional technical experience implementing various Informatica Cloud & On Premise, Oracle, and Microsoft projects
  • He is knowledgeable of multiple cloud solutions and database management systems, having completed dozens of successful projects including Oracle, Microsoft, and Amazon technologies
  • His background includes consulting and technology integration for Fortune 500 Companies
  • Vertical industry experience includes Hospitality, Health Services, Pharmaceutical, Insurance, Life Sciences, Consumer Goods and Financial Services.

IICS Developer

Marriott Vacations Worldwide
06.2019 - 04.2022
  • Tools: Informatica IDMC, IICS, CDI, CAI, CDGC
  • Developed several integrations using Informatica Cloud Application Integration (CAI)
  • The project Introduced 12 new secure APIs offering access to the legacy on-premise Peoplesoft system
  • Constructed 28 new Cloud Data Integration (CDI) maps between the Salesforce Health system and Microsoft’s Azure
  • The project introduced a new backup & restore process for critical data in the Salesforce application
  • Replaced a existing SAP file transfer process by publishing multiple IICs CAI APIs
  • The three new processes involved configuration of Service & Application connectors granting access to an on-premise SAP system known as SIMBA in the University
  • ETL & BI Development Projects for a Worldwide Data Warehouse for Finance & Marketing

Senior IT Data Solutions Analyst

Siemens, Global Healthcare Technology Supplier of Imaging
02.2014 - 05.2019
  • Products/Database/Tools: Informatica IICS vR37 & PowerCenter v10.4.1, Redshift v3.0.50, Oracle v19c
  • Facilitated a new cloud-based project integrating the telephony data in the existing Datawarehouse with the inContact Call Center solution by NICE CXone
  • The initial integration was developed on-premises using Informatica PowerCenter with a follow-up phase converting the ETL to Informatica’s IICS using Redshift for OLAP storage
  • Developed & upgraded several ETL integrations for the new Adobe Marketing Cloud project using IICS & Redshift
  • The project is a replacement for the legacy CRM Epiphany product
  • Developer for an ongoing multi-phase conversion project to upgrade several hundred sessions and mappings from the on-premises PowerCenter ETL to a cloud-based solution using Informatica’s IICS & Amazon’s Redshift
  • Each mapping & session is individually converted, the ETL code adjusted and thoroughly tested
  • Built several Informatica Extract, Transform and Load (ETL) workflow processes for a new business product line
  • Designed, managed, and implemented changes to the data model
  • The project involved integration and transformation of a new type of transaction from all aspects of the infrastructure including sourcing AS/400 iSeries, Web Services & Epiphany CRM data into the Data Warehouse storing Finance, Marketing Campaign & Response Tracking information
  • Developed an ongoing Informatica workflow process to synchronize tens of millions of weekly Campaign records for the Offers & Marketing Response fact tables
  • The workflow involved ETL between Campaign Generation & CRM systems and the Data Warehouse
  • Performance tuned the entire process including database & code level improvements
  • Mentoring of junior team members
  • Integration Project with a Worldwide Call Center

Lead Integration Specialist

Royal Caribbean Cruise Line
05.2011 - 02.2014
  • Products/Database/Tools: Informatica, Oracle v12c, SQL Server 2012
  • Developed an ETL process using the Informatica Cloud Data Synchronization process to load opportunity data from the on-premises Oracle data warehouse into an AWS Redshift cluster to facilitate access for a newly acquired organization
  • The process utilizes native Informatica connectors for both Redshift and Oracle to synchronize account and opportunity data
  • Objects are extracted from the Oracle DW and loaded into an AWS Redshift cluster
  • Job automated using Linux shell script runAJobCli
  • Developed an Informatica ETL process for Integration of a newly acquired organization's data into the current CRM database using SQL Server T-SQL with stored procs on the source side and Informatica PowerCenter for the target Oracle DB
  • Designed a fully automated Extract, Transform and Load (ETL) process using Informatica PowerCenter Workflow Manager and ETL for pharmacy sold-to accounts, sales opportunities, medical equipment inventory, orders and customer profile records
  • Jobs automated via command line and schedule via Tivoli
  • Converted existing PowerCenter mappings and workflow tasks to IICS
  • Legacy mappings consisted of integration with both the OLAP warehouse and also the legacy OLTP CRM DB – Siebel
  • Jobs are automated using Informatica command line (PMCMD)
  • Customized Web Services as a source for PowerCenter into the target warehouse database using business services for authentication in the CRM enterprise system
  • Used outbound Web Services to the proprietary in-house Web Service enabled system.

Technical Architect

LexisNexis
08.2010 - 05.2011
  • Products/Database/Tools: Informatica, Oracle v11g, PL/SQL, SQL Server 2008, T-SQL, Oracle CRM
  • Designed and implemented a global process integrating the worldwide onboard SQL Server databases for the fleet to the shore side Oracle CRM customer service system
  • Each of the thirty plus ships uploads tens of thousands of records per week that are then imported into Oracle CRM
  • The imported records consist of customer information, bookings, guest spending & service requests and all data relationships maintained via the integration
  • The process monitors and controls each record via Informatica and Tivoli
  • Developed the ETL process for the customer 360 degrees project consolidated several of the customer databases into a single source real-time system query
  • Utilized Informatica MDM (Master Data Management) and Informatica IDQ (data quality) for call customer data
  • Jobs automated using command line via POSIX and scheduled via Tivoli
  • Customized PL/SQL code for automatic assignment of service requests to call center agents
  • The assignment process incorporated new functionality for skills, expertise codes, weighting factors and workload
  • A new queuing methodology was implemented insuring aging service requests receive priority assignment based on agent availability and skill set
  • Jobs automated using command line via POSIX and scheduled via Tivoli
  • Wrote a custom Web Services business service for real-time access to the legacy DB2 & Oracle Data Warehouse Pricing & Promotions system for sales quoting
  • The group capacity, pricing and promotion data is presented in Oracle CRM via a virtual business component and pick applet
  • Developed a custom merge process to enable agents to enhance data quality for contacts and related child objects
  • The merge functionality included bi-directional integrations to the Customer Data Integration system and a proprietary opt-out application
  • Jobs automated using command line via POSIX and scheduled via Tivoli
  • Real-time Integration Project for Several Web Service Enabled In-house Custom Systems
  • Project Role: Technical Lead
  • Products/Tools: Informatica, MS SQL Server, Web Services
  • Configured ETL, Web Services, Data Maps, Integration Objects, Business Services and Workflows for real-time communication between Oracle CRM Enterprise and four in-house systems based on SOAP & XML protocols
  • Installed and customized Informatica’s Oracle CRM Connector for real-time inbound/outbound data transactions connecting to the Oracle CRM Environment via Business Components directly instead of the traditional ETL methods
  • Developed a test simulator in Informatica for testing inbound Web Services from custom build in-house systems into Oracle CRM Enterprise
  • Configured Informatica Web Services Consumer Connector for real-time access to Oracle OnDemand
  • Exported dozens of Web Services Description Language files from the OnDemand system then customized, optimized and imported those same WSLDs into Informatica for access to the OnDemand objects in real-time.

Development

01.2009 - 08.2010
  • Project for Several Integrated CRM Transactional Systems

Data Architect

Johnson & Johnson
07.2008 - 01.2009
  • Data Integration Management and Consolidation Project, Products/Database/Tools: Informatica PowerCenter, Oracle DBMS, PL/SQL
  • Developed corporate standards with supporting workflow processes for interface monitoring, error handling and Email notification for all inbound and outbound integrations using Informatica
  • Additional technologies included PL/SQL, Unix KSH scripts, SIM and Maestro
  • Consolidated inbound vendor activity interfaces further leveraging the new standards, workflow development and ETL processes for Informatica
  • Designed and implemented a new employee roster data store centralizing outbound queries and enabling consolation of all internal and vendor integrations.

Front Office, Technical Lead

Nish Government Contracts
02.2008 - 07.2008
  • Integration and Development Project for, Tracking System
  • Project Role:, Products/Database/Tools: Microsoft SQL Server, SSIS
  • Designed, developed and tested a bi-directional real-time integration with legacy systems using ETL
  • Customized the CRM Data Quality module for real-time de-duplication of accounts, contacts and leads
  • Installed and configured Oracle CRM Advanced Search using Oracle’s Secure Enterprise Search engine.

Development Project

Church and Dwight, Major Consumer Products Company
01.2007 - 02.2008
  • For Data Warehouse and Transactional System for Profitability Optimization

Technical Architect

SunLife, Large Financial and Insurance Corporation
01.2007 - 04.2007
  • Products/Database/Tools: Microsoft SQL Server, T-SQL, Analytics, SSIS
  • Designed, developed and tested the Forecast Live process
  • This process incorporates logic to calculate an entire Profit and Loss statement (P&L) across Planned, Actual, and Forecast data dimensions
  • The process consists of forty plus custom Informatica workflows and a network of sixty plus stored procedures assembling data into fact and dimension tables for use by Oracle CRM Analytics
  • Defined the OLAP and OLTP system the technical architecture
  • Created a technical architecture deliverable detailing all the hardware and system component changes required as part of this project
  • Designed the hardware configuration for the replacement of client’s existing Production and Test environments
  • Performance tuned the entire Forecast Live process, including the existing functionality
  • Incorporated all the new functionality (6 times more functionality) and, with the added help of some updated hardware, the overall processing time of the processes remained constant
  • Participated in analysis and design workshops on Oracle CRM Analytics
  • Upgrade,Performance Tuning and SARM Analysis Project for a Very Large Call Center
  • Project Role: Performance Tuning Team Lead
  • Products/Database/Tools:Oracle CRM, Oracle DB Led performance tuning team for the Oracle CRM upgrade project
  • The team consisted of five core members as well as and several auxiliary members representing different area of expertise
  • Area of the upgrade that were tuned included Oracle database, CTI, ETL interface to Web Services, eScripts, Workflows, Web Server, Oracle CRM Application Server and the Network interface
  • Implemented performance tuning in several environments including Development, Test, User Acceptance Test, Staging, Business Acceptance Test, SIT and Production
  • Developed a proactive process for monitoring the production system, identifying performance bottlenecks and escalating actions before user problem reports.

SolidWorks, Software Development Corporation
05.2004 - 01.2007
  • Upgrade and Integration Project for a Large Call Center and Partner Portal
  • Project Role: Technical Lead for Integration
  • Products/Database/Tools: Microsoft SQL Server, T-SQL, Enterprise Call Center
  • Customized ETL process for integration between CRM transactional database, analytics warehouse and legacy operation systems using Informatica PowerCenter
  • Implemented email message tracking and bounce back handling using Oracle CRM’s Apache Tomcat integration
  • Developed the ETL process for the company’s semi-annual automatic product upgrade
  • The process encompasses all aspects of the complex product model including assets, extended attributes, entitlements, agreements, accounts, contacts and business units
  • The process scales to contain additional product model complexity and amounted to 2+mm imported records
  • Built a VAR reassignment process using Assignment Manager to service mass migrations of assets, accounts and contacts among the 500+ business units in the portal
  • Configured an integration process with the legacy software problem report database and extended the data model, business component fields and user interface elements for the defect tracking module.

Lead Integration Specialist

IHA, Major Healthcare Insurance Services Corporation
03.2003 - 05.2004
  • Integration Project for a Large Call Center, Products/Database/Tools: Informatica PowerCenter, DB2
  • Designed a fully automated Extract, Transform and Load (ETL) process using Informatica PowerCenter Workflow Manager and ETL for an initial load of 25mm+ claims, 6mm+ image references and 3mm+ member records
  • Designed a daily delta batch load process to synchronize the Oracle CRM Database with the master member records database
  • The synchronization involves more than twenty separate data objects
  • Transformed denormalized legacy data into parent–child relationships and developed the process for real time data integration using ETL
  • Integrated the Oracle CRM call center module with Macess image system
  • The design enables the customer service representative to view member correspondence, stored as Macess image objects, by simply clicking a hyperlink
  • Developed scripts for continuous real time performance monitoring and improvement using DB utilities
  • This resulted in dramatic improvement in data retrieval on the client side and bulk data imports on the server side
  • Optimized ETL process for a dramatic improvement in bulk data import
  • Specified the storage capacity for the development, QA, training and production systems.

Independent Contractor

Thomas Francis Associates
09.2002 - 03.2003
  • Firm specializing in the placement of BI & DW contractors with Boston area clients.

Principal Consultant – BI & CRM Analytics Practice

Keane, Inc
01.1999 - 09.2002
  • Information Technology consulting firm specializing in software packages and custom development
  • Projects
  • Major Financial Services Corporation $5+mm Siebel Financial Service project consisting of 3 phases across 8 departments spanning 15 months
  • Project Role: Technical Lead
  • Products/Database: Siebel 2000 Finance Call Center / Oracle

Programmer / Analyst

09.1991 - 01.1999
  • Created global customer support Web application using Siebel WebTeam, Apache Web Server and Netscape Navigator
  • Implemented and maintained CRM information systems using Oracle and Sybase databases
  • Implemented Global CRM database in Germany, Italy, France, the United Kingdom, Holland and North America
  • Converted legacy systems to Siebel SupportTeam and QualityTeam Series 3 running under Sybase 4.9.2
  • Database administration of a custom developed defect tracking system based on DB2.

Education

Bachelor of Science - Computer Science

Northeastern University
Boston, Massachusetts

Skills

  • Informatica IICS & PowerCenter
  • Extract, Transform, Load (ETL)
  • iPaaS (Integration Platform as a Service)
  • Representational State Transfer (REST) APIs
  • JSON
  • Web Services
  • XML
  • XQuery
  • Python
  • JQuery
  • C
  • HTML5 & CSS3
  • Oracle CRM
  • Oracle DBMS
  • PL/SQL
  • Microsoft SQL Sever
  • T-SQL
  • SSIS
  • Net
  • JavaScript – including ES8
  • Visual Studio

Timeline

Senior Informatica Developer

The Pennsylvania State University
04.2022 - Current

IICS Developer

Marriott Vacations Worldwide
06.2019 - 04.2022

Senior IT Data Solutions Analyst

Siemens, Global Healthcare Technology Supplier of Imaging
02.2014 - 05.2019

Lead Integration Specialist

Royal Caribbean Cruise Line
05.2011 - 02.2014

Technical Architect

LexisNexis
08.2010 - 05.2011

Development

01.2009 - 08.2010

Data Architect

Johnson & Johnson
07.2008 - 01.2009

Front Office, Technical Lead

Nish Government Contracts
02.2008 - 07.2008

Development Project

Church and Dwight, Major Consumer Products Company
01.2007 - 02.2008

Technical Architect

SunLife, Large Financial and Insurance Corporation
01.2007 - 04.2007

SolidWorks, Software Development Corporation
05.2004 - 01.2007

Lead Integration Specialist

IHA, Major Healthcare Insurance Services Corporation
03.2003 - 05.2004

Independent Contractor

Thomas Francis Associates
09.2002 - 03.2003

Principal Consultant – BI & CRM Analytics Practice

Keane, Inc
01.1999 - 09.2002

Programmer / Analyst

09.1991 - 01.1999

Bachelor of Science - Computer Science

Northeastern University

Lead, Siebel Developer

ViaCord LLC

Software Development

Information

Similar Profiles

CREATE PROFILE
Thomas Clougherty