Project Management Business Growth

Effie Cooper ************@*****.*** 609-***-****

OVERVIEW: Highly skilled and results-driven ETL Consultant/Technical Lead with 20+ years of expertise in Data Migration, Integration, and Cloud Application Development. Extensive experience in leveraging Informatica Intelligent Cloud Services (IICS), Informatica PowerCenter, and relational databases such as Oracle 19c, PostgreSQL, and Microsoft Azure. Adept at designing, developing, testing, and troubleshooting complex data workflows, ensuring seamless integration between legacy systems and modern data warehouses. Recognized for analytical problem-solving, technical leadership, and the ability to drive initiatives within cross-functional teams to meet organizational objectives.

SUMMARY:Project Management Proven ability to manage full project lifecycles, from initial design and development through to successful implementation and post-deployment support. Expertise in batch scheduling using tools like Autosys, Tivoli, Active Batch, and Control-M. A strong track record of delivering innovative solutions to improve data management processes, enhance operational efficiency, and support critical business strategies. Strategic Collaboration Equipped with well-defined leadership, communication, technical, analytical, problem-solving, interpersonal, and organizational skills. Combines cross-functional and transformative leadership with attention to team driven success. KNOWLEDGE •Data Migration •On-Call Support • Strategic Leadership

& EXPERTISE:• Cloud Integration • Batch Scheduling • Informatica PowerCenter

• ETL Development • Business Intelligence • Cloud Application Design

• Data Modeling Precision • Technical Troubleshooting • Cross-Functional Collaboration PROFESSIONAL INNOSOUL CONSULTANT (FDOT Florida Department of Transportation)02/2024 to 05/2025 EXPERIENCE:Enterprise Application Integration Engineer, Informatica Intelligent Cloud Services (IICS) Developer Remote, Hybrid

•Migrated data from IBM Mainframe (z/OS) to Azure SQL Databases by creating and configuring IICS interfaces, Jobs, and Taskflows to integrate charge objects coded in Cobol, JCLs, and WebFocus.

•Optimized batch processes, including scheduling approximately 100+ Active Batch jobs to ensure efficient and timely data transfers between systems.

•Analyzed business and technical requirements for the Planning, Accounting, and Ledger Management (PALM) application to design and implement integration solutions using Azure SQL Database and flat file formats (csv, txt).

• Collaborated with cross-functional teams, managing task creation, status updates, and user story documentation in DevOps for continuous project progress tracking. Highlights Successfully migrated legacy FLAIR system data to modern Azure SQL environments, enhancing data availability and reporting capabilities for the FDOT.

Deployed over 100 IICS interfaces and jobs, improving the integration process and reducing manual effort for data transfer tasks.

Streamlined deployment and operational procedures by preparing comprehensive documentation for all created interfaces and workflows, resulting in increased team efficiency and smooth knowledge transfer.

UNIVERSITY OF ALABAMA SCHOOL OF MEDICINE 03/2023 to 11/2023 Data Warehouse Administrator III-ENT, (Health Services Information Systems)Remote

•Monitored Cerner’s Millennium Health Services Information Systems (HSIS) Informatica PowerCenter Jobs (750+), ensuring optimal performance across all scheduled jobs.

•Managed on-call production support rotation, performing weekly maintenance tasks in Dev and Production environments, including restarting SAP Business Objects services and verifying Tableau backup statuses.

• Coordinated with the Server Team to apply patches and upgrades on Virtual Machines (VM) and non-VM servers, applying certificates and updating new connections, while managing permissions for developers.

• Participated in IICS code reviews, including SQL and PL/SQL, to ensure code quality and readiness for deployment across environments using Jenkins. Managed SAP Business Objects and Tableau deployments via Snowflake Server.

• Created robust shell scripts to monitor specific workflows in PowerCenter, automating the process of notifying the team when workflows exceeded 3 hours of wait time. Highlights Enhanced communication across teams by preparing and sending three daily status reports on IICS, PowerCenter, SAP B/O, Tableau, and Oracle databases, contributing to faster error identification and resolution.

Improved system reliability by automating the monitoring process with shell scripts, reducing manual intervention and enhancing workflow efficiency.

Optimized Business Intelligence operations by modifying 350 SAP Business Objects reports, aligning them with UAB standards, improving reporting consistency & accuracy.

Documented dependencies for 600-700 PowerCenter interfaces, ensuring clear and up-to-date records for ongoing troubleshooting, system maintenance, and future upgrades.

~ Continued on Page Two ~

Effie Cooper Page Two

PROFESSIONAL DXC TECHNOLOGY (TMNA Toyota Motor North America, Inc.)01/2022 to 10/2022 EXPERIENCE:Senior ETL Developer, Administrator, Data Architect Remote

(Continue):•Migrated 7 interface applications from Oracle to PostgreSQL through Informatica PowerCenter, ensuring seamless integration between Sales and Manufacturing departments.

• Collaborated with Database, Application, and Integration Teams, participating in daily status updates via JIRA and Confluence, ensuring smooth migration progress and identifying potential issues.

•Optimized database performance by creating new connections, updating parameter files, and comparing load results between Oracle SQL Developer and PostgreSQL, leveraging PL/SQL for efficiency.

Highlights Consistently migrated complex interfaces, significantly improving data transfer efficiency and reliability across Oracle and PostgreSQL systems.

Enhanced system performance and reduced load times by implementing optimized database connections & parameter file updates, improving data flow between systems. WIPRO MAGELLAN HEALTH RX 08/2021 to 12/2021

Data Architect Remote

•Gathered business and technical requirements and prepared documentation to update the Pharmacy Data Warehouse (PDW) for RX Management, ensuring seamless integration of new technology.

• Collaborated closely with I.T. and business partners from the California Department of Health Care Services (DHCS) Managed Care Plans (MCPs) to streamline processes for the Medi-Cal Rx project.

Highlights Contributed to the enhancement of the Pharmacy Data Warehouse (PDW), facilitating the adoption of new technology that streamlined RX Management processes and improved overall efficiency.

WIPRO HUMANA (Medical Provider)04/2021 to 08/2021

Senior ETL Informatica Developer Remote

•Analyzed and assessed existing interfaces in Informatica PowerCenter and Informatica Data Integration Hub (DIH), identifying opportunities to improve performance in Incentive Compensation systems for Medicare, Veterans, Market Points, Memberships, and Roster Workday.

•Developed new interfaces, database tables, Unix shell scripts, and jobs using Dollar Universe batch scheduler to streamline data processes and optimize system performance. Highlights Enhanced system performance and efficiency by optimizing existing interfaces and implementing new solutions, significantly improving data flow and processing for the Incentive Compensation system.

JPMORGAN CHASE & CO.01/2021 to 03/2021

Senior ETL Developer Remote

•Managed and tracked tasks in JIRA, GIT.

•Analyzed and assessed existing interfaces in Informatica PowerCenter Transactions. Highlights Reviewed Unix shell scripts and Control-M batch processes, improving job reliability. PVH CORP.07/1992 to 08/2020

Informatica Developer, Informatica Administrator Bridgewater, NJ

• Supervised a team of 7 colleagues throughout the entire project lifecycle, overseeing 5 successful Informatica PowerCenter/PowerExchange upgrades and the application of necessary patches.

•Managed ETL loads and developed controls between sources and targets for audit, disaster recovery, and load balancing, ensuring high availability and resilience across systems.

• Provided on-call production support, managing batch loads for development, QA, preprod, and production environments while troubleshooting issues and ensuring timely resolution. Highlights Completed multiple upgrades, testing a mix of 7 Oracle versions, 2 Sybase, 2 SQL Server, 4 DB2(iSeries), and 7 OS versions, improving system performance and stability.

Enhanced disaster recovery and audit processes by implementing robust controls and strategies for offsite data backups and load balancing, increasing operational reliability.

Optimized system efficiency and minimized downtime by effectively troubleshooting and resolving technical issues, providing critical support for batch loads across environments. Technical Specialist II (06/2018 to 08/2020)

• Led project lifecycle implementation into production for Informatica, MuleSoft (APIs), and Data Services, providing project status presentations to network teams, I.T., business partners, and vendors.

•Managed the conversion of 1,500 batch jobs from Autosys to Tivoli, ensuring smooth execution and updating Run Book Instructions for the I.T. Operations Team.

• Collaborated with internal auditors to review and strengthen controls between data sources and targets, ensuring the integrity and security of batch data loads for 3-5 applications.

~ Continued on Page Three ~

Effie Cooper Page Three

PROFESSIONAL PVH CORP.(Continue)...

EXPERIENCE:Technical Specialist II

Highlights Created SharePoint TeamSite on Informatica upgrades for cross-functional teams communication center.

Enhanced disaster recovery capabilities by managing offsite processes for Informatica PowerCenter/PowerExchange and DataServices, ensuring business continuity in the event of system failures.

Developed an automated release process with I.T. teams to deploy APIs through Visual Studio 2015, PVCS, TFS, and Broadcom, streamlining deployment cycles and reducing errors.

Technical Specialist I (06/2006 to 06/2018)

Lead Developer (06/1997 to 06/2006)

Senior Developer (06/1992 to 06/1997)

• Collaborated with I.T. teams, business partners, and vendors to design and implement ODS

(Data Warehouse) interfaces for Business Objects (BO) reports, supporting the integration of data from approximately 22 applications.

• Led the setup of user security protocols, granting access to Informatica PowerCenter/PowerExchange, Business Intelligence, and Data Services for developers, consultants, and business partners.

Highlights Implemented and automated the first ETL processes using Informatica PowerCenter and Business Objects, significantly improving data integration and reporting capabilities.

Led the successful execution of 4 major upgrades involving Oracle, Sybase, SQL Server, DB2, and SAP Data Services, resulting in improved system stability and performance.

Optimized batch load performance by identifying and resolving issues in interfaces, improving data flow and system efficiency across key applications such as POS, DOM, Retail, and Supply Chain Tracking.

EDUCATION:MONTCLAIR STATE UNIVERSITY, Montclair, NJ Bachelor of Science ELECTRONIC COMP. PROGRAMMING INSTITUTE, Paterson, NJ Computer Science Cert. PROFESSIONAL •Oracle Database 19c, SQL, PL/SQL, 09/2023• Postman, Red Hat Enterprise Linux, 09/2023 DEVELOPMENT:•AWS Cloud Practitioner, 11/2022 • PostgreSQL pgAdmin, 01/2022

• Python, 11/2020 • Tableau, 11/2020

•DevOps (Cloud Computing, Git, Jenkins, Docker), 08/2020

•DataWeave 2.0, JSON, SAP ECC, SAP S/4 Hana, AWS, 06/2020

•MuleSoft Studio and Platform (Certified), 06/2020

• Business Objects Universe/Reports BODS, 01/2005

• Informatica Administration (Administrator Console), 03/1999

• Informatica PowerCenter/PowerExchange Tools, 03/1999 VOLUNTEER:• Volunteer at Ronald McDonald Housing Community from PVH Corp.

• Participate in walk/run races in New York for fundraiser charities from PVH Corp. TECHNICAL •Administrators Informatica Administrator, Business Objects(BO) Intelligence, SAP Data PROFICIENCIES:Services(BODS),Tableau

• Scheduling Tools Active Batch, Tivoli Workload Scheduler(TWS(8.5.1)), Autosys, Robot Schedule Enterprise(12), Control- M, Redwood Business Process Automation, Cron(Linux, AIX)

•Databases Azure SQL Database (12, 19), Oracle(7, 8i, 9i, 10g, 11g, 12c, 19c ( SQL, PL/SQL)), PostgreSQL (6.0), Sybase Adaptive Server Enterprise(ASE), DB2 Database

•Operating Systems SQL Server (2019), Unix(AIX, HP-UX(7.2(shell scripting)), Linux Red Hat Enterprise(8.9), DB2(iSeries), Citrix, Windows Server(2012, 2016), Windows Client(95, 3.1, 7, 10), Microsoft SQL Server(2012,2017), Snowflake, IBM MainFrame (z/OS)

• Software Informatica Intelligent Cloud Services (IICS), Informatica PowerCenter/PowerExchange(4.6, 6x, 7x, 8x,9x, 10.2.0 HotFix 1, 10.4.0, 10.5.3, CDI-PC), Informatica Data Integration Hub(DIH), Informatica Data Migration, Mule 4(MuleSoft Studio (7.4) and Platform), DataWeave(2.0), Team Foundation Server(TFS), SAP(System Applications Products), ERP(Enterprise Resource Planning), SAP S/4 Hana, Salesforce, MicroSoft Office, 2016 (Excel, Outlook, PowerPoint, Visio, Word, SharePoint), Rapid Mart, Retail Island Pacific(IP), ACS WholeSale, Merchandise Marketing(MM), SAP Business Intelligence(Universe, Web Intelligence, InfoView 4.3 (client version 14.2.0))), SAP(System Application Productions) Data Services(4.2 SP6), Supply Chain Tracking(SCT), W&D, Customer Information Control System, Crystal Reports, Zoom, Microsoft Teams, WebEx

• Tools Broadcom Release Automation, DBU, PuTTY, pgAdmin, Oracle SQL Developer

(21.4.1.349, 22.2), MicroSoft SQL Server 2017, PVCS Version Manager, Information Technology Service Management ITSM), ServiceNow, Postman, SharePoint, Telnet, WinSCP, Toad for Data Point 4.3, Toad for Oracle, JIRA, GIT, Microsoft Azure DevOps, Cognos, 360 Suite-Wiiisdom, and Jenkins.

Contact this candidate