Senior Mainframe & ERP Integration Systems Analyst

DAVID ABERE

New York, NY • ***********@*****.*** • 315-***-**** • linkedin.com/in/davidabere

Senior Systems Analyst Mainframe, ERP Integration

COBOL DB2 IBM z/OS Workday PeopleSoft

PROFESSIONAL SUMMARY

Senior Systems Analyst with 15+ years of expertise in mainframe and ERP integration, supporting critical financial and payroll systems processing over $1B in activity annually. Track record of maintaining 99%+ system availability in 24/7 production environments and integrating legacy platforms with modern ERP solutions including Workday and PeopleSoft.

CORE COMPETENCIES

ERP Integration (Workday, PeopleSoft) • Financial & Payroll Systems • Data Migration & System Modernization • Systems Analysis & Requirements Translation • High-Volume Batch Processing • Production Support (24/7) • Data Integrity & Controls • SDLC, Quality Assurance & User Acceptance Testing • Cross-Functional Collaboration • Interfaces

TECHNICAL SKILLS

Mainframe Platforms: IBM z/OS, MVS, IMS, TSO/ISPF, CICS, DB2

Programming & Development: COBOL, JCL, VSAM, SQL, File-Aid, Xpeditor, Abend-Aid,IBM Utilities (Sort, IDCAMS), Syncsort

ERP Systems: Workday (Student, HCM/Payroll), PeopleSoft (Commitment Accounting, Payroll/HR) — Fit-Gap Analysis, Data Migration

Data & Reporting: SAS, SAS Enterprise Guide

Collaboration: Microsoft Teams / Outlook / Word / Excel

PROFESSIONAL EXPERIENCE

Senior Systems Analyst (Mainframe, ERP Integration) 2019 – 2025

Louisiana State University — Remote

•Managed and enhanced a COBOL/DB2 Student Billing System supporting 40,000+ students and $550M+ in annual revenue, with 99%+ billing accuracy.

•Served as technical Subject Matter Expert (SME) for 24/7 production operations and integrations between legacy mainframe systems and Workday HR/Payroll, ensuring data integrity across all downstream processes.

•Developed data conversion programs for the Workday Student ERP implementation, enabling accurate migration of legacy student and financial data.

•Designed and enhanced 85+ COBOL and SAS programs supporting core billing logic and financial reporting processes, ensuring smooth operations and accurate reporting.

•Reduced batch processing errors and reruns through redesigned controls and operational procedures, improving overall production reliability and efficiency.

•Translated functional requirements across student administration, HR, and payroll systems into technical solutions, delivering effective system capabilities.

Technical Consultant (Contract) 2018

Presence of IT (POIT) — Remote

•Developed automated payroll validation test scripts supporting North American Payroll Quality Assurance and User Acceptance testing, streamlining validation and improving accuracy.

Senior Systems Analyst (Mainframe, ERP Integration) 2011 - 2018

Columbia University — New York, NY

•Served as sole technical SME for the Labor Distribution System (LDS) — the university's central payroll accounting platform supporting 30,000+ employees and $1B+ in annual financial activity.

•Led full technical integration between LDS and PeopleSoft Payroll, HR, and Benefits modules, including fit-gap analysis and data mapping across 50+ processes.

•Developed legacy data conversion programs for the PeopleSoft Commitment Accounting module implementation, providing accurate financial reporting from production go-live.

•Maintained COBOL batch and CICS applications with 99%+ system availability across a 24/7 production environment.

•Diagnosed and resolved production issues during after-hours coverage, minimizing disruption to payroll posting cycles and financial operations.

•Provided knowledge transfer and documentation during staff transitions, preserving institutional knowledge critical to the university's financial operations.

ADDITIONAL EXPERIENCE

Analyst / Programmer, Columbia University – New York, NY

EDUCATION & CERTIFICATION

Bachelor of Business Administration (BBA), Accounting — Pace University, New York, NY

Certificate in COBOL Programming — New York University, New York, NY

ITIL Foundation Certified

Contact this candidate