Data Warehouse Team Lead

Lawrence Holden

Oldsmar, FL ***** 813-***-**** ***********@*******.*** www.linkedin.com/in/larry-holden

DATA INTEGRATION ADMINISTRATOR

Talented and results-driven Data Warehouse Administrator with extensive experience in multiple repository environments. Apply broad industry knowledge, technical expertise, and innovative thinking to design and implement solutions that consistently increase system performance, reliability, and efficiency. Highly analytical leader with “big picture” vision and ability to work with management, staff, and customers to bridge gap between business objectives and technology capabilities. Respected team leader, adept at clearly establishing priorities, managing risk, and driving timely completion of complex, large-scale projects. Skilled technologist who thrives in a fast-paced, multi-dimensional environment and brings uncompromising commitment to quality and customer satisfaction.

KEY SKILLS

Data Warehouse Implementation Project Planning and Management Application Consulting Analysis ETL Programming and Administration Repository Security Solutions Testing and Documentation Repository Administration Team Lead

TECHNICAL SKILLS

Languages: Shell Scripting SQL PL / SQL SAS Autosys JIL

Databases: Oracle 19c / 11g / 10g / 9i / 8i / 7x Informix SQL Server Netezza 6.0 / 7.2 GreenPlum

Platforms: Windows UNIX AIX Linux RHEL8.1

Applications: Informatica PowerCenter 10.5.2 / 10.5.1 / 10.1.1 / 9.6.1 / 8.6 / 7.3 / 6.2 / 5.1 / 3.2 Informatica Metadata Manager 10.1.1 / 9.6.1 SAS DIS Aginity Workbench TOAD Autosys r11 NZAdmin

PROFESSIONAL EXPERIENCE

Centene corporation (Formerly Wellcare Health Plans Inc.), Tampa, FL. 05/2016 - 12/2023

Team Lead Informatica Administrator

Led small administrative team supporting Informatica PowerCenter, IDQ (data quality) and Big Data Management (BDM) in a fast-paced environment and handled upgrades, service designs, capacity planning, and resolving day to day issues such as connectivity, slow running workflows, vulnerabilities, patching, disaster recovery, and new Informatica server builds.

Managed team assignments and communications regarding maintenance outages, upgrades, disaster recovery events incident solutions, monthly outage and participated in admin support staff vetting and on-boarding.

Improved data integration reliability and efficiency by moving Informatica server stack (8 non-prod, 3 production) applications to new virtual servers with current PowerCenter, IDQ and BDM software versions.

Moved Informatica BDM from Linux RHEL6.1 to RHEL8 in new domain following processes for service design, build, testing / reconciliation, and production implementation.

Rotate admins for on-call and disaster recovery events ensuring entire admin team is up to speed.

Lead for server consolidation project moving WellCare Informatica servers out of Tampa data centers into Buffalo, NY data centers.

Responsible for internal audit response, reports include admin and development team privileges and roles.

Catalina Marketing Corporation, St. Petersburg, FL 01/2012 - 05/2016 Informatica Administrator / Team Lead

Designed, documented, and supported data warehouse solutions for multinational targeted campaigns, multi channel offerings, and data quality management.

Owned ETL deployment process from environment to environment to include folder comparisons, validations, and rollbacks.

Managed rotating on-call team for Netezza data warehouse, including monitoring, issue resolution, and scheduled maintenance.

Managed production issue queue to ensure high level of communication and timely resolution of production incidents.

Served as principal resource for health resource business, including projects for queuing patient / pharmacist consultations, pharmacy sales trends, and improving nightly load efficiency.

Environment: Informatica 9.6 Netezza 7.2 Oracle 11g Aginity Workbench SAS DIS NZAdmin Linux AIX PL / SQL

Wyndham Worldwide Corporation, Orlando, FL 08/2005 - 12/2011 ETL Developer

Functioned as vital technical resource within Vacation Ownership Division, solely accountable for data design, software development, and delivery of resort management and decision support projects, supply requirements gathering, ETL, software change management, QA, incident solutions, and documentation.

Designed simple yet effective data flows, resulting in reliable and accurate data delivery to data marts and CRM application systems.

Merged Fairfield brand with existing CRM system without adversely affecting existing service entities, enabling BI reporting and analysis which resulted in higher customer satisfaction and 30% fewer contract cancellations.

Enhanced system performance by optimizing SQL and modifying data load execution to take advantage of network, database, and repository resources resulting in more reliable timely data readiness.

Advocated for data quality initiative employing MDM, peer reviews, data steward, and creation of ETL standards and best practices documentation.

Automated delivery of resort credit card transaction data by employing Informatica workflow instances while protecting customer PII, resulting in faster credit card payments.

Environment: Oracle 9i / 10g TOAD SQL Server Informatica PowerCenter 9.0 / 8.6.1 / 8.1 / 7.3 / 6.2.2 Linux PL / SQL

ADDITIONAL RELEVANT EXPERIENCE

Royal Caribbean Cruises LTD, Repository Administrator / ETL Developer, Miramar, FL.

Verizon Communications, Data Warehouse Team Lead, Tampa, FL.

MILITARY EXPERIENCE

Honorably discharged from US Marines.

EDUCATION

The Cittone Institute, Edison, NJ – certificate in computer programming - Academic Achievement Award Recipient

CERTIFICATES AND ACHIEVEMENTS

Informatica 9x Administrator - Informatica Corp

Informatica Data Quality Administrator - Informatica University

Informatica Metadata Manager 10.1

Informatica 10.1 B2B Transformation

Informatica 9x Level 1 Developer

Oracle Business Intelligence Training (OBIEE)

IBM Netezza Appliance Usage

IBM Netezza Performance Server New Features

Scrum Training - Braintree

Apache Hadoop Essentials - Hortonworks

Hadoop Administrator 1 - Hortonworks

Contact this candidate