DAVID ABERE

Senior Systems Analyst | Mainframe, ERP Integration

New York, United States

#OpenToWork

About

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.

What I'm looking for

Sr. Systems Analyst, IT Business Analyst, Programmer

Experience

Louisiana State University

Senior Systems Analyst (Mainframe, ERP Integration)

Louisiana State University

Jan 2019 – Present

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.

ERP IntegrationWorkdayCOBOL
Columbia University

Senior Systems Analyst (Mainframe, ERP Integration)

Columbia University

Jan 2011 – Dec 2018

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.

PeopleSoftCOBOLIntegration

Technical Consultant (Contract)

Presence of IT (POIT)

Jan 2018 – Dec 2018

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

Payroll SystemsQuality AssuranceScripting

Education

New York University

New York University

Certificate · COBOL Programming

Pace University

Pace University

Bachelor of Business Administration · Accounting

Certifications

ITIL Foundation Certified

ITIL

Skills

SASIBM z/OSDB2COBOLUser Acceptance TestingQuality AssuranceSDLCControlsData IntegrityRequirements TranslationSystems AnalysisProduction SupportSystem ModernizationData MigrationPeopleSoftWorkdayERP Integration