Senior Informatica Lead, Developer, and Admin

Effie Cooper

609-***-**** ************@*****.*** linkedin.com/in/effiecooper

Senior Informatica Developer

SUMMARY Results-driven Informatica Lead, Developer, and Administrator with 15+ years of experience in data migration, integration, and development using on-premises architectures across enterprise platforms. Includes 5+ years of cloud experience. Proven expertise in delivering scalable solutions using Informatica PowerCenter, Intelligent Data Management Cloud (IDMC (formerly IICS)), and various databases such as Oracle, PostgreSQL, and Azure SQL Database. Additionally, skilled in optimizing performance tuning, managing batch loads, and implementing scheduling systems that enhance operational efficiency while improving data quality and governance. COMPETENCIES • Data Migration, Management, and Governance • Problem-Solving and Communication

• Data Architect, Modeling, and Engineering • Time Management and Innovative

• Cross-Functional Collaboration • Technical Leadership and Mentorship EXPERIENCE Enterprise Application Integration Engineer 02/2024 - 05/2025 innoSoul, Inc. Client: Florida Department of Transportation (FDOT) Remote, Hybrid Supported a large-scale data modernization effort for the Florida Department of Transportation (FDOT) by designing and implementing Informatica ETL solutions to migrate data from IBM Mainframe systems to Azure SQL Databases. Collaborated with cross-functional teams to manage batch scheduling, integration design, and Agile tracking through DevOps.

• Migrated legacy FLAIR system data from IBM Mainframe (z/OS) to Azure SQL Databases by creating and configuring Informatica IICS interfaces, Jobs, and Taskflows to integrate Charge Objects coded in Cobol, JCLs, and WebFocus. Significantly improving data availability and reporting capabilities for the FDOT.

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

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

• Deployed 100+ Informatica IICS interfaces and jobs, reducing manual data transfer tasks and accelerating Integration timelines. Also included modifications and tested Informatica PowerCenter interfaces.

• Streamlined deployment and operational procedures by preparing comprehensive documentation for all created interfaces and workflows, resulting in increased team efficiency and smooth knowledge transfer. Data Warehouse Administrator III-ENT 03/2023 - 11/2023 University of Alabama at Birmingham School of Medicine (UAB) Remote Documented, monitored, and maintained 750+ Informatica PowerCenter jobs for Cerner’s Millennium Health Services Information Systems (HSIS), ensuring peak performance, reliability, and issue resolution across development, QA, and production environments. Managed deployments, system updates, workflow automation, and cross-platform integrations using Informatica IICS interfaces, Jenkins, Snowflake Server, and various BI tools, including SAP Business Objects and Tableau. Cerner’s (HSIS), IICS interfaces, and SAP on Amazon Web Services

(AWS).

• 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 Informatica IICS code reviews, including SQL and PL/SQL, to ensure code quality and readiness for deployment across the environment 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.

• Enhanced communication across teams by preparing and sending three daily status reports on Informatica IICS, PowerCenter, SAP B/O, Tableau, and Oracle databases contributed to faster error identification and resolution.

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

• Optimized Business Intelligence operations by modifying 350+ SAP Business Objects reports, aligning them with UAB standards, improving reporting consistency and accuracy. Senior ETL Developer Informatica Administrator Data Architect 01/2022 - 10/2022 DXC Technology Client: Toyota Motor North America (TMNA) Remote Led the migration of 7 critical interface applications from Oracle to PostgreSQL using Informatica PowerCenter, ensuring seamless data integration between Sales and Manufacturing systems. Collaborated across technical teams and leveraged PL/SQL to optimize performance, troubleshoot proactively, and maintain daily progress through JIRA and Confluence.

• 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.

• 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 and parameter file updates, improving data flow between systems. Data Architect 08/2021 - 12/2021

WIPRO Client: Magellan Health RX 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 and reviewed with business partners.

• Collaborated closely with I.T. and business partners from the California Department of Health Care Services

(DHCS) and Managed Care Plans (MCPs) to streamline processes for the Medi-Cal Rx project.

• 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. Senior ETL Informatica Developer 04/2021 - 08/2021 WIPRO Client: Humana (Medical Provider) Remote

Improved performance of the Incentive Compensation system by analyzing and enhancing interfaces across Medicare, Veterans, and Membership programs using Informatica PowerCenter and Digital Innovation Hubs (DIH).

• 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.

• Enhanced system performance and efficiency by optimizing existing interfaces and implementing new solutions, significantly improving data flow and processing for the Incentive Compensation system. Senior ETL Developer 01/2021 - 03/2021

JPMorgan Chase & Co. Remote

Managed and tracked tasks in JIRA and GIT. In addition, analyzed and assessed existing interfaces in Informatica PowerCenter Transactions.

• Analyzed and assessed existing interfaces in Informatica PowerCenter Transactions.

• Reviewed Unix shell scripts and Control-M batch processes, improving job reliability. Informatica Developer Informatica Administrator Technical Specialist I and II 06/2006 - 08/2020 PVH Corp. Bridgewater, NJ

Informatica Developer Informatica Administrator 06/2013 - 08/2020 Supervised a team of 7 colleagues throughout the entire project lifecycle, overseeing 5 successful Informatica PowerCenter and PowerExchange upgrades, along with the application of necessary patches. Coordinated with I.T. and business partners.

• 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.

• 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 08/2009 - 06/2013

Led enterprise-wide upgrades and integrations, collaborating with IT, business partners, and vendors to implement and support Informatica, MuleSoft APIs, Data Services, and batch job orchestration. Oversaw batch job conversions, system upgrades, production deployments, and audit compliance to ensure system reliability and business continuity.

• 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.

• Created a SharePoint TeamSite on Informatica upgrades for the cross-functional teams' communication center.

• Enhanced disaster recovery capabilities by managing offsite processes for Informatica PowerCenter, PowerExchange and DataServices ensure 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- 08/2009

Oversaw the design, deployment, and administration of ETL and BI solutions, managing Informatica, SAP Business Objects, and Data Services across enterprise data environments. Led multiple tool implementations and upgrades, while coordinating security, performance tuning, and interface development for core business systems.

• Collaborated with IT teams, business partners, and vendors to design and implement ODS (Data Warehouse) interfaces for Business Objects (BO) reports, supporting the integration of data for 22+ applications.

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

• 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 significant 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 BS, Bachelor of Science in Business Administration and Management MONTCLAIR STATE UNIVERSITY, Montclair, NJ

Certification, Computer Science

ELECTRONIC COMPUTER PROGRAMMING INSTITUTE, Paterson, NJ PROFESSIONAL • Amazon Web Services (AWS) Cloud Practitioner Certification • SAP ERP and SAP S/4 HANA DEVELOPMENT • Microsoft Azure • DevOps Foundations

• Oracle Database 19c, 21c, SQL, PL/SQL • Data Engineering

• Red Hat Enterprise Linux, Unix, HP

TECHNICAL • Informatica PowerCenter PowerExchange Administrator Console • Informatica IDMC (formerly, IICS) SKILLS • Relational Databases (Oracle, PostgreSQL, Azure SQL) • On-Call Support

• DevOps (Cloud Computing, GIT, JIRA, Jenkins) • Enterprise Data Warehouse

• Problem-Solving Technical Troubleshooting Performance Tunning • Shell Scripting

• Tableau Qlik Business Objects Universe and Reports BODS • Workload Automation

Contact this candidate